Table: Tax Tracking

Table: TXAUDH
View: TX0011
Record length: 260
Flags: A R 

Keys: 3


Title  Flags  Fields
Tax Tracking Sequence   SEQUENCE
Tax Tracking by Fiscal Period   AUTHORITY, TYPE, FISCYEAR, FISCPERIOD, CUSTVEND, DOCDATE, SRCEAPP, DOCTYPE, DOCNUMBER, SEQUENCE
Tax Tracking by Customer/Vendor   D  AUTHORITY, TYPE, CUSTVEND, DOCDATE, SRCEAPP, DOCTYPE, DOCNUMBER, SEQUENCE

Fields: 34


Field  Type  Title  Presentation 
SEQUENCE  BCD*10.0     
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
AUTHORITY  String*6  Tax Authority  Mask: %-6N
TYPE  Integer  Transaction Type  List: 2 entries
1=Sales
2=Purchases
FISCYEAR  String*4  Fiscal Year  Mask: %4D
FISCPERIOD  Integer  Fiscal Period  List: 12 entries
1= 1
2= 2
3= 3
4= 4
5= 5
6= 6
7= 7
8= 8
9= 9
10=10
11=11
12=12
CUSTVEND  String*12  Customer/Vendor ID   
DOCDATE  Date  Document Date   
SRCEAPP  String*2  Source Application   
DOCTYPE  String*2  Document Type   
DOCNUMBER  String*22  Document No.   
POSTDATE  Date  Posting Date   
BUYERCLASS  Integer  Cust/Vend Tax Class   
COUNTRY  String*20  Country Code   
REPORTDATE  Date  Report Date   
DESCRIPTIO  String*30  Description   
ISFOREIGN  Boolean  Foreign Invoice   
HCURN  String*3  Home Currency Code  Mask: %-3N
RATETYPE  String*2  Rate Type   
SCURN  String*3  Source Currency Code  Mask: %-3N
RATEDATE  Date  Rate Date   
RATE  BCD*8.7  Rate   
CUSTVENDNM  String*30  Customer/Vendor Name   
SDECIMAL  Integer  Decimals in Source Currency   
SINVAMT  BCD*10.3  Invoice Amt in Source Currency   
HINVAMT  BCD*10.3  Invoice Amt in Func. Currency   
RECOVERABL  Boolean  Recoverable   
EXPSEPARTE  Boolean  Expense Separately   
RATERECOV  BCD*8.5  Recoverable Rate   
SRECOVRAMT  BCD*10.3  Recov. Amt in Source Currency   
HRECOVRAMT  BCD*10.3  Recov. Amt in Func. Currency   

This page was generated on 2003-Apr-12

Copyright © 2002 ACCPAC International, Inc. All rights reserved.