Tables [dbo].[SCCallsEx]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:59:08 AM Thursday, March 21, 2019
Last Modified12:59:08 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow Nulls
CallIDint4
False
EquipmentIDint4
True
FinalCallIDint4
True
OpenDatedatetime8
True
CloseDatedatetime8
True
RescheduledCallIDint4
True
RescheduledCallbit1
False
CallTypeCategoryvarchar(10)10
False
DownHoursdecimal(18,2)9
True
MeterReadingGroupIDint4
True
MeterReadingDatedatetime8
True
MeterTotaldecimal(18,0)9
True
MeterTypesTotalvarchar(255)255
True
MeterBWdecimal(18,0)9
True
MeterTypesBWvarchar(255)255
True
MeterColordecimal(18,0)9
True
MeterTypesColorvarchar(255)255
True
MeterScannerdecimal(18,0)9
True
MeterTypesScannervarchar(255)255
True
MeterOtherdecimal(18,0)9
True
MeterTypesOthervarchar(255)255
True
NextCallIDint4
True
NextCMCallIDint4
True
NextPMCallIDint4
True
CBCBWdecimal(18,0)9
True
CBCCMBWdecimal(18,0)9
True
CBCPMBWdecimal(18,0)9
True
CBCColordecimal(18,0)9
True
CBCCMColordecimal(18,0)9
True
CBCPMColordecimal(18,0)9
True
CBCScannerdecimal(18,0)9
True
CBCCMScannerdecimal(18,0)9
True
CBCPMScannerdecimal(18,0)9
True
OnHoldHoursdecimal(18,2)9
True
CREATE TABLE [dbo].[SCCallsEx]
(
[CallID] [int] NOT NULL,
[EquipmentID] [int] NULL,
[FinalCallID] [int] NULL,
[OpenDate] [datetime] NULL,
[CloseDate] [datetime] NULL,
[RescheduledCallID] [int] NULL,
[RescheduledCall] [bit] NOT NULL,
[CallTypeCategory] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DownHours] [decimal] (18, 2) NULL,
[MeterReadingGroupID] [int] NULL,
[MeterReadingDate] [datetime] NULL,
[MeterTotal] [decimal] (18, 0) NULL,
[MeterTypesTotal] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MeterBW] [decimal] (18, 0) NULL,
[MeterTypesBW] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MeterColor] [decimal] (18, 0) NULL,
[MeterTypesColor] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MeterScanner] [decimal] (18, 0) NULL,
[MeterTypesScanner] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MeterOther] [decimal] (18, 0) NULL,
[MeterTypesOther] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NextCallID] [int] NULL,
[NextCMCallID] [int] NULL,
[NextPMCallID] [int] NULL,
[CBCBW] [decimal] (18, 0) NULL,
[CBCCMBW] [decimal] (18, 0) NULL,
[CBCPMBW] [decimal] (18, 0) NULL,
[CBCColor] [decimal] (18, 0) NULL,
[CBCCMColor] [decimal] (18, 0) NULL,
[CBCPMColor] [decimal] (18, 0) NULL,
[CBCScanner] [decimal] (18, 0) NULL,
[CBCCMScanner] [decimal] (18, 0) NULL,
[CBCPMScanner] [decimal] (18, 0) NULL,
[OnHoldHours] [decimal] (18, 2) NULL
) ON [PRIMARY]
GO