UPR00400 - Payroll Pay Code Master | Prospr - Dynamics GP Table Reference

UPR00400 - Payroll Pay Code Master

Query Builder

Select * from UPR00400

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
EMPLOYID	Employee ID	String	16	View
PAYRCORD	Pay Record	String	8	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
RPTASWGS	Report As Wages	Boolean	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
SUTASTAT	Suta State	String	4	View
FFEDTXRT	Flat Federal Tax Rate	Integer	2	View
FLSTTXRT	Flat State Tax Rate	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
ACRUVACN	Accrue Vacation	Boolean	2	View
ACRUSTIM	Accrue Sick Time	Boolean	2	View
WRKRCOMP	Workers Comp	String	8	View
W2BXNMBR	W2 Box Number	Integer	2	View
W2BXLABL	W2 Box Label	String	8	View
PYADVTKN	Pay Advance Taken	Currency	10	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
PYSTPTBLID	Pay Step Table ID	String	16	View
Base_Step_Increased_On	Base Step Increases On	Integer	2	View
Step	Step	Integer	2	View
Step_Effective_Date	Step Effective Date	Date	4	View
Step_FTE	Step FTE	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
Workflow_Approval_Status	Workflow Approval Status 1 – Not Submitted 2 – Submitted 3 – No Approval Needed 4 – Pending Approval 5 – Pending Changes 6 – Approved 7 – Rejected 8 – Workflow Ended 9 – Workflow Not Activated 10 – Workflow Deactivated	Integer	2	View
Workflow_Priority	Workflow Priority	Integer	2	View

UPR00400 - Payroll Pay Code Master

Query Builder

Customer Service

Information

My Account

Contact Us