Insights

The table below list the data entities and columns used by Insights for the Inventory Visibility, Network Map, Inventory Insights, and Rebalance Recommendations features. See the table below on how each feature in Insights uses the data entities.

Note

How to read the table:

Required – The column name is mandatory in your dataset and you must populate the column name with values.
Optional – The column name is optional. For enhanced feature output, it is recommended to add the column name with values.
Not required – Data entity not required.

Data entity	Column	Is the column used for Inventory visibility?	Is the column used for Network map?	Is the column used for Inventory Insights?	Is the column used for Rebalance recommendations?	Is the column used for Lead time Insights?
site	id	Required	Required	Required	Required	Required
	description	Required	Required	Required	Required	Optional
	geo_id	Required – This field is required for filters to group sites by geographical groups such as region/country/state and so on.	Required – This field is required for filters to group sites by geographical groups such as region/country/state and so on.	Required – This field is required for filters to group sites by geographical groups such as region/country/state and so on.	Required	Required – This field is required for filters to group sites by geographical groups such as region/country/state and so on.
	site_type	Optional – Populating this column will display the site type on the inventory visibility page such as RDC, CDC, manufacturing site and so on.	Optional	Optional	Optional	Optional
	company_id	Optional	Optional	Optional	Optional	Column name company_id should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	latitude	Optional	Required – This field is used to view the site on the Network Map page.	Optional	Optional	Column name latitude should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	longitude	Optional	Required – This field is used to view the site on the Network Map page.	Optional	Optional	Column name longitude should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	is_active	Required – Identifies if the site needs to be considered for Insights computation. Note: If you want a site to be excluded from the Insights computation, make sure you set the column value to False. If the column is blank or null, the site is considered active.	Required – Identifies if the site needs to be considered for Insights computation. Note: If you want a site to be excluded from the Insights computation, make sure you set the column value to False. If the column is blank or null, the site is considered active.	Required – Identifies if the site needs to be considered for Insights computation. Note: If you want a site to be excluded from the Insights computation, make sure you set the column value to False. If the column is blank or null, the site is considered active.	Required – Identifies if the site needs to be considered for Insights computation. Note: If you want a site to be excluded from the Insights computation, make sure you set the column value to False. If the column is blank or null, the site is considered active.	Required – Identifies if the site needs to be considered for Insights computation. Note: If you want a site to be excluded from the Insights computation, make sure you set the column value to False. If the column is blank or null, the site is considered active.
	open_date	Optional	Optional	Optional	Optional	Column name open_date should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	end_date	Optional	Optional	Optional	Optional	Column name end_date should be available in your dataset. Value for the column name is not required for Lead Time Insights.
transportation_lane	id	Not required	Not required	Not required	Required	Required
	from_site_id	Not required	Not required	Not required	Required	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.
	to_site_id	Not required	Not required	Not required	Required	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.
	product_group_id	Not required	Not required	Not required	Required	Column name product_group_id should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	transit_time	Not required	Not required	Not required	Required	Column name transit_time should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	time_uom	Not required	Not required	Not required	Required – Supports day or days as units.	Column name time_uom should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	distance	Not required	Not required	Not required	Required	Column name distance should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	distance_uom	Not required	Not required	Not required	Required – Supports mile(s), km(s), or Kilometer(s) as units.	Column name distance_uom should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	eff_start_date	Not required	Not required	Not required	Optional	Column name eff_start_date should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	eff_end_date	Not required	Not required	Not required	Optional	Column name eff_end_date should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	product_id	Not required	Not required	Not required	Optional – Either product_id or product-group-id is required. When the lane is linked with a product, this field is mandatory.	Column name product_id should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	emissions_per_unit	Not required	Not required	Not required	Optional	Column name emissions_per_unit should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	emissions_per_weight	Not required	Not required	Not required	Optional	Column name emissions_per_unit should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	company_id	Not required	Not required	Not required	Optional	Column name company_id should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	from_geo_id	Not required	Not required	Not required	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.
	to_geo_id	Not required	Not required	Not required	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.
	carrier_tpartner_id	Not required	Not required	Not required	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.
	service_type	Not required	Not required	Not required	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.
	trans_mode	Not required	Not required	Not required	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.
	cost_per_unit	Not required	Not required	Not required	Optional – You can view the shipping cost unit by lane during rebalance recommendations.	Column name cost_per_unit should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	cost_currency	Not required	Not required	Not required	Optional – You can view the shipping cost unit by lane during rebalance recommendations.	Column name cost_currency should be available in your dataset. Value for the column name is not required for Lead Time Insights.
