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