Minimum required fields for data import

To properly process and manage data that is imported in Supply Chain Intelligence Suite, a minimal set of fields is required in the CSV files.

When objects are uploaded, make sure that you upload objects so that the data dependencies for an object exist before that object is uploaded. For example, because the products have a reference to a catalog, the catalog data must be uploaded first and then the product data can be uploaded after the catalog upload is completed.

Use the following upload order:
  1. Contacts
  2. Organizations
  3. Locations
  4. Catalogs
  5. Products
  6. Orders
  7. Order lines
Note: Emissions are associated with the order line based on the data in the system at the time that the order line is uploaded. If required objects are missing when an order line is uploaded, the product carbon footprint (PCF) might not be properly computed. If this issue occurs, delete the order line and upload it again after all the required objects are ingested.

Before you prepare CSV files for import, review the following minimum required fields.

Contact

Defines contacts in your supplier organization. For more information, see Contact.

Field Description
contactIdentifier Unique identifier for the contact.
firstName Given name.
lastName Surname.
emailAddress Email address.
Organization
Defines your supplier's organization. For more information, see Organization.
Field Description
organizationIdentifier A unique identifier for the organization
orgType An indication of the type of organization.
Note: The value must be SUPPLIER.
name The descriptive name of the organization.
primaryContact.contactIdentifier The ID for the primary contact for the organization.
Source location
Defines your supplier's location that ships to your organization. For more information, see Location.
Field Description
locationIdentifier A unique identifier for a location that your supplier owns.
LocationName The descriptive name for the location.
country The value must be the 3-digit country code of one of the 188 countries that Supply Chain Intelligence Suite supports.
Destination location
Defines your organization's location that your supplier ships to. For more information, see Location.
Field Description
locationIdentifier A unique identifier for a location that your organization owns.
LocationName The descriptive name for the location.
secondaryIdentifier A unique identifier that must match a location ID in Envizi™ ESG Suite.
Catalog
Defines the categories of products that your organization receives from suppliers. Controls the factor code that is used for a product. Each category has a factor code. For more information, see Product catalog.
Field Description
name

The descriptive name of the catalog code.
levelType

The type of level. It is used for filtering and categorization.

Note: The value must be CATEGORY.
code A unique identifier for the category.
catalogType

The category type.

Note: The value must be ITEM.
emissionsFactorGroup.factorCode

A classification code that identifies the emission factor. For the list of valid values, see

Factor codes.
Product
Defines a product that is shipped to your organization. For more information, see Product.
Field Description
partNumber

A unique identifier for the product.
value

The value or price of the product or material.
valueCurrency

The currency designation in ISO 4217 format.

Note: For use with the default EORA factor data, the value must be in USD.
name The descriptive name of the product.
productType

The type of product. The field is used for categorization or filtering.

Note: The value must be ITEM.
category.code

A unique identifier for the product category.

Note: The value must match an existing code field in a catalog object.
Order
Defines the order of goods that are inbound to your organization from a supplier. For more information, see Order.
Field Description
orderType Specifies whether the order is inbound or outbound.
Note: The value must be INBOUND.
orderIdentifier The unique identifier for an order.
vendor.organizationIdentifier The unique ID for the supplier.
Note: The value must match the organizationIdentifier of a SUPPLIER organization object.
Order line
Defines a shipment of one product that is inbound to your organization from a supplier for an order. For more information, see Order line.
Field Description
orderLineNumber Sequential number of the order line.
order.orderIdentifier A unique identifier for an order that the order line is fulfilling.
Note: The value must match the orderIdentifier of an order object.
order.orderType The value must be INBOUND.
product.partNumber The unique identifier of the product in the order line.
Note: The value must match the partNumber of a product object.
quantity

The quantity of products or materials in the order line.
quantityUnits The units of measure from the source system. Use standard UOM or ISO format. For example, EA.
plannedShipDate The date and time that fulfillment expects to ship the order line.
The following format is expected for the date and time: 
YYYY-MM-DDThh:mm:ssZ
Where
YYYY
The four-digit year.
MM
The two-digit month. For example, 01 is January.
DD
The two-digit day of the month. Valid values are 01 through 31.
T
Separator
hh
The two-digit hour. Valid values are 00 through 23. Do not include AMor PM.
mm
The two-digit minute. Valid values are 00 through 59.
ss
The two-digit second. Valid values are 00 through 59.
Z
The designator for the time zone. Valid values can be Z or +0000.

For example, 2023-06-28T14:30:36+0000.
shipFromInstructionLocation.locationIdentifier The location that the order line is being shipped from.
Note: The value must match the locationIdentifier of a SUPPLIER location object.
shipToLocation.locationIdentifier The location that the order line is being shipped to.
Note: The value must match the locationIdentifier of a location object that is defined for one of your organization's locations.
value Total value of products or materials in the order line. For example, 10850.
valueCurrency Currency designation in ISO 4217 format. For example, USD.