Tables [dbo].[SOSDownTimeCalc]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created1:00:52 AM Thursday, March 21, 2019
Last Modified1:00:52 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow Nulls
Techniciannvarchar(50)100
True
Territorynvarchar(50)100
True
OrgTechnvarchar(50)100
True
OrgTechNamenvarchar(50)100
True
CallCloseDatesmalldatetime4
True
InvoiceNumbernvarchar(50)100
True
CallNumbernvarchar(50)100
True
CustomerIDint4
True
EquipmentIDint4
True
Modelnvarchar(50)100
True
Preffullnamenvarchar(50)100
True
ResponseTimefloat8
True
Contractnvarchar(50)100
True
ContractCodenvarchar(50)100
True
DownHoursfloat8
True
RepairHoursfloat8
True
Invoicedint4
True
OpenDatesmalldatetime4
True
ReleaseDatesmalldatetime4
True
TotalDownTimefloat8
True
OnHoldTimefloat8
True
ReleaseDownTimefloat8
True
Callidint4
True
RescheduleCallIDint4
True
MasterCallidint4
True
IncidentCloseDatesmalldatetime4
True
OnHoldCodenvarchar(50)100
True
Categorynvarchar(50)100
True
CallTypenvarchar(50)100
True
MasterCallNumbernvarchar(50)100
True
CreateDatesmalldatetime4
True
CreateYearint4
True
CreateMonthint4
True
CreateDayint4
True
CreateQuarterint4
True
CloseDatesmalldatetime4
True
CloseYearint4
True
CloseMonthint4
True
CloseDayint4
True
CloseQuarterint4
True
FCFixint4
True
IsContractint4
True
CREATE TABLE [dbo].[SOSDownTimeCalc]
(
[Technician] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Territory] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OrgTech] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OrgTechName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallCloseDate] [smalldatetime] NULL,
[InvoiceNumber] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallNumber] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerID] [int] NULL,
[EquipmentID] [int] NULL,
[Model] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Preffullname] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResponseTime] [float] NULL,
[Contract] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContractCode] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DownHours] [float] NULL,
[RepairHours] [float] NULL,
[Invoiced] [int] NULL,
[OpenDate] [smalldatetime] NULL,
[ReleaseDate] [smalldatetime] NULL,
[TotalDownTime] [float] NULL,
[OnHoldTime] [float] NULL,
[ReleaseDownTime] [float] NULL,
[Callid] [int] NULL,
[RescheduleCallID] [int] NULL,
[MasterCallid] [int] NULL,
[IncidentCloseDate] [smalldatetime] NULL,
[OnHoldCode] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Category] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallType] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MasterCallNumber] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreateDate] [smalldatetime] NULL,
[CreateYear] [int] NULL,
[CreateMonth] [int] NULL,
[CreateDay] [int] NULL,
[CreateQuarter] [int] NULL,
[CloseDate] [smalldatetime] NULL,
[CloseYear] [int] NULL,
[CloseMonth] [int] NULL,
[CloseDay] [int] NULL,
[CloseQuarter] [int] NULL,
[FCFix] [int] NULL,
[IsContract] [int] NULL
) ON [PRIMARY]
GO