SOPTYPE

i4

2

Y

Not applicable

1=Quote;

2=Order;

3=Invoice;

4=Return;

5=Bkorder;

6=Fulfillment order

SOPNUMBE

string

21

Y

Not applicable

Document number

LNITMSEQ

i4

4

N

0

Line sequence number—leave 0 to autocreate sequence number

SLPRSNID

string

15

Y

Not applicable

Salesperson ID

SALSTERR

string

15

N

<blank>

Sales territory

COMPRCNT

number

21

N

0

Salesperson commission percentage

COMMAMNT

number

21

N

0

Commission amount

PRCTOSAL

number

21

N

100.00

Percent of sale that the commission is based on

CUSTNMBR

string

15

Y

Not applicable

Customer number

CURNCYID

string

15

N

<blank>

Currency ID

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