Importing and exporting > Importing data into MYOB AccountEdge > Field descriptions for importing and exporting >>
Field |
Description and Character Limits |
*Emp. Co./Last Name |
Must match a preexisting employee card or vendor card in your MYOB software company file. If a company name (no first name), 50 characters, alphanumeric. If a last name, 30 characters, alphanumeric. (If the card is an individual, must match both the first and last name in this format: the last name followed by a comma and a space, followed by the first name.) |
Emp. First Name |
20 characters, alphanumeric |
Slip ID |
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. |
*Activity ID |
30 characters, alphanumeric. Must match a preexisting Activity ID in your MYOB software company file. |
Cust. Co./Last Name |
Must match a preexisting customer card in your MYOB software company file. If a company name (no first name), 31 characters, alphanumeric. If a last name, 15 characters, alphanumeric. (If the card is an individual, MYOB AccountEdge matches the last name followed by a comma and a space, followed by the first name.) |
Cust. First Name |
15 characters, alphanumeric |
Units |
11 characters, numeric, including 2 decimal places |
Rate |
11 characters, numeric, including 2 decimal places. Available only for chargeable activities. |
Job |
15 characters, alphanumeric. Must match preexisting job in your MYOB software company file. Available only for chargeable activities. |
Notes |
255 characters, alphanumeric |
Adjustment Dollars |
11 characters, numeric, including 2 decimal places. Available only for chargeable activities. |
Adjustment Units |
11 characters, numeric, including 2 decimal places. Available only for chargeable activities. |
Already Billed Dollars |
11 characters, numeric, including 2 decimal places. Available only for chargeable activities. |
Already Billed Units |
11 characters, numeric, including 2 decimal places. Available only for chargeable activities. |
Start Time |
7 characters, numeric in the form hh.mm. Available only for hourly activities. |
Stop Time |
7 characters, numeric in the form hh.mm. Available only for hourly activities. |
*This is a Required Field: When importing, this field must have a valid matching import field.