CM_ACTUAL_H_VW

(SQL View)
 Index Back

PO & AP Matched Row View

07/99 GMG CN800-9.0:

SELECT BUSINESS_UNIT , INV_ITEM_ID , DT_TIMESTAMP , SEQ_NBR , CM_BOOK , BUSINESS_UNIT_RECV , RECEIVER_ID , RECV_LN_NBR , RECV_SHIP_SEQ_NBR , DISTRIB_LINE_NUM , MIN(COST_ELEMENT) FROM PS_CM_ACTUAL_COSTB WHERE EFF_STATUS = 'A' AND CM_ADJ_TYPE IN ('0','1') AND CM_COST_SOURCE IN ('1','4','U') GROUP BY BUSINESS_UNIT ,INV_ITEM_ID , DT_TIMESTAMP , SEQ_NBR , CM_BOOK , BUSINESS_UNIT_RECV, RECEIVER_ID , RECV_LN_NBR , RECV_SHIP_SEQ_NBR , DISTRIB_LINE_NUM

# 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 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
6 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
7 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
8 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
9 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
10 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
11 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element