Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/APR_BLM42100
Product: HRM Solution Series (1911)
Series:
Display Name: Future Effective Payroll Benefit Setup Group Display Name: HRM Solution Series
Physical Name: APR_BLM42100
Technical Name: APR_BLM_PRBenefit
Group Technical Name: APR
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | BENEFIT | Benefit | String | STR6_Payroll_Code | 6 | |
2 | DSCRIPTN | Description | String | STR30 | 30 | |
3 | INACTIVE | Inactive | Boolean | CB_Inactive | 0 | |
4 | BNFBEGDT | Benefit Beg Date | Date | DT | 8 | |
5 | BNFENDDT | Benefit End Date | Date | DT | 8 | |
6 | VARBENFT | Variable Benefit | Boolean | CB_Variable | 0 | |
7 | BNFTFREQ | Benefit Frequency | Integer | DDL_Ded/Ben Frequency | 0 | |
8 | TAXABLE | Taxable | Boolean | CB_Taxable | 0 | |
9 | SBJTFDTX | Subject To Federal Tax | Boolean | CB_Federal | 0 | |
10 | SBJTSSEC | Subject To Social Security | Boolean | CB_FICA_Social_Security | 0 | |
11 | SBJTMCAR | Subject To Medicare | Boolean | CB_FICA_Medicare | 0 | |
12 | SBJTSTTX | Subject To State Tax | Boolean | CB_State | 0 | |
13 | SBJTLTAX | Subject To Local Tax | Boolean | CB_Local | 0 | |
14 | SBJTFUTA | Subject To Futa | Boolean | CB_Futa | 0 | |
15 | SBJTSUTA | Subject To Suta | Boolean | CB_Suta | 0 | |
16 | FFEDTXRT | Flat Federal Tax Rate | Integer | INT4_%2 | 4 | |
17 | FLSTTXRT | Flat State Tax Rate | Integer | INT4_%2 | 4 | |
18 | BORCDTYP | Based On Record Type | Integer | DDL_Based_On_Record_Type | 0 | |
19 | BSDORCDS | Based On Records | Integer | GB | 0 | |
20 | BNFTMTHD | Benefit Method | Integer | DDL_Benefit_Method | 0 | |
21 | BNFFRMLA | Benefit Formula | Integer | GB | 0 | |
22 | BNFPRCNT_1 | Benefit Percent[1] | Currency | DLR8_U5% | 8 | |
23 | BNFPRCNT_2 | Benefit Percent[2] | Currency | DLR8_U5% | 8 | |
24 | BNFPRCNT_3 | Benefit Percent[3] | Currency | DLR8_U5% | 8 | |
25 | BNFPRCNT_4 | Benefit Percent[4] | Currency | DLR8_U5% | 8 | |
26 | BNFPRCNT_5 | Benefit Percent[5] | Currency | DLR8_U5% | 8 | |
27 | BNFITAMT_1 | Benefit Amount[1] | Currency | DLR11_$U2 | 14 | |
28 | BNFITAMT_2 | Benefit Amount[2] | Currency | DLR11_$U2 | 14 | |
29 | BNFITAMT_3 | Benefit Amount[3] | Currency | DLR11_$U2 | 14 | |
30 | BNFITAMT_4 | Benefit Amount[4] | Currency | DLR11_$U2 | 14 | |
31 | BNFITAMT_5 | Benefit Amount[5] | Currency | DLR11_$U2 | 14 | |
32 | BNFTRMAX_1 | Benefit Tier Max[1] | Currency | DLR11_$U2 | 14 | |
33 | BNFTRMAX_2 | Benefit Tier Max[2] | Currency | DLR11_$U2 | 14 | |
34 | BNFTRMAX_3 | Benefit Tier Max[3] | Currency | DLR11_$U2 | 14 | |
35 | BNFTRMAX_4 | Benefit Tier Max[4] | Currency | DLR11_$U2 | 14 | |
36 | BNFTRMAX_5 | Benefit Tier Max[5] | Currency | DLR11_$U2 | 14 | |
37 | BNTRMXUN_1 | Benefit Tier Max Units[1] | Long Integer | LI9_U2 | 9 | |
38 | BNTRMXUN_2 | Benefit Tier Max Units[2] | Long Integer | LI9_U2 | 9 | |
39 | BNTRMXUN_3 | Benefit Tier Max Units[3] | Long Integer | LI9_U2 | 9 | |
40 | BNTRMXUN_4 | Benefit Tier Max Units[4] | Long Integer | LI9_U2 | 9 | |
41 | BNTRMXUN_5 | Benefit Tier Max Units[5] | Long Integer | LI9_U2 | 9 | |
42 | BNPAYPMX | Benefit Pay Period Max | Currency | DLR11_$U2 | 14 | |
43 | BNFYRMAX | Benefit Year Max | Currency | DLR11_$U2 | 14 | |
44 | BNFLFMAX | Benefit Lifetime Max | Currency | DLR11_$U2 | 14 | |
45 | W2BXNMBR | W2 Box Number | Integer | INT2_U0 | 2 | |
46 | W2BXLABL | W2 Box Label | String | STR6 | 6 | |
47 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['Future Effective Payroll Benefit Setup'].NOTEINDX AS 'Future Effective Payroll Benefit Setup-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
APR_BLM42100 AS ['Future Effective Payroll Benefit Setup']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Future Effective Payroll Benefit Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
48 | DATAENTDFLT | Data Entry Default | Boolean | CB_DataEntryDefault | 0 | |
49 | EMPLRMAXMAT | Employer Maximum Match | Currency | DLR8_U5% | 8 | |
50 | W2BXNMBR2 | W2 Box Number 2 | Integer | INT2_U0 | 2 | |
51 | W2BXLABL2 | W2 Box Label 2 | String | STR6 | 6 | |
52 | W2BXNMBR3 | W2 Box Number 3 | Integer | INT2_U0 | 2 | |
53 | W2BXLABL3 | W2 Box Label 3 | String | STR6 | 6 | |
54 | W2BXNMBR4 | W2 Box Number 4 | Integer | INT2_U0 | 2 | |
55 | W2BXLABL4 | W2 Box Label 4 | String | STR6 | 6 | |
56 | Benefit_Fiscal_Max | Benefit Fiscal Max | Currency | DLR11_$U2 | 14 |