CREATE TABLE [dbo].[SCBillingLaborCodes]
(
[BillingLaborCodeID] [int] NOT NULL IDENTITY(1, 1),
[BillingLaborCode] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (75) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LaborRate] [money] NOT NULL,
[OvertimeRate] [money] NOT NULL,
[MinimumPeriod] [decimal] (18, 6) NOT NULL,
[CombineHoursForBilling] [bit] NOT NULL CONSTRAINT [DF_SCBillingLaborCodes_CombineHoursForBilling] DEFAULT ((0)),
[IncrementalBillingOption] [int] NOT NULL CONSTRAINT [DF_SCBillingLaborCodes_IncrementalBillingOption] DEFAULT ((0)),
[LaborIncrementPeriod] [decimal] (18, 6) NULL,
[LaborRoundingOption] [int] NULL,
[OvertimeIncrementPeriod] [decimal] (18, 6) NULL,
[OvertimeRoundingOption] [int] NULL,
[CombineIncrementalHours] [bit] NOT NULL CONSTRAINT [DF_SCBillingLaborCodes_CombineIncrementalHours] DEFAULT ((0)),
[BillingLaborCodeMajor] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[BillingLaborCodeMinor] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CurrentRev] [bit] NOT NULL CONSTRAINT [DF_SCBillingLaborCodes_CurrentRev] DEFAULT ((0)),
[Active] [bit] NOT NULL CONSTRAINT [DF_SCBillingLaborCodes_Active] DEFAULT ((1)),
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LastUpdate] [datetime] NOT NULL,
[TimeStamp] [timestamp] NULL,
[AggregateLabor] [bit] NOT NULL CONSTRAINT [DF_SCBillingLaborCodes_AggregateLabor] DEFAULT ((0)),
[GroupLaborBy] [int] NOT NULL CONSTRAINT [DF_SCBillingLaborCodes_GroupLaborBy] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCBillingLaborCodes] ADD CONSTRAINT [PK_SCBillingLaborCodes] PRIMARY KEY CLUSTERED ([BillingLaborCodeID]) ON [PRIMARY]
GO