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