Importing and exporting > Importing data into MYOB AccountEdge > Field descriptions for importing and exporting >>
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. |
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 |
-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 |
^This is a Conditional Field: When importing, one or both fields must have a valid matching import field.