-- Create Table Statement for 'Merchant Charge Payment'
DROP TABLE IF EXISTS `IAPP_MERCHANT_CHARGE_PAYMENT`;
CREATE TABLE `IAPP_MERCHANT_CHARGE_PAYMENT` (
	CREATE_DATE datetime,
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	ACCOUNT_ID varchar,
	CHARGE_CODE varchar,
	PAYMENT_AMOUNT int(11),
	REMAINING_AMOUNT int(11),
	SEQUENCE_NUMBER int(11),
	STATUS_CL varchar,
	RESPONSE_DATE datetime,
	MERCHANT_ACCOUNT_GROUP_FK bigint(20),
	MERCHANT_STATEMENT_FK bigint(20),
	RESELLER_STATEMENT_FK bigint(20),
	RESELLER_FK int(11),
	MERCHANT_CHARGE_FK bigint(20),
	MASTER_MERCHANT_STATEMENT_FK bigint(20),
	RESELLER_STATEMENT_EXTENDED_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;