CREATE TABLE [dbo].[SAConfigCurrentTCODetails]
(
[CurrentTCODetailID] [int] NOT NULL IDENTITY(1, 1),
[ConfigCurrentTCOID] [int] NULL,
[DeviceItemID] [int] NULL,
[DeviceTypeID] [int] NULL,
[Action] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_Action] DEFAULT ((0)),
[Make] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Model] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TrackedAs] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IPAddress] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Building] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Floor] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Department] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SerialNumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PurchaseDate] [datetime] NULL,
[EquipmentCost] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_EquipmentCost] DEFAULT ((0)),
[Bundled] [bit] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_Bundled] DEFAULT ((0)),
[IntroductionDate] [datetime] NULL,
[PrinterAge] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_PrinterAge] DEFAULT ((0)),
[BlackSpeed] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_BlackSpeed] DEFAULT ((0)),
[ColorSpeed] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_ColorSpeed] DEFAULT ((0)),
[DepreciationSchedule] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_DepreciationSchedule] DEFAULT ((0)),
[DepreciationAmount] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_DepreciationAmount] DEFAULT ((0)),
[Ownership] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_Ownership] DEFAULT ((0)),
[LeasePayment] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_LeasePayment] DEFAULT ((0)),
[Competitive] [bit] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_Competitive] DEFAULT ((0)),
[Competitor] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Notes] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_Notes] DEFAULT (''),
[FirstReadDate] [datetime] NULL,
[FirstBlackRead] [decimal] (18, 2) NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_FirstBlackRead] DEFAULT ((0)),
[FirstColorRead] [decimal] (18, 2) NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_FirstColorRead] DEFAULT ((0)),
[SecondReadDate] [datetime] NULL,
[SecondBlackRead] [decimal] (18, 2) NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_SecondBlackRead] DEFAULT ((0)),
[SecondColorRead] [decimal] (18, 2) NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_SecondColorRead] DEFAULT ((0)),
[DaysMetered] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_DaysMetered] DEFAULT ((0)),
[BlackManuTonerFill] [decimal] (18, 2) NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_BlackManuTonerFill] DEFAULT ((0)),
[ColorManuTonerFill] [decimal] (18, 2) NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_ColorManuTonerFill] DEFAULT ((0)),
[BlackMonthlyVolume] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_BlackMonthlyVolume] DEFAULT ((0)),
[BlackFillRatio] [decimal] (18, 2) NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_BlackFillRatio] DEFAULT ((0)),
[BlackCosts] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_BlackCosts] DEFAULT ((0)),
[BlackTonerYield] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_BlackTonerYield] DEFAULT ((0)),
[ColorMonthlyVolume] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_ColorMonthlyVolume] DEFAULT ((0)),
[ColorFillRatio] [decimal] (18, 2) NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_ColorFillRatio] DEFAULT ((0)),
[CyanCosts] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_CyanCosts] DEFAULT ((0)),
[CyanYield] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_CyanYield] DEFAULT ((0)),
[MagentaCosts] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_MagentaCosts] DEFAULT ((0)),
[MagentaYield] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_MagentaYield] DEFAULT ((0)),
[YellowCosts] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_YellowCosts] DEFAULT ((0)),
[YellowYield] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_YellowYield] DEFAULT ((0)),
[ServicePartCost] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_ServicePartCost] DEFAULT ((0)),
[TransferKitCost] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_TransferKitCost] DEFAULT ((0)),
[TransferKitYield] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_TransferKitYield] DEFAULT ((0)),
[MaintenanceKitCost] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_MaintenanceKitCost] DEFAULT ((0)),
[MaintenanceKitYield] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_MaintenanceKitYield] DEFAULT ((0)),
[LaborRate] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_LaborRate] DEFAULT ((0)),
[MiscDollarCosts] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_MiscDollarCosts] DEFAULT ((0)),
[MiscRate] [decimal] (14, 8) NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_MiscRate] DEFAULT ((0)),
[MiscVolume] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_MiscVolume] DEFAULT ((0)),
[BlackCPP] [decimal] (14, 8) NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_BlackCPP] DEFAULT ((0)),
[ColorCPP] [decimal] (14, 8) NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_ColorCPP] DEFAULT ((0)),
[LaborCPP] [decimal] (14, 8) NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_LaborCPP] DEFAULT ((0)),
[MiscCPP] [decimal] (14, 8) NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_MiscCPP] DEFAULT ((0)),
[OverrideLaborRate] [bit] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_OverrideLaborRate] DEFAULT ((0)),
[BlackDrumCost] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_BlackDrumCost] DEFAULT ((0)),
[BlackDrumYield] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_BlackDrumYield] DEFAULT ((0)),
[CyanDrumCost] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_CyanDrumCost] DEFAULT ((0)),
[CyanDrumYield] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_CyanDrumYield] DEFAULT ((0)),
[MagentaDrumCost] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_MagentaDrumCost] DEFAULT ((0)),
[MagentaDrumYield] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_MagentaDrumYield] DEFAULT ((0)),
[YellowDrumCost] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_YellowDrumCost] DEFAULT ((0)),
[YellowDrumYield] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_YellowDrumYield] DEFAULT ((0)),
[FuserCost] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_FuserCost] DEFAULT ((0)),
[FuserYield] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_FuserYield] DEFAULT ((0)),
[UseMeterInformation] [bit] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_UseMeterInformation] DEFAULT ((0)),
[ContractedBWVolume] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_ContractedBWVolume] DEFAULT ((0)),
[ContractedColorVolume] [int] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_ContractedColorVolume] DEFAULT ((0)),
[ContractedBWRate] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_ContractedBWRate] DEFAULT ((0)),
[ContractedColorRate] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_ContractedColorRate] DEFAULT ((0)),
[ContractedBWOverage] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_ContractedBWOverage] DEFAULT ((0)),
[ContractedColorOverage] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_ContractedColorOverage] DEFAULT ((0)),
[ContractedBaseCostVolume] [money] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_ContractedBaseCostVolume] DEFAULT ((0)),
[OverrideAnyConsuCalc] [bit] NULL CONSTRAINT [DF_SAConfigCurrentTCODetails_OverrideAnyConsuCalc] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAConfigCurrentTCODetails] ADD CONSTRAINT [PK_SAConfigCurrentTCODetails] PRIMARY KEY CLUSTERED ([CurrentTCODetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAConfigCurrentTCODetails] ADD CONSTRAINT [FK_SAConfigCurrentTCODetails_ConfigCurrentTCOID_SAConfigCurrentTCO] FOREIGN KEY ([ConfigCurrentTCOID]) REFERENCES [dbo].[SAConfigCurrentTCO] ([ConfigCurrentTCOID])
GO
ALTER TABLE [dbo].[SAConfigCurrentTCODetails] ADD CONSTRAINT [FK_SAConfigCurrentTCODetails_DeviceItemID_SADeviceItems] FOREIGN KEY ([DeviceItemID]) REFERENCES [dbo].[SADeviceItems] ([DeviceItemID])
GO
ALTER TABLE [dbo].[SAConfigCurrentTCODetails] ADD CONSTRAINT [FK_SAConfigCurrentTCODetails_DeviceTypeID_SADeviceType] FOREIGN KEY ([DeviceTypeID]) REFERENCES [dbo].[SADeviceType] ([DeviceTypeID])
GO