Importing and exporting

Activity Slips Fields

View a list of all types of fields: Field descriptions for importing and exporting

Field

Description and Character Limits

*Emp. Co./Last Name

When importing, must match a preexisting employee card or vendor card in the MYOB AccountEdge 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, AccountEdge matches the last name, followed by a comma and a space and 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. When importing, must match a preexisting Activity ID in the AccountEdge company file.

Cust. Co./Last Name

When importing, must match a preexisting customer card in the MYOB AccountEdge 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, AccountEdge matches the last name, followed by a comma and a space and 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. When importing, must match a preexisting job in the MYOB AccountEdge 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.

*Required Field:  When importing, this field must have a valid matching import field.