CREATE TABLE [dbo].[SAConfigPrinters]
(
[ConfigPrinterID] [int] NOT NULL IDENTITY(1, 1),
[ConfigQuoteID] [int] NOT NULL,
[SupplySourceID] [int] NOT NULL,
[SupplyVendorID] [int] NOT NULL,
[Term] [int] NULL,
[Coverage] [decimal] (10, 5) NULL,
[ClrCoverage] [decimal] (10, 5) NULL,
[Margin] [decimal] (10, 5) NULL,
[BlkVolume] [int] NULL,
[BlkCPP] [decimal] (14, 8) NULL,
[ClrVolume] [int] NULL,
[ClrCPP] [decimal] (14, 8) NULL,
[BlkCost] [money] NULL,
[ClrCost] [money] NULL,
[TotalPayment] [money] NULL,
[TotalPrice] [money] NULL,
[TotalProfit] [money] NULL,
[TotalVolume] [bigint] NULL,
[TotalCost] [money] NULL,
[TotalMarginProfit] [money] NULL,
[TotalAvgCPP] [decimal] (14, 8) NULL,
[Selected] [bit] NULL,
[ClrMargin] [decimal] (18, 0) NULL,
[ManualTotals] [bit] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAConfigPrinters] ADD CONSTRAINT [PK_SAConfigPrinters] PRIMARY KEY CLUSTERED ([ConfigPrinterID], [ConfigQuoteID], [SupplySourceID], [SupplyVendorID]) ON [PRIMARY]
GO