CM_ACTCSTB_TEO1

(SQL Table)
Index Back

CCU TEO temp table

CCU temporary table for CM_ACTUAL_COSTB

  • Parent record: CM_ACTUAL_COST
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EO_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    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 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
    9 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
    10 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
    11 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
    12 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
    13 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
    14 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
    15 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    16 CM_DTTM_IN_EFFECT DateTime(26) TIMESTAMP Date Timestamp
    17 CM_DTTM_STAMP DateTime(26) TIMESTAMP Date Timestamp
    18 CM_ADJ_TYPE Character(1) VARCHAR2(1) NOT NULL 07/99 GMG CN800-9.0:
    0=Original Cost
    1=Cost Adjustment
    2=Value Adjustment
    19 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
    20 CM_UNIT_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0:
    21 CM_UNIT_COST_PO Signed Number(32,15) DECIMAL(30,15) NOT NULL 07/99 GMG CN800-9.0:
    22 CM_UNIT_COST_POVO Signed Number(32,15) DECIMAL(30,15) NOT NULL 07/99 GMG CN800-9.0:
    23 CM_UNIT_COST_VO Signed Number(32,15) DECIMAL(30,15) NOT NULL 07/99 GMG CN800-9.0:
    24 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    25 CM_PERR_POSTED_FLG Character(1) VARCHAR2(1) NOT NULL RetroActive Per Avg Posted Flg

    Default Value: N

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

    28 EO_FROM_CURRENCY Character(3) VARCHAR2(3) NOT NULL Currency Code