CREATE TABLE [dbo].[RevenueRatingImportInvoiceMerge]
(
[RevenueRatingImportInvoiceMergeID] [int] NOT NULL IDENTITY(1, 1),
[DistributionCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MergeToCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IsPacking] [bit] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RevenueRatingImportInvoiceMerge] ADD CONSTRAINT [PK_RevenueRatingImportInvoiceMerge] PRIMARY KEY NONCLUSTERED  ([RevenueRatingImportInvoiceMergeID]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_RevenueRatingImportInvoiceMerge_DistCode] ON [dbo].[RevenueRatingImportInvoiceMerge] ([DistributionCode]) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [IX_RevenueRatingImportInvoiceMerge_DistMergeCode] ON [dbo].[RevenueRatingImportInvoiceMerge] ([DistributionCode], [MergeToCode]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[RevenueRatingImportInvoiceMerge] TO [MssExec]
GRANT INSERT ON  [dbo].[RevenueRatingImportInvoiceMerge] TO [MssExec]
GRANT DELETE ON  [dbo].[RevenueRatingImportInvoiceMerge] TO [MssExec]
GRANT UPDATE ON  [dbo].[RevenueRatingImportInvoiceMerge] TO [MssExec]
GO