SOPTYPE | smallint | Yes | 1=QUOTE,2=ORDER,3=INVOICE,4=RETURN,5=BKORDER,6=FULFILLMENT ORDER | IN |
TAXTYPE | smallint | Yes | 0=Regular,1=Freight,2=Misc. - Optional/Required | IN |
CUSTNMBR | char(15) | Yes | Customer Number - Optional/Required | IN |
LNITMSEQ | int | Yes | Line Item Sequence -Ignored for Freight/Misc. - Optional/Required | IN |
SALESAMT | numeric(19,5) | No | Details Taxable Amount for Sales/Freight/Misc. - Optional | IN |
FRTTXAMT | numeric(19,5) | No | Freight Tax -Must be on Freight record and 0 Sequence Number record - Optional | IN |
MSCTXAMT | numeric(19,5) | No | Misc. Tax -Must be on Misc. record and 0 Sequence Number record - Optional | IN |
FREIGHT | numeric(19,5) | No | Freight Amount-Must be on Freight record and 0 Sequence Number record- Optional | IN |
MISCAMNT | numeric(19,5) | No | Misc Amount -Must be on Misc. record and 0 Sequence Number record - Optional | IN |
STAXAMNT | numeric(19,5) | No | Sales Tax Amount -Not used for Freight/Misc. records - Optional | IN |
RequesterTrx | smallint | No | Requester Transaction - 0=false,1=true - if true than populates Requester shadow table | IN |
USRDEFND1 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND2 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND3 | char(50) | No | User Defined field - developer use only | IN |
USRDEFND4 | varchar(8000) | No | User Defined field - developer use only | IN |
USRDEFND5 | varchar(8000) | No | User Defined field - developer use only | IN |
ErrorState | int | No | Create Custom Business Logic | INOUT |
oErrString | varchar(255) | No | Create Custom Business Logic | INOUT |