View: VAT Worksheet Detail Amounts

RotoID: TK0580
Table: TKTBOXD
Protocol: Detail, Ordered revisions
DLL:TKTBOXD

Compositions: 1

RotoID	Tables	Title	DLL

TK0400	TKGBAS	Generate VAT Worksheet	TKGBAS

Keys: 1

Title	Fields

Box Number/Detail Number	FROMDATE, TODATE, BOX, DETAILNUM

Fields: 11

Field

Index

Type

Title

Attributes

Presentation

FROMDATE

Date

From Date

E A K R

TODATE

Date

To Date

E A K R

BOX

Integer

Box Number

E A K R

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

E A K R

FROM

Integer

From GL or TX?

E A

List:2 entries

1	=	General Ledger
2	=	Tax Services

GLACCT

String*45

GL Account Number

E A

Mask: %-45C

TAXAUTH

String*12

Tax Authority

E A

Mask: %-12N

BUYERCLASS

Integer

Customer/Vendor Tax Class

E A

ITEMCLASS

Integer

Item Tax Class

E A

AMOUNT

BCD*10.3

Amount

E A

TTYPE

Integer

Transaction Type

E A

List:3 entries

1	=	Sales
2	=	Purchases
3	=	Not Applicable

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