IN_SDWCPU1_NONV

(SQL View)
 Index Back

Putaways not Complete

Real-time view of Putaways not Complete

SELECT B.BUSINESS_UNIT_IN , 0 , ' ' , ' ' , A.INV_ITEM_ID , ' ' , A.RECEIVER_ID , A.RECV_LN_NBR , 0 , B.BUSINESS_UNIT , A.RECV_SHIP_SEQ_NBR , B.DISTRIB_LINE_NUM , 0 , 'IN_SDWC_NOT_PUTAWAY' , 'SUP_DMD_ALERTS' , 0 , '01' , B.BUSINESS_UNIT_IN , ' ' , ' ' , B.PO_ID , ' ' , A.RMA_ID , B.QTY_DS_ACCPT_SUOM , A.MOVE_STAT_INV , '1' , A.BUSINESS_UNIT %Concat '~' %Concat A.RECEIVER_ID %Concat '~' %Concat %NumToChar(A.RECV_LN_NBR) %Concat '~' %Concat %NumToChar(A.RECV_SHIP_SEQ_NBR) , '0' , 0 FROM PS_RECV_LN_SHIP A , PS_RECV_LN_DISTRIB B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RECEIVER_ID = B.RECEIVER_ID AND A.RECV_LN_NBR = B.RECV_LN_NBR AND A.RECV_SHIP_SEQ_NBR = B.RECV_SHIP_SEQ_NBR AND A.MOVE_STAT_INV = 'P' AND A.RECV_SHIP_STATUS <> 'X' UNION SELECT C.BUSINESS_UNIT , 0 , C.INV_LOT_ID , C.CONTAINER_ID , C.INV_ITEM_ID , C.SERIAL_ID , C.RECEIVER_ID , C.RECV_LN_NBR , C.SEQ_NUM , CASE WHEN C.SOURCE_BUS_UNIT = ' ' THEN C.BUSINESS_UNIT ELSE C.SOURCE_BUS_UNIT END , C.RECV_SHIP_SEQ_NBR , C.DISTRIB_LINE_NUM , C.DISTRIB_SEQ_NUM , 'IN_SDWC_NOT_PUTAWAY' , 'SUP_DMD_ALERTS' , 0 , C.TRANS_SOURCE , C.BUSINESS_UNIT , C.STAGED_STATUS , ' ' , C.PO_ID , C.PRODUCTION_ID , C.RMA_ID , C.QTY , ' ' , '2' , C.BUSINESS_UNIT %Concat '~' %Concat C.INV_LOT_ID %Concat '~' %Concat C.CONTAINER_ID %Concat '~' %Concat C.INV_ITEM_ID %Concat '~' %Concat C.SERIAL_ID %Concat '~' %Concat C.RECEIVER_ID %Concat '~' %Concat %NumToChar(C.RECV_LN_NBR) %Concat '~' %Concat %NumToChar(C.SEQ_NUM) %Concat '~' %Concat C.SOURCE_BUS_UNIT %Concat '~' %Concat %NumToChar(C.RECV_SHIP_SEQ_NBR) %Concat '~' %Concat %NumToChar(C.DISTRIB_LINE_NUM) %Concat '~' %Concat %NumToChar(C.DISTRIB_SEQ_NUM) , '0' , 0 FROM PS_STAGED_INF_INV C UNION SELECT D.BUSINESS_UNIT , D.STAGING_ID , D.INV_LOT_ID , D.CONTAINER_ID , D.INV_ITEM_ID , D.SERIAL_ID , D.RECEIVER_ID , D.RECV_LN_NBR , D.STAGED_NUM , CASE WHEN D.TRANS_SOURCE = '02' THEN D.BUSINESS_UNIT ELSE D.SOURCE_BUS_UNIT END , D.RECV_SHIP_SEQ_NBR , D.DISTRIB_LINE_NUM , D.DISTRIB_SEQ_NUM , 'IN_SDWC_NOT_PUTAWAY' , 'SUP_DMD_ALERTS' , 0 , D.TRANS_SOURCE , D.BUSINESS_UNIT , ' ' , D.PUTAWAY_STATUS , D.PO_ID , D.PRODUCTION_ID , D.RMA_ID , D.QTY , ' ' , '3' , D.BUSINESS_UNIT %Concat '~' %Concat %NumToChar(D.STAGING_ID) %Concat '~'%Concat D.INV_LOT_ID %Concat '~' %Concat D.CONTAINER_ID %Concat '~' %Concat D.INV_ITEM_ID %Concat '~' %Concat D.SERIAL_ID %Concat '~' %Concat D.RECEIVER_ID %Concat '~' %Concat %NumToChar(D.RECV_LN_NBR) %Concat '~' %Concat %NumToChar(D.STAGED_NUM) %Concat '~' %Concat D.SOURCE_BUS_UNIT %Concat '~' %Concat %NumToChar(D.RECV_SHIP_SEQ_NBR) %Concat '~' %Concat %NumToChar(D.DISTRIB_LINE_NUM) %Concat '~' %Concat %NumToChar(D.DISTRIB_SEQ_NUM) , '0' , 0 FROM PS_STAGED_ITEM_INV D

# 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