use t22v001

ALTER TABLE RECEIVED_FROM_JOB_CHALLAN_DETAIL Add AddLess1Name Varchar(35)
ALTER TABLE RECEIVED_FROM_JOB_CHALLAN_DETAIL Add AddLess1Perc Money
ALTER TABLE RECEIVED_FROM_JOB_CHALLAN_DETAIL Add AddLess1Amt Money
ALTER TABLE RECEIVED_FROM_JOB_CHALLAN_DETAIL Add AddLess2Name Varchar(35)
ALTER TABLE RECEIVED_FROM_JOB_CHALLAN_DETAIL Add AddLess2Perc Money
ALTER TABLE RECEIVED_FROM_JOB_CHALLAN_DETAIL Add AddLess2Amt Money

UPDATE RECEIVED_FROM_JOB_CHALLAN_DETAIL Set AddLess1Name = ''
UPDATE RECEIVED_FROM_JOB_CHALLAN_DETAIL Set AddLess1Perc = 0
UPDATE RECEIVED_FROM_JOB_CHALLAN_DETAIL Set AddLess1Amt = 0
UPDATE RECEIVED_FROM_JOB_CHALLAN_DETAIL Set AddLess2Name = ''
UPDATE RECEIVED_FROM_JOB_CHALLAN_DETAIL Set AddLess2Perc =0
UPDATE RECEIVED_FROM_JOB_CHALLAN_DETAIL Set AddLess2Amt =0


Create Table MARKING_GSTR_REPORT (FormName Varchar(30),FormSrNo Varchar(15))