-- Create Table Statement for 'FirstData North EDC Capture Retail Transaction'
DROP TABLE IF EXISTS `FIRST_DATA_NORTH_EDC_CAPTURE_RETAIL_TRANSACTION`;
CREATE TABLE `FIRST_DATA_NORTH_EDC_CAPTURE_RETAIL_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TRANSACTION_CODE varchar,
	TRANSACTION_AMOUNT varchar,
	TRANSACTION_DATE varchar,
	TRANSACTION_TIME varchar,
	APPROVAL_CODE varchar,
	BATCH_RECORD_NUMBER varchar,
	TICKET_NUMBER varchar,
	CHARGE_TYPE varchar,
	CREDIT_DEBIT_IND varchar,
	CASH_BACK_AMOUNT varchar,
	DEBIT_RECEIPT_NUMBER varchar,
	NUMBER_OF_SUPPLEMENTAL_RECORDS varchar,
	MANUALLY_ENTERED varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	FIRST_DATA_NORTH_EDC_RETAIL_FILE_BATCH_FK bigint(20),
	TABLE_PC2_TOTAL_ADDENDA varchar,
	TABLE_PC2_TAX_AMOUNT varchar,
	TABLE_PC2_TAX_INDICATOR varchar,
	TABLE_PC2_PURCHASE_ID_FORMAT_CODE varchar,
	TABLE_PC2_PURCHASE_IDENTIFIER varchar,
	TABLE_PC2_DESTINATION_POSTAL_CODE varchar,
	TABLE_PC2_MERCHANT_TYPE varchar,
	TABLE_PC2_MERCHANT_TAX_ID varchar,
	TABLE_C01 varchar,
	TABLE_D01 varchar,
	TABLE_AT1 varchar,
	TABLE_AMX varchar,
	TABLE0DS varchar,
	TABLE0VI varchar,
	FIRST_DATA_NORTH_EDC_CAPTURE_RETAIL_TRANSACTIONS_IDX int(11),
	CHARGE_TRANSACTION_FK bigint(20),
	NUMBER_OF_SUPPLEMENTAL_RECORDS varchar,
	NAME_2 varchar,
	CHARGE_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;