CREATE TABLE [dbo].[CBAccounts]
(
[AccountID] [int] NOT NULL,
[BankName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[BankRouterNumber] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[BankAccountNumber] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Contact] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Phone] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Fax] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CheckNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Balance] [money] NOT NULL CONSTRAINT [DF_CBAccounts_Balance] DEFAULT ((0)),
[Remarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Active] [bit] NOT NULL,
[Locks] [int] NOT NULL CONSTRAINT [DF_CBAccounts_Locks] DEFAULT ((0)),
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_CBAccounts_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_CBAccounts_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[EFTEnabled] [bit] NOT NULL CONSTRAINT [DF_CBAccounts_EFTEnabled] DEFAULT ((0)),
[EFTCompanyID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CBAccounts_EFTCompanyID] DEFAULT (''),
[EFTCompanyName] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CBAccounts_EFTCompanyName] DEFAULT (''),
[EFTDestination] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CBAccounts_EFTDestination] DEFAULT (''),
[EFTDestinationName] [varchar] (23) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CBAccounts_EFTDestinationName] DEFAULT (''),
[EFTOrigin] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CBAccounts_EFTOrigin] DEFAULT (''),
[EFTOriginName] [varchar] (23) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CBAccounts_EFTOriginName] DEFAULT (''),
[EFTIncludeSelfDebit] [bit] NOT NULL CONSTRAINT [DF_CBAccounts_EFTIncludeSelfDebit] DEFAULT ((0)),
[AccountTypeID] [int] NOT NULL CONSTRAINT [DF_CBAccounts_AccountTypeID] DEFAULT ((2)),
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_CBAccounts_NoteFlag] DEFAULT ((0)),
[NoteCount] [int] NOT NULL CONSTRAINT [DF_CBAccounts_NoteCount] DEFAULT ((0)),
[StatementBegBal] [money] NOT NULL CONSTRAINT [DF_CBAccounts_StatementBegBal] DEFAULT ((0)),
[StatementEndBal] [money] NOT NULL CONSTRAINT [DF_CBAccounts_StatementEndBal] DEFAULT ((0)),
[BalanceSheetGroupID] [int] NULL,
[CheckImageID] [int] NULL,
[SigImageID] [int] NULL,
[CompanyName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CBAccounts_CompanyName] DEFAULT (''),
[CompanyAddress] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CBAccounts_CompanyAddress] DEFAULT (''),
[BankNameAddress] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CBAccounts_BankNameAddress] DEFAULT ('')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CBAccounts] ADD CONSTRAINT [PK_CBAccounts] PRIMARY KEY CLUSTERED ([AccountID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CBAccounts] ADD CONSTRAINT [FK_CBAccounts_AccountID_GLAccounts] FOREIGN KEY ([AccountID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[CBAccounts] ADD CONSTRAINT [FK_CBAccounts_AccountTypeID_CBAccountTypes] FOREIGN KEY ([AccountTypeID]) REFERENCES [dbo].[CBAccountTypes] ([AccountTypeID])
GO
ALTER TABLE [dbo].[CBAccounts] ADD CONSTRAINT [FK_CBAccounts_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[CBAccounts] ADD CONSTRAINT [FK_CBAccounts_CheckImageID_SHImages] FOREIGN KEY ([CheckImageID]) REFERENCES [dbo].[SHImages] ([ImageID])
GO
ALTER TABLE [dbo].[CBAccounts] ADD CONSTRAINT [FK_CBAccounts_NoteID_CBAccountNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[CBAccountNotes] ([NoteID])
GO
ALTER TABLE [dbo].[CBAccounts] ADD CONSTRAINT [FK_CBAccounts_SigImageID_SHImages] FOREIGN KEY ([SigImageID]) REFERENCES [dbo].[SHImages] ([ImageID])
GO