-- Create Table Statement for 'Transaction List Export'
DROP TABLE IF EXISTS `TRANSACTION_LIST_EXPORT`;
CREATE TABLE `TRANSACTION_LIST_EXPORT` (
	ID bigint(20) NOT NULL,
	ACCOUNT_ID int(11),
	ACCOUNT_NAME varchar,
	ACCOUNT_CODE varchar,
	RESELLER_ID int(11),
	RESELLER_NAME varchar,
	RESELLER_CODE varchar,
	STATEMENT_ID bigint(20),
	SUBMISSION_TYPE varchar,
	SUBMISSION_ID bigint(20),
	DEPOSIT_TYPE varchar,
	ACTIVITY_DATE datetime,
	CAPTURE_DATE datetime,
	CAPTURE_AMOUNT bigint(20),
	CAPTURE_CURRENCY_CODE varchar,
	INDUSTRY_TYPE varchar,
	TYPE varchar,
	CATEGORY_TYPE varchar,
	STATUS varchar,
	MEMO varchar,
	ORIGINAL_AMOUNT bigint(20),
	REMAINING_AMOUNT bigint(20),
	ORIGINAL_TRANSACTION_REMAINING_AMOUNT bigint(20),
	AMOUNT bigint(20),
	ORIGINAL_TRANSACTION_ID bigint(20),
	ORIGINAL_TRANSACTION_CODE varchar,
	ACCOUNT_TYPE varchar,
	TOKEN varchar,
	ACCOUNT_NUMBER varchar,
	ACCOUNT_ACCESSORY varchar,
	HOLDER_NAME varchar,
	TERMINAL_ID bigint(20),
	TERMINAL_CODE varchar,
	BILLING_ADDRESS_STREET varchar,
	BILLING_ADDRESS_CITY varchar,
	BILLING_ADDRESS_STATE varchar,
	BILLING_ADDRESS_ZIP_CODE varchar,
	BILLING_ADDRESS_COUNTRY_CODE varchar,
	BILLING_ADDRESS_PHONE varchar,
	BILLING_ADDRESS_EMAIL varchar,
	TRANSACTION_ID bigint(20),
	TRANSACTION_CODE varchar,
	INTERNAL_CODE varchar,
	ITEM_CODE varchar,
	USER_CODE varchar,
	CUSTOMER_ACCOUNT_CODE varchar,
	CUSTOMER_ACCOUNT_INTERNAL_CODE varchar,
	TICKET_NUMBER varchar,
	CASE_NUMBER varchar,
	APPROVAL_CODE varchar,
	RESPONSE_CODE varchar,
	RESPONSE_MESSAGE varchar,
	AVS_RESPONSE_CODE varchar,
	CSC_RESPONSE_CODE varchar,
	PROCESSOR_TRANSACTION_ID varchar,
	PROCESSOR_RESPONSE_CODE varchar,
	PROCESSOR_RESPONSE_MESSAGE varchar,
	PROCESSOR_AVS_RESPONSE_CODE varchar,
	PROCESSOR_CSC_RESPONSE_CODE varchar,
	INTERCHANGE_NAME varchar,
	INTERCHANGE_PERCENTAGE_RATE decimal(10,2),
	INTERCHANGE_PERCENTAGE_AMOUNT int(11),
	INTERCHANGE_ITEM_AMOUNT int(11),
	INTERCHANGE_TOTAL_AMOUNT int(11),
	SURCHARGE_PERCENTAGE_RATE decimal(10,2),
	SURCHARGE_PERCENTAGE_AMOUNT int(11),
	SURCHARGE_ITEM_RATE int(11),
	SURCHARGE_ITEM_AMOUNT int(11),
	SURCHARGE_TOTAL_AMOUNT int(11),
	SURCHARGE_FLAT_AMOUNT int(11),
	DATA_REGISTRY_EXPORT_CODE bigint(20),
	CLIENT_HOST varchar,
	REQUEST_HOST varchar,
	PRIMARY KEY (ID)
) ENGINE=InnoDB;