PV_MS_TST_PC_VW

(SQL View)
Index Back

SELECT C.SETID , C.VENDOR_ID , C.VNDR_LOC , B.INV_ITEM_ID , %Substring(A.PV_CP_UOM,1,3) FROM PS_PV_CP_ITM_XREF A , PS_ITM_VENDOR B , PS_PV_MS_SUPPLIER C WHERE A.SETID = B.SETID AND A.PV_CP_SPN = B.ITM_ID_VNDR AND A.PV_CP_PART_EXT = B.PV_CP_PART_EXT AND A.SETID = C.SETID AND B.VENDOR_ID = C.VENDOR_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
5 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage