CREATE TABLE [dbo].[SCBillingAccountCodeLabors]
(
[BillingAccountCodeID] [int] NOT NULL,
[ActivityCodeID] [int] NOT NULL,
[LaborGLID] [int] NOT NULL,
[LaborDeptID] [int] NULL,
[LaborCostGLID] [int] NOT NULL,
[LaborCostDeptID] [int] NULL,
[LaborCostAppliedGLID] [int] NOT NULL,
[LaborCostAppliedDeptID] [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_SCBillingAccountCodeLabors_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCBillingAccountCodeLabors_LastUpdate] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCBillingAccountCodeLabors] ADD CONSTRAINT [PK_SCBillingAccountCodeLabors] PRIMARY KEY CLUSTERED ([BillingAccountCodeID], [ActivityCodeID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCBillingAccountCodeLabors] ADD CONSTRAINT [FK_SCBillingAccountCodeLabors_ActivityCodeID_PRActivityCodes] FOREIGN KEY ([ActivityCodeID]) REFERENCES [dbo].[PRActivityCodes] ([ActivityCodeID])
GO
ALTER TABLE [dbo].[SCBillingAccountCodeLabors] ADD CONSTRAINT [FK_SCBillingAccountCodeLabors_BillingAccountCodeID_SCBillingAccountCodes] FOREIGN KEY ([BillingAccountCodeID]) REFERENCES [dbo].[SCBillingAccountCodes] ([BillingAccountCodeID])
GO
ALTER TABLE [dbo].[SCBillingAccountCodeLabors] ADD CONSTRAINT [FK_SCBillingAccountCodeLabors_LaborCostAppliedDeptID_GLDepts] FOREIGN KEY ([LaborCostAppliedDeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[SCBillingAccountCodeLabors] ADD CONSTRAINT [FK_SCBillingAccountCodeLabors_LaborCostAppliedGLID_GLAccounts] FOREIGN KEY ([LaborCostAppliedGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[SCBillingAccountCodeLabors] ADD CONSTRAINT [FK_SCBillingAccountCodeLabors_LaborCostDeptID_GLDepts] FOREIGN KEY ([LaborCostDeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[SCBillingAccountCodeLabors] ADD CONSTRAINT [FK_SCBillingAccountCodeLabors_LaborCostGLID_GLAccounts] FOREIGN KEY ([LaborCostGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[SCBillingAccountCodeLabors] ADD CONSTRAINT [FK_SCBillingAccountCodeLabors_LaborDeptID_GLDepts] FOREIGN KEY ([LaborDeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[SCBillingAccountCodeLabors] ADD CONSTRAINT [FK_SCBillingAccountCodeLabors_LaborGLID_GLAccounts] FOREIGN KEY ([LaborGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO