Table: Tax Tracking

Table: TXAUDH
View: TX0011
Record Length: 398

Flags: A R 

Keys: 4

Title Flags Fields

Tax Tracking Sequence SEQUENCE
Tax Tracking by Fiscal Period AUTHORITYTYPEFISCYEARFISCPERIODCUSTVENDDOCDATESRCEAPPDOCTYPEDOCNUMBERSEQUENCE
Tax Tracking by Customer/Vendor D  AUTHORITYTYPECUSTVENDDOCDATESRCEAPPDOCTYPEDOCNUMBERSEQUENCE
Tax Tracking by Document Date D  AUTHORITYTYPEDOCDATEBUYERCLASS

Fields: 44

Field Type Title Presentation

SEQUENCE BCD*10.0 Sequence
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
SRCEDOCNUM String*22 Source Document Number
ID1099CLAS String*6 Withholding Tax 1099/CPRS Code