Tables [dbo].[SCProposalMeterGroups]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:59:28 AM Thursday, March 21, 2019
Last Modified1:15:09 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK__SCPropos__75F2D088AE59654F: BillingMeterGroupIDBillingMeterGroupIDint4
False
1 - 1
ProposalIDint4
False
ContractDetailIDint4
False
ContractMeterGroupvarchar(64)64
True
ContractMeterGroupDescriptionvarchar(128)128
True
CoveredCopiesdecimal(18,6)9
True
OvgChargeTypechar(1)1
True
OverageMethodIDint4
False
((1))
GroupCopiesdecimal(18,6)9
True
CountedCopiesdecimal(18,6)9
True
BillableCopiesdecimal(18,6)9
True
TotalChargeAmountmoney8
True
EffectiveRatedecimal(16,6)9
True
QIDint4
True
ContractMeterGroupIDint4
True
MeterCountint4
False
CreatorIDchar(8)8
True
UpdatorIDchar(8)8
True
CreateDatedatetime8
True
LastUpdatedatetime8
True
timestamptimestamp8
False
DistTaxAmountmoney8
False
((0))
NextCoveredCopiesdecimal(18,6)9
True
OverageAmountmoney8
True
BaseAmountmoney8
True
AvgGroupRatedecimal(18,6)9
False
((0))
NonAdjustedCoveredCopiesdecimal(18,6)9
True
BaseRatePerCopydecimal(18,6)9
True
NonAdjustedBaseRatePerCopydecimal(18,6)9
True
NextCoveredCopiesDatedatetime8
True
BilledCoveredCopiesdecimal(18,6)9
False
((0))
CoveredCopiesPerint4
False
((0))
DistCodeIDint4
False
((0))
BillMeterGroupBaseAmountbit1
False
((0))
RoundBaseAmountDigitsint4
False
((2))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK__SCPropos__75F2D088AE59654F: BillingMeterGroupIDPK__SCPropos__75F2D088AE59654FBillingMeterGroupID
True
80
CREATE TABLE [dbo].[SCProposalMeterGroups]
(
[BillingMeterGroupID] [int] NOT NULL IDENTITY(1, 1),
[ProposalID] [int] NOT NULL,
[ContractDetailID] [int] NOT NULL,
[ContractMeterGroup] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContractMeterGroupDescription] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CoveredCopies] [decimal] (18, 6) NULL,
[OvgChargeType] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OverageMethodID] [int] NOT NULL CONSTRAINT [DF_SCProposalMeterGroups_OverageMethodID] DEFAULT ((1)),
[GroupCopies] [decimal] (18, 6) NULL,
[CountedCopies] [decimal] (18, 6) NULL,
[BillableCopies] [decimal] (18, 6) NULL,
[TotalChargeAmount] [money] NULL,
[EffectiveRate] [decimal] (16, 6) NULL,
[QID] [int] NULL,
[ContractMeterGroupID] [int] NULL,
[MeterCount] [int] NOT 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] NOT NULL,
[DistTaxAmount] [money] NOT NULL CONSTRAINT [DF_SCProposalMeterGroups_DistTaxAmount] DEFAULT ((0)),
[NextCoveredCopies] [decimal] (18, 6) NULL,
[OverageAmount] [money] NULL,
[BaseAmount] [money] NULL,
[AvgGroupRate] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCProposalMeterGroups_AvgGroupRate] DEFAULT ((0)),
[NonAdjustedCoveredCopies] [decimal] (18, 6) NULL,
[BaseRatePerCopy] [decimal] (18, 6) NULL,
[NonAdjustedBaseRatePerCopy] [decimal] (18, 6) NULL,
[NextCoveredCopiesDate] [datetime] NULL,
[BilledCoveredCopies] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCProposalMeterGroups_BilledCoveredCopies] DEFAULT ((0)),
[CoveredCopiesPer] [int] NOT NULL CONSTRAINT [DF_SCProposalMeterGroups_CoveredCopiesPer] DEFAULT ((0)),
[DistCodeID] [int] NOT NULL CONSTRAINT [DF_SCProposalMeterGroups_DistcodeID] DEFAULT ((0)),
[BillMeterGroupBaseAmount] [bit] NOT NULL CONSTRAINT [DF_SCProposalMeterGroups_BillMeterGroupBaseAmount] DEFAULT ((0)),
[RoundBaseAmountDigits] [int] NOT NULL CONSTRAINT [DF_SCProposalMeterGroups_RoundBaseAmountDigits] DEFAULT ((2))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCProposalMeterGroups] ADD CONSTRAINT [PK__SCPropos__75F2D088AE59654F] PRIMARY KEY CLUSTERED  ([BillingMeterGroupID]) ON [PRIMARY]
GO