CREATE TABLE [dbo].[SCContractMeterGroups]
(
[ContractMeterGroupID] [int] NOT NULL IDENTITY(1, 1),
[ContractMeterGroup] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ContractID] [int] NOT NULL,
[CoveredCopies] [decimal] (18, 6) NULL,
[ApplyToExpiration] [bit] NULL,
[OverageTypeID] [int] NULL,
[UseOverages] [bit] NOT NULL CONSTRAINT [DF_SCContractMeterGroups_UseOverages] DEFAULT ((0)),
[MeterCount] [int] NOT NULL CONSTRAINT [DF_SCContractMeterGroups_MeterCount] DEFAULT ((1)),
[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_SCContractMeterGroups_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCContractMeterGroups_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[NextOvgIncreaseDate] [datetime] NULL,
[NextOvgScheduleDetailID] [int] NULL,
[OvgRateScheduleStartDateType] [int] NULL,
[OvgRateScheduleStartDate] [datetime] NULL,
[OvgRateScheduleIsRenewalType] [bit] NULL CONSTRAINT [DF_SCContractMeterGroups_OvgRateScheduleIsRenewalType] DEFAULT ((0)),
[OverageMethodID] [int] NOT NULL CONSTRAINT [DF_SCContractMeterGroups_OverageMethodID] DEFAULT ((1)),
[CreditRate] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCContractMeterGroups_CreditRate] DEFAULT ((0)),
[BaseDistributionCodeID] [int] NULL,
[BilledCoveredCopiesBalance] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCContractMeterGroups_BilledCoveredCopiesBalance] DEFAULT ((0)),
[BillMeterGroupBaseAmount] [bit] NOT NULL CONSTRAINT [DF_SCContractMeterGroups_BillMeterGroupBaseAmount] DEFAULT ((0)),
[BaseRatePerCopy] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCContractMeterGroups_BaseRatePerCopy] DEFAULT ((0)),
[RoundBaseAmountDigits] [int] NOT NULL CONSTRAINT [DF_SCContractMeterGroups_RoundBaseAmountDigits] DEFAULT ((2)),
[UnearnedBalance] [money] NOT NULL CONSTRAINT [DF_SCContractMeterGroups_UnearnedBalance] DEFAULT ((0)),
[BaseRateScheduleIsRenewalType] [bit] NULL CONSTRAINT [DF_SCContractMeterGroups_BaseRateScheduleIsRenewalType] DEFAULT ((0)),
[BaseRateScheduleStartDate] [datetime] NULL,
[BaseRateScheduleStartDateType] [int] NULL,
[NextBaseIncreaseDate] [datetime] NULL,
[NextBaseScheduleDetailID] [int] NULL,
[NextCoveredCopies] [decimal] (18, 6) NULL,
[NextCoveredCopiesDate] [datetime] NULL,
[CoveredCopiesPer] [int] NOT NULL CONSTRAINT [DF_SCContractMeterGroups_CoveredCopiesPer] DEFAULT ((0)),
[BilledCoveredCopiesBalanceAdjustment] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCContractMeterGroups_BilledCoveredCopiesBalanceAdjustment] DEFAULT ((0)),
[OverageBillingCycleID] [int] NULL,
[OverageBilledThruDate] [datetime] NULL,
[OverageNextBillingDate] [datetime] NULL,
[OverageLastBillingDate] [datetime] NULL,
[OverageBilledThruDateInitial] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCContractMeterGroups] ADD CONSTRAINT [PK_SCContractMeterGroups] PRIMARY KEY CLUSTERED ([ContractMeterGroupID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCContractMeterGroups] ADD CONSTRAINT [FK_SCContractMeterGroups_BaseDistributionCodeID_SCContractBaseDistCodes] FOREIGN KEY ([BaseDistributionCodeID]) REFERENCES [dbo].[SCContractBaseDistCodes] ([BaseDistributionCodeID])
GO
ALTER TABLE [dbo].[SCContractMeterGroups] ADD CONSTRAINT [FK_SCContractMeterGroups_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO
ALTER TABLE [dbo].[SCContractMeterGroups] ADD CONSTRAINT [FK_SCContractMeterGroups_OverageBillingCycleID_SCBillingCycles] FOREIGN KEY ([OverageBillingCycleID]) REFERENCES [dbo].[SCBillingCycles] ([BillingCycleID])
GO
ALTER TABLE [dbo].[SCContractMeterGroups] ADD CONSTRAINT [FK_SCContractMeterGroups_OverageMethodID_SCOverageMethods] FOREIGN KEY ([OverageMethodID]) REFERENCES [dbo].[SCOverageMethods] ([OverageMethodID])
GO