Mutual Funds Data Dictionary

fiAnalytics
├── overallAnalysis
│   ├── totalPortfolioValue - Total current market value of entire mutual fund portfolio
│   ├── totalInvestedAmount - Total money invested across all mutual funds
│   ├── absolutePercentageReturn - Overall return percentage across entire portfolio
│   ├── profitAmount - Total profit or loss amount in rupees
│   ├── xirr - Extended Internal Rate of Return for entire portfolio (time-weighted return)
│   └── portfolioConsolidatedAnalysis (Aggregated holdings across all funds)
│       ├── name - Company name whose stocks are held across various funds
│       ├── isin - International Securities Identification Number of the company
│       ├── percentageContribution - What percentage this company represents in total portfolio
│       ├── totalPortfolioAmount - Total value of this company's stocks across all funds
│       ├── assetClass - Type of investment (Equity, Debt, Others)
│       └── assetSubClass - More specific category (Domestic Equities, International Equities, Rights, etc.)
│
├── mutualFundWiseAnalysis (Detailed analysis for each mutual fund scheme)
│   ├── isin - International Securities Identification Number of the fund
│   ├── benchmarkIndex - Reference market index for performance comparison
│   ├── amcName - Asset Management Company name (fund house like HDFC, ICICI, etc.)
│   ├── mutualFundName - Complete name of the mutual fund scheme
│   ├── lastNavDate - Last date when Net Asset Value was updated
│   ├── accountDetails (Investment account information for this fund)
│   │   ├── folioNo - Unique investor account number with the fund house
│   │   ├── linkedAccRef - Internal system reference identifier
│   │   └── dematId - Dematerialized account identifier
│   ├── totalInvestedAmount - Total money invested in this specific fund
│   ├── totalPortfolioValue - Current market value of this fund investment
│   ├── nav - Net Asset Value (current price per unit of the fund)
│   ├── units - Number of fund units owned by the investor
│   ├── profitAmount - Profit or loss on this fund investment
│   ├── absolutePercentageReturn - Return percentage for this specific fund
│   ├── expenseRatio - Annual management fee charged by the fund (as percentage)
│   ├── cagr - Compound Annual Growth Rate for this fund
│   ├── xirr - Extended Internal Rate of Return for this fund (time-weighted return)
│   ├── portfolioDistributionAnalysis (Detailed breakdown of stocks held by this fund)
│   │   ├── companyName - Name of the company stock held by the fund
│   │   ├── isin - Company's unique stock identifier
│   │   ├── marketCap - Total market value of the company
│   │   ├── percentageContribution - What percentage this stock represents in the fund
│   │   ├── sector - Industry sector the company belongs to (Banking, IT, FMCG, etc.)
│   │   ├── peRatio - Price to Earnings ratio (company valuation metric)
│   │   ├── marketCapitalizationType - Company size classification (LARGE_CAP, MID_CAP, SMALL_CAP)
│   │   ├── assetClass - Type of investment (Equity, Debt, etc.)
│   │   ├── assetSubClass - More specific investment category
│   │   ├── finCode - Internal company financial identification code
│   │   ├── invDate - Date when fund invested in this stock
│   │   └── invEndDate - Date when fund sold this stock (if applicable)
│   ├── marketCapBasedDistributionAnalysis (Fund allocation by company sizes)
│   │   ├── OTHER - Percentage allocated to other category investments
│   │   ├── SMALL_CAP - Percentage in small-sized company stocks
│   │   ├── LARGE_CAP - Percentage in large-sized company stocks
│   │   └── MID_CAP - Percentage in medium-sized company stocks
│   ├── equityOnlyMarketCapBasedDistributionAnalysis (Stock-only allocation by sizes)
│   │   ├── SMALL_CAP - Small company stocks percentage (equity only)
│   │   ├── LARGE_CAP - Large company stocks percentage (equity only)
│   │   └── MID_CAP - Medium company stocks percentage (equity only)
│   ├── sectorBasedDistributionAnalysis - How fund is distributed across different industry sectors
│   ├── historicalNav - Past Net Asset Value records showing fund performance over time
│   ├── marketCapitalizationType - Fund's primary focus on company sizes (LARGE_CAP, MID_CAP, etc.)
│   ├── fundType - Category of mutual fund scheme (Equity, Debt, Hybrid, etc.)
│   ├── schemeCategory - Regulatory classification of the fund as per SEBI guidelines
│   ├── schemeSubCategory - More detailed fund classification within the main category
│   ├── transactions (Complete history of buy/sell/dividend activities in this fund)
│   │   ├── amount - Transaction amount in rupees
│   │   ├── units - Number of fund units bought/sold in this transaction
│   │   ├── nav - Net Asset Value at the time of transaction
│   │   ├── transactionDateTime - Date and time when transaction occurred (as array: [year, month, day, hour, minute])
│   │   ├── transactionType - Type of transaction (BUY, SELL, DIVIDEND, etc.)
│   │   ├── isin - International Securities Identification Number of the fund
│   │   ├── amfiCode - Association of Mutual Funds in India code for the scheme
│   │   ├── txnId - Unique transaction identifier
│   │   ├── narration - Transaction description or notes
│   │   ├── mode - Mode of transaction (online, offline, etc.)
│   │   ├── schemeCode - Short code identifying the scheme
│   │   ├── schemePlan - Scheme plan type (Growth, Dividend, etc.)
│   │   ├── amc - Asset Management Company name for this transaction
│   │   ├── registrar - Registrar and Transfer Agent handling the transaction
│   │   └── isinDescription - Description of the ISIN
│   ├── errorFlags - Any data processing issues, warnings, or validation errors
│   ├── monthlyWorth - Month-by-month portfolio value tracking showing investment growth
│   ├── amfiCode - Association of Mutual Funds in India code for the scheme
│   ├── registrar - Registrar and Transfer Agent name (KFinTech, CAMS, etc.)
│   ├── fatcaStatus - Foreign Account Tax Compliance Act status (Y/N)
│   ├── lienUnits - Number of units under lien (blocked for lending)
│   ├── lockinUnits - Number of units in lock-in period (cannot be redeemed)
│   ├── ucc - Unique Client Code for the investor
│   ├── schemeCode - Short internal code for the scheme
│   ├── schemeOption - Scheme option code (DP for Dividend Payout, etc.)
│   ├── schemeTypes - Category of scheme (GROWTH/EQUITY ORIENTED SCHEMES, INCOME/DEBT ORIENTED SCHEMES)
│   └── fundName - Short name of the fund scheme
│
├── accountWiseFundAnalysis (Fund analysis broken down by individual investment accounts)
│   ├── fundWiseAnalysis (Same structure as mutualFundWiseAnalysis but account-specific)
│   ├── overallAnalysisStartDate - Start date for this account's investment analysis period
│   ├── overallAnalysisEndDate - End date for this account's investment analysis period
│   └── accountDetail (Detailed account holder information)
│       ├── linkReferenceNumber - Unique reference number linking account to data provider
│       ├── maskedAccountNumber - Partially masked bank account number for security
│       ├── fiType - Financial Information type (MUTUAL_FUNDS, etc.)
│       ├── bank - Bank or financial institution name providing the data
│       └── holders (Account holder details - can be multiple holders)
│           ├── name - Full name of account holder
│           ├── dob - Date of birth of account holder
│           ├── mobile - Mobile phone number
│           ├── nominee - Nominee registration status
│           ├── landline - Landline phone number
│           ├── address - Complete postal address
│           ├── email - Email address
│           ├── pan - Permanent Account Number (tax identifier)
│           ├── dematId - Dematerialized account identifier
│           ├── folioNo - Folio number with the fund house
│           ├── kycCompliance - Know Your Customer compliance status
│           └── ckycCompliance - Central Know Your Customer compliance status
│
├── marketCapBasedAnalysis (Overall portfolio distribution by company sizes)
│   ├── OTHER - Total percentage in other category investments across all funds
│   ├── SMALL_CAP - Total percentage in small company investments
│   ├── LARGE_CAP - Total percentage in large company investments
│   └── MID_CAP - Total percentage in medium company investments
│
└── equityOnlyMarketCapBasedAnalysis (Equity-only portfolio distribution by company sizes)
    ├── SMALL_CAP - Small company equity percentage across all funds
    ├── LARGE_CAP - Large company equity percentage across all funds
    └── MID_CAP - Medium company equity percentage across all funds