product	id	Required	Required	Required	Required	Required
	description	Required	Required	Required	Required	Required
	product_group_id	Required – Using this field, you can group products by product category such dairy, clothes, and so on.	Required – Using this field, you can group products by product category such dairy, clothes, and so on.	Required – Using this field, you can group products by product category such dairy, clothes, and so on.	Required	Required – Using this field, you can group products by product category such dairy, clothes, and so on.
	is_deleted	Required – Identifies if the product needs to be considered for Insights computation. Note: If you want the product to be excluded from the Insights computation, make sure you set the column value to True and set to False to include this product for Insights computation. If the column is left blank or null, the system considers the default value of True.	Required – Identifies if the product needs to be considered for Insights computation. Note: If you want the product to be excluded from the Insights computation, make sure you set the column value to True and set to False to include this product for Insights computation. If the column is left blank or null, the system considers the default value of True.	Required – Identifies if the product needs to be considered for Insights computation. Note: If you want the product to be excluded from the Insights computation, make sure you set the column value to True and set to False to include this product for Insights computation. If the column is left blank or null, the system considers the default value of True.	Required – Identifies if the product needs to be considered for Insights computation. Note: If you want the product to be excluded from the Insights computation, make sure you set the column value to True and set to False to include this product for Insights computation. If the column is left blank or null, the system considers the default value of True.	Required – Identifies if the product needs to be considered for Insights computation. Note: If you want the product to be excluded from the Insights computation, make sure you set the column value to True and set to False to include this product for Insights computation. If the column is left blank or null, the system considers the default value of True.
	product_type	Optional – This field is required to support multiple product levels such as planning and fulfillment product.	Optional – This field is required to support multiple product levels such as planning and fulfillment product.	Optional – This field is required to support multiple product levels such as planning and fulfillment product.	Optional – This field is required to support multiple product levels such as planning and fulfillment product.	Column name product_type should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	parent_product_id	Optional – This field is required to support multiple product levels such as planning and fulfillment product.	Optional – This field is required to support multiple product levels such as planning and fulfillment product.	Optional – This field is required to support multiple product levels such as planning and fulfillment product.	Optional – This field is required to support multiple product levels such as planning and fulfillment product.	Column name parent_product_id should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	base_uom	Optional – This field is required for Insights to calculate the default base uom for a given product.	Optional – This field is required for Insights to calculate the default base uom for a given product.	Optional – This field is required for Insights to calculate the default base uom for a given product.	Optional – This field is required for Insights to calculate the default base uom for a given product.	Column name base_uom should be available in your dataset. Value for the column name is not required for Lead Time Insights.
product_hierarchy	id	Required	Required	Required	Required	Required
	description	Required – Using this field, you can filter groups by product category such dairy, clothes, and so on.	Required – Using this field, you can filter groups by product category such dairy, clothes, and so on.	Required – Using this field, you can filter groups by product category such dairy, clothes, and so on.	Required – Using this field, you can filter groups by product category such dairy, clothes, and so on.	Required – Using this field, you can filter groups by product category such dairy, clothes, and so on.
	parent_product_group_id	Optional – This field is used by filters to support multiple product hierarchy category such as dairy, frozen diary products, fresh diary and so on.	Optional – This field is used by filters to support multiple product hierarchy category such as dairy, frozen diary products, fresh diary and so on.	Optional – This field is used by filters to support multiple product hierarchy category such as dairy, frozen diary products, fresh diary and so on.	Column name parent_product_group_id should be available in your dataset. Value for the column name is not required for Rebalance Recommendations.	Optional – This field is used by filters to support multiple product hierarchy category such as dairy, frozen diary products, fresh diary and so on.
product_uom Note This data entity is optional. For product uom conversions, data is required in either product-uom, uom_conversion, or Insights.	product_uom_id	Required – This field is required to perform the product uom conversion.	Required – This field is required to perform the product uom conversion.	Required – This field is required to perform the product uom conversion.	Required – This field is required to perform the product uom conversion.	Not required
	product_id	Required	Required	Required	Required	Not required
	uom	Required – This field is required for conversion to units.	Required – This field is required for conversion to units.	Required – This field is required for conversion to units.	Required – This field is required for conversion to units.	Not required
	description	Optional	Optional	Optional	Optional	Not required
	quantity	Required – This field contains the conversion factor.	Required – This field contains the conversion factor.	Required – This field contains the conversion factor.	Required – This field contains the conversion factor.	Not required
	quantity_uom	Required – This field is required for conversion from units.	Required – This field is required for conversion from units.	Required – This field is required for conversion from units.	Required – This field is required for conversion from units.	Not required
	eff_start_date	Optional	Optional	Optional	Optional	Not required
	eff_end_date	Optional	Optional	Optional	Optional	Not required
	company_id	Optional	Optional	Optional	Optional	Not required
