Table 6911 "Expense Report Line Item"

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

Properties

Property	Value
Caption	Expense Report Line Itemization
Access	Internal
DataClassification	CustomerContent
LookupPageId	Expense Report 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 6906 “Expense Report Header” (“Expense Report Header”.“No.”)
2	Expense Report Line No.	Integer	—	TableRelation Table 6907 “Expense Report Line” (“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 where(Inactive = const(false)))
7	Expense Subcategory Code	Code[20]	Specifies the expense subcategory code for this itemization. via Page 6931 “Expense Report Line Items”	TableRelation Table 6929 “Expense Subcategory” (“Expense SubCategory”.Code where(“Expense Category Code” = field(“Expense Category Code”), Inactive = const(false)))
8	Description	Text[100]	Specifies a description for this itemization. via Page 6931 “Expense Report Line Items”
9	Start Date	Date	Specifies the start date for this itemization. via Page 6931 “Expense Report Line Items”
10	Quantity	Decimal	Specifies the quantity for this itemization. via Page 6931 “Expense Report Line Items”
11	Daily Rate	Decimal	Specifies the daily rate for this itemization. via Page 6931 “Expense Report Line Items”
12	Amount	Decimal	Specifies the total amount for all itemization lines. via Page 6931 “Expense Report Line Items”	not editable
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.

Procedures

4 local procedures, no public ones.

Triggers

OnInsert, OnModify, OnDelete

Relations

lookup page Page 6931 “Expense Report Line Items”
Expense Report No.: TableRelation Table 6906 “Expense Report Header”
Expense Report Line No.: TableRelation Table 6907 “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 6907 “Expense Report Line”: Itemized Amount

Pages and codeunits on this table

Page 6905 “Expense Report Line Item API” (source table)
Page 6931 “Expense Report Line Items” (source table)

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Codeunit 6910 “Expense Report” (2 calls: UpdateExpenseReportLineInformation → GetExpenseReportLine, UpdateItemizationInformationOnExpenseReportLine → GetExpenseReportLine)

Recent changes

2026-08-26 #10631 Integration/main to releases 29.x 31a860b5 (releases/29.x, BC29, feature)
2026-08-21 #10031 Add AI-assisted policy evaluation backend to Expense Agent (main, BC30, feature)
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). The call sections above are our own, per object, from the BC29 call graph. 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: "Expense Report Line Item"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.