-- Create Table Statement for 'Provisioning Transaction Response Detail'
DROP TABLE IF EXISTS `PROVISIONING_TRANSACTION_RESPONSE_DETAIL`;
CREATE TABLE `PROVISIONING_TRANSACTION_RESPONSE_DETAIL` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	FIELD_NAME varchar,
	PORTFOLIO_CODE int(11),
	RESPONSE_MESSAGE varchar,
	OBJECT_NAME varchar,
	PROVISIONING_TRANSACTION_RESPONSE_STATUS_CL varchar,
	PROVIDER_RESPONSE_MESSAGE varchar,
	PROVIDER_RESPONSE_CODE varchar,
	RESPONSE_MESSAGE varchar,
	PROVIDER_RESPONSE_MESSAGE varchar,
	RESPONSE_MESSAGE varchar,
	PROVIDER_RESPONSE_MESSAGE varchar,
	RAW_ERROR_DATA longtext,
	RESPONSE_DATA longtext,
	RAW_RESPONSE_DATA_TYPE varchar,
	RAW_WARNING_DATA longtext,
	RAW_SUPPLEMENT_DATA longtext,
	PROVIDER_OPERATION_NAME varchar,
	REQUEST_DATE datetime,
	RESPONSE_DATE datetime,
	RAW_ERROR_DATA longtext,
	RESPONSE_DATA longtext,
	RAW_RESPONSE_DATA_TYPE varchar,
	RAW_WARNING_DATA longtext,
	RAW_SUPPLEMENT_DATA longtext,
	PROVIDER_OPERATION_NAME varchar,
	REQUEST_DATE datetime,
	RESPONSE_DATE datetime,
	PROVIDER_RESPONSE_CODE varchar,
	PROVIDER_RESPONSE_CODE varchar,
	RAW_ERROR_DATA longtext,
	RESPONSE_DATA longtext,
	RAW_RESPONSE_DATA_TYPE varchar,
	RAW_WARNING_DATA longtext,
	RAW_SUPPLEMENT_DATA longtext,
	PROVIDER_OPERATION_NAME varchar,
	REQUEST_DATE datetime,
	RESPONSE_DATE datetime,
	PROVISIONING_TRANSACTION_FK bigint(20),
	PROVISIONING_TRANSACTION_FK bigint(20),
	PROVISIONING_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;