-- Create Table Statement for 'Merchant Fee Schema'
DROP TABLE IF EXISTS `MERCHANT_FEE_SCHEMA`;
CREATE TABLE `MERCHANT_FEE_SCHEMA` (
PORTFOLIO_CODE int(11),
RESELLER_CODE int(11),
MERCHANT_ACCOUNT_CODE int(11),
FUNDING_MODE_CL varchar,
FEE_TEMPLATE_CODE varchar,
DESCRIPTION varchar,
MONTHLY_FEE_DAY int(11),
PROCESSING_COST_CL varchar,
REALTIME_DEPOSIT_POLICY varchar,
BATCH_DEPOSIT_POLICY varchar,
REALTIME_VISA_CARD_PRESENT_PROCESSING_BUY_RATE int(11),
REALTIME_VISA_CARD_PRESENT_PROCESSING_DESCRIPTION varchar,
REALTIME_VISA_CARD_PRESENT_PROCESSING_FEE int(11),
REALTIME_VISA_CARD_PRESENT_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
REALTIME_VISA_CARD_PRESENT_ITEM_BUY_RATE int(11),
REALTIME_VISA_CARD_PRESENT_ITEM_DESCRIPTION varchar,
REALTIME_VISA_CARD_PRESENT_ITEM_FEE int(11),
REALTIME_VISA_CARD_PRESENT_ITEM_FEE_FUNDING_POLICY_CL varchar,
REALTIME_VISA_CARD_PRESENT_REFUND_POLICY_CL varchar,
REALTIME_VISA_PROCESSING_BUY_RATE int(11),
REALTIME_VISA_PROCESSING_DESCRIPTION varchar,
REALTIME_VISA_PROCESSING_FEE int(11),
REALTIME_VISA_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
REALTIME_VISA_ITEM_BUY_RATE int(11),
REALTIME_VISA_ITEM_DESCRIPTION varchar,
REALTIME_VISA_ITEM_FEE int(11),
REALTIME_VISA_ITEM_FEE_FUNDING_POLICY_CL varchar,
REALTIME_VISA_REFUND_POLICY_CL varchar,
REALTIME_VISA_DEBIT_PROCESSING_BUY_RATE int(11),
REALTIME_VISA_DEBIT_PROCESSING_DESCRIPTION varchar,
REALTIME_VISA_DEBIT_PROCESSING_FEE int(11),
REALTIME_VISA_DEBIT_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
REALTIME_VISA_DEBIT_ITEM_BUY_RATE int(11),
REALTIME_VISA_DEBIT_ITEM_DESCRIPTION varchar,
REALTIME_VISA_DEBIT_ITEM_FEE int(11),
REALTIME_VISA_DEBIT_ITEM_FEE_FUNDING_POLICY_CL varchar,
REALTIME_VISA_DEBIT_REFUND_POLICY_CL varchar,
BATCH_VISA_PROCESSING_BUY_RATE int(11),
BATCH_VISA_PROCESSING_DESCRIPTION varchar,
BATCH_VISA_PROCESSING_FEE int(11),
BATCH_VISA_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
BATCH_VISA_ITEM_BUY_RATE int(11),
BATCH_VISA_ITEM_DESCRIPTION varchar,
BATCH_VISA_ITEM_FEE int(11),
BATCH_VISA_ITEM_FEE_FUNDING_POLICY_CL varchar,
BATCH_VISA_REFUND_POLICY_CL varchar,
BATCH_VISA_DEBIT_PROCESSING_BUY_RATE int(11),
BATCH_VISA_DEBIT_PROCESSING_DESCRIPTION varchar,
BATCH_VISA_DEBIT_PROCESSING_FEE int(11),
BATCH_VISA_DEBIT_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
BATCH_VISA_DEBIT_ITEM_BUY_RATE int(11),
BATCH_VISA_DEBIT_ITEM_DESCRIPTION varchar,
BATCH_VISA_DEBIT_ITEM_FEE int(11),
BATCH_VISA_DEBIT_ITEM_FEE_FUNDING_POLICY_CL varchar,
BATCH_VISA_DEBIT_REFUND_POLICY_CL varchar,
REALTIME_MASTER_CARD_CARD_PRESENT_PROCESSING_BUY_RATE int(11),
REALTIME_MASTER_CARD_CARD_PRESENT_PROCESSING_DESCRIPTION varchar,
REALTIME_MASTER_CARD_CARD_PRESENT_PROCESSING_FEE int(11),
REALTIME_MC_CARD_PRESENT_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
REALTIME_MASTER_CARD_CARD_PRESENT_ITEM_BUY_RATE int(11),
REALTIME_MASTER_CARD_CARD_PRESENT_ITEM_DESCRIPTION varchar,
REALTIME_MASTER_CARD_CARD_PRESENT_ITEM_FEE int(11),
REALTIME_MASTER_CARD_CARD_PRESENT_ITEM_FEE_FUNDING_POLICY_CL varchar,
REALTIME_MASTER_CARD_CARD_PRESENT_REFUND_POLICY_CL varchar,
REALTIME_MASTER_CARD_PROCESSING_BUY_RATE int(11),
REALTIME_MASTER_CARD_PROCESSING_DESCRIPTION varchar,
REALTIME_MASTER_CARD_PROCESSING_FEE int(11),
REALTIME_MASTER_CARD_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
REALTIME_MASTER_CARD_ITEM_BUY_RATE int(11),
REALTIME_MASTER_CARD_ITEM_DESCRIPTION varchar,
REALTIME_MASTER_CARD_ITEM_FEE int(11),
REALTIME_MASTER_CARD_ITEM_FEE_FUNDING_POLICY_CL varchar,
REALTIME_MASTER_CARD_REFUND_POLICY_CL varchar,
REALTIME_MASTER_CARD_DEBIT_PROCESSING_BUY_RATE int(11),
REALTIME_MASTER_CARD_DEBIT_PROCESSING_DESCRIPTION varchar,
REALTIME_MASTER_CARD_DEBIT_PROCESSING_FEE int(11),
REALTIME_MASTER_CARD_DEBIT_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
REALTIME_MASTER_CARD_DEBIT_ITEM_BUY_RATE int(11),
REALTIME_MASTER_CARD_DEBIT_ITEM_DESCRIPTION varchar,
REALTIME_MASTER_CARD_DEBIT_ITEM_FEE int(11),
REALTIME_MASTER_CARD_DEBIT_ITEM_FEE_FUNDING_POLICY_CL varchar,
REALTIME_MASTER_CARD_DEBIT_REFUND_POLICY_CL varchar,
BATCH_MASTER_CARD_PROCESSING_BUY_RATE int(11),
BATCH_MASTER_CARD_PROCESSING_DESCRIPTION varchar,
BATCH_MASTER_CARD_PROCESSING_FEE int(11),
BATCH_MASTER_CARD_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
BATCH_MASTER_CARD_ITEM_BUY_RATE int(11),
BATCH_MASTER_CARD_ITEM_DESCRIPTION varchar,
BATCH_MASTER_CARD_ITEM_FEE int(11),
BATCH_MASTER_CARD_ITEM_FEE_FUNDING_POLICY_CL varchar,
BATCH_MASTER_CARD_REFUND_POLICY_CL varchar,
BATCH_MASTER_CARD_DEBIT_PROCESSING_BUY_RATE int(11),
BATCH_MASTER_CARD_DEBIT_PROCESSING_DESCRIPTION varchar,
BATCH_MASTER_CARD_DEBIT_PROCESSING_FEE int(11),
BATCH_MASTER_CARD_DEBIT_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
BATCH_MASTER_CARD_DEBIT_ITEM_BUY_RATE int(11),
BATCH_MASTER_CARD_DEBIT_ITEM_DESCRIPTION varchar,
BATCH_MASTER_CARD_DEBIT_ITEM_FEE int(11),
BATCH_MASTER_CARD_DEBIT_ITEM_FEE_FUNDING_POLICY_CL varchar,
BATCH_MASTER_CARD_DEBIT_REFUND_POLICY_CL varchar,
REALTIME_DISCOVER_CARD_PRESENT_PROCESSING_BUY_RATE int(11),
REALTIME_DISCOVER_CARD_PRESENT_PROCESSING_DESCRIPTION varchar,
REALTIME_DISCOVER_CARD_PRESENT_PROCESSING_FEE int(11),
REALTIME_DISCOVER_CARD_PRESENT_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
REALTIME_DISCOVER_CARD_PRESENT_ITEM_BUY_RATE int(11),
REALTIME_DISCOVER_CARD_PRESENT_ITEM_DESCRIPTION varchar,
REALTIME_DISCOVER_CARD_PRESENT_ITEM_FEE int(11),
REALTIME_DISCOVER_CARD_PRESENT_ITEM_FEE_FUNDING_POLICY_CL varchar,
REALTIME_DISCOVER_CARD_PRESENT_REFUND_POLICY_CL varchar,
REALTIME_DISCOVER_PROCESSING_BUY_RATE int(11),
REALTIME_DISCOVER_PROCESSING_DESCRIPTION varchar,
REALTIME_DISCOVER_PROCESSING_FEE int(11),
REALTIME_DISCOVER_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
REALTIME_DISCOVER_ITEM_BUY_RATE int(11),
REALTIME_DISCOVER_ITEM_DESCRIPTION varchar,
REALTIME_DISCOVER_ITEM_FEE int(11),
REALTIME_DISCOVER_ITEM_FEE_FUNDING_POLICY_CL varchar,
REALTIME_DISCOVER_REFUND_POLICY_CL varchar,
BATCH_DISCOVER_PROCESSING_BUY_RATE int(11),
BATCH_DISCOVER_PROCESSING_DESCRIPTION varchar,
BATCH_DISCOVER_PROCESSING_FEE int(11),
BATCH_DISCOVER_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
BATCH_DISCOVER_ITEM_BUY_RATE int(11),
BATCH_DISCOVER_ITEM_DESCRIPTION varchar,
BATCH_DISCOVER_ITEM_FEE_FUNDING_POLICY_CL varchar,
BATCH_DISCOVER_REFUND_POLICY_CL varchar,
BATCH_DISCOVER_ITEM_FEE int(11),
REALTIME_AMEX_CARD_PRESENT_PROCESSING_BUY_RATE int(11),
REALTIME_AMEX_CARD_PRESENT_PROCESSING_DESCRIPTION varchar,
REALTIME_AMEX_CARD_PRESENT_PROCESSING_FEE int(11),
REALTIME_AMEX_CARD_PRESENT_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
REALTIME_AMEX_CARD_PRESENT_ITEM_BUY_RATE int(11),
REALTIME_AMEX_CARD_PRESENT_ITEM_DESCRIPTION varchar,
REALTIME_AMEX_CARD_PRESENT_ITEM_FEE int(11),
REALTIME_AMEX_CARD_PRESENT_ITEM_FEE_FUNDING_POLICY_CL varchar,
REALTIME_AMEX_CARD_PRESENT_REFUND_POLICY_CL varchar,
REALTIME_AMEX_PROCESSING_BUY_RATE int(11),
REALTIME_AMEX_PROCESSING_DESCRIPTION varchar,
REALTIME_AMEX_PROCESSING_FEE int(11),
REALTIME_AMEX_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
REALTIME_AMEX_ITEM_BUY_RATE int(11),
REALTIME_AMEX_ITEM_DESCRIPTION varchar,
REALTIME_AMEX_ITEM_FEE int(11),
REALTIME_AMEX_ITEM_FEE_FUNDING_POLICY_CL varchar,
REALTIME_AMEX_REFUND_POLICY_CL varchar,
BATCH_AMEX_PROCESSING_BUY_RATE int(11),
BATCH_AMEX_PROCESSING_DESCRIPTION varchar,
BATCH_AMEX_PROCESSING_FEE int(11),
BATCH_AMEX_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
BATCH_AMEX_ITEM_BUY_RATE int(11),
BATCH_AMEX_ITEM_DESCRIPTION varchar,
BATCH_AMEX_ITEM_FEE int(11),
BATCH_AMEX_ITEM_FEE_FUNDING_POLICY_CL varchar,
BATCH_AMEX_REFUND_POLICY_CL varchar,
REALTIME_DIRECT_DEBIT_PROCESSING_BUY_RATE int(11),
REALTIME_DIRECT_DEBIT_PROCESSING_DESCRIPTION varchar,
REALTIME_DIRECT_DEBIT_PROCESSING_FEE int(11),
REALTIME_DIRECT_DEBIT_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
REALTIME_DIRECT_DEBIT_ITEM_BUY_RATE int(11),
REALTIME_DIRECT_DEBIT_ITEM_DESCRIPTION varchar,
REALTIME_DIRECT_DEBIT_ITEM_FEE int(11),
REALTIME_DIRECT_DEBIT_MAX_FEE_AMOUNT int(11),
REALTIME_DIRECT_DEBIT_ITEM_FEE_FUNDING_POLICY_CL varchar,
REALTIME_DIRECT_DEBIT_REFUND_POLICY_CL varchar,
BATCH_DIRECT_DEBIT_PROCESSING_BUY_RATE int(11),
BATCH_DIRECT_DEBIT_PROCESSING_DESCRIPTION varchar,
BATCH_DIRECT_DEBIT_PROCESSING_FEE int(11),
BATCH_DIRECT_DEBIT_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
BATCH_DIRECT_DEBIT_ITEM_BUY_RATE int(11),
BATCH_DIRECT_DEBIT_ITEM_DESCRIPTION varchar,
BATCH_DIRECT_DEBIT_ITEM_FEE int(11),
BATCH_DIRECT_DEBIT_MAX_FEE_AMOUNT int(11),
BATCH_DIRECT_DEBIT_ITEM_FEE_FUNDING_POLICY_CL varchar,
BATCH_DIRECT_DEBIT_REFUND_POLICY_CL varchar,
REALTIME_MADA_CARD_PRESENT_PROCESSING_BUY_RATE int(11),
REALTIME_MADA_CARD_PRESENT_PROCESSING_DESCRIPTION varchar,
REALTIME_MADA_CARD_PRESENT_PROCESSING_FEE int(11),
REALTIME_MADA_CARD_PRESENT_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
REALTIME_MADA_CARD_PRESENT_ITEM_BUY_RATE int(11),
REALTIME_MADA_CARD_PRESENT_ITEM_DESCRIPTION varchar,
REALTIME_MADA_CARD_PRESENT_ITEM_FEE int(11),
REALTIME_MADA_CARD_PRESENT_ITEM_FEE_FUNDING_POLICY_CL varchar,
REALTIME_MADA_CARD_PRESENT_REFUND_POLICY_CL varchar,
REALTIME_MADA_PROCESSING_BUY_RATE int(11),
REALTIME_MADA_PROCESSING_DESCRIPTION varchar,
REALTIME_MADA_PROCESSING_FEE int(11),
REALTIME_MADA_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
REALTIME_MADA_ITEM_BUY_RATE int(11),
REALTIME_MADA_ITEM_DESCRIPTION varchar,
REALTIME_MADA_ITEM_FEE int(11),
REALTIME_MADA_ITEM_FEE_FUNDING_POLICY_CL varchar,
REALTIME_MADA_REFUND_POLICY_CL varchar,
BATCH_MADA_PROCESSING_BUY_RATE int(11),
BATCH_MADA_PROCESSING_DESCRIPTION varchar,
BATCH_MADA_PROCESSING_FEE int(11),
BATCH_MADA_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
BATCH_MADA_ITEM_DESCRIPTION varchar,
BATCH_MADA_ITEM_FEE int(11),
BATCH_MADA_ITEM_FEE_FUNDING_POLICY_CL varchar,
BATCH_MADA_REFUND_POLICY_CL varchar,
REALTIME_BANK_CARD_PROCESSING_BUY_RATE int(11),
REALTIME_BANK_CARD_PROCESSING_DESCRIPTION varchar,
REALTIME_BANK_CARD_PROCESSING_FEE int(11),
REALTIME_BANK_CARD_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
REALTIME_BANK_CARD_ITEM_BUY_RATE int(11),
REALTIME_BANK_CARD_ITEM_DESCRIPTION varchar,
REALTIME_BANK_CARD_ITEM_FEE int(11),
REALTIME_BANK_CARD_ITEM_FEE_FUNDING_POLICY_CL varchar,
REALTIME_BANK_CARD_REFUND_POLICY_CL varchar,
REALTIME_EBT_PROCESSING_BUY_RATE int(11),
REALTIME_EBT_PROCESSING_DESCRIPTION varchar,
REALTIME_EBT_PROCESSING_FEE int(11),
REALTIME_EBT_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
REALTIME_EBT_ITEM_BUY_RATE int(11),
REALTIME_EBT_ITEM_DESCRIPTION varchar,
REALTIME_EBT_ITEM_FEE int(11),
REALTIME_EBT_ITEM_FEE_FUNDING_POLICY_CL varchar,
REALTIME_EBT_REFUND_POLICY_CL varchar,
FLAT_BATCH_DECLINE_BUY_RATE int(11),
FLAT_BATCH_DECLINE_DESCRIPTION varchar,
FLAT_BATCH_DECLINE_FEE int(11),
FLAT_BATCH_DECLINE_FEE_FUNDING_POLICY_CL varchar,
FLAT_REALTIME_DECLINE_BUY_RATE int(11),
FLAT_REALTIME_DECLINE_DESCRIPTION varchar,
FLAT_REALTIME_DECLINE_FEE int(11),
FLAT_REALTIME_DECLINE_FEE_FUNDING_POLICY_CL varchar,
FLAT_CHARGEBACK_BUY_RATE int(11),
FLAT_CHARGEBACK_DESCRIPTION varchar,
FLAT_CHARGEBACK_FEE int(11),
FLAT_CHARGEBACK_FEE_FUNDING_POLICY_CL varchar,
FLAT_REVERSAL_BUY_RATE int(11),
FLAT_REVERSAL_DESCRIPTION varchar,
FLAT_REVERSAL_FEE int(11),
FLAT_REVERSAL_FEE_FUNDING_POLICY_CL varchar,
FLAT_DIRECT_DEBIT_RETURN_BUY_RATE int(11),
FLAT_DIRECT_DEBIT_RETURN_DESCRIPTION varchar,
FLAT_DIRECT_DEBIT_RETURN_FEE int(11),
FLAT_DIRECT_DEBIT_RETURN_FEE_FUNDING_POLICY_CL varchar,
FLAT_DIRECT_DEBIT_NOC_BUY_RATE int(11),
FLAT_DIRECT_DEBIT_NOC_DESCRIPTION varchar,
FLAT_DIRECT_DEBIT_NOC_FEE int(11),
FLAT_DIRECT_DEBIT_NOC_FEE_FUNDING_POLICY_CL varchar,
FLAT_DIRECT_DEBIT_DISPUTE_BUY_RATE int(11),
FLAT_DIRECT_DEBIT_DISPUTE_DESCRIPTION varchar,
FLAT_DIRECT_DEBIT_DISPUTE_FEE int(11),
FLAT_DIRECT_DEBIT_DISPUTE_FEE_FUNDING_POLICY_CL varchar,
FLAT_BATCH_SUBMISSION_BUY_RATE int(11),
FLAT_BATCH_SUBMISSION_DESCRIPTION varchar,
FLAT_BATCH_SUBMISSION_FEE int(11),
FLAT_BATCH_SUBMISSION_FEE_FUNDING_POLICY_CL varchar,
FLAT_REALTIME_SUBMISSION_BUY_RATE int(11),
FLAT_REALTIME_SUBMISSION_DESCRIPTION varchar,
FLAT_REALTIME_SUBMISSION_FEE int(11),
FLAT_REALTIME_SUBMISSION_FEE_FUNDING_POLICY_CL varchar,
FLAT_DEPOSIT_BUY_RATE int(11),
FLAT_DEPOSIT_DESCRIPTION varchar,
FLAT_DEPOSIT_FEE int(11),
FLAT_DEPOSIT_FEE_FUNDING_POLICY_CL varchar,
RECURRING_ANNUAL01_BUY_RATE int(11),
RECURRING_ANNUAL01_DELAY_PERIOD int(11),
RECURRING_ANNUAL01_DESCRIPTION varchar,
RECURRING_ANNUAL01_FEE int(11),
RECURRING_ANNUAL01_FEE_FUNDING_POLICY_CL varchar,
RECURRING_ANNUAL02_BUY_RATE int(11),
RECURRING_ANNUAL02_DELAY_PERIOD int(11),
RECURRING_ANNUAL02_DESCRIPTION varchar,
RECURRING_ANNUAL02_FEE int(11),
RECURRING_ANNUAL02_FEE_FUNDING_POLICY_CL varchar,
RECURRING_ANNUAL03_BUY_RATE int(11),
RECURRING_ANNUAL03_DELAY_PERIOD int(11),
RECURRING_ANNUAL03_DESCRIPTION varchar,
RECURRING_ANNUAL03_FEE int(11),
RECURRING_ANNUAL03_FEE_FUNDING_POLICY_CL varchar,
RECURRING_ANNUAL04_BUY_RATE int(11),
RECURRING_ANNUAL04_DELAY_PERIOD int(11),
RECURRING_ANNUAL04_DESCRIPTION varchar,
RECURRING_ANNUAL04_FEE int(11),
RECURRING_ANNUAL04_FEE_FUNDING_POLICY_CL varchar,
RECURRING_ANNUAL05_BUY_RATE int(11),
RECURRING_ANNUAL05_DELAY_PERIOD int(11),
RECURRING_ANNUAL05_DESCRIPTION varchar,
RECURRING_ANNUAL05_FEE int(11),
RECURRING_ANNUAL05_FEE_FUNDING_POLICY_CL varchar,
RECURRING_MONTHLY01_BUY_RATE int(11),
RECURRING_MONTHLY01_DELAY_PERIOD int(11),
RECURRING_MONTHLY01_DESCRIPTION varchar,
RECURRING_MONTHLY01_FEE int(11),
RECURRING_MONTHLY01_FEE_FUNDING_POLICY_CL varchar,
RECURRING_MONTHLY02_BUY_RATE int(11),
RECURRING_MONTHLY02_DELAY_PERIOD int(11),
RECURRING_MONTHLY02_DESCRIPTION varchar,
RECURRING_MONTHLY02_FEE int(11),
RECURRING_MONTHLY02_FEE_FUNDING_POLICY_CL varchar,
RECURRING_MONTHLY03_BUY_RATE int(11),
RECURRING_MONTHLY03_DELAY_PERIOD int(11),
RECURRING_MONTHLY03_DESCRIPTION varchar,
RECURRING_MONTHLY03_FEE int(11),
RECURRING_MONTHLY03_FEE_FUNDING_POLICY_CL varchar,
RECURRING_MONTHLY04_BUY_RATE int(11),
RECURRING_MONTHLY04_DELAY_PERIOD int(11),
RECURRING_MONTHLY04_DESCRIPTION varchar,
RECURRING_MONTHLY04_FEE int(11),
RECURRING_MONTHLY04_FEE_FUNDING_POLICY_CL varchar,
RECURRING_MONTHLY05_BUY_RATE int(11),
RECURRING_MONTHLY05_DELAY_PERIOD int(11),
RECURRING_MONTHLY05_DESCRIPTION varchar,
RECURRING_MONTHLY05_FEE int(11),
RECURRING_MONTHLY05_FEE_FUNDING_POLICY_CL varchar,
RECURRING_MONTHLY06_BUY_RATE int(11),
RECURRING_MONTHLY06_DELAY_PERIOD int(11),
RECURRING_MONTHLY06_DESCRIPTION varchar,
RECURRING_MONTHLY06_FEE int(11),
RECURRING_MONTHLY06_FEE_FUNDING_POLICY_CL varchar,
RECURRING_MONTHLY07_BUY_RATE int(11),
RECURRING_MONTHLY07_DELAY_PERIOD int(11),
RECURRING_MONTHLY07_DESCRIPTION varchar,
RECURRING_MONTHLY07_FEE int(11),
RECURRING_MONTHLY07_FEE_FUNDING_POLICY_CL varchar,
RECURRING_MONTHLY08_BUY_RATE int(11),
RECURRING_MONTHLY08_DELAY_PERIOD int(11),
RECURRING_MONTHLY08_DESCRIPTION varchar,
RECURRING_MONTHLY08_FEE int(11),
RECURRING_MONTHLY08_FEE_FUNDING_POLICY_CL varchar,
RECURRING_MONTHLY09_BUY_RATE int(11),
RECURRING_MONTHLY09_DELAY_PERIOD int(11),
RECURRING_MONTHLY09_DESCRIPTION varchar,
RECURRING_MONTHLY09_FEE int(11),
RECURRING_MONTHLY09_FEE_FUNDING_POLICY_CL varchar,
RECURRING_MONTHLY10_BUY_RATE int(11),
RECURRING_MONTHLY10_DELAY_PERIOD int(11),
RECURRING_MONTHLY10_DESCRIPTION varchar,
RECURRING_MONTHLY10_FEE int(11),
RECURRING_MONTHLY10_FEE_FUNDING_POLICY_CL varchar,
RECURRING_ONETIME01_BUY_RATE int(11),
RECURRING_ONETIME01_DELAY_PERIOD int(11),
RECURRING_ONETIME01_DESCRIPTION varchar,
RECURRING_ONETIME01_FEE int(11),
RECURRING_ONETIME01_FEE_FUNDING_POLICY_CL varchar,
RECURRING_ONETIME02_BUY_RATE int(11),
RECURRING_ONETIME02_DELAY_PERIOD int(11),
RECURRING_ONETIME02_DESCRIPTION varchar,
RECURRING_ONETIME02_FEE int(11),
RECURRING_ONETIME02_FEE_FUNDING_POLICY_CL varchar,
RECURRING_ONETIME03_BUY_RATE int(11),
RECURRING_ONETIME03_DELAY_PERIOD int(11),
RECURRING_ONETIME03_DESCRIPTION varchar,
RECURRING_ONETIME03_FEE int(11),
RECURRING_ONETIME03_FEE_FUNDING_POLICY_CL varchar,
RECURRING_ONETIME04_BUY_RATE int(11),
RECURRING_ONETIME04_DELAY_PERIOD int(11),
RECURRING_ONETIME04_DESCRIPTION varchar,
RECURRING_ONETIME04_FEE int(11),
RECURRING_ONETIME04_FEE_FUNDING_POLICY_CL varchar,
RECURRING_ONETIME05_BUY_RATE int(11),
RECURRING_ONETIME05_DELAY_PERIOD int(11),
RECURRING_ONETIME05_DESCRIPTION varchar,
RECURRING_ONETIME05_FEE int(11),
RECURRING_ONETIME05_FEE_FUNDING_POLICY_CL varchar,
RECURRING_ONETIME06_BUY_RATE int(11),
RECURRING_ONETIME06_DELAY_PERIOD int(11),
RECURRING_ONETIME06_DESCRIPTION varchar,
RECURRING_ONETIME06_FEE_FUNDING_POLICY_CL varchar,
VOLUME_MARKUP_DESCRIPTION varchar,
VOLUME_MARKUP01_FEE int(11),
VOLUME_MARKUP01_THRESHOLD int(11),
VOLUME_MARKUP02_FEE int(11),
VOLUME_MARKUP02_THRESHOLD int(11),
VOLUME_MARKUP03_FEE int(11),
VOLUME_MARKUP03_THRESHOLD int(11),
VOLUME_MARKUP04_FEE int(11),
VOLUME_MARKUP04_THRESHOLD int(11),
VOLUME_MARKUP05_FEE int(11),
VOLUME_MARKUP05_THRESHOLD int(11),
VOLUME_MARKUP06_FEE int(11),
VOLUME_MARKUP06_THRESHOLD int(11),
VOLUME_MARKUP07_FEE int(11),
VOLUME_MARKUP07_THRESHOLD int(11),
VOLUME_MARKUP08_FEE int(11),
VOLUME_MARKUP08_THRESHOLD int(11),
VOLUME_MARKUP09_FEE int(11),
VOLUME_MARKUP09_THRESHOLD int(11),
VOLUME_MARKUP10_FEE int(11),
VOLUME_MARKUP_FEE_FUNDING_POLICY_CL varchar,
ID bigint(20) NOT NULL,
BATCH_MADA_ITEM_BUY_RATE int(11),
FEE_SCHEMA_FK int(11),
RECURRING_ONETIME06_FEE int(11),
IS_ACTIVE tinyint(1),
REALTIME_DISCOVER_DEBIT_PROCESSING_BUY_RATE int(11),
REALTIME_DISCOVER_DEBIT_PROCESSING_DESCRIPTION varchar,
REALTIME_DISCOVER_DEBIT_PROCESSING_FEE int(11),
REALTIME_DISCOVER_DEBIT_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
REALTIME_DISCOVER_DEBIT_ITEM_BUY_RATE int(11),
REALTIME_DISCOVER_DEBIT_ITEM_DESCRIPTION varchar,
REALTIME_DISCOVER_DEBIT_ITEM_FEE int(11),
REALTIME_DISCOVER_DEBIT_ITEM_FEE_FUNDING_POLICY_CL varchar,
REALTIME_DISCOVER_DEBIT_REFUND_POLICY_CL varchar,
BATCH_DISCOVER_DEBIT_PROCESSING_BUY_RATE int(11),
BATCH_DISCOVER_DEBIT_PROCESSING_DESCRIPTION varchar,
BATCH_DISCOVER_DEBIT_PROCESSING_FEE int(11),
BATCH_DISCOVER_DEBIT_PROCESSING_FEE_FUNDING_POLICY_CL varchar,
BATCH_DISCOVER_DEBIT_ITEM_BUY_RATE int(11),
BATCH_DISCOVER_DEBIT_ITEM_DESCRIPTION varchar,
BATCH_DISCOVER_DEBIT_ITEM_FEE int(11),
BATCH_DISCOVER_DEBIT_ITEM_FEE_FUNDING_POLICY_CL varchar,
BATCH_DISCOVER_DEBIT_REFUND_POLICY_CL varchar,
REALTIME_DIRECT_DEBIT_MAX_FEE_AMOUNT_BUY_RATE int(11),
BATCH_DIRECT_DEBIT_MAX_FEE_AMOUNT_BUY_RATE int(11),
REALTIME_VISA_CARD_PRESENT_PROCESSING_COMMISSIONABLE_RATE int(11),
REALTIME_VISA_CARD_PRESENT_ITEM_COMMISSIONABLE_RATE int(11),
REALTIME_VISA_PROCESSING_COMMISSIONABLE_RATE int(11),
REALTIME_VISA_ITEM_COMMISSIONABLE_RATE int(11),
REALTIME_VISA_DEBIT_PROCESSING_COMMISSIONABLE_RATE int(11),
REALTIME_VISA_DEBIT_ITEM_COMMISSIONABLE_RATE int(11),
BATCH_VISA_PROCESSING_COMMISSIONABLE_RATE int(11),
BATCH_VISA_ITEM_COMMISSIONABLE_RATE int(11),
BATCH_VISA_DEBIT_PROCESSING_COMMISSIONABLE_RATE int(11),
BATCH_VISA_DEBIT_ITEM_COMMISSIONABLE_RATE int(11),
REALTIME_MASTER_CARD_CARD_PRESENT_PROCESSING_COMMISSIONABLE_RATE int(11),
REALTIME_MASTER_CARD_CARD_PRESENT_ITEM_COMMISSIONABLE_RATE int(11),
REALTIME_MASTER_CARD_PROCESSING_COMMISSIONABLE_RATE int(11),
REALTIME_MASTER_CARD_ITEM_COMMISSIONABLE_RATE int(11),
REALTIME_MASTER_CARD_DEBIT_PROCESSING_COMMISSIONABLE_RATE int(11),
REALTIME_MASTER_CARD_DEBIT_ITEM_COMMISSIONABLE_RATE int(11),
BATCH_MASTER_CARD_PROCESSING_COMMISSIONABLE_RATE int(11),
BATCH_MASTER_CARD_ITEM_COMMISSIONABLE_RATE int(11),
BATCH_MASTER_CARD_DEBIT_PROCESSING_COMMISSIONABLE_RATE int(11),
BATCH_MASTER_CARD_DEBIT_ITEM_COMMISSIONABLE_RATE int(11),
REALTIME_DISCOVER_CARD_PRESENT_PROCESSING_COMMISSIONABLE_RATE int(11),
REALTIME_DISCOVER_CARD_PRESENT_ITEM_COMMISSIONABLE_RATE int(11),
REALTIME_DISCOVER_PROCESSING_COMMISSIONABLE_RATE int(11),
REALTIME_DISCOVER_ITEM_COMMISSIONABLE_RATE int(11),
REALTIME_DISCOVER_DEBIT_PROCESSING_COMMISSIONABLE_RATE int(11),
REALTIME_DISCOVER_DEBIT_ITEM_COMMISSIONABLE_RATE int(11),
BATCH_DISCOVER_PROCESSING_COMMISSIONABLE_RATE int(11),
BATCH_DISCOVER_ITEM_COMMISSIONABLE_RATE int(11),
BATCH_DISCOVER_DEBIT_PROCESSING_COMMISSIONABLE_RATE int(11),
BATCH_DISCOVER_DEBIT_ITEM_COMMISSIONABLE_RATE int(11),
REALTIME_AMEX_CARD_PRESENT_PROCESSING_COMMISSIONABLE_RATE int(11),
REALTIME_AMEX_CARD_PRESENT_ITEM_COMMISSIONABLE_RATE int(11),
REALTIME_AMEX_PROCESSING_COMMISSIONABLE_RATE int(11),
REALTIME_AMEX_ITEM_COMMISSIONABLE_RATE int(11),
BATCH_AMEX_PROCESSING_COMMISSIONABLE_RATE int(11),
BATCH_AMEX_ITEM_COMMISSIONABLE_RATE int(11),
REALTIME_DIRECT_DEBIT_PROCESSING_COMMISSIONABLE_RATE int(11),
REALTIME_DIRECT_DEBIT_ITEM_COMMISSIONABLE_RATE int(11),
REALTIME_DIRECT_DEBIT_MAX_FEE_AMOUNT_COMMISSIONABLE_RATE int(11),
BATCH_DIRECT_DEBIT_PROCESSING_COMMISSIONABLE_RATE int(11),
BATCH_DIRECT_DEBIT_ITEM_COMMISSIONABLE_RATE int(11),
BATCH_DIRECT_DEBIT_MAX_FEE_AMOUNT_COMMISSIONABLE_RATE int(11),
REALTIME_MADA_CARD_PRESENT_PROCESSING_COMMISSIONABLE_RATE int(11),
REALTIME_MADA_CARD_PRESENT_ITEM_COMMISSIONABLE_RATE int(11),
REALTIME_MADA_PROCESSING_COMMISSIONABLE_RATE int(11),
REALTIME_MADA_ITEM_COMMISSIONABLE_RATE int(11),
BATCH_MADA_PROCESSING_COMMISSIONABLE_RATE int(11),
BATCH_MADA_ITEM_COMMISSIONABLE_RATE int(11),
REALTIME_BANK_CARD_PROCESSING_COMMISSIONABLE_RATE int(11),
REALTIME_BANK_CARD_ITEM_COMMISSIONABLE_RATE int(11),
REALTIME_EBT_PROCESSING_COMMISSIONABLE_RATE int(11),
REALTIME_EBT_ITEM_COMMISSIONABLE_RATE int(11),
FLAT_BATCH_DECLINE_COMMISSIONABLE_RATE int(11),
FLAT_REALTIME_DECLINE_COMMISSIONABLE_RATE int(11),
FLAT_CHARGEBACK_COMMISSIONABLE_RATE int(11),
FLAT_REVERSAL_COMMISSIONABLE_RATE int(11),
FLAT_DIRECT_DEBIT_RETURN_COMMISSIONABLE_RATE int(11),
FLAT_DIRECT_DEBIT_NOC_COMMISSIONABLE_RATE int(11),
FLAT_DIRECT_DEBIT_DISPUTE_COMMISSIONABLE_RATE int(11),
FLAT_BATCH_SUBMISSION_COMMISSIONABLE_RATE int(11),
FLAT_REALTIME_SUBMISSION_COMMISSIONABLE_RATE int(11),
FLAT_DEPOSIT_COMMISSIONABLE_RATE int(11),
RECURRING_ANNUAL01_COMMISSIONABLE_RATE int(11),
RECURRING_ANNUAL02_COMMISSIONABLE_RATE int(11),
RECURRING_ANNUAL03_COMMISSIONABLE_RATE int(11),
RECURRING_ANNUAL04_COMMISSIONABLE_RATE int(11),
RECURRING_ANNUAL05_COMMISSIONABLE_RATE int(11),
RECURRING_MONTHLY01_COMMISSIONABLE_RATE int(11),
RECURRING_MONTHLY02_COMMISSIONABLE_RATE int(11),
RECURRING_MONTHLY03_COMMISSIONABLE_RATE int(11),
RECURRING_MONTHLY04_COMMISSIONABLE_RATE int(11),
RECURRING_MONTHLY05_COMMISSIONABLE_RATE int(11),
RECURRING_MONTHLY06_COMMISSIONABLE_RATE int(11),
RECURRING_MONTHLY07_COMMISSIONABLE_RATE int(11),
RECURRING_MONTHLY08_COMMISSIONABLE_RATE int(11),
RECURRING_MONTHLY09_COMMISSIONABLE_RATE int(11),
RECURRING_MONTHLY10_COMMISSIONABLE_RATE int(11),
RECURRING_ONETIME01_COMMISSIONABLE_RATE int(11),
RECURRING_ONETIME02_COMMISSIONABLE_RATE int(11),
RECURRING_ONETIME03_COMMISSIONABLE_RATE int(11),
RECURRING_ONETIME04_COMMISSIONABLE_RATE int(11),
RECURRING_ONETIME05_COMMISSIONABLE_RATE int(11),
RECURRING_ONETIME06_COMMISSIONABLE_RATE int(11),
VOLUME_MARKUP_COMMISSIONABLE_RATE int(11),
REALTIME_ITEM_FEE_POLICY varchar,
BATCH_ITEM_FEE_POLICY varchar,
FEE_TYPE_CL varchar,
CREATE_DATE datetime,
EFFECTIVE_DATE date,
MERCHANT_FEE_SCHEMA_EXTENDED_FK bigint(20),
REALTIME_VISA_MAX_FEE_AMOUNT int(11),
REALTIME_VISA_MAX_FEE_BUY_RATE int(11),
REALTIME_VISA_CARD_PRESENT_MAX_FEE_AMOUNT int(11),
REALTIME_VISA_CARD_PRESENT_MAX_FEE_BUY_RATE int(11),
REALTIME_VISA_DEBIT_MAX_FEE_AMOUNT int(11),
REALTIME_VISA_DEBIT_MAX_FEE_BUY_RATE int(11),
BATCH_VISA_MAX_FEE_AMOUNT int(11),
BATCH_VISA_MAX_FEE_BUY_RATE int(11),
BATCH_VISA_DEBIT_MAX_FEE_AMOUNT int(11),
BATCH_VISA_DEBIT_MAX_FEE_BUY_RATE int(11),
REALTIME_MASTER_CARD_MAX_FEE_AMOUNT int(11),
REALTIME_MASTER_CARD_MAX_FEE_BUY_RATE int(11),
REALTIME_MASTER_CARD_CARD_PRESENT_MAX_FEE_AMOUNT int(11),
REALTIME_MASTER_CARD_CARD_PRESENT_MAX_FEE_BUY_RATE int(11),
REALTIME_MASTER_CARD_DEBIT_MAX_FEE_AMOUNT int(11),
REALTIME_MASTER_CARD_DEBIT_MAX_FEE_BUY_RATE int(11),
BATCH_MASTER_CARD_MAX_FEE_AMOUNT int(11),
BATCH_MASTER_CARD_MAX_FEE_BUY_RATE int(11),
BATCH_MASTER_CARD_DEBIT_MAX_FEE_AMOUNT int(11),
BATCH_MASTER_CARD_DEBIT_MAX_FEE_BUY_RATE int(11),
REALTIME_DISCOVER_MAX_FEE_AMOUNT int(11),
REALTIME_DISCOVER_MAX_FEE_BUY_RATE int(11),
REALTIME_DISCOVER_CARD_PRESENT_MAX_FEE_AMOUNT int(11),
REALTIME_DISCOVER_CARD_PRESENT_MAX_FEE_BUY_RATE int(11),
REALTIME_DISCOVER_DEBIT_MAX_FEE_AMOUNT int(11),
REALTIME_DISCOVER_DEBIT_MAX_FEE_BUY_RATE int(11),
BATCH_DISCOVER_MAX_FEE_AMOUNT int(11),
BATCH_DISCOVER_MAX_FEE_BUY_RATE int(11),
BATCH_DISCOVER_DEBIT_MAX_FEE_AMOUNT int(11),
BATCH_DISCOVER_DEBIT_MAX_FEE_BUY_RATE int(11),
REALTIME_AMEX_MAX_FEE_AMOUNT int(11),
REALTIME_AMEX_MAX_FEE_BUY_RATE int(11),
REALTIME_AMEX_CARD_PRESENT_MAX_FEE_AMOUNT int(11),
REALTIME_AMEX_CARD_PRESENT_MAX_FEE_BUY_RATE int(11),
BATCH_AMEX_MAX_FEE_AMOUNT int(11),
BATCH_AMEX_MAX_FEE_BUY_RATE int(11),
REALTIME_MADA_MAX_FEE_AMOUNT int(11),
REALTIME_MADA_MAX_FEE_BUY_RATE int(11),
REALTIME_MADA_CARD_PRESENT_MAX_FEE_AMOUNT int(11),
REALTIME_MADA_CARD_PRESENT_MAX_FEE_BUY_RATE int(11),
BATCH_MADA_MAX_FEE_AMOUNT int(11),
BATCH_MADA_MAX_FEE_BUY_RATE int(11),
REALTIME_BANK_CARD_MAX_FEE_AMOUNT int(11),
REALTIME_BANK_CARD_MAX_FEE_BUY_RATE int(11),
FLAT_REFUND_BUY_RATE int(11),
FLAT_REFUND_DESCRIPTION varchar,
FLAT_REFUND_FEE int(11),
FLAT_REFUND_FEE_FUNDING_POLICY_CL varchar,
FLAT_REFUND_CHARGE_BUY_RATE int(11),
FLAT_REFUND_CHARGE_DESCRIPTION varchar,
FLAT_REFUND_CHARGE_FEE int(11),
BATCH_DIRECT_DEBIT_MAX_FEE_AMOUNT_COMMISSIONABLE_RATE int(11),
REALTIME_DIRECT_DEBIT_MAX_FEE_AMOUNT_COMMISSIONABLE_RATE int(11),
FLAT_REFUND_CHARGE_FUNDING_POLICY_CL varchar,
FLAT_REFUND_COMMISSIONABLE_RATE int(11),
FLAT_REFUND_CHARGE_COMMISSIONABLE_RATE int(11),
FEE_TYPE_CL varchar,
CREATE_DATE datetime,
EFFECTIVE_DATE date,
REALTIME_ITEM_FEE_POLICY varchar,
BATCH_ITEM_FEE_POLICY varchar,
MERCHANT_FEE_SCHEMA_EXTENDED_FK bigint(20),
REALTIME_VISA_MAX_FEE_AMOUNT int(11),
REALTIME_VISA_MAX_FEE_BUY_RATE int(11),
REALTIME_VISA_CARD_PRESENT_MAX_FEE_AMOUNT int(11),
REALTIME_VISA_CARD_PRESENT_MAX_FEE_BUY_RATE int(11),
REALTIME_VISA_DEBIT_MAX_FEE_AMOUNT int(11),
REALTIME_VISA_DEBIT_MAX_FEE_BUY_RATE int(11),
BATCH_VISA_MAX_FEE_AMOUNT int(11),
BATCH_VISA_MAX_FEE_BUY_RATE int(11),
BATCH_VISA_DEBIT_MAX_FEE_AMOUNT int(11),
BATCH_VISA_DEBIT_MAX_FEE_BUY_RATE int(11),
REALTIME_MASTER_CARD_MAX_FEE_AMOUNT int(11),
REALTIME_MASTER_CARD_MAX_FEE_BUY_RATE int(11),
REALTIME_MASTER_CARD_CARD_PRESENT_MAX_FEE_AMOUNT int(11),
REALTIME_MASTER_CARD_CARD_PRESENT_MAX_FEE_BUY_RATE int(11),
REALTIME_MASTER_CARD_DEBIT_MAX_FEE_AMOUNT int(11),
REALTIME_MASTER_CARD_DEBIT_MAX_FEE_BUY_RATE int(11),
BATCH_MASTER_CARD_MAX_FEE_AMOUNT int(11),
BATCH_MASTER_CARD_MAX_FEE_BUY_RATE int(11),
BATCH_MASTER_CARD_DEBIT_MAX_FEE_AMOUNT int(11),
BATCH_MASTER_CARD_DEBIT_MAX_FEE_BUY_RATE int(11),
REALTIME_DISCOVER_MAX_FEE_AMOUNT int(11),
REALTIME_DISCOVER_MAX_FEE_BUY_RATE int(11),
REALTIME_DISCOVER_CARD_PRESENT_MAX_FEE_AMOUNT int(11),
REALTIME_DISCOVER_CARD_PRESENT_MAX_FEE_BUY_RATE int(11),
REALTIME_DISCOVER_DEBIT_MAX_FEE_AMOUNT int(11),
REALTIME_DISCOVER_DEBIT_MAX_FEE_BUY_RATE int(11),
BATCH_DISCOVER_MAX_FEE_AMOUNT int(11),
BATCH_DISCOVER_MAX_FEE_BUY_RATE int(11),
BATCH_DISCOVER_DEBIT_MAX_FEE_AMOUNT int(11),
BATCH_DISCOVER_DEBIT_MAX_FEE_BUY_RATE int(11),
REALTIME_AMEX_MAX_FEE_AMOUNT int(11),
REALTIME_AMEX_MAX_FEE_BUY_RATE int(11),
REALTIME_AMEX_CARD_PRESENT_MAX_FEE_AMOUNT int(11),
REALTIME_AMEX_CARD_PRESENT_MAX_FEE_BUY_RATE int(11),
BATCH_AMEX_MAX_FEE_AMOUNT int(11),
BATCH_AMEX_MAX_FEE_BUY_RATE int(11),
REALTIME_MADA_MAX_FEE_AMOUNT int(11),
REALTIME_MADA_MAX_FEE_BUY_RATE int(11),
REALTIME_MADA_CARD_PRESENT_MAX_FEE_AMOUNT int(11),
REALTIME_MADA_CARD_PRESENT_MAX_FEE_BUY_RATE int(11),
BATCH_MADA_MAX_FEE_AMOUNT int(11),
BATCH_MADA_MAX_FEE_BUY_RATE int(11),
REALTIME_BANK_CARD_MAX_FEE_AMOUNT int(11),
REALTIME_BANK_CARD_MAX_FEE_BUY_RATE int(11),
FLAT_REFUND_BUY_RATE int(11),
FLAT_REFUND_DESCRIPTION varchar,
FLAT_REFUND_FEE int(11),
FLAT_REFUND_FEE_FUNDING_POLICY_CL varchar,
FLAT_REFUND_CHARGE_BUY_RATE int(11),
FLAT_REFUND_CHARGE_DESCRIPTION varchar,
FLAT_REFUND_CHARGE_FEE int(11),
FLAT_REFUND_CHARGE_FUNDING_POLICY_CL varchar,
FLAT_REFUND_COMMISSIONABLE_RATE int(11),
FLAT_REFUND_CHARGE_COMMISSIONABLE_RATE int(11),
FEE_TYPE_CL varchar,
CREATE_DATE datetime,
EFFECTIVE_DATE date,
PRIMARY KEY (ID)
) ENGINE=InnoDB;