------FIRST RUN THESE QUERY
drop TABLE OPENING_GREY_AT_SHOP_ITEM_DETAIL 
drop TABLE OPENING_GREY_AT_SHOP_TAKA_DETAIL 
drop TABLE OPENING_GREY_AT_SHOP_YARN_TAKA_DETAIL 
drop TABLE OPENING_GREY_AT_SHOP 

CREATE TABLE OPENING_GREY_AT_SHOP (SrNo Varchar(15) Primary Key,BillNo Varchar(20),BillDate DateTime,ChallanNo Varchar(15),ChallanRecdDate DateTime,WeaverCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),GrossAmt Money,UName Varchar(255),TransName Varchar(35),TransLRNo Varchar(60),GSTSupplyType Varchar(15),EntType Varchar(25),TaxableAmt Money,Remark Varchar(255))
CREATE TABLE OPENING_GREY_AT_SHOP_ITEM_DETAIL (SrNo Varchar(15) Foreign Key References OPENING_GREY_AT_SHOP(SrNo),ItemSrNo Numeric(3),ItemName Varchar(40),ItemPcs bigint,ItemCut Money,ItemMts Money,ItemFoldPerc Money,ItemActualMts Money,ItemPer Varchar(1),ItemRate Money,ItemAmount Money,Marka Varchar(15),SaleOrdNo Varchar(10),YarnLotNo Varchar(25),Denier Varchar(25),Grade Varchar(25), PerWT Money, HSNCode Varchar(10), IGSTPerc Money, CGSTPerc Money, SGSTPerc Money, UTGSTPerc Money, CESSPerc Money, IGSTAmt Money, CGSTAmt Money, SGSTAmt Money, UTGSTAmt Money, CESSAmt Money)
CREATE TABLE OPENING_GREY_AT_SHOP_TAKA_DETAIL (SrNo Varchar(15),ItemSrNo Numeric(3),ItemName Varchar(40),TakaSrNo Numeric(3),TakaMts Money,TakaTP1 Money,TakaTP2 Money,TakaTP3 Money,TakaTP4 Money,TakaTP5 Money,StWeight Money,OrgWeight Money,Veriation Money,Marka Varchar(15),WevTkSrNo Varchar(15))
CREATE TABLE OPENING_GREY_AT_SHOP_YARN_TAKA_DETAIL (SrNo Varchar(15),ItemSrNo Numeric(3),TakaSrNo Numeric(3),CartoonNo Varchar(50),Cone bigint,NetWeight Money,ShadeColor Varchar(50))

ALTER TABLE RECEIVED_BANK_BOOK_DETAIL ADD Dollar Money
ALTER TABLE FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL drop column ItemRemark,Fold,WOFoldMts
ALTER TABLE FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL add RD Money, RDAmt Money, LessAmt Money,ItemRemark Varchar(255),Fold Money,WOFoldMts Money












------SECONED RUN THESE QUERY



update FINISHED_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL set RD =0, RDAmt =0, LessAmt =0,ItemRemark ='',Fold =0,WOFoldMts =bkmts
UPDATE RECEIVED_BANK_BOOK_DETAIL SET Dollar =0