CREATE TABLE [dbo].[SCQBillingMeterGroups]
(
[BillingMeterGroupID] [int] NOT NULL IDENTITY(1, 1),
[BillingID] [int] NOT NULL,
[ContractDetailID] [int] NOT NULL,
[OverageTypeID] [int] NOT NULL,
[ContractMeterGroupID] [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,
[CoveredCopies] [decimal] (18, 6) NULL,
[OvgChargeType] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GroupCopies] [decimal] (18, 6) NULL,
[CountedCopies] [decimal] (18, 6) NULL,
[BillableCopies] [decimal] (18, 6) NULL,
[TotalChargeAmount] [money] NULL,
[EffectiveRate] [decimal] (16, 6) NULL,
[MeterCount] [int] NOT NULL,
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreateDate] [datetime] NULL CONSTRAINT [DF_SCQBillingMeterGroups_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NULL CONSTRAINT [DF_SCQBillingMeterGroups_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[NextOvgMethod] [int] NULL,
[NextOvgRateIncreaseValue] [decimal] (16, 6) NULL,
[NextOvgRoundNoDigits] [int] NULL,
[OverageMethodID] [int] NOT NULL CONSTRAINT [DF_SCQBillingMeterGroups_OverageMethodID] DEFAULT ((1)),
[DistTaxAmount] [money] NOT NULL CONSTRAINT [DF_SCQBillingMeterGroups_DistTaxAmount] DEFAULT ((0)),
[NextCoveredCopies] [decimal] (18, 6) NULL,
[AvgGroupRate] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCQBillingMeterGroups_AvgGroupRate] DEFAULT ((0)),
[BaseAmount] [money] NULL,
[OverageAmount] [money] NULL,
[BaseRatePerCopy] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCQBillingMeterGroups_BaseRatePerCopy] DEFAULT ((0)),
[RoundBaseAmountDigits] [int] NOT NULL CONSTRAINT [DF_SCQBillingMeterGroups_RoundBaseAmountDigits] DEFAULT ((2)),
[BilledCoveredCopies] [decimal] (18, 6) NULL,
[BaseDistributionCodeID] [int] NULL,
[NextBaseMethod] [int] NULL,
[NextBaseRateIncreaseValue] [decimal] (16, 6) NULL,
[NextBaseRoundNoDigits] [int] NULL,
[NextCoveredCopiesDate] [datetime] NULL,
[CoveredCopiesPer] [int] NOT NULL CONSTRAINT [DF_SCQBillingMeterGroups_CoveredCopiesPer] DEFAULT ((0)),
[BillMeterGroupBaseAmount] [bit] NOT NULL CONSTRAINT [DF_SCQBillingMeterGroups_BillMeterGroupBaseAmount] DEFAULT ((0)),
[BilledCoveredCopiesBalance] [decimal] (18, 6) NULL,
[UsedCoveredCopies] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCQBillingMeterGroups_UsedCoveredCopies] DEFAULT ((0)),
[NextBaseRatePerCopy] [decimal] (18, 6) NULL,
[NextBaseIncreaseDate] [datetime] NULL,
[NextBaseScheduleDetailID] [int] NULL,
[NextOvgIncreaseDate] [datetime] NULL,
[NextOvgScheduleDetailID] [int] NULL,
[NonAdjustedCoveredCopies] [decimal] (18, 6) NULL,
[NonAdjustedBaseRatePerCopy] [decimal] (18, 6) NULL,
[CoveredCopiesOvgMultiplier] [decimal] (18, 6) NOT NULL,
[CoveredCopiesBaseMultiplier] [decimal] (18, 6) NOT NULL,
[MeterGroupDetailID] [int] NOT NULL,
[NonAdjustedNextCoveredCopiesDate] [datetime] NULL,
[OverageBillingCycleID] [int] NULL,
[OverageFromDate] [datetime] NULL,
[OverageToDate] [datetime] NULL,
[NonAdjustedOverageNextBillingDate] [datetime] NULL,
[NonAdjustedOverageLastBillingDate] [datetime] NULL,
[OverageCyclesBilled] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQBillingMeterGroups] ADD CONSTRAINT [PK__SCQBilli__75F2D088B3220964] PRIMARY KEY CLUSTERED ([BillingMeterGroupID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQBillingMeterGroups] ADD CONSTRAINT [FK_SCQBillingMeterGroups_BaseDistributionCodeID_SCContractBaseDistCodes] FOREIGN KEY ([BaseDistributionCodeID]) REFERENCES [dbo].[SCContractBaseDistCodes] ([BaseDistributionCodeID])
GO
ALTER TABLE [dbo].[SCQBillingMeterGroups] ADD CONSTRAINT [FK_SCQBillingMeterGroups_BillingID_SCQBillingContracts] FOREIGN KEY ([BillingID], [ContractDetailID]) REFERENCES [dbo].[SCQBillingContracts] ([BillingID], [ContractDetailID])
GO
ALTER TABLE [dbo].[SCQBillingMeterGroups] ADD CONSTRAINT [FK_SCQBillingMeterGroups_OverageBillingCycleID_SCBillingCycles] FOREIGN KEY ([OverageBillingCycleID]) REFERENCES [dbo].[SCBillingCycles] ([BillingCycleID])
GO
ALTER TABLE [dbo].[SCQBillingMeterGroups] ADD CONSTRAINT [FK_SCQBillingMeterGroups_OverageMethodID_SCOverageMethods] FOREIGN KEY ([OverageMethodID]) REFERENCES [dbo].[SCOverageMethods] ([OverageMethodID])
GO