-- Create Table Statement for 'Reseller'
DROP TABLE IF EXISTS `IAPP_RESELLER`;
CREATE TABLE `IAPP_RESELLER` (
	CODE int(11) NOT NULL,
	NAME varchar,
	CREATE_DATE datetime,
	IS_ACTIVE tinyint(1),
	NOTES varchar,
	STREET1 varchar,
	STREET2 varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	PHONE varchar,
	FAX varchar,
	EMAIL varchar,
	BANK_ACCOUNT_HOLDER_NAME varchar,
	BANK_ROUTING_NUMBER_MASKED varchar,
	BANK_ACCOUNT_NUMBER_MASKED varchar,
	TOKEN_CODE varchar,
	REF_CODE varchar,
	CONTACT_NAME varchar,
	COUNTRY_CODE varchar,
	DEFAULT_USER_FK int(11),
	BUSINESS_INFO_FK bigint(20),
	REMITTANCE_EMAIL_RECIPIENT_LIST varchar,
	PORTFOLIO_FK int(11),
	MERCHANT_FK int(11),
	ACCOUNT_STORE_CODE bigint(20),
	RESELLER_CL varchar,
	FUNDS_DISTRIBUTION_CL varchar,
	RESELLER_ACTIVITY_FK bigint(20),
	IS_FUNDS_DISTRIBUTION_REVIEW_REQUIRED tinyint(1),
	CHANNEL_FK bigint(20),
	TERMINAL_MANAGERS_LIST varchar,
	TERMINAL_SUPPORT_NUMBER varchar,
	IS_MASTER_RESELLER_STATEMENT_REVIEW_REQUIRED tinyint(1),
	MERCHANT_FEE_POLICY varchar,
	MERCHANT_FEE_MIN_AMOUNT int(11),
	MERCHANT_FEE_BASIS_CL varchar,
	ONBOARDING_PROFILE_ID varchar,
	ONBOARDING_PROFILE_ID bigint(20),
	ONBOARDING_PROFILE_ID bigint(20),
	MERCHANT_FEE_BASIS_CL varchar,
	MERCHANT_FEE_BASIS_CL varchar,
	IS_MASTER_RESELLER_STATEMENT_REVIEW_REQUIRED tinyint(1),
	IS_MASTER_RESELLER_STATEMENT_REVIEW_REQUIRED tinyint(1),
	ONBOARDING_PROFILE_ID bigint(20),
	IS_MULTIPLE_RETURNS_FILE_SUPPORTED tinyint(1),
	BATCH_PROCESSING_POLICY_CL varchar,
	IS_MULTIPLE_RETURNS_FILE_SUPPORTED tinyint(1),
	BATCH_PROCESSING_POLICY_CL varchar,
	TAG_LIST varchar,
	TAG_LIST varchar,
	TAG_LIST varchar,
	IS_MULTIPLE_RETURNS_FILE_SUPPORTED tinyint(1),
	BATCH_PROCESSING_POLICY_CL varchar,
	DATA_EXPORT_POLICY varchar,
	DATA_EXPORT_POLICY varchar,
	DATA_EXPORT_POLICY varchar,
	COMMISSIONS_RATE int(11),
	COMMISSIONS_START_DATE datetime,
	COMMISSIONS_END_DATE datetime,
	IS_COMMISSIONS_ACTIVE tinyint(1),
	COMMISSIONS_RATE int(11),
	COMMISSIONS_START_DATE datetime,
	COMMISSIONS_END_DATE datetime,
	IS_COMMISSIONS_ACTIVE tinyint(1),
	COMMISSIONS_RATE int(11),
	COMMISSIONS_START_DATE datetime,
	COMMISSIONS_END_DATE datetime,
	IS_COMMISSIONS_ACTIVE tinyint(1),
	LAST_RESELLER_STATEMENT_EXTENDED_DATE datetime,
	PREV_RESELLER_STATEMENT_EXTENDED_DATE datetime,
	COMMISSIONS_START_DATE datetime,
	COMMISSIONS_END_DATE datetime,
	IS_COMMISSIONS_ACTIVE tinyint(1),
	PLATFORM_FEES_RATE int(11),
	BUY_RATE_HANDLING_MODE_CL varchar,
	IS_REMITTANCE_HOLD_ENABLED tinyint(1),
	BALANCE int(11),
	REMITTER_FK int(11),
	REMITTANCE_HOLD_NOTE varchar,
	REMITTANCE_HOLD_USER_NAME varchar,
	PRIMARY KEY (CODE)
) ENGINE=InnoDB;