PROD_UOM_VW_LNG

(SQL View)
 Index Back

UOM for stockable products

This record stores the Product attributes by Unit of Measure. It will also include the conversion rate associated with the unit of measure.

SELECT a.setid , a.product_id , a.unit_of_measure , d.language_cd , d.descr FROM ps_prod_uom a , ps_prod_item_vw b , ps_inv_item_uom c , PS_UNITS_TBL_LANG d WHERE a.product_id = b.product_id AND a.setid = b.setid AND a.setid = c.setid AND b.inv_item_id = c.inv_item_id AND a.unit_of_measure = c.unit_of_measure AND a.unit_of_measure = d.unit_of_measure

  • Related Language Record for PROD_UOM_VW_SS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: PROD_ITEM

    3 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Prompt Table: %EDITTABLE

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description