-- Create Table Statement for 'Merchant Group Scheduled Adjustment'
DROP TABLE IF EXISTS `IAPP_MERCHANT_GROUP_SCHEDULED_ADJUSTMENT`;
CREATE TABLE `IAPP_MERCHANT_GROUP_SCHEDULED_ADJUSTMENT` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11),
	EFFECTIVE_DATE datetime,
	AMOUNT int(11),
	STATUS_CL varchar,
	DESCRIPTION varchar,
	ADJUSTMENT_CL varchar,
	MERCHANT_STATEMENT_FK bigint(20),
	MERCHANT_STATEMENT_DETAIL_FK bigint(20),
	MERCHANT_ACCOUNT_GROUP_FK bigint(20),
	MERCHANT_STATEMENT_FK bigint(20),
	MERCHANT_STATEMENT_FK bigint(20),
	REMITTANCE_SOURCE_CL varchar,
	REMITTANCE_SOURCE_CL varchar,
	REMITTANCE_SOURCE_CL varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;