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.