-- Create Table Statement for 'Provider Transaction'
DROP TABLE IF EXISTS `PROVIDER_TRANSACTION`;
CREATE TABLE `PROVIDER_TRANSACTION` (
	MERCHANT_ACCOUNT_CODE int(11),
	CREATE_DATE datetime,
	REMITTANCE_DATE datetime,
	PROVIDER_NAME varchar,
	AMOUNT int(11),
	NOTE varchar,
	TRANSACTION_CODE bigint(20),
	PROVIDER_AUTHORIZATION_TRANSACTION_CODE varchar,
	PROVIDER_SETTLEMENT_TRANSACTION_CODE varchar,
	CHARGEBACK_CASE_CODE varchar,
	MERCHANT_ID varchar,
	MERCHANT_NAME varchar,
	AUTHORIZATION_DATE varchar,
	SETTLEMENT_DATE varchar,
	AUTHORIZATION_AMOUNT int(11),
	SETTLEMENT_AMOUNT int(11),
	CHARGEBACK_AMOUNT int(11),
	AUTHORIZATION_CURRENCY_CODE varchar,
	SETTLEMENT_CURRENCY_CODE varchar,
	CHARGEBACK_CURRENCY_CODE varchar,
	PAYMENT_OPTION_TYPE varchar,
	BIN varchar,
	ACCOUNT_NUMBER_LAST4 varchar,
	RESPONSE_CODE varchar,
	RESPONSE_MESSAGE varchar,
	CUSTOMER_ACCOUNT_CODE varchar,
	CUSTOMER_ACCOUNT_NAME varchar,
	INTERCHANGE_RATE_NAME varchar,
	INTERCHANGE_FEE_AMOUNT4P bigint(20),
	INTERCHANGE_PERCENT_RATE4P int(11),
	INTERCHANGE_FLAT_AMOUNT4P bigint(20),
	ISSUING_BANK varchar,
	ISSUING_BANK_COUNTRY_CODE varchar,
	BILLING_DESCRIPTOR varchar,
	STREET varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	AVS_RESPONSE_CODE varchar,
	AVS_RESPONSE_MESSAGE varchar,
	ID bigint(20) NOT NULL,
	TRANSACTION_CL varchar,
	ACCOUNT_TYPE_CL varchar,
	PORTFOLIO_CODE int(11),
	RESELLER_CODE int(11),
	APPROVAL_CODE varchar,
	RESPONSE_CODE varchar,
	RESPONSE_CODE varchar,
	FILE_BATCH_FK bigint(20),
	FILE_BATCH_FK bigint(20),
	FILE_BATCH_FK bigint(20),
	INTERCHANGE_FEE_AMOUNT4P bigint(20),
	INTERCHANGE_FLAT_AMOUNT4P bigint(20),
	INTERCHANGE_FEE_AMOUNT4P bigint(20),
	INTERCHANGE_FLAT_AMOUNT4P bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;