Importing and exporting > Importing data into MYOB AccountEdge > Field descriptions for importing and exporting >>
Field |
Description and Character Limits |
*Bank Account |
5 characters, numeric. May (optionally) have a non-numeric separator between the first digit and the last 4 digits (for example, 1-1234). If the bank account doesn't exist in AccountEdge, a default account is substituted. |
Check #: |
8 characters, alphanumeric |
*Date |
10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as a separator between months, days and years. |
Co./Last Name |
255 characters, alphanumeric |
First name |
255 characters, alphanumeric |
Addr 1 - Line 1 |
255 characters, alphanumeric |
- Line 2 |
255 characters, alphanumeric |
- Line 3 |
255 characters, alphanumeric |
- Line 4 |
255 characters, alphanumeric |
Memo |
255 characters, alphanumeric |
*Allocation Account # |
Must be valid, preexisting MYOB software account number. 5 characters, numeric. May (optionally) have a non-numeric separator between the first digit and the last 4 digits (for example, 1-1234). |
Amount |
18 characters (including dollar sign, comma and negative sign). If no decimal entered, MYOB AccountEdge appends .00. If more than 2 decimals, MYOB software rounds to the nearest cent. |
Job |
15 characters, alphanumeric |
Allocation Memo |
255 characters, alphanumeric |
Import Duty Amount |
18 characters (including dollar sign, comma and negative sign). If no decimal entered, MYOB AccountEdge appends .00. If more than 2 decimals, MYOB software rounds to the nearest cent. |
Already Printed |
1 character alphanumeric indicates the transaction has already been printed. |
Currency Code |
3 character alphanumeric. |
Exchange Rate |
10 digits, including 9 decimal places. If blank, current exchange rate substituted |
Allocation Memo |
255 characters, alphanumeric |
Category |
15 characters, alphanumeric |
*This is a Required Field: When importing, this field must have a valid matching import field.