CM_PERRAVG_TMPK

(SQL Table)
 Index Back

Actual Costs by Book

WRG: ADDED KEYS production_id op_sequence process_instance

  • Parent record: CM_ACTUAL_COST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
    3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    4 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
    5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    6 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
    7 CM_SEQ_COST Number(15,0) DECIMAL(15) NOT NULL Cost Sequence Number. Incremented each time the actual cost is updated.
    8 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
    9 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    10 CM_COST_SOURCE Character(1) VARCHAR2(1) NOT NULL 12/29/2005 dbe ICE 1379942000 - Added "U" Xlat.
    0=Depletion
    1=PO Receipt
    2=Expr Ptway
    3=IUTransfer
    4=AP Matched
    5=User Adj
    6=Qty Adjs.
    7=Bin to Bin
    8=Prelim Cst
    9=Prdn Compl
    C=NegQty
    R=Return
    S=Split from
    U=75 Upgrade
    11 CM_UNIT_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0:
    12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    13 POSTED_FLAG Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a Receivables item has been posted. This field is automatically updated by the Receivables Update program.
    N=Not Posted
    X=Don't Post
    Y=Posted