| Return_Record_Type | smallint | No | Return Record Type, 1=Open, 2=Closed | IN |
| RETDOCID | char(15) | No | Return Document ID | IN |
| LNSEQNBR | numeric(19,5) | No | Line Sequence Number | IN |
| RETTYPE | char(11) | No | Return Type | IN |
| RETSTAT | char(3) | No | Line Return Status | IN |
| CUSTNMBR | char(15) | No | Customer Number | IN |
| ADRSCODE | char(15) | No | Address Code of customer | IN |
| ITEMNMBR | char(31) | No | Item Number | IN |
| ITEMDESC | char(101) | No | Item Description | IN |
| LOCNCODE | char(11) | No | Location Code of the item | IN |
| SVC_Ready_To_Close | tinyint | No | Flag to indicate line is ready for closing. 0=No, 1=Ready | IN |
| SVC_RMA_Reason_Code | char(3) | No | RMA Reason Code | IN |
| NOTETXT | nvarchar(2000) | No | Notes for the line | IN |
| RETORIG | smallint | No | Flag to indicate Return Origin. 1=None, 2=Service Call, 3=SOP | IN |
| RETREF | char(31) | No | Return Reference | IN |
| EQPLINE | int | No | Equipment Line Sequence of Service Call Part line | IN |
| LNITMSEQ | int | No | Line Item Sequence of Service Call Part line | IN |
| SVC_RMA_From_Service | tinyint | No | Flag to indicate whether RMA created from Service Call. 0=No, 1=Yes | IN |
| CMPNTSEQ | int | No | Component Sequence number of SOP Document Line | IN |
| SOP_Line_Item_Sequence | int | No | SOP Document Line Sequence Number | IN |
| ENTDTE | datetime | No | Entry Date for the return line | IN |
| ENTTME | datetime | No | Entry Time for the return line | IN |
| ETADTE | datetime | No | ETA Date for the return line | IN |
| ETATME | datetime | No | ETA Time for the return line | IN |
| Commit_Date | datetime | No | Commit Date for the return line | IN |
| Commit_Time | datetime | No | Commit Time for the return line | IN |
| RETUDATE | datetime | No | Actual Date of returning the item | IN |
| Return_Time | datetime | No | Actual Time of returning the item | IN |
| COMPDTE | datetime | No | Completed date of return line | IN |
| COMPTME | datetime | No | Completed time of return line | IN |
| PRMDATE | datetime | No | Promised date of return | IN |
| USERID | char(15) | No | Create or last modified User ID | IN |
| OFFID | char(11) | No | Office ID | IN |
| RTRNNAME | char(45) | No | Name of the person to return to | IN |
| RETADDR1 | char(61) | No | Address line 1 of return address | IN |
| RETADDR2 | char(61) | No | Address line 2 of return address | IN |
| RETADDR3 | char(61) | No | Address line 3 of return address | IN |
| RTRNCITY | char(21) | No | City of return address | IN |
| SVC_Return_State | char(29) | No | State of return address | IN |
| RTRNZIP | char(11) | No | Zip Code of return address | IN |
| Return_Country | char(61) | No | Country of return address | IN |
| CUSTNAME | char(65) | No | Customer Name | IN |
| CONTACT | char(61) | No | Name of Contact Person | IN |
| ADDRESS1 | char(61) | No | Address line 1 of customer | IN |
| ADDRESS2 | char(61) | No | Address line 2 of customer | IN |
| ADDRESS3 | char(61) | No | Address line 3 of customer | IN |
| CITY | char(35) | No | City of customer's address | IN |
| STATE | char(29) | No | State of customer's address | IN |
| ZIPCODE | char(11) | No | Zip Code of customer's address | IN |
| COUNTRY | char(61) | No | Country of customer's address | IN |
| CSTPONBR | char(21) | No | Customer PO Number, if any | IN |
| QUANTITY | numeric(19,5) | No | Quantity being returned | IN |
| UOFM | char(9) | No | Unit of Measure of the returned item | IN |
| UNITCOST | numeric(19,5) | No | Unit Cost of the item | IN |
| UNITPRCE | numeric(19,5) | No | Unit Price of the Item | IN |
| XTNDPRCE | numeric(19,5) | No | Extended Price of the Item | IN |
| CUSTOWN | tinyint | No | Flag to indicate customer owned item. 0=No, 1=Yes | IN |
| FACTSEAL | tinyint | No | Flag to indicate whether item was factory seales. 0=No, 1=Yes | IN |
| Flat_Rate_Repair_Price | numeric(19,5) | No | Flat Rate Repair Price | IN |
| Repair_Price | numeric(19,5) | No | Actual Repair Price, if not Flat Rate | IN |
| NTE_Price | numeric(19,5) | No | NTE Price, if any | IN |
| Repair_Cost | numeric(19,5) | No | Repair Cost | IN |
| Bill_of_Lading | char(31) | No | Bill of Lading number, if any | IN |
| SHIPMTHD | char(15) | No | Shipping Method | IN |
| Location_Code_Replacemen | char(11) | No | Location Code for Replacement | IN |
| Replace_Item_Number | char(31) | No | Replacing Item Number if being replaced by another item | IN |
| Replace_U_Of_M | char(9) | No | Unit of Measure of Replacing Item Number | IN |
| Replace_Price_Level | char(11) | No | Price Level of Replacing Item Number | IN |
| Replace_QTY | numeric(19,5) | No | Quantity of item being replaced | IN |
| Replace_Cost | numeric(19,5) | No | Cost of item being replaced | IN |
| Replace_Price | numeric(19,5) | No | Price Level of Replacing Item Number | IN |
| Item_Number_Invoice | char(31) | No | Item Number used in SOP Invoice for return | IN |
| USERDEF1 | char(21) | No | User Comments for return line | IN |
| USERDEF2 | char(21) | No | User Comments for return line | IN |
| USRDEF03 | char(21) | No | User Comments for return line | IN |
| USRDEF04 | char(21) | No | User Comments for return line | IN |
| USRDEF05 | char(21) | No | User Comments for return line | IN |
| CURNCYID | char(15) | No | Currency ID used in return | IN |
| Return_Item_Number | char(31) | No | Item Number being returned to Customer | IN |
| Return_Item_Description | char(51) | No | Description of Item Number being returned | IN |
| Return_Location_Code | char(11) | No | Location Code being returned to | IN |
| Return_QTY | numeric(19,5) | No | Quantity of item being returned | IN |
| Return_U_Of_M | char(9) | No | Unit of Measure of item being returned | IN |
| RETCOST | numeric(19,5) | No | Unit Cost of returning item | IN |
| SVC_Return_Price_Level | char(11) | No | Price Level of item being returned | IN |
| SVC_Return_Price | numeric(19,5) | No | Price Level of item being returned | IN |
| SVC_Extended_Return_Pric | numeric(19,5) | No | Extended Price for returning item | IN |
| SVC_FO_ID | char(51) | No | FO ID | IN |
| SVC_SCM_Complete | smallint | No | Flag to indicate whether SCM was completed | IN |
| UpdateIfExists | tinyint | No | Flag to allow customer data to be updated if it exists. 0=no, 1=yes | IN |
| RequesterTrx | smallint | No | Requester Trx - 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 | Error Code | INOUT |
| oErrString | varchar(255) | No | List of errors encountered | INOUT |