Tables [dbo].[ARFinCharges]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:56:44 AM Thursday, March 21, 2019
Last Modified1:10:09 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_ARFinCharges: FinChargeIDFinChargeIDint4
False
Datedatetime8
False
DatePeriodint4
False
Periodint4
False
Batchvarchar(15)15
False
Foreign Keys FK_ARFinCharges_GLID_GLAccounts1: [dbo].[GLAccounts1].GLIDGLIDint4
False
Foreign Keys FK_ARFinCharges_CreditGLID_GLAccounts1: [dbo].[GLAccounts1].CreditGLIDCreditGLIDint4
False
MinChargemoney8
False
MaxChargemoney8
False
AnnualRatefloat8
False
PeriodicRatefloat8
False
BeginDatedatetime8
False
CutoffDatedatetime8
False
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
False
Foreign Keys FK_ARFinCharges_CreditDeptID_GLDepts: [dbo].[GLDepts].CreditDeptIDCreditDeptIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_ARFinCharges: FinChargeIDPK_ARFinChargesFinChargeID
True
80
NameColumns
FK_ARFinCharges_CreditDeptID_GLDeptsCreditDeptID->[dbo].[GLDepts].[DeptID]
FK_ARFinCharges_CreditGLID_GLAccounts1CreditGLID->[dbo].[GLAccounts1].[AccountID]
FK_ARFinCharges_GLID_GLAccounts1GLID->[dbo].[GLAccounts1].[AccountID]
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