-- Create Table Statement for 'World Pay TCMP Retail Transaction' DROP TABLE IF EXISTS `WORLD_PAY_TCMP_RETAIL_TRANSACTION`; CREATE TABLE `WORLD_PAY_TCMP_RETAIL_TRANSACTION` ( ID bigint(20) NOT NULL, MERCHANT_ACCOUNT_CODE int(11) NOT NULL, APPLICATION_TYPE varchar, PROCESSING_TYPE varchar, TERMINAL_IDENTIFICATION varchar, DEVICE_IDENTIFIER varchar, MESSAGE_NUMBER varchar, TRANSACTION_CODE varchar, ACCOUNT_TYPE varchar, ENTRY_METHOD varchar, REQUEST_TYPE varchar, MOTO_ECOMMERCE_FLAG varchar, CARD_HOLDER_ID_METHOD varchar, SIC_OVERRIDE_FLAG varchar, OVERRIDING_SIC_CODE varchar, BATCH_NUMBER varchar, SEQUENCE_NUMBER varchar, LOCAL_TRANSACTION_DATE varchar, LOCAL_TRANSACTION_TIME varchar, TOTAL_AMOUNT varchar, RETRIEVAL_BILLABLE_EVENT_DATA varchar, AUTHORIZATION_CODE varchar, ADDITIONAL_AMOUNT_FIELD varchar, TRANS_TYPE_IDENTIFIER varchar, EBT_VOUCHER_NUMBER varchar, EBT_AUTHORIZATION_CODE varchar, CUSTOMER_ADDRESS varchar, CUSTOMER_ZIP_CODE varchar, PARTIAL_AUTHORIZATION_SUPPORT varchar, MISCELLANEOUS_MERCHANT_ID varchar, TERMINAL_INPUT_CAPABILITIES varchar, CHARGE_TRANSACTION_FK bigint(20), RETAIL_TRANSACTION_CYCLE_FK bigint(20), VERIFIED_VISA_MASTER_CARD_INDICATOR varchar, TOTAL_AMOUNT_AUTHORIZED varchar, ACTION_CODE varchar, RESPONSE_LITERAL varchar, RETRIEVAL_DATA varchar, ADDITIONAL_RECEIPT_DATA varchar, TRAN_TYPE_SPECIFIC_DATA varchar, TRAN_TYPE_IDENTIFIER varchar, AMOUNT_OF_CASH_BACK_AUTHORIZED varchar, FEE_AMT_FOR_DEBIT varchar, DEBIT_BALANCE varchar, FOOD_ACCOUNT_BALANCE varchar, CASH_ACCOUNT_BALANCE varchar, FCS_NUMBER varchar, AVS_RESULT_CODE varchar, CVV2_RESULT_CODE varchar, PURCHASE_CARD_INDICATOR varchar, AUTH_SOURCE varchar, CREDIT_ACI_AUTHORIZATION_CHARACTERISTICS_INDICATOR varchar, VALIDATION_CODE varchar, UCAF_CAVV_RESULT_CODE varchar, EMAIL varchar, DESCRIPTION varchar, INVOICE_NUMBER varchar, POSTAL_ZIP_CODE varchar, POSTAL_ADDRESS varchar, PHONE_NUMBER varchar, HEALTHCARE_AMOUNT varchar, TRANSIT_AMOUNT varchar, PRESCRIPTION_AMOUNT varchar, VISION_AMOUNT varchar, CLINIC_AMOUNT varchar, DENTAL_AMOUNT varchar, RETAIL_TRANSACTION_CYCLE_FK bigint(20), CHARGE_TRANSACTION_FK bigint(20), RETAIL_TRANSACTION_CYCLE_FK bigint(20), CHARGE_TRANSACTION_FK bigint(20), PRIMARY KEY (ID) ) ENGINE=InnoDB;