Table: Local Tax Repository Table

Table: UTLCTX
View: UT0016
Record Length: 1146

Flags: A R 

Keys: 1

Title Flags Fields
Tax ID TAXID

Fields: 126

Field Type Title Presentation
TAXID String*6 Tax Mask: %-6C
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
TAXTYPE Integer Type
LONGDESC String*60 Description
ROUNDTAXSW Boolean Round Tax
STDARDDED1 BCD*10.3 Standard Deduction
EXMPTNAMT1 BCD*10.3 Amount per Exemption
EXMPTCRSW Boolean Tax Credit Exemption switch
ANNMAXERN BCD*10.3 Annual Maximum Earnings
ANNUALMIN BCD*10.3 Annual Minimum Earnings
W2BOXTYP Integer W2-Box Type
W2WITHTAX String*6 Combine with Tax
ECALCMTHD Integer Employee Calculation Method
EAMTORPCT BCD*9.5 Employee Amount/Percent
ELIMITON Integer Employee Limit
EANNUALMAX BCD*10.3 Employee Annual Maximum
EDAILYMIN BCD*10.3 Employee Daily Minimum
EDAILYMAX BCD*10.3 Employee Daily Maximum
EWEEKLYMIN BCD*10.3 Employee Weekly Minimum
EWEEKLYMAX BCD*10.3 Employee Weekly Maximum
EBIWKLYMIN BCD*10.3 Employee Biweekly Minimum
EBIWKLYMAX BCD*10.3 Employee Biweekly Maximum
ESEMIMNMIN BCD*10.3 Employee Semimonthly Minimum
ESEMIMNMAX BCD*10.3 Employee Semimonthly Maximum
EMNTHLYMIN BCD*10.3 Employee Monthly Minimum
EMNTHLYMAX BCD*10.3 Employee Monthly Maximum
EQRTRLYMIN BCD*10.3 Employee Quarterly Minimum
EQRTRLYMAX BCD*10.3 Employee Quarterly Maximum
E10PPPYMIN BCD*10.3 Employee 10 Pay Periods/Year Min
E10PPPYMAX BCD*10.3 Employee 10 Pay Periods/Year Max
E13PPPYMIN BCD*10.3 Employee 13 Pay Periods/Year Min
E13PPPYMAX BCD*10.3 Employee 13 Pay Periods/Year Max
E22PPPYMIN BCD*10.3 Employee 22 Pay Periods/Year Min
E22PPPYMAX BCD*10.3 Employee 22 Pay Periods/Year Max
RCALCMTHD Integer Employer Calculation Method
RAMTORPCT BCD*9.5 Employer Amount/Percent
RLIMITON Integer Employer Limit
RANNUALMAX BCD*10.3 Employer Annual Maximum
RDAILYMIN BCD*10.3 Employer Daily Minimum
RDAILYMAX BCD*10.3 Employer Daily Maximum
RWEEKLYMIN BCD*10.3 Employer Weekly Minimum
RWEEKLYMAX BCD*10.3 Employer Weekly Maximum
RBIWKLYMIN BCD*10.3 Employer Biweekly Minimum
RBIWKLYMAX BCD*10.3 Employer Biweekly Maximum
RSEMIMNMIN BCD*10.3 Employer Semimonthly Minimum
RSEMIMNMAX BCD*10.3 Employer Semimonthly Maximum
RMNTHLYMIN BCD*10.3 Employer Monthly Minimum
RMNTHLYMAX BCD*10.3 Employer Monthly Maximum
RQRTRLYMIN BCD*10.3 Employer Quarterly Minimum
RQRTRLYMAX BCD*10.3 Employer Quarterly Maximum
R10PPPYMIN BCD*10.3 Employer 10 Pay Periods/Year Min
R10PPPYMAX BCD*10.3 Employer 10 Pay Periods/Year Max
R13PPPYMIN BCD*10.3 Employer 13 Pay Periods/Year Min
R13PPPYMAX BCD*10.3 Employer 13 Pay Periods/Year Max
R22PPPYMIN BCD*10.3 Employer 22 Pay Periods/Year Min
R22PPPYMAX BCD*10.3 Employer 22 Pay Periods/Year Max
WGBRACK1 BCD*10.3 Wage Ceiling for Bracket 1
WGADDAMT1 BCD*10.3 Tax Add Amount for Bracket 1
WGPCTOVR1 BCD*5.5 Tax Percentage for Bracket 1
WGBRACK2 BCD*10.3 Wage Ceiling for Bracket 2
WGADDAMT2 BCD*10.3 Tax Add Amount for Bracket 2
WGPCTOVR2 BCD*5.5 Tax Percentage for Bracket 2
WGBRACK3 BCD*10.3 Wage Ceiling for Bracket 3
WGADDAMT3 BCD*10.3 Tax Add Amount for Bracket 3
WGPCTOVR3 BCD*5.5 Tax Percentage for Bracket 3
WGBRACK4 BCD*10.3 Wage Ceiling for Bracket 4
WGADDAMT4 BCD*10.3 Tax Add Amount for Bracket 4
WGPCTOVR4 BCD*5.5 Tax Percentage for Bracket 4
WGBRACK5 BCD*10.3 Wage Ceiling for Bracket 5
WGADDAMT5 BCD*10.3 Tax Add Amount for Bracket 5
WGPCTOVR5 BCD*5.5 Tax Percentage for Bracket 5
WGBRACK6 BCD*10.3 Wage Ceiling for Bracket 6
WGADDAMT6 BCD*10.3 Tax Add Amount for Bracket 6
WGPCTOVR6 BCD*5.5 Tax Percentage for Bracket 6
WGBRACK7 BCD*10.3 Wage Ceiling for Bracket 7
WGADDAMT7 BCD*10.3 Tax Add Amount for Bracket 7
WGPCTOVR7 BCD*5.5 Tax Percentage for Bracket 7
WGBRACK8 BCD*10.3 Wage Ceiling for Bracket 8
WGADDAMT8 BCD*10.3 Tax Add Amount for Bracket 8
WGPCTOVR8 BCD*5.5 Tax Percentage for Bracket 8
WGBRACK9 BCD*10.3 Wage Ceiling for Bracket 9
WGADDAMT9 BCD*10.3 Tax Add Amount for Bracket 9
WGPCTOVR9 BCD*5.5 Tax Percentage for Bracket 9
WGBRACK10 BCD*10.3 Wage Ceiling for Bracket 10
WGADDAMT10 BCD*10.3 Tax Add Amount for Bracket 10
WGPCTOVR10 BCD*5.5 Tax Percentage for Bracket 10
WGBRACK11 BCD*10.3 Wage Ceiling for Bracket 11
WGADDAMT11 BCD*10.3 Tax Add Amount for Bracket 11
WGPCTOVR11 BCD*5.5 Tax Percentage for Bracket 11
WGBRACK12 BCD*10.3 Wage Ceiling for Bracket 12
WGADDAMT12 BCD*10.3 Tax Add Amount for Bracket 12
WGPCTOVR12 BCD*5.5 Tax Percentage for Bracket 12
WGBRACK13 BCD*10.3 Wage Ceiling for Bracket 13
WGADDAMT13 BCD*10.3 Tax Add Amount for Bracket 13
WGPCTOVR13 BCD*5.5 Tax Percentage for Bracket 13
WGBRACK14 BCD*10.3 Wage Ceiling for Bracket 14
WGADDAMT14 BCD*10.3 Tax Add Amount for Bracket 14
WGPCTOVR14 BCD*5.5 Tax Percentage for Bracket 14
WGBRACK15 BCD*10.3 Wage Ceiling for Bracket 15
WGADDAMT15 BCD*10.3 Tax Add Amount for Bracket 15
WGPCTOVR15 BCD*5.5 Tax Percentage for Bracket 15
WGBRACK16 BCD*10.3 Wage Ceiling for Bracket 16
WGADDAMT16 BCD*10.3 Tax Add Amount for Bracket 16
WGPCTOVR16 BCD*5.5 Tax Percentage for Bracket 16
WGBRACK17 BCD*10.3 Wage Ceiling for Bracket 17
WGADDAMT17 BCD*10.3 Tax Add Amount for Bracket 17
WGPCTOVR17 BCD*5.5 Tax Percentage for Bracket 17
WGBRACK18 BCD*10.3 Wage Ceiling for Bracket 18
WGADDAMT18 BCD*10.3 Tax Add Amount for Bracket 18
WGPCTOVR18 BCD*5.5 Tax Percentage for Bracket 18
WGBRACK19 BCD*10.3 Wage Ceiling for Bracket 19
WGADDAMT19 BCD*10.3 Tax Add Amount for Bracket 19
WGPCTOVR19 BCD*5.5 Tax Percentage for Bracket 19
WGBRACK20 BCD*10.3 Wage Ceiling for Bracket 20
WGADDAMT20 BCD*10.3 Tax Add Amount for Bracket 20
WGPCTOVR20 BCD*5.5 Tax Percentage for Bracket 20
CLADID String*30 CLAD ID
FLSCODE String*4 FLS Code
LOCSTATE String*30 State Mask: %-2C
LOCTAXCODE String*10 Political Subdivision Code Mask: %-10n
LOCTYPE Integer Location Type. 0 - Unknown, 1 - Resident, 2 - Non-Resident
TAXCAT String*10 Local Tax Category (PSD, LST, etc.)
TCACODE String*10 Tax Collection Agency Code

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).