ORDENT_CONV_VW

(SQL View)
 Index Back

Order entry uom conversion vie

Item unit of measure conversion view

select a.setid, a.inv_item_id, a.unit_of_measure, a.conversion_rate from ps_inv_item_uom a, PS_UOM_TYPE_INV b where a.setid = b.setid and a.inv_item_id = b.inv_item_id and a.unit_of_measure = b.unit_of_measure and b.inv_uom_type = 'ORDR'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
4 CONVERSION_RATE Signed Number(17,8) DECIMAL(15,8) NOT NULL Conversion Rate