UPR19900 - Payroll Flat Tax Records | Prospr - Dynamics GP Table Reference

UPR19900 - Payroll Flat Tax Records

Select * from UPR19900

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
ISTIPPAY	Is Tips Pay	Boolean	2	View
ACTINDX	Account Index	Long Integer	4	View
ACCTAMNT	Account Amount	Currency	10	View
ACCTTYPE	Account Type Field values: 1 = Posting Account 2 = Unit Account 3 = Posting Allocation Account 4 = Unit Allocation Account	Integer	2	View
STATECD	State Code	String	4	View
PAYRCORD	Pay Record	String	8	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
GROSWAGS_1	Gross Wages[1]	Currency	10	View
GROSWAGS_2	Gross Wages[2]	Currency	10	View
GROSWAGS_3	Gross Wages[3]	Currency	10	View
GROSWAGS_4	Gross Wages[4]	Currency	10	View
GROSWAGS_5	Gross Wages[5]	Currency	10	View
GROSWAGS_6	Gross Wages[6]	Currency	10	View
GROSWAGS_7	Gross Wages[7]	Currency	10	View
GROSWAGS_8	Gross Wages[8]	Currency	10	View
GROSWAGS_9	Gross Wages[9]	Currency	10	View
GROSWAGS_10	Gross Wages[10]	Currency	10	View
GROSWAGS_11	Gross Wages[11]	Currency	10	View
GROSWAGS_12	Gross Wages[12]	Currency	10	View
FFEDTXRT	Flat Federal Tax Rate	Integer	2	View
FLSTTXRT	Flat State Tax Rate	Integer	2	View