Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
CONSTS | Contract Record Type |
Integer | 2 | View | |
CONTNBR | Contract Number |
String | 12 | View | |
ITEMNMBR | Item Number |
String | 32 | View | |
SERLNMBR | Serial Number |
String | 22 | View | |
SRVRECTYPE | Service Record Type |
Integer | 2 | View | |
CALLNBR | Service Call Number |
String | 12 | View | |
SRVTYPE | Service Type |
String | 12 | View | |
SVCDESCR | Service Description |
String | 62 | View | |
ADRSCODE | Address Code |
String | 16 | View | |
OFFID | Office ID |
String | 12 | View | |
SVCAREA | Service Area |
String | 12 | View | |
TECHID | Tech ID |
String | 12 | View | |
ENTDTE | Entry Date |
Date | 4 | View | |
ENTTME | Entry Time |
Time | 4 | View | |
DISPDTE | Dispatch Date |
Date | 4 | View | |
DISPTME | Dispatch Time |
Time | 4 | View | |
ETADTE | ETA Date |
Date | 4 | View | |
ETATME | ETA Time |
Time | 4 | View | |
ARRIVDTE | Arrival Date |
Date | 4 | View | |
ARRIVTME | Arrival Time |
Time | 4 | View | |
COMPDTE | Complete Date |
Date | 4 | View | |
COMPTME | Complete Time |
Time | 4 | View | |
LABSTOTPRC | Labor Sub Total Price |
Currency | 10 | View | |
LABPCT | Labor Pct |
Currency | 10 | View | |
LABSTOTCST | Labor Sub Total Cost |
Currency | 10 | View | |
PARSTOTPRC | Part Sub Total Price |
Currency | 10 | View | |
PARTPCT | Part Pct |
Currency | 10 | View | |
PARSTOTCST | Part Sub Total Cost |
Currency | 10 | View | |
MSCSTOTPRC | Misc Sub Total Price |
Currency | 10 | View | |
MISCPCT | Misc Pct |
Currency | 10 | View | |
MISSTOTCST | Misc Sub Total Cost |
Currency | 10 | View | |
PRETAXTOT | PreTax Total |
Currency | 10 | View | |
TAXAMNT | Tax Amount |
Currency | 10 | View | |
TOTAL | Total |
Currency | 10 | View | |
Invoiced_Amount | Invoiced Amount |
Currency | 10 | View |