Other table in Microsoft Dynamics 365 Business Central. 54 fields, 0 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: Journal Template Name, Journal Batch Name, Line No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Journal Template Name PK | Code | Normal | → Sust. Excise Journal Template #6238 |
| 2 | Journal Batch Name PK | Code | Normal | → Sust. Excise Journal Batch #6239 |
| 3 | Line No. PK | Integer | Normal | |
| 4 | Posting Date | Date | Normal | |
| 5 | Entry Type | Option | Normal | |
| 6 | Document Type | Option | Normal | |
| 7 | Document No. | Code | Normal | |
| 8 | Account No. | Code | Normal | → Sustainability Account #6210 |
| 9 | Account Name | Text | Normal | |
| 10 | Account Category | Code | Normal | → Sustain. Account Category #6211 |
| 11 | Account Subcategory | Code | Normal | → Sustain. Account Subcategory #6212 |
| 12 | Description | Text | Normal | |
| 13 | Partner Type | Option | Normal | |
| 14 | Partner No. | Code | Normal | |
| 17 | Source of Emission Data | Option | Normal | |
| 18 | Emission Verified | Boolean | Normal | |
| 19 | CBAM Compliance | Boolean | Normal | |
| 20 | Source Type | Option | Normal | |
| 21 | Source No. | Code | Normal | |
| 22 | Source Description | Text | Normal | |
| 23 | Source Unit of Measure | Code | Normal | → Unit of Measure #204 |
| 24 | Source Qty. | Decimal | Normal | |
| 25 | Material Breakdown No. | Code | Normal | → Sust. Item Mat. Comp. Header #6236 |
| 26 | Material Breakdown Description | Text | Normal | |
| 27 | Material Breakdown Unit of Measure | Code | Normal | → Unit of Measure #204 |
| 28 | Material Breakdown Weight | Decimal | Normal | |
| 29 | CO2e Emission per Unit | Decimal | Normal | |
| 30 | CO2e Unit of Measure | Code | Normal | → Unit of Measure #204 |
| 31 | Total Embedded CO2e Emission | Decimal | Normal | |
| 32 | CBAM Certificates Required | Boolean | Normal | |
| 35 | Emission Cost per Unit | Decimal | Normal | |
| 36 | Total Emission Cost | Decimal | Normal | |
| 40 | Carbon Pricing Paid | Boolean | Normal | |
| 41 | Already Paid Emission | Decimal | Normal | |
| 42 | Adjusted CBAM Cost | Decimal | Normal | |
| 43 | Certificate Amount | Decimal | Normal | |
| 45 | Qty. per Unit of Measure | Decimal | Normal | |
| 50 | Country/Region Code | Code | Normal | → Country/Region #9 |
| 55 | Source Document No. | Code | Normal | |
| 56 | Source Document Line No. | Integer | Normal | |
| 60 | Responsibility Center | Code | Normal | → Responsibility Center #5714 |
| 70 | Shortcut Dimension 1 Code | Code | Normal | → Dimension Value #349 |
| 71 | Shortcut Dimension 2 Code | Code | Normal | → Dimension Value #349 |
| 80 | Source Code | Code | Normal | → Source Code #230 |
| 90 | Reason Code | Code | Normal | → Reason Code #231 |
| 480 | Dimension Set ID | Integer | Normal | → Dimension Set Entry #480 |
| 500 | Item Ledger Entry No. | Integer | Normal | → Item Ledger Entry #32 |
| 5170 | Calculated Date | Date | Normal | |
| 5171 | Calculated By | 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 Sust. Excise Jnl. Line table through TableRelation properties.