-- Create Table Statement for 'Charge Transaction'
DROP TABLE IF EXISTS `CHARGE_TRANSACTION`;
CREATE TABLE `CHARGE_TRANSACTION` (
	ID bigint(20) NOT NULL,
	APPROVAL_CODE varchar,
	AVS_RESULT_CODE varchar,
	TAX_AMOUNT int(11),
	FEE_AMOUNT int(11),
	ITEM_CODE varchar,
	CREDIT_INDICATOR tinyint(1),
	TRANSACTION_CODE varchar,
	TRANSACTION_DATE datetime,
	REQUEST_DATE datetime,
	CUSTOMER_ACCOUNT_CODE varchar,
	TRANSACTION_MEMO varchar,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	IS_ORGANIZATION tinyint(1),
	STREET varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	COUNTRY_CODE varchar,
	PHONE varchar,
	EMAIL varchar,
	TOKEN_CODE varchar,
	ACCOUNT_NUMBER varchar,
	ACCOUNT_NUMBER_LAST4 varchar,
	ACCOUNT_ACCESSORY varchar,
	ACCOUNT_CL varchar,
	ACCOUNT_NUMBER_MASKED varchar,
	ACCOUNT_ACCESSORY_MASKED varchar,
	ACCOUNT_NUMBER_UPDATED varchar,
	ACCOUNT_NUMBER_UPDATED_LAST4 varchar,
	ACCOUNT_ACCESSORY_UPDATED varchar,
	ACCOUNT_CL_UPDATED varchar,
	ACCOUNT_NUMBER_UPDATED_MASKED varchar,
	ACCOUNT_ACCESSORY_UPDATED_MASKED varchar,
	TOKEN_CODE_UPDATED varchar,
	BIN_ENCODED varchar,
	BIN_UPDATED_ENCODED varchar,
	IS_BIN_UNAVAILABLE tinyint(1),
	PROCESSING_GROUP_CODE varchar,
	IS_REBILL_ENABLED tinyint(1),
	IS_RETURN tinyint(1),
	ORIGINAL_AMOUNT int(11),
	BALANCE int(11),
	IS_PARTIAL_AUTHORIZATION tinyint(1),
	CHECK_NUMBER varchar,
	SEQUENCE_NUMBER int(11),
	SEQUENCE_COUNT int(11),
	ACCOUNT_LEVEL_CL varchar,
	IS_PROXYNIZATION_ENABLED tinyint(1),
	SETTLEMENT_GROUP_CODE varchar,
	CHARGEBACK_TRANSACTION_FK bigint(20),
	BANK_INFO_FK int(11),
	REVERSAL_CHARGEBACK_TRANSACTION_FK bigint(20),
	SECOND_CHARGEBACK_TRANSACTION_FK bigint(20),
	SECOND_REVERSAL_CHARGEBACK_TRANSACTION_FK bigint(20),
	VOID_INDICATOR tinyint(1),
	SHIPPING_FIRST_NAME varchar,
	SHIPPING_LAST_NAME varchar,
	SHIPPING_STREET varchar,
	SHIPPING_CITY varchar,
	SHIPPING_STATE varchar,
	SHIPPING_ZIP_CODE varchar,
	TAX_INVOICE_CODE varchar,
	ORDER_CODE varchar,
	ORDER_DATE datetime,
	TAX_RATE int(11),
	TAX_INDICATOR_CL varchar,
	LOCAL_TAX_AMOUNT int(11),
	LOCAL_TAX_INDICATOR_CL varchar,
	NATIONAL_TAX_AMOUNT int(11),
	NATIONAL_TAX_INDICATOR_CL varchar,
	CUSTOMER_ACCOUNT_TAX_ID varchar,
	COMMODITY_CODE varchar,
	DISCOUNT_AMOUNT int(11),
	SHIPPING_AMOUNT int(11),
	DUTY_AMOUNT int(11),
	SHIPPING_ORIGIN_ZIP_CODE varchar,
	SHIPPING_COUNTRY_CODE varchar,
	FUNDING_DATE datetime,
	REMITTANCE_DATE datetime,
	DEPOSIT_DATE datetime,
	LOG varchar,
	ORIGINAL_RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	AUTH_EXPIRATION_DATE datetime,
	REBILL_ATTEMPT_COUNT int(11),
	TRANSACTION_INTERNAL_CODE varchar,
	CUSTOMER_ACCOUNT_INTERNAL_CODE varchar,
	TRANSACTION_GROUP_CODE varchar,
	TIP_AMOUNT int(11),
	TIP_RECIPIENT_CODE varchar,
	IS_COMMERCIAL_CARD tinyint(1),
	NET_AMOUNT int(11),
	CASH_BACK_AMOUNT int(11),
	ACCOUNT_SOURCE_CL varchar,
	OPERATION_CL varchar,
	HOLDER_NAME_UPDATED varchar,
	AUTHENTICATION_STATUS_CL varchar,
	AUTHENTICATION_CODE varchar,
	HEALTHCARE_AMOUNT int(11),
	TRANSIT_AMOUNT int(11),
	PRESCRIPTION_AMOUNT int(11),
	VISION_AMOUNT int(11),
	DENTAL_AMOUNT int(11),
	CLINIC_AMOUNT int(11),
	VOUCHER_NUMBER varchar,
	TRANSACTION_CATEGORY_CL varchar,
	DUKPT varchar,
	ENTRY_CL varchar,
	IS_INTERREGIONAL tinyint(1),
	IS_PREPAID tinyint(1),
	INTERCHANGE_RATE_NAME varchar,
	INTERCHANGE_PERCENTAGE_FEE4P int(11),
	INTERCHANGE_FLAT_FEE4P int(11),
	INTERCHANGE_FEE_AMOUNT4P int(11),
	PROCESSOR_FEE_AMOUNT4P int(11),
	ASSESSMENTS_FEE_AMOUNT4P int(11),
	PROCESSING_FEE_AMOUNT4P int(11),
	PERITEM_FEE_AMOUNT4P int(11),
	RETRY_FEE_AMOUNT int(11),
	PROCESSING_PROFILE_FK bigint(20),
	EXPECTED_EFFECTIVE_DATE datetime,
	PROVIDER_OPERATION_CL varchar,
	HASH_DATA varchar,
	INITIAL_AUTHORIZED_AMOUNT int(11),
	ORIGINAL_TRANSACTION_REMAINING_AMOUNT int(11),
	NOC_TRANSACTION_FK bigint(20),
	PROVIDER_REFERENCE_NUMBER varchar,
	DRIVER_NUMBER varchar,
	VEHICLE_NUMBER varchar,
	ODOMETR_READING int(11),
	SERVICE_RESTRICTION_CODE varchar,
	PETROLEUM_PRODUCT1_CODE varchar,
	PETROLEUM_PRODUCT2_CODE varchar,
	PETROLEUM_PRODUCT3_CODE varchar,
	PETROLEUM_PRODUCT4_CODE varchar,
	PETROLEUM_PRODUCT1_CL varchar,
	PETROLEUM_PRODUCT2_CL varchar,
	PETROLEUM_PRODUCT3_CL varchar,
	PETROLEUM_PRODUCT4_CL varchar,
	PETROLEUM_PRODUCT1_QUANTITY int(11),
	PETROLEUM_PRODUCT2_QUANTITY int(11),
	PETROLEUM_PRODUCT3_QUANTITY int(11),
	PETROLEUM_PRODUCT4_QUANTITY int(11),
	PETROLEUM_PRODUCT1_UNIT_COST_AMOUNT int(11),
	PETROLEUM_PRODUCT2_UNIT_COST_AMOUNT int(11),
	PETROLEUM_PRODUCT3_UNIT_COST_AMOUNT int(11),
	PETROLEUM_PRODUCT4_UNIT_COST_AMOUNT int(11),
	PROCESSING_COST_AMOUNT4P int(11),
	IS_VERIFIED_IIAS tinyint(1),
	IS_CONFIRMED tinyint(1),
	LODGING_CHECK_OUT_DATE datetime,
	LODGING_FOLIO_NUMBER varchar,
	LODGING_ROOM_NUMBER varchar,
	LODGING_CHECK_IN_DATE datetime,
	LODGING_DURATION int(11),
	LODGING_SPECIAL_PROGRAM_CL varchar,
	LODGING_CHARGE_CL varchar,
	LODGING_ROOM_RATE_AMOUNT int(11),
	LODGING_ROOM_TAX_AMOUNT int(11),
	LODGING_DEPARTURE_ADJUSTMENT_AMOUNT int(11),
	SETTLEMENT_AMOUNT int(11),
	AUTHORIZATION_CURRENCY_CODE_CL varchar,
	CAPTURE_CURRENCY_CODE_CL varchar,
	BALANCE_FOOD_STAMP int(11),
	THIRD_REVERSAL_CHARGEBACK_TRANSACTION_FK bigint(20),
	THIRD_CHARGEBACK_TRANSACTION_FK bigint(20),
	SETTLEMENT_DELAY int(11),
	WARNING_CODE int(11),
	DESCRIPTOR varchar,
	CONFIRMATION_LOG varchar,
	LANE_CODE varchar,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	SUBMISSION_CL varchar,
	AMOUNT int(11),
	RESPONSE_CODE varchar,
	RESPONSE_MESSAGE varchar,
	PROVIDER_RESPONSE_CODE varchar,
	TRANSACTION_CL varchar,
	STATUS_CL varchar,
	CSC_RESPONSE_CODE varchar,
	RESPONSE_DATE datetime,
	CONFIRM_CL varchar,
	VOID_TRANSACTION_CODE varchar,
	VOID_DATE datetime,
	VOID_TRANSACTION_MEMO varchar,
	TRANSACTION_INDUSTRY_CL varchar,
	RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	SUB_BATCH_FK bigint(20),
	BATCH_FK bigint(20),
	ORIGINAL_SUB_BATCH_CODE bigint(20),
	PROCESSING_SUB_BATCH_CODE bigint(20),
	IS_AGGREGATE_TRANSACTION tinyint(1),
	TEMPORARY_TOKEN_CODE varchar,
	ORIGINAL_REFERENCE_NUMBER bigint(20),
	ORIGINAL_PROVIDER_REFERENCE_NUMBER varchar,
	BILLING_PROFILE_TYPE varchar,
	DRIVER_LICENSE_STATE varchar,
	DRIVER_LICENSE_NUMBER varchar,
	IDENTITY_VERIFICATION_CL varchar,
	IDENTITY_VERIFICATION_VALUE varchar,
	PROVIDER_RESPONSE_MESSAGE varchar,
	REMAINING_AMOUNT int(11),
	TRANSACTION_ORIGIN_CODE varchar,
	VOID_TRANSACTION_ORIGIN_CODE varchar,
	CLIENT_HOST varchar,
	REQUEST_HOST varchar,
	VOID_CLIENT_HOST varchar,
	VOID_REQUEST_HOST varchar,
	PROVIDER_AVS_RESPONSE_CODE varchar,
	PROVIDER_CSC_RESPONSE_CODE varchar,
	MICR_DATA varchar,
	CHECK_IMAGE_FK bigint(20),
	USER_CODE varchar,
	VOID_USER_CODE varchar,
	CURRENCY_CODE_CL varchar,
	REWARD_POINTS_AMOUNT int(11),
	REWARD_CURRENCY_AMOUNT int(11),
	RECEIPT_NOTES varchar,
	CHARGE_TRANSACTION_ADDENDA_FK bigint(20),
	TENDER_CL varchar,
	TERMINAL_CL varchar,
	CSC_INDICATOR_CL varchar,
	TOKEN varchar,
	ENTRY_MODE_CL varchar,
	ENTRY_MEDIUM_CL varchar,
	ENTRY_PIN_MODE_CL varchar,
	TERMINAL_CAPABILITY_MODE varchar,
	VOID_REASON_CODE varchar,
	TERMINAL_CODE bigint(20),
	TICKET_NUMBER varchar,
	CHARGE_TRANSACTION_TAG_DATA_FK bigint(20),
	PROCESSING_MODE_CL varchar,
	TICKET_AMOUNT int(11),
	SIGNATURE_FK bigint(20),
	ACCOUNT_NUMBER_FIRST4 varchar,
	AUTHENTICATION_THREE_D_SECURE_FK bigint(20),
	SUBSCRIPTION_TRANSACTION_FK bigint(20),
	SUBSCRIPTION_CODE varchar,
	PROVIDER_TRANSACTION_CODE varchar,
	HOLDER_VERIFICATION_MODE_TYPE_CL varchar,
	SERVICE_CODE varchar,
	STAN_VALUE varchar,
	PROCESSING_LOG_FK bigint(20),
	CHARGE_TRANSACTION_DISTRIBUTION_FK bigint(20),
	REFUND_TRANSACTION_FK bigint(20),
	AGGREGATE_TRANSACTION_FK bigint(20),
	HOLDER_BIRTHDATE datetime,
	VANTIV_CHARGEBACK_TRANSACTION_FK bigint(20),
	TSYS_CAPTURE_RETAIL_TRANSACTION_FK bigint(20),
	ACCOUNT_UPDATE_TRANSACTION_FK bigint(20),
	AMEX_CAPTURE_RETAIL_TRANSACTION_FK bigint(20),
	AMEX_CHARGEBACK_DOCUMENT_TRANSACTION_FK bigint(20),
	CHARGEBACK_CASE_FK bigint(20),
	CC_AMEX_BATCH_TRANSACTION_FK bigint(20),
	CC_MONERIS_BATCH_TRANSACTION_FK bigint(20),
	CC_MWE_BATCH_TRANSACTION_FK bigint(20),
	CC_PAYMENTECH_BATCH_TRANSACTION_FK bigint(20),
	CC_WESTPAC_BATCH_TRANSACTION_FK bigint(20),
	EFT1464_CANADA_BATCH_TRANSACTION_FK bigint(20),
	DEBIT_ACCOUNT_CL varchar,
	IS_TOKENIZATION_ENABLED tinyint(1),
	IS_CSC_VERIFICATION_ENABLED tinyint(1),
	IS_AVS_VERIFICATION_ENABLED tinyint(1),
	SHIPPING_DATE datetime,
	IS_ACCOUNT_TYPE_CORRECTION_ENABLED tinyint(1),
	SOURCE_TRANSACTION_FK bigint(20),
	SPLIT_COUNT int(11),
	VOID_PROVIDER_REFERENCE_NUMBER varchar,
	VOID_PROVIDER_REFERENCE_NUMBER varchar,
	RESPONSE_CODE varchar,
	RESPONSE_CODE varchar,
	PAYMENT_NETWORK_NAME varchar,
	VOID_PROVIDER_REFERENCE_NUMBER varchar,
	PAYMENT_NETWORK_NAME varchar,
	PAYMENT_NETWORK_NAME varchar,
	CAPTURE_TRANSACTION_CODE varchar,
	CAPTURE_DATE datetime,
	CAPTURE_TRANSACTION_CODE varchar,
	CAPTURE_DATE datetime,
	ORIGINAL_NETWORK_TRANSACTION_ID varchar,
	HOLDER_NAME varchar,
	CAPTURE_TRANSACTION_CODE varchar,
	CAPTURE_DATE datetime,
	ADDRESS varchar,
	HOLDER_NAME varchar,
	IS_AUTHORIZATION_ONLY tinyint(1),
	PAYMENT_OPTION_TYPE varchar,
	STREET1 varchar,
	STREET2 varchar,
	ADDRESS varchar,
	IS_AUTHORIZATION_ONLY tinyint(1),
	PAYMENT_OPTION_TYPE varchar,
	STREET1 varchar,
	STREET2 varchar,
	TRANSACTION_TYPE varchar,
	TRANSACTION_TYPE varchar,
	IS_AUTHORIZATION_ONLY tinyint(1),
	STREET2 varchar,
	HOLDER_NAME varchar,
	ADDRESS varchar,
	IS_AUTHORIZATION_ONLY tinyint(1),
	PAYMENT_OPTION_TYPE varchar,
	STREET1 varchar,
	STREET2 varchar,
	TRANSACTION_TYPE varchar,
	AVS_RESULT_CODE varchar,
	CSC_RESPONSE_CODE varchar,
	SOURCE_TRANSACTION_FK bigint(20),
	ORIGINAL_RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGEBACK_TRANSACTION_FK bigint(20),
	REVERSAL_CHARGEBACK_TRANSACTION_FK bigint(20),
	SECOND_CHARGEBACK_TRANSACTION_FK bigint(20),
	SECOND_REVERSAL_CHARGEBACK_TRANSACTION_FK bigint(20),
	THIRD_CHARGEBACK_TRANSACTION_FK bigint(20),
	THIRD_REVERSAL_CHARGEBACK_TRANSACTION_FK bigint(20),
	NOC_TRANSACTION_FK bigint(20),
	CHECK_IMAGE_FK bigint(20),
	SIGNATURE_FK bigint(20),
	SOURCE_TRANSACTION_FK bigint(20),
	ORIGINAL_RETAIL_TRANSACTION_CYCLE_FK bigint(20),
	CHARGEBACK_TRANSACTION_FK bigint(20),
	REVERSAL_CHARGEBACK_TRANSACTION_FK bigint(20),
	SECOND_CHARGEBACK_TRANSACTION_FK bigint(20),
	SECOND_REVERSAL_CHARGEBACK_TRANSACTION_FK bigint(20),
	THIRD_CHARGEBACK_TRANSACTION_FK bigint(20),
	THIRD_REVERSAL_CHARGEBACK_TRANSACTION_FK bigint(20),
	NOC_TRANSACTION_FK bigint(20),
	CHECK_IMAGE_FK bigint(20),
	SIGNATURE_FK bigint(20),
	COUNTRY_CODE varchar,
	FIRST_NAME varchar,
	TRANSACTION_DATE int(11),
	NEW_TEST_FIELD varchar,
	TEST_FK bigint(20),
	APPROVAL_CODE varchar,
	LAST_NAME varchar,
	ITEM_CODE varchar,
	TRANSACTION_CODE varchar,
	TEST_TRANSACTION int(11) NOT NULL,
	CUSTOMER_ACCOUNT_CODE varchar NOT NULL,
	TRANSACTION_MEMO varchar,
	TEST_FIELD_ADD int(11),
	CHARGEBACK_TRANSACTION_FK bigint(20),
	AVS_RESULT_CODE varchar,
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TERMINAL_CODE bigint(20),
	SUBMISSION_CL varchar,
	AMOUNT int(11),
	CURRENCY_CODE_CL varchar,
	RESPONSE_CODE varchar,
	RESPONSE_MESSAGE varchar,
	PROVIDER_RESPONSE_CODE varchar,
	PROVIDER_RESPONSE_MESSAGE varchar,
	TRANSACTION_CL varchar,
	STATUS_CL varchar,
	NET_AMOUNT int(11),
	CASH_BACK_AMOUNT int(11),
	APPROVAL_CODE varchar,
	CSC_RESPONSE_CODE varchar,
	FEE_AMOUNT int(11),
	CREDIT_INDICATOR tinyint(1),
	TRANSACTION_DATE datetime,
	REQUEST_DATE datetime,
	FIRST_NAME varchar,
	IS_ORGANIZATION tinyint(1),
	STREET varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	COUNTRY_CODE varchar,
	PHONE varchar,
	EMAIL varchar,
	TOKEN_CODE varchar,
	TOKEN varchar,
	ACCOUNT_NUMBER varchar,
	ACCOUNT_ACCESSORY varchar,
	ACCOUNT_CL varchar,
	ENTRY_CL varchar,
	ENTRY_MODE_CL varchar,
	ENTRY_MEDIUM_CL varchar,
	ENTRY_PIN_MODE_CL varchar,
	TERMINAL_CAPABILITY_MODE varchar,
	ACCOUNT_NUMBER_MASKED varchar,
	ACCOUNT_ACCESSORY_MASKED varchar,
	ACCOUNT_NUMBER_UPDATED varchar,
	ACCOUNT_CL_UPDATED varchar,
	IS_RETURN tinyint(1),
	ORIGINAL_AMOUNT int(11),
	BALANCE int(11),
	IS_PARTIAL_AUTHORIZATION tinyint(1),
	CHECK_NUMBER varchar,
	SEQUENCE_NUMBER int(11),
	SEQUENCE_COUNT int(11),
	ACCOUNT_LEVEL_CL varchar,
	IS_PROXYNIZATION_ENABLED tinyint(1),
	SHIPPING_FIRST_NAME varchar,
	SHIPPING_LAST_NAME varchar,
	SHIPPING_STREET varchar,
	SHIPPING_CITY varchar,
	SHIPPING_STATE varchar,
	SHIPPING_ZIP_CODE varchar,
	FUNDING_DATE datetime,
	REMITTANCE_DATE datetime,
	DEPOSIT_DATE datetime,
	LOG varchar,
	AUTH_EXPIRATION_DATE datetime,
	USER_CODE varchar,
	TIP_AMOUNT int(11),
	INTERCHANGE_RATE_NAME varchar,
	INTERCHANGE_PERCENTAGE_FEE4P int(11),
	INTERCHANGE_FLAT_FEE4P int(11),
	INTERCHANGE_FEE_AMOUNT4P int(11),
	PROCESSOR_FEE_AMOUNT4P int(11),
	ASSESSMENTS_FEE_AMOUNT4P int(11),
	PROCESSING_COST_AMOUNT4P int(11),
	PROCESSING_FEE_AMOUNT4P int(11),
	PERITEM_FEE_AMOUNT4P int(11),
	RETRY_FEE_AMOUNT int(11),
	DESCRIPTOR varchar,
	TERMINAL_CL varchar,
	SETTLEMENT_AMOUNT int(11),
	AUTHORIZATION_CURRENCY_CODE_CL varchar,
	CAPTURE_CURRENCY_CODE_CL varchar,
	WARNING_CODE int(11),
	CONFIRM_CL varchar,
	TRANSACTION_INDUSTRY_CL varchar,
	IS_AGGREGATE_TRANSACTION tinyint(1),
	CLIENT_HOST varchar,
	REQUEST_HOST varchar,
	VOID_REASON_CODE varchar,
	BANK_INFO_FK int(11),
	PROCESSING_PROFILE_FK bigint(20),
	NOC_TRANSACTION_FK bigint(20),
	REFUND_TRANSACTION_FK bigint(20),
	AGGREGATE_TRANSACTION_FK bigint(20),
	SIGNATURE_FK bigint(20),
	SUBSCRIPTION_TRANSACTION_FK bigint(20),
	HOLDER_BIRTHDATE datetime,
	DEBIT_ACCOUNT_CL varchar,
	CAPTURE_DATE datetime,
	HOLDER_NAME varchar,
	ADDRESS varchar,
	PAYMENT_OPTION_TYPE varchar,
	STREET1 varchar,
	TRANSACTION_TYPE varchar,
	AVS_RESULT_CODE varchar,
	ITEM_CODE varchar,
	TRANSACTION_CODE varchar,
	TRANSACTION_MEMO varchar,
	LAST_NAME varchar,
	CHARGEBACK_TRANSACTION_FK bigint(20),
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TERMINAL_CODE bigint(20),
	SUBMISSION_CL varchar,
	AMOUNT int(11),
	CURRENCY_CODE_CL varchar,
	RESPONSE_CODE varchar,
	RESPONSE_MESSAGE varchar,
	PROVIDER_RESPONSE_CODE varchar,
	PROVIDER_RESPONSE_MESSAGE varchar,
	TRANSACTION_CL varchar,
	STATUS_CL varchar,
	NET_AMOUNT int(11),
	CASH_BACK_AMOUNT int(11),
	APPROVAL_CODE varchar,
	CSC_RESPONSE_CODE varchar,
	FEE_AMOUNT int(11),
	CREDIT_INDICATOR tinyint(1),
	TRANSACTION_DATE datetime,
	REQUEST_DATE datetime,
	FIRST_NAME varchar,
	IS_ORGANIZATION tinyint(1),
	STREET varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	COUNTRY_CODE varchar,
	PHONE varchar,
	EMAIL varchar,
	TOKEN_CODE varchar,
	TOKEN varchar,
	ACCOUNT_NUMBER varchar,
	ACCOUNT_ACCESSORY varchar,
	ACCOUNT_CL varchar,
	ENTRY_CL varchar,
	ENTRY_MODE_CL varchar,
	ENTRY_MEDIUM_CL varchar,
	ENTRY_PIN_MODE_CL varchar,
	TERMINAL_CAPABILITY_MODE varchar,
	ACCOUNT_NUMBER_MASKED varchar,
	ACCOUNT_ACCESSORY_MASKED varchar,
	ACCOUNT_NUMBER_UPDATED varchar,
	ACCOUNT_CL_UPDATED varchar,
	IS_RETURN tinyint(1),
	ORIGINAL_AMOUNT int(11),
	BALANCE int(11),
	IS_PARTIAL_AUTHORIZATION tinyint(1),
	CHECK_NUMBER varchar,
	SEQUENCE_NUMBER int(11),
	SEQUENCE_COUNT int(11),
	ACCOUNT_LEVEL_CL varchar,
	IS_PROXYNIZATION_ENABLED tinyint(1),
	SHIPPING_FIRST_NAME varchar,
	SHIPPING_LAST_NAME varchar,
	SHIPPING_STREET varchar,
	SHIPPING_CITY varchar,
	SHIPPING_STATE varchar,
	SHIPPING_ZIP_CODE varchar,
	FUNDING_DATE datetime,
	REMITTANCE_DATE datetime,
	DEPOSIT_DATE datetime,
	LOG varchar,
	AUTH_EXPIRATION_DATE datetime,
	USER_CODE varchar,
	TIP_AMOUNT int(11),
	INTERCHANGE_RATE_NAME varchar,
	INTERCHANGE_PERCENTAGE_FEE4P int(11),
	INTERCHANGE_FLAT_FEE4P int(11),
	INTERCHANGE_FEE_AMOUNT4P int(11),
	PROCESSOR_FEE_AMOUNT4P int(11),
	ASSESSMENTS_FEE_AMOUNT4P int(11),
	PROCESSING_COST_AMOUNT4P int(11),
	PROCESSING_FEE_AMOUNT4P int(11),
	PERITEM_FEE_AMOUNT4P int(11),
	RETRY_FEE_AMOUNT int(11),
	DESCRIPTOR varchar,
	TERMINAL_CL varchar,
	SETTLEMENT_AMOUNT int(11),
	AUTHORIZATION_CURRENCY_CODE_CL varchar,
	CAPTURE_CURRENCY_CODE_CL varchar,
	WARNING_CODE int(11),
	CONFIRM_CL varchar,
	TRANSACTION_INDUSTRY_CL varchar,
	IS_AGGREGATE_TRANSACTION tinyint(1),
	CLIENT_HOST varchar,
	REQUEST_HOST varchar,
	VOID_REASON_CODE varchar,
	BANK_INFO_FK int(11),
	PROCESSING_PROFILE_FK bigint(20),
	NOC_TRANSACTION_FK bigint(20),
	REFUND_TRANSACTION_FK bigint(20),
	AGGREGATE_TRANSACTION_FK bigint(20),
	SIGNATURE_FK bigint(20),
	SUBSCRIPTION_TRANSACTION_FK bigint(20),
	HOLDER_BIRTHDATE datetime,
	DEBIT_ACCOUNT_CL varchar,
	CAPTURE_DATE datetime,
	HOLDER_NAME varchar,
	ADDRESS varchar,
	PAYMENT_OPTION_TYPE varchar,
	STREET1 varchar,
	TRANSACTION_TYPE varchar,
	AVS_RESULT_CODE varchar,
	ITEM_CODE varchar,
	TRANSACTION_CODE varchar,
	TRANSACTION_MEMO varchar,
	LAST_NAME varchar,
	CHARGEBACK_TRANSACTION_FK bigint(20),
	INTERCHANGE_RATE_NAME varchar,
	RETAIL_TRANSACTION_CYCLE bigint(20),
	AMOUNT int(11),
	HOLDER_NAME int(11),
	ZIP_CODE varchar,
	ZIP_CODE varchar,
	PRIMARY KEY (ID, ID, ID)
) ENGINE=InnoDB;