Cost Journal Line #1101

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

33
Fields
0
Records
3
Primary key
0
FlowFields
13
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Journal Template Name, Line No., Journal Batch Name.

All fields (33)

Cost Journal Line — FIELDS
NO.FIELDTYPECLASSRELATION
1 Journal Template Name PK Code Normal → Cost Journal Template #1100
2 Line No. PK Integer Normal
4 Cost Type No. Code Normal → Cost Type #1103
5 Posting Date Date Normal
7 Document No. Code Normal
8 Description Text Normal
9 Journal Batch Name PK Code Normal → Cost Journal Batch #1102
11 Bal. Cost Type No. Code Normal → Cost Type #1103
16 Amount Decimal Normal
17 Balance Decimal Normal
18 Debit Amount Decimal Normal
19 Credit Amount Decimal Normal
20 Cost Center Code Code Normal → Cost Center #1112
21 Cost Object Code Code Normal → Cost Object #1113
22 Bal. Cost Center Code Code Normal → Cost Center #1112
23 Bal. Cost Object Code Code Normal → Cost Object #1113
27 Reason Code Code Normal → Reason Code #231
29 G/L Entry No. Integer Normal → G/L Entry #17
30 Source Code Code Normal → Source Code #230
31 System-Created Entry Boolean Normal
32 Cost Entry No. Integer Normal
33 Allocated Boolean Normal
50 Allocation Description Text Normal
51 Allocation ID Code Normal
68 Additional-Currency Amount Decimal Normal
69 Add.-Currency Debit Amount Decimal Normal
70 Add.-Currency Credit Amount Decimal Normal
100 Budget Name 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

Related tables (9)

Tables referenced by fields on the Cost Journal Line table through TableRelation properties.

Cost Journal Template
#1100 · Other · via Journal Template Name
Cost Type
#1103 · Other · via Cost Type No., Bal. Cost Type No.
Cost Journal Batch
#1102 · Other · via Journal Batch Name
Cost Center
#1112 · Other · via Cost Center Code, Bal. Cost Center Code
Cost Object
#1113 · Other · via Cost Object Code, Bal. Cost Object Code
Reason Code
#231 · Other · via Reason Code
G/L Entry
#17 · Ledger Entries · via G/L Entry No.
Source Code
#230 · Other · via Source Code