View: Company Payroll Taxes

RotoID: UP0029
Table: UPTXMS
DLL: UPTXMS

Compositions: 2


RotoID  Table  Title  DLL 
UP0015  UPINCL  Include List  UPINCL
UP0009  UPDIST  Distribution  UPDIST

Keys: 2


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

Fields: 152


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*30  Description  E A   
SHORTDESC  5  String*15  Short Description  E A   
REPORTID  6  String*20  Reporting ID  E A  Mask: %-12C
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: 4 entries
1=Not Applicable
2=Other Information Box
3=Combine with Another Tax
4=Local Tax Box
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 Mi  X   
E10PPPYMAX  52  BCD*10.3  Employee 10 Pay Periods/Year Ma  X   
E13PPPYMIN  53  BCD*10.3  Employee 13 Pay Periods/Year Mi  X   
E13PPPYMAX  54  BCD*10.3  Employee 13 Pay Periods/Year Ma  X   
E22PPPYMIN  55  BCD*10.3  Employee 22 Pay Periods/Year Mi  X   
E22PPPYMAX  56  BCD*10.3  Employee 22 Pay Periods/Year Ma  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  X   
RLIMITON  60  Integer  Employer Limit  P X   
RANNUALMAX  61  BCD*10.3  Employer Annual Maximum  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 Mi  X   
R10PPPYMAX  76  BCD*10.3  Employer 10 Pay Periods/Year Ma  X   
R13PPPYMIN  77  BCD*10.3  Employer 13 Pay Periods/Year Mi  X   
R13PPPYMAX  78  BCD*10.3  Employer 13 Pay Periods/Year Ma  X   
R22PPPYMIN  79  BCD*10.3  Employer 22 Pay Periods/Year Mi  X   
R22PPPYMAX  80  BCD*10.3  Employer 22 Pay Periods/Year Ma  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 Inclu   
LISTUSEBEI  143  Integer  List Usage for Base Earnings In  E A X   
WHMETHBEI  144  Integer  Withholding Method for Base Ear  E A X  List: 3 entries
1=Regular Rate
4=Taxable, No Withholding
6=Supplemental Withholding
LISTUSEBDI  145  Integer  List Usage for Base Deductions  E A X   
EFFECTDATE  146  Date  INTERNAL USE - Tax Table Effect  A C   
FIPSNBR  147  Integer  INTERNAL USE - Tax Table FIPS N  A C   
FIPSCODE  148  String*2  INTERNAL USE - Tax Table FIPS C  A C   
CFGPARMVER  149  Integer  INTERNAL USE - Tax Table Parame  A C   
CFGPARMCNT  150  Integer  INTERNAL USE - Tax Table Parame  A C   
CALCATTRIB  151  Long  INTERNAL USE - Tax Calculation  A C   
TRAKATTRIB  152  Long  INTERNAL USE - Tax YTD Tracking  A C   

Copyright © 2001 ACCPAC International, Inc. All rights reserved.