# Table: Company Payroll Taxes

Table: UPTXMS
View: UP0029
Record length: 1238
Flags: A R

## Keys: 2

Title | Flags | Fields
--- | --- | ---
Tax |  | TAXID
Tax by Category, Type | M | CATEGORY, TAXTYPE, TAXID

## Fields: 155

Field | Type | Title | Presentation
--- | --- | --- | ---
TAXID | String*6 | Tax | Mask: %-6N
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
CATEGORY | Integer | Category |
TAXTYPE | Integer | Type | List: 6 entries
19 | = | Income Tax
20 | = | Unemployment Tax
18 | = | Insurance Tax
21 | = | Pension Plan Tax
22 | = | Health Tax
23 | = | Other Tax
LONGDESC | String*60 | Description |
SHORTDESC | String*15 | Short Description |
REPORTID | String*20 | Reporting ID | Mask: %-15C
ACTIVESW | Boolean | Tax Inactive |
INACTASOF | Date | Inactive Date |
LASTMAINT | Date | Last Maintained |
BASEMULT | BCD*5.5 | Base Multiplier |
SURTAXMULT | BCD*5.5 | Surtax Multiplier |
ROUNDTAXSW | Boolean | Round Tax |
DAILYPPY | Integer | Daily Pay Periods per Year |
TAXCREDITS | Boolean | RESERVED - Tax Credits |
TAXCRPCNT | BCD*5.5 | RESERVED - Tax Credit Percent |
STDARDDED1 | BCD*10.3 | Standard Deduction |
STDARDDED2 | BCD*10.3 | RESERVED - Standard Deduction |
STDARDDED3 | BCD*10.3 | RESERVED - Standard Deduction |
STDARDDED4 | BCD*10.3 | RESERVED - Standard Deduction |
EXMPTNAMT1 | BCD*10.3 | Amount per Exemption |
EXMPTNAMT2 | BCD*10.3 | RESERVED - Amount per Exemption |
EXMPTNAMT3 | BCD*10.3 | RESERVED - Amount per Exemption |
EXMPTNAMT4 | BCD*10.3 | RESERVED - Amount per Exemption |
EXMPTCRSW | Boolean | Tax Credit Exemption switch |
ANNMAXHRS | BCD*4.3 | Annual Maximum Hours |
ANNMAXERN | BCD*10.3 | Annual Maximum Earnings |
ANNUALMIN | BCD*10.3 | Annual Minimum Earnings |
W2BOXTYP | Integer | W-2 Box Type | List: 4 entries
1 | = | Not Applicable
2 | = | Other Information Box
3 | = | Combine with Another Tax
4 | = | Local Tax Box
W2WITHTAX | String*6 | Combine with Tax |
ASSOCW2SW | Boolean | Associate with W-2 printing |
ASSOCTAX | String*6 | Associated Tax |
ECALCMTHD | Integer | Employee Calculation Method | 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 | BCD*5.5 | Employee Supplemental Rate |
EBASETAX | String*6 | Employee Base Tax |
EAMTORPCT | BCD*9.5 | Employee Amount/Percent |
ELIMITON | Integer | Employee Limit | List: 3 entries
1 | = | No Limit
4 | = | Withholding
5 | = | Base
EANNUALMAX | BCD*10.3 | Employee Annual Maximum |
ECLCMINWRK | Boolean | Employee Minimum Weeks Worked |
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 | 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 | String*6 | Employer Base Tax |
RAMTORPCT | BCD*9.5 | Employer Amount/Percent |
RLIMITON | Integer | Employer Limit | List: 3 entries
1 | = | No Limit
4 | = | Withholding
5 | = | Base
RANNUALMAX | BCD*10.3 | Employer Annual Maximum |
RCLCMINWRK | Boolean | Employer Minimum Weeks Worked |
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 |
LEVEL | Integer | Level |
LISTUSEBHI | Integer | List Usage for Base Hours Include |
LISTUSEBEI | Integer | List Usage for Base Earnings Include |
WHMETHBEI | Integer | Withholding Method for Base Earnings Include | List: 3 entries
1 | = | Regular Rate
4 | = | Taxable, No Withholding
6 | = | Supplemental Withholding
LISTUSEBDI | Integer | List Usage for Base Deductions Include |
EFFECTDATE | Date | INTERNAL USE - Tax Table Effective Date |
FIPSNBR | Integer | INTERNAL USE - Tax Table FIPS Number |
FIPSCODE | String*2 | INTERNAL USE - Tax Table FIPS Code |
CFGPARMVER | Integer | INTERNAL USE - Tax Table Parameter Version |
CFGPARMCNT | Integer | INTERNAL USE - Tax Table Parameter Count |
VALUES | Long | Number of Optional Fields |

This page was generated on 2008-May-02

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.