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

COMPANY..UPR10205 Table Definition

(COMPANY..Payroll Work Benefit)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
DEPRTMNT char(7)
''
Department...(more) Join Now
join ... more text available
JOBTITLE char(7)
''

USERID char(15)
''
The user t...(more) Join Now
join ... more text available
PYRNTYPE smallint
0

EMPLOYID char(15)
''
Employee I...(more) Join Now
join ... more text available
TRXNUMBER int
0

BENEFIT char(7)
''

TAXABLE tinyint
0
Taxable: ...(more) Join Now
VARBENFT tinyint
0
Variable B...(more) Join Now
VARDBAMT numeric(19,5)
0.00

VARDBPCT int
0

BNFTFREQ smallint
0
Benefit Fr...(more) Join Now
TOTLBNFT numeric(19,5)
0.00

AMTBOTIP numeric(19,5)
0.00

BCHSOURC char(15)
''
Batch Sour...(more) Join Now
PRTRXSRC int
0

LASTUSER char(15)
''
Last User:...(more) Join Now GL10000.LASTUSER
LSTDTEDT datetime
'1/1/1900'
Last Date ...(more) Join Now GL10000.LSTDTEDT
TRXBEGDT datetime
'1/1/1900'

TRXENDDT datetime
'1/1/1900'

BLDCHWRG binary(4)
0

BLDCHERR binary(4)
0

BNFTMTHD smallint
0
Benefit Me...(more) Join Now
PRCSSQNC smallint
0

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