View: Tax Tracking

RotoID: TX0011
Table: TXAUDH
Protocol: Header, Key auto generate
DLL:TXAUDH

Compositions: 1

RotoID Tables Title DLL

TX0012 TXAUDD Tax Tracking Item Class TXAUDD

Keys: 4

Title Fields

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

Fields: 40

Field Index Type Title Attributes Presentation

SEQUENCE 1 BCD*10.0 Sequence E A K R 
AUTHORITY 2 String*12 Tax Authority E A  Mask: %-12N
TYPE 3 Integer Transaction Type E A  List:2 entries
1 = Sales
2 = Purchases
FISCYEAR 4 String*4 Fiscal Year E A  Mask: %4D
FISCPERIOD 5 Integer Fiscal Period E A  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 6 String*12 Customer/Vendor ID E A 
DOCDATE 7 Date Document Date E A 
SRCEAPP 8 String*2 Source Application E A 
DOCTYPE 9 String*2 Document Type E A 
DOCNUMBER 10 String*22 Document No. E A 
POSTDATE 11 Date Posting Date E A 
BUYERCLASS 12 Integer Cust/Vend Tax Class E A 
COUNTRY 13 String*30 Country Code E A 
REPORTDATE 14 Date Report Date E A 
DESCRIPTIO 15 String*60 Description E A 
ISFOREIGN 16 Boolean Foreign Invoice E A 
HCURN 17 String*3 Home Currency Code E A  Mask: %-3N
RATETYPE 18 String*2 Rate Type E A  Mask: %-2N
SCURN 19 String*3 Source Currency Code E A  Mask: %-3N
RATEDATE 20 Date Rate Date E A 
RATE 21 BCD*8.7 Rate E A 
CUSTVENDNM 22 String*60 Customer/Vendor Name E A 
SDECIMAL 23 Integer Decimals in Source Currency E A 
SINVAMT 24 BCD*10.3 Invoice Amt in Source Currency E A 
HINVAMT 25 BCD*10.3 Invoice Amt in Func. Currency E A 
RECOVERABL 26 Boolean Recoverable E A 
EXPSEPARTE 27 Boolean Expense Separately E A 
RATERECOV 28 BCD*8.5 Recoverable Rate E A 
SRECOVRAMT 29 BCD*10.3 Recov. Amt in Source Currency E A 
HRECOVRAMT 30 BCD*10.3 Recov. Amt in Func. Currency E A 
TCURN 31 String*3 Tax Reporting Currency Code E A  Mask: %-3N
TDECIMAL 32 Integer Decimals in Tax Reporting Currency E A 
TRATETYPE 33 String*2 Tax Reporting Rate Type E A  Mask: %-2N
TRATEDATE 34 Date Tax Reporting Rate Date E A 
TRATE 35 BCD*8.7 Tax Reporting Rate E A 
RATEOP 36 Integer Rate Operation E A  List:2 entries
1 = Multiply
2 = Divide
TRATEOP 37 Integer Tax Reporting Rate Operation E A  List:2 entries
1 = Multiply
2 = Divide
TRECOVRAMT 38 BCD*10.3 Recov. Amt in Tax Reporting Currency E A 
SRCEDOCNUM 39 String*22 Source Document Number E A 
ID1099CLAS 40 String*6 Withholding Tax 1099/CPRS Code E A