Standardized reporting date
Microsoft Cloud for Sustainability
The Reporting date field in Microsoft Sustainability Manager standardizes the date across different carbon, water, waste, and circularity data sources to provide streamlined reporting and analysis. This field is derived from existing data points, such as transaction dates, consumption start dates, and consumption end dates. With this field, you can efficiently query and align data for Power BI reporting, preparation reports, scorecards, goals, and other platform components, ensuring data consistency and enabling effective analysis across all relevant categories within the system.
These tables show which dates map to the Reporting date field in reports and analysis.
Carbon data
| Scope | Category | Consumption start date | Consumption end date | Transaction date | Entity logical name | Attribute logical name |
|---|---|---|---|---|---|---|
| 1 | Fugitive emissions (Emissions) | X | msdyn_emission | msdyn_transactiondate | ||
| 1 | Industrial Process | X | msdyn_industrialprocess | msdyn_consumptionenddate | ||
| 1 | Mobile combustion | X | msdyn_mobilecombustion | msdyn_consumptionenddate | ||
| 1 | Stationary combustion | X | msdyn_stationarycombustion | msdyn_consumptionenddate | ||
| 2 | Purchased cooling | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 2 | Purchased electricity | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 2 | Purchased heat | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 2 | Purchased steam | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 3 | 1. Purchased goods and services (Emissions) | X | msdyn_emission | msdyn_transactiondate | ||
| 3 | 2. Capital goods (Emissions) | X | msdyn_emission | msdyn_transactiondate | ||
| 3 | 3. (Preview) Fuel- and energy-related activities - Mobile combustion | X | msdyn_mobilecombustion | msdyn_consumptionenddate | ||
| 3 | 3. (Preview) Fuel- and energy-related activities - Mobile combustion (Emissions) | X | msdyn_emission | msdyn_consumptionenddate | ||
| 3 | 3. (Preview) Fuel- and energy-related activities - Purchased cooling | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 3 | 3. (Preview) Fuel- and energy-related activities - Purchased cooling (Emissions) | X | msdyn_emission | msdyn_consumptionenddate | ||
| 3 | 3. (Preview) Fuel- and energy-related activities - Purchased electricity | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 3 | 3. (Preview) Fuel- and energy-related activities - Purchased electricity (Emissions) | X | msdyn_emission | msdyn_consumptionenddate | ||
| 3 | 3. (Preview) Fuel- and energy-related activities - Purchased heat | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 3 | 3. (Preview) Fuel- and energy-related activities - Purchased heat (Emissions) | X | msdyn_emission | msdyn_consumptionenddate | ||
| 3 | 3. (Preview) Fuel- and energy-related activities - Purchased steam | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 3 | 3. (Preview) Fuel- and energy-related activities - Purchased steam (Emissions) | X | msdyn_emission | msdyn_consumptionenddate | ||
| 3 | 3. (Preview) Fuel- and energy-related activities - Stationary combustion | X | msdyn_stationarycombustion | msdyn_consumptionenddate | ||
| 3 | 3. (Preview) Fuel- and energy-related activities - Stationary combustion (Emissions) | X | msdyn_emission | msdyn_consumptionenddate | ||
| 3 | 3. (Preview) Fuel- and energy-related activities - Unspecified (Emissions) | X | msdyn_emission | msdyn_consumptionenddate | ||
| 3 | 4. Upstream transportation and distribution (Emissions) | X | msdyn_emission | msdyn_transactiondate | ||
| 3 | 5. Waste generated in operations | X | msdyn_wastegeneratedinoperations | msdyn_consumptionenddate | ||
| 3 | 6. Business travel | X | msdyn_businesstravel | msdyn_consumptionenddate | ||
| 3 | 7. Employee commuting | X | msdyn_employeecommuting | msdyn_consumptionenddate | ||
| 3 | 8. Upstream leased assets - Purchased steam | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 3 | 8. Upstream leased assets - Purchased heat | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 3 | 8. Upstream leased assets - Fugitive emissions (Emissions) | X | msdyn_emission | msdyn_transactiondate | ||
| 3 | 8. Upstream leased assets - Mobile combustion | X | msdyn_mobilecombustion | msdyn_consumptionenddate | ||
| 3 | 8. Upstream leased assets - Purchased cooling | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 3 | 8. Upstream leased assets - Purchased electricity | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 3 | 8. Upstream leased assets - Stationary combustion | X | msdyn_stationarycombustion | msdyn_consumptionenddate | ||
| 3 | 9. Downstream transportation and distribution (Emissions) | X | msdyn_emission | msdyn_transactiondate | ||
| 3 | 10. Processing of sold products - Stationary combustion | X | msdyn_stationarycombustion | msdyn_consumptionenddate | ||
| 3 | 10. Processing of sold products - Mobile combustion | X | msdyn_mobilecombustion | msdyn_consumptionenddate | ||
| 3 | 10. Processing of sold products (Emissions) | X | msdyn_emission | msdyn_transactiondate | ||
| 3 | 10. Processing of sold products - Industrial process | X | msdyn_industrialprocess | msdyn_consumptionenddate | ||
| 3 | 10. Processing of sold products - Purchased electricity | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 3 | 10. Processing of sold products - Purchased cooling | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 3 | 10. Processing of sold products - Purchased heat | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 3 | 10. Processing of sold products - Purchased steam | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 3 | 10. Processing of sold products - Waste generated in operations | X | msdyn_wastegeneratedinoperations | msdyn_consumptionenddate | ||
| 3 | 11. Use of sold products - Purchased heat | X | msdyn_purchasedenergy | msdyn_consumptionstartdate | ||
| 3 | 11. Use of sold products - Industrial process | X | msdyn_industrialprocess | msdyn_consumptionstartdate | ||
| 3 | 11. Use of sold products - Fugitive emissions | X | msdyn_fugitiveemission | msdyn_consumptionstartdate | ||
| 3 | 11. Use of sold products - Purchased cooling | X | msdyn_purchasedenergy | msdyn_consumptionstartdate | ||
| 3 | 11. Use of sold products - Mobile combustion | X | msdyn_mobilecombustion | msdyn_consumptionstartdate | ||
| 3 | 11. Use of sold products - Purchased electricity | X | msdyn_purchasedenergy | msdyn_consumptionstartdate | ||
| 3 | 11. Use of sold products - Stationary combustion | X | msdyn_stationarycombustion | msdyn_consumptionstartdate | ||
| 3 | 11. Use of sold products - Purchased steam | X | msdyn_purchasedenergy | msdyn_consumptionstartdate | ||
| 3 | 12. End-of-life treatment of sold products | X | msdyn_endoflifetreatmentofsoldproducts | msdyn_consumptionenddate | ||
| 3 | 13. Downstream leased assets - Fugitive emissions (Emissions) | X | msdyn_emission | msdyn_transactiondate | ||
| 3 | 13. Downstream leased assets - Purchased electricity | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 3 | 13. Downstream leased assets - Purchased heat | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 3 | 13. Downstream leased assets - Mobile combustion | X | msdyn_mobilecombustion | msdyn_consumptionenddate | ||
| 3 | 13. Downstream leased assets - Stationary combustion | X | msdyn_stationarycombustion | msdyn_consumptionenddate | ||
| 3 | 13. Downstream leased assets - Purchased cooling | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 3 | 13. Downstream leased assets - Purchased steam | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 3 | 14. Franchises - Purchased heat | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 3 | 14. Franchises - Purchased electricity | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 3 | 14. Franchises - Purchased cooling | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 3 | 14. Franchises - Mobile combustion | X | msdyn_mobilecombustion | msdyn_consumptionenddate | ||
| 3 | 14. Franchises - Industrial process | X | msdyn_industrialprocess | msdyn_consumptionenddate | ||
| 3 | 14. Franchises - Purchased steam | X | msdyn_purchasedenergy | msdyn_consumptionenddate | ||
| 3 | 14. Franchises - Fugitive emissions | X | msdyn_fugitiveemission | msdyn_transactiondate | ||
| 3 | 14. Franchises - Stationary combustion | X | msdyn_stationarycombustion | msdyn_consumptionenddate | ||
| 3 | 15. Investments - Business loans and unlisted equity | X | msdyn_investment | msdyn_consumptionenddate | ||
| 3 | 15. Investments - Listed equity and corporate bonds | X | msdyn_investment | msdyn_consumptionenddate | ||
| 3 | 15. Investments - Commercial real estate | X | msdyn_investment | msdyn_consumptionstartdate | ||
| 3 | 15. Investments - Sovereign bonds | X | msdyn_investment | msdyn_consumptionenddate | ||
| 3 | 15. Investments - Project finance | X | msdyn_investment | msdyn_consumptionenddate | ||
| 3 | 15. Investments - Motor vehicle loan | X | msdyn_investment | msdyn_consumptionstartdate | ||
| 3 | 15. Investments - Mortgages | X | msdyn_investment | msdyn_consumptionstartdate |
Water, waste, and circularity data
| Module | Sustainability data definition name | Field/attribute to be mapped | Required (Y/N) | Secondary field/atribute to be mapped | Entity logical name | Attribute logical name |
|---|---|---|---|---|---|---|
| Water | (Preview) Water quantities | Transaction end date | Y | msdyn_waterquantity | msdyn_transactionenddate | |
| Water | (Preview) Stored water | Measurement date | Y | msdyn_storedwater | msdyn_measurementdate | |
| Water | (Preview) Water quality test results | Water quality test date | Y | msdyn_waterqualitytestresult | msdyn_waterqualitytestdate | |
| Water | (Preview) Water samples | Collection date | N | N/A | msdyn_watersamplev2 | msdyn_collectiondate |
| Waste | (Preview) Waste quantities | Diversion end date | Y | msdyn_wastequantity | msdyn_diversionenddate | |
| Waste | (Preview) Waste quality test results | Waste quality test date | Y | msdyn_wastequalitytestresult | msdyn_wastequalitytestdate | |
| Waste | (Preview) Waste test methods | Collection date | N | N/A | msdyn_wastetestmethod | msdyn_collectiondate |
| Waste | (Preview) Item sustainable content | Valid to date | N | Valid from date | msdyn_itemsustainablecontent | msdyn_validtodate |
| Waste | (Preview) Item bill of materials | Valid to date | N | Valid from date | msdyn_itembillofmaterial | msdyn_validtodate |
| Waste | (Preview) Facility item consumption | Consumption end date | N | Consumption start date | msdyn_facilityitemconsumption | msdyn_consumptionenddate |
| Reference data | (Preview) Facility item production | Production end date | N | Production start date | msdyn_facilityitemproduction | msdyn_productionenddate |
| Reference data | (Preview) Facility capacities | Period end date | Y | msdyn_facilitycapacity | msdyn_periodenddate | |
| Reference data | (Preview) Sustainability item | Valid to date | N | Valid from date | msdyn_sustainabilityitemsku | msdyn_validtodate |
