Data Enrichment Upload Data Dictionary
The Data Enrichment Upload Data Dictionary defines the supported fields, formatting requirements, and data types for SupplierGateway Data Enrichment upload files. Two upload templates are available:
- Short Version – Contains the minimum required and commonly used fields.
- Expanded Version – Includes additional supplier profile, classification, and diversity fields.
Sample templates and sample data files are provided for both formats.
UPLOAD/INPUT FILE - Short Version
⬇️ Click to download a short data template
⬇️ Click to download a sample short data input file
| Data Element | Max Length | Note | Example |
|---|---|---|---|
| Company Name* | 70 | REQUIRED Company names longer than 70 characters will be truncated to 70 character limit. | Acme Manufacturing |
| EIN | 9 | RECOMMENDED US Tax ID’s are 9 digits long. Non-US Tax ID’s may be longer or shorter. US Tax ID’s may be furnished with or without dashes. Numbers only are preferred. |
(US) 999876543 (NON US) FR 12345678901 |
| Supplier Number * | 50 | REQUIRED Supplier numbers are used to identify your suppliers in the system. Supplier Numbers are assigned to uploaded records and should be unique to the supplier. |
MID-192837464 0000028374 |
| Address | 70 | REQUIRED Street Address | 123 Harmony Lane |
| City | 35 | REQUIRED City Name | Phoenix |
| Country Id | REQUIRED Country abbreviation or full spelling or ISO 3166 Code |
USA United States 840 |
|
| State | 35 |
REQUIRED 2 Digit Abbreviation (US) Full Province Spelling (Non-US) |
(US) CA (Non-US) Oxfordshire |
| Zip | 20 |
REQUIRED 5 Digit Zip, or 9-Digit Zip-plus4 (US) Up to 20 digit postal code (Non-US) |
(US) 92620 92620-0128 (Non-US) CT1 2ES |
| Contact First Name | 25 |
OPTIONAL Given name, first name |
Angelique |
| Contact Last Name | 25 |
OPTIONAL Surname, last name |
Johnson |
| Contact Email | 50 |
OPTIONAL Single email only. Do not include multiple emails |
ajohnson2@indco.com |
| Spend Amount | 10 |
OPTIONAL Spend amount in whole numbers to be used for a quick view of spend analytics. No special characters, no symbols (e.g., enter 35000 - NOT $35,000.27) |
35000 |
| Spend Date | 4 |
OPTIONAL Year to be used for the spend amount entry as YYYY (e.g., 2024) |
2024 |
INPUT/UPLOAD FILE - Expanded Version
⬇️ Click to download an expanded data template
⬇️ Click to download a sample expanded data input file
| Data Element | Max Length | Note | Example |
|---|---|---|---|
| Company Name* | 70 | REQUIRED Company names longer than 70 characters will be truncated to 70 character limit. | Acme Manufacturing |
| EIN | 9 | RECOMMENDED US Tax ID’s are 9 digits long. Non-US Tax ID’s may be longer or shorter. US Tax ID’s may be furnished with or without dashes. Numbers only are preferred. |
(US) 999876543 (NON US) FR 12345678901 |
| Supplier Number * | 50 | REQUIRED Supplier numbers are used to identify your suppliers in the system. Supplier Numbers are assigned to uploaded records and should be unique to the supplier. |
MID-192837464 0000028374 |
| Address | 70 | REQUIRED Street Address | 123 Harmony Lane |
| City | 35 | REQUIRED City Name | Phoenix |
| Country Id | REQUIRED Country abbreviation or full spelling or ISO 3166 Code |
USA United States 840 |
|
| State | 35 |
REQUIRED 2 Digit Abbreviation (US) Full Province Spelling (Non-US) |
(US) CA (Non-US) Oxfordshire |
| Zip | 20 |
REQUIRED 5 Digit Zip, or 9-Digit Zip-plus4 (US) Up to 20 digit postal code (Non-US) |
(US) 92620 92620-0128 (Non-US) CT1 2ES |
| Address2 | 70 |
OPTIONAL Address 2, Suite, Unit, Name, etc |
Suite 134 Unit 341 Healdsden House |
| Phone | 25 |
OPTIONAL 10 Digit (US) Up to 25 Digit (Non-US) |
3105551212 4418713245 |
| Contact First Name | 25 |
OPTIONAL Given name, first name |
Angelique |
| Contact Last Name | 25 |
OPTIONAL Surname, last name |
Johnson |
| Contact Email | 50 |
OPTIONAL Single email only. Do not include multiple emails |
ajohnson2@indco.com |
| Small Business | 4 |
OPTIONAL Small Business according to SBA Size standard. Cannot be Small AND Large. Options (Y/Yes/True/No/N/0/1) |
YES = (Y or Yes or True or 1) NO = (No or N or 0 or blank) |
| Minority Owned | 4 |
OPTIONAL Minority Owned Business Options (Y/Yes/True/No/N/0/1) |
YES = (Y or Yes or True or 1) NO = (No or N or 0 or blank) |
| Woman Owned | 4 |
OPTIONAL Woman Owned Business Options (Y/Yes/True/No/N/0/1) |
YES = (Y or Yes or True or 1) NO = (No or N or 0 or blank) |
| Hubzone | 4 |
OPTIONAL HubZone Certified Business Options (Y/Yes/True/No/N/0/1) |
YES = (Y or Yes or True or 1) NO = (No or N or 0 or blank) |
| Small Disadvantage | 4 |
OPTIONAL Small Disadvantage Owned Business Options (Y/Yes/True/No/N/0/1) |
YES = (Y or Yes or True or 1) NO = (No or N or 0 or blank) |
| Veteran Owned | 4 |
OPTIONAL Veteran Owned Business Options (Y/Yes/True/No/N/0/1) |
YES = (Y or Yes or True or 1) NO = (No or N or 0 or blank) |
| Service Disabled Veteran Owned | 4 |
OPTIONAL Service Disabled Veteran Owned Business Options (Y/Yes/True/No/N/0/1) |
YES = (Y or Yes or True or 1) NO = (No or N or 0 or blank) |
| Large Business | 4 |
OPTIONAL Large Business (Sba Size Standard) Cannot be Large AND Small. Options (Y/Yes/True/No/N/0/1) |
YES = (Y or Yes or True or 1) NO = (No or N or 0 or blank) |
| Ethnicity | 1000 |
OPTIONAL Multiple Ethnicity values can be sent as comma Separated. Options are abbreviation or or ID’s 1 or White (Not Hispanic) or W 2 or African American or AA 3 or Hispanic American or HA 4 or Native American or NA 5 or Alaskan Native or AN 6 or Subcontinent Asian American or SAA 7 or Native Hawaiian or NH 8 or Asian Pacific American or APA 9 or Other 10 or Canadian Aboriginal or CA |
2,3,4 AA, HA, NA African American, Hispanic American, Native American |
| LGBT |
OPTIONAL LGBT Owned Business Options (Y/Yes/True/No/N/0/1) |
YES = (Y or Yes or True or 1) NO = (No or N or 0 or blank) |
|
| NAICS | 2000 |
OPTIONAL 6 digit NAICS codes, separated by comma |
111211, 113332, 113456,118736 |
| Spend Amount* | 10 |
OPTIONAL Spend amount in whole numbers to be used for a quick view of spend analytics. No special characters, no symbols (e.g., enter 35000 - NOT $35,000.27) |
35000 |
| Spend Date* | 4 |
OPTIONAL Year to be used for the spend amount entry as (e.g., 2024) |
2024 |
Important Notes
- Company names longer than 70 characters are truncated during processing.
- Supplier Numbers must be unique for each supplier.
- Employer Identification Numbers may include United States or Non-United States tax identification numbers.
- Spend Amount must contain whole numbers only. Do not include currency symbols, commas, or decimals.
- Spend Date must be entered as a four-digit year.
Note: Spend data included in a Data Enrichment upload is used only for Data Enrichment reporting and analytics. It is not imported into the Tier 1 Spend application. To upload Tier 1 spend data, use the Upload Spend Console.
Additional Resources
Sample data files are available for both the Short Version and Expanded Version templates to assist with preparing upload files.
Sample Data Record (partial view)
Comments
0 comments
Please sign in to leave a comment.