Return_Record_Type | smallint | No | Return Record Type, 1=Open, 2=Closed | IN |
RETDOCID | char(15) | No | Return Document ID | IN |
RETORIG | smallint | No | Flag to indicate Return Origin. 1=None, 2=Service Call, 3=SOP | IN |
RETREF | char(31) | No | Return Reference | IN |
RETSTAT | char(3) | No | Line Return Status | IN |
RETTYPE | char(11) | No | Return Type | 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 |
USERID | char(15) | No | Create or last modified User ID | IN |
OFFID | char(11) | No | Office ID | IN |
LOCNCODE | char(11) | No | Default Location Code of the items | 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 |
CUSTNMBR | char(15) | No | Customer Number | IN |
ADRSCODE | char(15) | No | Address Code of customer | IN |
CKHOLD | smallint | No | Flag to indicate whether to check for Customer Hold | IN |
CUSTNAME | char(65) | No | Customer's Name | IN |
CONTACT | char(61) | No | Contact Person's Name of Customer | IN |
ADDRESS1 | char(61) | No | Address line 1 | IN |
ADDRESS2 | char(61) | No | Address line 2 | IN |
ADDRESS3 | char(61) | No | Address line 3 | IN |
CITY | char(35) | No | City name | IN |
STATE | char(29) | No | State name | IN |
ZIPCODE | char(11) | No | Zip Code | IN |
COUNTRY | char(61) | No | Country name | IN |
NOTETXT | nvarchar(2000) | No | Notes text | IN |
Bill_of_Lading | char(31) | No | Bill of Lading number, if any | IN |
SHIPMTHD | char(15) | No | Shipping Method | IN |
Bill_To_Customer | char(15) | No | Bill To Customer ID | IN |
SVC_Bill_To_Address_Code | char(15) | No | Bill To Customer Address Code | 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 |
CSTPONBR | char(21) | No | Customer PO Number | IN |
SVC_RMA_Reason_Code | char(3) | No | RMA Reason Code | IN |
SVC_RMA_From_Service | tinyint | No | Flag to indicate whether RMA created from Service Call. 0=No, 1=Yes | IN |
SVC_FO_ID | char(51) | No | FO ID | IN |
CURNCYID | char(15) | No | Currency ID used in return | 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 | List of errors encountered | INOUT |
oErrString | varchar(255) | No | List of errors encountered | INOUT |