View: Financial Report Information

RotoID: GL0031

Protocol: Superview
DLL:FRFISC

Keys: 1

Title Fields
Financial Account Number ACCTID, RPTYR, DESIGNATOR, CURID, CURTYPE

Fields: 228

Field Index Type Title Attributes Presentation
ACCTID 1 String*45 Account Number E A K R  Mask: %-45C
RPTYR 2 String*4 Reporting Year E A K R  Mask: %04D
DESIGNATOR 3 String*1 Fiscal Set Designator E A K R  List:11 entries
A = Actuals
Q = Quantity
R = Reporting
P = Provisional Actuals
O = Provisional Quantity
T = Provisional Reporting
1 = Budget 1
2 = Budget 2
3 = Budget 3
4 = Budget 4
5 = Budget 5
CURID 4 String*3 Currency Code E A K R  Mask: %-3N
CURTYPE 5 String*1 Currency Type E A K R  List:3 entries
S = Source
E = Equivalent
F = Functional
AMTTYPE 6 String*1 Fiscal Set Type E A 
RPTYROFF 7 Integer Reporting Year Offset E A 
RPTPERIOD 8 Integer Reporting Period E A 
BALP 9 BCD*10.3 Balance Current Period E A C 
BALLP 10 BCD*10.3 Balance Last Period E A C 
BAL1P 11 BCD*10.3 Balance Period 1 E A C 
BAL2P 12 BCD*10.3 Balance Period 2 E A C 
BAL3P 13 BCD*10.3 Balance Period 3 E A C 
BAL4P 14 BCD*10.3 Balance Period 4 E A C 
BAL5P 15 BCD*10.3 Balance Period 5 E A C 
BAL6P 16 BCD*10.3 Balance Period 6 E A C 
BAL7P 17 BCD*10.3 Balance Period 7 E A C 
BAL8P 18 BCD*10.3 Balance Period 8 E A C 
BAL9P 19 BCD*10.3 Balance Period 9 E A C 
BAL10P 20 BCD*10.3 Balance Period 10 E A C 
BAL11P 21 BCD*10.3 Balance Period 11 E A C 
BAL12P 22 BCD*10.3 Balance Period 12 E A C 
BAL13P 23 BCD*10.3 Balance Period 13 E A C 
BAL1PA 24 BCD*10.3 Balance 1 Period Ago E A C 
BAL2PA 25 BCD*10.3 Balance 2 Periods Ago E A C 
BAL3PA 26 BCD*10.3 Balance 3 Periods Ago E A C 
BAL4PA 27 BCD*10.3 Balance 4 Periods Ago E A C 
BAL5PA 28 BCD*10.3 Balance 5 Periods Ago E A C 
BAL6PA 29 BCD*10.3 Balance 6 Periods Ago E A C 
BAL7PA 30 BCD*10.3 Balance 7 Periods Ago E A C 
BAL8PA 31 BCD*10.3 Balance 8 Periods Ago E A C 
BAL9PA 32 BCD*10.3 Balance 9 Periods Ago E A C 
BAL10PA 33 BCD*10.3 Balance 10 Periods Ago E A C 
BAL11PA 34 BCD*10.3 Balance 11 Periods Ago E A C 
BAL12PA 35 BCD*10.3 Balance 12 Periods Ago E A C 
BAL13PA 36 BCD*10.3 Balance 13 Periods Ago E A C 
BALQ 37 BCD*10.3 Balance Current Quarter E A C 
BALLQ 38 BCD*10.3 Balance Last Quarter E A C 
BAL1Q 39 BCD*10.3 Balance Quarter 1 E A C 
BAL2Q 40 BCD*10.3 Balance Quarter 2 E A C 
BAL3Q 41 BCD*10.3 Balance Quarter 3 E A C 
BAL4Q 42 BCD*10.3 Balance Quarter 4 E A C 
BAL1QTD 43 BCD*10.3 Balance Quarter 1 to Date E A C 
BAL2QTD 44 BCD*10.3 Balance Quarter 2 to Date E A C 
BAL3QTD 45 BCD*10.3 Balance Quarter 3 to Date E A C 
BAL4QTD 46 BCD*10.3 Balance Quarter 4 to Date E A C 
BAL1QA 47 BCD*10.3 Balance 1 Quarter Ago E A C 
BAL2QA 48 BCD*10.3 Balance 2 Quarters Ago E A C 
BAL3QA 49 BCD*10.3 Balance 3 Quarters Ago E A C 
BAL4QA 50 BCD*10.3 Balance 4 Quarters Ago E A C 
BALS 51 BCD*10.3 Balance Current Half Year E A C 
BALLS 52 BCD*10.3 Balance Last Half Year E A C 
BAL1S 53 BCD*10.3 Balance Half Year 1 E A C 
BAL2S 54 BCD*10.3 Balance Half Year 2 E A C 
BAL1STD 55 BCD*10.3 Balance Half Year 1 to Date E A C 
BAL2STD 56 BCD*10.3 Balance Half Year 2 to Date E A C 
BAL1SA 57 BCD*10.3 Balance 1 Half Year Ago E A C 
BAL2SA 58 BCD*10.3 Balance 2 Half Years Ago E A C 
BALY 59 BCD*10.3 Balance Total Year E A C 
BALYTD 60 BCD*10.3 Balance Year to Date E A C 
BALOPEN 61 BCD*10.3 Balance Beginning of Year E A C 
NETP 62 BCD*10.3 Net Current Period E A C 
NETLP 63 BCD*10.3 Net Last Period E A C 
NET1P 64 BCD*10.3 Net Period 1 E A C 
NET2P 65 BCD*10.3 Net Period 2 E A C 
NET3P 66 BCD*10.3 Net Period 3 E A C 
NET4P 67 BCD*10.3 Net Period 4 E A C 
NET5P 68 BCD*10.3 Net Period 5 E A C 
NET6P 69 BCD*10.3 Net Period 6 E A C 
NET7P 70 BCD*10.3 Net Period 7 E A C 
NET8P 71 BCD*10.3 Net Period 8 E A C 
NET9P 72 BCD*10.3 Net Period 9 E A C 
NET10P 73 BCD*10.3 Net Period 10 E A C 
NET11P 74 BCD*10.3 Net Period 11 E A C 
NET12P 75 BCD*10.3 Net Period 12 E A C 
NET13P 76 BCD*10.3 Net Period 13 E A C 
NET1PA 77 BCD*10.3 Net 1 Period Ago E A C 
NET2PA 78 BCD*10.3 Net 2 Periods Ago E A C 
NET3PA 79 BCD*10.3 Net 3 Periods Ago E A C 
NET4PA 80 BCD*10.3 Net 4 Periods Ago E A C 
NET5PA 81 BCD*10.3 Net 5 Periods Ago E A C 
NET6PA 82 BCD*10.3 Net 6 Periods Ago E A C 
NET7PA 83 BCD*10.3 Net 7 Periods Ago E A C 
NET8PA 84 BCD*10.3 Net 8 Periods Ago E A C 
NET9PA 85 BCD*10.3 Net 9 Periods Ago E A C 
NET10PA 86 BCD*10.3 Net 10 Periods Ago E A C 
NET11PA 87 BCD*10.3 Net 11 Periods Ago E A C 
NET12PA 88 BCD*10.3 Net 12 Periods Ago E A C 
NET13PA 89 BCD*10.3 Net 13 Periods Ago E A C 
NETQ 90 BCD*10.3 Net Current Quarter E A C 
NETLQ 91 BCD*10.3 Net Last Quarter E A C 
NET1Q 92 BCD*10.3 Net Quarter 1 E A C 
NET2Q 93 BCD*10.3 Net Quarter 2 E A C 
NET3Q 94 BCD*10.3 Net Quarter 3 E A C 
NET4Q 95 BCD*10.3 Net Quarter 4 E A C 
NET1QTD 96 BCD*10.3 Net Quarter 1 to Date E A C 
NET2QTD 97 BCD*10.3 Net Quarter 2 to Date E A C 
NET3QTD 98 BCD*10.3 Net Quarter 3 to Date E A C 
NET4QTD 99 BCD*10.3 Net Quarter 4 to Date E A C 
NETPQ 100 BCD*10.3 Net Preceeding Quarter E A C 
NETPQ1PA 101 BCD*10.3 Net Preceeding Quarter 1P Ago E A C 
NETPQ2PA 102 BCD*10.3 Net Preceeding Quarter 2P Ago E A C 
NETPQ3PA 103 BCD*10.3 Net Preceeding Quarter 3P Ago E A C 
NETPQ4PA 104 BCD*10.3 Net Preceeding Quarter 4P Ago E A C 
NETPQ5PA 105 BCD*10.3 Net Preceeding Quarter 5P Ago E A C 
NETPQ6PA 106 BCD*10.3 Net Preceeding Quarter 6P Ago E A C 
NETPQ7PA 107 BCD*10.3 Net Preceeding Quarter 7P Ago E A C 
NETPQ8PA 108 BCD*10.3 Net Preceeding Quarter 8P Ago E A C 
NETPQ9PA 109 BCD*10.3 Net Preceeding Quarter 9P Ago E A C 
NETPQ10PA 110 BCD*10.3 Net Preceeding Quarter 10P Ago E A C 
NETPQ11PA 111 BCD*10.3 Net Preceeding Quarter 11P Ago E A C 
NETPQ12PA 112 BCD*10.3 Net Preceeding Quarter 12P Ago E A C 
NETPQ13PA 113 BCD*10.3 Net Preceeding Quarter 13P Ago E A C 
NET1QA 114 BCD*10.3 Net 1 Quarter Ago E A C 
NET2QA 115 BCD*10.3 Net 2 Quarters Ago E A C 
NET3QA 116 BCD*10.3 Net 3 Quarters Ago E A C 
NET4QA 117 BCD*10.3 Net 4 Quarters Ago E A C 
NETS 118 BCD*10.3 Net Current Half Year E A 
NETLS 119 BCD*10.3 Net Last Half Year E A 
NET1S 120 BCD*10.3 Net Half Year 1 E A 
NET2S 121 BCD*10.3 Net Half Year 2 E A 
NETPS 122 BCD*10.3 Net Preceeding Half Year E A 
NET1STD 123 BCD*10.3 Net Half Year 1 to Date E A 
NET2STD 124 BCD*10.3 Net Half Year 2 to Date E A 
NETPS1PA 125 BCD*10.3 Net Preceeding Half Year 1P Ago E A 
NETPS2PA 126 BCD*10.3 Net Preceeding Half Year 2P Ago E A 
NETPS3PA 127 BCD*10.3 Net Preceeding Half Year 3P Ago E A 
NETPS4PA 128 BCD*10.3 Net Preceeding Half Year 4P Ago E A 
NETPS5PA 129 BCD*10.3 Net Preceeding Half Year 5P Ago E A 
NETPS6PA 130 BCD*10.3 Net Preceeding Half Year 6P Ago E A 
NETPS7PA 131 BCD*10.3 Net Preceeding Half Year 7P Ago E A 
NETPS8PA 132 BCD*10.3 Net Preceeding Half Year 8P Ago E A 
NETPS9PA 133 BCD*10.3 Net Preceeding Half Year 9P Ago E A 
NETPS10PA 134 BCD*10.3 Net Preceeding Half Year 10P Ago E A 
NETPS11PA 135 BCD*10.3 Net Preceeding Half Year 11P Ago E A 
NETPS12PA 136 BCD*10.3 Net Preceeding Half Year 12P Ago E A 
NETPS13PA 137 BCD*10.3 Net Preceeding Half Year 13P Ago E A 
NET1SA 138 BCD*10.3 Net 1 Half Year Ago E A 
NET2SA 139 BCD*10.3 Net 2 Half Years Ago E A 
NETY 140 BCD*10.3 Net Total Year E A 
NETYTD 141 BCD*10.3 Net Year to Date E A 
NETPY 142 BCD*10.3 Net Preceeding Year E A 
NETPY1PA 143 BCD*10.3 Net Preceeding Year 1P Ago E A 
NETPY2PA 144 BCD*10.3 Net Preceeding Year 2P Ago E A 
NETPY3PA 145 BCD*10.3 Net Preceeding Year 3P Ago E A 
NETPY4PA 146 BCD*10.3 Net Preceeding Year 4P Ago E A 
NETPY5PA 147 BCD*10.3 Net Preceeding Year 5P Ago E A 
NETPY6PA 148 BCD*10.3 Net Preceeding Year 6P Ago E A 
NETPY7PA 149 BCD*10.3 Net Preceeding Year 7P Ago E A 
NETPY8PA 150 BCD*10.3 Net Preceeding Year 8P Ago E A 
NETPY9PA 151 BCD*10.3 Net Preceeding Year 9P Ago E A 
NETPY10PA 152 BCD*10.3 Net Preceeding Year 10P Ago E A 
NETPY11PA 153 BCD*10.3 Net Preceeding Year 11P Ago E A 
NETPY12PA 154 BCD*10.3 Net Preceeding Year 12P Ago E A 
NETPY13PA 155 BCD*10.3 Net Preceeding Year 13P Ago E A 
NETADJ 156 BCD*10.3 Net Adjustments E A 
BALCLOSE 157 BCD*10.3 Closing Balance E A 
NETCLOSE 158 BCD*10.3 Net Closing Amount E A 
BALQTD 159 BCD*10.3 Balance Quarter to Date E A 
BALLQTD 160 BCD*10.3 Balance Last Quarter to Date E A 
BAL1QATD 161 BCD*10.3 Balance 1 Quarter Ago to Date E A 
BAL2QATD 162 BCD*10.3 Balance 2 Quarters Ago to Date E A 
BAL3QATD 163 BCD*10.3 Balance 3 Quarters Ago to Date E A 
BAL4QATD 164 BCD*10.3 Balance 4 Quarters Ago to Date E A 
BALSTD 165 BCD*10.3 Balance Half Year to Date E A 
BALLSTD 166 BCD*10.3 Balance Last Half Year to Date E A 
BAL1SATD 167 BCD*10.3 Balance 1 Half Year Ago to Date E A 
BAL2SATD 168 BCD*10.3 Balance 2 Half Years Ago to Date E A 
NETQTD 169 BCD*10.3 Net Quarter to Date E A 
NETLQTD 170 BCD*10.3 Net Last Quarter to Date E A 
NET1QATD 171 BCD*10.3 Net 1 Quarter Ago to Date E A 
NET2QATD 172 BCD*10.3 Net 2 Quarters Ago to Date E A 
NET3QATD 173 BCD*10.3 Net 3 Quarters Ago to Date E A 
NET4QATD 174 BCD*10.3 Net 4 Quarters Ago to Date E A 
NETSTD 175 BCD*10.3 Net Half Year to Date E A 
NETLSTD 176 BCD*10.3 Net Last Half Year to Date E A 
NET1SATD 177 BCD*10.3 Net 1 Half Year Ago to Date E A 
NET2SATD 178 BCD*10.3 Net 2 Half Years Ago to Date E A 
BALPQ 179 BCD*10.3 Bal Preceeding Quarter E A 
BALPQ1PA 180 BCD*10.3 Bal Preceeding Quarter 1P Ago E A 
BALPQ2PA 181 BCD*10.3 Bal Preceeding Quarter 2P Ago E A 
BALPQ3PA 182 BCD*10.3 Bal Preceeding Quarter 3P Ago E A 
BALPQ4PA 183 BCD*10.3 Bal Preceeding Quarter 4P Ago E A 
BALPQ5PA 184 BCD*10.3 Bal Preceeding Quarter 5P Ago E A 
BALPQ6PA 185 BCD*10.3 Bal Preceeding Quarter 6P Ago E A 
BALPQ7PA 186 BCD*10.3 Bal Preceeding Quarter 7P Ago E A 
BALPQ8PA 187 BCD*10.3 Bal Preceeding Quarter 8P Ago E A 
BALPQ9PA 188 BCD*10.3 Bal Preceeding Quarter 9P Ago E A 
BALPQ10PA 189 BCD*10.3 Bal Preceeding Quarter 10P Ago E A 
BALPQ11PA 190 BCD*10.3 Bal Preceeding Quarter 11P Ago E A 
BALPQ12PA 191 BCD*10.3 Bal Preceeding Quarter 12P Ago E A 
BALPQ13PA 192 BCD*10.3 Bal Preceeding Quarter 13P Ago E A 
BALPS 193 BCD*10.3 Bal Preceeding Half Year E A 
BALPS1PA 194 BCD*10.3 Bal Preceeding Half Year 1P Ago E A 
BALPS2PA 195 BCD*10.3 Bal Preceeding Half Year 2P Ago E A 
BALPS3PA 196 BCD*10.3 Bal Preceeding Half Year 3P Ago E A 
BALPS4PA 197 BCD*10.3 Bal Preceeding Half Year 4P Ago E A 
BALPS5PA 198 BCD*10.3 Bal Preceeding Half Year 5P Ago E A 
BALPS6PA 199 BCD*10.3 Bal Preceeding Half Year 6P Ago E A 
BALPS7PA 200 BCD*10.3 Bal Preceeding Half Year 7P Ago E A 
BALPS8PA 201 BCD*10.3 Bal Preceeding Half Year 8P Ago E A 
BALPS9PA 202 BCD*10.3 Bal Preceeding Half Year 9P Ago E A 
BALPS10PA 203 BCD*10.3 Bal Preceeding Half Year 10P Ago E A 
BALPS11PA 204 BCD*10.3 Bal Preceeding Half Year 11P Ago E A 
BALPS12PA 205 BCD*10.3 Bal Preceeding Half Year 12P Ago E A 
BALPS13PA 206 BCD*10.3 Bal Preceeding Half Year 13P Ago E A 
BALPY 207 BCD*10.3 Bal Preceeding Year E A 
BALPY1PA 208 BCD*10.3 Bal Preceeding Year 1P Ago E A 
BALPY2PA 209 BCD*10.3 Bal Preceeding Year 2P Ago E A 
BALPY3PA 210 BCD*10.3 Bal Preceeding Year 3P Ago E A 
BALPY4PA 211 BCD*10.3 Bal Preceeding Year 4P Ago E A 
BALPY5PA 212 BCD*10.3 Bal Preceeding Year 5P Ago E A 
BALPY6PA 213 BCD*10.3 Bal Preceeding Year 6P Ago E A 
BALPY7PA 214 BCD*10.3 Bal Preceeding Year 7P Ago E A 
BALPY8PA 215 BCD*10.3 Bal Preceeding Year 8P Ago E A 
BALPY9PA 216 BCD*10.3 Bal Preceeding Year 9P Ago E A 
BALPY10PA 217 BCD*10.3 Bal Preceeding Year 10P Ago E A 
BALPY11PA 218 BCD*10.3 Bal Preceeding Year 11P Ago E A 
BALPY12PA 219 BCD*10.3 Bal Preceeding Year 12P Ago E A 
BALPY13PA 220 BCD*10.3 Bal Preceeding Year 13P Ago E A 
BUDGETSW 221 Integer Budget Opening Balance Switch E A 
QTYSW 222 Integer Quantity Opening Balance Switch E A 
GLPOSTFIL 223 String*1024 Additional FRTRN Filter E A 
ACCESSSW 224 Integer Table GLPOST Switch E A 
GETSW 225 Integer FRTRN Switch E A 
ACCTBAL 226 String*1 Account Bal of 1st FRTRN Record E A 
GLPOSTORD 227 Integer FRTRN Browsing Order E A 
ROLLUPSW 228 Integer Rollup Switch 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).