Vendors Table Formats (VE)
Follow Ajera CRM specifications for preparing a file containing vendor data.
| Field Name | Data Type | Length | Notes |
|---|---|---|---|
| Vendor | varchar | 20 | Vendor number; primary key |
| AvailableForCRM | varchar | 1 | Variable indicating whether or not the record is available to CRM users |
| Category | varchar | 1 | Vendor type; required field; must exist in CFGVendorType (Type/Label) |
| DisabledVetOwnedSmallBusiness | varchar | Variable indicating whether the Disabled Vet. owned Small Business option is selected | |
| DisadvBusiness | varchar | 1 | Variable indicating whether or not the Vendor is a Disadvantaged Business; default is N (No) |
| FedID | varchar | 11 | Vendor's federal taxpayer identification number |
| HBCU | varchar | 1 | Variable indicating whether or not the Vendor has an HBCU (Historically Black College or University) Minority Status; default is N (No) |
| Memo | text | 16 | Memo field for comments regarding the vendor |
| MinorityBusiness | varchar | 1 | Variable indicating whether or not the vendor is a Minority Business; default is N (No) |
| Name | varchar | 100 | Vendor name; required field |
| Org | varchar | 14 | Vendor's organization; used for sorting purposes only; must exist in Organization |
| PriorWork | varchar | 1 | Variable indicating whether or not the vendor has done prior work for the organization; default is N (No) |
| Recommend | varchar | 1 | Variable indicating whether or not the Vendor has been recommended to do work for the organization in the future; default is N (No) |
| SmallBusiness | varchar | 1 | Variable indicating whether or not the vendor is a Small Business; default is N (No) |
| SortName | varchar | 40 | Vendor sort name |
| Specialty | text | 16 | User-entered description of the vendor's business specialty |
| Status | varchar | 1 | Variable indicating the vendor's status; valid options are A (Active), I (Inactive), or D (Dormant); required field; must exist in CFGVendorStatus (Status/Label) |
| Type | varchar | 10 | Vendor specialty; must exist in CFGPrimarySpecialty (Code/Description) |
| VetOwnedSmallBusiness | varchar | Variable indicating whether or not the Veteran Owned Small Business option is selected | |
| WebSite | varchar | 255 | Vendor's Web site address |
| WomanOwned | varchar | 1 | Variable indicating whether or not the Vendor is a Woman Owned Business; default is N (No) |
| Address | varchar | 20 | Vendor address code; primary key |
| Address1 | varchar | 50 | First line of the vendor's address |
| Address2 | varchar | 50 | Second line of the vendor's address |
| Address3 | varchar | 50 | Third line of the vendor's address |
| Address4 | varchar | 50 | Fourth line of the vendor's address |
| City | varchar | 30 | Vendor's city |
| State | varchar | 10 |
Vendor's state. If you import both state and country, that combination must already be a valid combination in Ajera CRM. If you import a state but not a country, the state must be a valid state for the United States. |
| ZIP | varchar | 10 | Vendor's ZIP code |
| Country | varchar | 40 | Vendor's country |
| Phone | varchar | 24 | Vendor's telephone number |
| FAX | varchar | 24 | Vendor's fax number |
| varchar | 50 | Vendor's e-mail address | |
| PrimaryInd | varchar | 1 | Flag indicating whether or not the Address is the vendor's primary address; default is N (No) |