Table: Tax Authorities

Table: TXAUTH
View: TX0002
Record length: 375
Flags: A R 

Keys: 1

Title  Flags  Fields

Tax Authority  AUTHORITY

Fields: 25

Field  Type  Title  Presentation 

AUTHORITY  String*12  Tax Authority  Mask: %-12N
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
DESC  String*60  Description   
SCURN  String*3  Tax Reporting Currency  Mask: %-3N
MAXTAX  BCD*10.3  Maximum Tax Allowable   
MINTAX  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  Boolean  Allow Tax In Price  List: 2 entries
0=No
1=Yes
LIABTIMING  Integer     
LIABILITY  String*45  Tax Liability Account  Mask: %-45C
DEFER  String*45     
DEFERRECOV  String*45     
DISCBASE  Boolean     
AUDITLEVEL  Integer  Report Level  List: 2 entries
1=At invoice level
0=No reporting
RECOVERABL  Boolean  Tax Recoverable  List: 2 entries
0=No
1=Yes
RATERECOV  BCD*8.5  Recoverable Rate   
ACCTRECOV  String*45  Recoverable Tax Account  Mask: %-45C
EXPSEPARTE  Boolean  Expense Separately  List: 2 entries
0=No
1=Yes
ACCTEXP  String*45  Expense Account  Mask: %-45C
LASTMAINT  Date  Last Maintained   
TAXTYPE  Integer  Tax Type  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  Integer  Report Tax on Retainage Document  List: 3 entries
0=No Reporting
1=At Time of Retainage Document
2=At Time of Original Document

This page was generated on 2008-May-01

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