Importing/Exporting - Cards Fields

Cards Fields - Employee

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

Card Status

If the field is blank or the letter N appears in the field, the card won't be marked; the card will have an active status.

If the field contains a Y or any non-blank character (other then N), the card will be marked; the card will have an inactive status.

Currency Code

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

The Addr field through the Salutation field 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
- Line 5

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

- City

Cannot exceed 255 characters, alphanumeric.

- State

Cannot exceed 255 characters, alphanumeric.

- ZIP Code

10 characters, alphanumeric.

- Country

255 characters, alphanumeric.

-Phone # 1

21 characters, alphanumeric.

-Phone # 2

21 characters, alphanumeric.

-Phone # 3

21 characters, alphanumeric.

- Fax #

21 characters, alphanumeric.

- Email

21 characters, alphanumeric.

- WWW

21 characters, alphanumeric.

- 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

30 characters, alphanumeric.

Custom List 2

30 characters, alphanumeric.

Custom List 3

30 characters, alphanumeric.

Custom Field 1

30 characters, alphanumeric.

Custom Field 2

30 characters, alphanumeric.

Custom Field 3

30 characters, alphanumeric.

Billing Rate

10 characters, numeric including 4 decimal places

Cost Per Hour

10 characters, numeric including 4 decimal places

.

Payment Method

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

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

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.
Card Status	If the field is blank or the letter N appears in the field, the card won't be marked; the card will have an active status. If the field contains a Y or any non-blank character (other then N), the card will be marked; the card will have an inactive status.
Currency Code	3 characters, alpha. Must match a preexisting currency code in the Currency List. If no code specified, local currency substituted.
The Addr field through the Salutation field 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 - Line 5	Total Address field (lines 1 to 4) cannot exceed 255 characters, alphanumeric.
- City	Cannot exceed 255 characters, alphanumeric.
- State	Cannot exceed 255 characters, alphanumeric.
- ZIP Code	10 characters, alphanumeric.
- Country	255 characters, alphanumeric.
-Phone # 1	21 characters, alphanumeric.
-Phone # 2	21 characters, alphanumeric.
-Phone # 3	21 characters, alphanumeric.
- Fax #	21 characters, alphanumeric.
- Email	21 characters, alphanumeric.
- WWW	21 characters, alphanumeric.
- 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	30 characters, alphanumeric.
Custom List 2	30 characters, alphanumeric.
Custom List 3	30 characters, alphanumeric.
Custom Field 1	30 characters, alphanumeric.
Custom Field 2	30 characters, alphanumeric.
Custom Field 3	30 characters, alphanumeric.
Billing Rate	10 characters, numeric including 4 decimal places
Cost Per Hour	10 characters, numeric including 4 decimal places
	.
Payment Method	1 character numeric: 1 = Cash 2 = Check 3 = Electronic