BI_UOM_PRMP_VW

(SQL View)
 Index Back

Payment Method Prompt view

Mass Update - Payment Method prompt view for Error 0115

SELECT DISTINCT a.fieldvalue , a.xlatlongname FROM PSXLATITEM a WHERE a.fieldname = 'UNIT_OF_MEASURE' AND a.eff_status = 'A' AND a.effdt = ( SELECT MAX(b.effdt) FROM PSXLATITEM b WHERE b.fieldname = a.fieldname AND b.eff_status = a.eff_status AND b.effdt <=%CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
2 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name