-----RUN IN FIRM
insert into 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 FINISHED_ITEM_MASTER)


insert into GREY_ITEM_MASTER
SELECT        ItemName, ItemRatePerPcs, ItemRatePerMts, 0, 0, 0, HSNCode, GSTPerc, DescGST, EntType
FROM            COMMON.DBO.GREY_ITEM_MASTER WHERE ITEMNAME NOT IN (SELECT ITEMNAME FROM GREY_ITEM_MASTER)

insert into 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 SCREEN_ITEM_MASTER)