CM_WC_PUTAW_CVW

(SQL View)
Index Back

Putaways not Complete

Real-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