Tables [dbo].[SCQBillingOvgCharges]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:00:00 AM Thursday, March 21, 2019
Last Modified1:15:18 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_SCQBillingOvgCharges: OverageChargeID\BillingMeterGroupIDOverageChargeIDint4
False
1 - 1
Cluster Primary Key PK_SCQBillingOvgCharges: OverageChargeID\BillingMeterGroupIDForeign Keys FK_SCQBillingOvgCharges_BillingMeterGroupID_SCQBillingMeterGroups: [dbo].[SCQBillingMeterGroups].BillingMeterGroupIDBillingMeterGroupIDint4
False
OverageRatedecimal(14,6)9
True
BilledCopiesdecimal(18,6)9
True
AmountBilledmoney8
True
CreatorIDchar(8)8
True
UpdatorIDchar(8)8
True
CreateDatedatetime8
True
LastUpdatedatetime8
True
timestamptimestamp8
True
NextOvgRatedecimal(14,6)9
True
OverageDetailIDint4
True
CreditRatedecimal(18,6)9
False
((0))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCQBillingOvgCharges: OverageChargeID\BillingMeterGroupIDPK_SCQBillingOvgChargesOverageChargeID, BillingMeterGroupID
True
80
NameColumns
FK_SCQBillingOvgCharges_BillingMeterGroupID_SCQBillingMeterGroupsBillingMeterGroupID->[dbo].[SCQBillingMeterGroups].[BillingMeterGroupID]
CREATE TABLE [dbo].[SCQBillingOvgCharges]
(
[OverageChargeID] [int] NOT NULL IDENTITY(1, 1),
[BillingMeterGroupID] [int] NOT NULL,
[OverageRate] [decimal] (14, 6) NULL,
[BilledCopies] [decimal] (18, 6) NULL,
[AmountBilled] [money] 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,
[NextOvgRate] [decimal] (14, 6) NULL,
[OverageDetailID] [int] NULL,
[CreditRate] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCQBillingOvgCharges_CreditRate] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQBillingOvgCharges] ADD CONSTRAINT [PK_SCQBillingOvgCharges] PRIMARY KEY CLUSTERED  ([OverageChargeID], [BillingMeterGroupID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQBillingOvgCharges] ADD CONSTRAINT [FK_SCQBillingOvgCharges_BillingMeterGroupID_SCQBillingMeterGroups] FOREIGN KEY ([BillingMeterGroupID]) REFERENCES [dbo].[SCQBillingMeterGroups] ([BillingMeterGroupID])
GO