Tables [dbo].[SAConfigCurrentTCO]
PropertyValue
Row Count (~)0
Created12:58:55 AM Thursday, March 21, 2019
Last Modified1:14:09 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_SAConfigCurrentTCO: ConfigCurrentTCOIDConfigCurrentTCOIDint4
False
1 - 1
ConfigQuoteIDint4
False
AvgBlackCPPdecimal(14,8)9
True
((0))
AvgColorCPPdecimal(14,8)9
True
((0))
TotalCostmoney8
True
((0))
BlackVolumedecimal(14,4)9
True
((0))
ColorVolumedecimal(14,4)9
True
((0))
AvgLaborCPPdecimal(14,8)9
True
((0))
AvgMiscCPPdecimal(14,8)9
True
((0))
ManualTotalsbit1
False
((0))
MonthlyBlackCostmoney8
True
((0))
MonthlyColorCostmoney8
True
((0))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SAConfigCurrentTCO: ConfigCurrentTCOIDPK_SAConfigCurrentTCOConfigCurrentTCOID
True
80
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