CNTRCT_VNDR_LOC

(SQL View)
 Index Back

Supplier Contract Line View


SELECT a.setid , a.cntrct_id , b.cntrct_line_nbr , a.vendor_setid , a.vendor_id , c.vndr_loc , a.cntrct_type , b.inv_item_id , b.descr254_mixed , b.category_id , c.unit_of_measure , c.currency_cd FROM ps_cntrct_hdr a , ps_cntrct_line b , PS_CNTRCT_LINE_UOM c WHERE a.setid = b.setid AND a.cntrct_id = b.cntrct_id AND a.version_nbr = b.version_nbr AND a.cntrct_type = 'PO' AND a.cntrct_status = 'A' AND a.version_status = 'C' AND a.setid = c.setid AND a.cntrct_id = c.cntrct_id AND a.version_nbr = c.version_nbr AND b.cntrct_line_nbr = c.cntrct_line_nbr

# 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 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

Default Value: NEXT

3 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
4 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
6 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
7 CNTRCT_TYPE Character(2) VARCHAR2(2) NOT NULL Contract Type
AP=Recurring Voucher
GN=General Contract
MS=Master Contract
PO=Purchase Order
8 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
9 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
10 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
11 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code