Element name |
Data type |
Length |
Required |
Default |
Description |
---|---|---|---|---|---|
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 |