Tables [dbo].[SCProposalMeters]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:59:29 AM Thursday, March 21, 2019
Last Modified1:15:09 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_SCProposalMeters: BillingMeterIDBillingMeterIDint4
False
1 - 1
BillingMeterGroupIDint4
False
MeterIDint4
False
MeterTypevarchar(15)15
True
MeterDescriptionvarchar(50)50
False
EquipmentIDint4
False
BeginMeterReadingIDint4
True
BeginMeterDisplaydecimal(18,6)9
True
BeginMeterActualdecimal(18,6)9
True
BeginMeterDatedatetime8
True
EndMeterReadingIDint4
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
BillingEquipmentIDint4
False
EquipmentInstanceint4
False
((1))
BeginMeterReadingIsEstimatebit1
False
((0))
EndMeterReadingIsEstimatebit1
False
((0))
DistOverageAmountmoney8
False
((0))
DistPercentdecimal(8,6)5
False
((0))
DistBillableCopiesdecimal(18,6)9
True
((0))
Voidbit1
False
((0))
CreatorIDchar(8)8
True
UpdatorIDchar(8)8
True
CreateDatedatetime8
True
LastUpdatedatetime8
True
timestamptimestamp8
False
DistTaxAmountmoney8
False
((0))
DistBaseAmountmoney8
False
((0))
Foreign Keys FK_SCProposalMeters_SCContractDetailID_SCContractDetails: [dbo].[SCContractDetails].SCContractDetailIDSCContractDetailIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCProposalMeters: BillingMeterIDPK_SCProposalMetersBillingMeterID
True
80
NameColumns
FK_SCProposalMeters_SCContractDetailID_SCContractDetailsSCContractDetailID->[dbo].[SCContractDetails].[ContractDetailID]
CREATE TABLE [dbo].[SCProposalMeters]
(
[BillingMeterID] [int] NOT NULL IDENTITY(1, 1),
[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,
[BillingEquipmentID] [int] NOT NULL,
[EquipmentInstance] [int] NOT NULL CONSTRAINT [DF_SCProposalMeters_EquipmentInstance] DEFAULT ((1)),
[BeginMeterReadingIsEstimate] [bit] NOT NULL CONSTRAINT [DF_SCProposalMeters_BeginMeterReadingIsEstimate] DEFAULT ((0)),
[EndMeterReadingIsEstimate] [bit] NOT NULL CONSTRAINT [DF_SCProposalMeters_EndMeterReadingIsEstimate] DEFAULT ((0)),
[DistOverageAmount] [money] NOT NULL CONSTRAINT [DF_SCProposalMeters_DistOverageAmount] DEFAULT ((0)),
[DistPercent] [decimal] (8, 6) NOT NULL CONSTRAINT [DF_SCProposalMeters_DistPercent] DEFAULT ((0)),
[DistBillableCopies] [decimal] (18, 6) NULL CONSTRAINT [DF_SCProposalMeters_DistBillableCopies] DEFAULT ((0)),
[Void] [bit] NOT NULL CONSTRAINT [DF_SCProposalMeters_Void] DEFAULT ((0)),
[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_SCProposalMeters_DistTaxAmount] DEFAULT ((0)),
[DistBaseAmount] [money] NOT NULL CONSTRAINT [DF_SCProposalMeters_DistBaseAmount] DEFAULT ((0)),
[SCContractDetailID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCProposalMeters] ADD CONSTRAINT [PK_SCProposalMeters] PRIMARY KEY CLUSTERED  ([BillingMeterID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCProposalMeters] ADD CONSTRAINT [FK_SCProposalMeters_SCContractDetailID_SCContractDetails] FOREIGN KEY ([SCContractDetailID]) REFERENCES [dbo].[SCContractDetails] ([ContractDetailID])
GO