Table: Company Payroll Taxes

Table: UPTXMS
View: UP0029
Record Length: 1290

Flags: A R 

Keys: 2

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

Fields: 161

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:5 entries
1 = Not Applicable
2 = Other Information Box
3 = Combine with Another Tax
4 = Local Tax Box
5 = Suppress W2 Reporting
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
AUTOUPDATE Boolean Automatically Update Local Tax
LOCSTATE String*30 State Mask: %-2C
LOCTAXCODE String*10 Local Tax Code Mask: %-10n
ATXTYPE Integer RESERVED - Aatrix Tax Type
EMPDEFAULT Boolean Automatically Populate Employee
EMPDEFDIST String*6 Default Distribution Code Mask: %-6N

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