⬅ Back B. L. TRENDZ 09-02-2023.sql
use T23B001

drop table CHALLAN_RECEIVED_FROM_JOB_FINISHED_TAKA_DETAIL
Create Table CHALLAN_RECEIVED_FROM_JOB_FINISHED_TAKA_DETAIL (SrNo varchar(6) Foreign Key References CHALLAN_RECEIVED_FROM_JOB(SrNo),ItemSrNo Numeric(3),TakaSrNo Numeric(3),TakaMts Money,TakaQty Numeric(5),ShadeNo Varchar(15))

drop table OPENING_CHALLAN_RECEIVED_FROM_JOB_FINISHED_TAKA_DETAIL
Create Table OPENING_CHALLAN_RECEIVED_FROM_JOB_FINISHED_TAKA_DETAIL (SrNo varchar(6) Foreign Key References OPENING_CHALLAN_RECEIVED_FROM_JOB(SrNo),ItemSrNo Numeric(3),TakaSrNo Numeric(3),TakaMts Money,TakaQty Numeric(5),ShadeNo Varchar(15))

--------------------- OR IMPORT / EXPORT FOR OTHER TABLE