Table: VAT Worksheet Detail Amounts

Table: TKTBOXD
View: TK0580
Record Length: 121

Flags: A R 

Keys: 1

Title Flags Fields
Box Number/Detail Number FROMDATE, TODATE, BOX, DETAILNUM

Fields: 15

Field Type Title Presentation
FROMDATE Date From Date
TODATE Date To Date
BOX Integer Box Number List:7 entries
1 = 1 - VAT due in this period on sales and other outputs
2 = 2 - VAT due in this period on acquisitions from other EC member states
4 = 4 - VAT reclaimed in this period on purchases and other inputs (including acquisitions from the EC)
6 = 6 - Total value of sales and all other outputs excluding any VAT
7 = 7 - Total value of purchases and all other inputs excluding any VAT
8 = 8 - Total sales of goods/related services, excluding VAT, to EC member states
9 = 9 - Total goods/related services acquisitions, excluding VAT, from EC member states
DETAILNUM BCD*10.0 Detail Line Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
FROM Integer From GL or TX? List:2 entries
1 = General Ledger
2 = Tax Services
GLACCT String*45 GL Account Number Mask: %-45C
TAXAUTH String*12 Tax Authority Mask: %-12N
BUYERCLASS Integer Customer/Vendor Tax Class
ITEMCLASS Integer Item Tax Class
AMOUNT BCD*10.3 Amount
TTYPE Integer Transaction Type List:3 entries
1 = Sales
2 = Purchases
3 = Not Applicable

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).