ORD_DSNET_NONVW (SQL View)	Index Back
Ship From IBU Hierarchy This child table to the DS_NETHDR_TBL stores the warehouses (Inventory Business Units - IBU) in the order of priority. Material would be supplied from the first IBU in this list, and if not available, the processing would take the next IBU into consideration.

ORD_DSNET_NONVW

(SQL View)

Ship From IBU Hierarchy

This child table to the DS_NETHDR_TBL stores the warehouses (Inventory Business Units - IBU) in the order of priority. Material would be supplied from the first IBU in this list, and if not available, the processing would take the next IBU into consideration.

select setid, ds_network_code, priority_nbr, business_unit_in from PS_DS_NETDET_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 DS_NETWORK_CODE Character(6) VARCHAR2(6) NOT NULL Distribution Network Code

3 PRIORITY_NBR Number(3,0) SMALLINT NOT NULL Priority

4 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	DS_NETWORK_CODE	Character(6)	VARCHAR2(6) NOT NULL	Distribution Network Code
3	PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority
4	BUSINESS_UNIT_IN	Character(5)	VARCHAR2(5) NOT NULL	Inventory Unit