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

COMPANY..UPR10204 Table Definition

(COMPANY..Payroll Work Deduction)

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

DEDUCTON char(7)
''
Deduction:...(more) Join Now
join ... more text available
TXSHANTY tinyint
0
Tax Shelte...(more) Join Now
DEDNSQNC smallint
0

VARDEDTN tinyint
0
Variable D...(more) Join Now
VARDBAMT numeric(19,5)
0.00

VARDBPCT int
0

DEDNFREQ smallint
0
Deduction ...(more) Join Now
TTLDEDTN 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

DEDNMTHD smallint
0
Deduction ...(more) Join Now
PRCSSQNC smallint
0

SEQCOUNT int
0

SEQUENCESUM numeric(19,5)
0.00

CALCCHKWRN binary(4)
0

ATTEMPTEDAMT numeric(19,5)
0.00

SPLITMTHD smallint
0

MAXAMOUNT numeric(19,5)
0.00

BASEDONWAGES numeric(19,5)
0.00

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