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
Customer No (Required)Customer NoABC123
NameCustomer NameABC Company
Ship-to NameName for the Ship To AddressLANGLEY
Address 1Address Line 1PO Box 123
Address 2Address Line 2
Address 3Address Line 3
Address 4Address Line 4
CityCityLangley
ProvinceProvince (2 digit code)BC
CountryCountry (3 digit code)CAN
Postal CodePostal CodeV2E 0E2
PhonePhone number555-555-5555
FaxFax number555-555-5555
EmailEmail address[email protected]
Web pageCompany URL
www.abc123.com
Ship Via CodeShipping Method Code01
Contact #1 NameFirst Contact name
Jane
Contact #1 Tel No.First Contact phone number555-555-5555
Contact #1 cell
First Contact cell number 555-555-5555
Contact #1 otherFirst Contact otherOffice Admin.
Contact #1 emailFirst Contact email[email protected]
Contact #1 typeFirst Contact type;
Not working in version 3.11
Accounting
Contact #2 Name
Second Contact nameBill
Contact #2 Tel No.
Second Contact phone number555-555-5555
Contact #2 cell
Second Contact cell phone555-555-5555
Contact #2 other
Second Contact otherBill junior
Contact #2 email
Second Contact email[email protected]
Contact #2 type
Second Contact type;
Not working in version 3.11
Sales
Contact #3 Name
Third Contact nameBill Senior
Contact #3 Tel No.
Third Contact phone number555-555-5555
Contact #3 cell
Third Contact cell phone555-555-5555
Contact #3 other
Third Contact otherCEO
Contact #3 email
Third Contact email[email protected]
Contact #3 type
Third Contact type;
Not working in version 3.11
Main
Ship To On HoldHold Address check box on the Address;
F = Not on hold
T = On hold
F
Sales Tax 1First Sales Tax Code1
Sales Tax 2Second Sales Tax Code2
Sales Tax 3Third Sales Tax Code3
Sales Tax 4Fourth Sales Tax Code4
Sales Tax 1 Exempt NoFirst Sales Tax Exempt Number123456
Sales Tax 2 Exempt No
Second Sales Tax Exempt Number234567
Sales Tax 3 Exempt No
Third Sales Tax Exempt Number345678
Sales Tax 4 Exempt No
Fourth Sales Tax Exempt Number456789
Selling price levelSelling Price Level01
Revenue GL AccountRevenue GL Account of the Ship To Address for use when the Company Setting "Override Sales Account" is checked under Customers41300
WarehouseDefault warehouse for the Ship To AddressVA
SalespersonDefault Salesperson for the Ship To AddressMary
Territory CodeDefault Territory Code for the Ship To AddressDESIGNERS
Last Invoice NoCustomer's last invoice number posted
0000620387
Last Invoice DateCustomer's last date invoice date
01/15/2024
Credit TypeCustomer’s Credit Limit Type;
0 = No Credit
1 = Unlimited Credit
2 = Limited Credit
2
Credit LimitCustomer's credit limit
1000
On HoldCustomer's on hold flag;
F = Not on hold
T = On hold
F
StatusCustomer's current status;
A = Active
I = Inactive
P = Prospect
A
Statement Method

Customer's Statements setting; 

B = Both form and email 

E = Email 

F = Form 

N = Not required

E
Invoice MethodCustomer's Invoices setting;
B = Both form and email
E = Email
F = Form
N = Not required
E
PO Number RequiredCustomer's purchase order number required flag;
F = No
T = Yes
F
Apply Financial ChargesCustomer's status for charging service / finance charges;
F = Not exempt, charge service fee
T = Exempt, do not charge fee
T
DiscountCustomer's default invoice discount % that is applied after line discounts
2
Receivable AccountGL Account for Accounts Receivables
11210
User Defined 1Value for User Defined 1 field that is set in Company Settings > Variables and is displayed in the General tabWHOLESALE
User Defined 2
Value for User Defined 1 field that is set in Company Settings > Variables and is displayed in the General tab
Misc.
CurrencyCustomer currency CAD
Special CodeSpecial Code field in the General tab;
A-Z for use only in reporting and filtering.
A
Terms CodeExisting Payment Terms CodeNET30
Default Ship To IDDefault Ship To Address IDLANGLEY
ReferenceReference field in the General tab
Reference