Tables [dbo].[SCReportLabors]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:55:58 AM Thursday, March 21, 2019
Last Modified1:15:28 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_SCReportLabors: ReportID\DetailIDForeign Keys FK_SCReportLabors_ReportID_SCReports: [dbo].[SCReports].ReportIDReportIDint4
False
Cluster Primary Key PK_SCReportLabors: ReportID\DetailIDDetailIDint4
False
Foreign Keys FK_SCReportLabors_TechnicianID_SCTechnicians: [dbo].[SCTechnicians].TechnicianIDTechnicianIDint4
False
Assistbit1
False
DispatchDatedatetime8
True
ArrivalDatedatetime8
False
DepartureDatedatetime8
False
TravelHoursfloat8
False
BeginOdometerdecimal(16,1)9
True
EndOdometerdecimal(16,1)9
True
Rolloverbit1
False
Mileagefloat8
False
LaborHoursfloat8
False
LaborRatemoney8
False
OvertimeHoursfloat8
False
OvertimeRatemoney8
False
Foreign Keys FK_SCReportLabors_GLID_GLAccounts5: [dbo].[GLAccounts5].GLIDGLIDint4
False
Foreign Keys FK_SCReportLabors_DeptID_GLDepts5: [dbo].[GLDepts5].DeptIDDeptIDint4
True
Amountmoney8
False
((0))
BurdenRatemoney8
False
((0))
Foreign Keys FK_SCReportLabors_CostGLID_GLAccounts5: [dbo].[GLAccounts5].CostGLIDCostGLIDint4
False
Foreign Keys FK_SCReportLabors_CostDeptID_GLDepts5: [dbo].[GLDepts5].CostDeptIDCostDeptIDint4
True
Foreign Keys FK_SCReportLabors_CostAppliedGLID_GLAccounts5: [dbo].[GLAccounts5].CostAppliedGLIDCostAppliedGLIDint4
False
Foreign Keys FK_SCReportLabors_CostAppliedDeptID_GLDepts5: [dbo].[GLDepts5].CostAppliedDeptIDCostAppliedDeptIDint4
True
Costmoney8
False
((0))
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
TransactionWarrantyIDint4
True
IsWarrantiedbit1
False
((0))
ActualHoursdecimal(18,6)9
True
InterruptHoursdecimal(18,2)9
True
TaxFlagint4
False
((2))
Foreign Keys FK_SCReportLabors_ActivityCodeID_PRActivityCodes: [dbo].[PRActivityCodes].ActivityCodeIDActivityCodeIDint4
False
BillableMileagedecimal(16,4)9
False
((0))
Remarksvarchar(1024)1024
False
('')
Notesvarchar(1024)1024
False
('')
TravelAmountmoney8
False
((0))
MileageAmountmoney8
False
((0))
EarnedAmountmoney8
False
((0))
TravelEarnedAmountmoney8
False
((0))
MileageEarnedAmountmoney8
False
((0))
LaborGroupIDint4
True
Respondedbit1
False
((0))
Foreign Keys FK_SCReportLabors_TaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].TaxFlagIDTaxFlagIDint4
False
((3))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCReportLabors: ReportID\DetailIDPK_SCReportLaborsReportID, DetailID
True
80
NameColumns
FK_SCReportLabors_ActivityCodeID_PRActivityCodesActivityCodeID->[dbo].[PRActivityCodes].[ActivityCodeID]
FK_SCReportLabors_CostAppliedDeptID_GLDepts5CostAppliedDeptID->[dbo].[GLDepts5].[DeptID]
FK_SCReportLabors_CostAppliedGLID_GLAccounts5CostAppliedGLID->[dbo].[GLAccounts5].[AccountID]
FK_SCReportLabors_CostDeptID_GLDepts5CostDeptID->[dbo].[GLDepts5].[DeptID]
FK_SCReportLabors_CostGLID_GLAccounts5CostGLID->[dbo].[GLAccounts5].[AccountID]
FK_SCReportLabors_DeptID_GLDepts5DeptID->[dbo].[GLDepts5].[DeptID]
FK_SCReportLabors_GLID_GLAccounts5GLID->[dbo].[GLAccounts5].[AccountID]
FK_SCReportLabors_ReportID_SCReportsReportID->[dbo].[SCReports].[ReportID]
FK_SCReportLabors_TaxFlagID_ShTaxFlagsTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
FK_SCReportLabors_TechnicianID_SCTechniciansTechnicianID->[dbo].[SCTechnicians].[TechnicianID]
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