Table extension 6212 "Sustainability Purch. Header"
Sustainability · Microsoft.Sustainability.Purchase
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 2 connected objects and pages
Sustainability · Microsoft.Sustainability.Purchase · BC29-30 · source at ea08af5e · facts from BC29
Extends Purchase Header.
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 |
|---|---|---|---|---|
| 6210 | Sustainability Lines Exist | Boolean | — | FlowField: exist(“Purchase Line” where(“Sust. Account No.” = filter(‘<>’‘’‘’), “Document No.” = field(“No.”))); not editable |
| 6211 | Emission C02 | Decimal | Specifies the Emission C02 for Purchase Order via Page extension 6217 “Sust. Purch. Order Stats.” | FlowField: sum(“Purchase Line”.“Emission CO2” where(“Document Type” = field(“Document Type”), “Document No.” = field(“No.”))); not editable |
| 6212 | Emission CH4 | Decimal | Specifies the Emission CH4 for Purchase Order via Page extension 6217 “Sust. Purch. Order Stats.” | FlowField: sum(“Purchase Line”.“Emission CH4” where(“Document Type” = field(“Document Type”), “Document No.” = field(“No.”))); not editable |
| 6213 | Emission N2O | Decimal | Specifies the Emission N2O for Purchase Order via Page extension 6217 “Sust. Purch. Order Stats.” | FlowField: sum(“Purchase Line”.“Emission N2O” where(“Document Type” = field(“Document Type”), “Document No.” = field(“No.”))); not editable |
| 6214 | Posted Emission C02 | Decimal | Specifies the Posted Emission C02 for Purchase Order via Page extension 6217 “Sust. Purch. Order Stats.” | FlowField: sum(“Purchase Line”.“Posted Emission CO2” where(“Document Type” = field(“Document Type”), “Document No.” = field(“No.”))); not editable |
| 6215 | Posted Emission CH4 | Decimal | Specifies the Posted Emission CH4 for Purchase Order via Page extension 6217 “Sust. Purch. Order Stats.” | FlowField: sum(“Purchase Line”.“Posted Emission CH4” where(“Document Type” = field(“Document Type”), “Document No.” = field(“No.”))); not editable |
| 6216 | Posted Emission N2O | Decimal | Specifies the Posted Emission N2O for Purchase Order via Page extension 6217 “Sust. Purch. Order Stats.” | FlowField: sum(“Purchase Line”.“Posted Emission N2O” where(“Document Type” = field(“Document Type”), “Document No.” = field(“No.”))); not editable |
| 6217 | Energy Consumption | Decimal | Specifies the Energy Consumption for Purchase Order via Page extension 6217 “Sust. Purch. Order Stats.” | FlowField: sum(“Purchase Line”.“Energy Consumption” where(“Document Type” = field(“Document Type”), “Document No.” = field(“No.”))); not editable |
| 6218 | Posted Energy Consumption | Decimal | Specifies the Posted Energy Consumption for Purchase Order via Page extension 6217 “Sust. Purch. Order Stats.” | FlowField: sum(“Purchase Line”.“Posted Energy Consumption” where(“Document Type” = field(“Document Type”), “Document No.” = field(“No.”))); not editable |
| 6219 | Total Emission Cost | Decimal | Specifies the Total CBAM Cost for Purchase Order via Page extension 6217 “Sust. Purch. Order Stats.” | FlowField: sum(“Purchase Line”.“Total Emission Cost” where(“Document Type” = field(“Document Type”), “Document No.” = field(“No.”))); not editable |
| 6220 | Posted Total Emission Cost | Decimal | Specifies the Posted Total Emission Cost for Purchase Order via Page extension 6217 “Sust. Purch. Order Stats.” | FlowField: sum(“Purchase Line”.“Posted Total Emission Cost” where(“Document Type” = field(“Document Type”), “Document No.” = field(“No.”))); not editable |
Relations
- extends Table 38 “Purchase Header”
- Emission C02: CalcFormula Table 39 “Purchase Line”
- Emission CH4: CalcFormula Table 39 “Purchase Line”
- Emission N2O: CalcFormula Table 39 “Purchase Line”
- Energy Consumption: CalcFormula Table 39 “Purchase Line”
- Posted Emission C02: CalcFormula Table 39 “Purchase Line”
- Posted Emission CH4: CalcFormula Table 39 “Purchase Line”
- Posted Emission N2O: CalcFormula Table 39 “Purchase Line”
- Posted Energy Consumption: CalcFormula Table 39 “Purchase Line”
- Posted Total Emission Cost: CalcFormula Table 39 “Purchase Line”
- Sustainability Lines Exist: CalcFormula Table 39 “Purchase Line”
- Total Emission Cost: CalcFormula Table 39 “Purchase Line”
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: "tableextension", object_name: "Sustainability Purch. Header"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.