-- Create Table Statement for 'Tpg Maverick Terminal Order Transaction'
DROP TABLE IF EXISTS `TPG_MAVERICK_TERMINAL_ORDER_TRANSACTION`;
CREATE TABLE `TPG_MAVERICK_TERMINAL_ORDER_TRANSACTION` (
ID bigint(20) NOT NULL,
TPG_MAVERICK_TERMINAL_ORDER_TRANSACTION_DETAILS bigint(20),
TERMINAL_ORDER_TRANSACTION_FK bigint(20),
FULFILLMENT_CENTER_CODE bigint(20),
PO varchar,
SHIPPER varchar,
FIRST_NAME varchar,
LAST_NAME varchar,
ADDRESS1 varchar,
CITY varchar,
ZIP varchar,
COUNTRY varchar,
PHONE varchar,
COMPANY varchar,
ADDRESS2 varchar,
STATE varchar,
ADDITIONAL_OPTION_CUSTOMER_ID varchar,
ADDITIONAL_OPTION_CUSTOMER_PO varchar,
RESPONSE_NUMBER varchar,
RESPONSE_ERROR_CODE varchar,
RESPONSE_ERROR_MESSAGE varchar,
RESPONSE_STATUS varchar,
RESPONSE_TRACKING_NUMBER varchar,
RESPONSE_TRACKING_STATUS varchar,
RESPONSE_SHIP_DATE varchar,
SHIPPING_METHOD varchar,
PRIMARY KEY (ID)
) ENGINE=InnoDB;