Untitled

mail@pastecode.io avatar
unknown
plain_text
a month ago
2.3 kB
1
Indexable
Never
INSERT INTO monnify_agency_banking.card_sales_cost_commission (status,card_sales_cost_id,enabled,agent_instant_commission,agent_post_transaction_commission,brm_instant_commission,brm_post_transaction_commission,sc_instant_commission,sc_post_transaction_commission,rm_instant_commission,rm_post_transaction_commission,ho_instant_commission,ho_post_transaction_commission,created_on,last_modified_on,commission_debit_account_number,ho_account_number,agent_post_batch_completion_commission) VALUES
	 (1,7,1,0,0,10000,0,20000,0,0,0,0,0,'2024-02-27 16:54:12','2024-02-27 16:54:12',NULL,NULL,0),
	 (1,8,1,20000,10000,0,0,1000,0,1500,0,3000,0,'2024-02-27 17:09:29','2024-02-27 17:09:29',NULL,NULL,0),
	 (1,9,1,10000,15000,0,0,1000,0,1500,0,3000,0,'2024-02-27 17:10:07','2024-02-27 17:10:07',NULL,NULL,0),
	 (1,12,1,0,0,30000,10000,0,0,0,0,10000,0,'2024-03-11 11:11:21','2024-03-11 11:11:21',NULL,NULL,0),
	 (1,10,1,0,20000,0,0,0,0,0,0,0,0,'2024-03-11 12:40:18','2024-03-11 12:40:18',NULL,NULL,0),
	 (1,1,1,0,0,0,0,0,0,0,0,0,0,'2024-03-11 12:59:04','2024-03-11 12:59:04',NULL,NULL,20000),
	 (1,4,1,8000,0,0,5000,0,0,0,0,0,15000,'2024-03-11 13:02:17','2024-03-11 13:02:17',NULL,NULL,72000),
	 (1,5,1,0,0,50000,20000,0,0,0,0,0,30000,'2024-03-11 13:03:46','2024-03-11 13:03:46',NULL,NULL,0),
	 (1,6,1,0,0,50000,20000,0,0,0,0,0,30000,'2024-03-11 13:04:22','2024-03-11 13:04:22',NULL,NULL,0),
	 (1,13,1,100000,0,0,0,0,0,0,0,0,0,'2024-03-12 09:03:35','2024-03-12 09:03:35',NULL,NULL,400000);
INSERT INTO monnify_agency_banking.card_sales_cost_commission (status,card_sales_cost_id,enabled,agent_instant_commission,agent_post_transaction_commission,brm_instant_commission,brm_post_transaction_commission,sc_instant_commission,sc_post_transaction_commission,rm_instant_commission,rm_post_transaction_commission,ho_instant_commission,ho_post_transaction_commission,created_on,last_modified_on,commission_debit_account_number,ho_account_number,agent_post_batch_completion_commission) VALUES
	 (1,11,1,80000,0,0,5000,0,0,0,0,0,5000,'2024-03-12 10:06:44','2024-03-12 10:06:44',NULL,NULL,10000),
	 (1,3,1,8000,0,0,5000,0,0,0,0,0,5000,'2024-03-13 11:40:19','2024-03-13 11:40:19',NULL,NULL,82000),
	 (1,2,1,8000,0,0,0,0,0,0,0,0,0,'2024-03-13 11:40:59','2024-03-13 11:40:59',NULL,NULL,42000);
Leave a Comment