Table 6919 "Posted Exp. Rep. Line Item"

ExpenseAgent · Microsoft.ExpenseAgent · captioned “Posted Expense Report Line Itemization” · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Posted Expense Report Line Itemization
Access	Internal
DataClassification	CustomerContent
LookupPageId	Posted Exp. Rep. Line Items

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Expense Report No.	Code[20]	—	TableRelation Table 6915 “Posted Expense Report Header” (“Posted Expense Report Header”.“No.”)
2	Expense Report Line No.	Integer	—	TableRelation Table 6916 “Posted Expense Report Line” (“Posted Expense Report Line”.“Line No.” where(“Document No.” = field(“Expense Report No.”)))
3	Line No.	Integer	—
5	Expense No.	Code[20]	—	TableRelation Expense.“No.”
6	Expense Category Code	Code[20]	—	TableRelation Table 6921 “Expense Category” (“Expense Category”.Code)
7	Expense Subcategory Code	Code[20]	Specifies the expense subcategory code for this itemization. via Page 6944 “Posted Exp. Report Line Items”	TableRelation Table 6929 “Expense Subcategory” (“Expense SubCategory”.Code where(“Expense Category Code” = field(“Expense Category Code”)))
8	Description	Text[100]	Specifies a description for this itemization. via Page 6944 “Posted Exp. Report Line Items”
9	Start Date	Date	Specifies the start date for this itemization. via Page 6944 “Posted Exp. Report Line Items”
10	Quantity	Decimal	Specifies the quantity for this itemization. via Page 6944 “Posted Exp. Report Line Items”
11	Daily Rate	Decimal	Specifies the daily rate for this itemization. via Page 6944 “Posted Exp. Report Line Items”
12	Amount	Decimal	Specifies the total amount for all itemization lines. via Page 6944 “Posted Exp. Report Line Items”
13	Refundable	Boolean	—	not editable

Keys

PK: Expense Report No., Expense Report Line No., Line No. (clustered)
Key2: Expense Report No., Expense Report Line No.

Relations

lookup page Page 6943 “Posted Exp. Rep. Line Items”
Expense Report No.: TableRelation Table 6915 “Posted Expense Report Header”
Expense Report Line No.: TableRelation Table 6916 “Posted Expense Report Line”
Expense Category Code: TableRelation Table 6921 “Expense Category”
Expense Subcategory Code: TableRelation Table 6929 “Expense Subcategory”

Referenced by

1 fields in 1 objects relate to this table (TableRelation or CalcFormula).

Table 6916 “Posted Expense Report Line”: Itemized Amount

Pages and codeunits on this table

Page 6906 “Posted Exp. Rep. Line Item API” (source table)
Page 6943 “Posted Exp. Rep. Line Items” (source table)
Page 6944 “Posted Exp. Report Line Items” (source table)

Recent changes

2026-08-04 #9859 [Master] - Move Expense Agent (Preview) app into BCApps (main, BC30, feature, added)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Posted Exp. Rep. Line Item"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.