update GLTypeMaster set id = 105 where id = 47;
update GLTypeMaster set id = 104 where id = 46;
update GLTypeMaster set id = 103 where id = 45;
update GLTypeMaster set id = 102 where id = 44;
update GLTypeMaster set id = 101 where id = 43;

INSERT INTO TransactionTypeMaster(id, transaction_class_id, name) VALUES
(34, 7, 'Commission Demand'),
(35, 6, 'Commission');

INSERT INTO GLTypeMaster(id, gl_code, gl_category_id, gl_class_id, name, system_defined) VALUES
(43, 'GL323', 2, 1, 'Commission Payable', 1),
(44, 'GL324', 4, 1, 'Commission', 1);

INSERT INTO TransactionGLTypeMap(id, tx_type_id, debit_gl_type_id, credit_gl_type_id, is_default) VALUES
(81, 34, 44, 43, 1),
(82, 35, 43, 9, 1);
