UNITSTBL_TO_LVW

(SQL View)
 Index Back

To Units of Measure

Inventory item Unit of Measure long and short descriptions for related languages.

SELECT A.UNIT_OF_MEASURE ,L.LANGUAGE_CD ,L.DESCR ,L.DESCRSHORT FROM PS_UNITS_TBL A , PS_UNITS_TBL_LANG L WHERE A.UNIT_OF_MEASURE = L.UNIT_OF_MEASURE

  • Related Language Record for UNITS_TBL_TO_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 UNIT_OF_MEASURE_TO Character(3) VARCHAR2(3) NOT NULL Unit of Measure To
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description