Expense Report Header #6906

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

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

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

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

All fields (53)

Expense Report Header — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
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 User	Code	Normal
45	Approver Expense User No.	Code	Normal	→ Expense User #6923
46	Approver Expense User ID	Code	Normal
47	Created By	Code	Normal
48	Approver Comment	BLOB	Normal
50	Reimbursement Currency Factor	Decimal	Normal
55	Pending Approval By	Code	FlowFilter	→ Expense User #6923
56	Submitter Expense User No.	Code	Normal	→ Expense User #6923
57	Submitter Expense User ID	Code	Normal
58	Created By Expense User Id	GUID	Normal
59	Modified By Expense User Id	GUID	Normal
63	Posting No.	Code	Normal
65	Last Posting No.	Code	Normal	→ Expense Report Header #6906
441	Approved/Rejected Expense User Number	Code	Normal	→ Expense User #6923
442	Approved/Rejected Expense User Display Name ⚡ FLOW	Text	FlowField
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