Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
SVC_Document_Type | SVC Document Type |
Integer | 2 | View | |
RCRDTYPE | Record Type |
Integer | 2 | View | |
DOCID | Document ID |
String | 16 | View | |
EQPLINE | Equipment Line Item Sequence |
Long Integer | 4 | View | |
LNITMSEQ | Line Item Sequence |
Long Integer | 4 | View | |
TECHID | Tech ID |
String | 12 | View | |
Work_Type | Work Type |
String | 12 | View | |
STATIONID | Depot Station ID |
String | 12 | View | |
EMPLOYID | Employee ID |
String | 16 | View | |
PayCode | Pay Code |
String | 8 | View | |
DEPRTMNT | Department |
String | 8 | View | |
JOBTITLE | Job Title |
String | 8 | View | |
STATECD | State Code |
String | 4 | View | |
LOCALTAX | Local Tax |
String | 8 | View | |
SUTASTAT | Suta State |
String | 4 | View | |
WRKRCOMP | Workers Comp |
String | 8 | View | |
SHFTCODE | Shift Code |
String | 8 | View | |
TRXHRUNT | TRX Hours/Units |
Long Integer | 4 | View | |
STRTDATE | Start Date |
Date | 4 | View | |
STRTTIME | Start Time |
Time | 4 | View | |
ENDDATE | End Date |
Date | 4 | View | |
ENDTIME | End Time |
Time | 4 | View | |
POSTED | Posted |
Boolean | 2 | View |