-- Create Table Statement for 'Processing Deviation'
DROP TABLE IF EXISTS `IAPP_PROCESSING_DEVIATION`;
CREATE TABLE `IAPP_PROCESSING_DEVIATION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11),
	PORTFOLIO_CODE int(11),
	RESELLER_CODE int(11),
	MERCHANT_ACCOUNT_PROFILE_CODE bigint(20),
	PERIOD_CL varchar,
	ACTIVITY_DATE datetime,
	STATUS_CL varchar,
	TRANSACTION_VOLUME int(11),
	TRANSACTION_COUNT int(11),
	AVG_TRANSACTION_AMOUNT int(11),
	AVG_TRANSACTION_VOLUME int(11),
	AVG_TRANSACTION_COUNT int(11),
	AVG_PROCESSING_FREQUENCY int(11),
	EVEN_AMOUNT_TRANSACTION_COUNT int(11),
	LOW_TICKET_TRANSACTION_COUNT int(11),
	DUPLICATE_AMOUNT_TRANSACTION_COUNT int(11),
	DUPLICATE_CARD_TRANSACTION_COUNT int(11),
	DUPLICATE_TRANSACTION_COUNT int(11),
	CREDITS_COUNT int(11),
	REFUNDS_COUNT int(11),
	ACCOUNT_VERIFICATIONS_COUNT int(11),
	DECLINES_RATE int(11),
	RETURNS_RATE int(11),
	CHARGEBACKS_RATE int(11),
	SWIPED_TRANSACTIONS_RATE int(11),
	KEYED_TRANSACTIONS_RATE int(11),
	NON_PRESENT_TRANSACTIONS_RATE int(11),
	PROCESSING_STATISTICS_FK bigint(20),
	OFF_HOURS_TRANSACTION_COUNT int(11),
	INACTIVE_DAYS_COUNT int(11),
	CREATE_DATE datetime,
	TRANSACTION_AMOUNT int(11),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;