Tables [dbo].[SCBillingMeters]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:55:44 AM Thursday, March 21, 2019
Last Modified1:14:43 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Foreign Keys FK_SCBillingMeters_BillingMeterGroupID_SCBillingMeterGroups: [dbo].[SCBillingMeterGroups].BillingMeterGroupIDBillingMeterGroupIDint4
False
Foreign Keys FK_SCBillingMeters_MeterID_MTMeters: [dbo].[MTMeters].MeterIDMeterIDint4
False
MeterTypevarchar(15)15
True
MeterDescriptionvarchar(50)50
False
Foreign Keys FK_SCBillingMeters_EquipmentID_SCEquipments: [dbo].[SCEquipments].EquipmentIDEquipmentIDint4
False
Foreign Keys FK_SCBillingMeters_BeginMeterReadingID_MTMeterReadings: [dbo].[MTMeterReadings].BeginMeterReadingIDBeginMeterReadingIDint4
True
BeginMeterDisplaydecimal(18,6)9
True
BeginMeterActualdecimal(18,6)9
True
BeginMeterDatedatetime8
True
Foreign Keys FK_SCBillingMeters_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
Voidbit1
False
((0))
Foreign Keys FK_SCBillingMeters_BillingEquipmentID_SCBillingEquipments: [dbo].[SCBillingEquipments].BillingEquipmentIDBillingEquipmentIDint4
False
BeginMeterReadingIsEstimatebit1
False
((0))
EndMeterReadingIsEstimatebit1
False
((0))
Cluster Primary Key PK_SCBillingMeters: BillingMeterIDBillingMeterIDint4
False
1 - 1
DistOverageAmountmoney8
False
((0))
DistPercentdecimal(18,6)9
False
((0))
DistBillableCopiesdecimal(18,6)9
True
((0))
DistTaxAmountmoney8
False
((0))
ExpectedMonthlyVolumedecimal(18,6)9
False
((0))
DistBaseAmountmoney8
False
((0))
DistContractAdjOverageAmountmoney8
False
((0))
DistBilledCoveredCopiesdecimal(18,6)9
False
((0))
DistUsedCoveredCopiesdecimal(18,6)9
False
((0))
BilledCoveredCopiesBalancedecimal(18,6)9
False
((0))
OverageFromDatedatetime8
True
OverageToDatedatetime8
True
Foreign Keys FK_SCBillingMeters_SCContractDetailID_SCContractDetails: [dbo].[SCContractDetails].SCContractDetailIDSCContractDetailIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCBillingMeters: BillingMeterIDPK_SCBillingMetersBillingMeterID
True
80
NameColumns
FK_SCBillingMeters_BeginMeterReadingID_MTMeterReadingsBeginMeterReadingID->[dbo].[MTMeterReadings].[MeterReadingID]
FK_SCBillingMeters_BillingEquipmentID_SCBillingEquipmentsBillingEquipmentID->[dbo].[SCBillingEquipments].[BillingEquipmentID]
FK_SCBillingMeters_BillingMeterGroupID_SCBillingMeterGroupsBillingMeterGroupID->[dbo].[SCBillingMeterGroups].[BillingMeterGroupID]
FK_SCBillingMeters_EndMeterReadingID_MTMeterReadingsEndMeterReadingID->[dbo].[MTMeterReadings].[MeterReadingID]
FK_SCBillingMeters_EquipmentID_SCEquipmentsEquipmentID->[dbo].[SCEquipments].[EquipmentID]
FK_SCBillingMeters_MeterID_MTMetersMeterID->[dbo].[MTMeters].[MeterID]
FK_SCBillingMeters_SCContractDetailID_SCContractDetailsSCContractDetailID->[dbo].[SCContractDetails].[ContractDetailID]
CREATE TABLE [dbo].[SCBillingMeters]
(
[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,
[Void] [bit] NOT NULL CONSTRAINT [DF_SCBillingMeters_Void] DEFAULT ((0)),
[BillingEquipmentID] [int] NOT NULL,
[BeginMeterReadingIsEstimate] [bit] NOT NULL CONSTRAINT [DF_SCBillingMeters_BeginMeterReadingIsEstimate] DEFAULT ((0)),
[EndMeterReadingIsEstimate] [bit] NOT NULL CONSTRAINT [DF_SCBillingMeters_EndMeterReadingIsEstimate] DEFAULT ((0)),
[BillingMeterID] [int] NOT NULL IDENTITY(1, 1),
[DistOverageAmount] [money] NOT NULL CONSTRAINT [DF_SCBillingMeters_DistOverageAmount] DEFAULT ((0)),
[DistPercent] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCBillingMeters_DistPercent] DEFAULT ((0)),
[DistBillableCopies] [decimal] (18, 6) NULL CONSTRAINT [DF_SCBillingMeters_DistBillableCopies] DEFAULT ((0)),
[DistTaxAmount] [money] NOT NULL CONSTRAINT [DF_SCBillingMeters_DistTaxAmount] DEFAULT ((0)),
[ExpectedMonthlyVolume] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCBillingMeters_ExpectedMonthlyVolume] DEFAULT ((0)),
[DistBaseAmount] [money] NOT NULL CONSTRAINT [DF_SCBillingMeters_DistBaseAmount] DEFAULT ((0)),
[DistContractAdjOverageAmount] [money] NOT NULL CONSTRAINT [DF_SCBillingMeters_DistContractAdjOverageAmount] DEFAULT ((0)),
[DistBilledCoveredCopies] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCBillingMeters_DistBilledCoveredCopies] DEFAULT ((0)),
[DistUsedCoveredCopies] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCBillingMeters_DistUsedCoveredCopies] DEFAULT ((0)),
[BilledCoveredCopiesBalance] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCBillingMeters_BilledCoveredCopiesBalance] DEFAULT ((0)),
[OverageFromDate] [datetime] NULL,
[OverageToDate] [datetime] NULL,
[SCContractDetailID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCBillingMeters] ADD CONSTRAINT [PK_SCBillingMeters] PRIMARY KEY CLUSTERED  ([BillingMeterID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCBillingMeters] ADD CONSTRAINT [FK_SCBillingMeters_BeginMeterReadingID_MTMeterReadings] FOREIGN KEY ([BeginMeterReadingID]) REFERENCES [dbo].[MTMeterReadings] ([MeterReadingID])
GO
ALTER TABLE [dbo].[SCBillingMeters] ADD CONSTRAINT [FK_SCBillingMeters_BillingEquipmentID_SCBillingEquipments] FOREIGN KEY ([BillingEquipmentID]) REFERENCES [dbo].[SCBillingEquipments] ([BillingEquipmentID])
GO
ALTER TABLE [dbo].[SCBillingMeters] ADD CONSTRAINT [FK_SCBillingMeters_BillingMeterGroupID_SCBillingMeterGroups] FOREIGN KEY ([BillingMeterGroupID]) REFERENCES [dbo].[SCBillingMeterGroups] ([BillingMeterGroupID])
GO
ALTER TABLE [dbo].[SCBillingMeters] ADD CONSTRAINT [FK_SCBillingMeters_EndMeterReadingID_MTMeterReadings] FOREIGN KEY ([EndMeterReadingID]) REFERENCES [dbo].[MTMeterReadings] ([MeterReadingID])
GO
ALTER TABLE [dbo].[SCBillingMeters] ADD CONSTRAINT [FK_SCBillingMeters_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SCBillingMeters] ADD CONSTRAINT [FK_SCBillingMeters_MeterID_MTMeters] FOREIGN KEY ([MeterID]) REFERENCES [dbo].[MTMeters] ([MeterID])
GO
ALTER TABLE [dbo].[SCBillingMeters] ADD CONSTRAINT [FK_SCBillingMeters_SCContractDetailID_SCContractDetails] FOREIGN KEY ([SCContractDetailID]) REFERENCES [dbo].[SCContractDetails] ([ContractDetailID])
GO
  • [dbo].[v_dtf_ContractMetersBilledLast30Days]
  • [dbo].[v_dtf_EstimatedBillings]