CC_UOM_NM_VW(SQL View) |
Index Back |
---|---|
ProCard New Merchant UOMThis 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 |