CREATE TABLE [dbo].[ARFinCharges]
(
[FinChargeID] [int] NOT NULL,
[Date] [datetime] NOT NULL,
[DatePeriod] [int] NOT NULL,
[Period] [int] NOT NULL,
[Batch] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[GLID] [int] NOT NULL,
[CreditGLID] [int] NOT NULL,
[MinCharge] [money] NOT NULL,
[MaxCharge] [money] NOT NULL,
[AnnualRate] [float] NOT NULL,
[PeriodicRate] [float] NOT NULL,
[BeginDate] [datetime] NOT NULL,
[CutoffDate] [datetime] 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_ARFinCharges_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ARFinCharges_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL,
[CreditDeptID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARFinCharges] ADD CONSTRAINT [PK_ARFinCharges] PRIMARY KEY CLUSTERED ([FinChargeID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARFinCharges] ADD CONSTRAINT [FK_ARFinCharges_CreditDeptID_GLDepts] FOREIGN KEY ([CreditDeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[ARFinCharges] ADD CONSTRAINT [FK_ARFinCharges_CreditGLID_GLAccounts1] FOREIGN KEY ([CreditGLID]) REFERENCES [dbo].[GLAccounts1] ([AccountID])
GO
ALTER TABLE [dbo].[ARFinCharges] ADD CONSTRAINT [FK_ARFinCharges_GLID_GLAccounts1] FOREIGN KEY ([GLID]) REFERENCES [dbo].[GLAccounts1] ([AccountID])
GO