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