Below is a description of the Spire Fields for this Import.
Please refer to the User Manual for more information on how to do Imports.
| Spire 3.11 Fields | Explanation | Example |
| Group By | Group By number (Order No or Group By is required) | 1 |
| Order No | Sales Order number (Order No or Group By is required) | 0000706588 |
| Type | Sales Order type; B - Booking Order O - Sales Order Q - Quote R - RMA S - Standing Order W - Work Order | O |
| Order Date | Order Date | 01/01/2024 |
| Invoice Date | Invoice Date | 03/01/2024 |
| Required Date | Required Date | 02/01/2024 |
| Item Required Date | Item Required Date | 02/01/2024 |
| Ship Date | Ship Date | 01/15/2024 |
| Invoice No | Invoice number | 0000620386 |
| Customer No (Required) | Customer No. | A1PAR |
| Customer PO | Customer Purchase Order number | 1001 |
| Ship to ID | Customer's Ship To ID | TORONTO |
| Order Reference No | Order reference number | 12345 |
| Terms Code | Existing Payment Terms Code | NET30 |
| Part Warehouse | Part Warehouse | VA |
| Part No | Part number | CMATS |
| Order Qty | Order quantity | 5 |
| Committed Qty | Committed quantity | 5 |
| Unit Price | Unit Price | 10 |
| Line Description | Line Description for item | Crash Mats |
| Item Comment | Comment on the line item | Requested by Randy |
| Shipping Name | Ship To name | Toronto Office |
| Shipping Address 1 | Ship To address line 1 | 123 2nd Street |
| Shipping Address 2 | Ship To address line 2 | Floor 3 |
| Shipping Address 3 | Ship To address line 3 | Unit A |
| Shipping Address 4 | Ship To address line 4 | Attn: Jack |
| Shipping City | Ship To city | Toronto |
| Shipping Province | Ship To province | Ontario |
| Shipping Country | Ship To country; 3 digit code | CAN |
| Shipping Postal Code | Shipping postal code | M4C 1A1 |
| Shipping Phone | Shippng phone number | 555-555-5555 |
| Shipping Fax | Shipping fax number | 555-555-5555 |
| Shipping Email | Shipping email | Jack@email.ca |
| Shipping Web Page | Shipping web page | www.A1PAR.com |
| Shipping Ship Via Code | Existing Ship Via code | 01 |
| Shipping Contact #1 Name | First shipping contact name | Ed |
| Shipping Contact #1 Tel No. | First shipping contact phone number | 555-555-5555 |
| Shipping Contact #1 cell | First shippng contact cell number | 555-555-5555 |
| Shipping Contact #1 other | First shipping contact other | CEO |
| Shipping Contact #1 email | First shippng contact email | Ed@email.ca |
| Shipping Contact #1 type | First shipping contact type; Not working in version 3.11 | Main |
| Shipping Contact #2 Name | Second shippng contact name | Jane |
| Shipping Contact #2 Tel No. | Second shipping contact phone number | 555-555-5555 |
| Shipping Contact #2 cell | Second shipping contact cell number | 555-555-5555 |
| Shipping Contact #2 other | Second shipping contact other | Ed's wife |
| Shipping Contact #2 email | Second shipping contact email | Jane@email.ca |
| Shipping Contact #2 type | Second shipping contact type; Not working in version 3.11 | Main |
| Shipping Contact #3 Name | Third shippng contact name | Joe |
| Shipping Contact #3 Tel No. | Third shipping contact phone number | 555-555-5555 |
| Shipping Contact #3 cell | Third shippng contact cell number | 555-555-5555 |
| Shipping Contact #3 other | Third shipping contact other | New to the company |
| Shipping Contact #3 email | Third shippng contact email | Receiving@email.ca |
| Shipping Contact #3 type | Third shipping contact type; Not working in version 3.11 | Main |
| Salesperson | Exisint Salesperson | David |
| Territory | Existing Territory | BUILDERS |
| Tax 1 | First existing Sales Tax code | 1 |
| Tax 2 | Second existing Sales Tax code | 2 |
| Unit of Measure | Unit of measure | EA |
| Billing Contact 1 | First billing contact | Ben Smith |
| Shipping Carrier | Shipping carrier | |
| Tracking No | Shippng tracking number | 109-123456789 |