/SRMSMC/D_S_SUST

Supplier Sustainability Data | #other | Component: Supplier Data Management
Column Name Description
CLIENT Client
PARTNER Key: Supplier ID
RECORD_GUID UUID in X form (binary)
Column Name Description
💲 Currency (SOC_FINES_CURR):
SOC_FINES Fines Paid for Non-Compliance with Social Standards
💲 Currency (ENV_FINES_CURR):
ENV_FINES Environmental Fine
💲 Currency (TOTAL_SPEND_CURR):
TOTAL_SPEND Total Spend with Supplier
💲 Currency (TOT_REVENUE_CURR):
TOTAL_REVENUE Total Revenue of Supplier
Column Name Description
📏 Total Energy Consumption Unit (TTL_ENR_CONS_UN):
TTL_ENR_CONS Total Energy Consumption
📏 Renewable Energy Unit (RENEW_ENERGY_UN):
RENEWABLE_ENERGY Renewable Energy
📏 Total Water Consumption Unit (TTL_WATER_CON_UN):
TTL_WATER_CONS Total Water Consumption
📏 Water Recycled Unit (RECYCL_WATER_UN):
RECYCLED_WATER Amount of Water Recycled
📏 Direct Emissions Unit (GHG_SCOPE1_UN):
GHG_SCOPE1 Direct Emissions
📏 Indirect Emissions Unit (GHG_SCOPE2_UN):
GHG_SCOPE2 Indirect Emissions
📏 Third-Party Emissions Unit (GHG_SCOPE3_UN):
GHG_SCOPE3 Third-Party Emissions
📏 Total Non-Hazardous Waste Unit (WASTE_NON_HZD_UN):
WASTE_NON_HZD Total Non-Hazardous Waste
📏 Total Hazardous Waste Unit (WASTE_HZD_UNIT):
WASTE_HZD Total Hazardous Waste
📏 Total Waste Recycled Unit (WASTE_RECYCLD_UN):
WASTE_RECYCLED Total Waste Recycled
Column Name Description
VALIDITY_START Validity Start Date
VALIDITY_END Validity End Date
AUDIT_CONDUCT_ON Audit Date
SUPP_COC_DATE Supplier Code of Conduct Date
SUST_REPORT_DATE Last Publication Date of Sustainability Report
WOM_OWNED_EXP Expiration Date of a Certificate (WBE/MBE, for ex.)
MIN_OWNED_EXP Expiration Date of a Certificate (WBE/MBE, for ex.)
Column Name Description
SUPP_COC Supplier Code of Conduct Indicator Show values
SUST_RPT_RATING Sustainability Reporting Standard Rating Show values
DEL_FLAG Checkbox Show values
OVERALL_SCORE Overall Score Show values
TOT_RESP_SCORE Social Responsibility Compliance Score Show values
TOT_ENV_SCORE Total Environmental Compliance Score Show values
TOT_ECO_SCORE Total Economic Compliance Score Show values
SOC_PROC_SYS Social Compliance Regarding Processes and Systems Show values
HUMAN_RIGHTS Human Rights Compliance Code Show values
HEALTH_SAFETY Health and Safety Compliance Code Show values
DISCRIMINATION Non-Discrimination Compliance Code Show values
CHILD_LABOUR Child Labor Compliance Code Show values
FORCED_LABOUR Forced Labor Compliance Code Show values
COL_BARGAINING Right to Collective Bargaining Compliance Code Show values
ANTI_CORRUPTION Anti-Corruption Compliance Code Show values
WOMEN_OWNED Women-Owned Business (WBE-Certified) Show values
MINORITY_OWNED Minority-Owned Business (MBE-Certified) Show values
ENV_PROTECTION Environmental Protection Compliance Code Show values
ENV_INITIATIVES Environmental Initiatives Compliance Code Show values
ENV_TECHNOLOGY Clean Technology Compliance Code Show values
ENV_PROC_SYS Environmental Compliance Regarding Processes and Systems Show values
TOTAL_RISK Total Supply Risk Code Show values
FINANCIAL_RISK Financial Supply Risk Code Show values
LOGISTICAL_RISK Logistics Supply Risk Code Show values
QUALITY_RISK Quality Supply Risk Code Show values
POLITICAL_RISK Political Supply Risk Code Show values
EVALUATION_SCORE Evaluation Score (0 to 100; Manually Assigned to Suppliers) Show values
STRAT_IMPORTANCE Strategic Importance Code Show values
PREFERRED_SUPPL Preferred Supplier Indicator Show values
STRAT_PARTNER Strategic Partnership Indicator Show values
QUALIFICATION Supplier Qualification Level Code Show values
DEPENDENCY_RATIO Dependency Ratio Show values
Column Name Description Domain name
AUDIT_AGENCY Audit Agency
SUST_REPORT Sustainability Reporting Standard
SOC_COMMENTS Comments TEXT255
ENV_COMMENTS Comments TEXT255
EMPLOYEE_COUNT Number of Employees SSTN_EMP_COUNT
DUMMY_EEW_SSTN Dummy function in length 1 DUMMY
SUPPLIER_AREA Supplier Area Grouping Code SSTN_SUPPLIER_AREA_GROUPING
SUPPLIER_ORIGIN Supplier Origin Type Code SSTN_SUPPLIER_ORIGIN_TYPE
Master Data Relations Join Conditions
Direct Emissions Unit
  • /SRMSMC/D_S_SUST.CLIENT == T006.MANDT
  • /SRMSMC/D_S_SUST.GHG_SCOPE1_UN == T006.MSEHI
Indirect Emissions Unit
  • /SRMSMC/D_S_SUST.CLIENT == T006.MANDT
  • /SRMSMC/D_S_SUST.GHG_SCOPE2_UN == T006.MSEHI
Third-Party Emissions Unit
  • /SRMSMC/D_S_SUST.CLIENT == T006.MANDT
  • /SRMSMC/D_S_SUST.GHG_SCOPE3_UN == T006.MSEHI
Water Recycled Unit
  • /SRMSMC/D_S_SUST.CLIENT == T006.MANDT
  • /SRMSMC/D_S_SUST.RECYCL_WATER_UN == T006.MSEHI
Renewable Energy Unit
  • /SRMSMC/D_S_SUST.CLIENT == T006.MANDT
  • /SRMSMC/D_S_SUST.RENEW_ENERGY_UN == T006.MSEHI
Total Energy Consumption Unit
  • /SRMSMC/D_S_SUST.CLIENT == T006.MANDT
  • /SRMSMC/D_S_SUST.TTL_ENR_CONS_UN == T006.MSEHI
Total Water Consumption Unit
  • /SRMSMC/D_S_SUST.CLIENT == T006.MANDT
  • /SRMSMC/D_S_SUST.TTL_WATER_CON_UN == T006.MSEHI
Total Hazardous Waste Unit
  • /SRMSMC/D_S_SUST.CLIENT == T006.MANDT
  • /SRMSMC/D_S_SUST.WASTE_HZD_UNIT == T006.MSEHI