Element name | Data type | Length | Required | Default | Description |
|---|---|---|---|---|---|
SOPTYPE | i4 | 2 | Y | Not applicable | SOP type: 1=Quote; 2=Order; 3=Invoice; 4=Return; 5=Bkorder; 6=Fulfillment order |
SOPNUMBE | string | 21 | Y | Not applicable | SOP number |
SEQNUMBR | i4 | 4 | N | 0 | Sequence number |
DISTTYPE | i4 | 2 | Y | Not applicable | Distribution type: 1=Sales; 2=Receiving; 3=Cash; 4=Taken; 5=Available; 6=Trade; 7=Freight; 8=Miscellaneous; 9=Taxes; 10=Mark; 11=Commission Expense; 12=Commission pay; 13=Other; 14=COGS; 15=Invoice; 16=Returns; 17=In use; 18=In service; 19=Damaged; 20=Unit; 21=Deposits; 22=Round |
DistRef | string | 30 | N | <blank> | Distribution reference |
ACTINDX | i4 | 4 | N | 0 | Account index |
ACTNUMST | string | 75 | N | <blank> | Account number string |
DEBITAMT | number | 21 | N | 0 | Debit amount |
CRDTAMNT | number | 21 | N | 0 | Credit amount |
CUSTNMBR | string | 15 | Y | Not applicable | Customer number |
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 |
The valid distribution types for each SOPTYPE are as follows:
SOPTYPE | Distribution types |
|---|---|
3 | 1 , 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, or 21 |
4 | 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, or 21 |