Tables [dbo].[SCBillingAccountCodeLabors]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:59:06 AM Thursday, March 21, 2019
Last Modified1:14:28 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_SCBillingAccountCodeLabors: BillingAccountCodeID\ActivityCodeIDForeign Keys FK_SCBillingAccountCodeLabors_BillingAccountCodeID_SCBillingAccountCodes: [dbo].[SCBillingAccountCodes].BillingAccountCodeIDBillingAccountCodeIDint4
False
Cluster Primary Key PK_SCBillingAccountCodeLabors: BillingAccountCodeID\ActivityCodeIDForeign Keys FK_SCBillingAccountCodeLabors_ActivityCodeID_PRActivityCodes: [dbo].[PRActivityCodes].ActivityCodeIDActivityCodeIDint4
False
Foreign Keys FK_SCBillingAccountCodeLabors_LaborGLID_GLAccounts: [dbo].[GLAccounts].LaborGLIDLaborGLIDint4
False
Foreign Keys FK_SCBillingAccountCodeLabors_LaborDeptID_GLDepts: [dbo].[GLDepts].LaborDeptIDLaborDeptIDint4
True
Foreign Keys FK_SCBillingAccountCodeLabors_LaborCostGLID_GLAccounts: [dbo].[GLAccounts].LaborCostGLIDLaborCostGLIDint4
False
Foreign Keys FK_SCBillingAccountCodeLabors_LaborCostDeptID_GLDepts: [dbo].[GLDepts].LaborCostDeptIDLaborCostDeptIDint4
True
Foreign Keys FK_SCBillingAccountCodeLabors_LaborCostAppliedGLID_GLAccounts: [dbo].[GLAccounts].LaborCostAppliedGLIDLaborCostAppliedGLIDint4
False
Foreign Keys FK_SCBillingAccountCodeLabors_LaborCostAppliedDeptID_GLDepts: [dbo].[GLDepts].LaborCostAppliedDeptIDLaborCostAppliedDeptIDint4
True
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCBillingAccountCodeLabors: BillingAccountCodeID\ActivityCodeIDPK_SCBillingAccountCodeLaborsBillingAccountCodeID, ActivityCodeID
True
80
NameColumns
FK_SCBillingAccountCodeLabors_ActivityCodeID_PRActivityCodesActivityCodeID->[dbo].[PRActivityCodes].[ActivityCodeID]
FK_SCBillingAccountCodeLabors_BillingAccountCodeID_SCBillingAccountCodesBillingAccountCodeID->[dbo].[SCBillingAccountCodes].[BillingAccountCodeID]
FK_SCBillingAccountCodeLabors_LaborCostAppliedDeptID_GLDeptsLaborCostAppliedDeptID->[dbo].[GLDepts].[DeptID]
FK_SCBillingAccountCodeLabors_LaborCostAppliedGLID_GLAccountsLaborCostAppliedGLID->[dbo].[GLAccounts].[AccountID]
FK_SCBillingAccountCodeLabors_LaborCostDeptID_GLDeptsLaborCostDeptID->[dbo].[GLDepts].[DeptID]
FK_SCBillingAccountCodeLabors_LaborCostGLID_GLAccountsLaborCostGLID->[dbo].[GLAccounts].[AccountID]
FK_SCBillingAccountCodeLabors_LaborDeptID_GLDeptsLaborDeptID->[dbo].[GLDepts].[DeptID]
FK_SCBillingAccountCodeLabors_LaborGLID_GLAccountsLaborGLID->[dbo].[GLAccounts].[AccountID]
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