Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
RTV_Number | RTV Number |
String | 16 | View | |
RTV_Type | RTV Type |
String | 12 | View | |
RTV_Return_Status | RTV Return Status |
String | 4 | View | |
RTV_Status | RTV Status |
Integer | 2 | View | |
VRMA_Document_ID | VRMA Document ID |
String | 16 | View | |
RETDOCID | Return Document ID |
String | 16 | View | |
LNSEQNBR | Line SEQ Number |
Currency | 10 | View | |
DSCRIPTN | Description |
String | 32 | View | |
VENDORID | Vendor ID |
String | 16 | View | |
VENDNAME | Vendor Name |
String | 66 | View | |
ADRSCODE | Address Code |
String | 16 | View | |
Ship_Address_Name | Ship Address Name |
String | 66 | View | |
Ship_Address_1 | Ship Address 1 |
String | 62 | View | |
Ship_Address_2 | Ship Address 2 |
String | 62 | View | |
Ship_Address_3 | Ship Address 3 |
String | 62 | View | |
Ship_City | Ship City |
String | 36 | View | |
Ship_State | Ship State |
String | 30 | View | |
ZIPCODE | Zip Code |
String | 12 | View | |
Ship_Country | Ship Country |
String | 62 | View | |
ENTDTE | Entry Date |
Date | 4 | View | |
ENTTME | Entry Time |
Time | 4 | View | |
PRMDATE | Promised Date |
Date | 4 | View | |
Promised_Time | Promised Time |
Time | 4 | View | |
Shipped_Date | Shipped Date |
Date | 4 | View | |
Shipped_Time | Shipped Time |
Time | 4 | View | |
receiptdate | Receipt Date |
Date | 4 | View | |
Receipt_Time | Receipt Time |
Time | 4 | View | |
COMPDTE | Complete Date |
Date | 4 | View | |
COMPTME | Complete Time |
Time | 4 | View | |
LOCCODEB | Location Code Bad |
String | 12 | View | |
LOCNCODE | Location Code |
String | 12 | View | |
Part_Price | Part Price |
Currency | 10 | View | |
Part_Cost | Part Cost |
Currency | 10 | View | |
Labor_Price | Labor Price |
Currency | 10 | View | |
Labor_Cost | Labor Cost |
Currency | 10 | View | |
Expense_Price | Expense Price |
Currency | 10 | View | |
Expense_Cost | Expense Cost |
Currency | 10 | View | |
Travel_Price | Travel Price |
Currency | 10 | View | |
Travel_Cost | Travel Cost |
Currency | 10 | View | |
Bill_of_Lading_Out | Bill of Lading Out |
String | 32 | View | |
Shipping_Method_Out | Shipping Method Out |
String | 16 | View | |
Bill_of_Lading | Bill of Lading |
String | 32 | View | |
SHIPMTHD | Shipping Method |
String | 16 | View | |
OFFID | Office ID |
String | 12 | View | |
NOTEINDX | Note Index |
Currency | 10 | View | |
VCHNUMWK | Voucher Number - WORK |
String | 18 | View | |
Voucher_Number_Invoice | Voucher Number Invoice |
String | 18 | View | |
Voucher_Number_Reimburse | Voucher Number Reimbursement |
String | 18 | View | |
CUSTOWN | Customer Owned |
Boolean | 2 | View | |
USERID | User ID |
String | 16 | View | |
USERDEF1 | User Defined 1 |
String | 22 | View | |
USERDEF2 | User Defined 2 |
String | 22 | View | |
USRDEF03 | User Defined 3 |
String | 22 | View | |
USRDEF04 | User Defined 4 |
String | 22 | View | |
USRDEF05 | User Defined 5 |
String | 22 | View | |
CURNCYID | Currency ID |
String | 16 | View | |
CURRNIDX | Currency Index |
Integer | 2 | View | |
RATETPID | Rate Type ID |
String | 16 | View | |
EXGTBLID | Exchange Table ID |
String | 16 | View | |
XCHGRATE | Exchange Rate |
Currency (Variable) | 10 | View | |
EXCHDATE | Exchange Date |
Date | 4 | View | |
DECPLACS | Decimal Places |
Integer | 2 | View | |
TIME1 | Time |
Time | 4 | View | |
RATECALC | Rate Calc Method |
Integer | 2 | View | |
VIEWMODE | View Mode |
Integer | 2 | View | |
ISMCTRX | IS MC Trx |
Integer | 2 | View | |
EXPNDATE | Expiration Date |
Date | 4 | View | |
DENXRATE | Denomination Exchange Rate |
Currency (Variable) | 10 | View | |
MCTRXSTT | MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. |
Integer | 2 | View | |
Originating_Part_Price | Originating Part Price |
Currency | 10 | View | |
Originating_Part_Cost | Originating Part Cost |
Currency | 10 | View | |
Originating_Labor_Price | Originating Labor Price |
Currency | 10 | View | |
Originating_Labor_Cost | Originating Labor Cost |
Currency | 10 | View | |
Originating_ExpensePrice | Originating Expense Price |
Currency | 10 | View | |
Originating_Expense_Cost | Originating Expense Cost |
Currency | 10 | View | |
Originating_Travel_Price | Originating Travel Price |
Currency | 10 | View | |
Originating_Travel_Cost | Originating Travel Cost |
Currency | 10 | View | |
VOIDSTTS | Void Status 0 = Document has not been voided. |
Integer | 2 | View |