Table 6912 "Expense Ledger Entry"
ExpenseAgent · Microsoft.ExpenseAgent
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 16 connected objects and pages
ExpenseAgent · Microsoft.ExpenseAgent · BC29-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 6903 “Expense Ledger Entries” (2 Learn pages).
Properties
| Property | Value |
|---|---|
| Caption | Expense Ledger Entry |
| Access | Internal |
| DataClassification | CustomerContent |
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 | Entry No. | Integer | Specifies the entry number. via Page 6903 “Expense Ledger Entries” | |
| 2 | Expense User No. | Code[20] | Specifies the expense user number linked to the entry. via Page 6903 “Expense Ledger Entries” | TableRelation Table 6923 “Expense User” (“Expense User”.“No.”); not editable |
| 3 | Employee No. | Code[20] | Specifies the employee number linked to the entry. via Page 6903 “Expense Ledger Entries” | TableRelation Table 5200 “Employee” |
| 4 | Posting Date | Date | Specifies the posting date of the entry. via Page 6903 “Expense Ledger Entries” | |
| 5 | Document Type | Enum “Gen. Journal Document Type” | Specifies the document type of the entry. via Page 6903 “Expense Ledger Entries” | enum Enum 6 “Gen. Journal Document Type” |
| 6 | Document No. | Code[20] | Specifies the document number of the entry. via Page 6903 “Expense Ledger Entries” | |
| 7 | Description | Text[100] | Specifies the entry description. via Page 6903 “Expense Ledger Entries” | |
| 11 | Currency Code | Code[10] | Specifies the currency code for the entry amount. via Page 6903 “Expense Ledger Entries” | TableRelation Table 4 “Currency” |
| 13 | Amount | Decimal | Specifies the entry amount. via Page 6903 “Expense Ledger Entries” | |
| 15 | Original Amt. (LCY) | Decimal | Specifies the original entry amount in local currency (LCY). via Page 6903 “Expense Ledger Entries” | not editable |
| 17 | Amount (LCY) | Decimal | Specifies the entry amount in local currency (LCY). via Page 6903 “Expense Ledger Entries” | not editable |
| 18 | Expense Category | Code[20] | — | TableRelation Table 6921 “Expense Category” (“Expense Category”.Code) |
| 19 | Expense Subcategory Code | Code[20] | — | TableRelation Table 6929 “Expense Subcategory” (“Expense SubCategory”.Code where(“Expense Category Code” = field(“Expense Category”))) |
| 22 | Employee Posting Group | Code[20] | — | TableRelation Table 5221 “Employee Posting Group” (Employee Posting Group) |
| 23 | Global Dimension 1 Code | Code[20] | Specifies the code for global dimension 1 linked to this entry for analysis. via Page 6903 “Expense Ledger Entries” | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))) |
| 24 | Global Dimension 2 Code | Code[20] | Specifies the code for global dimension 2 linked to this entry for analysis. via Page 6903 “Expense Ledger Entries” | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))) |
| 27 | User ID | Code[50] | — | TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation |
| 28 | Source Code | Code[10] | — | TableRelation Source Code |
| 37 | Non-Refundable Amount | Decimal | Specifies the reduction applied to the entry amount. via Page 6903 “Expense Ledger Entries” | not editable |
| 38 | Non-Refundable Amount (LCY) | Decimal | Specifies the reduction applied to the entry amount in local currency (LCY). via Page 6903 “Expense Ledger Entries” | not editable |
| 39 | Reimbursable Amount | Decimal | Specifies the amount that can be reimbursed for this entry. via Page 6903 “Expense Ledger Entries” | not editable |
| 40 | Reimbursable Amount (LCY) | Decimal | Specifies the reimbursable amount for the entry in local currency (LCY). via Page 6903 “Expense Ledger Entries” | not editable |
| 41 | Refundable Amount | Decimal | Specifies the amount refundable for this entry. via Page 6903 “Expense Ledger Entries” | not editable |
| 42 | Refundable Amount (LCY) | Decimal | Specifies the refundable amount for the entry in local currency (LCY). via Page 6903 “Expense Ledger Entries” | not editable |
| 48 | Journal Templ. Name | Code[10] | Journal Template Name caption | DataClassification SystemMetadata |
| 49 | Journal Batch Name | Code[10] | — | |
| 50 | Reason Code | Code[10] | — | TableRelation Reason Code |
| 53 | Transaction No. | Integer | — | |
| 64 | No. Series | Code[20] | — | TableRelation No. Series |
| 75 | Original Amount | Decimal | Specifies the original entry amount. via Page 6903 “Expense Ledger Entries” | not editable |
| 80 | Document Line No. | Integer | — | |
| 87 | Reversed | Boolean | — | |
| 88 | Reversed by Entry No. | Integer | — | TableRelation Table 6912 “Expense Ledger Entry” (Expense Ledger Entry) |
| 89 | Reversed Entry No. | Integer | — | TableRelation Table 6912 “Expense Ledger Entry” (Expense Ledger Entry) |
| 90 | Job No. | Code[20] | Specifies the job number assigned to the entry. via Page 6903 “Expense Ledger Entries” | TableRelation Job.“No.” |
| 91 | Job Task No. | Code[20] | Specifies the job task number assigned to the entry. via Page 6903 “Expense Ledger Entries” | TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”))) |
| 172 | Payment Method Code | Code[10] | Specifies the payment method used for the entry. via Page 6903 “Expense Ledger Entries” | TableRelation Table 6913 “Expense Payment Method” (Expense Payment Method) |
| 480 | Dimension Set ID | Integer | — | TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable |
| 481 | Shortcut Dimension 3 Code | Code[20] | Specifies the code for Shortcut Dimension 3 as defined in General Ledger Setup. via Page 6903 “Expense Ledger Entries” | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(3))); not editable |
| 482 | Shortcut Dimension 4 Code | Code[20] | Specifies the code for Shortcut Dimension 4 as defined in General Ledger Setup. via Page 6903 “Expense Ledger Entries” | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(4))); not editable |
| 483 | Shortcut Dimension 5 Code | Code[20] | Specifies the code for Shortcut Dimension 5 as defined in General Ledger Setup. via Page 6903 “Expense Ledger Entries” | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(5))); not editable |
| 484 | Shortcut Dimension 6 Code | Code[20] | Specifies the code for Shortcut Dimension 6 as defined in General Ledger Setup. via Page 6903 “Expense Ledger Entries” | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(6))); not editable |
| 485 | Shortcut Dimension 7 Code | Code[20] | Specifies the code for Shortcut Dimension 7 as defined in General Ledger Setup. via Page 6903 “Expense Ledger Entries” | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(7))); not editable |
| 486 | Shortcut Dimension 8 Code | Code[20] | Specifies the code for Shortcut Dimension 8 as defined in General Ledger Setup. via Page 6903 “Expense Ledger Entries” | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(8))); not editable |
Keys
- Key1: Entry No. (clustered)
Trigger event subscribers
- OnAfterInsertEvent: Codeunit 6996 “Exp. Preview Posting Handler” OnInsertExpenseLedgEntry
Procedures
CopyFromGenJnlLine(GenJnlLine: Record "Gen. Journal Line")CopyFromPostedExpenseReportLine(PostedExpenseReportLine: Record "Posted Expense Report Line")GetNextEntryNo(): IntegerShowDimensions()
Plus 1 local procedures.
Relations
- drill-down page Page 6903 “Expense Ledger Entries”
- lookup page Page 6903 “Expense Ledger Entries”
- Job Task No.: TableRelation Table 1001 “Job Task”
- Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Currency Code: TableRelation Table 4 “Currency”
- Shortcut Dimension 3 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 4 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 5 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 6 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 7 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 8 Code: CalcFormula Table 480 “Dimension Set Entry”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Employee No.: TableRelation Table 5200 “Employee”
- Employee Posting Group: TableRelation Table 5221 “Employee Posting Group”
- Reversed by Entry No.: TableRelation Table 6912 “Expense Ledger Entry”
- Reversed Entry No.: TableRelation Table 6912 “Expense Ledger Entry”
- Payment Method Code: TableRelation Table 6913 “Expense Payment Method”
- Expense Category: TableRelation Table 6921 “Expense Category”
- Expense User No.: TableRelation Table 6923 “Expense User”
- Expense Subcategory Code: TableRelation Table 6929 “Expense Subcategory”
Referenced by
2 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 6912 “Expense Ledger Entry”: Reversed by Entry No., Reversed Entry No.
Pages and codeunits on this table
- Page 6903 “Expense Ledger Entries” (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” (1 call:
ShowDimensions → ShowDimensionSet) - Codeunit 9500 “Sequence No. Mgt.” (1 call:
GetNextEntryNo → GetNextSeqNo)
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). 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 Ledger Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.