View: Generate BAS Worksheet

RotoID: TW0400
Table: TWGBAS
Protocol: Header
DLL:TWGBAS

Compositions: 1

RotoID Tables Title DLL
TW0580 TWTBOXD BAS Worksheet Detail Amounts TWTBOXD

Keys: 1

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

Fields: 78

Field Index Type Title Attributes Presentation
FROMYEAR 1 String*4 From Fiscal Year E A K R  Mask: %-4d
FROMPERIOD 2 Integer From Fiscal Period E A K P R 
TOYEAR 3 String*4 To Fiscal Year E A K R  Mask: %-4d
TOPERIOD 4 Integer To Fiscal Period E A K P R 
CALG1 5 BCD*10.3 Calculated G1 E A C 
PMG1 6 BCD*10.3 Plus OR Minus G1 E A 
CALG2 7 BCD*10.3 Calculated G2 E A C 
PMG2 8 BCD*10.3 Plus OR Minus G2 E A 
CALG3 9 BCD*10.3 Calculated G3 E A C 
PMG3 10 BCD*10.3 Plus OR Minus G3 E A 
CALG4 11 BCD*10.3 Calculated G4 E A C 
PMG4 12 BCD*10.3 Plus OR Minus G4 E A 
CALG7 13 BCD*10.3 Calculated G7 E A C 
PMG7 14 BCD*10.3 Plus OR Minus G7 E A 
CALG10 15 BCD*10.3 Calculated G10 E A C 
PMG10 16 BCD*10.3 Plus OR Minus G10 E A 
CALG11 17 BCD*10.3 Calculated G11 E A C 
PMG11 18 BCD*10.3 Plus OR Minus G11 E A 
CALG13 19 BCD*10.3 Calculated G13 E A C 
PMG13 20 BCD*10.3 Plus OR Minus G13 E A 
CALG14 21 BCD*10.3 Calculated G14 E A C 
PMG14 22 BCD*10.3 Plus OR Minus G14 E A 
CALG15 23 BCD*10.3 Calculated G15 E A C 
PMG15 24 BCD*10.3 Plus OR Minus G15 E A 
CALG18 25 BCD*10.3 Calculated G18 E A C 
PMG18 26 BCD*10.3 Plus OR Minus G18 E A 
CALW1 27 BCD*10.3 Calculated W1 E A C 
PMW1 28 BCD*10.3 Plus OR Minus W1 E A 
CALW2 29 BCD*10.3 Calculated W2 E A C 
PMW2 30 BCD*10.3 Plus OR Minus W2 E A 
CALW4 31 BCD*10.3 Calculated W4 E A C 
PMW4 32 BCD*10.3 Plus OR Minus W4 E A 
CALW3 33 BCD*10.3 Calculated W3 E A C 
PMW3 34 BCD*10.3 Plus OR Minus W3 E A 
CAL5B 35 BCD*10.3 Calculated 5B E A C 
PM5B 36 BCD*10.3 Plus OR Minus 5B E A 
CAL7 37 BCD*10.3 Calculated 7 E A C 
PM7 38 BCD*10.3 Plus OR Minus 7 E A 
TOTT7 39 BCD*10.3 Total T7 E A 
TOTT8 40 BCD*10.3 Total T8 E A 
TOTT9 41 BCD*10.3 Total T9 E A 
REASONT4 42 String*2 T4 Reason code for variation E A  Mask: %-2d
JSONFILE 43 String*255 JSON Audit File Name E A C 
TOTG1 75 BCD*10.3 Total G1 E A 
TOTG2 76 BCD*10.3 Total G2 E A 
TOTG3 77 BCD*10.3 Total G3 E A 
TOTG4 78 BCD*10.3 Total G4 E A 
TOTG7 79 BCD*10.3 Total G7 E A 
TOTG10 80 BCD*10.3 Total G10 E A 
TOTG11 81 BCD*10.3 Total G11 E A 
TOTG13 82 BCD*10.3 Total G13 E A 
TOTG14 83 BCD*10.3 Total G14 E A 
TOTG15 84 BCD*10.3 Total G15 E A 
TOTG18 85 BCD*10.3 Total G18 E A 
TOTW1 86 BCD*10.3 Total W1 E A 
TOTW2 87 BCD*10.3 Total W2 E A 
TOTW4 88 BCD*10.3 Total W4 E A 
TOTW3 89 BCD*10.3 Total W3 E A 
TOT5B 90 BCD*10.3 Total 5B E A 
TOT7 91 BCD*10.3 Total 7 E A 
TOTG5 92 BCD*10.3 G5 = G2 + G3 + G4 E A C 
TOTG6 93 BCD*10.3 G6 = G1 - G5 E A C 
TOTG8 94 BCD*10.3 G8 = G6 + G7 E A C 
TOTG9 95 BCD*10.3 G9 = G8 / 11 E A C 
TOTG12 96 BCD*10.3 G12 = G10 + G11 E A C 
TOTG16 97 BCD*10.3 G16 = G13 + G14 + G15 E A C 
TOTG17 98 BCD*10.3 G17 = G12 - G16 E A C 
TOTG19 99 BCD*10.3 G19 = G17 + G18 E A C 
TOTG20 100 BCD*10.3 G20 = G19 / 11 E A C 
TOTW5 101 BCD*10.3 W5 = W2 + W4 + W3 E A C 
TOT1A 102 BCD*10.3 1A = G9 E A C 
TOT1B 103 BCD*10.3 1B = G20 E A C 
TOT4 104 BCD*10.3 4 = W5 E A C 
TOT5A 105 BCD*10.3 5A = T7 or T9 if T9 is different than T7 E A C 
TOT8A 106 BCD*10.3 8A = 1A + 4 + 5A + 7 E A C 
TOT8B 107 BCD*10.3 8B = 1B + 5B E A C 
AGTB 108 Boolean Is 8A more than 8B? E A C 
TOT9 109 BCD*10.3 Total 9 E A C 

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