Tables


Database Analysis of Synergetic_AUVIC_CDA_PROD1.finance

Generated on Fri Sep 04 11:41 AEST 2020

XML Representation
Insertion Order Deletion Order
TABLES 233
VIEWS 292
COLUMNS 14983
Constraints 75

Database Properties

Database Type: Microsoft SQL Server - 13.00.4001

Tables

Table / View Children Parents Columns Rows Type Comments
Agents 0 1 4 -1 Table
AssetDefinitions 1 0 10 -1 Table
AssetDefinitionsHistory 0 0 14 -1 Table
AssetDepreciation 0 1 9 -1 Table
Assets 1 1 44 -1 Table
AssetsArchive 0 0 43 -1 Table
BankingConfig 4 0 36 -1 Table
BankingConfigLog 0 0 8 -1 Table
BankStatementControl 5 1 16 -1 Table
BankStatementTransactions 0 1 15 -1 Table
BankStatementTransactionsXRef 0 1 6 -1 Table
BusinessUnitGLClassification 0 0 5 -1 Table
BusinessUnitItemCategories 0 1 7 -1 Table
BusinessUnits 6 0 107 -1 Table
BusinessUnitUsers 0 0 5 -1 Table
BusinessUnitUsersHistory 0 0 10 -1 Table
ConfigFin 0 0 16 -1 Table
ConfigFinHistory 0 0 16 -1 Table
ConfigHistory 0 0 16 -1 Table
Creditors 4 1 43 -1 Table
CreditorsHistory 0 0 44 -1 Table
CreditorTransactions 1 1 37 -1 Table
CreditorTransactionsDeleted 0 0 31 -1 Table
CreditorTransactionsHistory 0 0 38 -1 Table
CreditorTransactionsXref 0 0 4 -1 Table
DebtorArrangements 0 0 12 -1 Table
DebtorBalances 0 0 20 -1 Table
DebtorFeeAutoTuitionPeriods 0 1 3 -1 Table
DebtorFeeGeneralLedger 0 0 7 -1 Table
DebtorFees 3 0 27 -1 Table
DebtorFeesHistory 0 0 31 -1 Table
DebtorInstalments 0 0 22 -1 Table
DebtorInstalmentsArchive 0 0 17 -1 Table
DebtorInstalmentsHistory 0 0 22 -1 Table
DebtorOverdueLetterHistory 0 0 14 -1 Table
DebtorOverdueLetterHistoryArch 0 0 14 -1 Table
DebtorPaymentMethods 0 2 19 -1 Table
DebtorPaymentMethodsArchive 0 0 16 -1 Table
DebtorPaymentMethodsHistory 0 0 23 -1 Table
DebtorPaymentMethodsOnline 0 2 30 -1 Table
DebtorPaymentMethodsOnlineHistory 0 0 32 -1 Table
Debtors 14 0 63 -1 Table
DebtorsArchive 0 0 64 -1 Table
DebtorsAutoTuitionDefinition 0 0 8 -1 Table
DebtorsHistory 0 0 64 -1 Table
DebtorSplitPayments 0 0 8 -1 Table
DebtorSplitPaymentsArchive 0 0 8 -1 Table
DebtorsSalesBusinessUnits 0 3 4 -1 Table
DebtorStatementBalances 0 3 20 -1 Table
DebtorStatementBalancesArch 0 0 20 -1 Table
DebtorStatementBalancesRecipients 0 0 10 -1 Table
DebtorStatementControl 1 0 77 -1 Table
DebtorStatementRecipients 0 2 10 -1 Table
DebtorStatementRecipientsArch 0 0 9 -1 Table
DebtorStatementRecipientsHistory 0 0 14 -1 Table
DebtorStudentConcessions 0 0 11 -1 Table
DebtorStudentConcessionsHistory 0 0 15 -1 Table
DebtorSubLedgers 0 0 27 0 View
DebtorTransactionGeneralLedger 0 2 9 -1 Table
DebtorTransactionGeneralLedgerArchive 0 0 9 -1 Table
DebtorTransactions 2 7 28 -1 Table
DebtorTransactionsArchive 0 0 28 -1 Table
DebtorTransactionsDeleted 0 0 31 -1 Table
DebtorTransactionsHistory 0 0 28 -1 Table
DebtorTransactionsXref 0 1 9 -1 Table
DebtorTransactionsXrefArchive 0 0 9 -1 Table
DebtorTransactionsXRefHistory 0 0 11 -1 Table
DebtorVoluntaryContributionPlan 0 0 15 -1 Table
EnrolmentDepositDefinitions 1 0 9 -1 Table
EnrolmentDepositRepayments 0 0 11 -1 Table
EnrolmentDepositRepaySelect 0 0 10 -1 Table
EnrolmentDeposits 0 1 26 -1 Table
FinanceConfig 0 3 242 -1 Table
FinanceConfigLog 0 0 7 -1 Table
GeneralLedger 0 0 31 0 View
GeneralLedgerAllocationCodes 1 0 6 -1 Table
GeneralLedgerAllocationLinks 0 0 4 -1 Table
GeneralLedgerBankTransactions 0 1 19 -1 Table
GeneralLedgerBudgetUsers 0 0 7 -1 Table
GeneralLedgerChartOfAccounts 1 0 9 -1 Table
GeneralLedgerChartOfAccountsHistory 0 0 12 -1 Table
GeneralLedgerCostCentres 1 1 8 -1 Table
GeneralLedgerCostCentresHistory 0 0 11 -1 Table
GeneralLedgerDivisions 1 0 3 -1 Table
GeneralLedgerFinanceReportLinks 0 8 9 -1 Table
GeneralLedgerFinanceReports 8 0 15 -1 Table
GeneralLedgerJournals 1 3 47 -1 Table
GeneralLedgerJournalsDeleted 0 0 37 -1 Table
GeneralLedgerJournalsTransferDefinition 0 0 7 -1 Table
GeneralLedgerJournalsUpdated 0 0 35 -1 Table
GeneralLedgerLinks 0 0 3 -1 Table
GeneralLedgerMonthlyBudgets 0 0 23 0 View
GeneralLedgerPostingControl 5 0 33 -1 Table
GeneralLedgerPostingControlHistory 0 0 36 -1 Table
GeneralLedgerPostingControlPrints 0 0 8 -1 Table
GeneralLedgerPostingControlRelatedPostings 0 0 2 -1 Table
GeneralLedgerUsers 0 0 2 -1 Table
GeneralLedgerUsersHistory 0 0 8 -1 Table
InvoiceConfig 0 0 6 -1 Table
Invoices 0 0 12 -1 Table
ItemCategoryPriceGroups 0 1 6 -1 Table
ItemConsignmentPayments 0 1 10 -1 Table
ItemCreditors 0 1 5 -1 Table
ItemPriceGroups 3 0 10 -1 Table
ItemPriceGroupsConstituencies 0 1 5 -1 Table
ItemReceipts 0 2 22 -1 Table
Items 4 0 16 -1 Table
ItemSaleCloseOffReceiptPostingControl 2 1 4 -1 Table
ItemSaleCloseOffReceiptPostingControlCurrency 0 2 4 -1 Table
ItemSaleDetails 0 3 19 -1 Table
ItemSalePayments 0 1 29 -1 Table
ItemSales 2 0 11 -1 Table
ItemStock 5 2 21 -1 Table
ItemStockPrices 0 2 5 -1 Table
ItemStocktake 0 2 8 -1 Table
LookupTableComment 0 0 5 -1 Table
LookupTableControl 0 0 9 -1 Table
LookupTableHistory 0 0 6 -1 Table
PABXCalls 0 0 11 -1 Table
PaymentGatewayLog 0 0 30 -1 Table
PayrollCodeDefinitions 0 0 38 0 View
PayrollCodeDefinitionsEvents 0 0 20 0 View
PayrollCodeDefinitionsHistory 0 0 33 0 View
PayrollEarnersLevy 0 0 4 -1 Table
PayrollEarnersLevyHistory 0 0 8 -1 Table
PayrollEmployeeDeclaration 0 0 66 0 View
PayrollEmployeeDeclarationHistory 0 0 56 0 View
PayrollEmployeeFTEHistory 0 0 6 -1 Table
PayrollEmployeeLeaveApplications 0 0 11 -1 Table
PayrollEmployeeLeaveApplicationsHistory 0 0 15 -1 Table
PayrollEmployeeLeaveEntHist 0 0 14 -1 Table
PayrollEmployeeLeaveEntitles 0 0 10 -1 Table
PayrollEmployeeLeaveHistory 0 0 11 0 View
PayrollEmployeeLeaveRate 0 0 6 0 View
PayrollEmployeePayDetailBackPays 0 0 17 0 View
PayrollEmployeePayDetails 0 0 22 0 View
PayrollEmployeePayDetailsHistory 0 0 25 0 View
PayrollEmployeePayMethods 0 0 10 0 View
PayrollEmployeePayMethodsHistory 0 0 13 0 View
PayrollEmployeePays 0 0 37 0 View
PayrollEmployeePaysHistory 0 0 39 0 View
PayrollEmployees 0 0 57 0 View
PayrollEmployeesHistory 0 0 52 0 View
PayrollEmployeeStandardPayDetails 0 0 34 0 View
PayrollEmployeeStandardPayDetailsEvents 0 0 33 0 View
PayrollEmployeeStandardPayDetailsEventsVirtual 0 0 23 0 View
PayrollEmployeeStandardPayDetailsHistory 0 0 37 0 View
PayrollEmployeeStandardPayMethods 0 0 10 0 View
PayrollEmployeeStandardPayMethodsHistory 0 0 14 0 View
PayrollEmployeeSuperannuationAttribute 0 0 9 0 View
PayrollEmployeeSuperannuationAttributeHistory 0 0 14 0 View
PayrollEmployeeSuperannuationFund 0 0 25 0 View
PayrollEmployeeSuperannuationFundHistory 0 0 25 0 View
PayrollEncryptedKeys 0 0 5 -1 Table
PayrollGovtSubmission 0 0 20 0 View
PayrollGovtSubmissionApproval 0 1 7 -1 Table
PayrollGovtSubmissionApprovalHistory 0 0 5 -1 Table
PayrollGovtSubmissionEmployee 0 0 15 0 View
PayrollGovtSubmissionEmployeeHistory 0 0 16 0 View
PayrollGovtSubmissionEventLog 0 0 8 -1 Table
PayrollGovtSubmissionHistory 0 0 21 0 View
PayrollGovtSubmissionStatus 0 0 9 -1 Table
PayrollHECSTaxationRates 0 0 5 -1 Table
PayrollHECSTaxationRatesHistory 0 0 9 -1 Table
PayrollInUseRegister 0 1 5 -1 Table
PayrollLeaveAwardDefinitions 0 2 8 -1 Table
PayrollLeaveAwardDefinitionsHistory 0 0 12 -1 Table
PayrollLeaveAwards 2 0 13 -1 Table
PayrollLeaveAwardsHistory 0 0 17 -1 Table
PayrollLeaveCategoryDays 0 0 3 -1 Table
PayrollPayGroups 0 0 4 -1 Table
PayrollPostingControl 3 0 31 -1 Table
PayrollPostingControlHistory 0 0 35 -1 Table
PayrollRebates 0 0 6 -1 Table
PayrollRebatesHistory 0 0 10 -1 Table
PayrollSuperContributionTaxationRates 0 0 3 -1 Table
PayrollSuperContributionTaxationRatesHistory 0 0 7 -1 Table
PayrollTaxationRates 0 0 6 -1 Table
PayrollTaxationRatesHistory 0 0 10 -1 Table
PayrollUpdatePostingEmployee 0 1 3 -1 Table
PortalPaymentPlansSelections 0 2 14 -1 Table
PurchaseOrderApproval 0 0 14 -1 Table
PurchaseOrderAuthoriserLevel 0 0 11 -1 Table
PurchaseOrderAuthoriserLevelApproval 0 0 10 -1 Table
PurchaseOrderDetails 0 1 31 -1 Table
PurchaseOrderDetailsHistory 0 0 35 -1 Table
PurchaseOrders 1 1 34 -1 Table
PurchaseOrdersHistory 0 0 34 -1 Table
PurchaseOrdersRequisitionHold 0 0 36 -1 Table
PurchaseOrderStatusHistory 0 0 5 -1 Table
pvAddressesArchive 0 0 59 0 View
pvAssetsQuantitySummarise 0 0 30 0 View
pvBusinessUnits 0 0 108 0 View
pvCEOVICDebtorTransactions 0 0 27 0 View
pvCommunityAddresses 0 0 136 0 View
pvCommunityAddressesArchive 0 0 153 0 View
pvCommunityAddressesFinance 0 0 135 0 View
pvCommunityAddressLinks 0 0 36 0 View
pvCommunityArchive 0 0 137 0 View
pvConfig 0 0 17 0 View
pvConfigGroupSecurity 0 0 14 0 View
pvConfigUserGroups 0 0 2 0 View
pvConfigUsers 0 0 43 0 View
pvConstituencies 0 0 13 0 View
pvCourseAgentCommissionControl 0 0 4 0 View
pvCourseAgentCommissionRules 0 0 5 0 View
pvCreditorAddresses 0 0 57 0 View
pvCreditorPayments 0 0 13 0 View
pvCreditorPaymentSelection 0 0 22 0 View
pvCreditors 0 0 49 0 View
pvCreditorTransactions 0 0 51 0 View
pvCreditorTransactionsWithBank 0 0 68 0 View
pvCurrentPayrollGovtSubmission 0 0 12 0 View
pvDebtorArrangements 0 0 15 0 View
pvDebtorFeeAutoTuitionPeriods 0 0 3 0 View
pvDebtorFeesLinkedToEnrolmentDeposits 0 0 6 0 View
pvDebtorGLReceipts 0 0 23 0 View
pvDebtorNames 0 0 8 0 View
pvDebtors 0 0 92 0 View
pvDebtorStatementControl 0 0 81 0 View
pvDebtorStatementEmailContentType 0 0 2 0 View
pvDebtorStatementRecipients 0 0 23 0 View
pvDebtorStatementRecipientsNoAddress 0 0 9 0 View
pvDebtorTransactionsWithPrepaid 0 0 26 0 View
pvDonorPledges 0 0 24 0 View
pvDonorReceipts 0 0 25 0 View
pvEnrolDepositStudentDetails 0 0 12 0 View
pvEnrolmentDepositRepaySelectActive 0 0 10 0 View
pvFileSemesters 0 0 18 0 View
pvFinalStatesPayrollGovtSubmissionStatus 0 0 3 0 View
pvFutureStudentContacts 0 0 12 0 View
pvFutureStudentNames 0 0 21 0 View
pvFutureStudents 0 0 131 0 View
pvGeneralLedgerJournals 0 0 71 0 View
pvGeneralLedgerMonthlyBudgets 0 0 25 0 View
pvGeneralLedgerPostingControl 0 0 34 0 View
pvGeneralLedgerPostingControlRelatedPostings 0 0 3 0 View
pvGetDate 0 0 3 0 View
pvItemCreditors 0 0 9 0 View
pvItemPriceGroupsConstituencies 0 0 6 0 View
pvItemPriceGroupsWithConstits 0 0 13 0 View
pvItemSaleNames 0 0 13 0 View
pvItemSalePayments 0 0 47 0 View
pvItemStockPrices 0 0 27 0 View
pvItemStocktake 0 0 15 0 View
pvluAppeal 0 0 10 0 View
pvluBank 0 0 6 0 View
pvluBankStateBranch 0 0 11 0 View
pvluBoarder 0 0 6 0 View
pvluCampus 0 0 18 0 View
pvluCountry 0 0 10 0 View
pvluDebtorCashPrepaidGeneralLedger 0 0 13 0 View
pvluDebtorFeeCategory 0 0 7 0 View
pvluEthnicGroup 0 0 8 0 View
pvluExchangeScheme 0 0 8 0 View
pvluFileType 0 0 13 0 View
pvluForm 0 0 11 0 View
pvluFrequency 0 0 9 0 View
pvluFund 0 0 9 0 View
pvluIndigenousGroup 0 0 8 0 View
pvluPayrollTaxationRate 0 0 10 0 View
pvluStudentEligibility 0 0 8 0 View
pvluStudentStatus 0 0 6 0 View
pvluStudentVerificationDocument 0 0 8 0 View
pvluTransport 0 0 11 0 View
pvluTuitionSiblingDiscount 0 0 7 0 View
pvluTuitionVariation 0 0 8 0 View
pvluYearlevel 0 0 39 0 View
pvMessageLog 0 0 10 0 View
pvPastStudentContacts 0 0 12 0 View
pvPastStudents 0 0 44 0 View
pvPastStudentsOriginal 0 0 108 0 View
pvPastStudentYears 0 0 53 0 View
pvPastStudentYearsNZMOERollReturn 0 0 37 0 View
pvPayrollCalcEmployeeWeeklyEarningsHistory 0 0 24 0 View
pvPayrollDateBase 0 0 2 0 View
pvPayrollEmployeeLeaveEntitleAll 0 0 14 0 View
pvPayrollEmployeeLeaveRatePayloadXML 0 0 21 0 View
pvPayrollEmployeePaysXML 0 0 3 0 View
pvPayrollEmployeeReportingCategoryTotals 0 0 5 0 View
pvPayrollEmployeeSuperannuationExportStandardValues 0 0 74 0 View
pvPayrollEmployeeSuperannuationFund 0 0 25 0 View
pvPayrollGovtSubmissionAll 0 0 21 0 View
pvPayrollGovtSubmissionApprovalXML 0 0 9 0 View
pvPayrollGovtSubmissionEmployeeAll 0 0 13 0 View
pvPayrollGovtSubmissionEmployeeAllowancesXML 0 0 10 0 View
pvPayrollGovtSubmissionEmployeeDeductionsXML 0 0 8 0 View
pvPayrollGovtSubmissionEmployeeETPCXML 0 0 12 0 View
pvPayrollGovtSubmissionEmployeeXML 0 0 66 0 View
pvPayrollGovtSubmissionStatus 0 0 13 0 View
pvPayrollGovtSubmissionXML 0 0 32 0 View
pvPayrollPostingControl 0 0 73 0 View
pvPurchaseOrderDetails 0 0 43 0 View
pvReceipts 0 0 43 0 View
pvrefLUFieldMeaning 0 0 5 0 View
pvRefModule 0 0 8 0 View
pvrefPayrollPayCodeType 0 0 8 0 View
pvSchool 0 0 29 0 View
pvSequence 0 0 1 0 View
pvStaff 0 0 64 0 View
pvStudentClasses 0 0 34 0 View
pvStudentContacts 0 0 14 0 View
pvStudentCourseCharges 0 0 9 0 View
pvStudentCourseChargesFinancial 0 0 12 0 View
pvStudentCourses 0 0 39 0 View
pvStudentCoursesFinancial 0 0 38 0 View
pvStudentNames 0 0 34 0 View
pvStudents 0 0 108 0 View
pvStudentsDebtorStudentID 0 0 108 0 View
pvStudentSemester 0 0 49 0 View
pvStudentStatic 0 0 67 0 View
pvStudentTransport 0 0 23 0 View
pvStudentYears 0 0 54 0 View
pvStudentYearsNZMOERollReturn 0 0 37 0 View
pvSubjectClasses 0 0 46 0 View
pvSynDatabaseLocalFinance 0 0 7 0 View
pvSynDatabases 0 0 57 0 View
pvSystemObjectHistory 0 0 11 0 View
pvSystemProcessControl 0 0 10 0 View
pvTags 0 0 3 0 View
pvTimeSheets 0 0 17 0 View
pvvCommunityQualifications 0 0 59 0 View
pvvCommunitySkills 0 0 50 0 View
pvvStaff 0 0 90 0 View
pvvStaffJobPositions 0 0 64 0 View
pvvStudentContactAddress 0 0 200 0 View
pvvStudentCountByFamily 0 0 2 0 View
pvvStudents 0 0 195 0 View
pvwkCreditorTransactions 0 0 52 0 View
pvwkDebtorFeeGeneralLedger 0 0 12 0 View
pvwkDebtorTransactionAllocations 0 0 22 0 View
pvwkDebtorTransactions 0 0 16 0 View
pvxfrGeneralLedgerPostingControl 0 0 8 0 View
pvxiDebtorCharges 0 0 17 0 View
Receipts 0 1 39 -1 Table
ReceiptsDeleted 0 0 42 -1 Table
ReceiptsHistory 0 0 42 -1 Table
SalesPaymentMethods 0 1 13 -1 Table
SynDatabaseLocal 0 0 8 -1 Table
tGeneralLedger 2 2 31 -1 Table
tGeneralLedgerHistory 0 0 29 -1 Table
tGeneralLedgerMonthlyBudgets 0 0 13 -1 Table
tPayrollCodeDefinitions 1 1 32 -1 Table
tPayrollCodeDefinitionsEvents 0 0 13 -1 Table
tPayrollCodeDefinitionsHistory 0 0 36 -1 Table
tPayrollEmployeeDeclaration 0 0 52 -1 Table
tPayrollEmployeeDeclarationHistory 0 0 54 -1 Table
tPayrollEmployeeEventsPays 0 0 3 -1 Table
tPayrollEmployeeLeaveRate 0 0 7 -1 Table
tPayrollEmployeeLeaveTransactions 0 0 16 -1 Table
tPayrollEmployeePayDetailBackPays 0 0 9 -1 Table
tPayrollEmployeePayDetails 0 0 21 -1 Table
tPayrollEmployeePayDetailsHistory 0 0 25 -1 Table
tPayrollEmployeePayMethods 0 0 10 -1 Table
tPayrollEmployeePayMethodsHistory 0 0 14 -1 Table
tPayrollEmployeePays 0 0 36 -1 Table
tPayrollEmployeePaysHistory 0 0 38 -1 Table
tPayrollEmployees 2 0 53 -1 Table
tPayrollEmployeesHistory 0 0 53 -1 Table
tPayrollEmployeeStandardPayDetails 0 2 34 -1 Table
tPayrollEmployeeStandardPayDetailsEvents 0 0 14 -1 Table
tPayrollEmployeeStandardPayDetailsHistory 0 0 36 -1 Table
tPayrollEmployeeStandardPayMethods 0 0 10 -1 Table
tPayrollEmployeeStandardPayMethodsHistory 0 0 14 -1 Table
tPayrollEmployeeSuperannuationAttribute 0 1 7 -1 Table
tPayrollEmployeeSuperannuationAttributeHistory 0 0 11 -1 Table
tPayrollEmployeeSuperannuationFund 2 2 26 -1 Table
tPayrollEmployeeSuperannuationFundHistory 0 0 28 -1 Table
tPayrollGovtSubmission 2 1 11 -1 Table
tPayrollGovtSubmissionEmployee 0 1 10 -1 Table
tPayrollGovtSubmissionEmployeeHistory 0 0 11 -1 Table
tPayrollGovtSubmissionHistory 0 0 12 -1 Table
vAssetDepreciation 0 0 79 0 View
vAssets 0 0 73 0 View
vAssetSchedulePriorYear 0 0 64 0 View
vBankReconciliation 0 0 14 0 View
vCashJournalDetails 0 0 13 0 View
vCashJournals 0 0 9 0 View
vCashReceiptsEntry 0 0 106 0 View
vCommunityAddresses 0 0 212 0 View
vCommunityAddressesCurrentUser 0 0 136 0 View
vCommunityAddressesFinance 0 0 131 0 View
vCreditorInvoiceEntry 0 0 72 0 View
vCreditorInvoices 0 0 32 0 View
vCreditors 0 0 62 0 View
vCreditorsAll 0 0 60 0 View
vCreditorsWithTransactions 0 0 24 0 View
vCreditorTransactions 0 0 55 0 View
vCreditorTransactionsAll 0 0 42 0 View
vDebtorActiveArrangements 0 0 92 0 View
vDebtorAgedReceipts 0 0 9 0 View
vDebtorArrearsBroughtForward 0 0 10 0 View
vDebtorCashMisallocatedReceipts 0 0 113 0 View
vDebtorChargesCreditAllocations 0 0 24 0 View
vDebtorChargesxRefCredits 0 0 19 0 View
vDebtorChargesXRefReceipts 0 0 37 0 View
vDebtorFees 0 0 35 0 View
vDebtorInstalmentsInitialStatement 0 0 22 0 View
vDebtorInstalmentsInitialStatementRecipients 0 0 27 0 View
vDebtorInstalmentsStudents 0 0 65 0 View
vDebtorMultipleActiveArrangements 0 0 6 0 View
vDebtorOverdueLetters 0 0 13 0 View
vDebtorOverdueLettersAllRecipients 0 0 19 0 View
vDebtorPrepaidSchoolFeesCurrentYear 0 0 17 0 View
vDebtorPrepaidSchoolFeesNextYear 0 0 13 0 View
vDebtorReceiptAllocations 0 0 26 0 View
vDebtorReceiptGeneralLedgerAllocations 0 0 32 0 View
vDebtorReceiptsModifiedDeleted 0 0 14 0 View
vDebtors 0 0 101 0 View
vDebtorsAll 0 0 103 0 View
vDebtorSplitPayments 0 0 201 0 View
vDebtorStuConcessionsApplied 0 0 38 0 View
vDebtorStudentConcessions 0 0 26 0 View
vDebtorTransactionAddress 0 0 107 0 View
vDebtorTransactionGLJournals 0 0 98 0 View
vDebtorTransactionsProjectedInstalments 0 0 43 0 View
vDonationReceipts 0 0 23 0 View
vEnrolmentDeposits 0 0 93 0 View
vFinanceConfig 0 0 3 0 View
vFinanceReport 0 0 33 0 View
vFinanceReportCashJournals 0 0 24 0 View
vGeneralLedger 0 0 43 0 View
vGeneralLedgerBankTransactions 0 0 22 0 View
vGeneralLedgerBudgetCurrentUser 0 0 6 0 View
vGeneralLedgerBudgetUsersDefault 0 0 7 0 View
vGeneralLedgerGovernmentReturn 0 0 21 0 View
vGeneralLedgerJnlBudgetTotal 0 0 8 0 View
vGeneralLedgerJournalReceipts 0 0 64 0 View
vGeneralLedgerJournals 0 0 52 0 View
vGeneralLedgerSubAllocationBalances 0 0 47 0 View
vGLCashAccountingAdjustments 0 0 4 0 View
vGLCashJournalDetails 0 0 16 0 View
vGLDepartmentExpenseReport 0 0 70 0 View
vGLFinanceReportJournals 0 0 68 0 View
vGLFinanceReportLinks 0 0 22 0 View
vGLMonthlyMovementInColumns 0 0 31 0 View
vGLMonthlyMovementInColumnsAllYears 0 0 50 0 View
vGLMonthlyMovementInColumnsAllYearsAllBudgets 0 0 50 0 View
vGLReportingMonthSummary 0 0 20 0 View
vGLSecurity 0 0 2 0 View
vItemSalePayments 0 0 40 0 View
vItemSalePaymentsWithChange 0 0 20 0 View
vItemSales 0 0 170 0 View
vItemSalesGLJournals 0 0 170 0 View
vItemSalesNoPayments 0 0 5 0 View
vItemsSeq 0 0 14 0 View
vItemStock 0 0 37 0 View
vItemStockAll 0 0 38 0 View
vItemStockPrices 0 0 40 0 View
vItemStockPricesForID 0 0 21 0 View
vLoginName 0 0 5 0 View
VoluntaryContributionPlan 0 0 6 -1 Table
VoluntaryContributionPlanOption 0 0 12 -1 Table
vPABXCalls 0 0 69 0 View
vPayCodeTotalsByEmployee 0 0 17 0 View
vPayrollCodeDefinitions 0 0 39 0 View
vPayrollEmpAnnSalWithSuperPct 0 0 22 0 View
vPayrollEmployeeCurrentDetails 0 0 15 0 View
vPayrollEmployeeLeaveAwardCurrent 0 0 2 0 View
vPayrollEmployeeLeaveEntitles 0 0 40 0 View
vPayrollEmployeeLeaveSummary 0 0 27 0 View
vPayrollEmployeeLeaveTransactions 0 0 24 0 View
vPayrollEmployeePayDetailFullGL 0 0 13 0 View
vPayrollEmployeePayDetails 0 0 71 0 View
vPayrollEmployeePayDetailTots 0 0 7 0 View
vPayrollEmployeePayTotals 0 0 119 0 View
vPayrollEmployees 0 0 72 0 View
vPayrollEmployeesFTECurrent 0 0 6 0 View
vPayrollEmployeeStandardPayMethods 0 0 13 0 View
vPayrollEmployeeStdPayDetails 0 0 68 0 View
vPayrollEmployeeSuperPayDetails 0 0 53 0 View
vPayrollJournalListing 0 0 90 0 View
vPayrollJournalListingSimple 0 0 27 0 View
vPayrollLeaveDetails 0 0 43 0 View
vPayrollPaydayEmploymentInformation 0 0 49 0 View
vPayrollPaySlip 0 0 72 0 View
vPurchaseOrderAuthorisers 0 0 3 0 View
vPurchaseOrderDetailGLBudgets 0 0 8 0 View
vPurchaseOrderDetailsSecure 0 0 31 0 View
vPurchaseOrders 0 0 80 0 View
vPurchaseOrdersSummary 0 0 32 0 View
vPurchaseOrderStatusHistory 0 0 7 0 View
vReportFooterFinance 0 0 3 0 View
vSchoolDetailsFinance 0 0 14 0 View
vSchoolEntityDetails 0 0 15 0 View
vTagsOwn 0 0 10 0 View
vUserDatabaseObjectPermissions 0 0 6 0 View
vwkDebtorBalances 0 0 19 0 View
wkAssets 0 0 28 -1 Table
wkBankStatementTransactions 1 1 17 -1 Table
wkBankStatementTransactionsXRef 0 3 8 -1 Table
wkBarcodePrintQueue 0 0 6 -1 Table
wkCreditorAllocGL 0 0 19 -1 Table
wkCreditorTransactions 0 0 38 -1 Table
wkCrystalLogins 0 0 3 0 View
wkDebtorBalances 0 0 18 -1 Table
wkDebtorElectronicReceiptsExceptions 0 0 10 -1 Table
wkDebtorFeeGeneralLedger 0 0 12 -1 Table
wkDebtorInstalments 0 0 6 -1 Table
wkDebtorStatementDebtors 0 0 5 -1 Table
wkDebtorStatementRecipients 0 0 17 -1 Table
wkDebtorStatementTransactions 0 0 37 -1 Table
wkDebtorTransactionAllocations 0 0 22 -1 Table
wkDebtorTransactions 0 0 14 -1 Table
wkEnrolmentDepositRepayments 0 0 12 -1 Table
wkEnrolmentDeposits 0 0 20 -1 Table
wkGeneralLedgerAutoCreate 0 0 3 -1 Table
wkGeneralLedgerBankTransactions 1 0 22 -1 Table
wkGeneralLedgerJournals 0 0 24 -1 Table
wkInvoiceJournals 0 0 14 -1 Table
wkItemReceipts 0 0 16 -1 Table
wkPayrollLogins 0 0 3 -1 Table
wkPurchaseOrderDetails 0 0 34 -1 Table
wkReceiptAllocDebtors 0 0 11 -1 Table
wkReceiptAllocDebtorsXRef 0 0 12 -1 Table
wkReceiptAllocGL 0 0 20 -1 Table
wkReceiptAllocGLAssetSales 0 0 8 -1 Table
wkReceiptAllocGLDonorPledges 0 0 19 -1 Table
wkReceiptAllocGLDonorReceipts 0 0 21 -1 Table
wkReceiptDonorPledges 0 0 9 -1 Table
wkReceipts 0 0 37 -1 Table
wkStudentCourseCommissionSchedule 0 1 22 -1 Table
Workflow 1 0 5 -1 Table
WorkflowStateMapping 0 1 7 -1 Table
WorkflowStateTransition 0 0 8 -1 Table