CREATE TABLE [dbo].[AccountingNote]
(
[ANPriKey] [int] NOT NULL IDENTITY(1, 1),
[DateCreated] [datetime] NOT NULL,
[CreatedBy] [int] NOT NULL,
[NoteText] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountingNote] ADD CONSTRAINT [PK_AccountingNote] PRIMARY KEY NONCLUSTERED  ([ANPriKey]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_AccountingNote_CreatedBy] ON [dbo].[AccountingNote] ([CreatedBy]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountingNote] ADD CONSTRAINT [FK_AccountingNote_Sysuser] FOREIGN KEY ([CreatedBy]) REFERENCES [dbo].[Sysuser] ([SysUserID])
GO
GRANT SELECT ON  [dbo].[AccountingNote] TO [MssExec]
GRANT INSERT ON  [dbo].[AccountingNote] TO [MssExec]
GRANT DELETE ON  [dbo].[AccountingNote] TO [MssExec]
GRANT UPDATE ON  [dbo].[AccountingNote] TO [MssExec]
GO
EXEC sp_addextendedproperty N'MS_Description', N'This table stores notes linked to various accounting transactions', 'SCHEMA', N'dbo', 'TABLE', N'AccountingNote', NULL, NULL
GO
EXEC sp_addextendedproperty N'MS_Description', N'Primary key of this table', 'SCHEMA', N'dbo', 'TABLE', N'AccountingNote', 'COLUMN', N'ANPriKey'
GO
EXEC sp_addextendedproperty N'MS_Description', N'MoverSuite user that created the note', 'SCHEMA', N'dbo', 'TABLE', N'AccountingNote', 'COLUMN', N'CreatedBy'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The date the note was added to the database', 'SCHEMA', N'dbo', 'TABLE', N'AccountingNote', 'COLUMN', N'DateCreated'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The body of the note message', 'SCHEMA', N'dbo', 'TABLE', N'AccountingNote', 'COLUMN', N'NoteText'
GO