Main Finance views

Views have been created by the Synergetic development team to make querying the database an easier process. These views are either from the:

Finance database, as outlined below.
Main Synergetic database. See Main Synergetic views.

Additional data is sometimes also retrieved from the main Synergetic database to complement the Finance data.
Users will need to have security permission to the SynergyOneFinance database.

View name	Description	Base tables used
vAssets	Use this view to obtain listings of assets that exist within Asset Register Maintenance. For example, you could get a listing of all assets of a certain asset type: _{SELECT * FROM vAssets} _{WHERE AssetTypeCode = 'Car'}	Assets AssetDefinitions Community Addresses FinanceConfig tGeneralLedger luAssetCategory Creditors
vAssetDepreciation	Use this view to obtain: a list of assets for a depreciation posting the amount that they depreciated by.	vAssets AssetDepreciation GeneralLedgerPostingControl
vBankReconciliation	Use this view to list all unreconciled cheques that have not been cancelled. The Bank Reconciliation Crystal Report for example, uses this view by: getting the GeneralLedgerReportingMonthEndDate, defined in Finance Configuration Maintenance including any cheques or payments that have not yet been reconciled or cancelled before that date.	BankingConfig GeneralLedgerBankTransactions GeneralLedger FinanceConfig GeneralLedgerJournals GeneralLedgerPostingControl
vCashReceiptsEntry	Use this view to list all receipts that have been processed. The view includes: payment type origin amount.	GeneralLedgerJournals GeneralLedger luGeneralLedgerRcptAllocations Receipts Community Addresses GeneralLedgerPostingControl EnrolmentDeposits EnrolmentDepositDefinitions DonorReceipts luFund luAppeal Assets DebtorTransactions Debtors
vCreditorInvoiceEntry	Use this view to list all invoices that have been entered through Creditor Invoice Entry.	CreditorTransactions FinanceConfig Creditors Community GeneralLedgerJournals GeneralLedger GeneralLedgerPostingControl Assets EnrolmentDeposits Addresses EnrolmentRepairRepayments AssetDefinitions
vCreditorInvoices	Use this view to list all creditor invoices.	CreditorTransactions Creditors Community Addresses GeneralLedgerPostingControl
vCreditors	Use this view to list all current creditors and relevant information about them. This information comes straight from the base table so whatever is in Creditor Maintenance will appear in a listing with this view.	Creditors luCreditorSupplierCategory Community Addresses luCountry
vCreditorsAll	Use this view to list all creditors and the relevant information about them, including inactive creditors.	Creditors luCreditorSupplierCategory Community Addresses luCountry
vCreditorTransactions	Use this view to list all creditor invoices and payments. That is, transactions.	CreditorTransactions FinanceConfig Community Creditors Addresses GeneralLedger GeneralLedgerJournals GeneralLedgerPostingControl GeneralLedgerCostCentres
vDebtorActiveArrangements	Use this view to view active debtor arrangements. Includes: arrangements that are not yet complete the oldest outstanding transaction date all of the information from vDebtors, covered below.	vDebtors DebtorArrangements luDebtorArrangement
vDebtorInstalmentsStudents	Use this view to summarise debtor instalments. Includes: debtor information fee code total amount due or paid instalment setup details.	DebtorInstalments DebtorFees Community Addresses Debtors DebtorPaymentMethods
vDebtors	Use this view to list active debtor contact information, including: spouse contact details previous payment summary current balances.	Debtors Community Addresses DebtorSubLedgers CommunityAddressLinks FinanceConfig
vDebtorsAll	Use this view to list the contact information of all debtors, including inactive debtors. Contact information includes: spouse contact details previous payment summary current balances.	Debtors Community Addresses DebtorSubLedgers CommunityAddressLinks FinanceConfig
vDebtorStudentConcessions	Use this view to list all student concessions that are currently listed for the student and their related debtor. All data from the Concessions tab of Current Student Maintenance is included in the view. See Current Student Maintenance - Concessions tab in the Current students manual.	DebtorFees DebtorStudentConcessions vStudents
vDebtorTransactionAddress	Use this view to list all debtor charges and receipts.	Debtors DebtorTransactions Community Addresses DebtorFees GeneralLedgerPostingControl DebtorStatementControl
vEnrolmentDeposits	Use this view to list all current enrolment deposits, along with: student information contact or payee information.	EnrolmentDeposits EnrolmentDepositDefinitions PastStudents Students FutureStudents StudentSemester Community Addresses luCampus luTax
vFinanceReport	Use this view to get a hard-copy of any of your finance reports. For example, the G/L Finance Report Structure report primarily uses this view.	GeneralLedgerFinanceReports GeneralLedgerFinanceReportLinks luGeneralLedgerFinanceReport GeneralLedger
vGeneralLedgerJnlBudgetTotal	Use this view to list all account budgets against actual expenses.	GeneralLedger GeneralLedgerMonthlyBudgets GeneralLedgerJournals
vGeneralLedgerJournals	Use this view to list all journals that have been posted to the general ledger from any of the finance modules within Synergetic.	GeneralLedger GeneralLedgerJournals GeneralLedgerPostingControl GeneralLedgerCostCentres Community Addresses
vGLMonthlyMovementInColumns	Use this view to get total expenses for general ledger accounts in each period for the specified general ledger reporting year. The GLReportingGLYear value can be set on the General tab of Finance Configuration Maintenance. If required, change the G/L Reporting End Date field on the tab. See Synergetic Financial Configuration - General tab in the Finance manual.	GeneralLedger FinanceConfig GeneralLedgerJournals GeneralLedgerMonthlyBudgets
vGLMonthlyMovementInColumnsAllYears	Use this view to get total expenses for general ledger accounts in each period for each general ledger reporting year. The GLReportingGLYear value can be set on the General tab of Finance Configuration Maintenance. If required, change the G/L Reporting End Date field on the tab. See Synergetic Financial Configuration - General tab in the Finance manual.	GeneralLedger FinanceConfig GeneralLedgerCostCentres GeneralLedgerChartOfAccounts GeneralLedgerDivisions
vGLMonthlyMovementInColumnsAllYearsAllBudgets	Use this view to get: total expenses for general ledger accounts in each period for each general ledger reporting year budget information for each general ledger reporting year. The GLReportingGLYear value can be set on the General tab of Finance Configuration Maintenance. If required, change the G/L Reporting End Date field on the tab. See Synergetic Financial Configuration - General tab in the Finance manual.	GeneralLedger FinanceConfig GeneralLedgerCostCentres GeneralLedgerChartOfAccounts GeneralLedgerDivisions
vGLReportingMonthSummary	Use this view to show the following details for your general ledger accounts: opening balance year-to-date current and full year expense figures current and full year budget figures.	GeneralLedger FinanceConfig GeneralLedgerCostCentres
vItemSales	Use this view to list every sale made and the person or general ledger code that the item went to.	ItemSales ItemSalePayment SalesPaymentMethods Staff luItemCategory BusinessUnits Students ItemSaleDetails Community Items vDebtors GeneralLedgerPostingControl FutureStudents Community Addresses FinanceConfig ConfigUsers StudentYears GeneralLedger GeneralLedgerCostCentres
vItemStock	Use this view to list all active items and the amount of stock on hand at each business unit.	Items ItemStock CreditorTransactions Creditors GeneralLedgerPostingControl Community Addresses luItemCategory BusinessUnits
vItemStockAll	Use this view to list all items, including inactive items, and the amount of stock on hand at each business unit.	Items ItemStock CreditorTransactions Creditors GeneralLedgerPostingControl Community Addresses luItemCategory BusinessUnits
vPayrollEmployeePayDetails	Use this view to get pay details by line, for each employee's pay for a given pay posting.	PayrollEmployeePayDetails PayrollEmployees PayrollPayGroups PayrollCodeDefinitions GeneralLedgerPostingControl luPayrollSuperannuationFund Community luPayrollSuperannuationList Addresses FinanceConfig luPayrollPayFrequency refPayrollPayCodeType
vPayrollEmployeePayDetailTots	Use this view to get totals for each PayCode by posting number. This view is: useful for analysing an overall pay run not useful for individual employee totals used for the totals in the Payroll Journal Listing report.	PayrollEmployeePayDetails PayrollCodeDefinitions
vPayrollEmployees	Use this view to extract all payroll employee information. It: includes the year-to-date pay figure includes the total pay figure does not provide information about each line of pay. For information about each line of pay, see the vPayrollEmployeePayDetails view, covered earlier.	PayrollEmployees Community Addresses PayrollPayGroups luPayrollTaxationRate luPayrollPayFrequency PayrollEmployeePays GeneralLedgerPostingControl luPayrollEmployeeStatus Staff
vPurchaseOrders	Use this view to extract all of the details in Purchase Order Maintenance. Every purchase detail will return a record in a query from this view.	PurchaseOrders GeneralLedgerAllocationCodes BusinessUnits PurchaseOrderDetails Community Items Addresses FinanceConfig luDeliveryPoint luPurchaseOrderUrgency Staff Creditors