CUSTNMBR

string

15

Y

Not applicable

Customer number

ADRSCODE

string

15

Y

Not applicable

Address ID

SLPRSNID

string

15

N

<blank>

Salesperson ID

UPSZONE

string

3

N

<blank>

UPS zone

SHIPMTHD

string

15

N

<blank>

Shipping method

TAXSCHID

string

15

N

<blank>

Tax schedule

CNTCPRSN

string

60

N

<blank>

Contact person

ADDRESS1

string

60

N

<blank>

Customer address one

ADDRESS2

string

60

N

<blank>

Customer address two

ADDRESS3

string

60

N

<blank>

Customer address three

COUNTRY

string

60

N

<blank>

Customer country

CITY

string

35

N

<blank>

Customer city

STATE

string

29

N

<blank>

Customer state

ZIPCODE

string

10

N

<blank>

Customer zip

PHNUMBR1

string

21

N

<blank>

Phone one

PHNUMBR2

string

21

N

<blank>

Phone two

PHNUMBR3

string

21

N

<blank>

Phone three

FAX

string

21

N

<blank>

Fax

GPSFOINTEGRATIONID

string

30

N

<blank>

Front office integration ID

INTEGRATIONSOURCE

i4

2

N

0

Integration source

INTEGRATIONID

string

30

N

<blank>

Integration ID

CCode

string

6

N

<blank>

Country code

LOCNCODE

string

10

N

<blank>

Location code

SALSTERR

string

15

N

<blank>

Sales territory

USERDEF1

string

20

N

<blank>

User defined 1

USERDEF2

string

20

N

<blank>

User defined 2

UpdateIfExists

i4

1

N

1

Flag to allow updates to customer data:

0=No not update;

1=Update if exists

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