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