F&O Table Layout (S01 Import Selection)
Fut02_client Must be a CLI with type ‘T’ e.g. ENERGY.T and nominated as a ‘F&O client’. E.g. entry would be ENERGY (without the T)
Fut02_brokerprice Optional. Usually only relevant if the trade is a CFD (Contract for Difference). Format is 99999999.99
Fut02_bs B or S (buy or sell)
Fut02_code Optional. is used to describe the type of F&O trade e.g. hedge, spec, roll, buyback. Codes are validated with TERMCODES/TRADE Maximum 3 characters. See note 1. Special; will use code = ‘AA’ and the commission is being determined from CLI to get relevant Comrate
Fut02_comrate Optional. Commission rate, format 999999.99, will be located from fut02_client, fut02_code static if no entry
Fut02_confirmdate Optional. YYYYMMDD format, date when trade confirmed into position, usually same as Trade date
Fut02_dept Optional. Code validated with DEPT list. See note 1. If no entry then will apply CLI static chr20_dept
Fut02_declndate Redundant for manual entry. The TCCM calculated date for the instrument traded. YYYYMMDD format for expiry/declaration date
Fut02_externalserial Optional, freeformat max 10 characters. Useful to link to external broker system. See note 1.
Fut02_floorbroker Optional, Must be a CLI with type ‘T’ e.g. JPM (without the T) and nominated as a ‘F&O broker’. See note 1.
Fut02_comod The instrument traded, validate with TCCM list but will carry through an invalid code for correction at TERM/confirmation..
Fut02_currlots The number of lots traded. No decimal places and no signing
Fut02_memo Optional. Free format memo , maximum 120 characters. See note 1.
Fut02_memo2 Optional. Free format memo , maximum 120 characters. See note 1.
Fut02_exprice Optional. Option Series price. Must be expressed exactly as market quotes its prices e.g. NY11 c/lb so 20.50 is valid. Leave blank if a Futures trade
Fut02_extype Optional. Option Series type. C = Call or P = Put. Leave blank if a Futures trade
Fut02_fixed Optional. Code to indicate that this trade is linked to a TRADE Price Fixation. Blank or ‘Y’ See note 1.
Fut02_phys Optional. TRADE reference to which this trade is linked for creation of a Price Fixation See note 1.
Fut02_price Trade price , format 999999.99
Fut02_prompt Settlement date/month. YYYYMM or YYYYMMDD. Validation will be according to TCCM static for this input
Fut02_strategy Optional. Code is used for grouping the F&O trade e.g. Spread Business. Codes are validated with TERMCODES/STRATEGIES Maximum 15 characters See note 1.
Fut02_strategygroup Optional. Code is used for grouping the F&O trade e.g. Sugar, Cocoa.. Codes are validated with TERMCODES/STRATEGIES Maximum 15 characters See note 1.
Fut02_trdat Trade/execution Date. YYYYMMDD format
Fut02_trtime Optional. Trade/execution Time HHMM format See note 1.
Fut02_trinit Optional. Trader’s Initials. Validated with CMP list of initials where CMP record is nominated with trader functionality. See note 1.
Note 1: These features are enabled at Company specific level , using S01/View/F&O to select
Note 2: fut02_comod is used to locate fut02_exchange and fut02_declndate