-- Create Table Statement for 'Merchant Charge'
DROP TABLE IF EXISTS `IAPP_MERCHANT_CHARGE`;
CREATE TABLE `IAPP_MERCHANT_CHARGE` (
	CREATE_DATE datetime,
	DESCRIPTION varchar,
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	AMOUNT int(11),
	ACCOUNT_ID varchar,
	CHARGE_CODE varchar,
	EXPECTED_EFFECTIVE_DATE datetime,
	BALANCE int(11),
	LAST_SEQUENCE_NUMBER int(11),
	SUB_BATCH_FK bigint(20),
	BATCH_FK bigint(20),
	RESELLER_FK int(11),
	CHARGE_CL varchar,
	RESPONSE_CODE varchar,
	RESPONSE_MESSAGE varchar,
	CHARGE_STATUS_CL varchar,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	RESELLER_FK int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;