-- 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;