CREATE TABLE [dbo].[SCBillingMeterGroups]
(
[BillingMeterGroupID] [int] NOT NULL IDENTITY(1, 1),
[InvoiceID] [int] NOT NULL,
[ContractDetailID] [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,
[QID] [int] 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,
[LastUpdate] [datetime] NULL,
[timestamp] [timestamp] NULL,
[ContractMeterGroupID] [int] NULL,
[OverageMethodID] [int] NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_OverageMethodID] DEFAULT ((1)),
[DistTaxAmount] [money] NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_DistTaxAmount] DEFAULT ((0)),
[NextCoveredCopies] [decimal] (18, 6) NULL,
[AvgGroupRate] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_AvgGroupRate] DEFAULT ((0)),
[BaseAmount] [money] NULL,
[OverageAmount] [money] NULL,
[DistCodeID] [int] NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_DistcodeID] DEFAULT ((0)),
[CoveredCopiesPer] [int] NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_CoveredCopiesPer] DEFAULT ((0)),
[BillMeterGroupBaseAmount] [bit] NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_BillMeterGroupBaseAmount] DEFAULT ((0)),
[NextCoveredCopiesDate] [datetime] NULL,
[BaseRatePerCopy] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_BaseRatePerCopy] DEFAULT ((0)),
[RoundBaseAmountDigits] [int] NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_RoundBaseAmountDigits] DEFAULT ((2)),
[UsedCoveredCopies] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_UsedCoveredCopies] DEFAULT ((0)),
[BilledCoveredCopies] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_BilledCoveredCopies] DEFAULT ((0)),
[CoveredCopiesOvgMultiplier] [int] NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_CoveredCopiesOvgMultiplier] DEFAULT ((1)),
[CoveredCopiesBaseMultiplier] [int] NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_CoveredCopiesBaseMultiplier] DEFAULT ((1)),
[NonAdjustedCoveredCopies] [decimal] (18, 6) NULL,
[NonAdjustedBaseRatePerCopy] [decimal] (18, 6) NULL,
[NonAdjustedNextCoveredCopiesDate] [datetime] NULL,
[OverageBillingCycleID] [int] NULL,
[OverageFromDate] [datetime] NULL,
[OverageToDate] [datetime] NULL,
[NonAdjustedOverageNextBillingDate] [datetime] NULL,
[NonAdjustedOverageLastBillingDate] [datetime] NULL,
[OverageCyclesBilled] [int] NULL,
[BaseDistributionCodeID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCBillingMeterGroups] ADD CONSTRAINT [PK__SCBillin__75F2D0888D8C2BBF] PRIMARY KEY CLUSTERED ([BillingMeterGroupID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCBillingMeterGroups] ADD CONSTRAINT [FK_SCBillingMeterGroups_BaseDistributionCodeID_SCContractBaseDistCodes] FOREIGN KEY ([BaseDistributionCodeID]) REFERENCES [dbo].[SCContractBaseDistCodes] ([BaseDistributionCodeID])
GO
ALTER TABLE [dbo].[SCBillingMeterGroups] ADD CONSTRAINT [FK_SCBillingMeterGroups_InvoiceID_SCBillingContracts] FOREIGN KEY ([InvoiceID], [ContractDetailID]) REFERENCES [dbo].[SCBillingContracts] ([InvoiceID], [ContractDetailID])
GO
ALTER TABLE [dbo].[SCBillingMeterGroups] ADD CONSTRAINT [FK_SCBillingMeterGroups_OverageBillingCycleID_SCBillingCycles] FOREIGN KEY ([OverageBillingCycleID]) REFERENCES [dbo].[SCBillingCycles] ([BillingCycleID])
GO
ALTER TABLE [dbo].[SCBillingMeterGroups] ADD CONSTRAINT [FK_SCBillingMeterGroups_OverageMethodID_SCOverageMethods] FOREIGN KEY ([OverageMethodID]) REFERENCES [dbo].[SCOverageMethods] ([OverageMethodID])
GO