CM_ITM_PERR_VW

(SQL View)
 Index Back

Item Master Average Cst View

11/02 mxs This view retrieves only retroactive average costed items. Used on Average Cost Adjustment panel (record cm_cost_adjrwrk). Created for release 8.8 .

SELECT B.SETID , A.BUSINESS_UNIT , E.CM_BOOK , A.INV_ITEM_ID , B.DESCR , E.DT_TIMESTAMP , E.SEQ_NBR , B.UNIT_MEASURE_STD , E.COST_ELEMENT , E.CM_UNIT_COST , A.QTY_OWNED , A.ITM_STATUS_CURRENT , E.CURRENCY_CD , A.AVERAGE_COST FROM PS_BU_ITEMS_INV A , PS_MASTER_ITEM_TBL B , PS_SET_CNTRL_REC C , PS_CM_ITEM_SFLG_VW D , PS_CM_PERRCUR_VW E WHERE A.ITM_STATUS_CURRENT IN ('1','2','3') AND A.INV_ITEM_ID = B.INV_ITEM_ID AND C.RECNAME = 'MASTER_ITEM_TBL' AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND B.SETID = C.SETID AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.INV_ITEM_ID = A.INV_ITEM_ID AND D.CM_PERRAVG_FLAG > 0 AND E.BUSINESS_UNIT = A.BUSINESS_UNIT AND E.INV_ITEM_ID = A.INV_ITEM_ID

  • Related Language Record: CM_ITM_AVG_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
    4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
    7 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    8 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
    9 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
    10 CM_UNIT_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0:
    11 QTY_OWNED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Owned
    12 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    14 AVERAGE_COST Number(15,4) DECIMAL(14,4) NOT NULL Average Purchase Price