Tables [dbo].[SCBillingEquipments]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:56:30 AM Thursday, March 21, 2019
Last Modified1:14:41 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Foreign Keys FK_SCBillingEquipments_InvoiceID_SCBillingContracts: [dbo].[SCBillingContracts].InvoiceID\ContractDetailIDInvoiceIDint4
False
Foreign Keys FK_SCBillingEquipments_InvoiceID_SCBillingContracts: [dbo].[SCBillingContracts].InvoiceID\ContractDetailIDContractDetailIDint4
False
EquipmentDetailIDint4
False
Foreign Keys FK_SCBillingEquipments_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
CustomerNumbervarchar(32)32
True
Foreign Keys FK_SCBillingEquipments_LocationID_ARCustomers: [dbo].[ARCustomers].LocationIDLocationIDint4
False
LocationNamevarchar(128)128
False
Addressvarchar(64)64
False
Cityvarchar(32)32
False
Statevarchar(16)16
False
Zipvarchar(16)16
False
Countryvarchar(16)16
False
Cluster Primary Key PK_SCBillingEquipments: BillingEquipmentIDBillingEquipmentIDint4
False
1 - 1
QIDint4
True
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))
MeterCountint4
False
((0))
BaseBillingTypeIDint4
False
((1))
NextBaseAmountmoney8
True
CurNonAdjustedBaseAmountmoney8
True
Foreign Keys FK_SCBillingEquipments_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))
Foreign Keys FK_SCBillingEquipments_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_SCBillingEquipments_DivisionID_GLDivisions: [dbo].[GLDivisions].DivisionIDDivisionIDint4
False
Foreign Keys FK_SCBillingEquipments_BalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].BalanceSheetGroupIDBalanceSheetGroupIDint4
False
Foreign Keys FK_SCBillingEquipments_LeaseDivisionID_GLDivisions: [dbo].[GLDivisions].LeaseDivisionIDLeaseDivisionIDint4
False
Foreign Keys FK_SCBillingEquipments_LeaseBalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].LeaseBalanceSheetGroupIDLeaseBalanceSheetGroupIDint4
False
DistMGBaseAmountmoney8
False
((0))
DistContractAdjBaseAmountmoney8
False
((0))
BillBaseFromDatedatetime8
True
BillBaseToDatedatetime8
True
Foreign Keys FK_SCBillingEquipments_ContractDetailTypeID_SCContractDetailTypes: [dbo].[SCContractDetailTypes].ContractDetailTypeIDContractDetailTypeIDint4
False
((1))
ParentDetailInstanceint4
True
Foreign Keys FK_SCBillingEquipments_ParentBillingEquipmentID_SCBillingEquipments: [dbo].[SCBillingEquipments].ParentBillingEquipmentIDParentBillingEquipmentIDint4
True
CombineWithParentBaseAmountbit1
False
((0))
SCContractDetailInstancedecimal(18,6)9
False
((0))
Foreign Keys FK_SCBillingEquipments_TaxExemptCodeID_SHTaxExemptCodes: [dbo].[SHTaxExemptCodes].TaxExemptCodeIDTaxExemptCodeIDint4
True
Taxablebit1
False
((0))
Foreign Keys FK_SCBillingEquipments_ItemID_ICItems: [dbo].[ICItems].ItemIDItemIDint4
True
Descriptionvarchar(255)255
False
('')
Foreign Keys FK_SCBillingEquipments_SCContractDetailID_SCContractDetails: [dbo].[SCContractDetails].SCContractDetailIDSCContractDetailIDint4
True
Foreign Keys FK_SCBillingEquipments_ParentSCContractDetailID_SCContractDetails: [dbo].[SCContractDetails].ParentSCContractDetailIDParentSCContractDetailIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCBillingEquipments: BillingEquipmentIDPK_SCBillingEquipmentsBillingEquipmentID
True
80
NameColumns
FK_SCBillingEquipments_BalanceSheetGroupID_GLBalanceSheetGroupsBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_SCBillingEquipments_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_SCBillingEquipments_ContractDetailTypeID_SCContractDetailTypesContractDetailTypeID->[dbo].[SCContractDetailTypes].[ContractDetailTypeID]
FK_SCBillingEquipments_DivisionID_GLDivisionsDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_SCBillingEquipments_EquipmentID_SCEquipmentsEquipmentID->[dbo].[SCEquipments].[EquipmentID]
FK_SCBillingEquipments_InvoiceID_SCBillingContractsInvoiceID->[dbo].[SCBillingContracts].[InvoiceID]
ContractDetailID->[dbo].[SCBillingContracts].[ContractDetailID]
FK_SCBillingEquipments_ItemID_ICItemsItemID->[dbo].[ICItems].[ItemID]
FK_SCBillingEquipments_LeaseBalanceSheetGroupID_GLBalanceSheetGroupsLeaseBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_SCBillingEquipments_LeaseDivisionID_GLDivisionsLeaseDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_SCBillingEquipments_LocationID_ARCustomersLocationID->[dbo].[ARCustomers].[CustomerID]
FK_SCBillingEquipments_ParentBillingEquipmentID_SCBillingEquipmentsParentBillingEquipmentID->[dbo].[SCBillingEquipments].[BillingEquipmentID]
FK_SCBillingEquipments_ParentSCContractDetailID_SCContractDetailsParentSCContractDetailID->[dbo].[SCContractDetails].[ContractDetailID]
FK_SCBillingEquipments_SCContractDetailID_SCContractDetailsSCContractDetailID->[dbo].[SCContractDetails].[ContractDetailID]
FK_SCBillingEquipments_TaxCodeID_ShTaxCodesTaxCodeID->[dbo].[ShTaxCodes].[TaxCodeID]
FK_SCBillingEquipments_TaxExemptCodeID_SHTaxExemptCodesTaxExemptCodeID->[dbo].[SHTaxExemptCodes].[TaxExemptCodeID]
CREATE TABLE [dbo].[SCBillingEquipments]
(
[InvoiceID] [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_SCBillingEquipments_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCBillingEquipments_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[CustomerNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationID] [int] NOT NULL,
[LocationName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Address] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[City] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[State] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Zip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Country] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[BillingEquipmentID] [int] NOT NULL IDENTITY(1, 1),
[QID] [int] NULL,
[BaseFromDate] [datetime] NULL,
[BaseToDate] [datetime] NULL,
[OverageFromDate] [datetime] NULL,
[OverageToDate] [datetime] NULL,
[ProrateStart] [bit] NOT NULL CONSTRAINT [DF_SCBillingEquipments_ProrateStart] DEFAULT ((0)),
[ProrateStartAmount] [money] NOT NULL CONSTRAINT [DF_SCBillingEquipments_ProrateStartAmount] DEFAULT ((0)),
[ProrateEnd] [bit] NOT NULL CONSTRAINT [DF_SCBillingEquipments_ProrateEnd] DEFAULT ((0)),
[ProrateEndAmount] [money] NOT NULL CONSTRAINT [DF_SCBillingEquipments_ProrateEndAmount] DEFAULT ((0)),
[PrevBaseFromDate] [datetime] NULL,
[PrevBaseToDate] [datetime] NULL,
[PrevBaseAmount] [money] NOT NULL CONSTRAINT [DF_SCBillingEquipments_PrevBaseAmount] DEFAULT ((0)),
[CurrentBaseAmount] [money] NOT NULL CONSTRAINT [DF_SCBillingEquipments_CurrentBaseAmount] DEFAULT ((0)),
[MeterCount] [int] NOT NULL CONSTRAINT [DF_SCBillingEquipments_MeterCount] DEFAULT ((0)),
[BaseBillingTypeID] [int] NOT NULL CONSTRAINT [DF_SCBillingEquipments_BaseBillingTypeID] DEFAULT ((1)),
[NextBaseAmount] [money] NULL,
[CurNonAdjustedBaseAmount] [money] NULL,
[TaxCodeID] [int] NULL,
[LeaseAmount] [money] NOT NULL CONSTRAINT [DF_SCBillingEquipments_LeaseAmount] DEFAULT ((0)),
[LocationNotes] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCBillingEquipments_LocationNotes] DEFAULT (''),
[DistTaxAmount] [money] NOT NULL CONSTRAINT [DF_SCBillingEquipments_DistTaxAmount] DEFAULT ((0)),
[Quantity] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCBillingEquipments_Quantity] DEFAULT ((1)),
[UnitBaseAmount] [money] NOT NULL CONSTRAINT [DF_SCBillingEquipments_UnitBaseAmount] DEFAULT ((0)),
[DistCodeID] [int] NOT NULL CONSTRAINT [DF_SCBillingEquipments_DistcodeID] DEFAULT ((0)),
[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_SCBillingEquipments_DistMGBaseAmount] DEFAULT ((0)),
[DistContractAdjBaseAmount] [money] NOT NULL CONSTRAINT [DF_SCBillingEquipments_DistContractAdjBaseAmount] DEFAULT ((0)),
[BillBaseFromDate] [datetime] NULL,
[BillBaseToDate] [datetime] NULL,
[ContractDetailTypeID] [int] NOT NULL CONSTRAINT [DF_SCBillingEquipments_ContractDetailTypeID] DEFAULT ((1)),
[ParentDetailInstance] [int] NULL,
[ParentBillingEquipmentID] [int] NULL,
[CombineWithParentBaseAmount] [bit] NOT NULL CONSTRAINT [DF_SCBillingEquipments_CombineWithParentBaseAmount] DEFAULT ((0)),
[SCContractDetailInstance] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCBillingEquipments_SCContractDetailInstance] DEFAULT ((0)),
[TaxExemptCodeID] [int] NULL,
[Taxable] [bit] NOT NULL CONSTRAINT [DF_SCBillingEquipments_Taxable] DEFAULT ((0)),
[ItemID] [int] NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCBillingEquipments_Description] DEFAULT (''),
[SCContractDetailID] [int] NULL,
[ParentSCContractDetailID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCBillingEquipments] ADD CONSTRAINT [PK_SCBillingEquipments] PRIMARY KEY CLUSTERED  ([BillingEquipmentID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCBillingEquipments] ADD CONSTRAINT [FK_SCBillingEquipments_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SCBillingEquipments] ADD CONSTRAINT [FK_SCBillingEquipments_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCBillingEquipments] ADD CONSTRAINT [FK_SCBillingEquipments_ContractDetailTypeID_SCContractDetailTypes] FOREIGN KEY ([ContractDetailTypeID]) REFERENCES [dbo].[SCContractDetailTypes] ([ContractDetailTypeID])
GO
ALTER TABLE [dbo].[SCBillingEquipments] ADD CONSTRAINT [FK_SCBillingEquipments_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SCBillingEquipments] ADD CONSTRAINT [FK_SCBillingEquipments_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SCBillingEquipments] ADD CONSTRAINT [FK_SCBillingEquipments_InvoiceID_SCBillingContracts] FOREIGN KEY ([InvoiceID], [ContractDetailID]) REFERENCES [dbo].[SCBillingContracts] ([InvoiceID], [ContractDetailID])
GO
ALTER TABLE [dbo].[SCBillingEquipments] ADD CONSTRAINT [FK_SCBillingEquipments_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[SCBillingEquipments] ADD CONSTRAINT [FK_SCBillingEquipments_LeaseBalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([LeaseBalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SCBillingEquipments] ADD CONSTRAINT [FK_SCBillingEquipments_LeaseDivisionID_GLDivisions] FOREIGN KEY ([LeaseDivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SCBillingEquipments] ADD CONSTRAINT [FK_SCBillingEquipments_LocationID_ARCustomers] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCBillingEquipments] ADD CONSTRAINT [FK_SCBillingEquipments_ParentBillingEquipmentID_SCBillingEquipments] FOREIGN KEY ([ParentBillingEquipmentID]) REFERENCES [dbo].[SCBillingEquipments] ([BillingEquipmentID])
GO
ALTER TABLE [dbo].[SCBillingEquipments] ADD CONSTRAINT [FK_SCBillingEquipments_ParentSCContractDetailID_SCContractDetails] FOREIGN KEY ([ParentSCContractDetailID]) REFERENCES [dbo].[SCContractDetails] ([ContractDetailID])
GO
ALTER TABLE [dbo].[SCBillingEquipments] ADD CONSTRAINT [FK_SCBillingEquipments_SCContractDetailID_SCContractDetails] FOREIGN KEY ([SCContractDetailID]) REFERENCES [dbo].[SCContractDetails] ([ContractDetailID])
GO
ALTER TABLE [dbo].[SCBillingEquipments] ADD CONSTRAINT [FK_SCBillingEquipments_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[SCBillingEquipments] ADD CONSTRAINT [FK_SCBillingEquipments_TaxExemptCodeID_SHTaxExemptCodes] FOREIGN KEY ([TaxExemptCodeID]) REFERENCES [dbo].[SHTaxExemptCodes] ([TaxExemptCodeID])
GO