CREATE TABLE [dbo].[SCHReports]
(
[ReportID] [int] NOT NULL,
[ReportNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerID] [int] NULL,
[CustomerName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BillToID] [int] NULL,
[BillToName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContractID] [int] NULL,
[Contract] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BillCodeID] [int] NULL,
[BillCode] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallID] [int] NULL,
[CallNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallDate] [datetime] NULL,
[CallDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallNotes] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCHReports_CallNotes] DEFAULT (''),
[CallTypeID] [int] NULL,
[CallTypeDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallCanceled] [bit] NULL CONSTRAINT [DF_SCHReports_CallCanceled] DEFAULT ((0)),
[CallCancelCodeID] [int] NULL,
[CallCancelDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallReleaseDate] [datetime] NULL,
[Callback] [int] NOT NULL CONSTRAINT [DF_SCHReports_Callback] DEFAULT ((0)),
[RescheduledCallID] [int] NULL,
[RescheduledCallNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Date] [datetime] NULL,
[PONumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TermID] [int] NULL,
[Term] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TermDiscountRate] [float] NULL,
[TermDiscountDate] [datetime] NULL,
[DueDate] [datetime] NULL,
[SalesRepID] [int] NULL,
[SalesRep] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationID] [int] NULL,
[LocationNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationContact] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationPhone] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationFax] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationNotes] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MeterDate] [datetime] NULL,
[MeterDisplay] [int] NULL,
[MeterActual] [int] NULL,
[MeterOverride] [bit] NULL,
[CopyCredits] [int] NULL,
[IncompleteDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IncompleteCodeID] [int] NULL,
[OpenDate] [datetime] NULL,
[ResponseHours] [float] NULL,
[RepairHours] [float] NULL,
[DownHours] [float] NULL,
[CloseDate] [datetime] NULL,
[TravelBase] [money] NULL,
[TravelHours] [float] NULL CONSTRAINT [DF_SCHReports_TravelHours] DEFAULT ((0)),
[TravelRate] [money] NULL,
[Mileage] [float] NULL CONSTRAINT [DF_SCHReports_Mileage] DEFAULT ((0)),
[MileageRate] [money] NULL,
[TravelAmount] [money] NULL CONSTRAINT [DF_SCHReports_TravelAmount] DEFAULT ((0)),
[UseBurdenRate] [bit] NULL,
[TravelCostPerHour] [money] NULL,
[TravelCostPerMile] [money] NULL,
[TravelCost] [money] NULL CONSTRAINT [DF_SCHReports_TravelCost] DEFAULT ((0)),
[MiscDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MiscEarnedAmount] [money] NULL,
[MiscAmount] [money] NULL,
[EarnedAmount] [money] NULL CONSTRAINT [DF_SCHReports_EarnedAmount] DEFAULT ((0)),
[Remarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TaxCodeID] [int] NULL,
[TaxCode] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Taxable] [bit] NULL CONSTRAINT [DF_SCHReports_Taxable] DEFAULT ((1)),
[LaborAmount] [money] NULL CONSTRAINT [DF_SCHReports_LaborAmount] DEFAULT ((0)),
[MaterialAmount] [money] NULL CONSTRAINT [DF_SCHReports_MaterialAmount] DEFAULT ((0)),
[TaxAmount] [money] NULL CONSTRAINT [DF_SCHReports_TaxAmount] DEFAULT ((0)),
[PostInvoiceNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PreventativeMaintenance] [bit] NULL CONSTRAINT [DF_SCHReports_PreventativeMaintenance] DEFAULT ((0)),
[OnHoldCodeID] [int] NULL,
[OnHoldCode] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OnHoldReleaseDate] [datetime] NULL,
[OnHoldReleaserID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResponseCalcOverrideDate] [datetime] NULL,
[JobID] [int] NULL,
[Job] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DelayCodeID] [int] NULL,
[DelayCode] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CallTerritoryID] [int] NULL,
[CallTerritory] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipmentID] [int] NULL,
[EquipmentNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipItem] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipModelID] [int] NULL,
[EquipModel] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipMake] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipSerialNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MileageAmount] [money] NULL,
[MileageCost] [money] NULL,
[LaborCost] [money] NULL CONSTRAINT [DF_SCHReports_LaborCost] DEFAULT ((0)),
[MaterialCost] [money] NULL CONSTRAINT [DF_SCHReports_MaterialCost] DEFAULT ((0)),
[UseStandardAdjustment] [bit] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [PK_SCHReports] PRIMARY KEY CLUSTERED ([ReportID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_BillCodeID_SCBillCodes] FOREIGN KEY ([BillCodeID]) REFERENCES [dbo].[SCBillCodes] ([BillCodeID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_BillToID_ARCustomers] FOREIGN KEY ([BillToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_CallCancelCodeID_SCCancelCodes] FOREIGN KEY ([CallCancelCodeID]) REFERENCES [dbo].[SCCancelCodes] ([CancelCodeID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_CallID_SCCalls] FOREIGN KEY ([CallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_CallTerritoryID_SCTerritories] FOREIGN KEY ([CallTerritoryID]) REFERENCES [dbo].[SCTerritories] ([TerritoryID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_CallTypeID_SCCallTypes] FOREIGN KEY ([CallTypeID]) REFERENCES [dbo].[SCCallTypes] ([CallTypeID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_DelayCodeID_SCDelayCodes] FOREIGN KEY ([DelayCodeID]) REFERENCES [dbo].[SCDelayCodes] ([DelayCodeID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_EquipModelID_ICModels] FOREIGN KEY ([EquipModelID]) REFERENCES [dbo].[ICModels] ([ModelID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_IncompleteCodeID_SCIncompleteCodes] FOREIGN KEY ([IncompleteCodeID]) REFERENCES [dbo].[SCIncompleteCodes] ([IncompleteCodeID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_JobID_ICJobs] FOREIGN KEY ([JobID]) REFERENCES [dbo].[ICJobs] ([JobID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_LocationID_ARCustomers] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_OnHoldCodeID_ShOnHoldCodes] FOREIGN KEY ([OnHoldCodeID]) REFERENCES [dbo].[ShOnHoldCodes] ([OnHoldCodeID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_RescheduledCallID_SCCalls] FOREIGN KEY ([RescheduledCallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_SalesRepID_ShAgents] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ShAgents] ([AgentID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[SCHReports] ADD CONSTRAINT [FK_SCHReports_TermID_ShTerms] FOREIGN KEY ([TermID]) REFERENCES [dbo].[ShTerms] ([TermID])
GO