CREATE TABLE [dbo].[SCProposalMeterGroups]
(
[BillingMeterGroupID] [int] NOT NULL IDENTITY(1, 1),
[ProposalID] [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,
[OverageMethodID] [int] NOT NULL CONSTRAINT [DF_SCProposalMeterGroups_OverageMethodID] DEFAULT ((1)),
[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,
[ContractMeterGroupID] [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] NOT NULL,
[DistTaxAmount] [money] NOT NULL CONSTRAINT [DF_SCProposalMeterGroups_DistTaxAmount] DEFAULT ((0)),
[NextCoveredCopies] [decimal] (18, 6) NULL,
[OverageAmount] [money] NULL,
[BaseAmount] [money] NULL,
[AvgGroupRate] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCProposalMeterGroups_AvgGroupRate] DEFAULT ((0)),
[NonAdjustedCoveredCopies] [decimal] (18, 6) NULL,
[BaseRatePerCopy] [decimal] (18, 6) NULL,
[NonAdjustedBaseRatePerCopy] [decimal] (18, 6) NULL,
[NextCoveredCopiesDate] [datetime] NULL,
[BilledCoveredCopies] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCProposalMeterGroups_BilledCoveredCopies] DEFAULT ((0)),
[CoveredCopiesPer] [int] NOT NULL CONSTRAINT [DF_SCProposalMeterGroups_CoveredCopiesPer] DEFAULT ((0)),
[DistCodeID] [int] NOT NULL CONSTRAINT [DF_SCProposalMeterGroups_DistcodeID] DEFAULT ((0)),
[BillMeterGroupBaseAmount] [bit] NOT NULL CONSTRAINT [DF_SCProposalMeterGroups_BillMeterGroupBaseAmount] DEFAULT ((0)),
[RoundBaseAmountDigits] [int] NOT NULL CONSTRAINT [DF_SCProposalMeterGroups_RoundBaseAmountDigits] DEFAULT ((2))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCProposalMeterGroups] ADD CONSTRAINT [PK__SCPropos__75F2D088AE59654F] PRIMARY KEY CLUSTERED ([BillingMeterGroupID]) ON [PRIMARY]
GO