Return_Record_Type | smallint | Yes | Return Record Type, 1=Open, 2=Closed | IN |
QTYTYPE | smallint | Yes | (Required/Optional) Qty Type, 1=On Hand, 2=Returned, 3=In Use, 4=In Service, 5=Damaged | IN |
SERLTQTY | numeric(19,5) | No | (Optional) Serial/Lot Qty, > 0 indicates add/update, < 0 indicates delete if exists | IN |
ITEMNMBR | char(31) | Yes | (Required/Optional) Returning Item Number | IN |
SERLNMBR | char(21) | Yes | (Required/Optional) Returning Item's Serial Number | IN |
LOCNCODE | char(11) | Yes | (Required/Optional) Location Code of the item | IN |
SLTSQNUM | int | No | (Optional) Returning Item's Serial Line Sequence Number | IN |
BIN | char(15) | No | (Optional) Returning Item's Bin Number | IN |
SVC_Original_Serial | tinyint | No | (Optional) Flag to indicate whether serial is original. 0=No, 1=Yes | IN |
DATERECD | datetime | No | (Optional) Date the returning item was received | IN |
ReplaceItem | smallint | No | (Optional) Flag to indicate if the line is Replacement Item or not. 0=No, 1=Yes | IN |
UpdateIfExists | tinyint | No | (Optional) Flag to allow customer data to be updated if it exists. 0=No, 1=Yes | IN |
RequesterTrx | smallint | No | (Optional) Requester Transaction - 0=false,1=true - if true then populates Requester shadow table | IN |
USRDEFND1 | char(50) | No | (Developer) User Defined field - developer use only | IN |
USRDEFND2 | char(50) | No | (Developer) User Defined field - developer use only | IN |
USRDEFND3 | char(50) | No | (Developer) User Defined field - developer use only | IN |
USRDEFND4 | varchar(8000) | No | (Developer) User Defined field - developer use only | IN |
USRDEFND5 | varchar(8000) | No | (Developer) User Defined field - developer use only | IN |
oErrString | varchar(255) | No | List of errors encountered | INOUT |