update station..tbDRChargeSlip set ChargeSlip = 1,LabNum = 1,AssessNum = 1 update cardio..tbHrtSlip set ChargeSlip = 1,RequestNum = 1 update PATIENT_DATA..tbERChargeSlip set ChargeSlip = 1,LabNum =1, AssessNum = 1 update station..tbORChargeSlip set ChargeSlip = 1,LabNum = 1,AssessNum = 1 update station..tbICUChargeSlip set ChargeSlip = 1,LabNum = 1, AssessNum = 1 update Station..tbNURChargeSlip set ChargeSlip = 1,LabNum = 1,AssessNum = 1 update CLINICAL_AREA..tbPTChargeSlip set ChargeSlip = 1, LabNum = 1 UPDATE STATION..tbCLchargeSlip SET ChargeSlip ='1', LabNum='1', AssessNum = 1 UPDATE HEMODIALYSIS..tbKidneyChargeSlip SET ChargeSlip ='1', LabNum='1' delete from Patient_data..tbOPDChargeSlip insert into Patient_data..tbOPDChargeSlip (EmpID,ChargeSlip,Counter) Values('8','1',1) insert into RADIOLOGY..tbXROpd(RequestNum,CSlip) values(1,1) insert into RADIOLOGY..tbCTOpd(RequestNum,CSlip) values(1,1) insert into RADIOLOGY..tbULOpd(RequestNum,CSlip) values(1,1) insert into RADIOLOGY..tbMRIRequestnum(RequestNum,CSlip) values(1,1) insert into Station..tbNurseMISlip(Chargeslip,LabNum) values(1,1) -- Note Please Check the StationId base on client build station update station..tbNurseChargeSlipTerminal set ChargeSlip = 1 where StationID = '' update station..tbNurseChargeSlipTerminal set ChargeSlip = 1 where StationID = '' update station..tbNurseChargeSlipTerminal set ChargeSlip = 1 where StationID = '' update station..tbNurseChargeSlipTerminal set ChargeSlip = 1 where StationID = '' update station..tbNurseChargeSlipTerminal set ChargeSlip = 1 where StationID = '' Update Billing..tbassessmentnum set Assessmentnum ='1', Requestnum ='1', SOANumber ='1' Insert into Billing..tbparslastnumber(Idnum,Controlnum) Values(null,'0') Insert into Billing..tbBillRefundVoucherNumber(LastRVNum) Values('1') Update Billing..tbParsBSNum set BSNum='1' Update Station..tbNewBornLastNumber set IDNum ='1' Update Radiology..tbradiologyrevenues set ChargeslipNum ='1', Requestnum ='1' UPDATE INVENTORY..tbInvChargeSlip set DispensingCSlip ='1', CreditMemo='1', DispensingCSR='1' UPDATE LABORATORY..tbLabSLIP SET Chargeslip ='1', Requestnum='1', CreditMemoNum='1', SpecimenNum ='1' Update Patient_data..tbAdmittingsetup set isallowDischargeWithoutBillingDate = 1 Update Patient_data..tbadmlastnumber set Hospnum=1, IDNum=1, OPDID=1,ERNum=1, Reservationnum =1, Hemonum=1,TIDNum=1,Filenum=1,RoomRefnum=1,MiscRefnum=1,OPFilenum=1,FDNum=1,Transnum=1 --Update Billing..tbParsLastCertNum --set CertNum ='1' INSERT INTO Billing..tbParsLastCertNum(CertNum) VALUES('1') --Update tbBillChargeSlip --set LastChargeslipNumber ='1' INSERT INTO Billing..tbBillChargeSlip(LastChargeSlipNumber) VALUES('1') **Chargelip setting for other department** --Station..tbNurseOtherSlip