View: Local Tax Repository Table

RotoID: UT0016
Table: UTLCTX
Protocol: Flat
DLL:UTLCTX

Keys: 1

Title Fields
Tax ID TAXID

Fields: 123

Field Index Type Title Attributes Presentation
TAXID 1 String*6 Tax E A K R  Mask: %-6C
TAXTYPE 2 Integer Type E A 
LONGDESC 3 String*60 Description E A 
ROUNDTAXSW 4 Boolean Round Tax E A X 
STDARDDED1 5 BCD*10.3 Standard Deduction E A X 
EXMPTNAMT1 6 BCD*10.3 Amount per Exemption E A X 
EXMPTCRSW 7 Boolean Tax Credit Exemption switch E A X 
ANNMAXERN 8 BCD*10.3 Annual Maximum Earnings E A X 
ANNUALMIN 9 BCD*10.3 Annual Minimum Earnings E A X 
W2BOXTYP 10 Integer W2-Box Type E A X 
W2WITHTAX 11 String*6 Combine with Tax E A X 
ECALCMTHD 12 Integer Employee Calculation Method E A X 
EAMTORPCT 13 BCD*9.5 Employee Amount/Percent E A X 
ELIMITON 14 Integer Employee Limit E A X 
EANNUALMAX 15 BCD*10.3 Employee Annual Maximum E A X 
EDAILYMIN 16 BCD*10.3 Employee Daily Minimum E A X 
EDAILYMAX 17 BCD*10.3 Employee Daily Maximum E A X 
EWEEKLYMIN 18 BCD*10.3 Employee Weekly Minimum E A X 
EWEEKLYMAX 19 BCD*10.3 Employee Weekly Maximum E A X 
EBIWKLYMIN 20 BCD*10.3 Employee Biweekly Minimum E A X 
EBIWKLYMAX 21 BCD*10.3 Employee Biweekly Maximum E A X 
ESEMIMNMIN 22 BCD*10.3 Employee Semimonthly Minimum E A X 
ESEMIMNMAX 23 BCD*10.3 Employee Semimonthly Maximum E A X 
EMNTHLYMIN 24 BCD*10.3 Employee Monthly Minimum E A X 
EMNTHLYMAX 25 BCD*10.3 Employee Monthly Maximum E A X 
EQRTRLYMIN 26 BCD*10.3 Employee Quarterly Minimum E A X 
EQRTRLYMAX 27 BCD*10.3 Employee Quarterly Maximum E A X 
E10PPPYMIN 28 BCD*10.3 Employee 10 Pay Periods/Year Min E A X 
E10PPPYMAX 29 BCD*10.3 Employee 10 Pay Periods/Year Max E A X 
E13PPPYMIN 30 BCD*10.3 Employee 13 Pay Periods/Year Min E A X 
E13PPPYMAX 31 BCD*10.3 Employee 13 Pay Periods/Year Max E A X 
E22PPPYMIN 32 BCD*10.3 Employee 22 Pay Periods/Year Min E A X 
E22PPPYMAX 33 BCD*10.3 Employee 22 Pay Periods/Year Max E A X 
RCALCMTHD 34 Integer Employer Calculation Method E A X 
RAMTORPCT 35 BCD*9.5 Employer Amount/Percent E A X 
RLIMITON 36 Integer Employer Limit E A X 
RANNUALMAX 37 BCD*10.3 Employer Annual Maximum E A X 
RDAILYMIN 38 BCD*10.3 Employer Daily Minimum E A X 
RDAILYMAX 39 BCD*10.3 Employer Daily Maximum E A X 
RWEEKLYMIN 40 BCD*10.3 Employer Weekly Minimum E A X 
RWEEKLYMAX 41 BCD*10.3 Employer Weekly Maximum E A X 
RBIWKLYMIN 42 BCD*10.3 Employer Biweekly Minimum E A X 
RBIWKLYMAX 43 BCD*10.3 Employer Biweekly Maximum E A X 
RSEMIMNMIN 44 BCD*10.3 Employer Semimonthly Minimum E A X 
RSEMIMNMAX 45 BCD*10.3 Employer Semimonthly Maximum E A X 
RMNTHLYMIN 46 BCD*10.3 Employer Monthly Minimum E A X 
RMNTHLYMAX 47 BCD*10.3 Employer Monthly Maximum E A X 
RQRTRLYMIN 48 BCD*10.3 Employer Quarterly Minimum E A X 
RQRTRLYMAX 49 BCD*10.3 Employer Quarterly Maximum E A X 
R10PPPYMIN 50 BCD*10.3 Employer 10 Pay Periods/Year Min E A X 
R10PPPYMAX 51 BCD*10.3 Employer 10 Pay Periods/Year Max E A X 
R13PPPYMIN 52 BCD*10.3 Employer 13 Pay Periods/Year Min E A X 
R13PPPYMAX 53 BCD*10.3 Employer 13 Pay Periods/Year Max E A X 
R22PPPYMIN 54 BCD*10.3 Employer 22 Pay Periods/Year Min E A X 
R22PPPYMAX 55 BCD*10.3 Employer 22 Pay Periods/Year Max E A X 
WGBRACK1 56 BCD*10.3 Wage Ceiling for Bracket 1 E A X 
WGADDAMT1 57 BCD*10.3 Tax Add Amount for Bracket 1 E A X 
WGPCTOVR1 58 BCD*5.5 Tax Percentage for Bracket 1 E A X 
WGBRACK2 59 BCD*10.3 Wage Ceiling for Bracket 2 E A X 
WGADDAMT2 60 BCD*10.3 Tax Add Amount for Bracket 2 E A X 
WGPCTOVR2 61 BCD*5.5 Tax Percentage for Bracket 2 E A X 
WGBRACK3 62 BCD*10.3 Wage Ceiling for Bracket 3 E A X 
WGADDAMT3 63 BCD*10.3 Tax Add Amount for Bracket 3 E A X 
WGPCTOVR3 64 BCD*5.5 Tax Percentage for Bracket 3 E A X 
WGBRACK4 65 BCD*10.3 Wage Ceiling for Bracket 4 E A X 
WGADDAMT4 66 BCD*10.3 Tax Add Amount for Bracket 4 E A X 
WGPCTOVR4 67 BCD*5.5 Tax Percentage for Bracket 4 E A X 
WGBRACK5 68 BCD*10.3 Wage Ceiling for Bracket 5 E A X 
WGADDAMT5 69 BCD*10.3 Tax Add Amount for Bracket 5 E A X 
WGPCTOVR5 70 BCD*5.5 Tax Percentage for Bracket 5 E A X 
WGBRACK6 71 BCD*10.3 Wage Ceiling for Bracket 6 E A X 
WGADDAMT6 72 BCD*10.3 Tax Add Amount for Bracket 6 E A X 
WGPCTOVR6 73 BCD*5.5 Tax Percentage for Bracket 6 E A X 
WGBRACK7 74 BCD*10.3 Wage Ceiling for Bracket 7 E A X 
WGADDAMT7 75 BCD*10.3 Tax Add Amount for Bracket 7 E A X 
WGPCTOVR7 76 BCD*5.5 Tax Percentage for Bracket 7 E A X 
WGBRACK8 77 BCD*10.3 Wage Ceiling for Bracket 8 E A X 
WGADDAMT8 78 BCD*10.3 Tax Add Amount for Bracket 8 E A X 
WGPCTOVR8 79 BCD*5.5 Tax Percentage for Bracket 8 E A X 
WGBRACK9 80 BCD*10.3 Wage Ceiling for Bracket 9 E A X 
WGADDAMT9 81 BCD*10.3 Tax Add Amount for Bracket 9 E A X 
WGPCTOVR9 82 BCD*5.5 Tax Percentage for Bracket 9 E A X 
WGBRACK10 83 BCD*10.3 Wage Ceiling for Bracket 10 E A X 
WGADDAMT10 84 BCD*10.3 Tax Add Amount for Bracket 10 E A X 
WGPCTOVR10 85 BCD*5.5 Tax Percentage for Bracket 10 E A X 
WGBRACK11 86 BCD*10.3 Wage Ceiling for Bracket 11 E A X 
WGADDAMT11 87 BCD*10.3 Tax Add Amount for Bracket 11 E A X 
WGPCTOVR11 88 BCD*5.5 Tax Percentage for Bracket 11 E A X 
WGBRACK12 89 BCD*10.3 Wage Ceiling for Bracket 12 E A X 
WGADDAMT12 90 BCD*10.3 Tax Add Amount for Bracket 12 E A X 
WGPCTOVR12 91 BCD*5.5 Tax Percentage for Bracket 12 E A X 
WGBRACK13 92 BCD*10.3 Wage Ceiling for Bracket 13 E A X 
WGADDAMT13 93 BCD*10.3 Tax Add Amount for Bracket 13 E A X 
WGPCTOVR13 94 BCD*5.5 Tax Percentage for Bracket 13 E A X 
WGBRACK14 95 BCD*10.3 Wage Ceiling for Bracket 14 E A X 
WGADDAMT14 96 BCD*10.3 Tax Add Amount for Bracket 14 E A X 
WGPCTOVR14 97 BCD*5.5 Tax Percentage for Bracket 14 E A X 
WGBRACK15 98 BCD*10.3 Wage Ceiling for Bracket 15 E A X 
WGADDAMT15 99 BCD*10.3 Tax Add Amount for Bracket 15 E A X 
WGPCTOVR15 100 BCD*5.5 Tax Percentage for Bracket 15 E A X 
WGBRACK16 101 BCD*10.3 Wage Ceiling for Bracket 16 E A X 
WGADDAMT16 102 BCD*10.3 Tax Add Amount for Bracket 16 E A X 
WGPCTOVR16 103 BCD*5.5 Tax Percentage for Bracket 16 E A X 
WGBRACK17 104 BCD*10.3 Wage Ceiling for Bracket 17 E A X 
WGADDAMT17 105 BCD*10.3 Tax Add Amount for Bracket 17 E A X 
WGPCTOVR17 106 BCD*5.5 Tax Percentage for Bracket 17 E A X 
WGBRACK18 107 BCD*10.3 Wage Ceiling for Bracket 18 E A X 
WGADDAMT18 108 BCD*10.3 Tax Add Amount for Bracket 18 E A X 
WGPCTOVR18 109 BCD*5.5 Tax Percentage for Bracket 18 E A X 
WGBRACK19 110 BCD*10.3 Wage Ceiling for Bracket 19 E A X 
WGADDAMT19 111 BCD*10.3 Tax Add Amount for Bracket 19 E A X 
WGPCTOVR19 112 BCD*5.5 Tax Percentage for Bracket 19 E A X 
WGBRACK20 113 BCD*10.3 Wage Ceiling for Bracket 20 E A X 
WGADDAMT20 114 BCD*10.3 Tax Add Amount for Bracket 20 E A X 
WGPCTOVR20 115 BCD*5.5 Tax Percentage for Bracket 20 E A X 
CLADID 116 String*30 CLAD ID E A 
FLSCODE 117 String*4 FLS Code E A 
LOCSTATE 118 String*30 State E A X  Mask: %-2C
LOCTAXCODE 119 String*10 Political Subdivision Code E A X  Mask: %-10n
LOCTYPE 120 Integer Location Type. 0 - Unknown, 1 - Resident, 2 - Non-Resident E A 
TAXCAT 121 String*10 Local Tax Category (PSD, LST, etc.) E A X 
TCACODE 122 String*10 Tax Collection Agency Code E A X 
PROCESSCMD 128 Integer Process Command Code E A C  List:5 entries
1 = Install local tax repository
2 = Update all company taxes from local tax repository
3 = Update all employee taxes from local tax repository
4 = Update all employee tax for one local tax from local tax repository
9 = Clear Cache

This page was generated on 2021-Nov-24

© 2021 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).