Sust. Excise Jnl. Line #6240

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

54
Fields
0
Records
3
Primary key
0
FlowFields
20
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.FIELDTYPECLASSRELATION
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

Related tables (15)

Tables referenced by fields on the Sust. Excise Jnl. Line table through TableRelation properties.

Sust. Excise Journal Template
#6238 · Other · via Journal Template Name
Sust. Excise Journal Batch
#6239 · Other · via Journal Batch Name
Sustainability Account
#6210 · Other · via Account No.
Sustain. Account Category
#6211 · Other · via Account Category
Sustain. Account Subcategory
#6212 · Other · via Account Subcategory
Unit of Measure
#204 · Other · via Source Unit of Measure, Material Breakdown Unit of Measure, CO2e Unit of Measure
Sust. Item Mat. Comp. Header
#6236 · Other · via Material Breakdown No.
Country/Region
#9 · General Ledger · via Country/Region Code
Responsibility Center
#5714 · Other · via Responsibility Center
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Source Code
#230 · Other · via Source Code
Reason Code
#231 · Other · via Reason Code
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
Item Ledger Entry
#32 · Inventory · via Item Ledger Entry No.