Reconciliation Reports
The reconciliation reports provide the individual and summary level financial transactions (Purchase Orders, PCards etc.) of the departments. They are meant for internal use only and are not financial statements.
Report Elements Glossary Table
Report : Reconciled Transactions Report |
|---|
Prompts
Fiscal Year -> Division ->Department
Tab 1:
This report
Filters
Report Elements
The table below lists all the elements used in the Reports.
| Element | Source (System->Table->Column) | Description | Frequency of Update |
|---|---|---|---|
| Fiscal Year | [Finance].[dbo].[REC_DivDepts]->[FiscalYear] | ||
| Division | [Finance].[dbo].[REC_Divisions]->[DivID]/ DivName] | ||
| Department | [Finance].[dbo].[REC_DivDepts]->[Deptid] [Finance].[dbo].[REC_Rev_Expense]->Dept_DESC | ||
| Reporting Month | [Finance].[dbo].[REC_Rev_Expense]->REPORTING_PERIOD Calculated | ||
| Type | [Finance].[dbo].[REC_Rev_Expense]->[REVEXP_TYPE] | Values include Revenue or Expense | |
| Fund Code | [Finance].[dbo].[REC_Rev_Expense]->[FUND_CODE] | ||
| Fund Description | [Finance].[dbo].[REC_Rev_Expense]->[FUND_DESC] | ||
| Trans Description Report | [Finance].[dbo].[REC_Rev_Expense]->[TRANS_DESC_RPT] | ||
| Posted | [Finance].[dbo].[REC_Rev_Expense]->[POSTED_DATE] | ||
| Doc Num 1 Report | [Finance].[dbo].[REC_Rev_Expense]->[DOC_NUM_1_RPT] | ||
| Invoice | [Finance].[dbo].[REC_Rev_Expense]->[INVOICE] | ||
| Actual Amount | [Finance].[dbo].[REC_Rev_Expense]->[ACTUAL_AMT] | ||
| Reconciled | [Finance].[dbo].[REC_Rev_Expense]->[Reconciled] | ||
| Report Run Date | Date that the report data was refreshed from source | Real Time |