Account Structure to be Used in MIS {MISTAB-6}

This menu option does not generate any figures, but rather generates a table that represents Account Structure. The Account Structure is defined in the Financial Code Structures option {FCSO-3} and can be used as an aid to represent data from the General Ledger in Trial Balance Format. No user selection is allowed in this report.

Subtotal Accounts and Header Accounts are not taken into consideration, but each Detail Account and Total Account is linked to the next Function Level Account of which it forms a part.

There are 10 columns, one column for each Function Level as well as a column for the Detail accounts, irrespective of Function Level. The data in this View can be joined to views with other Financial Data using the Detail Account Column. The other columns can then be then used to group data, where the column chosen depends on the Account Function Level on which data is required.

The corresponding ORACLE View is named M07v_Account_Structure and it contains the following columns:

A.    Row_Number.

This column contains a row number for the set of data as stored on the database.

B.    Detail_Account.

This column has the Account Numbers of all the Detail Accounts.

C.    Level_1_Account.

This column has the Account Numbers and Descriptions which would appear on a Function Level 1 Trial Balance corresponding to the Detail Accounts in the Detail_Account column.

D.    Level_2_Account.

This column has the Account Numbers and Descriptions which would appear on a Function Level 2 Trial Balance corresponding to the Detail Accounts in the Detail_Account column.

E.    Level_3_Account.

This column has the Account Numbers and Descriptions which would appear on a Function Level 3 Trial Balance corresponding to the Detail Accounts in the Detail_Account column.

F.    Level_4_Account.

This column has the Account Numbers and Descriptions which would appear on a Function Level 4 Trial Balance corresponding to the Detail Accounts in the Detail_Account column.

G.    Level_5_Account.

This column has the Account Numbers and Descriptions which would appear on a Function Level 5 Trial Balance corresponding to the Detail Accounts in the Detail_Account column.

H.    Level_6_Account.

This column has the Account Numbers and Descriptions which would appear on a Function Level 6 Trial Balance corresponding to the Detail Accounts in the Detail_Account column.

I.    Level_7_Account.

This column has the Account Numbers and Descriptions which would appear on a Function Level 7 Trial Balance corresponding to the Detail Accounts in the Detail_Account column.

J.    Level_8_Account.

This column has the Account Numbers and Descriptions which would appear on a Function Level 8 Trial Balance corresponding to the Detail Accounts in the Detail_Account column.

K.    Level_9_Account.

This column has the Account Numbers and Descriptions which would appear on a Function Level 9 Trial Balance corresponding to the Detail Accounts in the Detail_Account column.

User Selection	Prompt Text ^{* an item between square brackets [ ] is the default answer}	Type & Length	Comments
	None

Sort Order	Per	Comments
	None

System Select
	No special system selection

Example:

Processing Rules
	No special processing rules