Future Effective Payroll Deduction Setup (APR_BLM43100)

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
Physical Name: APR_BLM43100
Technical Name: APR_BLM_PRDeduction

Group Display Name: HRM Solution Series
Group Technical Name: APR

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	DEDUCTON	Deduction	STR6_Payroll_Code	String	8	6
2	DSCRIPTN	Description	STR30	String	32	30
3	INACTIVE	Inactive	CB_Inactive	Boolean	2	0
4	DEDBEGDT	Deduction Beg Date	DT	Date	4	8
5	DEDENDDT	Deduction End Date	DT	Date	4	8
6	VARDEDTN	Variable Deduction	CB_Variable	Boolean	2	0
7	DEDNFREQ	Deduction Frequency	DDL_Ded/Ben Frequency	Integer	2	0
8	TXSHANTY	Tax Sheltered Annuity	CB_Tax_Sheltered_Annuity	Boolean	2	0
9	SFRFEDTX	Sheltered From Federal Tax	CB_Federal_Tax	Boolean	2	0
10	SHFRFICA	Sheltered From FICA	CB_FICA_Social_Security	Boolean	2	0
11	SHFRSTTX	Sheltered From State Tax	CB_State_Tax	Boolean	2	0
12	SFRLCLTX	Sheltered From Local Tax	CB_Local_Tax	Boolean	2	0
13	BSDORCDS	Based On Records	GB	Integer	2	0
14	DEDNMTHD	Deduction Method	DDL_Deduction_Method	Integer	2	0
15	DEDFRMLA	Deduction Formula	GB	Integer	2	0
16	DEDCAMNT_1	Deduction Amount[1]	DLR11_$S2	Currency	10	14
17	DEDCAMNT_2	Deduction Amount[2]	DLR11_$S2	Currency	10	14
18	DEDCAMNT_3	Deduction Amount[3]	DLR11_$S2	Currency	10	14
19	DEDCAMNT_4	Deduction Amount[4]	DLR11_$S2	Currency	10	14
20	DEDCAMNT_5	Deduction Amount[5]	DLR11_$S2	Currency	10	14
21	DEDNPRCT_1	Deduction Percent[1]	DLR8_U5%	Currency	10	8
22	DEDNPRCT_2	Deduction Percent[2]	DLR8_U5%	Currency	10	8
23	DEDNPRCT_3	Deduction Percent[3]	DLR8_U5%	Currency	10	8
24	DEDNPRCT_4	Deduction Percent[4]	DLR8_U5%	Currency	10	8
25	DEDNPRCT_5	Deduction Percent[5]	DLR8_U5%	Currency	10	8
26	DEDTRMAX_1	Deduction Tier Max[1]	DLR11_$U2	Currency	10	14
27	DEDTRMAX_2	Deduction Tier Max[2]	DLR11_$U2	Currency	10	14
28	DEDTRMAX_3	Deduction Tier Max[3]	DLR11_$U2	Currency	10	14
29	DEDTRMAX_4	Deduction Tier Max[4]	DLR11_$U2	Currency	10	14
30	DEDTRMAX_5	Deduction Tier Max[5]	DLR11_$U2	Currency	10	14
31	DETRMXUN_1	Deduction Tier Max Units[1]	LI9_U2	Long Integer	4	9
32	DETRMXUN_2	Deduction Tier Max Units[2]	LI9_U2	Long Integer	4	9
33	DETRMXUN_3	Deduction Tier Max Units[3]	LI9_U2	Long Integer	4	9
34	DETRMXUN_4	Deduction Tier Max Units[4]	LI9_U2	Long Integer	4	9
35	DETRMXUN_5	Deduction Tier Max Units[5]	LI9_U2	Long Integer	4	9
36	DEPYPRMX	Deduction Pay Period Max	DLR11_$S2	Currency	10	14
37	DEDYRMAX	Deduction Year Max	DLR11_$S2	Currency	10	14
38	DEDLTMAX	Deduction Lifetime Max	DLR11_$S2	Currency	10	14
39	W2BXNMBR	W2 Box Number	INT2_U0	Integer	2	2
40	W2BXLABL	W2 Box Label	STR6	String	8	6
41	NOTEINDX	Note Index	DLR14	Currency	10	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['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	2	0
43	DEDTYPE	Deduction Type	DDL_Deduction_Type	Integer	2	0
44	GARNCAT	Garnishment Category	DDL_Garnishment_Cat	Integer	2	0
45	EARNINGSCODE	Earnings Code	STR15_Earnings_Code	String	16	15
46	W2BXNMBR2	W2 Box Number 2	INT2_U0	Integer	2	2
47	W2BXLABL2	W2 Box Label 2	STR6	String	8	6
48	W2BXNMBR3	W2 Box Number 3	INT2_U0	Integer	2	2
49	W2BXLABL3	W2 Box Label 3	STR6	String	8	6
50	W2BXNMBR4	W2 Box Number 4	INT2_U0	Integer	2	2
51	W2BXLABL4	W2 Box Label 4	STR6	String	8	6
52	Deduction_Fiscal_Yr_Max	Deduction Fiscal Year Max	DLR11_$S2	Currency	10	14
53	SHFRFICAMED	Sheltered From FICA Medicare	CB_FICA_Medicare	Boolean	2	0
54	DEX_ROW_ID		int	int	10	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.

azurecurve Products HRM Solution Series (1911)PayrollFuture Effective Payroll Deduction Setup (APR_BLM43100)

Click to show/hide

Leave a Reply Cancel reply