Tables [dbo].[SCBillingMeterGroups]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:55:43 AM Thursday, March 21, 2019
Last Modified1:14:44 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK__SCBillin__75F2D0888D8C2BBF: BillingMeterGroupIDBillingMeterGroupIDint4
False
1 - 1
Foreign Keys FK_SCBillingMeterGroups_InvoiceID_SCBillingContracts: [dbo].[SCBillingContracts].InvoiceID\ContractDetailIDInvoiceIDint4
False
Foreign Keys FK_SCBillingMeterGroups_InvoiceID_SCBillingContracts: [dbo].[SCBillingContracts].InvoiceID\ContractDetailIDContractDetailIDint4
False
ContractMeterGroupvarchar(64)64
True
ContractMeterGroupDescriptionvarchar(128)128
True
CoveredCopiesdecimal(18,6)9
True
OvgChargeTypechar(1)1
True
GroupCopiesdecimal(18,6)9
True
CountedCopiesdecimal(18,6)9
True
BillableCopiesdecimal(18,6)9
True
TotalChargeAmountmoney8
True
EffectiveRatedecimal(16,6)9
True
QIDint4
True
MeterCountint4
False
CreatorIDchar(8)8
True
UpdatorIDchar(8)8
True
CreateDatedatetime8
True
LastUpdatedatetime8
True
timestamptimestamp8
True
ContractMeterGroupIDint4
True
Foreign Keys FK_SCBillingMeterGroups_OverageMethodID_SCOverageMethods: [dbo].[SCOverageMethods].OverageMethodIDOverageMethodIDint4
False
((1))
DistTaxAmountmoney8
False
((0))
NextCoveredCopiesdecimal(18,6)9
True
AvgGroupRatedecimal(18,6)9
False
((0))
BaseAmountmoney8
True
OverageAmountmoney8
True
DistCodeIDint4
False
((0))
CoveredCopiesPerint4
False
((0))
BillMeterGroupBaseAmountbit1
False
((0))
NextCoveredCopiesDatedatetime8
True
BaseRatePerCopydecimal(18,6)9
False
((0))
RoundBaseAmountDigitsint4
False
((2))
UsedCoveredCopiesdecimal(18,6)9
False
((0))
BilledCoveredCopiesdecimal(18,6)9
False
((0))
CoveredCopiesOvgMultiplierint4
False
((1))
CoveredCopiesBaseMultiplierint4
False
((1))
NonAdjustedCoveredCopiesdecimal(18,6)9
True
NonAdjustedBaseRatePerCopydecimal(18,6)9
True
NonAdjustedNextCoveredCopiesDatedatetime8
True
Foreign Keys FK_SCBillingMeterGroups_OverageBillingCycleID_SCBillingCycles: [dbo].[SCBillingCycles].OverageBillingCycleIDOverageBillingCycleIDint4
True
OverageFromDatedatetime8
True
OverageToDatedatetime8
True
NonAdjustedOverageNextBillingDatedatetime8
True
NonAdjustedOverageLastBillingDatedatetime8
True
OverageCyclesBilledint4
True
Foreign Keys FK_SCBillingMeterGroups_BaseDistributionCodeID_SCContractBaseDistCodes: [dbo].[SCContractBaseDistCodes].BaseDistributionCodeIDBaseDistributionCodeIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK__SCBillin__75F2D0888D8C2BBF: BillingMeterGroupIDPK__SCBillin__75F2D0888D8C2BBFBillingMeterGroupID
True
80
NameColumns
FK_SCBillingMeterGroups_BaseDistributionCodeID_SCContractBaseDistCodesBaseDistributionCodeID->[dbo].[SCContractBaseDistCodes].[BaseDistributionCodeID]
FK_SCBillingMeterGroups_InvoiceID_SCBillingContractsInvoiceID->[dbo].[SCBillingContracts].[InvoiceID]
ContractDetailID->[dbo].[SCBillingContracts].[ContractDetailID]
FK_SCBillingMeterGroups_OverageBillingCycleID_SCBillingCyclesOverageBillingCycleID->[dbo].[SCBillingCycles].[BillingCycleID]
FK_SCBillingMeterGroups_OverageMethodID_SCOverageMethodsOverageMethodID->[dbo].[SCOverageMethods].[OverageMethodID]
CREATE TABLE [dbo].[SCBillingMeterGroups]
(
[BillingMeterGroupID] [int] NOT NULL IDENTITY(1, 1),
[InvoiceID] [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,
[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,
[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] NULL,
[ContractMeterGroupID] [int] NULL,
[OverageMethodID] [int] NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_OverageMethodID] DEFAULT ((1)),
[DistTaxAmount] [money] NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_DistTaxAmount] DEFAULT ((0)),
[NextCoveredCopies] [decimal] (18, 6) NULL,
[AvgGroupRate] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_AvgGroupRate] DEFAULT ((0)),
[BaseAmount] [money] NULL,
[OverageAmount] [money] NULL,
[DistCodeID] [int] NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_DistcodeID] DEFAULT ((0)),
[CoveredCopiesPer] [int] NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_CoveredCopiesPer] DEFAULT ((0)),
[BillMeterGroupBaseAmount] [bit] NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_BillMeterGroupBaseAmount] DEFAULT ((0)),
[NextCoveredCopiesDate] [datetime] NULL,
[BaseRatePerCopy] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_BaseRatePerCopy] DEFAULT ((0)),
[RoundBaseAmountDigits] [int] NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_RoundBaseAmountDigits] DEFAULT ((2)),
[UsedCoveredCopies] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_UsedCoveredCopies] DEFAULT ((0)),
[BilledCoveredCopies] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_BilledCoveredCopies] DEFAULT ((0)),
[CoveredCopiesOvgMultiplier] [int] NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_CoveredCopiesOvgMultiplier] DEFAULT ((1)),
[CoveredCopiesBaseMultiplier] [int] NOT NULL CONSTRAINT [DF_SCBillingMeterGroups_CoveredCopiesBaseMultiplier] DEFAULT ((1)),
[NonAdjustedCoveredCopies] [decimal] (18, 6) NULL,
[NonAdjustedBaseRatePerCopy] [decimal] (18, 6) NULL,
[NonAdjustedNextCoveredCopiesDate] [datetime] NULL,
[OverageBillingCycleID] [int] NULL,
[OverageFromDate] [datetime] NULL,
[OverageToDate] [datetime] NULL,
[NonAdjustedOverageNextBillingDate] [datetime] NULL,
[NonAdjustedOverageLastBillingDate] [datetime] NULL,
[OverageCyclesBilled] [int] NULL,
[BaseDistributionCodeID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCBillingMeterGroups] ADD CONSTRAINT [PK__SCBillin__75F2D0888D8C2BBF] PRIMARY KEY CLUSTERED  ([BillingMeterGroupID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCBillingMeterGroups] ADD CONSTRAINT [FK_SCBillingMeterGroups_BaseDistributionCodeID_SCContractBaseDistCodes] FOREIGN KEY ([BaseDistributionCodeID]) REFERENCES [dbo].[SCContractBaseDistCodes] ([BaseDistributionCodeID])
GO
ALTER TABLE [dbo].[SCBillingMeterGroups] ADD CONSTRAINT [FK_SCBillingMeterGroups_InvoiceID_SCBillingContracts] FOREIGN KEY ([InvoiceID], [ContractDetailID]) REFERENCES [dbo].[SCBillingContracts] ([InvoiceID], [ContractDetailID])
GO
ALTER TABLE [dbo].[SCBillingMeterGroups] ADD CONSTRAINT [FK_SCBillingMeterGroups_OverageBillingCycleID_SCBillingCycles] FOREIGN KEY ([OverageBillingCycleID]) REFERENCES [dbo].[SCBillingCycles] ([BillingCycleID])
GO
ALTER TABLE [dbo].[SCBillingMeterGroups] ADD CONSTRAINT [FK_SCBillingMeterGroups_OverageMethodID_SCOverageMethods] FOREIGN KEY ([OverageMethodID]) REFERENCES [dbo].[SCOverageMethods] ([OverageMethodID])
GO