Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
COMPTRNM | Computer TRX Number |
Long Integer | 4 | View | |
BACHNUMB | Batch Number |
String | 16 | View | |
EMPLOYID | Employee ID |
String | 16 | View | |
COMPTRTP | Computer TRX Type |
Integer | 2 | View | |
UPRTRXCD | UPR TRX Code |
String | 8 | View | |
TRXBEGDT | TRX Beginning Date |
Date | 4 | View | |
TRXENDDT | TRX Ending Date |
Date | 4 | View | |
TRXHRUNT | TRX Hours/Units |
Long Integer | 4 | View | |
DAYSWRDK | Days Worked |
Long Integer | 4 | View | |
WKSWRKD | Weeks Worked |
Long Integer | 4 | View | |
INTERID | Intercompany ID |
String | 6 | View | |
DEPRTMNT | Department |
String | 8 | View | |
JOBTITLE | Job Title |
String | 8 | View | |
LOCATNID | Location ID |
String | 16 | View | |
SHFTCODE | Shift Code |
String | 8 | View | |
STATECD | State Code |
String | 4 | View | |
SUTASTAT | Suta State |
String | 4 | View | |
PAYRTAMT | Pay Rate Amount |
Currency | 10 | View | |
ERMSGTXT | Error Message Text |
String | 256 | View | |
MKTOPROC | Marked To Process |
Boolean | 2 | View | |
APR_Import_Group | APR Import Group |
String | 16 | View |