# 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. - ** [site](network-site-entity.md) ** - **Column:** id / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** description / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Optional - **Column:** geo\_id / **Is the column used for Inventory visibility?:** Required – This field is required for filters to group sites by geographical groups such as region/country/state and so on. / **Is the column used for Network map?:** Required – This field is required for filters to group sites by geographical groups such as region/country/state and so on. / **Is the column used for Inventory Insights?:** Required – This field is required for filters to group sites by geographical groups such as region/country/state and so on. / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required – This field is required for filters to group sites by geographical groups such as region/country/state and so on. - **Column:** site\_type / **Is the column used for Inventory visibility?:** Optional – Populating this column will display the site type on the inventory visibility page such as RDC, CDC, manufacturing site and so on. / **Is the column used for Network map?:** Optional / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Optional - **Column:** company\_id / **Is the column used for Inventory visibility?:** Optional / **Is the column used for Network map?:** Optional / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used 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:** latitude / **Is the column used for Inventory visibility?:** Optional / **Is the column used for Network map?:** Required – This field is used to view the *site* on the Network Map page. / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Column name *latitude* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** longitude / **Is the column used for Inventory visibility?:** Optional / **Is the column used for Network map?:** Required – This field is used to view the *site* on the Network Map page. / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Column name *longitude* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** is\_active / **Is the column used for Inventory visibility?:** 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. / **Is the column used for Network map?:** 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. / **Is the column used for Inventory Insights?:** 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. / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** 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. - **Column:** open\_date / **Is the column used for Inventory visibility?:** Optional / **Is the column used for Network map?:** Optional / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Column name *open\_date* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** end\_date / **Is the column used for Inventory visibility?:** Optional / **Is the column used for Network map?:** Optional / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Column name *end\_date* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - ** [transportation\_lane](network-transporation-lane-entity.md) ** - **Column:** id / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** from\_site\_id / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** 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:** to\_site\_id / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** 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:** product\_group\_id / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Column name *product\_group\_id* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** transit\_time / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Column name *transit\_time* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** time\_uom / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Required – Supports day or days as units. / **Is the column used for Lead time Insights?:** Column name *time\_uom* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** distance / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Column name *distance* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** distance\_uom / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Required – Supports mile(s), km(s), or Kilometer(s) as units. / **Is the column used for Lead time Insights?:** Column name *distance\_uom* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** eff\_start\_date / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Column name *eff\_start\_date* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** eff\_end\_date / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Column name *eff\_end\_date* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** product\_id / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Optional – Either product\_id or product-group-id is required. When the lane is linked with a product, this field is mandatory. / **Is the column used for Lead time Insights?:** Column name *product\_id* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** emissions\_per\_unit / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Column name *emissions\_per\_unit* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** emissions\_per\_weight / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Column name *emissions\_per\_unit* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** company\_id / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used 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:** from\_geo\_id / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** 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:** to\_geo\_id / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** 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:** carrier\_tpartner\_id / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** 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:** service\_type / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** 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:** trans\_mode / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** 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:** cost\_per\_unit / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Optional – You can view the shipping cost unit by lane during rebalance recommendations. / **Is the column used for Lead time Insights?:** Column name *cost\_per\_unit* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** cost\_currency / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Optional – You can view the shipping cost unit by lane during rebalance recommendations. / **Is the column used for Lead time Insights?:** Column name *cost\_currency* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - ** [product](product-product-entity.md) ** - **Column:** id / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** description / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** product\_group\_id / **Is the column used for Inventory visibility?:** Required – Using this field, you can group products by product category such dairy, clothes, and so on. / **Is the column used for Network map?:** Required – Using this field, you can group products by product category such dairy, clothes, and so on. / **Is the column used for Inventory Insights?:** Required – Using this field, you can group products by product category such dairy, clothes, and so on. / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required – Using this field, you can group products by product category such dairy, clothes, and so on. - **Column:** is\_deleted / **Is the column used for Inventory visibility?:** 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*. / **Is the column used for Network map?:** 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*. / **Is the column used for Inventory Insights?:** 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*. / **Is the column used for Rebalance recommendations?:** 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*. / **Is the column used for Lead time Insights?:** 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*. - **Column:** product\_type / **Is the column used for Inventory visibility?:** Optional – This field is required to support multiple product levels such as planning and fulfillment product. / **Is the column used for Network map?:** Optional – This field is required to support multiple product levels such as planning and fulfillment product. / **Is the column used for Inventory Insights?:** Optional – This field is required to support multiple product levels such as planning and fulfillment product. / **Is the column used for Rebalance recommendations?:** Optional – This field is required to support multiple product levels such as planning and fulfillment product. / **Is the column used for Lead time Insights?:** Column name *product\_type* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** parent\_product\_id / **Is the column used for Inventory visibility?:** Optional – This field is required to support multiple product levels such as planning and fulfillment product. / **Is the column used for Network map?:** Optional – This field is required to support multiple product levels such as planning and fulfillment product. / **Is the column used for Inventory Insights?:** Optional – This field is required to support multiple product levels such as planning and fulfillment product. / **Is the column used for Rebalance recommendations?:** Optional – This field is required to support multiple product levels such as planning and fulfillment product. / **Is the column used for Lead time Insights?:** Column name *parent\_product\_id* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** base\_uom / **Is the column used for Inventory visibility?:** Optional – This field is required for Insights to calculate the default base uom for a given product. / **Is the column used for Network map?:** Optional – This field is required for Insights to calculate the default base uom for a given product. / **Is the column used for Inventory Insights?:** Optional – This field is required for Insights to calculate the default base uom for a given product. / **Is the column used for Rebalance recommendations?:** Optional – This field is required for Insights to calculate the default base uom for a given product. / **Is the column used for Lead time Insights?:** Column name *base\_uom* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - ** [product\_hierarchy](product-hierarchy-entity.md) ** - **Column:** id / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** description / **Is the column used for Inventory visibility?:** Required – Using this field, you can filter groups by product category such dairy, clothes, and so on. / **Is the column used for Network map?:** Required – Using this field, you can filter groups by product category such dairy, clothes, and so on. / **Is the column used for Inventory Insights?:** Required – Using this field, you can filter groups by product category such dairy, clothes, and so on. / **Is the column used for Rebalance recommendations?:** Required – Using this field, you can filter groups by product category such dairy, clothes, and so on. / **Is the column used for Lead time Insights?:** Required – Using this field, you can filter groups by product category such dairy, clothes, and so on. - **Column:** parent\_product\_group\_id / **Is the column used for Inventory visibility?:** Optional – This field is used by filters to support multiple product hierarchy category such as dairy, frozen diary products, fresh diary and so on. / **Is the column used for Network map?:** Optional – This field is used by filters to support multiple product hierarchy category such as dairy, frozen diary products, fresh diary and so on. / **Is the column used for Inventory Insights?:** Optional – This field is used by filters to support multiple product hierarchy category such as dairy, frozen diary products, fresh diary and so on. / **Is the column used for Rebalance recommendations?:** Column name *parent\_product\_group\_id* should be available in your dataset. Value for the column name is not required for Rebalance Recommendations. / **Is the column used for Lead time Insights?:** 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](product-uom-entity.md) This data entity is *optional*. For product uom conversions, data is *required* in either *product-uom*, *uom\_conversion*, or *Insights*. ** - **Column:** product\_uom\_id / **Is the column used for Inventory visibility?:** Required – This field is required to perform the product uom conversion. / **Is the column used for Network map?:** Required – This field is required to perform the product uom conversion. / **Is the column used for Inventory Insights?:** Required – This field is required to perform the product uom conversion. / **Is the column used for Rebalance recommendations?:** Required – This field is required to perform the product uom conversion. / **Is the column used for Lead time Insights?:** Not required - **Column:** product\_id / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Not required - **Column:** uom / **Is the column used for Inventory visibility?:** Required – This field is required for conversion to units. / **Is the column used for Network map?:** Required – This field is required for conversion to units. / **Is the column used for Inventory Insights?:** Required – This field is required for conversion to units. / **Is the column used for Rebalance recommendations?:** Required – This field is required for conversion to units. / **Is the column used for Lead time Insights?:** Not required - **Column:** description / **Is the column used for Inventory visibility?:** Optional / **Is the column used for Network map?:** Optional / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Not required - **Column:** quantity / **Is the column used for Inventory visibility?:** Required – This field contains the conversion factor. / **Is the column used for Network map?:** Required – This field contains the conversion factor. / **Is the column used for Inventory Insights?:** Required – This field contains the conversion factor. / **Is the column used for Rebalance recommendations?:** Required – This field contains the conversion factor. / **Is the column used for Lead time Insights?:** Not required - **Column:** quantity\_uom / **Is the column used for Inventory visibility?:** Required – This field is required for conversion from units. / **Is the column used for Network map?:** Required – This field is required for conversion from units. / **Is the column used for Inventory Insights?:** Required – This field is required for conversion from units. / **Is the column used for Rebalance recommendations?:** Required – This field is required for conversion from units. / **Is the column used for Lead time Insights?:** Not required - **Column:** eff\_start\_date / **Is the column used for Inventory visibility?:** Optional / **Is the column used for Network map?:** Optional / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Not required - **Column:** eff\_end\_date / **Is the column used for Inventory visibility?:** Optional / **Is the column used for Network map?:** Optional / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Not required - **Column:** company\_id / **Is the column used for Inventory visibility?:** Optional / **Is the column used for Network map?:** Optional / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Not required - ** [uom\_conversion](reference-uom-conversion-entity.md) This data entity is *optional*. For product uom conversions, data is *required* in either *product-uom*, *uom\_conversion*, or *Insights*. ** - **Column:** uom / **Is the column used for Inventory visibility?:** Required – This field is required for conversion from units. / **Is the column used for Network map?:** Required – This field is required for conversion from units. / **Is the column used for Inventory Insights?:** Required – This field is required for conversion from units. / **Is the column used for Rebalance recommendations?:** Required – This field is required for conversion from units. / **Is the column used for Lead time Insights?:** Not required - **Column:** company\_id / **Is the column used for Inventory visibility?:** Optional / **Is the column used for Network map?:** Optional / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Not required - **Column:** conversion\_uom\_id / **Is the column used for Inventory visibility?:** Required – This field is required for conversion to units. / **Is the column used for Network map?:** Required – This field is required for conversion to units. / **Is the column used for Inventory Insights?:** Required – This field is required for conversion to units. / **Is the column used for Rebalance recommendations?:** Required – This field is required for conversion to units. / **Is the column used for Lead time Insights?:** Not required - **Column:** conversion\_factor / **Is the column used for Inventory visibility?:** Required – This field contains the conversion factor. / **Is the column used for Network map?:** Required – This field contains the conversion factor. / **Is the column used for Inventory Insights?:** Required – This field contains the conversion factor. / **Is the column used for Rebalance recommendations?:** Required – This field contains the conversion factor. / **Is the column used for Lead time Insights?:** Not required - ** [geography](organization-geography-entity.md) ** - **Column:** id / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** description / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** parent\_geo\_id / **Is the column used for Inventory visibility?:** Optional – This field is used to support multiple location hierarchy such as USA, USA-East, and so on. / **Is the column used for Network map?:** Required – This field is used to support multiple location hierarchy such as USA, USA-East, and so on. / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Required – This field is used to support multiple location hierarchy such as USA, USA-East, and so on. - ** [trading\_partner](organization-trading-partner-entity.md) ** - **Column:** id / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** description / **Is the column used for Inventory visibility?:** Optional / **Is the column used for Network map?:** Optional / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Required - **Column:** country / **Is the column used for Inventory visibility?:** Optional / **Is the column used for Network map?:** Optional / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Optional - **Column:** eff\_start\_date / **Is the column used for Inventory visibility?:** 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. / **Is the column used for Network map?:** 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. / **Is the column used for Inventory Insights?:** 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. / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** Column name *eff\_start\_date* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** eff\_end\_date / **Is the column used for Inventory visibility?:** 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. / **Is the column used for Network map?:** 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. / **Is the column used for Inventory Insights?:** 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. / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** Column name *eff\_end\_date* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** time\_zone / **Is the column used for Inventory visibility?:** Optional / **Is the column used for Network map?:** Optional / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Column name *time\_zone* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** is\_active / **Is the column used for Inventory visibility?:** Optional / **Is the column used for Network map?:** Optional / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Column name *is\_active* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** tpartner\_type / **Is the column used for Inventory visibility?:** 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. / **Is the column used for Network map?:** 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. / **Is the column used for Inventory Insights?:** 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. / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** Column name *tpartner\_type* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** geo\_id / **Is the column used for Inventory visibility?:** 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. / **Is the column used for Network map?:** 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. / **Is the column used for Inventory Insights?:** 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. / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** Column name *geo\_id* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - ** [inbound\_order](replenishment-inbound-order-entity.md) This data entity is *required* for *Lead Time Insights* but *optional* for *Inventory Visibility*, *Network Map*, *Inventory Insights*, and *Rebalance Recommendations*. ** - **Column:** id / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Not required / **Is the column used for Lead time Insights?:** Required - **Column:** order\_type / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Not required / **Is the column used for Lead time Insights?:** Optional – Data can be used by inbound order line. - **Column:** order\_status / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Not required / **Is the column used for Lead time Insights?:** Optional - **Column:** to\_site\_id / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Not required / **Is the column used for Lead time Insights?:** Column name *site\_id* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** submitted\_date / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Not required / **Is the column used for Lead time Insights?:** Required - **Column:** tpartner\_id / **Is the column used for Inventory visibility?:** 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. / **Is the column used for Network map?:** 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. / **Is the column used for Inventory Insights?:** 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. / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** 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](replenishment-inbound-order-line-entity.md) ** - **Column:** id / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** order\_id / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** order\_type / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Optional - **Column:** status / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Optional - **Column:** product\_id / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** to\_site\_id / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** from\_site\_id / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** quantity\_submitted / **Is the column used for Inventory visibility?:** Required – One quantity field should be set. / **Is the column used for Network map?:** Required – One quantity field should be set. / **Is the column used for Inventory Insights?:** Required – One quantity field should be set. / **Is the column used for Rebalance recommendations?:** Required – One quantity field should be set. / **Is the column used for Lead time Insights?:** Required – One quantity field should be set. - **Column:** quantity\_confirmed / **Is the column used for Inventory visibility?:** Optional – One quantity field should be set. / **Is the column used for Network map?:** Optional – One quantity field should be set. / **Is the column used for Inventory Insights?:** Optional – One quantity field should be set. / **Is the column used for Rebalance recommendations?:** Optional – One quantity field should be set. / **Is the column used for Lead time Insights?:** Optional – One quantity field should be set. - **Column:** quantity\_received / **Is the column used for Inventory visibility?:** Optional – This field should be blank for open orders. / **Is the column used for Network map?:** Optional – This field should be blank for open orders. / **Is the column used for Inventory Insights?:** Optional – This field should be blank for open orders. / **Is the column used for Rebalance recommendations?:** Optional – This field should be blank for open orders. / **Is the column used for Lead time Insights?:** Optional – This field should be blank for open orders. - **Column:** quantity\_uom / **Is the column used for Inventory visibility?:** Required – This field is required to determine the unit for quantity fields. / **Is the column used for Network map?:** Required – This field is required to determine the unit for quantity fields. / **Is the column used for Inventory Insights?:** Required – This field is required to determine the unit for quantity fields. / **Is the column used for Rebalance recommendations?:** Required – This field is required to determine the unit for quantity fields. / **Is the column used for Lead time Insights?:** Column name *quantity\_uom* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** expected\_delivery\_date / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** submitted\_date / **Is the column used for Inventory visibility?:** Column name *submitted\_date* should be available in your dataset. Value for the column name is not required for Inventory visibility. / **Is the column used for Network map?:** Column name *submitted\_date* should be available in your dataset. Value for the column name is not required for Network map. / **Is the column used for Inventory Insights?:** Column name *submitted\_date* should be available in your dataset. Value for the column name is not required for Inventory Insights. / **Is the column used for Rebalance recommendations?:** Column name *submitted\_date* should be available in your dataset. Value for the column name is not required for Rebalance Recommendations. / **Is the column used for Lead time Insights?:** Required - **Column:** incoterm / **Is the column used for Inventory visibility?:** Column name *incoterm* should be available in your dataset. Value for the column name is not required for Inventory visibility. / **Is the column used for Network map?:** Column name *incoterm* should be available in your dataset. Value for the column name is not required for Network map. / **Is the column used for Inventory Insights?:** Column name *incoterm* should be available in your dataset. Value for the column name is not required for Inventory Insights. / **Is the column used for Rebalance recommendations?:** Column name *incoterm* should be available in your dataset. Value for the column name is not required for Rebalance Recommendations. / **Is the column used for Lead time Insights?:** Optional - **Column:** product\_group\_id / **Is the column used for Inventory visibility?:** Column name *product\_group\_id* should be available in your dataset. Value for the column name is not required for Inventory visibility. / **Is the column used for Network map?:** Column name *product\_group\_id* should be available in your dataset. Value for the column name is not required for Network map. / **Is the column used for Inventory Insights?:** Column name *product\_group\_id* should be available in your dataset. Value for the column name is not required for Inventory Insights. / **Is the column used for Rebalance recommendations?:** Column name *product\_group\_id* should be available in your dataset. Value for the column name is not required for Rebalance Recommendations. / **Is the column used for Lead time Insights?:** Optional - **Column:** company\_id / **Is the column used for Inventory visibility?:** Column name *company\_id* should be available in your dataset. Value for the column name is not required for Inventory Insights. / **Is the column used for Network map?:** Column name *company\_id* should be available in your dataset. Value for the column name is not required for Network map. / **Is the column used for Inventory Insights?:** Column name *company\_id* should be available in your dataset. Value for the column name is not required for Inventory Insights. / **Is the column used for Rebalance recommendations?:** Column name *company\_id* should be available in your dataset. Value for the column name is not required for Rebalance Recommendations. / **Is the column used for Lead time Insights?:** Optional - **Column:** tpartner\_id / **Is the column used for Inventory visibility?:** 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. / **Is the column used for Network map?:** 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. / **Is the column used for Inventory Insights?:** 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. / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** 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:** reservation\_id / **Is the column used for Inventory visibility?:** 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. / **Is the column used for Network map?:** 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. / **Is the column used for Inventory Insights?:** 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. / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** Column name *reservation\_id* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** order\_receive\_date / **Is the column used for Inventory visibility?:** Column name *order\_receive\_date* should be available in your dataset. Value for the column name is not required for Inventory visibility. / **Is the column used for Network map?:** Column name *order\_receive\_date* should be available in your dataset. Value for the column name is not required for Network map. / **Is the column used for Inventory Insights?:** Column name *order\_receive\_date* should be available in your dataset. Value for the column name is not required for Inventory Insights. / **Is the column used for Rebalance recommendations?:** Column name *order\_receive\_date* should be available in your dataset. Value for the column name is not required for Rebalance Recommendations. / **Is the column used for Lead time Insights?:** Optional - ** [inbound\_order\_line\_schedule](replenishment-inbound-order-line-schedule-entity.md) 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](admin-support-ug.md). ** - **Column:** id / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** order\_id / **Is the column used for Inventory visibility?:** Required – This field is required to link back to an order line along with the order\_line\_id. / **Is the column used for Network map?:** Required – This field is required to link back to an order line along with the order\_line\_id. / **Is the column used for Inventory Insights?:** Required – This field is required to link back to an order line along with the order\_line\_id. / **Is the column used for Rebalance recommendations?:** Required – This field is required to link back to an order line along with the order\_line\_id. / **Is the column used for Lead time Insights?:** 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:** order\_line\_id / **Is the column used for Inventory visibility?:** Required – This field is required to link back to an order line along with order\_id. / **Is the column used for Network map?:** Required – This field is required to link back to an order line along with order\_id. / **Is the column used for Inventory Insights?:** Required – This field is required to link back to an order line along with order\_id. / **Is the column used for Rebalance recommendations?:** Required – This field is required to link back to an order line along with order\_id. / **Is the column used for Lead time Insights?:** Column name *order\_line\_id* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** company\_id / **Is the column used for Inventory visibility?:** Column name *company\_id* should be available in your dataset. Value for the column name is not required for Lead Time Insights. / **Is the column used for Network map?:** Column name *company\_id* should be available in your dataset. Value for the column name is not required for Lead Time Insights. / **Is the column used for Inventory Insights?:** Column name *company\_id* should be available in your dataset. Value for the column name is not required for Lead Time Insights. / **Is the column used for Rebalance recommendations?:** Column name *company\_id* should be available in your dataset. Value for the column name is not required for Lead Time Insights. / **Is the column used 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:** product\_id / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** expected\_delivery\_date / **Is the column used for Inventory visibility?:** Optional – *delivery\_date* or *expected\_delivery date* must be provided. / **Is the column used for Network map?:** Optional – *delivery\_date* or *expected\_delivery date* must be provided. / **Is the column used for Inventory Insights?:** Optional – *delivery\_date* or *expected\_delivery date* must be provided. / **Is the column used for Rebalance recommendations?:** Optional – *delivery\_date* or *expected\_delivery date* must be provided. / **Is the column used for Lead time Insights?:** Optional - **Column:** delivery\_date / **Is the column used for Inventory visibility?:** Optional – *delivery\_date* or *expected\_delivery date* must be provided. / **Is the column used for Network map?:** Optional – *delivery\_date* or *expected\_delivery date* must be provided. / **Is the column used for Inventory Insights?:** Optional – *delivery\_date* or *expected\_delivery date* must be provided. / **Is the column used for Rebalance recommendations?:** Optional – *delivery\_date* or *expected\_delivery date* must be provided. / **Is the column used for Lead time Insights?:** Column name *delivery\_date* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** ship\_date / **Is the column used for Inventory visibility?:** Optional – Date when the order was shipped. / **Is the column used for Network map?:** Optional – Date when the order was shipped. / **Is the column used for Inventory Insights?:** Optional – Date when the order was shipped. / **Is the column used for Rebalance recommendations?:** Optional – Date when the order was shipped. / **Is the column used for Lead time Insights?:** Column name *ship\_date* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** quantity\_submitted / **Is the column used for Inventory visibility?:** Required – One quantity field should be set. This field uses the uom set at the line level. / **Is the column used for Network map?:** Required – One quantity field should be set. This field uses the uom set at the line level. / **Is the column used for Inventory Insights?:** Required – One quantity field should be set. This field uses the uom set at the line level. / **Is the column used for Rebalance recommendations?:** Required – One quantity field should be set. This field uses the uom set at the line level. / **Is the column used for Lead time Insights?:** Column name *quantity\_submitted* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** quantity\_confirmed / **Is the column used for Inventory visibility?:** Required – One quantity field should be set. This field uses the uom set at the line level. / **Is the column used for Network map?:** Required – One quantity field should be set. This field uses the uom set at the line level. / **Is the column used for Inventory Insights?:** Required – One quantity field should be set. This field uses the uom set at the line level. / **Is the column used for Rebalance recommendations?:** Required – One quantity field should be set. This field uses the uom set at the line level. / **Is the column used for Lead time Insights?:** Column name *quantity\_confirmed* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** quantity\_received / **Is the column used for Inventory visibility?:** Required – One quantity field should be set. This field uses the uom set at the line level. / **Is the column used for Network map?:** Required – One quantity field should be set. This field uses the uom set at the line level. / **Is the column used for Inventory Insights?:** Required – One quantity field should be set. This field uses the uom set at the line level. / **Is the column used for Rebalance recommendations?:** Required – One quantity field should be set. This field uses the uom set at the line level. / **Is the column used for Lead time Insights?:** Column name *quantity\_received* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - ** [shipment](replenishment-shipment-entity.md) ** - **Column:** id / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Optional - **Column:** order\_id / **Is the column used for Inventory visibility?:** Required – This field is required to calculate the in-transit and on-order values for projected inventory visibility. / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required – This field is required to calculate the in-transit and on-order values for projected inventory visibility. / **Is the column used for Rebalance recommendations?:** Required – This field is required to calculate the in-transit and on-order values for projected inventory visibility. / **Is the column used for Lead time Insights?:** Required - **Column:** order\_line\_id / **Is the column used for Inventory visibility?:** Required – This field is required to calculate the in-transit and on-order values for projected inventory visibility. / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required – This field is required to calculate the in-transit and on-order values for projected inventory visibility. / **Is the column used for Rebalance recommendations?:** Required – This field is required to calculate the in-transit and on-order values for projected inventory visibility. / **Is the column used for Lead time Insights?:** Required - **Column:** product\_id / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** ship\_to\_site\_id / **Is the column used for Inventory visibility?:** Optional – Derived from inbound order line. / **Is the column used for Network map?:** Optional – Derived from inbound order line. / **Is the column used for Inventory Insights?:** Optional – Derived from inbound order line. / **Is the column used for Rebalance recommendations?:** Optional – Derived from inbound order line. / **Is the column used for Lead time Insights?:** Required - **Column:** actual\_delivery\_date / **Is the column used for Inventory visibility?:** Optional – *planned\_delivery\_date* or *actual\_delivery\_date* must be provided. / **Is the column used for Network map?:** Optional – *planned\_delivery\_date* or *actual\_delivery\_date* must be provided. / **Is the column used for Inventory Insights?:** Optional – *planned\_delivery\_date* or *actual\_delivery\_date* must be provided. / **Is the column used for Rebalance recommendations?:** Optional – *planned\_delivery\_date* or *actual\_delivery\_date* must be provided. / **Is the column used for Lead time Insights?:** Required - **Column:** units\_shipped / **Is the column used for Inventory visibility?:** Optional – Derived from inbound order line. / **Is the column used for Network map?:** Optional – Derived from inbound order line. / **Is the column used for Inventory Insights?:** Optional – Derived from inbound order line. / **Is the column used for Rebalance recommendations?:** Optional – Derived from inbound order line. / **Is the column used for Lead time Insights?:** Optional – Derived from inbound order line. - **Column:** uom / **Is the column used for Inventory visibility?:** Optional – This field is used to determine the unit for quantity fields. / **Is the column used for Network map?:** Optional – This field is used to determine the unit for quantity fields. / **Is the column used for Inventory Insights?:** Optional – This field is used to determine the unit for quantity fields. / **Is the column used for Rebalance recommendations?:** Optional – This field is used to determine the unit for quantity fields. / **Is the column used for Lead time Insights?:** Optional – This field is used to determine the unit for quantity fields. - **Column:** planned\_ship\_date / **Is the column used for Inventory visibility?:** Optional – *planned\_ship\_date* or *actual\_ship\_date* must be provided. / **Is the column used for Network map?:** Optional – *planned\_ship\_date* or *actual\_ship\_date* must be provided. / **Is the column used for Inventory Insights?:** Optional – *planned\_ship\_date* or *actual\_ship\_date* must be provided. / **Is the column used for Rebalance recommendations?:** Optional – *planned\_ship\_date* or *actual\_ship\_date* must be provided. / **Is the column used for Lead time Insights?:** Column name *planned\_ship\_date* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** actual\_ship\_date / **Is the column used for Inventory visibility?:** Optional – *planned\_ship\_date* or *actual\_ship\_date* must be provided. / **Is the column used for Network map?:** Optional – *planned\_ship\_date* or *actual\_ship\_date* must be provided. / **Is the column used for Inventory Insights?:** Optional – *planned\_ship\_date* or *actual\_ship\_date* must be provided. / **Is the column used for Rebalance recommendations?:** Optional – *planned\_ship\_date* or *actual\_ship\_date* must be provided. / **Is the column used for Lead time Insights?:** Column name *actual\_ship\_date* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** planned\_delivery\_date / **Is the column used for Inventory visibility?:** Optional – *planned\_delivery\_date* or *actual\_delivery\_date* must be provided. / **Is the column used for Network map?:** Optional – *planned\_delivery\_date* or *actual\_delivery\_date* must be provided. / **Is the column used for Inventory Insights?:** Optional – *planned\_delivery\_date* or *actual\_delivery\_date* must be provided. / **Is the column used for Rebalance recommendations?:** Optional – *planned\_delivery\_date* or *actual\_delivery\_date* must be provided. / **Is the column used for Lead time Insights?:** Column name *planned\_delivery\_date* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** ship\_from\_site\_id / **Is the column used for Inventory visibility?:** Optional – Derived from inbound order line. / **Is the column used for Network map?:** Optional – Derived from inbound order line. / **Is the column used for Inventory Insights?:** Optional – Derived from inbound order line. / **Is the column used for Rebalance recommendations?:** Optional – Derived from inbound order line. / **Is the column used for Lead time Insights?:** Optional - **Column:** supplier\_tpartner\_id / **Is the column used for Inventory visibility?:** Column name *supplier\_tpartner\_id* should be available in your dataset. Value for the column name is not required for Inventory visibility. / **Is the column used for Network map?:** Column name *supplier\_tpartner\_id* should be available in your dataset. Value for the column name is not required for Network map. / **Is the column used for Inventory Insights?:** Column name *supplier\_tpartner\_id* should be available in your dataset. Value for the column name is not required for Inventory Insights. / **Is the column used for Rebalance recommendations?:** Column name *supplier\_tpartner\_id* should be available in your dataset. Value for the column name is not required for Rebalance Recommendations. / **Is the column used for Lead time Insights?:** Optional - **Column:** transportation\_mode / **Is the column used for Inventory visibility?:** Column name *transportation\_mode* should be available in your dataset. Value for the column name is not required for Inventory visibility. / **Is the column used for Network map?:** Column name *transportation\_mode* should be available in your dataset. Value for the column name is not required for Network map. / **Is the column used for Inventory Insights?:** Column name *transportation\_mode* should be available in your dataset. Value for the column name is not required for Inventory Insights. / **Is the column used for Rebalance recommendations?:** Column name *transportation\_mode* should be available in your dataset. Value for the column name is not required for Rebalance Recommendations. / **Is the column used for Lead time Insights?:** Optional - **Column:** ship\_from\_site\_address\_country / **Is the column used 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 Inventory visibility. / **Is the column used 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 Network map. / **Is the column used 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 Inventory Insights. / **Is the column used for Rebalance recommendations?:** Column name *ship\_from\_site\_address\_country* should be available in your dataset. Value for the column name is not required for Rebalance Recommendations. / **Is the column used for Lead time Insights?:** Optional - **Column:** ship\_to\_site\_address\_country / **Is the column used 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 Inventory visibility. / **Is the column used 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 Network map. / **Is the column used 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 Inventory Insights. / **Is the column used for Rebalance recommendations?:** Column name *ship\_to\_site\_address\_country* should be available in your dataset. Value for the column name is not required for Rebalance Recommendations. / **Is the column used for Lead time Insights?:** Optional - **Column:** carrier\_id / **Is the column used for Inventory visibility?:** Column name *carrier\_id* should be available in your dataset. Value for the column name is not required for Inventory visibility. / **Is the column used for Network map?:** Column name *carrier\_id* should be available in your dataset. Value for the column name is not required for Network map. / **Is the column used for Inventory Insights?:** Column name *carrier\_id* should be available in your dataset. Value for the column name is not required for Inventory Insights. / **Is the column used for Rebalance recommendations?:** Column name *carrier\_id* should be available in your dataset. Value for the column name is not required for Rebalance Recommendations. / **Is the column used for Lead time Insights?:** Optional - **Column:** package\_id / **Is the column used for Inventory visibility?:** 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. / **Is the column used for Network map?:** 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. / **Is the column used for Inventory Insights?:** 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. / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** 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](planning-inv-policy-entity.md) ** - **Column:** id / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** site\_id / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** product\_id / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** min\_safety\_stock / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** max\_safety\_stock / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** qty\_uom / **Is the column used for Inventory visibility?:** Optional – This field is used to determine the UOM for inventory policy. / **Is the column used for Network map?:** Optional – This field is used to determine the UOM for inventory policy. / **Is the column used for Inventory Insights?:** Optional – This field is used to determine the UOM for inventory policy. / **Is the column used for Rebalance recommendations?:** Optional – This field is used to determine the UOM for inventory policy. / **Is the column used for Lead time Insights?:** Optional – This field is used to determine the UOM for inventory policy. - **Column:** min\_doc\_limit / **Is the column used for Inventory visibility?:** Optional – This field is required if you want to see the days of cover. / **Is the column used for Network map?:** Optional – This field is required if you want to see the days of cover. / **Is the column used for Inventory Insights?:** Optional – This field is required if you want to see the days of cover. / **Is the column used for Rebalance recommendations?:** Optional – This field is required if you want to see the days of cover. / **Is the column used for Lead time Insights?:** Column name *min\_doc\_limit* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** max\_doc\_limit / **Is the column used for Inventory visibility?:** Optional – This field is required if you want to see the days of cover. / **Is the column used for Network map?:** Optional – This field is required if you want to see the days of cover. / **Is the column used for Inventory Insights?:** Optional – This field is required if you want to see the days of cover. / **Is the column used for Rebalance recommendations?:** Optional – This field is required if you want to see the days of cover. / **Is the column used for Lead time Insights?:** Column name *max\_doc\_limit* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** eff\_start\_date / **Is the column used for Inventory visibility?:** 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. / **Is the column used for Network map?:** 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. / **Is the column used for Inventory Insights?:** 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. / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** 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:** eff\_end\_date / **Is the column used for Inventory visibility?:** 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. / **Is the column used for Network map?:** 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. / **Is the column used for Inventory Insights?:** 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. / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** 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:** company\_id / **Is the column used for Inventory visibility?:** Optional / **Is the column used for Network map?:** Optional / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Optional - **Column:** ss\_policy / **Is the column used for Inventory visibility?:** Required – *abs\_level* when there is no value. / **Is the column used for Network map?:** Required – *abs\_level* when there is no value. / **Is the column used for Inventory Insights?:** Required – *abs\_level* when there is no value. / **Is the column used for Rebalance recommendations?:** Required – *abs\_level* when there is no value. / **Is the column used for Lead time Insights?:** Required – *abs\_level* when there is no value. - **Column:** fallback\_policy\_1 / **Is the column used for Inventory visibility?:** Optional / **Is the column used for Network map?:** Optional / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Column name *fallback\_policy\_1* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** product\_group\_id / **Is the column used for Inventory visibility?:** 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. / **Is the column used for Network map?:** 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. / **Is the column used for Inventory Insights?:** 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. / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** 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:** dest\_geo\_id / **Is the column used for Inventory visibility?:** 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. / **Is the column used for Network map?:** 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. / **Is the column used for Inventory Insights?:** 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. / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** 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:** vendor\_tpartner\_id / **Is the column used for Inventory visibility?:** 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. / **Is the column used for Network map?:** 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. / **Is the column used for Inventory Insights?:** 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. / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** 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](inventory_mgmnt-inv-level-entity.md) Enter the on-hand inventory at the beginning of the day. ** - **Column:** snapshot\_date / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** site\_id / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** product\_id / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** company\_id / **Is the column used for Inventory visibility?:** Optional / **Is the column used for Network map?:** Optional / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Optional - **Column:** on\_hand\_inventory / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Required - **Column:** allocated\_inventory / **Is the column used for Inventory visibility?:** Optional / **Is the column used for Network map?:** Optional / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Column name *allocated\_inventory* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** quantity\_uom / **Is the column used for Inventory visibility?:** Optional – This field is used to determine the quantity UOM for inventory records. / **Is the column used for Network map?:** Optional – This field is used to determine the quantity UOM for inventory records. / **Is the column used for Inventory Insights?:** Optional – This field is used to determine the quantity UOM for inventory records. / **Is the column used for Rebalance recommendations?:** Optional – This field is used to determine the quantity UOM for inventory records. / **Is the column used for Lead time Insights?:** Column name *quantity\_uom* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** inv\_condition / **Is the column used for Inventory visibility?:** 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. / **Is the column used for Network map?:** 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. / **Is the column used for Inventory Insights?:** 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. / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** 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:** lot\_number / **Is the column used for Inventory visibility?:** 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. / **Is the column used for Network map?:** 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. / **Is the column used for Inventory Insights?:** 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. / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** 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](forecast-forecast-entity.md) ** - **Column:** site\_id / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Not required - **Column:** product\_id / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Not required - **Column:** mean / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Not required - **Column:** forecast\_start\_dttm 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. / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Not required - **Column:** forecast\_end\_dttm / **Is the column used for Inventory visibility?:** Required / **Is the column used for Network map?:** Required / **Is the column used for Inventory Insights?:** Required / **Is the column used for Rebalance recommendations?:** Required / **Is the column used for Lead time Insights?:** Not required - **Column:** quantity\_uom / **Is the column used for Inventory visibility?:** Optional – This field is used to determine the quantity UOM for forecast. / **Is the column used for Network map?:** Optional – This field is used to determine the quantity UOM for forecast. / **Is the column used for Inventory Insights?:** Optional – This field is used to determine the quantity UOM for forecast. / **Is the column used for Rebalance recommendations?:** Optional – This field is used to determine the quantity UOM for forecast. / **Is the column used for Lead time Insights?:** Column name *quantity\_uom* should be available in your dataset. Value for the column name is not required for Lead Time Insights. - **Column:** snapshot\_date / **Is the column used for Inventory visibility?:** 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. / **Is the column used for Network map?:** 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. / **Is the column used for Inventory Insights?:** 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. / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** Not required - **Column:** region\_id / **Is the column used for Inventory visibility?:** 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. / **Is the column used for Network map?:** 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. / **Is the column used for Inventory Insights?:** 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. / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** Not required - **Column:** product\_group\_id / **Is the column used for Inventory visibility?:** 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. / **Is the column used for Network map?:** 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. / **Is the column used for Inventory Insights?:** 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. / **Is the column used for Rebalance recommendations?:** 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. / **Is the column used for Lead time Insights?:** Not required - ** [vendor\_lead\_time](vendor-management-lead-time-entity.md) ** - **Column:** company\_id / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Not required / **Is the column used for Lead time Insights?:** Optional - **Column:** vendor\_tpartner\_id / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Not required / **Is the column used for Lead time Insights?:** Required - **Column:** product\_id / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Not required / **Is the column used for Lead time Insights?:** Required - **Column:** site\_id / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Not required / **Is the column used for Lead time Insights?:** Required - **Column:** planned\_lead\_time / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Not required / **Is the column used for Lead time Insights?:** Required - **Column:** eff\_start\_date / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Not required / **Is the column used for Lead time Insights?:** Optional - **Column:** eff\_end\_date / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Not required / **Is the column used for Lead time Insights?:** Optional - **Column:** product\_group\_id / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Not required / **Is the column used for Lead time Insights?:** 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:** region\_id / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Not required / **Is the column used for Lead time Insights?:** 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:** source\_site\_id / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Not required / **Is the column used for Lead time Insights?:** Optional. Site from where the inbound shipment originated. - **Column:** trans\_mode / **Is the column used for Inventory visibility?:** Not required / **Is the column used for Network map?:** Not required / **Is the column used for Inventory Insights?:** Not required / **Is the column used for Rebalance recommendations?:** Not required / **Is the column used for Lead time Insights?:** Optional. Transportation mode used. For example, ship, truck, rail. - ** [outbound\_order\_line](outbound-fulfillment-order-line-entity.md) 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. ** - **Column:** id / **Is the column used for Inventory visibility?:** Required. Determines the outbound shipment ID. / **Is the column used for Network map?:** Required. Determines the outbound shipment ID. / **Is the column used for Inventory Insights?:** Required. Determines the outbound shipment ID. / **Is the column used for Rebalance recommendations?:** Required. Determines the outbound shipment ID. / **Is the column used for Lead time Insights?:** Not required - **Column:** cust\_order\_id / **Is the column used for Inventory visibility?:** Required. Determines the outbound order ID. / **Is the column used for Network map?:** Required. Determines the outbound order ID. / **Is the column used for Inventory Insights?:** Required. Determines the outbound order ID. / **Is the column used for Rebalance recommendations?:** Required. Determines the outbound order ID. / **Is the column used for Lead time Insights?:** Not required - **Column:** product\_id / **Is the column used for Inventory visibility?:** Required. Determines the product ID shipped. / **Is the column used for Network map?:** Required. Determines the product ID shipped. / **Is the column used for Inventory Insights?:** Required. Determines the product ID shipped. / **Is the column used for Rebalance recommendations?:** Required. Determines the product ID shipped. / **Is the column used for Lead time Insights?:** Not required - **Column:** ship\_from\_site\_id / **Is the column used for Inventory visibility?:** Required. Determines the site from where the units are shipped. / **Is the column used for Network map?:** Required. Determines the site from where the units are shipped. / **Is the column used for Inventory Insights?:** Required. Determines the site from where the units are shipped. / **Is the column used for Rebalance recommendations?:** Required. Determines the site from where the units are shipped. / **Is the column used for Lead time Insights?:** Not required - **Column:** ship\_to\_site\_id / **Is the column used for Inventory visibility?:** Optional. Site where the products should be shipped. / **Is the column used for Network map?:** Optional. Site where the products should be shipped. / **Is the column used for Inventory Insights?:** Optional. Site where the products should be shipped. / **Is the column used for Rebalance recommendations?:** Optional. Site where the products should be shipped. / **Is the column used for Lead time Insights?:** Not required - **Column:** final\_quantity\_requested / **Is the column used for Inventory visibility?:** Optional. Final quantity after all updates and cancellations. / **Is the column used for Network map?:** Optional. Final quantity after all updates and cancellations. / **Is the column used for Inventory Insights?:** Optional. Final quantity after all updates and cancellations. / **Is the column used for Rebalance recommendations?:** Optional. Final quantity after all updates and cancellations. / **Is the column used for Lead time Insights?:** Not required - **Column:** quantity\_promised / **Is the column used for Inventory visibility?:** Required. Quantity agreed to be delivered. / **Is the column used for Network map?:** Required. Quantity agreed to be delivered. / **Is the column used for Inventory Insights?:** Required. Quantity agreed to be delivered. / **Is the column used for Rebalance recommendations?:** Required. Quantity agreed to be delivered. / **Is the column used for Lead time Insights?:** Not required - **Column:** quantity\_delivered / **Is the column used for Inventory visibility?:** Optional. Actual quantity delivered. / **Is the column used for Network map?:** Optional. Actual quantity delivered. / **Is the column used for Inventory Insights?:** Optional. Actual quantity delivered. / **Is the column used for Rebalance recommendations?:** Optional. Actual quantity delivered. / **Is the column used for Lead time Insights?:** Not required - **Column:** status / **Is the column used for Inventory visibility?:** Optional. Displays the status of the order line. For example, canceled, open, closed, and so on. / **Is the column used for Network map?:** Optional. Displays the status of the order line. For example, canceled, open, closed, and so on. / **Is the column used for Inventory Insights?:** Optional. Displays the status of the order line. For example, canceled, open, closed, and so on. / **Is the column used for Rebalance recommendations?:** Optional. Displays the status of the order line. For example, canceled, open, closed, and so on. / **Is the column used for Lead time Insights?:** Not required - **Column:** quantity\_uom / **Is the column used for Inventory visibility?:** Optional. Unit of measure for quantity. For example, eaches, cases. / **Is the column used for Network map?:** Optional. Unit of measure for quantity. For example, eaches, cases. / **Is the column used for Inventory Insights?:** Optional. Unit of measure for quantity. For example, eaches, cases. / **Is the column used for Rebalance recommendations?:** Optional. Unit of measure for quantity. For example, eaches, cases. / **Is the column used for Lead time Insights?:** Not required - **Column:** requested\_delivery\_date / **Is the column used for Inventory visibility?:** Optional / **Is the column used for Network map?:** Optional / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Not required - **Column:** promised\_delivery\_date / **Is the column used for Inventory visibility?:** Optional / **Is the column used for Network map?:** Optional / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Not required - ** [outbound\_shipment](outbound-fulfillment-shipment-entity.md) This data entity is *optional*. Supply Chain will use the demand data from the outbound\_order\_line or forecast data entity. ** - **Column:** id / **Is the column used for Inventory visibility?:** Required. Determines the outbound shipment ID. / **Is the column used for Network map?:** Required. Determines the outbound shipment ID. / **Is the column used for Inventory Insights?:** Required. Determines the outbound shipment ID. / **Is the column used for Rebalance recommendations?:** Required. Determines the outbound shipment ID. / **Is the column used for Lead time Insights?:** Not required - **Column:** from\_site\_id / **Is the column used for Inventory visibility?:** Required. Determines the site from where the units are shipped. / **Is the column used for Network map?:** Required. Determines the site from where the units are shipped. / **Is the column used for Inventory Insights?:** Required. Determines the site from where the units are shipped. / **Is the column used for Rebalance recommendations?:** Required. Determines the site from where the units are shipped. / **Is the column used for Lead time Insights?:** Not required - **Column:** product\_id / **Is the column used for Inventory visibility?:** Required. Determines the product ID of the product shipped. / **Is the column used for Network map?:** Required. Determines the product ID of the product shipped. / **Is the column used for Inventory Insights?:** Required. Determines the product ID of the product shipped. / **Is the column used for Rebalance recommendations?:** Required. Determines the product ID of the product shipped. / **Is the column used for Lead time Insights?:** Not required - **Column:** cust\_order\_id / **Is the column used for Inventory visibility?:** Required. Determines the outbound order ID. / **Is the column used for Network map?:** Required. Determines the outbound order ID. / **Is the column used for Inventory Insights?:** Required. Determines the outbound order ID. / **Is the column used for Rebalance recommendations?:** Required. Determines the outbound order ID. / **Is the column used for Lead time Insights?:** Not required - **Column:** cust\_order\_line\_id / **Is the column used for Inventory visibility?:** Required. Determines the outbound order line ID. / **Is the column used for Network map?:** Required. Determines the outbound order line ID. / **Is the column used for Inventory Insights?:** Required. Determines the outbound order line ID. / **Is the column used for Rebalance recommendations?:** Required. Determines the outbound order line ID. / **Is the column used for Lead time Insights?:** Not required - **Column:** expected\_ship\_date / **Is the column used for Inventory visibility?:** Required. Determines when the products exit the from\_site. / **Is the column used for Network map?:** Required. Determines when the products exit the from\_site. / **Is the column used for Inventory Insights?:** Required. Determines when the products exit the from\_site. / **Is the column used for Rebalance recommendations?:** Required. Determines when the products exit the from\_site. / **Is the column used for Lead time Insights?:** Not required - **Column:** actual\_ship\_date / **Is the column used for Inventory visibility?:** Optional. Determines the actual date when the product exits the from\_site. / **Is the column used for Network map?:** Optional. Determines the actual date when the product exits the from\_site. / **Is the column used for Inventory Insights?:** Optional. Determines the actual date when the product exits the from\_site. / **Is the column used for Rebalance recommendations?:** Optional. Determines the actual date when the product exits the from\_site. / **Is the column used for Lead time Insights?:** Not required - **Column:** shipped\_qty / **Is the column used for Inventory visibility?:** Required. Determines the quantity shipped from the from\_site. / **Is the column used for Network map?:** Required. Determines the quantity shipped from the from\_site. / **Is the column used for Inventory Insights?:** Required. Determines the quantity shipped from the from\_site. / **Is the column used for Rebalance recommendations?:** Required. Determines the quantity shipped from the from\_site. / **Is the column used for Lead time Insights?:** Not required - **Column:** cust\_shipment\_status / **Is the column used for Inventory visibility?:** Optional. Status of the shipment. For example, canceled, open, closed, and so on. / **Is the column used for Network map?:** Optional. Status of the shipment. For example, canceled, open, closed, and so on. / **Is the column used for Inventory Insights?:** Optional. Status of the shipment. For example, canceled, open, closed, and so on. / **Is the column used for Rebalance recommendations?:** Optional. Status of the shipment. For example, canceled, open, closed, and so on. / **Is the column used for Lead time Insights?:** Not required - **Column:** to\_site\_id / **Is the column used for Inventory visibility?:** Optional. Site where products should be shipped. / **Is the column used for Network map?:** Optional. Site where products should be shipped. / **Is the column used for Inventory Insights?:** Optional. Site where products should be shipped. / **Is the column used for Rebalance recommendations?:** Optional. Site where products should be shipped. / **Is the column used for Lead time Insights?:** Not required - **Column:** expected\_delivery\_date / **Is the column used for Inventory visibility?:** Optional / **Is the column used for Network map?:** Optional / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Not required - **Column:** actual\_delivery\_date / **Is the column used for Inventory visibility?:** Optional / **Is the column used for Network map?:** Optional / **Is the column used for Inventory Insights?:** Optional / **Is the column used for Rebalance recommendations?:** Optional / **Is the column used for Lead time Insights?:** Not required