update GLTypeMaster set id = 47 where id = 45;
update GLTypeMaster set id = 46 where id = 44;
update GLTypeMaster set id = 45 where id = 43;
update GLTypeMaster set id = 44 where id = 42;
update GLTypeMaster set id = 43 where id = 41;

INSERT INTO TransactionTypeMaster(id, transaction_class_id, name) VALUES
(32, 7, 'Cheque Bounce Charge Demand'),
(33, 6, 'Cheque Bounce Charge');

INSERT INTO GLTypeMaster(id, gl_code, gl_category_id, gl_class_id, name, system_defined) VALUES
(41, 'GL321', 1, 3, 'Cheque Bounce Charge Receivable', 1),
(42, 'GL322', 3, 3, 'Cheque Bounce Charge', 1);

INSERT INTO TransactionGLTypeMap(id, tx_type_id, debit_gl_type_id, credit_gl_type_id, is_default) VALUES
(79, 32, 41, 42, 1),
(80, 33, 9, 41, 1);
