| COMPTRNM |
int
0
|
Computer T...(more) Join Now
|
|
|
|
| BACHNUMB |
char(15)
''
|
Batch Numb...(more) Join Now
|
|
|
join ... more text available
|
| EMPLOYID |
char(15)
''
|
Employee I...(more) Join Now
|
|
|
join ... more text available
|
| COMPTRTP |
smallint
0
|
Computer T...(more) Join Now
|
|
|
|
| SALCHG |
smallint
0
|
Salary Cha...(more) Join Now
|
|
|
|
| UPRTRXCD |
char(7)
''
|
UPR TRX Co...(more) Join Now
|
|
|
|
| TRXBEGDT |
datetime
'1/1/1900'
|
TRX Beginn...(more) Join Now
|
|
|
|
| TRXENDDT |
datetime
'1/1/1900'
|
TRX Ending...(more) Join Now
|
|
|
|
| TRXHRUNT |
int
0
|
TRX Hours/...(more) Join Now
|
|
|
|
| HRLYPYRT |
numeric(19,5)
0.00
|
|
|
|
|
| PAYRTAMT |
numeric(19,5)
0.00
|
Pay Rate A...(more) Join Now
|
|
|
|
| VARDBAMT |
numeric(19,5)
0.00
|
Variable D...(more) Join Now
|
|
|
|
| VARDBPCT |
int
0
|
Variable D...(more) Join Now
|
|
|
|
| RECEIPTS |
numeric(19,5)
0.00
|
Receipts: ...(more) Join Now
|
|
|
|
| DAYSWRDK |
int
0
|
|
|
|
|
| WKSWRKD |
int
0
|
|
|
|
|
| DEPRTMNT |
char(7)
''
|
Department...(more) Join Now
|
|
|
join ... more text available
|
| JOBTITLE |
char(7)
''
|
|
|
|
|
| STATECD |
char(3)
''
|
State Code...(more) Join Now
|
|
|
|
| LOCALTAX |
char(7)
''
|
|
|
|
|
| SUTASTAT |
char(3)
''
|
Suta State...(more) Join Now
|
|
|
|
| WRKRCOMP |
char(7)
''
|
Workers Co...(more) Join Now
|
|
|
|
| LASTUSER |
char(15)
''
|
Last User:...(more) Join Now
|
|
|
|
| LSTDTEDT |
datetime
'1/1/1900'
|
Last Date ...(more) Join Now
|
|
|
|
| TRXSORCE |
char(13)
''
|
Transactio...(more) Join Now
|
|
|
|
| DOCTYPE |
smallint
0
|
Document T...(more) Join Now
|
|
|
|
| VOIDED |
tinyint
0
|
Voided: Th...(more) Join Now
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| INADDNTOSAL |
tinyint
0
|
In Additio...(more) Join Now
|
|
|
|
| SHFTCODE |
char(7)
''
|
Shift Code...(more) Join Now
|
|
|
|
| SHFTPREM |
numeric(19,5)
0.00
|
|
|
|
|
| JOBNUMBR |
char(17)
''
|
Job Number...(more) Join Now
|
|
|
|
| UNIONCD |
char(7)
''
|
Union Code...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|