SOPTYPE | smallint | Yes | 1=QUOTE,2=ORDER,3=INVOICE,4=RETURN,5=BKORDER,6=FULFILLMENT ORDER | IN |
SOPNUMBE | char(21) | Yes | Document Number | IN |
LNITMSEQ | int | No | Line Item Sequence | IN |
CMPNTSEQ | int | No | Component Sequence | IN |
QTYTYPE | smallint | No | Quantity Type- 1 = QTY On Hand, 2 = QTY Returned, 3 = QTY in Use, 4 = QTY in Service, 5 = QTY Damaged | IN |
ITEMNMBR | char(30) | No | Item Number | IN |
LOCNCODE | char(10) | No | Will use default from IV if empty | IN |
QUANTITY | numeric(19,5) | No | Not used - always is set to 1 because Serial numbers are a 1 to 1 relationship to the Sop Line. Multiple nodes | IN |
BIN | char(15) | Yes | Bin if multibins are enabled and creating a serial # on the fly @I_vAUTOCREATESERIAL = 1 | IN |
CREATEBIN | tinyint | No | Create Bin 0 = no, 1 = yes - can only create bin when autocreating serial number and multi bins are enabled or return | IN |
SERLNMBR | char(20) | No | New Serial Number - if not passed in and @I_vUpdateIfExists = 1 and @I_vSERLNMBRToReplace <> '', then deletes | IN |
AUTOCREATESERIAL | int | No | or return @I_vSOPTYPE = 1 - otherwise defaults from IV00200 | IN |
DOCID | char(15) | No | Document ID - optional - should match the DOCID passed to taSopLineIvcInsert | IN |
DROPSHIP | smallint | No | Drop Ship Flag 1=DropShip - should match DropShip passed to taSopLineIvcInsert | IN |
QTYFULFI | numeric(19,5) | No | Quantity Fulfilled - sum of this field on all taSopSerialPre nodes being passed in should match @I_vQTYFULFI passed | IN |
ALLOCATE | smallint | No | Allocates quantities - should match @I_vALLOCATE passed to taSopLineIvcInsert - 0=use @I_vDOCID default; | IN |
UpdateIfExists | smallint | No | Auto Create Serial Number on the Fly 0 = False & 1 = True | IN |
SERLNMBRToReplace | char(20) | No | Auto Create Serial Number on the Fly 0 = False & 1 = True | 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 |