Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/APR_BLM43100
Product: HRM Solution Series (1911)
Series: Payroll
Display Name: Future Effective Payroll Deduction Setup Group Display Name: HRM Solution Series
Physical Name: APR_BLM43100
Technical Name: APR_BLM_PRDeduction
Group Technical Name: APR
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | DEDUCTON ![]() | Deduction | STR6_Payroll_Code | String | 6 | |
2 | DSCRIPTN ![]() | Description | STR30 | String | 30 | |
3 | INACTIVE ![]() | Inactive | CB_Inactive | Boolean | 0 | |
4 | DEDBEGDT ![]() | Deduction Beg Date | DT | Date | 8 | |
5 | DEDENDDT ![]() | Deduction End Date | DT | Date | 8 | |
6 | VARDEDTN ![]() | Variable Deduction | CB_Variable | Boolean | 0 | |
7 | DEDNFREQ ![]() | Deduction Frequency | DDL_Ded/Ben Frequency | Integer | 0 | |
8 | TXSHANTY ![]() | Tax Sheltered Annuity | CB_Tax_Sheltered_Annuity | Boolean | 0 | |
9 | SFRFEDTX ![]() | Sheltered From Federal Tax | CB_Federal_Tax | Boolean | 0 | |
10 | SHFRFICA ![]() | Sheltered From FICA | CB_FICA_Social_Security | Boolean | 0 | |
11 | SHFRSTTX ![]() | Sheltered From State Tax | CB_State_Tax | Boolean | 0 | |
12 | SFRLCLTX ![]() | Sheltered From Local Tax | CB_Local_Tax | Boolean | 0 | |
13 | BSDORCDS ![]() | Based On Records | GB | Integer | 0 | |
14 | DEDNMTHD ![]() | Deduction Method | DDL_Deduction_Method | Integer | 0 | |
15 | DEDFRMLA ![]() | Deduction Formula | GB | Integer | 0 | |
16 | DEDCAMNT_1 ![]() | Deduction Amount[1] | DLR11_$S2 | Currency | 14 | |
17 | DEDCAMNT_2 ![]() | Deduction Amount[2] | DLR11_$S2 | Currency | 14 | |
18 | DEDCAMNT_3 ![]() | Deduction Amount[3] | DLR11_$S2 | Currency | 14 | |
19 | DEDCAMNT_4 ![]() | Deduction Amount[4] | DLR11_$S2 | Currency | 14 | |
20 | DEDCAMNT_5 ![]() | Deduction Amount[5] | DLR11_$S2 | Currency | 14 | |
21 | DEDNPRCT_1 ![]() | Deduction Percent[1] | DLR8_U5% | Currency | 8 | |
22 | DEDNPRCT_2 ![]() | Deduction Percent[2] | DLR8_U5% | Currency | 8 | |
23 | DEDNPRCT_3 ![]() | Deduction Percent[3] | DLR8_U5% | Currency | 8 | |
24 | DEDNPRCT_4 ![]() | Deduction Percent[4] | DLR8_U5% | Currency | 8 | |
25 | DEDNPRCT_5 ![]() | Deduction Percent[5] | DLR8_U5% | Currency | 8 | |
26 | DEDTRMAX_1 ![]() | Deduction Tier Max[1] | DLR11_$U2 | Currency | 14 | |
27 | DEDTRMAX_2 ![]() | Deduction Tier Max[2] | DLR11_$U2 | Currency | 14 | |
28 | DEDTRMAX_3 ![]() | Deduction Tier Max[3] | DLR11_$U2 | Currency | 14 | |
29 | DEDTRMAX_4 ![]() | Deduction Tier Max[4] | DLR11_$U2 | Currency | 14 | |
30 | DEDTRMAX_5 ![]() | Deduction Tier Max[5] | DLR11_$U2 | Currency | 14 | |
31 | DETRMXUN_1 ![]() | Deduction Tier Max Units[1] | LI9_U2 | Long Integer | 9 | |
32 | DETRMXUN_2 ![]() | Deduction Tier Max Units[2] | LI9_U2 | Long Integer | 9 | |
33 | DETRMXUN_3 ![]() | Deduction Tier Max Units[3] | LI9_U2 | Long Integer | 9 | |
34 | DETRMXUN_4 ![]() | Deduction Tier Max Units[4] | LI9_U2 | Long Integer | 9 | |
35 | DETRMXUN_5 ![]() | Deduction Tier Max Units[5] | LI9_U2 | Long Integer | 9 | |
36 | DEPYPRMX ![]() | Deduction Pay Period Max | DLR11_$S2 | Currency | 14 | |
37 | DEDYRMAX ![]() | Deduction Year Max | DLR11_$S2 | Currency | 14 | |
38 | DEDLTMAX ![]() | Deduction Lifetime Max | DLR11_$S2 | Currency | 14 | |
39 | W2BXNMBR ![]() | W2 Box Number | INT2_U0 | Integer | 2 | |
40 | W2BXLABL ![]() | W2 Box Label | STR6 | String | 6 | |
41 | NOTEINDX ![]() | Note Index | DLR14 | Currency | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['Future Effective Payroll Deduction Setup'].NOTEINDX AS 'Future Effective Payroll Deduction Setup-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
APR_BLM43100 AS ['Future Effective Payroll Deduction Setup']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Future Effective Payroll Deduction Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
42 | DATAENTDFLT ![]() | Data Entry Default | CB_DataEntryDefault | Boolean | 0 | |
43 | DEDTYPE ![]() | Deduction Type | DDL_Deduction_Type | Integer | 0 | |
44 | GARNCAT ![]() | Garnishment Category | DDL_Garnishment_Cat | Integer | 0 | |
45 | EARNINGSCODE ![]() | Earnings Code | STR15_Earnings_Code | String | 15 | |
46 | W2BXNMBR2 ![]() | W2 Box Number 2 | INT2_U0 | Integer | 2 | |
47 | W2BXLABL2 ![]() | W2 Box Label 2 | STR6 | String | 6 | |
48 | W2BXNMBR3 ![]() | W2 Box Number 3 | INT2_U0 | Integer | 2 | |
49 | W2BXLABL3 ![]() | W2 Box Label 3 | STR6 | String | 6 | |
50 | W2BXNMBR4 ![]() | W2 Box Number 4 | INT2_U0 | Integer | 2 | |
51 | W2BXLABL4 ![]() | W2 Box Label 4 | STR6 | String | 6 | |
52 | Deduction_Fiscal_Yr_Max ![]() | Deduction Fiscal Year Max | DLR11_$S2 | Currency | 14 | |
53 | SHFRFICAMED ![]() | Sheltered From FICA Medicare | CB_FICA_Medicare | Boolean | 0 | |
54 | DEX_ROW_ID ![]() | int | int | 10 | ||
DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column. |