CM_DEPLETE_COST

(SQL Table)
 Index Back

Depleted Depletion Costs

04/99 GMG CN800-9.0; Created. Notes: + cm_dt_timestamp and seq_nbr fields join to the depletion transaction originating in transaction_inv. + cm_dt_timestamp and cm_seq_nbr fields join to the receipt keys dt_timestamp and seq_nbr. + cm_dt_timestamp_a and cm_seq_nbr_a join to the receipt keys and to the actual cost. + cm_seq_cost is a key to handle cost adjustments. The delta creates another row with a unique cm_seq_cost. 08/10/01 DMW : R-CMORSE-DQ7K6 / R-MSUBBA-3F5MV Performance Enhancement - add posted_flag index A

  • Parent record: CM_DEPLETE

    • # 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 CM_BOOK Character(10) VARCHAR2(10) NOT NULL Cost Book
    4 DT_TIMESTAMP DateTime(26) TIMESTAMP NOT NULL Date Timestamp
    5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    6 CM_DT_TIMESTAMP DateTime(26) TIMESTAMP NOT NULL Receipt dttm.
    7 CM_SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    8 CM_DT_TIMESTAMP_A DateTime(26) TIMESTAMP NOT NULL 07/99 GMG CN800-9.0: Original putaway dttm when bin-to-bin'd.
    9 CM_SEQ_NBR_A Number(15,0) DECIMAL(15) NOT NULL 07/99 GMG CN800-9.0:
    10 COST_ELEMENT Character(4) VARCHAR2(4) NOT NULL Cost Element
    11 CM_SEQ_COST Number(15,0) DECIMAL(15) NOT NULL Cost Sequence Number. Incremented each time the actual cost is updated.
    12 CM_DT_TIMESTAMP_P DateTime(26) TIMESTAMP 07/99 GMG CN800-9.0:
    13 CM_SEQ_NBR_P Number(15,0) DECIMAL(15) NOT NULL 07/99 GMG CN800-9.0:
    14 TRANSACTION_GROUP Character(3) VARCHAR2(3) NOT NULL 11/7/02 LLR - Added the new (600's) transactions groups for 8.8.
    15 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID
    16 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
    17 CONSIGNED_FLAG Character(1) VARCHAR2(1) NOT NULL Consigned Flag
    18 EFFDT Date(10) DATE Effective Date
    19 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator
    20 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity
    21 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
    22 CM_UNIT_COST Signed Number(27,15) DECIMAL(25,15) NOT NULL 07/99 GMG CN800-9.0:
    23 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    24 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
    25 CM_COST_MODE Character(1) VARCHAR2(1) NOT NULL 07/99 GMG CN800-9.0:
    L=Live
    S=Simulated
    26 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    27 PROCESS_FLAG Character(1) VARCHAR2(1) NOT NULL Process Flag
    A=Purge All
    S=Only purge items with at least
    28 CE_POSTED_FLAG Character(1) VARCHAR2(1) NOT NULL Posted
    6=Cost for 661
    N=Cost Pending Calculation
    Y=Cost Calculated
    29 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