# View: Tax State Details

RotoID: TX0014
Table: TXSTATED
Protocol: Detail, Ordered revisions
DLL: TXSTATED

## Compositions: 1

RotoID | Tables | Title | DLL
--- | --- | --- | ---
TX0013 | TXSTATEH | Tax State Headers | TXSTATEH

## Keys: 1

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

## Fields: 161

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
GROUPID | 1 | String*12 | Tax Group | E A K R | Mask: %-12N
TTYPE | 2 | Integer | Transaction Type | E A K R | List: 2 entries
1 | = | Sales
2 | = | Purchases
VERSION | 3 | Long | Version | E A K R |
TXAUTHNUM | 4 | Integer | Tax Authority Line Number | E A K R |
AUTHORITY | 5 | String*12 | Tax Authority | E A | Mask: %-12N
DESC | 6 | String*60 | Description | E A |
AUDITLEVEL | 7 | Integer | Report Level | E A | List: 2 entries
1 | = | At invoice level
0 | = | No reporting
TAXABLE | 8 | Integer | Taxable | E A | List: 2 entries
0 | = | No
1 | = | Yes
SURTAX | 9 | Integer | Surtax | E A | List: 2 entries
0 | = | No
1 | = | Yes
SURAUTH | 10 | String*12 | Surtax On Authority | E A | Mask: %-12N
MINTAX | 11 | BCD*10.3 | Maximum Tax Allowable | E A |
MAXTAX | 12 | BCD*10.3 | No Tax Charged Below | E A |
TXBASE | 13 | Integer | Tax Base | E A | List: 5 entries
1 | = | Selling price
2 | = | Standard cost
3 | = | Most recent cost
4 | = | Alternate amount 1
5 | = | Alternate amount 2
INCLUDABLE | 14 | Integer | Allow Tax In Price | E A | List: 2 entries
0 | = | No
1 | = | Yes
TXRTGCTL | 15 | Integer | Report Tax on Retainage Document | E A | List: 3 entries
0 | = | No Reporting
1 | = | At Time of Retainage Document
2 | = | At Time of Original Document
RECOVERABL | 16 | Integer | Tax Recoverable | E A | List: 2 entries
0 | = | No
1 | = | Yes
RATERECOV | 17 | BCD*8.5 | Recoverable Rate | E A |
ACCTRECOV | 18 | String*45 | Recoverable Tax Account | E A | Mask: %-45C
EXPSEPARTE | 19 | Integer | Expense Separately | E A | List: 2 entries
0 | = | No
1 | = | Yes
ACCTEXP | 20 | String*45 | Expense Account | E A | Mask: %-45C
LIABILITY | 21 | String*45 | Tax Liability Account | E A | Mask: %-45C
HCLASS01 | 22 | Integer | Header Class 1 | E A | List: 4 entries
0 | = | Undefined
1 | = | Exists
2 | = | Exempt
3 | = | Rates Defined
HCLASS02 | 23 | Integer | Header Class 2 | E A | List: 4 entries
0 | = | Undefined
1 | = | Exists
2 | = | Exempt
3 | = | Rates Defined
HCLASS03 | 24 | Integer | Header Class 3 | E A | List: 4 entries
0 | = | Undefined
1 | = | Exists
2 | = | Exempt
3 | = | Rates Defined
HCLASS04 | 25 | Integer | Header Class 4 | E A | List: 4 entries
0 | = | Undefined
1 | = | Exists
2 | = | Exempt
3 | = | Rates Defined
HCLASS05 | 26 | Integer | Header Class 5 | E A | List: 4 entries
0 | = | Undefined
1 | = | Exists
2 | = | Exempt
3 | = | Rates Defined
HCLASS06 | 27 | Integer | Header Class 6 | E A | List: 4 entries
0 | = | Undefined
1 | = | Exists
2 | = | Exempt
3 | = | Rates Defined
HCLASS07 | 28 | Integer | Header Class 7 | E A | List: 4 entries
0 | = | Undefined
1 | = | Exists
2 | = | Exempt
3 | = | Rates Defined
HCLASS08 | 29 | Integer | Header Class 8 | E A | List: 4 entries
0 | = | Undefined
1 | = | Exists
2 | = | Exempt
3 | = | Rates Defined
HCLASS09 | 30 | Integer | Header Class 9 | E A | List: 4 entries
0 | = | Undefined
1 | = | Exists
2 | = | Exempt
3 | = | Rates Defined
HCLASS10 | 31 | Integer | Header Class10 | E A | List: 4 entries
0 | = | Undefined
1 | = | Exists
2 | = | Exempt
3 | = | Rates Defined
DCLASS01 | 32 | Integer | Detail Class 1 | E A | List: 3 entries
0 | = | Undefined
1 | = | Exists
2 | = | Exempt
DCLASS02 | 33 | Integer | Detail Class 2 | E A | List: 3 entries
0 | = | Undefined
1 | = | Exists
2 | = | Exempt
DCLASS03 | 34 | Integer | Detail Class 3 | E A | List: 3 entries
0 | = | Undefined
1 | = | Exists
2 | = | Exempt
DCLASS04 | 35 | Integer | Detail Class 4 | E A | List: 3 entries
0 | = | Undefined
1 | = | Exists
2 | = | Exempt
DCLASS05 | 36 | Integer | Detail Class 5 | E A | List: 3 entries
0 | = | Undefined
1 | = | Exists
2 | = | Exempt
DCLASS06 | 37 | Integer | Detail Class 6 | E A | List: 3 entries
0 | = | Undefined
1 | = | Exists
2 | = | Exempt
DCLASS07 | 38 | Integer | Detail Class 7 | E A | List: 3 entries
0 | = | Undefined
1 | = | Exists
2 | = | Exempt
DCLASS08 | 39 | Integer | Detail Class 8 | E A | List: 3 entries
0 | = | Undefined
1 | = | Exists
2 | = | Exempt
DCLASS09 | 40 | Integer | Detail Class 9 | E A | List: 3 entries
0 | = | Undefined
1 | = | Exists
2 | = | Exempt
DCLASS10 | 41 | Integer | Detail Class10 | E A | List: 3 entries
0 | = | Undefined
1 | = | Exists
2 | = | Exempt
HCLS01DESC | 42 | String*60 | Header Class 1 Description | E A |
HCLS02DESC | 43 | String*60 | Header Class 2 Description | E A |
HCLS03DESC | 44 | String*60 | Header Class 3 Description | E A |
HCLS04DESC | 45 | String*60 | Header Class 4 Description | E A |
HCLS05DESC | 46 | String*60 | Header Class 5 Description | E A |
HCLS06DESC | 47 | String*60 | Header Class 6 Description | E A |
HCLS07DESC | 48 | String*60 | Header Class 7 Description | E A |
HCLS08DESC | 49 | String*60 | Header Class 8 Description | E A |
HCLS09DESC | 50 | String*60 | Header Class 9 Description | E A |
HCLS10DESC | 51 | String*60 | Header Class10 Description | E A |
DCLS01DESC | 52 | String*60 | Detail Class 1 Description | E A |
DCLS02DESC | 53 | String*60 | Detail Class 2 Description | E A |
DCLS03DESC | 54 | String*60 | Detail Class 3 Description | E A |
DCLS04DESC | 55 | String*60 | Detail Class 4 Description | E A |
DCLS05DESC | 56 | String*60 | Detail Class 5 Description | E A |
DCLS06DESC | 57 | String*60 | Detail Class 6 Description | E A |
DCLS07DESC | 58 | String*60 | Detail Class 7 Description | E A |
DCLS08DESC | 59 | String*60 | Detail Class 8 Description | E A |
DCLS09DESC | 60 | String*60 | Detail Class 9 Description | E A |
DCLS10DESC | 61 | String*60 | Detail Class10 Description | E A |
TXRATE0101 | 62 | BCD*8.5 | Buyer Class 1 Item Class 1 Rate | E A |
TXRATE0102 | 63 | BCD*8.5 | Buyer Class 1 Item Class 2 Rate | E A |
TXRATE0103 | 64 | BCD*8.5 | Buyer Class 1 Item Class 3 Rate | E A |
TXRATE0104 | 65 | BCD*8.5 | Buyer Class 1 Item Class 4 Rate | E A |
TXRATE0105 | 66 | BCD*8.5 | Buyer Class 1 Item Class 5 Rate | E A |
TXRATE0106 | 67 | BCD*8.5 | Buyer Class 1 Item Class 6 Rate | E A |
TXRATE0107 | 68 | BCD*8.5 | Buyer Class 1 Item Class 7 Rate | E A |
TXRATE0108 | 69 | BCD*8.5 | Buyer Class 1 Item Class 8 Rate | E A |
TXRATE0109 | 70 | BCD*8.5 | Buyer Class 1 Item Class 9 Rate | E A |
TXRATE0110 | 71 | BCD*8.5 | Buyer Class 1 Item Class10 Rate | E A |
TXRATE0201 | 72 | BCD*8.5 | Buyer Class 2 Item Class 1 Rate | E A |
TXRATE0202 | 73 | BCD*8.5 | Buyer Class 2 Item Class 2 Rate | E A |
TXRATE0203 | 74 | BCD*8.5 | Buyer Class 2 Item Class 3 Rate | E A |
TXRATE0204 | 75 | BCD*8.5 | Buyer Class 2 Item Class 4 Rate | E A |
TXRATE0205 | 76 | BCD*8.5 | Buyer Class 2 Item Class 5 Rate | E A |
TXRATE0206 | 77 | BCD*8.5 | Buyer Class 2 Item Class 6 Rate | E A |
TXRATE0207 | 78 | BCD*8.5 | Buyer Class 2 Item Class 7 Rate | E A |
TXRATE0208 | 79 | BCD*8.5 | Buyer Class 2 Item Class 8 Rate | E A |
TXRATE0209 | 80 | BCD*8.5 | Buyer Class 2 Item Class 9 Rate | E A |
TXRATE0210 | 81 | BCD*8.5 | Buyer Class 2 Item Class10 Rate | E A |
TXRATE0301 | 82 | BCD*8.5 | Buyer Class 3 Item Class 1 Rate | E A |
TXRATE0302 | 83 | BCD*8.5 | Buyer Class 3 Item Class 2 Rate | E A |
TXRATE0303 | 84 | BCD*8.5 | Buyer Class 3 Item Class 3 Rate | E A |
TXRATE0304 | 85 | BCD*8.5 | Buyer Class 3 Item Class 4 Rate | E A |
TXRATE0305 | 86 | BCD*8.5 | Buyer Class 3 Item Class 5 Rate | E A |
TXRATE0306 | 87 | BCD*8.5 | Buyer Class 3 Item Class 6 Rate | E A |
TXRATE0307 | 88 | BCD*8.5 | Buyer Class 3 Item Class 7 Rate | E A |
TXRATE0308 | 89 | BCD*8.5 | Buyer Class 3 Item Class 8 Rate | E A |
TXRATE0309 | 90 | BCD*8.5 | Buyer Class 3 Item Class 9 Rate | E A |
TXRATE0310 | 91 | BCD*8.5 | Buyer Class 3 Item Class10 Rate | E A |
TXRATE0401 | 92 | BCD*8.5 | Buyer Class 4 Item Class 1 Rate | E A |
TXRATE0402 | 93 | BCD*8.5 | Buyer Class 4 Item Class 2 Rate | E A |
TXRATE0403 | 94 | BCD*8.5 | Buyer Class 4 Item Class 3 Rate | E A |
TXRATE0404 | 95 | BCD*8.5 | Buyer Class 4 Item Class 4 Rate | E A |
TXRATE0405 | 96 | BCD*8.5 | Buyer Class 4 Item Class 5 Rate | E A |
TXRATE0406 | 97 | BCD*8.5 | Buyer Class 4 Item Class 6 Rate | E A |
TXRATE0407 | 98 | BCD*8.5 | Buyer Class 4 Item Class 7 Rate | E A |
TXRATE0408 | 99 | BCD*8.5 | Buyer Class 4 Item Class 8 Rate | E A |
TXRATE0409 | 100 | BCD*8.5 | Buyer Class 4 Item Class 9 Rate | E A |
TXRATE0410 | 101 | BCD*8.5 | Buyer Class 4 Item Class10 Rate | E A |
TXRATE0501 | 102 | BCD*8.5 | Buyer Class 5 Item Class 1 Rate | E A |
TXRATE0502 | 103 | BCD*8.5 | Buyer Class 5 Item Class 2 Rate | E A |
TXRATE0503 | 104 | BCD*8.5 | Buyer Class 5 Item Class 3 Rate | E A |
TXRATE0504 | 105 | BCD*8.5 | Buyer Class 5 Item Class 4 Rate | E A |
TXRATE0505 | 106 | BCD*8.5 | Buyer Class 5 Item Class 5 Rate | E A |
TXRATE0506 | 107 | BCD*8.5 | Buyer Class 5 Item Class 6 Rate | E A |
TXRATE0507 | 108 | BCD*8.5 | Buyer Class 5 Item Class 7 Rate | E A |
TXRATE0508 | 109 | BCD*8.5 | Buyer Class 5 Item Class 8 Rate | E A |
TXRATE0509 | 110 | BCD*8.5 | Buyer Class 5 Item Class 9 Rate | E A |
TXRATE0510 | 111 | BCD*8.5 | Buyer Class 5 Item Class10 Rate | E A |
TXRATE0601 | 112 | BCD*8.5 | Buyer Class 6 Item Class 1 Rate | E A |
TXRATE0602 | 113 | BCD*8.5 | Buyer Class 6 Item Class 2 Rate | E A |
TXRATE0603 | 114 | BCD*8.5 | Buyer Class 6 Item Class 3 Rate | E A |
TXRATE0604 | 115 | BCD*8.5 | Buyer Class 6 Item Class 4 Rate | E A |
TXRATE0605 | 116 | BCD*8.5 | Buyer Class 6 Item Class 5 Rate | E A |
TXRATE0606 | 117 | BCD*8.5 | Buyer Class 6 Item Class 6 Rate | E A |
TXRATE0607 | 118 | BCD*8.5 | Buyer Class 6 Item Class 7 Rate | E A |
TXRATE0608 | 119 | BCD*8.5 | Buyer Class 6 Item Class 8 Rate | E A |
TXRATE0609 | 120 | BCD*8.5 | Buyer Class 6 Item Class 9 Rate | E A |
TXRATE0610 | 121 | BCD*8.5 | Buyer Class 6 Item Class10 Rate | E A |
TXRATE0701 | 122 | BCD*8.5 | Buyer Class 7 Item Class 1 Rate | E A |
TXRATE0702 | 123 | BCD*8.5 | Buyer Class 7 Item Class 2 Rate | E A |
TXRATE0703 | 124 | BCD*8.5 | Buyer Class 7 Item Class 3 Rate | E A |
TXRATE0704 | 125 | BCD*8.5 | Buyer Class 7 Item Class 4 Rate | E A |
TXRATE0705 | 126 | BCD*8.5 | Buyer Class 7 Item Class 5 Rate | E A |
TXRATE0706 | 127 | BCD*8.5 | Buyer Class 7 Item Class 6 Rate | E A |
TXRATE0707 | 128 | BCD*8.5 | Buyer Class 7 Item Class 7 Rate | E A |
TXRATE0708 | 129 | BCD*8.5 | Buyer Class 7 Item Class 8 Rate | E A |
TXRATE0709 | 130 | BCD*8.5 | Buyer Class 7 Item Class 9 Rate | E A |
TXRATE0710 | 131 | BCD*8.5 | Buyer Class 7 Item Class10 Rate | E A |
TXRATE0801 | 132 | BCD*8.5 | Buyer Class 8 Item Class 1 Rate | E A |
TXRATE0802 | 133 | BCD*8.5 | Buyer Class 8 Item Class 2 Rate | E A |
TXRATE0803 | 134 | BCD*8.5 | Buyer Class 8 Item Class 3 Rate | E A |
TXRATE0804 | 135 | BCD*8.5 | Buyer Class 8 Item Class 4 Rate | E A |
TXRATE0805 | 136 | BCD*8.5 | Buyer Class 8 Item Class 5 Rate | E A |
TXRATE0806 | 137 | BCD*8.5 | Buyer Class 8 Item Class 6 Rate | E A |
TXRATE0807 | 138 | BCD*8.5 | Buyer Class 8 Item Class 7 Rate | E A |
TXRATE0808 | 139 | BCD*8.5 | Buyer Class 8 Item Class 8 Rate | E A |
TXRATE0809 | 140 | BCD*8.5 | Buyer Class 8 Item Class 9 Rate | E A |
TXRATE0810 | 141 | BCD*8.5 | Buyer Class 8 Item Class10 Rate | E A |
TXRATE0901 | 142 | BCD*8.5 | Buyer Class 9 Item Class 1 Rate | E A |
TXRATE0902 | 143 | BCD*8.5 | Buyer Class 9 Item Class 2 Rate | E A |
TXRATE0903 | 144 | BCD*8.5 | Buyer Class 9 Item Class 3 Rate | E A |
TXRATE0904 | 145 | BCD*8.5 | Buyer Class 9 Item Class 4 Rate | E A |
TXRATE0905 | 146 | BCD*8.5 | Buyer Class 9 Item Class 5 Rate | E A |
TXRATE0906 | 147 | BCD*8.5 | Buyer Class 9 Item Class 6 Rate | E A |
TXRATE0907 | 148 | BCD*8.5 | Buyer Class 9 Item Class 7 Rate | E A |
TXRATE0908 | 149 | BCD*8.5 | Buyer Class 9 Item Class 8 Rate | E A |
TXRATE0909 | 150 | BCD*8.5 | Buyer Class 9 Item Class 9 Rate | E A |
TXRATE0910 | 151 | BCD*8.5 | Buyer Class 9 Item Class10 Rate | E A |
TXRATE1001 | 152 | BCD*8.5 | Buyer Class10 Item Class 1 Rate | E A |
TXRATE1002 | 153 | BCD*8.5 | Buyer Class10 Item Class 2 Rate | E A |
TXRATE1003 | 154 | BCD*8.5 | Buyer Class10 Item Class 3 Rate | E A |
TXRATE1004 | 155 | BCD*8.5 | Buyer Class10 Item Class 4 Rate | E A |
TXRATE1005 | 156 | BCD*8.5 | Buyer Class10 Item Class 5 Rate | E A |
TXRATE1006 | 157 | BCD*8.5 | Buyer Class10 Item Class 6 Rate | E A |
TXRATE1007 | 158 | BCD*8.5 | Buyer Class10 Item Class 7 Rate | E A |
TXRATE1008 | 159 | BCD*8.5 | Buyer Class10 Item Class 8 Rate | E A |
TXRATE1009 | 160 | BCD*8.5 | Buyer Class10 Item Class 9 Rate | E A |
TXRATE1010 | 161 | BCD*8.5 | Buyer Class10 Item Class10 Rate | E A |

This page was generated on 2009-Nov-19

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