...
The reconciliation reports provide the individual and summary level financial transactions (Purchase Orders, PCards etc.transactions (Daily Revenue and Expense) of the departments, along with their reconciliation status. They are meant for internal use only and are not financial statements. . All transactions that do not have the source of "YTD" or "LTD" and do not have a fund code of "8000" are displayed. The departments are grouped under divisions.
| Table of Contents | ||
|---|---|---|
|
...
Report Elements Glossary Table
...
Report : Reconciled Transactions Report |
|---|
Prompts
Fiscal Year -> Division ->Department
Tab 1:
This report report provides the individual and summary level financial transactions (Daily Revenue and Expense) of the departments, along with their reconciliation status.
Filters
Report Elements
...
The table below lists all the elements used in the Reports.the reports. Detailed glossary entries for these elements can be found in the MetaMart (https://usfpro1.forest.usf.edu/pls/ax_repo/f?p=1056:1)
| Element | Source (System->Table->Column) | Description | Frequency of Update | |||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
| [Finance].[dbo].[REC_DivDepts]-> | ||||||||
| [FiscalYear] | This field holds the fiscal year. | Daily | ||||||
| ||||||||
| [Finance].[dbo].[REC_Divisions]->[DivID]/ DivName] | Division is a grouping of multiple departments and is sometimes referred to as the super department. | Daily | ||||||
| DEPTID DEPT_DESC | |||||||
[Finance].[dbo].[REC_DivDepts]->[Deptid] [Finance].[dbo].[REC_Rev_Expense]->Dept_DESC | This field holds the department ID and department description. | Daily | ||||||
| ||||||||
[Finance].[dbo].[REC_Rev_Expense]->REPORTING_PERIOD Calculated | This fields holds the fiscal month. | Daily | ||||||
| [Finance].[dbo].[REC_Rev_Expense]->[REVEXP_TYPE] | |||||||
| Values include Revenue or Expense | Daily | |||||||
| [Finance].[dbo].[REC_Rev_Expense]->[FUND_CODE | |||||||
| ] | This field identifies the fund code associated with a record. | Daily | ||||||
| [Finance].[dbo].[REC_Rev_Expense]->[FUND_DESC | |||||||
| ] | This field holds the fund description. | Daily | ||||||
| ||||||||
[Finance].[dbo].[REC_Rev_Expense]->[TRANS_DESC_RPT | ||||||||
] | This field holds the transaction description. | Daily | ||||||
| [Finance].[dbo].[REC_Rev_Expense]->[POSTED_DATE] | This field holds the posted date. | ||||||
| Daily | ||||||||
| [Finance].[dbo].[REC_Rev_Expense]->[DOC_NUM_1_RPT | |||||||
| ] | This field holds the Document Number 1 Report. | Daily | ||||||
| [Finance].[dbo].[REC_Rev_Expense]->[INVOICE | |||||||
| ] | This field identifies the invoice for Current Month records with a PIDM (P | Daily | ||||||
| [Finance].[dbo].[REC_Rev_Expense]->[ACTUAL_AMT | |||||||
| ] | This field contains the actual amount associated with a transaction. For Cash Total records, it is set to "0". | Daily | ||||||
| [Finance].[dbo].[REC_Rev_Expense]->[Reconciled | |||||||
| ] | Values are "Reconciled" or "Not Reconciled." | Daily | ||||||
Report Run Date
| ||||||||
| Calculated | Date that the report data was refreshed from its source. | Real Time |
...