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

COMPANY..APR_BLM41301 Table Definition

(COMPANY..Future Effective Benefit Tiers Backup)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
BENEFIT char(7)
''
Benefit: ...(more) Join Now UPR00600.BENEFIT
BNFTMTHD smallint
0
Benefit Me...(more) Join Now
BNFPRCNT_1 numeric(19,5)
0
Benefit Pe...(more) Join Now
BNFPRCNT_2 numeric(19,5)
0

BNFPRCNT_3 numeric(19,5)
0

BNFPRCNT_4 numeric(19,5)
0

BNFPRCNT_5 numeric(19,5)
0

BNFITAMT_1 numeric(19,5)
0
Benefit Am...(more) Join Now
BNFITAMT_2 numeric(19,5)
0

BNFITAMT_3 numeric(19,5)
0

BNFITAMT_4 numeric(19,5)
0

BNFITAMT_5 numeric(19,5)
0

BNFTRMAX_1 numeric(19,5)
0
Benefit Ti...(more) Join Now
BNFTRMAX_2 numeric(19,5)
0

BNFTRMAX_3 numeric(19,5)
0

BNFTRMAX_4 numeric(19,5)
0

BNFTRMAX_5 numeric(19,5)
0

BNTRMXUN_1 int
0
Benefit Ti...(more) Join Now
BNTRMXUN_2 int
0

BNTRMXUN_3 int
0

BNTRMXUN_4 int
0

BNTRMXUN_5 int
0

DEDUCTON char(7)
''
Deduction:...(more) Join Now UPR00500.DEDUCTON
join ... more text available
DEDNMTHD smallint
0
Deduction ...(more) Join Now UPR00500.DEDNMTHD
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

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

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

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