Table: Tax State Details

Table: TXSTATED
View: TX0014
Record length: 2347
Flags: A R 

Keys: 1

Title  Flags  Fields
Tax Group/Tran. Type/Version  GROUPID, TTYPE, VERSION, TXAUTHNUM

Fields: 165

Field  Type  Title  Presentation 
GROUPID  String*12  Tax Group  Mask: %-12N
TTYPE  Integer  Transaction Type  List: 2 entries
1=Sales
2=Purchases
VERSION  Long  Version   
TXAUTHNUM  Integer  Tax Authority Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
AUTHORITY  String*12  Tax Authority  Mask: %-12N
DESC  String*60  Description   
AUDITLEVEL  Integer  Report Level  List: 2 entries
1=At invoice level
0=No reporting
TAXABLE  Integer  Taxable  List: 2 entries
0=No
1=Yes
SURTAX  Integer  Surtax  List: 2 entries
0=No
1=Yes
SURAUTH  String*12  Surtax On Authority  Mask: %-12N
MINTAX  BCD*10.3  Maximum Tax Allowable   
MAXTAX  BCD*10.3  No Tax Charged Below   
TXBASE  Integer  Tax Base  List: 5 entries
1=Selling price
2=Standard cost
3=Most recent cost
4=Alternate amount 1
5=Alternate amount 2
INCLUDABLE  Integer  Allow Tax In Price  List: 2 entries
0=No
1=Yes
TXRTGCTL  Integer  Report Tax on Retainage Document  List: 3 entries
0=No Reporting
1=At Time of Retainage Document
2=At Time of Original Document
RECOVERABL  Integer  Tax Recoverable  List: 2 entries
0=No
1=Yes
RATERECOV  BCD*8.5  Recoverable Rate   
ACCTRECOV  String*45  Recoverable Tax Account  Mask: %-45C
EXPSEPARTE  Integer  Expense Separately  List: 2 entries
0=No
1=Yes
ACCTEXP  String*45  Expense Account  Mask: %-45C
LIABILITY  String*45  Tax Liability Account  Mask: %-45C
HCLASS01  Integer  Header Class 1  List: 4 entries
0=Undefined
1=Exists
2=Exempt
3=Rates Defined
HCLASS02  Integer  Header Class 2  List: 4 entries
0=Undefined
1=Exists
2=Exempt
3=Rates Defined
HCLASS03  Integer  Header Class 3  List: 4 entries
0=Undefined
1=Exists
2=Exempt
3=Rates Defined
HCLASS04  Integer  Header Class 4  List: 4 entries
0=Undefined
1=Exists
2=Exempt
3=Rates Defined
HCLASS05  Integer  Header Class 5  List: 4 entries
0=Undefined
1=Exists
2=Exempt
3=Rates Defined
HCLASS06  Integer  Header Class 6  List: 4 entries
0=Undefined
1=Exists
2=Exempt
3=Rates Defined
HCLASS07  Integer  Header Class 7  List: 4 entries
0=Undefined
1=Exists
2=Exempt
3=Rates Defined
HCLASS08  Integer  Header Class 8  List: 4 entries
0=Undefined
1=Exists
2=Exempt
3=Rates Defined
HCLASS09  Integer  Header Class 9  List: 4 entries
0=Undefined
1=Exists
2=Exempt
3=Rates Defined
HCLASS10  Integer  Header Class10  List: 4 entries
0=Undefined
1=Exists
2=Exempt
3=Rates Defined
DCLASS01  Integer  Detail Class 1  List: 3 entries
0=Undefined
1=Exists
2=Exempt
DCLASS02  Integer  Detail Class 2  List: 3 entries
0=Undefined
1=Exists
2=Exempt
DCLASS03  Integer  Detail Class 3  List: 3 entries
0=Undefined
1=Exists
2=Exempt
DCLASS04  Integer  Detail Class 4  List: 3 entries
0=Undefined
1=Exists
2=Exempt
DCLASS05  Integer  Detail Class 5  List: 3 entries
0=Undefined
1=Exists
2=Exempt
DCLASS06  Integer  Detail Class 6  List: 3 entries
0=Undefined
1=Exists
2=Exempt
DCLASS07  Integer  Detail Class 7  List: 3 entries
0=Undefined
1=Exists
2=Exempt
DCLASS08  Integer  Detail Class 8  List: 3 entries
0=Undefined
1=Exists
2=Exempt
DCLASS09  Integer  Detail Class 9  List: 3 entries
0=Undefined
1=Exists
2=Exempt
DCLASS10  Integer  Detail Class10  List: 3 entries
0=Undefined
1=Exists
2=Exempt
HCLS01DESC  String*60  Header Class 1 Description   
HCLS02DESC  String*60  Header Class 2 Description   
HCLS03DESC  String*60  Header Class 3 Description   
HCLS04DESC  String*60  Header Class 4 Description   
HCLS05DESC  String*60  Header Class 5 Description   
HCLS06DESC  String*60  Header Class 6 Description   
HCLS07DESC  String*60  Header Class 7 Description   
HCLS08DESC  String*60  Header Class 8 Description   
HCLS09DESC  String*60  Header Class 9 Description   
HCLS10DESC  String*60  Header Class10 Description   
DCLS01DESC  String*60  Detail Class 1 Description   
DCLS02DESC  String*60  Detail Class 2 Description   
DCLS03DESC  String*60  Detail Class 3 Description   
DCLS04DESC  String*60  Detail Class 4 Description   
DCLS05DESC  String*60  Detail Class 5 Description   
DCLS06DESC  String*60  Detail Class 6 Description   
DCLS07DESC  String*60  Detail Class 7 Description   
DCLS08DESC  String*60  Detail Class 8 Description   
DCLS09DESC  String*60  Detail Class 9 Description   
DCLS10DESC  String*60  Detail Class10 Description   
TXRATE0101  BCD*8.5  Buyer Class 1 Item Class 1 Rate   
TXRATE0102  BCD*8.5  Buyer Class 1 Item Class 2 Rate   
TXRATE0103  BCD*8.5  Buyer Class 1 Item Class 3 Rate   
TXRATE0104  BCD*8.5  Buyer Class 1 Item Class 4 Rate   
TXRATE0105  BCD*8.5  Buyer Class 1 Item Class 5 Rate   
TXRATE0106  BCD*8.5  Buyer Class 1 Item Class 6 Rate   
TXRATE0107  BCD*8.5  Buyer Class 1 Item Class 7 Rate   
TXRATE0108  BCD*8.5  Buyer Class 1 Item Class 8 Rate   
TXRATE0109  BCD*8.5  Buyer Class 1 Item Class 9 Rate   
TXRATE0110  BCD*8.5  Buyer Class 1 Item Class10 Rate   
TXRATE0201  BCD*8.5  Buyer Class 2 Item Class 1 Rate   
TXRATE0202  BCD*8.5  Buyer Class 2 Item Class 2 Rate   
TXRATE0203  BCD*8.5  Buyer Class 2 Item Class 3 Rate   
TXRATE0204  BCD*8.5  Buyer Class 2 Item Class 4 Rate   
TXRATE0205  BCD*8.5  Buyer Class 2 Item Class 5 Rate   
TXRATE0206  BCD*8.5  Buyer Class 2 Item Class 6 Rate   
TXRATE0207  BCD*8.5  Buyer Class 2 Item Class 7 Rate   
TXRATE0208  BCD*8.5  Buyer Class 2 Item Class 8 Rate   
TXRATE0209  BCD*8.5  Buyer Class 2 Item Class 9 Rate   
TXRATE0210  BCD*8.5  Buyer Class 2 Item Class10 Rate   
TXRATE0301  BCD*8.5  Buyer Class 3 Item Class 1 Rate   
TXRATE0302  BCD*8.5  Buyer Class 3 Item Class 2 Rate   
TXRATE0303  BCD*8.5  Buyer Class 3 Item Class 3 Rate   
TXRATE0304  BCD*8.5  Buyer Class 3 Item Class 4 Rate   
TXRATE0305  BCD*8.5  Buyer Class 3 Item Class 5 Rate   
TXRATE0306  BCD*8.5  Buyer Class 3 Item Class 6 Rate   
TXRATE0307  BCD*8.5  Buyer Class 3 Item Class 7 Rate   
TXRATE0308  BCD*8.5  Buyer Class 3 Item Class 8 Rate   
TXRATE0309  BCD*8.5  Buyer Class 3 Item Class 9 Rate   
TXRATE0310  BCD*8.5  Buyer Class 3 Item Class10 Rate   
TXRATE0401  BCD*8.5  Buyer Class 4 Item Class 1 Rate   
TXRATE0402  BCD*8.5  Buyer Class 4 Item Class 2 Rate   
TXRATE0403  BCD*8.5  Buyer Class 4 Item Class 3 Rate   
TXRATE0404  BCD*8.5  Buyer Class 4 Item Class 4 Rate   
TXRATE0405  BCD*8.5  Buyer Class 4 Item Class 5 Rate   
TXRATE0406  BCD*8.5  Buyer Class 4 Item Class 6 Rate   
TXRATE0407  BCD*8.5  Buyer Class 4 Item Class 7 Rate   
TXRATE0408  BCD*8.5  Buyer Class 4 Item Class 8 Rate   
TXRATE0409  BCD*8.5  Buyer Class 4 Item Class 9 Rate   
TXRATE0410  BCD*8.5  Buyer Class 4 Item Class10 Rate   
TXRATE0501  BCD*8.5  Buyer Class 5 Item Class 1 Rate   
TXRATE0502  BCD*8.5  Buyer Class 5 Item Class 2 Rate   
TXRATE0503  BCD*8.5  Buyer Class 5 Item Class 3 Rate   
TXRATE0504  BCD*8.5  Buyer Class 5 Item Class 4 Rate   
TXRATE0505  BCD*8.5  Buyer Class 5 Item Class 5 Rate   
TXRATE0506  BCD*8.5  Buyer Class 5 Item Class 6 Rate   
TXRATE0507  BCD*8.5  Buyer Class 5 Item Class 7 Rate   
TXRATE0508  BCD*8.5  Buyer Class 5 Item Class 8 Rate   
TXRATE0509  BCD*8.5  Buyer Class 5 Item Class 9 Rate   
TXRATE0510  BCD*8.5  Buyer Class 5 Item Class10 Rate   
TXRATE0601  BCD*8.5  Buyer Class 6 Item Class 1 Rate   
TXRATE0602  BCD*8.5  Buyer Class 6 Item Class 2 Rate   
TXRATE0603  BCD*8.5  Buyer Class 6 Item Class 3 Rate   
TXRATE0604  BCD*8.5  Buyer Class 6 Item Class 4 Rate   
TXRATE0605  BCD*8.5  Buyer Class 6 Item Class 5 Rate   
TXRATE0606  BCD*8.5  Buyer Class 6 Item Class 6 Rate   
TXRATE0607  BCD*8.5  Buyer Class 6 Item Class 7 Rate   
TXRATE0608  BCD*8.5  Buyer Class 6 Item Class 8 Rate   
TXRATE0609  BCD*8.5  Buyer Class 6 Item Class 9 Rate   
TXRATE0610  BCD*8.5  Buyer Class 6 Item Class10 Rate   
TXRATE0701  BCD*8.5  Buyer Class 7 Item Class 1 Rate   
TXRATE0702  BCD*8.5  Buyer Class 7 Item Class 2 Rate   
TXRATE0703  BCD*8.5  Buyer Class 7 Item Class 3 Rate   
TXRATE0704  BCD*8.5  Buyer Class 7 Item Class 4 Rate   
TXRATE0705  BCD*8.5  Buyer Class 7 Item Class 5 Rate   
TXRATE0706  BCD*8.5  Buyer Class 7 Item Class 6 Rate   
TXRATE0707  BCD*8.5  Buyer Class 7 Item Class 7 Rate   
TXRATE0708  BCD*8.5  Buyer Class 7 Item Class 8 Rate   
TXRATE0709  BCD*8.5  Buyer Class 7 Item Class 9 Rate   
TXRATE0710  BCD*8.5  Buyer Class 7 Item Class10 Rate   
TXRATE0801  BCD*8.5  Buyer Class 8 Item Class 1 Rate   
TXRATE0802  BCD*8.5  Buyer Class 8 Item Class 2 Rate   
TXRATE0803  BCD*8.5  Buyer Class 8 Item Class 3 Rate   
TXRATE0804  BCD*8.5  Buyer Class 8 Item Class 4 Rate   
TXRATE0805  BCD*8.5  Buyer Class 8 Item Class 5 Rate   
TXRATE0806  BCD*8.5  Buyer Class 8 Item Class 6 Rate   
TXRATE0807  BCD*8.5  Buyer Class 8 Item Class 7 Rate   
TXRATE0808  BCD*8.5  Buyer Class 8 Item Class 8 Rate   
TXRATE0809  BCD*8.5  Buyer Class 8 Item Class 9 Rate   
TXRATE0810  BCD*8.5  Buyer Class 8 Item Class10 Rate   
TXRATE0901  BCD*8.5  Buyer Class 9 Item Class 1 Rate   
TXRATE0902  BCD*8.5  Buyer Class 9 Item Class 2 Rate   
TXRATE0903  BCD*8.5  Buyer Class 9 Item Class 3 Rate   
TXRATE0904  BCD*8.5  Buyer Class 9 Item Class 4 Rate   
TXRATE0905  BCD*8.5  Buyer Class 9 Item Class 5 Rate   
TXRATE0906  BCD*8.5  Buyer Class 9 Item Class 6 Rate   
TXRATE0907  BCD*8.5  Buyer Class 9 Item Class 7 Rate   
TXRATE0908  BCD*8.5  Buyer Class 9 Item Class 8 Rate   
TXRATE0909  BCD*8.5  Buyer Class 9 Item Class 9 Rate   
TXRATE0910  BCD*8.5  Buyer Class 9 Item Class10 Rate   
TXRATE1001  BCD*8.5  Buyer Class10 Item Class 1 Rate   
TXRATE1002  BCD*8.5  Buyer Class10 Item Class 2 Rate   
TXRATE1003  BCD*8.5  Buyer Class10 Item Class 3 Rate   
TXRATE1004  BCD*8.5  Buyer Class10 Item Class 4 Rate   
TXRATE1005  BCD*8.5  Buyer Class10 Item Class 5 Rate   
TXRATE1006  BCD*8.5  Buyer Class10 Item Class 6 Rate   
TXRATE1007  BCD*8.5  Buyer Class10 Item Class 7 Rate   
TXRATE1008  BCD*8.5  Buyer Class10 Item Class 8 Rate   
TXRATE1009  BCD*8.5  Buyer Class10 Item Class 9 Rate   
TXRATE1010  BCD*8.5  Buyer Class10 Item Class10 Rate   

This page was generated on 2009-Nov-19

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