CREATE TABLE [dbo].[SCReportLabors]
(
[ReportID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[TechnicianID] [int] NOT NULL,
[Assist] [bit] NOT NULL,
[DispatchDate] [datetime] NULL,
[ArrivalDate] [datetime] NOT NULL,
[DepartureDate] [datetime] NOT NULL,
[TravelHours] [float] NOT NULL,
[BeginOdometer] [decimal] (16, 1) NULL,
[EndOdometer] [decimal] (16, 1) NULL,
[Rollover] [bit] NOT NULL,
[Mileage] [float] NOT NULL,
[LaborHours] [float] NOT NULL,
[LaborRate] [money] NOT NULL,
[OvertimeHours] [float] NOT NULL,
[OvertimeRate] [money] NOT NULL,
[GLID] [int] NOT NULL,
[DeptID] [int] NULL,
[Amount] [money] NOT NULL CONSTRAINT [DF_SCReportLabors_Amount] DEFAULT ((0)),
[BurdenRate] [money] NOT NULL CONSTRAINT [DF_SCReportLabors_BurdenRate] DEFAULT ((0)),
[CostGLID] [int] NOT NULL,
[CostDeptID] [int] NULL,
[CostAppliedGLID] [int] NOT NULL,
[CostAppliedDeptID] [int] NULL,
[Cost] [money] NOT NULL CONSTRAINT [DF_SCReportLabors_Cost] 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_SCReportLabors_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCReportLabors_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[TransactionWarrantyID] [int] NULL,
[IsWarrantied] [bit] NOT NULL CONSTRAINT [DF_SCReportLabors_IsWarrantied] DEFAULT ((0)),
[ActualHours] [decimal] (18, 6) NULL,
[InterruptHours] [decimal] (18, 2) NULL,
[TaxFlag] [int] NOT NULL CONSTRAINT [DF_SCReportLabors_TaxFlag] DEFAULT ((2)),
[ActivityCodeID] [int] NOT NULL,
[BillableMileage] [decimal] (16, 4) NOT NULL CONSTRAINT [DF_SCReportLabors_BillableMileage] DEFAULT ((0)),
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCReportLabors_Remarks] DEFAULT (''),
[Notes] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCReportLabors_Notes] DEFAULT (''),
[TravelAmount] [money] NOT NULL CONSTRAINT [DF_SCReportLabors_TravelAmount] DEFAULT ((0)),
[MileageAmount] [money] NOT NULL CONSTRAINT [DF_SCReportLabors_MileageAmount] DEFAULT ((0)),
[EarnedAmount] [money] NOT NULL CONSTRAINT [DF_SCReportLabors_EarnedAmount] DEFAULT ((0)),
[TravelEarnedAmount] [money] NOT NULL CONSTRAINT [DF_SCReportLabors_TravelEarnedAmount] DEFAULT ((0)),
[MileageEarnedAmount] [money] NOT NULL CONSTRAINT [DF_SCReportLabors_MileageEarnedAmount] DEFAULT ((0)),
[LaborGroupID] [int] NULL,
[Responded] [bit] NOT NULL CONSTRAINT [DF_SCReportLabors_Responded] DEFAULT ((0)),
[TaxFlagID] [int] NOT NULL CONSTRAINT [DF_SCReportLabors_TaxFlagID] DEFAULT ((3))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCReportLabors] ADD CONSTRAINT [PK_SCReportLabors] PRIMARY KEY CLUSTERED ([ReportID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCReportLabors] ADD CONSTRAINT [FK_SCReportLabors_ActivityCodeID_PRActivityCodes] FOREIGN KEY ([ActivityCodeID]) REFERENCES [dbo].[PRActivityCodes] ([ActivityCodeID])
GO
ALTER TABLE [dbo].[SCReportLabors] ADD CONSTRAINT [FK_SCReportLabors_CostAppliedDeptID_GLDepts5] FOREIGN KEY ([CostAppliedDeptID]) REFERENCES [dbo].[GLDepts5] ([DeptID])
GO
ALTER TABLE [dbo].[SCReportLabors] ADD CONSTRAINT [FK_SCReportLabors_CostAppliedGLID_GLAccounts5] FOREIGN KEY ([CostAppliedGLID]) REFERENCES [dbo].[GLAccounts5] ([AccountID])
GO
ALTER TABLE [dbo].[SCReportLabors] ADD CONSTRAINT [FK_SCReportLabors_CostDeptID_GLDepts5] FOREIGN KEY ([CostDeptID]) REFERENCES [dbo].[GLDepts5] ([DeptID])
GO
ALTER TABLE [dbo].[SCReportLabors] ADD CONSTRAINT [FK_SCReportLabors_CostGLID_GLAccounts5] FOREIGN KEY ([CostGLID]) REFERENCES [dbo].[GLAccounts5] ([AccountID])
GO
ALTER TABLE [dbo].[SCReportLabors] ADD CONSTRAINT [FK_SCReportLabors_DeptID_GLDepts5] FOREIGN KEY ([DeptID]) REFERENCES [dbo].[GLDepts5] ([DeptID])
GO
ALTER TABLE [dbo].[SCReportLabors] ADD CONSTRAINT [FK_SCReportLabors_GLID_GLAccounts5] FOREIGN KEY ([GLID]) REFERENCES [dbo].[GLAccounts5] ([AccountID])
GO
ALTER TABLE [dbo].[SCReportLabors] ADD CONSTRAINT [FK_SCReportLabors_ReportID_SCReports] FOREIGN KEY ([ReportID]) REFERENCES [dbo].[SCReports] ([ReportID])
GO
ALTER TABLE [dbo].[SCReportLabors] ADD CONSTRAINT [FK_SCReportLabors_TaxFlagID_ShTaxFlags] FOREIGN KEY ([TaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SCReportLabors] ADD CONSTRAINT [FK_SCReportLabors_TechnicianID_SCTechnicians] FOREIGN KEY ([TechnicianID]) REFERENCES [dbo].[SCTechnicians] ([TechnicianID])
GO