-- 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;