Table: Company Payroll Taxes

Table: CPTXMS
View: CP0029
Record Length: 1290

Flags: A R 

Keys: 2

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

Fields: 161

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
AUTOUPDATE Boolean RESERVED - US Only
LOCSTATE String*30 RESERVED - US Only Mask: %-2C
LOCTAXCODE String*10 RESERVED - US Only Mask: %-10n
ATXTYPE Integer RESERVED - US Only
EMPDEFAULT Boolean Automatically Populate Employee
EMPDEFDIST String*6 Default Distribution Code Mask: %-6N

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).