Module List > Module HRM tables APR_BLM33100
You are currently viewing the COMPANY database.
Change

COMPANY..APR_BLM33100 Table Definition

(COMPANY..Future Effective Payroll Deduction Setup History)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
DEDUCTON char(7)
''
Deduction:...(more) Join Now UPR00500.DEDUCTON
join ... more text available
DSCRIPTN char(31)
''

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
Deduction ...(more) Join Now UPR00500.DEDNMTHD
DEDFRMLA smallint
0
Deduction ...(more) Join Now UPR00500.DEDFRMLA
DEDCAMNT_1 numeric(19,5)
0
Deduction ...(more) Join Now UPR00500.DEDCAMNT_1
DEDCAMNT_2 numeric(19,5)
0

DEDCAMNT_3 numeric(19,5)
0

DEDCAMNT_4 numeric(19,5)
0

DEDCAMNT_5 numeric(19,5)
0

DEDNPRCT_1 numeric(19,5)
0
Deduction ...(more) Join Now UPR00500.DEDNPRCT_1
DEDNPRCT_2 numeric(19,5)
0

DEDNPRCT_3 numeric(19,5)
0

DEDNPRCT_4 numeric(19,5)
0

DEDNPRCT_5 numeric(19,5)
0

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

DEDTRMAX_3 numeric(19,5)
0

DEDTRMAX_4 numeric(19,5)
0

DEDTRMAX_5 numeric(19,5)
0

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

DETRMXUN_3 int
0

DETRMXUN_4 int
0

DETRMXUN_5 int
0

DEPYPRMX numeric(19,5)
0
Deduction ...(more) Join Now
DEDYRMAX numeric(19,5)
0
Deduction ...(more) Join Now
DEDLTMAX numeric(19,5)
0
Deduction ...(more) Join Now
W2BXNMBR smallint
0
W2 Box Num...(more) Join Now
W2BXLABL char(7)
''
W2 Box Lab...(more) Join Now
NOTEINDX numeric(19,5)
0
Note Index...(more) Join Now
join ... more text available
DATAENTDFLT tinyint
0
Data Entry...(more) Join Now
DEDTYPE smallint
0

GARNCAT smallint
0

EARNINGSCODE char(15)
''
Earnings C...(more) Join Now UPR00500.EARNINGSCODE
SEQNUMBR int
0
Sequence N...(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

SHFRFICAMED tinyint
0

CHANGEBY_I char(15)
''
*Change By...(more) Join Now TATX1030.CHANGEBY_I
CHANGEDATE_I datetime
'1/1/1900'
*Change Da...(more) Join Now HR2EMP02.CHANGEDATE_I
CHANGEREASON_I char(31)
''

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