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 |
Vendor No. (Required) | Vendor No | ABC123 |
Name | Vendor name | ABC 123 Co. |
Address 1 | Address Line 1 | PO Box 123 |
Address 2 | Address Line 2 | |
Address 3 | Address Line 3 | |
Address 4 | Address Line 4 | |
City | City | Langley |
Province | Province (2 digit code) | BC |
Country | Country (3 digit code) | CAN |
Postal Code | Postal Code | V2E 0E2 |
Phone | Phone number | 555-555-5555 |
Fax | Fax number | 555-555-5555 |
Email address | ABC@email.ca | |
Web page | Company URL | www.abc123.com |
Ship Via Code | Shipping Method Code | 01 |
Contact #1 Name | First Contact name | Jane |
Contact #1 Tel No. | First Contact phone number | 555-555-5555 |
Contact #1 cell | First Contact cell phone | 555-555-5555 |
Contact #1 other | First Contact other | Office Admin. |
Contact #1 email | First Contact email | Jane@email.ca |
Contact #1 type | First Contact type; Not working in version 3.11 | Accounting |
Contact #2 Name | Second Contact name | Bill |
Contact #2 Tel No. | Second Contact phone number | 555-555-5555 |
Contact #2 cell | Second Contact cell phone | 555-555-5555 |
Contact #2 other | Second Contact other | Bill Junior |
Contact #2 email | Second Contact email | BillJunior@email.ca |
Contact #2 type | Second Contact type; Nit working in version 3.11 | Sales |
Contact #3 Name | Third Contact name | Bill Senior |
Contact #3 Tel No. | Third Contact phone number | 555-555-5555 |
Contact #3 cell | Third Contact cell phone | 555-555-5555 |
Contact #3 other | Third Contact other | CEO |
Contact #3 email | Third Contact email | Bill@email.ca |
Contact #3 type | Third Contact type; Not working in version 3.11 | Main |
Sales Tax 1 | First Sales Tax Code | 1 |
Sales Tax 2 | Second Sales Tax Code | 2 |
Sales Tax 3 | Third Sales Tax Code | 3 |
Sales Tax 4 | Fourth Sales Tax Code | 4 |
Sales Tax 1 Exempt No | First Sales Tax Exempt Number | 123456 |
Sales Tax 2 Exempt No | Second Sales Tax Exempt Number | 234567 |
Sales Tax 3 Exempt No | Third Sales Tax Exempt Number | 345678 |
Sales Tax 4 Exempt No | Fourth Sales Tax Exempt Number | 456789 |
Last P.O. Number | Last Purchase Order number | 0000700055 |
Last Payment Reference | Last Payment Reference | 1001 |
Last P.O. Date | Last Purchase Order date | 01/01/2024 |
Credit Type | Vendor’s Credit Limit Type; 0 = No Credit 1 = Unlimited Credit 2 = Limited Credit | 2 |
Credit Limit | Vendor's Credit Limit | 1000 |
On Hold | Vendor's on hold flag; F = Not on hold T = On hold | F |
Status | Vendor's current status; A = Active I = Inactive | A |
GL Payables Account | Payables GL Account | 21120 |
GL Expense Account | Expense GL Account | 82320 |
Vendor Account No | The companies account number with this supplier | 123456789 |
Notes | Noted field of the General tab | Note |
Buyer | Buyer field of the General tab | Frank |
Terms Code | Payment Terms Code | NET30 |
Currency | Vendor currency | CAD |
Print Cheques | Print cheques by default; F = No T = Yes | F |
Purchase Order Type | Not in use, to be removed | N/A |
Reference | Reference field of the General tab | Reference |
Print CPRS | Print CPRS; F = No T = Yes | T |
Tax ID Type | CPRS/1099 Type flag; B = Business Number U = Social Insurance Number | B |
Tax ID | Business number or Social Insurance number | 123456789 |
Remit Name | Remit Address Name | ABC 123 Co, Head Office |
Remit Address 1 | Remit address line 1 | PO Box 123 |
Remit Address 2 | Remit address line 2 | |
Remit Address 3 | Remit address line 3 | |
Remit Addres 4 | Remit address line 4 | |
Remit City | Remit city | Langley |
Remit Province | Remit province (2 digit code) | BC |
Remit Country | Remit country (3 digit code) | CAN |
Remit Postal Code | Remit postal code | V2E 0E2 |
Remit Phone | Remit phone number | 555-555-5555 |
Remit Fax | Remit fax number | 555-555-5555 |
Remit Email | Remit email address | ABC@email.ca |
Remit Web page | Remit URL | www.abc123.com |
Remit Contact #1 Name | First remit contact | Jane |
Remit Contact #1 Tel No. | First remit contact telephone nuber | 555-555-5555 |
Remit Contact #1 cell | First remit contact cell phone | 555-555-5555 |
Remit Contact #1 other | FIrst remit contact other | Office Admin. |
Remit Contact #1 email | First remit contact email | Jane@email.ca |
Remit Contact #1 type | First remit contact type | Accounting |
Remit Contact #2 Name | Second remit contact name | Bill |
Remit Contact #2 Tel No. | Second remit contact phone number | 555-555-5555 |
Remit Contact #2 cell | Second remit contact cell phone | 555-555-5555 |
Remit Contact #2 other | Second remit contact other | Bill junior |
Remit Contact #2 email | Second remit contact email | Bill@email.ca |
Remit Contact #2 type | Second remit contact type | Sales |
Remit Contact #3 Name | Third remit contact name | Bill Senior |
Remit Contact #3 Tel No. | Third remit contact phone number | 555-555-5555 |
Remit Contact #3 cell | Third remit contact cell phone | 555-555-5555 |
Remit Contact #3 other | Third remit contact other | CEO |
Remit Contact #3 email | Third remit contact email | BillABC@email.ca |
Remit Contact #3 type | Third remit contact type | Main |