Tables [dbo].[SOSFastrakCalls]
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
CallNumberint4
True
CallDatedatetime8
True
InvoiceNumberint4
True
CompanyNamevarchar(50)50
True
Addressvarchar(50)50
True
Cityvarchar(50)50
False
Statevarchar(16)16
True
Zipvarchar(16)16
True
CustomerIDint4
True
CustomerNumbervarchar(50)50
True
PONumbervarchar(50)50
True
Modelvarchar(50)50
True
SerialNumbervarchar(50)50
True
RecDatedatetime8
True
RecHrsint4
True
RecMinint4
True
DispDatedatetime8
True
DispHrsint4
True
DispMinint4
True
ArrDatedatetime8
True
ArrHrsint4
True
ArrMinint4
True
RetDatedatetime8
True
RetHrsint4
True
RetMinint4
True
ResponseTimenumeric(18,0)9
True
RepairTimenumeric(18,0)9
True
ProbCodevarchar(10)10
True
ProbCodeDescvarchar(50)50
True
CallBackbit1
True
PrevCallnumbervarchar(15)15
True
ReturnYNvarchar(1)1
True
Meterint4
True
ContractNumbervarchar(15)15
True
ContractIDint4
True
Notesvarchar(250)250
True
CallNotesvarchar(250)250
True
Technicianvarchar(6)6
True
TechnicianIDint4
True
TechDescvarchar(50)50
True
Teamvarchar(50)50
True
EquipmentNumbervarchar(20)20
True
EquipmentiDint4
True
Rescheduledbit1
True
CREATE TABLE [dbo].[SOSFastrakCalls]
(
[CallNumber] [int] NULL,
[CallDate] [datetime] NULL,
[InvoiceNumber] [int] NULL,
[CompanyName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Address] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[City] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[State] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Zip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerID] [int] NULL,
[CustomerNumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PONumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Model] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SerialNumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RecDate] [datetime] NULL,
[RecHrs] [int] NULL,
[RecMin] [int] NULL,
[DispDate] [datetime] NULL,
[DispHrs] [int] NULL,
[DispMin] [int] NULL,
[ArrDate] [datetime] NULL,
[ArrHrs] [int] NULL,
[ArrMin] [int] NULL,
[RetDate] [datetime] NULL,
[RetHrs] [int] NULL,
[RetMin] [int] NULL,
[ResponseTime] [numeric] (18, 0) NULL,
[RepairTime] [numeric] (18, 0) NULL,
[ProbCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ProbCodeDesc] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallBack] [bit] NULL,
[PrevCallnumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ReturnYN] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Meter] [int] NULL,
[ContractNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContractID] [int] NULL,
[Notes] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallNotes] [varchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Technician] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TechnicianID] [int] NULL,
[TechDesc] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Team] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipmentNumber] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipmentiD] [int] NULL,
[Rescheduled] [bit] NULL
) ON [PRIMARY]
GO