Table: Tax Tracking

Table: TXAUDH
View: TX0011
Record length: 370
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: 42

Field  Type  Title  Presentation 

SEQUENCE  BCD*10.0     
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
AUTHORITY  String*12  Tax Authority  Mask: %-12N
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*30  Country Code   
REPORTDATE  Date  Report Date   
DESCRIPTIO  String*60  Description   
ISFOREIGN  Boolean  Foreign Invoice   
HCURN  String*3  Home Currency Code  Mask: %-3N
RATETYPE  String*2  Rate Type  Mask: %-2N
SCURN  String*3  Source Currency Code  Mask: %-3N
RATEDATE  Date  Rate Date   
RATE  BCD*8.7  Rate   
CUSTVENDNM  String*60  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   
TCURN  String*3  Tax Reporting Currency Code  Mask: %-3N
TDECIMAL  Integer  Decimals in Tax Reporting Currency   
TRATETYPE  String*2  Tax Reporting Rate Type  Mask: %-2N
TRATEDATE  Date  Tax Reporting Rate Date   
TRATE  BCD*8.7  Tax Reporting Rate   
RATEOP  Integer  Rate Operation  List: 2 entries
1=Multiply
2=Divide
TRATEOP  Integer  Tax Reporting Rate Operation  List: 2 entries
1=Multiply
2=Divide
TRECOVRAMT  BCD*10.3  Recov. Amt in Tax Reporting Currency   

This page was generated on 2008-May-01

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