N-Tier Visibility

The table below list the data entities and columns used by N-Tier Visibility.

Note

How to read the table:

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

Data entity	Column	Is the column used by N-Tier Visibility?
trading_partner	id	Required
	description	Required
	company_id	Optional
	tpartner_type	Required – When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.
	geo_id	Required – When you ingest data from SAP or EDI, the default value for string is SCN_RESERVED_NO_VALUE_PROVIDED. When you upload data using the Amazon S3 connector, you must enter a value or use SCN_RESERVED_NO_VALUE_PROVIDED for successful ingestion.
	eff_end_date	Required – You must enter a value for eff_start_date and eff_end_date. If you don't have a value, enter `1900-01-01 00:00:00` for eff_start_date, and `9999-12-31 23:59:59` for eff_end_date.
	eff_start_date	Required – You must enter a value for eff_start_date and eff_end_date. If you don't have a value, enter `1900-01-01 00:00:00` for eff_start_date, and `9999-12-31 23:59:59` for eff_end_date.
trading_partner_poc	tpartner_id	Required
trading_partner_poc	email	Required
product	id	Required – Data entity is optional but id is used to generate Partner Network View.
product_hierarchy	id
site	id
sourcing_rules	sourcing_rule_id	Required – Data entity is optional but sourcing_rule_id is used to generate Partner Network View.
supply_plan	supply_plan_id	Required
	snapshot_date	Optional
	creation_date	Optional
	tpartner_id	Required
	product_id	Required
	to_site_id	Required
	from_site_id	Optional
	plan_quantity	Required
	plan_type	Required
	plan_need_by_date	Required
	quantity_uom	Optional

Warning Javascript is disabled or is unavailable in your browser.

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

Document Conventions

Sustainability

Supply Planning