uom_conversion Note This data entity is optional. For product uom conversions, data is required in either product-uom, uom_conversion, or Insights.	uom	Required – This field is required for conversion from units.	Required – This field is required for conversion from units.	Required – This field is required for conversion from units.	Required – This field is required for conversion from units.	Not required
	company_id	Optional	Optional	Optional	Optional	Not required
	conversion_uom_id	Required – This field is required for conversion to units.	Required – This field is required for conversion to units.	Required – This field is required for conversion to units.	Required – This field is required for conversion to units.	Not required
	conversion_factor	Required – This field contains the conversion factor.	Required – This field contains the conversion factor.	Required – This field contains the conversion factor.	Required – This field contains the conversion factor.	Not required
geography	id	Required	Required	Required	Required	Required
	description	Required	Required	Required	Required	Required
	parent_geo_id	Optional – This field is used to support multiple location hierarchy such as USA, USA-East, and so on.	Required – This field is used to support multiple location hierarchy such as USA, USA-East, and so on.	Optional	Optional	Required – This field is used to support multiple location hierarchy such as USA, USA-East, and so on.
trading_partner	id	Required	Required	Required	Required	Required
	description	Optional	Optional	Optional	Optional	Required
	country	Optional	Optional	Optional	Optional	Optional
	eff_start_date	Required – You must enter a value for eff_start_date and eff_end_date. If you don't have a value, enter `1900-01-01 00:00:00` for eff_start_date, and `9999-12-31 23:59:59` for eff_end_date.	Required – You must enter a value for eff_start_date and eff_end_date. If you don't have a value, enter `1900-01-01 00:00:00` for eff_start_date, and `9999-12-31 23:59:59` for eff_end_date.	Required – You must enter a value for eff_start_date and eff_end_date. If you don't have a value, enter `1900-01-01 00:00:00` for eff_start_date, and `9999-12-31 23:59:59` for eff_end_date.	Required – You must enter a value for eff_start_date and eff_end_date. If you don't have a value, enter `1900-01-01 00:00:00` for eff_start_date, and `9999-12-31 23:59:59` for eff_end_date.	Column name eff_start_date should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	eff_end_date	Required – You must enter a value for eff_start_date and eff_end_date. If you don't have a value, enter `1900-01-01 00:00:00` for eff_start_date, and `9999-12-31 23:59:59` for eff_end_date.	Required – You must enter a value for eff_start_date and eff_end_date. If you don't have a value, enter `1900-01-01 00:00:00` for eff_start_date, and `9999-12-31 23:59:59` for eff_end_date.	Required – You must enter a value for eff_start_date and eff_end_date. If you don't have a value, enter `1900-01-01 00:00:00` for eff_start_date, and `9999-12-31 23:59:59` for eff_end_date.	Required – You must enter a value for eff_start_date and eff_end_date. If you don't have a value, enter `1900-01-01 00:00:00` for eff_start_date, and `9999-12-31 23:59:59` for eff_end_date.	Column name eff_end_date should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	time_zone	Optional	Optional	Optional	Optional	Column name time_zone should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	is_active	Optional	Optional	Optional	Optional	Column name is_active should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	tpartner_type	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Column name tpartner_type should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	geo_id	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Column name geo_id should be available in your dataset. Value for the column name is not required for Lead Time Insights.
inbound_order Note This data entity is required for Lead Time Insights but optional for Inventory Visibility, Network Map, Inventory Insights, and Rebalance Recommendations.	id	Not required	Not required	Not required	Not required	Required
	order_type	Not required	Not required	Not required	Not required	Optional – Data can be used by inbound order line.
	order_status	Not required	Not required	Not required	Not required	Optional
	to_site_id	Not required	Not required	Not required	Not required	Column name site_id should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	submitted_date	Not required	Not required	Not required	Not required	Required
	tpartner_id	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.
