CREATE TABLE [dbo].[SAConfigQuotes]
(
[ConfigQuoteID] [int] NOT NULL IDENTITY(1000, 1),
[ConfigQuoteName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[OpportunityID] [int] NOT NULL,
[CustomerID] [int] NULL,
[SalesRepID] [int] NOT NULL,
[Description] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_SAConfigQuotes_CreateDate] DEFAULT (getdate()),
[LastUpdated] [datetime] NOT NULL CONSTRAINT [DF_SAConfigQuotes_LastUpdated] DEFAULT (getdate()),
[QuoteDate] [datetime] NOT NULL CONSTRAINT [DF_SAConfigQuotes_QuoteDate] DEFAULT (getdate()),
[DueByDate] [datetime] NULL,
[NeededByDate] [datetime] NULL,
[PONumber] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OrderedBy] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExpirationDate] [datetime] NULL,
[Status] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SOID] [int] NULL,
[SONumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BillToID] [int] NULL,
[ShipToID] [int] NULL,
[MultiShip] [bit] NOT NULL CONSTRAINT [DF_SAConfigQuotes_MultiShip] DEFAULT ((0)),
[HidePrice] [bit] NOT NULL CONSTRAINT [DF_SAConfigQuotes_HidePrice] DEFAULT ((0)),
[HideAccessory] [bit] NOT NULL CONSTRAINT [DF_SAConfigQuotes_HideAccessory] DEFAULT ((0)),
[EnableLease] [bit] NOT NULL CONSTRAINT [DF_SAConfigQuotes_EnableLease] DEFAULT ((0)),
[LeasePrintOption] [bit] NOT NULL CONSTRAINT [DF_SAConfigQuotes_LeasePrintOption] DEFAULT ((0)),
[LeaseTermID] [int] NULL,
[LeaseIncludeBuyout] [bit] NOT NULL CONSTRAINT [DF_SAConfigQuotes_LeaseIncludeBuyout] DEFAULT ((0)),
[LeaseBuyoutAmount] [money] NULL,
[LeaseWrapBuyout] [bit] NULL,
[TotalPurchasePrice] [money] NULL,
[TotalSuggestedPrice] [money] NULL,
[TotalOutcostOverride] [money] NULL,
[TotalOutcostCalculated] [money] NULL,
[ProspectID] [int] NULL,
[LeaseName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LeaseCoName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[termInMonths] [tinyint] NULL,
[purchaseOptions] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LeaseFactor] [decimal] (14, 8) NULL,
[LeasePayment] [money] NULL,
[EnableCPP] [bit] NULL,
[BlackVolume] [decimal] (18, 0) NULL,
[ColorVolume] [decimal] (18, 0) NULL,
[ServiceRate] [decimal] (14, 8) NULL,
[ServiceClrRate] [decimal] (14, 8) NULL,
[OverageRate] [decimal] (14, 8) NULL,
[OverageClrRate] [decimal] (14, 8) NULL,
[TotalCPP] [money] NULL,
[ServiceAmount] [money] NULL,
[ServiceClrAmount] [money] NULL,
[CalcCPPFromList] [bit] NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TotalService] [money] NULL,
[InclServiceOnLease] [bit] NULL,
[InclPrintersOnService] [bit] NULL,
[PriceGroupID] [int] NULL,
[ContactFirstName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContactLastName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContactEmail] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SameAsBillTo] [bit] NULL CONSTRAINT [DF_SAConfigQuotes_SameAsBillTo] DEFAULT ((0)),
[ServiceBaseCost] [money] NULL,
[ServiceConnectFee] [money] NULL,
[ServiceInstallFee] [money] NULL,
[TaxCodeID] [int] NULL,
[ServiceBlackAlloc] [decimal] (18, 0) NULL,
[ServiceColorAlloc] [decimal] (18, 0) NULL,
[Completed] [bit] NULL,
[ShowAllCustomer] [bit] NULL,
[QuoteType] [int] NULL CONSTRAINT [DF_SAConfigQuotes_QuoteType] DEFAULT ((0)),
[MultiShipOneToOne] [bit] NULL,
[EquipmentAndContract] [bit] NULL,
[MultiShipSingleOrder] [bit] NOT NULL CONSTRAINT [DF_SAConfigQuotes_MultiShipSingleOrder] DEFAULT ((0)),
[MultiShipOrdersByShipTo] [bit] NOT NULL CONSTRAINT [DF_SAConfigQuotes_MultiShipOrdersByShipTo] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAConfigQuotes] ADD CONSTRAINT [PK_SAConfigQuotes] PRIMARY KEY CLUSTERED ([ConfigQuoteID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAConfigQuotes] ADD CONSTRAINT [FK_SAConfigQuotes_BillToID_ARCustomers] FOREIGN KEY ([BillToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SAConfigQuotes] ADD CONSTRAINT [FK_SAConfigQuotes_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SAConfigQuotes] ADD CONSTRAINT [FK_SAConfigQuotes_OpportunityID_SAOpportunity] FOREIGN KEY ([OpportunityID]) REFERENCES [dbo].[SAOpportunity] ([OpportunityID])
GO
ALTER TABLE [dbo].[SAConfigQuotes] ADD CONSTRAINT [FK_SAConfigQuotes_ProspectID_SAProspects] FOREIGN KEY ([ProspectID]) REFERENCES [dbo].[SAProspects] ([ProspectID])
GO
ALTER TABLE [dbo].[SAConfigQuotes] ADD CONSTRAINT [FK_SAConfigQuotes_SalesRepID_ARSalesReps] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ARSalesReps] ([SalesRepID])
GO
ALTER TABLE [dbo].[SAConfigQuotes] ADD CONSTRAINT [FK_SAConfigQuotes_ShipToID_ARCustomers] FOREIGN KEY ([ShipToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SAConfigQuotes] ADD CONSTRAINT [FK_SAConfigQuotes_SOID_SOOrders] FOREIGN KEY ([SOID]) REFERENCES [dbo].[SOOrders] ([SOID])
GO
ALTER TABLE [dbo].[SAConfigQuotes] ADD CONSTRAINT [FK_SAConfigQuotes_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO