-- Create Table Statement for 'Processing Limit'
DROP TABLE IF EXISTS `IAPP_PROCESSING_LIMIT`;
CREATE TABLE `IAPP_PROCESSING_LIMIT` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11),
	MERCHANT_ACCOUNT_PROFILE_CODE bigint(20),
	PERIOD_CL varchar,
	MAX_TRANSACTION_AMOUNT int(11),
	MAX_TRANSACTION_VOLUME int(11),
	MAX_TRANSACTION_COUNT int(11),
	MAX_AVG_DEVIATION_PROCESSING_FREQUENCY int(11),
	MAX_AVG_DEVIATION_TRANSACTION_AMOUNT int(11),
	MAX_AVG_DEVIATION_TRANSACTION_VOLUME int(11),
	MAX_AVG_DEVIATION_TRANSACTION_COUNT int(11),
	MAX_EVEN_AMOUNT_TRANSACTION_COUNT int(11),
	MAX_LOW_TICKET_TRANSACTION_COUNT int(11),
	MAX_DUPLICATE_AMOUNT_TRANSACTION_COUNT int(11),
	MAX_DUPLICATE_CARD_TRANSACTION_COUNT int(11),
	MAX_DUPLICATE_TRANSACTION_COUNT int(11),
	MAX_CREDITS_COUNT int(11),
	MAX_REFUNDS_COUNT int(11),
	MAX_ACCOUNT_VERIFICATIONS_COUNT int(11),
	MAX_DECLINES_RATE int(11),
	MAX_RETURNS_RATE int(11),
	MAX_CHARGEBACKS_RATE int(11),
	MAX_SWIPED_TRANSACTIONS_RATE int(11),
	MAX_KEYED_TRANSACTIONS_RATE int(11),
	MAX_NON_PRESENT_TRANSACTIONS_RATE int(11),
	MAX_OFF_HOURS_TRANSACTION_COUNT int(11),
	MAX_INACTIVE_DAYS_COUNT int(11),
	IS_ACTIVE tinyint(1),
	IS_ACTIVE tinyint(1),
	IS_ACTIVE tinyint(1),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;