Table 6916 "Posted Expense Report Line"
ExpenseAgent · Microsoft.ExpenseAgent
Across versions
- BC23-28not present
- BC29present
- BC30changed
Neighbourhood 34 connected objects and pages
ExpenseAgent · Microsoft.ExpenseAgent · BC29-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 6953 “Posted Expense Report Lines” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Posted Expense Report Line |
| Access | Internal |
| DataClassification | CustomerContent |
| LookupPageId | Posted Expense Report Lines |
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 User No. | Code[20] | — | TableRelation Table 6923 “Expense User” (“Expense User”.“No.”) |
| 2 | Expense No. | Code[20] | — | TableRelation Expense.“No.” |
| 3 | Document No. | Code[20] | — | TableRelation Table 6915 “Posted Expense Report Header” (“Posted Expense Report Header”.“No.”); not editable |
| 4 | Line No. | Integer | — | |
| 5 | Expense Category | Code[20] | Specifies the category that classifies this expense. via Page 6953 “Posted Expense Report Lines” | TableRelation Table 6921 “Expense Category” (“Expense Category”.Code) |
| 6 | Description | Text[100] | Specifies the description of the expense line. via Page 6953 “Posted Expense Report Lines” | |
| 7 | Justification | Text[100] | Specifies the reason or justification for the expense. via Page 6993 “Posted Expense Report SubP.” | |
| 8 | Additional Information | Text[100] | — | |
| 9 | Expense Date | Date | Specifies the date the expense was incurred. via Page 6953 “Posted Expense Report Lines” | |
| 10 | Expense Currency Code | Code[10] | Specifies the currency code for this line. via Page 6953 “Posted Expense Report Lines” | TableRelation Currency.Code; not editable |
| 11 | Amount | Decimal | Specifies the line amount in the transaction currency. via Page 6953 “Posted Expense Report Lines” | |
| 12 | VAT Liable | Boolean | Specifies whether VAT applies to this expense line via Page 6993 “Posted Expense Report SubP.” | |
| 13 | Amount without VAT | Decimal | Specifies the line amount excluding VAT. via Page 6953 “Posted Expense Report Lines” | |
| 14 | VAT Amount | Decimal | Specifies the VAT amount for this line in the transaction currency. via Page 6953 “Posted Expense Report Lines” | |
| 15 | Amount (LCY) | Decimal | Specifies the line amount converted to local currency. via Page 6953 “Posted Expense Report Lines” | not editable |
| 16 | Merchant Name | Text[100] | Specifies the merchant name associated with the expense. via Page 6916 “Posted Expense Billing Info.” | |
| 17 | Reimbursement Type | Enum “Expense Reimbursement Type” | Specifies the value of the Reimbursement Type field. via Page 6993 “Posted Expense Report SubP.” | enum Enum 6912 “Expense Reimbursement Type” |
| 18 | Receipt Attached | Boolean | — | not editable |
| 19 | Receipt Entry | Integer | — | not editable |
| 20 | Account Type | Enum “Expense Line Type” | Specifies the type of account for this line, such as G/L, Customer, or Vendor. via Page 6953 “Posted Expense Report Lines” | enum Enum 6978 “Expense Line Type” |
| 21 | Account No. | Code[20] | Specifies the account number used for posting this line. via Page 6953 “Posted Expense Report Lines” | TableRelation Table 15 “G/L Account”, Table 156 “Resource”, Table 270 “Bank Account” (if (“Account Type” = const(” “)) “Standard Text” else if (“Account Type” = const(Resource)) Resource else if (“Account Type” = const(“Fixed Asset”)) “Fixed Asset” else if (“Account Type” = const(“Bank Account”)) “Bank Account” else if (“Account Type” = const(“G/L Account”)) “G/L Account” where(Block…) |
| 22 | Shortcut Dimension 1 Code | Code[20] | Specifies the first shortcut dimension code for this line. via Page 6953 “Posted Expense Report Lines” | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false))) |
| 23 | Shortcut Dimension 2 Code | Code[20] | Specifies the second shortcut dimension code for this line. via Page 6953 “Posted Expense Report Lines” | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false))) |
| 24 | Payment Method Code | Code[10] | Specifies the payment method used for refunds or reimbursements. via Page 6993 “Posted Expense Report SubP.” | TableRelation Table 6913 “Expense Payment Method” (“Expense Payment Method”.Code) |
| 25 | Refundable | Boolean | Specifies whether the expense amount is refundable. via Page 6993 “Posted Expense Report SubP.” | |
| 26 | Purchase Invoice | Boolean | Specifies whether the expense is billed through a purchase invoice. via Page 6916 “Posted Expense Billing Info.” | |
| 27 | Posted Purch. Invoice No. | Code[20] | Specifies the number of the posted purchase invoice for the expense. via Page 6916 “Posted Expense Billing Info.” | TableRelation Table 122 “Purch. Inv. Header” (“Purch. Inv. Header”.“No.”) |
| 28 | Vendor No. | Code[20] | Specifies the vendor number to which the expense is billed. via Page 6916 “Posted Expense Billing Info.” | TableRelation Vendor.“No.” |
| 29 | Posted Date | Date | Specifies the date this line was posted to the ledger. via Page 6953 “Posted Expense Report Lines” | |
| 30 | Billable | Boolean | Specifies whether the expense is billable. via Page 6916 “Posted Expense Billing Info.” | |
| 31 | Billable to Customer | Code[20] | Specifies the customer to which the expense is billable. via Page 6916 “Posted Expense Billing Info.” | TableRelation Customer.“No.” |
| 32 | Expense Location | Code[20] | Specifies the location where the expense occurred. via Page 6953 “Posted Expense Report Lines” | TableRelation Table 6925 “Expense Location” (“Expense Location”.“No.”) |
| 33 | Starting Date and Time | DateTime | — | |
| 34 | Ending Date and Time | DateTime | — | |
| 35 | Non-Refundable Amount | Decimal | Specifies any reduction applied to the line amount. via Page 6953 “Posted Expense Report Lines” | |
| 36 | Starting Point | Text[50] | — | |
| 37 | Ending Point | Text[50] | — | |
| 38 | Non-Refundable Amount (LCY) | Decimal | Specifies any reduction converted to local currency. via Page 6953 “Posted Expense Report Lines” | |
| 39 | Reimbursable Amount | Decimal | Specifies the portion of the line amount eligible for reimbursement. via Page 6953 “Posted Expense Report Lines” | |
| 40 | Reimbursable Amount (LCY) | Decimal | Specifies the reimbursable portion converted to local currency. via Page 6953 “Posted Expense Report Lines” | |
| 41 | VAT Amount (LCY) | Decimal | Specifies the VAT amount converted to local currency. via Page 6953 “Posted Expense Report Lines” | not editable |
| 42 | Dimension Set ID | Integer | — | TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable |
| 43 | VAT Bus. Posting Group | Code[20] | Specifies the VAT business posting group used for tax calculation. via Page 6953 “Posted Expense Report Lines” | TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group) |
| 44 | VAT Prod. Posting Group | Code[20] | Specifies the VAT product posting group used for tax calculation. via Page 6953 “Posted Expense Report Lines” | TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group) |
| 45 | Expense Currency Factor | Decimal | — | |
| 46 | Expense Subcategory Code | Code[20] | — | TableRelation Table 6929 “Expense Subcategory” (“Expense SubCategory”.Code where(“Expense Category Code” = field(“Expense Category”))) |
| 47 | Unit of Measure Code | Code[10] | Specifies the unit of measure for the line quantity, if applicable. via Page 6953 “Posted Expense Report Lines” | TableRelation Table 204 “Unit of Measure” (Unit of Measure) |
| 48 | Expense Time | Time | — | |
| 49 | Itemized Amount | Decimal | Amount caption | FlowField: sum(“Posted Exp. Rep. Line Item”.“Amount” where(“Expense Report No.” = field(“Document No.”), “Expense Report Line No.” = field(“Line No.”))); not editable |
| 50 | Mileage | Decimal | Specifies the one-way distance traveled for mileage reimbursement. via Page 6993 “Posted Expense Report SubP.” | |
| 67 | Round Trip | Boolean | Specifies whether the mileage expense is a round trip. When enabled, the distance is doubled for reimbursement calculation. | |
| 68 | Vehicle Type | Code[20] | Specifies the vehicle type used for this mileage expense. The mileage rate matching this vehicle type is applied, or the generic rate when no vehicle-specific rate exists. | TableRelation Table 7108 “Expense Vehicle Type” (Expense Vehicle Type) |
| 51 | Credit Card Feed No. | Integer | — | |
| 52 | Applied Rule Id | Guid | — | |
| 53 | Amount without VAT (LCY) | Decimal | Specifies the line amount excluding VAT, in local currency. via Page 6993 “Posted Expense Report SubP.” | not editable |
| 54 | Expense Detail Required | Enum “Expense Detail Needed” | — | enum Enum 6905 “Expense Detail Needed” |
| 56 | Job No. | Code[20] | Specifies the value of the Project No. field. via Page 6916 “Posted Expense Billing Info.” | TableRelation Job.“No.” |
| 57 | Job Task No. | Code[20] | Specifies the value of the Project Task No. field. via Page 6916 “Posted Expense Billing Info.” | TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”))) |
| 58 | VAT % | Decimal | — | not editable |
| 59 | VAT Difference | Decimal | — | not editable |
| 60 | Calculated VAT Amount | Decimal | — | not editable |
| 65 | Refundable Amount | Decimal | Specifies the portion eligible for Refundable. via Page 6993 “Posted Expense Report SubP.” | |
| 66 | Refundable Amount (LCY) | Decimal | Specifies the refundable amount converted to local currency. via Page 6993 “Posted Expense Report SubP.” | |
| 77 | VAT Calculation Type | Enum “Tax Calculation Type” | — | enum Enum 254 “Tax Calculation Type”; not editable |
| 81 | Expense Ext. Doc. No. | Code[30] | Specifies the value of the Receipt No. field. via Page 6916 “Posted Expense Billing Info.” | |
| 85 | Merchant Registration No. | Text[50] | — | |
| 86 | Merchant VAT Registration No. | Text[20] | — | |
| 90 | Created By Exp. User Id | Guid | Created By Expense User Id caption | not editable; DataClassification EndUserIdentifiableInformation |
| 91 | Modified By Exp. User Id | Guid | Modified By Expense User Id caption | not editable; DataClassification EndUserIdentifiableInformation |
| 92 | Canceled | Boolean | — | obsolete Pending 29.0; not editable |
| 100 | Spend Request No. | Code[20] | Specifies the travel request to which the posted expense report line is linked. | TableRelation Table 6840 “Spend Request” (Spend Request) |
| 101 | Spend Request Close | Boolean | Specifies that the travel request will be closed when the expense report is posted. | |
| 102 | Policies Evaluated At | DateTime | — | not editable |
| 106 | Policy Status At Posting | Enum “Expense Policy Status” | — | enum Enum 6989 “Expense Policy Status”; not editable |
| 999 | Is Canceled | Boolean | Canceled caption | not editable |
| 1000 | Job Ledger Entry No. | Integer | Specifies the related job ledger entry number, if any. via Page 6993 “Posted Expense Report SubP.” | TableRelation Table 169 “Job Ledger Entry” (“Job Ledger Entry”.“Entry No.”); not editable |
Keys
- PK: Document No., Line No. (clustered)
Procedures
GetReimbursementCurrencyCode(): Code[10]ShowDimensions(): BooleanShowLineComments()GetPolicyStatus(): Enum "Expense Policy Status"(internal)
Relations
- lookup page Page 6953 “Posted Expense Report Lines”
- Job Task No.: TableRelation Table 1001 “Job Task”
- Posted Purch. Invoice No.: TableRelation Table 122 “Purch. Inv. Header”
- Account No.: TableRelation Table 15 “G/L Account” (conditional)
- Account No.: TableRelation Table 156 “Resource” (conditional)
- Job Ledger Entry No.: TableRelation Table 169 “Job Ledger Entry”
- Unit of Measure Code: TableRelation Table 204 “Unit of Measure”
- Account No.: TableRelation Table 270 “Bank Account” (conditional)
- VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
- VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
- Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Account No.: TableRelation Table 5600 “Fixed Asset” (conditional)
- Spend Request No.: TableRelation Table 6840 “Spend Request”
- Payment Method Code: TableRelation Table 6913 “Expense Payment Method”
- Document No.: TableRelation Table 6915 “Posted Expense Report Header”
- Itemized Amount: CalcFormula Table 6919 “Posted Exp. Rep. Line Item”
- Expense Category: TableRelation Table 6921 “Expense Category”
- Expense User No.: TableRelation Table 6923 “Expense User”
- Expense Location: TableRelation Table 6925 “Expense Location”
- Expense Subcategory Code: TableRelation Table 6929 “Expense Subcategory”
- Account No.: TableRelation Table 7 “Standard Text” (conditional)
- Vehicle Type: TableRelation Table 7108 “Expense Vehicle Type”
Referenced by
13 fields in 6 objects relate to this table (TableRelation or CalcFormula).
- Table 6915 “Posted Expense Report Header”: Amount (LCY), Amount without VAT (LCY), Non-Refundable Amount (LCY), Refundable Amount, Refundable Amount (LCY), Reimbursable Amount, Reimbursable Amount (LCY), VAT Amount (LCY)
- Table 6917 “Posted Exp. Rep. Line Particip”: Expense Report Line No.
- Table 6919 “Posted Exp. Rep. Line Item”: Expense Report Line No.
- Table 6920 “Posted Exp. Rep. Line Per Diem”: Expense Report Line No.
- Table extension 6906 “Exp. Project Ledg. Entry Ext”: Expense Report Line No.
- Table extension 6907 “Exp. Job Jnl. Line Ext”: Expense Report Line No.
Pages and codeunits on this table
- Page 6913 “Posted Exp. Report Lines API” (source table)
- Page 6916 “Posted Expense Billing Info.” (source table)
- Page 6953 “Posted Expense Report Lines” (source table)
- Page 6993 “Posted Expense Report SubP.” (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 408 “DimensionManagement” (2 calls:
ShowDimensions → EditDimensionSet,ShowDimensions → UpdateGlobalDimFromDimSetID)
Recent changes
- 2026-09-17 #11333 Align travel request APIs with employee travelers and expense report lifecycle (main, BC30, feature)
- 2026-09-09 #11007 Add Travel Request API lifecycle to Expense Agent (main, BC30, feature)
- 2026-08-27 #10561 Mileage Rate Setup (main, BC30, feature)
- 2026-08-26 #10631 Integration/main to releases 29.x 31a860b5 (releases/29.x, BC29, feature)
- 2026-08-24 #10451 [Bug 647233] Fix User Confirmed copied into Canceled when posting expense report lines (main, BC30, fix)
- 2026-08-21 #10031 Add AI-assisted policy evaluation backend to Expense Agent (main, BC30, feature)
- 2026-08-10 #9391 [Master] - Slice 616928: [Expense Management] [App part] Expense Managements Travel Requisitions 💸 (main, BC30, feature)
- 2026-08-04 #9859 [Master] - Move Expense Agent (Preview) app into BCApps (main, BC30, feature, added)
Deprecations
- field Canceled: Pending 29.0, “Replaced by field “Is Canceled” to resolve TransferFields collision with Expense Report Line field 92 (User Confirmed).”
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
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: "Posted Expense Report Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.