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
	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