BUSINESS_UNIT_INSF_KANBAN_ID10=New
20=Open
30=Dispatched
40=In Process
50=Complete
60=Hold
70=Canceled
BCT_RPL_KRCV_VW(SQL View) |
Index Back |
|---|---|
Kanban Rcvng Kanban-idView |
| SELECT 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_SOURCE ='2' AND (SF_RPL_STATUS BETWEEN '20' AND '60') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_IN |
Character(5) | VARCHAR2(5) NOT NULL | Inventory 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 |