INSERT INTO ACCOUNT_MASTER 
SELECT AccCode, AccName, AccType, AccAgentCode, AccGroupCode, AccAdd1, AccAdd2, AccAdd3, AccCityName, AccCityPin, AccPhone, AccMobile, AccFax, AccEmail, 
AccResident, AccGSTNo, AccCSTNo, AccPANNo, AccVATNo, AccContPerson, AccRef, AccCrLimit, AccCrDays, 0, 'Dr', 0, AccTANNo, 
AccKSTNo, TDSYesNo, TDSAccount, JobType, DiscPerc, RDPerPcs, RDPerMts, InsPolicyNo, Dhara, DharaDays, TransName, AccAdd21, AccAdd22, AccAdd23, 
AccCityName2, AccCityPin2, BlackListed, BankDetail, ExcessRate, SeriesName, CommPerc, TDSLimit, BankName, AccountNo, IFSCCode, Branch, LessDays, 
PackPerPcs, BankCommPerc, BankCommLessPerc, PackPerMts, PostageCharge, Taxable, GSTIN, CompScheme, GSTCategory, ECommGSTIN, GSTRegDate, 
AccManager, CityDistanceKM, SMAccCode, TCSApplicable, TCSCollectFrom
FROM common.dbo.ACCOUNT_MASTER WHERE AccCode COLLATE DATABASE_DEFAULT NOT IN (SELECT AccCode FROM T23V001.DBO.ACCOUNT_MASTER)






INSERT INTO T23A001.DBO.FINISHED_ITEM_MASTER
SELECT     ItemName, ItemQuality, ItemCategories, ItemRatePerPcs, ItemRatePerMts, ItemCut, ItemTopName, ItemTopMts, ItemMiddleName, ItemMiddleMts, ItemBottomName, 
                      ItemBottomMts, ItemOtherName, ItemOtherMts, ItemCutPcsMtr, ItemMtsPerKG, ItemGrp, 0, 0, 0, ItemImagePath, 
                      FoldPerc, ItemImagePath2, ItemImagePath3, ItemImagePath4, ItemImagePath5, PurRatePerPcs, PurRatePerMts, HSNCode, GSTPerc, DescGST, ItemPer
FROM         COMMON.DBO.FINISHED_ITEM_MASTER WHERE ITEMNAME NOT IN (SELECT ITEMNAME FROM T23A001.DBO.FINISHED_ITEM_MASTER)


INSERT INTO T23A001.DBO.SCREEN_ITEM_MASTER
SELECT     ItemName, ItemRatePerPcs, ItemRatePerMts, ItemGrp, 0, 0, 0, ItemImagePath, ItemOn, ItemCut, FabCost, JobCost, 
                      TotCost, CatalogName, Target, ItemImagePath2, ItemImagePath3, ItemImagePath4, ItemImagePath5, ScreenPcs, PurRatePerPcs, PurRatePerMts, ProfitPerc, Size, 
                      HSNCode, GSTPerc
FROM         COMMON.DBO.SCREEN_ITEM_MASTER WHERE ITEMNAME NOT IN (SELECT ITEMNAME FROM T23A001.DBO.SCREEN_ITEM_MASTER)