View: Company Payroll Taxes

RotoID: CP0029
Table: CPTXMS
Protocol: Header
DLL:CPTXMS

Compositions: 5

RotoID Tables 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: 160

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 Include X 
LISTUSEBEI 143 Integer List Usage for Base Earnings Include 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 Include E A X 
EFFECTDATE 146 Date INTERNAL USE - Tax Table Effective Date A C 
FIPSNBR 147 Integer RESERVED - US Only C 
FIPSCODE 148 String*2 RESERVED - US Only 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:4 entries
0 = Validation
1 = Insert Optional Fields
2 = Clear Local Tax Audit Tables
3 = Clear Local Tax Employee Audit Tables
VALUES 170 Long Number of Optional Fields E A C 
AUTOUPDATE 171 Boolean RESERVED - US Only E A X 
LOCSTATE 172 String*30 RESERVED - US Only E A X  Mask: %-2C
LOCTAXCODE 173 String*10 RESERVED - US Only E A X  Mask: %-10n
ATXTYPE 174 Integer RESERVED - US Only E A X 
EMPDEFAULT 175 Boolean Automatically Populate Employee E A X 
EMPDEFDIST 176 String*6 Default Distribution Code E A X  Mask: %-6N

This page was generated on 2022-Aug-18

© 2021 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).