Expense Ledger Entry #6912

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

The Expense Ledger Entry table (ID 6912) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 49 fields, with a primary key of Entry No., and includes 6 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: Entry No..

All fields (49)

Expense Ledger Entry — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Entry No. PK	Integer	Normal
2	Expense User No.	Code	Normal	→ Expense User #6923
3	Employee No.	Code	Normal	→ Employee #5200
4	Posting Date	Date	Normal
5	Document Type	Option	Normal
6	Document No.	Code	Normal
7	Description	Text	Normal
11	Currency Code	Code	Normal	→ Currency #4
13	Amount	Decimal	Normal
15	Original Amt. (LCY)	Decimal	Normal
17	Amount (LCY)	Decimal	Normal
18	Expense Category	Code	Normal	→ Expense Category #6921
19	Expense Subcategory Code	Code	Normal	→ Expense Subcategory #6929
22	Employee Posting Group	Code	Normal	→ Employee Posting Group #5221
23	Global Dimension 1 Code	Code	Normal	→ Dimension Value #349
24	Global Dimension 2 Code	Code	Normal	→ Dimension Value #349
27	User ID	Code	Normal
28	Source Code	Code	Normal	→ Source Code #230
37	Non-Refundable Amount	Decimal	Normal
38	Non-Refundable Amount (LCY)	Decimal	Normal
39	Reimbursable Amount	Decimal	Normal
40	Reimbursable Amount (LCY)	Decimal	Normal
41	Refundable Amount	Decimal	Normal
42	Refundable Amount (LCY)	Decimal	Normal
48	Journal Template Name	Code	Normal
49	Journal Batch Name	Code	Normal
50	Reason Code	Code	Normal	→ Reason Code #231
53	Transaction No.	Integer	Normal
64	No. Series	Code	Normal	→ No. Series #308
75	Original Amount	Decimal	Normal
80	Document Line No.	Integer	Normal
87	Reversed	Boolean	Normal
88	Reversed by Entry No.	Integer	Normal	→ Expense Ledger Entry #6912
89	Reversed Entry No.	Integer	Normal	→ Expense Ledger Entry #6912
90	Project No.	Code	Normal	→ Job #167
91	Project Task No.	Code	Normal	→ Job Task #1001
172	Payment Method Code	Code	Normal	→ Expense Payment Method #6913
480	Dimension Set ID	Integer	Normal	→ Dimension Set Entry #480
481	Shortcut Dimension 3 Code ⚡ FLOW	Code	FlowField
482	Shortcut Dimension 4 Code ⚡ FLOW	Code	FlowField
483	Shortcut Dimension 5 Code ⚡ FLOW	Code	FlowField
484	Shortcut Dimension 6 Code ⚡ FLOW	Code	FlowField
485	Shortcut Dimension 7 Code ⚡ FLOW	Code	FlowField
486	Shortcut Dimension 8 Code ⚡ FLOW	Code	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