Expense #6900

Other table in Microsoft Dynamics 365 Business Central. 60 fields, 72 records in Cronus demo.

The Expense table (ID 6900) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 60 fields, with a primary key of No., and includes 1 calculated FlowField. 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 (60)

Expense — FIELDS

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