File link:
1.Purpose of the file
This file is used to collect and centralise Product Carbon Footprint (PCF) data provided by external suppliers for specific raw materials procured by Syensqo. It records validated supplier PCF values and their carbon breakdowns (fossil, biogenic, land use, aircraft), together with supplementary indicators such as carbon content (BCC, TCC, RCC, CCU), transport PCF, primary data share, and data quality rating.
The data supports environmental reporting, sustainability assessments, and internal PCF calculations at the material/plant level.
2. File Structure
2.1. List of tabs
| Sheet Name | Description | Mandatory | Comment |
Sheet1 | Main data entry sheet. Contains validated supplier PCF values per raw material, supplier, and plant combination. | YES | Don't delete this sheet |
2.2. Main columns description
SHEET: Sheet1_TFS
| Field | Prod_Year | GBU | material_code | material_name | Supplier_code | Supplier_name | Plant_code | Plant_name | PCF_supplier | PCF_supplier_fossil | PCF_supplier_biogenic | PCF_supplier_landuse | PCF_supplier_aircraft | BCC_supplier | TCC_supplier | RCC_supplier | CCU_CC_supplier | PCF_transport_supplier | PDS_supplier | DQR_supplier | Adj_coeff_supplier | Comment | Qualification_Status | Collection_Date | Qualification_Date | Qualificator |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Description | Calendar year for which the PCF data is reported. | SAP code of the Global Business Unit. Validated against known GBU list. | SAP Raw Material Code uniquely identifying the purchased material. | SAP Raw Material Name as registered in the ERP system. | SAP Supplier Code from BW SPRINT identifying the supplying company. | SAP Supplier Name from BW SPRINT. | SAP Plant Code identifying the receiving Syensqo plant. | SAP Plant Name corresponding to the plant code. | Validated total Product Carbon Footprint (kgCO₂e/kg) from the supplier for this raw material. | Fossil carbon component of the supplier PCF. | Biogenic carbon component of the supplier PCF. | Land-use carbon component of the supplier PCF. | Aircraft (air-transport) carbon component of the supplier PCF. | Biogenic Carbon Content: kgC of renewable biological origin per kg of product (from supplier). | Total Carbon Content: total kgC per kg of product shared by the supplier. | Recycled Carbon Content: kgC from recycled sources per kg of product. | Carbon Capture & Utilisation: CO₂ captured and embedded in the product (kgC/kg). | Validated upstream transport PCF (kgCO₂e/kg) from supplier site to Syensqo plant. | Primary Data Share: proportion of PCF data collected directly from the supplier (0–1). | Data Quality Rating (1 = best, 3 = lowest). | Adjustment coefficient accounting for material concentration (e.g. solutions). | Free-text field for additional notes or clarifications regarding the data row. | Status of the PCF qualification process within Syensqo. | Date on which the PCF was collected from the supplier. | Date on which the PCF was qualified internally within Syensqo. | Name of the Syensqo person responsible for qualifying the supplier PCF. |
| Data Type | String YYYY | String | String | String | String | String | String | String | Float | Float | Float | Float | Float | Float 0–1 | Float 0–1 | Float 0–1 | Float 0–1 | Float 0–20 | Float 0–1 | Float 1–3 | Float | String | String | Date | Date | String |
| Mandatory | YES | YES | YES | YES | YES | YES | YES | YES | YES | NO | NO | NO | NO | NO | NO | NO | NO | NO | NO | NO | NO | NO | NO | NO | NO | NO |
| Validation / Allowed Values | e.g. 2024, 2025 | CS (Novecare) or "SP" (Specialty Polymers) | e.g. PF2_020/208483 | Free text; must match SAP record | Numeric SAP vendor code | Free text; must match SAP record | e.g. CZS, AQS, MJS | Free text; must match SAP record | Values outside –20 / +20 will be rejected | ≥ 0 | ≥ 0 | ≥ 0 | ≥ 0 | Between 0 and 1 | Between 0 and 1 | Between 0 and 1 | Between 0 and 1 | Between 0 and 20 | Between 0 and 1 | Between 1 and 3 | Typically between 0 and 1 | Free text | Validated (default if empty) | Pending | Rejected | Supports historisation; format YYYY-MM-DD | Supports historisation; format YYYY-MM-DD | Free text |
3. Filling instructions
| Field | Instructions |
| Sheet1_TFS | • Complete all mandatory fields for every row. Rows with missing mandatory values will be rejected during upload. • Use the correct data format for each column (see Section 2.2 above). • PCF_supplier is mandatory and must be a float. Values outside the range –20 to +20 kgCO₂e/kg will be rejected. • For BCC_supplier, TCC_supplier, RCC_supplier, CCU_CC_supplier, and PDS_supplier: if filled, values must be between 0 and 1. • For PCF_transport_supplier: if filled, value must be between 0 and 20. • For DQR_supplier: if filled, value must be between 1 (best quality) and 3 (lowest quality). • For Qualification_Status: leave empty (defaults to "Validated"), or enter exactly "Pending" or "Rejected". • Do not modify, add, or remove columns. • Duplicate rows (same Prod_Year + material_code + Supplier_code + Plant_code) will be rejected. Ensure no duplicate entries are present. • Do not leave mandatory fields blank. |
4. Maintenance best practices
Please comply with the following instructions to maintain the file:
• Always keep the original structure (do not add/remove columns without approval).
• Update only the necessary fields.
• Save a backup copy before any major changes.
• Respect data confidentiality.
5. Contact Points
| File owner | Hubert Sizaret |
| Technical Support | Camille Faure Laëtitia Arantes |
The data owner will receive the error file by email and will be responsible for making any necessary manual corrections.
For any questions or issues, please contact the responsible person listed above.
Please strictly follow these guidelines to ensure data quality and reliability.