View: Federal and Prov Taxes

RotoID: CT0001
Table: CTTTMC
Protocol: Flat
DLL:CTTTMC

Keys: 1

Title Fields
Tax TAXID

Fields: 59

Field Index Type Title Attributes Presentation
TAXID 1 String*6 Tax E A K R  Mask: %-6C
CATEGORY 2 Integer Category E A  List:3 entries
7 = Federal Tax
8 = Provincial Tax
9 = Local Tax
TAXTYPE 3 Integer Tax 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 Name E A 
EFFECTDATE 6 Date Effective Date E A 
CALCATTRIB 7 Long Calculation Attributes E A 
TRAKATTRIB 8 Long Historical Amounts Attributes E A 
ECALCMTHD 9 Integer Employee Tax Calculation Method E A  List:7 entries
1 = None
2 = Flat
5 = Amount Per Hour
7 = Percentage Of Base
13 = Tax Bracket Table
14 = Percentage Of Another Tax
15 = Percentage Of Employee Contribution
RCALCMTHD 10 Integer Employer Tax Calculation Method E A  List:7 entries
1 = None
2 = Flat
5 = Amount Per Hour
7 = Percentage Of Base
13 = Tax Bracket Table
14 = Percentage Of Another Tax
15 = Percentage Of Employee Contribution
FIPSNBR 11 Integer FIPS Number E A 
FIPSCODE 12 String*2 FIPS Code E A 
CFGPARMVER 13 Integer Configuration Fields Version E A 
CFGPARMCNT 14 Integer Configuration Field Count E A 
EMPPARMVER 15 Integer Employee Fields Version E A 
EMPPARMCNT 16 Integer Employee Field Count E A 
BASEMULT 17 BCD*5.5 Base Multiplier E A 
SURTAXMULT 18 BCD*5.5 Surtax Multiplier E A 
ROUNDTAXSW 19 Boolean Round Tax Flag E A 
DAILYPPY 20 Integer Daily Pay Periods Per Year E A 
ANNMAXWAGE 21 BCD*10.3 Annual Maximum Earnings E A 
EAMTORPCT 22 BCD*9.5 Employee Amount/Percent E A 
EANNMAXWH 23 BCD*10.3 Employee Annual Max Withholding E A 
RAMTORPCT 24 BCD*9.5 Employer Amount/Percent E A 
RANNMAXWH 25 BCD*10.3 Employer Annual Max Withholding E A 
NOFLDCNT 26 Integer Count of Fields to Suppress E A 
NOFLDIDX1 27 Long Suppressed Field 1 Index E A 
NOFLDIDX2 28 Long Suppressed Field 2 Index E A 
NOFLDIDX3 29 Long Suppressed Field 3 Index E A 
NOFLDIDX4 30 Long Suppressed Field 4 Index E A 
NOFLDIDX5 31 Long Suppressed Field 5 Index E A 
NOFLDIDX6 32 Long Suppressed Field 6 Index E A 
NOFLDIDX7 33 Long Suppressed Field 7 Index E A 
NOFLDIDX8 34 Long Suppressed Field 8 Index E A 
NOFLDIDX9 35 Long Suppressed Field 9 Index E A 
NOFLDIDX10 36 Long Suppressed Field 10 Index E A 
NOFLDIDX11 37 Long Suppressed Field 11 Index E A 
NOFLDIDX12 38 Long Suppressed Field 12 Index E A 
NOFLDIDX13 39 Long Suppressed Field 13 Index E A 
NOFLDIDX14 40 Long Suppressed Field 14 Index E A 
NOFLDIDX15 41 Long Suppressed Field 15 Index E A 
NOFLDIDX16 42 Long Suppressed Field 16 Index E A 
NOFLDIDX17 43 Long Suppressed Field 17 Index E A 
NOFLDIDX18 44 Long Suppressed Field 18 Index E A 
NOFLDIDX19 45 Long Suppressed Field 19 Index E A 
NOFLDIDX20 46 Long Suppressed Field 20 Index E A 
NOFLDIDX21 47 Long Suppressed Field 21 Index E A 
NOFLDIDX22 48 Long Suppressed Field 22 Index E A 
NOFLDIDX23 49 Long Suppressed Field 23 Index E A 
NOFLDIDX24 50 Long Suppressed Field 24 Index E A 
NOFLDIDX25 51 Long Suppressed Field 25 Index E A 
FORMID 52 String*8 Dynamic Fields Form ID E A 
PRVMAXWAGE 53 BCD*10.3 Employee Maximum Wage Base E A 
PRVEAMTPCT 54 BCD*9.5 Employee Default Amount/Percent E A 
PRVEAMAXWH 55 BCD*10.3 Employee Maximum W/H Amount E A 
PRVRAMTPCT 56 BCD*9.5 Employer Default Amount/Percent E A 
PRVRAMAXWH 57 BCD*10.3 Employer Maximum W/H Amount E A 
BASETAX 58 String*6 Base Tax E A 
TCALCORDER 59 Integer Tax Calculation Order E A 

This page was generated on 2021-Nov-24

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