Tables [dbo].[SCContractDetailMeters]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:56:00 AM Thursday, March 21, 2019
Last Modified1:14:55 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_SCContractDetailMeters: ContractDetailID\MeterIDForeign Keys FK_SCContractDetailMeters_ContractDetailID_SCContractDetails: [dbo].[SCContractDetails].ContractDetailIDContractDetailIDint4
False
Foreign Keys FK_SCContractDetailMeters_ContractMeterGroupID_SCContractMeterGroups: [dbo].[SCContractMeterGroups].ContractMeterGroupIDContractMeterGroupIDint4
True
Cluster Primary Key PK_SCContractDetailMeters: ContractDetailID\MeterIDForeign Keys FK_SCContractDetailMeters_MeterID_MTMeters: [dbo].[MTMeters].MeterIDMeterIDint4
False
Foreign Keys FK_SCContractDetailMeters_EquipmentID_SCEquipments: [dbo].[SCEquipments].EquipmentIDEquipmentIDint4
False
Foreign Keys FK_SCContractDetailMeters_ExpStartMeterReadingID_MTMeterReadings: [dbo].[MTMeterReadings].ExpStartMeterReadingIDExpStartMeterReadingIDint4
True
Foreign Keys FK_SCContractDetailMeters_ExpEndMeterReadingID_MTMeterReadings: [dbo].[MTMeterReadings].ExpEndMeterReadingIDExpEndMeterReadingIDint4
True
ExpStartMeterActualdecimal(18,6)9
True
ExpEndMeterActualdecimal(18,6)9
True
AccumCopiesdecimal(18,6)9
True
Activebit1
False
CreatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
timestamptimestamp8
True
ExpEndMeterDatedatetime8
True
ExpStartMeterDatedatetime8
True
ExpEndMeterDisplaydecimal(18,6)9
True
ExpStartMeterDisplaydecimal(18,6)9
True
AvgMonthlyVolumedecimal(18,6)9
True
Foreign Keys FK_SCContractDetailMeters_FirstBilledMeterReadingID_MTMeterReadings: [dbo].[MTMeterReadings].FirstBilledMeterReadingIDFirstBilledMeterReadingIDint4
True
FirstBilledMeterReadingDatedatetime8
True
FirstBilledMeterReadingDisplaydecimal(18,6)9
True
FirstBilledMeterReadingActualdecimal(18,6)9
True
Foreign Keys FK_SCContractDetailMeters_LastBilledMeterReadingID_MTMeterReadings: [dbo].[MTMeterReadings].LastBilledMeterReadingIDLastBilledMeterReadingIDint4
True
LastBilledMeterReadingDatedatetime8
True
LastBilledMeterReadingDisplaydecimal(18,6)9
True
LastBilledMeterReadingActualdecimal(18,6)9
True
ExpectedMonthlyVolumedecimal(18,4)9
False
((0))
ActualMonthlyVolumedecimal(18,4)9
True
StartCoveredCopiesdecimal(18,6)9
False
((0))
EndCoveredCopiesdecimal(18,6)9
False
((0))
ProrateStartAutoCalculatebit1
False
((1))
ProrateEndAutoCalculatebit1
False
((1))
ProrateStartCoveredCopiesdecimal(18,6)9
False
((0))
ProrateEndCoveredCopiesdecimal(18,6)9
False
((0))
BilledCoveredCopiesBalancedecimal(18,6)9
False
((0))
UnearnedCoveredCopiesBalancedecimal(18,6)9
False
((0))
UnearnedBalancemoney8
False
((0))
BilledCoveredCopiesBalanceAdjustmentdecimal(18,6)9
False
((0))
StartCoveredCopiesHasBeenSetbit1
False
((0))
EndCoveredCopiesHasBeenSetbit1
False
((0))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCContractDetailMeters: ContractDetailID\MeterIDPK_SCContractDetailMetersContractDetailID, MeterID
True
80
NameColumns
FK_SCContractDetailMeters_ContractDetailID_SCContractDetailsContractDetailID->[dbo].[SCContractDetails].[ContractDetailID]
FK_SCContractDetailMeters_ContractMeterGroupID_SCContractMeterGroupsContractMeterGroupID->[dbo].[SCContractMeterGroups].[ContractMeterGroupID]
FK_SCContractDetailMeters_EquipmentID_SCEquipmentsEquipmentID->[dbo].[SCEquipments].[EquipmentID]
FK_SCContractDetailMeters_ExpEndMeterReadingID_MTMeterReadingsExpEndMeterReadingID->[dbo].[MTMeterReadings].[MeterReadingID]
FK_SCContractDetailMeters_ExpStartMeterReadingID_MTMeterReadingsExpStartMeterReadingID->[dbo].[MTMeterReadings].[MeterReadingID]
FK_SCContractDetailMeters_FirstBilledMeterReadingID_MTMeterReadingsFirstBilledMeterReadingID->[dbo].[MTMeterReadings].[MeterReadingID]
FK_SCContractDetailMeters_LastBilledMeterReadingID_MTMeterReadingsLastBilledMeterReadingID->[dbo].[MTMeterReadings].[MeterReadingID]
FK_SCContractDetailMeters_MeterID_MTMetersMeterID->[dbo].[MTMeters].[MeterID]
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
  • [dbo].[v_SCContractDetailMeters]