file link: PCF_InputFile_ef_supplier
Purpose of the file: This file includes comprehensive data on emission factors associated with suppliers and their products, encompassing both Product Carbon Footprint (PCF) and biogenic emissions.
| gbu | Rawmaterial_code | Rawmaterial_name | Supplier_code | Supplier_name | Plant_code | Plant_name | PCF_supplier | BCC_supplier | TCC_supplier | RCC_supplier | CCU_CC_supplier | PCF_transport_supplier | PDS_supplier | DQR_supplier | Adj_coeff_supplier | Activity_Year | |
| Sample Data | CS | WP1_400/118919 | 2-ETHYL HEXYL ACRYLATE BULK | 106496 | BASF CORP | 1402 | CLAMECY | 2.31 | 3 | 2021 | |||||||
| Mandatory Field ? | Mandatory field; Must be filled. Validation if the GBU exists. | Mandatory field; Must be filled | Mandatory field; Must be filled | Mandatory field; Must be filled | Mandatory field; Must be filled | Mandatory field; Must be filled | Mandatory field; Must be filled | Mandatory field; | Not mandatory field. If the field is filled, the values should be between 0 and 1 | Not mandatory field. If the field is filled, the values should be between 0 and 1 | Not mandatory field. If the field is filled, the values should be between 0 and 1 | Not mandatory field. If the field is filled, the values should be between 0 and 1 | Not mandatory field. If the field is filled, the values should be between 0 and 20 | Not mandatory field | Not mandatory field.If the field is filled, the values should be between 1 and 3 | Not mandatory field. | Mandatory field |
| Data Type | string | string | string | string | string | string | string | Float greater than 20 and lower than - 20 should be uploaded, | float between 0 and 1 | float between 0 and 1 | float between 0 and 1 | float between 0 and 1 | float between 0 and 20 | float between 0 and 1 | float between 1 and 3 | float | string |
| Field Description | SAP code of the GBU (Global Business Unit); It can take the values "CS" for Novecare, "SP" for Specialty Polymers | SAP Raw Material Code | SAP Raw Material Name | SAP Supplier Code from BW SPRINT | SAP Supplier Name from BW SPRINT | SAP Plant Code | SAP Plant Name | Validated PCF from the supplier for the specific Raw Material | Validated PCF for upstream transportation from the supplier to Syensqo for the specific Raw Material | Coefficient specifying the concentration for the specific Raw Material | Year for which PCF is calculated | ||||||
| Comments |
Data Owner - Hubert Sizaret (the data owner will receive the error file by email and will be responsible for making any necessary manual corrections.)