CM_RTVADJD_VW

(SQL View)
 Index Back

Receipt Variances Temp

04/99 GMG CN800-9.0; Created.

SELECT BUSINESS_UNIT , INV_ITEM_ID , CM_BOOK , DT_TIMESTAMP , SEQ_NBR , CM_DT_TIMESTAMP , CM_SEQ_NBR , CM_DT_TIMESTAMP_A , CM_SEQ_NBR_A , COST_ELEMENT , MAX(CM_SEQ_COST) , SUM(CM_UNIT_COST) , SUM(CM_UNIT_COST_PO) , SUM(CM_UNIT_COST_POVO) , SUM(CM_UNIT_COST_VO) , SUM(CM_UNIT_COST_STD) , SUM(CM_UNIT_COST_VSUM) FROM PS_CM_RTVADJD_TMP GROUP BY BUSINESS_UNIT , INV_ITEM_ID , CM_BOOK , DT_TIMESTAMP , SEQ_NBR , CM_DT_TIMESTAMP , CM_SEQ_NBR , CM_DT_TIMESTAMP_A , CM_SEQ_NBR_A , COST_ELEMENT

# 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 DateTime(26) TIMESTAMP Receipt dttm.
7 CM_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
8 CM_DT_TIMESTAMP_A DateTime(26) TIMESTAMP 07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.
9 CM_SEQ_NBR_A Number(15,0) DECIMAL(15) NOT NULL 07/99 GMG CN800-9.0:
10 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
11 CM_SEQ_COST Number(15,0) DECIMAL(15) NOT NULL Cost Sequence Number. Incremented each time the actual cost is updated.
12 CM_UNIT_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0:
13 CM_UNIT_COST_PO Signed Number(32,15) DECIMAL(30,15) NOT NULL 07/99 GMG CN800-9.0:
14 CM_UNIT_COST_POVO Signed Number(32,15) DECIMAL(30,15) NOT NULL 07/99 GMG CN800-9.0:
15 CM_UNIT_COST_VO Signed Number(32,15) DECIMAL(30,15) NOT NULL 07/99 GMG CN800-9.0:
16 CM_UNIT_COST_STD Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0:
17 CM_UNIT_COST_VSUM Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0: