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

Table 6915 "Posted Expense Report Header"

ExpenseAgent · Microsoft.ExpenseAgent

Across versions

  1. BC23-28not present
  2. BC29present
  3. BC30changed

Neighbourhood 32 connected objects and pages

Table 6916 "Posted Expense Report Line" (relates to, 8 links)Posted Expense Report LineTable 349 "Dimension Value" (relates to, 2 links)Dimension ValueTable 6923 "Expense User" (relates to, 2 links)Expense UserTable 323 "VAT Business Posting Group" (relates to)VAT Business Posting GroupTable 480 "Dimension Set Entry" (relates to)Table 5221 "Employee Posting Group" (relates to)Employee Posting GroupTable 5714 "Responsibility Center" (relates to)Table 6840 "Spend Request" (relates to)Spend RequestTable 6934 "Posted Exp. Rep. Line VAT Spec" (relates to)Posted Exp. Rep. Line VAT SpecPage 6987 "Posted Expense Reports" (pages and codeunits on it, 2 links)Posted Expense ReportsCodeunit 6974 "Cancel Posted Expense Report" (pages and codeunits on it)Page 6957 "Posted Expense Reports API" (pages and codeunits on it)Posted Expense Reports APIPage 6978 "Posted Exp. Report Statistics" (pages and codeunits on it)Page 6998 "Posted Expense Report" (pages and codeunits on it)Posted Expense ReportPage 7094 "Posted Expense Report FactBox" (pages and codeunits on it)Posted Expense Report FactBoxPage 7097 "Posted Expense Report Stats" (pages and codeunits on it)Posted Expense Report StatsCodeunit 308 "No. Series - Batch" (calls)Codeunit 408 "DimensionManagement" (calls)DimensionManagementCodeunit 6926 "Expense Activity Log Mgt." (calls)Page 5200 "Employee Card" (calls)Employee CardTable 6900 "Expense" (referenced by)Table 6916 "Posted Expense Report Line" (referenced by)Table 6917 "Posted Exp. Rep. Line Particip" (referenced by)Table 6919 "Posted Exp. Rep. Line Item" (referenced by)Table 6920 "Posted Exp. Rep. Line Per Diem" (referenced by)Table 6934 "Posted Exp. Rep. Line VAT Spec" (referenced by)Table 7100 "Expense Activity Log Entry" (referenced by)Table extension 6901 "Exp - Sales Line - Ext" (referenced by)Table extension 6906 "Exp. Project Ledg. Entry Ext" (referenced by)Table extension 6907 "Exp. Job Jnl. Line Ext" (referenced by)Expense Management Overview in Business Central (Learn pages)Post Expense Reports in Business Central (Learn pages)

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 6987 “Posted Expense Reports” (2 Learn pages), Page 6998 “Posted Expense Report” (1).

Properties

