Importing/Exporting - Cards Fields

Cards Fields - Employee

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

Field

Description and Character Limits

^Co./Last Name

If a company name (no first name), 50 characters, alphanumeric. If a last name, 30 characters, alphanumeric.

First Name

20 characters, alphanumeric.

^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.

Card Status

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

Currency Code

3 characters, alpha. When importing, must match a preexisting currency code in the Currency List. If no code specified, local currency substituted.

The Addr through Salutation fields repeat for each of the five addresses allowed per card entry.

Addr 1 (2-3-4-5)
  - Line 1
  - Line 2
  - Line 3
  - Line 4

Total Address field (lines 1 through 4) cannot exceed 255 characters, alphanumeric

  - City
  - State

Cannot exceed 255 characters, alphanumeric (each field)

  - ZIP Code

10 characters, alphanumeric.

  - Country

255 characters, alphanumeric.

  - Phone #1
  - Phone #2
  - Phone #3

21 characters, alphanumeric (each field)

  - Fax #
  - Email
  - WWW

21 characters, alphanumeric (each field)

  - Salutation

15 characters, alphanumeric.

Picture

File name of the graphic. 255 characters, alphanumeric.

Notes

255 characters, alphanumeric.

Identifiers

10 characters, alpha only.

Custom List 1
Custom List 2
Custom List 3

30 characters, alphanumeric (each field)

Custom Field 1
Custom Field 2
Custom Field 3

30 characters, alphanumeric (each field)

Billing Rate

10 characters, numeric including 4 decimal places

Cost Per Hour

10 characters, numeric including 4 decimal places

Account Type

1 character, numeric:
0 = Checking
1 = Savings

ABA

9 numeric characters

Account Number

5 characters, numeric. May have an optional non-numeric separator between the first digit and the last 4 digits (example:  1-1234).

Account Name

20 characters, alphanumeric.

Payment Method

1 character, numeric:
1 = Cash
2 = Check
3 = Electronic

^Record ID

10 numeric characters

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

BirthDate

10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as separator between months, days and years.

Hire Date

10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as separator between months, days and years

Termination Date

10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as separator between months, days and years

Social Security #

11 alphanumeric

Residence Code

4 alphanumeric. Must match a Residence Code contained within the company file:
Payroll Tax Tables must be loaded into the company file
Information must be completed in the General Payroll Information window.

Work Code

4 alphanumeric. Must match a Work Code contained within the company file:
Payroll Tax Tables must be loaded into the company file
Information must be completed in the General Payroll Information window.

Pay Basis

1 alphanumeric. S - Salary, H - Hourly
Please see Additional Requirements below.

Salary/Rate

13 characters plus 4 decimal places (Hourly Salary)
13 characters plus 2 decimal places (Annual Salary)
If more than 4 decimal places: MYOB Premier Accounting rounds Hourly Salary to 4 decimal places; Annual Salary is rounded to 2 decimal places.
Please see Additional Requirements below.

Pay Frequency

1 alphanumeric
W - Weekly
2 - Every 2 Weeks
T - Twice a Month
M - Monthly
Please see Additional Requirements below.

Hours in Pay Period

3 digits, plus 3 decimal places.
Please see Additional Requirements below.

Wages Expense Account

5 characters, numeric. May have an optional non-numeric separator between the first digit and the last 4 digits (example: 1-1234). Must be a valid, preexisting MYOB account number.
Please see Additional Requirements below.

Federal Marital Status

1 alphabetic.
M = Married
S = Single
H = Head of Household
O = Other
Please see Additional Requirements below.

Federal Allowances

3 numeric.
Please see Additional Requirements below.

Federal Extra Withheld

13 digits, plus 2 decimal places.
Please see Additional Requirements below.

State Marital Status

1 alphabetic.
M = Married
S = Single
H = Head of Household
O = Other
Please see Additional Requirements below.

State Allowances

3 numeric.
Please see Additional Requirements below.

State Extra Withheld

13 digits, plus 2 decimal places.
Please see Additional Requirements below.

Local Marital Status

1 alphabetic.
M = Married
S = Single
H = Head of Household
O = Other
Please see Additional Requirements below.

Local Allowances

3 numeric.
Please see Additional Requirements below.

Local Extra Withheld

13 digits, plus 2 decimal places.
Please see Additional Requirements below.

Default Category

15 alphanumeric. Must match an existing Category in the company file.
Please see Additional Requirements below.

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

Additional Requirements

Payroll Tax Tables must be loaded into the company file. (To load payroll tax tables)

Information must be completed in the General Payroll Information window.

