CREATE TABLE [dbo].[StorageSetup]
(
[StorageSetupPriKey] [int] NOT NULL CONSTRAINT [DF_StorageSetup_StorageSetupPriKey] DEFAULT (1),
[UseDeferred] [bit] NOT NULL CONSTRAINT [DF_StorageSetup_UseDeferred] DEFAULT (0),
[ManualDeferred] [bit] NOT NULL,
[ManualDeferredGL] [varchar] (66) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Account] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SubAccount] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[StorageSetup] ADD CONSTRAINT [CK_TableSize_To_1] CHECK (([StorageSetupPriKey]<(2) AND [StorageSetupPriKey]>(0)))
GO
ALTER TABLE [dbo].[StorageSetup] ADD CONSTRAINT [PK_StorageSetup] PRIMARY KEY NONCLUSTERED  ([StorageSetupPriKey]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[StorageSetup] TO [MssExec]
GRANT INSERT ON  [dbo].[StorageSetup] TO [MssExec]
GRANT DELETE ON  [dbo].[StorageSetup] TO [MssExec]
GRANT UPDATE ON  [dbo].[StorageSetup] TO [MssExec]
GO
EXEC sp_addextendedproperty N'MS_Description', N'The account section of the deferred account.', 'SCHEMA', N'dbo', 'TABLE', N'StorageSetup', 'COLUMN', N'Account'
GO
EXEC sp_addextendedproperty N'MS_Description', N'0 if deferred gl account should be built. 1 if ManualDeferredGL is the deferred gl account.', 'SCHEMA', N'dbo', 'TABLE', N'StorageSetup', 'COLUMN', N'ManualDeferred'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The manual deferred account.', 'SCHEMA', N'dbo', 'TABLE', N'StorageSetup', 'COLUMN', N'ManualDeferredGL'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Primary key.', 'SCHEMA', N'dbo', 'TABLE', N'StorageSetup', 'COLUMN', N'StorageSetupPriKey'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The sub-account section of the deferred account.', 'SCHEMA', N'dbo', 'TABLE', N'StorageSetup', 'COLUMN', N'SubAccount'
GO
EXEC sp_addextendedproperty N'MS_Description', N'0 if the deferred account is not used, 1 if it is used.', 'SCHEMA', N'dbo', 'TABLE', N'StorageSetup', 'COLUMN', N'UseDeferred'
GO