-- Create Table Statement for 'Vantiv Tandem Processing Cost Batch'
DROP TABLE IF EXISTS `VANTIV_TANDEM_PROCESSING_COST_BATCH`;
CREATE TABLE `VANTIV_TANDEM_PROCESSING_COST_BATCH` (
	ID bigint(20) NOT NULL,
	FILE_CREATION_DATE varchar,
	FILE_CREATION_TIME varchar,
	PROCESSING_DATE varchar,
	CHAIN_CODE varchar,
	MERCHANT_ACRONYM varchar,
	BATCH_SETTLEMENT_TYPE varchar,
	FRONT_END_MERCHANT_ACCOUNT_NUMBER varchar,
	MERCHANT_DIVISION_NUMBER varchar,
	MERCHANT_STORE_NUMBER varchar,
	MERCHANT_NAME varchar,
	MERCHANT_LOCATION_COUNTRY_CODE varchar,
	BATCH_NUMBER_FILE_IDENTIFIER varchar,
	MERCHANT_CITY varchar,
	MERCHANT_STATE varchar,
	MERCHANT_ZIP_CODE varchar,
	TIME_ZONE varchar,
	PAYMENT_TYPE_INDICATOR varchar,
	NUMBER_OF_MONETARY_AUTHORIZATIONS varchar,
	DOLLAR_AMT_OF_MONETARY_AUTHORIZATIONS varchar,
	NUMBER_OF_COMPLETED_MONETARY_RETURNS varchar,
	DOLLAR_AMT_OF_COMPLETED_MONETARY_RETURNS varchar,
	NUMBER_OF_COMPLETED_CASH_BACK_TRANSACTIONS varchar,
	AMOUNT_OF_CASH_BACK_IN_COMPLETED_TRANSACTIONS varchar,
	NET_AMOUNT_OF_BATCH varchar,
	NET_AMOUNT_SIGN varchar,
	LOGICAL_COUNT_OF_ALL varchar,
	LOGICAL_RECORD_COUNT_IN_SUMMARY_SECTION varchar,
	RECONCILIATION_RECORD_LEVEL varchar,
	SUBMISSION_DATE_FIELD_OR_SUMMARY_TOTALS_INDICATOR varchar,
	TOTALS_RECORD_INDICATOR varchar,
	FILE_SUBMISSION_TIME varchar,
	FILE_DATE varchar,
	FILE_TYPE_OR_SUMMARY_INDICATOR_FIELD varchar,
	DIVISION_CODE varchar,
	STORE_NUMBER varchar,
	MERCHANT_ACCOUNT_NUMBER varchar,
	NET_SUBMITTED_SALES_AMOUNT varchar,
	NET_SUBMITTED_SALES_AMOUNT_SIGN varchar,
	REJECTED_AMOUNT varchar,
	REJECTED_AMOUNT_SIGN varchar,
	NET_SETTLED_SALES_AMOUNT varchar,
	NET_SETTLED_SALES_AMOUNT_SIGN varchar,
	NET_NON_SETTLED_SALES_AMOUNT varchar,
	NET_NON_SETTLED_SALES_AMOUNT_SIGN varchar,
	INTERCHANGE_FEES_AMOUNT varchar,
	INTERCHANGE_FEE_AMOUNT_SIGN varchar,
	CHARGEBACK_AMOUNT varchar,
	CHARGEBACK_AMOUNT_SIGN varchar,
	OTHER_ADJUSTMENTS_AMOUNT varchar,
	OTHER_ADJUSTMENT_AMOUNT_SIGN varchar,
	NET_DEPOSIT_AMOUNT varchar,
	NET_DEPOSIT_AMOUNT_SIGN varchar,
	CONVENIENCE_FEE_AMOUNT varchar,
	CONVENIENCE_FEE_AMOUNT_SIGN varchar,
	DEPOSIT_HOLD_AMOUNT varchar,
	DEPOSIT_HOLD_AMOUNT_SIGN varchar,
	DEPOSIT_RELEASE_AMOUNT varchar,
	DEPOSIT_RELEASE_AMOUNT_SIGN varchar,
	NET_DEPOSIT_HOLD_AMOUNT varchar,
	NET_DEPOSIT_HOLD_RELEASE_AMOUNT_SIGN varchar,
	NET_DEPOSIT_AMOUNT_AFTER_DEPOSIT_HOLDS varchar,
	NET_DEPOSIT_AMOUNT_AFTER_DEPOSIT_HOLDS_RELEASES_SIGN varchar,
	NET_SALES_AMOUNT varchar,
	NET_SALES_AMOUNT_SIGN varchar,
	SETTLEMENT_SUPPORT_INDICATOR varchar,
	NETWORK_FEES1 varchar,
	NETWORK_FEES_SIGN varchar,
	TAX_EXEMPT_AMOUNT varchar,
	NETWORK_DISCOUNT_REBATE_AMOUNT varchar,
	CHARGEBACK_ADJUSTMENT_AMOUNT varchar,
	CHARGEBACK_ADJUSTMENT_SIGN varchar,
	CURRENCY_CONVERSION varchar,
	RETURN_AMOUNT varchar,
	RETURN_AMOUNT_SIGN varchar,
	NET_OTHER_ADJUSTMENTS_TO_DEPOSIT varchar,
	NET_OTHER_ADJUSTMENTS_AMOUNT_SIGN varchar,
	NET_DEPOSIT_AMOUNT_AFTER_INTERCHANGE varchar,
	NET_DEPOSIT_AMOUNT_AFTER_INTERCHANGE_SIGN varchar,
	SALES_COUNT varchar,
	SALES_AMOUNT varchar,
	RETURN_COUNT varchar,
	CASH_BACK_AMOUNT varchar,
	PURCHASE_SALES_AMOUNT varchar,
	PURCHASE_SALES_AMOUNT_SIGN varchar,
	NETWORK_FEES2 varchar,
	ADJUSTMENT_AMOUNT varchar,
	ADJUSTMENT_AMOUNT_SIGN varchar,
	MERCHANT_NUMBER varchar,
	NET_FEES varchar,
	VANTIV_TANDEM_PROCESSING_COSTS_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;