Tables [dbo].[SCBillingAccountCodeIncludes]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:59:06 AM Thursday, March 21, 2019
Last Modified1:14:27 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_SCBillingAccountCodeIncludes: BillingAccountCodeID\ServiceCodeIDForeign Keys FK_SCBillingAccountCodeIncludes_BillingAccountCodeID_SCBillingAccountCodes: [dbo].[SCBillingAccountCodes].BillingAccountCodeIDBillingAccountCodeIDint4
False
Cluster Primary Key PK_SCBillingAccountCodeIncludes: BillingAccountCodeID\ServiceCodeIDForeign Keys FK_SCBillingAccountCodeIncludes_ServiceCodeID_ICServiceCodes: [dbo].[ICServiceCodes].ServiceCodeIDServiceCodeIDint4
False
Foreign Keys FK_SCBillingAccountCodeIncludes_COGSGLID_GLAccounts: [dbo].[GLAccounts].COGSGLIDCOGSGLIDint4
True
Foreign Keys FK_SCBillingAccountCodeIncludes_DeptID_GLDepts: [dbo].[GLDepts].DeptIDDeptIDint4
True
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCBillingAccountCodeIncludes: BillingAccountCodeID\ServiceCodeIDPK_SCBillingAccountCodeIncludesBillingAccountCodeID, ServiceCodeID
True
80
NameColumns
FK_SCBillingAccountCodeIncludes_BillingAccountCodeID_SCBillingAccountCodesBillingAccountCodeID->[dbo].[SCBillingAccountCodes].[BillingAccountCodeID]
FK_SCBillingAccountCodeIncludes_COGSGLID_GLAccountsCOGSGLID->[dbo].[GLAccounts].[AccountID]
FK_SCBillingAccountCodeIncludes_DeptID_GLDeptsDeptID->[dbo].[GLDepts].[DeptID]
FK_SCBillingAccountCodeIncludes_ServiceCodeID_ICServiceCodesServiceCodeID->[dbo].[ICServiceCodes].[ServiceCodeID]
CREATE TABLE [dbo].[SCBillingAccountCodeIncludes]
(
[BillingAccountCodeID] [int] NOT NULL,
[ServiceCodeID] [int] NOT NULL,
[COGSGLID] [int] NULL,
[DeptID] [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_SCBillingAccountCodeIncludes_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCBillingAccountCodeIncludes_LastUpdate] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCBillingAccountCodeIncludes] ADD CONSTRAINT [PK_SCBillingAccountCodeIncludes] PRIMARY KEY CLUSTERED  ([BillingAccountCodeID], [ServiceCodeID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCBillingAccountCodeIncludes] ADD CONSTRAINT [FK_SCBillingAccountCodeIncludes_BillingAccountCodeID_SCBillingAccountCodes] FOREIGN KEY ([BillingAccountCodeID]) REFERENCES [dbo].[SCBillingAccountCodes] ([BillingAccountCodeID])
GO
ALTER TABLE [dbo].[SCBillingAccountCodeIncludes] ADD CONSTRAINT [FK_SCBillingAccountCodeIncludes_COGSGLID_GLAccounts] FOREIGN KEY ([COGSGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[SCBillingAccountCodeIncludes] ADD CONSTRAINT [FK_SCBillingAccountCodeIncludes_DeptID_GLDepts] FOREIGN KEY ([DeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[SCBillingAccountCodeIncludes] ADD CONSTRAINT [FK_SCBillingAccountCodeIncludes_ServiceCodeID_ICServiceCodes] FOREIGN KEY ([ServiceCodeID]) REFERENCES [dbo].[ICServiceCodes] ([ServiceCodeID])
GO