MERCHANT1COUNTRY3STATE3CITY3CC_VNDR_NM_VW1(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 <> ' ' UNION SELECT ' ' , ' ' , ' ' , 'ALL' FROM PS_INSTALLATION_PO |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MERCHANT1 |
Character(40) | VARCHAR2(40) NOT NULL | Replica of Merchant field for Preferred Vendor Search. |
| 2 | COUNTRY3 |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 3 | STATE3 |
Character(6) | VARCHAR2(6) NOT NULL | State |
| 4 | CITY3 |
Character(30) | VARCHAR2(30) NOT NULL | City |