Posted Expense Report Header #6915

Other table in Microsoft Dynamics 365 Business Central. 46 fields, 0 records in Cronus demo.

The Posted Expense Report Header table (ID 6915) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 46 fields, with a primary key of No., and includes 8 calculated FlowFields. Use the reference below to explore every field, data type, and table relation.

46
Fields
0
Records
1
Primary key
8
FlowFields
16
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: No..

All fields (46)

Posted Expense Report Header — FIELDS
NO.FIELDTYPECLASSRELATION
1 No. PK Code Normal
2 Expense User No. Code Normal → Expense User #6923
3 Expense User Name Text Normal
4 Expense Report Date Date Normal
5 Posting Date Date Normal
6 Description Text Normal
10 Amount (LCY) ⚡ FLOW Decimal FlowField
12 Non-Refundable Amount (LCY) ⚡ FLOW Decimal FlowField
13 Reimbursable Amount ⚡ FLOW Decimal FlowField
14 Reimbursable Amount (LCY) ⚡ FLOW Decimal FlowField
15 Shortcut Dimension 1 Code Code Normal → Dimension Value #349
16 Shortcut Dimension 2 Code Code Normal → Dimension Value #349
17 Employee Posting Group Code Normal → Employee Posting Group #5221
18 Language Code Code Normal → Language #8
19 Comment Boolean Normal
20 Reason Code Code Normal → Reason Code #231
21 No. Series Code Normal
22 Posting No. Series Code Normal
23 Status Option Normal
24 Anti-Corruption Attestation Boolean Normal
25 Anti-Corruption Description Text Normal
26 Corrected Boolean Normal
27 Responsibility Center Code Normal → Responsibility Center #5714
28 Reimbursement Currency Code Code Normal → Currency #4
29 Corrected Document No. Code Normal
30 Dimension Set ID Integer Normal → Dimension Set Entry #480
31 VAT Amount (LCY) ⚡ FLOW Decimal FlowField
32 Amount without VAT (LCY) ⚡ FLOW Decimal FlowField
33 Refundable Amount (LCY) ⚡ FLOW Decimal FlowField
34 Refundable Amount ⚡ FLOW Decimal FlowField
40 VAT Bus. Posting Group Code Normal → VAT Business Posting Group #323
42 Submission Date and Time DateTime Normal
43 Approved/Rejected Date and Time DateTime Normal
44 Approved/Rejected By Code Normal
45 Approver Expense User No. Code Normal → Expense User #6923
46 Approver Expense User ID Code Normal
47 Created By Code Normal
50 Reimbursement Currency Factor Decimal Normal
58 Created By Expense User Id GUID Normal
59 Modified By Expense User Id GUID Normal
92 Canceled Boolean Normal
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

Related tables (10)

Tables referenced by fields on the Posted Expense Report Header table through TableRelation properties.

Expense User
#6923 · Other · via Expense User No., Approver Expense User No.
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Employee Posting Group
#5221 · Human Resources · via Employee Posting Group
Language
#8 · General Ledger · via Language Code
Reason Code
#231 · Other · via Reason Code
Responsibility Center
#5714 · Other · via Responsibility Center
Currency
#4 · General Ledger · via Reimbursement Currency Code
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
VAT Business Posting Group
#323 · Other · via VAT Bus. Posting Group