| SOPTYPE | smallint | Yes | 1=QUOTE,2=ORDER,3=INVOICE,4=RETURN,5=BKORDER,6=FULFILLMENT ORDER | IN |
| SOPNUMBE | char(21) | Yes | Invoice Number | IN |
| CUSTNMBR | char(15) | Yes | Customer Number | IN |
| DOCDATE | datetime | No | Invoice Date | IN |
| USERDATE | datetime | No | User Date - used to determine if a lot is expired, defaults to system date | IN |
| LOCNCODE | char(10) | No | Will use default from IV if empty | IN |
| ITEMNMBR | char(30) | Yes | Item Number | IN |
| AutoAssignBin | smallint | No | Auto Assign Bin - either the SOFULFILLMENT or SORETURN bin from item site combination or from site default | IN |
| UNITPRCE | numeric(19,5) | No | Unit Price for Item | IN |
| XTNDPRCE | numeric(19,5) | No | Extended Price for line Item | IN |
| QUANTITY | numeric(19,5) | No | Quantity to Invoice for SOPTYPE=1,2&5; Billed Qty for SOPTYPE=3 | IN |
| MRKDNAMT | numeric(19,5) | No | Markdown amount | IN |
| MRKDNPCT | numeric(19,5) | No | Markdown Percent | 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 |
| UNITCOST | numeric(19,5) | No | Used only for NON IV items | IN |
| PRCLEVEL | char(10) | No | Price level | IN |
| ITEMDESC | char(100) | No | Item description | IN |
| TAXAMNT | numeric(19,5) | No | Tax amount on the line item | IN |
| QTYONHND | numeric(19,5) | No | Return Quantity Type: On Hand | IN |
| QTYRTRND | numeric(19,5) | No | Return Quantity Type: Returned | IN |
| QTYINUSE | numeric(19,5) | No | Return Quantity Type: In Use | IN |
| QTYINSVC | numeric(19,5) | No | Return Quantity Type: In Service | IN |
| QTYDMGED | numeric(19,5) | No | Return Quantity Type: Damaged | IN |
| NONINVEN | smallint | No | Added on 7/17/00 to allow for NON-IV items | IN |
| LNITMSEQ | int | No | Added on 10/23/2000 to allow line seq. num. as an input parameter | IN |
| DROPSHIP | smallint | No | Drop Ship Flag 1=DropShip | IN |
| QTYTBAOR | numeric(19,5) | No | Added on 12/06/00 for Quantity to Back Order | IN |
| DOCID | char(15) | No | Document ID, key field in SOP40200 - optional | IN |
| SALSTERR | char(15) | Yes | Sales Territory | IN |
| SLPRSNID | char(15) | Yes | Sales Person ID, no commissions will be calculated if blank | IN |
| ITMTSHID | char(15) | No | Item Tax schedule ID | IN |
| IVITMTXB | smallint | No | IV Item Taxable - user can change item tax option per line 1=tax 2=nontax 3=based on cust | IN |
| TAXSCHID | char(15) | No | Tax Schedule ID can be used to override the default delivery method tax schedule | IN |
| PRSTADCD | char(15) | No | Primary Shipto Address Code | IN |
| ShipToName | char(64) | No | ShipToName | IN |
| CNTCPRSN | char(60) | No | Contact Person | IN |
| ADDRESS1 | char(60) | No | Customer Address One per shipto line item | IN |
| ADDRESS2 | char(60) | No | Customer Address Two per shipto line item | IN |
| ADDRESS3 | char(60) | No | Customer Address three per shipto line item | IN |
| CITY | char(35) | No | City per shipto line item | IN |
| STATE | char(29) | No | State per shipto line item | IN |
| ZIPCODE | char(10) | No | ZipCode per shipto line item | IN |
| COUNTRY | char(60) | No | Country per shipto line item | IN |
| PHONE1 | char(21) | No | Phone 1 per shipto line item | IN |
| PHONE2 | char(21) | No | Phone 2 per shipto line item | IN |
| PHONE3 | char(21) | No | Phone 3 per shipto line item | IN |
| FAXNUMBR | char(21) | No | Fax per shipto line item | IN |
| Print_Phone_NumberGB | smallint | No | @I_vPrint_Phone_NumberGB 0-4 valid | IN |
| EXCEPTIONALDEMAND | tinyint | No | Resource Planning | IN |
| ReqShipDate | datetime | No | Requested Ship Date | IN |
| FUFILDAT | datetime | No | Fulfill Date | IN |
| ACTLSHIP | datetime | No | Actual Ship Date | IN |
| SHIPMTHD | char(15) | No | Shipping Method | IN |
| INVINDX | varchar(75) | No | Inventory Account Number String | IN |
| CSLSINDX | varchar(75) | No | Cost of Goods Sold Account Number String | IN |
| SLSINDX | varchar(75) | No | Sales Account Number String | IN |
| MKDNINDX | varchar(75) | No | Markdowns Account Number String | IN |
| RTNSINDX | varchar(75) | No | Returns Account Number String | IN |
| INUSINDX | varchar(75) | No | In Use Account Number String | IN |
| INSRINDX | varchar(75) | No | In Service Account Number String | IN |
| DMGDINDX | varchar(75) | No | Damaged Account Number String | IN |
| AUTOALLOCATESERIAL | int | No | Auto Allocate Serial Numbers on the Fly 0 = Auto & 1 = Manual & 2 = Mixed | IN |
| AUTOALLOCATELOT | int | No | Auto Allocate Lot Numbers on the Fly 0 = Auto & 1 = Manual & 2 = Mixed | IN |
| GPSFOINTEGRATIONID | char(30) | No | Front Office Integration ID | IN |
| INTEGRATIONSOURCE | smallint | No | Integration Source | IN |
| INTEGRATIONID | char(30) | No | Integration ID | IN |
| RequesterTrx | smallint | No | Requester Transaction - 0=false,1=true - if true than populates Requester shadow table | IN |
| QTYCANCE | numeric(19,5) | No | Quantity Canceled - will subtract from the @I_vQUANTITY passed in | IN |
| QTYFULFI | numeric(19,5) | No | Quantity Fulfilled | IN |
| ALLOCATE | smallint | No | Allocates quantities - 0=use @I_vDOCID default; 1=Allocate quantities | IN |
| UpdateIfExists | smallint | No | Used to Modify existing lines - 1=Modify - entire line needs to be resent | IN |
| RecreateDist | smallint | No | Used only if @I_vUpdateIfExists = 1 - determines if distributions auto recreate | IN |
| QUOTEQTYTOINV | numeric(19,5) | No | Quote Qty to Invoice - added to @I_vQUANTITY and @I_vQTYCANCE for total quote amount | IN |
| TOTALQTY | numeric(19,5) | No | Total Line Qty - if not specified then it is calculated based on other quantities passed in | IN |
| CMMTTEXT | varchar(500) | No | Comment Text; only use if not using @I_vCOMMENT_1 thu @I_vCOMMENT_4 | IN |
| KitCompMan | smallint | Yes | Manually passing Kit Components - 0=False; 1=True - If 1 then @I_vLNITMSEQ is required | IN |
| DEFPRICING | int | No | 1 = unit price and extended price will be defaulted | IN |
| DEFEXTPRICE | int | No | Extended price will default based on the Unit Price and quantity passed in | IN |
| CURNCYID | char(15) | No | Currency ID - 02/10/02 - Added for Multi-Currency | IN |
| UOFM | char(8) | No | Unit of Measure | IN |
| IncludePromo | smallint | No | Include Extended Pricing Promotion, including free items | IN |
| CKCreditLimit | tinyint | No | 0=Do Not check limit; 1=check limit - this is on a per line basis, or you can just do at Hdr level | IN |
| QtyShrtOpt | smallint | No | Qty Shortage Opt.: 1=Sell Balance; 2=Override Shortage; 3=BO All; 4=BO Balance; 5=Cancel All; 6=Cancel Balance | IN |
| RECREATETAXES | smallint | No | RECREATETAXES: 0 = Do not recreate the taxes; 1 = Reclaculate the Taxes - TFS BugID# 71626 | IN |
| RECREATECOMM | smallint | No | RECREATECOMM: 0 = Do not recreate the commission amount ; 1 = Reclaculate the commission amount - TFS BugID# 71626 | 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 | Return value: 0=No Errors, 1=Error Occurred | INOUT |
| oErrString | varchar(255) | No | Return Error Code List | INOUT |