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