Data Enrichment Upload Data Dictionary

Here are data dictionaries for the Data Enrichment Upload Files. Use the links to navigate quickly to each section.  we have also provided a sample file with sample data for each one.

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	[e-mail]
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

UPLOAD/INPUT FILE - Short Version (Short_compact)

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	[e-mail]
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 YYYY (e.g., 2024)	2024

INPUT/UPLOAD FILE - Expanded Version

Sample Data Record (partial view)