Create Table GREY_PURCHASE_RETURN_GOODS_DETAIL (BkSrNo Varchar(6) Primary Key,BkAccCode Varchar(7) Foreign Key References ACCOUNT_MASTER(AccCode),BkGRAmt Money,BkGRDate DateTime,BkRemark Varchar(255),BkCurDate DateTime,BkCurTime DateTime,BkUName Varchar(255),TransName Varchar(35),TransLRNo Varchar(15),TransLRCase Varchar(30),TransLRDate DateTime,TransFromStation Varchar(35),PurRtnType Varchar(7),RevCharge Varchar(3),GSTSupplyType Varchar(15))
Create Table GREY_PURCHASE_RETURN_GOODS_ADDLESS_DETAIL (BkSrNo Varchar(6) Foreign Key References GREY_PURCHASE_RETURN_GOODS_DETAIL(BkSrNo),BkBillNo Varchar(20),BkItemName Varchar(30),BkCut Money,BkPcs Numeric(6),BkMts Money,BkPer Varchar(1),BkRate Money,BkBillGRAmt Money,BkStatus Varchar(7),ISrNo Numeric(6),PurSrNo Varchar(15),PurISrNo Numeric(6),HSNCode Varchar(10), IGSTPerc Money, IGSTAmt Money, CGSTPerc Money, CGSTAmt Money, SGSTPerc Money, SGSTAmt Money, UTGSTPerc Money, UTGSTAmt Money, CESSPerc Money, CESSAmt Money,ItemDiscPerc Money, ItemDiscAmt Money, ItemAddPerc Money, ItemAddAmt Money)
Create Table GREY_PURCHASE_RETURN_GOODS_TAKA_DETAIL (BkSrNo Varchar(6) Foreign Key References GREY_PURCHASE_RETURN_GOODS_DETAIL(BkSrNo),ItemSrNo Numeric(3),TakaSrNo Numeric(6),GreyMts Money,RecdMts Money, GreyTP1 Money,RecdTP1 Money,GreyTP2 Money,RecdTP2 Money,GreyTP3 Money,RecdTP3 Money,GreyTP4 Money,RecdTP4 Money,GreyTP5 Money,RecdTP5 Money,ShortPerc Money,CurTime DateTime)