CREATE TABLE [dbo].[SAConfigCurrentTCO]
(
[ConfigCurrentTCOID] [int] NOT NULL IDENTITY(1, 1),
[ConfigQuoteID] [int] NOT NULL,
[AvgBlackCPP] [decimal] (14, 8) NULL CONSTRAINT [DF_SAConfigCurrentTCO_AvgBlackCPP] DEFAULT ((0)),
[AvgColorCPP] [decimal] (14, 8) NULL CONSTRAINT [DF_SAConfigCurrentTCO_AvgColorCPP] DEFAULT ((0)),
[TotalCost] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCO_TotalCost] DEFAULT ((0)),
[BlackVolume] [decimal] (14, 4) NULL CONSTRAINT [DF_SAConfigCurrentTCO_BlackVolume] DEFAULT ((0)),
[ColorVolume] [decimal] (14, 4) NULL CONSTRAINT [DF_SAConfigCurrentTCO_ColorVolume] DEFAULT ((0)),
[AvgLaborCPP] [decimal] (14, 8) NULL CONSTRAINT [DF_SAConfigCurrentTCO_AvgLaborCPP] DEFAULT ((0)),
[AvgMiscCPP] [decimal] (14, 8) NULL CONSTRAINT [DF_SAConfigCurrentTCO_AvgMiscCPP] DEFAULT ((0)),
[ManualTotals] [bit] NOT NULL CONSTRAINT [DF_SAConfigCurrentTCO_ManualTotals] DEFAULT ((0)),
[MonthlyBlackCost] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCO_MonthlyBlackCost] DEFAULT ((0)),
[MonthlyColorCost] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCO_MonthlyColorCost] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAConfigCurrentTCO] ADD CONSTRAINT [PK_SAConfigCurrentTCO] PRIMARY KEY CLUSTERED ([ConfigCurrentTCOID]) ON [PRIMARY]
GO