CM_COST_REQ

(SQL Table)
 Index Back

Transaction Costing Request

07/99 GMG CN800-9.0:

  • Related Language Record: CM_COST_REQ_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Request ID
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

    Prompt Table: SP_BUIN_NONVW

    6 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book

    Prompt Table: CM_BU_BOOK_VW1

    7 CM_COST_RUN_MODE Character(1) VARCHAR2(1) NOT NULL Costing Run Mode
    0=Conversion
    1=Regular
    2=Mid Period
    3=Simulate
    4=Resimulate
    5=Make Live
    8 CM_COST_MODE Character(1) VARCHAR2(1) NOT NULL 07/99 GMG CN800-9.0:
    L=Live
    S=Simulated
    9 CM_COMMIT_LIMIT Number(10,0) DECIMAL(10) NOT NULL Commit Limit
    10 RUN_PPV Character(1) VARCHAR2(1) NOT NULL Apply Perpetual Average Adjs

    Y/N Table Edit

    11 AS_OF_DATE Date(10) DATE NOT NULL As of Date

    Default Value: %date

    12 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
    A=Always Process
    N=Don't Run
    O=Process Once

    Default Value: N

    13 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
    A=Active
    C=Successfully Completed
    E=Completed With Errors
    N=Not Yet Processed
    P=Processing Now
    X=No Success

    Default Value: N

    14 PROCESS_ORIG Character(1) VARCHAR2(1) NOT NULL Process Origin
    N=Other Source
    P=Process Scheduler

    Default Value: N

    15 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    16 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    17 DT_TIMESTAMP DateTime(26) TIMESTAMP Date Timestamp
    18 CM_UPDATE_STATS Character(1) VARCHAR2(1) NOT NULL Generate Table Statistics

    Y/N Table Edit

    Default Value: N

    19 CM_UPDATE_STATS_DE Character(1) VARCHAR2(1) NOT NULL 11/01 mxs

    Y/N Table Edit

    Default Value: Y

    20 CE_LOOP Character(1) VARCHAR2(1) NOT NULL Calculate Actual Prdn Costs

    Y/N Table Edit

    Default Value: N