
[dbo].[ClaimChargebackType]
CREATE TABLE [dbo].[ClaimChargebackType]
(
[ClaimChargebackTypeID] [int] NOT NULL IDENTITY(1, 1),
[ItemCodeFID] [int] NOT NULL,
[Description] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ClaimChargebackType] ADD CONSTRAINT [PK_ClaimChargebackType] PRIMARY KEY NONCLUSTERED ([ClaimChargebackTypeID]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ClaimChargebackType] ADD CONSTRAINT [FK_ClaimChargebackType_ItemCode] FOREIGN KEY ([ItemCodeFID]) REFERENCES [dbo].[ItemCode] ([ICPriKey])
GO
GRANT SELECT ON [dbo].[ClaimChargebackType] TO [MssExec]
GRANT INSERT ON [dbo].[ClaimChargebackType] TO [MssExec]
GRANT DELETE ON [dbo].[ClaimChargebackType] TO [MssExec]
GRANT UPDATE ON [dbo].[ClaimChargebackType] TO [MssExec]
GO