CREATE TABLE [dbo].[SCQReports]
(
[CallID] [int] NOT NULL,
[ReportNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ContractID] [int] NULL,
[BSABillForServices] [bit] NOT NULL,
[BSALaborDiscount] [float] NULL,
[BSAMaterialsDiscount] [float] NULL,
[BillCodeID] [int] NULL,
[Date] [datetime] NOT NULL,
[SalesRepID] [int] NULL,
[MeterDate] [datetime] NULL,
[MeterDisplay] [int] NULL,
[MeterActual] [int] NULL,
[MeterOverride] [bit] NOT NULL,
[CopyCredits] [int] NOT NULL,
[IncompleteDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IncompleteCodeID] [int] NULL,
[OpenDate] [datetime] NOT NULL,
[ResponseHours] [float] NOT NULL,
[RepairHours] [float] NOT NULL,
[DownHours] [float] NOT NULL,
[CloseDate] [datetime] NOT NULL,
[TravelBase] [money] NOT NULL,
[TravelHours] [float] NOT NULL CONSTRAINT [DF_SCQReports_TravelHours] DEFAULT ((0)),
[TravelRate] [money] NOT NULL,
[Mileage] [float] NOT NULL CONSTRAINT [DF_SCQReports_Mileage] DEFAULT ((0)),
[MileageRate] [money] NOT NULL,
[TravelAmount] [money] NOT NULL CONSTRAINT [DF_SCQReports_TravelAmount] DEFAULT ((0)),
[UseBurdenRate] [bit] NOT NULL,
[TravelCostPerHour] [money] NOT NULL,
[TravelCostPerMile] [money] NOT NULL,
[TravelCost] [money] NOT NULL CONSTRAINT [DF_SCQReports_TravelCost] DEFAULT ((0)),
[MiscDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MiscEarnedAmount] [money] NOT NULL,
[MiscAmount] [money] NOT NULL,
[TaxCodeID] [int] NULL,
[LaborAmount] [money] NOT NULL CONSTRAINT [DF_SCQReports_LaborAmount] DEFAULT ((0)),
[MaterialAmount] [money] NOT NULL CONSTRAINT [DF_SCQReports_MaterialAmount] DEFAULT ((0)),
[TaxAmount] [money] NOT NULL CONSTRAINT [DF_SCQReports_TaxAmount] DEFAULT ((0)),
[PreventativeMaintenance] [bit] NOT NULL CONSTRAINT [DF_SCQReports_PreventativeMaintenance] DEFAULT ((0)),
[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_SCQReports_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCQReports_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[MeterReadingDate] [datetime] NULL,
[DelayCodeID] [int] NULL,
[MileageAmount] [money] NOT NULL CONSTRAINT [DF_SCQReports_MileageAmount] DEFAULT ((0)),
[MileageCost] [money] NOT NULL CONSTRAINT [DF_SCQReports_MileageCost] DEFAULT ((0)),
[UseStandardAdjustment] [bit] NOT NULL CONSTRAINT [DF_SCQReports_UseStandardAdjustment] DEFAULT ((0)),
[BillableMileage] [decimal] (16, 4) NOT NULL CONSTRAINT [DF_SCQReports_BillableMileage] DEFAULT ((0)),
[RecalcNeeded] [bit] NOT NULL CONSTRAINT [DF_SCQReports_RecalcNeeded] DEFAULT ((0)),
[MiscTaxFlag] [int] NOT NULL CONSTRAINT [DF_SCQReports_MiscTaxFlag] DEFAULT ((0)),
[TravelTaxFlag] [int] NOT NULL,
[NetResolutionHours] [float] NOT NULL CONSTRAINT [DF_SCQReports_NetResolutionHours] DEFAULT ((0)),
[MiscTaxFlagID] [int] NOT NULL CONSTRAINT [DF_SCQReports_MiscTaxFlagID] DEFAULT ((1)),
[TravelTaxFlagID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQReports] ADD CONSTRAINT [PK_SCQReports] PRIMARY KEY CLUSTERED ([CallID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQReports] ADD CONSTRAINT [FK_SCQReports_BillCodeID_SCBillCodes] FOREIGN KEY ([BillCodeID]) REFERENCES [dbo].[SCBillCodes] ([BillCodeID])
GO
ALTER TABLE [dbo].[SCQReports] ADD CONSTRAINT [FK_SCQReports_CallID_SCCalls] FOREIGN KEY ([CallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[SCQReports] ADD CONSTRAINT [FK_SCQReports_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO
ALTER TABLE [dbo].[SCQReports] ADD CONSTRAINT [FK_SCQReports_DelayCodeID_SCDelayCodes] FOREIGN KEY ([DelayCodeID]) REFERENCES [dbo].[SCDelayCodes] ([DelayCodeID])
GO
ALTER TABLE [dbo].[SCQReports] ADD CONSTRAINT [FK_SCQReports_IncompleteCodeID_SCIncompleteCodes] FOREIGN KEY ([IncompleteCodeID]) REFERENCES [dbo].[SCIncompleteCodes] ([IncompleteCodeID])
GO
ALTER TABLE [dbo].[SCQReports] ADD CONSTRAINT [FK_SCQReports_MiscTaxFlagID_ShTaxFlags] FOREIGN KEY ([MiscTaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SCQReports] ADD CONSTRAINT [FK_SCQReports_SalesRepID_ARSalesReps] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ARSalesReps] ([SalesRepID])
GO
ALTER TABLE [dbo].[SCQReports] ADD CONSTRAINT [FK_SCQReports_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[SCQReports] ADD CONSTRAINT [FK_SCQReports_TravelTaxFlagID_ShTaxFlags] FOREIGN KEY ([TravelTaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO