Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
USERID | User ID |
String | 16 | View | |
RTV_Number | RTV Number |
String | 16 | View | |
RTV_Line | RTV Line |
Currency | 10 | View | |
RTV_Type | RTV Type |
String | 12 | View | |
OFFID | Office ID |
String | 12 | View | |
VENDORID | Vendor ID |
String | 16 | View | |
ADRSCODE | Address Code |
String | 16 | View | |
VENDNAME | Vendor Name |
String | 66 | View | |
LOCNCODE | Location Code |
String | 12 | View | |
ITEMNMBR | Item Number |
String | 32 | View | |
VNDITNUM | Vendor Item Number |
String | 32 | View | |
Part_Cost | Part Cost |
Currency | 10 | View | |
Part_Price | Part Price |
Currency | 10 | View | |
Labor_Cost | Labor Cost |
Currency | 10 | View | |
Labor_Price | Labor Price |
Currency | 10 | View | |
Expense_Cost | Expense Cost |
Currency | 10 | View | |
Expense_Price | Expense Price |
Currency | 10 | View | |
Travel_Cost | Travel Cost |
Currency | 10 | View | |
Travel_Price | Travel Price |
Currency | 10 | View | |
Originating_Part_Cost | Originating Part Cost |
Currency | 10 | View | |
Originating_Part_Price | Originating Part Price |
Currency | 10 | View | |
Originating_Labor_Cost | Originating Labor Cost |
Currency | 10 | View | |
Originating_Labor_Price | Originating Labor Price |
Currency | 10 | View | |
Originating_Expense_Cost | Originating Expense Cost |
Currency | 10 | View | |
Originating_ExpensePrice | Originating Expense Price |
Currency | 10 | View | |
Originating_Travel_Cost | Originating Travel Cost |
Currency | 10 | View | |
Originating_Travel_Price | Originating Travel Price |
Currency | 10 | View | |
MKDTOPST | Marked To Post |
Boolean | 2 | View | |
POSTED | Posted |
Boolean | 2 | View | |
ERMSGNBR | Error Message Number |
Integer | 2 | View | |
ERMSGTXT | Error Message Text |
String | 256 | View | |
ERMSGTX2 | Error Message Text 2 |
String | 256 | View |