UPR40600 - Payroll Pay Code Setup | Prospr - Dynamics GP Table Reference

UPR40600 - Payroll Pay Code Setup

Query Builder

Select * from UPR40600

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PAYRCORD	Pay Record	String	8	View
DSCRIPTN	Description	String	32	View
INACTIVE	Inactive	Boolean	2	View
PAYTYPE	Pay Type 1. Hourly 2. Salary 3. Piecework 4. Commission 5. Business Expense 6. Overtime 7. Double Time 8. Vacation 9. Sick 10. Holiday 11. Pension 12. Other 13. Earned Income Credit 14. Charged Tips 15. Reported Tips 16. Minimum Wage Balance	Integer	2	View
BSPAYRCD	Base Pay Record	String	8	View
PAYRTAMT	Pay Rate Amount	Currency	10	View
PAYUNIT	Pay Unit	String	26	View
PAYUNPER	Pay Unit Period	Integer	2	View
PAYPEROD	Pay Period	Integer	2	View
PAYPRPRD	Pay Per Period	Currency	10	View
MXPYPPER	Max Pay Per Period	Currency	10	View
TipType	Tip Type	Integer	2	View
PAYADVNC	Pay Advance	Currency	10	View
RPTASWGS	Report As Wages	Boolean	2	View
W2BXNMBR	W2 Box Number	Integer	2	View
W2BXLABL	W2 Box Label	String	8	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
ACRUVACN	Accrue Vacation	Boolean	2	View
ACRUSTIM	Accrue Sick Time	Boolean	2	View
NOTEINDX	Note Index	Currency	10	View
DATAENTDFLT	Data Entry Default	Boolean	2	View
SHFTCODE	Shift Code	String	8	View
PAYFACTR	Pay Factor	Currency	10	View
BSDONRTE	Based On Rate	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

UPR40600 - Payroll Pay Code Setup

Query Builder

Customer Service

Information

My Account

Contact Us