MASTER_ITEM_TBL

(SQL Table)
 Index Back

Item Master Header Table

This is the inventory item master table. It is used by the RF_ITEM_DEFN component to define and/or maintain inventory items. The record includes descriptions, a status and various classifications. Items are used primarily by the Service component to define material resources associated with a service and by FieldService engineers in the Manage Material component to order and record usage or removal of items from a customer site.

  • Related Language Record: MASTER_ITM_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    3 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 INV_ITEM_GROUP Character(15) VARCHAR2(15) NOT NULL Item Group

    Prompt Table: INV_ITEM_GROUP

    7 INV_PROD_FAM_CD Character(10) VARCHAR2(10) NOT NULL Family

    Prompt Table: INV_ITEM_FAM

    8 ITM_STATUS_EFFDT Date(10) DATE Item Status Date

    Default Value: %DATE

    9 ITM_STATUS_CURRENT Character(1) VARCHAR2(1) NOT NULL Item Status Current
    1=Active
    2=Hold
    3=Discontinue
    4=Inactive
    5=Pending Approval
    6=Denied Approval
    7=Under Initialization

    Default Value: 7

    10 ITM_STAT_DT_FUTURE Date(10) DATE Item Date Future
    11 ITM_STATUS_FUTURE Character(1) VARCHAR2(1) NOT NULL Item Status Future
    1=Active
    2=Hold
    3=Discontinue
    4=Inactive
    12 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Used to store the unit of measure for an item.

    Prompt Table: UNITS_TBL

    13 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control

    Y/N Table Edit

    Default Value: N

    14 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control

    Y/N Table Edit

    Default Value: N

    15 SHIP_SERIAL_CNTRL Character(1) VARCHAR2(1) NOT NULL Shipping Serial Control

    Y/N Table Edit

    Default Value: N

    16 NON_OWN_FLAG Character(1) VARCHAR2(1) NOT NULL 07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o

    Y/N Table Edit

    Default Value: N

    17 CONSIGNED_FLAG Character(1) VARCHAR2(1) NOT NULL Indicates if the item is consigned.

    Y/N Table Edit

    Default Value: N

    18 INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL Inventory Item

    Y/N Table Edit

    Default Value: Y

    19 SERVICEABLE_FLG Character(1) VARCHAR2(1) NOT NULL Flag to indicate if the item is serviceable or not.
    N=Non-serviceable
    Y=Serviceable

    Default Value: N

    20 RETURNABLE_FLG Character(1) VARCHAR2(1) NOT NULL Flag indicating if an item is returnable.
    N=Non-returnable
    Y=Returnable

    Default Value: N

    21 CONSUMABLE_FLG Character(1) VARCHAR2(1) NOT NULL Indicates if the item is consumable.
    N=Non-consumable
    Y=Consumable

    Default Value: N

    22 HAZ_CLASS_CD Character(4) VARCHAR2(4) NOT NULL Hazard Code
    23 INTL_HAZARD_ID Character(15) VARCHAR2(15) NOT NULL Intl Hazard ID
    24 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

    Prompt Table: CURRENCY_CD_TBL

    25 INV_STOCK_TYPE Character(4) VARCHAR2(4) NOT NULL Stock Type

    Prompt Table: STOCK_TYPE_INV

    26 DIST_CFG_FLAG Character(1) VARCHAR2(1) NOT NULL Distribution Configuration

    Y/N Table Edit

    Default Value: N

    27 CFG_CODE_OPT Character(1) VARCHAR2(1) NOT NULL Configurator Code Generation

    Default Value: N

    28 CP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID Field

    Prompt Table: CP_TEMP_HDR_VW

    29 SERVICE_PRICE Signed Number(22,5) DECIMAL(20,5) NOT NULL This is the price of the material - synced up with the pirce of the item from the SCM side
    30 CP_TREE_DIST Character(18) VARCHAR2(18) NOT NULL Distribution Model Field

    Prompt Table: %EDITTABLE

    31 PRDN_CFG_FLAG Character(1) VARCHAR2(1) NOT NULL Production Configuration

    Default Value: N

    32 PRODUCT_ID_NEW Character(18) VARCHAR2(18) NOT NULL New Product ID
    33 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    34 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    35 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    36 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    37 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    38 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time
    39 SERVICE_EXCH_AMT Signed Number(22,5) DECIMAL(20,5) NOT NULL Service exchange amount - gives the price of the material - synced up with the pricing from the SCM side