Table 6225 "Sust. Account (Analysis View)"
Sustainability · Microsoft.Sustainability.FinancialReporting
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 14 connected objects and pages
Sustainability · Microsoft.Sustainability.FinancialReporting · captioned “Sustainability Account (Analysis View)” · BC29-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Sustainability Account (Analysis View) |
| 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 | No. | Code[20] | Specifies the value of the No. field. via Page 6244 “Sust. Accs. (Analysis View)” | TableRelation Table 6210 “Sustainability Account” (if (“Account Source” = const(“Sust. Account”)) “Sustainability Account”); NotBlank |
| 2 | Name | Text[100] | Specifies the value of the Name field. via Page 6244 “Sust. Accs. (Analysis View)” | |
| 3 | Search Name | Code[100] | — | |
| 4 | Account Type | Enum “Sustainability Account Type” | Specifies the value of the Account Type field. via Page 6244 “Sust. Accs. (Analysis View)” | enum Enum 6211 “Sustainability Account Type” |
| 5 | Account Source | Enum “Analysis Account Source” | — | enum Enum 7133 “Analysis Account Source” |
| 6 | Global Dimension 1 Code | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))) |
| 7 | Global Dimension 2 Code | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))) |
| 11 | No. 2 | Code[20] | — | |
| 12 | Comment | Boolean | — | FlowField: exist(“Comment Line” where(“Table Name” = const(“Sustainability Account”), “No.” = field(“No.”))); not editable |
| 13 | Blocked | Boolean | — | |
| 14 | Direct Posting | Boolean | Specifies the value of the Direct Posting field. via Page 6244 “Sust. Accs. (Analysis View)” | |
| 17 | New Page | Boolean | — | |
| 18 | No. of Blank Lines | Integer | — | |
| 19 | Indentation | Integer | — | |
| 26 | Last Date Modified | Date | — | not editable |
| 28 | Date Filter | Date | — | FlowFilter |
| 29 | Global Dimension 1 Filter | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))); FlowFilter |
| 30 | Global Dimension 2 Filter | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))); FlowFilter |
| 34 | Totaling | Text[250] | Specifies the value of the Totaling field. via Page 6244 “Sust. Accs. (Analysis View)” | TableRelation Table 6210 “Sustainability Account” (if (“Account Source” = const(“Sust. Account”)) “Sustainability Account”) |
| 35 | Budget Filter | Code[10] | — | TableRelation Table 95 “G/L Budget Name” (G/L Budget Name); FlowFilter |
| 40 | Consol. Debit Acc. | Code[20] | Specifies the value of the Consol. Debit Acc. field. via Page 6244 “Sust. Accs. (Analysis View)” | |
| 41 | Consol. Credit Acc. | Code[20] | Specifies the value of the Consol. Credit Acc. field. via Page 6244 “Sust. Accs. (Analysis View)” | |
| 42 | Business Unit Filter | Code[20] | — | TableRelation Table 220 “Business Unit” (Business Unit); FlowFilter |
| 43 | Gen. Posting Type | Option | Specifies the value of the Gen. Posting Type field. via Page 6244 “Sust. Accs. (Analysis View)” | OptionCaption: ,Purchase,Sale |
| 44 | Gen. Bus. Posting Group | Code[20] | Specifies the value of the Gen. Bus. Posting Group field. via Page 6244 “Sust. Accs. (Analysis View)” | TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group) |
| 45 | Gen. Prod. Posting Group | Code[20] | Specifies the value of the Gen. Prod. Posting Group field. via Page 6244 “Sust. Accs. (Analysis View)” | TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group) |
| 49 | Automatic Ext. Texts | Boolean | — | |
| 54 | Tax Area Code | Code[20] | — | TableRelation Table 318 “Tax Area” (Tax Area) |
| 55 | Tax Liable | Boolean | — | |
| 56 | Tax Group Code | Code[20] | — | TableRelation Table 321 “Tax Group” (Tax Group) |
| 57 | VAT Bus. Posting Group | Code[20] | Specifies the value of the VAT Bus. Posting Group field. via Page 6244 “Sust. Accs. (Analysis View)” | TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group) |
| 58 | VAT Prod. Posting Group | Code[20] | Specifies the value of the VAT Prod. Posting Group field. via Page 6244 “Sust. Accs. (Analysis View)” | TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group) |
| 63 | Exchange Rate Adjustment | Option | — | OptionCaption: No Adjustment,Adjust Amount,Adjust Additional-Currency Amount |
| 66 | Analysis View Filter | Code[10] | — | TableRelation Table 363 “Analysis View” (Analysis View); FlowFilter |
| 67 | Dimension 1 Filter | Code[20] | — | FlowFilter |
| 68 | Dimension 2 Filter | Code[20] | — | FlowFilter |
| 69 | Dimension 3 Filter | Code[20] | — | FlowFilter |
| 70 | Dimension 4 Filter | Code[20] | — | FlowFilter |
| 100 | Net Change (CO2) | Decimal | Specifies the net change of CO2 in the account balance during the time period in the Date Filter field. via Page 6244 “Sust. Accs. (Analysis View)” | FlowField: sum(“Analysis View Entry”.“Emission CO2” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = fie…; not editable |
| 101 | Balance at Date (CO2) | Decimal | Specifies the balance at date of CO2 on the account for the upper date in the Date Filter field. via Page 6244 “Sust. Accs. (Analysis View)” | FlowField: sum(“Analysis View Entry”.“Emission CO2” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = fie…; not editable |
| 102 | Balance (CO2) | Decimal | Specifies the balance of CO2 on the account. via Page 6244 “Sust. Accs. (Analysis View)” | FlowField: sum(“Analysis View Entry”.“Emission CO2” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = fie…; not editable |
| 103 | Net Change (CH4) | Decimal | Specifies the net change of CH4 in the account balance during the time period in the Date Filter field. via Page 6244 “Sust. Accs. (Analysis View)” | FlowField: sum(“Analysis View Entry”.“Emission CH4” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = fie…; not editable |
| 104 | Balance at Date (CH4) | Decimal | Specifies the balance at date of CH4 on the account for the upper date in the Date Filter field. via Page 6244 “Sust. Accs. (Analysis View)” | FlowField: sum(“Analysis View Entry”.“Emission CH4” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = fie…; not editable |
| 105 | Balance (CH4) | Decimal | Specifies the balance of CH4 on the account. via Page 6244 “Sust. Accs. (Analysis View)” | FlowField: sum(“Analysis View Entry”.“Emission CH4” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = fie…; not editable |
| 106 | Net Change (N2O) | Decimal | Specifies the net change of N2O in the account balance during the time period in the Date Filter field. via Page 6244 “Sust. Accs. (Analysis View)” | FlowField: sum(“Analysis View Entry”.“Emission N2O” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = fie…; not editable |
| 107 | Balance at Date (N2O) | Decimal | Specifies the balance at date of N2O on the account for the upper date in the Date Filter field. via Page 6244 “Sust. Accs. (Analysis View)” | FlowField: sum(“Analysis View Entry”.“Emission N2O” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = fie…; not editable |
| 108 | Balance (N2O) | Decimal | Specifies the balance of N2O on the account. via Page 6244 “Sust. Accs. (Analysis View)” | FlowField: sum(“Analysis View Entry”.“Emission N2O” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = fie…; not editable |
| 109 | Net Change (CO2e Emission) | Decimal | Specifies the net change of CO2e Emission in the account balance during the time period in the Date Filter field. via Page 6244 “Sust. Accs. (Analysis View)” | FlowField: sum(“Analysis View Entry”.“CO2e Emission” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = fi…; not editable |
| 110 | Bal. at Date (CO2e Emission) | Decimal | Specifies the balance at date of CO2e Emission on the account for the upper date in the Date Filter field. via Page 6244 “Sust. Accs. (Analysis View)” | FlowField: sum(“Analysis View Entry”.“CO2e Emission” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = fi…; not editable |
| 111 | Balance (CO2e Emission) | Decimal | Specifies the balance of CO2e Emission on the account. via Page 6244 “Sust. Accs. (Analysis View)” | FlowField: sum(“Analysis View Entry”.“CO2e Emission” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = fi…; not editable |
| 112 | Net Change (Carbon Fee) | Decimal | Specifies the net change of Carbon Fee in the account balance during the time period in the Date Filter field. via Page 6244 “Sust. Accs. (Analysis View)” | FlowField: sum(“Analysis View Entry”.“Carbon Fee” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = field…; not editable |
| 113 | Balance at Date (Carbon Fee) | Decimal | Specifies the balance at date of Carbon Fee on the account for the upper date in the Date Filter field. via Page 6244 “Sust. Accs. (Analysis View)” | FlowField: sum(“Analysis View Entry”.“Carbon Fee” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = field…; not editable |
| 114 | Balance (Carbon Fee) | Decimal | Specifies the balance of Carbon Fee on the account. via Page 6244 “Sust. Accs. (Analysis View)” | FlowField: sum(“Analysis View Entry”.“Carbon Fee” where(“Analysis View Code” = field(“Analysis View Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Account No.” = field(“No.”), “Account Source” = field(“Account Source”), “Account No.” = field(filter(Totaling)), “Dimension 1 Value Code” = field…; not editable |
Keys
- Key1: No., Account Source (clustered)
- Key2: Search Name
- Key3: Gen. Bus. Posting Group
- Key4: Gen. Prod. Posting Group
Events published
OnBeforeGetCaptionClass(var SustAccountAnalysisView: Record "Sust. Account (Analysis View)"; AnalysisViewDimType: Integer; var Result: Text[250]; var IsHandled: Boolean)(integration)
Procedures
GetCaptionClass(AnalysisViewDimType: Integer): Text[250]CopyDimFilters(var AccSchedLine: Record "Acc. Schedule Line")SetDimFilters(DimFilter1: Text; DimFilter2: Text; DimFilter3: Text; DimFilter4: Text)
Relations
- Business Unit Filter: TableRelation Table 220 “Business Unit”
- Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
- Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
- Tax Area Code: TableRelation Table 318 “Tax Area”
- Tax Group Code: TableRelation Table 321 “Tax Group”
- VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
- VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
- Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Global Dimension 1 Filter: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Filter: TableRelation Table 349 “Dimension Value”
- Analysis View Filter: TableRelation Table 363 “Analysis View”
- Bal. at Date (CO2e Emission): CalcFormula Table 365 “Analysis View Entry”
- Balance (Carbon Fee): CalcFormula Table 365 “Analysis View Entry”
- Balance (CH4): CalcFormula Table 365 “Analysis View Entry”
- Balance (CO2): CalcFormula Table 365 “Analysis View Entry”
- Balance (CO2e Emission): CalcFormula Table 365 “Analysis View Entry”
- Balance (N2O): CalcFormula Table 365 “Analysis View Entry”
- Balance at Date (Carbon Fee): CalcFormula Table 365 “Analysis View Entry”
- Balance at Date (CH4): CalcFormula Table 365 “Analysis View Entry”
- Balance at Date (CO2): CalcFormula Table 365 “Analysis View Entry”
- Balance at Date (N2O): CalcFormula Table 365 “Analysis View Entry”
- Net Change (Carbon Fee): CalcFormula Table 365 “Analysis View Entry”
- Net Change (CH4): CalcFormula Table 365 “Analysis View Entry”
- Net Change (CO2): CalcFormula Table 365 “Analysis View Entry”
- Net Change (CO2e Emission): CalcFormula Table 365 “Analysis View Entry”
- Net Change (N2O): CalcFormula Table 365 “Analysis View Entry”
- No.: TableRelation Table 6210 “Sustainability Account”
- Totaling: TableRelation Table 6210 “Sustainability Account”
- Budget Filter: TableRelation Table 95 “G/L Budget Name”
- Comment: CalcFormula Table 97 “Comment Line”
Pages and codeunits on this table
- Page 6244 “Sust. Accs. (Analysis View)” (source table)
Ask your agent
Procedure bodies are not stored here (D10). 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: "Sust. Account (Analysis View)"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.