| CMRECNUM |
numeric(19,5)
0.00
|
Record Num...(more) Join Now
|
|
|
| AUCTRLCD |
char(13)
''
|
....(more) Join Now
|
|
|
| EMPLOYID |
char(15)
''
|
Employee I...(more) Join Now
|
|
join ... more text available
|
| CHEKNMBR |
char(21)
''
|
Check Numb...(more) Join Now
|
|
|
| PYADNMBR |
int
0
|
Payment/Ad...(more) Join Now
|
|
|
| TRXNUMBER |
int
0
|
TRX Number...(more) Join Now
|
|
|
| YEAR1 |
smallint
0
|
Year: The ...(more) Join Now
|
|
|
| CHEKDATE |
datetime
'1/1/1900'
|
Check Date...(more) Join Now
|
|
|
| DEPRTMNT |
char(7)
''
|
Department...(more) Join Now
|
|
join ... more text available
|
| PYRLRTYP |
smallint
0
|
1 = Regula...(more) Join Now
|
|
|
| PAYROLCD |
char(7)
''
|
Payroll Co...(more) Join Now
|
|
|
| TRXSORCE |
char(13)
''
|
Transactio...(more) Join Now
|
|
|
| DOCTYPE |
smallint
0
|
Document T...(more) Join Now
|
|
|
| JOBTITLE |
char(7)
''
|
|
|
|
| TRXBEGDT |
datetime
'1/1/1900'
|
Transactio...(more) Join Now
|
|
|
| TRXENDDT |
datetime
'1/1/1900'
|
Transactio...(more) Join Now
|
|
|
| UNTSTOPY |
numeric(19,5)
0.00
|
Units to p...(more) Join Now
|
|
|
| PAYRATE |
numeric(19,5)
0.00
|
|
|
|
| UPRTRXAM |
numeric(19,5)
0.00
|
UPR TRX Am...(more) Join Now
|
|
|
| TIMETYPE_I |
smallint
0
|
Time Type...(more) Join Now
|
|
|
| TIMEAVAILABLE |
numeric(19,5)
0.00
|
|
|
|
| TipType |
smallint
0
|
Tip Type: ...(more) Join Now
|
|
|
| RECEIPTS |
numeric(19,5)
0.00
|
|
|
|
| PAYADVNC |
numeric(19,5)
0.00
|
Pay Advanc...(more) Join Now
|
|
|
| STATECD |
char(3)
''
|
State Code...(more) Join Now
|
|
|
| LOCALTAX |
char(7)
''
|
|
|
|
| WRKRCOMP |
char(7)
''
|
Workers Co...(more) Join Now
|
|
|
| USWHPSTD |
char(15)
''
|
User Who P...(more) Join Now
|
|
|
| LSTDTEDT |
datetime
'1/1/1900'
|
Last Date ...(more) Join Now
|
|
|
| LASTUSER |
char(15)
''
|
Last User:...(more) Join Now
|
|
|
| SHFTCODE |
char(7)
''
|
Shift Code...(more) Join Now
|
|
|
| SHFTPREM |
numeric(19,5)
0.00
|
|
|
|
| TXBLWAGS |
numeric(19,5)
0.00
|
|
|
|
| DAYSWRDK |
int
0
|
|
|
|
| WKSWRKD |
int
0
|
|
|
|
| SUTASTAT |
char(3)
''
|
Suta State...(more) Join Now
|
|
|
| SBJTFUTA |
tinyint
0
|
|
|
|
| BSDONRTE |
numeric(19,5)
0.00
|
|
|
|
| EMPLCLAS |
char(15)
''
|
|
|
join ... more text available
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|