-- Create Table Statement for 'Statement'
DROP TABLE IF EXISTS `IAPP_MERCHANT_STATEMENT`;
CREATE TABLE `IAPP_MERCHANT_STATEMENT` (
	ID bigint(20) NOT NULL,
	CREATE_DATE datetime,
	START_DATE datetime,
	END_DATE datetime,
	MERCHANT_ACCOUNT_CODE int(11),
	AMOUNT int(11),
	BALANCE int(11),
	ADJUSTED_AMOUNT int(11),
	ACH_REMITTANCE_AMOUNT int(11),
	BANK_CARD_REMITTANCE_AMOUNT int(11),
	AMEX_REMITTANCE_AMOUNT int(11),
	RETURNS_AMOUNT int(11),
	MANUAL_ADJUSTMENTS_AMOUNT int(11),
	RESERVE_ADJUSTMENTS_AMOUNT int(11),
	REMITTED_AMOUNT int(11),
	STATUS_CL varchar,
	NEXT_CHARGEBACK_RESERVE_COLLECTED_AMOUNT int(11),
	NEXT_RETURN_RESERVE_COLLECTED_AMOUNT int(11),
	NEXT_REFUND_RESERVE_COLLECTED_AMOUNT int(11),
	ACH_TRANSACTION_CODE varchar,
	BANK_CARD_TRANSACTION_CODE varchar,
	AMEX_TRANSACTION_CODE varchar,
	APPROVER_CODE varchar,
	REMITTER_CODE varchar,
	NOTE varchar,
	MERCHANT_DEPOSIT_DATE datetime,
	CHARGEBACK_RESERVE_RATE decimal(10,2),
	NEXT_CHARGEBACK_RESERVE_REQUESTED_AMOUNT int(11),
	LAST_CHARGEBACK_RESERVE_COLLECTED_AMOUNT int(11),
	RETURN_RESERVE_RATE decimal(10,2),
	NEXT_RETURN_RESERVE_REQUESTED_AMOUNT int(11),
	LAST_RETURN_RESERVE_COLLECTED_AMOUNT int(11),
	REFUND_RESERVE_REQUESTED_AMOUNT int(11),
	NEXT_REFUND_RESERVE_REQUESTED_AMOUNT int(11),
	LAST_REFUND_RESERVE_REQUESTED_AMOUNT int(11),
	IS_PROCESSING_COST_BATCH_CARDS_ENABLED tinyint(1),
	IS_PROCESSING_COST_REALTIME_CARDS_ENABLED tinyint(1),
	REMITTANCE_TRANSACTION_CL varchar,
	IS_PROCESSING_COST_BATCH_AMEX_ENABLED tinyint(1),
	IS_PROCESSING_COST_BATCH_ACH_ENABLED tinyint(1),
	IS_PROCESSING_COST_REALTIME_AMEX_ENABLED tinyint(1),
	IS_PROCESSING_COST_REALTIME_ACH_ENABLED tinyint(1),
	EXPORT_DATE datetime,
	PORTFOLIO_CODE int(11),
	PREV_FEE_BALANCE bigint(20),
	NEXT_FEE_BALANCE bigint(20),
	EMAIL_SENT_DATE datetime,
	PREV_STATEMENT_BALANCE int(11),
	BALANCE_ADJUSTMENTS_AMOUNT int(11),
	WRITEOFFS_AMOUNT int(11),
	HOLD_AMOUNT int(11),
	REMITTANCE_CURRENCY_CODE varchar,
	IS_REATTEMPT_WITHDRAWAL tinyint(1),
	BATCH_DEPOSIT_POLICY varchar,
	REALTIME_DEPOSIT_POLICY varchar,
	ADVANCE_AMOUNT int(11),
	PREV_CONVENIENCE_FEE_AMOUNT int(11),
	NEXT_CONVENIENCE_FEE_AMOUNT int(11),
	CONVENIENCE_FEE_DEDUCTION_AMOUNT int(11),
	REVIEW_POLICY varchar,
	FEE_AMOUNT int(11),
	REMITTANCE_INFO varchar,
	RECONCILIATION_STATE_CL varchar,
	RECONCILIATOR_CODE varchar,
	PREV_RETURN_RESERVE_COLLECTED_AMOUNT int(11),
	PREV_REFUND_RESERVE_COLLECTED_AMOUNT int(11),
	PREV_CHARGEBACK_RESERVE_COLLECTED_AMOUNT int(11),
	PREV_BALANCE int(11),
	PREV_NET_BALANCE int(11),
	PREV_RETURNS_BALANCE int(11),
	PREV_REATTEMPT_RETURNS_BALANCE int(11),
	ARCHIVING_DATE datetime,
	MERCHANT_CYCLE_DETAIL_FK bigint(20),
	MERCHANT_FEE_FK bigint(20),
	FEE_SCHEMA_FK int(11),
	MERCHANT_ACCOUNT_GROUP_FK bigint(20),
	PORTFOLIO_EXPORT_DATE datetime,
	PORTFOLIO_EXPORT_DATE datetime,
	TAX_AMOUNT int(11),
	PREV_TAX_BALANCE int(11),
	NEXT_TAX_BALANCE int(11),
	TAX_AMOUNT bigint(20),
	PREV_TAX_BALANCE bigint(20),
	NEXT_TAX_BALANCE bigint(20),
	RESELLER_CODE int(11),
	APPROVAL_DATE datetime,
	PROCESSED_AMOUNT bigint(20),
	TAX_AMOUNT_RECEIVABLE bigint(20),
	FEE_AMOUNT_RECEIVABLE bigint(20),
	PROCESSING_COST_AMOUNT bigint(20),
	PROCESSING_COST_AMOUNT_RECEIVABLE bigint(20),
	MERCHANT_CHARGE_AMOUNT bigint(20),
	SPLIT_AMOUNT bigint(20),
	PREV_RETURN_FEE_BALANCE bigint(20),
	NEXT_RETURN_FEE_BALANCE bigint(20),
	PREV_RETURN_TAX_BALANCE bigint(20),
	NEXT_RETURN_TAX_BALANCE bigint(20),
	PREV_RETURN_PROCESSING_COST_BALANCE bigint(20),
	NEXT_RETURN_PROCESSING_COST_BALANCE bigint(20),
	TAX_AMOUNT bigint(20),
	PREV_TAX_BALANCE bigint(20),
	NEXT_TAX_BALANCE bigint(20),
	NEXT_NET_BALANCE bigint(20),
	PORTFOLIO_EXPORT_DATE datetime,
	DEPOSIT_TYPE varchar,
	DEPOSIT_TYPE varchar,
	NEXT_PROCESSING_COST_BALANCE bigint(20),
	PREV_PROCESSING_COST_BALANCE bigint(20),
	NEXT_FEE_BALANCE bigint(20),
	PREV_FEE_BALANCE bigint(20),
	PREV_NET_BALANCE int(11),
	CHARGEBACK_RESERVE_RATE decimal(10,2),
	RETURN_RESERVE_RATE decimal(10,2),
	CHARGEBACK_RESERVE_RATE decimal(10,2),
	RETURN_RESERVE_RATE decimal(10,2),
	PREV_RETURN_RESERVE_COLLECTED_AMOUNT int(11),
	PREV_REFUND_RESERVE_COLLECTED_AMOUNT int(11),
	PREV_CHARGEBACK_RESERVE_COLLECTED_AMOUNT int(11),
	PREV_RETURNS_BALANCE int(11),
	MERCHANT_STATEMENT_ACTIVITY_FK bigint(20),
	RETURN_SALE_RESERVE_TOTAL_AMOUNT bigint(20),
	CHARGEBACK_SALE_RESERVE_TOTAL_AMOUNT bigint(20),
	RETURN_RESERVE_MIN_AMOUNT bigint(20),
	CHARGEBACK_RESERVE_MIN_AMOUNT bigint(20),
	RETURN_SALE_RESERVE_TOTAL_AMOUNT bigint(20),
	CHARGEBACK_SALE_RESERVE_TOTAL_AMOUNT bigint(20),
	RETURN_RESERVE_MIN_AMOUNT bigint(20),
	CHARGEBACK_RESERVE_MIN_AMOUNT bigint(20),
	DEPOSIT_CL varchar,
	AMOUNT bigint(20),
	BALANCE bigint(20),
	ACH_REMITTANCE_AMOUNT bigint(20),
	BANK_CARD_REMITTANCE_AMOUNT bigint(20),
	AMEX_REMITTANCE_AMOUNT bigint(20),
	RETURNS_AMOUNT bigint(20),
	ADJUSTED_AMOUNT bigint(20),
	MANUAL_ADJUSTMENTS_AMOUNT bigint(20),
	REMITTED_AMOUNT bigint(20),
	PREV_STATEMENT_BALANCE bigint(20),
	BALANCE_ADJUSTMENTS_AMOUNT bigint(20),
	WRITEOFFS_AMOUNT bigint(20),
	HOLD_AMOUNT bigint(20),
	PREV_BALANCE bigint(20),
	PREV_REATTEMPT_RETURNS_BALANCE bigint(20),
	NEXT_TAX_BALANCE bigint(20),
	PREV_NET_BALANCE bigint(20),
	PREV_RETURNS_BALANCE bigint(20),
	INTERCHANGE_AMOUNT bigint(20),
	ASSESSMENTS_AMOUNT bigint(20),
	RESELLER_CODE int(11),
	APPROVAL_DATE datetime,
	PROCESSED_AMOUNT bigint(20),
	TAX_AMOUNT_RECEIVABLE bigint(20),
	FEE_AMOUNT_RECEIVABLE bigint(20),
	PROCESSING_COST_AMOUNT bigint(20),
	PROCESSING_COST_AMOUNT_RECEIVABLE bigint(20),
	MERCHANT_CHARGE_AMOUNT bigint(20),
	SPLIT_AMOUNT bigint(20),
	PREV_RETURN_FEE_BALANCE bigint(20),
	NEXT_RETURN_FEE_BALANCE bigint(20),
	PREV_RETURN_TAX_BALANCE bigint(20),
	NEXT_RETURN_TAX_BALANCE bigint(20),
	PREV_RETURN_PROCESSING_COST_BALANCE bigint(20),
	NEXT_RETURN_PROCESSING_COST_BALANCE bigint(20),
	NEXT_NET_BALANCE bigint(20),
	NEXT_PROCESSING_COST_BALANCE bigint(20),
	PREV_PROCESSING_COST_BALANCE bigint(20),
	NEXT_FEE_BALANCE bigint(20),
	PREV_FEE_BALANCE bigint(20),
	PREV_NET_BALANCE int(11),
	PREV_RETURN_RESERVE_COLLECTED_AMOUNT int(11),
	PREV_REFUND_RESERVE_COLLECTED_AMOUNT int(11),
	PREV_CHARGEBACK_RESERVE_COLLECTED_AMOUNT int(11),
	PREV_RETURNS_BALANCE int(11),
	MERCHANT_STATEMENT_ACTIVITY_FK bigint(20),
	DEPOSIT_CL varchar,
	TAX_AMOUNT bigint(20),
	PREV_TAX_BALANCE bigint(20),
	NEXT_TAX_BALANCE bigint(20),
	DEPOSIT_TYPE varchar,
	RETURN_SALE_RESERVE_TOTAL_AMOUNT bigint(20),
	CHARGEBACK_SALE_RESERVE_TOTAL_AMOUNT bigint(20),
	RETURN_RESERVE_MIN_AMOUNT bigint(20),
	CHARGEBACK_RESERVE_MIN_AMOUNT bigint(20),
	RESELLER_CODE int(11),
	APPROVAL_DATE datetime,
	PROCESSED_AMOUNT bigint(20),
	TAX_AMOUNT_RECEIVABLE bigint(20),
	FEE_AMOUNT_RECEIVABLE bigint(20),
	PROCESSING_COST_AMOUNT bigint(20),
	PROCESSING_COST_AMOUNT_RECEIVABLE bigint(20),
	MERCHANT_CHARGE_AMOUNT bigint(20),
	SPLIT_AMOUNT bigint(20),
	PREV_RETURN_FEE_BALANCE bigint(20),
	NEXT_RETURN_FEE_BALANCE bigint(20),
	PREV_RETURN_TAX_BALANCE bigint(20),
	NEXT_RETURN_TAX_BALANCE bigint(20),
	PREV_RETURN_PROCESSING_COST_BALANCE bigint(20),
	NEXT_RETURN_PROCESSING_COST_BALANCE bigint(20),
	NEXT_NET_BALANCE bigint(20),
	NEXT_PROCESSING_COST_BALANCE bigint(20),
	PREV_PROCESSING_COST_BALANCE bigint(20),
	MERCHANT_STATEMENT_ACTIVITY_FK bigint(20),
	DEPOSIT_CL varchar,
	DEPOSIT_CL varchar,
	DEPOSIT_CL varchar,
	INTERCHANGE_AMOUNT bigint(20),
	ASSESSMENTS_AMOUNT bigint(20),
	FEES_RESPONSIBLE_CL varchar,
	PREV_DIRECT_DEBIT_BALANCE bigint(20),
	PREV_BANK_CARD_BALANCE bigint(20),
	PREV_DIRECT_DEBIT_NET_BALANCE bigint(20),
	PREV_BANK_CARD_NET_BALANCE bigint(20),
	PREV_DIRECT_DEBIT_RETURNS_BALANCE bigint(20),
	PREV_BANK_CARD_RETURNS_BALANCE bigint(20),
	PREV_DIRECT_DEBIT_REATTEMPT_RETURNS_BALANCE bigint(20),
	PREV_BANK_CARD_REATTEMPT_RETURNS_BALANCE bigint(20),
	PREV_DIRECT_DEBIT_FEE_BALANCE bigint(20),
	PREV_BANK_CARD_FEE_BALANCE bigint(20),
	PREV_DIRECT_DEBIT_BALANCE bigint(20),
	PREV_BANK_CARD_BALANCE bigint(20),
	PREV_DIRECT_DEBIT_NET_BALANCE bigint(20),
	PREV_BANK_CARD_NET_BALANCE bigint(20),
	PREV_DIRECT_DEBIT_RETURNS_BALANCE bigint(20),
	PREV_BANK_CARD_RETURNS_BALANCE bigint(20),
	PREV_DIRECT_DEBIT_REATTEMPT_RETURNS_BALANCE bigint(20),
	PREV_BANK_CARD_REATTEMPT_RETURNS_BALANCE bigint(20),
	PREV_DIRECT_DEBIT_FEE_BALANCE bigint(20),
	PREV_BANK_CARD_FEE_BALANCE bigint(20),
	NEXT_BANK_CARD_TAX_BALANCE bigint(20),
	NEXT_BANK_CARD_PROCESSING_COST_BALANCE bigint(20),
	NEXT_BANK_CARD_FEE_BALANCE bigint(20),
	NEXT_DIRECT_DEBIT_TAX_BALANCE bigint(20),
	NEXT_DIRECT_DEBIT_PROCESSING_COST_BALANCE bigint(20),
	NEXT_DIRECT_DEBIT_FEE_BALANCE bigint(20),
	NEXT_BANK_CARD_RETURN_FEE_BALANCE bigint(20),
	PREV_BANK_CARD_RETURN_FEE_BALANCE bigint(20),
	NEXT_BANK_CARD_RETURN_TAX_BALANCE bigint(20),
	PREV_BANK_CARD_RETURN_TAX_BALANCE bigint(20),
	NEXT_DIRECT_DEBIT_RETURN_TAX_BALANCE bigint(20),
	PREV_DIRECT_DEBIT_RETURN_TAX_BALANCE bigint(20),
	BANK_CARD_PROCESSING_COST_AMOUNT bigint(20),
	DIRECT_DEBIT_PROCESSING_COST_AMOUNT bigint(20),
	NEXT_DIRECT_DEBIT_RETURN_FEE_BALANCE bigint(20),
	PREV_DIRECT_DEBIT_RETURN_FEE_BALANCE bigint(20),
	PREV_DIRECT_DEBIT_RETURN_PROCESSING_COST_BALANCE bigint(20),
	PREV_BANK_CARD_RETURN_PROCESSING_COST_BALANCE bigint(20),
	NEXT_DIRECT_DEBIT_RETURN_PROCESSING_COST_BALANCE bigint(20),
	NEXT_BANK_CARD_RETURN_PROCESSING_COST_BALANCE bigint(20),
	FEES_RESPONSIBLE_CL varchar,
	IS_IGNORE_REMITTANCE_SOURCE tinyint(1),
	MERCHANT_STATEMENT_CL varchar,
	RESELLER_COMMISSION_FK bigint(20),
	MASTER_MERCHANT_STATEMENT_FK bigint(20),
	INTERCHANGE_AMOUNT bigint(20),
	ASSESSMENTS_AMOUNT bigint(20),
	PREV_DIRECT_DEBIT_BALANCE bigint(20),
	PREV_BANK_CARD_BALANCE bigint(20),
	PREV_DIRECT_DEBIT_NET_BALANCE bigint(20),
	PREV_BANK_CARD_NET_BALANCE bigint(20),
	PREV_DIRECT_DEBIT_RETURNS_BALANCE bigint(20),
	PREV_BANK_CARD_RETURNS_BALANCE bigint(20),
	PREV_DIRECT_DEBIT_REATTEMPT_RETURNS_BALANCE bigint(20),
	PREV_BANK_CARD_REATTEMPT_RETURNS_BALANCE bigint(20),
	PREV_DIRECT_DEBIT_FEE_BALANCE bigint(20),
	PREV_BANK_CARD_FEE_BALANCE bigint(20),
	FEES_RESPONSIBLE_CL varchar,
	IS_IGNORE_REMITTANCE_SOURCE tinyint(1),
	IS_IGNORE_REMITTANCE_SOURCE tinyint(1),
	FUNDING_MODE_CL varchar,
	FUNDING_MODE_CL varchar,
	FUNDING_MODE_CL varchar,
	PREV_DEPOSIT_STATEMENT_DATE datetime,
	PREV_REMITTANCE_DATE datetime,
	PREV_STATEMENT_DATE datetime,
	PREV_DEPOSIT_STATEMENT_DATE datetime,
	PREV_REMITTANCE_DATE datetime,
	PREV_STATEMENT_DATE datetime,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;