Payroll Deduction Master (UPR00500)

azurecurve Products Microsoft Dynamics GP (0)PayrollPayroll Deduction Master (UPR00500)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/UPR00500

Product: Microsoft Dynamics GP (0)
Series: Payroll

Display Name: Payroll Deduction Master
Physical Name: UPR00500
Technical Name: UPR_MSTR_Deduction

Group Display Name: Payroll Employee Master
Group Technical Name: Payroll Employee Master

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	EMPLOYID	Employee ID	String	STR15_Employee_ID	15
2	DEDUCTON	Deduction	String	STR6_Payroll_Code	6
3	INACTIVE	Inactive	Boolean	CB_Inactive	0
4	DEDBEGDT	Deduction Beg Date	Date	DT	8
5	DEDENDDT	Deduction End Date	Date	DT	8
6	VARDEDTN	Variable Deduction	Boolean	CB_Variable	0
7	DEDNFREQ	Deduction Frequency	Integer	DDL_Ded/Ben Frequency	0
8	TXSHANTY	Tax Sheltered Annuity	Boolean	CB_Tax_Sheltered_Annuity	0
9	SFRFEDTX	Sheltered From Federal Tax	Boolean	CB_Federal_Tax	0
10	SHFRFICA	Sheltered From FICA	Boolean	CB_FICA_Social_Security	0
11	SHFRSTTX	Sheltered From State Tax	Boolean	CB_State_Tax	0
12	SFRLCLTX	Sheltered From Local Tax	Boolean	CB_Local_Tax	0
13	BSDORCDS	Based On Records	Integer	GB	0
14	DEDNMTHD	Deduction Method	Integer	DDL_Deduction_Method	0
15	DEDFRMLA	Deduction Formula	Integer	GB	0
16	DEDNPRCT	Deduction Percent	DLR8_U5%	Currency	8
17	DEDNPRCT_1	Deduction Percent[1]	Currency	DLR8_U5%	8
18	DEDNPRCT_2	Deduction Percent[2]	Currency	DLR8_U5%	8
19	DEDNPRCT_3	Deduction Percent[3]	Currency	DLR8_U5%	8
20	DEDNPRCT_4	Deduction Percent[4]	Currency	DLR8_U5%	8
21	DEDNPRCT_5	Deduction Percent[5]	Currency	DLR8_U5%	8
22	DEDCAMNT_1	Deduction Amount[1]	Currency	DLR11_$S2	14
23	DEDCAMNT_2	Deduction Amount[2]	Currency	DLR11_$S2	14
24	DEDCAMNT	Deduction Amount	DLR11_$S2	Currency	14
25	DEDCAMNT_3	Deduction Amount[3]	Currency	DLR11_$S2	14
26	DEDCAMNT_4	Deduction Amount[4]	Currency	DLR11_$S2	14
27	DEDCAMNT_5	Deduction Amount[5]	Currency	DLR11_$S2	14
28	DEDTRMAX_1	Deduction Tier Max[1]	Currency	DLR11_$U2	14
29	DEDTRMAX_2	Deduction Tier Max[2]	Currency	DLR11_$U2	14
30	DEDTRMAX	Deduction Tier Max	DLR11_$U2	Currency	14
31	DEDTRMAX_3	Deduction Tier Max[3]	Currency	DLR11_$U2	14
32	DEDTRMAX_4	Deduction Tier Max[4]	Currency	DLR11_$U2	14
33	DEDTRMAX_5	Deduction Tier Max[5]	Currency	DLR11_$U2	14
34	DETRMXUN_1	Deduction Tier Max Units[1]	Long Integer	LI9_U2	9
35	DETRMXUN_2	Deduction Tier Max Units[2]	Long Integer	LI9_U2	9
36	DETRMXUN_3	Deduction Tier Max Units[3]	Long Integer	LI9_U2	9
37	DETRMXUN_4	Deduction Tier Max Units[4]	Long Integer	LI9_U2	9
38	DETRMXUN	Deduction Tier Max Units	LI9_U2	Long Integer	9
39	DETRMXUN_5	Deduction Tier Max Units[5]	Long Integer	LI9_U2	9
40	DEPYPRMX	Deduction Pay Period Max	Currency	DLR11_$S2	14
41	DEDYRMAX	Deduction Year Max	Currency	DLR11_$S2	14
42	DEDLTMAX	Deduction Lifetime Max	Currency	DLR11_$S2	14
43	W2BXNMBR	W2 Box Number	Integer	INT2_U0	2
44	W2BXLABL	W2 Box Label	String	STR6	6
45	LTDDEDTN	LTD Deduction	Currency	DLR11_$S2	14
46	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Payroll Deduction Master'].NOTEINDX AS 'Payroll Deduction Master-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM UPR00500 AS ['Payroll Deduction Master'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Payroll Deduction Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
47	NOTEINDX2	Note Index2	Currency	DLR14	14
48	DATAENTDFLT	Data Entry Default	Boolean	CB_DataEntryDefault	0
49	EARNINGSCODE	Earnings Code	String	STR15_Earnings_Code	15
50	COURTDATE	Court Date	Date	DATE_L	0
51	COURTNAME	Court Name	String	STR30	30
52	DOCDESCR	Document Description	String	STR30	30
53	ORIGINALAMOUNT	Original Amount	Currency	DLR11_$U2	14
54	AMNTTAKEN	Amount Taken	Currency	DLR11_$U2	14
55	VENDORID	Vendor ID	String	STR_15_Vendor_ID	15
	Key to the PM Vendor Master File (PM00200). Click to show/hide SELECT ['Payroll Deduction Master'].VENDORID AS 'Payroll Deduction Master-Vendor ID' ,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID' FROM UPR00500 AS ['Payroll Deduction Master'] INNER JOIN PM00200 AS ['PM Vendor Master File'] ON ['Payroll Deduction Master'].VENDORID = ['PM Vendor Master File'].VENDORID
56	FEDMAXDED	Federal Maximum Deduction	String	STR15_Max_Code	15
57	STATEMAXDED	State Maximum Deduction	String	STR15_Max_Code	15
58	W2BXNMBR2	W2 Box Number 2	Integer	INT2_U0	2
59	W2BXLABL2	W2 Box Label 2	String	STR6	6
60	W2BXNMBR3	W2 Box Number 3	Integer	INT2_U0	2
61	W2BXLABL3	W2 Box Label 3	String	STR6	6
62	W2BXNMBR4	W2 Box Number 4	Integer	INT2_U0	2
63	W2BXLABL4	W2 Box Label 4	String	STR6	6
64	Deduction_Fiscal_Yr_Max	Deduction Fiscal Year Max	Currency	DLR11_$S2	14
65	SHFRFICAMED	Sheltered From FICA Medicare	Boolean	CB_FICA_Medicare	0

azurecurve Products Microsoft Dynamics GP (0)PayrollPayroll Deduction Master (UPR00500)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply