Consolidated CC Cost Report {MISTAB-3}

This menu option generates a summarized set of data that can be used for financial reporting. All transactions selected according to the selection criteria, except transactions in CT and SD not yet posted to the General Ledger, are considered.

The totals of each GLA within the specified Consolidation structure are stored.

The corresponding ORACLE View is named M09v_Consolidated_CC_Cost_Data and contains following columns:

A.    Request_Detail. The unique request number, user ID and the date when the particular set of data was generated.

B.    Request_Number. The unique request number.

C.    Header_1. Code and description of the Consolidation Cost Centre supplied as Selection Parameter.

D.    Header_2. Financial Year, Financial Cycle From, Financial Cycle To, Account From, Account To supplied as Selection Parameters.

E.    Header_3. Cycle 13 Included (Y/N), Cycle 14 Included (Y/N) supplied as Selection Parameters.

F.    Year_Entered_By_User. As per Selection Parameters.

G.    Financial_Cycles. As per Selection Parameters.

H.    Row_number. The rows in the summarized data set are numbered. This column indicates the row number.

I.    Cost_Center_Code. Cost Centre Code as defined in the Financial Code Structures {FCSO-1b1}

J.    Cost_Center_Name. Cost Centre Name as entered in the Financial Code Structures {FCSO-1b1}.

K.    Fund_Grp. Fund Group Code indicated on the Cost Centre Definition {FCSO-1b1} as defined in {FCSC-6}

L.    Dept_Code. Department Code indicated on the Cost Centre Definition {FCSO-1b1} as defined in the general system in option {GCS-4}

M.    Department_Name. The Name of the Department indicated on the Cost Centre Definition {FCSO-1b1} as entered in the general system
in option {GCS-4}

N.    Fact_School. The code of the Faculty or School indicated on the Department {GCS-4} as defined in option {GCS-3} of the general
system.

O.    Fact_School_Name. The name of the Faculty or School indicated on the Department {GCS-4} as entered in option {GCS-3} of the
general system.

P.    General_Ledger_Code. The code of the General Ledger indicated on the Cost Center Definition {FCSO-1b1} as defined in option
{FCSC-3} of the Financial Code Structures.

Q.    Vat_Regis. The VAT (Value Added Tax) Registration Number indicated on the Cost Center Definition {FCSO-1b1} as defined in option
{FCSC-1} of the Financial Code Structures.

R.    Vat_Code. The VAT (Value Added Tax) Rate Code indicated on the Cost Center Definition {FCSO-1b1} as defined in option {FCSC-2}
of the Financial Code Structures.

S.    Account_Number. The Account Number as defined in option {FCSO-3} of the Financial Code Structures.

T.    Account_Name. The name of the Account as entered in option {FCSO-3} of the Financial Code Structures.

U.    Account_Catg. The Account Category Code indicated on the Account Definition {FCSO-3} as defined in {FCSC-7} of the Financial
Code Structures.

V.    Account_Cat_Name. A combination of the Account Category Code and the Account Category Name indicated on the Account Definition
{FCSO-3} as defined in {FCSC-7}. The Account Category Code appears in front of the Name (with a zero added where less than 100) to facilitate sorting on this field.

W.    Account_Type. The Account Type indicated on the Account Category as defined in option {FCSC-7} of the Financial Code Structures.

X.    Sapse_Row_Code. The Sapse Row Code indicated on the Account Definition {FCSO-3}.

Y.    Actual_Debit. The sum of the values of Actual Debit Transactions for the GLA.

Z.    Actual_Credit. The sum of the values of Actual Credit Transactions for the GLA.

AA.    Budget_Debit. The sum of the values of Budget Debit Transactions for the GLA.

BB.    Budget_Credit. The sum of the values of Budget Credit Transactions for the GLA.

CC.    Commitments. The sum of the values of outstanding Commitments against the GLA.

DD.    Fin_Year. The Financial Year as indicated in the transaction record.

EE.    Fin_Cycle. The Financial Cycle as indicated in the transaction record.

User Selection	Prompt Text ^{* an item between square brackets [ ] is the default answer}	Type & Length	Comments
	(C)onsolidation Cc or Range of Cost Centres If (C) enter the Cost Centre Code If (R) Start/End Cost Centre Code	A1 A4 A4
	Start Account Code of ALL	N4
	Transaction Code or ALL	N4
	Financial Year of the Cost Report	YYYY
	Start Cycle	N2
	Up to which Cycle must be included in the Cost Report	N2

Sort Order	Per	Comments
	None

System Select
	No special system selection

Example:

Processing Rules
	No special processing rules