Accounting Software

Here is a table relationship diagram for a typical accounting database.

Download Accounting Database SQL Script

Table [dbo].[D_GLBudget]

Table [dbo].[D_GLBudgetItem]

Table [dbo].[D_GLJournal]

Table [dbo].[D_GLJournalItem]

Table [dbo].[D_GLSum]

Table [dbo].[D_Period]

Table [dbo].[K_Company]

Table [dbo].[K_Parameter]

Table [dbo].[L_Country]

Table [dbo].[L_Currency]

Table [dbo].[L_GLAccount]

Table [dbo].[L_GLAccountOrg]

Table [dbo].[L_GLDept]

Table [dbo].[L_GLJob]

Table [dbo].[L_GLJournalDesc]

Table [dbo].[L_GLJournalReason]

Table [dbo].[L_GLReport]

Table [dbo].[L_GLReportItem]

Table [dbo].[L_GLSource]

Table [dbo].[L_GLTax]

Table Constrains and Indexes

Trigger dbo.D_GLBudget_ITrig

Trigger dbo.D_GLBudget_UTrig

Trigger dbo.D_GLBudgetItem_ITrig

Trigger dbo.D_GLBudgetItem_UTrig

Trigger dbo.D_GLJournal_DTrig

Trigger dbo.D_GLJournal_ITrig

Trigger dbo.D_GLJournal_UTrig

Trigger dbo.D_GLJournalItem_ITrig

Trigger dbo.D_GLJournalItem_UTrig

Trigger dbo.D_GLSum_ITrig

Trigger dbo.D_GLSum_UTrig

Trigger dbo.D_Period_DTrig

Trigger dbo.D_Period_UTrig

Trigger dbo.L_Currency_DTrig

Trigger dbo.L_Currency_ITrig

Trigger dbo.L_Currency_UTrig

Trigger dbo.L_GLAccount_DTrig

Trigger dbo.L_GLAccount_ITrig

Trigger dbo.L_GLAccount_UTrig

Trigger dbo.L_GLAccountOrg_ITrig

Trigger dbo.L_GLAccountOrg_UTrig

Trigger dbo.L_GLDept_DTrig

Trigger dbo.L_GLDept_UTrig

Trigger dbo.L_GLJob_ITrig

Trigger dbo.L_GLJob_UTrig

Trigger dbo.L_GLReport_DTrig

Trigger dbo.L_GLReport_UTrig

Trigger dbo.L_GLReportItem_ITrig

Trigger dbo.L_GLReportItem_UTrig

Page1 2