SLPRSNID

string

15

Y

Not applicable

Salesperson ID

SALSTERR

string

15

Y

Not applicable

Territory ID

EMPLOYID

string

15

N

<blank>

Employee ID

VEDORID

string

15

N

<blank>

Vendor ID

SLPRSNFN

string

15

N

<blank>

Salesperson first name

SPRSNSMN

string

15

N

<blank>

Salesperson middle name

SPRSNSLN

string

20

N

<blank>

Salesperson last name

ADDRESS1

string

60

N

<blank>

Address ID 1

ADDRESS2

string

60

N

<blank>

Address ID 2

ADDRESS3

string

60

N

<blank>

Address ID 3

CITY

string

35

N

<blank>

City

STATE

string

29

N

<blank>

State

ZIP

string

10

N

<blank>

ZIP Code

COUNTRY

string

60

N

<blank>

Country

PHONE1

string

21

N

00000000000000

Phone1

PHONE2

string

21

N

00000000000000

Phone2

PHONE3

string

21

N

00000000000000

Phone3

FAX

string

21

N

00000000000000

Fax

INACTIVE

i4

1

N

0

Inactive salesperson

COMMCODE

string

15

N

<blank>

Commission code

COMPRCNT

number

21

N

0

Commission percent

STDCPRCT

number

21

N

0

Standard commission percent

COMAPPTO

i4

2

N

0

Commission applied: Apply to sales=0; Invoice=1

COSTTODT

number

21

N

0

Cost to date

CSTLSTYR

number

21

N

0

Cost last year

TTLCOMTD

number

21

N

0

Total commissions to date

TTLCOMLY

number

21

N

0

Total commissions last year

COMSLTDT

number

21

N

0

Commissioned sales to date

COMSLLYR

number

21

N

0

Commissioned sales last year

NCOMSLTD

number

21

N

0

Non-commissioned sales to date

NCOMSLYR

number

21

N

0

Non-commissioned sales last year

KPCALHST

i4

1

N

1

Keep calendar history

KPERHIST

i4

1

N

1

Keep fiscal year history

MODIFDT

datetime

16

N

<blank>

Modified date

CREATDDT

datetime

16

N

<blank>

Create date

COMMDEST

i4

2

N

0

Commission destination

UpdateIfExists

i4

1

N

0

Flag to allow data to be updated if it exists:

0=No;

1=Yes

RequesterTrx

i4

2

N

0

Requester transaction:

0=False;

1=True (if True, it populates 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>

Use-defined field—developer use only

USRDEFND5

string

8000

N

<blank>

User-defined field—developer use only