Skip to main content

📤 Upload Flexi Master​

Navigation: RMS ADMIN >> Upload >> Upload Flexi Master

Definition​

Upload Flexi Master is used for bulk upload. User create/view/modify/delete the Flexi upload.

🎯 Scope​

Given below are the type of uploads that User can upload in the file format:

  • MTF Approved ISIN
  • Ban Scrip
  • Scrip Basket restricted
  • Scrip Basket Margin
  • Haircut Template
  • Entity Master
  • Template Mapping
  • Entity wise Deposit
  • Holding upload
  • Entity level Direct Restriction
  • Position limit
  • Manual Position Upload
  • QVL Upload
  • Brokerage Template
  • Brokerage Schema

Description​

  • Step-1: Create Flexi Template
  • Step-2: Choose the source file from the location for uploading the file format. File Format should be in csv format only.
  • Step-3: Verify the Values in Header row, Footer row etc., as per preference
    • Default value:
      • Header Row: Default Value – 1
      • Footer Row: Default Value – 0
      • Skip Row: Default Value – 0
      • Column Delimiter: Default Value - ,
      • Row Delimiter: Default Value - \r\n
  • Step-4: Map the fields name with column name mentioned in file.
  • Step-5: Along with Mandatory checkbox, select the Optional field Checkbox and map the field name with column name as required for the file upload.
  • Select-6: Truncate option shall also be provided for some of the Uploads in Upload flexi Master. Based on the selection of Upload Type, Truncate option shall be display.
    • Purpose: Truncate will delete all previous data inserted and update the new data which is uploaded in the file.
  • Step-7: User can save the template using the Save button and upload using the Upload icon. In case, if any error occurred (not successfully uploaded), the user can click the log button to see the error. The reason for rejection will be Provided.

Below are the Sample File Format for the Upload Types:

1. Ban Scrip​

🔢 ExchangeId📦 sSymbol
1RELGOLDINAV
1ABB

2. Entity Master​

🔢 OpCode🆔 EntityId📝 EntityName🏢 EntityType📊 EntitySubType👥 EntityProfile📈 EntityState⚡ Status🔑 UCC☎️ Telephone No💳 PAN Card💰 Net Worth👨‍👩‍👧‍👦 Group✅ POA Approved
100A_1A_1_MOD1256111120986546123457QWERT1234YHO
100A_2A_2_MOD51216384111

3. Entity wise Deposit​

🔢 Operation Code🆔 EntityId🔑 Deposit ID💰 Deposit Amount📅 ExpiryDate📝 Remarks
100A_1199999917-02-2025added_0
100A_129999925-01-2023added_1

4. Haircut Template Master​

🔑 TemplateId🔢 OperationCode📋 ISIN📊 HairCutPercentage
AS20100INF733I0101050
AS20100INE117A0102250

5. Holding Master​

🔢 OpCode🔑 Holding ID🆔 EntityId📋 ISIN📊 MarketSegmentId📦 Holding Qty📋 EDIS Qty🔒 Max Collateral Qty💰 BuyPrice📈 Max CFS Qty📊 Collateral HC%📊 CFS HC%
1001DEMORET228INE012A0102517150501001000502020
1001DEMORET228INE012A0102518100501001000502020

6. Manual position​

🔢 OpCode🆔 EntityId📊 ExchangeId🔧 ExchangeInstrument🔧 ProductTypeId📦 Symbol📈 Series📅 ExpiryDate💲 Strikeprice🎯 OptionType📈 Buy Quantity💰 Buy Value📉 Sell Quantity💰 Sell Value🏢 hierarchy 1🏢 hierarchy 2🏢 hierarchy 3🏢 hierarchy 4🏢 hierarchy 5🏢 hierarchy 6🏢 hierarchy 7🏢 hierarchy 8🏢 hierarchy 9🏢 hierarchy 10
100RETK14FUTSTK7TCSXX29-05-20250XX17520000000000RETK1
100RETK14OPTSTK8RELIANCEXX29-05-20251400CE100014000000000RETK1

7. Position limit​

