-- Create Table Statement for 'Processing Profile'
DROP TABLE IF EXISTS `PROCESSING_PROFILE`;
CREATE TABLE `PROCESSING_PROFILE` (
ID bigint(20) NOT NULL,
NAME varchar,
IS_ACTIVE tinyint(1),
PROVIDER_CODE bigint(20),
MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
DEPOSIT_CL varchar,
PROVIDER_ACCOUNT_FK bigint(20),
IS_AGGREGATION_ENABLED tinyint(1),
IS_CREDIT_ENABLED tinyint(1),
IS_TWO_PHASE_PROCESSING_ENABLED tinyint(1),
AUTHORIZATION_CURRENCY_CODE_CL varchar,
CAPTURE_CURRENCY_CODE_CL varchar,
TYPE varchar,
SECONDARY_PROVIDER_ACCOUNT_FK bigint(20),
AGGREGATION_CYCLE_FK bigint(20),
PORTFOLIO_CODE int(11),
PROFILE_CL varchar,
ACCOUNT_PROCESSING_POLICY varchar,
IDENTITY varchar,
IDENTITY varchar,
IDENTITY varchar,
IS_UNMATCHED_PROCESSING_MODE tinyint(1),
CREDIT_PROCESSING_MODE_CL varchar,
IS_UNMATCHED_PROCESSING_MODE tinyint(1),
IS_UNMATCHED_PROCESSING_MODE tinyint(1),
TRANSACTION_SPLIT_POLICY varchar,
TRANSACTION_SUB_BATCH_LIMIT int(11),
TRANSACTION_SPLIT_POLICY varchar,
TRANSACTION_SUB_BATCH_LIMIT int(11),
NAME varchar,
TRANSACTION_SPLIT_POLICY varchar,
TRANSACTION_SUB_BATCH_LIMIT int(11),
TRANSACTION_SPLIT_POLICY varchar,
TRANSACTION_SUB_BATCH_LIMIT int(11),
ACCOUNT_PROCESSING_POLICY varchar,
ACCOUNT_PROCESSING_POLICY varchar,
ACCOUNT_PROCESSING_POLICY varchar,
ACCOUNT_PROCESSING_POLICY varchar,
CREDIT_PROCESSING_MODE_CL varchar,
CREDIT_PROCESSING_MODE_CL varchar,
CREDIT_PROCESSING_MODE_CL varchar,
CREDIT_PROCESSING_MODE_CL varchar,
ACCOUNT_PROCESSING_POLICY varchar,
ACCOUNT_PROCESSING_POLICY varchar,
IS_AGGREGATABLE tinyint(1),
IS_AGGREGATABLE tinyint(1),
IS_AGGREGATABLE tinyint(1),
PRIMARY KEY (ID)
) ENGINE=InnoDB;