SETIDSHIP_TO_CUST_IDBUSINESS_UNIT_INSP_DS_BU_NONVW(SQL View) |
Index Back |
|---|---|
Ship From IBU HierarchyThis 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. Date Initials Issue Description 022202 dms 11697201 New view for row level security |
| SELECT c.setid , c.cust_id , d.business_unit_in , c.ds_network_code , d.priority_nbr FROM ps_set_cntrl_rec sc , ps_ds_netdet_tbl d , PS_BUS_UNIT_TBL_IN a , ps_bus_unit_tbl_fs b , ps_cust_shipto_opt c WHERE sc.recname = 'DS_NETHDR_TBL' AND sc.setcntrlvalue = c.setid AND d.setid = sc.setid AND d.ds_network_code = c.ds_network_code AND a.business_unit = b.business_unit AND a.bu_status = '1' AND d.business_unit_in = a.business_unit AND %EffdtCheck(CUST_SHIPTO_OPT, C, %CurrentDateIn) AND c.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | SHIP_TO_CUST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Ship To Customer |
| 3 | BUSINESS_UNIT_IN |
Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
| 4 | DS_NETWORK_CODE | Character(6) | VARCHAR2(6) NOT NULL | Distribution Network Code |
| 5 | PRIORITY_NBR | Number(3,0) | SMALLINT NOT NULL | Priority |