The Customers Dataset has 2 sheets within the single spreadsheet. Its used to collect your customer's data for you workspace.
| Suppliers | ||||
| Column Name | Required | Value Type | Description | Example Value |
| Vendor Number | No | Number | The unique supplier identifier. If ommitted, Aturian will automatically generate a new one. | 100100 |
| Vendor Name | Yes | Text | The vendor/supplier's company name | San Mar |
| Aliases | No | Text | Other ways this vendor/supplier is referred to | Sanmar,Snmr |
| Vendor AP Account Number | No | Text | This supplier's AP Account Number followed by the Account Description. Found in the Accounting Dataset > Chart of Accounts | 72015-Utilities |
| Gen Cont: First Name | No | Text | The vendor's/supplier's general contact first name | Mary |
| Gen Cont: Last Name | No | Text | The vendor's/supplier's general contact last name | Jane |
| General Emails | No | Text | The vendor's/supplier's general contact phone number | 800-333-4444 |
| Order Emails | No | Text | The vendor's/supplier's general contact mobile number | 456-312-4425 |
| Art Emails | No | Text | The vendor's/supplier's general contact email address | maryjane@nwhschool.com |
| APAddr: Attention | No | Text | Who to address when sending physical mail to this vendor/supplier | Mary Jane |
| APAddr: Company | No | Text | The vendor's/supplier's company name | Northwest High School |
| APAddr: Street 1 | No | Text | The vendor's/supplier's street address | 101 Chicago Ave. |
| APAddr: Street 2 | No | Text | Optional field used to capture location details that don't fit in Street 1 | Ste. 101 |
| APAddr: City | No | Text | The city where the vendor/supplier resides | Evanston |
| APAddr: State | No | Text | The state where the vendor/supplier resides | Illinois |
| APAddr: Zip | No | Text | The zip code of the vendor's/supplier's location | 60202 |
| APAddr: Country | No | Text | The country that the vendor/supplier resides in | USA |
| OrdAddr: Attention | No | Text | Who to address when sending physical mail to the vendor/supplier | Mary Jane |
| OrdAddr: Company | No | Text | The company name for this vendor's/supplier's ship to address | Northwest High School |
| OrdAddr: Street 1 | No | Text | The street address for this vendor's/supplier's ship to address | 101 Chicago Ave. |
| OrdAddr: Street 2 | No | Text | Optional field used to capture location details that don't fit in Street 1 | Ste. 101 |
| OrdAddr: City | No | Text | The city used for this vendor's/supplier's ship to address | Evanston |
| OrdAddr: State | No | Text | The state used for this vendor's/supplier's ship to address | Illinois |
| OrdAddr: Zip | No | Text | The zip code used for this vendor's/supplier's ship to address | 60202 |
| OrdAddr: Country | No | Text | The country used for this vendor's/supplier's ship to address | USA |
| ShipTo: Attention | No | Text | Who to address when sending physical mail to the vendor/supplier | Mary |
| ShipTo: Company | No | Text | The company name for this vendor's/supplier's ship to address | Jane |
| ShipTo: Street 1 | No | Text | The street address for this vendor's/supplier's ship to address | 800-333-4444 |
| ShipTo: Street 2 | No | Text | Optional field used to capture location details that don't fit in Street 1 | 456-312-4425 |
| ShipTo: City | No | Text | The city used for this vendor's/supplier's ship to address | maryjane@nwhschool.com |
| ShipTo: State | No | Text | The state used for this vendor's/supplier's ship to address | Mary Jane |
| ShipTo: Zip | No | Text | The zip code used for this vendor's/supplier's ship to address | Northwest High School |
| ShipTo: Country | No | Text | The country used for this vendor's/supplier's ship to address | 101 Chicago Ave. |
| Web Address | No | Text | This vendor's/supplier's company website URL | www.sanmar.com |
| Sales Rep Info | No | Text | The sales rep for this vendor/supplier | Sarah Samuels |
| Main Telephone Number | No | Text | The main telephone number for this vendor/supplier | 800-700-6000 |
| Terms | Yes | Text | The credit terms for this vendor/supplier | Net 30 |
| Due Days | Yes | Number | The number of days the number of days after the invoice date when payment is due. | 30 |
| Cash Discount % | No | Number | The percentage discount offered if payment is made within the specified discount period | 2% |
| Discount Days | No | Number | The number of days from the invoice date during which your company is eligible to receive the cash discount | 10 |
| ASI Number | No | Text | The vendor's/supplier's ASI number | 12345 |
| Gets 1099 | No | Yes/No | Does this vendor/supplier receive a 1099 from your company? | No |
| Our Account Number | No | Text | Your company's account number with the vendor/supplier | S-12344 |
| Vendor Tax ID | No | Text | This vendor/supplier's tax ID number | 1234-5678-9012 |
| AP Email Address | No | Text | This vendor's/supplier's accounts payable email address | ap@sanmar.com |