Table 6227 "Sustainability Value Entry"
Sustainability · Microsoft.Sustainability.Ledger
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 26 connected objects and pages
Sustainability · Microsoft.Sustainability.Ledger · BC29-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Sustainability Value Entry |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Entry No. | Integer | Specifies the value of the Entry No. field. via Page 6248 “Sustainability Value Entries” | |
| 2 | Item No. | Code[20] | Specifies the value of the Item No. field. via Page 6248 “Sustainability Value Entries” | TableRelation Table 27 “Item” |
| 3 | Posting Date | Date | Specifies the value of the Posting Date field. via Page 6248 “Sustainability Value Entries” | |
| 4 | Item Ledger Entry Type | Enum “Item Ledger Entry Type” | Specifies the value of the Item Ledger Entry Type field. via Page 6248 “Sustainability Value Entries” | enum Enum 78 “Item Ledger Entry Type” |
| 5 | Document No. | Code[20] | Specifies the value of the Document No. field. via Page 6248 “Sustainability Value Entries” | |
| 6 | Item Ledger Entry No. | Integer | Specifies the value of the Item Ledger Entry No. field. via Page 6248 “Sustainability Value Entries” | TableRelation Table 32 “Item Ledger Entry” (Item Ledger Entry) |
| 7 | Valued Quantity | Decimal | Specifies the value of the Valued Quantity field. via Page 6248 “Sustainability Value Entries” | |
| 8 | Item Ledger Entry Quantity | Decimal | Specifies the value of the Item Ledger Entry Quantity field. via Page 6248 “Sustainability Value Entries” | |
| 9 | Invoiced Quantity | Decimal | Specifies the value of the Invoiced Quantity field. via Page 6248 “Sustainability Value Entries” | |
| 10 | CO2e per Unit | Decimal | Specifies the value of the CO2e per Unit field. via Page 6248 “Sustainability Value Entries” | |
| 11 | User ID | Code[50] | Specifies the value of the User ID field. via Page 6248 “Sustainability Value Entries” | TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation |
| 12 | Source Code | Code[10] | Specifies the value of the Source Code field. via Page 6248 “Sustainability Value Entries” | TableRelation Source Code |
| 13 | Applies-to Entry | Integer | Specifies the value of the Applies-to Entry field. via Page 6248 “Sustainability Value Entries” | |
| 14 | Global Dimension 1 Code | Code[20] | Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists. via Page 6248 “Sustainability Value Entries” | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))) |
| 15 | Global Dimension 2 Code | Code[20] | Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists. via Page 6248 “Sustainability Value Entries” | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))) |
| 16 | Expected Emission | Boolean | Specifies the value of the Expected Emission field. via Page 6248 “Sustainability Value Entries” | |
| 17 | CO2e Amount (Actual) | Decimal | Specifies the value of the CO2e Amount (Actual) field. via Page 6248 “Sustainability Value Entries” | |
| 18 | CO2e Amount (Expected) | Decimal | Specifies the value of the CO2e Amount (Expected) field. via Page 6248 “Sustainability Value Entries” | |
| 19 | Journal Batch Name | Code[10] | Specifies the value of the Journal Batch Name field. via Page 6248 “Sustainability Value Entries” | |
| 20 | Document Date | Date | Specifies the value of the Document Date field. via Page 6248 “Sustainability Value Entries” | |
| 21 | External Document No. | Code[35] | Specifies the value of the External Document No. field. via Page 6248 “Sustainability Value Entries” | |
| 22 | Document Type | Enum “Item Ledger Document Type” | Specifies the value of the Document Type field. via Page 6248 “Sustainability Value Entries” | enum Enum 79 “Item Ledger Document Type” |
| 23 | Document Line No. | Integer | Specifies the value of the Document Line No. field. via Page 6248 “Sustainability Value Entries” | |
| 30 | Account No. | Code[20] | — | TableRelation Table 6210 “Sustainability Account” (“Sustainability Account” where(“Account Type” = const(Posting))) |
| 31 | Account Name | Text[100] | — | |
| 32 | Account Category | Code[20] | — | TableRelation Table 6211 “Sustain. Account Category” (Sustain. Account Category) |
| 33 | Account Subcategory | Code[20] | — | TableRelation Table 6212 “Sustain. Account Subcategory” (“Sustain. Account Subcategory”.Code where(“Category Code” = field(“Account Category”))) |
| 105 | Entry Type | Enum “Cost Entry Type” | Specifies the value of the Entry Type field. via Page 6248 “Sustainability Value Entries” | enum Enum 104 “Cost Entry Type”; not editable |
| 480 | Dimension Set ID | Integer | — | TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable |
| 1000 | Job No. | Code[20] | Specifies the number of the project that the value entry relates to. via Page 6248 “Sustainability Value Entries” | TableRelation Job.“No.” |
| 1001 | Job Task No. | Code[20] | Specifies the number of the related project task. via Page 6248 “Sustainability Value Entries” | TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”))) |
| 5831 | Capacity Ledger Entry No. | Integer | Specifies the value of the Capacity Ledger Entry No. field. via Page 6248 “Sustainability Value Entries” | TableRelation Table 5832 “Capacity Ledger Entry” (Capacity Ledger Entry) |
| 5832 | Type | Enum “Sust. Value Type” | Specifies the value of the Type field. via Page 6248 “Sustainability Value Entries” | enum Enum 6219 “Sust. Value Type” |
| 5834 | No. | Code[20] | Specifies the value of the No. field. via Page 6248 “Sustainability Value Entries” | TableRelation Table 15 “G/L Account”, Table 156 “Resource”, Table 27 “Item” (if (Type = const(“Machine Center”)) “Machine Center” else if (Type = const(“Work Center”)) “Work Center” else if (Type = const(Resource)) Resource else if (Type = const(Item)) Item else if (Type = const(“Charge (Item)”)) “Item Charge” else if (Type = const(“G/L Account”)) “G/L Account” else if (Type…) |
| 5818 | Adjustment | Boolean | Specifies the value of the Adjustment field. via Page 6248 “Sustainability Value Entries” | |
| 5156 | Shortcut Dimension 3 Code | Code[20] | Specifies the code for Shortcut Dimension 3, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 6248 “Sustainability Value Entries” | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(3))) |
| 5157 | Shortcut Dimension 4 Code | Code[20] | Specifies the code for Shortcut Dimension 4, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 6248 “Sustainability Value Entries” | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(4))) |
| 5158 | Shortcut Dimension 5 Code | Code[20] | Specifies the code for Shortcut Dimension 5, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 6248 “Sustainability Value Entries” | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(5))) |
| 5159 | Shortcut Dimension 6 Code | Code[20] | Specifies the code for Shortcut Dimension 6, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 6248 “Sustainability Value Entries” | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(6))) |
| 5160 | Shortcut Dimension 7 Code | Code[20] | Specifies the code for Shortcut Dimension 7, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 6248 “Sustainability Value Entries” | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(7))) |
| 5161 | Shortcut Dimension 8 Code | Code[20] | Specifies the code for Shortcut Dimension 8, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 6248 “Sustainability Value Entries” | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(8))) |
Keys
- Key1: Entry No. (clustered)
- Key2: Document Type, Document No., Item No.
Trigger event subscribers
- OnAfterInsertEvent: Codeunit 6228 “Sust. Preview Posting Handler” OnInsertSustValueEntry
Procedures
ShowDimensions()CopyFromValueEntry(ValueEntry: Record "Value Entry")CopyFromResourceLedgerEntry(ResourceLedgerEntry: Record "Res. Ledger Entry")CopyFromFALedgerEntry(FALedgerEntry: Record "FA Ledger Entry")CopyFromJobLedgerEntry(JobLedgerEntry: Record "Job Ledger Entry")CopyFromSustainabilityJnlLine(SustainabilityJnlLine: Record "Sustainability Jnl. Line")GetLastEntryNo(): Integer
Relations
- drill-down page Page 6248 “Sustainability Value Entries”
- lookup page Page 6248 “Sustainability Value Entries”
- Job Task No.: TableRelation Table 1001 “Job Task”
- No.: TableRelation Table 15 “G/L Account” (conditional)
- No.: TableRelation Table 156 “Resource” (conditional)
- Item No.: TableRelation Table 27 “Item”
- No.: TableRelation Table 27 “Item” (conditional)
- Item Ledger Entry No.: TableRelation Table 32 “Item Ledger Entry”
- Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Shortcut Dimension 3 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 4 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 5 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 6 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 7 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 8 Code: CalcFormula Table 480 “Dimension Set Entry”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- No.: TableRelation Table 5800 “Item Charge” (conditional)
- Capacity Ledger Entry No.: TableRelation Table 5832 “Capacity Ledger Entry”
- Account No.: TableRelation Table 6210 “Sustainability Account”
- Account Category: TableRelation Table 6211 “Sustain. Account Category”
- Account Subcategory: TableRelation Table 6212 “Sustain. Account Subcategory”
- No.: TableRelation Table 99000754 “Work Center” (conditional)
- No.: TableRelation Table 99000758 “Machine Center” (conditional)
Referenced by
13 fields in 7 objects relate to this table (TableRelation or CalcFormula).
- Table extension 6257 “Sust. Job”: G/L Account (Total CO2e), Item (Total CO2e), Resource (Total CO2e), Total CO2e
- Table extension 6260 “Sust. Job Task”: G/L Account (Total CO2e), Item (Total CO2e), Resource (Total CO2e), Total CO2e
- Table extension 6236 “Sust. Sales Cr. Memo Header”: Total CO2e
- Table extension 6238 “Sust. Sales Invoice Header”: Total CO2e
- Table extension 6255 “Sust. Transfer Shipment Header”: Total CO2e
- Table extension 6272 “Sust. Service Cr. Memo Header”: Total CO2e
- Table extension 6274 “Sust. Service Invoice Header”: Total CO2e
Pages and codeunits on this table
- Page 6248 “Sustainability Value Entries” (source table)
- Page 6335 “Sustainability Value Entry” (source table)
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 408 “DimensionManagement” (1 call:
ShowDimensions → ShowDimensionSet) - Codeunit 703 “Find Record Management” (1 call:
GetLastEntryNo → GetLastEntryIntFieldValue)
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Sustainability Value Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.