INSERT INTO accounts.ledger_master(ledgercode, acc_head,parent_id,om_id,cc,opening_bal,status) VALUES ('1000000','Corpus Fund',0,90,0,0,1),('1000001','Surplus',0,90,0,0,1),('1000002','Sundry Creditors',0,90,0,0,1),('2000000','Vehicle',0,90,0,0,1),('2000001', 'Furniture',0,90,0,0,1),('2000002','Cash in Hand',0,90,0,0,1),('2000003','Cash at Bank',0,90,0,0,1),('2000004','Stores',0,90,0,0,1),('2000005','Salary Advance',0,90,0,0,1),('2000006','Travel Advance',0,90,0,0,1),('3000000','College Fee',0,90,0,0,1),('3000001','Bus Fee',0,90,0,0,1),('3000002','Fine',0,90,0,0,1),('3000003','Miscellaneous Income',0,90,0,0,1),('4000000','Salary',0,90,0,0,1),('4000001','Building Maintenance',0,90,0,0,1),('4000002','Laboratory Maintenance',0,90,0,0,1),('4000003','Vehicle Maintenance',0,90,0,0,1);




Download Queries