CC_UOM_NM_VW

(SQL View)
Index Back

ProCard New Merchant UOM

This view retrives those MERCHANT_UOM that do not have a matching UNITS_TBL.UNIT_OF_MEASURE.

SELECT DISTINCT A.MERCHANT_UOM , ' ' FROM PS_CC_TRANS_LINE A WHERE MERCHANT_UOM <> ' ' AND NOT EXISTS ( SELECT 'X' FROM PS_CC_UOM_XREF B WHERE B.MERCHANT_UOM = A.MERCHANT_UOM)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MERCHANT_UOM Character(20) VARCHAR2(20) NOT NULL Merchant UOM
2 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: UNITS_TBL