CM_ONHAND_VW

(SQL View)
 Index Back

On Hand Qty

04/99 GMG CN800-9.0 Created On Hand Quantities Based on Receipt Quantity Less Deplete Quantity

SELECT B.BUSINESS_UNIT , B.INV_ITEM_ID , B.CM_BOOK , B.CM_DT_TIMESTAMP , B.CM_SEQ_NBR , A.CM_DT_TIMESTAMP_A , A.CM_SEQ_NBR_A , A.CM_ORIG_TRANS_DATE , A.CONSIGNED_FLAG , A.STORAGE_AREA , A.INV_LOT_ID , A.SERIAL_ID , A.PRODUCTION_ID , A.TRANSACTION_GROUP , A.QTY_BASE , SUM(B.QTY_BASE) , A.QTY_BASE - SUM(B.QTY_BASE) FROM PS_CM_RECEIPTS A , PS_CM_DEPLETE B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INV_ITEM_ID = B.INV_ITEM_ID AND A.CM_BOOK = B.CM_BOOK AND A.DT_TIMESTAMP = B.CM_DT_TIMESTAMP AND A.SEQ_NBR = B.CM_SEQ_NBR AND A.CM_DT_TIMESTAMP_A = B.CM_DT_TIMESTAMP_A AND A.CM_SEQ_NBR_A = B.CM_SEQ_NBR_A GROUP BY B.BUSINESS_UNIT, B.INV_ITEM_ID, B.CM_BOOK, B.CM_DT_TIMESTAMP, B.CM_SEQ_NBR, A.CM_DT_TIMESTAMP_A , A.CM_SEQ_NBR_A, A.CM_ORIG_TRANS_DATE, A.CONSIGNED_FLAG, A.STORAGE_AREA, A.INV_LOT_ID, A.SERIAL_ID, A.PRODUCTION_ID, A.TRANSACTION_GROUP, A.QTY_BASE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
4 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
6 CM_DT_TIMESTAMP_A DateTime(26) TIMESTAMP 07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.
7 CM_SEQ_NBR_A Number(15,0) DECIMAL(15) NOT NULL 07/99 GMG CN800-9.0:
8 CM_ORIG_TRANS_DATE Date(10) DATE 07/99 GMG CN800-9.0:
9 CONSIGNED_FLAG Character(1) VARCHAR2(1) NOT NULL Consigned Flag
10 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
11 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
12 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
13 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
14 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
15 CM_RECEIPT_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 07/99 GMG CN800-9.0:
16 CM_DEPLETE_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity Depleted
17 CM_ONHAND_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL 08/30/99 RML Changed from "onhand" to "on hand"