Supplier Upload Data Dictionary
The Supplier Upload Data Dictionary applies to upload data for the supplier upload and the data enrichment tools. The Data Elements correspond to each column in the .csv upload file template accessible within the system.
- Required fields are shown in red with an asterisk*
- Best Results for data matching can be obtained by providing data in purple
A sample file is attached to this article
| Data Element | Max Length | Note | Example |
| Company Name* | 70 | Company names longer than 70 characters will be truncated to 70 character limit. | Acme Manufacturing |
| EIN | 9 | 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 | 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 | Street Address | 123 Harmony Lane |
| City | 35 | City Name | Phoenix |
| Country Id | Country abbreviation or full spelling or ISO 3166 Code |
USA United States 840 |
|
| State | 35 |
2 Digit Abbreviation (US) Full Province Spelling (Non-US) |
(US) CA (Non-US) Oxfordshire |
| Zip | 20 |
9 Digit Zip, or Zip-plus4 (US) Up to 20 digit postal code (Non-US) |
(US) 92620 (Non-US) CT1 2ES |
| Duns | 9 | 9 Digit DUNS - no dashes | 871928374 |
| Address2 | 70 | Address 2, Suite, Unit, Name, etc |
Suite 134 Unit 341 Healdsden House |
| Phone | 25 |
10 Digit (US) Up to 25 Dgit (Non-US) |
3105551212 4418713245 |
| Contact First Name | 25 | Given name, first name | Angelique |
| Contact Last Name | 25 | Surname, last name | Johnson |
| Contact Email | 50 | Single email only. Do not include multiple emails | ajohnson2@indco.com |
| Required to Report | 4 |
Signifies that the supplier is required to report Tier-2 (Standard) - Options (Y/Yes/True/No/N/0/1) |
Required = (Y or Yes or True or 1) Not Required = (No or N or 0 or blank) |
| Small Business | 4 |
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 |
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 |
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 |
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 |
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 |
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 |
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) |
| Historically Black College & University | 4 |
HBCU 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 |
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 |
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 |
| Master | 50 | Master Supplier Number. This will link the supplier record as a subsidiary of a Master Supplier identity. This is usually not used unless you have a master supplier number scheme in place. | ABC-1234 |
| Source | 50 | Entity Source Identifier. Use this only if you have established source identifiers for the records. Example, may be to identify all records from a specific ERP System. |
SAP1 Oracle-West |
| LGBT |
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) |
|
| Certification(s) | Certification data may be provided but must follow exact required syntax. Normally left Blank | ||
| Year Established | 4 | 4 Digit year | 1986 |
| Employees | 7 | Number of employees. Numbers only, no commas | 3000 |
| Capabilities | 2000 | Capabilities description. | ACME manufacturing is a producer of industrial steel widgets and housings… |
| NAICS | 2000 | 6 digit naics codes, separated by comma | 111211, 113332, 113456,118736 |
Sample Data Record (partial view)
Comments
0 comments
Article is closed for comments.