UOM_WKPrompt Table: UNITS_TBL
UNIT_OF_MEASUREMHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table: UNITS_TBL
UNITS_CVT_VW(SQL View) |
Index Back |
|---|---|
UOM Inverse Conversion - View |
| select UNIT_OF_MEASURE, UNIT_OF_MEASURE_TO, CONVERSION_RATE from PS_UNITS_CVT_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | UOM_WK |
Character(3) | VARCHAR2(3) NOT NULL |
Work Field for UOM
Prompt Table: UNITS_TBL |
| 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 |
| 3 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |