-- Create Table Statement for 'Merchant Account Group'
DROP TABLE IF EXISTS `IAPP_MERCHANT_ACCOUNT_GROUP`;
CREATE TABLE `IAPP_MERCHANT_ACCOUNT_GROUP` (
	ID bigint(20) NOT NULL,
	NAME varchar,
	MERCHANT_ACCOUNT_CODE int(11),
	BALANCE int(11),
	BANK_ACCOUNT_HOLDER_NAME varchar,
	BANK_ROUTING_NUMBER_MASKED varchar,
	BANK_ACCOUNT_NUMBER_MASKED varchar,
	TOKEN_CODE varchar,
	REFUND_RESERVE_REQUESTED_AMOUNT int(11),
	REFUND_RESERVE_COLLECTED_AMOUNT int(11),
	REFUND_RESERVE_REMAINING_AMOUNT int(11),
	CHARGEBACK_RESERVE_MIN_AMOUNT int(11),
	CHARGEBACK_RESERVE_REQUESTED_AMOUNT int(11),
	CHARGEBACK_RESERVE_COLLECTED_AMOUNT int(11),
	CHARGEBACK_RESERVE_RATE decimal(10,2),
	CHARGEBACK_RESERVE_PERIOD int(11),
	RETURN_RESERVE_MIN_AMOUNT int(11),
	RETURN_RESERVE_REQUESTED_AMOUNT int(11),
	RETURN_RESERVE_COLLECTED_AMOUNT int(11),
	RETURN_RESERVE_RATE decimal(10,2),
	RETURN_RESERVE_PERIOD int(11),
	PREV_DEPOSIT_STATEMENT_DATE datetime,
	LAST_DEPOSIT_STATEMENT_DATE datetime,
	PREV_REMITTANCE_DATE datetime,
	LAST_REMITTANCE_DATE datetime,
	PREV_STATEMENT_DATE datetime,
	LAST_STATEMENT_DATE datetime,
	PREV_COMMISSION_STATEMENT_DATE datetime,
	LAST_COMMISSION_STATEMENT_DATE datetime,
	IS_REFUND_RESERVE_ENABLED tinyint(1),
	IS_RETURN_RESERVE_ENABLED tinyint(1),
	IS_CHARGEBACK_RESERVE_ENABLED tinyint(1),
	REMITTANCE_RECIPIENT_LIST varchar,
	IS_IGNORE_REMITTANCE_SOURCE tinyint(1),
	MAX_WITHHOLDING_AMOUNT int(11),
	IS_REMITTANCE_HOLD_ENABLED tinyint(1),
	NET_BALANCE int(11),
	IS_MERCHANT_STATEMENT_ARCHIVING_ENABLED tinyint(1),
	BANK_NAME varchar,
	BANK_PHONE varchar,
	MINIMUM_REMITTANCE_AMOUNT int(11),
	IS_MERCHANT_STATEMENT_EXPORT_ENABLED tinyint(1),
	IS_REMITTANCE_EMAILING_ENABLED tinyint(1),
	PORTFOLIO_CODE int(11),
	RECURRING_FEES_BEGIN_DATE datetime,
	BANK_NAME_CHARGE varchar,
	BANK_PHONE_CHARGE varchar,
	BANK_ACCOUNT_HOLDER_NAME_CHARGE varchar,
	BANK_ROUTING_NUMBER_MASKED_CHARGE varchar,
	BANK_ACCOUNT_NUMBER_MASKED_CHARGE varchar,
	TOKEN_CODE_CHARGE varchar,
	FEE_WITHDRAWAL_POLICY_CL varchar,
	FEE_BALANCE bigint(20),
	STATEMENT_POLICY_CL varchar,
	RETURNS_BALANCE int(11),
	LAST_MERCHANT_STATEMENT_STATISTICS_UPDATE_DATE datetime,
	STATEMENT_EMAILING_POLICY varchar,
	IS_MERCHANT_STATEMENT_NET_PROCESSED_DETAIL_ENABLED tinyint(1),
	REATTEMPT_RETURNS_BALANCE int(11),
	MERCHANT_CYCLE_FK bigint(20),
	MERCHANT_FEE_FK bigint(20),
	FEE_SCHEMA_FK int(11),
	PROVIDER_PROFILE_LOG_FK bigint(20),
	ACCOUNT_STORE_CODE bigint(20),
	ACCOUNT_STORE_CODE_CHARGE bigint(20),
	DISTRIBUTION_SCHEMA_FK int(11),
	ACCOUNT_USAGE_CL_CHARGE varchar,
	CONVENIENCE_FEE_BALANCE int(11),
	MIN_MERCHANT_STATEMENT_AMOUNT int(11),
	MAX_MERCHANT_STATEMENT_AMOUNT int(11),
	MAX_RESERVE_ADJUSTMENT_AMOUNT int(11),
	REMITTANCE_HOLD_USER_CODE varchar,
	REMITTANCE_HOLD_NOTE varchar,
	BANK_ACCOUNT_TYPE_CL varchar,
	REMITTANCE_CURRENCY_CODE varchar,
	SETTLEMENT_CURRENCY_CODE varchar,
	REMITTANCE_START_DATE datetime,
	FEE_TEMPLATE_CODE bigint(20),
	CC_REMITTANCE_PERIOD int(11),
	AMEX_REMITTANCE_PERIOD int(11),
	REMITTANCE_PERIOD int(11),
	ACH_REMITTANCE_PERIOD int(11),
	ANNUAL_FEE_POLICY varchar,
	ANNUAL_FEE_POLICY varchar,
	ANNUAL_FEE_POLICY varchar,
	ANNUAL_FEE_POLICY varchar,
	ANNUAL_FEE_POLICY varchar,
	CC_REMITTANCE_PERIOD int(11),
	AMEX_REMITTANCE_PERIOD int(11),
	REMITTANCE_PERIOD int(11),
	ACH_REMITTANCE_PERIOD int(11),
	TAX_BALANCE int(11),
	TAX_BALANCE bigint(20),
	CC_REMITTANCE_PERIOD int(11),
	AMEX_REMITTANCE_PERIOD int(11),
	REMITTANCE_PERIOD int(11),
	ACH_REMITTANCE_PERIOD int(11),
	RESELLER_CODE int(11),
	RETURN_FEE_BALANCE bigint(20),
	RETURN_TAX_BALANCE bigint(20),
	RETURN_PROCESSING_COST_BALANCE bigint(20),
	LAST_REMITTANCE_RECONCILIATION_STATISTICS_UPDATE_DATE datetime,
	RETURN_TAX_BALANCE_REPORTED bigint(20),
	RETURN_FEE_BALANCE_REPORTED bigint(20),
	RETURN_PROCESSING_COST_BALANCE_REPORTED bigint(20),
	TAX_BALANCE bigint(20),
	PROCESSING_COST_BALANCE bigint(20),
	FEE_BALANCE bigint(20),
	CHARGEBACK_RESERVE_RATE decimal(10,2),
	RETURN_RESERVE_RATE decimal(10,2),
	CHARGEBACK_RESERVE_RATE decimal(10,2),
	RETURN_RESERVE_RATE decimal(10,2),
	RETURN_BALANCE_REPORTED bigint(20),
	BALANCE bigint(20),
	NET_BALANCE bigint(20),
	RETURNS_BALANCE bigint(20),
	REATTEMPT_RETURNS_BALANCE bigint(20),
	RESELLER_CODE int(11),
	RETURN_FEE_BALANCE bigint(20),
	RETURN_TAX_BALANCE bigint(20),
	RETURN_PROCESSING_COST_BALANCE bigint(20),
	LAST_REMITTANCE_RECONCILIATION_STATISTICS_UPDATE_DATE datetime,
	RETURN_TAX_BALANCE_REPORTED bigint(20),
	RETURN_FEE_BALANCE_REPORTED bigint(20),
	RETURN_PROCESSING_COST_BALANCE_REPORTED bigint(20),
	PROCESSING_COST_BALANCE bigint(20),
	FEE_BALANCE bigint(20),
	RETURN_BALANCE_REPORTED bigint(20),
	STATEMENT_VIEW_POLICY varchar,
	STATEMENT_VIEW_POLICY varchar,
	TAX_BALANCE bigint(20),
	RESELLER_CODE int(11),
	RETURN_FEE_BALANCE bigint(20),
	RETURN_TAX_BALANCE bigint(20),
	RETURN_PROCESSING_COST_BALANCE bigint(20),
	LAST_REMITTANCE_RECONCILIATION_STATISTICS_UPDATE_DATE datetime,
	RETURN_TAX_BALANCE_REPORTED bigint(20),
	RETURN_FEE_BALANCE_REPORTED bigint(20),
	RETURN_PROCESSING_COST_BALANCE_REPORTED bigint(20),
	PROCESSING_COST_BALANCE bigint(20),
	RETURN_BALANCE_REPORTED bigint(20),
	STATEMENT_VIEW_POLICY varchar,
	STATEMENT_EMAILING_POLICY varchar,
	FEES_RESPONSIBLE_CL varchar,
	DIRECT_DEBIT_BALANCE bigint(20),
	BANK_CARD_BALANCE bigint(20),
	DIRECT_DEBIT_NET_BALANCE bigint(20),
	BANK_CARD_NET_BALANCE bigint(20),
	DIRECT_DEBIT_FUTURE_RESERVE_BALANCE bigint(20),
	BANK_CARD_FUTURE_RESERVE_BALANCE bigint(20),
	DIRECT_DEBIT_FUTURE_FEE_BALANCE bigint(20),
	BANK_CARD_FUTURE_FEE_BALANCE bigint(20),
	DIRECT_DEBIT_FEE_BALANCE bigint(20),
	BANK_CARD_FEE_BALANCE bigint(20),
	DIRECT_DEBIT_RETURNS_BALANCE bigint(20),
	BANK_CARD_RETURNS_BALANCE bigint(20),
	DIRECT_DEBIT_REATTEMPT_RETURNS_BALANCE bigint(20),
	BANK_CARD_REATTEMPT_RETURNS_BALANCE bigint(20),
	STATEMENT_EMAILING_POLICY varchar,
	REMITTANCE_RECIPIENT_LIST_MONTHLY varchar,
	REMITTANCE_RECIPIENT_LIST_MONTHLY varchar,
	DIRECT_DEBIT_BALANCE bigint(20),
	BANK_CARD_BALANCE bigint(20),
	DIRECT_DEBIT_NET_BALANCE bigint(20),
	BANK_CARD_NET_BALANCE bigint(20),
	DIRECT_DEBIT_FUTURE_RESERVE_BALANCE bigint(20),
	BANK_CARD_FUTURE_RESERVE_BALANCE bigint(20),
	DIRECT_DEBIT_FUTURE_FEE_BALANCE bigint(20),
	BANK_CARD_FUTURE_FEE_BALANCE bigint(20),
	DIRECT_DEBIT_FEE_BALANCE bigint(20),
	BANK_CARD_FEE_BALANCE bigint(20),
	DIRECT_DEBIT_RETURNS_BALANCE bigint(20),
	BANK_CARD_RETURNS_BALANCE bigint(20),
	DIRECT_DEBIT_REATTEMPT_RETURNS_BALANCE bigint(20),
	BANK_CARD_REATTEMPT_RETURNS_BALANCE bigint(20),
	DIRECT_DEBIT_TAX_BALANCE bigint(20),
	DIRECT_DEBIT_PROCESSING_COST_BALANCE bigint(20),
	BANK_CARD_TAX_BALANCE bigint(20),
	BANK_CARD_PROCESSING_COST_BALANCE bigint(20),
	DIRECT_DEBIT_RETURN_FEE_BALANCE bigint(20),
	BANK_CARD_RETURN_FEE_BALANCE bigint(20),
	DIRECT_DEBIT_RETURN_TAX_BALANCE bigint(20),
	BANK_CARD_RETURN_TAX_BALANCE bigint(20),
	DIRECT_DEBIT_RETURN_PROCESSING_COST_BALANCE bigint(20),
	BANK_CARD_RETURN_PROCESSING_COST_BALANCE bigint(20),
	FEES_RESPONSIBLE_CL varchar,
	MONTHLY_STATEMENT_SENT_DATE datetime,
	OWNER_CL varchar,
	OWNER_CL varchar,
	REMITTANCE_RECIPIENT_LIST_MONTHLY varchar,
	DIRECT_DEBIT_BALANCE bigint(20),
	BANK_CARD_BALANCE bigint(20),
	DIRECT_DEBIT_NET_BALANCE bigint(20),
	BANK_CARD_NET_BALANCE bigint(20),
	DIRECT_DEBIT_FUTURE_RESERVE_BALANCE bigint(20),
	BANK_CARD_FUTURE_RESERVE_BALANCE bigint(20),
	DIRECT_DEBIT_FUTURE_FEE_BALANCE bigint(20),
	BANK_CARD_FUTURE_FEE_BALANCE bigint(20),
	DIRECT_DEBIT_FEE_BALANCE bigint(20),
	BANK_CARD_FEE_BALANCE bigint(20),
	DIRECT_DEBIT_RETURNS_BALANCE bigint(20),
	BANK_CARD_RETURNS_BALANCE bigint(20),
	DIRECT_DEBIT_REATTEMPT_RETURNS_BALANCE bigint(20),
	BANK_CARD_REATTEMPT_RETURNS_BALANCE bigint(20),
	FEES_RESPONSIBLE_CL varchar,
	OWNER_CL varchar,
	MONTHLY_STATEMENT_SENT_DATE datetime,
	MONTHLY_STATEMENT_SENT_DATE datetime,
	LAST_MERCHANT_REMITTANCE_STATISTICS_UPDATE_DATE datetime,
	LAST_MERCHANT_REMITTANCE_STATISTICS_UPDATE_DATE datetime,
	LAST_MERCHANT_REMITTANCE_STATISTICS_UPDATE_DATE datetime,
	MADA_REMITTANCE_PERIOD int(11),
	MERCHANT_FEE_SCHEMA_FK bigint(20),
	RECURRING_ANNUAL01_DATE datetime,
	RECURRING_ANNUAL02_DATE datetime,
	RECURRING_ANNUAL03_DATE datetime,
	RECURRING_ANNUAL04_DATE datetime,
	RECURRING_ANNUAL05_DATE datetime,
	RECURRING_ONETIME01_DATE datetime,
	RECURRING_ONETIME02_DATE datetime,
	RECURRING_ONETIME03_DATE datetime,
	RECURRING_ONETIME04_DATE datetime,
	RECURRING_ONETIME05_DATE datetime,
	RECURRING_ONETIME06_DATE datetime,
	RECURRING_ANNUAL01_DATE datetime,
	RECURRING_ANNUAL02_DATE datetime,
	RECURRING_ANNUAL03_DATE datetime,
	RECURRING_ANNUAL04_DATE datetime,
	RECURRING_ANNUAL05_DATE datetime,
	RECURRING_ONETIME01_DATE datetime,
	RECURRING_ONETIME02_DATE datetime,
	RECURRING_ONETIME03_DATE datetime,
	RECURRING_ONETIME04_DATE datetime,
	RECURRING_ONETIME05_DATE datetime,
	RECURRING_ONETIME06_DATE datetime,
	MERCHANT_FEE_SCHEMA_FK bigint(20),
	MADA_REMITTANCE_PERIOD int(11),
	MADA_REMITTANCE_PERIOD int(11),
	RECURRING_ANNUAL01_DATE datetime,
	RECURRING_ANNUAL02_DATE datetime,
	RECURRING_ANNUAL03_DATE datetime,
	RECURRING_ANNUAL04_DATE datetime,
	RECURRING_ANNUAL05_DATE datetime,
	RECURRING_ONETIME01_DATE datetime,
	RECURRING_ONETIME02_DATE datetime,
	RECURRING_ONETIME03_DATE datetime,
	RECURRING_ONETIME04_DATE datetime,
	RECURRING_ONETIME05_DATE datetime,
	RECURRING_ONETIME06_DATE datetime,
	MERCHANT_FEE_SCHEMA_FK bigint(20),
	MADA_REMITTANCE_PERIOD int(11),
	PREV_RESELLER_STATEMENT_DATE datetime,
	LAST_RESELLER_STATEMENT_DATE datetime,
	LAST_AGENT_STATEMENT_DATE datetime,
	PREV_AGENT_STATEMENT_DATE datetime,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;