Constraints

75 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
FK_DebtorFeeAutoTuitionPeriods_DebtorFees
DebtorFeeAutoTuitionPeriods.FeeCode
DebtorFees.FeeCode
Restrict delete
FK_FinanceConfig_BankingConfig
FinanceConfig.DefaultBankCode
BankingConfig.BankCode
Restrict delete
FK_FinanceConfig_DefaultDebtorBankCode
FinanceConfig.DefaultDebtorBankCode
BankingConfig.BankCode
Restrict delete
FK_FinanceConfig_DefaultCreditorBankCode
FinanceConfig.DefaultCreditorBankCode
BankingConfig.BankCode
Restrict delete
FK_DebtorStatementRecipients_Debtors
DebtorStatementRecipients.DebtorID
DebtorStatementRecipients.DebtorStudentID
Debtors.DebtorID
Debtors.DebtorStudentID
Restrict delete
FK_Assets_AssetDefinitions
Assets.AssetTypeCode
AssetDefinitions.AssetTypeCode
Restrict delete
FK_ItemCreditors_ItemsSeq_Items_ItemsSeq
ItemCreditors.ItemsSeq
Items.ItemsSeq
Restrict delete
FK_DebtorTransactions_GeneralLedgerPostingControl_CreditorPostingNumber
DebtorTransactions.CreditorPostingNumber
GeneralLedgerPostingControl.PostingNumber
Restrict delete
FK_DebtorTransactions_CreditorTransactions_CreditorTransactionSeq
DebtorTransactions.CreditorTransactionSeq
CreditorTransactions.TransactionSeq
Restrict delete
FK_DebtorTransactions_GeneralLedgerJournals_CreditorGLJournalSeq
DebtorTransactions.CreditorGLJournalSeq
GeneralLedgerJournals.GLJournalSeq
Restrict delete
FK_DebtorTransactions_Debtors
DebtorTransactions.DebtorID
DebtorTransactions.DebtorStudentID
Debtors.DebtorID
Debtors.DebtorStudentID
Restrict delete
FK_DebtorTransactions_DebtorFees
DebtorTransactions.FeeCode
DebtorFees.FeeCode
Restrict delete
FK_DebtorTransactions_GeneralLedgerPostingControl
DebtorTransactions.PostingNumber
GeneralLedgerPostingControl.PostingNumber
Restrict delete
FK_wkBankStatementTransactions_BankStatementControl
wkBankStatementTransactions.BankStatementControlSeq
BankStatementControl.BankStatementControlSeq
Restrict delete
FK_ItemStockPrices_ItemPriceGroupsSeq_ItemPriceGroups_ItemPriceGroupsSeq
ItemStockPrices.ItemPriceGroupsSeq
ItemPriceGroups.ItemPriceGroupsSeq
Restrict delete
FK_ItemStockPrices_ItemStockSeq_ItemStock_ItemStockSeq
ItemStockPrices.ItemStockSeq
ItemStock.ItemStockSeq
Restrict delete
FK_DebtorsSalesBusinessUnits_BusinessUnits
DebtorsSalesBusinessUnits.BusinessUnitCode
BusinessUnits.BusinessUnitCode
Restrict delete
FK_DebtorsSalesBusinessUnits_Debtors
DebtorsSalesBusinessUnits.DebtorID
DebtorsSalesBusinessUnits.DebtorStudentID
Debtors.DebtorID
Debtors.DebtorStudentID
Restrict delete
FK_wkStudentCourseCommissionSchedule_Creditors
wkStudentCourseCommissionSchedule.AgentID
Creditors.ID
Restrict delete
FK_DebtorTransactionsXref_DebtorTransactionsTo
DebtorTransactionsXref.TransactionSeqReceipt
DebtorTransactions.TransactionSeq
Restrict delete
FK_PurchaseOrders_BusinessUnits
PurchaseOrders.BusinessUnitCode
BusinessUnits.BusinessUnitCode
Restrict delete
FK_SalesPaymentMethod_BusinessUnit
SalesPaymentMethods.BusinessUnitCode
BusinessUnits.BusinessUnitCode
Restrict delete
FK_ItemStock_BusinessUnits
ItemStock.BusinessUnitCode
BusinessUnits.BusinessUnitCode
Restrict delete
FK_ItemStock_Items
ItemStock.ItemCode
Items.ItemCode
Restrict delete
FK_WorkflowStateMapping_Workflow
WorkflowStateMapping.WorkflowCode
Workflow.Code
Restrict delete
FK_GeneralLedgerJournals_GeneralLedger
GeneralLedgerJournals.GLYear
GeneralLedgerJournals.GLCode
tGeneralLedger.GLYear
tGeneralLedger.GLCode
Restrict delete
FK_GeneralLedgerJournals_GeneralLedgerPostingControl
GeneralLedgerJournals.PostingNumber
GeneralLedgerPostingControl.PostingNumber
Restrict delete
FK_BankStatementTransactions_BankStatementControl
BankStatementTransactions.BankStatementControlSeq
BankStatementControl.BankStatementControlSeq
Restrict delete
FK_PurchaseOrderDetails_PurchaseOrders
PurchaseOrderDetails.OrderNumber
PurchaseOrders.OrderNumber
Restrict delete
FK_PayrollUpdatePostingEmployee_PostingNumber
PayrollUpdatePostingEmployee.PostingNumber
PayrollPostingControl.PostingNumber
Restrict delete
FK_tPayrollEmployeeSuperannuationAttribute_tPayrollEmployeeSuperannuationFund
tPayrollEmployeeSuperannuationAttribute.tPayrollEmployeeSuperannuationFundSeq
tPayrollEmployeeSuperannuationFund.tPayrollEmployeeSuperannuationFundSeq
Restrict delete
FK_ItemReceipts_ItemStock
ItemReceipts.ItemCode
ItemReceipts.BusinessUnitCode
ItemStock.ItemCode
ItemStock.BusinessUnitCode
Restrict delete
FK_DebtorStatementBalances_Debtors
DebtorStatementBalances.DebtorID
DebtorStatementBalances.DebtorStudentID
Debtors.DebtorID
Debtors.DebtorStudentID
Restrict delete
FK_DebtorStatementBalances_DebtorStatementControl
DebtorStatementBalances.StatementNumber
DebtorStatementControl.StatementNumber
Restrict delete
FK_GeneralLedgerBankTransactions_BankStatementControl
GeneralLedgerBankTransactions.BankStatementControlSeq
BankStatementControl.BankStatementControlSeq
Restrict delete
FK_tPayrollEmployeeSuperannuationFund_tPayrollEmployees
tPayrollEmployeeSuperannuationFund.PayrollYear
tPayrollEmployeeSuperannuationFund.ID
tPayrollEmployees.PayrollYear
tPayrollEmployees.ID
Restrict delete
FK_Agents_Creditors
Agents.ID
Creditors.ID
Restrict delete
FK_EnrolmentDeposits_EnrolmentDepositDefinitions
EnrolmentDeposits.DepositCode
EnrolmentDepositDefinitions.DepositCode
Restrict delete
FK_BankStatementTransactionsXRef_BankStatementControl
BankStatementTransactionsXRef.BankStatementControlSeq
BankStatementControl.BankStatementControlSeq
Restrict delete
FK_CreditorsTransactions_Creditors
CreditorTransactions.ID
Creditors.ID
Restrict delete
FK_GeneralLedgerFinanceReportLinks_GeneralLedgerFinanceReports
GeneralLedgerFinanceReportLinks.FinanceReportCode
GeneralLedgerFinanceReportLinks.FinanceLevel1
GeneralLedgerFinanceReportLinks.FinanceLevel2
GeneralLedgerFinanceReportLinks.FinanceLevel3
GeneralLedgerFinanceReportLinks.FinanceLevel4
GeneralLedgerFinanceReportLinks.FinanceLevel5
GeneralLedgerFinanceReportLinks.FinanceLevel6
GeneralLedgerFinanceReportLinks.FinanceDetailSeq
GeneralLedgerFinanceReports.FinanceReportCode
GeneralLedgerFinanceReports.FinanceLevel1
GeneralLedgerFinanceReports.FinanceLevel2
GeneralLedgerFinanceReports.FinanceLevel3
GeneralLedgerFinanceReports.FinanceLevel4
GeneralLedgerFinanceReports.FinanceLevel5
GeneralLedgerFinanceReports.FinanceLevel6
GeneralLedgerFinanceReports.FinanceDetailSeq
Restrict delete
FK_AssetDepreciation_Assets
AssetDepreciation.AssetNumber
Assets.AssetNumber
Restrict delete
FK_wkBankStatementTransactionsxRef_BankStatementControl
wkBankStatementTransactionsXRef.BankStatementControlSeq
BankStatementControl.BankStatementControlSeq
Restrict delete
FK_wkBankStatementTransactionsxRef_wkBankStatementTransactions
wkBankStatementTransactionsXRef.wkBankStatementTransactionsSeq
wkBankStatementTransactions.wkBankStatementTransactionsSeq
Restrict delete
FK_wkBankStatementTransactionsxRef_wkGeneralLedgerBankTransactions
wkBankStatementTransactionsXRef.wkGeneralLedgerBankTransactionsSeq
wkGeneralLedgerBankTransactions.wkGeneralLedgerBankTransactionsSeq
Restrict delete
FK_DebtorTransactionGeneralLedger_GeneralLedgerAllocationCodes
DebtorTransactionGeneralLedger.GLSubAllocationCode
GeneralLedgerAllocationCodes.GLSuballocationCode
Restrict delete
FK_DebtorTransactionGeneralLedger_DebtorTransactions
DebtorTransactionGeneralLedger.TransactionSeq
DebtorTransactions.TransactionSeq
Restrict delete
FK_Receipts_GeneralLedgerPostingControl
Receipts.PostingNumber
GeneralLedgerPostingControl.PostingNumber
Restrict delete
FK_PayrollLeaveAwardDefinitions_PayrollLeaveAwards
PayrollLeaveAwardDefinitions.AwardCode
PayrollLeaveAwardDefinitions.LeaveCode
PayrollLeaveAwards.AwardCode
PayrollLeaveAwards.LeaveCode
Restrict delete
FK_tPayrollEmployeeStandardPayDetails_tPayrollEmployeeSuperannuationFund
tPayrollEmployeeStandardPayDetails.tPayrollEmployeeSuperannuationFundSeq
tPayrollEmployeeSuperannuationFund.tPayrollEmployeeSuperannuationFundSeq
Restrict delete
FK_tPayrollEmployeeStandardPayDetails_tPayrollCodeDefinitions
tPayrollEmployeeStandardPayDetails.PayCode
tPayrollCodeDefinitions.PayCode
Restrict delete
FK_ItemSaleCloseOffReceiptPostingControlPosting_ItemSaleCloseOffReceiptPostingControl
ItemSaleCloseOffReceiptPostingControlCurrency.PostingNumber
ItemSaleCloseOffReceiptPostingControlCurrency.PaymentMethodCode
ItemSaleCloseOffReceiptPostingControl.PostingNumber
ItemSaleCloseOffReceiptPostingControl.PaymentMethodCode
Restrict delete
FK_GeneralLedgerCostCentres_GLDivisions
GeneralLedgerCostCentres.GLDivisionCode
GeneralLedgerDivisions.GLDivisionCode
Restrict delete
FK_ItemSaleCloseOffReceiptPostingControl_GeneralLedgerPostingControl
ItemSaleCloseOffReceiptPostingControl.PostingNumber
GeneralLedgerPostingControl.PostingNumber
Restrict delete
FK_Creditors_HeadOfficeID
Creditors.HeadOfficeID
Creditors.ID
Restrict delete
FK_ItemCategoryPriceGroups_ItemPriceGroupsSeq_ItemPriceGroups_ItemPriceGroupsSeq
ItemCategoryPriceGroups.ItemPriceGroupsSeq
ItemPriceGroups.ItemPriceGroupsSeq
Restrict delete
FK_tPayrollGovtSubmission_PayrollPostingControl
tPayrollGovtSubmission.PostingNumber
PayrollPostingControl.PostingNumber
Restrict delete
FK_ItemSaleDetails_ItemStock
ItemSaleDetails.ItemCode
ItemSaleDetails.BusinessUnitCode
ItemStock.ItemCode
ItemStock.BusinessUnitCode
Restrict delete
FK_ItemSaleDetails_ItemSales
ItemSaleDetails.ItemSaleSeq
ItemSales.ItemSaleSeq
Restrict delete
FK_ItemPriceGroupsConstituencies_ItemPriceGroupsSeq_ItemPriceGroups_ItemPriceGroupsSeq
ItemPriceGroupsConstituencies.ItemPriceGroupsSeq
ItemPriceGroups.ItemPriceGroupsSeq
Restrict delete
FK_ItemConsignmentPayments_Items
ItemConsignmentPayments.ItemCode
Items.ItemCode
Restrict delete
FK_PayrollInUseRegister_PayrollPostingControl
PayrollInUseRegister.PostingNumber
PayrollPostingControl.PostingNumber
Restrict delete
FK_PortalPaymentPlansSelections_Debtors
PortalPaymentPlansSelections.DebtorID
PortalPaymentPlansSelections.DebtorStudentID
Debtors.DebtorID
Debtors.DebtorStudentID
Restrict delete
FK_ItemSalePayments_ItemSales
ItemSalePayments.ItemSaleSeq
ItemSales.ItemSaleSeq
Restrict delete
FK_BankStatementControl_BankingConfig
BankStatementControl.BankCode
BankingConfig.BankCode
Restrict delete
FK_ItemStocktake_Items_ItemCode
ItemStocktake.ItemCode
Items.ItemCode
Restrict delete
FK_ItemStocktake_BusinessUnits
ItemStocktake.BusinessUnitCode
BusinessUnits.BusinessUnitCode
Restrict delete
FK_DebtorPaymentMethods_Debtors
DebtorPaymentMethods.DebtorID
DebtorPaymentMethods.DebtorStudentID
Debtors.DebtorID
Debtors.DebtorStudentID
Restrict delete
FK_tPayrollGovtSubmissionEmployee_tPayrollGovtSubmission
tPayrollGovtSubmissionEmployee.tPayrollGovtSubmissionSeq
tPayrollGovtSubmission.tPayrollGovtSubmissionSeq
Restrict delete
FK_PayrollGovtSubmissionApproval_tPayrollGovtSubmission
PayrollGovtSubmissionApproval.PayrollGovtSubmissionSeq
tPayrollGovtSubmission.tPayrollGovtSubmissionSeq
Restrict delete
FK_tGeneralLedger_GeneralLedgerChartOfAccounts
tGeneralLedger.GLCOACode
GeneralLedgerChartOfAccounts.GLCOACode
Restrict delete
FK_tGeneralLedger_GeneralLedgerCostCentres
tGeneralLedger.CostCentreCode
GeneralLedgerCostCentres.CostCentreCode
Restrict delete
FK_DebtorPaymentMethodsOnline_Debtors
DebtorPaymentMethodsOnline.DebtorID
DebtorPaymentMethodsOnline.DebtorStudentID
Debtors.DebtorID
Debtors.DebtorStudentID
Restrict delete
FK_BusinessUnitItemCategories_BusinessUnitCode_BusinessUnits_BusinessUnitCode
BusinessUnitItemCategories.BusinessUnitCode
BusinessUnits.BusinessUnitCode
Restrict delete
FK_tPayrollCodeDefinitions_DebtorFees
tPayrollCodeDefinitions.DebtorFeeCode
DebtorFees.FeeCode
Restrict delete

Check Constraints

Table Constraint Name Constraint
None detected