View: Company Payroll Taxes

RotoID: UP0029
Table: UPTXMS
Protocol: Header
DLL:UPTXMS

Compositions: 5

RotoID Tables Title DLL
UP0015 UPINCL Include List UPINCL
UP0015 UPINCL Include List UPINCL
UP0015 UPINCL Include List UPINCL
UP0009 UPDIST Distribution UPDIST
UP0124 UPTXMO Taxes Optional Field Values UPTXMO

Keys: 2

Title Fields
Tax TAXID
Tax by Category, Type CATEGORY, TAXTYPE, TAXID

Fields: 160

Field Index Type Title Attributes Presentation
TAXID 1 String*6 Tax E A K R  Mask: %-6N
CATEGORY 2 Integer Category E A 
TAXTYPE 3 Integer Type E A  List:6 entries
19 = Income Tax
20 = Unemployment Tax
18 = Insurance Tax
21 = Pension Plan Tax
22 = Health Tax
23 = Other Tax
LONGDESC 4 String*60 Description E A 
SHORTDESC 5 String*15 Short Description E A 
REPORTID 6 String*20 Reporting ID E A  Mask: %-15C
ACTIVESW 7 Boolean Tax Inactive E A 
INACTASOF 8 Date Inactive Date A C 
LASTMAINT 9 Date Last Maintained E A C 
BASEMULT 10 BCD*5.5 Base Multiplier E A 
SURTAXMULT 11 BCD*5.5 Surtax Multiplier E A 
ROUNDTAXSW 12 Boolean Round Tax E A X 
DAILYPPY 13 Integer Daily Pay Periods per Year E A X 
TAXCREDITS 14 Boolean RESERVED - Tax Credits
TAXCRPCNT 15 BCD*5.5 RESERVED - Tax Credit Percent
STDARDDED1 16 BCD*10.3 Standard Deduction E A X 
STDARDDED2 17 BCD*10.3 RESERVED - Standard Deduction
STDARDDED3 18 BCD*10.3 RESERVED - Standard Deduction
STDARDDED4 19 BCD*10.3 RESERVED - Standard Deduction
EXMPTNAMT1 20 BCD*10.3 Amount per Exemption E A X 
EXMPTNAMT2 21 BCD*10.3 RESERVED - Amount per Exemption
EXMPTNAMT3 22 BCD*10.3 RESERVED - Amount per Exemption
EXMPTNAMT4 23 BCD*10.3 RESERVED - Amount per Exemption
EXMPTCRSW 24 Boolean Tax Credit Exemption switch E A X 
ANNMAXHRS 25 BCD*4.3 Annual Maximum Hours X 
ANNMAXERN 26 BCD*10.3 Annual Maximum Earnings E A X 
ANNUALMIN 27 BCD*10.3 Annual Minimum Earnings E A X 
W2BOXTYP 28 Integer W-2 Box Type E A X  List:5 entries
1 = Not Applicable
2 = Other Information Box
3 = Combine with Another Tax
4 = Local Tax Box
5 = Suppress W2 Reporting
W2WITHTAX 29 String*6 Combine with Tax X 
ASSOCW2SW 30 Boolean Associate with W-2 printing X 
ASSOCTAX 31 String*6 Associated Tax X 
ECALCMTHD 32 Integer Employee Calculation Method E A X  List:6 entries
1 = None
2 = Flat
5 = Amount per Hour
7 = Percentage of Base
13 = Tax Bracket Table
14 = Percentage of Another Tax
ESUPPRATE 33 BCD*5.5 Employee Supplemental Rate E A X 
EBASETAX 34 String*6 Employee Base Tax X 
EAMTORPCT 35 BCD*9.5 Employee Amount/Percent E A X 
ELIMITON 36 Integer Employee Limit E A P X  List:3 entries
1 = No Limit
4 = Withholding
5 = Base
EANNUALMAX 37 BCD*10.3 Employee Annual Maximum E A X 
ECLCMINWRK 38 Boolean Employee Minimum Weeks Worked X 
EDAILYMIN 39 BCD*10.3 Employee Daily Minimum X 
EDAILYMAX 40 BCD*10.3 Employee Daily Maximum X 
EWEEKLYMIN 41 BCD*10.3 Employee Weekly Minimum X 
EWEEKLYMAX 42 BCD*10.3 Employee Weekly Maximum X 
EBIWKLYMIN 43 BCD*10.3 Employee Biweekly Minimum X 
EBIWKLYMAX 44 BCD*10.3 Employee Biweekly Maximum X 
ESEMIMNMIN 45 BCD*10.3 Employee Semimonthly Minimum X 
ESEMIMNMAX 46 BCD*10.3 Employee Semimonthly Maximum X 
EMNTHLYMIN 47 BCD*10.3 Employee Monthly Minimum X 
EMNTHLYMAX 48 BCD*10.3 Employee Monthly Maximum X 
EQRTRLYMIN 49 BCD*10.3 Employee Quarterly Minimum X 
EQRTRLYMAX 50 BCD*10.3 Employee Quarterly Maximum X 
E10PPPYMIN 51 BCD*10.3 Employee 10 Pay Periods/Year Min X 
E10PPPYMAX 52 BCD*10.3 Employee 10 Pay Periods/Year Max X 
E13PPPYMIN 53 BCD*10.3 Employee 13 Pay Periods/Year Min X 
E13PPPYMAX 54 BCD*10.3 Employee 13 Pay Periods/Year Max X 
E22PPPYMIN 55 BCD*10.3 Employee 22 Pay Periods/Year Min X 
E22PPPYMAX 56 BCD*10.3 Employee 22 Pay Periods/Year Max X 
RCALCMTHD 57 Integer Employer Calculation Method E A X  List:6 entries
1 = None
2 = Flat
5 = Amount per Hour
7 = Percentage of Base
13 = Tax Bracket Table
15 = Percentage of Employee Withholding
RBASETAX 58 String*6 Employer Base Tax X 
RAMTORPCT 59 BCD*9.5 Employer Amount/Percent E A X 
RLIMITON 60 Integer Employer Limit E A P X  List:3 entries
1 = No Limit
4 = Withholding
5 = Base
RANNUALMAX 61 BCD*10.3 Employer Annual Maximum E A X 
RCLCMINWRK 62 Boolean Employer Minimum Weeks Worked X 
RDAILYMIN 63 BCD*10.3 Employer Daily Minimum X 
RDAILYMAX 64 BCD*10.3 Employer Daily Maximum X 
RWEEKLYMIN 65 BCD*10.3 Employer Weekly Minimum X 
RWEEKLYMAX 66 BCD*10.3 Employer Weekly Maximum X 
RBIWKLYMIN 67 BCD*10.3 Employer Biweekly Minimum X 
RBIWKLYMAX 68 BCD*10.3 Employer Biweekly Maximum X 
RSEMIMNMIN 69 BCD*10.3 Employer Semimonthly Minimum X 
RSEMIMNMAX 70 BCD*10.3 Employer Semimonthly Maximum X 
RMNTHLYMIN 71 BCD*10.3 Employer Monthly Minimum X 
RMNTHLYMAX 72 BCD*10.3 Employer Monthly Maximum X 
RQRTRLYMIN 73 BCD*10.3 Employer Quarterly Minimum X 
RQRTRLYMAX 74 BCD*10.3 Employer Quarterly Maximum X 
R10PPPYMIN 75 BCD*10.3 Employer 10 Pay Periods/Year Min X 
R10PPPYMAX 76 BCD*10.3 Employer 10 Pay Periods/Year Max X 
R13PPPYMIN 77 BCD*10.3 Employer 13 Pay Periods/Year Min X 
R13PPPYMAX 78 BCD*10.3 Employer 13 Pay Periods/Year Max X 
R22PPPYMIN 79 BCD*10.3 Employer 22 Pay Periods/Year Min X 
R22PPPYMAX 80 BCD*10.3 Employer 22 Pay Periods/Year Max X 
WGBRACK1 81 BCD*10.3 Wage Ceiling for Bracket 1 X 
WGADDAMT1 82 BCD*10.3 Tax Add Amount for Bracket 1 X 
WGPCTOVR1 83 BCD*5.5 Tax Percentage for Bracket 1 X 
WGBRACK2 84 BCD*10.3 Wage Ceiling for Bracket 2 X 
WGADDAMT2 85 BCD*10.3 Tax Add Amount for Bracket 2 X 
WGPCTOVR2 86 BCD*5.5 Tax Percentage for Bracket 2 X 
WGBRACK3 87 BCD*10.3 Wage Ceiling for Bracket 3 X 
WGADDAMT3 88 BCD*10.3 Tax Add Amount for Bracket 3 X 
WGPCTOVR3 89 BCD*5.5 Tax Percentage for Bracket 3 X 
WGBRACK4 90 BCD*10.3 Wage Ceiling for Bracket 4 X 
WGADDAMT4 91 BCD*10.3 Tax Add Amount for Bracket 4 X 
WGPCTOVR4 92 BCD*5.5 Tax Percentage for Bracket 4 X 
WGBRACK5 93 BCD*10.3 Wage Ceiling for Bracket 5 X 
WGADDAMT5 94 BCD*10.3 Tax Add Amount for Bracket 5 X 
WGPCTOVR5 95 BCD*5.5 Tax Percentage for Bracket 5 X 
WGBRACK6 96 BCD*10.3 Wage Ceiling for Bracket 6 X 
WGADDAMT6 97 BCD*10.3 Tax Add Amount for Bracket 6 X 
WGPCTOVR6 98 BCD*5.5 Tax Percentage for Bracket 6 X 
WGBRACK7 99 BCD*10.3 Wage Ceiling for Bracket 7 X 
WGADDAMT7 100 BCD*10.3 Tax Add Amount for Bracket 7 X 
WGPCTOVR7 101 BCD*5.5 Tax Percentage for Bracket 7 X 
WGBRACK8 102 BCD*10.3 Wage Ceiling for Bracket 8 X 
WGADDAMT8 103 BCD*10.3 Tax Add Amount for Bracket 8 X 
WGPCTOVR8 104 BCD*5.5 Tax Percentage for Bracket 8 X 
WGBRACK9 105 BCD*10.3 Wage Ceiling for Bracket 9 X 
WGADDAMT9 106 BCD*10.3 Tax Add Amount for Bracket 9 X 
WGPCTOVR9 107 BCD*5.5 Tax Percentage for Bracket 9 X 
WGBRACK10 108 BCD*10.3 Wage Ceiling for Bracket 10 X 
WGADDAMT10 109 BCD*10.3 Tax Add Amount for Bracket 10 X 
WGPCTOVR10 110 BCD*5.5 Tax Percentage for Bracket 10 X 
WGBRACK11 111 BCD*10.3 Wage Ceiling for Bracket 11 X 
WGADDAMT11 112 BCD*10.3 Tax Add Amount for Bracket 11 X 
WGPCTOVR11 113 BCD*5.5 Tax Percentage for Bracket 11 X 
WGBRACK12 114 BCD*10.3 Wage Ceiling for Bracket 12 X 
WGADDAMT12 115 BCD*10.3 Tax Add Amount for Bracket 12 X 
WGPCTOVR12 116 BCD*5.5 Tax Percentage for Bracket 12 X 
WGBRACK13 117 BCD*10.3 Wage Ceiling for Bracket 13 X 
WGADDAMT13 118 BCD*10.3 Tax Add Amount for Bracket 13 X 
WGPCTOVR13 119 BCD*5.5 Tax Percentage for Bracket 13 X 
WGBRACK14 120 BCD*10.3 Wage Ceiling for Bracket 14 X 
WGADDAMT14 121 BCD*10.3 Tax Add Amount for Bracket 14 X 
WGPCTOVR14 122 BCD*5.5 Tax Percentage for Bracket 14 X 
WGBRACK15 123 BCD*10.3 Wage Ceiling for Bracket 15 X 
WGADDAMT15 124 BCD*10.3 Tax Add Amount for Bracket 15 X 
WGPCTOVR15 125 BCD*5.5 Tax Percentage for Bracket 15 X 
WGBRACK16 126 BCD*10.3 Wage Ceiling for Bracket 16 X 
WGADDAMT16 127 BCD*10.3 Tax Add Amount for Bracket 16 X 
WGPCTOVR16 128 BCD*5.5 Tax Percentage for Bracket 16 X 
WGBRACK17 129 BCD*10.3 Wage Ceiling for Bracket 17 X 
WGADDAMT17 130 BCD*10.3 Tax Add Amount for Bracket 17 X 
WGPCTOVR17 131 BCD*5.5 Tax Percentage for Bracket 17 X 
WGBRACK18 132 BCD*10.3 Wage Ceiling for Bracket 18 X 
WGADDAMT18 133 BCD*10.3 Tax Add Amount for Bracket 18 X 
WGPCTOVR18 134 BCD*5.5 Tax Percentage for Bracket 18 X 
WGBRACK19 135 BCD*10.3 Wage Ceiling for Bracket 19 X 
WGADDAMT19 136 BCD*10.3 Tax Add Amount for Bracket 19 X 
WGPCTOVR19 137 BCD*5.5 Tax Percentage for Bracket 19 X 
WGBRACK20 138 BCD*10.3 Wage Ceiling for Bracket 20 X 
WGADDAMT20 139 BCD*10.3 Tax Add Amount for Bracket 20 X 
WGPCTOVR20 140 BCD*5.5 Tax Percentage for Bracket 20 X 
LEVEL 141 Integer Level E A X 
LISTUSEBHI 142 Integer List Usage for Base Hours Include X 
LISTUSEBEI 143 Integer List Usage for Base Earnings Include E A X 
WHMETHBEI 144 Integer Withholding Method for Base Earnings Include E A X  List:3 entries
1 = Regular Rate
4 = Taxable, No Withholding
6 = Supplemental Withholding
LISTUSEBDI 145 Integer List Usage for Base Deductions Include E A X 
EFFECTDATE 146 Date INTERNAL USE - Tax Table Effective Date A C 
FIPSNBR 147 Integer INTERNAL USE - Tax Table FIPS Number A C 
FIPSCODE 148 String*2 INTERNAL USE - Tax Table FIPS Code A C 
CFGPARMVER 149 Integer INTERNAL USE - Tax Table Parameter Version A C 
CFGPARMCNT 150 Integer INTERNAL USE - Tax Table Parameter Count A C 
CALCATTRIB 151 Long INTERNAL USE - Tax Calculation Attributes A C 
TRAKATTRIB 152 Long INTERNAL USE - Tax YTD Tracking Attributes A C 
PROCESSCMD 153 Integer Process Command Code E A C  List:4 entries
0 = Validation
1 = Insert Optional Fields
2 = Clear Local Tax Audit Tables
3 = Clear Local Tax Employee Audit Tables
VALUES 170 Long Number of Optional Fields E A C 
AUTOUPDATE 171 Boolean Automatically Update Local Tax E A X 
LOCSTATE 172 String*30 State E A X  Mask: %-2C
LOCTAXCODE 173 String*10 Local Tax Code E A X  Mask: %-10n
ATXTYPE 174 Integer RESERVED - Aatrix Tax Type E A X 
EMPDEFAULT 175 Boolean Automatically Populate Employee E A X 
EMPDEFDIST 176 String*6 Default Distribution Code E A X  Mask: %-6N

This page was generated on 2022-Aug-18

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