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: 154

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: 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 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: 2 entries
0=Validation
1=Insert Optional Fields
VALUES  170  Long  Number of Optional Fields  E A C   

This page was generated on 2008-May-02

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