Importing/Exporting - Activities Field

Activities Fields

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

Field

Description and Character Limits

*Activity ID

30 characters, alphanumeric

Activity Name

30 characters, alphanumeric

Description

255 characters, alphanumeric

Use Desc. On Sale

1 character. (Available only for chargeable activities.) Any non-blank character signifies that the description should be used on the invoice instead of the item name.

Non-Hourly

1 character. Any non-blank character signifies that the Type of this activity is Non-Hourly. Blank field indicates Hourly. (Won't update information on existing records.)

Non-Chargeable

1 character. Any non-blank character signifies that the Status of an activity is Non-Chargeable; a blank field indicates Chargeable. (Won't update information on existing records.)

Use Rate

1 character, alphabetic. (Available only when an activity is hourly and chargeable.) Use one of the following letters to indicate which rate to use:
E - Employee Billing Rate
C - Customer Billing Rate
A - Activity Rate

Activity Rate

11 digits, including 4 decimal places. This field is available only for chargeable non-hourly activities, and hourly activities when the Use Activity Rate has been specified.

Income Acct.

5 characters, numeric. Required for chargeable activities. When importing, must match a preexisting account in the MYOB Premier Accounting company file. May have an optional non-numeric separator between the first digit and the last 4 digits (example: 1-1234).

Tax When Sold

1 character. Any non-blank character signifies that the item is taxable when sold.

Unit of Measure

5 characters, alphanumeric (May be entered for non-hourly activities. Hour is automatically entered for hourly activities.)

Inactive Activity

If the field is blank or the letter N appears in the field, the activity won't be marked; it will have active status.
If the field contains a Y or any non-blank character (other than N), the activity will be marked; it will have inactive status.

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

Field	Description and Character Limits
*Activity ID	30 characters, alphanumeric
Activity Name	30 characters, alphanumeric
Description	255 characters, alphanumeric
Use Desc. On Sale	1 character. (Available only for chargeable activities.) Any non-blank character signifies that the description should be used on the invoice instead of the item name.
Non-Hourly	1 character. Any non-blank character signifies that the Type of this activity is Non-Hourly. Blank field indicates Hourly. (Won't update information on existing records.)
Non-Chargeable	1 character. Any non-blank character signifies that the Status of an activity is Non-Chargeable; a blank field indicates Chargeable. (Won't update information on existing records.)
Use Rate	1 character, alphabetic. (Available only when an activity is hourly and chargeable.) Use one of the following letters to indicate which rate to use: E - Employee Billing Rate C - Customer Billing Rate A - Activity Rate
Activity Rate	11 digits, including 4 decimal places. This field is available only for chargeable non-hourly activities, and hourly activities when the Use Activity Rate has been specified.
Income Acct.	5 characters, numeric. Required for chargeable activities. When importing, must match a preexisting account in the MYOB Premier Accounting company file. May have an optional non-numeric separator between the first digit and the last 4 digits (example: 1-1234).
Tax When Sold	1 character. Any non-blank character signifies that the item is taxable when sold.
Unit of Measure	5 characters, alphanumeric (May be entered for non-hourly activities. Hour is automatically entered for hourly activities.)
Inactive Activity	If the field is blank or the letter N appears in the field, the activity won't be marked; it will have active status. If the field contains a Y or any non-blank character (other than N), the activity will be marked; it will have inactive status.