Expense Report Line #6907

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

The Expense Report Line table (ID 6907) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 73 fields, with a primary key of Document No., Line No., and includes 2 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: Document No., Line No..

All fields (73)

Expense Report Line — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Expense User No.	Code	Normal	→ Expense User #6923
2	Expense No.	Code	Normal	→ Expense #6900
3	Document No. PK	Code	Normal	→ Expense Report Header #6906
4	Line No. PK	Integer	Normal
5	Expense Category	Code	Normal	→ Expense Category #6921
6	Description	Text	Normal
7	Justification	Text	Normal
8	Additional Information	Text	Normal
9	Expense Date	Date	Normal
10	Expense Currency Code	Code	Normal	→ Currency #4
11	Amount	Decimal	Normal
12	VAT Liable	Boolean	Normal
13	Amount without VAT	Decimal	Normal
14	VAT Amount	Decimal	Normal
15	Amount (LCY)	Decimal	Normal
16	Merchant Name	Text	Normal
17	Reimbursement Type	Option	Normal
18	Receipt Attached	Boolean	Normal
19	Receipt Entry	Integer	Normal
20	Account Type	Option	Normal
21	Account No.	Code	Normal
22	Shortcut Dimension 1 Code	Code	Normal	→ Dimension Value #349
23	Shortcut Dimension 2 Code	Code	Normal	→ Dimension Value #349
24	Payment Method Code	Code	Normal	→ Expense Payment Method #6913
25	Refundable	Boolean	Normal
26	Purchase Invoice	Boolean	Normal
27	Posted Purchase Invoice No.	Code	Normal	→ Purch. Inv. Header #122
28	Vendor No.	Code	Normal	→ Vendor #23
29	Posted Date	Date	Normal
30	Billable	Boolean	Normal
31	Billable to Customer	Code	Normal	→ Customer #18
32	Expense Location	Code	Normal	→ Expense Location #6925
33	Starting Date and Time	DateTime	Normal
34	Ending Date and Time	DateTime	Normal
35	Non-Refundable Amount	Decimal	Normal
36	Starting Point	Text	Normal
37	Ending Point	Text	Normal
38	Non-Refundable Amount (LCY)	Decimal	Normal
39	Reimbursable Amount	Decimal	Normal
40	Reimbursable Amount (LCY)	Decimal	Normal
41	VAT Amount (LCY)	Decimal	Normal
42	Dimension Set ID	Integer	Normal	→ Dimension Set Entry #480
43	VAT Bus. Posting Group	Code	Normal	→ VAT Business Posting Group #323
44	VAT Prod. Posting Group	Code	Normal	→ VAT Product Posting Group #324
45	Expense Currency Factor	Decimal	Normal
46	Expense Subcategory Code	Code	Normal	→ Expense Subcategory #6929
47	Unit of Measure Code	Code	Normal	→ Unit of Measure #204
48	Expense Time	Time	Normal
49	Amount ⚡ FLOW	Decimal	FlowField
50	Mileage	Decimal	Normal
51	Credit Card Feed No.	Integer	Normal
52	Applied Rule Id	GUID	Normal
53	Amount without VAT (LCY)	Decimal	Normal
54	Expense Detail Required	Option	Normal
55	Rule Violations ⚡ FLOW	Boolean	FlowField
56	Project No.	Code	Normal	→ Job #167
57	Project Task No.	Code	Normal	→ Job Task #1001
58	VAT %	Decimal	Normal
59	VAT Difference	Decimal	Normal
60	Calculated VAT Amount	Decimal	Normal
65	Refundable Amount	Decimal	Normal
66	Refundable Amount (LCY)	Decimal	Normal
67	Round Trip	Boolean	Normal
77	VAT Calculation Type	Option	Normal
81	Expense External Document No.	Code	Normal
90	Created By Expense User Id	GUID	Normal
91	Modified By Expense User Id	GUID	Normal
92	User Confirmed	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