BUSINESS_UNITSF_KANBAN_ID10=New
20=Open
30=Dispatched
40=In Process
50=Complete
60=Hold
70=Canceled
BCT_KANBAN_VW(SQL View) |
Index Back |
|---|---|
Inventory Open Kanban ViewView of all Kanban records that are marked with a source of 'Inventory' and a status of 'Open' or 'Dispatched' |
| SELECT BUSINESS_UNIT , SF_KANBAN_ID , INV_ITEM_ID , SF_RPL_STOR_AREA , SF_RPL_STOR_LEV1 , SF_RPL_STOR_LEV2 , SF_RPL_STOR_LEV3 , SF_RPL_STOR_LEV4 , STORAGE_AREA , STOR_LEVEL_1 , STOR_LEVEL_2 , STOR_LEVEL_3 , STOR_LEVEL_4 , SF_RPL_TRANS_QTY , SF_RPL_STATUS FROM PS_SF_WIP_RPL_REQ |
| # | 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 | STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
| 5 | STOR_LEVEL_1 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 1 |
| 6 | STOR_LEVEL_2 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 2 |
| 7 | STOR_LEVEL_3 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 3 |
| 8 | STOR_LEVEL_4 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 4 |
| 9 | TO_STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL | Storage Area |
| 10 | TO_STOR_LEVEL_1 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 1 |
| 11 | TO_STOR_LEVEL_2 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 2 |
| 12 | TO_STOR_LEVEL_3 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 3 |
| 13 | TO_STOR_LEVEL_4 | Character(4) | VARCHAR2(4) NOT NULL | Storage Level 4 |
| 14 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
| 15 | 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 |