Global_inventory_relationships

Columns

Name	Type	Length	Precision	Scale	References	In	Description
date_created	TIMESTAMP						Date created
date_last_modified	TIMESTAMP						Date last modified
global_invt_relationship_extid	VARCHAR2	255					Global inventory relationship external ID
global_invt_relationship_id	NUMBER		39	0			Global inventory relationship ID
inventory_subsidiary_id	NUMBER		39	0	subsidiary_id	Subsidiaries	Inventory subsidiary ID
is_all_locations_cust_return	VARCHAR2	3					Is all locations customer return
is_all_locations_fulfillment	VARCHAR2	3					Is all locations fulfillment
is_allow_cross_sub_cust_return	VARCHAR2	3					Is allow cross-subsidiary customer return
is_allow_cross_sub_fulfillment	VARCHAR2	3					Is allow cross-subsidiary fulfillment
is_inactive	VARCHAR2	3					Is inactive
originating_subsidiary_id	NUMBER		39	0	subsidiary_id	Subsidiaries	Originating subsidiary ID

Primary key

PK Column Name
global_invt_relationship_id

Foreign keys in this table

FK Name	FK Column Name	PK Table Name	PK Column Name	Key Seq
global_inventory_relationships_invt_subsidiaries_fk	inventory_subsidiary_id	Subsidiaries	subsidiary_id	1
global_inventory_relationships_orig_subsidiaries_fk	originating_subsidiary_id	Subsidiaries	subsidiary_id	1