-- Create Table Statement for 'TPG Terminal Order Transaction Detail'
DROP TABLE IF EXISTS `TPG_TERMINAL_ORDER_TRANSACTION_DETAIL`;
CREATE TABLE `TPG_TERMINAL_ORDER_TRANSACTION_DETAIL` (
ID bigint(20) NOT NULL,
MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
LINE_ID varchar,
ITEM_PRICE varchar,
ITEM_NUMBER varchar,
RETURN_SERIAL_NUMBER varchar,
INJECTION_INFORMATION varchar,
PROCESSOR varchar,
APPLICATION varchar,
PRIMARY_TID varchar,
SHIPPING_DATE varchar,
SHIPPING_NO varchar,
SHIPPED_WITH varchar,
TERMINAL_SUPPORT_NUMBER varchar,
SECONDARY_TID varchar,
PROCESSOR varchar,
APPLICATION varchar,
PROCESSOR varchar,
APPLICATION varchar,
ITEM_NUMBER varchar,
ITEM_NUMBER varchar,
RETURN_SERIAL_NUMBER varchar,
RETURN_SERIAL_NUMBER varchar,
TPG_TERMINAL_ORDER_TRANSACTION_FK bigint(20),
TPG_TERMINAL_ORDER_TRANSACTION_FK bigint(20),
TPG_TERMINAL_ORDER_TRANSACTION_FK bigint(20),
PRIMARY KEY (ID)
) ENGINE=InnoDB;