CREATE TABLE [dbo].[SCQAccrualMeterGroups]
(
[AccrualMeterGroupID] [int] NOT NULL IDENTITY(1, 1),
[AccrualID] [int] NOT NULL,
[ContractDetailID] [int] NOT NULL,
[MeterGroupDetailID] [int] NOT NULL,
[ContractMeterGroupID] [int] NOT NULL,
[DistCodeID] [int] NOT NULL,
[BaseAmount] [money] NOT NULL,
[BaseFromDate] [datetime] NULL,
[BaseToDate] [datetime] NULL,
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_SCQAccrualMeterGroups_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCQAccrualMeterGroups_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[OverageTypeID] [int] NOT NULL,
[OverageMethodID] [int] NOT NULL,
[ContractMeterGroup] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContractMeterGroupDescription] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AccruedCoveredCopies] [decimal] (18, 6) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQAccrualMeterGroups] ADD CONSTRAINT [PK_SCQAccrualMeterGroups] PRIMARY KEY CLUSTERED ([AccrualMeterGroupID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQAccrualMeterGroups] ADD CONSTRAINT [FK_SCQAccrualMeterGroups_AccrualID_SCQAccrualContracts] FOREIGN KEY ([AccrualID], [ContractDetailID]) REFERENCES [dbo].[SCQAccrualContracts] ([AccrualID], [ContractDetailID])
GO
ALTER TABLE [dbo].[SCQAccrualMeterGroups] ADD CONSTRAINT [FK_SCQAccrualMeterGroups_ContractMeterGroupID_SCContractMeterGroups] FOREIGN KEY ([ContractMeterGroupID]) REFERENCES [dbo].[SCContractMeterGroups] ([ContractMeterGroupID])
GO