Tables [dbo].[SAConfigQuoteDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:58:58 AM Thursday, March 21, 2019
Last Modified1:15:59 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_SAConfigQuoteDetails: ConfigQuoteDetailIDConfigQuoteDetailIDint4
False
1 - 1
Foreign Keys FK_SAConfigQuoteDetails_ConfigQuoteID_SAConfigQuotes: [dbo].[SAConfigQuotes].ConfigQuoteIDConfigQuoteIDint4
False
ConfigIDint4
False
ConfigNodeIDint4
False
NodeExpirationdatetime8
True
Foreign Keys FK_SAConfigQuoteDetails_itemID_ICItems: [dbo].[ICItems].itemIDitemIDint4
False
itemvarchar(255)255
True
Descriptionvarchar(255)255
True
quantityint4
True
isHostbit1
False
hostDetailIDint4
True
actualCostmoney8
True
baseCostmoney8
True
OutCostmoney8
False
OutCostExtendedmoney8
True
CalculatedOutCostmoney8
True
SuggestedPricemoney8
True
SellingPricemoney8
True
SellingPriceExtendedmoney8
True
CreateDatedatetime8
False
(getdate())
BlackVolumedecimal(18,0)9
True
ColorVolumedecimal(18,0)9
True
ServiceRatedecimal(14,8)9
True
ServiceClrRatedecimal(14,8)9
True
onLeasebit1
True
onServicebit1
True
OverageRatedecimal(14,8)9
True
OverageClrRatedecimal(14,8)9
True
Foreign Keys FK_SAConfigQuoteDetails_SOID_SOOrders: [dbo].[SOOrders].SOIDSOIDint4
True
SODetailIDint4
True
useBaseOutCostbit1
True
Foreign Keys FK_SAConfigQuoteDetails_CallID_SCCalls: [dbo].[SCCalls].CallIDCallIDint4
True
TotalQuantityint4
True
Foreign Keys FK_SAConfigQuoteDetails_EquipmentID_SCEquipments: [dbo].[SCEquipments].EquipmentIDEquipmentIDint4
True
Foreign Keys FK_SAConfigQuoteDetails_ContractID_SCContracts: [dbo].[SCContracts].ContractIDContractIDint4
True
TaxFlagint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SAConfigQuoteDetails: ConfigQuoteDetailIDPK_SAConfigQuoteDetailsConfigQuoteDetailID
True
80
NameColumns
FK_SAConfigQuoteDetails_CallID_SCCallsCallID->[dbo].[SCCalls].[CallID]
FK_SAConfigQuoteDetails_ConfigQuoteID_SAConfigQuotesConfigQuoteID->[dbo].[SAConfigQuotes].[ConfigQuoteID]
FK_SAConfigQuoteDetails_ContractID_SCContractsContractID->[dbo].[SCContracts].[ContractID]
FK_SAConfigQuoteDetails_EquipmentID_SCEquipmentsEquipmentID->[dbo].[SCEquipments].[EquipmentID]
FK_SAConfigQuoteDetails_itemID_ICItemsitemID->[dbo].[ICItems].[ItemID]
FK_SAConfigQuoteDetails_SOID_SOOrdersSOID->[dbo].[SOOrders].[SOID]
CREATE TABLE [dbo].[SAConfigQuoteDetails]
(
[ConfigQuoteDetailID] [int] NOT NULL IDENTITY(1, 1),
[ConfigQuoteID] [int] NOT NULL,
[ConfigID] [int] NOT NULL,
[ConfigNodeID] [int] NOT NULL,
[NodeExpiration] [datetime] NULL,
[itemID] [int] NOT NULL,
[item] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[quantity] [int] NULL,
[isHost] [bit] NOT NULL,
[hostDetailID] [int] NULL,
[actualCost] [money] NULL,
[baseCost] [money] NULL,
[OutCost] [money] NOT NULL,
[OutCostExtended] [money] NULL,
[CalculatedOutCost] [money] NULL,
[SuggestedPrice] [money] NULL,
[SellingPrice] [money] NULL,
[SellingPriceExtended] [money] NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_SAConfigQuoteDetails_CreateDate] DEFAULT (getdate()),
[BlackVolume] [decimal] (18, 0) NULL,
[ColorVolume] [decimal] (18, 0) NULL,
[ServiceRate] [decimal] (14, 8) NULL,
[ServiceClrRate] [decimal] (14, 8) NULL,
[onLease] [bit] NULL,
[onService] [bit] NULL,
[OverageRate] [decimal] (14, 8) NULL,
[OverageClrRate] [decimal] (14, 8) NULL,
[SOID] [int] NULL,
[SODetailID] [int] NULL,
[useBaseOutCost] [bit] NULL,
[CallID] [int] NULL,
[TotalQuantity] [int] NULL,
[EquipmentID] [int] NULL,
[ContractID] [int] NULL,
[TaxFlag] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAConfigQuoteDetails] ADD CONSTRAINT [PK_SAConfigQuoteDetails] PRIMARY KEY CLUSTERED  ([ConfigQuoteDetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAConfigQuoteDetails] ADD CONSTRAINT [FK_SAConfigQuoteDetails_CallID_SCCalls] FOREIGN KEY ([CallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[SAConfigQuoteDetails] ADD CONSTRAINT [FK_SAConfigQuoteDetails_ConfigQuoteID_SAConfigQuotes] FOREIGN KEY ([ConfigQuoteID]) REFERENCES [dbo].[SAConfigQuotes] ([ConfigQuoteID])
GO
ALTER TABLE [dbo].[SAConfigQuoteDetails] ADD CONSTRAINT [FK_SAConfigQuoteDetails_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO
ALTER TABLE [dbo].[SAConfigQuoteDetails] ADD CONSTRAINT [FK_SAConfigQuoteDetails_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SAConfigQuoteDetails] ADD CONSTRAINT [FK_SAConfigQuoteDetails_itemID_ICItems] FOREIGN KEY ([itemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[SAConfigQuoteDetails] ADD CONSTRAINT [FK_SAConfigQuoteDetails_SOID_SOOrders] FOREIGN KEY ([SOID]) REFERENCES [dbo].[SOOrders] ([SOID])
GO