CREATE TABLE [dbo].[AccountingBankAccount]
(
[AccountingBankAccountId] [int] NOT NULL IDENTITY(1, 1),
[AccountingAccountFid] [int] NOT NULL,
[Description] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Code] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AccountNumber] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Hidden] [bit] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountingBankAccount] ADD CONSTRAINT [PK_AccountingBankAccount] PRIMARY KEY CLUSTERED  ([AccountingBankAccountId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountingBankAccount] ADD CONSTRAINT [IX_AccountingBankAccount_AccountNumber] UNIQUE NONCLUSTERED  ([AccountNumber]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountingBankAccount] ADD CONSTRAINT [FK_AccountingBankAccount_AccountingAccount] FOREIGN KEY ([AccountingAccountFid]) REFERENCES [dbo].[AccountingAccount] ([AccountingAccountId])
GO
GRANT SELECT ON  [dbo].[AccountingBankAccount] TO [MssExec]
GRANT INSERT ON  [dbo].[AccountingBankAccount] TO [MssExec]
GRANT DELETE ON  [dbo].[AccountingBankAccount] TO [MssExec]
GRANT UPDATE ON  [dbo].[AccountingBankAccount] TO [MssExec]
GO