UPR00600 - Payroll Benefit Master | Prospr - Dynamics GP Table Reference

UPR00600 - Payroll Benefit Master

Query Builder

Select * from UPR00600

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPLOYID	Employee ID	String	16	View
BENEFIT	Benefit	String	8	View
INACTIVE	Inactive	Boolean	2	View
BNFBEGDT	Benefit Beg Date	Date	4	View
BNFENDDT	Benefit End Date	Date	4	View
VARBENFT	Variable Benefit	Boolean	2	View
BNFTFREQ	Benefit Frequency	Integer	2	View
TAXABLE	Taxable	Boolean	2	View
SBJTFDTX	Subject To Federal Tax	Boolean	2	View
SBJTSSEC	Subject To Social Security	Boolean	2	View
SBJTMCAR	Subject To Medicare	Boolean	2	View
SBJTSTTX	Subject To State Tax	Boolean	2	View
SBJTLTAX	Subject To Local Tax	Boolean	2	View
SBJTFUTA	Subject To Futa	Boolean	2	View
SBJTSUTA	Subject To Suta	Boolean	2	View
FFEDTXRT	Flat Federal Tax Rate	Integer	2	View
FLSTTXRT	Flat State Tax Rate	Integer	2	View
BORCDTYP	Based On Record Type	Integer	2	View
BSDORCDS	Based On Records	Integer	2	View
BNFTMTHD	Benefit Method	Integer	2	View
BNFFRMLA	Benefit Formula	Integer	2	View
BNFPRCNT_1	Benefit Percent[1]	Currency	10	View
BNFPRCNT_2	Benefit Percent[2]	Currency	10	View
BNFPRCNT_3	Benefit Percent[3]	Currency	10	View
BNFPRCNT_4	Benefit Percent[4]	Currency	10	View
BNFPRCNT_5	Benefit Percent[5]	Currency	10	View
BNFITAMT_1	Benefit Amount[1]	Currency	10	View
BNFITAMT_2	Benefit Amount[2]	Currency	10	View
BNFITAMT_3	Benefit Amount[3]	Currency	10	View
BNFITAMT_4	Benefit Amount[4]	Currency	10	View
BNFITAMT_5	Benefit Amount[5]	Currency	10	View
BNFTRMAX_1	Benefit Tier Max[1]	Currency	10	View
BNFTRMAX_2	Benefit Tier Max[2]	Currency	10	View
BNFTRMAX_3	Benefit Tier Max[3]	Currency	10	View
BNFTRMAX_4	Benefit Tier Max[4]	Currency	10	View
BNFTRMAX_5	Benefit Tier Max[5]	Currency	10	View
BNTRMXUN_1	Benefit Tier Max Units[1]	Long Integer	4	View
BNTRMXUN_2	Benefit Tier Max Units[2]	Long Integer	4	View
BNTRMXUN_3	Benefit Tier Max Units[3]	Long Integer	4	View
BNTRMXUN_4	Benefit Tier Max Units[4]	Long Integer	4	View
BNTRMXUN_5	Benefit Tier Max Units[5]	Long Integer	4	View
BNPAYPMX	Benefit Pay Period Max	Currency	10	View
BNFYRMAX	Benefit Year Max	Currency	10	View
BNFLFMAX	Benefit 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
LTDBNFIT	LTD Benefit	Currency	10	View
DATAENTDFLT	Data Entry Default	Boolean	2	View
EMPLRMAXMAT	Employer Maximum Match	Currency	10	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
Benefit_Fiscal_Max	Benefit Fiscal Max	Currency	10	View

UPR00600 - Payroll Benefit Master

Query Builder

Customer Service

Information

My Account

Contact Us