Property Value
Caption Posted Expense Report Header
Access Internal
DataClassification CustomerContent
LookupPageId Posted Expense Reports

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 No. Code[20] Specifies the expense report number. via Page 6998 “Posted Expense Report”
2 Expense User No. Code[20] Specifies the expense user number assigned to this report. via Page 6998 “Posted Expense Report” TableRelation Table 6923 “Expense User” (“Expense User”.“No.”)
3 Expense User Name Text[100] Specifies the expense user name for this report. via Page 6998 “Posted Expense Report”
4 Expense Report Date Date Specifies the date of the expense report. via Page 6998 “Posted Expense Report”
5 Posting Date Date Specifies the posting date used for accounting entries. via Page 6998 “Posted Expense Report”
6 Description Text[100] Specifies the value of the Description field. via Page 6998 “Posted Expense Report”
10 Amount (LCY) Decimal Specifies the total amount of all expense report lines in local currency. via Page 7097 “Posted Expense Report Stats” FlowField: sum(“Posted Expense Report Line”.“Amount (LCY)” where(“Document No.” = field(“No.”))); not editable
12 Non-Refundable Amount (LCY) Decimal — FlowField: sum(“Posted Expense Report Line”.“Non-Refundable Amount (LCY)” where(“Document No.” = field(“No.”))); not editable
13 Reimbursable Amount Decimal Specifies the value of the Reimbursable Amount field. via Page 7094 “Posted Expense Report FactBox” FlowField: sum(“Posted Expense Report Line”.“Reimbursable Amount” where(“Document No.” = field(“No.”))); not editable
14 Reimbursable Amount (LCY) Decimal Specifies the total reimbursable amount in local currency. via Page 7097 “Posted Expense Report Stats” FlowField: sum(“Posted Expense Report Line”.“Reimbursable Amount (LCY)” where(“Document No.” = field(“No.”))); not editable
15 Shortcut Dimension 1 Code Code[20] Specifies the first shortcut dimension code for posting analysis. via Page 6998 “Posted Expense Report” TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false)))
16 Shortcut Dimension 2 Code Code[20] Specifies the second shortcut dimension code for posting analysis. via Page 6998 “Posted Expense Report” TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false)))
17 Employee Posting Group Code[20] Specifies the posting group that determines ledger accounts for this employee. via Page 6987 “Posted Expense Reports” TableRelation Table 5221 “Employee Posting Group” (“Employee Posting Group”.Code)
18 Language Code Code[10] — TableRelation Language.Code; DataClassification SystemMetadata
19 Comment Boolean —
20 Reason Code Code[10] — TableRelation “Reason Code”.Code
21 No. Series Code[20] — DataClassification SystemMetadata
22 Posting No. Series Code[20] — DataClassification SystemMetadata
23 Status Enum “Expense Report Status” — enum Enum 6910 “Expense Report Status”; not editable; DataClassification SystemMetadata
24 Anti-Corruption Attestation Boolean Specifies whether the anti-corruption attestation has been accepted. via Page 6998 “Posted Expense Report”
25 Anti-Corruption Description Text[100] Specifies additional details for the anti-corruption attestation. via Page 6998 “Posted Expense Report”
26 Corrected Boolean Specifies whether this report has been corrected. via Page 6998 “Posted Expense Report”
27 Responsibility Center Code[20] Specifies the responsibility center used to assign costs. via Page 6998 “Posted Expense Report” TableRelation Table 5714 “Responsibility Center” (“Responsibility Center”.Code)
28 Reimbursement Currency Code Code[10] Specifies the value of the Reimbursement Currency Code field. via Page 7094 “Posted Expense Report FactBox” TableRelation Currency.Code
29 Corrected Document No. Code[20] Specifies the document number of the original report that was corrected. via Page 6998 “Posted Expense Report” not editable
30 Dimension Set ID Integer — TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable
31 VAT Amount (LCY) Decimal Specifies the total VAT amount for the expense report in local currency. via Page 7097 “Posted Expense Report Stats” FlowField: sum(“Posted Expense Report Line”.“VAT Amount (LCY)” where(“Document No.” = field(“No.”))); not editable
32 Amount without VAT (LCY) Decimal Specifies the total amount excluding VAT of all expense report lines in local currency. via Page 7097 “Posted Expense Report Stats” FlowField: sum(“Posted Expense Report Line”.“Amount without VAT (LCY)” where(“Document No.” = field(“No.”))); not editable
33 Refundable Amount (LCY) Decimal Specifies the total refundable amount in local currency. via Page 7097 “Posted Expense Report Stats” FlowField: sum(“Posted Expense Report Line”.“Refundable Amount (LCY)” where(“Document No.” = field(“No.”))); not editable
34 Refundable Amount Decimal Specifies the value of the Refundable Amount field. FlowField: sum(“Posted Expense Report Line”.“Refundable Amount” where(“Document No.” = field(“No.”))); not editable
40 VAT Bus. Posting Group Code[20] Specifies the VAT business posting group used for tax posting. via Page 6998 “Posted Expense Report” TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
42 Submission DateTime DateTime Submission Date and Time caption
43 Approved/Rejected DateTime DateTime Approved/Rejected Date and Time caption
44 Approved/Rejected By Code[50] — TableRelation User.“User Name”; not editable; DataClassification EndUserIdentifiableInformation
45 Approver Expense User No. Code[20] — TableRelation Table 6923 “Expense User” (“Expense User”.“No.”); not editable; DataClassification EndUserIdentifiableInformation
46 Approver Expense User ID Code[50] — TableRelation User.“User Name”; not editable; DataClassification EndUserIdentifiableInformation
47 Created By Code[50] — TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
50 Reimbursement Currency Factor Decimal — not editable
58 Created By Exp. User Id Guid Created By Expense User Id caption not editable; DataClassification EndUserIdentifiableInformation
59 Modified By Exp. User Id Guid Modified By Expense User Id caption not editable; DataClassification EndUserIdentifiableInformation
92 Canceled Boolean Specifies whether this posted expense report has been canceled. When canceled, the related ledger entries have been reversed. not editable
93 Approved Reclaim VAT (LCY) Decimal Specifies the total VAT amount approved for reclaim across all VAT specification lines of this posted expense report, in local currency. FlowField: sum(“Posted Exp. Rep. Line VAT Spec”.“Reclaim VAT Amount (LCY)” where(“Expense Report No.” = field(“No.”), “Reclaim Status” = const(Approved))); not editable
100 Spend Request No. Code[20] Specifies the travel request to which the posted expense report 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.

Keys

  • PK: No. (clustered)
  • ExpenseUser: Expense User No., No.

Procedures

  • ShowDimensions()
  • ShowEmployeeCard()

Triggers

OnInsert, OnDelete

Relations

Referenced by

10 fields in 10 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: "Posted Expense Report Header"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources