Module List > Module UPR tables UPR30300
You are currently viewing the COMPANY database.
Change

COMPANY..UPR30300 Table Definition

(COMPANY..Payroll Transaction History)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3