-- Create Table Statement for 'Moneris ISO Auth Retail Transaction'
DROP TABLE IF EXISTS `MONERIS_ISO_AUTH_RETAIL_TRANSACTION`;
CREATE TABLE `MONERIS_ISO_AUTH_RETAIL_TRANSACTION` (
ID bigint(20) NOT NULL,
MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
DPC_NUMBER varchar,
MESSAGE_TYPE varchar,
BIT03 varchar,
BIT04 varchar,
BIT07 varchar,
BIT11 varchar,
BIT12 varchar,
BIT13 varchar,
BIT17_RESPONSE varchar,
BIT22 varchar,
BIT37 varchar,
BIT38 varchar,
BIT39_RESPONSE varchar,
BIT41 varchar,
BIT42 varchar,
BIT44 varchar,
BIT46 varchar,
BIT48 varchar,
BIT54 varchar,
BIT54_RESPONSE varchar,
BIT55 varchar,
BIT55_RESPONSE varchar,
BIT56 varchar,
BIT57 varchar,
BIT58 varchar,
BIT58_RESPONSE varchar,
BIT60 varchar,
BIT61_RESPONSE varchar,
BIT63 varchar,
BIT64 varchar,
BIT91 varchar,
BIT95 varchar,
BIT104_RESPONSE varchar,
BIT114 varchar,
BIT116 varchar,
BIT117 varchar,
BIT118 varchar,
BIT119 varchar,
BIT122_RESPONSE varchar,
BIT123 varchar,
BIT124 varchar,
BIT126 varchar,
BIT127 varchar,
CHARGE_TRANSACTION_FK bigint(20),
RETAIL_TRANSACTION_CYCLE_FK bigint(20),
BIT38_RESPONSE varchar,
BIT37_RESPONSE varchar,
BIT48_RESPONSE_CODE varchar,
BIT116_RESPONSE varchar,
BIT04_RESPONSE varchar,
BIT57_RESPONSE varchar,
BIT122_TRANSACTION_ID varchar,
BIT56_RESPONSE varchar,
BIT122_BANK_DATE varchar,
CHARGE_TRANSACTION_FK bigint(20),
CHARGE_TRANSACTION_FK bigint(20),
PRIMARY KEY (ID)
) ENGINE=InnoDB;