🔢 OpCode📊 ExchangeId📦 UnderlyingSymbol🏢 EntitySubType🔧 InstrumentTypeID📅 ExpiryType🤖 AlgoFlag📅 ExpiryNearDays📊 UnderlyingMWPL📊 QuantityInMWPLPercent📊 UnderlyingFF📊 QuantityInFFPercent📊 QuantityInOIPercent📊 PositionLimit💯 AbsoluteValue⚡ ValidityType
10018AARTIIND11999110022211110
10018ABB21999120012221111

8. Scrip basket margin template​

🔑 TemplateId🔢 OpCode📊 ExchangeId🔧 InstrumentTypeId🔧 ProductId📦 Symbol📈 Series📅 ContractType📅 ExpiryDate🎯 OptionType📊 FlatBuyMarginPcnt📊 FlatSellMarginPcnt📊 AddonBuyMarginPcnt📊 AddonSellMarginPcnt📊 AddonBuyMarginPerLot📊 AddonSellMarginPerLot📝 Remarks
TEN1100181028NIFTY2999XX503839404142
TEN1100181038BANKNIFTY2999CE434445464748

9. Scrip basket Restricted template​

🔑 TemplateId📊 SBR level🔢 OperationCode📊 ExchangeId🔧 InstrumentTypeId🔧 ProductId📦 Symbol📈 Series📅 ContractType📅 ExpiryDate💲 StrikePrice📊 ITM(%) (Away from Spot)📊 OTM(%) (Away from Spot)🎯 OptionType🔒 FreshBuy🔒 FreshSell🔒 BuyIntPosSqoff🔒 SellIntPosSqoff🔒 BuyExpPosSqoff🔒 SellExpPosSqoff🔒 Rollover🔒 DMABuy🔒 DMASell📝 Remarks📅 RestrictionTillDate
RMK102100104ACCEQ000XX0011110115188217-12-2022
RMK102100103TCSEQ000XX1011110115188218-12-2022

10. Template Mapping​

🔢 Operation Code🏢 Mapping Type💡 Mapping Type Value📊 Entity State ID📦 Template Type ID🔑 Template Name🔑 New Template Name📝 Remarks
1001A_111KK1KK2ADDED
1001A_212KK2ADDED

11. MTF Approved ISIN​

Exchange file format will also be supported.

📋 ISIN
INE012A01025

12. Entity level direct Restricted template​

🔢 OperationCode👥 Entity Group Id🆔 EntityId📊 ExchangeId🔧 InstrumentTypeId🔧 ProductId📦 Symbol📈 Series📅 ContractType📅 ExpiryDate💲 StrikePrice🎯 OptionType🔒 FreshBuy🔒 FreshSell🔒 BuyIntPosSqoff🔒 SellIntPosSqoff🔒 BuyExpPosSqoff🔒 SellExpPosSqoff🔒 Rollover🔒 DMABuy🔒 DMASell📝 Remarks📅 RestrictionTillDate
100DEMORET238181028BANKNIFTYXX1999XX1111000115188217-12-2023
100DEMORET238191037USDINRXX2201CE0111110115188217-12-2023

13. Brokerage Template​

🔑 TemplateId🔢 OpCode📊 ExchangeId🔧 InstrumentTypeId🔧 ProductId📦 Brokerage Schema
TEN1100181028SCHEMA1
TEN1100181038SCHEMA2

14. Brokerage Schema​

📦 Brokerage Schema🔢 OpCode📊 BuyBrokerage %📊 SellBrokerage %💰 BuyFlatBrokeragePerLot/Qty💰 SellFlatBrokeragePerLot/Qty💰 BuyFlatBrokeragePerLot/Order💰 SellFlatBrokeragePerLot/Order💰 FlatTopupAddonBrokerageperScrip/Contract💰 Minimum Brokerage per Scrip/Contract💰 Maximum Brokerage per Scrip/Contract
SCHEMA110050320000000
SCHEMA210045100000000

15. QVL Template​

🔢 OperationCode🔑 TemplateId📊 QVLLevel📊 ExchangeId🔧 InstrumentTypeId🔧 ProductId📦 Symbol📈 Series📅 ContractType📅 ExpiryDate💲 StrikePrice🎯 OptionType📝 Remark🔑 QVL Rule ID💰 QVL Value
100DEFAULT_QVL111ACC110000
101DEF_QVL22181038TCS127-03-20253200145000000