Other table in Microsoft Dynamics 365 Business Central. 33 fields, 0 records in Cronus demo.
The Cost Journal Line table (ID 1101) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 33 fields, with a primary key of Journal Template Name, Line No., Journal Batch Name. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: Journal Template Name, Line No., Journal Batch Name.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 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 |
Tables referenced by fields on the Cost Journal Line table through TableRelation properties.