 -------------------------------Ali 2020-12-15-------------
 
 ALTER TABLE dbo.WF_LoanRequest ADD
	Period int NULL,
	PYear int NULL
GO

 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId])
VALUES(N'WFDisplayMonthToStartLoanDeduct',N'Display  Month To Start Loan Deduct',N'اظهار شهر بداية خصم السلفة',N'false',2,8,1,1,Null,Null,9)
Go
  -------------------------------End 2020-12-15-------------
  ----------------------------Sayed 2020-12-16--------------
  
CREATE TABLE [dbo].[ChartOfAccounts](
	[AccountCode] [nvarchar](15) NOT NULL,
	[Name] [nvarchar](150) NULL,
	[Arabic_Name] [nvarchar](150) NULL,
	[MyFather] [nvarchar](14) NULL,
	[Account_Type] [tinyint] NULL,
	[Follow_List] [tinyint] NULL,
	[SecurityLevel] [tinyint] NULL,
	[CostCenterType] [int] NULL,
	[Level] [tinyint] NULL,
	[CostCenterCode] [nvarchar](9) NULL,
	[BudgetCode] [smallint] NULL,
	[Posted] [smallint] NULL,
	[ClosingAccount] [nvarchar](15) NULL,
	[Asset] [bit] NULL,
	[Stock] [bit] NULL,
	[Payroll] [bit] NULL,
	[AoutoSerial] [int] NULL,
	[RecordAddBy] [nvarchar](20) NULL,
	[RecordAddDate] [datetime] NULL,
	[RecordLastChangeBy] [nvarchar](20) NULL,
	[RecordChangeDate] [datetime] NULL,
	[Closed] [bit] NULL,
	[F23] [nvarchar](255) NULL,
	[F24] [nvarchar](255) NULL,
	[F25] [nvarchar](255) NULL,
	[F26] [bit] NULL,
	[PosttoNextYear] [bit] NULL,
 CONSTRAINT [PK_ChartOfAccounts] PRIMARY KEY CLUSTERED 
(
	[AccountCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ChartOfCostCenters]    Script Date: 16/12/2020 10:04:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ChartOfCostCenters](
	[CostCenterCode] [nvarchar](9) NOT NULL,
	[Name] [nvarchar](30) NULL,
	[Arabic_Name] [nvarchar](30) NULL,
	[MyFather] [nvarchar](8) NULL,
	[ClosingAccount] [nvarchar](15) NULL,
	[CostCenterLevel] [smallint] NULL,
	[Stock] [bit] NULL,
	[Payroll] [bit] NULL,
	[Closed] [bit] NULL,
	[Posted] [int] NULL,
	[RecordAddBy] [nvarchar](20) NULL,
	[RecordAddDate] [datetime] NULL,
	[RecordLastChangeBy] [nvarchar](20) NULL,
	[RecordChangeDate] [datetime] NULL,
 CONSTRAINT [PK_ChartOfCostCenters] PRIMARY KEY CLUSTERED 
(
	[CostCenterCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ChartOfAccounts] ADD  CONSTRAINT [DF_ChartOfAccounts_Posted]  DEFAULT ((0)) FOR [Posted]
GO
ALTER TABLE [dbo].[ChartOfAccounts] ADD  CONSTRAINT [DF_ChartOfAccounts_Asset]  DEFAULT ((0)) FOR [Asset]
GO
ALTER TABLE [dbo].[ChartOfAccounts] ADD  CONSTRAINT [DF_ChartOfAccounts_Stock]  DEFAULT ((0)) FOR [Stock]
GO
ALTER TABLE [dbo].[ChartOfAccounts] ADD  CONSTRAINT [DF_ChartOfAccounts_Payroll]  DEFAULT ((0)) FOR [Payroll]
GO
ALTER TABLE [dbo].[ChartOfAccounts] ADD  CONSTRAINT [DF_ChartOfAccounts_Closed]  DEFAULT ((0)) FOR [Closed]
GO
ALTER TABLE [dbo].[ChartOfAccounts] ADD  CONSTRAINT [DF_ChartOfAccounts_F26]  DEFAULT ((0)) FOR [F26]
GO
ALTER TABLE [dbo].[ChartOfAccounts] ADD  CONSTRAINT [DF_ChartOfAccounts_PosttoNextYear]  DEFAULT ((0)) FOR [PosttoNextYear]
GO
ALTER TABLE [dbo].[ChartOfCostCenters] ADD  CONSTRAINT [DF_ChartOfCostCenters_Stock]  DEFAULT ((0)) FOR [Stock]
GO
ALTER TABLE [dbo].[ChartOfCostCenters] ADD  CONSTRAINT [DF_ChartOfCostCenters_Payroll]  DEFAULT ((0)) FOR [Payroll]
GO
ALTER TABLE [dbo].[ChartOfCostCenters] ADD  CONSTRAINT [DF_ChartOfCostCenters_Closed]  DEFAULT ((0)) FOR [Closed]
GO
---------------------------End 2020-12-16-----------------------------------------










