Tables [dbo].[SCQBillingMeters]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:59:58 AM Thursday, March 21, 2019
Last Modified1:15:18 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Foreign Keys FK_SCQBillingMeters_BillingMeterGroupID_SCQBillingMeterGroups: [dbo].[SCQBillingMeterGroups].BillingMeterGroupIDBillingMeterGroupIDint4
False
Foreign Keys FK_SCQBillingMeters_MeterID_MTMeters: [dbo].[MTMeters].MeterIDMeterIDint4
False
MeterTypevarchar(15)15
True
MeterDescriptionvarchar(50)50
False
Foreign Keys FK_SCQBillingMeters_EquipmentID_SCEquipments: [dbo].[SCEquipments].EquipmentIDEquipmentIDint4
False
Foreign Keys FK_SCQBillingMeters_BeginMeterReadingID_MTMeterReadings: [dbo].[MTMeterReadings].BeginMeterReadingIDBeginMeterReadingIDint4
True
BeginMeterDisplaydecimal(18,6)9
True
BeginMeterActualdecimal(18,6)9
True
BeginMeterDatedatetime8
True
Foreign Keys FK_SCQBillingMeters_EndMeterReadingID_MTMeterReadings: [dbo].[MTMeterReadings].EndMeterReadingIDEndMeterReadingIDint4
True
EndMeterDisplaydecimal(18,6)9
True
EndMeterActualdecimal(18,6)9
True
EndMeterDatedatetime8
True
DifferenceCopiesdecimal(18,6)9
True
CreditCopiesdecimal(18,6)9
True
CountedCopiesdecimal(18,6)9
True
CreatorIDchar(8)8
True
UpdatorIDchar(8)8
True
CreateDatedatetime8
True
LastUpdatedatetime8
True
timestamptimestamp8
True
Cluster Primary Key PK_SCQBillingMeters: BillingMeterIDBillingMeterIDint4
False
1 - 1
Foreign Keys FK_SCQBillingMeters_BillingEquipmentID_SCQBillingEquipments: [dbo].[SCQBillingEquipments].BillingEquipmentIDBillingEquipmentIDint4
False
Foreign Keys FK_SCQBillingMeters_SCContractDetailID_SCContractDetails: [dbo].[SCContractDetails].SCContractDetailIDSCContractDetailIDint4
False
BeginMeterReadingIsEstimatebit1
False
((0))
EndMeterReadingIsEstimatebit1
False
((0))
Foreign Keys FK_SCQBillingMeters_LastBilledMeterReadingID_MTMeterReadings: [dbo].[MTMeterReadings].LastBilledMeterReadingIDLastBilledMeterReadingIDint4
True
LastBilledMeterDisplaydecimal(18,6)9
True
LastBilledMeterActualdecimal(18,6)9
True
LastBilledMeterDatedatetime8
True
BilledAvgDailyVolumedecimal(18,2)9
True
WarningMsgvarchar(255)255
True
DistOverageAmountmoney8
False
((0))
DistPercentdecimal(18,6)9
False
((0))
DistBillableCopiesdecimal(18,6)9
True
((0))
DistTaxAmountmoney8
False
((0))
ExpectedMonthlyVolumedecimal(18,4)9
False
((0))
DistBaseAmountmoney8
False
((0))
DistContractAdjOverageAmountmoney8
False
((0))
MeterDetailIDint4
False
EquipmentDetailIDint4
False
MeterGroupDetailIDint4
False
DistBilledCoveredCopiesdecimal(18,6)9
False
((0))
DistUsedCoveredCopiesdecimal(18,6)9
False
((0))
BilledCoveredCopiesBalancedecimal(18,6)9
False
((0))
NewActualMonthlyVolumedecimal(18,6)9
True
TrueUpBaseCycleChargeDetailIDint4
True
OverageFromDatedatetime8
True
OverageToDatedatetime8
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCQBillingMeters: BillingMeterIDPK_SCQBillingMetersBillingMeterID
True
80
NameColumns
FK_SCQBillingMeters_BeginMeterReadingID_MTMeterReadingsBeginMeterReadingID->[dbo].[MTMeterReadings].[MeterReadingID]
FK_SCQBillingMeters_BillingEquipmentID_SCQBillingEquipmentsBillingEquipmentID->[dbo].[SCQBillingEquipments].[BillingEquipmentID]
FK_SCQBillingMeters_BillingMeterGroupID_SCQBillingMeterGroupsBillingMeterGroupID->[dbo].[SCQBillingMeterGroups].[BillingMeterGroupID]
FK_SCQBillingMeters_EndMeterReadingID_MTMeterReadingsEndMeterReadingID->[dbo].[MTMeterReadings].[MeterReadingID]
FK_SCQBillingMeters_EquipmentID_SCEquipmentsEquipmentID->[dbo].[SCEquipments].[EquipmentID]
FK_SCQBillingMeters_LastBilledMeterReadingID_MTMeterReadingsLastBilledMeterReadingID->[dbo].[MTMeterReadings].[MeterReadingID]
FK_SCQBillingMeters_MeterID_MTMetersMeterID->[dbo].[MTMeters].[MeterID]
FK_SCQBillingMeters_SCContractDetailID_SCContractDetailsSCContractDetailID->[dbo].[SCContractDetails].[ContractDetailID]
CREATE TABLE [dbo].[SCQBillingMeters]
(
[BillingMeterGroupID] [int] NOT NULL,
[MeterID] [int] NOT NULL,
[MeterType] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MeterDescription] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[EquipmentID] [int] NOT NULL,
[BeginMeterReadingID] [int] NULL,
[BeginMeterDisplay] [decimal] (18, 6) NULL,
[BeginMeterActual] [decimal] (18, 6) NULL,
[BeginMeterDate] [datetime] NULL,
[EndMeterReadingID] [int] NULL,
[EndMeterDisplay] [decimal] (18, 6) NULL,
[EndMeterActual] [decimal] (18, 6) NULL,
[EndMeterDate] [datetime] NULL,
[DifferenceCopies] [decimal] (18, 6) NULL,
[CreditCopies] [decimal] (18, 6) NULL,
[CountedCopies] [decimal] (18, 6) 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,
[BillingMeterID] [int] NOT NULL IDENTITY(1, 1),
[BillingEquipmentID] [int] NOT NULL,
[SCContractDetailID] [int] NOT NULL,
[BeginMeterReadingIsEstimate] [bit] NOT NULL CONSTRAINT [DF_SCQBillingMeters_BeginMeterReadingIsEstimate] DEFAULT ((0)),
[EndMeterReadingIsEstimate] [bit] NOT NULL CONSTRAINT [DF_SCQBillingMeters_EndMeterReadingIsEstimate] DEFAULT ((0)),
[LastBilledMeterReadingID] [int] NULL,
[LastBilledMeterDisplay] [decimal] (18, 6) NULL,
[LastBilledMeterActual] [decimal] (18, 6) NULL,
[LastBilledMeterDate] [datetime] NULL,
[BilledAvgDailyVolume] [decimal] (18, 2) NULL,
[WarningMsg] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DistOverageAmount] [money] NOT NULL CONSTRAINT [DF_SCQBillingMeters_DistOverageAmount] DEFAULT ((0)),
[DistPercent] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCQBillingMeters_DistPercent] DEFAULT ((0)),
[DistBillableCopies] [decimal] (18, 6) NULL CONSTRAINT [DF_SCQBillingMeters_DistBillableCopies] DEFAULT ((0)),
[DistTaxAmount] [money] NOT NULL CONSTRAINT [DF_SCQBillingMeters_DistTaxAmount] DEFAULT ((0)),
[ExpectedMonthlyVolume] [decimal] (18, 4) NOT NULL CONSTRAINT [DF_SCQBillingMeters_ExpectedMonthlyVolume] DEFAULT ((0)),
[DistBaseAmount] [money] NOT NULL CONSTRAINT [DF_SCQBillingMeters_DistBaseAmount] DEFAULT ((0)),
[DistContractAdjOverageAmount] [money] NOT NULL CONSTRAINT [DF_SCQBillingMeters_DistContractAdjOverageAmount] DEFAULT ((0)),
[MeterDetailID] [int] NOT NULL,
[EquipmentDetailID] [int] NOT NULL,
[MeterGroupDetailID] [int] NOT NULL,
[DistBilledCoveredCopies] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCQBillingMeters_DistBilledCoveredCopies] DEFAULT ((0)),
[DistUsedCoveredCopies] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCQBillingMeters_DistUsedCoveredCopies] DEFAULT ((0)),
[BilledCoveredCopiesBalance] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCQBillingMeters_BilledCoveredCopiesBalance] DEFAULT ((0)),
[NewActualMonthlyVolume] [decimal] (18, 6) NULL,
[TrueUpBaseCycleChargeDetailID] [int] NULL,
[OverageFromDate] [datetime] NULL,
[OverageToDate] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQBillingMeters] ADD CONSTRAINT [PK_SCQBillingMeters] PRIMARY KEY CLUSTERED  ([BillingMeterID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQBillingMeters] ADD CONSTRAINT [FK_SCQBillingMeters_BeginMeterReadingID_MTMeterReadings] FOREIGN KEY ([BeginMeterReadingID]) REFERENCES [dbo].[MTMeterReadings] ([MeterReadingID])
GO
ALTER TABLE [dbo].[SCQBillingMeters] ADD CONSTRAINT [FK_SCQBillingMeters_BillingEquipmentID_SCQBillingEquipments] FOREIGN KEY ([BillingEquipmentID]) REFERENCES [dbo].[SCQBillingEquipments] ([BillingEquipmentID])
GO
ALTER TABLE [dbo].[SCQBillingMeters] ADD CONSTRAINT [FK_SCQBillingMeters_BillingMeterGroupID_SCQBillingMeterGroups] FOREIGN KEY ([BillingMeterGroupID]) REFERENCES [dbo].[SCQBillingMeterGroups] ([BillingMeterGroupID])
GO
ALTER TABLE [dbo].[SCQBillingMeters] ADD CONSTRAINT [FK_SCQBillingMeters_EndMeterReadingID_MTMeterReadings] FOREIGN KEY ([EndMeterReadingID]) REFERENCES [dbo].[MTMeterReadings] ([MeterReadingID])
GO
ALTER TABLE [dbo].[SCQBillingMeters] ADD CONSTRAINT [FK_SCQBillingMeters_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SCQBillingMeters] ADD CONSTRAINT [FK_SCQBillingMeters_LastBilledMeterReadingID_MTMeterReadings] FOREIGN KEY ([LastBilledMeterReadingID]) REFERENCES [dbo].[MTMeterReadings] ([MeterReadingID])
GO
ALTER TABLE [dbo].[SCQBillingMeters] ADD CONSTRAINT [FK_SCQBillingMeters_MeterID_MTMeters] FOREIGN KEY ([MeterID]) REFERENCES [dbo].[MTMeters] ([MeterID])
GO
ALTER TABLE [dbo].[SCQBillingMeters] ADD CONSTRAINT [FK_SCQBillingMeters_SCContractDetailID_SCContractDetails] FOREIGN KEY ([SCContractDetailID]) REFERENCES [dbo].[SCContractDetails] ([ContractDetailID])
GO