use E26M002
use e26m003

-----RUN IN BOTH FIRM

drop table CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL
CREATE TABLE CHALLAN_RECEIVED_FROM_JOB_CHALLAN_DETAIL (SrNo Varchar(6) Foreign Key References CHALLAN_RECEIVED_FROM_JOB(SrNo),LotNo bigint,ItemName Varchar(30),JobSendChNo Varchar(15),JobSendSrNo Varchar(10),JobSendItmSrNo Numeric(3),ItemPcs bigint,ItemMts Money,SendChStatus Varchar(1),ItemPer Varchar(1),ItemRate Money,ItemAmt Money,WastePcs bigint,WasteMts Money,RtnPcs bigint,RtnMts Money,Screen Varchar(255),StockType Varchar(35),JobQuality Varchar(35),ItemSrNo bigint,ItemDescription Varchar(255), InwLotNo Varchar(15),InType Varchar(35),InSrNo Varchar(15),InISrNo bigint, InwChNo Varchar(15), InwDate DateTime)