UPR40900 - Payroll Deduction Setup | Prospr - Dynamics GP Table Reference

UPR40900 - Payroll Deduction Setup

Query Builder

Select * from UPR40900

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
DEDUCTON	Deduction	String	8	View
DSCRIPTN	Description	String	32	View
INACTIVE	Inactive	Boolean	2	View
DEDBEGDT	Deduction Beg Date	Date	4	View
DEDENDDT	Deduction End Date	Date	4	View
VARDEDTN	Variable Deduction	Boolean	2	View
DEDNFREQ	Deduction Frequency	Integer	2	View
TXSHANTY	Tax Sheltered Annuity	Boolean	2	View
SFRFEDTX	Sheltered From Federal Tax	Boolean	2	View
SHFRFICA	Sheltered From FICA	Boolean	2	View
SHFRSTTX	Sheltered From State Tax	Boolean	2	View
SFRLCLTX	Sheltered From Local Tax	Boolean	2	View
BSDORCDS	Based On Records	Integer	2	View
DEDNMTHD	Deduction Method	Integer	2	View
DEDFRMLA	Deduction Formula	Integer	2	View
DEDCAMNT_1	Deduction Amount[1]	Currency	10	View
DEDCAMNT_2	Deduction Amount[2]	Currency	10	View
DEDCAMNT_3	Deduction Amount[3]	Currency	10	View
DEDCAMNT_4	Deduction Amount[4]	Currency	10	View
DEDCAMNT_5	Deduction Amount[5]	Currency	10	View
DEDNPRCT_1	Deduction Percent[1]	Currency	10	View
DEDNPRCT_2	Deduction Percent[2]	Currency	10	View
DEDNPRCT_3	Deduction Percent[3]	Currency	10	View
DEDNPRCT_4	Deduction Percent[4]	Currency	10	View
DEDNPRCT_5	Deduction Percent[5]	Currency	10	View
DEDTRMAX_1	Deduction Tier Max[1]	Currency	10	View
DEDTRMAX_2	Deduction Tier Max[2]	Currency	10	View
DEDTRMAX_3	Deduction Tier Max[3]	Currency	10	View
DEDTRMAX_4	Deduction Tier Max[4]	Currency	10	View
DEDTRMAX_5	Deduction Tier Max[5]	Currency	10	View
DETRMXUN_1	Deduction Tier Max Units[1]	Long Integer	4	View
DETRMXUN_2	Deduction Tier Max Units[2]	Long Integer	4	View
DETRMXUN_3	Deduction Tier Max Units[3]	Long Integer	4	View
DETRMXUN_4	Deduction Tier Max Units[4]	Long Integer	4	View
DETRMXUN_5	Deduction Tier Max Units[5]	Long Integer	4	View
DEPYPRMX	Deduction Pay Period Max	Currency	10	View
DEDYRMAX	Deduction Year Max	Currency	10	View
DEDLTMAX	Deduction Lifetime Max	Currency	10	View
W2BXNMBR	W2 Box Number	Integer	2	View
W2BXLABL	W2 Box Label	String	8	View
NOTEINDX	Note Index	Currency	10	View
DATAENTDFLT	Data Entry Default	Boolean	2	View
DEDTYPE	Deduction Type	Integer	2	View
GARNCAT	Garnishment Category	Integer	2	View
EARNINGSCODE	Earnings Code	String	16	View
W2BXNMBR2	W2 Box Number 2	Integer	2	View
W2BXLABL2	W2 Box Label 2	String	8	View
W2BXNMBR3	W2 Box Number 3	Integer	2	View
W2BXLABL3	W2 Box Label 3	String	8	View
W2BXNMBR4	W2 Box Number 4	Integer	2	View
W2BXLABL4	W2 Box Label 4	String	8	View
Deduction_Fiscal_Yr_Max	Deduction Fiscal Year Max	Currency	10	View
SHFRFICAMED	Sheltered From FICA Medicare	Boolean	2	View

UPR40900 - Payroll Deduction Setup

Query Builder

Customer Service

Information

My Account

Contact Us