ITM_VND_UMP_CVW(SQL View) |
Index Back |
|---|---|
Price/UOM Supplier Loc For ItePrice/UOM Supplier Loc For Item |
| SELECT A.SETID ,A.INV_ITEM_ID ,A.VENDOR_SETID ,A.VENDOR_ID ,A.VNDR_LOC ,A.UNIT_OF_MEASURE ,A.CURRENCY_CD ,A.QTY_MIN ,A.EFFDT ,A.EFF_STATUS ,A.PRICE_VNDR ,A.UNIT_PRC_TOL ,A.EXT_PRC_TOL ,A.USE_STD_TOLERANCES ,A.PCT_UNIT_PRC_TOL ,A.PCT_EXT_PRC_TOL ,A.QTY_RECV_TOL_PCT ,A.UNIT_PRC_TOL_L ,A.PCT_UNIT_PRC_TOL_L ,A.EXT_PRC_TOL_L ,A.PCT_EXT_PRC_TOL_L ,A.LEAD_TIME ,' ' FROM PS_ITM_VNDR_UOM_PR A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL |
Item ID
Prompt Table: ITM_PURCH_VW |
| 3 | VENDOR_SETID |
Character(5) | VARCHAR2(5) NOT NULL |
Vendor SetID
Prompt Table: SP_SETID_NONVW |
| 4 | VENDOR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VNDR_VNDSET_VW |
| 5 | VNDR_LOC |
Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 6 | 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 |
| 7 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 8 | QTY_MIN |
Number(16,4) | DECIMAL(15,4) NOT NULL |
Minimum Quantity
Default Value: 1 |
| 9 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 10 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 11 | PRICE_VNDR | Number(16,5) | DECIMAL(15,5) NOT NULL | Vendor Price |
| 12 | UNIT_PRC_TOL | Number(14,5) | DECIMAL(13,5) NOT NULL | Unit Price Tolerance |
| 13 | EXT_PRC_TOL | Number(14,5) | DECIMAL(13,5) NOT NULL | Ext Price Tolerance |
| 14 | USE_STD_TOLERANCES | Character(1) | VARCHAR2(1) NOT NULL | Use Item Standard Tolerances |
| 15 | PCT_UNIT_PRC_TOL | Number(6,2) | DECIMAL(5,2) NOT NULL | % Unit Price Tolerance |
| 16 | PCT_EXT_PRC_TOL | Number(6,2) | DECIMAL(5,2) NOT NULL | % Ext Price Tolerance |
| 17 | QTY_RECV_TOL_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Qty Rcvd Tolerance % |
| 18 | UNIT_PRC_TOL_L | Number(14,5) | DECIMAL(13,5) NOT NULL | Unit Price Tolerance - Under |
| 19 | PCT_UNIT_PRC_TOL_L | Number(6,2) | DECIMAL(5,2) NOT NULL | % Unit Price Tolerance - Under |
| 20 | EXT_PRC_TOL_L | Number(14,5) | DECIMAL(13,5) NOT NULL | Ext Price Tolerance - Under |
| 21 | PCT_EXT_PRC_TOL_L | Number(6,2) | DECIMAL(5,2) NOT NULL | % Ext Price Tolerance - Under |
| 22 | LEAD_TIME | Number(3,0) | SMALLINT NOT NULL | Lead Time Days |
| 23 | AUDIT_ACTN | Character(1) | VARCHAR2(1) NOT NULL |
Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values |