Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

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 

Reporting Month

Report Elements

Type 

Fund Code

Fund Description

Trans Description Report

Posted

Doc Num 1 Report

Invoice

Actual Amount

Reconciled

The table below lists all the elements used in the Reports.

 

Element

Source

(System->Table->Column)

DescriptionFrequency of Update
Fiscal YearSid->  
Division   
Department

DEPTID

DEPT_DESC

  
Reporting Month   
TypeREVEXP_TYPE  
Fund CodeFUND_CODE  
Fund DescriptionFUND_DESC  
Trans Description Report

ACCOUNTING_PERIOD_BAL_CURR]
,[TRANS_DESC_RPT

  
PostedPOSTED_DATE  
Doc Num 1 ReportDOC_NUM_1_RPT  
InvoiceINVOICE  
Actual AmountACTUAL_AMT  
ReconciledReconciled  
Report Run Date  Date that the report data was refreshed from sourceReal Time

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  

  • No labels