CREATE TABLE [dbo].[SAConfigPrinterDetails]
(
[ConfigPrinterID] [int] NOT NULL CONSTRAINT [DF_SAConfigPrinterDetails_ConfigPrinterID] DEFAULT ((0)),
[DetailID] [int] NOT NULL,
[ConfigQuoteID] [int] NOT NULL,
[DeviceItemID] [int] NULL,
[DeviceTypeID] [int] NULL,
[SupplyVendorID] [int] NULL,
[SupplySourceID] [int] NULL,
[Make] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Model] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SerialNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Meter] [int] NULL,
[Volume] [int] NULL,
[ClrVolume] [int] NULL,
[ContractTerm] [int] NULL,
[MaintKitCost] [money] NULL,
[MaintKitYield] [int] NULL,
[MaintKitCPP] [decimal] (14, 8) NULL,
[PartsCostYr] [money] NULL,
[PartsCPP] [decimal] (14, 8) NULL,
[VendorNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TonerCost] [money] NULL,
[TonerYield] [int] NULL,
[TonerCoveragePercent] [int] NULL,
[TonerTrueYield] [int] NULL,
[TonerCPP] [decimal] (14, 8) NULL,
[TotalCPP] [decimal] (14, 8) NULL,
[ClrTonerCost] [money] NULL,
[ClrTonerYield] [int] NULL,
[ClrTonerCPP] [decimal] (14, 8) NULL,
[ClrTonerCoverage] [int] NULL,
[ClrTonerTrueYield] [int] NULL,
[Margin] [int] NULL,
[CartridgeQty] [int] NULL,
[ClrCartridgeQty] [int] NULL,
[Selected] [bit] NULL,
[DetailTypeID] [int] NULL,
[TransferKitCost] [money] NULL,
[TransferKitYield] [int] NULL,
[TransferKitCPP] [decimal] (14, 8) NULL,
[ClrMargin] [int] NULL,
[CurrentTCODetailID] [int] NULL,
[LaborCPP] [decimal] (14, 8) NULL,
[FuserCost] [money] NULL,
[FuserYield] [int] NULL,
[FuserCPP] [decimal] (14, 8) 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,
[MACAddress] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BlackDrumCost] [money] NULL,
[BlackDrumYield] [int] NULL,
[CyanDrumCost] [money] NULL,
[CyanDrumYield] [int] NULL,
[MagentaDrumCost] [money] NULL,
[MagentaDrumYield] [int] NULL,
[YellowDrumCost] [money] NULL,
[YellowDrumYield] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAConfigPrinterDetails] ADD CONSTRAINT [PK_SAConfigPrinterDetails] PRIMARY KEY CLUSTERED ([ConfigPrinterID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAConfigPrinterDetails] ADD CONSTRAINT [FK_SAConfigPrinterDetails_ConfigQuoteID_SAConfigQuotes] FOREIGN KEY ([ConfigQuoteID]) REFERENCES [dbo].[SAConfigQuotes] ([ConfigQuoteID])
GO