BUSINESS_UNITSF_KANBAN_ID10=New
20=Open
30=Dispatched
40=In Process
50=Complete
60=Hold
70=Canceled
SF_RPL_KANBN_VW(SQL View) |
Index Back |
|---|---|
SF Repl Kanban ID View |
| SELECT DISTINCT business_unit , sf_kanban_id , inv_item_id , sf_rpl_status , storage_area , stor_level_1 , stor_level_2 , stor_level_3 , stor_level_4 FROM PS_SF_WIP_RPL_REQ WHERE sf_rpl_status IN ('10','20') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SF_KANBAN_ID |
Character(15) | VARCHAR2(15) NOT NULL | Kanban ID |
| 3 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | SF_RPL_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
WIP Replenishment Status
10=New 20=Open 30=Dispatched 40=In Process 50=Complete 60=Hold 70=Canceled |
| 5 | STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
| 6 | STOR_LEVEL_1 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 1 |
| 7 | STOR_LEVEL_2 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 2 |
| 8 | STOR_LEVEL_3 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 3 |
| 9 | STOR_LEVEL_4 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 4 |