# View: Company Payroll Taxes

RotoID: CP0029
Table: CPTXMS
DLL: CPTXMS

## Compositions: 5

RotoID | Table | Title | DLL
--- | --- | --- | ---
CP0015 | CPINCL | Include List | CPINCL
CP0015 | CPINCL | Include List | CPINCL
CP0015 | CPINCL | Include List | CPINCL
CP0009 | CPDIST | Distribution | CPDIST
CP0124 | CPTXMO | Taxes Optional Field Values | CPTXMO

## 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 C |
TAXTYPE | 3 | Integer | Type | E A C | List: 6 entries
19 | = | Income Tax
20 | = | Employment 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: %-15N
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 | RESERVED - US Only | E A |
SURTAXMULT | 11 | BCD*5.5 | RESERVED - US Only | E A |
ROUNDTAXSW | 12 | Boolean | RESERVED - US Only | E A X |
DAILYPPY | 13 | Integer | RESERVED - US Only | E A X |
TAXCREDITS | 14 | Boolean | RESERVED - US Only |  |
TAXCRPCNT | 15 | BCD*5.5 | RESERVED - US Only |  |
STDARDDED1 | 16 | BCD*10.3 | RESERVED - US Only | E A X |
STDARDDED2 | 17 | BCD*10.3 | RESERVED - US Only |  |
STDARDDED3 | 18 | BCD*10.3 | RESERVED - US Only |  |
STDARDDED4 | 19 | BCD*10.3 | RESERVED - US Only |  |
EXMPTNAMT1 | 20 | BCD*10.3 | RESERVED - US Only | E A X |
EXMPTNAMT2 | 21 | BCD*10.3 | RESERVED - US Only |  |
EXMPTNAMT3 | 22 | BCD*10.3 | RESERVED - US Only |  |
EXMPTNAMT4 | 23 | BCD*10.3 | RESERVED - US Only |  |
EXMPTCRSW | 24 | Boolean | RESERVED - US Only | E A X |
ANNMAXHRS | 25 | BCD*4.3 | RESERVED - US Only | X |
ANNMAXERN | 26 | BCD*10.3 | RESERVED - US Only | X |
ANNUALMIN | 27 | BCD*10.3 | RESERVED - US Only | E A X |
W2BOXTYP | 28 | Integer | RESERVED - US Only | X |
W2WITHTAX | 29 | String*6 | RESERVED - US Only | X |
ASSOCW2SW | 30 | Boolean | RESERVED - US Only | X |
ASSOCTAX | 31 | String*6 | RESERVED - US Only | X |
ECALCMTHD | 32 | Integer | RESERVED - US Only | 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 | RESERVED - US Only | E A X |
EBASETAX | 34 | String*6 | RESERVED - US Only | X |
EAMTORPCT | 35 | BCD*9.5 | RESERVED - US Only | E A X |
ELIMITON | 36 | Integer | RESERVED - US Only | E A P X | List: 3 entries
1 | = | No Limit
4 | = | Withholding
5 | = | Base
EANNUALMAX | 37 | BCD*10.3 | RESERVED - US Only | E A X |
ECLCMINWRK | 38 | Boolean | RESERVED - US Only | X |
EDAILYMIN | 39 | BCD*10.3 | RESERVED - US Only | X |
EDAILYMAX | 40 | BCD*10.3 | RESERVED - US Only | X |
EWEEKLYMIN | 41 | BCD*10.3 | RESERVED - US Only | X |
EWEEKLYMAX | 42 | BCD*10.3 | RESERVED - US Only | X |
EBIWKLYMIN | 43 | BCD*10.3 | RESERVED - US Only | X |
EBIWKLYMAX | 44 | BCD*10.3 | RESERVED - US Only | X |
ESEMIMNMIN | 45 | BCD*10.3 | RESERVED - US Only | X |
ESEMIMNMAX | 46 | BCD*10.3 | RESERVED - US Only | X |
EMNTHLYMIN | 47 | BCD*10.3 | RESERVED - US Only | X |
EMNTHLYMAX | 48 | BCD*10.3 | RESERVED - US Only | X |
EQRTRLYMIN | 49 | BCD*10.3 | RESERVED - US Only | X |
EQRTRLYMAX | 50 | BCD*10.3 | RESERVED - US Only | X |
E10PPPYMIN | 51 | BCD*10.3 | RESERVED - US Only | X |
E10PPPYMAX | 52 | BCD*10.3 | RESERVED - US Only | X |
E13PPPYMIN | 53 | BCD*10.3 | RESERVED - US Only | X |
E13PPPYMAX | 54 | BCD*10.3 | RESERVED - US Only | X |
E22PPPYMIN | 55 | BCD*10.3 | RESERVED - US Only | X |
E22PPPYMAX | 56 | BCD*10.3 | RESERVED - US Only | X |
RCALCMTHD | 57 | Integer | RESERVED - US Only | 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 | RESERVED - US Only | X |
RAMTORPCT | 59 | BCD*9.5 | Employer Amount/Percent | E A X |
RLIMITON | 60 | Integer | RESERVED - US Only | E A P X | List: 3 entries
1 | = | No Limit
4 | = | Withholding
5 | = | Base
RANNUALMAX | 61 | BCD*10.3 | RESERVED - US Only | E A X |
RCLCMINWRK | 62 | Boolean | RESERVED - US Only | X |
RDAILYMIN | 63 | BCD*10.3 | RESERVED - US Only | X |
RDAILYMAX | 64 | BCD*10.3 | RESERVED - US Only | X |
RWEEKLYMIN | 65 | BCD*10.3 | RESERVED - US Only | X |
RWEEKLYMAX | 66 | BCD*10.3 | RESERVED - US Only | X |
RBIWKLYMIN | 67 | BCD*10.3 | RESERVED - US Only | X |
RBIWKLYMAX | 68 | BCD*10.3 | RESERVED - US Only | X |
RSEMIMNMIN | 69 | BCD*10.3 | RESERVED - US Only | X |
RSEMIMNMAX | 70 | BCD*10.3 | RESERVED - US Only | X |
RMNTHLYMIN | 71 | BCD*10.3 | RESERVED - US Only | X |
RMNTHLYMAX | 72 | BCD*10.3 | RESERVED - US Only | X |
RQRTRLYMIN | 73 | BCD*10.3 | RESERVED - US Only | X |
RQRTRLYMAX | 74 | BCD*10.3 | RESERVED - US Only | X |
R10PPPYMIN | 75 | BCD*10.3 | RESERVED - US Only | X |
R10PPPYMAX | 76 | BCD*10.3 | RESERVED - US Only | X |
R13PPPYMIN | 77 | BCD*10.3 | RESERVED - US Only | X |
R13PPPYMAX | 78 | BCD*10.3 | RESERVED - US Only | X |
R22PPPYMIN | 79 | BCD*10.3 | RESERVED - US Only | X |
R22PPPYMAX | 80 | BCD*10.3 | RESERVED - US Only | X |
WGBRACK1 | 81 | BCD*10.3 | RESERVED - US Only | X |
WGADDAMT1 | 82 | BCD*10.3 | RESERVED - US Only | X |
WGPCTOVR1 | 83 | BCD*5.5 | RESERVED - US Only | X |
WGBRACK2 | 84 | BCD*10.3 | RESERVED - US Only | X |
WGADDAMT2 | 85 | BCD*10.3 | RESERVED - US Only | X |
WGPCTOVR2 | 86 | BCD*5.5 | RESERVED - US Only | X |
WGBRACK3 | 87 | BCD*10.3 | RESERVED - US Only | X |
WGADDAMT3 | 88 | BCD*10.3 | RESERVED - US Only | X |
WGPCTOVR3 | 89 | BCD*5.5 | RESERVED - US Only | X |
WGBRACK4 | 90 | BCD*10.3 | RESERVED - US Only | X |
WGADDAMT4 | 91 | BCD*10.3 | RESERVED - US Only | X |
WGPCTOVR4 | 92 | BCD*5.5 | RESERVED - US Only | X |
WGBRACK5 | 93 | BCD*10.3 | RESERVED - US Only | X |
WGADDAMT5 | 94 | BCD*10.3 | RESERVED - US Only | X |
WGPCTOVR5 | 95 | BCD*5.5 | RESERVED - US Only | X |
WGBRACK6 | 96 | BCD*10.3 | RESERVED - US Only | X |
WGADDAMT6 | 97 | BCD*10.3 | RESERVED - US Only | X |
WGPCTOVR6 | 98 | BCD*5.5 | RESERVED - US Only | X |
WGBRACK7 | 99 | BCD*10.3 | RESERVED - US Only | X |
WGADDAMT7 | 100 | BCD*10.3 | RESERVED - US Only | X |
WGPCTOVR7 | 101 | BCD*5.5 | RESERVED - US Only | X |
WGBRACK8 | 102 | BCD*10.3 | RESERVED - US Only | X |
WGADDAMT8 | 103 | BCD*10.3 | RESERVED - US Only | X |
WGPCTOVR8 | 104 | BCD*5.5 | RESERVED - US Only | X |
WGBRACK9 | 105 | BCD*10.3 | RESERVED - US Only | X |
WGADDAMT9 | 106 | BCD*10.3 | RESERVED - US Only | X |
WGPCTOVR9 | 107 | BCD*5.5 | RESERVED - US Only | X |
WGBRACK10 | 108 | BCD*10.3 | RESERVED - US Only | X |
WGADDAMT10 | 109 | BCD*10.3 | RESERVED - US Only | X |
WGPCTOVR10 | 110 | BCD*5.5 | RESERVED - US Only | X |
WGBRACK11 | 111 | BCD*10.3 | RESERVED - US Only | X |
WGADDAMT11 | 112 | BCD*10.3 | RESERVED - US Only | X |
WGPCTOVR11 | 113 | BCD*5.5 | RESERVED - US Only | X |
WGBRACK12 | 114 | BCD*10.3 | RESERVED - US Only | X |
WGADDAMT12 | 115 | BCD*10.3 | RESERVED - US Only | X |
WGPCTOVR12 | 116 | BCD*5.5 | RESERVED - US Only | X |
WGBRACK13 | 117 | BCD*10.3 | RESERVED - US Only | X |
WGADDAMT13 | 118 | BCD*10.3 | RESERVED - US Only | X |
WGPCTOVR13 | 119 | BCD*5.5 | RESERVED - US Only | X |
WGBRACK14 | 120 | BCD*10.3 | RESERVED - US Only | X |
WGADDAMT14 | 121 | BCD*10.3 | RESERVED - US Only | X |
WGPCTOVR14 | 122 | BCD*5.5 | RESERVED - US Only | X |
WGBRACK15 | 123 | BCD*10.3 | RESERVED - US Only | X |
WGADDAMT15 | 124 | BCD*10.3 | RESERVED - US Only | X |
WGPCTOVR15 | 125 | BCD*5.5 | RESERVED - US Only | X |
WGBRACK16 | 126 | BCD*10.3 | RESERVED - US Only | X |
WGADDAMT16 | 127 | BCD*10.3 | RESERVED - US Only | X |
WGPCTOVR16 | 128 | BCD*5.5 | RESERVED - US Only | X |
WGBRACK17 | 129 | BCD*10.3 | RESERVED - US Only | X |
WGADDAMT17 | 130 | BCD*10.3 | RESERVED - US Only | X |
WGPCTOVR17 | 131 | BCD*5.5 | RESERVED - US Only | X |
WGBRACK18 | 132 | BCD*10.3 | RESERVED - US Only | X |
WGADDAMT18 | 133 | BCD*10.3 | RESERVED - US Only | X |
WGPCTOVR18 | 134 | BCD*5.5 | RESERVED - US Only | X |
WGBRACK19 | 135 | BCD*10.3 | RESERVED - US Only | X |
WGADDAMT19 | 136 | BCD*10.3 | RESERVED - US Only | X |
WGPCTOVR19 | 137 | BCD*5.5 | RESERVED - US Only | X |
WGBRACK20 | 138 | BCD*10.3 | RESERVED - US Only | X |
WGADDAMT20 | 139 | BCD*10.3 | RESERVED - US Only | X |
WGPCTOVR20 | 140 | BCD*5.5 | RESERVED - US Only | X |
LEVEL | 141 | Integer | Level | E A X |
LISTUSEBHI | 142 | Integer | List Usage for Base Hours Includ | X |
LISTUSEBEI | 143 | Integer | List Usage for Base Earnings Inc | E A X |
WHMETHBEI | 144 | Integer | RESERVED - US Only | E A X | List: 3 entries
1 | = | Regular Rate
4 | = | Taxable, No Withholding
6 | = | Supplemental Withholding
LISTUSEBDI | 145 | Integer | List Usage for Base Deductions I | E A X |
EFFECTDATE | 146 | Date | INTERNAL USE - Tax Table Effecti | A C |
FIPSNBR | 147 | Integer | RESERVED - US Only | C |
FIPSCODE | 148 | String*2 | RESERVED - US Only | C |
CFGPARMVER | 149 | Integer | INTERNAL USE - Tax Table Paramet | A C |
CFGPARMCNT | 150 | Integer | INTERNAL USE - Tax Table Paramet | A C |
CALCATTRIB | 151 | Long | INTERNAL USE - Tax Calculation A | A C |
TRAKATTRIB | 152 | Long | INTERNAL USE - Tax YTD Tracking | 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 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.