FI Schema – ETF

FI Schema – Exchange Traded Funds

ETF
Exchange Traded Funds
AccountBasic Profile of the account which should include the Account Owner information, maskedAccNumber and linkedAccRef numbers,
type of account specific to the FI type and any other generic details as might be pertinent for the specified FI type.
AttributesNameTypeUseAnnotation
maskedAccNumberstringrequiredMasked Account No.
linkedAccRefstringrequiredLinked account reference no. for the account
versionfloatrequiredVersion of Schema
typestringrequiredType of Schema (Fixed: "certificates_deposit")
Profile
Holders
HolderAttribute NameTypeUseAnnotation
namestringrequiredName of the Account Holder
dobdaterequired
mobileintegerrequired
nomineeenum(Registered, Not-Registered)requiredNominee registered for the account or not
dematIdstringrequired
landlinestringoptionalLandline no. of the Account Holder
addressstringoptional
emailstringrequired
panstringrequiredPAN no. of the Account Holder
ckycCompliancebooleanrequiredCentral KYC record exists or not
Summary
AttributesAttribute NameTypeUseAnnotation
currentValuefloatrequired
investmentValuefloatrequired
Holdings
HoldingQNameTypeUseAnnotation
amcstringrequiredAMC Name
registrarstringrequiredRTA Name
schemeCodestringrequiredScheme Name
isinstringrequiredISIN of the Fund
uccstringrequiredClient's UCC
amfiCodestringrequiredamfi Scheme Code
folioNostringrequired
dividendTypestringrequiredReinvest, payout or growth type of
dividend
FatcaStatusstringrequired
modeenum(DEMAT,
PHYSICAL)
requiredHolding is either DEMAT mode or
PHYSICAL
unitsfloatrequiredTotal no. of units held by the user for
that particular ISIN
closingUnitsstringrequired
lienUnitsstringrequired
ratestringrequiredRate at which it was bought, in case
of multiple transaction, the rate will
be the average buy price
navstringrequiredCurrent unit price of that ISIN
lockingUnitsstringrequiredApplicable for mutual funds of
ELSS/Tax saving category
Transactions
AttributesAttribute NameTypeUseAnnotation
startDatedaterequiredStart date of transactions
endDatedaterequiredEnd date of transactions
TransactionAttribute NameTypeUseAnnotation
txnIdstringrequiredUnique Transaction Id
amcstringrequired
registrarstringrequired
schemeCodestringrequired
isinstringrequired
amfiCodestringrequired
fundTypeenum(EQUITY, DEBT,
BALANCED, CASH,
OTHERS)
required
dividendTypestringrequired
uccstringrequired
amountstringrequired
closingUnitsstringrequired
lienUnitsstringrequired
navstringrequired
navDatedaterequired
typeenum(BUY, SELL,
OTHERS)
required
orderDatedaterequired
executionDatedaterequired
lock-inflagstringrequired
lock-inDaysstringrequired
modeenum(DEMAT,
PHYSICAL)
required
narrationstringrequired