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

Page1 2