Table: dbo.Accounting_Application
The table enumerates the different types of accounting applications that may use the database.
Columns
NameTypeConstraintsDescription
accounting_application_KEYint (4)NOT NULLPrimary key.
descriptionnvarchar (50)NOT NULLAbbreviation for the accounting application.
Primary key
NameColumnsDescription
PK_Accounting_Applicationaccounting_application_KEY
Unique constraints
NameColumnsDescription
UK_Accounting_Application$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Report_Definition_Application_License_Requirement__Accounting_Application__accounting_application_KEYaccounting_application_KEYReport_Definition_Application_License_Requirement
FK_Ach_File_Header_Record__Accounting_Application__origin__accounting_application_KEYorigin__accounting_application_KEYAch_File_Header_Record
FK_Journal_Entry__Accounting_Application__origin__accounting_application_KEYorigin__accounting_application_KEYJournal_Entry
FK_Bank_Transaction__Accounting_Application__origin__accounting_application_KEYorigin__accounting_application_KEYBank_Transaction
FK_Bank_Transaction_Template__Accounting_Application__origin__accounting_application_KEYorigin__accounting_application_KEYBank_Transaction_Template
FK_Payable_Transaction__Accounting_Application__origin__accounting_application_KEYorigin__accounting_application_KEYPayable_Transaction
FK_Payable_Payment_Application$origin__accounting_application_KEYorigin__accounting_application_KEYPayable_Payment_Application

Schema diagram