Field |
Description and Character Limits |
*Co./Last Name |
If a company name (no first name), 50 characters, alphanumeric. If a last name, 30 characters, alphanumeric. |
First Name |
20 characters, alphanumeric |
Card ID |
15 characters, alphanumeric |
Card Status |
If the field is blank or the letter N appears in the field, the card won't be marked; the card will have an active status. If the field contains a Y or any non-blank character (other than N), the card will be marked; the card will have an inactive status. For information about updating the status of existing records, see Updating the active/inactive status of cards, items, activities or accounts. |
Currency Code |
3 characters, alpha. Must match a preexisting currency code in the Currency List. If no code specified, local currency substituted. |
The Addr field through the Salutation field repeat for each of the five addresses allowed per card entry. | |
Addr 1 (2-3-4-5) - Line 1 - Line 2 - Line 3 - Line 4 |
Total Address field (lines 1 through 4) cannot exceed 255 characters, alphanumeric |
-City |
Cannot exceed 255 characters, alphanumeric |
State |
Cannot exceed 255 characters, alphanumeric |
-ZIP Code |
10 characters, alphanumeric |
-Country |
255 characters, alphanumeric |
-Phone #1 |
21 characters, alphanumeric |
-Phone #2 |
21 characters, alphanumeric |
-Phone #3 |
21 characters, alphanumeric |
-Fax # |
21 characters, alphanumeric |
21 characters, alphanumeric | |
-WWW |
21 characters, alphanumeric |
-Contact Name |
25 characters, alphanumeric |
-Salutation |
15 characters, alphanumeric |
Picture |
File name of the graphic. 255 characters, alphanumeric. |
Notes |
255 characters, alphanumeric |
Identifiers |
10 characters, alpha only |
Custom List 1 |
30 characters, alphanumeric |
Custom List 2 |
30 characters, alphanumeric |
Custom List 3 |
30 characters, alphanumeric |
Custom Field 1 |
30 characters, alphanumeric |
Custom Field 2 |
30 characters, alphanumeric |
Custom Field 3 |
30 characters, alphanumeric |
Billing Rate |
10 characters, numeric including 4 decimal places |
Cost Per Hour |
10 characters, numeric including 4 decimal places |
Terms - Payment is Due |
1 character, numeric. Use one of these codes to indicate when payment is due: 0 - COD |
- Discount Days |
3 characters, numeric-based on the code you enter in the Payment is Due field. If you choose code 0, 1, 2 or 4 to indicate Payment is Due, enter a number of days from 0-999. If you choose code 3 or 5, use a date from 1-31. (EOM=31) |
- Balance Due Days |
3 characters, numeric-based on the code you enter in the Payment is Due field. If you choose code 0, 1, 2 or 4 to indicate when payment is due, use a number of days from 0-999. If you choose code 3 or 5, use a date from 1-31. (EOM=31) |
- % Discount |
2 characters, numeric before a decimal point and 2 characters, numeric after a decimal point. |
- 1099 |
2 characters, numeric. Use one of these codes to indicate how you want to report 1099 payments: Blank or 0 - Not 1099 6 - Non-Employee Comp. |
Tax Code |
3 characters, alphanumeric. |
Credit Limit |
7 characters, numeric before a decimal point and 2 characters, numeric after a decimal point. |
Tax ID No. |
19 characters, alphanumeric |
Volume Discount% |
2 characters, numeric before a decimal point and 2 characters, numeric after a decimal point. |
Sales/Purchase Layout |
S indicates Service, I indicates Item, P indicates Professional and M indicates Miscellaneous invoice or purchase order layout. T indicates Time Billing invoice layout. |
Account |
5 characters, numeric. May (optionally) have a non-numeric separator between the first digit and the last 4 digits, for example, 1-1234. |
Comment |
255 characters, alphanumeric. |
Shipping Method |
20 characters, alphanumeric |
Printed Form |
255 characters, alphanumeric |
Freight Tax Code |
3 characters, alphanumeric. |
*This is a required field for importing.