CREATE TABLE [dbo].[SCQReportLabors]
(
[ReportLaborID] [int] NOT NULL,
[CallID] [int] NOT NULL,
[TechnicianID] [int] NOT NULL,
[Assist] [bit] NOT NULL,
[DispatchDate] [datetime] NULL,
[ArrivalDate] [datetime] NULL,
[DepartureDate] [datetime] NULL,
[TravelHours] [float] NULL,
[BeginOdometer] [decimal] (16, 1) NULL,
[EndOdometer] [decimal] (16, 1) NULL,
[Rollover] [bit] NULL,
[Mileage] [float] NULL,
[LaborHours] [float] NULL,
[LaborRate] [money] NULL,
[OvertimeHours] [float] NULL,
[OvertimeRate] [money] NULL,
[Amount] [money] NOT NULL CONSTRAINT [DF_SCQReportLabors_Amount] DEFAULT ((0)),
[BurdenRate] [money] NOT NULL CONSTRAINT [DF_SCQReportLabors_BurdenRate] DEFAULT ((0)),
[Dispatcher] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DispatchHistoryID] [int] NULL,
[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_SCQReportLabors_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCQReportLabors_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[ReportMaterialID] [int] NULL,
[TransactionWarrantyID] [int] NULL,
[IsWarrantied] [bit] NOT NULL CONSTRAINT [DF_SCQReportLabors_IsWarrantied] DEFAULT ((0)),
[ActualHours] [decimal] (18, 6) NULL,
[InterruptHours] [decimal] (18, 2) NULL,
[TaxFlag] [int] NOT NULL CONSTRAINT [DF_SCQReportLabors_TaxFlag] DEFAULT ((2)),
[ActivityCodeID] [int] NOT NULL,
[BillableMileage] [decimal] (16, 4) NOT NULL CONSTRAINT [DF_SCQReportLabors_BillableMileage] DEFAULT ((0)),
[RecalcNeeded] [bit] NOT NULL CONSTRAINT [DF_SCQReportLabors_RecalcNeeded] DEFAULT ((0)),
[DispatchID] [int] NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQReportLabors_Remarks] DEFAULT (''),
[Notes] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQReportLabors_Notes] DEFAULT (''),
[LaborGroupID] [int] NULL,
[Responded] [bit] NOT NULL CONSTRAINT [DF_SCQReportLabors_Responded] DEFAULT ((0)),
[TaxFlagID] [int] NOT NULL CONSTRAINT [DF_SCQReportLabors_TaxFlagID] DEFAULT ((3))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQReportLabors] ADD CONSTRAINT [PK_SCQReportLabors] PRIMARY KEY CLUSTERED ([ReportLaborID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQReportLabors] ADD CONSTRAINT [FK_SCQReportLabors_ActivityCodeID_PRActivityCodes] FOREIGN KEY ([ActivityCodeID]) REFERENCES [dbo].[PRActivityCodes] ([ActivityCodeID])
GO
ALTER TABLE [dbo].[SCQReportLabors] ADD CONSTRAINT [FK_SCQReportLabors_CallID_SCCalls] FOREIGN KEY ([CallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[SCQReportLabors] ADD CONSTRAINT [FK_SCQReportLabors_DispatchHistoryID_SCDispatchHistory] FOREIGN KEY ([DispatchHistoryID]) REFERENCES [dbo].[SCDispatchHistory] ([DispatchHistoryID])
GO
ALTER TABLE [dbo].[SCQReportLabors] ADD CONSTRAINT [FK_SCQReportLabors_DispatchID_SCDispatches] FOREIGN KEY ([DispatchID]) REFERENCES [dbo].[SCDispatches] ([DispatchID])
GO
ALTER TABLE [dbo].[SCQReportLabors] ADD CONSTRAINT [FK_SCQReportLabors_TaxFlagID_ShTaxFlags] FOREIGN KEY ([TaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SCQReportLabors] ADD CONSTRAINT [FK_SCQReportLabors_TechnicianID_SCTechnicians] FOREIGN KEY ([TechnicianID]) REFERENCES [dbo].[SCTechnicians] ([TechnicianID])
GO