-- Create Table Statement for 'Remittance Transaction'
DROP TABLE IF EXISTS `REMITTANCE_TRANSACTION`;
CREATE TABLE `REMITTANCE_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11),
	REMITTER_ACCOUNT_CODE int(11),
	REMITTED_AMOUNT bigint(20),
	RESERVE_AMOUNT bigint(20),
	MERCHANT_RESERVE_AMOUNT bigint(20),
	FACILITATOR_RESERVE_AMOUNT bigint(20),
	FEE_AMOUNT bigint(20),
	DEPOSIT_AMOUNT bigint(20),
	CHARGEBACK_AMOUNT bigint(20),
	RETURN_AMOUNT bigint(20),
	FUTURE_RESERVE_AMOUNT bigint(20),
	FUTURE_FEE_AMOUNT bigint(20),
	STATUS_CL varchar,
	POSTED_DATE datetime,
	TRANSACTION_CODE bigint(20),
	MERCHANT_STATEMENT_FK bigint(20),
	HOLD_AMOUNT bigint(20),
	FEE_TRANSACTION_CODE bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;