Table: Company Payroll Taxes

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

Keys: 2

Title  Flags  Fields

Tax  TAXID
Tax by Category, Type  M  CATEGORY, TAXTYPE, TAXID

Fields: 156

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   
AUTOUPDATE  Boolean  Automatically Update Local Tax   

This page was generated on 2009-Nov-19

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