The Order History Dataset has 2 sheets within the single spreadsheet and is used to import historical order data that will be READ-ONLY in your Aturian Workspace.
| Salesperson Default Commissions | ||||
| Column Name | Required | Value Type | Description | Example Value |
| OrderNumber | Yes | Text | The order number for the historical order | 15611984 |
| OrderDate | No | Text | The date the historical order was placed | 12/11/2024 |
| CustomerNumber | No | Text | The customer's unique identifier | 100100 |
| CustomerName | Yes | Text | The customer's company name | Northwest Highschool |
| CustomerContact | No | Text | The customer contact | john@nwhighschool.com |
| SalesPerson | Yes | Text | The salesperson for this historical order | Jane Doe |
| CustomerPO | No | Text | The customer's PO number for the historical order | AP100 |
| OrderName | No | Text | The name of the order | Shirts Order |
| BillingAdress | No | Text | The billing order for this historical order | 1000 Chicago Ave, Suite 100, Chicago IL 60202 |
| BillingInfo | No | Text | The billing terms for this historical order | Net 30 |
| ShippingAddress | Yes | Text | Where the order was shipped | 1000 Chicago Ave, Suite 100, Chicago IL 60202 |
| Notes | No | Text | Any notes added to this order | Your order notes |
| SubTotal | Yes | Number | The order's subtotal | 590.00 |
| SalesTax | Yes | Number | The order's sales tax | 10.75 |
| Freight | Yes | Number | The order's freight cost | 1.00 |
| Total | Yes | Number | The order's total | 601.75 |
| Order Item Information | ||||
| Column Name | Required | Value Type | Description | Example Value |
| Order Number | Yes | Text | The order number for the historical order | 1001 |
| InternaItemNumber | No | Text | The internal item number for the item in this order | ALPHA1000 |
| SupplierItemNumber | No | Text | The supplier's item number for the item in this order | K500 |
| SKU | No | Text | The unique SKU for the item in the order | ALPHA1000_120 |
| Name | Yes | Text | The item's name | Polo T Shirt |
| Description | No | Text | The item's description | Red / S |
| Qty | Yes | Number | The quantity ordered of this item | 100 |
| Cost | Yes | Number | The internal cost for the item | 7.99 |
| Sell | Yes | Number | The price charged to the customer for the item | 15 |
| Supplier | Yes | Text | The supplier of this product | Sanmar |
| Decorator | Yes | Text | The decorator of this product | Sharprint |
| ArtworkInfo | No | Text | The location, size, and decoration method for this order | Chest Left, 2x2, Embroidery |