Tables [dbo].[QTEquipStats]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:58:42 AM Thursday, March 21, 2019
Last Modified12:58:42 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow Nulls
CallIDint4
True
EquipmentIDint4
True
ItemIDint4
True
CustomerIDint4
True
TechnicianIDint4
True
CallDatedatetime8
True
UseableCallDatedatetime8
True
CallTypeIDint4
True
ContractIDint4
True
ReportIDint4
True
MeterDatedatetime8
True
MeterDisplayint4
True
MeterActualint4
True
TerritoryIDint4
True
NextReportIDint4
True
NextCallDatedatetime8
True
NextMeterDatedatetime8
True
NextMeterDisplayint4
True
NextMeterActualint4
True
UsableMeterint4
True
CallDaysint4
True
CBCint4
True
OnHoldCodevarchar(50)50
True
OnHoldCodeTypevarchar(32)32
True
incompletecodeidint4
True
Partscostmoney8
True
Travelhoursfloat8
True
Repairhoursfloat8
True
ResponseHoursfloat8
True
DownHoursfloat8
True
NextOnHoldCodevarchar(50)50
True
NextOnHoldTypevarchar(32)32
True
NextPartscostmoney8
True
NextTravelhoursfloat8
True
NextRepairhoursfloat8
True
NextResponseHoursfloat8
True
NextDownHoursfloat8
True
NextCallNumbervarchar(50)50
True
CallBackCallidint4
True
CallBackNumbervarchar(255)255
True
Rescheduledcallidint4
True
MonthlyAvgRunRateint4
True
TotalMeterActualint4
True
TotalMeterActualMetersvarchar(255)255
True
NextTotalMeterActualint4
True
NextTotalMeterActualMetersvarchar(255)255
True
TotalCBCint4
True
MeterReadingGroupIDint4
True
CREATE TABLE [dbo].[QTEquipStats]
(
[CallID] [int] NULL,
[EquipmentID] [int] NULL,
[ItemID] [int] NULL,
[CustomerID] [int] NULL,
[TechnicianID] [int] NULL,
[CallDate] [datetime] NULL,
[UseableCallDate] [datetime] NULL,
[CallTypeID] [int] NULL,
[ContractID] [int] NULL,
[ReportID] [int] NULL,
[MeterDate] [datetime] NULL,
[MeterDisplay] [int] NULL,
[MeterActual] [int] NULL,
[TerritoryID] [int] NULL,
[NextReportID] [int] NULL,
[NextCallDate] [datetime] NULL,
[NextMeterDate] [datetime] NULL,
[NextMeterDisplay] [int] NULL,
[NextMeterActual] [int] NULL,
[UsableMeter] [int] NULL,
[CallDays] [int] NULL,
[CBC] [int] NULL,
[OnHoldCode] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OnHoldCodeType] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[incompletecodeid] [int] NULL,
[Partscost] [money] NULL,
[Travelhours] [float] NULL,
[Repairhours] [float] NULL,
[ResponseHours] [float] NULL,
[DownHours] [float] NULL,
[NextOnHoldCode] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NextOnHoldType] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NextPartscost] [money] NULL,
[NextTravelhours] [float] NULL,
[NextRepairhours] [float] NULL,
[NextResponseHours] [float] NULL,
[NextDownHours] [float] NULL,
[NextCallNumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallBackCallid] [int] NULL,
[CallBackNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Rescheduledcallid] [int] NULL,
[MonthlyAvgRunRate] [int] NULL,
[TotalMeterActual] [int] NULL,
[TotalMeterActualMeters] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NextTotalMeterActual] [int] NULL,
[NextTotalMeterActualMeters] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TotalCBC] [int] NULL,
[MeterReadingGroupID] [int] NULL
) ON [PRIMARY]
GO