CM_CONS_AVGU_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.CM_BOOK , A.INV_ITEM_ID , A.COST_ELEMENT , A.DT_TIMESTAMP , A.SEQ_NBR , A.CM_DT_TIMESTAMP , A.CM_SEQ_NBR , A.CM_DT_TIMESTAMP_A , A.CM_SEQ_NBR_A , A.TRANSACTION_GROUP , A.POSTED_FLAG , A.QTY_BASE , A.CM_UNIT_COST FROM PS_CM_DEPLETE_COST 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.DT_TIMESTAMP AND A.SEQ_NBR = B.SEQ_NBR AND A.CM_DT_TIMESTAMP_A = B.CM_DT_TIMESTAMP_A AND A.CM_SEQ_NBR_A = B.CM_SEQ_NBR_A AND A.TRANSACTION_GROUP = B.TRANSACTION_GROUP AND A.TRANSACTION_GROUP = '060' AND B.CONSIGNED_FLAG = 'Y' AND B.TO_CONSIGNED_FLG = 'N' AND A.POSTED_FLAG IN ('N','A') AND B.POSTED_FLAG = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
5 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
6 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
7 CM_DT_TIMESTAMP DateTime(26) TIMESTAMP Receipt dttm.
8 CM_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
9 CM_DT_TIMESTAMP_A DateTime(26) TIMESTAMP 07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.
10 CM_SEQ_NBR_A Number(15,0) DECIMAL(15) NOT NULL 07/99 GMG CN800-9.0:
11 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
12 POSTED_FLAG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program.
N=Not Posted
X=Don't Post
Y=Posted
13 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
14 CM_UNIT_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0: