Tables [dbo].[SAConfigCurrentTCODetails]
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 NullsIdentityDefault
Cluster Primary Key PK_SAConfigCurrentTCODetails: CurrentTCODetailIDCurrentTCODetailIDint4
False
1 - 1
Foreign Keys FK_SAConfigCurrentTCODetails_ConfigCurrentTCOID_SAConfigCurrentTCO: [dbo].[SAConfigCurrentTCO].ConfigCurrentTCOIDConfigCurrentTCOIDint4
True
Foreign Keys FK_SAConfigCurrentTCODetails_DeviceItemID_SADeviceItems: [dbo].[SADeviceItems].DeviceItemIDDeviceItemIDint4
True
Foreign Keys FK_SAConfigCurrentTCODetails_DeviceTypeID_SADeviceType: [dbo].[SADeviceType].DeviceTypeIDDeviceTypeIDint4
True
Actionint4
True
((0))
Makevarchar(255)255
True
Modelvarchar(255)255
True
TrackedAsvarchar(255)255
True
IPAddressvarchar(16)16
True
Buildingvarchar(255)255
True
Floorvarchar(255)255
True
Departmentvarchar(255)255
True
SerialNumbervarchar(50)50
True
PurchaseDatedatetime8
True
EquipmentCostmoney8
True
((0))
Bundledbit1
True
((0))
IntroductionDatedatetime8
True
PrinterAgeint4
True
((0))
BlackSpeedint4
True
((0))
ColorSpeedint4
True
((0))
DepreciationScheduleint4
True
((0))
DepreciationAmountmoney8
True
((0))
Ownershipint4
True
((0))
LeasePaymentmoney8
True
((0))
Competitivebit1
True
((0))
Competitorvarchar(255)255
True
Notesvarchar(1000)1000
True
('')
FirstReadDatedatetime8
True
FirstBlackReaddecimal(18,2)9
True
((0))
FirstColorReaddecimal(18,2)9
True
((0))
SecondReadDatedatetime8
True
SecondBlackReaddecimal(18,2)9
True
((0))
SecondColorReaddecimal(18,2)9
True
((0))
DaysMeteredint4
True
((0))
BlackManuTonerFilldecimal(18,2)9
True
((0))
ColorManuTonerFilldecimal(18,2)9
True
((0))
BlackMonthlyVolumeint4
True
((0))
BlackFillRatiodecimal(18,2)9
True
((0))
BlackCostsmoney8
True
((0))
BlackTonerYieldint4
True
((0))
ColorMonthlyVolumeint4
True
((0))
ColorFillRatiodecimal(18,2)9
True
((0))
CyanCostsmoney8
True
((0))
CyanYieldint4
True
((0))
MagentaCostsmoney8
True
((0))
MagentaYieldint4
True
((0))
YellowCostsmoney8
True
((0))
YellowYieldint4
True
((0))
ServicePartCostmoney8
True
((0))
TransferKitCostmoney8
True
((0))
TransferKitYieldint4
True
((0))
MaintenanceKitCostmoney8
True
((0))
MaintenanceKitYieldint4
True
((0))
LaborRatemoney8
True
((0))
MiscDollarCostsmoney8
True
((0))
MiscRatedecimal(14,8)9
True
((0))
MiscVolumeint4
True
((0))
BlackCPPdecimal(14,8)9
True
((0))
ColorCPPdecimal(14,8)9
True
((0))
LaborCPPdecimal(14,8)9
True
((0))
MiscCPPdecimal(14,8)9
True
((0))
OverrideLaborRatebit1
True
((0))
BlackDrumCostmoney8
True
((0))
BlackDrumYieldint4
True
((0))
CyanDrumCostmoney8
True
((0))
CyanDrumYieldint4
True
((0))
MagentaDrumCostmoney8
True
((0))
MagentaDrumYieldint4
True
((0))
YellowDrumCostmoney8
True
((0))
YellowDrumYieldint4
True
((0))
FuserCostmoney8
True
((0))
FuserYieldint4
True
((0))
UseMeterInformationbit1
True
((0))
ContractedBWVolumeint4
True
((0))
ContractedColorVolumeint4
True
((0))
ContractedBWRatemoney8
True
((0))
ContractedColorRatemoney8
True
((0))
ContractedBWOveragemoney8
True
((0))
ContractedColorOveragemoney8
True
((0))
ContractedBaseCostVolumemoney8
True
((0))
OverrideAnyConsuCalcbit1
True
((0))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SAConfigCurrentTCODetails: CurrentTCODetailIDPK_SAConfigCurrentTCODetailsCurrentTCODetailID
True
80
NameColumns
FK_SAConfigCurrentTCODetails_ConfigCurrentTCOID_SAConfigCurrentTCOConfigCurrentTCOID->[dbo].[SAConfigCurrentTCO].[ConfigCurrentTCOID]
FK_SAConfigCurrentTCODetails_DeviceItemID_SADeviceItemsDeviceItemID->[dbo].[SADeviceItems].[DeviceItemID]
FK_SAConfigCurrentTCODetails_DeviceTypeID_SADeviceTypeDeviceTypeID->[dbo].[SADeviceType].[DeviceTypeID]
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