tableCopilot & Agentsofficial - Microsoftderived - from the source, no model text

Table 6912 "Expense Ledger Entry"

ExpenseAgent · Microsoft.ExpenseAgent

Across versions

  1. BC23-28not present
  2. BC29-30present

Neighbourhood 16 connected objects and pages

Table 480 "Dimension Set Entry" (relates to, 7 links)Dimension Set EntryTable 349 "Dimension Value" (relates to, 2 links)Dimension ValueTable 1001 "Job Task" (relates to)Table 4 "Currency" (relates to)CurrencyTable 5200 "Employee" (relates to)EmployeeTable 5221 "Employee Posting Group" (relates to)Employee Posting GroupTable 6913 "Expense Payment Method" (relates to)Expense Payment MethodTable 6921 "Expense Category" (relates to)Table 6923 "Expense User" (relates to)Expense UserTable 6929 "Expense Subcategory" (relates to)Page 6903 "Expense Ledger Entries" (pages and codeunits on it, 3 links)Expense Ledger EntriesCodeunit 6996 "Exp. Preview Posting Handler" (event subscribers)Exp. Preview Posting HandlerCodeunit 408 "DimensionManagement" (calls)DimensionManagementCodeunit 9500 "Sequence No. Mgt." (calls)Sequence No. Mgt.Expense Management Overview in Business Central (Learn pages)Expense Management Overview …Post Expense Reports in Business Central (Learn pages)Post Expense Reports in Busi…

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

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

Procedures

  • CopyFromGenJnlLine(GenJnlLine: Record "Gen. Journal Line")
  • CopyFromPostedExpenseReportLine(PostedExpenseReportLine: Record "Posted Expense Report Line")
  • GetNextEntryNo(): Integer
  • ShowDimensions()

Plus 1 local procedures.

Relations

Referenced by

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

Pages and codeunits on this 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.

Recent changes

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.

Evidence 1 sources