Table: Generate BAS Worksheet

Table: TWGBAS
View: TW0400
Record Length: 663

Flags: A R 

Keys: 1

Title Flags Fields
From/To Fiscal Year/Period FROMYEAR, FROMPERIOD, TOYEAR, TOPERIOD

Fields: 47

Field Type Title Presentation
FROMYEAR String*4 From Fiscal Year Mask: %-4d
FROMPERIOD Integer From Fiscal Period
TOYEAR String*4 To Fiscal Year Mask: %-4d
TOPERIOD Integer To Fiscal Period
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
CALG1 BCD*10.3 Calculated G1
PMG1 BCD*10.3 Plus OR Minus G1
CALG2 BCD*10.3 Calculated G2
PMG2 BCD*10.3 Plus OR Minus G2
CALG3 BCD*10.3 Calculated G3
PMG3 BCD*10.3 Plus OR Minus G3
CALG4 BCD*10.3 Calculated G4
PMG4 BCD*10.3 Plus OR Minus G4
CALG7 BCD*10.3 Calculated G7
PMG7 BCD*10.3 Plus OR Minus G7
CALG10 BCD*10.3 Calculated G10
PMG10 BCD*10.3 Plus OR Minus G10
CALG11 BCD*10.3 Calculated G11
PMG11 BCD*10.3 Plus OR Minus G11
CALG13 BCD*10.3 Calculated G13
PMG13 BCD*10.3 Plus OR Minus G13
CALG14 BCD*10.3 Calculated G14
PMG14 BCD*10.3 Plus OR Minus G14
CALG15 BCD*10.3 Calculated G15
PMG15 BCD*10.3 Plus OR Minus G15
CALG18 BCD*10.3 Calculated G18
PMG18 BCD*10.3 Plus OR Minus G18
CALW1 BCD*10.3 Calculated W1
PMW1 BCD*10.3 Plus OR Minus W1
CALW2 BCD*10.3 Calculated W2
PMW2 BCD*10.3 Plus OR Minus W2
CALW4 BCD*10.3 Calculated W4
PMW4 BCD*10.3 Plus OR Minus W4
CALW3 BCD*10.3 Calculated W3
PMW3 BCD*10.3 Plus OR Minus W3
CAL5B BCD*10.3 Calculated 5B
PM5B BCD*10.3 Plus OR Minus 5B
CAL7 BCD*10.3 Calculated 7
PM7 BCD*10.3 Plus OR Minus 7
TOTT7 BCD*10.3 Total T7
TOTT8 BCD*10.3 Total T8
TOTT9 BCD*10.3 Total T9
REASONT4 String*2 T4 Reason code for variation Mask: %-2d
JSONFILE String*255 JSON Audit File Name

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