CM_ACTUAL_COST

(SQL Table)
 Index Back

Actual Costs

04/99 GMG CN800-9.0; Created to hold the actual cost of putaways.

  • Parent Record Of CE_ACTB_SEQT CE_ACTB_VW CM_ACTB_VW CM_ACTB_VW2 CM_ACTCOSTBP_VW CM_ACTCOSTB_TMP CM_ACTCSTB_TEO1 CM_ACTCSTB_TEO2 CM_ACTCSTB_TEO3 CM_ACTUAL_COSTB CM_ACT_COSTB_VW CM_ACT_COST_T CM_AVG_RCST_T CM_DFLT_AVG_T CM_PERRAVG_TK CM_PERRAVG_TMPK

    • # 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 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
    8 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
    9 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
    10 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
    11 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
    12 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    13 CM_DTTM_IN_EFFECT DateTime(26) TIMESTAMP Date Timestamp
    14 CM_DTTM_STAMP DateTime(26) TIMESTAMP Date Timestamp
    15 CM_ADJ_TYPE Character(1) VARCHAR2(1) NOT NULL 07/99 GMG CN800-9.0:
    0=Original Cost
    1=Cost Adjustment
    2=Value Adjustment
    16 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
    17 CM_UNIT_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0:
    18 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    19 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    20 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: N