SOPTYPE | smallint | Yes | SOP Type 2=ORDER,3=INVOICE,4=RETURN,(5=BKORDER - not valid),6=FULFILLMENT ORDER | IN |
LNITMSEQ | int | Yes | Line Item Sequence Must match the seq # in the sop line if the item is on more than one line | IN |
CMPNTSEQ | int | Yes | Component Sequence Must match the seq # in the sop line if the item is a kit item | IN |
BIN | char(15) | No | Bin number if not passed in will use default bin | IN |
QTYTYPE | smallint | No | Quantity Type 1 = On Hand, 2 = Returned, 3 = in Use, 4 = in Service, 5 = Damaged | IN |
UOFM | char(8) | No | Unit of Measure will default to base uofm if not passed | IN |
QUANTITY | numeric(19,5) | Yes | Quantity must be greater than 0 | IN |
CreateBin | int | No | Create Bin on the Fly 0 = False & 1 = True | IN |
OverrideBin | tinyint | No | Override Bin Shortage Flag 0 = do NOT override, 1 = override | 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 |
oErrString | varchar(255) | No | Comma separated list of errors encountered | INOUT |