-- Create Table Statement for 'Merchant Statement Extended'
DROP TABLE IF EXISTS `IAPP_MERCHANT_STATEMENT_EXTENDED`;
CREATE TABLE `IAPP_MERCHANT_STATEMENT_EXTENDED` (
	CREATE_DATE datetime,
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	REMITTED_AMOUNT bigint(20),
	START_DATE datetime,
	END_DATE datetime,
	PROVIDER_STATEMENT_ID varchar,
	PROVIDER_MERCHANT_ID varchar,
	PROFILE_NAME varchar,
	CONTENT_FK bigint(20),
	DEPOSIT_CL varchar,
	STATEMENT_CL varchar,
	STATEMENT_CODE bigint(20),
	PAYMENT_CARD_SUBMISSIONS_AMOUNT bigint(20),
	PAYMENT_CARD_DECLINES_AMOUNT bigint(20),
	PAYMENT_CARD_VOIDS_AMOUNT bigint(20),
	PAYMENT_CARD_CHARGEBACKS_AMOUNT bigint(20),
	PAYMENT_CARD_BLACKLISTS_AMOUNT bigint(20),
	PAYMENT_CARD_ERRORS_AMOUNT bigint(20),
	PAYMENT_CARD_REVERSALS_AMOUNT bigint(20),
	PAYMENT_CARD_NET_AMOUNT bigint(20),
	DIRECT_DEBIT_SUBMITTED_AMOUNT bigint(20),
	DIRECT_DEBIT_DECLINES_AMOUNT bigint(20),
	DIRECT_DEBIT_VOIDS_AMOUNT bigint(20),
	DIRECT_DEBIT_RETURNS_AMOUNT bigint(20),
	DIRECT_DEBIT_BLACKLISTS_AMOUNT bigint(20),
	DIRECT_DEBIT_ERRORS_AMOUNT bigint(20),
	DIRECT_DEBIT_NET_AMOUNT bigint(20),
	TOTAL_COLLECTED_AMOUNT bigint(20),
	SURCHARGE_FEE_AMOUNT bigint(20),
	RESERVES_DIRECT_DEBIT_NET_SALES_AMOUNT bigint(20),
	RESERVES_PAYMENT_CARD_NET_SALES_AMOUNT bigint(20),
	RESERVES_RETURNS_RATE decimal(10,2),
	RESERVES_RETURNS_MIN_AMOUNT bigint(20),
	RESERVES_RETURNS_REQUIRED_BALANCE bigint(20),
	RESERVES_RETURNS_PREVIOUS_BALANCE bigint(20),
	RESERVES_RETURNS_COLLECTED_AMOUNT bigint(20),
	RESERVES_RETURNS_CURRENT_BALANCE bigint(20),
	RESERVES_CHARGEBACKS_RATE decimal(10,2),
	RESERVES_CHARGEBACKS_MIN_AMOUNT bigint(20),
	RESERVES_CHARGEBACKS_REQUIRED_BALANCE bigint(20),
	RESERVES_CHARGEBACKS_PREVIOUS_BALANCE bigint(20),
	RESERVES_CHARGEBACKS_COLLECTED_AMOUNT bigint(20),
	RESERVES_CHARGEBACKS_CURRENT_BALANCE bigint(20),
	RESERVES_REFUNDS_MAX_AMOUNT bigint(20),
	RESERVES_REFUNDS_PREVIOUS_BALANCE bigint(20),
	RESERVES_REFUNDS_COLLECTED_AMOUNT bigint(20),
	RESERVES_REFUNDS_CURRENT_BALANCE bigint(20),
	SPLIT_INS_AMOUNT bigint(20),
	SPLIT_OUTS_AMOUNT bigint(20),
	PULL_INS_AMOUNT bigint(20),
	PULL_OUTS_AMOUNT bigint(20),
	TAX_AMOUNT bigint(20),
	CHARGES_AMOUNT bigint(20),
	ADJUSTMENTS_AMOUNT bigint(20),
	PROCESSING_COST_AMOUNT bigint(20),
	DEPOSIT_DATE datetime,
	CAPTURE_CURRENCY_CODE varchar,
	ACCOUNT_TYPE varchar,
	DEPOSIT_TYPE varchar,
	ACCOUNT_TYPE varchar,
	DEPOSIT_TYPE varchar,
	BANK_ACCOUNT_NUMBER_MASKED varchar,
	BANK_ROUTING_NUMBER_MASKED varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;