UPR41400 - Payroll Local Tax Setup

Dynamics GP table UPR41400 (Payroll Local Tax Setup) contains 21 columns including LOCALTAX, DSCRIPTN, LCLTXCAL_1....

SQL Query Builder

SELECT * FROM UPR41400

Select all

Column	Description	Type	Length	Shared With
LOCALTAX	Local Tax	String	8	4 tables
DSCRIPTN	Description	String	32	27 tables
LCLTXCAL_1	Local Tax Calculation[1]	Integer	2	-
LCLTXCAL_2	Local Tax Calculation[2]	Integer	2	-
LCLTXCAL_3	Local Tax Calculation[3]	Integer	2	-
LCLTXCAL_4	Local Tax Calculation[4]	Integer	2	-
LCLTXCAL_5	Local Tax Calculation[5]	Integer	2	-
EXMTAMNT	Exemption Amount	Currency	10	-
MNTXBLWG	Minimum Taxable Wages	Currency	10	-
MYTDTXWG	Minimum YTD Taxable Wages	Currency	10	-
LCLTAXRT	Local Tax Rate	Long Integer	4	-
LCLTXAMT	Local Tax Amount	Currency	10	-
MAXPERYR	Maximum Per Year	Currency	10	-
INACTIVE	Inactive	Boolean	2	23 tables
Active Status values (2) 0 = Active1 = Inactive
NOTEINDX	Note Index	Currency	10	114 tables
STDDMTHD	Standard Deduction Method	Integer	2	-
STDDPCNT	Standard Deduction Percent	Long Integer	4	-
STDDEDAM	Standard Deduction Amount	Currency	10	-
STDEDMAX	Standard Deduction Maximum	Currency	10	-
STDEDMIN	Standard Deduction Minimum	Currency	10	-
TAXTYPE	Tax Type	Integer	2	-

Tables that share columns with UPR41400. Click "Join" to add to your query.

NOTEINDX

LOCALTAX