Table: dbo.Accounting_Application
The table enumerates the different types of accounting applications that may use the database.
Columns
Name | Type | Constraints | Description
accounting_application_KEY | int (4) | NOT NULL | Primary key.
description | nvarchar (50) | NOT NULL | Abbreviation for the accounting application.

Primary key
Name | Columns | Description
PK_Accounting_Application | accounting_application_KEY |
Unique constraints
Name | Columns | Description
UK_Accounting_Application$description | description |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Report_Definition_Application_License_Requirement__Accounting_Application__accounting_application_KEY | accounting_application_KEY | Report_Definition_Application_License_Requirement |
FK_Ach_File_Header_Record__Accounting_Application__origin__accounting_application_KEY | origin__accounting_application_KEY | Ach_File_Header_Record |
FK_Journal_Entry__Accounting_Application__origin__accounting_application_KEY | origin__accounting_application_KEY | Journal_Entry |
FK_Bank_Transaction__Accounting_Application__origin__accounting_application_KEY | origin__accounting_application_KEY | Bank_Transaction |
FK_Bank_Transaction_Template__Accounting_Application__origin__accounting_application_KEY | origin__accounting_application_KEY | Bank_Transaction_Template |
FK_Payable_Transaction__Accounting_Application__origin__accounting_application_KEY | origin__accounting_application_KEY | Payable_Transaction |
FK_Payable_Payment_Application$origin__accounting_application_KEY | origin__accounting_application_KEY | Payable_Payment_Application |