-- Create Table Statement for 'Business Estimates'
DROP TABLE IF EXISTS `IAPP_BUSINESS_ESTIMATES`;
CREATE TABLE `IAPP_BUSINESS_ESTIMATES` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11),
	ESTIMATION_PERIOD_CL varchar,
	ESTIMATED_AVG_TRANSACTION_AMOUNT int(11),
	ESTIMATED_MAX_TRANSACTION_AMOUNT int(11),
	ESTIMATED_TRANSACTION_VOLUME int(11),
	CARD_TYPE_DIRECT_DEBIT int(11),
	ENTRY_MODE_OTHER int(11),
	ENTRY_MODE_RETAIL int(11),
	ENTRY_MODE_ECOMMERCE int(11),
	ENTRY_MODE_MAIL int(11),
	ENTRY_MODE_PHONE int(11),
	ENTRY_MODE_TRADESHOW int(11),
	CARD_TYPE_MASTERCARD int(11),
	CARD_TYPE_VISA int(11),
	CARD_TYPE_AMEX int(11),
	CARD_TYPE_DISCOVER int(11),
	CARD_TYPE_OTHER int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;