Tables [dbo].[SCCalls]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:55:57 AM Thursday, March 21, 2019
Last Modified1:15:32 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_SCCalls: CallIDCallIDint4
False
Foreign Keys FK_SCCalls_WorkOrderID_SCWorkOrders: [dbo].[SCWorkOrders].WorkOrderIDWorkOrderIDint4
False
CallNumbervarchar(32)32
False
Foreign Keys FK_SCCalls_EquipmentID_SCEquipments: [dbo].[SCEquipments].EquipmentIDEquipmentIDint4
True
Foreign Keys FK_SCCalls_CustomerID_ARCustomers: [dbo].[ARCustomers].CustomerIDCustomerIDint4
False
Foreign Keys FK_SCCalls_BillToID_ARCustomers: [dbo].[ARCustomers].BillToIDBillToIDint4
False
Foreign Keys FK_SCCalls_ContractID_SCContracts: [dbo].[SCContracts].ContractIDContractIDint4
True
Foreign Keys FK_SCCalls_BillCodeID_SCBillCodes: [dbo].[SCBillCodes].BillCodeIDBillCodeIDint4
True
Callervarchar(255)255
False
Datedatetime8
False
ReqDatedatetime8
False
EstStartDatedatetime8
True
PONumbervarchar(32)32
False
Foreign Keys FK_SCCalls_TechnicianID_SCTechnicians: [dbo].[SCTechnicians].TechnicianIDTechnicianIDint4
False
Descriptionvarchar(255)255
False
Foreign Keys FK_SCCalls_CallTypeID_SCCallTypes: [dbo].[SCCallTypes].CallTypeIDCallTypeIDint4
False
EstDurationint4
False
Foreign Keys FK_SCCalls_PriorityID_SCPriorities: [dbo].[SCPriorities].PriorityIDPriorityIDint4
False
Notestextmax
True
Statuschar(3)3
False
Foreign Keys FK_SCCalls_CancelCodeID_SCCancelCodes: [dbo].[SCCancelCodes].CancelCodeIDCancelCodeIDint4
True
Dispatchedint4
False
((0))
AddressStreetvarchar(64)64
False
('')
AddressCityvarchar(32)32
False
('')
AddressStatevarchar(16)16
False
('')
AddressZipvarchar(16)16
False
('')
AddressCountryvarchar(16)16
False
('')
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
Foreign Keys FK_SCCalls_OnHoldCodeID_ShOnHoldCodes: [dbo].[ShOnHoldCodes].OnHoldCodeIDOnHoldCodeIDint4
True
OnHoldReleaseDatedatetime8
True
OnHoldReleaserIDvarchar(8)8
True
ResponseCalcOverrideDatedatetime8
True
Foreign Keys FK_SCCalls_RescheduledCallID_SCCalls: [dbo].[SCCalls].RescheduledCallIDRescheduledCallIDint4
True
CloseDatedatetime8
True
CancelDescriptionvarchar(255)255
False
('')
Callbackbit1
False
((0))
CallBackOverriddenByIDvarchar(10)10
False
('')
CallBackCallIDint4
True
Foreign Keys FK_SCCalls_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_SCCalls_JobID_ICJobs: [dbo].[ICJobs].JobIDJobIDint4
True
UntilDueLastCalcDatedatetime8
True
Foreign Keys FK_SCCalls_StartPriorityID_SCPriorities: [dbo].[SCPriorities].StartPriorityIDStartPriorityIDint4
True
DesiredResponseTimeint4
True
UntilDueint4
True
CallAlertbit1
False
((0))
CallAlertOverriddenByIDvarchar(10)10
False
('')
CheckOutTimedatetime8
True
BadSynchDatavarchar(1024)1024
True
Messagevarchar(1024)1024
True
Foreign Keys FK_SCCalls_DBFileHeaderID_DBFileHeader: [dbo].[DBFileHeader].DBFileHeaderIDDBFileHeaderIDint4
False
((1))
EquipDescriptionvarchar(255)255
True
EquipSerialNumbervarchar(30)30
True
Foreign Keys FK_SCCalls_EquipModelID_ICModels: [dbo].[ICModels].EquipModelIDEquipModelIDint4
True
AutoGenerateEquipOnInvoicebit1
False
((0))
Foreign Keys FK_SCCalls_CustomerTimeZoneCodeID_SHTimeZoneCodes: [dbo].[SHTimeZoneCodes].CustomerTimeZoneCodeIDCustomerTimeZoneCodeIDint4
True
CustomerTimeZoneBiasdecimal(14,4)9
True
Foreign Keys FK_SCCalls_ServiceHourCodeID_SHServiceHourCodes: [dbo].[SHServiceHourCodes].ServiceHourCodeIDServiceHourCodeIDint4
False
((1))
DayBeginTimedatetime8
True
DayEndTimedatetime8
True
Foreign Keys FK_SCCalls_MasterCallID_SCCalls: [dbo].[SCCalls].MasterCallIDMasterCallIDint4
True
ServerTimezoneBiasdecimal(14,4)9
True
CustomerTimezoneDSTbit1
False
((0))
Foreign Keys FK_SCCalls_NoteID_SCCallNotes: [dbo].[SCCallNotes].NoteIDNoteIDint4
True
NoteFlagint4
False
((0))
SendInvoiceToTechint4
False
((0))
CallOrderint4
False
((-1))
Foreign Keys FK_SCCalls_CallerContactID_CMContacts: [dbo].[CMContacts].CallerContactIDCallerContactIDint4
True
Foreign Keys FK_SCCalls_DependentCallID_SCCalls: [dbo].[SCCalls].DependentCallIDDependentCallIDint4
True
NoteCountint4
False
((0))
Foreign Keys FK_SCCalls_ItemID_ICItems: [dbo].[ICItems].ItemIDItemIDint4
True
Foreign Keys FK_SCCalls_ContractDetailID_SCContractDetails: [dbo].[SCContractDetails].ContractDetailIDContractDetailIDint4
True
Foreign Keys FK_SCCalls_LocationID_ARCustomers: [dbo].[ARCustomers].LocationIDLocationIDint4
False
Foreign Keys FK_SCCalls_SLACodeID_SCSLACodes: [dbo].[SCSLACodes].SLACodeIDSLACodeIDint4
True
ReportHoldIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCCalls: CallIDPK_SCCallsCallID
True
80
NameNo CheckColumns
FK_SCCalls_BillCodeID_SCBillCodesBillCodeID->[dbo].[SCBillCodes].[BillCodeID]
FK_SCCalls_BillToID_ARCustomers
True
BillToID->[dbo].[ARCustomers].[CustomerID]
FK_SCCalls_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_SCCalls_CallerContactID_CMContactsCallerContactID->[dbo].[CMContacts].[ContactID]
FK_SCCalls_CallTypeID_SCCallTypesCallTypeID->[dbo].[SCCallTypes].[CallTypeID]
FK_SCCalls_CancelCodeID_SCCancelCodesCancelCodeID->[dbo].[SCCancelCodes].[CancelCodeID]
FK_SCCalls_ContractDetailID_SCContractDetailsContractDetailID->[dbo].[SCContractDetails].[ContractDetailID]
FK_SCCalls_ContractID_SCContractsContractID->[dbo].[SCContracts].[ContractID]
FK_SCCalls_CustomerID_ARCustomers
True
CustomerID->[dbo].[ARCustomers].[CustomerID]
FK_SCCalls_CustomerTimeZoneCodeID_SHTimeZoneCodesCustomerTimeZoneCodeID->[dbo].[SHTimeZoneCodes].[TimeZoneCodeID]
FK_SCCalls_DBFileHeaderID_DBFileHeaderDBFileHeaderID->[dbo].[DBFileHeader].[DBFileHeaderID]
FK_SCCalls_DependentCallID_SCCallsDependentCallID->[dbo].[SCCalls].[CallID]
FK_SCCalls_EquipmentID_SCEquipmentsEquipmentID->[dbo].[SCEquipments].[EquipmentID]
FK_SCCalls_EquipModelID_ICModelsEquipModelID->[dbo].[ICModels].[ModelID]
FK_SCCalls_ItemID_ICItemsItemID->[dbo].[ICItems].[ItemID]
FK_SCCalls_JobID_ICJobsJobID->[dbo].[ICJobs].[JobID]
FK_SCCalls_LocationID_ARCustomersLocationID->[dbo].[ARCustomers].[CustomerID]
FK_SCCalls_MasterCallID_SCCallsMasterCallID->[dbo].[SCCalls].[CallID]
FK_SCCalls_NoteID_SCCallNotesNoteID->[dbo].[SCCallNotes].[NoteID]
FK_SCCalls_OnHoldCodeID_ShOnHoldCodesOnHoldCodeID->[dbo].[ShOnHoldCodes].[OnHoldCodeID]
FK_SCCalls_PriorityID_SCPrioritiesPriorityID->[dbo].[SCPriorities].[PriorityID]
FK_SCCalls_RescheduledCallID_SCCallsRescheduledCallID->[dbo].[SCCalls].[CallID]
FK_SCCalls_ServiceHourCodeID_SHServiceHourCodesServiceHourCodeID->[dbo].[SHServiceHourCodes].[ServiceHourCodeID]
FK_SCCalls_SLACodeID_SCSLACodesSLACodeID->[dbo].[SCSLACodes].[SLACodeID]
FK_SCCalls_StartPriorityID_SCPrioritiesStartPriorityID->[dbo].[SCPriorities].[PriorityID]
FK_SCCalls_TechnicianID_SCTechniciansTechnicianID->[dbo].[SCTechnicians].[TechnicianID]
FK_SCCalls_WorkOrderID_SCWorkOrdersWorkOrderID->[dbo].[SCWorkOrders].[WorkOrderID]
CREATE TABLE [dbo].[SCCalls]
(
[CallID] [int] NOT NULL,
[WorkOrderID] [int] NOT NULL,
[CallNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[EquipmentID] [int] NULL,
[CustomerID] [int] NOT NULL,
[BillToID] [int] NOT NULL,
[ContractID] [int] NULL,
[BillCodeID] [int] NULL,
[Caller] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Date] [datetime] NOT NULL,
[ReqDate] [datetime] NOT NULL,
[EstStartDate] [datetime] NULL,
[PONumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TechnicianID] [int] NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CallTypeID] [int] NOT NULL,
[EstDuration] [int] NOT NULL,
[PriorityID] [int] NOT NULL,
[Notes] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Status] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CancelCodeID] [int] NULL,
[Dispatched] [int] NOT NULL CONSTRAINT [DF_SCCalls_Dispatched] DEFAULT ((0)),
[AddressStreet] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCCalls_AddressStreet] DEFAULT (''),
[AddressCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCCalls_AddressCity] DEFAULT (''),
[AddressState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCCalls_AddressState] DEFAULT (''),
[AddressZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCCalls_AddressZip] DEFAULT (''),
[AddressCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCCalls_AddressCountry] DEFAULT (''),
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_SCCalls_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCCalls_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[OnHoldCodeID] [int] NULL,
[OnHoldReleaseDate] [datetime] NULL,
[OnHoldReleaserID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResponseCalcOverrideDate] [datetime] NULL,
[RescheduledCallID] [int] NULL,
[CloseDate] [datetime] NULL,
[CancelDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCCalls_CancelDescription] DEFAULT (''),
[Callback] [bit] NOT NULL CONSTRAINT [DF_SCCalls_Callback] DEFAULT ((0)),
[CallBackOverriddenByID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCCalls_CallBackOverriddenByID] DEFAULT (''),
[CallBackCallID] [int] NULL,
[BranchID] [int] NOT NULL,
[JobID] [int] NULL,
[UntilDueLastCalcDate] [datetime] NULL,
[StartPriorityID] [int] NULL,
[DesiredResponseTime] [int] NULL,
[UntilDue] [int] NULL,
[CallAlert] [bit] NOT NULL CONSTRAINT [DF_SCCalls_CallAlert] DEFAULT ((0)),
[CallAlertOverriddenByID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCCalls_CallAlertOverriddenByID] DEFAULT (''),
[CheckOutTime] [datetime] NULL,
[BadSynchData] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Message] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DBFileHeaderID] [int] NOT NULL CONSTRAINT [DF_SCCalls_DBFileHeaderID] DEFAULT ((1)),
[EquipDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipSerialNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipModelID] [int] NULL,
[AutoGenerateEquipOnInvoice] [bit] NOT NULL CONSTRAINT [DF_SCCalls_AutoGenerateEquipOnInvoice] DEFAULT ((0)),
[CustomerTimeZoneCodeID] [int] NULL,
[CustomerTimeZoneBias] [decimal] (14, 4) NULL,
[ServiceHourCodeID] [int] NOT NULL CONSTRAINT [DF_SCCalls_ServiceHourCodeID] DEFAULT ((1)),
[DayBeginTime] [datetime] NULL,
[DayEndTime] [datetime] NULL,
[MasterCallID] [int] NULL,
[ServerTimezoneBias] [decimal] (14, 4) NULL,
[CustomerTimezoneDST] [bit] NOT NULL CONSTRAINT [DF_SCCalls_CustomerTimezoneDST] DEFAULT ((0)),
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_SCCalls_NoteFlag] DEFAULT ((0)),
[SendInvoiceToTech] [int] NOT NULL CONSTRAINT [DF_SCCalls_SendInvoiceToTech] DEFAULT ((0)),
[CallOrder] [int] NOT NULL CONSTRAINT [DF_SCCalls_CallOrder] DEFAULT ((-1)),
[CallerContactID] [int] NULL,
[DependentCallID] [int] NULL,
[NoteCount] [int] NOT NULL CONSTRAINT [DF_SCCalls_NoteCount] DEFAULT ((0)),
[ItemID] [int] NULL,
[ContractDetailID] [int] NULL,
[LocationID] [int] NOT NULL,
[SLACodeID] [int] NULL,
[ReportHoldID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [PK_SCCalls] PRIMARY KEY CLUSTERED  ([CallID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_BillCodeID_SCBillCodes] FOREIGN KEY ([BillCodeID]) REFERENCES [dbo].[SCBillCodes] ([BillCodeID])
GO
ALTER TABLE [dbo].[SCCalls] WITH NOCHECK ADD CONSTRAINT [FK_SCCalls_BillToID_ARCustomers] FOREIGN KEY ([BillToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_CallerContactID_CMContacts] FOREIGN KEY ([CallerContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_CallTypeID_SCCallTypes] FOREIGN KEY ([CallTypeID]) REFERENCES [dbo].[SCCallTypes] ([CallTypeID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_CancelCodeID_SCCancelCodes] FOREIGN KEY ([CancelCodeID]) REFERENCES [dbo].[SCCancelCodes] ([CancelCodeID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_ContractDetailID_SCContractDetails] FOREIGN KEY ([ContractDetailID]) REFERENCES [dbo].[SCContractDetails] ([ContractDetailID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO
ALTER TABLE [dbo].[SCCalls] WITH NOCHECK ADD CONSTRAINT [FK_SCCalls_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_CustomerTimeZoneCodeID_SHTimeZoneCodes] FOREIGN KEY ([CustomerTimeZoneCodeID]) REFERENCES [dbo].[SHTimeZoneCodes] ([TimeZoneCodeID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_DBFileHeaderID_DBFileHeader] FOREIGN KEY ([DBFileHeaderID]) REFERENCES [dbo].[DBFileHeader] ([DBFileHeaderID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_DependentCallID_SCCalls] FOREIGN KEY ([DependentCallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_EquipModelID_ICModels] FOREIGN KEY ([EquipModelID]) REFERENCES [dbo].[ICModels] ([ModelID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_JobID_ICJobs] FOREIGN KEY ([JobID]) REFERENCES [dbo].[ICJobs] ([JobID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_LocationID_ARCustomers] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_MasterCallID_SCCalls] FOREIGN KEY ([MasterCallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_NoteID_SCCallNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[SCCallNotes] ([NoteID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_OnHoldCodeID_ShOnHoldCodes] FOREIGN KEY ([OnHoldCodeID]) REFERENCES [dbo].[ShOnHoldCodes] ([OnHoldCodeID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_PriorityID_SCPriorities] FOREIGN KEY ([PriorityID]) REFERENCES [dbo].[SCPriorities] ([PriorityID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_RescheduledCallID_SCCalls] FOREIGN KEY ([RescheduledCallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_ServiceHourCodeID_SHServiceHourCodes] FOREIGN KEY ([ServiceHourCodeID]) REFERENCES [dbo].[SHServiceHourCodes] ([ServiceHourCodeID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_SLACodeID_SCSLACodes] FOREIGN KEY ([SLACodeID]) REFERENCES [dbo].[SCSLACodes] ([SLACodeID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_StartPriorityID_SCPriorities] FOREIGN KEY ([StartPriorityID]) REFERENCES [dbo].[SCPriorities] ([PriorityID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_TechnicianID_SCTechnicians] FOREIGN KEY ([TechnicianID]) REFERENCES [dbo].[SCTechnicians] ([TechnicianID])
GO
ALTER TABLE [dbo].[SCCalls] ADD CONSTRAINT [FK_SCCalls_WorkOrderID_SCWorkOrders] FOREIGN KEY ([WorkOrderID]) REFERENCES [dbo].[SCWorkOrders] ([WorkOrderID])
GO