Tables [dbo].[SCProposalEquipments]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:59:23 AM Thursday, March 21, 2019
Last Modified1:15:09 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_SCProposalEquipments: BillingEquipmentIDBillingEquipmentIDint4
False
1 - 1
ProposalIDint4
False
QIDint4
True
ContractDetailIDint4
False
EquipmentDetailIDint4
False
Foreign Keys FK_SCProposalEquipments_EquipmentID_SCEquipments: [dbo].[SCEquipments].EquipmentIDEquipmentIDint4
True
BaseAmountmoney8
False
Copiesint4
False
LocationIDint4
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
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))
TaxCodeIDint4
True
NextBaseAmountmoney8
True
CurNonAdjustedBaseAmountmoney8
True
DiscAmountmoney8
False
((0))
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
False
LeaseAmountmoney8
False
((0))
LocationNotesvarchar(255)255
False
('')
DistTaxAmountmoney8
False
((0))
Quantitydecimal(18,6)9
False
((1))
UnitBaseAmountmoney8
False
((0))
BillBaseFromDatedatetime8
True
BillBaseToDatedatetime8
True
Foreign Keys FK_SCProposalEquipments_ContractDetailTypeID_SCContractDetailTypes: [dbo].[SCContractDetailTypes].ContractDetailTypeIDContractDetailTypeIDint4
False
((1))
ParentDetailInstanceint4
True
Foreign Keys FK_SCProposalEquipments_ParentBillingEquipmentID_SCProposalEquipments: [dbo].[SCProposalEquipments].ParentBillingEquipmentIDParentBillingEquipmentIDint4
True
CombineWithParentBaseAmountbit1
False
((0))
SCContractDetailInstancedecimal(18,6)9
False
((0))
Foreign Keys FK_SCProposalEquipments_ItemID_ICItems: [dbo].[ICItems].ItemIDItemIDint4
True
Descriptionvarchar(255)255
False
('')
Foreign Keys FK_SCProposalEquipments_SCContractDetailID_SCContractDetails: [dbo].[SCContractDetails].SCContractDetailIDSCContractDetailIDint4
True
Foreign Keys FK_SCProposalEquipments_ParentSCContractDetailID_SCContractDetails: [dbo].[SCContractDetails].ParentSCContractDetailIDParentSCContractDetailIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCProposalEquipments: BillingEquipmentIDPK_SCProposalEquipmentsBillingEquipmentID
True
80
NameColumns
FK_SCProposalEquipments_ContractDetailTypeID_SCContractDetailTypesContractDetailTypeID->[dbo].[SCContractDetailTypes].[ContractDetailTypeID]
FK_SCProposalEquipments_EquipmentID_SCEquipmentsEquipmentID->[dbo].[SCEquipments].[EquipmentID]
FK_SCProposalEquipments_ItemID_ICItemsItemID->[dbo].[ICItems].[ItemID]
FK_SCProposalEquipments_ParentBillingEquipmentID_SCProposalEquipmentsParentBillingEquipmentID->[dbo].[SCProposalEquipments].[BillingEquipmentID]
FK_SCProposalEquipments_ParentSCContractDetailID_SCContractDetailsParentSCContractDetailID->[dbo].[SCContractDetails].[ContractDetailID]
FK_SCProposalEquipments_SCContractDetailID_SCContractDetailsSCContractDetailID->[dbo].[SCContractDetails].[ContractDetailID]
CREATE TABLE [dbo].[SCProposalEquipments]
(
[BillingEquipmentID] [int] NOT NULL IDENTITY(1, 1),
[ProposalID] [int] NOT NULL,
[QID] [int] NULL,
[ContractDetailID] [int] NOT NULL,
[EquipmentDetailID] [int] NOT NULL,
[EquipmentID] [int] NULL,
[BaseAmount] [money] NOT NULL,
[Copies] [int] NOT 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,
[BaseFromDate] [datetime] NULL,
[BaseToDate] [datetime] NULL,
[OverageFromDate] [datetime] NULL,
[OverageToDate] [datetime] NULL,
[ProrateStart] [bit] NOT NULL CONSTRAINT [DF_SCProposalEquipments_ProrateStart] DEFAULT ((0)),
[ProrateStartAmount] [money] NOT NULL CONSTRAINT [DF_SCProposalEquipments_ProrateStartAmount] DEFAULT ((0)),
[ProrateEnd] [bit] NOT NULL CONSTRAINT [DF_SCProposalEquipments_ProrateEnd] DEFAULT ((0)),
[ProrateEndAmount] [money] NOT NULL CONSTRAINT [DF_SCProposalEquipments_ProrateEndAmount] DEFAULT ((0)),
[PrevBaseFromDate] [datetime] NULL,
[PrevBaseToDate] [datetime] NULL,
[PrevBaseAmount] [money] NOT NULL CONSTRAINT [DF_SCProposalEquipments_PrevBaseAmount] DEFAULT ((0)),
[CurrentBaseAmount] [money] NOT NULL CONSTRAINT [DF_SCProposalEquipments_CurrentBaseAmount] DEFAULT ((0)),
[MeterCount] [int] NOT NULL CONSTRAINT [DF_SCProposalEquipments_MeterCount] DEFAULT ((0)),
[BaseBillingTypeID] [int] NOT NULL CONSTRAINT [DF_SCProposalEquipments_BaseBillingTypeID] DEFAULT ((1)),
[TaxCodeID] [int] NULL,
[NextBaseAmount] [money] NULL,
[CurNonAdjustedBaseAmount] [money] NULL,
[DiscAmount] [money] NOT NULL CONSTRAINT [DF_SCProposalEquipments_DiscAmount] DEFAULT ((0)),
[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_SCProposalEquipments_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCProposalEquipments_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL,
[LeaseAmount] [money] NOT NULL CONSTRAINT [DF_SCProposalEquipments_LeaseAmount] DEFAULT ((0)),
[LocationNotes] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCProposalEquipments_LocationNotes] DEFAULT (''),
[DistTaxAmount] [money] NOT NULL CONSTRAINT [DF_SCProposalEquipments_DistTaxAmount] DEFAULT ((0)),
[Quantity] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCProposalEquipments_Quantity] DEFAULT ((1)),
[UnitBaseAmount] [money] NOT NULL CONSTRAINT [DF_SCProposalEquipments_UnitBaseAmount] DEFAULT ((0)),
[BillBaseFromDate] [datetime] NULL,
[BillBaseToDate] [datetime] NULL,
[ContractDetailTypeID] [int] NOT NULL CONSTRAINT [DF_SCProposalEquipments_ContractDetailTypeID] DEFAULT ((1)),
[ParentDetailInstance] [int] NULL,
[ParentBillingEquipmentID] [int] NULL,
[CombineWithParentBaseAmount] [bit] NOT NULL CONSTRAINT [DF_SCProposalEquipments_CombineWithParentBaseAmount] DEFAULT ((0)),
[SCContractDetailInstance] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCProposalEquipments_SCContractDetailInstance] DEFAULT ((0)),
[ItemID] [int] NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCProposalEquipments_Description] DEFAULT (''),
[SCContractDetailID] [int] NULL,
[ParentSCContractDetailID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCProposalEquipments] ADD CONSTRAINT [PK_SCProposalEquipments] PRIMARY KEY CLUSTERED  ([BillingEquipmentID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCProposalEquipments] ADD CONSTRAINT [FK_SCProposalEquipments_ContractDetailTypeID_SCContractDetailTypes] FOREIGN KEY ([ContractDetailTypeID]) REFERENCES [dbo].[SCContractDetailTypes] ([ContractDetailTypeID])
GO
ALTER TABLE [dbo].[SCProposalEquipments] ADD CONSTRAINT [FK_SCProposalEquipments_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SCProposalEquipments] ADD CONSTRAINT [FK_SCProposalEquipments_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[SCProposalEquipments] ADD CONSTRAINT [FK_SCProposalEquipments_ParentBillingEquipmentID_SCProposalEquipments] FOREIGN KEY ([ParentBillingEquipmentID]) REFERENCES [dbo].[SCProposalEquipments] ([BillingEquipmentID])
GO
ALTER TABLE [dbo].[SCProposalEquipments] ADD CONSTRAINT [FK_SCProposalEquipments_ParentSCContractDetailID_SCContractDetails] FOREIGN KEY ([ParentSCContractDetailID]) REFERENCES [dbo].[SCContractDetails] ([ContractDetailID])
GO
ALTER TABLE [dbo].[SCProposalEquipments] ADD CONSTRAINT [FK_SCProposalEquipments_SCContractDetailID_SCContractDetails] FOREIGN KEY ([SCContractDetailID]) REFERENCES [dbo].[SCContractDetails] ([ContractDetailID])
GO