SETIDINV_ITEM_IDCS=Case
EA=Each
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
ORDENT_CONV_VW(SQL View) |
Index Back |
|---|---|
Order entry uom conversion vieItem unit of measure conversion view |
| select a.setid, a.inv_item_id, a.unit_of_measure, a.conversion_rate from ps_inv_item_uom a, PS_UOM_TYPE_INV b where a.setid = b.setid and a.inv_item_id = b.inv_item_id and a.unit_of_measure = b.unit_of_measure and b.inv_uom_type = 'ORDR' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | 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 |
| 4 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |