CM_RECEIPT_COST

(SQL Table)
 Index Back

Receipts Costs

04/99 GMG CN800-9.0; Created 08/10/01 DMW : R-CMORSE-DQ7K6 / R-MSUBBA-3F5MV Performance Enhancement - add posted_flag index A

  • Parent record: CM_RECEIPTS

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