-- Create Table Statement for 'Statement List Export'
DROP TABLE IF EXISTS `STATEMENT_LIST_EXPORT`;
CREATE TABLE `STATEMENT_LIST_EXPORT` (
	CREATE_DATE datetime,
	ID bigint(20) NOT NULL,
	PROVIDER_MERCHANT_ID varchar,
	PROFILE_NAME varchar,
	ACCOUNT_ID int(11),
	STATEMENT_ID bigint(20),
	STATEMENT_TYPE varchar,
	DEPOSIT_TYPE varchar,
	END_DATE datetime,
	START_DATE datetime,
	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),
	REMITTED_AMOUNT bigint(20),
	DATA_REGISTRY_EXPORT_CODE bigint(20),
	PROCESSING_COST_AMOUNT bigint(20),
	DEPOSIT_DATE datetime,
	CAPTURE_CURRENCY_CODE varchar,
	BANK_ACCOUNT_NUMBER_MASKED varchar,
	BANK_ROUTING_NUMBER_MASKED varchar,
	SOURCE_TYPE varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;