SETIDDefault Value: OPR_DEF_TBL_FS.SETID
INV_ITEM_IDUNIT_MEASURE_STDVENDOR_SETIDDefault Value: OPR_DEF_TBL_FS.SETID
VENDOR_IDVNDR_LOCUNIT_OF_MEASUREMHR=Muti Hourly
PER=Percentage
SQF=Square Footage
ITM_VNDR_UM_VW1(SQL View) |
Index Back |
|---|
| SELECT a.setid , a.inv_item_id , a.unit_measure_std , b.vendor_setid , b.vendor_id , b.vndr_loc , b.unit_of_measure , b.conversion_rate FROM PS_MASTER_ITEM_TBL a , ps_itm_vndr_uom b WHERE a.setid = b.setid AND a.inv_item_id = b.inv_item_id AND b.conversion_rate >0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | UNIT_MEASURE_STD |
Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 4 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
Vendor SetID
Default Value: OPR_DEF_TBL_FS.SETID |
| 5 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 6 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 7 | UNIT_OF_MEASURE |
Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 8 | CONVERSION_RATE | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Conversion Rate |