CC_VNDR_NM_VW

(SQL View)
 Index Back

ProCard new merchant supplier


SELECT DISTINCT A.MERCHANT , A.COUNTRY , A.STATE , A.CITY , ' ' , ' ' , ' ' FROM PS_CC_TRANS_LINE A WHERE A.MERCHANT <> ' ' AND NOT EXISTS ( SELECT 'X' FROM PS_CC_VNDR_XREF B WHERE B.MERCHANT = A.MERCHANT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MERCHANT Character(40) VARCHAR2(40) NOT NULL Merchant
2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

3 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

4 CITY Character(30) VARCHAR2(30) NOT NULL City
5 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

Prompt Table: SP_SETID_NONVW

6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VENDOR

7 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: VENDOR_LOC_VW