Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
RTV_Number | RTV Number |
String | 16 | View | |
RTV_Line | RTV Line |
Currency | 10 | View | |
RTV_Type | RTV Type |
String | 12 | View | |
RTV_Status | RTV Status |
Integer | 2 | View | |
RTV_Return_Status | RTV Return Status |
String | 4 | View | |
VRMA_Document_ID | VRMA Document ID |
String | 16 | View | |
RETDOCID | Return Document ID |
String | 16 | View | |
LNSEQNBR | Line SEQ Number |
Currency | 10 | View | |
SVC_Process_SEQ_Number | SVC Process SEQ Number |
Currency | 10 | View | |
DSCRIPTN | Description |
String | 32 | View | |
REFRENCE | Reference |
String | 32 | View | |
Reference2 | Reference2 |
String | 32 | View | |
ITEMNMBR | Item Number |
String | 32 | View | |
ITEMDESC | Item Description |
String | 102 | View | |
ITMTRKOP | Item Tracking Option 1. None |
Integer | 2 | View | |
DECPLQTY | Decimal Places QTYS |
Integer | 2 | View | |
QUANTITY | QTY |
Currency | 10 | View | |
QTYSHPPD | QTY Shipped |
Currency | 10 | View | |
QTY_To_Receive | QTY To Receive |
Currency | 10 | View | |
QTYRECVD | QTY Received |
Currency | 10 | View | |
QTYCANCE | QTY Canceled |
Currency | 10 | View | |
UOFM | U Of M |
String | 10 | View | |
VENDORID | Vendor ID |
String | 16 | View | |
VNDITNUM | Vendor Item Number |
String | 32 | View | |
Return_Item_Number | Return Item Number |
String | 32 | View | |
OFFID | Office ID |
String | 12 | View | |
LOCCODEB | Location Code Bad |
String | 12 | View | |
LOCNCODE | Location Code |
String | 12 | 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 | |
PONMBRSTR | Purchase_Order_Number_STR |
String | 18 | View | |
POLNSEQ | Purchase_Order_Line_Sequence_DOL |
Currency | 10 | View | |
POPRCTNM | POP Receipt Number |
String | 18 | View | |
RCPTLNNM | Receipt Line Number |
Long Integer | 4 | View | |
Transfer_Reference | Transfer Reference |
String | 32 | View | |
TRANSLINESEQ | Transfer Line Item Sequence |
Long Integer | 4 | View | |
CALLNBR | Service Call Number |
String | 12 | View | |
EQPLINE | Equipment Line Item Sequence |
Long Integer | 4 | View | |
LINITMTYP | Line Item Type |
String | 4 | View | |
LNITMSEQ | Line Item Sequence |
Long Integer | 4 | 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 | |
Tracking_Number | Tracking Number |
String | 42 | 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 | |
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 | |
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 | |
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 | |
QTYTYPE | QTY Type 1 = On Hand |
Integer | 2 | View |