Tables [dbo].[SynchFail_Call]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created1:00:54 AM Thursday, March 21, 2019
Last Modified1:00:54 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow Nulls
CallIDint4
False
ServerCallIDint4
True
UserIDvarchar(50)50
False
CallNumbervarchar(255)255
True
CallTypeIDint4
True
PriorityIDint4
True
Rankint4
True
StatusIDchar(3)3
True
WorkOrderNumbervarchar(255)255
True
WorkOrderIDint4
True
EquipmentIDint4
True
Callervarchar(255)255
True
CustomerIDint4
True
CustomerNamevarchar(128)128
True
CallDatedatetime8
True
EstStartDatedatetime8
True
DueDatedatetime8
True
EstimatedDurationint4
True
Territoryvarchar(50)50
True
Addressvarchar(64)64
True
Cityvarchar(32)32
True
Statevarchar(16)16
True
Countryvarchar(16)16
True
PostalCodevarchar(16)16
True
Descriptionvarchar(255)255
True
IncompleteCodeIDint4
True
IncompleteDeliveryMethodIDint4
True
IncompleteRequiredDatedatetime8
True
IncompleteRemarksvarchar(255)255
True
Notes1varchar(255)255
True
Notes2varchar(255)255
True
Notes3varchar(255)255
True
Notes4varchar(255)255
True
OnHoldCodeint4
True
MiscDescriptionvarchar(255)255
True
MiscAmountdecimal(18,4)9
True
PreventativeMaintenancebit1
True
MeterDisplayint4
True
CopyCreditsint4
True
IsActivebit1
False
LastUpdatedatetime8
True
ModifiedDatedatetime8
False
CreateDatedatetime8
False
ForceSavebit1
True
ExistsOnServerbit1
False
WarrantyDatedatetime8
True
CloseDatedatetime8
True
CancelCodeIDint4
True
CancelDescriptionvarchar(255)255
True
Freshbit1
True
TermIDint4
True
CheckOutTimedatetime8
True
CallTypevarchar(255)255
True
FailTypeint4
True
FailMessagevarchar(1024)1024
True
BillCodevarchar(50)50
True
DelayCodeIDint4
True
ServerHoldbit1
True
CREATE TABLE [dbo].[SynchFail_Call]
(
[CallID] [int] NOT NULL,
[ServerCallID] [int] NULL,
[UserID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CallNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallTypeID] [int] NULL,
[PriorityID] [int] NULL,
[Rank] [int] NULL,
[StatusID] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WorkOrderNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WorkOrderID] [int] NULL,
[EquipmentID] [int] NULL,
[Caller] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerID] [int] NULL,
[CustomerName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallDate] [datetime] NULL,
[EstStartDate] [datetime] NULL,
[DueDate] [datetime] NULL,
[EstimatedDuration] [int] NULL,
[Territory] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Address] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[City] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[State] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Country] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PostalCode] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IncompleteCodeID] [int] NULL,
[IncompleteDeliveryMethodID] [int] NULL,
[IncompleteRequiredDate] [datetime] NULL,
[IncompleteRemarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Notes1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Notes2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Notes3] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Notes4] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OnHoldCode] [int] NULL,
[MiscDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MiscAmount] [decimal] (18, 4) NULL,
[PreventativeMaintenance] [bit] NULL,
[MeterDisplay] [int] NULL,
[CopyCredits] [int] NULL,
[IsActive] [bit] NOT NULL,
[LastUpdate] [datetime] NULL,
[ModifiedDate] [datetime] NOT NULL,
[CreateDate] [datetime] NOT NULL,
[ForceSave] [bit] NULL,
[ExistsOnServer] [bit] NOT NULL,
[WarrantyDate] [datetime] NULL,
[CloseDate] [datetime] NULL,
[CancelCodeID] [int] NULL,
[CancelDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Fresh] [bit] NULL,
[TermID] [int] NULL,
[CheckOutTime] [datetime] NULL,
[CallType] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FailType] [int] NULL,
[FailMessage] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BillCode] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DelayCodeID] [int] NULL,
[ServerHold] [bit] NULL
) ON [PRIMARY]
GO