# Table: Company Payroll Taxes

Table: CPTXMS
View: CP0029
Record length: 1238
Flags: A R

## Keys: 2

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

## Fields: 155

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 | = | Employment 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: %-15N
ACTIVESW | Boolean | Tax Inactive |
INACTASOF | Date | Inactive Date |
LASTMAINT | Date | Last Maintained |
BASEMULT | BCD*5.5 | RESERVED - US Only |
SURTAXMULT | BCD*5.5 | RESERVED - US Only |
ROUNDTAXSW | Boolean | RESERVED - US Only |
DAILYPPY | Integer | RESERVED - US Only |
TAXCREDITS | Boolean | RESERVED - US Only |
TAXCRPCNT | BCD*5.5 | RESERVED - US Only |
STDARDDED1 | BCD*10.3 | RESERVED - US Only |
STDARDDED2 | BCD*10.3 | RESERVED - US Only |
STDARDDED3 | BCD*10.3 | RESERVED - US Only |
STDARDDED4 | BCD*10.3 | RESERVED - US Only |
EXMPTNAMT1 | BCD*10.3 | RESERVED - US Only |
EXMPTNAMT2 | BCD*10.3 | RESERVED - US Only |
EXMPTNAMT3 | BCD*10.3 | RESERVED - US Only |
EXMPTNAMT4 | BCD*10.3 | RESERVED - US Only |
EXMPTCRSW | Boolean | RESERVED - US Only |
ANNMAXHRS | BCD*4.3 | RESERVED - US Only |
ANNMAXERN | BCD*10.3 | RESERVED - US Only |
ANNUALMIN | BCD*10.3 | RESERVED - US Only |
W2BOXTYP | Integer | RESERVED - US Only |
W2WITHTAX | String*6 | RESERVED - US Only |
ASSOCW2SW | Boolean | RESERVED - US Only |
ASSOCTAX | String*6 | RESERVED - US Only |
ECALCMTHD | Integer | RESERVED - US Only | 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 | RESERVED - US Only |
EBASETAX | String*6 | RESERVED - US Only |
EAMTORPCT | BCD*9.5 | RESERVED - US Only |
ELIMITON | Integer | RESERVED - US Only | List: 3 entries
1 | = | No Limit
4 | = | Withholding
5 | = | Base
EANNUALMAX | BCD*10.3 | RESERVED - US Only |
ECLCMINWRK | Boolean | RESERVED - US Only |
EDAILYMIN | BCD*10.3 | RESERVED - US Only |
EDAILYMAX | BCD*10.3 | RESERVED - US Only |
EWEEKLYMIN | BCD*10.3 | RESERVED - US Only |
EWEEKLYMAX | BCD*10.3 | RESERVED - US Only |
EBIWKLYMIN | BCD*10.3 | RESERVED - US Only |
EBIWKLYMAX | BCD*10.3 | RESERVED - US Only |
ESEMIMNMIN | BCD*10.3 | RESERVED - US Only |
ESEMIMNMAX | BCD*10.3 | RESERVED - US Only |
EMNTHLYMIN | BCD*10.3 | RESERVED - US Only |
EMNTHLYMAX | BCD*10.3 | RESERVED - US Only |
EQRTRLYMIN | BCD*10.3 | RESERVED - US Only |
EQRTRLYMAX | BCD*10.3 | RESERVED - US Only |
E10PPPYMIN | BCD*10.3 | RESERVED - US Only |
E10PPPYMAX | BCD*10.3 | RESERVED - US Only |
E13PPPYMIN | BCD*10.3 | RESERVED - US Only |
E13PPPYMAX | BCD*10.3 | RESERVED - US Only |
E22PPPYMIN | BCD*10.3 | RESERVED - US Only |
E22PPPYMAX | BCD*10.3 | RESERVED - US Only |
RCALCMTHD | Integer | RESERVED - US Only | 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 | RESERVED - US Only |
RAMTORPCT | BCD*9.5 | Employer Amount/Percent |
RLIMITON | Integer | RESERVED - US Only | List: 3 entries
1 | = | No Limit
4 | = | Withholding
5 | = | Base
RANNUALMAX | BCD*10.3 | RESERVED - US Only |
RCLCMINWRK | Boolean | RESERVED - US Only |
RDAILYMIN | BCD*10.3 | RESERVED - US Only |
RDAILYMAX | BCD*10.3 | RESERVED - US Only |
RWEEKLYMIN | BCD*10.3 | RESERVED - US Only |
RWEEKLYMAX | BCD*10.3 | RESERVED - US Only |
RBIWKLYMIN | BCD*10.3 | RESERVED - US Only |
RBIWKLYMAX | BCD*10.3 | RESERVED - US Only |
RSEMIMNMIN | BCD*10.3 | RESERVED - US Only |
RSEMIMNMAX | BCD*10.3 | RESERVED - US Only |
RMNTHLYMIN | BCD*10.3 | RESERVED - US Only |
RMNTHLYMAX | BCD*10.3 | RESERVED - US Only |
RQRTRLYMIN | BCD*10.3 | RESERVED - US Only |
RQRTRLYMAX | BCD*10.3 | RESERVED - US Only |
R10PPPYMIN | BCD*10.3 | RESERVED - US Only |
R10PPPYMAX | BCD*10.3 | RESERVED - US Only |
R13PPPYMIN | BCD*10.3 | RESERVED - US Only |
R13PPPYMAX | BCD*10.3 | RESERVED - US Only |
R22PPPYMIN | BCD*10.3 | RESERVED - US Only |
R22PPPYMAX | BCD*10.3 | RESERVED - US Only |
WGBRACK1 | BCD*10.3 | RESERVED - US Only |
WGADDAMT1 | BCD*10.3 | RESERVED - US Only |
WGPCTOVR1 | BCD*5.5 | RESERVED - US Only |
WGBRACK2 | BCD*10.3 | RESERVED - US Only |
WGADDAMT2 | BCD*10.3 | RESERVED - US Only |
WGPCTOVR2 | BCD*5.5 | RESERVED - US Only |
WGBRACK3 | BCD*10.3 | RESERVED - US Only |
WGADDAMT3 | BCD*10.3 | RESERVED - US Only |
WGPCTOVR3 | BCD*5.5 | RESERVED - US Only |
WGBRACK4 | BCD*10.3 | RESERVED - US Only |
WGADDAMT4 | BCD*10.3 | RESERVED - US Only |
WGPCTOVR4 | BCD*5.5 | RESERVED - US Only |
WGBRACK5 | BCD*10.3 | RESERVED - US Only |
WGADDAMT5 | BCD*10.3 | RESERVED - US Only |
WGPCTOVR5 | BCD*5.5 | RESERVED - US Only |
WGBRACK6 | BCD*10.3 | RESERVED - US Only |
WGADDAMT6 | BCD*10.3 | RESERVED - US Only |
WGPCTOVR6 | BCD*5.5 | RESERVED - US Only |
WGBRACK7 | BCD*10.3 | RESERVED - US Only |
WGADDAMT7 | BCD*10.3 | RESERVED - US Only |
WGPCTOVR7 | BCD*5.5 | RESERVED - US Only |
WGBRACK8 | BCD*10.3 | RESERVED - US Only |
WGADDAMT8 | BCD*10.3 | RESERVED - US Only |
WGPCTOVR8 | BCD*5.5 | RESERVED - US Only |
WGBRACK9 | BCD*10.3 | RESERVED - US Only |
WGADDAMT9 | BCD*10.3 | RESERVED - US Only |
WGPCTOVR9 | BCD*5.5 | RESERVED - US Only |
WGBRACK10 | BCD*10.3 | RESERVED - US Only |
WGADDAMT10 | BCD*10.3 | RESERVED - US Only |
WGPCTOVR10 | BCD*5.5 | RESERVED - US Only |
WGBRACK11 | BCD*10.3 | RESERVED - US Only |
WGADDAMT11 | BCD*10.3 | RESERVED - US Only |
WGPCTOVR11 | BCD*5.5 | RESERVED - US Only |
WGBRACK12 | BCD*10.3 | RESERVED - US Only |
WGADDAMT12 | BCD*10.3 | RESERVED - US Only |
WGPCTOVR12 | BCD*5.5 | RESERVED - US Only |
WGBRACK13 | BCD*10.3 | RESERVED - US Only |
WGADDAMT13 | BCD*10.3 | RESERVED - US Only |
WGPCTOVR13 | BCD*5.5 | RESERVED - US Only |
WGBRACK14 | BCD*10.3 | RESERVED - US Only |
WGADDAMT14 | BCD*10.3 | RESERVED - US Only |
WGPCTOVR14 | BCD*5.5 | RESERVED - US Only |
WGBRACK15 | BCD*10.3 | RESERVED - US Only |
WGADDAMT15 | BCD*10.3 | RESERVED - US Only |
WGPCTOVR15 | BCD*5.5 | RESERVED - US Only |
WGBRACK16 | BCD*10.3 | RESERVED - US Only |
WGADDAMT16 | BCD*10.3 | RESERVED - US Only |
WGPCTOVR16 | BCD*5.5 | RESERVED - US Only |
WGBRACK17 | BCD*10.3 | RESERVED - US Only |
WGADDAMT17 | BCD*10.3 | RESERVED - US Only |
WGPCTOVR17 | BCD*5.5 | RESERVED - US Only |
WGBRACK18 | BCD*10.3 | RESERVED - US Only |
WGADDAMT18 | BCD*10.3 | RESERVED - US Only |
WGPCTOVR18 | BCD*5.5 | RESERVED - US Only |
WGBRACK19 | BCD*10.3 | RESERVED - US Only |
WGADDAMT19 | BCD*10.3 | RESERVED - US Only |
WGPCTOVR19 | BCD*5.5 | RESERVED - US Only |
WGBRACK20 | BCD*10.3 | RESERVED - US Only |
WGADDAMT20 | BCD*10.3 | RESERVED - US Only |
WGPCTOVR20 | BCD*5.5 | RESERVED - US Only |
LEVEL | Integer | Level |
LISTUSEBHI | Integer | List Usage for Base Hours Include |
LISTUSEBEI | Integer | List Usage for Base Earnings Include |
WHMETHBEI | Integer | RESERVED - US Only | 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 | RESERVED - US Only |
FIPSCODE | String*2 | RESERVED - US Only |
CFGPARMVER | Integer | INTERNAL USE - Tax Table Parameter Version |
CFGPARMCNT | Integer | INTERNAL USE - Tax Table Parameter Count |
VALUES | Long | Number of Optional Fields |

This page was generated on 2008-May-02

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