CM_ACTCOSTB_TMP

(SQL Table)
 Index Back

Actual Costs by Book

  • 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 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 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
    6 CM_SEQ_COST Number(15,0) DECIMAL(15) NOT NULL Cost Sequence Number. Incremented each time the actual cost is updated.
    7 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
    8 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
    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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    15 CM_DTTM_IN_EFFECT DateTime(26) TIMESTAMP Date Timestamp
    16 CM_DTTM_STAMP DateTime(26) TIMESTAMP Date Timestamp
    17 CM_ADJ_TYPE Character(1) VARCHAR2(1) NOT NULL 07/99 GMG CN800-9.0:
    0=Original Cost
    1=Cost Adjustment
    2=Value Adjustment
    18 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
    19 CM_UNIT_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0:
    20 CM_UNIT_COST_PO Signed Number(32,15) DECIMAL(30,15) NOT NULL 07/99 GMG CN800-9.0:
    21 CM_UNIT_COST_POVO Signed Number(32,15) DECIMAL(30,15) NOT NULL 07/99 GMG CN800-9.0:
    22 CM_UNIT_COST_VO Signed Number(32,15) DECIMAL(30,15) NOT NULL 07/99 GMG CN800-9.0:
    23 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    24 CM_PERR_POSTED_FLG Character(1) VARCHAR2(1) NOT NULL RetroActive Per Avg Posted Flg

    Default Value: N

    25 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    26 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

    Default Value: X