inbound_order_line	id	Required	Required	Required	Required	Required
	order_id	Required	Required	Required	Required	Required
	order_type	Required	Required	Required	Required	Optional
	status	Required	Required	Required	Required	Optional
	product_id	Required	Required	Required	Required	Required
	to_site_id	Required	Required	Required	Required	Required
	from_site_id	Required	Required	Required	Required	Required
	quantity_submitted	Required – One quantity field should be set.	Required – One quantity field should be set.	Required – One quantity field should be set.	Required – One quantity field should be set.	Required – One quantity field should be set.
	quantity_confirmed	Optional – One quantity field should be set.	Optional – One quantity field should be set.	Optional – One quantity field should be set.	Optional – One quantity field should be set.	Optional – One quantity field should be set.
	quantity_received	Optional – This field should be blank for open orders.	Optional – This field should be blank for open orders.	Optional – This field should be blank for open orders.	Optional – This field should be blank for open orders.	Optional – This field should be blank for open orders.
	quantity_uom	Required – This field is required to determine the unit for quantity fields.	Required – This field is required to determine the unit for quantity fields.	Required – This field is required to determine the unit for quantity fields.	Required – This field is required to determine the unit for quantity fields.	Column name quantity_uom should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	expected_delivery_date	Required	Required	Required	Required	Required
	submitted_date	Column name submitted_date should be available in your dataset. Value for the column name is not required for Inventory visibility.	Column name submitted_date should be available in your dataset. Value for the column name is not required for Network map.	Column name submitted_date should be available in your dataset. Value for the column name is not required for Inventory Insights.	Column name submitted_date should be available in your dataset. Value for the column name is not required for Rebalance Recommendations.	Required
	incoterm	Column name incoterm should be available in your dataset. Value for the column name is not required for Inventory visibility.	Column name incoterm should be available in your dataset. Value for the column name is not required for Network map.	Column name incoterm should be available in your dataset. Value for the column name is not required for Inventory Insights.	Column name incoterm should be available in your dataset. Value for the column name is not required for Rebalance Recommendations.	Optional
	product_group_id	Column name product_group_id should be available in your dataset. Value for the column name is not required for Inventory visibility.	Column name product_group_id should be available in your dataset. Value for the column name is not required for Network map.	Column name product_group_id should be available in your dataset. Value for the column name is not required for Inventory Insights.	Column name product_group_id should be available in your dataset. Value for the column name is not required for Rebalance Recommendations.	Optional
	company_id	Column name company_id should be available in your dataset. Value for the column name is not required for Inventory Insights.	Column name company_id should be available in your dataset. Value for the column name is not required for Network map.	Column name company_id should be available in your dataset. Value for the column name is not required for Inventory Insights.	Column name company_id should be available in your dataset. Value for the column name is not required for Rebalance Recommendations.	Optional
	tpartner_id	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.
	reservation_id	Optional – This field is used to determine the connection between order line and order line schedule. For example, 1001 - A, where 1001 is the order_id and A is the order_line_id in the inbound_order_line_schedule table.	Optional – This field is used to determine the connection between order line and order line schedule. For example, 1001 - A, where 1001 is the order_id and A is the order_line_id in the inbound_order_line_schedule table.	Optional – This field is used to determine the connection between order line and order line schedule. For example, 1001 - A, where 1001 is the order_id and A is the order_line_id in the inbound_order_line_schedule table.	Optional – This field is used to determine the connection between order line and order line schedule. For example, 1001 - A, where 1001 is the order_id and A is the order_line_id in the inbound_order_line_schedule table.	Column name reservation_id should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	order_receive_date	Column name order_receive_date should be available in your dataset. Value for the column name is not required for Inventory visibility.	Column name order_receive_date should be available in your dataset. Value for the column name is not required for Network map.	Column name order_receive_date should be available in your dataset. Value for the column name is not required for Inventory Insights.	Column name order_receive_date should be available in your dataset. Value for the column name is not required for Rebalance Recommendations.	Optional
