CM_WC_PUTAW_CVW(SQL View) |
Index Back |
---|---|
Putaways not CompleteReal-time view of Putaways not Complete |
SELECT A.BUSINESS_UNIT , STAGING_ID , INV_LOT_ID , CONTAINER_ID , INV_ITEM_ID , SERIAL_ID , RECEIVER_ID , RECV_LN_NBR , STAGED_NUM , SOURCE_BUS_UNIT , RECV_SHIP_SEQ_NBR , DISTRIB_LINE_NUM , DISTRIB_SEQ_NUM , EOEN_PRCS_NAME , EOEN_CATEGORY , SEQ_NBR_EOEN , TRANS_SOURCE , BUSINESS_UNIT_IN , STAGED_STATUS , PUTAWAY_STATUS , PO_ID , PRODUCTION_ID , RMA_ID , QTY , MOVE_STAT_INV , PUTAWAY_STATE , IN_SDWC_HASH_KEY , EOEN_STATUS , ROWNBR , PUTAWAY_FLAG , B.OPRCLASS FROM PS_CM_WC_PUTAWY_VW A , PS_SEC_BU_CLS B , PS_SEC_BU_CLS C , PS_SEC_BU_CLS D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND SOURCE_BUS_UNIT = C.BUSINESS_UNIT AND BUSINESS_UNIT_IN = D.BUSINESS_UNIT AND B.OPRCLASS = C.OPRCLASS AND C.OPRCLASS = D.OPRCLASS |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUIN_NONVW |
2 | STAGING_ID | Number(15,0) | DECIMAL(15) NOT NULL | Putaway Staging ID |
3 | INV_LOT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Lot ID
Default Value: INSTALLATION_IN.DFLT_INV_LOT_ID |
4 | CONTAINER_ID | Character(10) | VARCHAR2(10) NOT NULL |
Container ID
Prompt Table: CNTR_ID_INV |
5 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: BU_ITM_INV_VW12 |
6 | SERIAL_ID | Character(20) | VARCHAR2(20) NOT NULL |
Serial ID
Default Value: INSTALLATION_IN.DFLT_SERIAL_ID |
7 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
8 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
9 | STAGED_NUM | Number(3,0) | SMALLINT NOT NULL |
Staged Number
Default Value: 1 |
10 | SOURCE_BUS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Source Bus Unit |
11 | RECV_SHIP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
12 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
13 | DISTRIB_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Sequence |
14 | EOEN_PRCS_NAME | Character(30) | VARCHAR2(30) NOT NULL | EOEN Process Name |
15 | EOEN_CATEGORY | Character(30) | VARCHAR2(30) NOT NULL | EOEN Category |
16 | SEQ_NBR_EOEN | Number(15,0) | DECIMAL(15) NOT NULL | EOEN Sequence Nbr |
17 | TRANS_SOURCE | Character(3) | VARCHAR2(3) NOT NULL |
Transaction Source
01=Purchasing 02=WIP Completion 03=Inventory 04=WIP Component 05=Adjustment 06=Component Kit Returns |
18 | BUSINESS_UNIT_IN | Character(5) | VARCHAR2(5) NOT NULL | Inventory Unit |
19 | STAGED_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Staged Status
01=InterUnit 02=Receipt |
20 | PUTAWAY_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Item Putaway Status
1=Not Assigned 2=Putaway Complete 3=In Error |
21 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
22 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
23 | RMA_ID | Character(10) | VARCHAR2(10) NOT NULL | RMA Number |
24 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
25 | MOVE_STAT_INV | Character(1) | VARCHAR2(1) NOT NULL |
MOVE_STAT_INV
M=Moved N=N/A P=Pending |
26 | PUTAWAY_STATE | Character(1) | VARCHAR2(1) NOT NULL |
Putaway State
1=Not Interfaced 2=Interfaced, Not Staged 3=Staged, Not Putaway 4=Putaway Complete |
27 | IN_SDWC_HASH_KEY | Character(60) | VARCHAR2(60) NOT NULL | Hash |
28 | EOEN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
EOEN Status
0=Open 1=Closed |
29 | ROWNBR | Number(7,0) | INTEGER NOT NULL | Row number |
30 | PUTAWAY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Item Putaway Flag
Y/N Table Edit |
31 | OPRCLASS | Character(30) | VARCHAR2(30) NOT NULL | Operator Class |