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.

^Emp.Card ID

15 characters, alphanumeric. Must be a unique ID.

Note: When you select Card ID in the Identify Card by field, *None is equivalent to no entry in the field.

^Emp. Record ID

10 numeric characters

The Record ID is an internal number within the MYOB AccountEdge company file.

^Conditional Fields:  When importing, one or more fields must contain valid entries for matching fields in the company file.

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