inbound_order_line_schedule Note This data entity is required for Lead Time Insights but optional for Inventory Visibility, Network Map, Inventory Insights, and Rebalance Recommendations. When data is not ingested for this data entity, Insights will use the supply data from inbound_order_line data entity. For custom configurations, contact Get support for AWS Supply Chain.	id	Required	Required	Required	Required	Required
	order_id	Required – This field is required to link back to an order line along with the order_line_id.	Required – This field is required to link back to an order line along with the order_line_id.	Required – This field is required to link back to an order line along with the order_line_id.	Required – This field is required to link back to an order line along with the order_line_id.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.
	order_line_id	Required – This field is required to link back to an order line along with order_id.	Required – This field is required to link back to an order line along with order_id.	Required – This field is required to link back to an order line along with order_id.	Required – This field is required to link back to an order line along with order_id.	Column name order_line_id should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	company_id	Column name company_id should be available in your dataset. Value for the column name is not required for Lead Time Insights.	Column name company_id should be available in your dataset. Value for the column name is not required for Lead Time Insights.	Column name company_id should be available in your dataset. Value for the column name is not required for Lead Time Insights.	Column name company_id should be available in your dataset. Value for the column name is not required for Lead Time Insights.	Column name company_id should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	product_id	Required	Required	Required	Required	Required
	expected_delivery_date	Optional – delivery_date or expected_delivery date must be provided.	Optional – delivery_date or expected_delivery date must be provided.	Optional – delivery_date or expected_delivery date must be provided.	Optional – delivery_date or expected_delivery date must be provided.	Optional
	delivery_date	Optional – delivery_date or expected_delivery date must be provided.	Optional – delivery_date or expected_delivery date must be provided.	Optional – delivery_date or expected_delivery date must be provided.	Optional – delivery_date or expected_delivery date must be provided.	Column name delivery_date should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	ship_date	Optional – Date when the order was shipped.	Optional – Date when the order was shipped.	Optional – Date when the order was shipped.	Optional – Date when the order was shipped.	Column name ship_date should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	quantity_submitted	Required – One quantity field should be set. This field uses the uom set at the line level.	Required – One quantity field should be set. This field uses the uom set at the line level.	Required – One quantity field should be set. This field uses the uom set at the line level.	Required – One quantity field should be set. This field uses the uom set at the line level.	Column name quantity_submitted should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	quantity_confirmed	Required – One quantity field should be set. This field uses the uom set at the line level.	Required – One quantity field should be set. This field uses the uom set at the line level.	Required – One quantity field should be set. This field uses the uom set at the line level.	Required – One quantity field should be set. This field uses the uom set at the line level.	Column name quantity_confirmed should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	quantity_received	Required – One quantity field should be set. This field uses the uom set at the line level.	Required – One quantity field should be set. This field uses the uom set at the line level.	Required – One quantity field should be set. This field uses the uom set at the line level.	Required – One quantity field should be set. This field uses the uom set at the line level.	Column name quantity_received should be available in your dataset. Value for the column name is not required for Lead Time Insights.
shipment	id	Required	Required	Required	Required	Optional
	order_id	Required – This field is required to calculate the in-transit and on-order values for projected inventory visibility.	Required	Required – This field is required to calculate the in-transit and on-order values for projected inventory visibility.	Required – This field is required to calculate the in-transit and on-order values for projected inventory visibility.	Required
	order_line_id	Required – This field is required to calculate the in-transit and on-order values for projected inventory visibility.	Required	Required – This field is required to calculate the in-transit and on-order values for projected inventory visibility.	Required – This field is required to calculate the in-transit and on-order values for projected inventory visibility.	Required
	product_id	Required	Required	Required	Required	Required
	ship_to_site_id	Optional – Derived from inbound order line.	Optional – Derived from inbound order line.	Optional – Derived from inbound order line.	Optional – Derived from inbound order line.	Required
	actual_delivery_date	Optional – planned_delivery_date or actual_delivery_date must be provided.	Optional – planned_delivery_date or actual_delivery_date must be provided.	Optional – planned_delivery_date or actual_delivery_date must be provided.	Optional – planned_delivery_date or actual_delivery_date must be provided.	Required
	units_shipped	Optional – Derived from inbound order line.	Optional – Derived from inbound order line.	Optional – Derived from inbound order line.	Optional – Derived from inbound order line.	Optional – Derived from inbound order line.
	uom	Optional – This field is used to determine the unit for quantity fields.	Optional – This field is used to determine the unit for quantity fields.	Optional – This field is used to determine the unit for quantity fields.	Optional – This field is used to determine the unit for quantity fields.	Optional – This field is used to determine the unit for quantity fields.
	planned_ship_date	Optional – planned_ship_date or actual_ship_date must be provided.	Optional – planned_ship_date or actual_ship_date must be provided.	Optional – planned_ship_date or actual_ship_date must be provided.	Optional – planned_ship_date or actual_ship_date must be provided.	Column name planned_ship_date should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	actual_ship_date	Optional – planned_ship_date or actual_ship_date must be provided.	Optional – planned_ship_date or actual_ship_date must be provided.	Optional – planned_ship_date or actual_ship_date must be provided.	Optional – planned_ship_date or actual_ship_date must be provided.	Column name actual_ship_date should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	planned_delivery_date	Optional – planned_delivery_date or actual_delivery_date must be provided.	Optional – planned_delivery_date or actual_delivery_date must be provided.	Optional – planned_delivery_date or actual_delivery_date must be provided.	Optional – planned_delivery_date or actual_delivery_date must be provided.	Column name planned_delivery_date should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	ship_from_site_id	Optional – Derived from inbound order line.	Optional – Derived from inbound order line.	Optional – Derived from inbound order line.	Optional – Derived from inbound order line.	Optional
	supplier_tpartner_id	Column name supplier_tpartner_id should be available in your dataset. Value for the column name is not required for Inventory visibility.	Column name supplier_tpartner_id should be available in your dataset. Value for the column name is not required for Network map.	Column name supplier_tpartner_id should be available in your dataset. Value for the column name is not required for Inventory Insights.	Column name supplier_tpartner_id should be available in your dataset. Value for the column name is not required for Rebalance Recommendations.	Optional
	transportation_mode	Column name transportation_mode should be available in your dataset. Value for the column name is not required for Inventory visibility.	Column name transportation_mode should be available in your dataset. Value for the column name is not required for Network map.	Column name transportation_mode should be available in your dataset. Value for the column name is not required for Inventory Insights.	Column name transportation_mode should be available in your dataset. Value for the column name is not required for Rebalance Recommendations.	Optional
	ship_from_site_address_country	Column name ship_from_site_address_country should be available in your dataset. Value for the column name is not required for Inventory visibility.	Column name ship_from_site_address_country should be available in your dataset. Value for the column name is not required for Network map.	Column name ship_from_site_address_country should be available in your dataset. Value for the column name is not required for Inventory Insights.	Column name ship_from_site_address_country should be available in your dataset. Value for the column name is not required for Rebalance Recommendations.	Optional
	ship_to_site_address_country	Column name ship_to_site_address_country should be available in your dataset. Value for the column name is not required for Inventory visibility.	Column name ship_to_site_address_country should be available in your dataset. Value for the column name is not required for Network map.	Column name ship_to_site_address_country should be available in your dataset. Value for the column name is not required for Inventory Insights.	Column name ship_to_site_address_country should be available in your dataset. Value for the column name is not required for Rebalance Recommendations.	Optional
	carrier_id	Column name carrier_id should be available in your dataset. Value for the column name is not required for Inventory visibility.	Column name carrier_id should be available in your dataset. Value for the column name is not required for Network map.	Column name carrier_id should be available in your dataset. Value for the column name is not required for Inventory Insights.	Column name carrier_id should be available in your dataset. Value for the column name is not required for Rebalance Recommendations.	Optional
	package_id	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.
