Sust. Excise Jnl. Line #6240

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

The Sust. Excise Jnl. Line table (ID 6240) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 54 fields, with a primary key of Journal Template Name, Journal Batch Name, Line No.. 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: Journal Template Name, Journal Batch Name, Line No..

All fields (54)

Sust. Excise Jnl. Line — FIELDS

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