CM_RHISTPERR_VW

(SQL View)
 Index Back

Resolved Neg Inv Hist-RetroAvg

02/04 8.9 joins to CM_PERRAVG_COST

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , A.CM_BOOK , 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.CM_DT_TIMESTAMP_P , A.CM_SEQ_NBR_P , A.STORAGE_AREA , A.INV_LOT_ID , A.SERIAL_ID , A.TRANSACTION_GROUP , A.PRODUCTION_ID , A.OP_SEQUENCE , A.CM_COST_PROC_GROUP , A.UNIT_MEASURE_STD , A.CONSIGNED_FLAG , A.TO_CONSIGNED_FLG , B.COST_ELEMENT , A.QTY_BASE , B.CM_UNIT_COST , %Round(%DecMult(A.QTY_BASE,B.CM_UNIT_COST),3) , A.PROCESS_INSTANCE FROM PS_CM_RESOLVE_HIST A , PS_CM_PERRAVG_COST 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.CM_DT_TIMESTAMP_P = B.DT_TIMESTAMP AND A.CM_SEQ_NBR_P = B.SEQ_NBR

# 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 CM_DT_TIMESTAMP_P DateTime(26) TIMESTAMP 07/99 GMG CN800-9.0:
11 CM_SEQ_NBR_P Number(15,0) DECIMAL(15) NOT NULL 07/99 GMG CN800-9.0:
12 STORAGE_AREA Character(5) VARCHAR2(5) NOT NULL Storage Area
13 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
14 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
15 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
16 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
17 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
18 CM_COST_PROC_GROUP Character(18) VARCHAR2(18) NOT NULL Cost Flow Record
19 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
20 CONSIGNED_FLAG Character(1) VARCHAR2(1) NOT NULL Consigned Flag
21 TO_CONSIGNED_FLG Character(1) VARCHAR2(1) NOT NULL To Consigned Flag
22 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
23 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
24 CM_UNIT_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0:
25 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
26 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance