Module List >
Module BS tables
B3980284
You are currently viewing the COMPANY
database.
Change
|
COMPANY..B3980284 Table Definition
(COMPANY..BSSI_UPRTransactionHIST)
Field Definitions:
What is the 'source' column?
| CMRECNUM |
numeric(19,5)
0.00
|
Record Num...(more) Join Now
|
UPR30300.CMRECNUM
|
|
|
| AUCTRLCD |
char(13)
''
|
|
|
|
|
| EMPLOYID |
char(15)
''
|
Employee I...(more) Join Now
|
UPR00100.EMPLOYID
|
|
join ... more text available
|
| CHEKNMBR |
char(21)
''
|
|
|
|
|
| PYADNMBR |
int
0
|
|
|
|
|
| YEAR1 |
smallint
0
|
Year: The ...(more) Join Now
|
UPR00900.YEAR1
|
|
|
| CHEKDATE |
datetime
'1/1/1900'
|
|
|
|
|
| DEPRTMNT |
char(7)
''
|
Department...(more) Join Now
|
TATX1030.DEPRTMNT
|
|
join ... more text available
|
| PYRLRTYP |
smallint
0
|
1 = Regula...(more) Join Now
|
|
|
|
| PAYROLCD |
char(7)
''
|
Payroll Co...(more) Join Now
|
UPR40500.PAYROLCD
|
|
|
| TRXSORCE |
char(13)
''
|
Transactio...(more) Join Now
|
|
|
|
| DOCTYPE |
smallint
0
|
Document T...(more) Join Now
|
POP10110.DOCTYPE
|
|
|
| JOBTITLE |
char(7)
''
|
Job Title:...(more) Join Now
|
TATX1030.JOBTITLE
|
|
|
| TRXBEGDT |
datetime
'1/1/1900'
|
|
|
|
|
| TRXENDDT |
datetime
'1/1/1900'
|
|
|
|
|
| UNTSTOPY |
numeric(19,5)
0.00
|
Units to p...(more) Join Now
|
|
|
|
| PAYRATE |
numeric(19,5)
0.00
|
|
|
|
|
| UPRTRXAM |
numeric(19,5)
0.00
|
|
|
|
|
| TIMETYPE_I |
smallint
0
|
|
|
|
|
| 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
|
UPR00300.STATECD
|
|
|
| LOCALTAX |
char(7)
''
|
Local Tax:...(more) Join Now
|
UPR00300.LOCALTAX
|
|
|
| WRKRCOMP |
char(7)
''
|
Workers Co...(more) Join Now
|
UPR00400.WRKRCOMP
|
|
|
| USWHPSTD |
char(15)
''
|
|
|
|
|
| LSTDTEDT |
datetime
'1/1/1900'
|
|
|
|
|
| LASTUSER |
char(15)
''
|
|
|
|
|
| SHFTCODE |
char(7)
''
|
Shift Code...(more) Join Now
|
UPR00400.SHFTCODE
|
|
|
| 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
|
UPR00400.SUTASTAT
|
|
|
| SBJTFUTA |
tinyint
0
|
Subject to...(more) Join Now
|
UPR00400.SBJTFUTA
|
|
|
| BSDONRTE |
numeric(19,5)
0.00
|
Based On R...(more) Join Now
|
UPR00400.BSDONRTE
|
|
|
| EMPLCLAS |
char(15)
''
|
Employee C...(more) Join Now
|
UPR00100.EMPLCLAS
|
|
join ... more text available
|
| BSSI_Facility_ID |
char(67)
''
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|