| SOPTYPE | smallint | Yes | 1=QUOTE,2=ORDER,3=INVOICE,4=RETURN,5=BKORDER,6=FULFILLMENT ORDER | IN |
| DOCID | char(15) | Yes | Document ID, key field in SOP40200 | IN |
| SOPNUMBE | char(21) | Yes | Invoice Number | IN |
| ORIGNUMB | char(21) | No | Order Number | IN |
| ORIGTYPE | smallint | No | Document Type of the Originating SOP Document - 0 if this is original document | IN |
| TAXSCHID | char(15) | Yes | Tax Schedule if you have taxes | IN |
| FRTSCHID | char(15) | No | Freight Schedule - optional | IN |
| MSCSCHID | char(15) | No | Misc Tax Schedule - optional | IN |
| SHIPMTHD | char(15) | No | Shipping Method | IN |
| TAXAMNT | numeric(19,5) | Yes | Tax Amount if line items have tax | IN |
| LOCNCODE | char(10) | No | Will use default from IV if empty | IN |
| DOCDATE | datetime | Yes | Document Date | IN |
| FREIGHT | numeric(19,5) | No | Freight amount | IN |
| MISCAMNT | numeric(19,5) | No | Misc amount | IN |
| TRDISAMT | numeric(19,5) | No | Trade Discount Amount | IN |
| TRADEPCT | numeric(19,5) | No | Trade Discount Percentage | IN |
| DISTKNAM | numeric(19,5) | No | Discount Taken Amount | IN |
| MRKDNAMT | numeric(19,5) | No | Markdown Amount | IN |
| CUSTNMBR | char(15) | Yes | Customer Number | IN |
| CUSTNAME | char(64) | No | Customer Name | IN |
| CSTPONBR | char(20) | No | Customer Purchase Order Number | IN |
| ShipToName | char(64) | No | Ship to Name | IN |
| ADDRESS1 | char(60) | No | Customer Address One | IN |
| ADDRESS2 | char(60) | No | Customer Address Two | IN |
| ADDRESS3 | char(60) | No | Customer Address Three | IN |
| CNTCPRSN | char(60) | No | Contact Person | IN |
| FAXNUMBR | char(21) | No | Fax Number | IN |
| CITY | char(35) | No | Customer City | IN |
| STATE | char(29) | No | Customer State | IN |
| ZIPCODE | char(10) | No | Customer Zip | IN |
| COUNTRY | char(60) | No | Customer Country | IN |
| PHNUMBR1 | char(21) | No | Phone one | IN |
| PHNUMBR2 | char(21) | No | Phone two | IN |
| PHNUMBR3 | char(21) | No | Phone three - Added for Release 6.0 | IN |
| Print_Phone_NumberGB | smallint | No | | IN |
| SUBTOTAL | numeric(19,5) | Yes | Subtotal = Total before taxes | IN |
| DOCAMNT | numeric(19,5) | Yes | Document Amount/Total | IN |
| PYMTRCVD | numeric(19,5) | Yes | Total of all Deposits and Payments | IN |
| SALSTERR | char(15) | No | Sales Territory | IN |
| SLPRSNID | char(15) | No | Sales Person ID | IN |
| UPSZONE | char(3) | No | UPS Zone | IN |
| USER2ENT | char(15) | No | User Who Entered | IN |
| BACHNUMB | char(15) | No | Batch Number | IN |
| PRBTADCD | char(15) | No | Primary Bill to Address Code | IN |
| PRSTADCD | char(15) | No | Primary Ship to Address Code | IN |
| FRTTXAMT | numeric(19,5) | No | Freight Tax Amount | IN |
| MSCTXAMT | numeric(19,5) | No | Misc Tax Amount | IN |
| ORDRDATE | datetime | No | Order Date | IN |
| MSTRNUMB | int | No | Master Number, defaults to next number if 0 | IN |
| PYMTRMID | char(20) | No | Payment term id, defaults from customer if not passed in | IN |
| DUEDATE | datetime | No | Due Date | IN |
| DISCDATE | datetime | No | Discount Date | IN |
| REFRENCE | char(30) | No | GL Reference | IN |
| USINGHEADERLEVELTAXES | int | No | Header Level Taxes | IN |
| BatchCHEKBKID | char(15) | No | Checkbook ID for the batch | IN |
| CREATECOMM | smallint | No | Flag to auto create commissions: 0=Manual; 1=Automatic - use if not callind taSopCommissions node | IN |
| COMMAMNT | numeric(19,5) | No | Total Amount of commissions for this document - Used with Manual Commissions | IN |
| COMPRCNT | numeric(19,5) | No | Used for ALL salespeople if passed in and @I_vCREATECOMM = 1; leave blank to use default percentages | IN |
| CREATEDIST | smallint | No | Flag to auto create distributions: 0=Manual; 1=Automatic - use if not calling taSopDistribution node | IN |
| CREATETAXES | smallint | No | Flag to auto create taxes with tax engine, leave at 0 if integrating your own | IN |
| DEFTAXSCHDS | smallint | No | Flag to default tax schedules based on setup, only used for Freight and Misc. - see help file for Line Item | IN |
| CURNCYID | char(15) | No | Currency ID - 02/10/02 - Added for Multi-Currency | IN |
| XCHGRATE | numeric(19,5) | No | Exchange Rate - 02/10/02 - Added for Multi-Currency - MC020103 | IN |
| RATETPID | char(15) | No | Rate Type ID - 02/10/02 - Added for Multi-Currency - MC020103 | IN |
| EXPNDATE | datetime | No | Expiration Date - 02/10/02 - Added for Multi-Currency - MC00100 | IN |
| EXCHDATE | datetime | No | Exchange Date - 02/10/02 - Added for Multi-Currency - MC00100 | IN |
| EXGTBDSC | char(30) | No | Exchange ID Desc. - 02/10/02 - Added for Multi-Currency - MC40300 | IN |
| EXTBLSRC | char(50) | No | Exchange Rate Source - 02/10/02 - Added for Multi-Currency - MC40300 | IN |
| RATEEXPR | smallint | No | Rate Expiration - 02/10/02 - Added for Multi-Currency - MC40300 | IN |
| DYSTINCR | smallint | No | Days to Increment - 02/10/02 - Added for Multi-Currency - MC40300 - only used when RATEEXPR = 8 | IN |
| RATEVARC | numeric(19,5) | No | Rate Variance - 02/10/02 - Added for Multi-Currency - MC40300 | IN |
| TRXDTDEF | smallint | No | Trx Date Default - 02/10/02 - Added for Multi-Currency - MC40300 | IN |
| RTCLCMTD | smallint | No | Rate Calc. Method - 02/10/02 - Added for Multi-Currency - MC40300 | IN |
| PRVDSLMT | smallint | No | Previous Days Limits - 02/10/02 - Added for Multi-Currency - MC40300 | IN |
| DATELMTS | smallint | No | Date Limits - 02/10/02 - Added for Multi-Currency - MC40300 | IN |
| TIME1 | datetime | No | Time 1 - 08/20/01 - 03/11/02 - Added for Multi-Currency - MC40300 | IN |
| DISAVAMT | numeric(19,5) | No | DISAVAMT | IN |
| DSCDLRAM | numeric(19,5) | No | Discount Dollar Amount | IN |
| DSCPCTAM | numeric(19,5) | No | Discount Percent Amount | IN |
| FREIGTBLE | int | No | Freight Taxable 0=default from Sop Setup 1=Taxable 2=Non-taxable 3=Base on Customers | IN |
| MISCTBLE | int | No | Misc Amount Taxable 0=default from Sop Setup 1=Taxable 2=Non-taxable 3=Base on Customers | IN |
| COMMNTID | char(15) | No | Comment ID | IN |
| COMMENT_1 | char(50) | No | not required | IN |
| COMMENT_2 | char(50) | No | not required | IN |
| COMMENT_3 | char(50) | No | not required | IN |
| COMMENT_4 | char(50) | No | not required | IN |
| GPSFOINTEGRATIONID | char(30) | No | Front Office Integration ID | IN |
| INTEGRATIONSOURCE | smallint | No | Integration Source | IN |
| INTEGRATIONID | char(30) | No | Integration ID | IN |
| ReqShipDate | datetime | No | Requested Ship Date | IN |
| RequesterTrx | smallint | No | Requester Transaction - 0=false,1=true - if true than populates Requester shadow table | IN |
| CKCreditLimit | tinyint | No | 0 - Do Not check credit limit; 1 - check credit limit | IN |
| CKHOLD | tinyint | No | 0 - Do Not check Hold status; 1 - check Hold status | IN |
| UpdateExisting | tinyint | No | Used to modify header - 0=New Transaction; 1=Update Header - used to update after transaction exists | IN |
| QUOEXPDA | datetime | No | Quote Expiration Date - Defaults baed on setup if not filled in | IN |
| QUOTEDAT | datetime | No | Quote Date - Used for SOPTYPE <> 1, if SOPTYPE = 1 then DOCDATE is used | IN |
| INVODATE | datetime | No | Invoice Date - Used for SOPTYPE <> 3, if SOPTYPE = 3 then DOCDATE is used | IN |
| BACKDATE | datetime | No | Backorder Date - Used for SOPTYPE <> 4, if SOPTYPE = 4 then DOCDATE is used | IN |
| RETUDATE | datetime | No | Return Date - Used for SOPTYPE <> 5, if SOPTYPE = 5 then DOCDATE is used | IN |
| CMMTTEXT | varchar(500) | No | Comment Text; only use if not using @I_vCOMMENT_1 thu @I_vCOMMENT_4 | IN |
| PRCLEVEL | char(10) | No | Price Level | IN |
| DEFPRICING | tinyint | No | 1 = subtotal will be calculated from Sop Lines | IN |
| TAXEXMT1 | char(25) | No | Tax Exempt #1 - - will default from Customer if not supplied | IN |
| TAXEXMT2 | char(25) | No | Tax Exempt #2 - - will default from Customer if not supplied | IN |
| TXRGNNUM | char(25) | No | Tax Registration Number - - will default from Customer if not supplied | IN |
| REPTING | tinyint | No | Repeating - - 0=False & 1=True - only valid for Quotes | IN |
| TRXFREQU | smallint | No | Frequency - - 1=Weekly, 2=Biweekly, 3=Semimonthly, 4=Monthly, 5=Bi-Monthly, 6=Quarterly, & 7=Misc. only valid for Quotes | IN |
| TIMETREP | smallint | No | Times Repeating - - only valid for Quotes | IN |
| QUOTEDYSTINCR | smallint | No | Days to Increment - - only valid for Quotes | IN |
| NOTETEXT | varchar(8000) | No | Notes field | 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 | Error Code | INOUT |
| oErrString | varchar(255) | No | Comma separated list of errors encountered | INOUT |