---run in all firm

use T24L004

INSERT INTO COMMON.DBO.FINISHED_ITEM_MASTER SELECT ItemName, ItemQuality, ItemCategories, ItemRatePerPcs, ItemRatePerMts, ItemCut, ItemTopName, ItemTopMts, ItemMiddleName, ItemMiddleMts, ItemBottomName, ItemBottomMts, ItemOtherName, ItemOtherMts, ItemCutPcsMtr, ItemMtsPerKG, ItemGrp, ItemImagePath, FoldPerc, ItemImagePath2, ItemImagePath3, ItemImagePath4, ItemImagePath5, PurRatePerPcs, PurRatePerMts, HSNCode, GSTPerc, DescGST, ItemPer FROM FINISHED_ITEM_MASTER WHERE ITEMNAME NOT IN (SELECT ITEMNAME FROM COMMON.DBO.FINISHED_ITEM_MASTER)
INSERT INTO COMMON.DBO.SCREEN_ITEM_MASTER SELECT ItemName, ItemRatePerPcs, ItemRatePerMts, ItemGrp, ItemImagePath, ItemOn, ItemCut, FabCost, JobCost, TotCost, CatalogName, Target, ItemImagePath2, ItemImagePath3, ItemImagePath4, ItemImagePath5, ScreenPcs, PurRatePerPcs, PurRatePerMts, ProfitPerc, Size, HSNCode, GSTPerc FROM SCREEN_ITEM_MASTER WHERE ITEMNAME NOT IN (SELECT ITEMNAME FROM COMMON.DBO.SCREEN_ITEM_MASTER)
INSERT INTO COMMON.DBO.GREY_ITEM_MASTER SELECT ItemName, ItemRatePerPcs, ItemRatePerMts, HSNCode, GSTPerc, DescGST, EntType FROM GREY_ITEM_MASTER WHERE ITEMNAME NOT IN (SELECT ITEMNAME FROM COMMON.DBO.GREY_ITEM_MASTER)