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

COMPANY..APR_BLM42100 Table Definition

(COMPANY..Future Effective Payroll Benefit Setup)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
BENEFIT char(7)
''
Benefit: ...(more) Join Now UPR00600.BENEFIT
DSCRIPTN char(31)
''

INACTIVE tinyint
0

BNFBEGDT datetime
'1/1/1900'
Benefit Be...(more) Join Now
BNFENDDT datetime
'1/1/1900'
Benefit En...(more) Join Now
VARBENFT tinyint
0
Variable B...(more) Join Now
BNFTFREQ smallint
0
Benefit Fr...(more) Join Now
TAXABLE tinyint
0
Taxable: ...(more) Join Now
SBJTFDTX tinyint
0
Subject To...(more) Join Now
SBJTSSEC tinyint
0
Subject To...(more) Join Now
SBJTMCAR tinyint
0
Subject To...(more) Join Now
SBJTSTTX tinyint
0
Subject to...(more) Join Now
SBJTLTAX tinyint
0
Subject to...(more) Join Now
SBJTFUTA tinyint
0
Subject to...(more) Join Now UPR00400.SBJTFUTA
SBJTSUTA tinyint
0
Subject to...(more) Join Now
FFEDTXRT smallint
0
Flat Feder...(more) Join Now
FLSTTXRT smallint
0
Flat State...(more) Join Now
BORCDTYP smallint
0
Based On ...(more) Join Now
BSDORCDS smallint
0
Based On R...(more) Join Now
BNFTMTHD smallint
0
Benefit Me...(more) Join Now
BNFFRMLA smallint
0
Benefit Formula: 0 is Single, 1 is Tiered. In SBM, this field defaults to the value from the Benefit Formula field of the Payroll Benefit Setup table. The Benefit Formula field is always set to zero (0) in SBM. This field is not exposed in the SBM user interface.
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

BNPAYPMX numeric(19,5)
0
Benefit Pa...(more) Join Now
BNFYRMAX numeric(19,5)
0
Benefit Ye...(more) Join Now
BNFLFMAX numeric(19,5)
0
Benefit Li...(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
EMPLRMAXMAT numeric(19,5)
0
Employer ...(more) Join Now
W2BXNMBR2 smallint
0

W2BXLABL2 char(7)
''

W2BXNMBR3 smallint
0

W2BXLABL3 char(7)
''

W2BXNMBR4 smallint
0

W2BXLABL4 char(7)
''

Benefit_Fiscal_Max numeric(19,5)
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