tableSustainabilityofficial - Microsoftderived - from the source, no model text

Table 6227 "Sustainability Value Entry"

Sustainability · Microsoft.Sustainability.Ledger

Across versions

  1. BC23-28not present
  2. BC29-30present

Neighbourhood 26 connected objects and pages

Table 480 "Dimension Set Entry" (relates to, 7 links)Dimension Set EntryTable 27 "Item" (relates to, 2 links)ItemTable 349 "Dimension Value" (relates to, 2 links)Dimension ValueTable 1001 "Job Task" (relates to)Job TaskTable 15 "G/L Account" (relates to)Table 156 "Resource" (relates to)ResourceTable 32 "Item Ledger Entry" (relates to)Item Ledger EntryTable 5800 "Item Charge" (relates to)Item ChargeTable 5832 "Capacity Ledger Entry" (relates to)Capacity Ledger EntryTable 6210 "Sustainability Account" (relates to)Table 6211 "Sustain. Account Category" (relates to)Sustain. Account CategoryTable 6212 "Sustain. Account Subcategory" (relates to)Sustain. Account SubcategoryTable 99000754 "Work Center" (relates to)Work CenterTable 99000758 "Machine Center" (relates to)Page 6248 "Sustainability Value Entries" (pages and codeunits on it, 3 links)Sustainability Value EntriesPage 6335 "Sustainability Value Entry" (pages and codeunits on it)Codeunit 6228 "Sust. Preview Posting Handler" (event subscribers)Codeunit 408 "DimensionManagement" (calls)Codeunit 703 "Find Record Management" (calls)Table extension 6257 "Sust. Job" (referenced by, 4 links)Sust. JobTable extension 6260 "Sust. Job Task" (referenced by, 4 links)Sust. Job TaskTable extension 6236 "Sust. Sales Cr. Memo Header" (referenced by)Table extension 6238 "Sust. Sales Invoice Header" (referenced by)Table extension 6255 "Sust. Transfer Shipment Header" (referenced by)Table extension 6272 "Sust. Service Cr. Memo Header" (referenced by)Table extension 6274 "Sust. Service Invoice Header" (referenced by)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

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

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

Referenced by

13 fields in 7 objects relate to this table (TableRelation or CalcFormula).

Pages and codeunits on this 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.

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.

Evidence 1 sources