PV_VNDR_PR_VW

(SQL View)
Index Back

Supplier Price Quantity View


SELECT A.SETID , A.INV_ITEM_ID , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC ,A.PRICE_VNDR , A.UNIT_OF_MEASURE , A.QTY_MIN , A.CURRENCY_CD FROM PS_ITM_VNDR_UOM_PR A WHERE A.EFFDT IN( SELECT MAX(C.EFFDT) FROM PS_ITM_VNDR_UOM_PR C WHERE C.SETID = A.SETID AND C.INV_ITEM_ID = A.INV_ITEM_ID AND C.VENDOR_SETID = A.VENDOR_SETID AND C.VENDOR_ID = A.VENDOR_ID AND C.VNDR_LOC = A.VNDR_LOC AND C.UNIT_OF_MEASURE = A.UNIT_OF_MEASURE AND C.QTY_MIN = A.QTY_MIN AND C.CURRENCY_CD = A.CURRENCY_CD AND C.EFF_STATUS = 'A' AND C.EFFDT <= %CurrentDateIn )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
6 PRICE_VNDR Number(16,5) DECIMAL(15,5) NOT NULL Vendor Price
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 QTY_MIN Number(16,4) DECIMAL(15,4) NOT NULL Minimum Quantity
9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code