UOM_WKPrompt Table: UNITS_TBL
UNIT_OF_MEASURECS=Case
EA=Each
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
Prompt Table: UNITS_TBL
UNITS_CVT_VW(SQL View) |
Index Back |
|---|---|
UOM Inverse Conversion - ViewInventory item unit of measure conversion rates. |
| 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.
CS=Case EA=Each 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 |