View: BAS Worksheet Detail Amounts

RotoID: TW0580
Table: TWTBOXD
Protocol: Detail, Ordered revisions
DLL:TWTBOXD

Compositions: 1

RotoID Tables Title DLL
TW0400 TWGBAS Generate BAS Worksheet TWGBAS

Keys: 1

Title Fields
Box Number/Detail Number FROMYEAR, FROMPERIOD, TOYEAR, TOPERIOD, BOX, DETAILNUM

Fields: 12

Field Index Type Title Attributes Presentation
FROMYEAR 1 String*4 From Fiscal Year E A K R 
FROMPERIOD 2 Integer From Fiscal Period E A K R 
TOYEAR 3 String*4 To Fiscal Year E A K R 
TOPERIOD 4 Integer To Fiscal Period E A K R 
BOX 5 Integer Box Number E A K R  List:17 entries
1 = G1 - Total Sales
2 = G2 - Export Sales
3 = G3 - Other GST-Free Sales
4 = G4 - Input Taxed Sales
5 = G7 - Sales Adjustments
6 = G10 - Capital Purchases
7 = G11 - Non-Capital Purchases
8 = G13 - Purchases for Making Input Taxes Sales
9 = G14 - GST-Free Purchases
10 = G15 - Estimated Purchases for Private Use
11 = G18 - Purchase Adjustments
16 = W1 - Total salary, wages and other payments
17 = W2 - Amount withheld from payments shown at W1
18 = W4 - Amount withheld where no ABN is quoted
19 = W3 - Other amounts withheld (excluding any amounts shown at W2 or W4)
20 = 5B - Credit from PAYG Income Tax Instalment Variation
21 = 7 - Deferred Company/Fund Instalment
DETAILNUM 6 BCD*10.0 Detail Line Number E A K R 
FROM 7 Integer From GL or TX? E A  List:2 entries
1 = General Ledger
2 = Tax Services
GLACCT 8 String*45 GL Account Number E A  Mask: %-45C
TAXAUTH 9 String*12 Tax Authority E A  Mask: %-12N
BUYERCLASS 10 Integer Customer/Vendor Tax Class E A 
ITEMCLASS 11 Integer Item Tax Class E A 
AMOUNT 12 BCD*10.3 Amount E A 

This page was generated on 2022-Aug-18

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