-- Create Table Statement for 'Reseller Statement Extended'
DROP TABLE IF EXISTS `RESELLER_STATEMENT_EXTENDED`;
CREATE TABLE `RESELLER_STATEMENT_EXTENDED` (
	ID bigint(20) NOT NULL,
	RESELLER_CODE int(11),
	CREATE_DATE datetime,
	START_DATE datetime,
	END_DATE datetime,
	DEPOSIT_DATE datetime,
	STATUS_CL varchar,
	AMOUNT int(11),
	ADJUSTED_AMOUNT int(11),
	REMITTED_AMOUNT int(11),
	CREATOR_CODE varchar,
	APPROVER_CODE varchar,
	REMITTER_CODE varchar,
	TRANSACTION_CODE varchar,
	PREV_RESELLER_STATEMENT_DATE datetime,
	PREV_BALANCE int(11),
	NEXT_BALANCE int(11),
	RESIDUALS_AMOUNT int(11),
	PLATFORM_FEES_AMOUNT int(11),
	CHARGES_AMOUNT int(11),
	FEES_AMOUNT int(11),
	ADJUSTMENTS_AMOUNT int(11),
	TOTAL_MERCHANTS_COUNT int(11),
	ACTIVE_MERCHANTS_COUNT int(11),
	RESELLER_STATEMENT_EXTENDED_DETAILS bigint(20),
	BANK_ACCOUNT_NUMBER_MASKED varchar,
	BANK_ROUTING_NUMBER_MASKED varchar,
	HOLD_AMOUNT int(11),
	EMAIL_SENT_DATE datetime,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;