CREATE TABLE [dbo].[Accounts_New] ( [AccountsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Code] nvarchar(500) NULL, [Account] nvarchar(2000) NULL, [Opening] decimal(18, 4) NULL, [DbCr] varchar(255) NULL, [Type] nvarchar(500) NULL, [AcGroup] nvarchar(500) NULL, [AcHeadCode] int NULL, [AcHead] nvarchar(500) NULL, [BalPL] varchar(255) NULL, [AccountAR] nvarchar(500) NULL, [ID] int NULL, [flag] varchar(5) NULL, [namear] nvarchar(2000) NULL, [typear] nvarchar(500) NULL, [acgroupar] nvarchar(500) NULL ); INSERT INTO dbo.[Accounts_New] ([Code], [Account], [Opening], [DbCr], [Type], [AcGroup], [AcHeadCode], [AcHead], [BalPL], [AccountAR], [ID], [flag], [namear], [typear], [acgroupar]) SELECT [Code], [Account], [Opening], [DbCr], [Type], [AcGroup], [AcHeadCode], [AcHead], [BalPL], [AccountAR], [ID], [flag], [namear], [typear], [acgroupar] FROM [Accounts]; DROP TABLE dbo.[Accounts]; EXEC sp_rename 'dbo.Accounts_New', 'Accounts'; GO CREATE TABLE [dbo].[AdditionalColumnDetails_New] ( [AdditionalColumnDetailsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [InvAddcolName] nvarchar(2000) NULL, [InvAddcolStatus] nvarchar(10) NULL, [InvAddDatecolName] nvarchar(2000) NULL, [InvAddDatecolStatus] nvarchar(10) NULL, [ProInvAddcolName] nvarchar(2000) NULL, [ProInvAddcolStatus] nvarchar(10) NULL, [ProInvAddDatecolName] nvarchar(2000) NULL, [ProInvAddDatecolStatus] nvarchar(10) NULL, [InvRetAddcolName] nvarchar(2000) NULL, [InvRetAddcolStatus] nvarchar(10) NULL, [InvRetAddDatecolName] nvarchar(2000) NULL, [InvRetAddDatecolStatus] nvarchar(10) NULL, [InvDebitAddcolName] nvarchar(2000) NULL, [InvDebitAddcolStatus] nvarchar(10) NULL, [InvDebitAddDatecolName] nvarchar(2000) NULL, [InvDebitAddDatecolStatus] nvarchar(10) NULL, [QuotAddcolName] nvarchar(2000) NULL, [QuotAddcolStatus] nvarchar(10) NULL, [QuotAddDatecolName] nvarchar(2000) NULL, [QuotAddDatecolStatus] nvarchar(10) NULL, [DelAddcolName] nvarchar(2000) NULL, [DelAddcolStatus] nvarchar(10) NULL, [DelAddDatecolName] nvarchar(2000) NULL, [DelAddDatecolStatus] nvarchar(10) NULL ); INSERT INTO dbo.[AdditionalColumnDetails_New] ([InvAddcolName], [InvAddcolStatus], [InvAddDatecolName], [InvAddDatecolStatus], [ProInvAddcolName], [ProInvAddcolStatus], [ProInvAddDatecolName], [ProInvAddDatecolStatus], [InvRetAddcolName], [InvRetAddcolStatus], [InvRetAddDatecolName], [InvRetAddDatecolStatus], [InvDebitAddcolName], [InvDebitAddcolStatus], [InvDebitAddDatecolName], [InvDebitAddDatecolStatus], [QuotAddcolName], [QuotAddcolStatus], [QuotAddDatecolName], [QuotAddDatecolStatus], [DelAddcolName], [DelAddcolStatus], [DelAddDatecolName], [DelAddDatecolStatus]) SELECT [InvAddcolName], [InvAddcolStatus], [InvAddDatecolName], [InvAddDatecolStatus], [ProInvAddcolName], [ProInvAddcolStatus], [ProInvAddDatecolName], [ProInvAddDatecolStatus], [InvRetAddcolName], [InvRetAddcolStatus], [InvRetAddDatecolName], [InvRetAddDatecolStatus], [InvDebitAddcolName], [InvDebitAddcolStatus], [InvDebitAddDatecolName], [InvDebitAddDatecolStatus], [QuotAddcolName], [QuotAddcolStatus], [QuotAddDatecolName], [QuotAddDatecolStatus], [DelAddcolName], [DelAddcolStatus], [DelAddDatecolName], [DelAddDatecolStatus] FROM [AdditionalColumnDetails]; DROP TABLE dbo.[AdditionalColumnDetails]; EXEC sp_rename 'dbo.AdditionalColumnDetails_New', 'AdditionalColumnDetails'; GO CREATE TABLE [dbo].[AdditionalGridColumnDetails_New] ( [AdditionalGridColumnDetailsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [InvAddGridcolName] nvarchar(2000) NULL, [InvAddGridcolStatus] nvarchar(10) NULL, [InvAddGridDatecolName] nvarchar(2000) NULL, [InvAddGridDatecolStatus] nvarchar(10) NULL, [ProInvAddGridcolName] nvarchar(2000) NULL, [ProInvAddGridcolStatus] nvarchar(10) NULL, [ProInvAddGridDatecolName] nvarchar(2000) NULL, [ProInvAddGridDatecolStatus] nvarchar(10) NULL, [InvRetAddGridcolName] nvarchar(2000) NULL, [InvRetAddGridcolStatus] nvarchar(10) NULL, [InvRetAddGridDatecolName] nvarchar(2000) NULL, [InvRetAddGridDatecolStatus] nvarchar(10) NULL, [InvDebitAddGridcolName] nvarchar(2000) NULL, [InvDebitAddGridcolStatus] nvarchar(10) NULL, [InvDebitAddGridDatecolName] nvarchar(2000) NULL, [InvDebitAddGridDatecolStatus] nvarchar(10) NULL, [QuotAddGridcolName] nvarchar(2000) NULL, [QuotAddGridcolStatus] nvarchar(10) NULL, [QuotAddGridDatecolName] nvarchar(2000) NULL, [QuotAddGridDatecolStatus] nvarchar(10) NULL, [DelAddGridcolName] nvarchar(2000) NULL, [DelAddGridcolStatus] nvarchar(10) NULL, [DelAddGridDatecolName] nvarchar(2000) NULL, [DelAddGridDatecolStatus] nvarchar(10) NULL ); INSERT INTO dbo.[AdditionalGridColumnDetails_New] ([InvAddGridcolName], [InvAddGridcolStatus], [InvAddGridDatecolName], [InvAddGridDatecolStatus], [ProInvAddGridcolName], [ProInvAddGridcolStatus], [ProInvAddGridDatecolName], [ProInvAddGridDatecolStatus], [InvRetAddGridcolName], [InvRetAddGridcolStatus], [InvRetAddGridDatecolName], [InvRetAddGridDatecolStatus], [InvDebitAddGridcolName], [InvDebitAddGridcolStatus], [InvDebitAddGridDatecolName], [InvDebitAddGridDatecolStatus], [QuotAddGridcolName], [QuotAddGridcolStatus], [QuotAddGridDatecolName], [QuotAddGridDatecolStatus], [DelAddGridcolName], [DelAddGridcolStatus], [DelAddGridDatecolName], [DelAddGridDatecolStatus]) SELECT [InvAddGridcolName], [InvAddGridcolStatus], [InvAddGridDatecolName], [InvAddGridDatecolStatus], [ProInvAddGridcolName], [ProInvAddGridcolStatus], [ProInvAddGridDatecolName], [ProInvAddGridDatecolStatus], [InvRetAddGridcolName], [InvRetAddGridcolStatus], [InvRetAddGridDatecolName], [InvRetAddGridDatecolStatus], [InvDebitAddGridcolName], [InvDebitAddGridcolStatus], [InvDebitAddGridDatecolName], [InvDebitAddGridDatecolStatus], [QuotAddGridcolName], [QuotAddGridcolStatus], [QuotAddGridDatecolName], [QuotAddGridDatecolStatus], [DelAddGridcolName], [DelAddGridcolStatus], [DelAddGridDatecolName], [DelAddGridDatecolStatus] FROM [AdditionalGridColumnDetails]; DROP TABLE dbo.[AdditionalGridColumnDetails]; EXEC sp_rename 'dbo.AdditionalGridColumnDetails_New', 'AdditionalGridColumnDetails'; GO CREATE TABLE [dbo].[BankBookReport_New] ( [BankBookReportId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [AcCode] nvarchar(500) NULL, [Amt] decimal(18, 4) NULL ); INSERT INTO dbo.[BankBookReport_New] ([AcCode], [Amt]) SELECT [AcCode], [Amt] FROM [BankBookReport]; DROP TABLE dbo.[BankBookReport]; EXEC sp_rename 'dbo.BankBookReport_New', 'BankBookReport'; GO CREATE TABLE [dbo].[BankDeposit_New] ( [BankDepositId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Branch] nvarchar(500) NULL, [DocNo] nvarchar(500) NULL, [EntryDate] datetime NULL, [KeyFld] nvarchar(10) NULL, [Narration] nvarchar(500) NULL, [Amount] decimal(18, 4) NULL, [AccountCode] nvarchar(500) NULL, [BankCode] nvarchar(500) NULL, [Account] nvarchar(2000) NULL, [Bank] nvarchar(500) NULL, [podate] datetime NULL, [Notes] nvarchar(500) NULL, [PurchaseDocNo] nvarchar(500) NULL ); INSERT INTO dbo.[BankDeposit_New] ([Branch], [DocNo], [EntryDate], [KeyFld], [Narration], [Amount], [AccountCode], [BankCode], [Account], [Bank], [podate], [Notes], [PurchaseDocNo]) SELECT [Branch], [DocNo], [EntryDate], [KeyFld], [Narration], [Amount], [AccountCode], [BankCode], [Account], [Bank], [podate], [Notes], [PurchaseDocNo] FROM [BankDeposit]; DROP TABLE dbo.[BankDeposit]; EXEC sp_rename 'dbo.BankDeposit_New', 'BankDeposit'; GO CREATE TABLE [dbo].[barcodeset_New] ( [barcodesetId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [barcode] nvarchar(2000) NULL ); INSERT INTO dbo.[barcodeset_New] ([barcode]) SELECT [barcode] FROM [barcodeset]; DROP TABLE dbo.[barcodeset]; EXEC sp_rename 'dbo.barcodeset_New', 'barcodeset'; GO CREATE TABLE [dbo].[BkUp_New] ( [BkUpId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [BkName] nvarchar(500) NULL, [BkTime] datetime NULL, [BkDrive] nvarchar(500) NULL, [BkCnt] int NULL ); INSERT INTO dbo.[BkUp_New] ([BkName], [BkTime], [BkDrive], [BkCnt]) SELECT [BkName], [BkTime], [BkDrive], [BkCnt] FROM [BkUp]; DROP TABLE dbo.[BkUp]; EXEC sp_rename 'dbo.BkUp_New', 'BkUp'; GO CREATE TABLE [dbo].[CashBookReport_New] ( [CashBookReportId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [AcCode] nvarchar(500) NULL, [Amt] decimal(18, 4) NULL ); INSERT INTO dbo.[CashBookReport_New] ([AcCode], [Amt]) SELECT [AcCode], [Amt] FROM [CashBookReport]; DROP TABLE dbo.[CashBookReport]; EXEC sp_rename 'dbo.CashBookReport_New', 'CashBookReport'; GO CREATE TABLE [dbo].[CashEntry_New] ( [CashEntryId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [DocNo] nvarchar(500) NULL, [EntryDate] datetime NULL, [SalesMan] nvarchar(2000) NULL, [SalesMancode] nvarchar(500) NULL, [Account] nvarchar(2000) NULL, [TotalRec] decimal(18, 4) NULL, [TotalPaymnt] decimal(18, 4) NULL, [Type] nvarchar(500) NULL, [Deleted] varchar(5) NULL, [gross] decimal(18, 4) NULL, [vattotal] decimal(18, 4) NULL, [VATNO] nvarchar(500) NULL, [NARRATION] nvarchar(2000) NULL ); INSERT INTO dbo.[CashEntry_New] ([DocNo], [EntryDate], [SalesMan], [SalesMancode], [Account], [TotalRec], [TotalPaymnt], [Type], [Deleted], [gross], [vattotal], [VATNO], [NARRATION]) SELECT [DocNo], [EntryDate], [SalesMan], [SalesMancode], [Account], [TotalRec], [TotalPaymnt], [Type], [Deleted], [gross], [vattotal], [VATNO], [NARRATION] FROM [CashEntry]; DROP TABLE dbo.[CashEntry]; EXEC sp_rename 'dbo.CashEntry_New', 'CashEntry'; GO CREATE TABLE [dbo].[CashEntryDetails_New] ( [CashEntryDetailsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [DocNo] nvarchar(500) NULL, [EntryDate] datetime NULL, [ACCode] nvarchar(500) NULL, [ACName] nvarchar(2000) NULL, [Receipt] decimal(18, 4) NULL, [payments] decimal(18, 4) NULL, [InvoiceNo] nvarchar(500) NULL, [Narration] nvarchar(2000) NULL, [Slno] decimal(18, 4) NULL, [Type] nvarchar(500) NULL, [Deleted] varchar(5) NULL, [VATNO] nvarchar(500) NULL, [vatper] decimal(18, 4) NULL, [vatamt] decimal(18, 4) NULL, [NAME] nvarchar(2000) NULL ); INSERT INTO dbo.[CashEntryDetails_New] ([DocNo], [EntryDate], [ACCode], [ACName], [Receipt], [payments], [InvoiceNo], [Narration], [Slno], [Type], [Deleted], [VATNO], [vatper], [vatamt], [NAME]) SELECT [DocNo], [EntryDate], [ACCode], [ACName], [Receipt], [payments], [InvoiceNo], [Narration], [Slno], [Type], [Deleted], [VATNO], [vatper], [vatamt], [NAME] FROM [CashEntryDetails]; DROP TABLE dbo.[CashEntryDetails]; EXEC sp_rename 'dbo.CashEntryDetails_New', 'CashEntryDetails'; GO CREATE TABLE [dbo].[Category_New] ( [CategoryId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Code] nvarchar(500) NULL, [Name] nvarchar(2000) NULL, [Remarks] nvarchar(2000) NULL, [NameAR] nvarchar(2000) NULL, [RemarksAR] nvarchar(2000) NULL, [ITEMIMAGENAME] nvarchar(500) NULL, [ITEMIMAGE] image NULL ); INSERT INTO dbo.[Category_New] ([Code], [Name], [Remarks], [NameAR], [RemarksAR], [ITEMIMAGENAME], [ITEMIMAGE]) SELECT [Code], [Name], [Remarks], [NameAR], [RemarksAR], [ITEMIMAGENAME], [ITEMIMAGE] FROM [Category]; DROP TABLE dbo.[Category]; EXEC sp_rename 'dbo.Category_New', 'Category'; GO CREATE TABLE [dbo].[CbLedger no need_New] ( [CbLedger no needId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [VoucherNo] nvarchar(500) NULL, [Branch] nvarchar(2000) NULL, [RefNo] nvarchar(500) NULL, [KeyFld] varchar(50) NULL, [AcCode] nvarchar(500) NULL, [Amount] decimal(18, 4) NULL, [Narration] nvarchar(2000) NULL, [ChequeNo] nvarchar(500) NULL, [Cleared] nvarchar(500) NULL, [Type] nvarchar(500) NULL ); INSERT INTO dbo.[CbLedger no need_New] ([EntryDate], [VoucherNo], [Branch], [RefNo], [KeyFld], [AcCode], [Amount], [Narration], [ChequeNo], [Cleared], [Type]) SELECT [EntryDate], [VoucherNo], [Branch], [RefNo], [KeyFld], [AcCode], [Amount], [Narration], [ChequeNo], [Cleared], [Type] FROM [CbLedger no need]; DROP TABLE dbo.[CbLedger no need]; EXEC sp_rename 'dbo.CbLedger no need_New', 'CbLedger no need'; GO CREATE TABLE [dbo].[CbLedgerBKP_New] ( [CbLedgerBKPId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [VoucherNo] nvarchar(500) NULL, [Branch] nvarchar(2000) NULL, [RefNo] nvarchar(500) NULL, [KeyFld] nvarchar(2000) NULL, [AcCode] nvarchar(2000) NULL, [Amount] decimal(18, 4) NULL, [Narration] nvarchar(2000) NULL, [ChequeNo] nvarchar(500) NULL, [Cleared] nvarchar(500) NULL, [Type] nvarchar(500) NULL ); INSERT INTO dbo.[CbLedgerBKP_New] ([EntryDate], [VoucherNo], [Branch], [RefNo], [KeyFld], [AcCode], [Amount], [Narration], [ChequeNo], [Cleared], [Type]) SELECT [EntryDate], [VoucherNo], [Branch], [RefNo], [KeyFld], [AcCode], [Amount], [Narration], [ChequeNo], [Cleared], [Type] FROM [CbLedgerBKP]; DROP TABLE dbo.[CbLedgerBKP]; EXEC sp_rename 'dbo.CbLedgerBKP_New', 'CbLedgerBKP'; GO CREATE TABLE [dbo].[Company_New] ( [CompanyId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Code] nvarchar(500) NULL, [Name] nvarchar(2000) NULL, [Remarks] nvarchar(2000) NULL, [NameAR] nvarchar(500) NULL, [RemarksAR] nvarchar(2000) NULL ); INSERT INTO dbo.[Company_New] ([Code], [Name], [Remarks], [NameAR], [RemarksAR]) SELECT [Code], [Name], [Remarks], [NameAR], [RemarksAR] FROM [Company]; DROP TABLE dbo.[Company]; EXEC sp_rename 'dbo.Company_New', 'Company'; GO CREATE TABLE [dbo].[companydetails_New] ( [companydetailsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Code] varchar(50) NULL, [Name] nvarchar(2000) NULL, [Address1] nvarchar(2000) NULL, [Address2] nvarchar(2000) NULL, [Address3] nvarchar(2000) NULL, [Address4] nvarchar(2000) NULL, [CrLimit] decimal(18, 4) NULL, [Opening] decimal(18, 4) NULL, [DbCr] nvarchar(500) NULL, [NameAR] nvarchar(2000) NULL, [Address1AR] nvarchar(2000) NULL, [Address2AR] nvarchar(2000) NULL, [Address3AR] nvarchar(2000) NULL, [Address4AR] nvarchar(2000) NULL, [Contact] nvarchar(500) NULL, [Telephone] nvarchar(500) NULL, [Fax] nvarchar(500) NULL, [Email] nvarchar(2000) NULL, [Del1] nvarchar(500) NULL, [Del2] nvarchar(500) NULL, [Del3] nvarchar(500) NULL, [Del4] nvarchar(500) NULL, [Mobile] nvarchar(500) NULL, [Vatno] nvarchar(500) NULL, [fill] nvarchar(5) NULL, [crdays] decimal(18, 4) NULL, [custgroup] nvarchar(500) NULL, [ContactArabic] nvarchar(500) NULL, [phoneArabic] nvarchar(500) NULL, [FaxArabic] nvarchar(500) NULL, [emailArabic] nvarchar(500) NULL, [mobArabic] nvarchar(500) NULL, [vatnoArabic] nvarchar(500) NULL, [BuildingNo] nvarchar(500) NULL, [StreetName] nvarchar(500) NULL, [District] nvarchar(500) NULL, [City] nvarchar(500) NULL, [Country] nvarchar(500) NULL, [PostalCode] nvarchar(500) NULL, [AdditionalNo] nvarchar(500) NULL, [OtherSellerNo] nvarchar(500) NULL, [BuildingNoArabic] nvarchar(500) NULL, [StreetNameArabic] nvarchar(500) NULL, [DistrictArabic] nvarchar(500) NULL, [CityArabic] nvarchar(500) NULL, [CountryArabic] nvarchar(500) NULL, [PostalCodeArabic] nvarchar(500) NULL, [AdditionalNoArabic] nvarchar(500) NULL, [OtherSellerNoArabic] nvarchar(500) NULL, [logoimage] image NULL, [signatureimage] image NULL, [sealimage] image NULL, [footerimage] image NULL, [headderimage] image NULL, [PlotIdentificationAr] nvarchar(500) NULL, [CitySubdivisionNameAr] nvarchar(500) NULL, [CountrySubentityAr] nvarchar(500) NULL, [PlotIdentification] nvarchar(500) NULL, [CitySubdivisionName] nvarchar(500) NULL, [CountrySubentity] nvarchar(500) NULL, [CountryCode] nvarchar(200) NULL, [IdentificationNo] nvarchar(200) NULL, [Identification] nvarchar(200) NULL, [IdentificationNoAr] nvarchar(200) NULL, [GroupVat] nvarchar(500) NULL, [Neighbourhood] nvarchar(500) NULL, [NeighbourhoodAr] nvarchar(500) NULL ); INSERT INTO dbo.[companydetails_New] ([Code], [Name], [Address1], [Address2], [Address3], [Address4], [CrLimit], [Opening], [DbCr], [NameAR], [Address1AR], [Address2AR], [Address3AR], [Address4AR], [Contact], [Telephone], [Fax], [Email], [Del1], [Del2], [Del3], [Del4], [Mobile], [Vatno], [fill], [crdays], [custgroup], [ContactArabic], [phoneArabic], [FaxArabic], [emailArabic], [mobArabic], [vatnoArabic], [BuildingNo], [StreetName], [District], [City], [Country], [PostalCode], [AdditionalNo], [OtherSellerNo], [BuildingNoArabic], [StreetNameArabic], [DistrictArabic], [CityArabic], [CountryArabic], [PostalCodeArabic], [AdditionalNoArabic], [OtherSellerNoArabic], [logoimage], [signatureimage], [sealimage], [footerimage], [headderimage], [PlotIdentificationAr], [CitySubdivisionNameAr], [CountrySubentityAr], [PlotIdentification], [CitySubdivisionName], [CountrySubentity], [CountryCode], [IdentificationNo], [Identification], [IdentificationNoAr], [GroupVat], [Neighbourhood], [NeighbourhoodAr]) SELECT [Code], [Name], [Address1], [Address2], [Address3], [Address4], [CrLimit], [Opening], [DbCr], [NameAR], [Address1AR], [Address2AR], [Address3AR], [Address4AR], [Contact], [Telephone], [Fax], [Email], [Del1], [Del2], [Del3], [Del4], [Mobile], [Vatno], [fill], [crdays], [custgroup], [ContactArabic], [phoneArabic], [FaxArabic], [emailArabic], [mobArabic], [vatnoArabic], [BuildingNo], [StreetName], [District], [City], [Country], [PostalCode], [AdditionalNo], [OtherSellerNo], [BuildingNoArabic], [StreetNameArabic], [DistrictArabic], [CityArabic], [CountryArabic], [PostalCodeArabic], [AdditionalNoArabic], [OtherSellerNoArabic], [logoimage], [signatureimage], [sealimage], [footerimage], [headderimage], [PlotIdentificationAr], [CitySubdivisionNameAr], [CountrySubentityAr], [PlotIdentification], [CitySubdivisionName], [CountrySubentity], [CountryCode], [IdentificationNo], [Identification], [IdentificationNoAr], [GroupVat], [Neighbourhood], [NeighbourhoodAr] FROM [companydetails]; DROP TABLE dbo.[companydetails]; EXEC sp_rename 'dbo.companydetails_New', 'companydetails'; GO CREATE TABLE [dbo].[companydetailsbkp_New] ( [companydetailsbkpId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Code] varchar(50) NULL, [Name] nvarchar(2000) NULL, [Address1] nvarchar(2000) NULL, [Address2] nvarchar(2000) NULL, [Address3] nvarchar(2000) NULL, [Address4] nvarchar(2000) NULL, [CrLimit] decimal(18, 4) NULL, [Opening] decimal(18, 4) NULL, [DbCr] nvarchar(500) NULL, [NameAR] nvarchar(2000) NULL, [Address1AR] nvarchar(2000) NULL, [Address2AR] nvarchar(2000) NULL, [Address3AR] nvarchar(2000) NULL, [Address4AR] nvarchar(2000) NULL, [Contact] nvarchar(500) NULL, [Telephone] nvarchar(500) NULL, [Fax] nvarchar(500) NULL, [Email] nvarchar(2000) NULL, [Del1] nvarchar(500) NULL, [Del2] nvarchar(500) NULL, [Del3] nvarchar(500) NULL, [Del4] nvarchar(500) NULL, [Mobile] nvarchar(500) NULL, [Vatno] nvarchar(500) NULL, [fill] nvarchar(5) NULL, [crdays] decimal(18, 4) NULL, [custgroup] nvarchar(500) NULL, [ContactArabic] nvarchar(500) NULL, [phoneArabic] nvarchar(500) NULL, [FaxArabic] nvarchar(500) NULL, [emailArabic] nvarchar(500) NULL, [mobArabic] nvarchar(500) NULL, [vatnoArabic] nvarchar(500) NULL, [BuildingNo] nvarchar(500) NULL, [StreetName] nvarchar(500) NULL, [District] nvarchar(500) NULL, [City] nvarchar(500) NULL, [Country] nvarchar(500) NULL, [PostalCode] nvarchar(500) NULL, [AdditionalNo] nvarchar(500) NULL, [OtherSellerNo] nvarchar(500) NULL, [BuildingNoArabic] nvarchar(500) NULL, [StreetNameArabic] nvarchar(500) NULL, [DistrictArabic] nvarchar(500) NULL, [CityArabic] nvarchar(500) NULL, [CountryArabic] nvarchar(500) NULL, [PostalCodeArabic] nvarchar(500) NULL, [AdditionalNoArabic] nvarchar(500) NULL, [OtherSellerNoArabic] nvarchar(500) NULL, [logoimage] image NULL, [signatureimage] image NULL, [sealimage] image NULL, [footerimage] image NULL, [headderimage] image NULL, [PlotIdentificationAr] nvarchar(500) NULL, [CitySubdivisionNameAr] nvarchar(500) NULL, [CountrySubentityAr] nvarchar(500) NULL, [PlotIdentification] nvarchar(500) NULL, [CitySubdivisionName] nvarchar(500) NULL, [CountrySubentity] nvarchar(500) NULL, [CountryCode] nvarchar(200) NULL, [IdentificationNo] nvarchar(200) NULL, [Identification] nvarchar(200) NULL, [IdentificationNoAr] nvarchar(200) NULL, [GroupVat] nvarchar(500) NULL, [Neighbourhood] nvarchar(500) NULL, [NeighbourhoodAr] nvarchar(500) NULL ); INSERT INTO dbo.[companydetailsbkp_New] ([Code], [Name], [Address1], [Address2], [Address3], [Address4], [CrLimit], [Opening], [DbCr], [NameAR], [Address1AR], [Address2AR], [Address3AR], [Address4AR], [Contact], [Telephone], [Fax], [Email], [Del1], [Del2], [Del3], [Del4], [Mobile], [Vatno], [fill], [crdays], [custgroup], [ContactArabic], [phoneArabic], [FaxArabic], [emailArabic], [mobArabic], [vatnoArabic], [BuildingNo], [StreetName], [District], [City], [Country], [PostalCode], [AdditionalNo], [OtherSellerNo], [BuildingNoArabic], [StreetNameArabic], [DistrictArabic], [CityArabic], [CountryArabic], [PostalCodeArabic], [AdditionalNoArabic], [OtherSellerNoArabic], [logoimage], [signatureimage], [sealimage], [footerimage], [headderimage], [PlotIdentificationAr], [CitySubdivisionNameAr], [CountrySubentityAr], [PlotIdentification], [CitySubdivisionName], [CountrySubentity], [CountryCode], [IdentificationNo], [Identification], [IdentificationNoAr], [GroupVat], [Neighbourhood], [NeighbourhoodAr]) SELECT [Code], [Name], [Address1], [Address2], [Address3], [Address4], [CrLimit], [Opening], [DbCr], [NameAR], [Address1AR], [Address2AR], [Address3AR], [Address4AR], [Contact], [Telephone], [Fax], [Email], [Del1], [Del2], [Del3], [Del4], [Mobile], [Vatno], [fill], [crdays], [custgroup], [ContactArabic], [phoneArabic], [FaxArabic], [emailArabic], [mobArabic], [vatnoArabic], [BuildingNo], [StreetName], [District], [City], [Country], [PostalCode], [AdditionalNo], [OtherSellerNo], [BuildingNoArabic], [StreetNameArabic], [DistrictArabic], [CityArabic], [CountryArabic], [PostalCodeArabic], [AdditionalNoArabic], [OtherSellerNoArabic], [logoimage], [signatureimage], [sealimage], [footerimage], [headderimage], [PlotIdentificationAr], [CitySubdivisionNameAr], [CountrySubentityAr], [PlotIdentification], [CitySubdivisionName], [CountrySubentity], [CountryCode], [IdentificationNo], [Identification], [IdentificationNoAr], [GroupVat], [Neighbourhood], [NeighbourhoodAr] FROM [companydetailsbkp]; DROP TABLE dbo.[companydetailsbkp]; EXEC sp_rename 'dbo.companydetailsbkp_New', 'companydetailsbkp'; GO CREATE TABLE [dbo].[companydetailsNO NEED_New] ( [companydetailsNO NEEDId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Code] varchar(50) NULL, [Name] nvarchar(2000) NULL, [Address1] nvarchar(2000) NULL, [Address2] nvarchar(2000) NULL, [Address3] nvarchar(2000) NULL, [Address4] nvarchar(2000) NULL, [CrLimit] decimal(18, 4) NULL, [Opening] decimal(18, 4) NULL, [DbCr] nvarchar(500) NULL, [NameAR] nvarchar(2000) NULL, [Address1AR] nvarchar(2000) NULL, [Address2AR] nvarchar(2000) NULL, [Address3AR] nvarchar(2000) NULL, [Address4AR] nvarchar(2000) NULL, [Contact] nvarchar(500) NULL, [Telephone] nvarchar(500) NULL, [Fax] nvarchar(500) NULL, [Email] nvarchar(2000) NULL, [Del1] nvarchar(500) NULL, [Del2] nvarchar(500) NULL, [Del3] nvarchar(500) NULL, [Del4] nvarchar(500) NULL, [Mobile] nvarchar(500) NULL, [Vatno] nvarchar(500) NULL, [fill] nvarchar(5) NULL, [crdays] decimal(18, 4) NULL, [custgroup] nvarchar(500) NULL, [ContactArabic] nvarchar(500) NULL, [phoneArabic] nvarchar(500) NULL, [FaxArabic] nvarchar(500) NULL, [emailArabic] nvarchar(500) NULL, [mobArabic] nvarchar(500) NULL, [vatnoArabic] nvarchar(500) NULL, [BuildingNo] nvarchar(500) NULL, [StreetName] nvarchar(500) NULL, [District] nvarchar(500) NULL, [City] nvarchar(500) NULL, [Country] nvarchar(500) NULL, [PostalCode] nvarchar(500) NULL, [AdditionalNo] nvarchar(500) NULL, [OtherSellerNo] nvarchar(500) NULL, [BuildingNoArabic] nvarchar(500) NULL, [StreetNameArabic] nvarchar(500) NULL, [DistrictArabic] nvarchar(500) NULL, [CityArabic] nvarchar(500) NULL, [CountryArabic] nvarchar(500) NULL, [PostalCodeArabic] nvarchar(500) NULL, [AdditionalNoArabic] nvarchar(500) NULL, [OtherSellerNoArabic] nvarchar(500) NULL, [logoimage] image NULL, [signatureimage] image NULL, [sealimage] image NULL, [footerimage] image NULL, [headderimage] image NULL, [PlotIdentificationAr] nvarchar(500) NULL, [CitySubdivisionNameAr] nvarchar(500) NULL, [CountrySubentityAr] nvarchar(500) NULL, [PlotIdentification] nvarchar(500) NULL, [CitySubdivisionName] nvarchar(500) NULL, [CountrySubentity] nvarchar(500) NULL, [CountryCode] nvarchar(200) NULL, [IdentificationNo] nvarchar(200) NULL, [Identification] nvarchar(200) NULL, [IdentificationNoAr] nvarchar(200) NULL, [GroupVat] nvarchar(500) NULL, [Neighbourhood] nvarchar(500) NULL, [NeighbourhoodAr] nvarchar(500) NULL ); INSERT INTO dbo.[companydetailsNO NEED_New] ([Code], [Name], [Address1], [Address2], [Address3], [Address4], [CrLimit], [Opening], [DbCr], [NameAR], [Address1AR], [Address2AR], [Address3AR], [Address4AR], [Contact], [Telephone], [Fax], [Email], [Del1], [Del2], [Del3], [Del4], [Mobile], [Vatno], [fill], [crdays], [custgroup], [ContactArabic], [phoneArabic], [FaxArabic], [emailArabic], [mobArabic], [vatnoArabic], [BuildingNo], [StreetName], [District], [City], [Country], [PostalCode], [AdditionalNo], [OtherSellerNo], [BuildingNoArabic], [StreetNameArabic], [DistrictArabic], [CityArabic], [CountryArabic], [PostalCodeArabic], [AdditionalNoArabic], [OtherSellerNoArabic], [logoimage], [signatureimage], [sealimage], [footerimage], [headderimage], [PlotIdentificationAr], [CitySubdivisionNameAr], [CountrySubentityAr], [PlotIdentification], [CitySubdivisionName], [CountrySubentity], [CountryCode], [IdentificationNo], [Identification], [IdentificationNoAr], [GroupVat], [Neighbourhood], [NeighbourhoodAr]) SELECT [Code], [Name], [Address1], [Address2], [Address3], [Address4], [CrLimit], [Opening], [DbCr], [NameAR], [Address1AR], [Address2AR], [Address3AR], [Address4AR], [Contact], [Telephone], [Fax], [Email], [Del1], [Del2], [Del3], [Del4], [Mobile], [Vatno], [fill], [crdays], [custgroup], [ContactArabic], [phoneArabic], [FaxArabic], [emailArabic], [mobArabic], [vatnoArabic], [BuildingNo], [StreetName], [District], [City], [Country], [PostalCode], [AdditionalNo], [OtherSellerNo], [BuildingNoArabic], [StreetNameArabic], [DistrictArabic], [CityArabic], [CountryArabic], [PostalCodeArabic], [AdditionalNoArabic], [OtherSellerNoArabic], [logoimage], [signatureimage], [sealimage], [footerimage], [headderimage], [PlotIdentificationAr], [CitySubdivisionNameAr], [CountrySubentityAr], [PlotIdentification], [CitySubdivisionName], [CountrySubentity], [CountryCode], [IdentificationNo], [Identification], [IdentificationNoAr], [GroupVat], [Neighbourhood], [NeighbourhoodAr] FROM [companydetailsNO NEED]; DROP TABLE dbo.[companydetailsNO NEED]; EXEC sp_rename 'dbo.companydetailsNO NEED_New', 'companydetailsNO NEED'; GO CREATE TABLE [dbo].[country_New] ( [countryId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [id] nvarchar(100) NULL, [name] nvarchar(2000) NULL, [image] nvarchar(500) NULL, [continent_id] int NULL, [entrydate] nvarchar(500) NULL, [status] char NULL, [category_sequence] int NULL, [deleted] char NULL, [nameAr] nvarchar(500) NULL ); INSERT INTO dbo.[country_New] ([id], [name], [image], [continent_id], [entrydate], [status], [category_sequence], [deleted], [nameAr]) SELECT [id], [name], [image], [continent_id], [entrydate], [status], [category_sequence], [deleted], [nameAr] FROM [country]; DROP TABLE dbo.[country]; EXEC sp_rename 'dbo.country_New', 'country'; GO CREATE TABLE [dbo].[CreditNote_New] ( [CreditNoteId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Branch] nvarchar(500) NULL, [CnNo] nvarchar(500) NULL, [EntryDate] nvarchar(500) NULL, [Narration] nvarchar(2000) NULL, [Amount] decimal(18, 4) NULL, [CustomerCode] nvarchar(500) NULL, [AccountCode] nvarchar(500) NULL, [Customer] nvarchar(2000) NULL, [Account] nvarchar(2000) NULL, [Notes] nvarchar(2000) NULL, [InvoiceNo] nvarchar(500) NULL ); INSERT INTO dbo.[CreditNote_New] ([Branch], [CnNo], [EntryDate], [Narration], [Amount], [CustomerCode], [AccountCode], [Customer], [Account], [Notes], [InvoiceNo]) SELECT [Branch], [CnNo], [EntryDate], [Narration], [Amount], [CustomerCode], [AccountCode], [Customer], [Account], [Notes], [InvoiceNo] FROM [CreditNote]; DROP TABLE dbo.[CreditNote]; EXEC sp_rename 'dbo.CreditNote_New', 'CreditNote'; GO CREATE TABLE [dbo].[CurrencyMaster_New] ( [CurrencyMasterId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Code] nvarchar(500) NULL, [Name] nvarchar(2000) NULL, [Rate] decimal(18, 4) NULL ); INSERT INTO dbo.[CurrencyMaster_New] ([Code], [Name], [Rate]) SELECT [Code], [Name], [Rate] FROM [CurrencyMaster]; DROP TABLE dbo.[CurrencyMaster]; EXEC sp_rename 'dbo.CurrencyMaster_New', 'CurrencyMaster'; GO CREATE TABLE [dbo].[CustLedgerReport_New] ( [CustLedgerReportId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [AcCode] nvarchar(500) NULL, [Amt] decimal(18, 4) NULL ); INSERT INTO dbo.[CustLedgerReport_New] ([AcCode], [Amt]) SELECT [AcCode], [Amt] FROM [CustLedgerReport]; DROP TABLE dbo.[CustLedgerReport]; EXEC sp_rename 'dbo.CustLedgerReport_New', 'CustLedgerReport'; GO CREATE TABLE [dbo].[CustomerItem_New] ( [CustomerItemId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [ItemCode] nvarchar(250) NULL, [ItemName] nvarchar(500) NULL, [Rate] decimal(18, 4) NULL, [Unit] nvarchar(50) NULL, [PartNo] nvarchar(500) NULL, [ItemNameAR] nvarchar(500) NULL, [customercode] nvarchar(250) NULL, [customer] nvarchar(500) NULL, [Unitid] nvarchar(50) NULL ); INSERT INTO dbo.[CustomerItem_New] ([ItemCode], [ItemName], [Rate], [Unit], [PartNo], [ItemNameAR], [customercode], [customer], [Unitid]) SELECT [ItemCode], [ItemName], [Rate], [Unit], [PartNo], [ItemNameAR], [customercode], [customer], [Unitid] FROM [CustomerItem]; DROP TABLE dbo.[CustomerItem]; EXEC sp_rename 'dbo.CustomerItem_New', 'CustomerItem'; GO CREATE TABLE [dbo].[customeritemSalesPriceDetails_New] ( [customeritemSalesPriceDetailsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [ItemCode] nvarchar(250) NULL, [Unitid] nvarchar(50) NULL, [qty] decimal(18, 4) NULL, [Rate] decimal(18, 4) NULL, [customercode] nvarchar(250) NULL ); INSERT INTO dbo.[customeritemSalesPriceDetails_New] ([ItemCode], [Unitid], [qty], [Rate], [customercode]) SELECT [ItemCode], [Unitid], [qty], [Rate], [customercode] FROM [customeritemSalesPriceDetails]; DROP TABLE dbo.[customeritemSalesPriceDetails]; EXEC sp_rename 'dbo.customeritemSalesPriceDetails_New', 'customeritemSalesPriceDetails'; GO CREATE TABLE [dbo].[CustomerReceipt_New] ( [CustomerReceiptId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [VoucherNo] nvarchar(500) NULL, [KeyFld] nvarchar(15) NULL, [PaidDate] datetime NULL, [Narration] nvarchar(2000) NULL, [TotAmount] decimal(18, 4) NULL, [CustomerCode] nvarchar(500) NULL, [CBCode] nvarchar(500) NULL, [InvoiceNo] nvarchar(500) NULL, [InvoiceAmount] decimal(18, 4) NULL, [InvoiceBalance] decimal(18, 4) NULL, [ChequeNo] nvarchar(500) NULL, [ChequeDate] datetime NULL, [SalesMan] nvarchar(2000) NULL, [TMP] nvarchar(1) NULL, [CustomerName] nvarchar(2000) NULL, [Account] nvarchar(2000) NULL, [AccountCode] nvarchar(500) NULL, [PayMode] nvarchar(500) NULL, [Advance] nvarchar(200) NULL, [Deleted] nvarchar(200) NULL, [bank] nvarchar(500) NULL, [AutoFill] nvarchar(5) NULL, [Rvno] nvarchar(500) NULL, [totaldiscount] decimal(18, 4) NULL, [DiscountDetails] nvarchar(2000) NULL ); INSERT INTO dbo.[CustomerReceipt_New] ([VoucherNo], [KeyFld], [PaidDate], [Narration], [TotAmount], [CustomerCode], [CBCode], [InvoiceNo], [InvoiceAmount], [InvoiceBalance], [ChequeNo], [ChequeDate], [SalesMan], [TMP], [CustomerName], [Account], [AccountCode], [PayMode], [Advance], [Deleted], [bank], [AutoFill], [Rvno], [totaldiscount], [DiscountDetails]) SELECT [VoucherNo], [KeyFld], [PaidDate], [Narration], [TotAmount], [CustomerCode], [CBCode], [InvoiceNo], [InvoiceAmount], [InvoiceBalance], [ChequeNo], [ChequeDate], [SalesMan], [TMP], [CustomerName], [Account], [AccountCode], [PayMode], [Advance], [Deleted], [bank], [AutoFill], [Rvno], [totaldiscount], [DiscountDetails] FROM [CustomerReceipt]; DROP TABLE dbo.[CustomerReceipt]; EXEC sp_rename 'dbo.CustomerReceipt_New', 'CustomerReceipt'; GO CREATE TABLE [dbo].[CustomerReceiptDetail_New] ( [CustomerReceiptDetailId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [InvoiceNo] nvarchar(500) NULL, [InvoiceAmount] decimal(18, 4) NULL, [ReceivedAmount] decimal(18, 4) NULL, [BalanceAmount] decimal(18, 4) NULL, [Accode] nvarchar(500) NULL, [VoucherNo] nvarchar(500) NULL, [KeyFld] nvarchar(10) NULL, [slno] decimal(18, 4) NULL, [InvoiceBalance] decimal(18, 4) NULL, [TotalReceived] decimal(18, 4) NULL, [PaidDate] datetime NULL, [BillNo] nvarchar(500) NULL, [Narration] nvarchar(2000) NULL, [Deleted] nvarchar(500) NULL, [Invdate] datetime NULL, [Discount] decimal(18, 4) NULL, [Salesman] nvarchar(500) NULL ); INSERT INTO dbo.[CustomerReceiptDetail_New] ([InvoiceNo], [InvoiceAmount], [ReceivedAmount], [BalanceAmount], [Accode], [VoucherNo], [KeyFld], [slno], [InvoiceBalance], [TotalReceived], [PaidDate], [BillNo], [Narration], [Deleted], [Invdate], [Discount], [Salesman]) SELECT [InvoiceNo], [InvoiceAmount], [ReceivedAmount], [BalanceAmount], [Accode], [VoucherNo], [KeyFld], [slno], [InvoiceBalance], [TotalReceived], [PaidDate], [BillNo], [Narration], [Deleted], [Invdate], [Discount], [Salesman] FROM [CustomerReceiptDetail]; DROP TABLE dbo.[CustomerReceiptDetail]; EXEC sp_rename 'dbo.CustomerReceiptDetail_New', 'CustomerReceiptDetail'; GO CREATE TABLE [dbo].[DamageItem_New] ( [DamageItemId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [DocNO] nvarchar(500) NULL, [Date] datetime NULL, [enteredby] nvarchar(2000) NULL, [SlNo] decimal(18, 4) NULL, [ItemCode] nvarchar(500) NULL, [ItemName] nvarchar(2000) NULL, [Qty] decimal(18, 4) NULL, [RATE] decimal(18, 4) NULL, [Amount] decimal(18, 4) NULL, [accode] nvarchar(500) NULL, [Acname] nvarchar(500) NULL, [TotalCost] decimal(18, 4) NULL, [storeshop] nvarchar(500) NULL ); INSERT INTO dbo.[DamageItem_New] ([DocNO], [Date], [enteredby], [SlNo], [ItemCode], [ItemName], [Qty], [RATE], [Amount], [accode], [Acname], [TotalCost], [storeshop]) SELECT [DocNO], [Date], [enteredby], [SlNo], [ItemCode], [ItemName], [Qty], [RATE], [Amount], [accode], [Acname], [TotalCost], [storeshop] FROM [DamageItem]; DROP TABLE dbo.[DamageItem]; EXEC sp_rename 'dbo.DamageItem_New', 'DamageItem'; GO CREATE TABLE [dbo].[DebitNote_New] ( [DebitNoteId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Branch] nvarchar(500) NULL, [EntryDate] datetime NULL, [InvNo] nvarchar(500) NULL, [DebitNoteNo] nvarchar(500) NULL, [BillType] nvarchar(500) NULL, [RefNo] nvarchar(500) NULL, [PONo] nvarchar(500) NULL, [CustomerCode] nvarchar(500) NULL, [CustomerName] nvarchar(2000) NULL, [Address] nvarchar(2000) NULL, [Phone] nvarchar(500) NULL, [Fax] nvarchar(500) NULL, [Attended] nvarchar(2000) NULL, [GrossAmount] decimal(18, 4) NULL, [LessPerc] decimal(18, 4) NULL, [LessAmount] decimal(18, 4) NULL, [NetAmount] decimal(18, 4) NULL, [SR] nvarchar(500) NULL, [AddLess] decimal(18, 4) NULL, [Remarks] nvarchar(2000) NULL, [Received] decimal(18, 4) NULL, [DnNo] nvarchar(150) NULL, [QuotNo] nvarchar(500) NULL, [Flag] char NULL, [CreditPeriod] nvarchar(500) NULL, [ReceivedAmount] decimal(18, 4) NULL, [UserName] nvarchar(500) NULL, [InvoiceRetNo] nvarchar(500) NULL, [ReceivedAmt] decimal(18, 4) NULL, [ChangeAmount] decimal(18, 4) NULL, [InvoiceDate] datetime NULL, [Narration] nvarchar(2000) NULL, [voucherNo] nvarchar(500) NULL, [Commision] decimal(18, 4) NULL, [Stock] decimal(18, 4) NULL, [Status] char NULL, [Bank1] nvarchar(500) NULL, [Bank2] nvarchar(500) NULL, [Bank3] nvarchar(500) NULL, [Bank4] nvarchar(500) NULL, [Del1] nvarchar(500) NULL, [Del2] nvarchar(500) NULL, [Del3] nvarchar(500) NULL, [Del4] nvarchar(500) NULL, [PODate] datetime NULL, [Freight] decimal(18, 4) NULL, [Retention] nvarchar(500) NULL, [DelDate] datetime NULL, [ProjectNo] nvarchar(500) NULL, [Deleted] char NULL, [AccountCode] nvarchar(500) NULL, [AccountName] nvarchar(2000) NULL, [ReceiptNo] nvarchar(500) NULL, [hijridate] datetime NULL, [Remarks1] nvarchar(2000) NULL, [Mobile] nvarchar(500) NULL, [TransApp] nvarchar(500) NULL, [vattotal] decimal(18, 4) NULL, [Vatno] nvarchar(200) NULL, [crdays] decimal(18, 4) NULL, [invdueDate] datetime NULL, [LOCCODE] nvarchar(500) NULL, [LOCNAME] nvarchar(2000) NULL, [bankcode] nvarchar(500) NULL, [bankname] nvarchar(2000) NULL, [bankamount] decimal(18, 4) NULL, [pinvno] nvarchar(500) NULL, [qrcode] image NULL, [INVTYPE] nvarchar(500) NULL, [INVRETITEMTYPE] nvarchar(500) NULL, [DEBITNOTEREASON] nvarchar(500) NULL ); INSERT INTO dbo.[DebitNote_New] ([Branch], [EntryDate], [InvNo], [DebitNoteNo], [BillType], [RefNo], [PONo], [CustomerCode], [CustomerName], [Address], [Phone], [Fax], [Attended], [GrossAmount], [LessPerc], [LessAmount], [NetAmount], [SR], [AddLess], [Remarks], [Received], [DnNo], [QuotNo], [Flag], [CreditPeriod], [ReceivedAmount], [UserName], [InvoiceRetNo], [ReceivedAmt], [ChangeAmount], [InvoiceDate], [Narration], [voucherNo], [Commision], [Stock], [Status], [Bank1], [Bank2], [Bank3], [Bank4], [Del1], [Del2], [Del3], [Del4], [PODate], [Freight], [Retention], [DelDate], [ProjectNo], [Deleted], [AccountCode], [AccountName], [ReceiptNo], [hijridate], [Remarks1], [Mobile], [TransApp], [vattotal], [Vatno], [crdays], [invdueDate], [LOCCODE], [LOCNAME], [bankcode], [bankname], [bankamount], [pinvno], [qrcode], [INVTYPE], [INVRETITEMTYPE], [DEBITNOTEREASON]) SELECT [Branch], [EntryDate], [InvNo], [DebitNoteNo], [BillType], [RefNo], [PONo], [CustomerCode], [CustomerName], [Address], [Phone], [Fax], [Attended], [GrossAmount], [LessPerc], [LessAmount], [NetAmount], [SR], [AddLess], [Remarks], [Received], [DnNo], [QuotNo], [Flag], [CreditPeriod], [ReceivedAmount], [UserName], [InvoiceRetNo], [ReceivedAmt], [ChangeAmount], [InvoiceDate], [Narration], [voucherNo], [Commision], [Stock], [Status], [Bank1], [Bank2], [Bank3], [Bank4], [Del1], [Del2], [Del3], [Del4], [PODate], [Freight], [Retention], [DelDate], [ProjectNo], [Deleted], [AccountCode], [AccountName], [ReceiptNo], [hijridate], [Remarks1], [Mobile], [TransApp], [vattotal], [Vatno], [crdays], [invdueDate], [LOCCODE], [LOCNAME], [bankcode], [bankname], [bankamount], [pinvno], [qrcode], [INVTYPE], [INVRETITEMTYPE], [DEBITNOTEREASON] FROM [DebitNote]; DROP TABLE dbo.[DebitNote]; EXEC sp_rename 'dbo.DebitNote_New', 'DebitNote'; GO CREATE TABLE [dbo].[DebitNoteItem_New] ( [DebitNoteItemId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Branch] nvarchar(15) NULL, [EntryDate] datetime NULL, [ItemCode] nvarchar(500) NULL, [ItemName] nvarchar(2000) NULL, [Damage] decimal(18, 4) NULL, [Unit] nvarchar(50) NULL, [Qty] decimal(18, 4) NULL, [Rate] decimal(18, 4) NULL, [Amount] decimal(18, 4) NULL, [SR] nvarchar(500) NULL, [SlNo] decimal(18, 4) NULL, [Cost] decimal(18, 4) NULL, [DebitNoteNo] nvarchar(500) NULL, [InvoiceDate] datetime NULL, [DocumentNo] decimal(18, 4) NULL, [InvNo] nvarchar(500) NULL, [SQTY] decimal(18, 4) NULL, [Sales] decimal(18, 4) NULL, [QtyPerUnit] decimal(18, 4) NULL, [TOTQty] decimal(18, 4) NULL, [PerQty] decimal(18, 4) NULL, [PartNo] nvarchar(2000) NULL, [stdcost] decimal(18, 4) NULL, [RateAfterDisc] decimal(18, 4) NULL, [RetQty] decimal(18, 4) NULL, [DNNo] nvarchar(500) NULL, [Deleted] nvarchar(500) NULL, [VATPER] decimal(18, 4) NULL, [VATAMT] decimal(18, 4) NULL, [VAT] decimal(18, 4) NULL, [Disc] decimal(18, 4) NULL, [DisconRate] decimal(18, 4) NULL, [SalesRate] decimal(18, 4) NULL ); INSERT INTO dbo.[DebitNoteItem_New] ([Branch], [EntryDate], [ItemCode], [ItemName], [Damage], [Unit], [Qty], [Rate], [Amount], [SR], [SlNo], [Cost], [DebitNoteNo], [InvoiceDate], [DocumentNo], [InvNo], [SQTY], [Sales], [QtyPerUnit], [TOTQty], [PerQty], [PartNo], [stdcost], [RateAfterDisc], [RetQty], [DNNo], [Deleted], [VATPER], [VATAMT], [VAT], [Disc], [DisconRate], [SalesRate]) SELECT [Branch], [EntryDate], [ItemCode], [ItemName], [Damage], [Unit], [Qty], [Rate], [Amount], [SR], [SlNo], [Cost], [DebitNoteNo], [InvoiceDate], [DocumentNo], [InvNo], [SQTY], [Sales], [QtyPerUnit], [TOTQty], [PerQty], [PartNo], [stdcost], [RateAfterDisc], [RetQty], [DNNo], [Deleted], [VATPER], [VATAMT], [VAT], [Disc], [DisconRate], [SalesRate] FROM [DebitNoteItem]; DROP TABLE dbo.[DebitNoteItem]; EXEC sp_rename 'dbo.DebitNoteItem_New', 'DebitNoteItem'; GO CREATE TABLE [dbo].[DebitNoteLog_New] ( [DebitNoteLogId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [DebitNoteNo] nvarchar(500) NULL, [BillType] nvarchar(500) NULL, [CreditPeriod] nvarchar(500) NULL, [CustomerCode] nvarchar(500) NULL, [CustomerName] nvarchar(2000) NULL, [Phone] nvarchar(500) NULL, [Attended] nvarchar(2000) NULL, [Remarks] nvarchar(2000) NULL, [GrossAmount] decimal(18, 4) NULL, [ReceivedAmt] decimal(18, 4) NULL, [LessPerc] decimal(18, 4) NULL, [LessAmount] decimal(18, 4) NULL, [ChangeAmount] decimal(18, 4) NULL, [NetAmount] decimal(18, 4) NULL, [UserName] nvarchar(500) NULL, [System] nvarchar(500) NULL, [DateAndTime] datetime NULL, [Action] nvarchar(500) NULL ); INSERT INTO dbo.[DebitNoteLog_New] ([EntryDate], [DebitNoteNo], [BillType], [CreditPeriod], [CustomerCode], [CustomerName], [Phone], [Attended], [Remarks], [GrossAmount], [ReceivedAmt], [LessPerc], [LessAmount], [ChangeAmount], [NetAmount], [UserName], [System], [DateAndTime], [Action]) SELECT [EntryDate], [DebitNoteNo], [BillType], [CreditPeriod], [CustomerCode], [CustomerName], [Phone], [Attended], [Remarks], [GrossAmount], [ReceivedAmt], [LessPerc], [LessAmount], [ChangeAmount], [NetAmount], [UserName], [System], [DateAndTime], [Action] FROM [DebitNoteLog]; DROP TABLE dbo.[DebitNoteLog]; EXEC sp_rename 'dbo.DebitNoteLog_New', 'DebitNoteLog'; GO CREATE TABLE [dbo].[DefaultAccountMaster_New] ( [DefaultAccountMasterId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [BankCode] nvarchar(500) NULL, [BankName] nvarchar(2000) NULL, [BankRemarks] nvarchar(2000) NULL ); INSERT INTO dbo.[DefaultAccountMaster_New] ([BankCode], [BankName], [BankRemarks]) SELECT [BankCode], [BankName], [BankRemarks] FROM [DefaultAccountMaster]; DROP TABLE dbo.[DefaultAccountMaster]; EXEC sp_rename 'dbo.DefaultAccountMaster_New', 'DefaultAccountMaster'; GO CREATE TABLE [dbo].[DeliveryLog_New] ( [DeliveryLogId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [DNNo] nvarchar(500) NULL, [CustomerCode] nvarchar(500) NULL, [CustomerName] nvarchar(2000) NULL, [Phone] nvarchar(500) NULL, [Attended] nvarchar(2000) NULL, [Fax] nvarchar(500) NULL, [Attention] nvarchar(2000) NULL, [Address] nvarchar(2000) NULL, [InvNo] nvarchar(500) NULL, [QuotNo] nvarchar(500) NULL, [RefNo] nvarchar(500) NULL, [UserName] nvarchar(2000) NULL, [System] nvarchar(2000) NULL, [DateAndTime] datetime NULL, [Action] nvarchar(2000) NULL ); INSERT INTO dbo.[DeliveryLog_New] ([EntryDate], [DNNo], [CustomerCode], [CustomerName], [Phone], [Attended], [Fax], [Attention], [Address], [InvNo], [QuotNo], [RefNo], [UserName], [System], [DateAndTime], [Action]) SELECT [EntryDate], [DNNo], [CustomerCode], [CustomerName], [Phone], [Attended], [Fax], [Attention], [Address], [InvNo], [QuotNo], [RefNo], [UserName], [System], [DateAndTime], [Action] FROM [DeliveryLog]; DROP TABLE dbo.[DeliveryLog]; EXEC sp_rename 'dbo.DeliveryLog_New', 'DeliveryLog'; GO CREATE TABLE [dbo].[DeliveryNote_New] ( [DeliveryNoteId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [QuotationNo] nvarchar(500) NULL, [RefNo] nvarchar(500) NULL, [PONo] nvarchar(500) NULL, [DNNo] nvarchar(500) NULL, [BillType] nvarchar(500) NULL, [CustomerCode] nvarchar(500) NULL, [CustomerName] nvarchar(2000) NULL, [Telephone] nvarchar(500) NULL, [Fax] nvarchar(500) NULL, [Attended] nvarchar(2000) NULL, [GrossAmount] decimal(18, 4) NULL, [Discount] decimal(18, 4) NULL, [NetAmount] decimal(18, 4) NULL, [KeyFld] decimal(18, 4) NULL, [Less] decimal(18, 4) NULL, [Status] decimal(18, 4) NULL, [Attention] nvarchar(2000) NULL, [Remarks] nvarchar(2000) NULL, [InvoiceNo] nvarchar(500) NULL, [Address] nvarchar(2000) NULL, [Flag] nvarchar(500) NULL, [UserName] nvarchar(500) NULL, [emailAttention] nvarchar(2000) NULL, [mobAttention] nvarchar(500) NULL, [del1] nvarchar(500) NULL, [del2] nvarchar(500) NULL, [del3] nvarchar(500) NULL, [del4] nvarchar(500) NULL, [podate] datetime NULL, [InvDate] datetime NULL, [deleted] nvarchar(500) NULL, [Mobile] nvarchar(500) NULL, [Vatno] nvarchar(200) NULL, [vattotal] decimal(18, 4) NULL, [TOTALCOST] decimal(18, 4) NULL, [DISPER] decimal(18, 4) NULL, [DISAMT] decimal(18, 4) NULL, [DISNET] decimal(18, 4) NULL, [Detail1] nvarchar(2000) NULL, [Detail2] nvarchar(2000) NULL, [Detail3] nvarchar(2000) NULL, [Detail4] nvarchar(2000) NULL, [Detail5] nvarchar(2000) NULL, [Detail6] nvarchar(2000) NULL, [Detail7] nvarchar(2000) NULL, [Detail8] nvarchar(2000) NULL, [Detail9] nvarchar(2000) NULL, [Detail10] nvarchar(2000) NULL, [DetailDate1] datetime NULL, [DetailDate2] datetime NULL, [DetailDate3] datetime NULL, [DetailDate4] datetime NULL ); INSERT INTO dbo.[DeliveryNote_New] ([EntryDate], [QuotationNo], [RefNo], [PONo], [DNNo], [BillType], [CustomerCode], [CustomerName], [Telephone], [Fax], [Attended], [GrossAmount], [Discount], [NetAmount], [KeyFld], [Less], [Status], [Attention], [Remarks], [InvoiceNo], [Address], [Flag], [UserName], [emailAttention], [mobAttention], [del1], [del2], [del3], [del4], [podate], [InvDate], [deleted], [Mobile], [Vatno], [vattotal], [TOTALCOST], [DISPER], [DISAMT], [DISNET], [Detail1], [Detail2], [Detail3], [Detail4], [Detail5], [Detail6], [Detail7], [Detail8], [Detail9], [Detail10], [DetailDate1], [DetailDate2], [DetailDate3], [DetailDate4]) SELECT [EntryDate], [QuotationNo], [RefNo], [PONo], [DNNo], [BillType], [CustomerCode], [CustomerName], [Telephone], [Fax], [Attended], [GrossAmount], [Discount], [NetAmount], [KeyFld], [Less], [Status], [Attention], [Remarks], [InvoiceNo], [Address], [Flag], [UserName], [emailAttention], [mobAttention], [del1], [del2], [del3], [del4], [podate], [InvDate], [deleted], [Mobile], [Vatno], [vattotal], [TOTALCOST], [DISPER], [DISAMT], [DISNET], [Detail1], [Detail2], [Detail3], [Detail4], [Detail5], [Detail6], [Detail7], [Detail8], [Detail9], [Detail10], [DetailDate1], [DetailDate2], [DetailDate3], [DetailDate4] FROM [DeliveryNote]; DROP TABLE dbo.[DeliveryNote]; EXEC sp_rename 'dbo.DeliveryNote_New', 'DeliveryNote'; GO CREATE TABLE [dbo].[DeliveryNoteItem_New] ( [DeliveryNoteItemId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [ItemCode] nvarchar(500) NULL, [ItemName] nvarchar(2000) NULL, [Unit] nvarchar(50) NULL, [Qty] decimal(18, 4) NULL, [Rate] decimal(18, 4) NULL, [Amount] decimal(18, 4) NULL, [SlNo] decimal(18, 4) NULL, [Status] decimal(18, 4) NULL, [DNNo] nvarchar(500) NULL, [OrdQty] decimal(18, 4) NULL, [PartNo] nvarchar(2000) NULL, [qtyperunit] decimal(18, 4) NULL, [deleted] nvarchar(500) NULL, [Vatper] decimal(18, 4) NULL, [VatAmt] decimal(18, 4) NULL, [IDISCPER] decimal(18, 4) NULL, [IDISCRATE] decimal(18, 4) NULL, [PRATE] decimal(18, 4) NULL, [DISCONINCRATE] decimal(18, 4) NULL, [storeshop] nvarchar(500) NULL, [ItemDetail1] nvarchar(500) NULL, [ItemDetail2] nvarchar(500) NULL, [ItemDetail3] nvarchar(500) NULL, [ItemDetail4] nvarchar(500) NULL, [ItemDetail5] nvarchar(500) NULL, [ItemDetail6] nvarchar(500) NULL, [ItemDetail7] nvarchar(500) NULL, [ItemDetail8] nvarchar(500) NULL, [ItemDetail9] nvarchar(500) NULL, [ItemDetail10] nvarchar(500) NULL, [ItemDetailDate1] datetime NULL, [ItemDetailDate2] datetime NULL, [ItemDetailDate3] datetime NULL, [ItemDetailDate4] datetime NULL ); INSERT INTO dbo.[DeliveryNoteItem_New] ([EntryDate], [ItemCode], [ItemName], [Unit], [Qty], [Rate], [Amount], [SlNo], [Status], [DNNo], [OrdQty], [PartNo], [qtyperunit], [deleted], [Vatper], [VatAmt], [IDISCPER], [IDISCRATE], [PRATE], [DISCONINCRATE], [storeshop], [ItemDetail1], [ItemDetail2], [ItemDetail3], [ItemDetail4], [ItemDetail5], [ItemDetail6], [ItemDetail7], [ItemDetail8], [ItemDetail9], [ItemDetail10], [ItemDetailDate1], [ItemDetailDate2], [ItemDetailDate3], [ItemDetailDate4]) SELECT [EntryDate], [ItemCode], [ItemName], [Unit], [Qty], [Rate], [Amount], [SlNo], [Status], [DNNo], [OrdQty], [PartNo], [qtyperunit], [deleted], [Vatper], [VatAmt], [IDISCPER], [IDISCRATE], [PRATE], [DISCONINCRATE], [storeshop], [ItemDetail1], [ItemDetail2], [ItemDetail3], [ItemDetail4], [ItemDetail5], [ItemDetail6], [ItemDetail7], [ItemDetail8], [ItemDetail9], [ItemDetail10], [ItemDetailDate1], [ItemDetailDate2], [ItemDetailDate3], [ItemDetailDate4] FROM [DeliveryNoteItem]; DROP TABLE dbo.[DeliveryNoteItem]; EXEC sp_rename 'dbo.DeliveryNoteItem_New', 'DeliveryNoteItem'; GO CREATE TABLE [dbo].[DeliveryNoteReturn_New] ( [DeliveryNoteReturnId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [DNRetNo] nvarchar(500) NULL, [DNDate] datetime NULL, [EntryDate] datetime NULL, [QuotationNo] nvarchar(500) NULL, [RefNo] nvarchar(500) NULL, [PONo] nvarchar(500) NULL, [DNNo] nvarchar(500) NULL, [BillType] nvarchar(500) NULL, [CustomerCode] nvarchar(500) NULL, [CustomerName] nvarchar(2000) NULL, [Telephone] nvarchar(500) NULL, [Fax] nvarchar(500) NULL, [Attended] nvarchar(2000) NULL, [GrossAmount] decimal(18, 4) NULL, [Discount] decimal(18, 4) NULL, [NetAmount] decimal(18, 4) NULL, [KeyFld] decimal(18, 4) NULL, [Less] decimal(18, 4) NULL, [Status] decimal(18, 4) NULL, [Attention] nvarchar(2000) NULL, [Remarks] nvarchar(2000) NULL, [InvoiceNo] nvarchar(500) NULL, [Address] nvarchar(2000) NULL, [Flag] nvarchar(500) NULL, [UserName] nvarchar(500) NULL, [emailAttention] nvarchar(2000) NULL, [mobAttention] nvarchar(500) NULL, [del1] nvarchar(500) NULL, [del2] nvarchar(500) NULL, [del3] nvarchar(500) NULL, [del4] nvarchar(500) NULL, [podate] datetime NULL, [InvDate] datetime NULL, [deleted] nvarchar(500) NULL, [Mobile] nvarchar(500) NULL, [Vatno] nvarchar(200) NULL ); INSERT INTO dbo.[DeliveryNoteReturn_New] ([DNRetNo], [DNDate], [EntryDate], [QuotationNo], [RefNo], [PONo], [DNNo], [BillType], [CustomerCode], [CustomerName], [Telephone], [Fax], [Attended], [GrossAmount], [Discount], [NetAmount], [KeyFld], [Less], [Status], [Attention], [Remarks], [InvoiceNo], [Address], [Flag], [UserName], [emailAttention], [mobAttention], [del1], [del2], [del3], [del4], [podate], [InvDate], [deleted], [Mobile], [Vatno]) SELECT [DNRetNo], [DNDate], [EntryDate], [QuotationNo], [RefNo], [PONo], [DNNo], [BillType], [CustomerCode], [CustomerName], [Telephone], [Fax], [Attended], [GrossAmount], [Discount], [NetAmount], [KeyFld], [Less], [Status], [Attention], [Remarks], [InvoiceNo], [Address], [Flag], [UserName], [emailAttention], [mobAttention], [del1], [del2], [del3], [del4], [podate], [InvDate], [deleted], [Mobile], [Vatno] FROM [DeliveryNoteReturn]; DROP TABLE dbo.[DeliveryNoteReturn]; EXEC sp_rename 'dbo.DeliveryNoteReturn_New', 'DeliveryNoteReturn'; GO CREATE TABLE [dbo].[DeliveryNoteReturnItem_New] ( [DeliveryNoteReturnItemId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [ItemCode] nvarchar(500) NULL, [ItemName] nvarchar(2000) NULL, [Unit] nvarchar(50) NULL, [Qty] decimal(18, 4) NULL, [Rate] decimal(18, 4) NULL, [Amount] decimal(18, 4) NULL, [SlNo] decimal(18, 4) NULL, [Status] decimal(18, 4) NULL, [DNRetNo] nvarchar(500) NULL, [OrdQty] decimal(18, 4) NULL, [PartNo] nvarchar(2000) NULL, [qtyperunit] decimal(18, 4) NULL, [deleted] nvarchar(500) NULL, [Vatper] decimal(18, 4) NULL, [VatAmt] decimal(18, 4) NULL ); INSERT INTO dbo.[DeliveryNoteReturnItem_New] ([EntryDate], [ItemCode], [ItemName], [Unit], [Qty], [Rate], [Amount], [SlNo], [Status], [DNRetNo], [OrdQty], [PartNo], [qtyperunit], [deleted], [Vatper], [VatAmt]) SELECT [EntryDate], [ItemCode], [ItemName], [Unit], [Qty], [Rate], [Amount], [SlNo], [Status], [DNRetNo], [OrdQty], [PartNo], [qtyperunit], [deleted], [Vatper], [VatAmt] FROM [DeliveryNoteReturnItem]; DROP TABLE dbo.[DeliveryNoteReturnItem]; EXEC sp_rename 'dbo.DeliveryNoteReturnItem_New', 'DeliveryNoteReturnItem'; GO CREATE TABLE [dbo].[Department_New] ( [DepartmentId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [DepCode] varchar(50) NULL, [DepName] varchar(50) NULL, [Remarks] varchar(250) NULL ); INSERT INTO dbo.[Department_New] ([DepCode], [DepName], [Remarks]) SELECT [DepCode], [DepName], [Remarks] FROM [Department]; DROP TABLE dbo.[Department]; EXEC sp_rename 'dbo.Department_New', 'Department'; GO CREATE TABLE [dbo].[EDebitNote_New] ( [EDebitNoteId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EDebitNoteNo] nvarchar(500) NULL, [ESELLERNAME] nvarchar(2000) NULL, [ESELLERVATNO] nvarchar(500) NULL, [ECustomerName] nvarchar(2000) NULL, [ECUSTOMERVATNO] nvarchar(500) NULL, [EINVOICEDATE] datetime NULL, [EINVOICETOTAL] decimal(18, 4) NULL, [EVATTOTAL] decimal(18, 4) NULL, [EUUINO] nvarchar(500) NULL, [QRCODE] image NULL, [QRSTRING] nvarchar(4000) NULL, [INVOICEHASH] nvarchar(4000) NULL, [PREVIOUSHASH] nvarchar(4000) NULL, [EXMLNAME] nvarchar(500) NULL, [INVTYPE] nvarchar(500) NULL ); INSERT INTO dbo.[EDebitNote_New] ([EDebitNoteNo], [ESELLERNAME], [ESELLERVATNO], [ECustomerName], [ECUSTOMERVATNO], [EINVOICEDATE], [EINVOICETOTAL], [EVATTOTAL], [EUUINO], [QRCODE], [QRSTRING], [INVOICEHASH], [PREVIOUSHASH], [EXMLNAME], [INVTYPE]) SELECT [EDebitNoteNo], [ESELLERNAME], [ESELLERVATNO], [ECustomerName], [ECUSTOMERVATNO], [EINVOICEDATE], [EINVOICETOTAL], [EVATTOTAL], [EUUINO], [QRCODE], [QRSTRING], [INVOICEHASH], [PREVIOUSHASH], [EXMLNAME], [INVTYPE] FROM [EDebitNote]; DROP TABLE dbo.[EDebitNote]; EXEC sp_rename 'dbo.EDebitNote_New', 'EDebitNote'; GO CREATE TABLE [dbo].[EInvoice_New] ( [EInvoiceId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EInvNO] nvarchar(500) NULL, [ESELLERNAME] nvarchar(2000) NULL, [ESELLERVATNO] nvarchar(500) NULL, [ECustomerName] nvarchar(2000) NULL, [ECUSTOMERVATNO] nvarchar(500) NULL, [EINVOICEDATE] datetime NULL, [EINVOICETOTAL] decimal(18, 4) NULL, [EVATTOTAL] decimal(18, 4) NULL, [EUUINO] nvarchar(500) NULL, [QRCODE] image NULL, [QRSTRING] nvarchar(4000) NULL, [INVOICEHASH] nvarchar(4000) NULL, [PREVIOUSHASH] nvarchar(4000) NULL, [EXMLNAME] nvarchar(500) NULL, [INVTYPE] nvarchar(500) NULL ); INSERT INTO dbo.[EInvoice_New] ([EInvNO], [ESELLERNAME], [ESELLERVATNO], [ECustomerName], [ECUSTOMERVATNO], [EINVOICEDATE], [EINVOICETOTAL], [EVATTOTAL], [EUUINO], [QRCODE], [QRSTRING], [INVOICEHASH], [PREVIOUSHASH], [EXMLNAME], [INVTYPE]) SELECT [EInvNO], [ESELLERNAME], [ESELLERVATNO], [ECustomerName], [ECUSTOMERVATNO], [EINVOICEDATE], [EINVOICETOTAL], [EVATTOTAL], [EUUINO], [QRCODE], [QRSTRING], [INVOICEHASH], [PREVIOUSHASH], [EXMLNAME], [INVTYPE] FROM [EInvoice]; DROP TABLE dbo.[EInvoice]; EXEC sp_rename 'dbo.EInvoice_New', 'EInvoice'; GO CREATE TABLE [dbo].[EInvoiceReturn_New] ( [EInvoiceReturnId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EInvRetNO] nvarchar(500) NULL, [ESELLERNAME] nvarchar(2000) NULL, [ESELLERVATNO] nvarchar(500) NULL, [ECustomerName] nvarchar(2000) NULL, [ECUSTOMERVATNO] nvarchar(500) NULL, [EINVOICEDATE] datetime NULL, [EINVOICETOTAL] decimal(18, 4) NULL, [EVATTOTAL] decimal(18, 4) NULL, [EUUINO] nvarchar(500) NULL, [QRCODE] image NULL, [QRSTRING] nvarchar(4000) NULL, [INVOICEHASH] nvarchar(4000) NULL, [PREVIOUSHASH] nvarchar(4000) NULL, [EXMLNAME] nvarchar(500) NULL, [INVTYPE] nvarchar(500) NULL ); INSERT INTO dbo.[EInvoiceReturn_New] ([EInvRetNO], [ESELLERNAME], [ESELLERVATNO], [ECustomerName], [ECUSTOMERVATNO], [EINVOICEDATE], [EINVOICETOTAL], [EVATTOTAL], [EUUINO], [QRCODE], [QRSTRING], [INVOICEHASH], [PREVIOUSHASH], [EXMLNAME], [INVTYPE]) SELECT [EInvRetNO], [ESELLERNAME], [ESELLERVATNO], [ECustomerName], [ECUSTOMERVATNO], [EINVOICEDATE], [EINVOICETOTAL], [EVATTOTAL], [EUUINO], [QRCODE], [QRSTRING], [INVOICEHASH], [PREVIOUSHASH], [EXMLNAME], [INVTYPE] FROM [EInvoiceReturn]; DROP TABLE dbo.[EInvoiceReturn]; EXEC sp_rename 'dbo.EInvoiceReturn_New', 'EInvoiceReturn'; GO CREATE TABLE [dbo].[EmployeeADLeaveDetails_New] ( [EmployeeADLeaveDetailsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EmployeeID] varchar(50) NULL, [SLNO] int NULL, [fromdate] datetime NULL, [todate] datetime NULL, [leavedays] decimal(18, 4) NULL, [REMARKS] nvarchar(500) NULL ); INSERT INTO dbo.[EmployeeADLeaveDetails_New] ([EmployeeID], [SLNO], [fromdate], [todate], [leavedays], [REMARKS]) SELECT [EmployeeID], [SLNO], [fromdate], [todate], [leavedays], [REMARKS] FROM [EmployeeADLeaveDetails]; DROP TABLE dbo.[EmployeeADLeaveDetails]; EXEC sp_rename 'dbo.EmployeeADLeaveDetails_New', 'EmployeeADLeaveDetails'; GO CREATE TABLE [dbo].[EmployeeMaster_New] ( [EmployeeMasterId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EmployeeID] nvarchar(500) NULL, [EmpName] nvarchar(500) NULL, [Title] nvarchar(500) NULL, [IqamaNo] nvarchar(500) NULL, [Nationality] nvarchar(500) NULL, [IqamaExpiryDate] datetime NULL, [PassportNo] nvarchar(500) NULL, [PassportExpiry] datetime NULL, [IqamaExpiryDateArabic] datetime NULL, [PassPortArabicExpire] datetime NULL, [LicenceNo] nvarchar(500) NULL, [LicenceExpire] datetime NULL, [LicenceArabicExpire] datetime NULL, [mobileno] nvarchar(500) NULL, [Basic] decimal(18, 4) NULL, [BloodGroup] nvarchar(500) NULL, [JoiningDate] datetime NULL, [Photo] image NULL, [HealthInsNo] nvarchar(500) NULL, [HealthInsArabicExpire] datetime NULL, [HealthInsExpire] datetime NULL, [ibanno] nvarchar(500) NULL, [bankcode] nvarchar(500) NULL, [shortname] nvarchar(500) NULL, [DOB] datetime NULL, [HealthCardNo] nvarchar(500) NULL, [HealthCardExpDate] datetime NULL, [LeavePerYear] decimal(18, 4) NULL, [agreement] nvarchar(500) NULL, [agreementstartdate] datetime NULL, [agreementEnddate] datetime NULL, [DriverCard] nvarchar(500) NULL, [DrivercardIssueDate] datetime NULL, [DrivercardExpiryDate] datetime NULL, [Otherallow] decimal(18, 4) NULL, [deptcode] nvarchar(500) NULL, [deptname] nvarchar(500) NULL, [FoodAcco] decimal(18, 4) NULL, [Transport] decimal(18, 4) NULL, [Target] decimal(18, 4) NULL, [FoodAllowance] decimal(18, 4) NULL, [TravelAllowance] decimal(18, 4) NULL, [OtherAllowance] decimal(18, 4) NULL, [EmployeeStatus] nvarchar(100) NULL, [RegularHour] decimal(18, 4) NULL, [CostPerHour] decimal(18, 4) NULL, [OverTime] decimal(18, 4) NULL, [CostPerOT] decimal(18, 4) NULL, [ThirdPartyId] nvarchar(500) NULL, [PortID] nvarchar(500) NULL, [OtherId] nvarchar(500) NULL, [AramcoIdDate] datetime NULL, [ThirdPartyIdDate] datetime NULL, [PortIdDate] datetime NULL, [OtherIdDate] datetime NULL, [Emptype] nvarchar(500) NULL, [PhotoAramco] image NULL, [PhotoPortId] image NULL, [PhotoThirdPartyId] image NULL, [PhotoOtherId] image NULL, [PhotoAgreement] image NULL, [PhotoIqama] image NULL, [PhotoPassportPage1] image NULL, [PhotoPassportPage2] image NULL, [PhotoVisaCopy] image NULL, [PhotoDrivingLicence] image NULL, [AramcoIdFileName] nvarchar(500) NULL, [PortIdFileName] nvarchar(500) NULL, [ThirdPartyIdFileName] nvarchar(500) NULL, [OtherIdFileName] nvarchar(500) NULL, [AgreementFileName] nvarchar(500) NULL, [IqamaFileName] nvarchar(500) NULL, [PassportPage1FileName] nvarchar(500) NULL, [PassportPage2FileName] nvarchar(500) NULL, [VisaCopyFileName] nvarchar(500) NULL, [DrivingLicenseFileName] nvarchar(500) NULL, [AramcoId] nvarchar(500) NULL, [BankName] nvarchar(500) NULL, [SUPPLIERCODE] nvarchar(500) NULL, [Suppliername] nvarchar(500) NULL, [fat] nvarchar(500) NULL, [projectcode] nvarchar(500) NULL, [projectname] nvarchar(500) NULL, [StatusCode] nvarchar(500) NULL, [StatusName] nvarchar(500) NULL ); INSERT INTO dbo.[EmployeeMaster_New] ([EmployeeID], [EmpName], [Title], [IqamaNo], [Nationality], [IqamaExpiryDate], [PassportNo], [PassportExpiry], [IqamaExpiryDateArabic], [PassPortArabicExpire], [LicenceNo], [LicenceExpire], [LicenceArabicExpire], [mobileno], [Basic], [BloodGroup], [JoiningDate], [Photo], [HealthInsNo], [HealthInsArabicExpire], [HealthInsExpire], [ibanno], [bankcode], [shortname], [DOB], [HealthCardNo], [HealthCardExpDate], [LeavePerYear], [agreement], [agreementstartdate], [agreementEnddate], [DriverCard], [DrivercardIssueDate], [DrivercardExpiryDate], [Otherallow], [deptcode], [deptname], [FoodAcco], [Transport], [Target], [FoodAllowance], [TravelAllowance], [OtherAllowance], [EmployeeStatus], [RegularHour], [CostPerHour], [OverTime], [CostPerOT], [ThirdPartyId], [PortID], [OtherId], [AramcoIdDate], [ThirdPartyIdDate], [PortIdDate], [OtherIdDate], [Emptype], [PhotoAramco], [PhotoPortId], [PhotoThirdPartyId], [PhotoOtherId], [PhotoAgreement], [PhotoIqama], [PhotoPassportPage1], [PhotoPassportPage2], [PhotoVisaCopy], [PhotoDrivingLicence], [AramcoIdFileName], [PortIdFileName], [ThirdPartyIdFileName], [OtherIdFileName], [AgreementFileName], [IqamaFileName], [PassportPage1FileName], [PassportPage2FileName], [VisaCopyFileName], [DrivingLicenseFileName], [AramcoId], [BankName], [SUPPLIERCODE], [Suppliername], [fat], [projectcode], [projectname], [StatusCode], [StatusName]) SELECT [EmployeeID], [EmpName], [Title], [IqamaNo], [Nationality], [IqamaExpiryDate], [PassportNo], [PassportExpiry], [IqamaExpiryDateArabic], [PassPortArabicExpire], [LicenceNo], [LicenceExpire], [LicenceArabicExpire], [mobileno], [Basic], [BloodGroup], [JoiningDate], [Photo], [HealthInsNo], [HealthInsArabicExpire], [HealthInsExpire], [ibanno], [bankcode], [shortname], [DOB], [HealthCardNo], [HealthCardExpDate], [LeavePerYear], [agreement], [agreementstartdate], [agreementEnddate], [DriverCard], [DrivercardIssueDate], [DrivercardExpiryDate], [Otherallow], [deptcode], [deptname], [FoodAcco], [Transport], [Target], [FoodAllowance], [TravelAllowance], [OtherAllowance], [EmployeeStatus], [RegularHour], [CostPerHour], [OverTime], [CostPerOT], [ThirdPartyId], [PortID], [OtherId], [AramcoIdDate], [ThirdPartyIdDate], [PortIdDate], [OtherIdDate], [Emptype], [PhotoAramco], [PhotoPortId], [PhotoThirdPartyId], [PhotoOtherId], [PhotoAgreement], [PhotoIqama], [PhotoPassportPage1], [PhotoPassportPage2], [PhotoVisaCopy], [PhotoDrivingLicence], [AramcoIdFileName], [PortIdFileName], [ThirdPartyIdFileName], [OtherIdFileName], [AgreementFileName], [IqamaFileName], [PassportPage1FileName], [PassportPage2FileName], [VisaCopyFileName], [DrivingLicenseFileName], [AramcoId], [BankName], [SUPPLIERCODE], [Suppliername], [fat], [projectcode], [projectname], [StatusCode], [StatusName] FROM [EmployeeMaster]; DROP TABLE dbo.[EmployeeMaster]; EXEC sp_rename 'dbo.EmployeeMaster_New', 'EmployeeMaster'; GO CREATE TABLE [dbo].[EmployeeMobilizationEntryDetails_New] ( [EmployeeMobilizationEntryDetailsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [DocNo] nvarchar(500) NULL, [EntryDate] datetime NULL, [RefNo] nvarchar(500) NULL, [slno] nvarchar(50) NULL, [EmployeeCode] nvarchar(2000) NULL, [EmployeeName] nvarchar(2000) NULL, [Designation] nvarchar(2000) NULL, [SiteDesignation] nvarchar(2000) NULL, [BRANCHNAME] nvarchar(2000) NULL ); INSERT INTO dbo.[EmployeeMobilizationEntryDetails_New] ([DocNo], [EntryDate], [RefNo], [slno], [EmployeeCode], [EmployeeName], [Designation], [SiteDesignation], [BRANCHNAME]) SELECT [DocNo], [EntryDate], [RefNo], [slno], [EmployeeCode], [EmployeeName], [Designation], [SiteDesignation], [BRANCHNAME] FROM [EmployeeMobilizationEntryDetails]; DROP TABLE dbo.[EmployeeMobilizationEntryDetails]; EXEC sp_rename 'dbo.EmployeeMobilizationEntryDetails_New', 'EmployeeMobilizationEntryDetails'; GO CREATE TABLE [dbo].[EmployeeVacationDetails_New] ( [EmployeeVacationDetailsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EmployeeID] varchar(50) NULL, [SLNO] int NULL, [VacationDate] datetime NULL, [RejoingDate] datetime NULL, [Remarks] nvarchar(100) NULL ); INSERT INTO dbo.[EmployeeVacationDetails_New] ([EmployeeID], [SLNO], [VacationDate], [RejoingDate], [Remarks]) SELECT [EmployeeID], [SLNO], [VacationDate], [RejoingDate], [Remarks] FROM [EmployeeVacationDetails]; DROP TABLE dbo.[EmployeeVacationDetails]; EXEC sp_rename 'dbo.EmployeeVacationDetails_New', 'EmployeeVacationDetails'; GO CREATE TABLE [dbo].[EnquiryRegistration_New] ( [EnquiryRegistrationId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [RefNo] nvarchar(50) NULL, [RFQNo] nvarchar(500) NULL, [RFQDate] datetime NULL, [CustomerCode] nvarchar(500) NULL, [CustomerName] nvarchar(2000) NULL, [Contact] nvarchar(500) NULL, [Address] nvarchar(2000) NULL, [Telephone] nvarchar(500) NULL, [Fax] nvarchar(500) NULL, [SalesMan] nvarchar(2000) NULL, [Remarks] nvarchar(2000) NULL, [Status] nvarchar(500) NULL, [Stage] nvarchar(500) NULL, [Flag] nvarchar(500) NULL, [Username] nvarchar(500) NULL, [Mobile] nvarchar(500) NULL, [Vatno] nvarchar(200) NULL ); INSERT INTO dbo.[EnquiryRegistration_New] ([EntryDate], [RefNo], [RFQNo], [RFQDate], [CustomerCode], [CustomerName], [Contact], [Address], [Telephone], [Fax], [SalesMan], [Remarks], [Status], [Stage], [Flag], [Username], [Mobile], [Vatno]) SELECT [EntryDate], [RefNo], [RFQNo], [RFQDate], [CustomerCode], [CustomerName], [Contact], [Address], [Telephone], [Fax], [SalesMan], [Remarks], [Status], [Stage], [Flag], [Username], [Mobile], [Vatno] FROM [EnquiryRegistration]; DROP TABLE dbo.[EnquiryRegistration]; EXEC sp_rename 'dbo.EnquiryRegistration_New', 'EnquiryRegistration'; GO CREATE TABLE [dbo].[EnquiryRegistrationDetails_New] ( [EnquiryRegistrationDetailsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [ItemCode] nvarchar(500) NULL, [ItemName] nvarchar(2000) NULL, [Qty] decimal(18, 4) NULL, [Unit] nvarchar(500) NULL, [Slno] int NULL, [Status] char NULL, [RefNo] nvarchar(500) NULL, [PartNo] nvarchar(2000) NULL, [storeshop] nvarchar(500) NULL ); INSERT INTO dbo.[EnquiryRegistrationDetails_New] ([ItemCode], [ItemName], [Qty], [Unit], [Slno], [Status], [RefNo], [PartNo], [storeshop]) SELECT [ItemCode], [ItemName], [Qty], [Unit], [Slno], [Status], [RefNo], [PartNo], [storeshop] FROM [EnquiryRegistrationDetails]; DROP TABLE dbo.[EnquiryRegistrationDetails]; EXEC sp_rename 'dbo.EnquiryRegistrationDetails_New', 'EnquiryRegistrationDetails'; GO CREATE TABLE [dbo].[FinalProduct_New] ( [FinalProductId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [idFinalProductID] uniqueidentifier NULL, [EntryDate] datetime NULL, [DocNo] nvarchar(50) NULL, [EnterdBy] nvarchar(2000) NULL, [ItemCode] nvarchar(50) NULL, [ItemName] nvarchar(2000) NULL, [Rate] decimal(18, 4) NULL, [Qty] decimal(18, 4) NULL, [Amt] decimal(18, 4) NULL, [Unit] nvarchar(50) NULL, [CustCode] nvarchar(500) NULL, [CustName] nvarchar(2000) NULL ); INSERT INTO dbo.[FinalProduct_New] ([idFinalProductID], [EntryDate], [DocNo], [EnterdBy], [ItemCode], [ItemName], [Rate], [Qty], [Amt], [Unit], [CustCode], [CustName]) SELECT [idFinalProductID], [EntryDate], [DocNo], [EnterdBy], [ItemCode], [ItemName], [Rate], [Qty], [Amt], [Unit], [CustCode], [CustName] FROM [FinalProduct]; DROP TABLE dbo.[FinalProduct]; EXEC sp_rename 'dbo.FinalProduct_New', 'FinalProduct'; GO CREATE TABLE [dbo].[FinalProductItem_New] ( [FinalProductItemId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [id] uniqueidentifier NULL, [idFinalProductID] uniqueidentifier NULL, [EntryDate] datetime NULL, [SlNo] int NULL, [DocNo] nvarchar(50) NULL, [ItemCode] nvarchar(500) NULL, [ItemName] nvarchar(2000) NULL, [Rate] decimal(18, 4) NULL, [Qty] decimal(18, 4) NULL, [Amt] decimal(18, 4) NULL, [Unit] nvarchar(500) NULL ); INSERT INTO dbo.[FinalProductItem_New] ([id], [idFinalProductID], [EntryDate], [SlNo], [DocNo], [ItemCode], [ItemName], [Rate], [Qty], [Amt], [Unit]) SELECT [id], [idFinalProductID], [EntryDate], [SlNo], [DocNo], [ItemCode], [ItemName], [Rate], [Qty], [Amt], [Unit] FROM [FinalProductItem]; DROP TABLE dbo.[FinalProductItem]; EXEC sp_rename 'dbo.FinalProductItem_New', 'FinalProductItem'; GO CREATE TABLE [dbo].[FinancialYear_New] ( [FinancialYearId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [RefNo] int NULL, [FromDate] datetime NULL, [ToDate] datetime NULL, [Status] nvarchar(500) NULL, [Year] datetime NULL ); INSERT INTO dbo.[FinancialYear_New] ([RefNo], [FromDate], [ToDate], [Status], [Year]) SELECT [RefNo], [FromDate], [ToDate], [Status], [Year] FROM [FinancialYear]; DROP TABLE dbo.[FinancialYear]; EXEC sp_rename 'dbo.FinancialYear_New', 'FinancialYear'; GO CREATE TABLE [dbo].[GenLedger no need_New] ( [GenLedger no needId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Branch] nvarchar(500) NULL, [EntryDate] datetime NULL, [VoucherNo] nvarchar(500) NULL, [RefNo] nvarchar(500) NULL, [AcCode] nvarchar(500) NULL, [Amount] decimal(18, 4) NULL, [Narration] nvarchar(2000) NULL, [SalesMan] nvarchar(2000) NULL, [Type] nvarchar(500) NULL ); INSERT INTO dbo.[GenLedger no need_New] ([Branch], [EntryDate], [VoucherNo], [RefNo], [AcCode], [Amount], [Narration], [SalesMan], [Type]) SELECT [Branch], [EntryDate], [VoucherNo], [RefNo], [AcCode], [Amount], [Narration], [SalesMan], [Type] FROM [GenLedger no need]; DROP TABLE dbo.[GenLedger no need]; EXEC sp_rename 'dbo.GenLedger no need_New', 'GenLedger no need'; GO CREATE TABLE [dbo].[GenLedgerReport_New] ( [GenLedgerReportId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [AcCode] nvarchar(500) NULL, [Amt] decimal(18, 4) NULL ); INSERT INTO dbo.[GenLedgerReport_New] ([AcCode], [Amt]) SELECT [AcCode], [Amt] FROM [GenLedgerReport]; DROP TABLE dbo.[GenLedgerReport]; EXEC sp_rename 'dbo.GenLedgerReport_New', 'GenLedgerReport'; GO CREATE TABLE [dbo].[GetStock_New] ( [GetStockId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [SUMQTY] decimal(18, 4) NULL, [ITEMCODE] nvarchar(500) NULL ); INSERT INTO dbo.[GetStock_New] ([SUMQTY], [ITEMCODE]) SELECT [SUMQTY], [ITEMCODE] FROM [GetStock]; DROP TABLE dbo.[GetStock]; EXEC sp_rename 'dbo.GetStock_New', 'GetStock'; GO CREATE TABLE [dbo].[GoodsReceipt_New] ( [GoodsReceiptId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [BillType] nvarchar(500) NULL, [DocumentNo] nvarchar(500) NULL, [InvoiceNo] nvarchar(500) NULL, [RefNo] nvarchar(500) NULL, [PONo] nvarchar(500) NULL, [InvoiceDate] datetime NULL, [SupplierCode] nvarchar(500) NULL, [SupplierName] nvarchar(2000) NULL, [Address] nvarchar(2000) NULL, [GrossAmount] decimal(18, 4) NULL, [Freight] decimal(18, 4) NULL, [Commission] decimal(18, 4) NULL, [UnLoading] decimal(18, 4) NULL, [Others] decimal(18, 4) NULL, [Discount] decimal(18, 4) NULL, [NetAmount] decimal(18, 4) NULL, [KeyFld] decimal(18, 4) NULL, [PR] nvarchar(500) NULL, [Currency] nvarchar(500) NULL, [ExchangeRate] decimal(18, 4) NULL, [Flag] char NULL, [AcCode] nvarchar(500) NULL, [ReceivedAmount] decimal(18, 4) NULL, [UserName] nvarchar(500) NULL, [Attended] nvarchar(2000) NULL, [PurchaseRet] nvarchar(2000) NULL, [Narration] nvarchar(2000) NULL, [VoucherNo] nvarchar(500) NULL, [purType] nvarchar(500) NULL, [Status] nvarchar(500) NULL, [DLRgross] decimal(18, 4) NULL, [DLRnet] decimal(18, 4) NULL, [Deleted] nvarchar(500) NULL, [Mobile] nvarchar(500) NULL, [vattotal] decimal(18, 4) NULL, [vatno] nvarchar(200) NULL, [PaymentNo] nvarchar(50) NULL, [ACNAME] nvarchar(250) NULL, [LESS] decimal(18, 4) NULL, [PurchaseInvNo] nvarchar(500) NULL, [SupInvNo] nvarchar(500) NULL, [STATUSCHK] int NULL, [NETDISC] decimal(18, 4) NULL, [DISCPER] decimal(18, 4) NULL, [DELIVERYNOTENO] nvarchar(100) NULL ); INSERT INTO dbo.[GoodsReceipt_New] ([EntryDate], [BillType], [DocumentNo], [InvoiceNo], [RefNo], [PONo], [InvoiceDate], [SupplierCode], [SupplierName], [Address], [GrossAmount], [Freight], [Commission], [UnLoading], [Others], [Discount], [NetAmount], [KeyFld], [PR], [Currency], [ExchangeRate], [Flag], [AcCode], [ReceivedAmount], [UserName], [Attended], [PurchaseRet], [Narration], [VoucherNo], [purType], [Status], [DLRgross], [DLRnet], [Deleted], [Mobile], [vattotal], [vatno], [PaymentNo], [ACNAME], [LESS], [PurchaseInvNo], [SupInvNo], [STATUSCHK], [NETDISC], [DISCPER], [DELIVERYNOTENO]) SELECT [EntryDate], [BillType], [DocumentNo], [InvoiceNo], [RefNo], [PONo], [InvoiceDate], [SupplierCode], [SupplierName], [Address], [GrossAmount], [Freight], [Commission], [UnLoading], [Others], [Discount], [NetAmount], [KeyFld], [PR], [Currency], [ExchangeRate], [Flag], [AcCode], [ReceivedAmount], [UserName], [Attended], [PurchaseRet], [Narration], [VoucherNo], [purType], [Status], [DLRgross], [DLRnet], [Deleted], [Mobile], [vattotal], [vatno], [PaymentNo], [ACNAME], [LESS], [PurchaseInvNo], [SupInvNo], [STATUSCHK], [NETDISC], [DISCPER], [DELIVERYNOTENO] FROM [GoodsReceipt]; DROP TABLE dbo.[GoodsReceipt]; EXEC sp_rename 'dbo.GoodsReceipt_New', 'GoodsReceipt'; GO CREATE TABLE [dbo].[GoodsReceiptItem_New] ( [GoodsReceiptItemId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [ItemCode] nvarchar(500) NULL, [ItemName] nvarchar(2000) NULL, [Unit] nvarchar(50) NULL, [Qty] decimal(18, 4) NULL, [Damage] decimal(18, 4) NULL, [Rate] decimal(18, 4) NULL, [Amount] decimal(18, 4) NULL, [KeyFld] decimal(18, 4) NULL, [EntryDate] datetime NULL, [PR] nvarchar(500) NULL, [SlNo] decimal(18, 4) NULL, [username] nvarchar(500) NULL, [DocumentNo] nvarchar(500) NULL, [InvoiceNo] nvarchar(500) NULL, [PurchaseRet] nvarchar(500) NULL, [PQTY] decimal(18, 4) NULL, [RateAfterDisc] decimal(18, 4) NULL, [SalesRate] decimal(18, 4) NULL, [QtyPerUnit] decimal(18, 4) NULL, [conrate] decimal(18, 4) NULL, [Deleted] nvarchar(500) NULL, [RateAfterexp] decimal(18, 4) NULL, [VATPER] decimal(18, 4) NULL, [VATAMT] decimal(18, 4) NULL, [PartNo] nvarchar(2000) NULL, [FRATE] decimal(18, 4) NULL, [PCRATE] decimal(18, 4) NULL, [Disc] decimal(18, 4) NULL, [DisconRate] decimal(18, 4) NULL, [STATUSCHK] int NULL, [DISCONINCRATE] decimal(18, 4) NULL, [storeshop] nvarchar(500) NULL ); INSERT INTO dbo.[GoodsReceiptItem_New] ([ItemCode], [ItemName], [Unit], [Qty], [Damage], [Rate], [Amount], [KeyFld], [EntryDate], [PR], [SlNo], [username], [DocumentNo], [InvoiceNo], [PurchaseRet], [PQTY], [RateAfterDisc], [SalesRate], [QtyPerUnit], [conrate], [Deleted], [RateAfterexp], [VATPER], [VATAMT], [PartNo], [FRATE], [PCRATE], [Disc], [DisconRate], [STATUSCHK], [DISCONINCRATE], [storeshop]) SELECT [ItemCode], [ItemName], [Unit], [Qty], [Damage], [Rate], [Amount], [KeyFld], [EntryDate], [PR], [SlNo], [username], [DocumentNo], [InvoiceNo], [PurchaseRet], [PQTY], [RateAfterDisc], [SalesRate], [QtyPerUnit], [conrate], [Deleted], [RateAfterexp], [VATPER], [VATAMT], [PartNo], [FRATE], [PCRATE], [Disc], [DisconRate], [STATUSCHK], [DISCONINCRATE], [storeshop] FROM [GoodsReceiptItem]; DROP TABLE dbo.[GoodsReceiptItem]; EXEC sp_rename 'dbo.GoodsReceiptItem_New', 'GoodsReceiptItem'; GO CREATE TABLE [dbo].[IncomeStatement_New] ( [IncomeStatementId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [AccountCode] nvarchar(500) NULL, [AccountName] nvarchar(2000) NULL, [Type] nvarchar(500) NULL, [AccountHead] nvarchar(2000) NULL, [AcGroup] nvarchar(2000) NULL, [Debit] decimal(18, 4) NULL, [Credit] decimal(18, 4) NULL ); INSERT INTO dbo.[IncomeStatement_New] ([AccountCode], [AccountName], [Type], [AccountHead], [AcGroup], [Debit], [Credit]) SELECT [AccountCode], [AccountName], [Type], [AccountHead], [AcGroup], [Debit], [Credit] FROM [IncomeStatement]; DROP TABLE dbo.[IncomeStatement]; EXEC sp_rename 'dbo.IncomeStatement_New', 'IncomeStatement'; GO CREATE TABLE [dbo].[Infouser_New] ( [InfouserId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [code] nvarchar(500) NULL, [name] nvarchar(2000) NULL, [password] nvarchar(500) NULL, [permissions] decimal(18, 4) NULL, [type] nvarchar(500) NULL, [ID] char NULL, [TVisibility] nvarchar(500) NULL, [Tupdate] nvarchar(500) NULL, [Tcancel] nvarchar(500) NULL, [AVisibility] nvarchar(500) NULL, [Aupdate] nvarchar(500) NULL, [Acancel] nvarchar(500) NULL, [MVisibility] nvarchar(500) NULL, [Mupdate] nvarchar(500) NULL, [Mcancel] nvarchar(500) NULL, [QVisibility] nvarchar(500) NULL, [Qupdate] nvarchar(500) NULL, [Qcancel] nvarchar(500) NULL, [UVisibility] nvarchar(500) NULL, [RVisibility] nvarchar(500) NULL, [QtyChecking] nvarchar(500) NULL, [InvChecking] nvarchar(500) NULL, [Itemcost] decimal(18, 4) NULL, [MinSalRateChecking] nvarchar(500) NULL ); INSERT INTO dbo.[Infouser_New] ([code], [name], [password], [permissions], [type], [ID], [TVisibility], [Tupdate], [Tcancel], [AVisibility], [Aupdate], [Acancel], [MVisibility], [Mupdate], [Mcancel], [QVisibility], [Qupdate], [Qcancel], [UVisibility], [RVisibility], [QtyChecking], [InvChecking], [Itemcost], [MinSalRateChecking]) SELECT [code], [name], [password], [permissions], [type], [ID], [TVisibility], [Tupdate], [Tcancel], [AVisibility], [Aupdate], [Acancel], [MVisibility], [Mupdate], [Mcancel], [QVisibility], [Qupdate], [Qcancel], [UVisibility], [RVisibility], [QtyChecking], [InvChecking], [Itemcost], [MinSalRateChecking] FROM [Infouser]; DROP TABLE dbo.[Infouser]; EXEC sp_rename 'dbo.Infouser_New', 'Infouser'; GO CREATE TABLE [dbo].[IntegrationInfo_New] ( [IntegrationInfoId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Code] nvarchar(4000) NULL, [SysName] nvarchar(4000) NULL, [AuthStatus] nvarchar(500) NULL ); INSERT INTO dbo.[IntegrationInfo_New] ([Code], [SysName], [AuthStatus]) SELECT [Code], [SysName], [AuthStatus] FROM [IntegrationInfo]; DROP TABLE dbo.[IntegrationInfo]; EXEC sp_rename 'dbo.IntegrationInfo_New', 'IntegrationInfo'; GO CREATE TABLE [dbo].[InternalMaterialTrans_New] ( [InternalMaterialTransId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Branch] nvarchar(15) NULL, [EntryDate] datetime NULL, [InvNo] nvarchar(500) NULL, [ReturnInvoiceNo] nvarchar(500) NULL, [BillType] nvarchar(500) NULL, [RefNo] nvarchar(500) NULL, [PONo] nvarchar(500) NULL, [CustomerCode] nvarchar(500) NULL, [CustomerName] nvarchar(2000) NULL, [Address] nvarchar(2000) NULL, [Phone] nvarchar(500) NULL, [Fax] nvarchar(500) NULL, [Attended] nvarchar(2000) NULL, [GrossAmount] decimal(18, 4) NULL, [LessPerc] decimal(18, 4) NULL, [LessAmount] decimal(18, 4) NULL, [NetAmount] decimal(18, 4) NULL, [SR] nvarchar(500) NULL, [Received] decimal(18, 4) NULL, [DnNo] nvarchar(500) NULL, [QuotNo] nvarchar(500) NULL, [Flag] char NULL, [CreditPeriod] nvarchar(500) NULL, [ReceivedAmount] decimal(18, 4) NULL, [UserName] nvarchar(500) NULL, [InvoiceRetNo] decimal(18, 4) NULL, [ReceivedAmt] decimal(18, 4) NULL, [ChangeAmount] decimal(18, 4) NULL, [InvoiceDate] datetime NULL, [Narration] nvarchar(2000) NULL, [voucherNo] nvarchar(500) NULL, [fromstorecode] nvarchar(500) NULL, [fromstore] nvarchar(500) NULL, [Remarks] nvarchar(500) NULL, [AddLess] decimal(18, 4) NULL, [tostorecode] nvarchar(500) NULL, [tostore] nvarchar(500) NULL, [MatOutNo] nvarchar(100) NULL ); INSERT INTO dbo.[InternalMaterialTrans_New] ([Branch], [EntryDate], [InvNo], [ReturnInvoiceNo], [BillType], [RefNo], [PONo], [CustomerCode], [CustomerName], [Address], [Phone], [Fax], [Attended], [GrossAmount], [LessPerc], [LessAmount], [NetAmount], [SR], [Received], [DnNo], [QuotNo], [Flag], [CreditPeriod], [ReceivedAmount], [UserName], [InvoiceRetNo], [ReceivedAmt], [ChangeAmount], [InvoiceDate], [Narration], [voucherNo], [fromstorecode], [fromstore], [Remarks], [AddLess], [tostorecode], [tostore], [MatOutNo]) SELECT [Branch], [EntryDate], [InvNo], [ReturnInvoiceNo], [BillType], [RefNo], [PONo], [CustomerCode], [CustomerName], [Address], [Phone], [Fax], [Attended], [GrossAmount], [LessPerc], [LessAmount], [NetAmount], [SR], [Received], [DnNo], [QuotNo], [Flag], [CreditPeriod], [ReceivedAmount], [UserName], [InvoiceRetNo], [ReceivedAmt], [ChangeAmount], [InvoiceDate], [Narration], [voucherNo], [fromstorecode], [fromstore], [Remarks], [AddLess], [tostorecode], [tostore], [MatOutNo] FROM [InternalMaterialTrans]; DROP TABLE dbo.[InternalMaterialTrans]; EXEC sp_rename 'dbo.InternalMaterialTrans_New', 'InternalMaterialTrans'; GO CREATE TABLE [dbo].[InternalMaterialTransDetails_New] ( [InternalMaterialTransDetailsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Branch] nvarchar(15) NULL, [EntryDate] datetime NULL, [ItemCode] nvarchar(500) NULL, [ItemName] nvarchar(2000) NULL, [Damage] decimal(18, 4) NULL, [Unit] nvarchar(500) NULL, [Qty] decimal(18, 4) NULL, [Rate] decimal(18, 4) NULL, [Amount] decimal(18, 4) NULL, [SR] nvarchar(500) NULL, [SlNo] decimal(18, 4) NULL, [Cost] decimal(18, 4) NULL, [InvoiceRetNo] nvarchar(500) NULL, [InvoiceDate] datetime NULL, [DocumentNo] nvarchar(500) NULL, [InvNo] nvarchar(500) NULL, [SQTY] decimal(18, 4) NULL, [Sales] decimal(18, 4) NULL, [Stock] decimal(18, 4) NULL, [purrate] decimal(18, 4) NULL, [SALESRATE] decimal(18, 4) NULL, [MatOutNo] nvarchar(500) NULL, [qtyperunit] decimal(18, 4) NULL, [storeshop] nvarchar(500) NULL ); INSERT INTO dbo.[InternalMaterialTransDetails_New] ([Branch], [EntryDate], [ItemCode], [ItemName], [Damage], [Unit], [Qty], [Rate], [Amount], [SR], [SlNo], [Cost], [InvoiceRetNo], [InvoiceDate], [DocumentNo], [InvNo], [SQTY], [Sales], [Stock], [purrate], [SALESRATE], [MatOutNo], [qtyperunit], [storeshop]) SELECT [Branch], [EntryDate], [ItemCode], [ItemName], [Damage], [Unit], [Qty], [Rate], [Amount], [SR], [SlNo], [Cost], [InvoiceRetNo], [InvoiceDate], [DocumentNo], [InvNo], [SQTY], [Sales], [Stock], [purrate], [SALESRATE], [MatOutNo], [qtyperunit], [storeshop] FROM [InternalMaterialTransDetails]; DROP TABLE dbo.[InternalMaterialTransDetails]; EXEC sp_rename 'dbo.InternalMaterialTransDetails_New', 'InternalMaterialTransDetails'; GO CREATE TABLE [dbo].[Invoice_New] ( [InvoiceId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Branch] nvarchar(500) NULL, [EntryDate] datetime NULL, [InvNo] nvarchar(500) NULL, [ReturnInvoiceNo] nvarchar(500) NULL, [BillType] nvarchar(500) NULL, [RefNo] nvarchar(500) NULL, [PONo] nvarchar(500) NULL, [CustomerCode] nvarchar(500) NULL, [CustomerName] nvarchar(2000) NULL, [Address] nvarchar(2000) NULL, [Phone] nvarchar(500) NULL, [Fax] nvarchar(500) NULL, [Attended] nvarchar(2000) NULL, [GrossAmount] decimal(18, 4) NULL, [LessPerc] decimal(18, 4) NULL, [LessAmount] decimal(18, 4) NULL, [NetAmount] decimal(18, 4) NULL, [SR] nvarchar(500) NULL, [AddLess] decimal(18, 4) NULL, [Remarks] nvarchar(2000) NULL, [Received] decimal(18, 4) NULL, [DnNo] nvarchar(150) NULL, [QuotNo] nvarchar(500) NULL, [Flag] char NULL, [CreditPeriod] nvarchar(500) NULL, [ReceivedAmount] decimal(18, 4) NULL, [UserName] nvarchar(500) NULL, [InvoiceRetNo] nvarchar(500) NULL, [ReceivedAmt] decimal(18, 4) NULL, [ChangeAmount] decimal(18, 4) NULL, [InvoiceDate] datetime NULL, [Narration] nvarchar(2000) NULL, [voucherNo] nvarchar(500) NULL, [Commision] decimal(18, 4) NULL, [Stock] decimal(18, 4) NULL, [Status] char NULL, [Bank1] nvarchar(500) NULL, [Bank2] nvarchar(500) NULL, [Bank3] nvarchar(500) NULL, [Bank4] nvarchar(500) NULL, [Del1] nvarchar(500) NULL, [Del2] nvarchar(500) NULL, [Del3] nvarchar(500) NULL, [Del4] nvarchar(500) NULL, [PODate] datetime NULL, [Freight] decimal(18, 4) NULL, [Retention] nvarchar(500) NULL, [DelDate] datetime NULL, [ProjectNo] nvarchar(500) NULL, [Deleted] char NULL, [AccountCode] nvarchar(500) NULL, [AccountName] nvarchar(2000) NULL, [ReceiptNo] nvarchar(500) NULL, [hijridate] datetime NULL, [Remarks1] nvarchar(2000) NULL, [Mobile] nvarchar(500) NULL, [TransApp] nvarchar(500) NULL, [vattotal] decimal(18, 4) NULL, [Vatno] nvarchar(200) NULL, [crdays] decimal(18, 4) NULL, [invdueDate] datetime NULL, [LOCCODE] nvarchar(500) NULL, [LOCNAME] nvarchar(2000) NULL, [bankcode] nvarchar(500) NULL, [bankname] nvarchar(2000) NULL, [bankamount] decimal(18, 4) NULL, [pinvno] nvarchar(500) NULL, [qrcode] image NULL, [InvType] nvarchar(500) NULL, [INVRETITEMTYPE] nvarchar(500) NULL, [NETDISC] decimal(18, 4) NULL, [invsubdetails] nvarchar(4000) NULL, [invsubstatus] nvarchar(400) NULL, [DebitNoteReason] nvarchar(500) NULL, [idtype] nvarchar(500) NULL, [Idno] nvarchar(500) NULL, [Detail1] nvarchar(2000) NULL, [Detail2] nvarchar(2000) NULL, [Detail3] nvarchar(2000) NULL, [Detail4] nvarchar(2000) NULL, [Detail5] nvarchar(2000) NULL, [Detail6] nvarchar(2000) NULL, [Detail7] nvarchar(2000) NULL, [Detail8] nvarchar(2000) NULL, [Detail9] nvarchar(2000) NULL, [Detail10] nvarchar(2000) NULL, [DetailDate1] datetime NULL, [DetailDate2] datetime NULL, [DetailDate3] datetime NULL, [DetailDate4] datetime NULL, [TRANSMODE] nvarchar(50) NULL, [FGROSS] decimal(18, 4) NULL, [FDISCOUNT] decimal(18, 4) NULL, [FGRSAFTDISC] decimal(18, 4) NULL, [FVATTOTAL] decimal(18, 4) NULL, [FNETAMOUNT] decimal(18, 4) NULL, [Farbicnumber] nvarchar(500) NULL, [Farabic] nvarchar(500) NULL, [CurrName] nvarchar(500) NULL, [CurrRate] decimal(18, 4) NULL, [DNPrefix] nvarchar(500) NULL, [CounterRecAmt] decimal(18, 4) NULL, [CounterBalAmt] decimal(18, 4) NULL, [RetentionPer] decimal(18, 4) NULL, [RetentionAmt] decimal(18, 4) NULL, [DueAfterRetention] decimal(18, 4) NULL, [RetentionDetails] nvarchar(500) NULL, [InvoiceOrderNo] nvarchar(500) NULL, [InvRemarks] nvarchar(500) NULL, [InvDelMode] nvarchar(500) NULL ); INSERT INTO dbo.[Invoice_New] ([Branch], [EntryDate], [InvNo], [ReturnInvoiceNo], [BillType], [RefNo], [PONo], [CustomerCode], [CustomerName], [Address], [Phone], [Fax], [Attended], [GrossAmount], [LessPerc], [LessAmount], [NetAmount], [SR], [AddLess], [Remarks], [Received], [DnNo], [QuotNo], [Flag], [CreditPeriod], [ReceivedAmount], [UserName], [InvoiceRetNo], [ReceivedAmt], [ChangeAmount], [InvoiceDate], [Narration], [voucherNo], [Commision], [Stock], [Status], [Bank1], [Bank2], [Bank3], [Bank4], [Del1], [Del2], [Del3], [Del4], [PODate], [Freight], [Retention], [DelDate], [ProjectNo], [Deleted], [AccountCode], [AccountName], [ReceiptNo], [hijridate], [Remarks1], [Mobile], [TransApp], [vattotal], [Vatno], [crdays], [invdueDate], [LOCCODE], [LOCNAME], [bankcode], [bankname], [bankamount], [pinvno], [qrcode], [InvType], [INVRETITEMTYPE], [NETDISC], [invsubdetails], [invsubstatus], [DebitNoteReason], [idtype], [Idno], [Detail1], [Detail2], [Detail3], [Detail4], [Detail5], [Detail6], [Detail7], [Detail8], [Detail9], [Detail10], [DetailDate1], [DetailDate2], [DetailDate3], [DetailDate4], [TRANSMODE], [FGROSS], [FDISCOUNT], [FGRSAFTDISC], [FVATTOTAL], [FNETAMOUNT], [Farbicnumber], [Farabic], [CurrName], [CurrRate], [DNPrefix], [CounterRecAmt], [CounterBalAmt], [RetentionPer], [RetentionAmt], [DueAfterRetention], [RetentionDetails], [InvoiceOrderNo], [InvRemarks], [InvDelMode]) SELECT [Branch], [EntryDate], [InvNo], [ReturnInvoiceNo], [BillType], [RefNo], [PONo], [CustomerCode], [CustomerName], [Address], [Phone], [Fax], [Attended], [GrossAmount], [LessPerc], [LessAmount], [NetAmount], [SR], [AddLess], [Remarks], [Received], [DnNo], [QuotNo], [Flag], [CreditPeriod], [ReceivedAmount], [UserName], [InvoiceRetNo], [ReceivedAmt], [ChangeAmount], [InvoiceDate], [Narration], [voucherNo], [Commision], [Stock], [Status], [Bank1], [Bank2], [Bank3], [Bank4], [Del1], [Del2], [Del3], [Del4], [PODate], [Freight], [Retention], [DelDate], [ProjectNo], [Deleted], [AccountCode], [AccountName], [ReceiptNo], [hijridate], [Remarks1], [Mobile], [TransApp], [vattotal], [Vatno], [crdays], [invdueDate], [LOCCODE], [LOCNAME], [bankcode], [bankname], [bankamount], [pinvno], [qrcode], [InvType], [INVRETITEMTYPE], [NETDISC], [invsubdetails], [invsubstatus], [DebitNoteReason], [idtype], [Idno], [Detail1], [Detail2], [Detail3], [Detail4], [Detail5], [Detail6], [Detail7], [Detail8], [Detail9], [Detail10], [DetailDate1], [DetailDate2], [DetailDate3], [DetailDate4], [TRANSMODE], [FGROSS], [FDISCOUNT], [FGRSAFTDISC], [FVATTOTAL], [FNETAMOUNT], [Farbicnumber], [Farabic], [CurrName], [CurrRate], [DNPrefix], [CounterRecAmt], [CounterBalAmt], [RetentionPer], [RetentionAmt], [DueAfterRetention], [RetentionDetails], [InvoiceOrderNo], [InvRemarks], [InvDelMode] FROM [Invoice]; DROP TABLE dbo.[Invoice]; EXEC sp_rename 'dbo.Invoice_New', 'Invoice'; GO CREATE TABLE [dbo].[InvoiceDebitNote_New] ( [InvoiceDebitNoteId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Branch] nvarchar(500) NULL, [EntryDate] datetime NULL, [InvNo] nvarchar(500) NULL, [DebitNoteNo] nvarchar(500) NULL, [BillType] nvarchar(500) NULL, [RefNo] nvarchar(500) NULL, [PONo] nvarchar(500) NULL, [CustomerCode] nvarchar(500) NULL, [CustomerName] nvarchar(2000) NULL, [Address] nvarchar(2000) NULL, [Phone] nvarchar(500) NULL, [Fax] nvarchar(500) NULL, [Attended] nvarchar(2000) NULL, [GrossAmount] decimal(18, 4) NULL, [LessPerc] decimal(18, 4) NULL, [LessAmount] decimal(18, 4) NULL, [NetAmount] decimal(18, 4) NULL, [SR] nvarchar(500) NULL, [AddLess] decimal(18, 4) NULL, [Remarks] nvarchar(2000) NULL, [Received] decimal(18, 4) NULL, [DnNo] nvarchar(150) NULL, [QuotNo] nvarchar(500) NULL, [Flag] char NULL, [CreditPeriod] nvarchar(500) NULL, [ReceivedAmount] decimal(18, 4) NULL, [UserName] nvarchar(500) NULL, [InvoiceRetNo] nvarchar(500) NULL, [ReceivedAmt] decimal(18, 4) NULL, [ChangeAmount] decimal(18, 4) NULL, [InvoiceDate] datetime NULL, [Narration] nvarchar(2000) NULL, [voucherNo] nvarchar(500) NULL, [Commision] decimal(18, 4) NULL, [Stock] decimal(18, 4) NULL, [Status] char NULL, [Bank1] nvarchar(500) NULL, [Bank2] nvarchar(500) NULL, [Bank3] nvarchar(500) NULL, [Bank4] nvarchar(500) NULL, [Del1] nvarchar(500) NULL, [Del2] nvarchar(500) NULL, [Del3] nvarchar(500) NULL, [Del4] nvarchar(500) NULL, [PODate] datetime NULL, [Freight] decimal(18, 4) NULL, [Retention] nvarchar(500) NULL, [DelDate] datetime NULL, [ProjectNo] nvarchar(500) NULL, [Deleted] char NULL, [AccountCode] nvarchar(500) NULL, [AccountName] nvarchar(2000) NULL, [ReceiptNo] nvarchar(500) NULL, [hijridate] datetime NULL, [Remarks1] nvarchar(2000) NULL, [Mobile] nvarchar(500) NULL, [TransApp] nvarchar(500) NULL, [vattotal] decimal(18, 4) NULL, [Vatno] nvarchar(200) NULL, [crdays] decimal(18, 4) NULL, [invdueDate] datetime NULL, [LOCCODE] nvarchar(500) NULL, [LOCNAME] nvarchar(2000) NULL, [bankcode] nvarchar(500) NULL, [bankname] nvarchar(2000) NULL, [bankamount] decimal(18, 4) NULL, [pinvno] nvarchar(500) NULL, [qrcode] image NULL, [INVTYPE] nvarchar(500) NULL, [INVRETITEMTYPE] nvarchar(500) NULL, [EXMLNAME] nvarchar(2000) NULL, [DebitNoteReason] nvarchar(500) NULL, [idtype] nvarchar(500) NULL, [Idno] nvarchar(500) NULL, [Detail1] nvarchar(2000) NULL, [Detail2] nvarchar(2000) NULL, [Detail3] nvarchar(2000) NULL, [Detail4] nvarchar(2000) NULL, [Detail5] nvarchar(2000) NULL, [Detail6] nvarchar(2000) NULL, [Detail7] nvarchar(2000) NULL, [Detail8] nvarchar(2000) NULL, [Detail9] nvarchar(2000) NULL, [Detail10] nvarchar(2000) NULL, [DetailDate1] datetime NULL, [DetailDate2] datetime NULL, [DetailDate3] datetime NULL, [DetailDate4] datetime NULL, [TRANSMODE] nvarchar(50) NULL, [FGROSS] decimal(18, 4) NULL, [FVATTOTAL] decimal(18, 4) NULL, [FNETAMOUNT] decimal(18, 4) NULL, [Farbicnumber] nvarchar(500) NULL, [Farabic] nvarchar(500) NULL, [CurrName] nvarchar(500) NULL, [CurrRate] decimal(18, 4) NULL ); INSERT INTO dbo.[InvoiceDebitNote_New] ([Branch], [EntryDate], [InvNo], [DebitNoteNo], [BillType], [RefNo], [PONo], [CustomerCode], [CustomerName], [Address], [Phone], [Fax], [Attended], [GrossAmount], [LessPerc], [LessAmount], [NetAmount], [SR], [AddLess], [Remarks], [Received], [DnNo], [QuotNo], [Flag], [CreditPeriod], [ReceivedAmount], [UserName], [InvoiceRetNo], [ReceivedAmt], [ChangeAmount], [InvoiceDate], [Narration], [voucherNo], [Commision], [Stock], [Status], [Bank1], [Bank2], [Bank3], [Bank4], [Del1], [Del2], [Del3], [Del4], [PODate], [Freight], [Retention], [DelDate], [ProjectNo], [Deleted], [AccountCode], [AccountName], [ReceiptNo], [hijridate], [Remarks1], [Mobile], [TransApp], [vattotal], [Vatno], [crdays], [invdueDate], [LOCCODE], [LOCNAME], [bankcode], [bankname], [bankamount], [pinvno], [qrcode], [INVTYPE], [INVRETITEMTYPE], [EXMLNAME], [DebitNoteReason], [idtype], [Idno], [Detail1], [Detail2], [Detail3], [Detail4], [Detail5], [Detail6], [Detail7], [Detail8], [Detail9], [Detail10], [DetailDate1], [DetailDate2], [DetailDate3], [DetailDate4], [TRANSMODE], [FGROSS], [FVATTOTAL], [FNETAMOUNT], [Farbicnumber], [Farabic], [CurrName], [CurrRate]) SELECT [Branch], [EntryDate], [InvNo], [DebitNoteNo], [BillType], [RefNo], [PONo], [CustomerCode], [CustomerName], [Address], [Phone], [Fax], [Attended], [GrossAmount], [LessPerc], [LessAmount], [NetAmount], [SR], [AddLess], [Remarks], [Received], [DnNo], [QuotNo], [Flag], [CreditPeriod], [ReceivedAmount], [UserName], [InvoiceRetNo], [ReceivedAmt], [ChangeAmount], [InvoiceDate], [Narration], [voucherNo], [Commision], [Stock], [Status], [Bank1], [Bank2], [Bank3], [Bank4], [Del1], [Del2], [Del3], [Del4], [PODate], [Freight], [Retention], [DelDate], [ProjectNo], [Deleted], [AccountCode], [AccountName], [ReceiptNo], [hijridate], [Remarks1], [Mobile], [TransApp], [vattotal], [Vatno], [crdays], [invdueDate], [LOCCODE], [LOCNAME], [bankcode], [bankname], [bankamount], [pinvno], [qrcode], [INVTYPE], [INVRETITEMTYPE], [EXMLNAME], [DebitNoteReason], [idtype], [Idno], [Detail1], [Detail2], [Detail3], [Detail4], [Detail5], [Detail6], [Detail7], [Detail8], [Detail9], [Detail10], [DetailDate1], [DetailDate2], [DetailDate3], [DetailDate4], [TRANSMODE], [FGROSS], [FVATTOTAL], [FNETAMOUNT], [Farbicnumber], [Farabic], [CurrName], [CurrRate] FROM [InvoiceDebitNote]; DROP TABLE dbo.[InvoiceDebitNote]; EXEC sp_rename 'dbo.InvoiceDebitNote_New', 'InvoiceDebitNote'; GO CREATE TABLE [dbo].[InvoiceDebitNoteItem_New] ( [InvoiceDebitNoteItemId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Branch] nvarchar(15) NULL, [EntryDate] datetime NULL, [ItemCode] nvarchar(500) NULL, [ItemName] nvarchar(2000) NULL, [Damage] decimal(18, 4) NULL, [Unit] nvarchar(50) NULL, [Qty] decimal(18, 4) NULL, [Rate] decimal(18, 4) NULL, [Amount] decimal(18, 4) NULL, [SR] nvarchar(500) NULL, [SlNo] decimal(18, 4) NULL, [Cost] decimal(18, 4) NULL, [DebitNoteNo] nvarchar(500) NULL, [InvoiceDate] datetime NULL, [DocumentNo] decimal(18, 4) NULL, [InvNo] nvarchar(500) NULL, [SQTY] decimal(18, 4) NULL, [Sales] decimal(18, 4) NULL, [QtyPerUnit] decimal(18, 4) NULL, [TOTQty] decimal(18, 4) NULL, [PerQty] decimal(18, 4) NULL, [PartNo] nvarchar(2000) NULL, [stdcost] decimal(18, 4) NULL, [RateAfterDisc] decimal(18, 4) NULL, [RetQty] decimal(18, 4) NULL, [DNNo] nvarchar(500) NULL, [Deleted] nvarchar(500) NULL, [VATPER] decimal(18, 4) NULL, [VATAMT] decimal(18, 4) NULL, [VAT] decimal(18, 4) NULL, [Disc] decimal(18, 4) NULL, [DisconRate] decimal(18, 4) NULL, [SalesRate] decimal(18, 4) NULL, [INVOICERATE] decimal(18, 4) NULL, [INVOICEQTY] decimal(18, 4) NULL, [VATCATEGORY] nvarchar(50) NULL, [VATEXCCODE] nvarchar(50) NULL, [VATEXCNAME] nvarchar(50) NULL, [storeshop] nvarchar(500) NULL, [FRate] decimal(18, 4) NULL, [FAmount] decimal(18, 4) NULL, [FVATPER] decimal(18, 4) NULL, [FVATAMT] decimal(18, 4) NULL, [FLineTotal] decimal(18, 4) NULL, [Fdisconrate] decimal(18, 4) NULL, [ItemDetail1] nvarchar(500) NULL, [ItemDetail2] nvarchar(500) NULL, [ItemDetail3] nvarchar(500) NULL, [ItemDetail4] nvarchar(500) NULL, [ItemDetail5] nvarchar(500) NULL, [ItemDetail6] nvarchar(500) NULL, [ItemDetail7] nvarchar(500) NULL, [ItemDetail8] nvarchar(500) NULL, [ItemDetail9] nvarchar(500) NULL, [ItemDetail10] nvarchar(500) NULL, [ItemDetailDate1] datetime NULL, [ItemDetailDate2] datetime NULL, [ItemDetailDate3] datetime NULL, [ItemDetailDate4] datetime NULL ); INSERT INTO dbo.[InvoiceDebitNoteItem_New] ([Branch], [EntryDate], [ItemCode], [ItemName], [Damage], [Unit], [Qty], [Rate], [Amount], [SR], [SlNo], [Cost], [DebitNoteNo], [InvoiceDate], [DocumentNo], [InvNo], [SQTY], [Sales], [QtyPerUnit], [TOTQty], [PerQty], [PartNo], [stdcost], [RateAfterDisc], [RetQty], [DNNo], [Deleted], [VATPER], [VATAMT], [VAT], [Disc], [DisconRate], [SalesRate], [INVOICERATE], [INVOICEQTY], [VATCATEGORY], [VATEXCCODE], [VATEXCNAME], [storeshop], [FRate], [FAmount], [FVATPER], [FVATAMT], [FLineTotal], [Fdisconrate], [ItemDetail1], [ItemDetail2], [ItemDetail3], [ItemDetail4], [ItemDetail5], [ItemDetail6], [ItemDetail7], [ItemDetail8], [ItemDetail9], [ItemDetail10], [ItemDetailDate1], [ItemDetailDate2], [ItemDetailDate3], [ItemDetailDate4]) SELECT [Branch], [EntryDate], [ItemCode], [ItemName], [Damage], [Unit], [Qty], [Rate], [Amount], [SR], [SlNo], [Cost], [DebitNoteNo], [InvoiceDate], [DocumentNo], [InvNo], [SQTY], [Sales], [QtyPerUnit], [TOTQty], [PerQty], [PartNo], [stdcost], [RateAfterDisc], [RetQty], [DNNo], [Deleted], [VATPER], [VATAMT], [VAT], [Disc], [DisconRate], [SalesRate], [INVOICERATE], [INVOICEQTY], [VATCATEGORY], [VATEXCCODE], [VATEXCNAME], [storeshop], [FRate], [FAmount], [FVATPER], [FVATAMT], [FLineTotal], [Fdisconrate], [ItemDetail1], [ItemDetail2], [ItemDetail3], [ItemDetail4], [ItemDetail5], [ItemDetail6], [ItemDetail7], [ItemDetail8], [ItemDetail9], [ItemDetail10], [ItemDetailDate1], [ItemDetailDate2], [ItemDetailDate3], [ItemDetailDate4] FROM [InvoiceDebitNoteItem]; DROP TABLE dbo.[InvoiceDebitNoteItem]; EXEC sp_rename 'dbo.InvoiceDebitNoteItem_New', 'InvoiceDebitNoteItem'; GO CREATE TABLE [dbo].[InvoiceDebitNoteLog_New] ( [InvoiceDebitNoteLogId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [DebitNoteNo] nvarchar(500) NULL, [BillType] nvarchar(500) NULL, [CreditPeriod] nvarchar(500) NULL, [CustomerCode] nvarchar(500) NULL, [CustomerName] nvarchar(2000) NULL, [Phone] nvarchar(500) NULL, [Attended] nvarchar(2000) NULL, [Remarks] nvarchar(2000) NULL, [GrossAmount] decimal(18, 4) NULL, [ReceivedAmt] decimal(18, 4) NULL, [LessPerc] decimal(18, 4) NULL, [LessAmount] decimal(18, 4) NULL, [ChangeAmount] decimal(18, 4) NULL, [NetAmount] decimal(18, 4) NULL, [UserName] nvarchar(500) NULL, [System] nvarchar(500) NULL, [DateAndTime] datetime NULL, [Action] nvarchar(500) NULL ); INSERT INTO dbo.[InvoiceDebitNoteLog_New] ([EntryDate], [DebitNoteNo], [BillType], [CreditPeriod], [CustomerCode], [CustomerName], [Phone], [Attended], [Remarks], [GrossAmount], [ReceivedAmt], [LessPerc], [LessAmount], [ChangeAmount], [NetAmount], [UserName], [System], [DateAndTime], [Action]) SELECT [EntryDate], [DebitNoteNo], [BillType], [CreditPeriod], [CustomerCode], [CustomerName], [Phone], [Attended], [Remarks], [GrossAmount], [ReceivedAmt], [LessPerc], [LessAmount], [ChangeAmount], [NetAmount], [UserName], [System], [DateAndTime], [Action] FROM [InvoiceDebitNoteLog]; DROP TABLE dbo.[InvoiceDebitNoteLog]; EXEC sp_rename 'dbo.InvoiceDebitNoteLog_New', 'InvoiceDebitNoteLog'; GO CREATE TABLE [dbo].[InvoiceItem_New] ( [InvoiceItemId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Branch] nvarchar(15) NULL, [EntryDate] datetime NULL, [ItemCode] nvarchar(500) NULL, [ItemName] nvarchar(2000) NULL, [Damage] decimal(18, 4) NULL, [Unit] nvarchar(50) NULL, [Qty] decimal(18, 4) NULL, [Rate] decimal(18, 4) NULL, [Amount] decimal(18, 4) NULL, [SR] nvarchar(500) NULL, [SlNo] decimal(18, 4) NULL, [Cost] decimal(18, 4) NULL, [InvoiceRetNo] nvarchar(500) NULL, [InvoiceDate] datetime NULL, [DocumentNo] decimal(18, 4) NULL, [InvNo] nvarchar(500) NULL, [SQTY] decimal(18, 4) NULL, [Sales] decimal(18, 4) NULL, [QtyPerUnit] decimal(18, 4) NULL, [TOTQty] decimal(18, 4) NULL, [PerQty] decimal(18, 4) NULL, [PartNo] nvarchar(2000) NULL, [stdcost] decimal(18, 4) NULL, [RateAfterDisc] decimal(18, 4) NULL, [RetQty] decimal(18, 4) NULL, [DNNo] nvarchar(500) NULL, [Deleted] nvarchar(500) NULL, [VATPER] decimal(18, 4) NULL, [VATAMT] decimal(18, 4) NULL, [VAT] decimal(18, 4) NULL, [InvoiceQty] decimal(18, 4) NULL, [InvoiceRate] decimal(18, 4) NULL, [Discper] decimal(18, 4) NULL, [DiscOnRate] decimal(18, 4) NULL, [disconincrate] decimal(18, 4) NULL, [VATCATEGORY] nvarchar(50) NULL, [VATEXCCODE] nvarchar(50) NULL, [VATEXCNAME] nvarchar(50) NULL, [storeshop] nvarchar(500) NULL, [FRate] decimal(18, 4) NULL, [FAmount] decimal(18, 4) NULL, [FVATPER] decimal(18, 4) NULL, [FVATAMT] decimal(18, 4) NULL, [FDiscper] decimal(18, 4) NULL, [FDiscOnRate] decimal(18, 4) NULL, [FLineTotal] decimal(18, 4) NULL, [ItemDetail1] nvarchar(500) NULL, [ItemDetail2] nvarchar(500) NULL, [ItemDetail3] nvarchar(500) NULL, [ItemDetail4] nvarchar(500) NULL, [ItemDetail5] nvarchar(500) NULL, [ItemDetail6] nvarchar(500) NULL, [ItemDetail7] nvarchar(500) NULL, [ItemDetail8] nvarchar(500) NULL, [ItemDetail9] nvarchar(500) NULL, [ItemDetail10] nvarchar(500) NULL, [ItemDetailDate1] datetime NULL, [ItemDetailDate2] datetime NULL, [ItemDetailDate3] datetime NULL, [ItemDetailDate4] datetime NULL ); INSERT INTO dbo.[InvoiceItem_New] ([Branch], [EntryDate], [ItemCode], [ItemName], [Damage], [Unit], [Qty], [Rate], [Amount], [SR], [SlNo], [Cost], [InvoiceRetNo], [InvoiceDate], [DocumentNo], [InvNo], [SQTY], [Sales], [QtyPerUnit], [TOTQty], [PerQty], [PartNo], [stdcost], [RateAfterDisc], [RetQty], [DNNo], [Deleted], [VATPER], [VATAMT], [VAT], [InvoiceQty], [InvoiceRate], [Discper], [DiscOnRate], [disconincrate], [VATCATEGORY], [VATEXCCODE], [VATEXCNAME], [storeshop], [FRate], [FAmount], [FVATPER], [FVATAMT], [FDiscper], [FDiscOnRate], [FLineTotal], [ItemDetail1], [ItemDetail2], [ItemDetail3], [ItemDetail4], [ItemDetail5], [ItemDetail6], [ItemDetail7], [ItemDetail8], [ItemDetail9], [ItemDetail10], [ItemDetailDate1], [ItemDetailDate2], [ItemDetailDate3], [ItemDetailDate4]) SELECT [Branch], [EntryDate], [ItemCode], [ItemName], [Damage], [Unit], [Qty], [Rate], [Amount], [SR], [SlNo], [Cost], [InvoiceRetNo], [InvoiceDate], [DocumentNo], [InvNo], [SQTY], [Sales], [QtyPerUnit], [TOTQty], [PerQty], [PartNo], [stdcost], [RateAfterDisc], [RetQty], [DNNo], [Deleted], [VATPER], [VATAMT], [VAT], [InvoiceQty], [InvoiceRate], [Discper], [DiscOnRate], [disconincrate], [VATCATEGORY], [VATEXCCODE], [VATEXCNAME], [storeshop], [FRate], [FAmount], [FVATPER], [FVATAMT], [FDiscper], [FDiscOnRate], [FLineTotal], [ItemDetail1], [ItemDetail2], [ItemDetail3], [ItemDetail4], [ItemDetail5], [ItemDetail6], [ItemDetail7], [ItemDetail8], [ItemDetail9], [ItemDetail10], [ItemDetailDate1], [ItemDetailDate2], [ItemDetailDate3], [ItemDetailDate4] FROM [InvoiceItem]; DROP TABLE dbo.[InvoiceItem]; EXEC sp_rename 'dbo.InvoiceItem_New', 'InvoiceItem'; GO CREATE TABLE [dbo].[InvoiceLog_New] ( [InvoiceLogId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [InvNo] nvarchar(500) NULL, [BillType] nvarchar(500) NULL, [CreditPeriod] nvarchar(500) NULL, [CustomerCode] nvarchar(500) NULL, [CustomerName] nvarchar(2000) NULL, [Phone] nvarchar(500) NULL, [Attended] nvarchar(2000) NULL, [Remarks] nvarchar(2000) NULL, [GrossAmount] decimal(18, 4) NULL, [ReceivedAmt] decimal(18, 4) NULL, [LessPerc] decimal(18, 4) NULL, [LessAmount] decimal(18, 4) NULL, [ChangeAmount] decimal(18, 4) NULL, [NetAmount] decimal(18, 4) NULL, [UserName] nvarchar(500) NULL, [System] nvarchar(500) NULL, [DateAndTime] datetime NULL, [Action] nvarchar(500) NULL ); INSERT INTO dbo.[InvoiceLog_New] ([EntryDate], [InvNo], [BillType], [CreditPeriod], [CustomerCode], [CustomerName], [Phone], [Attended], [Remarks], [GrossAmount], [ReceivedAmt], [LessPerc], [LessAmount], [ChangeAmount], [NetAmount], [UserName], [System], [DateAndTime], [Action]) SELECT [EntryDate], [InvNo], [BillType], [CreditPeriod], [CustomerCode], [CustomerName], [Phone], [Attended], [Remarks], [GrossAmount], [ReceivedAmt], [LessPerc], [LessAmount], [ChangeAmount], [NetAmount], [UserName], [System], [DateAndTime], [Action] FROM [InvoiceLog]; DROP TABLE dbo.[InvoiceLog]; EXEC sp_rename 'dbo.InvoiceLog_New', 'InvoiceLog'; GO CREATE TABLE [dbo].[InvoiceResubmitLog_New] ( [InvoiceResubmitLogId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [DocNo] nvarchar(500) NULL, [BillType] nvarchar(500) NULL, [CreditPeriod] nvarchar(500) NULL, [CustomerCode] nvarchar(500) NULL, [CustomerName] nvarchar(2000) NULL, [Phone] nvarchar(500) NULL, [Attended] nvarchar(2000) NULL, [Remarks] nvarchar(2000) NULL, [GrossAmount] decimal(18, 4) NULL, [ReceivedAmt] decimal(18, 4) NULL, [LessPerc] decimal(18, 4) NULL, [LessAmount] decimal(18, 4) NULL, [ChangeAmount] decimal(18, 4) NULL, [NetAmount] decimal(18, 4) NULL, [UserName] nvarchar(500) NULL, [System] nvarchar(500) NULL, [DateAndTime] datetime NULL, [Action] nvarchar(500) NULL, [Trtype] nvarchar(500) NULL ); INSERT INTO dbo.[InvoiceResubmitLog_New] ([EntryDate], [DocNo], [BillType], [CreditPeriod], [CustomerCode], [CustomerName], [Phone], [Attended], [Remarks], [GrossAmount], [ReceivedAmt], [LessPerc], [LessAmount], [ChangeAmount], [NetAmount], [UserName], [System], [DateAndTime], [Action], [Trtype]) SELECT [EntryDate], [DocNo], [BillType], [CreditPeriod], [CustomerCode], [CustomerName], [Phone], [Attended], [Remarks], [GrossAmount], [ReceivedAmt], [LessPerc], [LessAmount], [ChangeAmount], [NetAmount], [UserName], [System], [DateAndTime], [Action], [Trtype] FROM [InvoiceResubmitLog]; DROP TABLE dbo.[InvoiceResubmitLog]; EXEC sp_rename 'dbo.InvoiceResubmitLog_New', 'InvoiceResubmitLog'; GO CREATE TABLE [dbo].[InvoiceWiseProfit_New] ( [InvoiceWiseProfitId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Month] int NULL, [Year] int NULL, [Profit] decimal(18, 4) NULL ); INSERT INTO dbo.[InvoiceWiseProfit_New] ([Month], [Year], [Profit]) SELECT [Month], [Year], [Profit] FROM [InvoiceWiseProfit]; DROP TABLE dbo.[InvoiceWiseProfit]; EXEC sp_rename 'dbo.InvoiceWiseProfit_New', 'InvoiceWiseProfit'; GO CREATE TABLE [dbo].[item_New] ( [itemId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [itemcode] nvarchar(500) NULL, [ItemName] nvarchar(2000) NULL, [Company] nvarchar(2000) NULL, [Category] nvarchar(2000) NULL, [ItemSize] nvarchar(500) NULL, [OPStock] decimal(18, 4) NULL, [Stock] decimal(18, 4) NULL, [ROL] decimal(18, 4) NULL, [Cost] decimal(18, 4) NULL, [opCost] decimal(18, 4) NULL, [StandardCost] decimal(18, 4) NULL, [Location] nvarchar(500) NULL, [DamageStock] decimal(18, 4) NULL, [OpDamage] decimal(18, 4) NULL, [PurhRate] decimal(18, 4) NULL, [Rate] decimal(18, 4) NULL, [ItemNameAR] nvarchar(2000) NULL, [RateLock] decimal(18, 4) NULL, [Unit] nvarchar(50) NULL, [BOXQTY] decimal(18, 4) NULL, [BOXprice] decimal(18, 4) NULL, [PKTQTY] decimal(18, 4) NULL, [PKTprice] decimal(18, 4) NULL, [MACHINECode] nvarchar(500) NULL, [ReOrderQty] decimal(18, 4) NULL, [PartNo] nvarchar(2000) NULL, [ID] decimal(18, 4) NULL, [Rate2] decimal(18, 4) NULL, [Rate3] decimal(18, 4) NULL, [Punit] nvarchar(50) NULL, [qtyperunit] decimal(18, 4) NULL, [LocCode] nvarchar(100) NULL, [LocName] nvarchar(150) NULL, [QtyChecking] nvarchar(20) NULL, [VATPER] decimal(18, 4) NULL, [StkMode] nvarchar(15) NULL, [entrydate] datetime NULL, [modifydate] nvarchar(500) NULL, [vatrate] decimal(18, 4) NULL, [vatcategory] nvarchar(100) NULL, [vatexcCode] nvarchar(100) NULL, [VatExcName] nvarchar(100) NULL, [Notes] nvarchar(500) NULL, [Model] nvarchar(500) NULL, [Fitted] nvarchar(500) NULL, [ITEMIMAGENAME] nvarchar(500) NULL, [ITEMIMAGE] image NULL ); INSERT INTO dbo.[item_New] ([itemcode], [ItemName], [Company], [Category], [ItemSize], [OPStock], [Stock], [ROL], [Cost], [opCost], [StandardCost], [Location], [DamageStock], [OpDamage], [PurhRate], [Rate], [ItemNameAR], [RateLock], [Unit], [BOXQTY], [BOXprice], [PKTQTY], [PKTprice], [MACHINECode], [ReOrderQty], [PartNo], [ID], [Rate2], [Rate3], [Punit], [qtyperunit], [LocCode], [LocName], [QtyChecking], [VATPER], [StkMode], [entrydate], [modifydate], [vatrate], [vatcategory], [vatexcCode], [VatExcName], [Notes], [Model], [Fitted], [ITEMIMAGENAME], [ITEMIMAGE]) SELECT [itemcode], [ItemName], [Company], [Category], [ItemSize], [OPStock], [Stock], [ROL], [Cost], [opCost], [StandardCost], [Location], [DamageStock], [OpDamage], [PurhRate], [Rate], [ItemNameAR], [RateLock], [Unit], [BOXQTY], [BOXprice], [PKTQTY], [PKTprice], [MACHINECode], [ReOrderQty], [PartNo], [ID], [Rate2], [Rate3], [Punit], [qtyperunit], [LocCode], [LocName], [QtyChecking], [VATPER], [StkMode], [entrydate], [modifydate], [vatrate], [vatcategory], [vatexcCode], [VatExcName], [Notes], [Model], [Fitted], [ITEMIMAGENAME], [ITEMIMAGE] FROM [item]; DROP TABLE dbo.[item]; EXEC sp_rename 'dbo.item_New', 'item'; GO CREATE TABLE [dbo].[itemaccess_New] ( [itemaccessId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [icode] nvarchar(50) NULL, [iname] nvarchar(2000) NULL, [unit] nvarchar(50) NULL, [pprice] decimal(18, 4) NULL, [sprice] decimal(18, 4) NULL, [profit] decimal(18, 4) NULL, [cdate] smalldatetime NULL, [rem] nvarchar(250) NULL, [cpv] decimal(18, 4) NULL, [lastpd] smalldatetime NULL, [Location] nvarchar(50) NULL, [gcode] nvarchar(150) NULL, [code2] nvarchar(150) NULL, [gname] nvarchar(2000) NULL, [Acost] decimal(18, 4) NULL, [Mqty] decimal(18, 4) NULL, [MProfit] nvarchar(50) NULL, [MSprice] decimal(18, 4) NULL, [Dis] decimal(18, 4) NULL, [Brand] nvarchar(100) NULL, [qty] decimal(18, 4) NULL, [Sqty] decimal(18, 4) NULL, [Wqty] decimal(18, 4) NULL, [Pid] nvarchar(50) NULL, [Des] nvarchar(50) NULL, [Sname1] nvarchar(2000) NULL, [Sname2] nvarchar(2000) NULL, [Sname3] nvarchar(2000) NULL, [Price1] decimal(18, 4) NULL, [Price2] decimal(18, 4) NULL, [Price3] decimal(18, 4) NULL ); INSERT INTO dbo.[itemaccess_New] ([icode], [iname], [unit], [pprice], [sprice], [profit], [cdate], [rem], [cpv], [lastpd], [Location], [gcode], [code2], [gname], [Acost], [Mqty], [MProfit], [MSprice], [Dis], [Brand], [qty], [Sqty], [Wqty], [Pid], [Des], [Sname1], [Sname2], [Sname3], [Price1], [Price2], [Price3]) SELECT [icode], [iname], [unit], [pprice], [sprice], [profit], [cdate], [rem], [cpv], [lastpd], [Location], [gcode], [code2], [gname], [Acost], [Mqty], [MProfit], [MSprice], [Dis], [Brand], [qty], [Sqty], [Wqty], [Pid], [Des], [Sname1], [Sname2], [Sname3], [Price1], [Price2], [Price3] FROM [itemaccess]; DROP TABLE dbo.[itemaccess]; EXEC sp_rename 'dbo.itemaccess_New', 'itemaccess'; GO CREATE TABLE [dbo].[itemcheck_New] ( [itemcheckId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [itemcode] nvarchar(500) NULL, [ItemName] nvarchar(2000) NULL, [Company] nvarchar(2000) NULL, [Category] nvarchar(2000) NULL, [ItemSize] nvarchar(500) NULL, [OPStock] decimal(18, 4) NULL, [Stock] decimal(18, 4) NULL, [ROL] decimal(18, 4) NULL, [Cost] decimal(18, 4) NULL, [opCost] decimal(18, 4) NULL, [StandardCost] decimal(18, 4) NULL, [Location] nvarchar(500) NULL, [DamageStock] decimal(18, 4) NULL, [OpDamage] decimal(18, 4) NULL, [PurhRate] decimal(18, 4) NULL, [Rate] decimal(18, 4) NULL, [ItemNameAR] nvarchar(2000) NULL, [RateLock] decimal(18, 4) NULL, [Unit] nvarchar(500) NULL, [BOXQTY] decimal(18, 4) NULL, [BOXprice] decimal(18, 4) NULL, [PKTQTY] decimal(18, 4) NULL, [PKTprice] decimal(18, 4) NULL, [MACHINECode] nvarchar(500) NULL, [ReOrderQty] decimal(18, 4) NULL, [PartNo] nvarchar(2000) NULL, [ID] decimal(18, 4) NULL, [Rate2] decimal(18, 4) NULL, [Rate3] decimal(18, 4) NULL, [Punit] nvarchar(500) NULL, [qtyperunit] decimal(18, 4) NULL ); INSERT INTO dbo.[itemcheck_New] ([itemcode], [ItemName], [Company], [Category], [ItemSize], [OPStock], [Stock], [ROL], [Cost], [opCost], [StandardCost], [Location], [DamageStock], [OpDamage], [PurhRate], [Rate], [ItemNameAR], [RateLock], [Unit], [BOXQTY], [BOXprice], [PKTQTY], [PKTprice], [MACHINECode], [ReOrderQty], [PartNo], [ID], [Rate2], [Rate3], [Punit], [qtyperunit]) SELECT [itemcode], [ItemName], [Company], [Category], [ItemSize], [OPStock], [Stock], [ROL], [Cost], [opCost], [StandardCost], [Location], [DamageStock], [OpDamage], [PurhRate], [Rate], [ItemNameAR], [RateLock], [Unit], [BOXQTY], [BOXprice], [PKTQTY], [PKTprice], [MACHINECode], [ReOrderQty], [PartNo], [ID], [Rate2], [Rate3], [Punit], [qtyperunit] FROM [itemcheck]; DROP TABLE dbo.[itemcheck]; EXEC sp_rename 'dbo.itemcheck_New', 'itemcheck'; GO CREATE TABLE [dbo].[ITEMCOSTPRICE1_New] ( [ITEMCOSTPRICE1Id] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Code] nvarchar(1500) NULL, [Name] nvarchar(1500) NULL, [UNIT1] nvarchar(50) NULL, [UNIT2] nvarchar(50) NULL, [UNIT3] nvarchar(50) NULL, [UNIT4] nvarchar(50) NULL, [PRICE1] decimal(18, 4) NULL, [PRICE2] decimal(18, 4) NULL, [AMOUNT] decimal(18, 4) NULL ); INSERT INTO dbo.[ITEMCOSTPRICE1_New] ([Code], [Name], [UNIT1], [UNIT2], [UNIT3], [UNIT4], [PRICE1], [PRICE2], [AMOUNT]) SELECT [Code], [Name], [UNIT1], [UNIT2], [UNIT3], [UNIT4], [PRICE1], [PRICE2], [AMOUNT] FROM [ITEMCOSTPRICE1]; DROP TABLE dbo.[ITEMCOSTPRICE1]; EXEC sp_rename 'dbo.ITEMCOSTPRICE1_New', 'ITEMCOSTPRICE1'; GO CREATE TABLE [dbo].[ItemHistory_New] ( [ItemHistoryId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [RefNo] nvarchar(500) NULL, [Type] nvarchar(500) NULL, [Unit] nvarchar(500) NULL, [OPStock] decimal(18, 4) NULL, [CurrentStock] decimal(18, 4) NULL, [IssueQty] decimal(18, 4) NULL, [IssueRetQty] decimal(18, 4) NULL, [PurQty] decimal(18, 4) NULL, [PurRetQty] decimal(18, 4) NULL, [TransOutQty] decimal(18, 4) NULL, [TransInQty] decimal(18, 4) NULL, [DeliveryQty] decimal(18, 4) NULL, [FinalQty] decimal(18, 4) NULL, [ProductionQty] decimal(18, 4) NULL, [qtyperunit] decimal(18, 4) NULL, [DmgQty] decimal(18, 4) NULL, [AdjQty] decimal(18, 4) NULL, [storeshop] nvarchar(500) NULL ); INSERT INTO dbo.[ItemHistory_New] ([EntryDate], [RefNo], [Type], [Unit], [OPStock], [CurrentStock], [IssueQty], [IssueRetQty], [PurQty], [PurRetQty], [TransOutQty], [TransInQty], [DeliveryQty], [FinalQty], [ProductionQty], [qtyperunit], [DmgQty], [AdjQty], [storeshop]) SELECT [EntryDate], [RefNo], [Type], [Unit], [OPStock], [CurrentStock], [IssueQty], [IssueRetQty], [PurQty], [PurRetQty], [TransOutQty], [TransInQty], [DeliveryQty], [FinalQty], [ProductionQty], [qtyperunit], [DmgQty], [AdjQty], [storeshop] FROM [ItemHistory]; DROP TABLE dbo.[ItemHistory]; EXEC sp_rename 'dbo.ItemHistory_New', 'ItemHistory'; GO CREATE TABLE [dbo].[ITEMPRATE_New] ( [ITEMPRATEId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Code] nvarchar(500) NULL, [Name] nvarchar(2000) NULL, [UNIT1] nvarchar(500) NULL, [UNIT] nvarchar(500) NULL, [PRATE] decimal(18, 4) NULL ); INSERT INTO dbo.[ITEMPRATE_New] ([Code], [Name], [UNIT1], [UNIT], [PRATE]) SELECT [Code], [Name], [UNIT1], [UNIT], [PRATE] FROM [ITEMPRATE]; DROP TABLE dbo.[ITEMPRATE]; EXEC sp_rename 'dbo.ITEMPRATE_New', 'ITEMPRATE'; GO CREATE TABLE [dbo].[ITEMRATE1_New] ( [ITEMRATE1Id] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Code] nvarchar(1500) NULL, [Name] nvarchar(1500) NULL, [UNIT1] nvarchar(50) NULL, [UNIT2] nvarchar(50) NULL, [UNIT3] nvarchar(50) NULL, [UNIT4] nvarchar(50) NULL, [PRICE1] decimal(18, 4) NULL, [PRICE2] decimal(18, 4) NULL, [AMOUNT] decimal(18, 4) NULL ); INSERT INTO dbo.[ITEMRATE1_New] ([Code], [Name], [UNIT1], [UNIT2], [UNIT3], [UNIT4], [PRICE1], [PRICE2], [AMOUNT]) SELECT [Code], [Name], [UNIT1], [UNIT2], [UNIT3], [UNIT4], [PRICE1], [PRICE2], [AMOUNT] FROM [ITEMRATE1]; DROP TABLE dbo.[ITEMRATE1]; EXEC sp_rename 'dbo.ITEMRATE1_New', 'ITEMRATE1'; GO CREATE TABLE [dbo].[ITEMSRATE_New] ( [ITEMSRATEId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Code] nvarchar(500) NULL, [Name] nvarchar(2000) NULL, [UNIT1] nvarchar(500) NULL, [UNIT] nvarchar(500) NULL, [SRATE] decimal(18, 4) NULL, [SRATE2] decimal(18, 4) NULL ); INSERT INTO dbo.[ITEMSRATE_New] ([Code], [Name], [UNIT1], [UNIT], [SRATE], [SRATE2]) SELECT [Code], [Name], [UNIT1], [UNIT], [SRATE], [SRATE2] FROM [ITEMSRATE]; DROP TABLE dbo.[ITEMSRATE]; EXEC sp_rename 'dbo.ITEMSRATE_New', 'ITEMSRATE'; GO CREATE TABLE [dbo].[ITEMtemp1_New] ( [ITEMtemp1Id] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [itemcode] nvarchar(500) NULL, [ItemName] nvarchar(2000) NULL, [ItemNameAR] nvarchar(2000) NULL, [Unit] nvarchar(500) NULL, [Cost] decimal(18, 4) NULL, [Rate] decimal(18, 4) NULL, [Location] nvarchar(500) NULL, [stock] decimal(18, 4) NULL ); INSERT INTO dbo.[ITEMtemp1_New] ([itemcode], [ItemName], [ItemNameAR], [Unit], [Cost], [Rate], [Location], [stock]) SELECT [itemcode], [ItemName], [ItemNameAR], [Unit], [Cost], [Rate], [Location], [stock] FROM [ITEMtemp1]; DROP TABLE dbo.[ITEMtemp1]; EXEC sp_rename 'dbo.ITEMtemp1_New', 'ITEMtemp1'; GO CREATE TABLE [dbo].[ITEMtemp2_New] ( [ITEMtemp2Id] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [itemcode] nvarchar(500) NULL, [stock] decimal(18, 4) NULL ); INSERT INTO dbo.[ITEMtemp2_New] ([itemcode], [stock]) SELECT [itemcode], [stock] FROM [ITEMtemp2]; DROP TABLE dbo.[ITEMtemp2]; EXEC sp_rename 'dbo.ITEMtemp2_New', 'ITEMtemp2'; GO CREATE TABLE [dbo].[itemtempupdate_New] ( [itemtempupdateId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [itemcode] nvarchar(500) NULL, [updateflag] int NULL ); INSERT INTO dbo.[itemtempupdate_New] ([itemcode], [updateflag]) SELECT [itemcode], [updateflag] FROM [itemtempupdate]; DROP TABLE dbo.[itemtempupdate]; EXEC sp_rename 'dbo.itemtempupdate_New', 'itemtempupdate'; GO CREATE TABLE [dbo].[JournalEntry_New] ( [JournalEntryId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [JournalNo] nvarchar(500) NULL, [SalesMan] nvarchar(2000) NULL, [SalesManCode] nvarchar(500) NULL, [TotRec] decimal(18, 4) NULL, [TotPay] decimal(18, 4) NULL, [TotDebitvat] decimal(18, 4) NULL, [TotCreditvat] decimal(18, 4) NULL ); INSERT INTO dbo.[JournalEntry_New] ([EntryDate], [JournalNo], [SalesMan], [SalesManCode], [TotRec], [TotPay], [TotDebitvat], [TotCreditvat]) SELECT [EntryDate], [JournalNo], [SalesMan], [SalesManCode], [TotRec], [TotPay], [TotDebitvat], [TotCreditvat] FROM [JournalEntry]; DROP TABLE dbo.[JournalEntry]; EXEC sp_rename 'dbo.JournalEntry_New', 'JournalEntry'; GO CREATE TABLE [dbo].[JournalEntryDetails_New] ( [JournalEntryDetailsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [JournalNo] nvarchar(500) NULL, [AccCode] nvarchar(500) NULL, [AccName] nvarchar(2000) NULL, [Debit] decimal(18, 4) NULL, [Credit] decimal(18, 4) NULL, [invoiceNo] nvarchar(500) NULL, [Narration] nvarchar(2000) NULL, [SalesMan] nvarchar(2000) NULL, [Slno] decimal(18, 4) NULL, [Type] nvarchar(500) NULL, [DebitVatper] decimal(18, 4) NULL, [CreditVatper] decimal(18, 4) NULL, [DebitVat] decimal(18, 4) NULL, [CreditVat] decimal(18, 4) NULL, [VatNo] nvarchar(500) NULL, [Name] nvarchar(500) NULL, [DebitInc] decimal(18, 4) NULL, [CreditInc] decimal(18, 4) NULL ); INSERT INTO dbo.[JournalEntryDetails_New] ([EntryDate], [JournalNo], [AccCode], [AccName], [Debit], [Credit], [invoiceNo], [Narration], [SalesMan], [Slno], [Type], [DebitVatper], [CreditVatper], [DebitVat], [CreditVat], [VatNo], [Name], [DebitInc], [CreditInc]) SELECT [EntryDate], [JournalNo], [AccCode], [AccName], [Debit], [Credit], [invoiceNo], [Narration], [SalesMan], [Slno], [Type], [DebitVatper], [CreditVatper], [DebitVat], [CreditVat], [VatNo], [Name], [DebitInc], [CreditInc] FROM [JournalEntryDetails]; DROP TABLE dbo.[JournalEntryDetails]; EXEC sp_rename 'dbo.JournalEntryDetails_New', 'JournalEntryDetails'; GO CREATE TABLE [dbo].[Location_New] ( [LocationId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Code] nvarchar(100) NULL, [Name] nvarchar(2000) NULL, [Remarks] nvarchar(2000) NULL ); INSERT INTO dbo.[Location_New] ([Code], [Name], [Remarks]) SELECT [Code], [Name], [Remarks] FROM [Location]; DROP TABLE dbo.[Location]; EXEC sp_rename 'dbo.Location_New', 'Location'; GO CREATE TABLE [dbo].[Machinary_New] ( [MachinaryId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Code] nvarchar(500) NULL, [Name] nvarchar(2000) NULL, [Company] nvarchar(2000) NULL, [Category] nvarchar(2000) NULL, [ItemSize] decimal(18, 4) NULL, [OPStock] decimal(18, 4) NULL, [Stock] decimal(18, 4) NULL, [ROL] decimal(18, 4) NULL, [Cost] decimal(18, 4) NULL, [opCost] decimal(18, 4) NULL, [StandardCost] decimal(18, 4) NULL, [Location] decimal(18, 4) NULL, [DamageStock] decimal(18, 4) NULL, [OpDamage] decimal(18, 4) NULL, [PurhRate] decimal(18, 4) NULL, [Rate] decimal(18, 4) NULL, [ItemNameAR] nvarchar(2000) NULL, [RateLock] decimal(18, 4) NULL, [Unit] nvarchar(500) NULL, [BOXQTY] decimal(18, 4) NULL, [BOXprice] decimal(18, 4) NULL, [PKTQTY] decimal(18, 4) NULL, [PKTprice] decimal(18, 4) NULL, [ID] decimal(18, 4) NULL, [ItemCode] nvarchar(500) NULL ); INSERT INTO dbo.[Machinary_New] ([Code], [Name], [Company], [Category], [ItemSize], [OPStock], [Stock], [ROL], [Cost], [opCost], [StandardCost], [Location], [DamageStock], [OpDamage], [PurhRate], [Rate], [ItemNameAR], [RateLock], [Unit], [BOXQTY], [BOXprice], [PKTQTY], [PKTprice], [ID], [ItemCode]) SELECT [Code], [Name], [Company], [Category], [ItemSize], [OPStock], [Stock], [ROL], [Cost], [opCost], [StandardCost], [Location], [DamageStock], [OpDamage], [PurhRate], [Rate], [ItemNameAR], [RateLock], [Unit], [BOXQTY], [BOXprice], [PKTQTY], [PKTprice], [ID], [ItemCode] FROM [Machinary]; DROP TABLE dbo.[Machinary]; EXEC sp_rename 'dbo.Machinary_New', 'Machinary'; GO CREATE TABLE [dbo].[MachineEnquiry_New] ( [MachineEnquiryId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [ItemCode] nvarchar(500) NULL, [ItemName] nvarchar(2000) NULL, [MacCode] nvarchar(500) NULL, [MacName] nvarchar(2000) NULL, [EnqryNo] nvarchar(500) NULL ); INSERT INTO dbo.[MachineEnquiry_New] ([ItemCode], [ItemName], [MacCode], [MacName], [EnqryNo]) SELECT [ItemCode], [ItemName], [MacCode], [MacName], [EnqryNo] FROM [MachineEnquiry]; DROP TABLE dbo.[MachineEnquiry]; EXEC sp_rename 'dbo.MachineEnquiry_New', 'MachineEnquiry'; GO CREATE TABLE [dbo].[MaterialTrans_New] ( [MaterialTransId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Branch] nvarchar(15) NULL, [EntryDate] datetime NULL, [InvNo] nvarchar(500) NULL, [ReturnInvoiceNo] nvarchar(500) NULL, [BillType] nvarchar(500) NULL, [RefNo] nvarchar(500) NULL, [PONo] nvarchar(500) NULL, [CustomerCode] nvarchar(500) NULL, [CustomerName] nvarchar(2000) NULL, [Address] nvarchar(2000) NULL, [Phone] nvarchar(500) NULL, [Fax] nvarchar(500) NULL, [Attended] nvarchar(2000) NULL, [GrossAmount] decimal(18, 4) NULL, [LessPerc] decimal(18, 4) NULL, [LessAmount] decimal(18, 4) NULL, [NetAmount] decimal(18, 4) NULL, [SR] nvarchar(500) NULL, [Received] decimal(18, 4) NULL, [DnNo] nvarchar(500) NULL, [QuotNo] nvarchar(500) NULL, [Flag] char NULL, [CreditPeriod] nvarchar(500) NULL, [ReceivedAmount] decimal(18, 4) NULL, [UserName] nvarchar(500) NULL, [InvoiceRetNo] decimal(18, 4) NULL, [ReceivedAmt] decimal(18, 4) NULL, [ChangeAmount] decimal(18, 4) NULL, [InvoiceDate] datetime NULL, [Narration] nvarchar(2000) NULL, [voucherNo] nvarchar(500) NULL, [fromstorecode] nvarchar(500) NULL, [fromstore] nvarchar(500) NULL, [Remarks] nvarchar(500) NULL, [AddLess] decimal(18, 4) NULL, [tostorecode] nvarchar(500) NULL, [tostore] nvarchar(500) NULL, [MatOutNo] nvarchar(100) NULL ); INSERT INTO dbo.[MaterialTrans_New] ([Branch], [EntryDate], [InvNo], [ReturnInvoiceNo], [BillType], [RefNo], [PONo], [CustomerCode], [CustomerName], [Address], [Phone], [Fax], [Attended], [GrossAmount], [LessPerc], [LessAmount], [NetAmount], [SR], [Received], [DnNo], [QuotNo], [Flag], [CreditPeriod], [ReceivedAmount], [UserName], [InvoiceRetNo], [ReceivedAmt], [ChangeAmount], [InvoiceDate], [Narration], [voucherNo], [fromstorecode], [fromstore], [Remarks], [AddLess], [tostorecode], [tostore], [MatOutNo]) SELECT [Branch], [EntryDate], [InvNo], [ReturnInvoiceNo], [BillType], [RefNo], [PONo], [CustomerCode], [CustomerName], [Address], [Phone], [Fax], [Attended], [GrossAmount], [LessPerc], [LessAmount], [NetAmount], [SR], [Received], [DnNo], [QuotNo], [Flag], [CreditPeriod], [ReceivedAmount], [UserName], [InvoiceRetNo], [ReceivedAmt], [ChangeAmount], [InvoiceDate], [Narration], [voucherNo], [fromstorecode], [fromstore], [Remarks], [AddLess], [tostorecode], [tostore], [MatOutNo] FROM [MaterialTrans]; DROP TABLE dbo.[MaterialTrans]; EXEC sp_rename 'dbo.MaterialTrans_New', 'MaterialTrans'; GO CREATE TABLE [dbo].[MaterialTransDetails_New] ( [MaterialTransDetailsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Branch] nvarchar(15) NULL, [EntryDate] datetime NULL, [ItemCode] nvarchar(500) NULL, [ItemName] nvarchar(2000) NULL, [Damage] decimal(18, 4) NULL, [Unit] nvarchar(500) NULL, [Qty] decimal(18, 4) NULL, [Rate] decimal(18, 4) NULL, [Amount] decimal(18, 4) NULL, [SR] nvarchar(500) NULL, [SlNo] decimal(18, 4) NULL, [Cost] decimal(18, 4) NULL, [InvoiceRetNo] nvarchar(500) NULL, [InvoiceDate] datetime NULL, [DocumentNo] nvarchar(500) NULL, [InvNo] nvarchar(500) NULL, [SQTY] decimal(18, 4) NULL, [Sales] decimal(18, 4) NULL, [Stock] decimal(18, 4) NULL, [purrate] decimal(18, 4) NULL, [SALESRATE] decimal(18, 4) NULL, [MatOutNo] nvarchar(500) NULL, [qtyperunit] decimal(18, 4) NULL, [storeshop] nvarchar(500) NULL ); INSERT INTO dbo.[MaterialTransDetails_New] ([Branch], [EntryDate], [ItemCode], [ItemName], [Damage], [Unit], [Qty], [Rate], [Amount], [SR], [SlNo], [Cost], [InvoiceRetNo], [InvoiceDate], [DocumentNo], [InvNo], [SQTY], [Sales], [Stock], [purrate], [SALESRATE], [MatOutNo], [qtyperunit], [storeshop]) SELECT [Branch], [EntryDate], [ItemCode], [ItemName], [Damage], [Unit], [Qty], [Rate], [Amount], [SR], [SlNo], [Cost], [InvoiceRetNo], [InvoiceDate], [DocumentNo], [InvNo], [SQTY], [Sales], [Stock], [purrate], [SALESRATE], [MatOutNo], [qtyperunit], [storeshop] FROM [MaterialTransDetails]; DROP TABLE dbo.[MaterialTransDetails]; EXEC sp_rename 'dbo.MaterialTransDetails_New', 'MaterialTransDetails'; GO CREATE TABLE [dbo].[MaterialTransOut_New] ( [MaterialTransOutId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Branch] nvarchar(15) NULL, [EntryDate] datetime NULL, [InvNo] nvarchar(500) NULL, [ReturnInvoiceNo] nvarchar(500) NULL, [BillType] nvarchar(500) NULL, [RefNo] nvarchar(500) NULL, [PONo] nvarchar(500) NULL, [CustomerCode] nvarchar(500) NULL, [CustomerName] nvarchar(2000) NULL, [Address] nvarchar(2000) NULL, [Phone] nvarchar(500) NULL, [Fax] nvarchar(500) NULL, [Attended] nvarchar(2000) NULL, [GrossAmount] decimal(18, 4) NULL, [LessPerc] decimal(18, 4) NULL, [LessAmount] decimal(18, 4) NULL, [NetAmount] decimal(18, 4) NULL, [SR] nvarchar(500) NULL, [Received] decimal(18, 4) NULL, [DnNo] nvarchar(500) NULL, [QuotNo] nvarchar(500) NULL, [Flag] char NULL, [CreditPeriod] nvarchar(500) NULL, [ReceivedAmount] decimal(18, 4) NULL, [UserName] nvarchar(500) NULL, [InvoiceRetNo] nvarchar(500) NULL, [ReceivedAmt] decimal(18, 4) NULL, [ChangeAmount] decimal(18, 4) NULL, [InvoiceDate] datetime NULL, [Narration] nvarchar(2000) NULL, [voucherNo] nvarchar(500) NULL, [fromstorecode] nvarchar(500) NULL, [fromstore] nvarchar(500) NULL, [Remarks] nvarchar(2000) NULL, [AddLess] decimal(18, 4) NULL, [tostorecode] nvarchar(500) NULL, [tostore] nvarchar(500) NULL, [recno] nvarchar(100) NULL, [smcode] nvarchar(50) NULL, [sm] nvarchar(100) NULL, [drcode] nvarchar(50) NULL, [dr] nvarchar(100) NULL ); INSERT INTO dbo.[MaterialTransOut_New] ([Branch], [EntryDate], [InvNo], [ReturnInvoiceNo], [BillType], [RefNo], [PONo], [CustomerCode], [CustomerName], [Address], [Phone], [Fax], [Attended], [GrossAmount], [LessPerc], [LessAmount], [NetAmount], [SR], [Received], [DnNo], [QuotNo], [Flag], [CreditPeriod], [ReceivedAmount], [UserName], [InvoiceRetNo], [ReceivedAmt], [ChangeAmount], [InvoiceDate], [Narration], [voucherNo], [fromstorecode], [fromstore], [Remarks], [AddLess], [tostorecode], [tostore], [recno], [smcode], [sm], [drcode], [dr]) SELECT [Branch], [EntryDate], [InvNo], [ReturnInvoiceNo], [BillType], [RefNo], [PONo], [CustomerCode], [CustomerName], [Address], [Phone], [Fax], [Attended], [GrossAmount], [LessPerc], [LessAmount], [NetAmount], [SR], [Received], [DnNo], [QuotNo], [Flag], [CreditPeriod], [ReceivedAmount], [UserName], [InvoiceRetNo], [ReceivedAmt], [ChangeAmount], [InvoiceDate], [Narration], [voucherNo], [fromstorecode], [fromstore], [Remarks], [AddLess], [tostorecode], [tostore], [recno], [smcode], [sm], [drcode], [dr] FROM [MaterialTransOut]; DROP TABLE dbo.[MaterialTransOut]; EXEC sp_rename 'dbo.MaterialTransOut_New', 'MaterialTransOut'; GO CREATE TABLE [dbo].[MaterialTransOutDetails_New] ( [MaterialTransOutDetailsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Branch] nvarchar(15) NULL, [EntryDate] datetime NULL, [ItemCode] nvarchar(50) NULL, [ItemName] nvarchar(2000) NULL, [Damage] decimal(18, 4) NULL, [Unit] nvarchar(500) NULL, [Qty] decimal(18, 4) NULL, [Rate] decimal(18, 4) NULL, [Amount] decimal(18, 4) NULL, [SR] nvarchar(500) NULL, [SlNo] decimal(18, 4) NULL, [Cost] decimal(18, 4) NULL, [InvoiceRetNo] nvarchar(500) NULL, [InvoiceDate] datetime NULL, [DocumentNo] nvarchar(500) NULL, [InvNo] nvarchar(500) NULL, [SQTY] decimal(18, 4) NULL, [Sales] decimal(18, 4) NULL, [Stock] decimal(18, 4) NULL, [purrate] decimal(18, 4) NULL, [qtyperunit] decimal(18, 4) NULL, [storeshop] nvarchar(500) NULL ); INSERT INTO dbo.[MaterialTransOutDetails_New] ([Branch], [EntryDate], [ItemCode], [ItemName], [Damage], [Unit], [Qty], [Rate], [Amount], [SR], [SlNo], [Cost], [InvoiceRetNo], [InvoiceDate], [DocumentNo], [InvNo], [SQTY], [Sales], [Stock], [purrate], [qtyperunit], [storeshop]) SELECT [Branch], [EntryDate], [ItemCode], [ItemName], [Damage], [Unit], [Qty], [Rate], [Amount], [SR], [SlNo], [Cost], [InvoiceRetNo], [InvoiceDate], [DocumentNo], [InvNo], [SQTY], [Sales], [Stock], [purrate], [qtyperunit], [storeshop] FROM [MaterialTransOutDetails]; DROP TABLE dbo.[MaterialTransOutDetails]; EXEC sp_rename 'dbo.MaterialTransOutDetails_New', 'MaterialTransOutDetails'; GO CREATE TABLE [dbo].[ModeOfPay_New] ( [ModeOfPayId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [id] decimal(18, 4) NULL, [code] nvarchar(500) NULL, [mode] nvarchar(500) NULL ); INSERT INTO dbo.[ModeOfPay_New] ([id], [code], [mode]) SELECT [id], [code], [mode] FROM [ModeOfPay]; DROP TABLE dbo.[ModeOfPay]; EXEC sp_rename 'dbo.ModeOfPay_New', 'ModeOfPay'; GO CREATE TABLE [dbo].[OpeningInvoiceDetails_New] ( [OpeningInvoiceDetailsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Slno] nvarchar(500) NULL, [custcode] nvarchar(2000) NULL, [invdate] datetime NULL, [invno] nvarchar(500) NULL, [PONO] nvarchar(2000) NULL, [invamt] decimal(18, 4) NULL, [recamt] decimal(18, 4) NULL, [retamt] decimal(18, 4) NULL, [BalanceAmt] decimal(18, 4) NULL, [Salesman] nvarchar(500) NULL ); INSERT INTO dbo.[OpeningInvoiceDetails_New] ([Slno], [custcode], [invdate], [invno], [PONO], [invamt], [recamt], [retamt], [BalanceAmt], [Salesman]) SELECT [Slno], [custcode], [invdate], [invno], [PONO], [invamt], [recamt], [retamt], [BalanceAmt], [Salesman] FROM [OpeningInvoiceDetails]; DROP TABLE dbo.[OpeningInvoiceDetails]; EXEC sp_rename 'dbo.OpeningInvoiceDetails_New', 'OpeningInvoiceDetails'; GO CREATE TABLE [dbo].[OpeningPurchaseInvoiceDetails_New] ( [OpeningPurchaseInvoiceDetailsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Slno] nvarchar(500) NULL, [Suppcode] nvarchar(2000) NULL, [Docdate] datetime NULL, [Docno] nvarchar(500) NULL, [PurInvNo] nvarchar(2000) NULL, [PONO] nvarchar(200) NULL, [VoucherAmt] decimal(18, 4) NULL, [PaidAmt] decimal(18, 4) NULL, [retamt] decimal(18, 4) NULL, [BalanceAmt] decimal(18, 4) NULL, [Purchaser] nvarchar(500) NULL ); INSERT INTO dbo.[OpeningPurchaseInvoiceDetails_New] ([Slno], [Suppcode], [Docdate], [Docno], [PurInvNo], [PONO], [VoucherAmt], [PaidAmt], [retamt], [BalanceAmt], [Purchaser]) SELECT [Slno], [Suppcode], [Docdate], [Docno], [PurInvNo], [PONO], [VoucherAmt], [PaidAmt], [retamt], [BalanceAmt], [Purchaser] FROM [OpeningPurchaseInvoiceDetails]; DROP TABLE dbo.[OpeningPurchaseInvoiceDetails]; EXEC sp_rename 'dbo.OpeningPurchaseInvoiceDetails_New', 'OpeningPurchaseInvoiceDetails'; GO CREATE TABLE [dbo].[OpeningStockEntry_New] ( [OpeningStockEntryId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [DocNo] nvarchar(500) NULL, [EnteredBy] nvarchar(500) NULL, [Remarks] nvarchar(500) NULL, [username] nvarchar(500) NULL, [BranchName] nvarchar(500) NULL ); INSERT INTO dbo.[OpeningStockEntry_New] ([EntryDate], [DocNo], [EnteredBy], [Remarks], [username], [BranchName]) SELECT [EntryDate], [DocNo], [EnteredBy], [Remarks], [username], [BranchName] FROM [OpeningStockEntry]; DROP TABLE dbo.[OpeningStockEntry]; EXEC sp_rename 'dbo.OpeningStockEntry_New', 'OpeningStockEntry'; GO CREATE TABLE [dbo].[OpeningStockEntryItem_New] ( [OpeningStockEntryItemId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [docno] nvarchar(500) NULL, [ItemCode] nvarchar(500) NULL, [ItemName] nvarchar(500) NULL, [ArabicName] nvarchar(500) NULL, [LocName] nvarchar(500) NULL, [Unit] nvarchar(50) NULL, [Quantity] decimal(18, 4) NULL, [Rate] decimal(18, 4) NULL, [Amount] decimal(18, 4) NULL, [SlNo] decimal(18, 4) NULL, [Vatper] decimal(18, 4) NULL, [VatAmt] decimal(18, 4) NULL, [STORESHOP] nvarchar(500) NULL, [qtyperunit] decimal(18, 4) NULL, [BranchName] nvarchar(500) NULL ); INSERT INTO dbo.[OpeningStockEntryItem_New] ([EntryDate], [docno], [ItemCode], [ItemName], [ArabicName], [LocName], [Unit], [Quantity], [Rate], [Amount], [SlNo], [Vatper], [VatAmt], [STORESHOP], [qtyperunit], [BranchName]) SELECT [EntryDate], [docno], [ItemCode], [ItemName], [ArabicName], [LocName], [Unit], [Quantity], [Rate], [Amount], [SlNo], [Vatper], [VatAmt], [STORESHOP], [qtyperunit], [BranchName] FROM [OpeningStockEntryItem]; DROP TABLE dbo.[OpeningStockEntryItem]; EXEC sp_rename 'dbo.OpeningStockEntryItem_New', 'OpeningStockEntryItem'; GO CREATE TABLE [dbo].[OpeningStockEntryItemForupdate_New] ( [OpeningStockEntryItemForupdateId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [docno] nvarchar(500) NULL, [ItemCode] nvarchar(500) NULL, [ItemName] nvarchar(500) NULL, [ArabicName] nvarchar(500) NULL, [LocName] nvarchar(500) NULL, [Unit] nvarchar(50) NULL, [Quantity] decimal(18, 4) NULL, [Rate] decimal(18, 4) NULL, [Amount] decimal(18, 4) NULL, [SlNo] decimal(18, 4) NULL, [Vatper] decimal(18, 4) NULL, [VatAmt] decimal(18, 4) NULL, [STORESHOP] nvarchar(500) NULL, [qtyperunit] decimal(18, 4) NULL, [BranchName] nvarchar(500) NULL ); INSERT INTO dbo.[OpeningStockEntryItemForupdate_New] ([EntryDate], [docno], [ItemCode], [ItemName], [ArabicName], [LocName], [Unit], [Quantity], [Rate], [Amount], [SlNo], [Vatper], [VatAmt], [STORESHOP], [qtyperunit], [BranchName]) SELECT [EntryDate], [docno], [ItemCode], [ItemName], [ArabicName], [LocName], [Unit], [Quantity], [Rate], [Amount], [SlNo], [Vatper], [VatAmt], [STORESHOP], [qtyperunit], [BranchName] FROM [OpeningStockEntryItemForupdate]; DROP TABLE dbo.[OpeningStockEntryItemForupdate]; EXEC sp_rename 'dbo.OpeningStockEntryItemForupdate_New', 'OpeningStockEntryItemForupdate'; GO CREATE TABLE [dbo].[PaymentToEmployee_New] ( [PaymentToEmployeeId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [RefNo] int NULL, [TicDate] datetime NULL, [EmpCode] varchar(50) NULL, [EmpName] varchar(100) NULL, [Growth] varchar(100) NULL, [FromPlace] varchar(100) NULL, [ToPlace] varchar(100) NULL, [TicAmount] decimal(18, 4) NULL, [CreditAcCode] varchar(50) NULL, [CreditAcName] varchar(200) NULL, [DebitAcCode] varchar(50) NULL, [DebitAcName] varchar(200) NULL, [PayType] varchar(100) NULL, [Narration] nvarchar(500) NULL, [Accountant] varchar(100) NULL, [ApprovedBy] varchar(100) NULL, [Title] nvarchar(150) NULL, [projectcode] nvarchar(50) NULL, [projectname] nvarchar(150) NULL ); INSERT INTO dbo.[PaymentToEmployee_New] ([RefNo], [TicDate], [EmpCode], [EmpName], [Growth], [FromPlace], [ToPlace], [TicAmount], [CreditAcCode], [CreditAcName], [DebitAcCode], [DebitAcName], [PayType], [Narration], [Accountant], [ApprovedBy], [Title], [projectcode], [projectname]) SELECT [RefNo], [TicDate], [EmpCode], [EmpName], [Growth], [FromPlace], [ToPlace], [TicAmount], [CreditAcCode], [CreditAcName], [DebitAcCode], [DebitAcName], [PayType], [Narration], [Accountant], [ApprovedBy], [Title], [projectcode], [projectname] FROM [PaymentToEmployee]; DROP TABLE dbo.[PaymentToEmployee]; EXEC sp_rename 'dbo.PaymentToEmployee_New', 'PaymentToEmployee'; GO CREATE TABLE [dbo].[PaymentType_New] ( [PaymentTypeId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [PTypeCode] varchar(50) NULL, [PTypeName] varchar(100) NULL, [Remarks] varchar(200) NULL ); INSERT INTO dbo.[PaymentType_New] ([PTypeCode], [PTypeName], [Remarks]) SELECT [PTypeCode], [PTypeName], [Remarks] FROM [PaymentType]; DROP TABLE dbo.[PaymentType]; EXEC sp_rename 'dbo.PaymentType_New', 'PaymentType'; GO CREATE TABLE [dbo].[PermanentSettings_New] ( [PermanentSettingsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [custcode] nvarchar(5) NULL, [suppcode] nvarchar(5) NULL, [ItemCode] nvarchar(5) NULL, [focuson] nvarchar(500) NULL, [DiscFocusOn] nvarchar(200) NULL, [ConnectOn] nvarchar(250) NULL, [QuotBfrItem] nvarchar(50) NULL, [AllsysIntegration] nvarchar(50) NULL, [invbilltype] nvarchar(500) NULL, [PurBilltype] nvarchar(500) NULL, [ProInvBilltype] nvarchar(500) NULL, [ItemSelection] nvarchar(5) NULL, [CrDaysBlock] nvarchar(10) NULL, [StoreEnable] nvarchar(10) NULL, [InvWL] nvarchar(10) NULL, [InvRetWL] nvarchar(10) NULL, [InvDNWL] nvarchar(10) NULL, [ProInvWL] nvarchar(10) NULL, [QuotWL] nvarchar(10) NULL, [DNWL] nvarchar(10) NULL, [POWL] nvarchar(10) NULL, [InvTaxType] nvarchar(10) NULL, [InvRetTaxType] nvarchar(10) NULL, [InvDNTaxType] nvarchar(10) NULL, [InvFocusStartFrom] nvarchar(500) NULL, [PurFocusStartFrom] nvarchar(500) NULL, [InvNoString] nvarchar(5) NULL, [DeliveryFocusStartFrom] nvarchar(500) NULL, [Replacement] nvarchar(5) NULL, [QuotFocusStartFrom] nvarchar(500) NULL, [InvPP] nvarchar(10) NULL, [InvRetPP] nvarchar(10) NULL, [InvDNPP] nvarchar(10) NULL, [ProInvPP] nvarchar(10) NULL, [QuotPP] nvarchar(10) NULL, [DNPP] nvarchar(10) NULL, [POPP] nvarchar(10) NULL, [POFocusStartFrom] nvarchar(500) NULL, [DeliveryEffect] nvarchar(5) NULL, [DNItemSlno] nvarchar(5) NULL, [InvItemSlno] nvarchar(5) NULL, [QuotItemSlno] nvarchar(5) NULL, [PRInvItemSlno] nvarchar(5) NULL, [ItemPrefix] nvarchar(5) NULL, [ItemPrefixvalue] nvarchar(50) NULL, [ItemSearchCount] decimal(18, 4) NULL, [ExpDfltVat] decimal(18, 4) NULL, [JrnlDfltVat] decimal(18, 4) NULL, [Itmsrhfilt] nvarchar(5) NULL, [Fcsaftitmto] nvarchar(50) NULL, [ShowStdCost] nvarchar(500) NULL, [ItCodeColWidth] decimal(18, 4) NULL, [ItNameColWidth] decimal(18, 4) NULL, [ArItNameColWidth] decimal(18, 4) NULL, [UnitColWidth] decimal(18, 4) NULL, [StkColWidth] decimal(18, 4) NULL, [RateColWidth] decimal(18, 4) NULL, [CostColWidth] decimal(18, 4) NULL, [ModelColWidth] decimal(18, 4) NULL, [LocColWidth] decimal(18, 4) NULL, [TrnsSrchCnt] decimal(18, 4) NULL, [DfltCshCode] nvarchar(500) NULL, [DfltCshName] nvarchar(500) NULL, [DfltBnkCode] nvarchar(500) NULL, [DfltBnkName] nvarchar(500) NULL, [Apptype] nvarchar(500) NULL, [UnitSelection] nvarchar(50) NULL, [UIType] nvarchar(50) NULL, [CustNameBlank] nvarchar(5) NULL ); INSERT INTO dbo.[PermanentSettings_New] ([custcode], [suppcode], [ItemCode], [focuson], [DiscFocusOn], [ConnectOn], [QuotBfrItem], [AllsysIntegration], [invbilltype], [PurBilltype], [ProInvBilltype], [ItemSelection], [CrDaysBlock], [StoreEnable], [InvWL], [InvRetWL], [InvDNWL], [ProInvWL], [QuotWL], [DNWL], [POWL], [InvTaxType], [InvRetTaxType], [InvDNTaxType], [InvFocusStartFrom], [PurFocusStartFrom], [InvNoString], [DeliveryFocusStartFrom], [Replacement], [QuotFocusStartFrom], [InvPP], [InvRetPP], [InvDNPP], [ProInvPP], [QuotPP], [DNPP], [POPP], [POFocusStartFrom], [DeliveryEffect], [DNItemSlno], [InvItemSlno], [QuotItemSlno], [PRInvItemSlno], [ItemPrefix], [ItemPrefixvalue], [ItemSearchCount], [ExpDfltVat], [JrnlDfltVat], [Itmsrhfilt], [Fcsaftitmto], [ShowStdCost], [ItCodeColWidth], [ItNameColWidth], [ArItNameColWidth], [UnitColWidth], [StkColWidth], [RateColWidth], [CostColWidth], [ModelColWidth], [LocColWidth], [TrnsSrchCnt], [DfltCshCode], [DfltCshName], [DfltBnkCode], [DfltBnkName], [Apptype], [UnitSelection], [UIType], [CustNameBlank]) SELECT [custcode], [suppcode], [ItemCode], [focuson], [DiscFocusOn], [ConnectOn], [QuotBfrItem], [AllsysIntegration], [invbilltype], [PurBilltype], [ProInvBilltype], [ItemSelection], [CrDaysBlock], [StoreEnable], [InvWL], [InvRetWL], [InvDNWL], [ProInvWL], [QuotWL], [DNWL], [POWL], [InvTaxType], [InvRetTaxType], [InvDNTaxType], [InvFocusStartFrom], [PurFocusStartFrom], [InvNoString], [DeliveryFocusStartFrom], [Replacement], [QuotFocusStartFrom], [InvPP], [InvRetPP], [InvDNPP], [ProInvPP], [QuotPP], [DNPP], [POPP], [POFocusStartFrom], [DeliveryEffect], [DNItemSlno], [InvItemSlno], [QuotItemSlno], [PRInvItemSlno], [ItemPrefix], [ItemPrefixvalue], [ItemSearchCount], [ExpDfltVat], [JrnlDfltVat], [Itmsrhfilt], [Fcsaftitmto], [ShowStdCost], [ItCodeColWidth], [ItNameColWidth], [ArItNameColWidth], [UnitColWidth], [StkColWidth], [RateColWidth], [CostColWidth], [ModelColWidth], [LocColWidth], [TrnsSrchCnt], [DfltCshCode], [DfltCshName], [DfltBnkCode], [DfltBnkName], [Apptype], [UnitSelection], [UIType], [CustNameBlank] FROM [PermanentSettings]; DROP TABLE dbo.[PermanentSettings]; EXEC sp_rename 'dbo.PermanentSettings_New', 'PermanentSettings'; GO CREATE TABLE [dbo].[ProductionEntryMaster_New] ( [ProductionEntryMasterId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [DocNo] nvarchar(2000) NULL, [EntryDate] datetime NULL, [REMARKS] nvarchar(500) NULL, [userNAME] nvarchar(500) NULL, [Deleted] nvarchar(20) NULL ); INSERT INTO dbo.[ProductionEntryMaster_New] ([DocNo], [EntryDate], [REMARKS], [userNAME], [Deleted]) SELECT [DocNo], [EntryDate], [REMARKS], [userNAME], [Deleted] FROM [ProductionEntryMaster]; DROP TABLE dbo.[ProductionEntryMaster]; EXEC sp_rename 'dbo.ProductionEntryMaster_New', 'ProductionEntryMaster'; GO CREATE TABLE [dbo].[ProductionMasterItem_New] ( [ProductionMasterItemId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [SlNo] nvarchar(500) NULL, [ItemCode] nvarchar(2000) NULL, [ItemName] nvarchar(2000) NULL, [Unit] nvarchar(2000) NULL, [Qty] decimal(18, 4) NULL, [DocNo] nvarchar(2000) NULL, [PartNo] nvarchar(2000) NULL, [qtyperunit] decimal(18, 4) NULL, [COST] decimal(18, 4) NULL, [Deleted] nvarchar(20) NULL, [PACKINGQTY] decimal(18, 4) NULL, [storeshop] nvarchar(500) NULL ); INSERT INTO dbo.[ProductionMasterItem_New] ([SlNo], [ItemCode], [ItemName], [Unit], [Qty], [DocNo], [PartNo], [qtyperunit], [COST], [Deleted], [PACKINGQTY], [storeshop]) SELECT [SlNo], [ItemCode], [ItemName], [Unit], [Qty], [DocNo], [PartNo], [qtyperunit], [COST], [Deleted], [PACKINGQTY], [storeshop] FROM [ProductionMasterItem]; DROP TABLE dbo.[ProductionMasterItem]; EXEC sp_rename 'dbo.ProductionMasterItem_New', 'ProductionMasterItem'; GO CREATE TABLE [dbo].[ProductionMasterItemFP_New] ( [ProductionMasterItemFPId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [SlNo] nvarchar(500) NULL, [ItemCode] nvarchar(2000) NULL, [ItemName] nvarchar(2000) NULL, [Unit] nvarchar(2000) NULL, [Qty] decimal(18, 4) NULL, [DocNo] nvarchar(2000) NULL, [PartNo] nvarchar(2000) NULL, [qtyperunit] decimal(18, 4) NULL, [COST] decimal(18, 4) NULL, [Deleted] nvarchar(20) NULL, [PACKINGQTY] decimal(18, 4) NULL, [storeshop] nvarchar(500) NULL ); INSERT INTO dbo.[ProductionMasterItemFP_New] ([SlNo], [ItemCode], [ItemName], [Unit], [Qty], [DocNo], [PartNo], [qtyperunit], [COST], [Deleted], [PACKINGQTY], [storeshop]) SELECT [SlNo], [ItemCode], [ItemName], [Unit], [Qty], [DocNo], [PartNo], [qtyperunit], [COST], [Deleted], [PACKINGQTY], [storeshop] FROM [ProductionMasterItemFP]; DROP TABLE dbo.[ProductionMasterItemFP]; EXEC sp_rename 'dbo.ProductionMasterItemFP_New', 'ProductionMasterItemFP'; GO CREATE TABLE [dbo].[ProformaInvoice_New] ( [ProformaInvoiceId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Branch] nvarchar(500) NULL, [EntryDate] datetime NULL, [InvNo] nvarchar(500) NULL, [ReturnInvoiceNo] nvarchar(500) NULL, [BillType] nvarchar(500) NULL, [RefNo] nvarchar(500) NULL, [PONo] nvarchar(500) NULL, [CustomerCode] nvarchar(500) NULL, [CustomerName] nvarchar(2000) NULL, [Address] nvarchar(2000) NULL, [Phone] nvarchar(500) NULL, [Fax] nvarchar(500) NULL, [Attended] nvarchar(2000) NULL, [GrossAmount] decimal(18, 4) NULL, [LessPerc] decimal(18, 4) NULL, [LessAmount] decimal(18, 4) NULL, [NetAmount] decimal(18, 4) NULL, [SR] nvarchar(500) NULL, [AddLess] decimal(18, 4) NULL, [Remarks] nvarchar(2000) NULL, [Received] decimal(18, 4) NULL, [DnNo] nvarchar(150) NULL, [QuotNo] nvarchar(500) NULL, [Flag] char NULL, [CreditPeriod] nvarchar(500) NULL, [ReceivedAmount] decimal(18, 4) NULL, [UserName] nvarchar(500) NULL, [InvoiceRetNo] nvarchar(500) NULL, [ReceivedAmt] decimal(18, 4) NULL, [ChangeAmount] decimal(18, 4) NULL, [InvoiceDate] datetime NULL, [Narration] nvarchar(2000) NULL, [voucherNo] nvarchar(500) NULL, [Commision] decimal(18, 4) NULL, [Stock] decimal(18, 4) NULL, [Status] char NULL, [Bank1] char NULL, [Bank2] nvarchar(150) NULL, [Bank3] nvarchar(150) NULL, [Bank4] nvarchar(500) NULL, [Del1] nvarchar(500) NULL, [Del2] nvarchar(500) NULL, [Del3] nvarchar(500) NULL, [Del4] nvarchar(500) NULL, [PODate] datetime NULL, [Freight] nvarchar(500) NULL, [Retention] nvarchar(500) NULL, [DelDate] datetime NULL, [ProjectNo] nvarchar(500) NULL, [Deleted] nvarchar(500) NULL, [AccountCode] nvarchar(500) NULL, [AccountName] nvarchar(2000) NULL, [ReceiptNo] nvarchar(500) NULL, [hijridate] datetime NULL, [Remarks1] nvarchar(2000) NULL, [Mobile] nvarchar(500) NULL, [TransApp] nvarchar(500) NULL, [vattotal] decimal(18, 4) NULL, [Vatno] nvarchar(200) NULL, [crdays] decimal(18, 4) NULL, [invdueDate] datetime NULL, [NETDISC] decimal(18, 4) NULL, [Detail1] nvarchar(2000) NULL, [Detail2] nvarchar(2000) NULL, [Detail3] nvarchar(2000) NULL, [Detail4] nvarchar(2000) NULL, [Detail5] nvarchar(2000) NULL, [Detail6] nvarchar(2000) NULL, [Detail7] nvarchar(2000) NULL, [Detail8] nvarchar(2000) NULL, [Detail9] nvarchar(2000) NULL, [Detail10] nvarchar(2000) NULL, [DetailDate1] datetime NULL, [DetailDate2] datetime NULL, [DetailDate3] datetime NULL, [DetailDate4] datetime NULL ); INSERT INTO dbo.[ProformaInvoice_New] ([Branch], [EntryDate], [InvNo], [ReturnInvoiceNo], [BillType], [RefNo], [PONo], [CustomerCode], [CustomerName], [Address], [Phone], [Fax], [Attended], [GrossAmount], [LessPerc], [LessAmount], [NetAmount], [SR], [AddLess], [Remarks], [Received], [DnNo], [QuotNo], [Flag], [CreditPeriod], [ReceivedAmount], [UserName], [InvoiceRetNo], [ReceivedAmt], [ChangeAmount], [InvoiceDate], [Narration], [voucherNo], [Commision], [Stock], [Status], [Bank1], [Bank2], [Bank3], [Bank4], [Del1], [Del2], [Del3], [Del4], [PODate], [Freight], [Retention], [DelDate], [ProjectNo], [Deleted], [AccountCode], [AccountName], [ReceiptNo], [hijridate], [Remarks1], [Mobile], [TransApp], [vattotal], [Vatno], [crdays], [invdueDate], [NETDISC], [Detail1], [Detail2], [Detail3], [Detail4], [Detail5], [Detail6], [Detail7], [Detail8], [Detail9], [Detail10], [DetailDate1], [DetailDate2], [DetailDate3], [DetailDate4]) SELECT [Branch], [EntryDate], [InvNo], [ReturnInvoiceNo], [BillType], [RefNo], [PONo], [CustomerCode], [CustomerName], [Address], [Phone], [Fax], [Attended], [GrossAmount], [LessPerc], [LessAmount], [NetAmount], [SR], [AddLess], [Remarks], [Received], [DnNo], [QuotNo], [Flag], [CreditPeriod], [ReceivedAmount], [UserName], [InvoiceRetNo], [ReceivedAmt], [ChangeAmount], [InvoiceDate], [Narration], [voucherNo], [Commision], [Stock], [Status], [Bank1], [Bank2], [Bank3], [Bank4], [Del1], [Del2], [Del3], [Del4], [PODate], [Freight], [Retention], [DelDate], [ProjectNo], [Deleted], [AccountCode], [AccountName], [ReceiptNo], [hijridate], [Remarks1], [Mobile], [TransApp], [vattotal], [Vatno], [crdays], [invdueDate], [NETDISC], [Detail1], [Detail2], [Detail3], [Detail4], [Detail5], [Detail6], [Detail7], [Detail8], [Detail9], [Detail10], [DetailDate1], [DetailDate2], [DetailDate3], [DetailDate4] FROM [ProformaInvoice]; DROP TABLE dbo.[ProformaInvoice]; EXEC sp_rename 'dbo.ProformaInvoice_New', 'ProformaInvoice'; GO CREATE TABLE [dbo].[ProformaInvoiceItem_New] ( [ProformaInvoiceItemId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Branch] nvarchar(15) NULL, [EntryDate] datetime NULL, [ItemCode] nvarchar(500) NULL, [ItemName] nvarchar(2000) NULL, [Damage] decimal(18, 4) NULL, [Unit] nvarchar(50) NULL, [Qty] decimal(18, 4) NULL, [Rate] decimal(18, 4) NULL, [Amount] decimal(18, 4) NULL, [SR] nvarchar(500) NULL, [SlNo] decimal(18, 4) NULL, [Cost] decimal(18, 4) NULL, [InvoiceRetNo] nvarchar(500) NULL, [InvoiceDate] datetime NULL, [DocumentNo] decimal(18, 4) NULL, [InvNo] nvarchar(500) NULL, [SQTY] decimal(18, 4) NULL, [Sales] decimal(18, 4) NULL, [QtyPerUnit] decimal(18, 4) NULL, [TOTQty] decimal(18, 4) NULL, [PerQty] decimal(18, 4) NULL, [PartNo] nvarchar(2000) NULL, [stdcost] decimal(18, 4) NULL, [RateAfterDisc] decimal(18, 4) NULL, [RetQty] decimal(18, 4) NULL, [DNNo] nvarchar(500) NULL, [Deleted] nvarchar(500) NULL, [VATPER] decimal(18, 4) NULL, [VATAMT] decimal(18, 4) NULL, [IDISCPER] decimal(18, 4) NULL, [IDISCONRATE] decimal(18, 4) NULL, [IDISCONINCRATE] decimal(18, 4) NULL, [storeshop] nvarchar(500) NULL, [ItemDetail1] nvarchar(500) NULL, [ItemDetail2] nvarchar(500) NULL, [ItemDetail3] nvarchar(500) NULL, [ItemDetail4] nvarchar(500) NULL, [ItemDetail5] nvarchar(500) NULL, [ItemDetail6] nvarchar(500) NULL, [ItemDetail7] nvarchar(500) NULL, [ItemDetail8] nvarchar(500) NULL, [ItemDetail9] nvarchar(500) NULL, [ItemDetail10] nvarchar(500) NULL, [ItemDetailDate1] datetime NULL, [ItemDetailDate2] datetime NULL, [ItemDetailDate3] datetime NULL, [ItemDetailDate4] datetime NULL ); INSERT INTO dbo.[ProformaInvoiceItem_New] ([Branch], [EntryDate], [ItemCode], [ItemName], [Damage], [Unit], [Qty], [Rate], [Amount], [SR], [SlNo], [Cost], [InvoiceRetNo], [InvoiceDate], [DocumentNo], [InvNo], [SQTY], [Sales], [QtyPerUnit], [TOTQty], [PerQty], [PartNo], [stdcost], [RateAfterDisc], [RetQty], [DNNo], [Deleted], [VATPER], [VATAMT], [IDISCPER], [IDISCONRATE], [IDISCONINCRATE], [storeshop], [ItemDetail1], [ItemDetail2], [ItemDetail3], [ItemDetail4], [ItemDetail5], [ItemDetail6], [ItemDetail7], [ItemDetail8], [ItemDetail9], [ItemDetail10], [ItemDetailDate1], [ItemDetailDate2], [ItemDetailDate3], [ItemDetailDate4]) SELECT [Branch], [EntryDate], [ItemCode], [ItemName], [Damage], [Unit], [Qty], [Rate], [Amount], [SR], [SlNo], [Cost], [InvoiceRetNo], [InvoiceDate], [DocumentNo], [InvNo], [SQTY], [Sales], [QtyPerUnit], [TOTQty], [PerQty], [PartNo], [stdcost], [RateAfterDisc], [RetQty], [DNNo], [Deleted], [VATPER], [VATAMT], [IDISCPER], [IDISCONRATE], [IDISCONINCRATE], [storeshop], [ItemDetail1], [ItemDetail2], [ItemDetail3], [ItemDetail4], [ItemDetail5], [ItemDetail6], [ItemDetail7], [ItemDetail8], [ItemDetail9], [ItemDetail10], [ItemDetailDate1], [ItemDetailDate2], [ItemDetailDate3], [ItemDetailDate4] FROM [ProformaInvoiceItem]; DROP TABLE dbo.[ProformaInvoiceItem]; EXEC sp_rename 'dbo.ProformaInvoiceItem_New', 'ProformaInvoiceItem'; GO CREATE TABLE [dbo].[ProformaInvoiceLog_New] ( [ProformaInvoiceLogId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [InvNo] nvarchar(500) NULL, [BillType] nvarchar(500) NULL, [CreditPeriod] nvarchar(500) NULL, [CustomerCode] nvarchar(500) NULL, [CustomerName] nvarchar(2000) NULL, [Phone] nvarchar(500) NULL, [Attended] nvarchar(2000) NULL, [Remarks] nvarchar(2000) NULL, [GrossAmount] decimal(18, 4) NULL, [ReceivedAmt] decimal(18, 4) NULL, [LessPerc] decimal(18, 4) NULL, [LessAmount] decimal(18, 4) NULL, [ChangeAmount] decimal(18, 4) NULL, [NetAmount] decimal(18, 4) NULL, [UserName] nvarchar(500) NULL, [System] nvarchar(500) NULL, [DateAndTime] datetime NULL, [Action] nvarchar(500) NULL ); INSERT INTO dbo.[ProformaInvoiceLog_New] ([EntryDate], [InvNo], [BillType], [CreditPeriod], [CustomerCode], [CustomerName], [Phone], [Attended], [Remarks], [GrossAmount], [ReceivedAmt], [LessPerc], [LessAmount], [ChangeAmount], [NetAmount], [UserName], [System], [DateAndTime], [Action]) SELECT [EntryDate], [InvNo], [BillType], [CreditPeriod], [CustomerCode], [CustomerName], [Phone], [Attended], [Remarks], [GrossAmount], [ReceivedAmt], [LessPerc], [LessAmount], [ChangeAmount], [NetAmount], [UserName], [System], [DateAndTime], [Action] FROM [ProformaInvoiceLog]; DROP TABLE dbo.[ProformaInvoiceLog]; EXEC sp_rename 'dbo.ProformaInvoiceLog_New', 'ProformaInvoiceLog'; GO CREATE TABLE [dbo].[Project_New] ( [ProjectId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [CustCode] nvarchar(500) NULL, [Customer] nvarchar(2000) NULL, [Project] nvarchar(500) NULL, [ProjectCode] nvarchar(500) NULL, [Amount] decimal(18, 4) NULL, [Description] nvarchar(2000) NULL, [EntryDate] datetime NULL ); INSERT INTO dbo.[Project_New] ([CustCode], [Customer], [Project], [ProjectCode], [Amount], [Description], [EntryDate]) SELECT [CustCode], [Customer], [Project], [ProjectCode], [Amount], [Description], [EntryDate] FROM [Project]; DROP TABLE dbo.[Project]; EXEC sp_rename 'dbo.Project_New', 'Project'; GO CREATE TABLE [dbo].[Purchase_New] ( [PurchaseId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [BillType] nvarchar(500) NULL, [DocumentNo] nvarchar(500) NULL, [InvoiceNo] nvarchar(500) NULL, [RefNo] nvarchar(500) NULL, [PONo] nvarchar(500) NULL, [InvoiceDate] datetime NULL, [SupplierCode] nvarchar(500) NULL, [SupplierName] nvarchar(2000) NULL, [Address] nvarchar(2000) NULL, [GrossAmount] decimal(18, 4) NULL, [Freight] decimal(18, 4) NULL, [Commission] decimal(18, 4) NULL, [UnLoading] decimal(18, 4) NULL, [Others] decimal(18, 4) NULL, [Discount] decimal(18, 4) NULL, [NetAmount] decimal(18, 4) NULL, [KeyFld] decimal(18, 4) NULL, [PR] nvarchar(500) NULL, [Currency] nvarchar(500) NULL, [ExchangeRate] decimal(18, 4) NULL, [Flag] char NULL, [AcCode] nvarchar(500) NULL, [ReceivedAmount] decimal(18, 4) NULL, [UserName] nvarchar(500) NULL, [Attended] nvarchar(2000) NULL, [PurchaseRet] nvarchar(2000) NULL, [Narration] nvarchar(2000) NULL, [VoucherNo] nvarchar(500) NULL, [purType] nvarchar(500) NULL, [Status] nvarchar(500) NULL, [DLRgross] decimal(18, 4) NULL, [DLRnet] decimal(18, 4) NULL, [Deleted] nvarchar(500) NULL, [Mobile] nvarchar(500) NULL, [vattotal] decimal(18, 4) NULL, [Vatno] nvarchar(200) NULL, [PaymentNo] nvarchar(50) NULL, [ACNAME] nvarchar(250) NULL, [LESS] decimal(18, 4) NULL, [PurchaseInvNo] nvarchar(500) NULL, [SupInvNo] nvarchar(500) NULL, [NETDISC] decimal(18, 4) NULL, [GRNNO] nvarchar(100) NULL ); INSERT INTO dbo.[Purchase_New] ([EntryDate], [BillType], [DocumentNo], [InvoiceNo], [RefNo], [PONo], [InvoiceDate], [SupplierCode], [SupplierName], [Address], [GrossAmount], [Freight], [Commission], [UnLoading], [Others], [Discount], [NetAmount], [KeyFld], [PR], [Currency], [ExchangeRate], [Flag], [AcCode], [ReceivedAmount], [UserName], [Attended], [PurchaseRet], [Narration], [VoucherNo], [purType], [Status], [DLRgross], [DLRnet], [Deleted], [Mobile], [vattotal], [Vatno], [PaymentNo], [ACNAME], [LESS], [PurchaseInvNo], [SupInvNo], [NETDISC], [GRNNO]) SELECT [EntryDate], [BillType], [DocumentNo], [InvoiceNo], [RefNo], [PONo], [InvoiceDate], [SupplierCode], [SupplierName], [Address], [GrossAmount], [Freight], [Commission], [UnLoading], [Others], [Discount], [NetAmount], [KeyFld], [PR], [Currency], [ExchangeRate], [Flag], [AcCode], [ReceivedAmount], [UserName], [Attended], [PurchaseRet], [Narration], [VoucherNo], [purType], [Status], [DLRgross], [DLRnet], [Deleted], [Mobile], [vattotal], [Vatno], [PaymentNo], [ACNAME], [LESS], [PurchaseInvNo], [SupInvNo], [NETDISC], [GRNNO] FROM [Purchase]; DROP TABLE dbo.[Purchase]; EXEC sp_rename 'dbo.Purchase_New', 'Purchase'; GO CREATE TABLE [dbo].[PurchaseBKP_New] ( [PurchaseBKPId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [BillType] nvarchar(500) NULL, [DocumentNo] nvarchar(500) NULL, [InvoiceNo] nvarchar(500) NULL, [RefNo] nvarchar(500) NULL, [PONo] nvarchar(500) NULL, [InvoiceDate] datetime NULL, [SupplierCode] nvarchar(500) NULL, [SupplierName] nvarchar(2000) NULL, [Address] nvarchar(2000) NULL, [GrossAmount] decimal(18, 4) NULL, [Freight] decimal(18, 4) NULL, [Commission] decimal(18, 4) NULL, [UnLoading] decimal(18, 4) NULL, [Others] decimal(18, 4) NULL, [Discount] decimal(18, 4) NULL, [NetAmount] decimal(18, 4) NULL, [KeyFld] decimal(18, 4) NULL, [PR] nvarchar(500) NULL, [Currency] nvarchar(500) NULL, [ExchangeRate] decimal(18, 4) NULL, [Flag] char NULL, [AcCode] nvarchar(500) NULL, [ReceivedAmount] decimal(18, 4) NULL, [UserName] nvarchar(500) NULL, [Attended] nvarchar(2000) NULL, [PurchaseRet] nvarchar(500) NULL, [Narration] nvarchar(2000) NULL, [VoucherNo] nvarchar(500) NULL, [purType] nvarchar(500) NULL, [Status] nvarchar(500) NULL ); INSERT INTO dbo.[PurchaseBKP_New] ([EntryDate], [BillType], [DocumentNo], [InvoiceNo], [RefNo], [PONo], [InvoiceDate], [SupplierCode], [SupplierName], [Address], [GrossAmount], [Freight], [Commission], [UnLoading], [Others], [Discount], [NetAmount], [KeyFld], [PR], [Currency], [ExchangeRate], [Flag], [AcCode], [ReceivedAmount], [UserName], [Attended], [PurchaseRet], [Narration], [VoucherNo], [purType], [Status]) SELECT [EntryDate], [BillType], [DocumentNo], [InvoiceNo], [RefNo], [PONo], [InvoiceDate], [SupplierCode], [SupplierName], [Address], [GrossAmount], [Freight], [Commission], [UnLoading], [Others], [Discount], [NetAmount], [KeyFld], [PR], [Currency], [ExchangeRate], [Flag], [AcCode], [ReceivedAmount], [UserName], [Attended], [PurchaseRet], [Narration], [VoucherNo], [purType], [Status] FROM [PurchaseBKP]; DROP TABLE dbo.[PurchaseBKP]; EXEC sp_rename 'dbo.PurchaseBKP_New', 'PurchaseBKP'; GO CREATE TABLE [dbo].[PurchaseItem_New] ( [PurchaseItemId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [ItemCode] nvarchar(500) NULL, [ItemName] nvarchar(2000) NULL, [Unit] nvarchar(50) NULL, [Qty] decimal(18, 4) NULL, [Damage] decimal(18, 4) NULL, [Rate] decimal(18, 4) NULL, [Amount] decimal(18, 4) NULL, [KeyFld] decimal(18, 4) NULL, [EntryDate] datetime NULL, [PR] nvarchar(500) NULL, [SlNo] decimal(18, 4) NULL, [username] nvarchar(500) NULL, [DocumentNo] nvarchar(500) NULL, [InvoiceNo] nvarchar(500) NULL, [PurchaseRet] nvarchar(500) NULL, [PQTY] decimal(18, 4) NULL, [RateAfterDisc] decimal(18, 4) NULL, [SalesRate] decimal(18, 4) NULL, [QtyPerUnit] decimal(18, 4) NULL, [conrate] decimal(18, 4) NULL, [Deleted] nvarchar(500) NULL, [RateAfterexp] decimal(18, 4) NULL, [VATPER] decimal(18, 4) NULL, [VATAMT] decimal(18, 4) NULL, [PartNo] nvarchar(2000) NULL, [FRATE] decimal(18, 4) NULL, [PCRATE] decimal(18, 4) NULL, [Disc] decimal(18, 4) NULL, [DisconRate] decimal(18, 4) NULL, [IDISCONINCRATE] decimal(18, 4) NULL, [storeshop] nvarchar(500) NULL ); INSERT INTO dbo.[PurchaseItem_New] ([ItemCode], [ItemName], [Unit], [Qty], [Damage], [Rate], [Amount], [KeyFld], [EntryDate], [PR], [SlNo], [username], [DocumentNo], [InvoiceNo], [PurchaseRet], [PQTY], [RateAfterDisc], [SalesRate], [QtyPerUnit], [conrate], [Deleted], [RateAfterexp], [VATPER], [VATAMT], [PartNo], [FRATE], [PCRATE], [Disc], [DisconRate], [IDISCONINCRATE], [storeshop]) SELECT [ItemCode], [ItemName], [Unit], [Qty], [Damage], [Rate], [Amount], [KeyFld], [EntryDate], [PR], [SlNo], [username], [DocumentNo], [InvoiceNo], [PurchaseRet], [PQTY], [RateAfterDisc], [SalesRate], [QtyPerUnit], [conrate], [Deleted], [RateAfterexp], [VATPER], [VATAMT], [PartNo], [FRATE], [PCRATE], [Disc], [DisconRate], [IDISCONINCRATE], [storeshop] FROM [PurchaseItem]; DROP TABLE dbo.[PurchaseItem]; EXEC sp_rename 'dbo.PurchaseItem_New', 'PurchaseItem'; GO CREATE TABLE [dbo].[PurchaseOrder_New] ( [PurchaseOrderId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [RefNo] nvarchar(500) NULL, [SupplierRefNo] nvarchar(500) NULL, [PONo] nvarchar(500) NULL, [SupplierCode] nvarchar(500) NULL, [SupplierName] nvarchar(2000) NULL, [Address] nvarchar(2000) NULL, [Telephone] nvarchar(500) NULL, [Fax] nvarchar(500) NULL, [Attended] nvarchar(2000) NULL, [GrossAmount] decimal(18, 4) NULL, [Discount] decimal(18, 4) NULL, [NetAmount] decimal(18, 4) NULL, [KeyFld] decimal(18, 4) NULL, [Less] decimal(18, 4) NULL, [Attention] nvarchar(2000) NULL, [Remarks] nvarchar(2000) NULL, [Flag] char NULL, [DeliveryTime] nvarchar(500) NULL, [PaymentsTerms] nvarchar(500) NULL, [UserName] nvarchar(500) NULL, [QuotDate] datetime NULL, [Del1] nvarchar(500) NULL, [Del2] nvarchar(500) NULL, [Del3] nvarchar(500) NULL, [Del4] nvarchar(500) NULL, [Freight] nvarchar(500) NULL, [Transport] nvarchar(500) NULL, [Mobile] nvarchar(500) NULL, [Vatno] nvarchar(500) NULL, [Vattotal] decimal(18, 4) NULL, [NETDISC] decimal(18, 4) NULL, [LESSPER] decimal(18, 4) NULL, [Currency] nvarchar(500) NULL, [ExchangeRate] decimal(18, 4) NULL ); INSERT INTO dbo.[PurchaseOrder_New] ([EntryDate], [RefNo], [SupplierRefNo], [PONo], [SupplierCode], [SupplierName], [Address], [Telephone], [Fax], [Attended], [GrossAmount], [Discount], [NetAmount], [KeyFld], [Less], [Attention], [Remarks], [Flag], [DeliveryTime], [PaymentsTerms], [UserName], [QuotDate], [Del1], [Del2], [Del3], [Del4], [Freight], [Transport], [Mobile], [Vatno], [Vattotal], [NETDISC], [LESSPER], [Currency], [ExchangeRate]) SELECT [EntryDate], [RefNo], [SupplierRefNo], [PONo], [SupplierCode], [SupplierName], [Address], [Telephone], [Fax], [Attended], [GrossAmount], [Discount], [NetAmount], [KeyFld], [Less], [Attention], [Remarks], [Flag], [DeliveryTime], [PaymentsTerms], [UserName], [QuotDate], [Del1], [Del2], [Del3], [Del4], [Freight], [Transport], [Mobile], [Vatno], [Vattotal], [NETDISC], [LESSPER], [Currency], [ExchangeRate] FROM [PurchaseOrder]; DROP TABLE dbo.[PurchaseOrder]; EXEC sp_rename 'dbo.PurchaseOrder_New', 'PurchaseOrder'; GO CREATE TABLE [dbo].[PurchaseOrderItem_New] ( [PurchaseOrderItemId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [ItemCode] nvarchar(500) NULL, [ItemName] nvarchar(2000) NULL, [Unit] nvarchar(50) NULL, [Qty] decimal(18, 4) NULL, [Rate] decimal(18, 4) NULL, [Amount] decimal(18, 4) NULL, [SlNo] decimal(18, 4) NULL, [PONo] nvarchar(500) NULL, [SalesRate] decimal(18, 4) NULL, [PartNo] nvarchar(2000) NULL, [Vatper] decimal(18, 4) NULL, [VatAmt] decimal(18, 4) NULL, [storeshop] nvarchar(500) NULL ); INSERT INTO dbo.[PurchaseOrderItem_New] ([EntryDate], [ItemCode], [ItemName], [Unit], [Qty], [Rate], [Amount], [SlNo], [PONo], [SalesRate], [PartNo], [Vatper], [VatAmt], [storeshop]) SELECT [EntryDate], [ItemCode], [ItemName], [Unit], [Qty], [Rate], [Amount], [SlNo], [PONo], [SalesRate], [PartNo], [Vatper], [VatAmt], [storeshop] FROM [PurchaseOrderItem]; DROP TABLE dbo.[PurchaseOrderItem]; EXEC sp_rename 'dbo.PurchaseOrderItem_New', 'PurchaseOrderItem'; GO CREATE TABLE [dbo].[Purchaser_New] ( [PurchaserId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Code] nvarchar(15) NULL, [Name] nvarchar(2000) NULL, [Remarks] nvarchar(2000) NULL, [NameAR] nvarchar(2000) NULL, [RemarksAR] nvarchar(2000) NULL, [CrLimit] money NULL, [AcCode] nvarchar(500) NULL, [Description] nvarchar(2000) NULL ); INSERT INTO dbo.[Purchaser_New] ([Code], [Name], [Remarks], [NameAR], [RemarksAR], [CrLimit], [AcCode], [Description]) SELECT [Code], [Name], [Remarks], [NameAR], [RemarksAR], [CrLimit], [AcCode], [Description] FROM [Purchaser]; DROP TABLE dbo.[Purchaser]; EXEC sp_rename 'dbo.Purchaser_New', 'Purchaser'; GO CREATE TABLE [dbo].[QtyAdjustment_New] ( [QtyAdjustmentId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [DocNO] nvarchar(500) NULL, [Entered] nvarchar(2000) NULL, [gross] decimal(18, 4) NULL ); INSERT INTO dbo.[QtyAdjustment_New] ([EntryDate], [DocNO], [Entered], [gross]) SELECT [EntryDate], [DocNO], [Entered], [gross] FROM [QtyAdjustment]; DROP TABLE dbo.[QtyAdjustment]; EXEC sp_rename 'dbo.QtyAdjustment_New', 'QtyAdjustment'; GO CREATE TABLE [dbo].[QtyAdjustmentDetails_New] ( [QtyAdjustmentDetailsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [DocNO] nvarchar(500) NULL, [SlNo] decimal(18, 4) NULL, [ItemCode] nvarchar(500) NULL, [ItemName] nvarchar(2000) NULL, [Qty] decimal(18, 4) NULL, [Reason] nvarchar(2000) NULL, [CurrentQty] decimal(18, 4) NULL, [unit] nvarchar(50) NULL, [qtyperunit] decimal(18, 4) NULL, [newqty] decimal(18, 4) NULL, [prate] decimal(18, 4) NULL, [storeshop] nvarchar(500) NULL ); INSERT INTO dbo.[QtyAdjustmentDetails_New] ([EntryDate], [DocNO], [SlNo], [ItemCode], [ItemName], [Qty], [Reason], [CurrentQty], [unit], [qtyperunit], [newqty], [prate], [storeshop]) SELECT [EntryDate], [DocNO], [SlNo], [ItemCode], [ItemName], [Qty], [Reason], [CurrentQty], [unit], [qtyperunit], [newqty], [prate], [storeshop] FROM [QtyAdjustmentDetails]; DROP TABLE dbo.[QtyAdjustmentDetails]; EXEC sp_rename 'dbo.QtyAdjustmentDetails_New', 'QtyAdjustmentDetails'; GO CREATE TABLE [dbo].[Quotation_New] ( [QuotationId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [QuotationNo] nvarchar(500) NULL, [RefNo] nvarchar(500) NULL, [Attended] nvarchar(2000) NULL, [CustomerCode] nvarchar(500) NULL, [CustomerName] nvarchar(2000) NULL, [Address] nvarchar(2000) NULL, [Telephone] nvarchar(500) NULL, [Fax] nvarchar(500) NULL, [Attention] nvarchar(2000) NULL, [NetAmount] decimal(18, 4) NULL, [KeyFld] decimal(18, 4) NULL, [PaymentTerms] nvarchar(500) NULL, [Validity] nvarchar(500) NULL, [PlaceOfDelivery] nvarchar(500) NULL, [DeliveryTime] nvarchar(500) NULL, [Flag] nvarchar(500) NULL, [Less] decimal(18, 4) NULL, [LessPerc] decimal(18, 4) NULL, [GrossAmount] decimal(18, 4) NULL, [Remarks] nvarchar(2000) NULL, [UserName] nvarchar(500) NULL, [PenQuo] bit NULL, [custRefNo] nvarchar(500) NULL, [SalesMan] nvarchar(2000) NULL, [AttenMob] nvarchar(500) NULL, [AttenEmail] nvarchar(500) NULL, [CustEmail] nvarchar(500) NULL, [RFQDate] datetime NULL, [Del1] nvarchar(500) NULL, [Del2] nvarchar(500) NULL, [Del3] nvarchar(500) NULL, [Del4] nvarchar(500) NULL, [freight] nvarchar(500) NULL, [Trans] nvarchar(500) NULL, [dnno] nvarchar(100) NULL, [Mobile] nvarchar(500) NULL, [Vatno] nvarchar(200) NULL, [Vattotal] decimal(18, 4) NULL, [NETDISC] decimal(18, 4) NULL, [Detail1] nvarchar(2000) NULL, [Detail2] nvarchar(2000) NULL, [Detail3] nvarchar(2000) NULL, [Detail4] nvarchar(2000) NULL, [Detail5] nvarchar(2000) NULL, [Detail6] nvarchar(2000) NULL, [Detail7] nvarchar(2000) NULL, [Detail8] nvarchar(2000) NULL, [Detail9] nvarchar(2000) NULL, [Detail10] nvarchar(2000) NULL, [DetailDate1] datetime NULL, [DetailDate2] datetime NULL, [DetailDate3] datetime NULL, [DetailDate4] datetime NULL ); INSERT INTO dbo.[Quotation_New] ([EntryDate], [QuotationNo], [RefNo], [Attended], [CustomerCode], [CustomerName], [Address], [Telephone], [Fax], [Attention], [NetAmount], [KeyFld], [PaymentTerms], [Validity], [PlaceOfDelivery], [DeliveryTime], [Flag], [Less], [LessPerc], [GrossAmount], [Remarks], [UserName], [PenQuo], [custRefNo], [SalesMan], [AttenMob], [AttenEmail], [CustEmail], [RFQDate], [Del1], [Del2], [Del3], [Del4], [freight], [Trans], [dnno], [Mobile], [Vatno], [Vattotal], [NETDISC], [Detail1], [Detail2], [Detail3], [Detail4], [Detail5], [Detail6], [Detail7], [Detail8], [Detail9], [Detail10], [DetailDate1], [DetailDate2], [DetailDate3], [DetailDate4]) SELECT [EntryDate], [QuotationNo], [RefNo], [Attended], [CustomerCode], [CustomerName], [Address], [Telephone], [Fax], [Attention], [NetAmount], [KeyFld], [PaymentTerms], [Validity], [PlaceOfDelivery], [DeliveryTime], [Flag], [Less], [LessPerc], [GrossAmount], [Remarks], [UserName], [PenQuo], [custRefNo], [SalesMan], [AttenMob], [AttenEmail], [CustEmail], [RFQDate], [Del1], [Del2], [Del3], [Del4], [freight], [Trans], [dnno], [Mobile], [Vatno], [Vattotal], [NETDISC], [Detail1], [Detail2], [Detail3], [Detail4], [Detail5], [Detail6], [Detail7], [Detail8], [Detail9], [Detail10], [DetailDate1], [DetailDate2], [DetailDate3], [DetailDate4] FROM [Quotation]; DROP TABLE dbo.[Quotation]; EXEC sp_rename 'dbo.Quotation_New', 'Quotation'; GO CREATE TABLE [dbo].[QuotationItem_New] ( [QuotationItemId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [ItemCode] nvarchar(500) NULL, [ItemName] nvarchar(2000) NULL, [Unit] nvarchar(50) NULL, [Qty] decimal(18, 4) NULL, [Rate] decimal(18, 4) NULL, [Amount] decimal(18, 4) NULL, [KeyFld] nvarchar(500) NULL, [SlNo] decimal(18, 4) NULL, [Remarks] nvarchar(2000) NULL, [QuotationNo] nvarchar(500) NULL, [qtyperunit] decimal(18, 4) NULL, [partno] nvarchar(2000) NULL, [VatAmt] decimal(18, 4) NULL, [Vatper] decimal(18, 4) NULL, [IDiscPer] decimal(18, 4) NULL, [IDiscRate] decimal(18, 4) NULL, [DISCONINCRATE] decimal(18, 4) NULL, [stdcost] decimal(18, 4) NULL, [storeshop] nvarchar(500) NULL, [ItemDetail1] nvarchar(500) NULL, [ItemDetail2] nvarchar(500) NULL, [ItemDetail3] nvarchar(500) NULL, [ItemDetail4] nvarchar(500) NULL, [ItemDetail5] nvarchar(500) NULL, [ItemDetail6] nvarchar(500) NULL, [ItemDetail7] nvarchar(500) NULL, [ItemDetail8] nvarchar(500) NULL, [ItemDetail9] nvarchar(500) NULL, [ItemDetail10] nvarchar(500) NULL, [ItemDetailDate1] datetime NULL, [ItemDetailDate2] datetime NULL, [ItemDetailDate3] datetime NULL, [ItemDetailDate4] datetime NULL ); INSERT INTO dbo.[QuotationItem_New] ([EntryDate], [ItemCode], [ItemName], [Unit], [Qty], [Rate], [Amount], [KeyFld], [SlNo], [Remarks], [QuotationNo], [qtyperunit], [partno], [VatAmt], [Vatper], [IDiscPer], [IDiscRate], [DISCONINCRATE], [stdcost], [storeshop], [ItemDetail1], [ItemDetail2], [ItemDetail3], [ItemDetail4], [ItemDetail5], [ItemDetail6], [ItemDetail7], [ItemDetail8], [ItemDetail9], [ItemDetail10], [ItemDetailDate1], [ItemDetailDate2], [ItemDetailDate3], [ItemDetailDate4]) SELECT [EntryDate], [ItemCode], [ItemName], [Unit], [Qty], [Rate], [Amount], [KeyFld], [SlNo], [Remarks], [QuotationNo], [qtyperunit], [partno], [VatAmt], [Vatper], [IDiscPer], [IDiscRate], [DISCONINCRATE], [stdcost], [storeshop], [ItemDetail1], [ItemDetail2], [ItemDetail3], [ItemDetail4], [ItemDetail5], [ItemDetail6], [ItemDetail7], [ItemDetail8], [ItemDetail9], [ItemDetail10], [ItemDetailDate1], [ItemDetailDate2], [ItemDetailDate3], [ItemDetailDate4] FROM [QuotationItem]; DROP TABLE dbo.[QuotationItem]; EXEC sp_rename 'dbo.QuotationItem_New', 'QuotationItem'; GO CREATE TABLE [dbo].[QuotationLog_New] ( [QuotationLogId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [QuotationNo] nvarchar(500) NULL, [CustomerCode] nvarchar(500) NULL, [CustomerName] nvarchar(2000) NULL, [Phone] nvarchar(500) NULL, [Attended] nvarchar(2000) NULL, [Fax] nvarchar(500) NULL, [Attention] nvarchar(2000) NULL, [PaymentTerms] nvarchar(500) NULL, [Validity] nvarchar(500) NULL, [GrossAmt] decimal(18, 4) NULL, [NetAmount] decimal(18, 4) NULL, [UserName] nvarchar(500) NULL, [System] nvarchar(500) NULL, [DateAndTime] datetime NULL, [Action] nvarchar(500) NULL ); INSERT INTO dbo.[QuotationLog_New] ([EntryDate], [QuotationNo], [CustomerCode], [CustomerName], [Phone], [Attended], [Fax], [Attention], [PaymentTerms], [Validity], [GrossAmt], [NetAmount], [UserName], [System], [DateAndTime], [Action]) SELECT [EntryDate], [QuotationNo], [CustomerCode], [CustomerName], [Phone], [Attended], [Fax], [Attention], [PaymentTerms], [Validity], [GrossAmt], [NetAmount], [UserName], [System], [DateAndTime], [Action] FROM [QuotationLog]; DROP TABLE dbo.[QuotationLog]; EXEC sp_rename 'dbo.QuotationLog_New', 'QuotationLog'; GO CREATE TABLE [dbo].[ReceiptDetails_New] ( [ReceiptDetailsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [ItemCode] nvarchar(500) NULL, [ItemName] nvarchar(2000) NULL, [Qty] decimal(18, 4) NULL, [Rate] money NULL, [KeyFld] nvarchar(500) NULL, [EntryDate] datetime NULL, [ItemNAmeAR] nvarchar(2000) NULL, [SoldFlag] nvarchar(1) NULL, [SlNo] decimal(18, 4) NULL ); INSERT INTO dbo.[ReceiptDetails_New] ([ItemCode], [ItemName], [Qty], [Rate], [KeyFld], [EntryDate], [ItemNAmeAR], [SoldFlag], [SlNo]) SELECT [ItemCode], [ItemName], [Qty], [Rate], [KeyFld], [EntryDate], [ItemNAmeAR], [SoldFlag], [SlNo] FROM [ReceiptDetails]; DROP TABLE dbo.[ReceiptDetails]; EXEC sp_rename 'dbo.ReceiptDetails_New', 'ReceiptDetails'; GO CREATE TABLE [dbo].[ReceiptFromEmployee_New] ( [ReceiptFromEmployeeId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [RefNo] int NULL, [TicDate] datetime NULL, [EmpCode] varchar(50) NULL, [EmpName] varchar(100) NULL, [Growth] varchar(100) NULL, [FromPlace] varchar(100) NULL, [ToPlace] varchar(100) NULL, [TicAmount] decimal(18, 4) NULL, [CreditAcCode] varchar(50) NULL, [CreditAcName] varchar(200) NULL, [DebitAcCode] varchar(50) NULL, [DebitAcName] varchar(200) NULL, [PayType] varchar(100) NULL, [Narration] nvarchar(500) NULL, [Accountant] varchar(100) NULL, [ApprovedBy] varchar(100) NULL, [Title] nvarchar(150) NULL, [projectcode] nvarchar(50) NULL, [projectname] nvarchar(150) NULL ); INSERT INTO dbo.[ReceiptFromEmployee_New] ([RefNo], [TicDate], [EmpCode], [EmpName], [Growth], [FromPlace], [ToPlace], [TicAmount], [CreditAcCode], [CreditAcName], [DebitAcCode], [DebitAcName], [PayType], [Narration], [Accountant], [ApprovedBy], [Title], [projectcode], [projectname]) SELECT [RefNo], [TicDate], [EmpCode], [EmpName], [Growth], [FromPlace], [ToPlace], [TicAmount], [CreditAcCode], [CreditAcName], [DebitAcCode], [DebitAcName], [PayType], [Narration], [Accountant], [ApprovedBy], [Title], [projectcode], [projectname] FROM [ReceiptFromEmployee]; DROP TABLE dbo.[ReceiptFromEmployee]; EXEC sp_rename 'dbo.ReceiptFromEmployee_New', 'ReceiptFromEmployee'; GO CREATE TABLE [dbo].[Replacement_New] ( [ReplacementId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [ReplacementCode] decimal(18, 4) NULL, [ItemCode] varchar(100) NULL, [ItemName] varchar(100) NULL, [RepItemCode] varchar(100) NULL, [RepItemName] varchar(100) NULL, [id] int NULL ); INSERT INTO dbo.[Replacement_New] ([ReplacementCode], [ItemCode], [ItemName], [RepItemCode], [RepItemName], [id]) SELECT [ReplacementCode], [ItemCode], [ItemName], [RepItemCode], [RepItemName], [id] FROM [Replacement]; DROP TABLE dbo.[Replacement]; EXEC sp_rename 'dbo.Replacement_New', 'Replacement'; GO CREATE TABLE [dbo].[RFQToSupplier_New] ( [RFQToSupplierId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [RefNo] nvarchar(100) NULL, [RFQNo] decimal(18, 4) NULL, [SalesMan] nvarchar(2000) NULL, [SupplierCode] nvarchar(15) NULL, [SupplierName] nvarchar(2000) NULL, [Address] nvarchar(2000) NULL, [Telephone] nvarchar(100) NULL, [Fax] nvarchar(100) NULL, [Attention] nvarchar(2000) NULL, [Remarks] nvarchar(2000) NULL, [KeyFld] nvarchar(15) NULL, [Flag] char NULL, [Salutation] nvarchar(2000) NULL, [UserName] nvarchar(500) NULL, [RFQDate] datetime NULL, [Del1] nvarchar(500) NULL, [Del2] nvarchar(500) NULL, [Del3] nvarchar(500) NULL, [Del4] nvarchar(500) NULL, [PayTerms] nvarchar(500) NULL, [Mobile] nvarchar(500) NULL, [Vatno] nvarchar(200) NULL ); INSERT INTO dbo.[RFQToSupplier_New] ([EntryDate], [RefNo], [RFQNo], [SalesMan], [SupplierCode], [SupplierName], [Address], [Telephone], [Fax], [Attention], [Remarks], [KeyFld], [Flag], [Salutation], [UserName], [RFQDate], [Del1], [Del2], [Del3], [Del4], [PayTerms], [Mobile], [Vatno]) SELECT [EntryDate], [RefNo], [RFQNo], [SalesMan], [SupplierCode], [SupplierName], [Address], [Telephone], [Fax], [Attention], [Remarks], [KeyFld], [Flag], [Salutation], [UserName], [RFQDate], [Del1], [Del2], [Del3], [Del4], [PayTerms], [Mobile], [Vatno] FROM [RFQToSupplier]; DROP TABLE dbo.[RFQToSupplier]; EXEC sp_rename 'dbo.RFQToSupplier_New', 'RFQToSupplier'; GO CREATE TABLE [dbo].[RFQToSupplierDetails_New] ( [RFQToSupplierDetailsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [ItemCode] nvarchar(200) NULL, [ItemName] nvarchar(2000) NULL, [Unit] nvarchar(50) NULL, [Qty] decimal(18, 4) NULL, [EntryDate] datetime NULL, [SlNo] decimal(18, 4) NULL, [Remarks] nvarchar(2000) NULL, [status] nvarchar(500) NULL, [RFQNo] nvarchar(500) NULL, [PartNo] nvarchar(2000) NULL, [storeshop] nvarchar(500) NULL ); INSERT INTO dbo.[RFQToSupplierDetails_New] ([ItemCode], [ItemName], [Unit], [Qty], [EntryDate], [SlNo], [Remarks], [status], [RFQNo], [PartNo], [storeshop]) SELECT [ItemCode], [ItemName], [Unit], [Qty], [EntryDate], [SlNo], [Remarks], [status], [RFQNo], [PartNo], [storeshop] FROM [RFQToSupplierDetails]; DROP TABLE dbo.[RFQToSupplierDetails]; EXEC sp_rename 'dbo.RFQToSupplierDetails_New', 'RFQToSupplierDetails'; GO CREATE TABLE [dbo].[SalesMan_New] ( [SalesManId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Code] nvarchar(15) NULL, [Name] nvarchar(2000) NULL, [Remarks] nvarchar(2000) NULL, [NameAR] nvarchar(2000) NULL, [RemarksAR] nvarchar(2000) NULL, [CrLimit] money NULL, [AcCode] nvarchar(15) NULL, [Designation] nvarchar(150) NULL, [Mobile] nvarchar(500) NULL, [Email] nvarchar(500) NULL ); INSERT INTO dbo.[SalesMan_New] ([Code], [Name], [Remarks], [NameAR], [RemarksAR], [CrLimit], [AcCode], [Designation], [Mobile], [Email]) SELECT [Code], [Name], [Remarks], [NameAR], [RemarksAR], [CrLimit], [AcCode], [Designation], [Mobile], [Email] FROM [SalesMan]; DROP TABLE dbo.[SalesMan]; EXEC sp_rename 'dbo.SalesMan_New', 'SalesMan'; GO CREATE TABLE [dbo].[SaveData_New] ( [SaveDataId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [ItemCode] nvarchar(500) NULL, [ItemName] nvarchar(2000) NULL, [Qty] nvarchar(500) NULL, [Unit] nvarchar(500) NULL, [Slno] nvarchar(500) NULL, [RefNo] nvarchar(500) NULL, [RFQNo] nvarchar(500) NULL ); INSERT INTO dbo.[SaveData_New] ([ItemCode], [ItemName], [Qty], [Unit], [Slno], [RefNo], [RFQNo]) SELECT [ItemCode], [ItemName], [Qty], [Unit], [Slno], [RefNo], [RFQNo] FROM [SaveData]; DROP TABLE dbo.[SaveData]; EXEC sp_rename 'dbo.SaveData_New', 'SaveData'; GO CREATE TABLE [dbo].[ScreenColourSettings_New] ( [ScreenColourSettingsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [BGInvoice] nvarchar(500) NULL, [BGInvoiceReturn] nvarchar(500) NULL, [BGInvoiceDebitNote] nvarchar(500) NULL, [BGProformaInvoice] nvarchar(500) NULL, [BGQuotation] nvarchar(500) NULL, [BGDeliveryNote] nvarchar(500) NULL, [BGPurchase] nvarchar(500) NULL, [BGPurchaseReturn] nvarchar(500) NULL, [BGPO] nvarchar(500) NULL, [BGGoodsReceipt] nvarchar(500) NULL, [BGEnquiry] nvarchar(500) NULL, [BGRFQ] nvarchar(500) NULL, [BGProduction] nvarchar(500) NULL, [BGTransIn] nvarchar(500) NULL, [BGTransOut] nvarchar(500) NULL, [BGDamage] nvarchar(500) NULL, [BGStockAdjustment] nvarchar(500) NULL, [BGCustReceipt] nvarchar(500) NULL, [BGSuppPayment] nvarchar(500) NULL, [BGExpenseEntry] nvarchar(500) NULL, [BGJournalEntry] nvarchar(500) NULL, [BGPaymentTOEmployee] nvarchar(500) NULL, [BGReceiptFromEmployee] nvarchar(500) NULL, [BGTimesheetentry] nvarchar(500) NULL, [BGACMaster] nvarchar(500) NULL, [BGACHeadMaster] nvarchar(500) NULL, [BGCatGoryMaster] nvarchar(500) NULL, [BGBrandMaster] nvarchar(500) NULL, [BGCurrencyMaster] nvarchar(500) NULL, [BGCustomerMaster] nvarchar(500) NULL, [BGProductMaster] nvarchar(500) NULL, [BGPurchaserMaster] nvarchar(500) NULL, [BGSalesManMaster] nvarchar(500) NULL, [BGSupplierMaster] nvarchar(500) NULL, [BGUnitMaster] nvarchar(500) NULL, [BGLocationMaster] nvarchar(500) NULL, [BGVatMaster] nvarchar(500) NULL, [BGDefaultAccMaster] nvarchar(500) NULL, [BGBranchMaster] nvarchar(500) NULL, [BGCountryMaster] nvarchar(500) NULL, [BGCustWiseProdMaster] nvarchar(500) NULL, [BGEmpMaster] nvarchar(500) NULL, [BGTitleMaster] nvarchar(500) NULL, [BGStatusMaster] nvarchar(500) NULL, [BGDeptMaster] nvarchar(500) NULL, [BGProjectMaster] nvarchar(500) NULL, [BGPaymentType] nvarchar(500) NULL, [BGStoreMaster] nvarchar(500) NULL, [BGOPStockEntry] nvarchar(500) NULL, [BGReplacementMaster] nvarchar(500) NULL, [BGDBBackup] nvarchar(500) NULL, [BGUserAccounts] nvarchar(500) NULL, [BGUpdateSetup] nvarchar(500) NULL, [BGStockStartDate] nvarchar(500) NULL, [BGUserPermission] nvarchar(500) NULL, [BGFinYear] nvarchar(500) NULL, [BGBalanceTransfer] nvarchar(500) NULL, [BGBarcodeSettings] nvarchar(500) NULL, [BGCompanyDetails] nvarchar(500) NULL, [BGYearUnlock] nvarchar(500) NULL, [BGBackgroundSettings] nvarchar(500) NULL, [BGApplicationBackGround] nvarchar(500) NULL, [BGReportsBackground] nvarchar(500) NULL ); INSERT INTO dbo.[ScreenColourSettings_New] ([BGInvoice], [BGInvoiceReturn], [BGInvoiceDebitNote], [BGProformaInvoice], [BGQuotation], [BGDeliveryNote], [BGPurchase], [BGPurchaseReturn], [BGPO], [BGGoodsReceipt], [BGEnquiry], [BGRFQ], [BGProduction], [BGTransIn], [BGTransOut], [BGDamage], [BGStockAdjustment], [BGCustReceipt], [BGSuppPayment], [BGExpenseEntry], [BGJournalEntry], [BGPaymentTOEmployee], [BGReceiptFromEmployee], [BGTimesheetentry], [BGACMaster], [BGACHeadMaster], [BGCatGoryMaster], [BGBrandMaster], [BGCurrencyMaster], [BGCustomerMaster], [BGProductMaster], [BGPurchaserMaster], [BGSalesManMaster], [BGSupplierMaster], [BGUnitMaster], [BGLocationMaster], [BGVatMaster], [BGDefaultAccMaster], [BGBranchMaster], [BGCountryMaster], [BGCustWiseProdMaster], [BGEmpMaster], [BGTitleMaster], [BGStatusMaster], [BGDeptMaster], [BGProjectMaster], [BGPaymentType], [BGStoreMaster], [BGOPStockEntry], [BGReplacementMaster], [BGDBBackup], [BGUserAccounts], [BGUpdateSetup], [BGStockStartDate], [BGUserPermission], [BGFinYear], [BGBalanceTransfer], [BGBarcodeSettings], [BGCompanyDetails], [BGYearUnlock], [BGBackgroundSettings], [BGApplicationBackGround], [BGReportsBackground]) SELECT [BGInvoice], [BGInvoiceReturn], [BGInvoiceDebitNote], [BGProformaInvoice], [BGQuotation], [BGDeliveryNote], [BGPurchase], [BGPurchaseReturn], [BGPO], [BGGoodsReceipt], [BGEnquiry], [BGRFQ], [BGProduction], [BGTransIn], [BGTransOut], [BGDamage], [BGStockAdjustment], [BGCustReceipt], [BGSuppPayment], [BGExpenseEntry], [BGJournalEntry], [BGPaymentTOEmployee], [BGReceiptFromEmployee], [BGTimesheetentry], [BGACMaster], [BGACHeadMaster], [BGCatGoryMaster], [BGBrandMaster], [BGCurrencyMaster], [BGCustomerMaster], [BGProductMaster], [BGPurchaserMaster], [BGSalesManMaster], [BGSupplierMaster], [BGUnitMaster], [BGLocationMaster], [BGVatMaster], [BGDefaultAccMaster], [BGBranchMaster], [BGCountryMaster], [BGCustWiseProdMaster], [BGEmpMaster], [BGTitleMaster], [BGStatusMaster], [BGDeptMaster], [BGProjectMaster], [BGPaymentType], [BGStoreMaster], [BGOPStockEntry], [BGReplacementMaster], [BGDBBackup], [BGUserAccounts], [BGUpdateSetup], [BGStockStartDate], [BGUserPermission], [BGFinYear], [BGBalanceTransfer], [BGBarcodeSettings], [BGCompanyDetails], [BGYearUnlock], [BGBackgroundSettings], [BGApplicationBackGround], [BGReportsBackground] FROM [ScreenColourSettings]; DROP TABLE dbo.[ScreenColourSettings]; EXEC sp_rename 'dbo.ScreenColourSettings_New', 'ScreenColourSettings'; GO CREATE TABLE [dbo].[setup_New] ( [setupId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [code] nvarchar(500) NULL, [SValue] nvarchar(500) NULL ); INSERT INTO dbo.[setup_New] ([code], [SValue]) SELECT [code], [SValue] FROM [setup]; DROP TABLE dbo.[setup]; EXEC sp_rename 'dbo.setup_New', 'setup'; GO CREATE TABLE [dbo].[SheetA_New] ( [SheetAId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [GR] nvarchar(255) NULL, [PC] nvarchar(255) NULL, [PN] nvarchar(255) NULL ); INSERT INTO dbo.[SheetA_New] ([GR], [PC], [PN]) SELECT [GR], [PC], [PN] FROM [SheetA]; DROP TABLE dbo.[SheetA]; EXEC sp_rename 'dbo.SheetA_New', 'SheetA'; GO CREATE TABLE [dbo].[SheetO_New] ( [SheetOId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [CATEG] nvarchar(255) NULL, [CODE] nvarchar(53) NULL, [ITNAME] nvarchar(2000) NULL ); INSERT INTO dbo.[SheetO_New] ([CATEG], [CODE], [ITNAME]) SELECT [CATEG], [CODE], [ITNAME] FROM [SheetO]; DROP TABLE dbo.[SheetO]; EXEC sp_rename 'dbo.SheetO_New', 'SheetO'; GO CREATE TABLE [dbo].[Status_New] ( [StatusId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Code] nvarchar(50) NULL, [Name] nvarchar(100) NULL, [Remarks] nvarchar(100) NULL ); INSERT INTO dbo.[Status_New] ([Code], [Name], [Remarks]) SELECT [Code], [Name], [Remarks] FROM [Status]; DROP TABLE dbo.[Status]; EXEC sp_rename 'dbo.Status_New', 'Status'; GO CREATE TABLE [dbo].[Stock_New] ( [StockId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Code] nvarchar(500) NULL, [Name] nvarchar(2000) NULL, [Qty] decimal(18, 4) NULL ); INSERT INTO dbo.[Stock_New] ([Code], [Name], [Qty]) SELECT [Code], [Name], [Qty] FROM [Stock]; DROP TABLE dbo.[Stock]; EXEC sp_rename 'dbo.Stock_New', 'Stock'; GO CREATE TABLE [dbo].[StockReg_New] ( [StockRegId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [ItemName] nvarchar(2000) NULL, [OPStock] decimal(18, 4) NULL, [ItemCode] nvarchar(500) NULL, [category] nvarchar(500) NULL, [PQty] decimal(18, 4) NULL, [SQty] decimal(18, 4) NULL, [closing] decimal(18, 4) NULL ); INSERT INTO dbo.[StockReg_New] ([ItemName], [OPStock], [ItemCode], [category], [PQty], [SQty], [closing]) SELECT [ItemName], [OPStock], [ItemCode], [category], [PQty], [SQty], [closing] FROM [StockReg]; DROP TABLE dbo.[StockReg]; EXEC sp_rename 'dbo.StockReg_New', 'StockReg'; GO CREATE TABLE [dbo].[StockStartDate_New] ( [StockStartDateId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Stockdate] datetime NULL ); INSERT INTO dbo.[StockStartDate_New] ([Stockdate]) SELECT [Stockdate] FROM [StockStartDate]; DROP TABLE dbo.[StockStartDate]; EXEC sp_rename 'dbo.StockStartDate_New', 'StockStartDate'; GO CREATE TABLE [dbo].[StockUpdate_New] ( [StockUpdateId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [ItemCode] nvarchar(500) NULL, [Qty] decimal(18, 4) NULL ); INSERT INTO dbo.[StockUpdate_New] ([ItemCode], [Qty]) SELECT [ItemCode], [Qty] FROM [StockUpdate]; DROP TABLE dbo.[StockUpdate]; EXEC sp_rename 'dbo.StockUpdate_New', 'StockUpdate'; GO CREATE TABLE [dbo].[SuppLedgerReport_New] ( [SuppLedgerReportId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [AcCode] nvarchar(500) NULL, [Amt] decimal(18, 4) NULL ); INSERT INTO dbo.[SuppLedgerReport_New] ([AcCode], [Amt]) SELECT [AcCode], [Amt] FROM [SuppLedgerReport]; DROP TABLE dbo.[SuppLedgerReport]; EXEC sp_rename 'dbo.SuppLedgerReport_New', 'SuppLedgerReport'; GO CREATE TABLE [dbo].[SupplierPayment_New] ( [SupplierPaymentId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [VoucherNo] nvarchar(500) NULL, [KeyFld] nvarchar(15) NULL, [EntryDate] datetime NULL, [Narration] nvarchar(2000) NULL, [TotAmount] decimal(18, 4) NULL, [SupplierCode] nvarchar(500) NULL, [CBCode] nvarchar(500) NULL, [InvoiceNo] nvarchar(500) NULL, [InvoiceAmount] decimal(18, 4) NULL, [InvoiceBalance] decimal(18, 4) NULL, [TMP] nvarchar(1) NULL, [SupplierName] nvarchar(2000) NULL, [Account] nvarchar(500) NULL, [Type] nvarchar(500) NULL, [Purchaser] nvarchar(2000) NULL, [ChkNo] char NULL, [ChkDate] datetime NULL, [AccountCode] nvarchar(500) NULL, [PayMode] nvarchar(500) NULL, [Advance] nvarchar(5) NULL, [AutoFill] nvarchar(5) NULL, [Rvno] nvarchar(100) NULL, [totaldiscount] decimal(18, 4) NULL, [DiscountDetails] nvarchar(2000) NULL ); INSERT INTO dbo.[SupplierPayment_New] ([VoucherNo], [KeyFld], [EntryDate], [Narration], [TotAmount], [SupplierCode], [CBCode], [InvoiceNo], [InvoiceAmount], [InvoiceBalance], [TMP], [SupplierName], [Account], [Type], [Purchaser], [ChkNo], [ChkDate], [AccountCode], [PayMode], [Advance], [AutoFill], [Rvno], [totaldiscount], [DiscountDetails]) SELECT [VoucherNo], [KeyFld], [EntryDate], [Narration], [TotAmount], [SupplierCode], [CBCode], [InvoiceNo], [InvoiceAmount], [InvoiceBalance], [TMP], [SupplierName], [Account], [Type], [Purchaser], [ChkNo], [ChkDate], [AccountCode], [PayMode], [Advance], [AutoFill], [Rvno], [totaldiscount], [DiscountDetails] FROM [SupplierPayment]; DROP TABLE dbo.[SupplierPayment]; EXEC sp_rename 'dbo.SupplierPayment_New', 'SupplierPayment'; GO CREATE TABLE [dbo].[SupplierPaymentDetails_New] ( [SupplierPaymentDetailsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [InvoiceNo] nvarchar(500) NULL, [InvoiceAmount] decimal(18, 4) NULL, [ReceivedAmount] decimal(18, 4) NULL, [BalanceAmount] decimal(18, 4) NULL, [Accode] nvarchar(500) NULL, [VoucherNo] nvarchar(500) NULL, [KeyFld] nvarchar(10) NULL, [slno] decimal(18, 4) NULL, [InvoiceBalance] decimal(18, 4) NULL, [TotalReceived] decimal(18, 4) NULL, [EntryDate] datetime NULL, [BillNo] nvarchar(500) NULL, [Narration] nvarchar(2000) NULL, [Type] nvarchar(500) NULL, [purchaseinvno] nvarchar(500) NULL, [invdate] datetime NULL, [Discount] decimal(18, 4) NULL ); INSERT INTO dbo.[SupplierPaymentDetails_New] ([InvoiceNo], [InvoiceAmount], [ReceivedAmount], [BalanceAmount], [Accode], [VoucherNo], [KeyFld], [slno], [InvoiceBalance], [TotalReceived], [EntryDate], [BillNo], [Narration], [Type], [purchaseinvno], [invdate], [Discount]) SELECT [InvoiceNo], [InvoiceAmount], [ReceivedAmount], [BalanceAmount], [Accode], [VoucherNo], [KeyFld], [slno], [InvoiceBalance], [TotalReceived], [EntryDate], [BillNo], [Narration], [Type], [purchaseinvno], [invdate], [Discount] FROM [SupplierPaymentDetails]; DROP TABLE dbo.[SupplierPaymentDetails]; EXEC sp_rename 'dbo.SupplierPaymentDetails_New', 'SupplierPaymentDetails'; GO CREATE TABLE [dbo].[SupplierReceipt_New] ( [SupplierReceiptId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [DocNo] nvarchar(500) NULL, [EntryDate] datetime NULL, [Narration] nvarchar(2000) NULL, [Amount] decimal(18, 4) NULL, [CustomerCode] nvarchar(500) NULL, [CBCode] nvarchar(500) NULL, [InvoiceNo] nvarchar(500) NULL, [InvoiceAmount] decimal(18, 4) NULL, [InvoiceBalance] decimal(18, 4) NULL, [ChequeNo] nvarchar(500) NULL, [ChequeDate] datetime NULL, [SalesMan] nvarchar(2000) NULL, [TMP] nvarchar(50) NULL, [IdentifyField] nvarchar(500) NULL, [Account] nvarchar(500) NULL, [SalesManCode] nvarchar(500) NULL ); INSERT INTO dbo.[SupplierReceipt_New] ([DocNo], [EntryDate], [Narration], [Amount], [CustomerCode], [CBCode], [InvoiceNo], [InvoiceAmount], [InvoiceBalance], [ChequeNo], [ChequeDate], [SalesMan], [TMP], [IdentifyField], [Account], [SalesManCode]) SELECT [DocNo], [EntryDate], [Narration], [Amount], [CustomerCode], [CBCode], [InvoiceNo], [InvoiceAmount], [InvoiceBalance], [ChequeNo], [ChequeDate], [SalesMan], [TMP], [IdentifyField], [Account], [SalesManCode] FROM [SupplierReceipt]; DROP TABLE dbo.[SupplierReceipt]; EXEC sp_rename 'dbo.SupplierReceipt_New', 'SupplierReceipt'; GO CREATE TABLE [dbo].[SupplierReceiptDetail_New] ( [SupplierReceiptDetailId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [InvoiceAmount] decimal(18, 4) NULL, [ReceivedAmount] decimal(18, 4) NULL, [BalanceAmount] decimal(18, 4) NULL, [Accode] varchar(50) NULL, [VoucherNo] varchar(50) NULL, [KeyFld] nvarchar(10) NULL, [slno] decimal(18, 4) NULL, [InvoiceBalance] decimal(18, 4) NULL, [SuppCode] varchar(50) NULL, [SuppName] varchar(50) NULL, [Amount] decimal(18, 4) NULL, [InvoiceNo] varchar(50) NULL, [Narration] varchar(50) NULL, [IdentifyField] varchar(10) NULL, [DocNo] varchar(50) NULL, [EntryDate] datetime NULL ); INSERT INTO dbo.[SupplierReceiptDetail_New] ([InvoiceAmount], [ReceivedAmount], [BalanceAmount], [Accode], [VoucherNo], [KeyFld], [slno], [InvoiceBalance], [SuppCode], [SuppName], [Amount], [InvoiceNo], [Narration], [IdentifyField], [DocNo], [EntryDate]) SELECT [InvoiceAmount], [ReceivedAmount], [BalanceAmount], [Accode], [VoucherNo], [KeyFld], [slno], [InvoiceBalance], [SuppCode], [SuppName], [Amount], [InvoiceNo], [Narration], [IdentifyField], [DocNo], [EntryDate] FROM [SupplierReceiptDetail]; DROP TABLE dbo.[SupplierReceiptDetail]; EXEC sp_rename 'dbo.SupplierReceiptDetail_New', 'SupplierReceiptDetail'; GO CREATE TABLE [dbo].[tbl_Expense_New] ( [tbl_ExpenseId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [int_ExpenceId] int NULL, [int_GroupId] int NULL, [str_ExpenseName] nvarchar(2000) NULL, [bit_delete] bit NULL ); INSERT INTO dbo.[tbl_Expense_New] ([int_ExpenceId], [int_GroupId], [str_ExpenseName], [bit_delete]) SELECT [int_ExpenceId], [int_GroupId], [str_ExpenseName], [bit_delete] FROM [tbl_Expense]; DROP TABLE dbo.[tbl_Expense]; EXEC sp_rename 'dbo.tbl_Expense_New', 'tbl_Expense'; GO CREATE TABLE [dbo].[tbl_ExpenseGroup_New] ( [tbl_ExpenseGroupId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [int_GroupId] int NULL, [str_groupName] nvarchar(2000) NULL, [bit_delete] bit NULL ); INSERT INTO dbo.[tbl_ExpenseGroup_New] ([int_GroupId], [str_groupName], [bit_delete]) SELECT [int_GroupId], [str_groupName], [bit_delete] FROM [tbl_ExpenseGroup]; DROP TABLE dbo.[tbl_ExpenseGroup]; EXEC sp_rename 'dbo.tbl_ExpenseGroup_New', 'tbl_ExpenseGroup'; GO CREATE TABLE [dbo].[tbl_ExpenseTrans_New] ( [tbl_ExpenseTransId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [int_TransId] int NULL, [int_ExpenseId] int NULL, [dec_Amount] decimal(18, 4) NULL, [str_Description] nvarchar(2000) NULL, [dtm_ExpDate] datetime NULL, [bit_delete] bit NULL ); INSERT INTO dbo.[tbl_ExpenseTrans_New] ([int_TransId], [int_ExpenseId], [dec_Amount], [str_Description], [dtm_ExpDate], [bit_delete]) SELECT [int_TransId], [int_ExpenseId], [dec_Amount], [str_Description], [dtm_ExpDate], [bit_delete] FROM [tbl_ExpenseTrans]; DROP TABLE dbo.[tbl_ExpenseTrans]; EXEC sp_rename 'dbo.tbl_ExpenseTrans_New', 'tbl_ExpenseTrans'; GO CREATE TABLE [dbo].[TblAccounting_New] ( [TblAccountingId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [EntryDate] datetime NULL, [VoucherNo] nvarchar(500) NULL, [AcCode] nvarchar(500) NULL, [Amount] decimal(18, 4) NULL, [Narration] nvarchar(2000) NULL, [SalesMan] nvarchar(2000) NULL, [Type] nvarchar(500) NULL, [billtype] nvarchar(500) NULL ); INSERT INTO dbo.[TblAccounting_New] ([EntryDate], [VoucherNo], [AcCode], [Amount], [Narration], [SalesMan], [Type], [billtype]) SELECT [EntryDate], [VoucherNo], [AcCode], [Amount], [Narration], [SalesMan], [Type], [billtype] FROM [TblAccounting]; DROP TABLE dbo.[TblAccounting]; EXEC sp_rename 'dbo.TblAccounting_New', 'TblAccounting'; GO CREATE TABLE [dbo].[TblDayBook_New] ( [TblDayBookId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [CashSales] decimal(18, 4) NULL, [CreditSales] decimal(18, 4) NULL, [CashSalesReturn] decimal(18, 4) NULL, [CreditSalesReturn] decimal(18, 4) NULL, [CashPurchase] decimal(18, 4) NULL, [CreditPurchase] decimal(18, 4) NULL, [CashPurchaseReturn] decimal(18, 4) NULL, [CreditPurchaseReturn] decimal(18, 4) NULL, [CustRecpt] decimal(18, 4) NULL, [SuppPay] decimal(18, 4) NULL, [Expense] decimal(18, 4) NULL, [BankSales] decimal(18, 4) NULL, [BankPurchase] decimal(18, 4) NULL, [BankPurchaseRet] decimal(18, 4) NULL, [BankSalesRet] decimal(18, 4) NULL, [BankCustRec] decimal(18, 4) NULL, [BankSuppPay] decimal(18, 4) NULL, [BankExpense] decimal(18, 4) NULL, [journal] decimal(18, 4) NULL, [CashDeposit] decimal(18, 4) NULL ); INSERT INTO dbo.[TblDayBook_New] ([CashSales], [CreditSales], [CashSalesReturn], [CreditSalesReturn], [CashPurchase], [CreditPurchase], [CashPurchaseReturn], [CreditPurchaseReturn], [CustRecpt], [SuppPay], [Expense], [BankSales], [BankPurchase], [BankPurchaseRet], [BankSalesRet], [BankCustRec], [BankSuppPay], [BankExpense], [journal], [CashDeposit]) SELECT [CashSales], [CreditSales], [CashSalesReturn], [CreditSalesReturn], [CashPurchase], [CreditPurchase], [CashPurchaseReturn], [CreditPurchaseReturn], [CustRecpt], [SuppPay], [Expense], [BankSales], [BankPurchase], [BankPurchaseRet], [BankSalesRet], [BankCustRec], [BankSuppPay], [BankExpense], [journal], [CashDeposit] FROM [TblDayBook]; DROP TABLE dbo.[TblDayBook]; EXEC sp_rename 'dbo.TblDayBook_New', 'TblDayBook'; GO CREATE TABLE [dbo].[tblDayBookDetail_New] ( [tblDayBookDetailId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Docno] nvarchar(100) NULL, [Entrydate] datetime NULL, [Code] nvarchar(100) NULL, [Name] nvarchar(2000) NULL, [Amount] decimal(18, 4) NULL, [Transtype] nvarchar(500) NULL, [CashorCredit] nvarchar(500) NULL, [InorOut] nvarchar(500) NULL ); INSERT INTO dbo.[tblDayBookDetail_New] ([Docno], [Entrydate], [Code], [Name], [Amount], [Transtype], [CashorCredit], [InorOut]) SELECT [Docno], [Entrydate], [Code], [Name], [Amount], [Transtype], [CashorCredit], [InorOut] FROM [tblDayBookDetail]; DROP TABLE dbo.[tblDayBookDetail]; EXEC sp_rename 'dbo.tblDayBookDetail_New', 'tblDayBookDetail'; GO CREATE TABLE [dbo].[tblProfitandlossAccountReport_New] ( [tblProfitandlossAccountReportId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Closingstock] decimal(18, 4) NULL, [OpeningStock] decimal(18, 4) NULL, [Sales] decimal(18, 4) NULL, [Expenses] decimal(18, 4) NULL, [Purchases] decimal(18, 4) NULL, [ExpAcName] nvarchar(2000) NULL, [ExpAmount] decimal(18, 4) NULL, [Income] decimal(18, 4) NULL, [IncomeAcName] nvarchar(2000) NULL, [IncomeAmount] decimal(18, 4) NULL, [ExpIncflag] nvarchar(10) NULL, [flag] int NULL ); INSERT INTO dbo.[tblProfitandlossAccountReport_New] ([Closingstock], [OpeningStock], [Sales], [Expenses], [Purchases], [ExpAcName], [ExpAmount], [Income], [IncomeAcName], [IncomeAmount], [ExpIncflag], [flag]) SELECT [Closingstock], [OpeningStock], [Sales], [Expenses], [Purchases], [ExpAcName], [ExpAmount], [Income], [IncomeAcName], [IncomeAmount], [ExpIncflag], [flag] FROM [tblProfitandlossAccountReport]; DROP TABLE dbo.[tblProfitandlossAccountReport]; EXEC sp_rename 'dbo.tblProfitandlossAccountReport_New', 'tblProfitandlossAccountReport'; GO CREATE TABLE [dbo].[TblSummaryReport_New] ( [TblSummaryReportId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [ClosingStock] decimal(18, 4) NULL, [TotalSale] decimal(18, 4) NULL, [CustomerBalance] decimal(18, 4) NULL, [Expense] decimal(18, 4) NULL, [SupplierBalance] decimal(18, 4) NULL, [TotalPurchase] decimal(18, 4) NULL, [TotalAsset] decimal(18, 4) NULL ); INSERT INTO dbo.[TblSummaryReport_New] ([ClosingStock], [TotalSale], [CustomerBalance], [Expense], [SupplierBalance], [TotalPurchase], [TotalAsset]) SELECT [ClosingStock], [TotalSale], [CustomerBalance], [Expense], [SupplierBalance], [TotalPurchase], [TotalAsset] FROM [TblSummaryReport]; DROP TABLE dbo.[TblSummaryReport]; EXEC sp_rename 'dbo.TblSummaryReport_New', 'TblSummaryReport'; GO CREATE TABLE [dbo].[tblTempCustomerLedger_New] ( [tblTempCustomerLedgerId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Opening] decimal(18, 4) NULL, [EntryDate] datetime NULL, [Amount] decimal(18, 4) NULL, [VoucherNo] nvarchar(500) NULL, [CreditPeriod] nvarchar(500) NULL, [Narration] nvarchar(2000) NULL, [Bal] bigint NULL, [id] int NULL, [PONo] nvarchar(500) NULL, [Rvno] nvarchar(100) NULL, [LOCATION] nvarchar(500) NULL, [type] nvarchar(500) NULL ); INSERT INTO dbo.[tblTempCustomerLedger_New] ([Opening], [EntryDate], [Amount], [VoucherNo], [CreditPeriod], [Narration], [Bal], [id], [PONo], [Rvno], [LOCATION], [type]) SELECT [Opening], [EntryDate], [Amount], [VoucherNo], [CreditPeriod], [Narration], [Bal], [id], [PONo], [Rvno], [LOCATION], [type] FROM [tblTempCustomerLedger]; DROP TABLE dbo.[tblTempCustomerLedger]; EXEC sp_rename 'dbo.tblTempCustomerLedger_New', 'tblTempCustomerLedger'; GO CREATE TABLE [dbo].[tblTempSupplierLedger_New] ( [tblTempSupplierLedgerId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Opening] decimal(18, 4) NULL, [EntryDate] datetime NULL, [Amount] decimal(18, 4) NULL, [VoucherNo] nvarchar(500) NULL, [Narration] nvarchar(2000) NULL, [Bal] bigint NULL, [id] int NULL, [Rvno] nvarchar(100) NULL ); INSERT INTO dbo.[tblTempSupplierLedger_New] ([Opening], [EntryDate], [Amount], [VoucherNo], [Narration], [Bal], [id], [Rvno]) SELECT [Opening], [EntryDate], [Amount], [VoucherNo], [Narration], [Bal], [id], [Rvno] FROM [tblTempSupplierLedger]; DROP TABLE dbo.[tblTempSupplierLedger]; EXEC sp_rename 'dbo.tblTempSupplierLedger_New', 'tblTempSupplierLedger'; GO CREATE TABLE [dbo].[tempbalancesheet_New] ( [tempbalancesheetId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [code] nvarchar(500) NULL, [Account] nvarchar(2000) NULL, [Acgroup] nvarchar(2000) NULL, [Amount] decimal(18, 4) NULL, [Type] nvarchar(2000) NULL, [SUBGROUP] nvarchar(50) NULL ); INSERT INTO dbo.[tempbalancesheet_New] ([code], [Account], [Acgroup], [Amount], [Type], [SUBGROUP]) SELECT [code], [Account], [Acgroup], [Amount], [Type], [SUBGROUP] FROM [tempbalancesheet]; DROP TABLE dbo.[tempbalancesheet]; EXEC sp_rename 'dbo.tempbalancesheet_New', 'tempbalancesheet'; GO CREATE TABLE [dbo].[TimeSheetEntry_New] ( [TimeSheetEntryId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [ID] int NULL, [Slno] int NULL, [EmpCode] varchar(50) NULL, [EmpName] varchar(50) NULL, [Type] varchar(50) NULL, [Title] nvarchar(100) NULL, [Period] datetime NULL, [TotalRegularHrs] decimal(18, 4) NULL, [OTtype] varchar(50) NULL, [TotalOTHrs] decimal(18, 4) NULL, [TotalRegular] decimal(18, 4) NULL, [TotalOT] decimal(18, 4) NULL, [TotalCost] decimal(18, 4) NULL, [TotalNet] decimal(18, 4) NULL, [RegularPerHour] decimal(18, 4) NULL, [RegularOT] decimal(18, 4) NULL, [CostPerHour] decimal(18, 4) NULL, [CostPerOt] decimal(18, 4) NULL, [EntryDate] datetime NULL, [Bonus] decimal(18, 4) NULL, [narration] varchar(300) NULL ); INSERT INTO dbo.[TimeSheetEntry_New] ([ID], [Slno], [EmpCode], [EmpName], [Type], [Title], [Period], [TotalRegularHrs], [OTtype], [TotalOTHrs], [TotalRegular], [TotalOT], [TotalCost], [TotalNet], [RegularPerHour], [RegularOT], [CostPerHour], [CostPerOt], [EntryDate], [Bonus], [narration]) SELECT [ID], [Slno], [EmpCode], [EmpName], [Type], [Title], [Period], [TotalRegularHrs], [OTtype], [TotalOTHrs], [TotalRegular], [TotalOT], [TotalCost], [TotalNet], [RegularPerHour], [RegularOT], [CostPerHour], [CostPerOt], [EntryDate], [Bonus], [narration] FROM [TimeSheetEntry]; DROP TABLE dbo.[TimeSheetEntry]; EXEC sp_rename 'dbo.TimeSheetEntry_New', 'TimeSheetEntry'; GO CREATE TABLE [dbo].[TimeSheetEntryDtls_New] ( [TimeSheetEntryDtlsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [ID] int NULL, [Slno] int NULL, [EmpCode] varchar(50) NULL, [EmpName] varchar(50) NULL, [Date] datetime NULL, [ProjCode] varchar(50) NULL, [ProjName] varchar(100) NULL, [RegularHrs] decimal(18, 4) NULL, [OTtype] varchar(50) NULL, [OTHrs] decimal(18, 4) NULL, [RegularTotal] decimal(18, 4) NULL, [CostTotal] decimal(18, 4) NULL, [OTTotal] decimal(18, 4) NULL, [NetTotal] decimal(18, 4) NULL, [narration] nvarchar(150) NULL ); INSERT INTO dbo.[TimeSheetEntryDtls_New] ([ID], [Slno], [EmpCode], [EmpName], [Date], [ProjCode], [ProjName], [RegularHrs], [OTtype], [OTHrs], [RegularTotal], [CostTotal], [OTTotal], [NetTotal], [narration]) SELECT [ID], [Slno], [EmpCode], [EmpName], [Date], [ProjCode], [ProjName], [RegularHrs], [OTtype], [OTHrs], [RegularTotal], [CostTotal], [OTTotal], [NetTotal], [narration] FROM [TimeSheetEntryDtls]; DROP TABLE dbo.[TimeSheetEntryDtls]; EXEC sp_rename 'dbo.TimeSheetEntryDtls_New', 'TimeSheetEntryDtls'; GO CREATE TABLE [dbo].[TitleMaster_New] ( [TitleMasterId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [id] nvarchar(500) NULL, [Name] nvarchar(500) NULL, [Remarks] nvarchar(500) NULL ); INSERT INTO dbo.[TitleMaster_New] ([id], [Name], [Remarks]) SELECT [id], [Name], [Remarks] FROM [TitleMaster]; DROP TABLE dbo.[TitleMaster]; EXEC sp_rename 'dbo.TitleMaster_New', 'TitleMaster'; GO CREATE TABLE [dbo].[TransactionCount_New] ( [TransactionCountId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Transaction] nvarchar(100) NULL, [Count] decimal(18, 4) NULL ); INSERT INTO dbo.[TransactionCount_New] ([Transaction], [Count]) SELECT [Transaction], [Count] FROM [TransactionCount]; DROP TABLE dbo.[TransactionCount]; EXEC sp_rename 'dbo.TransactionCount_New', 'TransactionCount'; GO CREATE TABLE [dbo].[UserDetails_New] ( [UserDetailsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [UName] nvarchar(50) NULL, [PWord] nvarchar(500) NULL, [ULevel] smallint NULL, [UCode] nvarchar(50) NULL, [UNameAR] nvarchar(500) NULL, [PWordAR] nvarchar(500) NULL, [Language] smallint NULL, [OptAdd] int NULL, [OptEdit] int NULL, [OptDelete] int NULL, [OptReport] int NULL, [Admin] int NULL ); INSERT INTO dbo.[UserDetails_New] ([UName], [PWord], [ULevel], [UCode], [UNameAR], [PWordAR], [Language], [OptAdd], [OptEdit], [OptDelete], [OptReport], [Admin]) SELECT [UName], [PWord], [ULevel], [UCode], [UNameAR], [PWordAR], [Language], [OptAdd], [OptEdit], [OptDelete], [OptReport], [Admin] FROM [UserDetails]; DROP TABLE dbo.[UserDetails]; EXEC sp_rename 'dbo.UserDetails_New', 'UserDetails'; GO CREATE TABLE [dbo].[VATCategoryDetails_New] ( [VATCategoryDetailsId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Slno] nvarchar(500) NULL, [Code] nvarchar(20) NULL, [DescriptionEN] nvarchar(2000) NULL, [DescriptionAR] nvarchar(2000) NULL, [ExemptionCode] nvarchar(500) NULL, [ExemptionTextEN] nvarchar(2000) NULL, [ExemptionTextAR] nvarchar(2000) NULL ); INSERT INTO dbo.[VATCategoryDetails_New] ([Slno], [Code], [DescriptionEN], [DescriptionAR], [ExemptionCode], [ExemptionTextEN], [ExemptionTextAR]) SELECT [Slno], [Code], [DescriptionEN], [DescriptionAR], [ExemptionCode], [ExemptionTextEN], [ExemptionTextAR] FROM [VATCategoryDetails]; DROP TABLE dbo.[VATCategoryDetails]; EXEC sp_rename 'dbo.VATCategoryDetails_New', 'VATCategoryDetails'; GO CREATE TABLE [dbo].[VATMaster_New] ( [VATMasterId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [Code] nvarchar(500) NULL, [Name] nvarchar(2000) NULL, [Rate] decimal(18, 4) NULL, [defaultper] nvarchar(50) NULL ); INSERT INTO dbo.[VATMaster_New] ([Code], [Name], [Rate], [defaultper]) SELECT [Code], [Name], [Rate], [defaultper] FROM [VATMaster]; DROP TABLE dbo.[VATMaster]; EXEC sp_rename 'dbo.VATMaster_New', 'VATMaster'; GO CREATE TABLE [dbo].[ZatcaAuthInfo_New] ( [ZatcaAuthInfoId] INT IDENTITY(1,1) NOT NULL PRIMARY KEY, [ZatcaToken] nvarchar(4000) NULL, [ZatcaSecret] nvarchar(4000) NULL, [AuthStatus] nvarchar(500) NULL, [AppAuthInfoCount] nvarchar(10) NULL ); INSERT INTO dbo.[ZatcaAuthInfo_New] ([ZatcaToken], [ZatcaSecret], [AuthStatus], [AppAuthInfoCount]) SELECT [ZatcaToken], [ZatcaSecret], [AuthStatus], [AppAuthInfoCount] FROM [ZatcaAuthInfo]; DROP TABLE dbo.[ZatcaAuthInfo]; EXEC sp_rename 'dbo.ZatcaAuthInfo_New', 'ZatcaAuthInfo'; GO