07/99 GMG CN800-9.0: Actual Costs rows that have been Receipt Costed

CM_ACTCOSTED_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.DT_TIMESTAMP , A.SEQ_NBR , A.COST_ELEMENT , A.CM_SEQ_COST , B.CM_BOOK , A.CM_DTTM_IN_EFFECT , A.CM_DTTM_STAMP , A.EFF_STATUS , A.CM_ADJ_TYPE , A.CURRENCY_CD FROM PS_CM_ACTUAL_COSTB A , PS_CM_BU_BOOK_TBL B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.CM_BOOK = B.CM_BOOK AND A.EFF_STATUS = 'A' AND B.CM_BOOK_STATUS = 'A' AND A.DT_TIMESTAMP > B.CM_BOOK_START AND EXISTS ( SELECT 'X' FROM PS_CM_RECEIPT_COST C WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.INV_ITEM_ID = C.INV_ITEM_ID AND A.CM_BOOK = C.CM_BOOK AND A.DT_TIMESTAMP = C.DT_TIMESTAMP AND A.SEQ_NBR = C.SEQ_NBR AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.CM_BOOK = C.CM_BOOK)

# 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 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
5 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
6 CM_SEQ_COST Number(15,0) DECIMAL(15) NOT NULL Cost Sequence Number. Incremented each time the actual cost is updated.
7 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
8 CM_DTTM_IN_EFFECT DateTime(26) TIMESTAMP Date Timestamp
9 CM_DTTM_STAMP DateTime(26) TIMESTAMP Date Timestamp
10 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
11 CM_ADJ_TYPE Character(1) VARCHAR2(1) NOT NULL 07/99 GMG CN800-9.0:
0=Original Cost
1=Cost Adjustment
2=Value Adjustment
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code