MASTER_ITM_LANG

(SQL Table)
 Index Back

Item Master Related Language

This view shows Item ID, Related Language Code and Description fields for an Item.

  • Related Language Record for MASTER_ITEM_TBL MASTER_ITM_VW MASTER_ITM_VW2 MASTER_ITM_VW3 PROD_STOCK_VW RF_ITEM_MST_VW1 RF_ITEM_ORD_VW RF_ITEM_SVC_VW RF_MR_ITEM_VW RF_MST_ITEM_VW RF_MU_ITEM_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description