inv_policy	id	Required	Required	Required	Required	Required
	site_id	Required	Required	Required	Required	Required
	product_id	Required	Required	Required	Required	Required
	min_safety_stock	Required	Required	Required	Required	Required
	max_safety_stock	Required	Required	Required	Required	Required
	qty_uom	Optional – This field is used to determine the UOM for inventory policy.	Optional – This field is used to determine the UOM for inventory policy.	Optional – This field is used to determine the UOM for inventory policy.	Optional – This field is used to determine the UOM for inventory policy.	Optional – This field is used to determine the UOM for inventory policy.
	min_doc_limit	Optional – This field is required if you want to see the days of cover.	Optional – This field is required if you want to see the days of cover.	Optional – This field is required if you want to see the days of cover.	Optional – This field is required if you want to see the days of cover.	Column name min_doc_limit should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	max_doc_limit	Optional – This field is required if you want to see the days of cover.	Optional – This field is required if you want to see the days of cover.	Optional – This field is required if you want to see the days of cover.	Optional – This field is required if you want to see the days of cover.	Column name max_doc_limit should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	eff_start_date	Required – You must enter a value for eff_start_date and eff_end_date. If you don't have a value, enter `1900-01-01 00:00:00` for eff_start_date, and `9999-12-31 23:59:59` for eff_end_date.	Required – You must enter a value for eff_start_date and eff_end_date. If you don't have a value, enter `1900-01-01 00:00:00` for eff_start_date, and `9999-12-31 23:59:59` for eff_end_date.	Required – You must enter a value for eff_start_date and eff_end_date. If you don't have a value, enter `1900-01-01 00:00:00` for eff_start_date, and `9999-12-31 23:59:59` for eff_end_date.	Required – You must enter a value for eff_start_date and eff_end_date. If you don't have a value, enter `1900-01-01 00:00:00` for eff_start_date, and `9999-12-31 23:59:59` for eff_end_date.	Required – You must enter a value for eff_start_date and eff_end_date. If you don't have a value, enter `1900-01-01 00:00:00` for eff_start_date, and `9999-12-31 23:59:59` for eff_end_date.
	eff_end_date	Required – You must enter a value for eff_start_date and eff_end_date. If you don't have a value, enter `1900-01-01 00:00:00` for eff_start_date, and `9999-12-31 23:59:59` for eff_end_date.	Required – You must enter a value for eff_start_date and eff_end_date. If you don't have a value, enter `1900-01-01 00:00:00` for eff_start_date, and `9999-12-31 23:59:59` for eff_end_date.	Required – You must enter a value for eff_start_date and eff_end_date. If you don't have a value, enter `1900-01-01 00:00:00` for eff_start_date, and `9999-12-31 23:59:59` for eff_end_date.	Required – You must enter a value for eff_start_date and eff_end_date. If you don't have a value, enter `1900-01-01 00:00:00` for eff_start_date, and `9999-12-31 23:59:59` for eff_end_date.	Required – You must enter a value for eff_start_date and eff_end_date. If you don't have a value, enter `1900-01-01 00:00:00` for eff_start_date, and `9999-12-31 23:59:59` for eff_end_date.
	company_id	Optional	Optional	Optional	Optional	Optional
	ss_policy	Required – abs_level when there is no value.	Required – abs_level when there is no value.	Required – abs_level when there is no value.	Required – abs_level when there is no value.	Required – abs_level when there is no value.
	fallback_policy_1	Optional	Optional	Optional	Optional	Column name fallback_policy_1 should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	product_group_id	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.
	dest_geo_id	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.
	vendor_tpartner_id	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.
