| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
VS_LOADTRANSCODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Load Transaction Code
1=Add transaction
2=Delete transaction
3=Update matching transaction
4=Update if existed or add
|
| 3 |
VS_ACQ_BIN |
Number(6,0) |
INTEGER NOT NULL |
Visa/Infospan Acquiring Bin
|
| 4 |
VS_SUPPLIER_NAME1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Supplier Name
|
| 5 |
VS_SUPPLIER_CITY |
Character(14) |
VARCHAR2(14) NOT NULL |
Visa Supplier City
|
| 6 |
VS_SUPPLIER_STATE |
Character(4) |
VARCHAR2(4) NOT NULL |
Supplier State/Province
|
| 7 |
VS_SUPPLIERCOUNTRY |
Character(5) |
VARCHAR2(5) NOT NULL |
Supplier Country
|
| 8 |
VS_SUPPLIER_POSTAL |
Character(14) |
VARCHAR2(14) NOT NULL |
Supplier Postal Code
|
| 9 |
VS_MERCHANT_CAT_CD |
Character(4) |
VARCHAR2(4) NOT NULL |
Merchant Category Code
|
| 10 |
VS_SUPPLIERADDRESS |
Character(30) |
VARCHAR2(30) NOT NULL |
Supplier Address
|
| 11 |
VS_MPS_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Merchant Profile Service ID
|
| 12 |
VS_LEGALNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Business Legal Name
|
| 13 |
VS_ALT_DBA_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Alternate Supplier DBA Name
|
| 14 |
VS_MAILINGADDRESS |
Character(30) |
VARCHAR2(30) NOT NULL |
Mailing Address
|
| 15 |
VS_DUNS_NBR |
Character(9) |
VARCHAR2(9) NOT NULL |
Dun & Bradstreet Number
|
| 16 |
VS_INC_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Incorporation Status Code
1=Individual/Sole proprietorship
2=Partnership
3=Corporation-Chapter S, C
4=Medical/Legal corporation
5=Associations/estates/trusts
6=Tax-exempt organizations
7=Government-Federal/State/Local
8=International organization
9=Limited liability company
|
| 17 |
VS_MINORITY_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Minority Owned Status Code
AI=Asian Indian
AP=Asian Pacific
BL=Black
HI=Hispanic
N=Not Minority-Owned
NA=Native American
OT=Other
|
| 18 |
VS_TIN |
Character(9) |
VARCHAR2(9) NOT NULL |
Tax Identification Number
|
| 19 |
VS_SIC_CODE1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Primary SIC Code
|
| 20 |
VS_SIC_CODE2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Secondary SIC Code
|
| 21 |
VS_SUPPLIER_PHONE |
Character(15) |
VARCHAR2(15) NOT NULL |
Supplier Phone Number
|
| 22 |
VS_OWNER_FNAME |
Character(25) |
VARCHAR2(25) NOT NULL |
Sole Owner First Name
|
| 23 |
VS_OWNER_MINITIAL |
Character(2) |
VARCHAR2(2) NOT NULL |
Sole Owner Middle Initial
|
| 24 |
VS_OWNER_LNAME |
Character(25) |
VARCHAR2(25) NOT NULL |
Sole Owner Last Name
|
| 25 |
VS_WOMEN_OWNED |
Character(1) |
VARCHAR2(1) NOT NULL |
Women Owned Indicator
Y/N Table Edit
|
| 26 |
VS_SALES_VOLUME |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sales Volume
|
| 27 |
VS_EMPLOYEE_COUNT |
Number(6,0) |
INTEGER NOT NULL |
Employee Count
|
| 28 |
VS_ISSUER_BIN |
Character(6) |
VARCHAR2(6) NOT NULL |
Issuer BIN
|
| 29 |
VS_TIN_TYPE_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
TIN Type Code
1=SSN
2=FEIN
|
| 30 |
VS_SUPPLIER_EMAIL |
Character(40) |
VARCHAR2(40) NOT NULL |
Supplier Email Address
|
| 31 |
VS_SUPPLIER_FAX |
Character(15) |
VARCHAR2(15) NOT NULL |
Supplier Fax Number
|
| 32 |
VS_RESERVE_PHONE |
Character(15) |
VARCHAR2(15) NOT NULL |
Reservation Phone
|
| 33 |
VS_LEVEL_III_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Level III Capture Code
N=Supplier not capable
Y=Supplier Capable
|
| 34 |
VS_LEVEL_II_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Level II Capture Code
N=Code/CRI was not sent
Y=Code/CRI was sent
|
| 35 |
VS_PARENT_SUPPLIER |
Character(12) |
VARCHAR2(12) NOT NULL |
Parent Visa Supplier Id
|
| 36 |
VS_ALT_SUPP_CITY |
Character(20) |
VARCHAR2(20) NOT NULL |
Alternate Supplier City
|
| 37 |
VS_ALT_SUPP_STATE |
Character(3) |
VARCHAR2(3) NOT NULL |
Alternate Supplier State
|
| 38 |
VS_ALT_SUPP_POSTAL |
Character(14) |
VARCHAR2(14) NOT NULL |
Alternate Supplier Postal Code
|
| 39 |
CC_OUT_OF_BUS_DATE |
Date(10) |
DATE |
Supplier Out of Business Date
|
| 40 |
CC_OWNER_CHNG_DATE |
Date(10) |
DATE |
Supplier Ownership Change Date
|
| 41 |
VS_8A_CLASS |
Character(1) |
VARCHAR2(1) NOT NULL |
8A Classification Indicator
Y/N Table Edit
|
| 42 |
CC_8A_EXP_DT |
Date(10) |
DATE |
8A Expiration Date
|
| 43 |
VS_SBA_PARTICIPANT |
Character(1) |
VARCHAR2(1) NOT NULL |
SBA Participant
Y/N Table Edit
|
| 44 |
VS_DISABLED_VET |
Character(1) |
VARCHAR2(1) NOT NULL |
Disabled Veteran
Y/N Table Edit
|
| 45 |
VS_VETERAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Veteran Indicator
Y/N Table Edit
|
| 46 |
VS_VIETNAM_VET |
Character(1) |
VARCHAR2(1) NOT NULL |
Vietnam Era Veteran
Y/N Table Edit
|
| 47 |
VS_REFUSAL_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Supplier Information Refusal
N=Not Refuse
Y=Refuse
|
| 48 |
CC_INCSTATUSCHANGE |
Date(10) |
DATE |
Inc Status Change Date
|
| 49 |
VS_SMALLBUSINESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Small Disadvantaged Business
Y/N Table Edit
|
| 50 |
VS_MAILINGCITY |
Character(20) |
VARCHAR2(20) NOT NULL |
Mailing City
|
| 51 |
VS_MAILINGSTATE |
Character(4) |
VARCHAR2(4) NOT NULL |
Mailing State/Province
|
| 52 |
VS_MAILINGCOUNTRY |
Character(5) |
VARCHAR2(5) NOT NULL |
Mailing Country
|
| 53 |
VS_ALT_SUPPCOUNTRY |
Character(5) |
VARCHAR2(5) NOT NULL |
Alternate Supplier Country
|
| 54 |
VS_HUB_ZONE |
Character(1) |
VARCHAR2(1) NOT NULL |
Hub Zone
Y/N Table Edit
|
| 55 |
VS_FRANCHISECODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Franchise Code
C=Corporate
F=Franchise
|
| 56 |
VS_NAICS1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Primary NAICS Code
|
| 57 |
VS_NAICS2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Secondary NAICS Code
|
| 58 |
VS_SELLER_ID |
Character(19) |
VARCHAR2(19) NOT NULL |
Visa Commerce Seller ID
|
| 59 |
VS_RESERVED |
Character(12) |
VARCHAR2(12) NOT NULL |
Reserved for Future Use
|
| 60 |
VS_OPTIONAL_01 |
Character(26) |
VARCHAR2(26) NOT NULL |
Optional Field 1
|
| 61 |
VS_OPTIONAL_02 |
Character(26) |
VARCHAR2(26) NOT NULL |
Optional Field 2
|
| 62 |
VS_OPTIONAL_03 |
Character(26) |
VARCHAR2(26) NOT NULL |
Optional Field 3
|
| 63 |
VS_OPTIONAL_04 |
Character(26) |
VARCHAR2(26) NOT NULL |
Optional Field 4
|