Tables [dbo].[SCBillingOvgCharges]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:55:53 AM Thursday, March 21, 2019
Last Modified1:14:44 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_SCBillingOvgCharges: OverageChargeID\BillingMeterGroupIDOverageChargeIDint4
False
Cluster Primary Key PK_SCBillingOvgCharges: OverageChargeID\BillingMeterGroupIDForeign Keys FK_SCBillingOvgCharges_BillingMeterGroupID_SCBillingMeterGroups: [dbo].[SCBillingMeterGroups].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_SCBillingOvgCharges: OverageChargeID\BillingMeterGroupIDPK_SCBillingOvgChargesOverageChargeID, BillingMeterGroupID
True
80
NameColumns
FK_SCBillingOvgCharges_BillingMeterGroupID_SCBillingMeterGroupsBillingMeterGroupID->[dbo].[SCBillingMeterGroups].[BillingMeterGroupID]
CREATE TABLE [dbo].[SCBillingOvgCharges]
(
[OverageChargeID] [int] NOT NULL,
[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_SCBillingOvgCharges_CreditRate] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCBillingOvgCharges] ADD CONSTRAINT [PK_SCBillingOvgCharges] PRIMARY KEY CLUSTERED  ([OverageChargeID], [BillingMeterGroupID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCBillingOvgCharges] ADD CONSTRAINT [FK_SCBillingOvgCharges_BillingMeterGroupID_SCBillingMeterGroups] FOREIGN KEY ([BillingMeterGroupID]) REFERENCES [dbo].[SCBillingMeterGroups] ([BillingMeterGroupID])
GO
  • [dbo].[v_SCBillingMeterGroups]