inv_level Note Enter the on-hand inventory at the beginning of the day.	snapshot_date	Required	Required	Required	Required	Required
	site_id	Required	Required	Required	Required	Required
	product_id	Required	Required	Required	Required	Required
	company_id	Optional	Optional	Optional	Optional	Optional
	on_hand_inventory	Required	Required	Required	Required	Required
	allocated_inventory	Optional	Optional	Optional	Optional	Column name allocated_inventory should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	quantity_uom	Optional – This field is used to determine the quantity UOM for inventory records.	Optional – This field is used to determine the quantity UOM for inventory records.	Optional – This field is used to determine the quantity UOM for inventory records.	Optional – This field is used to determine the quantity UOM for inventory records.	Column name quantity_uom should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	inv_condition	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.
	lot_number	Required – Insights expects one inventory level record per site and product for the given snapshot date. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required – Insights expects one inventory level record per site and product for the given snapshot date. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required – Insights expects one inventory level record per site and product for the given snapshot date. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required – Insights expects one inventory level record per site and product for the given snapshot date. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required – Insights expects one inventory level record per site and product for the given snapshot date. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.
forecast	site_id	Required	Required	Required	Required	Not required
	product_id	Required	Required	Required	Required	Not required
	mean	Required	Required	Required	Required	Not required
	forecast_start_dttm Note Make sure the forecast_start_dttm and forecast_end_dttm are set at different dates when forecast is set at a daily interval. The forecast_end_dttm must be set at the explicit end of the date range.	Required	Required	Required	Required	Not required
	forecast_end_dttm	Required	Required	Required	Required	Not required
	quantity_uom	Optional – This field is used to determine the quantity UOM for forecast.	Optional – This field is used to determine the quantity UOM for forecast.	Optional – This field is used to determine the quantity UOM for forecast.	Optional – This field is used to determine the quantity UOM for forecast.	Column name quantity_uom should be available in your dataset. Value for the column name is not required for Lead Time Insights.
	snapshot_date	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Not required
	region_id	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Not required
	product_group_id	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.	Not required
vendor_lead_time	company_id	Not required	Not required	Not required	Not required	Optional
	vendor_tpartner_id	Not required	Not required	Not required	Not required	Required
	product_id	Not required	Not required	Not required	Not required	Required
	site_id	Not required	Not required	Not required	Not required	Required
	planned_lead_time	Not required	Not required	Not required	Not required	Required
	eff_start_date	Not required	Not required	Not required	Not required	Optional
	eff_end_date	Not required	Not required	Not required	Not required	Optional
	product_group_id	Not required	Not required	Not required	Not required	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.
	region_id	Not required	Not required	Not required	Not required	Required. When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.
	source_site_id	Not required	Not required	Not required	Not required	Optional. Site from where the inbound shipment originated.
	trans_mode	Not required	Not required	Not required	Not required	Optional. Transportation mode used. For example, ship, truck, rail.
