SOPTYPE | smallint | Yes | 1=QUOTE,2=ORDER,3=INVOICE,4=RETURN,5=BKORDER,6=FULFILLMENT ORDER | IN |
SOPNUMBE | char(21) | Yes | Document Number | IN |
USERDATE | datetime | No | User Date - used to determine if a lot is expired, defaults to system date | IN |
LNITMSEQ | int | No | Line Item Sequence - This field is used to order the line items. Internally, this number is | 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 | Total Quantity for line Item | IN |
BIN | char(15) | Yes | Bin - if multi bins are enabled and creating a lot # on the fly then required - otherwise defaults from IV00300 | IN |
CREATEBIN | tinyint | No | Create Bin 0 = no, 1 = yes - can only create bin when autocreating lot number and multi bins are enabled | IN |
LOTNUMBR | char(20) | No | Lot number for auto creation | IN |
EXPNDATE | datetime | No | Expiration Date - can be used to select a specific lot layer | IN |
MFGDATE | datetime | No | Manufacturing Date | 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 |
RequesterTrx | smallint | No | Requester Transaction - 0=false,1=true - if true than populates Requester shadow table | 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 - the sum of this field on all taSopLotAuto 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 |
CMPNTSEQ | int | No | Component Sequence | IN |
LOTNUMBRToReplace | char(20) | No | Previous Lot Number - Only used if modifying an existing lot # | IN |
AUTOCREATELOT | int | No | Auto Create Lot Number on the Fly 0 = False & 1 = True | IN |
UOFM | char(8) | No | Unit of Measure - should match to what is used on the Sop Line | IN |
DATERECD | datetime | No | Date Received | IN |
UpdateIfExists | smallint | No | Used to Add/Modify existing documents - 0=New Document 1=Modify Existing | 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 |