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

COMPANY..UPR00500 Table Definition

(COMPANY..Payroll Deduction Master)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
EMPLOYID char(15)
''
Employee I...(more) Join Now
join ... more text available
DEDUCTON char(7)
''
Deduction:...(more) Join Now
join ... more text available
INACTIVE tinyint
0

DEDBEGDT datetime
'1/1/1900'
Deduction ...(more) Join Now
DEDENDDT datetime
'1/1/1900'
Deduction ...(more) Join Now
VARDEDTN tinyint
0
Variable D...(more) Join Now
DEDNFREQ smallint
0
Deduction ...(more) Join Now
TXSHANTY tinyint
0
Tax Shelte...(more) Join Now
SFRFEDTX tinyint
0
Sheltered ...(more) Join Now
SHFRFICA tinyint
0
Sheltered ...(more) Join Now
SHFRSTTX tinyint
0
Sheltered ...(more) Join Now
SFRLCLTX tinyint
0
Sheltered ...(more) Join Now
BSDORCDS smallint
0
Based On R...(more) Join Now
DEDNMTHD smallint
0
p>Deductio...(more) Join Now
DEDFRMLA smallint
0
Deduction ...(more) Join Now
DEDNPRCT_1 numeric(19,5)
0.00
Deduction ...(more) Join Now
DEDNPRCT_2 numeric(19,5)
0.00

DEDNPRCT_3 numeric(19,5)
0.00

DEDNPRCT_4 numeric(19,5)
0.00

DEDNPRCT_5 numeric(19,5)
0.00

DEDCAMNT_1 numeric(19,5)
0.00
Deduction ...(more) Join Now
DEDCAMNT_2 numeric(19,5)
0.00

DEDCAMNT_3 numeric(19,5)
0.00

DEDCAMNT_4 numeric(19,5)
0.00

DEDCAMNT_5 numeric(19,5)
0.00

DEDTRMAX_1 numeric(19,5)
0.00
Deduction ...(more) Join Now
DEDTRMAX_2 numeric(19,5)
0.00

DEDTRMAX_3 numeric(19,5)
0.00

DEDTRMAX_4 numeric(19,5)
0.00

DEDTRMAX_5 numeric(19,5)
0.00

DETRMXUN_1 int
0
Deduction ...(more) Join Now
DETRMXUN_2 int
0

DETRMXUN_3 int
0

DETRMXUN_4 int
0

DETRMXUN_5 int
0

DEPYPRMX numeric(19,5)
0.00
Deduction ...(more) Join Now
DEDYRMAX numeric(19,5)
0.00
Deduction ...(more) Join Now
DEDLTMAX numeric(19,5)
0.00
Deduction ...(more) Join Now
W2BXNMBR smallint
0
W2 Box Num...(more) Join Now
W2BXLABL char(7)
''
W2 Box Lab...(more) Join Now
LTDDEDTN numeric(19,5)
0.00
LTD Deduct...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
NOTEINDX2 numeric(19,5)
0.00
Note Index...(more) Join Now
DATAENTDFLT tinyint
0
Data Entry...(more) Join Now
EARNINGSCODE char(15)
''
Earnings C...(more) Join Now
COURTDATE datetime
'1/1/1900'
Court Date...(more) Join Now
COURTNAME char(31)
''
Court Name...(more) Join Now
DOCDESCR char(31)
''
Document D...(more) Join Now
ORIGINALAMOUNT numeric(19,5)
0.00
Original A...(more) Join Now
AMNTTAKEN numeric(19,5)
0.00
Amount Tak...(more) Join Now
VENDORID char(15)
''
Vendor ID:...(more) Join Now
join ... more text available
FEDMAXDED char(15)
''
Federal Ma...(more) Join Now
STATEMAXDED char(15)
''
State Maxi...(more) Join Now
W2BXNMBR2 smallint
0

W2BXLABL2 char(7)
''

W2BXNMBR3 smallint
0

W2BXLABL3 char(7)
''

W2BXNMBR4 smallint
0

W2BXLABL4 char(7)
''

Deduction_Fiscal_Yr_Max numeric(19,5)
0.00

SHFRFICAMED tinyint
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