Tables [dbo].[SCContractAdjustmentCodes]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:59:10 AM Thursday, March 21, 2019
Last Modified1:15:22 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK__SCContra__D72C72DDEBCB9AD5: ContractAdjCodeIDContractAdjCodeIDint4
False
1 - 1
Indexes IX_SCContractAdjustmentCodes_ContractAdjCodeContractAdjCodevarchar(15)15
False
Descriptionvarchar(50)50
False
Foreign Keys FK_SCContractAdjustmentCodes_BaseGLID_GLAccounts: [dbo].[GLAccounts].BaseGLIDBaseGLIDint4
False
Foreign Keys FK_SCContractAdjustmentCodes_BaseDeptID_GLDepts: [dbo].[GLDepts].BaseDeptIDBaseDeptIDint4
True
Foreign Keys FK_SCContractAdjustmentCodes_OverageGLID_GLAccounts: [dbo].[GLAccounts].OverageGLIDOverageGLIDint4
False
Foreign Keys FK_SCContractAdjustmentCodes_OverageDeptID_GLDepts: [dbo].[GLDepts].OverageDeptIDOverageDeptIDint4
True
BaseRatemoney8
False
BasePercentdecimal(18,4)9
False
BaseMinimumFeemoney8
False
BaseMaximumFeemoney8
False
BaseTaxFlagint4
False
OverageRatemoney8
False
OveragePercentdecimal(18,4)9
False
OverageMinimumFeemoney8
False
OverageMaximumFeemoney8
False
OverageTaxFlagint4
False
Activebit1
False
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
Foreign Keys FK_SCContractAdjustmentCodes_BaseTaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].BaseTaxFlagIDBaseTaxFlagIDint4
False
Foreign Keys FK_SCContractAdjustmentCodes_OverageTaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].OverageTaxFlagIDOverageTaxFlagIDint4
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK__SCContra__D72C72DDEBCB9AD5: ContractAdjCodeIDPK__SCContra__D72C72DDEBCB9AD5ContractAdjCodeID
True
80
IX_SCContractAdjustmentCodes_ContractAdjCodeContractAdjCode
True
80
NameColumns
FK_SCContractAdjustmentCodes_BaseDeptID_GLDeptsBaseDeptID->[dbo].[GLDepts].[DeptID]
FK_SCContractAdjustmentCodes_BaseGLID_GLAccountsBaseGLID->[dbo].[GLAccounts].[AccountID]
FK_SCContractAdjustmentCodes_BaseTaxFlagID_ShTaxFlagsBaseTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
FK_SCContractAdjustmentCodes_OverageDeptID_GLDeptsOverageDeptID->[dbo].[GLDepts].[DeptID]
FK_SCContractAdjustmentCodes_OverageGLID_GLAccountsOverageGLID->[dbo].[GLAccounts].[AccountID]
FK_SCContractAdjustmentCodes_OverageTaxFlagID_ShTaxFlagsOverageTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
CREATE TABLE [dbo].[SCContractAdjustmentCodes]
(
[ContractAdjCodeID] [int] NOT NULL IDENTITY(1, 1),
[ContractAdjCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[BaseGLID] [int] NOT NULL,
[BaseDeptID] [int] NULL,
[OverageGLID] [int] NOT NULL,
[OverageDeptID] [int] NULL,
[BaseRate] [money] NOT NULL,
[BasePercent] [decimal] (18, 4) NOT NULL,
[BaseMinimumFee] [money] NOT NULL,
[BaseMaximumFee] [money] NOT NULL,
[BaseTaxFlag] [int] NOT NULL,
[OverageRate] [money] NOT NULL,
[OveragePercent] [decimal] (18, 4) NOT NULL,
[OverageMinimumFee] [money] NOT NULL,
[OverageMaximumFee] [money] NOT NULL,
[OverageTaxFlag] [int] NOT NULL,
[Active] [bit] NOT 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_SCContractAdjustmentCodes_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCContractAdjustmentCodes_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[BaseTaxFlagID] [int] NOT NULL,
[OverageTaxFlagID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCContractAdjustmentCodes] ADD CONSTRAINT [PK__SCContra__D72C72DDEBCB9AD5] PRIMARY KEY CLUSTERED  ([ContractAdjCodeID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCContractAdjustmentCodes] ADD CONSTRAINT [IX_SCContractAdjustmentCodes_ContractAdjCode] UNIQUE NONCLUSTERED  ([ContractAdjCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCContractAdjustmentCodes] ADD CONSTRAINT [FK_SCContractAdjustmentCodes_BaseDeptID_GLDepts] FOREIGN KEY ([BaseDeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[SCContractAdjustmentCodes] ADD CONSTRAINT [FK_SCContractAdjustmentCodes_BaseGLID_GLAccounts] FOREIGN KEY ([BaseGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[SCContractAdjustmentCodes] ADD CONSTRAINT [FK_SCContractAdjustmentCodes_BaseTaxFlagID_ShTaxFlags] FOREIGN KEY ([BaseTaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SCContractAdjustmentCodes] ADD CONSTRAINT [FK_SCContractAdjustmentCodes_OverageDeptID_GLDepts] FOREIGN KEY ([OverageDeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[SCContractAdjustmentCodes] ADD CONSTRAINT [FK_SCContractAdjustmentCodes_OverageGLID_GLAccounts] FOREIGN KEY ([OverageGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[SCContractAdjustmentCodes] ADD CONSTRAINT [FK_SCContractAdjustmentCodes_OverageTaxFlagID_ShTaxFlags] FOREIGN KEY ([OverageTaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO