Before cardfiles (customer, user and vendor information) can be imported into Jim2, the data must be prepared first. The following is an explanation of Jim2 CardFile fields.
Happen Business provides a spreadsheet template that can be used to import data into Jim2. Please contact support@happen.biz to obtain it.
It is very important to get the data right at this stage – the correct spelling, the look required, all the records verified. It is a lot easier and quicker to amend it now in a spreadsheet than later when it is in database form. |
The fields in red are mandatory in Jim2
Field |
Description/Use |
Data Type |
# of Chars |
Example |
---|---|---|---|---|
Card Code |
Unique card code |
String |
10 |
HAPPEN.BUS. Characters that can be used are 0-9 A-Z '.' '/' '-' . Please ensure there are no spaces. |
Name |
Name of the company |
String |
100 |
Happen Business Pty Limited |
Contact |
Name of company contact |
String |
30 |
John Smith |
Address Line 1 |
Address line 1 |
String |
250 |
Locked Bag A |
Address Line 2 |
Address line 2 |
String |
250 |
Post Office |
Address Line 3 |
Address line 3 |
String |
250 |
Morts Road |
Suburb |
Suburb |
String |
50 |
Mortdale |
State |
State |
String |
3 |
NSW |
PostCode |
Postcode |
String |
8 |
2223 |
Country |
Country |
String |
30 |
Australia |
Delivery Address Line 1 |
Delivery address line 1 |
String |
250 |
P2 Building |
Delivery Address Line 2 |
Delivery address line 2 |
String |
250 |
29-33 Pitt Street |
Delivery Address Line 3 |
Delivery address line 3 |
String |
250 |
Entrance off The Strand |
Delivery Suburb |
Delivery suburb |
String |
30 |
Mortdale |
Delivery State |
Delivery state |
String |
3 |
NSW |
Delivery PostCode |
Delivery postcode |
String |
8 |
2223 |
Delivery Country |
Delivery country |
String |
30 |
Australia |
ABN |
Customer ABN number |
String |
15 |
91 890 678 543 |
Customer |
Is this cardfile a customer? |
Boolean |
T/F |
T |
Customer Price Level |
What price level is this customer set at? |
Integer (1-5 set up in Jim2) |
- |
1-Wholesale |
Ship Card |
If shipping address is different to cardfile address (a child card). If this cardfile is only a shipping address, Customer should not be set to T. |
Boolean |
T/F |
T |
Parent Card Code |
If Ship Card, enter the card code of associated billing customer which is the entity work is invoiced to. |
String |
10 |
HAPPEN.BUS |
Customer Terms |
What terms does this customer have? |
String 10 set up in Jim2 |
- |
COD |
Customer Tax Paid |
Does this customer pay tax? |
Boolean |
T/F |
T |
Customer Credit Limit |
What is this customer's credit limit? |
Decimal |
15 |
15000.00 |
Customer on Credit Hold |
Is this customer on credit hold? |
Boolean |
T/F |
F |
Customer Delivery Details |
How to ship to this customer? |
String |
50 |
DHL |
Customer Invoice Via |
How the invoice is to be delivered to the customer (print, fax, email, etc.). |
String (preset in Jim2) |
- |
|
Customer Statement Send Via |
How the statement is to be delivered to the customer (print, fax, email, don't send). |
String (preset in Jim2) |
- |
|
Customer Account Manager |
Account manager for this customer. |
String |
10 |
Julian White |
Branch |
Enter the relevant branch against each cardfile, if branches are used. |
String |
4 |
Shepparton Branch |
Vendor |
Is the cardfile a vendor? |
Boolean |
T/F |
F |
Vendor Terms |
What terms does this vendor have? |
String 50 set up in Jim2 |
- |
- |
Vendor Tax Paid |
Does this vendor pay tax? |
Boolean |
T/F |
- |
VendAccountNo |
The account number with the supplier goes here. |
String |
15 |
- |
BSB Number |
Vendor bank BSB |
String |
7 |
082-123 |
Bank Account Number |
Vendor bank account number |
String |
9 |
576923125 |
Salutation |
Contact's title |
String |
4 |
Mr |
First Name |
Contact's first name |
String |
25 |
John |
Middle Name |
Contact's middle name |
String |
25 |
Christopher |
Last Name |
Contact's last name |
String |
25 |
Smith |
Display Name |
Name of contact to be displayed |
String |
50 |
John Smith |
Job Title |
Job title of contact |
String |
50 |
Financial Controller |
Department |
Department of contact |
String |
50 |
Accounts |
Phone |
Phone number of cardfile |
String |
100 |
+612 9570 4696 |
Fax |
Fax number of cardfile |
String |
100 |
+612 9580 8253 |
Mobile |
Mobile number of cardfile contact |
String |
100 |
0404 040 404 |
Email of cardfile contact |
String |
100 |
sales@happen.biz |
|
Web Page |
Website |
String |
100 |
https://www.jim2.com.au |
Region |
Enter the region against each cardfile, if using Regions. |
String |
- |
- |
Report Level 1 |
Jim2 Report Group, ie. Active, Prospective etc. |
String |
30 |
Jim2 Client |
Report Level 2 |
2nd level Jim2 report group |
String |
30 |
Active |
Report Level 3 |
3rd level Jim2 report group |
String |
30 |
End User |
Report Level 4 |
4th level Jim2 report group |
String |
30 |
Industry |
Report Level 5 |
5th level Jim2 report group |
String |
30 |
Sub-Industry |
When entering numbers that have a leading zero in any columns, to ensure Excel does not trim off the zeroes, set the column format to Text or add an apostrophe (') prior to the 0. |
Further information