UPR40200 - Payroll Setup | Prospr - Dynamics GP Table Reference

UPR40200 - Payroll Setup

Query Builder

Select * from UPR40200

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
SETUPKEY	Setup Key	Integer	2	View
AUTOVRTM	Automatic Overtime	Boolean	2	View
REGHRSRQ	Regular Hours Required	Long Integer	4	View
LSFUTADT	Last Futa Date	Date	4	View
LSSUTADT	Last Suta Date	Date	4	View
LSWCMPDT	Last Workers Comp Date	Date	4	View
USRDFPR1	User Defined Prompt 1	String	16	View
USRDRPR2	User Defined Prompt 2	String	16	View
COMPCHID	Computer Checkbook ID	String	16	View
MLCHBKID	Manual Checkbook ID	String	16	View
UPRNPNUM	UPR Next Payment Number	Long Integer	4	View
UPRNANUM	UPR Next Adjustment Number	Long Integer	4	View
NXCTRNUM	Next Computer TRX Number	Long Integer	4	View
NXMTRNUM	Next Manual TRX Number	Long Integer	4	View
KPYCHKHS	Keep Pay Check History	Boolean	2	View
KPPTRHST	Keep Pay Trx History	Boolean	2	View
KPYGLDST	Keep Pay GL Distribution	Boolean	2	View
EDFINFLD	Edit Financial Fields	Boolean	2	View
DSPYRTRX	Display Pay Rate On Trx	Boolean	2	View
CalcTipAlloc	Calc Tip Alloc	Boolean	2	View
TipAllocRate	Tip Alloc Rate	Currency	10	View
TRKDYWKD	Track Days Worked	Boolean	2	View
TRKWKWKD	Track Weeks Worked	Boolean	2	View
PAYRTDEC	Pay Rate Decimals	Integer	2	View
DEDTNDEC	Deduction Decimals	Integer	2	View
BNFTDCML	Benefit Decimals	Integer	2	View
CHKFRMAT	Check Format	Integer	2	View
SCKTMAVLPWD	Sick Time Available Password	String	12	View
VCTAVLPWD	Vacation Available Password	String	12	View
Benefit_YTD_Amts	UPR_SETP_Benefits	Boolean	2	View
Deduction_YTD_Amts	UPR_SETP_Deductions	Boolean	2	View
Local_Taxes_YTD_Amts	UPR_SETP_Local_Taxes	Boolean	2	View
Pay_Code_YTD_Amts	UPR_SETP_Pay_Codes	Boolean	2	View
State_Taxes_YTD_Amts	UPR_SETP_State_Taxes	Boolean	2	View
PYFTRDEC	Pay Factor Decimals	Integer	2	View
Enable_Fiscal_Tracking	Enable Fiscal Tracking	Boolean	2	View
Check_Print_Default	Check Print Default	Integer	2	View

UPR40200 - Payroll Setup

Query Builder

Customer Service

Information

My Account

Contact Us