SOPTYPE

i4

2

Y

Not applicable

1=Quote;

2=Order;

3=Invoice;

4=Return;

5=Back order;

6=Fulfillment order

TAXTYPE

i4

2

N

0

0=Regular;

1=Freight;

2=Miscellaneous (required/optional field)

SOPNUMBE

string

21

Y

Not applicable

Invoice number

CUSTNMBR

string

15

Y

Not applicable

Customer number (required/optional field)

LNITMSEQ

i4

4

N

0

Line item sequence—ignored for freight/miscellaneous required/optional field

SALESAMT

number

21

N

0

Details taxable amount for sales

FRTTXAMT

number

21

N

0

Freight tax—must be on freight record and 0 sequence number record

MSCTXAMT

number

21

N

0

Miscellaneous tax—must be on miscellaneous record and 0 sequence number record

FREIGHT

number

21

N

0

Freight amount—must be on freight record and 0 sequence number record

MISCAMNT

number

21

N

0

Miscellaneous amount—must be on miscellaneous record and 0 sequence number record

TAXDTLID

string

15

Y

Not applicable

Tax detail ID

ACTINDX

i4

4

N

0

Account index

ACTNUMST

string

75

N

<blank>

Account number string

STAXAMNT

number

21

N

0

Sales tax amount—not used for freight

TDTTXSLS

number

21

N

Default from setup

Total taxable sales amount

TXDTOTTX

number

21

N

Default from setup

Tax detail total tax potential

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