ORD_DSNET_CLSVW

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

SELECT cls.oprclass , n.setid , n.ds_network_code , n.priority_nbr , n.business_unit_in FROM ps_ds_netdet_tbl n , PS_SEC_BU_CLS cls WHERE cls.business_unit = n.business_unit_in

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