mysql> show create table cs_tpm_tl_operation \G; *************************** 1. row *************************** Table: cs_tpm_tl_operation Create Table: CREATE TABLE `cs_tpm_tl_operation` ( `c_clro` char(5) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Clearing_org_code : Posting and give-up Is the TL operation clearing organization identifier', `d_bus` date NOT NULL COMMENT 'Operation_business_date: Posting and give-up Is the trade leg operation business date', `c_int_ope` bigint(15) NOT NULL COMMENT 'Operation_Id: Posting and give-up Is the internal identifier of the TL operation.', `c_int_inst` bigint(15) DEFAULT NULL COMMENT 'Internal_instrument_id: Posting and give-up Is the instrument id of the TL operation', `y_pos_bal` varchar(2) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Position_balance_type_code: Posting (to be completed) Is the position balance type code of the POSITION_BALANCE targeted by TL operation.', `c_ope` varchar(10) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Operation_code: Posting and give-up Is the operation code corresponding to the TL operation : - Systematic - Automatic - Manual - Corrective Same values as the one used for the BOOK_ENTRY_RULE in the book keeping plus some values for TL operation w', `c_buysell` varchar(1) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Buy_sell_code: Posting and give-up Is the Buy_sell_code of the trade leg related to the operation', `q_req` bigint(18) DEFAULT NULL COMMENT 'Requested_quantity: Posting and give-up Is the quantity requested to the TL operation. Usually, this quantity is equal to the executed quantity.', `q_exec` bigint(18) DEFAULT NULL COMMENT 'Quantity: Posting and give-up Is the quantity executed of the TL operation.', `q_pnd` bigint(18) DEFAULT NULL COMMENT 'Pending_quantity: Give-up Is the quantity filled for give-up on GLOBEX trade legs received in the evening.', `p_tlg` decimal(28,10) DEFAULT NULL COMMENT 'Trade_price : Posting and give-up Valued with the Trade_price', `o_val` decimal(28,10) DEFAULT NULL COMMENT 'Value_amount: Posting Is the valuation of the position amount', `i_openclo_req` varchar(1) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Requested_open_close_mode: Posting Indicates if the posting has been requested in opening mode (gross) or closing mode (net). Give-up Is the open / clode mode indicated for the give-up request', `i_openclo` varchar(1) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Open_close_mode: Posting Indicates if the posting has to be done in opening mode (gross) or closing mode (net).', `c_ext_tmf` varchar(16) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Trading_member_code : Posting TMF of the relationship to which is associated the position account where the quantity has to be posted.', `c_int_tmf` bigint(15) DEFAULT NULL COMMENT 'Trading_member_id : Posting Internal identifier of the TMF of the relationship to which is associated the position ', `c_ext_cmf` varchar(16) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Clearing_member_code: Posting CMF of the relationship to which is associated the position account where the quantity has to be posted', `c_int_cmf` bigint(15) DEFAULT NULL COMMENT 'Clearing_member_id: Posting internal identifier of the CMF of the relationship to which is associated the position account where the quantity has to be posted', `c_orig_pa` varchar(5) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Origin_code: Posting Is the origin of the position account where the quantity has to be posted.', `c_ext_pa` varchar(15) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Position_account_external_id : Posting Is the external id of the position account wher the quantity has to be posted.', `c_int_pa` bigint(15) DEFAULT NULL COMMENT 'Posiiton_account_internal_id: Is the internal identifier associated to a Position Account.', `c_ord_trader` varchar(16) DEFAULT NULL COMMENT 'Trader_order_code: Posting Is the order number received with the posting operation (reference for the member). Give-up Optional attribute Indicates the posting order number designated in the give up request.', `c_ext_tmf_orig` varchar(16) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Original_trading_member_code: Give-up Is the sending member of a give-up', `c_ext_tmf_dest` varchar(16) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Destination_trading_member_code : Give-up Is the receiving member of a give-up.', `i_deft_brog_fee` varchar(1) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Brokerage_default_fee_indicator : Give-up Is the fee indicator used in the give up request. "Yes" if the default fees have to applied, "No" if specific fees have to be applied ', `y_brog_fee` varchar(1) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Brokerage_fee_type: Give-up If there is no default fee, this data indicates if the fees to apply on the trade leg is : - A percentage of the trade leg value (P) - A amount per lot (L) - A global sum (T)', `o_brog_fee` decimal(28,10) DEFAULT NULL COMMENT 'Brokerage_fee_amount: Give-up Is the fee amount designated in the give up request for a give-up with no default fees.', `l_free_text` varchar(30) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Order_free_text: Give-up Optional attribute Is the comment related to the operation.', `l_mail_comment` varchar(30) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Order_free_text: Give-up cancellation and Take-up Optional attribute Is the comment related to the operation.', `c_stus_ope` varchar(1) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Status_code : Posting and give-up Is the current status of posting operation : - Completed - Deleted . Give-up / take-up Is the current status of the give-up and take-up operation : - Pending - Completed - Deleted - Rejected', `d_setl` date DEFAULT NULL COMMENT 'Settlement_date: Is the date when the trade is sent to the delivery house for cash trade.', `d_noti` date DEFAULT NULL COMMENT 'Notification_date : Is the date when the non guaranteed trade are sent to the delivery house (for cash only).', `p_val` decimal(28,10) DEFAULT NULL COMMENT 'Valued_price: Is deduced from the received price but takes into account accrued interest and / or indexing coefficients and coupon correction.', `p_init` decimal(28,10) DEFAULT NULL COMMENT 'Initial_price: Is deduced from the received price but takes into account accrued interest and / or indexing coefficients.', `i_gnt` char(1) CHARACTER SET latin1 DEFAULT NULL COMMENT 'Guarantee_indicator: Indicates if the trade is guaranteed by the Clearing House (Yes or No).', `c_int_tlg` bigint(15) DEFAULT NULL COMMENT 'Internal_trade_leg_id :', `d_bus_tlg` date DEFAULT NULL COMMENT 'Trade_leg_business_date :', `c_coe` varchar(6) DEFAULT NULL COMMENT 'COE_id : Is the corporate event identifier', `i_coe` varchar(1) CHARACTER SET latin1 DEFAULT NULL COMMENT 'COE_ind : Is the corporate event indicator. It can be: - "Y" when a posting is the result of the corporate event application - "N" in the other cases', `y_algo_coe` varchar(3) DEFAULT NULL COMMENT 'y_algo_coe', `c_int_ope_coe_parent` bigint(15) DEFAULT NULL COMMENT 'COE_parent_operation_id : Is the internal identifier of the parent operation (posting) when COE_parent_operation_id: the child operation (posting) has been created by applying a COE.', `d_bus_ope_coe_parent` date DEFAULT NULL COMMENT 'COE_parent_operation_business_date : Is the business date of the parent operation', `d_h_cre` datetime DEFAULT NULL COMMENT 'System_creation_timestamp: Timestamp when the TL operation has been created in the system.', `d_h_cancel` datetime DEFAULT NULL COMMENT 'System_cancellation_timestamp: Timestamp when the TL operation has been cancelled in the system.', `d_h_updt` datetime DEFAULT NULL COMMENT 'System_modification_timestamp: Timestamp when the TL operation has been modified in the system.', `c_int_prc` int(10) unsigned NOT NULL, `c_ext_mbr_submit` varchar(10) DEFAULT NULL, `c_ext_command` varchar(16) DEFAULT NULL, `c_ext_mbr_submit_upd` varchar(10) DEFAULT NULL COMMENT 'Submitting member for take-up', PRIMARY KEY (`d_bus`,`c_int_ope`), KEY `d_bus_ope_coe_parent` (`d_bus_ope_coe_parent`,`c_int_ope_coe_parent`), KEY `c_int_inst` (`c_int_inst`), KEY `c_int_tlg` (`c_int_tlg`,`d_bus_tlg`) ) ENGINE=MEMORY DEFAULT CHARSET=utf8 COMMENT='TL_operation' 1 row in set (0.00 sec) ERROR: No query specified