CCF — Materials
Yearly import that declares the total consumption volume of each material per collection and category within the carbon footprint scope.
Import behavior: user choice — via the SBP UI you can select incremental import or delete-and-reload at the time of upload.
Dependency: MATERIAL_CODE and MATERIAL SUB-CODE must already exist in the Material Library for the same reporting year.
FAQ
What happens to existing records on re-import?
Via the UI, you choose whether to delete existing data or perform an incremental import.
Can I change column order or titles?
No.
How do I update existing records?
Export via Export file, edit rows, re-upload.
What if a material code is not found?
All material codes must be imported into the Material Library first. Codes not present in the Material Library will cause an import error.
Schema
| Column | Mandatory | Definition | Rule | Type | Example |
|---|---|---|---|---|---|
| MATERIAL_TYPE | YES | Whether the material is a production or packaging material | Select from dropdown | single select | material |
| COLLECTION_CATEGORY | YES | Collection category cluster | Select from dropdown | single select | ready_to_wear |
| COLLECTION_NAME | NO | Name of an existing collection | Select from collection list | single select | SS24 |
| MATERIAL_CODE | YES | Material code from the Material Library | Select from dropdown | single select | ER_433_pack |
| MATERIAL SUB-CODE | NO | Material sub-code | Max 255 chars | alphanumeric | SW-01-Blu |
| CONSUMPTION_VALUE | YES | Total consumption of the material for the year | 0.01 ≤ x ≤ 1,000,000 · 2 decimal digits | numeric | 200.43 |
| CONSUMPTION_UNIT_OF_MEASURE | YES | Unit of measure for consumption | Select from dropdown | single select | mt |
Glossaries
MATERIAL_TYPE — 2 values: packaging · material
COLLECTION_CATEGORY — 10 values
ready_to_wear · footwear · bags_&_backpacks · accessories · activewear_outerwear · knitwear · underwear · swimwear · others · Sportswear
COLLECTION_NAME — dynamic, populated from platform data.
MATERIAL_CODE — dynamic, populated from platform data.
CONSUMPTION_UNIT_OF_MEASURE — 4 values: kg · mt · sqm · u
Cross-file dependencies
| Column | References |
|---|---|
| MATERIAL_CODE | Material Library (same reporting year) |
| MATERIAL SUB-CODE | Material Library (same reporting year) |