PROD_UOM_VW_SS

(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.descr, c.conversion_rate from ps_prod_uom a, ps_prod_item_vw b, ps_inv_item_uom c, PS_UNITS_TBL 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: PROD_UOM_VW_LNG

    • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate