-- Create Table Statement for 'Tsys Processing Cost'
DROP TABLE IF EXISTS `TSYS_PROCESSING_COST`;
CREATE TABLE `TSYS_PROCESSING_COST` (
	ID bigint(20) NOT NULL,
	CHARGE_TRANSACTION_FK bigint(20),
	TRANSACTION_IDENTITY varchar,
	TSYS_PROCESSING_COST_BATCH_FK bigint(20),
	SEQUENCE_NUMBER_AREA varchar,
	ENTRY_RUN_NUMBER varchar,
	SEQUENCE_NUMBER_WITHIN_ENTRY_RUN varchar,
	MERCHANT_ACCOUNT_NUMBER varchar,
	TRANSACTION_CODE varchar,
	ASSOCIATION_NUMBER varchar,
	REFERENCE_NUMBER varchar,
	TRANSACTION_DATE varchar,
	TRANSACTION_AMOUNT varchar,
	BATCH_JULIAN_DATE varchar,
	NET_DEPOSIT varchar,
	CARDHOLDER_ACCOUNT_NUMBER_MASKED varchar,
	BEST_INTERCHANGE_ELIGIBLE varchar,
	TRANSACTION_DATA_CONDITION_CODE varchar,
	DOWNGRADE_REASON1 varchar,
	DOWNGRADE_REASON2 varchar,
	DOWNGRADE_REASON3 varchar,
	ONLINE_ENTRY varchar,
	ACH_FLAG varchar,
	AUTH_SOURCE varchar,
	CARDHOLDER_ID_METHOD varchar,
	CAT_INDICATOR varchar,
	REIMBURSEMENT_ATTRIBUTE varchar,
	MAIL_ORDER_TELEPHONE_ORDER_INDICATOR varchar,
	ACI varchar,
	BANKNET_REFERENCE_NUMBER varchar,
	BANKNET_AUTH_DATE varchar,
	TRANSACTION_IDENTIFIER varchar,
	DRAFT_A_FLAG varchar,
	AUTH_CURRENCY_CODE varchar,
	AUTH_AMOUNT varchar,
	VALIDATION_CODE varchar,
	AUTH_RESPONSE_CODE varchar,
	NETWORK_IDENTIFIER_DEBIT varchar,
	SWITCH_SETTLED_INDICATOR varchar,
	POS_ENTRY_MODE varchar,
	DEBIT_CREDIT_INDICATOR varchar,
	REVERSAL_FLAG varchar,
	MERCHANT_NAME varchar,
	AUTHORIZATION_NUMBER varchar,
	REJECT_REASON varchar,
	CARD_TYPE varchar,
	CURRENCY_CODE varchar,
	ORIGINAL_TRANSACTION_AMOUNT varchar,
	FOREIGN_CARD_INDICATOR varchar,
	CARRYOVER_INDICATOR varchar,
	EXTENSION_RECORD_INDICATOR varchar,
	MCC_CODE varchar,
	TERMINAL_ID varchar,
	DISCOVER_POS_ENTRY_MODE varchar,
	PURCHASE_ID varchar,
	CASH_BACK_AMOUNT varchar,
	CASH_BACK_AMOUNT_SIGN varchar,
	POS_DATA_CODE varchar,
	PROGRAM_REGISTRATION_ID varchar,
	CARD_TYPE2 varchar,
	PRODUCT_ID varchar,
	SUBMITTED_INTERCHANGE varchar,
	SYSTEM_TRACE_AUDIT_NUMBER varchar,
	DISCOVER_TRANSACTION_TYPE varchar,
	LOCAL_TRANSACTION_TIME varchar,
	DISCOVER_PROCESSING_CODE varchar,
	COMMERCIAL_CARD_SERVICE_INDICATOR varchar,
	FEE_AMOUNT varchar,
	FEE_TYPE varchar,
	DCC_INDICATOR varchar,
	REGULATED_INDICATOR varchar,
	VISA_INTEGRITY_FEE varchar,
	IASF_FEE_TYPE varchar,
	IASF_FEE_AMOUNT varchar,
	DEBIT_OR_CREDIT_INDICATOR varchar,
	ADJUSTMENT_AMOUNT varchar,
	DEBIT_CREDIT_INDICATOR2 varchar,
	CASHBACK_FEE_AMOUNT varchar,
	CASHBACK_FEE_SIGN varchar,
	INDUSTRY_SE varchar,
	SELLER_ID varchar,
	SELLER_DBA varchar,
	SELLER_ADDRESS varchar,
	SELLER_PHONE varchar,
	SELLER_POSTAL_CODE varchar,
	SELLER_EMAIL varchar,
	MC_LANE_ID varchar,
	P1_SEQUENCE_NUMBER_AREA varchar,
	P1_ENTRY_RUN_NUMBER varchar,
	P1_SEQUENCE_NUMBER_WITHIN_ENTRY_RUN varchar,
	P1_MERCHANT_ACCOUNT_NUMBER varchar,
	P1_TRANSACTION_CODE varchar,
	P1_VAT_TAX_AMOUNT_FREIGHT varchar,
	P1_VAT_TAX_RATE_FREIGHT varchar,
	P1_PRODUCT_IDENTIFIER varchar,
	P1_PRODUCT_IDENTIFIER2 varchar,
	P1_CUSTOMER_CODE varchar,
	P1_LOCAL_TAX varchar,
	P1_LOCAL_TAX_AMOUNT varchar,
	P1_FREIGHT_AMOUNT varchar,
	P1_DESTINATION_ZIP varchar,
	P1_MERCHANT_TYPE varchar,
	P1_DUTY_AMOUNT varchar,
	P1_MERCHANT_TAX_ID varchar,
	P1_SHIP_FROM_ZIP_CODE varchar,
	P1_NATIONAL_TAX_INCLUDED varchar,
	P1_NATIONAL_ALT_TAX_AMOUNT varchar,
	P1_OTHER_TAX varchar,
	P1_DESTINATION_COUNTRY_CODE varchar,
	P1_MERCHANT_REFERENCE_NUMBER varchar,
	P1_DISCOUNT_AMOUNT varchar,
	P1_MERCHANT_VAT_REGISTRATION varchar,
	P1_CUSTOMER_VAT_REGISTRATION varchar,
	P1_SUMMARY_COMMODITY_CODE varchar,
	P1_VAT_INVOICE_REFERENCE_NUMBER varchar,
	P1_ORDER_DATE varchar,
	P1_DETAIL_RECORD_TO_FOLLOW varchar,
	DR_SEQUENCE_NUMBER_AREA varchar,
	DR_ENTRY_RUN_NUMBER varchar,
	DR_SEQUENCE_NUMBER_WITHIN_ENTRY_RUN varchar,
	DR_MERCHANT_ACCOUNT_NUMBER varchar,
	DR_TRANSACTION_CODE varchar,
	DR_PURCHASE_ID_DIRECT_MARKETING_ORD_NUMBER varchar,
	DR_ADDRESS_VERIFICATION_SERVICE_RESPONSE varchar,
	DR_TOTAL_AUTHORIZED_AMOUNT varchar,
	DR_MERCHANT_CUSTOMER_SERVICE_PHONE_NUMBER varchar,
	DR_MAIL_PHONE_INSTALLMENT_SEQUENCE_NUMBER varchar,
	DR_MAIL_PHONE_INSTALLMENT_COUNT varchar,
	DR_EXTENSION_RECORD_INDICATOR varchar,
	MERCHANT_ACCOUNT_CODE int(11),
	INTERCHANGE_FLAT_FEE4P int(11),
	INTERCHANGE_PERCENTAGE_RATE4P int(11),
	INTERCHANGE_PERCENTAGE_AMOUNT4P bigint(20),
	INTERCHANGE_RATE_NAME varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	CHARGE_TRANSACTION_FK bigint(20),
	INTERCHANGE_PERCENTAGE_AMOUNT4P bigint(20),
	INTERCHANGE_PERCENTAGE_AMOUNT4P bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;