outbound_order_line Note This data entity is optional. Insights will use the demand data from the forecast entity. If you ingest information for the outbound_order_line entity, make sure the shipment information is also ingested for the outbound_shipment entity to gather the demand for the correct dates.	id	Required. Determines the outbound shipment ID.	Required. Determines the outbound shipment ID.	Required. Determines the outbound shipment ID.	Required. Determines the outbound shipment ID.	Not required
	cust_order_id	Required. Determines the outbound order ID.	Required. Determines the outbound order ID.	Required. Determines the outbound order ID.	Required. Determines the outbound order ID.	Not required
	product_id	Required. Determines the product ID shipped.	Required. Determines the product ID shipped.	Required. Determines the product ID shipped.	Required. Determines the product ID shipped.	Not required
	ship_from_site_id	Required. Determines the site from where the units are shipped.	Required. Determines the site from where the units are shipped.	Required. Determines the site from where the units are shipped.	Required. Determines the site from where the units are shipped.	Not required
	ship_to_site_id	Optional. Site where the products should be shipped.	Optional. Site where the products should be shipped.	Optional. Site where the products should be shipped.	Optional. Site where the products should be shipped.	Not required
	final_quantity_requested	Optional. Final quantity after all updates and cancellations.	Optional. Final quantity after all updates and cancellations.	Optional. Final quantity after all updates and cancellations.	Optional. Final quantity after all updates and cancellations.	Not required
	quantity_promised	Required. Quantity agreed to be delivered.	Required. Quantity agreed to be delivered.	Required. Quantity agreed to be delivered.	Required. Quantity agreed to be delivered.	Not required
	quantity_delivered	Optional. Actual quantity delivered.	Optional. Actual quantity delivered.	Optional. Actual quantity delivered.	Optional. Actual quantity delivered.	Not required
	status	Optional. Displays the status of the order line. For example, canceled, open, closed, and so on.	Optional. Displays the status of the order line. For example, canceled, open, closed, and so on.	Optional. Displays the status of the order line. For example, canceled, open, closed, and so on.	Optional. Displays the status of the order line. For example, canceled, open, closed, and so on.	Not required
	quantity_uom	Optional. Unit of measure for quantity. For example, eaches, cases.	Optional. Unit of measure for quantity. For example, eaches, cases.	Optional. Unit of measure for quantity. For example, eaches, cases.	Optional. Unit of measure for quantity. For example, eaches, cases.	Not required
	requested_delivery_date	Optional	Optional	Optional	Optional	Not required
	promised_delivery_date	Optional	Optional	Optional	Optional	Not required
outbound_shipment Note This data entity is optional. AWS Supply Chain will use the demand data from the outbound_order_line or forecast data entity.	id	Required. Determines the outbound shipment ID.	Required. Determines the outbound shipment ID.	Required. Determines the outbound shipment ID.	Required. Determines the outbound shipment ID.	Not required
	from_site_id	Required. Determines the site from where the units are shipped.	Required. Determines the site from where the units are shipped.	Required. Determines the site from where the units are shipped.	Required. Determines the site from where the units are shipped.	Not required
	product_id	Required. Determines the product ID of the product shipped.	Required. Determines the product ID of the product shipped.	Required. Determines the product ID of the product shipped.	Required. Determines the product ID of the product shipped.	Not required
	cust_order_id	Required. Determines the outbound order ID.	Required. Determines the outbound order ID.	Required. Determines the outbound order ID.	Required. Determines the outbound order ID.	Not required
	cust_order_line_id	Required. Determines the outbound order line ID.	Required. Determines the outbound order line ID.	Required. Determines the outbound order line ID.	Required. Determines the outbound order line ID.	Not required
	expected_ship_date	Required. Determines when the products exit the from_site.	Required. Determines when the products exit the from_site.	Required. Determines when the products exit the from_site.	Required. Determines when the products exit the from_site.	Not required
	actual_ship_date	Optional. Determines the actual date when the product exits the from_site.	Optional. Determines the actual date when the product exits the from_site.	Optional. Determines the actual date when the product exits the from_site.	Optional. Determines the actual date when the product exits the from_site.	Not required
	shipped_qty	Required. Determines the quantity shipped from the from_site.	Required. Determines the quantity shipped from the from_site.	Required. Determines the quantity shipped from the from_site.	Required. Determines the quantity shipped from the from_site.	Not required
	cust_shipment_status	Optional. Status of the shipment. For example, canceled, open, closed, and so on.	Optional. Status of the shipment. For example, canceled, open, closed, and so on.	Optional. Status of the shipment. For example, canceled, open, closed, and so on.	Optional. Status of the shipment. For example, canceled, open, closed, and so on.	Not required
	to_site_id	Optional. Site where products should be shipped.	Optional. Site where products should be shipped.	Optional. Site where products should be shipped.	Optional. Site where products should be shipped.	Not required
	expected_delivery_date	Optional	Optional	Optional	Optional	Not required
	actual_delivery_date	Optional	Optional	Optional	Optional	Not required

Warning Javascript is disabled or is unavailable in your browser.

To use the Amazon Web Services Documentation, Javascript must be enabled. Please refer to your browser's Help pages for instructions.

Document Conventions

Supply Planning

Work Order Insights