RTV_Number | char(15) | No | RTV Number | IN |
RTV_Line | numeric(19,5) | No | Line Sequence Number | IN |
RTV_Type | char(11) | No | Return Type | IN |
VRMA_Document_ID | char(15) | No | Vendor's RMA Document Number, if any | IN |
RETDOCID | char(15) | No | RMA Number of the customer, if created from RMA | IN |
LNSEQNBR | numeric(19,5) | No | Line Sequence Number of the RMA Document | IN |
SVC_Process_SEQ_Number | numeric(19,5) | No | Line Process Sequence Number of RMA | IN |
DSCRIPTN | char(31) | No | RTV Description | IN |
REFRENCE | char(31) | No | Reference information | IN |
Reference2 | char(31) | No | Reference information | IN |
ITEMNMBR | char(31) | No | Item Number being shipped | IN |
ITEMDESC | char(101) | No | Item Description | IN |
QUANTITY | numeric(19,5) | No | Quantity of item returned | IN |
UOFM | char(9) | No | Unit of Measure | IN |
VENDORID | char(15) | No | Vendor ID | IN |
ADRSCODE | char(15) | No | Address Code of the Vendor's Ship To Address | IN |
Ship_Address_Name | char(65) | No | Name of contact person of vendor to ship to | IN |
Ship_Address_1 | char(61) | No | Address line 1 of vendor's address | IN |
Ship_Address_2 | char(61) | No | Address line 2 | IN |
Ship_Address_3 | char(61) | No | Address line 3 | IN |
Ship_City | char(35) | No | City Name | IN |
Ship_State | char(29) | No | State Name | IN |
ZIPCODE | char(11) | No | Zip Code | IN |
Ship_Country | char(61) | No | Country Name | IN |
VNDITNUM | char(31) | No | Vendor's Item Number | IN |
Return_Item_Number | char(31) | No | Item Number of the item being returned by vendor | IN |
OFFID | char(11) | No | Office ID | IN |
LOCCODEB | char(11) | No | Location Code of the item from where it's shipped | IN |
LOCNCODE | char(11) | No | Location Code of the item being returned to | IN |
ENTDTE | datetime | No | Entered Date | IN |
ENTTME | datetime | No | Entered Time | IN |
PRMDATE | datetime | No | Promised/ETA Date | IN |
Promised_Time | datetime | No | Promised/ETA Time | IN |
Shipped_Date | datetime | No | Shipped Date | IN |
Shipped_Time | datetime | No | Shipped Time | IN |
Receiptdate | datetime | No | Received Date | IN |
Receipt_Time | datetime | No | Received Time | IN |
COMPDTE | datetime | No | Completed Date | IN |
COMPTME | datetime | No | Completed Time | IN |
Bill_of_Lading_Out | char(31) | No | Bill of Lading number for shipment to vendor | IN |
Shipping_Method_Out | char(15) | No | Shipping Method for shipment | IN |
Bill_of_Lading | char(31) | No | Bill of Lading number for shipment to vendor | IN |
SHIPMTHD | char(15) | No | Shipping Method for receiving | IN |
Tracking_Number | char(41) | No | Tracking number for receiving | IN |
NOTETXT | nvarchar(2000) | No | Notes | IN |
CUSTOWN | tinyint | No | Flag to indicate if item was customer owned. 0=No, 1=Yes | IN |
USERDEF1 | char(21) | No | Additional Information, line 1 | IN |
USERDEF2 | char(21) | No | Additional Information, line 2 | IN |
USRDEF03 | char(21) | No | Additional Information, line 3 | IN |
USRDEF04 | char(21) | No | Additional Information, line 4 | IN |
USRDEF05 | char(21) | No | Additional Information, line 5 | IN |
Part_Price | numeric(19,5) | No | Unit Price of item being shipped | IN |
Part_Cost | numeric(19,5) | No | Unit Cost of item being shipped | IN |
Labor_Price | numeric(19,5) | No | Labor charges to be charged, if any | IN |
Labor_Cost | numeric(19,5) | No | Labor cost, if any | IN |
Expense_Price | numeric(19,5) | No | Addl. Expense charges, if any | IN |
Expense_Cost | numeric(19,5) | No | Addl. Expense cost, if any | IN |
Travel_Price | numeric(19,5) | No | Travel charges, if any | IN |
Travel_Cost | numeric(19,5) | No | Travel Expense cost, if any | 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 | Error Code | INOUT |
oErrString | varchar(255) | No | List of errors encountered | INOUT |