Financial Report per Report Structure {MISTAB-10}

This menu option summarises Financial Data in exactly the same way as {FGLOR1-10} prints it.

The option is for use with the Executive Web System
 
 

User Selection	Prompt Text * an item between square brackets [ ] is the default answer	Type & Length	Comments
	Report Code	A2
	Financial Year	YYYY

 
 

Sort Order	Per	Comments

System Select
	No special system selection

The data is available using the ORACLE View named Mw1v_All_Cross_Tables where the column program number is 17. The columns of the view should be interpreted as follows

A.	Program_Number. The number of the program that generated the data. For this program it will always be 17.
B.	Request_Number. The unique request number.
C.	Date_Changed. The date on which the set of data for the request number was last updated.
D.	Original_User. The user who generated the set of data.
E.	Header_1. Will always be “Financial Report per Reporting Structure”.
F.	Header_2. Will indicate for Report Code as entered in the user selection.
G.	Header_3. Will indicate the Fianacial Year and the Start and End Cycles.
H.	Header_4. Will indicate whether cycles 13 and 14 are included.
I.	Row_Number. A sequential row number.
J.	Row_Description_Line_1. The row number of the report as set up in the reporting structure.
K.	Row_Description_Line_2. The description of the row as set up in the reporting structure.
L.	Description_Line_3. The note linked to the row in the reporting structure.
M.	Column_Number. The column number as set up in the reporting structure.
N.	Numerical_Decimal_Field. The amount.