Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
SRVRECTYPE | Service Record Type |
Integer | 2 | View | |
CALLNBR | Service Call Number |
String | 12 | View | |
EQPLINE | Equipment Line Item Sequence |
Long Integer | 4 | View | |
LNITMSEQ | Line Item Sequence |
Long Integer | 4 | View | |
LINITMTYP | Line Item Type |
String | 4 | View | |
ITEMUSETYPE | Item Use Type |
String | 4 | View | |
TECHID | Tech ID |
String | 12 | View | |
Work_Type | Work Type |
String | 12 | View | |
TRANSTME | Transaction Time |
String | 8 | View | |
BILLABLTIM | Billable Time |
String | 8 | View | |
QTYORDER | QTY Ordered |
Currency | 10 | View | |
QTYSOLD | QTY Sold |
Currency | 10 | View | |
STRTDATE | Start Date |
Date | 4 | View | |
STRTTIME | Start Time |
Time | 4 | View | |
ENDDATE | End Date |
Date | 4 | View | |
ENDTME | SVC_End Time |
Time | 4 | View | |
ITEMNMBR | Item Number |
String | 32 | View | |
ITEMDESC | Item Description |
String | 102 | View |