SETIDBUSINESS_UNITBUSINESS_UNIT_INORDENT_DOMBU_VW(SQL View) |
Index Back |
|---|---|
ORDENT_DOMBU_VWNew for the aprd (R-KALBRI-437TL. |
| SELECT Sc.setid , c.BUSINESS_UNIT , 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_BUS_UNIT_TBL_OM c WHERE sc.recname = 'DS_NETHDR_TBL' AND sc.setcntrlvalue = c.BUSINESS_UNIT 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 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 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 |