Skip to main content

Data Collection: Templates

R
Written by Root Support
Updated over a week ago

  • Order ID *: Unique identifier for the order.

  • Order date *: Date when the order was placed.

  • Product ID *: Unique identifier for the product.

  • Product name: Name of the product.

  • Quantity *: Number of units ordered.

  • Departure facility *: Location from where the order was shipped.

  • Arrival facility *: Location where the order was received. Preferably as specific as possible, but you can also fill in a city or a postcode (+country).

  • Transport category: Classification of your purchase orders based on the mode of transport used. Think about: international shipments by sea or sample orders.

  • Status: Status of the information provided for each purchase order.

  • Order ID *: Unique identifier for the sale.

  • Order date *: Date when the sale occurred.

  • Product ID *: Unique identifier for the product.

  • Product name: Name of the product.

  • Quantity *: Number of units sold.

  • Departure facility *: Location from where the product was shipped.

  • Arrival facility: Name of the receiving location, when B2B. This facility will show up in your Facilities overview.

  • Arrival name: Name of the receiving location, when B2C. This address will not show up in your Facilities overview. This is an optional field when dealing with confidentiality.

  • Arrival address: Address of the receiving location of the Arrival name. Preferably as specific as possible, but you can also fill in a city or postcode (+country).

  • Transport category: Classification of your sales orders based on the mode of transport used. Think about: international shipments by air, international shipments by sea, and deliveries within Europe.

  • Status: Status of the information provided for each sales orders.

  • ID *: Unique identifier for the product.

  • Product: Name of the product.

  • Category: Product bucket or category

  • Relations: Whether the product is using primary data (source) or proxy data (proxy).

  • Mass: The mass of a single unit in kg.

  • Packaging: A standardized Packaging ID.

  • BOM: Shows whether BOM data is uploaded.

  • Usage (if in scope): Shows whether Usage data is uploaded.

  • End of Life (if in scope): Shows whether EOL data is uploaded.

  • Product ID *: The Product ID in which the Materials appear.

  • Component: The name of the component in which the material appears. Example: "Button".

  • Name: Material name. Be as specific as possible; add characteristics of a material to be able differentiate an impact reference match later. Example: "woven cotton textile, organic".

  • Amount: Amount of material, unit defined in next column.

  • Unit: Measurement type, e.g. grams, m2.

  • Supplier: If the material has a specific supplier that is different from the supplier of the associated Product ID, the name of the material supplier can be added here.

  • Supplier address: The address of the material supplier.

  • Level *: The level layer of the material

  • Product ID *: Material name. Be as specific as possible; add characteristics of a material to be able differentiate an impact reference match later. Example: "woven cotton textile, organic".

  • Name *: Name of material identified from uploaded BOM.

  • Quantity *: Number of units ordered.

  • Unit *: Measurement type, e.g. grams, m2.

  • Supplier name: Name of supplier.

  • Supplier address: Address of supplier.

Products: Usage (TBD)

Products: End of Life (TBD)

  • Level *: Use this level structure to add multiple layers in the product packaging.

  • Packaging ID *: The Product ID in which the Materials appear.

  • Name *: Material name. Be as specific as possible; add characteristics of a material to be able differentiate an impact reference match later.

  • Quantity *: Amount of material, unit defined in next column.

  • Unit *: Measurement type, e.g. grams, m2.

  • Supplier: Name of supplier.

  • Supplier address: Address of supplier.

  • Facility name *: Name of relevant facility

  • Address: Address of relevant facility. Be as specific as possible (e.g. Street+No, Postcode, City, Country)

  • Category: Facility category, determined by you.

  • Published: Determines if a unique link is generated to facility supplier data collection.

  • Type: A standardized facility type which determines the GHG impact category (more info here).

  • Facility name *: Name of relevant facility

  • Start date *: Start of Utilities contract date

  • End date *: End of Utilities contract date

  • Dataset *: Type of consumption activity (more info here)

  • Capital owned *: Determines whether the consumption source is Owned (e.g. solar panels, etc).

  • Quantity *: Amount of consumption

  • Unit *: Unit of consumption amount (e.g. kWh, m3, etc)

  • Data input: "total consumption" or "estimate per product", allows scaling up per product

  • Percentage: When supplier produces for multiple clients, use to scale consumption amount

  • Facility name: Name of relevant facility of expenditure

  • Name: Name of expenditure

  • Quantity: Amount of expenditure

  • Unit: Unit of expenditure amount (EUR, $, etc)

  • Capital good: Determines whether expenditure is a Capital Good (Yes/No)

Facilities: Consumables (TBD)

No bulk upload template is available yet.

Facilities: Residual Waste (TBD)

No bulk upload template is available yet.

  • Facility name: Name of relevant facility

  • Material name: Name of packaging material

  • Mass (kg): Amount of logistics packaging

  • Supplier: Logistics packaging supplier name

  • Supplier address: Logistics packaging supplier address

More info on how to create transport legs and complex routes here.

  • Order ID *: Relevant order ID

  • Departure address *: Departure address of transport leg

  • Arrival address *: Arrival address of transport leg

  • Mode of transport *: Mode of transport (e.g. Containership, Truck, etc)

More info on how to create transport legs and complex routes here.

  • Order ID *: Relevant order ID

  • Departure address *: Departure address of transport leg

  • Arrival address *: Arrival address of transport leg

  • Mode of transport *: Mode of transport (e.g. Containership, Truck, etc)

  • Employee ID: Allows to add an employee ID

  • Year*: Year in which commute took place

  • Country*: Country in which commute took place

  • Travel mode*: Travel mode of commute (e.g. Bike, Diesel car, etc)

  • Total distance (km per year)*: Total distance of commute in year of commute

  • Owned/leased*: Determines if travel mode is owned/leased (Yes/No)

  • Travel ID: Allows to add an identifier to the relevant trip

  • Date*: Date of relevant trip

  • Departure*: Departure location of trip (e.g. Amsterdam, Paris, etc).

  • Arrival*: Arrival location of trip (e.g. Amsterdam, Paris, etc).

  • Travel mode*: Travel mode of trip

  • Total distance (km per year)*: Total distance of trip

  • Owned/leased*: Determines if travel mode is owned/leased (Yes/No)

Did this answer your question?