Tables [dbo].[SCQBillingEquipments]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:59:49 AM Thursday, March 21, 2019
Last Modified1:15:17 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Foreign Keys FK_SCQBillingEquipments_BillingID_SCQBillingContracts: [dbo].[SCQBillingContracts].BillingID\ContractDetailIDBillingIDint4
False
Foreign Keys FK_SCQBillingEquipments_BillingID_SCQBillingContracts: [dbo].[SCQBillingContracts].BillingID\ContractDetailIDContractDetailIDint4
False
EquipmentDetailIDint4
False
Foreign Keys FK_SCQBillingEquipments_EquipmentID_SCEquipments: [dbo].[SCEquipments].EquipmentIDEquipmentIDint4
True
BaseAmountmoney8
False
Copiesint4
False
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
Cluster Primary Key PK_SCQBillingEquipments: BillingEquipmentIDBillingEquipmentIDint4
False
1 - 1
Foreign Keys FK_SCQBillingEquipments_SCContractDetailID_SCContractDetails: [dbo].[SCContractDetails].SCContractDetailIDSCContractDetailIDint4
False
BaseFromDatedatetime8
True
BaseToDatedatetime8
True
OverageFromDatedatetime8
True
OverageToDatedatetime8
True
ProrateStartbit1
False
((0))
ProrateStartAmountmoney8
False
((0))
ProrateEndbit1
False
((0))
ProrateEndAmountmoney8
False
((0))
PrevBaseFromDatedatetime8
True
PrevBaseToDatedatetime8
True
PrevBaseAmountmoney8
False
((0))
CurrentBaseAmountmoney8
False
((0))
LocationIDint4
False
Addressvarchar(64)64
False
('')
Cityvarchar(32)32
False
('')
Statevarchar(16)16
False
('')
Zipvarchar(16)16
False
('')
Countryvarchar(16)16
False
('')
MeterCountint4
False
((0))
BaseBillingTypeIDint4
False
((1))
NextBaseAmountmoney8
True
CurNonAdjustedBaseAmountmoney8
True
NextBaseMethodint4
True
NextBaseRateIncreaseValuedecimal(16,6)9
True
NextBaseRoundNoDigitsint4
True
Foreign Keys FK_SCQBillingEquipments_TaxCodeID_ShTaxCodes: [dbo].[ShTaxCodes].TaxCodeIDTaxCodeIDint4
True
LeaseAmountmoney8
False
((0))
LocationNotesvarchar(255)255
False
('')
DistTaxAmountmoney8
False
((0))
Quantitydecimal(18,6)9
False
((1))
UnitBaseAmountmoney8
False
((0))
DistCodeIDint4
False
((0))
NextBaseIncreaseDatedatetime8
True
NextBaseScheduleDetailIDint4
True
Foreign Keys FK_SCQBillingEquipments_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_SCQBillingEquipments_DivisionID_GLDivisions: [dbo].[GLDivisions].DivisionIDDivisionIDint4
False
Foreign Keys FK_SCQBillingEquipments_BalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].BalanceSheetGroupIDBalanceSheetGroupIDint4
False
Foreign Keys FK_SCQBillingEquipments_LeaseDivisionID_GLDivisions: [dbo].[GLDivisions].LeaseDivisionIDLeaseDivisionIDint4
False
Foreign Keys FK_SCQBillingEquipments_LeaseBalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].LeaseBalanceSheetGroupIDLeaseBalanceSheetGroupIDint4
False
DistMGBaseAmountmoney8
False
((0))
DistContractAdjBaseAmountmoney8
False
((0))
BillBaseFromDatedatetime8
True
BillBaseToDatedatetime8
True
IncludeOnInvoicebit1
False
((1))
Foreign Keys FK_SCQBillingEquipments_ContractDetailTypeID_SCContractDetailTypes: [dbo].[SCContractDetailTypes].ContractDetailTypeIDContractDetailTypeIDint4
False
((1))
ParentDetailInstanceint4
True
Foreign Keys FK_SCQBillingEquipments_ParentBillingEquipmentID_SCQBillingEquipments: [dbo].[SCQBillingEquipments].ParentBillingEquipmentIDParentBillingEquipmentIDint4
True
CombineWithParentBaseAmountbit1
False
((0))
SCContractDetailInstancedecimal(18,6)9
False
((0))
StatusMsgTypeint4
False
((0))
StatusMsgvarchar(1024)1024
False
('')
Foreign Keys FK_SCQBillingEquipments_TaxExemptCodeID_SHTaxExemptCodes: [dbo].[SHTaxExemptCodes].TaxExemptCodeIDTaxExemptCodeIDint4
True
Taxablebit1
False
((0))
Foreign Keys FK_SCQBillingEquipments_ItemID_ICItems: [dbo].[ICItems].ItemIDItemIDint4
True
Descriptionvarchar(255)255
False
('')
Foreign Keys FK_SCQBillingEquipments_ParentSCContractDetailID_SCContractDetails: [dbo].[SCContractDetails].ParentSCContractDetailIDParentSCContractDetailIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCQBillingEquipments: BillingEquipmentIDPK_SCQBillingEquipmentsBillingEquipmentID
True
80
NameColumns
FK_SCQBillingEquipments_BalanceSheetGroupID_GLBalanceSheetGroupsBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_SCQBillingEquipments_BillingID_SCQBillingContractsBillingID->[dbo].[SCQBillingContracts].[BillingID]
ContractDetailID->[dbo].[SCQBillingContracts].[ContractDetailID]
FK_SCQBillingEquipments_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_SCQBillingEquipments_ContractDetailTypeID_SCContractDetailTypesContractDetailTypeID->[dbo].[SCContractDetailTypes].[ContractDetailTypeID]
FK_SCQBillingEquipments_DivisionID_GLDivisionsDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_SCQBillingEquipments_EquipmentID_SCEquipmentsEquipmentID->[dbo].[SCEquipments].[EquipmentID]
FK_SCQBillingEquipments_ItemID_ICItemsItemID->[dbo].[ICItems].[ItemID]
FK_SCQBillingEquipments_LeaseBalanceSheetGroupID_GLBalanceSheetGroupsLeaseBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_SCQBillingEquipments_LeaseDivisionID_GLDivisionsLeaseDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_SCQBillingEquipments_ParentBillingEquipmentID_SCQBillingEquipmentsParentBillingEquipmentID->[dbo].[SCQBillingEquipments].[BillingEquipmentID]
FK_SCQBillingEquipments_ParentSCContractDetailID_SCContractDetailsParentSCContractDetailID->[dbo].[SCContractDetails].[ContractDetailID]
FK_SCQBillingEquipments_SCContractDetailID_SCContractDetailsSCContractDetailID->[dbo].[SCContractDetails].[ContractDetailID]
FK_SCQBillingEquipments_TaxCodeID_ShTaxCodesTaxCodeID->[dbo].[ShTaxCodes].[TaxCodeID]
FK_SCQBillingEquipments_TaxExemptCodeID_SHTaxExemptCodesTaxExemptCodeID->[dbo].[SHTaxExemptCodes].[TaxExemptCodeID]
CREATE TABLE [dbo].[SCQBillingEquipments]
(
[BillingID] [int] NOT NULL,
[ContractDetailID] [int] NOT NULL,
[EquipmentDetailID] [int] NOT NULL,
[EquipmentID] [int] NULL,
[BaseAmount] [money] NOT NULL,
[Copies] [int] NOT NULL,
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_SCQBillingEquipments_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCQBillingEquipments_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[BillingEquipmentID] [int] NOT NULL IDENTITY(1, 1),
[SCContractDetailID] [int] NOT NULL,
[BaseFromDate] [datetime] NULL,
[BaseToDate] [datetime] NULL,
[OverageFromDate] [datetime] NULL,
[OverageToDate] [datetime] NULL,
[ProrateStart] [bit] NOT NULL CONSTRAINT [DF_SCQBillingEquipments_ProrateStart] DEFAULT ((0)),
[ProrateStartAmount] [money] NOT NULL CONSTRAINT [DF_SCQBillingEquipments_ProrateStartAmount] DEFAULT ((0)),
[ProrateEnd] [bit] NOT NULL CONSTRAINT [DF_SCQBillingEquipments_ProrateEnd] DEFAULT ((0)),
[ProrateEndAmount] [money] NOT NULL CONSTRAINT [DF_SCQBillingEquipments_ProrateEndAmount] DEFAULT ((0)),
[PrevBaseFromDate] [datetime] NULL,
[PrevBaseToDate] [datetime] NULL,
[PrevBaseAmount] [money] NOT NULL CONSTRAINT [DF_SCQBillingEquipments_PrevBaseAmount] DEFAULT ((0)),
[CurrentBaseAmount] [money] NOT NULL CONSTRAINT [DF_SCQBillingEquipments_CurrentBaseAmount] DEFAULT ((0)),
[LocationID] [int] NOT NULL,
[Address] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQBillingEquipments_Address] DEFAULT (''),
[City] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQBillingEquipments_City] DEFAULT (''),
[State] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQBillingEquipments_State] DEFAULT (''),
[Zip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQBillingEquipments_Zip] DEFAULT (''),
[Country] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQBillingEquipments_Country] DEFAULT (''),
[MeterCount] [int] NOT NULL CONSTRAINT [DF_SCQBillingEquipments_MeterCount] DEFAULT ((0)),
[BaseBillingTypeID] [int] NOT NULL CONSTRAINT [DF_SCQBillingEquipments_BaseBillingTypeID] DEFAULT ((1)),
[NextBaseAmount] [money] NULL,
[CurNonAdjustedBaseAmount] [money] NULL,
[NextBaseMethod] [int] NULL,
[NextBaseRateIncreaseValue] [decimal] (16, 6) NULL,
[NextBaseRoundNoDigits] [int] NULL,
[TaxCodeID] [int] NULL,
[LeaseAmount] [money] NOT NULL CONSTRAINT [DF_SCQBillingEquipments_LeaseAmount] DEFAULT ((0)),
[LocationNotes] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQBillingEquipments_LocationNotes] DEFAULT (''),
[DistTaxAmount] [money] NOT NULL CONSTRAINT [DF_SCQBillingEquipments_DistTaxAmount] DEFAULT ((0)),
[Quantity] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCQBillingEquipments_Quantity] DEFAULT ((1)),
[UnitBaseAmount] [money] NOT NULL CONSTRAINT [DF_SCQBillingEquipments_UnitBaseAmount] DEFAULT ((0)),
[DistCodeID] [int] NOT NULL CONSTRAINT [DF_SCQBillingEquipments_DistcodeID] DEFAULT ((0)),
[NextBaseIncreaseDate] [datetime] NULL,
[NextBaseScheduleDetailID] [int] NULL,
[BranchID] [int] NOT NULL,
[DivisionID] [int] NOT NULL,
[BalanceSheetGroupID] [int] NOT NULL,
[LeaseDivisionID] [int] NOT NULL,
[LeaseBalanceSheetGroupID] [int] NOT NULL,
[DistMGBaseAmount] [money] NOT NULL CONSTRAINT [DF_SCQBillingEquipments_DistMGBaseAmount] DEFAULT ((0)),
[DistContractAdjBaseAmount] [money] NOT NULL CONSTRAINT [DF_SCQBillingEquipments_DistContractAdjBaseAmount] DEFAULT ((0)),
[BillBaseFromDate] [datetime] NULL,
[BillBaseToDate] [datetime] NULL,
[IncludeOnInvoice] [bit] NOT NULL CONSTRAINT [DF_SCQBillingEquipments_IncludeOnInvoice] DEFAULT ((1)),
[ContractDetailTypeID] [int] NOT NULL CONSTRAINT [DF_SCQBillingEquipments_ContractDetailTypeID] DEFAULT ((1)),
[ParentDetailInstance] [int] NULL,
[ParentBillingEquipmentID] [int] NULL,
[CombineWithParentBaseAmount] [bit] NOT NULL CONSTRAINT [DF_SCQBillingEquipments_CombineWithParentBaseAmount] DEFAULT ((0)),
[SCContractDetailInstance] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCQBillingEquipments_SCContractDetailInstance] DEFAULT ((0)),
[StatusMsgType] [int] NOT NULL CONSTRAINT [DF_SCQBillingEquipments_StatusMsgType] DEFAULT ((0)),
[StatusMsg] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQBillingEquipments_StatusMsg] DEFAULT (''),
[TaxExemptCodeID] [int] NULL,
[Taxable] [bit] NOT NULL CONSTRAINT [DF_SCQBillingEquipments_Taxable] DEFAULT ((0)),
[ItemID] [int] NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQBillingEquipments_Description] DEFAULT (''),
[ParentSCContractDetailID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQBillingEquipments] ADD CONSTRAINT [PK_SCQBillingEquipments] PRIMARY KEY CLUSTERED  ([BillingEquipmentID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQBillingEquipments] ADD CONSTRAINT [FK_SCQBillingEquipments_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SCQBillingEquipments] ADD CONSTRAINT [FK_SCQBillingEquipments_BillingID_SCQBillingContracts] FOREIGN KEY ([BillingID], [ContractDetailID]) REFERENCES [dbo].[SCQBillingContracts] ([BillingID], [ContractDetailID])
GO
ALTER TABLE [dbo].[SCQBillingEquipments] ADD CONSTRAINT [FK_SCQBillingEquipments_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCQBillingEquipments] ADD CONSTRAINT [FK_SCQBillingEquipments_ContractDetailTypeID_SCContractDetailTypes] FOREIGN KEY ([ContractDetailTypeID]) REFERENCES [dbo].[SCContractDetailTypes] ([ContractDetailTypeID])
GO
ALTER TABLE [dbo].[SCQBillingEquipments] ADD CONSTRAINT [FK_SCQBillingEquipments_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SCQBillingEquipments] ADD CONSTRAINT [FK_SCQBillingEquipments_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SCQBillingEquipments] ADD CONSTRAINT [FK_SCQBillingEquipments_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[SCQBillingEquipments] ADD CONSTRAINT [FK_SCQBillingEquipments_LeaseBalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([LeaseBalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SCQBillingEquipments] ADD CONSTRAINT [FK_SCQBillingEquipments_LeaseDivisionID_GLDivisions] FOREIGN KEY ([LeaseDivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SCQBillingEquipments] ADD CONSTRAINT [FK_SCQBillingEquipments_ParentBillingEquipmentID_SCQBillingEquipments] FOREIGN KEY ([ParentBillingEquipmentID]) REFERENCES [dbo].[SCQBillingEquipments] ([BillingEquipmentID])
GO
ALTER TABLE [dbo].[SCQBillingEquipments] ADD CONSTRAINT [FK_SCQBillingEquipments_ParentSCContractDetailID_SCContractDetails] FOREIGN KEY ([ParentSCContractDetailID]) REFERENCES [dbo].[SCContractDetails] ([ContractDetailID])
GO
ALTER TABLE [dbo].[SCQBillingEquipments] ADD CONSTRAINT [FK_SCQBillingEquipments_SCContractDetailID_SCContractDetails] FOREIGN KEY ([SCContractDetailID]) REFERENCES [dbo].[SCContractDetails] ([ContractDetailID])
GO
ALTER TABLE [dbo].[SCQBillingEquipments] ADD CONSTRAINT [FK_SCQBillingEquipments_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[SCQBillingEquipments] ADD CONSTRAINT [FK_SCQBillingEquipments_TaxExemptCodeID_SHTaxExemptCodes] FOREIGN KEY ([TaxExemptCodeID]) REFERENCES [dbo].[SHTaxExemptCodes] ([TaxExemptCodeID])
GO