Job Ledger Entry #169

Ledger Entries table in Microsoft Dynamics 365 Business Central. 88 fields, 0 records in Cronus demo.

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 (88)

Job Ledger Entry — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Entry No. PK	Integer	Normal
2	Project No.	Code	Normal	→ Job #167
3	Posting Date	Date	Normal
4	Document No.	Code	Normal
5	Type	Option	Normal
7	No.	Code	Normal
8	Description	Text	Normal
9	Quantity	Decimal	Normal
11	Direct Unit Cost (LCY)	Decimal	Normal
12	Unit Cost (LCY)	Decimal	Normal
13	Total Cost (LCY)	Decimal	Normal
14	Unit Price (LCY)	Decimal	Normal
15	Total Price (LCY)	Decimal	Normal
16	Resource Group No.	Code	Normal	→ Resource Group #152
17	Unit of Measure Code	Code	Normal
19	Job Register No.	Integer	Normal	→ Job Register #241
20	Location Code	Code	Normal	→ Location #14
29	Posting Group	Code	Normal	→ Inventory Posting Group #94
30	Global Dimension 1 Code	Code	Normal	→ Dimension Value #349
31	Global Dimension 2 Code	Code	Normal	→ Dimension Value #349
32	Work Type Code	Code	Normal	→ Work Type #200
33	Customer Price Group	Code	Normal	→ Customer Price Group #6
37	User ID	Code	Normal
38	Source Code	Code	Normal	→ Source Code #230
40	Shpt. Method Code	Code	Normal	→ Shipment Method #10
60	Amt. to Post to G/L	Decimal	Normal
61	Amt. Posted to G/L	Decimal	Normal
64	Entry Type	Option	Normal
75	Journal Batch Name	Code	Normal
76	Reason Code	Code	Normal	→ Reason Code #231
77	Transaction Type	Code	Normal	→ Transaction Type #258
78	Transport Method	Code	Normal	→ Transport Method #259
79	Country/Region Code	Code	Normal	→ Country/Region #9
80	Gen. Bus. Posting Group	Code	Normal	→ Gen. Business Posting Group #250
81	Gen. Prod. Posting Group	Code	Normal	→ Gen. Product Posting Group #251
82	Entry/Exit Point	Code	Normal	→ Entry/Exit Point #282
83	Document Date	Date	Normal
84	External Document No.	Code	Normal
85	Area	Code	Normal	→ Area #284
86	Transaction Specification	Code	Normal	→ Transaction Specification #285
87	No. Series	Code	Normal	→ No. Series #308
88	Additional-Currency Total Cost	Decimal	Normal
89	Add.-Currency Total Price	Decimal	Normal
94	Add.-Currency Line Amount	Decimal	Normal
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
1000	Project Task No.	Code	Normal	→ Job Task #1001
1001	Line Amount (LCY)	Decimal	Normal
1002	Unit Cost	Decimal	Normal
1003	Total Cost	Decimal	Normal
1004	Unit Price	Decimal	Normal
1005	Total Price	Decimal	Normal
1006	Line Amount	Decimal	Normal
1007	Line Discount Amount	Decimal	Normal
1008	Line Discount Amount (LCY)	Decimal	Normal
1009	Currency Code	Code	Normal	→ Currency #4
1010	Currency Factor	Decimal	Normal
1016	Description 2	Text	Normal
1017	Ledger Entry Type	Option	Normal
1018	Ledger Entry No.	Integer	Normal
1019	Serial No.	Code	Normal
1020	Lot No.	Code	Normal
1021	Line Discount %	Decimal	Normal
1022	Line Type	Option	Normal
1023	Original Unit Cost (LCY)	Decimal	Normal
1024	Original Total Cost (LCY)	Decimal	Normal
1025	Original Unit Cost	Decimal	Normal
1026	Original Total Cost	Decimal	Normal
1027	Original Total Cost (ACY)	Decimal	Normal
1028	Adjusted	Boolean	Normal
1029	DateTime Adjusted	DateTime	Normal
5402	Variant Code	Code	Normal
5403	Bin Code	Code	Normal	→ Bin #7354
5404	Qty. per Unit of Measure	Decimal	Normal
5405	Quantity (Base)	Decimal	Normal
5900	Service Order No.	Code	Normal
5901	Posted Service Shipment No.	Code	Normal
6515	Package No.	Code	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