Tables [dbo].[SAConfigPrinterDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:58:55 AM Thursday, March 21, 2019
Last Modified1:14:15 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_SAConfigPrinterDetails: ConfigPrinterID\DetailIDConfigPrinterIDint4
False
((0))
Cluster Primary Key PK_SAConfigPrinterDetails: ConfigPrinterID\DetailIDDetailIDint4
False
Foreign Keys FK_SAConfigPrinterDetails_ConfigQuoteID_SAConfigQuotes: [dbo].[SAConfigQuotes].ConfigQuoteIDConfigQuoteIDint4
False
DeviceItemIDint4
True
DeviceTypeIDint4
True
SupplyVendorIDint4
True
SupplySourceIDint4
True
Makevarchar(255)255
False
Modelvarchar(255)255
False
SerialNumbervarchar(255)255
True
Meterint4
True
Volumeint4
True
ClrVolumeint4
True
ContractTermint4
True
MaintKitCostmoney8
True
MaintKitYieldint4
True
MaintKitCPPdecimal(14,8)9
True
PartsCostYrmoney8
True
PartsCPPdecimal(14,8)9
True
VendorNumbervarchar(30)30
True
TonerCostmoney8
True
TonerYieldint4
True
TonerCoveragePercentint4
True
TonerTrueYieldint4
True
TonerCPPdecimal(14,8)9
True
TotalCPPdecimal(14,8)9
True
ClrTonerCostmoney8
True
ClrTonerYieldint4
True
ClrTonerCPPdecimal(14,8)9
True
ClrTonerCoverageint4
True
ClrTonerTrueYieldint4
True
Marginint4
True
CartridgeQtyint4
True
ClrCartridgeQtyint4
True
Selectedbit1
True
DetailTypeIDint4
True
TransferKitCostmoney8
True
TransferKitYieldint4
True
TransferKitCPPdecimal(14,8)9
True
ClrMarginint4
True
CurrentTCODetailIDint4
True
LaborCPPdecimal(14,8)9
True
FuserCostmoney8
True
FuserYieldint4
True
FuserCPPdecimal(14,8)9
True
IPAddressvarchar(16)16
True
Buildingvarchar(255)255
True
Floorvarchar(255)255
True
Departmentvarchar(255)255
True
MACAddressvarchar(30)30
True
BlackDrumCostmoney8
True
BlackDrumYieldint4
True
CyanDrumCostmoney8
True
CyanDrumYieldint4
True
MagentaDrumCostmoney8
True
MagentaDrumYieldint4
True
YellowDrumCostmoney8
True
YellowDrumYieldint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SAConfigPrinterDetails: ConfigPrinterID\DetailIDPK_SAConfigPrinterDetailsConfigPrinterID, DetailID
True
80
NameColumns
FK_SAConfigPrinterDetails_ConfigQuoteID_SAConfigQuotesConfigQuoteID->[dbo].[SAConfigQuotes].[ConfigQuoteID]
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