-- Create Table Statement for 'Vantiv Tandem Processing Cost'
DROP TABLE IF EXISTS `VANTIV_TANDEM_PROCESSING_COST`;
CREATE TABLE `VANTIV_TANDEM_PROCESSING_COST` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TRANSACTION_DATE varchar,
	TRANSACTION_TIME varchar,
	TRANSACTION_TYPE_CODE varchar,
	CARD_ACCOUNT_NUMBER varchar,
	EXPIRATION_DATE varchar,
	AUTHORIZED_AMOUNT varchar,
	OLD_AUTHORIZED_AMOUNT varchar,
	AUTHORIZATION_REQUEST_RESPONSE_CODE varchar,
	AUTHORIZATION_CODE varchar,
	POS_ENTRY_MODE varchar,
	MCC_CODE varchar,
	CARD_TYPE varchar,
	CALL_TYPE varchar,
	AUTHORIZATION_SOURCE varchar,
	POS_CONDITION_CODE varchar,
	CAT_INDICATOR varchar,
	AVS_RESPONSE_CODE varchar,
	CVV2_PRESENCE_CODE_INDICATOR varchar,
	CVV2_RESPONSE_CODE_INDICATOR varchar,
	MAIL_PHONE_INDICATOR varchar,
	SALES_PERSON varchar,
	CURRENCY_CODE varchar,
	COUNTRY_CODE varchar,
	ACI varchar,
	VISA_TRANSACTION_ID varchar,
	VISA_VALIDATION_CODE varchar,
	VISA_AUTHORIZATION_RESPONSE_CODE varchar,
	MASTER_CARD_BANKNET_REFERENCE_NUMBER varchar,
	MASTER_CARD_BANKNET_SETTLEMENT_DATE varchar,
	BUSINESS_DATE varchar,
	RETRIEVAL_REFERENCE_NUMBER varchar,
	CAVV_RESPONSE varchar,
	VOID_INDICATOR varchar,
	ORIGIN_TYPE varchar,
	VISA_CARD_LEVEL_RESULTS varchar,
	RTC_SETTLEMENT_TYPE varchar,
	TOKEN varchar,
	TOKEN_ID varchar,
	EMV_TRANSACTION_FLAG varchar,
	CARD_EMV_CAPABILITY_FLAG varchar,
	TERMINAL_EMV_CAPABILITY_FLAG varchar,
	EMV_OFFLINE_TRANSACTION_FLAG varchar,
	CARD_PRODUCT_TYPE varchar,
	MERCHANT_REFERENCE_NUMBER varchar,
	BATCH_NUMBER varchar,
	CONVENIENCE_FEE_AMOUNT varchar,
	NETWORK_REFERENCE_NUMBER varchar,
	TERMINAL_NUMBER varchar,
	ORIGINAL_INTERCHANGE_INDICATOR varchar,
	INTERCHANGE_CODE varchar,
	INTERCHANGE_AMOUNT varchar,
	INTERCHANGE_AMOUNT_SIGN varchar,
	INTERCHANGE_ADJUSTMENT_REASON_CODE varchar,
	INTERCHANGE_ADJUSTMENT_AMOUNT varchar,
	INTERCHANGE_ADJUSTMENT_SIGN varchar,
	DCC_MCP_INDICATOR varchar,
	CARDHOLDER_BILLING_AMOUNT varchar,
	CONVERSION_RATE varchar,
	CARDHOLDER_BILLING_CURRENCY_CODE varchar,
	ORIGINAL_TRANSACTION_REFERENCE_NUMBER varchar,
	ADJUSTMENT_REVERSAL_DATE varchar,
	ADJUSTMENT_REVERSAL_TIME varchar,
	ADJUSTMENT_TYPE varchar,
	ADJUSTMENT_REVERSAL_AMOUNT varchar,
	ADJUSTMENT_REVERSAL_AMOUNT_SIGN varchar,
	ERROR_CODE varchar,
	NETWORK varchar,
	TRANSACTION_DISPOSITION varchar,
	DENIAL_CODE varchar,
	TERMINAL_LOCATION varchar,
	CARDHOLDER_ACRO varchar,
	CARDHOLDER_I_D_METHOD varchar,
	FROM_ACCOUNT_TYPE varchar,
	TERMINAL_ID varchar,
	REGISTER_NUMBER varchar,
	ORIGINATOR varchar,
	RECEIVER varchar,
	ORIGINAL_TRANSACTION_DATE varchar,
	ORIGINAL_TRANSACTION_TIME varchar,
	CARD_PRIMARY_ACCOUNT_NUMBER varchar,
	ORIGINAL_AMOUNT varchar,
	ORIGINAL_AMOUNT_SIGN varchar,
	ADJUSTMENT_TRANSACTION_DISPOSITION varchar,
	ADJUSTMENT_NUMBER varchar,
	ADJUSTMENT_DATE_FORMAT varchar,
	ADJUSTMENT_TIME_FORMAT varchar,
	ADJUSTMENT_ACTION varchar,
	ADJUSTMENT_AMOUNT varchar,
	ADJUSTMENT_AMOUNT_SIGN varchar,
	ADJUSTMENT_PROCESS varchar,
	ADJUSTMENT_REASON_CODE varchar,
	TERMINAL_SEQUENCE_NUMBER varchar,
	ADDRESS varchar,
	ORIGINATOR_COMMENTS varchar,
	RECEIVER_COMMENTS varchar,
	MAGNETIC_STRIPE varchar,
	REMAINING_BALANCE varchar,
	TRANSACTION_ORIGIN_FLAG varchar,
	CARDHOLDER_CURRENCY_CODE varchar,
	CARDHOLDER_TRANSACTION_AMOUNT varchar,
	CARDHOLDER_CONVERSION_RATE varchar,
	PROGRAM_AGENT varchar,
	SKU_NUMBER varchar,
	PROGRAM_IDENTIFIER varchar,
	REMAINING_BALANCE_AMOUNT varchar,
	FRANCHISE_CARD_TRANSACTION_FLAG varchar,
	FRANCHISE_PROGRAM_TYPE varchar,
	ON_US_TRANSACTION_FLAG varchar,
	ON_US_TRANSACTION varchar,
	CARD_OWNER_MID varchar,
	CARD_OWNER_CHAIN_CODE varchar,
	CHECK_ABA_NUMBER varchar,
	CHECKING_ACCOUNT_NUMBER varchar,
	CHECK_SERIAL_NUMBER varchar,
	CARDHOLDER_ID varchar,
	CHECK_WRITER_ID_METHOD varchar,
	ID_NUMBER varchar,
	ID_STATE_CODE varchar,
	CHECK_WRITER_DATE_OF_BIRTH varchar,
	CHECK_WRITER_PHONE_NUMBER varchar,
	CHECK_TYPE varchar,
	DRAFT_LOCATOR varchar,
	EMV_TRANSACTION_INDICATOR varchar,
	MERCHANT_DISCRETIONARY1 varchar,
	MERCHANT_DISCRETIONARY2 varchar,
	MERCHANT_DISCRETIONARY3 varchar,
	PINLESS_IND varchar,
	REQUESTED_AUTHORIZATION_AMOUNT varchar,
	REQUESTED_SETTLED_AMOUNT varchar,
	SURCHARGE_AMOUNT varchar,
	TRANSACTION_AMOUNT varchar,
	TRANSACTION_SEQUENCE_NUMBER varchar,
	CASH_BACK_AMOUNT varchar,
	TRANSACTION_DATE_DATE datetime,
	COST_MATCHING_STATUS_CL varchar,
	TRANSACTION_IDENTITY varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	TRANSACTION_IDENTITY varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	TRANSACTION_IDENTITY varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	VANTIV_TANDEM_PROCESSING_COST_BATCH_FK bigint(20),
	VANTIV_TANDEM_PROCESSING_COST_BATCH_FK bigint(20),
	VANTIV_TANDEM_PROCESSING_COST_BATCH_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;