-- Create Table Statement for 'Merchant Financial Statistics'
DROP TABLE IF EXISTS `IAPP_MERCHANT_FINANCIAL_STATISTICS`;
CREATE TABLE `IAPP_MERCHANT_FINANCIAL_STATISTICS` (
ID bigint(20) NOT NULL,
MERCHANT_ACCOUNT_CODE int(11),
CREATE_DATE datetime,
AMOUNT int(11),
SUBMISSION_DATE datetime,
REQUEST_DATE datetime,
RESPONSE_DATE datetime,
DEPOSIT_DATE datetime,
REMITTANCE_DATE datetime,
TRANSACTION_SOURCE_CL varchar,
PAYMENT_CL varchar,
ATTEMPT_COUNT int(11),
SUBMISSION_CODE bigint(20),
IS_SUBMISSION_CLOSED tinyint(1),
IS_OUTSIDE_SUBMISSION tinyint(1),
TRANSACTION_CL varchar,
TRANSACTION_CODE bigint(20),
MERCHANT_ACCOUNT_GROUP_CODE bigint(20),
SUBMISSION_CL varchar,
PROVIDER_NAME varchar,
IS_FINAL_ATTEMPT tinyint(1),
FUNDING_DATE datetime,
ENTRY_CL varchar,
IS_INTERREGIONAL tinyint(1),
IS_PREPAID tinyint(1),
INTERCHANGE_RATE_NAME varchar,
INTERCHANGE_PERCENTAGE_FEE4P int(11),
INTERCHANGE_FEE_AMOUNT4P bigint(20),
INTERCHANGE_FLAT_FEE4P int(11),
PROCESSOR_FEE_AMOUNT4P int(11),
ASSESSMENTS_FEE_AMOUNT4P int(11),
PROCESSING_FEE_AMOUNT4P int(11),
PERITEM_FEE_AMOUNT4P int(11),
PROCESSING_COST_AMOUNT4P int(11),
REBILL_ATTEMPT_COUNT int(11),
SETTLEMENT_RECONCILIATION_DATE datetime,
AUTHORIZATION_RECONCILIATION_DATE datetime,
IS_AVS_ENABLED tinyint(1),
SETTLEMENT_AMOUNT int(11),
AUTHORIZATION_CURRENCY_CODE varchar,
SETTLEMENT_CURRENCY_CODE varchar,
AGGREGATE_TRANSACTION_CODE bigint(20),
FEE_AMOUNT int(11),
IS_CHARGEBACK_TRANSACTION tinyint(1),
PROVIDER_TRANSACTION_CODE varchar,
USER_CODE varchar,
ADJUSTMENT_DATE datetime,
ADJUSTMENT_NOTE varchar,
PORTFOLIO_CODE int(11),
SPLIT_MERCHANT_ACCOUNT_CODE int(11),
PROCESSOR_RECONCILIATION_DATE datetime,
ORIGINAL_TRANSACTION_CODE bigint(20),
PROCESSOR_RECONCILIATION_DATE datetime,
ORIGINAL_TRANSACTION_CODE bigint(20),
IS_CSC_ENABLED tinyint(1),
IS_CSC_ENABLED tinyint(1),
RESELLER_CODE int(11),
RESELLER_CODE int(11),
PROCESSOR_RECONCILIATION_DATE datetime,
ORIGINAL_TRANSACTION_CODE bigint(20),
IS_CSC_ENABLED tinyint(1),
RESELLER_CODE int(11),
FLAT_FEE_AMOUNT_4P int(11),
PROCESSING_FEE_RATE_4P int(11),
FLAT_FEE_AMOUNT_4P int(11),
PROCESSING_FEE_RATE_4P int(11),
IS_AGGREGATE tinyint(1),
FLAT_FEE_AMOUNT_4P int(11),
PROCESSING_FEE_RATE_4P int(11),
IS_AGGREGATE tinyint(1),
IS_AGGREGATE tinyint(1),
INTERCHANGE_FEE_AMOUNT4P bigint(20),
INTERCHANGE_FEE_AMOUNT4P bigint(20),
PRIMARY KEY (ID)
) ENGINE=InnoDB;