CM_ACTCSTB_H_VW

(SQL View)
 Index Back

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

# 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_SEQ_COST Number(15,0) DECIMAL(15) NOT NULL Cost Sequence Number. Incremented each time the actual cost is updated.
6 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
7 CM_ADJ_TYPE Character(1) VARCHAR2(1) NOT NULL 07/99 GMG CN800-9.0:
0=Original Cost
1=Cost Adjustment
2=Value Adjustment
8 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
9 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
10 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
11 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
12 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
13 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
14 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit