EMPLOYID

string

15

Y

Not applicable

Employee ID

ADRSCODE

string

15

Y

Not applicable

Address code

ADDRESS1

string

60

N

<blank>

Address line 1

ADDRESS2

string

60

N

<blank>

Address line 2

ADDRESS3

string

60

N

<blank>

Address line 3

CITY

string

35

N

<blank>

City

STATE

string

29

N

<blank>

State

ZIPCODE

string

10

N

<blank>

ZIP Code/postal code

COUNTY

string

60

N

<blank>

County

COUNTRY

string

60

N

<blank>

Country

PHONE1

string

21

N

<blank>

Phone 1

PHONE2

string

21

N

<blank>

Phone 2

PHONE3

string

21

N

<blank>

Phone 3

FAX

string

21

N

<blank>

Fax number

Foreign_Address

i4

1

N

0

Foreign address: 0=False; 1=True

Foreign_StateProvince

string

23

N

<blank>

Foreign state or province

Foreign_Postal_Code

string

15

N

<blank>

Foreign postal code

Ccode

string

6

N

<blank>

Country code

UpdateIfExists

i4

1

N

1

Flag to allow address data to updated if it currently exists:

0=No;

1=Yes

RequesterTrx

i4

2

N

0

Requester transaction

0=False;

1=True (if True, it populates the requester shadow table)

USRDEFND1

string

50

N

<blank>

User-defined field—developer use only

USRDEFND2

string

50

N

<blank>

User-defined field—developer use only

USRDEFND3

string

50

N

<blank>

User-defined field—developer use only

USRDEFND4

string

8000

N

<blank>

User-defined field—developer use only

USRDEFND5

string

8000

N

<blank>

User-defined field—developer use only