CREATE TABLE [dbo].[SCContractDetailMeters]
(
[ContractDetailID] [int] NOT NULL,
[ContractMeterGroupID] [int] NULL,
[MeterID] [int] NOT NULL,
[EquipmentID] [int] NOT NULL,
[ExpStartMeterReadingID] [int] NULL,
[ExpEndMeterReadingID] [int] NULL,
[ExpStartMeterActual] [decimal] (18, 6) NULL,
[ExpEndMeterActual] [decimal] (18, 6) NULL,
[AccumCopies] [decimal] (18, 6) NULL,
[Active] [bit] NOT NULL,
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_SCContractDetailMeters_CreateDate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[ExpEndMeterDate] [datetime] NULL,
[ExpStartMeterDate] [datetime] NULL,
[ExpEndMeterDisplay] [decimal] (18, 6) NULL,
[ExpStartMeterDisplay] [decimal] (18, 6) NULL,
[AvgMonthlyVolume] [decimal] (18, 6) NULL,
[FirstBilledMeterReadingID] [int] NULL,
[FirstBilledMeterReadingDate] [datetime] NULL,
[FirstBilledMeterReadingDisplay] [decimal] (18, 6) NULL,
[FirstBilledMeterReadingActual] [decimal] (18, 6) NULL,
[LastBilledMeterReadingID] [int] NULL,
[LastBilledMeterReadingDate] [datetime] NULL,
[LastBilledMeterReadingDisplay] [decimal] (18, 6) NULL,
[LastBilledMeterReadingActual] [decimal] (18, 6) NULL,
[ExpectedMonthlyVolume] [decimal] (18, 4) NOT NULL CONSTRAINT [DF_SCContractDetailMeters_ExpectedMonthlyVolume] DEFAULT ((0)),
[ActualMonthlyVolume] [decimal] (18, 4) NULL,
[StartCoveredCopies] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCContractDetailMeters_StartCoveredCopies] DEFAULT ((0)),
[EndCoveredCopies] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCContractDetailMeters_EndCoveredCopies] DEFAULT ((0)),
[ProrateStartAutoCalculate] [bit] NOT NULL CONSTRAINT [DF_SCContractDetailMeters_ProrateStartAutoCalculate] DEFAULT ((1)),
[ProrateEndAutoCalculate] [bit] NOT NULL CONSTRAINT [DF_SCContractDetailMeters_ProrateEndAutoCalculate] DEFAULT ((1)),
[ProrateStartCoveredCopies] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCContractDetailMeters_ProrateStartCoveredCopies] DEFAULT ((0)),
[ProrateEndCoveredCopies] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCContractDetailMeters_ProrateEndCoveredCopies] DEFAULT ((0)),
[BilledCoveredCopiesBalance] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCContractDetailMeters_BilledCoveredCopiesBalance] DEFAULT ((0)),
[UnearnedCoveredCopiesBalance] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCContractDetailMeters_UnearnedCoveredCopiesBalance] DEFAULT ((0)),
[UnearnedBalance] [money] NOT NULL CONSTRAINT [DF_SCContractDetailMeters_UnearnedBalance] DEFAULT ((0)),
[BilledCoveredCopiesBalanceAdjustment] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCContractDetailMeters_BilledCoveredCopiesBalanceAdjustment] DEFAULT ((0)),
[StartCoveredCopiesHasBeenSet] [bit] NOT NULL CONSTRAINT [DF_SCContractDetailMeters_StartCoveredCopiesHasBeenSet] DEFAULT ((0)),
[EndCoveredCopiesHasBeenSet] [bit] NOT NULL CONSTRAINT [DF_SCContractDetailMeters_EndCoveredCopiesHasBeenSet] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCContractDetailMeters] ADD CONSTRAINT [PK_SCContractDetailMeters] PRIMARY KEY CLUSTERED ([ContractDetailID], [MeterID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCContractDetailMeters] ADD CONSTRAINT [FK_SCContractDetailMeters_ContractDetailID_SCContractDetails] FOREIGN KEY ([ContractDetailID]) REFERENCES [dbo].[SCContractDetails] ([ContractDetailID])
GO
ALTER TABLE [dbo].[SCContractDetailMeters] ADD CONSTRAINT [FK_SCContractDetailMeters_ContractMeterGroupID_SCContractMeterGroups] FOREIGN KEY ([ContractMeterGroupID]) REFERENCES [dbo].[SCContractMeterGroups] ([ContractMeterGroupID])
GO
ALTER TABLE [dbo].[SCContractDetailMeters] ADD CONSTRAINT [FK_SCContractDetailMeters_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SCContractDetailMeters] ADD CONSTRAINT [FK_SCContractDetailMeters_ExpEndMeterReadingID_MTMeterReadings] FOREIGN KEY ([ExpEndMeterReadingID]) REFERENCES [dbo].[MTMeterReadings] ([MeterReadingID])
GO
ALTER TABLE [dbo].[SCContractDetailMeters] ADD CONSTRAINT [FK_SCContractDetailMeters_ExpStartMeterReadingID_MTMeterReadings] FOREIGN KEY ([ExpStartMeterReadingID]) REFERENCES [dbo].[MTMeterReadings] ([MeterReadingID])
GO
ALTER TABLE [dbo].[SCContractDetailMeters] ADD CONSTRAINT [FK_SCContractDetailMeters_FirstBilledMeterReadingID_MTMeterReadings] FOREIGN KEY ([FirstBilledMeterReadingID]) REFERENCES [dbo].[MTMeterReadings] ([MeterReadingID])
GO
ALTER TABLE [dbo].[SCContractDetailMeters] ADD CONSTRAINT [FK_SCContractDetailMeters_LastBilledMeterReadingID_MTMeterReadings] FOREIGN KEY ([LastBilledMeterReadingID]) REFERENCES [dbo].[MTMeterReadings] ([MeterReadingID])
GO
ALTER TABLE [dbo].[SCContractDetailMeters] ADD CONSTRAINT [FK_SCContractDetailMeters_MeterID_MTMeters] FOREIGN KEY ([MeterID]) REFERENCES [dbo].[MTMeters] ([MeterID])
GO