Sustainability Value Entry #6227

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

46
Fields
0
Records
1
Primary key
6
FlowFields
15
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Entry No..

All fields (46)

Sustainability Value Entry — FIELDS
NO.FIELDTYPECLASSRELATION
1 Entry No. PK Integer Normal
2 Item No. Code Normal → Item #27
3 Posting Date Date Normal
4 Item Ledger Entry Type Option Normal
5 Document No. Code Normal
6 Item Ledger Entry No. Integer Normal → Item Ledger Entry #32
7 Sust. Valued Quantity Decimal Normal
8 Item Ledger Entry Quantity Decimal Normal
9 Invoiced Quantity Decimal Normal
10 CO2e per Unit Decimal Normal
11 User ID Code Normal
12 Source Code Code Normal → Source Code #230
13 Applies-to Entry Integer Normal
14 Global Dimension 1 Code Code Normal → Dimension Value #349
15 Global Dimension 2 Code Code Normal → Dimension Value #349
16 Expected Emission Boolean Normal
17 CO2e Amount (Actual) Decimal Normal
18 CO2e Amount (Expected) Decimal Normal
19 Journal Batch Name Code Normal
20 Document Date Date Normal
21 External Document No. Code Normal
22 Document Type Option Normal
23 Document Line No. Integer Normal
30 Account No. Code Normal → Sustainability Account #6210
31 Account Name Text Normal
32 Account Category Code Normal → Sustain. Account Category #6211
33 Account Subcategory Code Normal → Sustain. Account Subcategory #6212
105 Entry Type Option Normal
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
1000 Project No. Code Normal → Job #167
1001 Project Task No. Code Normal → Job Task #1001
5156 Shortcut Dimension 3 Code ⚡ FLOW Code FlowField
5157 Shortcut Dimension 4 Code ⚡ FLOW Code FlowField
5158 Shortcut Dimension 5 Code ⚡ FLOW Code FlowField
5159 Shortcut Dimension 6 Code ⚡ FLOW Code FlowField
5160 Shortcut Dimension 7 Code ⚡ FLOW Code FlowField
5161 Shortcut Dimension 8 Code ⚡ FLOW Code FlowField
5818 Adjustment Boolean Normal
5831 Capacity Ledger Entry No. Integer Normal → Capacity Ledger Entry #5832
5832 Type Option Normal
5834 No. 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 (12)

Tables referenced by fields on the Sustainability Value Entry table through TableRelation properties.

Item
#27 · Inventory · via Item No.
Item Ledger Entry
#32 · Inventory · via Item Ledger Entry No.
Source Code
#230 · Other · via Source Code
Dimension Value
#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code
Sustainability Account
#6210 · Other · via Account No.
Sustain. Account Category
#6211 · Other · via Account Category
Sustain. Account Subcategory
#6212 · Other · via Account Subcategory
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
Job
#167 · Other · via Project No.
Job Task
#1001 · Jobs · via Project Task No.
Capacity Ledger Entry
#5832 · Other · via Capacity Ledger Entry No.