# 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 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.