Residence Code and Work Code must be assigned to the employee card. (To add an employee card)

Field	Description and Character Limits
^Co./Last Name	If a company name (no first name), 50 characters, alphanumeric. If a last name, 30 characters, alphanumeric.
First Name	20 characters, alphanumeric.
^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.
Card Status	If the field is blank or the letter N appears in the field, the card won't be marked; it will have active status. If the field contains a Y or any non-blank character (other then N), the card will be marked; it will have inactive status.
Currency Code	3 characters, alpha. When importing, must match a preexisting currency code in the Currency List. If no code specified, local currency substituted.
The Addr through Salutation fields repeat for each of the five addresses allowed per card entry.
Addr 1 (2-3-4-5) - Line 1 - Line 2 - Line 3 - Line 4	Total Address field (lines 1 through 4) cannot exceed 255 characters, alphanumeric
- City - State	Cannot exceed 255 characters, alphanumeric (each field)
- ZIP Code	10 characters, alphanumeric.
- Country	255 characters, alphanumeric.
- Phone #1 - Phone #2 - Phone #3	21 characters, alphanumeric (each field)
- Fax # - Email - WWW	21 characters, alphanumeric (each field)
- Salutation	15 characters, alphanumeric.
Picture	File name of the graphic. 255 characters, alphanumeric.
Notes	255 characters, alphanumeric.
Identifiers	10 characters, alpha only.
Custom List 1 Custom List 2 Custom List 3	30 characters, alphanumeric (each field)
Custom Field 1 Custom Field 2 Custom Field 3	30 characters, alphanumeric (each field)
Billing Rate	10 characters, numeric including 4 decimal places
Cost Per Hour	10 characters, numeric including 4 decimal places
Account Type	1 character, numeric: 0 = Checking 1 = Savings
ABA	9 numeric characters
Account Number	5 characters, numeric. May have an optional non-numeric separator between the first digit and the last 4 digits (example: 1-1234).
Account Name	20 characters, alphanumeric.
Payment Method	1 character, numeric: 1 = Cash 2 = Check 3 = Electronic
^Record ID	10 numeric characters The Record ID is an internal number within the MYOB Premier Accounting company file.
BirthDate	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as separator between months, days and years.
Hire Date	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as separator between months, days and years
Termination Date	10 characters, alphanumeric. Follows date convention of your system. Allows any non-numeric as separator between months, days and years
Social Security #	11 alphanumeric
Residence Code	4 alphanumeric. Must match a Residence Code contained within the company file: Payroll Tax Tables must be loaded into the company file Information must be completed in the General Payroll Information window.
Work Code	4 alphanumeric. Must match a Work Code contained within the company file: Payroll Tax Tables must be loaded into the company file Information must be completed in the General Payroll Information window.
Pay Basis	1 alphanumeric. S - Salary, H - Hourly Please see Additional Requirements below.
Salary/Rate	13 characters plus 4 decimal places (Hourly Salary) 13 characters plus 2 decimal places (Annual Salary) If more than 4 decimal places: MYOB Premier Accounting rounds Hourly Salary to 4 decimal places; Annual Salary is rounded to 2 decimal places. Please see Additional Requirements below.
Pay Frequency	1 alphanumeric W - Weekly 2 - Every 2 Weeks T - Twice a Month M - Monthly Please see Additional Requirements below.
Hours in Pay Period	3 digits, plus 3 decimal places. Please see Additional Requirements below.
Wages Expense Account	5 characters, numeric. May have an optional non-numeric separator between the first digit and the last 4 digits (example: 1-1234). Must be a valid, preexisting MYOB account number. Please see Additional Requirements below.
Federal Marital Status	1 alphabetic. M = Married S = Single H = Head of Household O = Other Please see Additional Requirements below.
Federal Allowances	3 numeric. Please see Additional Requirements below.
Federal Extra Withheld	13 digits, plus 2 decimal places. Please see Additional Requirements below.
State Marital Status	1 alphabetic. M = Married S = Single H = Head of Household O = Other Please see Additional Requirements below.
State Allowances	3 numeric. Please see Additional Requirements below.
State Extra Withheld	13 digits, plus 2 decimal places. Please see Additional Requirements below.
Local Marital Status	1 alphabetic. M = Married S = Single H = Head of Household O = Other Please see Additional Requirements below.
Local Allowances	3 numeric. Please see Additional Requirements below.
Local Extra Withheld	13 digits, plus 2 decimal places. Please see Additional Requirements below.
Default Category	15 alphanumeric. Must match an existing Category in the company file. Please see Additional Requirements below.