Tables [dbo].[GLBudgetDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:56:13 AM Thursday, March 21, 2019
Last Modified1:11:03 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Foreign Keys FK_GLBudgetDetails_BudgetID_GLBudgets: [dbo].[GLBudgets].BudgetIDBudgetIDint4
False
Foreign Keys FK_GLBudgetDetails_GLID_GLAccounts5: [dbo].[GLAccounts5].GLIDGLIDint4
False
Periodint4
False
Foreign Keys FK_GLBudgetDetails_DeptID_GLDepts5: [dbo].[GLDepts5].DeptIDDeptIDint4
True
Amountmoney8
False
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
Primary Key PK_GLBudgetDetails: BudgetDetailIDBudgetDetailIDint4
False
1 - 1
Foreign Keys FK_GLBudgetDetails_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
True
DivisionIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Primary Key PK_GLBudgetDetails: BudgetDetailIDPK_GLBudgetDetailsBudgetDetailID
True
80
NameColumns
FK_GLBudgetDetails_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_GLBudgetDetails_BudgetID_GLBudgetsBudgetID->[dbo].[GLBudgets].[BudgetID]
FK_GLBudgetDetails_DeptID_GLDepts5DeptID->[dbo].[GLDepts5].[DeptID]
FK_GLBudgetDetails_GLID_GLAccounts5GLID->[dbo].[GLAccounts5].[AccountID]
CREATE TABLE [dbo].[GLBudgetDetails]
(
[BudgetID] [int] NOT NULL,
[GLID] [int] NOT NULL,
[Period] [int] NOT NULL,
[DeptID] [int] NULL,
[Amount] [money] 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_GLBudgetDetails_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_GLBudgetDetails_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[BudgetDetailID] [int] NOT NULL IDENTITY(1, 1),
[BranchID] [int] NULL,
[DivisionID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GLBudgetDetails] ADD CONSTRAINT [PK_GLBudgetDetails] PRIMARY KEY NONCLUSTERED  ([BudgetDetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GLBudgetDetails] ADD CONSTRAINT [FK_GLBudgetDetails_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[GLBudgetDetails] ADD CONSTRAINT [FK_GLBudgetDetails_BudgetID_GLBudgets] FOREIGN KEY ([BudgetID]) REFERENCES [dbo].[GLBudgets] ([BudgetID])
GO
ALTER TABLE [dbo].[GLBudgetDetails] ADD CONSTRAINT [FK_GLBudgetDetails_DeptID_GLDepts5] FOREIGN KEY ([DeptID]) REFERENCES [dbo].[GLDepts5] ([DeptID])
GO
ALTER TABLE [dbo].[GLBudgetDetails] ADD CONSTRAINT [FK_GLBudgetDetails_GLID_GLAccounts5] FOREIGN KEY ([GLID]) REFERENCES [dbo].[GLAccounts5] ([AccountID])
GO
  • [dbo].[v_GLBudgetDetailPivot]