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 AUTHORITY, TYPE, FISCYEAR, FISCPERIOD, CUSTVEND, DOCDATE, SRCEAPP, DOCTYPE, DOCNUMBER, SEQUENCE
Tax Tracking by Customer/Vendor AUTHORITY, TYPE, CUSTVEND, DOCDATE, SRCEAPP, DOCTYPE, DOCNUMBER, SEQUENCE
Tax Tracking by Document Date AUTHORITY, TYPE, DOCDATE, BUYERCLASS

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 

This page was generated on 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).