View: Tax Authorities

RotoID: TX0002
Table: TXAUTH
Protocol: Header
DLL:TXAUTH

Compositions: 1

RotoID Tables Title DLL

TX0001 TXCLASS Tax Classes TXCLASS

Keys: 1

Title Fields

Tax Authority AUTHORITY

Fields: 22

Field Index Type Title Attributes Presentation

AUTHORITY 1 String*12 Tax Authority E A K R  Mask: %-12N
DESC 2 String*60 Description E A 
SCURN 3 String*3 Tax Reporting Currency E A X  Mask: %-3N
MAXTAX 4 BCD*10.3 Maximum Tax Allowable E A 
MINTAX 5 BCD*10.3 No Tax Charged Below E A 
TXBASE 6 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 7 Boolean Allow Tax In Price E A  List:2 entries
0 = No
1 = Yes
LIABILITY 9 String*45 Tax Liability Account E A  Mask: %-45C
AUDITLEVEL 13 Integer Report Level E A  List:2 entries
1 = At invoice level
0 = No reporting
RECOVERABL 14 Boolean Tax Recoverable E A  List:2 entries
0 = No
1 = Yes
RATERECOV 15 BCD*8.5 Recoverable Rate E A 
ACCTRECOV 16 String*45 Recoverable Tax Account E A  Mask: %-45C
EXPSEPARTE 17 Boolean Expense Separately E A  List:2 entries
0 = No
1 = Yes
ACCTEXP 18 String*45 Expense Account E A  Mask: %-45C
LASTMAINT 19 Date Last Maintained A C 
TAXTYPE 20 Integer Tax Type E A  List:9 entries
10 = Federal Tax
20 = State Tax
30 = County Tax
40 = City Tax
0 = Other
60 = GST
70 = PST
80 = HST
90 = VAT
TXRTGCTL 21 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
REFNUMBER 22 String*60 Reference Number E A 
REFNAME 23 String*60 Reference Name E A 
ACCTWHT 24 String*45 Withholding Tax Account E A  Mask: %-45C
INPUTACCT 25 String*45 Reverse Charge Input Tax Account E A  Mask: %-45C
OUTPUTACCT 26 String*45 Reverse Charge Output Tax Account E A  Mask: %-45C