UPR00500 - Payroll Deduction Master | Prospr - Dynamics GP Table Reference

UPR00500 - Payroll Deduction Master

Query Builder

Select * from UPR00500

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPLOYID	Employee ID	String	16	View
DEDUCTON	Deduction	String	8	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
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
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
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
LTDDEDTN	LTD Deduction	Currency	10	View
NOTEINDX	Note Index	Currency	10	View
NOTEINDX2	Note Index2	Currency	10	View
DATAENTDFLT	Data Entry Default	Boolean	2	View
EARNINGSCODE	Earnings Code	String	16	View
COURTDATE	Court Date	Date	4	View
COURTNAME	Court Name	String	32	View
DOCDESCR	Document Description	String	32	View
ORIGINALAMOUNT	Original Amount	Currency	10	View
AMNTTAKEN	Amount Taken	Currency	10	View
VENDORID	Vendor ID	String	16	View
FEDMAXDED	Federal Maximum Deduction	String	16	View
STATEMAXDED	State Maximum Deduction	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

UPR00500 - Payroll Deduction Master

Query Builder

Customer Service

Information

My Account

Contact Us