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