use T20B001
Create Table CHALLAN_RECEIVED_FROM_JOB_YARN_TAKA_DETAIL (SrNo Varchar(6) Foreign Key References CHALLAN_RECEIVED_FROM_JOB(SrNo),ItemSrNo Numeric(3),YTakaSrNo Numeric(6),WeaverSrNo Varchar(6),MtsKGs Money, UsedWeight Money,WeightPer100Mts Money, MtsPer1KG Money)
Create Table OPENING_CHALLAN_RECEIVED_FROM_JOB_YARN_TAKA_DETAIL (SrNo Varchar(6) Foreign Key References OPENING_CHALLAN_RECEIVED_FROM_JOB(SrNo),ItemSrNo Numeric(3),YTakaSrNo Numeric(6),WeaverSrNo Varchar(6),MtsKGs Money, UsedWeight Money,WeightPer100Mts Money, MtsPer1KG Money)