-- Create Table Statement for 'Terminal Order'
DROP TABLE IF EXISTS `TERMINAL_ORDER`;
CREATE TABLE `TERMINAL_ORDER` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	SHIPPING_NAME varchar,
	SHIPPING_STREET1 varchar,
	SHIPPING_CITY varchar,
	SHIPPING_STATE varchar,
	SHIPPING_ZIP_CODE varchar,
	SHIPPING_COUNTRY_CODE varchar,
	NOTES varchar,
	RMA_NUMBER varchar,
	TRACKING_NUMBER varchar,
	SHIPMENT_NUMBER varchar,
	ORDER_STATUS_CL varchar,
	TERMINAL_CODE bigint(20),
	CREATE_DATE datetime,
	CREATOR_CODE varchar,
	SHIPPING_DATE datetime,
	DELIVERY_CONFIRMATION_DATE datetime,
	PROCESSING_DATE datetime,
	FULFILLMENT_CENTER_FK bigint(20),
	CONTACT_NAME varchar,
	PHONE varchar,
	EMAIL varchar,
	SHIPPING_STREET2 varchar,
	TERMINAL_ORDER_CL varchar,
	DELIVERY_CONFIRMATION_HOST varchar,
	PAYMENT_ARRANGEMENT_CL varchar,
	ACCEPTANCE_NOTIFICATION_EMAIL_FK bigint(20),
	APPROVAL_NOTIFICATION_EMAIL_FK bigint(20),
	CANCELLATION_NOTIFICATION_EMAIL_FK bigint(20),
	MODIFICATION_NOTIFICATION_EMAIL_FK bigint(20),
	SHIPMENT_NOTIFICATION_EMAIL_FK bigint(20),
	RESPONSE_MESSAGE varchar,
	TERMINAL_SUPPORT_NUMBER varchar,
	SHIPPING_METHOD_FK bigint(20),
	TERMINAL_ORDER_DETAIL_FK bigint(20),
	TERMINAL_ORDER_HISTORY_FK bigint(20),
	TERMINAL_ORDER_TRANSACTION_FK bigint(20),
	ACCEPTANCE_NOTIFICATION_EMAIL_FK bigint(20),
	APPROVAL_NOTIFICATION_EMAIL_FK bigint(20),
	CANCELLATION_NOTIFICATION_EMAIL_FK bigint(20),
	MODIFICATION_NOTIFICATION_EMAIL_FK bigint(20),
	SHIPMENT_NOTIFICATION_EMAIL_FK bigint(20),
	ACCEPTANCE_NOTIFICATION_EMAIL_FK bigint(20),
	APPROVAL_NOTIFICATION_EMAIL_FK bigint(20),
	CANCELLATION_NOTIFICATION_EMAIL_FK bigint(20),
	MODIFICATION_NOTIFICATION_EMAIL_FK bigint(20),
	SHIPMENT_NOTIFICATION_EMAIL_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;