1.61.2 Fund Export
This topic provides detailed information on the Fund Export.
Table 1-194 Fund Export
| Field name | Description | Datatype | Length | Table Name |
|---|---|---|---|---|
| SEGMENTID | Segmentid | VARCHAR2 | 20 | FUNDDEMOGRAPHICSUPLOADTBL |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 22 | FUNDDEMOGRAPHICSUPLOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | FUNDDEMOGRAPHICSUPLOADTBL |
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | FUNDDEMOGRAPHICSUPLOADTBL |
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | FUNDDEMOGRAPHICSUPLOADTBL |
| IMPORTFILENAME | Importfile name | VARCHAR2 | 255 | FUNDDEMOGRAPHICSUPLOADTBL |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 50 | FUNDDEMOGRAPHICSUPLOADTBL |
| FUNDID | Fundid | VARCHAR2 | 6 | FUNDDEMOGRAPHICSUPLOADTBL |
| RULEEFFECTIVEDATE | Ruleeffectivedate | DATE | 7 | FUNDDEMOGRAPHICSUPLOADTBL |
| AUTH_STAT | Auth_Stat | VARCHAR2 | 1 | FUNDDEMOGRAPHICSUPLOADTBL |
| FUNDSTARTDATE | Fundstartdate | DATE | 7 | FUNDDEMOGRAPHICSUPLOADTBL |
| FUNDNAME | Fundname | VARCHAR2 | 60 | FUNDDEMOGRAPHICSUPLOADTBL |
| FUNDNAMESHOR T | Fundnameshort | VARCHAR2 | 90 | FUNDDEMOGRAPHICSUPLOADTBL |
| FUNDCLASS | Fundclass | VARCHAR2 | 1 | FUNDDEMOGRAPHICSUPLOADTBL |
| FUNDTYPE | Fundtype | NUMBER | 38 | FUNDDEMOGRAPHICSUPLOADTBL |
| FUNDFAMILY | Fundfamily | VARCHAR2 | 6 | FUNDDEMOGRAPHICSUPLOADTBL |
| FUNDBASECURRENCY | Fundbasecurrency | VARCHAR2 | 3 | FUNDDEMOGRAPHICSUPLOADTBL |
| FUNDCOUNTRY | Fundcountry | VARCHAR2 | 3 | FUNDDEMOGRAPHICSUPLOADTBL |
| FISCALSTARTYEAR | Fiscalstartyear | DATE | 7 | FUNDDEMOGRAPHICSUPLOADTBL |
| FISCALENDYEAR | Fiscalendyear | DATE | 7 | FUNDDEMOGRAPHICSUPLOADTBL |
| AMCID | Amcid | VARCHAR2 | 12 | FUNDDEMOGRAPHICSUPLOADTBL |
| BROKERSALLOWED | Brokersallowed | NUMBER | 1 | FUNDDEMOGRAPHICSUPLOADTBL |
| REGISTRARID | Registrarid | VARCHAR2 | 12 | FUNDDEMOGRAPHICSUPLOADTBL |
| TRUSTEEID | Trusteeid | VARCHAR2 | 12 | FUNDDEMOGRAPHICSUPLOADTBL |
| LATESTRULE | Latestrule | NUMBER | 1 | FUNDDEMOGRAPHICSUPLOADTBL |
| MOD_NO | Mod_No | NUMBER | 22 | FUNDDEMOGRAPHICSUPLOADTBL |
| MAKER_ID | Maker_Id | VARCHAR2 | 320 | FUNDDEMOGRAPHICSUPLOADTBL |
| MAKER_DT_STA MP | Maker_Dt_Stam p | DATE | 7 | FUNDDEMOGRAPHICSUPLOADTBL |
| CHECKER_ID | Checker_Id | VARCHAR2 | 320 | FUNDDEMOGRAPHICSUPLOADTBL |
| CHECKER_DT_STA MP | Checker_Dt_Stam p | DATE | 7 | FUNDDEMOGRAPHICSUPLOADTBL |
| MINHOLDINGPERIOD | Minholdingperiod | NUMBER | 22 | FUNDDEMOGRAPHICSUPLOADTBL |
| PRIMARYREGADDRESS | Primaryregaddress | VARCHAR2 | 255 | FUNDDEMOGRAPHICSUPLOADTBL |
| FUNDTAXID | Fundtaxid | VARCHAR2 | 25 | FUNDDEMOGRAPHICSUPLOADTBL |
| FUNDIDENTIFICATIONNUMBER | Fundidentifi cationnum ber | VARCHAR2 | 25 | FUNDDEMOGRAPHICSUPLOADTBL |
| FUNDTICK ERSYMBOL | Fundtickersymbol | VARCHAR2 | 25 | FUNDDEMOGRAPHICSUPLOADTBL |
| ALLOWIRAINVESTMENTS | Allowirainvestments | NUMBER | 1 | FUNDDEMOGRAPHICSUPLOADTBL |
| CUSTODIAN | Custodian | VARCHAR2 | 12 | FUNDDEMOGRAPHICSUPLOADTBL |
| FUNDSUSPENDED | Fundsuspended | NUMBER | 1 | FUNDDEMOGRAPHICSUPLOADTBL |
| MINAMOUNT FORTAXIDINDV | Minamountfortaxidindv | NUMBER | 30 | FUNDDEMOGRAPHICSUPLOADTBL |
| MINAMOUNT FORTAXIDCOR | Minamountfortaxidcor | NUMBER | 30 | FUNDDEMOGRAPHICSUPLOADTBL |
| RECORD_ST AT | Record_Stat | CHAR | 1 | FUNDDEMOGRAPHICSUPLOADTBL |
| ONCE_AUTH | Once_Auth | CHAR | 1 | FUNDDEMOGRAPHICSUPLOADTBL |
| EXISTINGFUND | Existingfund | NUMBER | 1 | FUNDDEMOGRAPHICSUPLOADTBL |
| UMBRELLAFUND | Umbrellafund | NUMBER | 1 | FUNDDEMOGRAPHICSUPLOADTBL |
| HEDGEFUND | Hedgefund | VARCHAR2 | 1 | FUNDDEMOGRAPHICSUPLOADTBL |
| FUNDENABLED | Fundenabled | NUMBER | 1 | FUNDDEMOGRAPHICSUPLOADTBL |
| COEENABLED | Coeenabled | VARCHAR2 | 1 | FUNDDEMOGRAPHICSUPLOADTBL |
| LEGALENTIT Y | Legalentity | VARCHAR2 | 12 | FUNDDEMOGRAPHICSUPLOADTBL |
| FUNDCLOSEDDATE | Fundcloseddate | DATE | 7 | FUNDDEMOGRAPHICSUPLOADTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | TPRUPLOADTBL |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 22 | TPRUPLOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | TPRUPLOADTBL |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 50 | TPRUPLOADTBL |
| FUNDID | Fundid | VARCHAR2 | 6 | TPRUPLOADTBL |
| RULEEFFECTIVEDATE | Ruleeffectivedate | DATE | 7 | TPRUPLOADTBL |
| TRANSACTIONTYPE | Transactiontype | VARCHAR2 | 2 | TPRUPLOADTBL |
| TRANSACTIONSTARTDATE | Transactionstartdate | DATE | 7 | TPRUPLOADTBL |
| TRANSACTIONENDDATE | Transactionenddate | DATE | 7 | TPRUPLOADTBL |
| TRANSACTIONFREQUENCY | Transaction frequency | VARCHAR2 | 1 | TPRUPLOADTBL |
| TRANSAC TIONSTART PERIOD | Transaction startperiod | NUMBER | 22 | TPRUPLOADTBL |
| TRANSAC TIONEND PERIOD | Transactionendperiod | NUMBER | 22 | TPRUPLOADTBL |
| TRANSACTIONSTARTTIME | Transactionstarttime | DATE | 7 | TPRUPLOADTBL |
| TRANSACTIONENDTIME | Transactionendtime | DATE | 7 | TPRUPLOADTBL |
| MINTRANSACTIONAMOUNT | Mintransactionamount | NUMBER | 30 | TPRUPLOADTBL |
| STEPAMOUN T | Stepamount | NUMBER | 30 | TPRUPLOADTBL |
| MAXTRANSACTIONAMOUNT | Maxtransactionamount | NUMBER | 30 | TPRUPLOADTBL |
| MINTRANSACTIONUNITS | Mintransactionunits | NUMBER | 27 | TPRUPLOADTBL |
| STEPUNITS | Stepunits | NUMBER | 27 | TPRUPLOADTBL |
| MAXTRANSACTIONUNITS | Maxtransactionunits | NUMBER | 27 | TPRUPLOADTBL |
| ONLINEALLOCATION | Onlineallocation | NUMBER | 1 | TPRUPLOADTBL |
| ALLOCATIONPERVSREGCAPITAL | Allocationpervsregcapital | NUMBER | 20 | TPRUPLOADTBL |
| ALLOCATIONPOLICY | Allocationpolicy | VARCHAR2 | 1 | TPRUPLOADTBL |
| NOOFTXNALLOWEDFORFREQ | Nooftxnallowedforfreq | VARCHAR2 | 1 | TPRUPLOADTBL |
| NOOFTXNALLOWEDPERUH | Nooftxnallowedperuh | NUMBER | 22 | TPRUPLOADTBL |
| NOOFFREETXNALLOWEDPER UH | Nooffreetxnallowedperuh | NUMBER | 22 | TPRUPLOADTBL |
| ALLOWBACKDATING | Allowbackdating | NUMBER | 1 | TPRUPLOADTBL |
| BACKDATINGLIMIT | Backdatinglimit | NUMBER | 22 | TPRUPLOADTBL |
| FUNDTRANS ACTIONCOUNTER | Fundtransactioncounter | NUMBER | 22 | TPRUPLOADTBL |
| ACKNOWLEDGEMENTREQUIRED | Acknowledgementrequired | NUMBER | 1 | TPRUPLOADTBL |
| CONFIRMATIONREQUIRED | Confirmationrequired | NUMBER | 1 | TPRUPLOADTBL |
| BASEPRICEDEFINITION | Basepricedefinition | VARCHAR2 | 60 | TPRUPLOADTBL |
| BASEPRICEFACTOR | Basepricefactor | NUMBER | 7 | TPRUPLOADTBL |
| NOOFDECIMALSFORBASEPRICE | Noofdecimalsforbaseprice | NUMBER | 22 | TPRUPLOADTBL |
| ROUNDOFFTRUNCATEBASEP RICE | Roundofftruncatebaseprice | VARCHAR2 | 1 | TPRUPLOADTBL |
| TRANSACTIONENABLED | Transactionenabled | NUMBER | 1 | TPRUPLOADTBL |
| CROSSBRANCHALLOWED | Crossbranchallowed | NUMBER | 1 | TPRUPLOADTBL |
| PRICELAG | Pricelag | NUMBER | 22 | TPRUPLOADTBL |
| ALLOCATIONLAG | Allocationlag | NUMBER | 22 | TPRUPLOADTBL |
| CONFIRMATIONLAG | Confirmationlag | NUMBER | 22 | TPRUPLOADTBL |
| CHQALLOCONPARWITHCASH | Chqalloconparwithcash | NUMBER | 1 | TPRUPLOADTBL |
| HOLDINGPERIODAPPLICABLE | Holdingperiodapplicable | NUMBER | 1 | TPRUPLOADTBL |
| RETAINAGEINGTOSUBSCRIPTION | Retainageingtosubscription | NUMBER | 1 | TPRUPLOADTBL |
| CREDITCARDALLOCONPARWIT HCASH | Creditcardalloconparwithcash | NUMBER | 1 | TPRUPLOADTBL |
| LIMITREDEMPTIONMODE | Limitredemptionmode | VARCHAR2 | 1 | TPRUPLOADTBL |
| NATUREOFLIMIT | Natureoflimit | VARCHAR2 | 1 | TPRUPLOADTBL |
| TRANSFERALLOCONPARWITHCA SH | Transferalloconparwithcash | NUMBER | 1 | TPRUPLOADTBL |
| GROSSAMOUNT | Grossamount | VARCHAR2 | 1 | TPRUPLOADTBL |
| GROSSUNITS | Grossunits | VARCHAR2 | 1 | TPRUPLOADTBL |
| NETAMOUNT | Netamount | VARCHAR2 | 1 | TPRUPLOADTBL |
| NETUNITS | Netunits | VARCHAR2 | 1 | TPRUPLOADTBL |
| MININITIALTXNAMOUNT | Mininitialtxnamount | NUMBER | 30 | TPRUPLOADTBL |
| MININI TIALTXNUNITS | Mininitialtxnunits | NUMBER | 27 | TPRUPLOADTBL |
| MINSITXNAMOUNT | Minsitxnamount | NUMBER | 30 | TPRUPLOADTBL |
| MAXSITXNAMOUNT | Maxsitxnamount | NUMBER | 30 | TPRUPLOADTBL |
| MINSITXNUNITS | Minsitxnunits | NUMBER | 27 | TPRUPLOADTBL |
| MAXSITXNUNITS | Maxsitxnunits | NUMBER | 27 | TPRUPLOADTBL |
| EXISTINGUH | Existinguh | VARCHAR2 | 2 | TPRUPLOADTBL |
| NOOFDECIMALSFORUNITPRICE | Noofdecimalsforunitprice | NUMBER | 22 | TPRUPLOADTBL |
| ROUND OFFTRUN CATEUNITP RICE | Roundofftruncateunitprice | VARCHAR2 | 1 | TPRUPLOADTBL |
| ROUNDOFFTRUNCATEUNITS | Roundofftruncateunits | VARCHAR2 | 1 | TPRUPLOADTBL |
| PAYMENTLAG | Paymentlag | NUMBER | 22 | TPRUPLOADTBL |
| TRANSACTIONCUTOFFTIME | Transactioncutofftime | DATE | 7 | TPRUPLOADTBL |
| ENFORCEHOLDINGPERIOD | Enforceholdingperiod | NUMBER | 1 | TPRUPLOADTBL |
| APPLYENTRYTIMELOAD | Applyentrytimeload | NUMBER | 1 | TPRUPLOADTBL |
| IPOMAXISSUESIZE | Ipomaxissuesize | NUMBER | 27 | TPRUPLOADTBL |
| FLUCTUATIONALLOWED | Fluctuationallowed | NUMBER | 5 | TPRUPLOADTBL |
| TRANSACTIONSUSPENDED | Transactionsuspended | NUMBER | 1 | TPRUPLOADTBL |
| MINSIHOLDINGAMOUNT | Minsiholdingamount | NUMBER | 30 | TPRUPLOADTBL |
| MINSIHOLDINGUNITS | Minsiholdingunits | NUMBER | 27 | TPRUPLOADTBL |
| MINSIHOLDINGAPPLYFOR | Minsiholdingapplyfor | VARCHAR2 | 1 | TPRUPLOADTBL |
| MINSIHOLDINGINDICATOR | Minsiholdingindicator | VARCHAR2 | 1 | TPRUPLOADTBL |
| PRICELAGCALENDARBASIS | Pricelagcalendarbasis | VARCHAR2 | 1 | TPRUPLOADTBL |
| ALLOCLAGCALENDARBASIS | Alloclagcalendarbasis | VARCHAR2 | 1 | TPRUPLOADTBL |
| SIDESCRIPTION | Sidescription | VARCHAR2 | 255 | TPRUPLOADTBL |
| SIHOLIDAYRULE | Siholidayrule | VARCHAR2 | 1 | TPRUPLOADTBL |
| SICALENDERBASIS | Sicalenderbasis | VARCHAR2 | 1 | TPRUPLOADTBL |
| SIGENDAY | Sigenday | VARCHAR2 | 3 | TPRUPLOADTBL |
| SIFREQUENCY | Sifrequency | VARCHAR2 | 1 | TPRUPLOADTBL |
| SIGENCYCLE | Sigencycle | VARCHAR2 | 1 | TPRUPLOADTBL |
| SICUTOFFDAY | Sicutoffday | NUMBER | 22 | TPRUPLOADTBL |
| SICUTOFFLAG | Sicutofflag | NUMBER | 22 | TPRUPLOADTBL |
| ENFORCESIRULE | Enforcesirule | NUMBER | 22 | TPRUPLOADTBL |
| PAYMENTLAGCALENDARBASIS | Paymentlagcalendarbasis | VARCHAR2 | 1 | TPRUPLOADTBL |
| LINKTOUNSETTLEDINFLOWS | Linktounsettledinflows | NUMBER | 1 | TPRUPLOADTBL |
| PSEUDOSWITCHLAG | Pseudoswitchlag | NUMBER | 22 | TPRUPLOADTBL |
| ALLOWSYSTEMATICPLANS | Allowsystematicplans | NUMBER | 1 | TPRUPLOADTBL |
| MAXINITIALTXNAMOUNT | Maxinitialtxnamount | NUMBER | 30 | TPRUPLOADTBL |
| MAXINITIALTXNUNITS | Maxinitialtxnunits | NUMBER | 27 | TPRUPLOADTBL |
| PSEUDOSWITCHLAGCALEND ARBASIS | Pseudoswitchlagcalendarbasi s | VARCHAR2 | 1 | TPRUPLOADTBL |
| FULLOUTFLOW | Fulloutflow | NUMBER | 1 | TPRUPLOADTBL |
| MAXNOOFSITRANSACTIONS | Maxnoofsitransactions | NUMBER | 4 | TPRUPLOADTBL |
| MAXVALIDITY | Maxvalidity | NUMBER | 4 | TPRUPLOADTBL |
| SILEADTIME | Sileadtime | NUMBER | 22 | TPRUPLOADTBL |
| APPLICABLEACCOUNTTYPE S | Applicableaccounttypes | VARCHAR2 | 255 | TPRUPLOADTBL |
| INFLOWOVERRIDABLEMSG | Inflowoverridablemsg | NUMBER | 1 | TPRUPLOADTBL |
| MINMATURITYPERIOD | Minmaturityperiod | NUMBER | 4 | TPRUPLOADTBL |
| MAXMATURITYPERIOD | Maxmaturityperiod | NUMBER | 4 | TPRUPLOADTBL |
| FUTUREDATELIMIT | Futuredatelimit | NUMBER | 22 | TPRUPLOADTBL |
| UHCALENDARBASIS | Uhcalendarbasis | VARCHAR2 | 1 | TPRUPLOADTBL |
| NOOFDECIMALSFORUNITS | Noofdecimalsforunits | NUMBER | 22 | TPRUPLOADTBL |
| NOTICEPERIODDATEBASIS | Noticeperioddatebasis | VARCHAR2 | 1 | TPRUPLOADTBL |
| NOTICEPERIOD | Noticeperiod | NUMBER | 3 | TPRUPLOADTBL |
| SIAUTOTERMINATIONCOUNTER | Siautoterminationcounter | NUMBER | 3 | TPRUPLOADTBL |
| THRESHOLDAMOUNT | Thresholdamount | NUMBER | 30 | TPRUPLOADTBL |
| CONSSIAUTOCOUNTE R | Conssiautocounter | NUMBER | 3 | TPRUPLOADTBL |
| MAXSITXNSALLOWED | Maxsitxnsallowed | NUMBER | 3 | TPRUPLOADTBL |
| STARTTIME | Starttime | VARCHAR2 | 8 | TPRUPLOADTBL |
| ENDTIME | Endtime | VARCHAR2 | 8 | TPRUPLOADTBL |
| CUTOFFTIME | Cutofftime | VARCHAR2 | 8 | TPRUPLOADTBL |
| GOCUTOFFLAG | Gocutofflag | VARCHAR2 | 8 | TPRUPLOADTBL |
| GOTHRESHOLDUNITS | Gothresholdunits | NUMBER | 27 | TPRUPLOADTBL |
| GOSETTLEMENTLAG | Gosettlementlag | NUMBER | 22 | TPRUPLOADTBL |
| GOSETTLAGCALENDAR | Gosettlagcalendar | VARCHAR2 | 1 | TPRUPLOADTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | FUNDLOADUP LOADTBL |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 22 | FUNDLOADUP LOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | FUNDLOADUP LOADTBL |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 50 | FUNDLOADUP LOADTBL |
| FUNDID | Fundid | VARCHAR2 | 6 | FUNDLOADUP LOADTBL |
| RULEEFFECTIVEDATE | Ruleeffectivedate | DATE | 7 | FUNDLOADUP LOADTBL |
| TRANSACTIONTYPE | Transactiontype | VARCHAR2 | 2 | FUNDLOADUP LOADTBL |
| LOADID | Loadid | NUMBER | 5 | FUNDLOADUP LOADTBL |
| LOADTOPRICE | Loadtoprice | NUMBER | 22 | FUNDLOADUP LOADTBL |
| FROMENTITYTYPE | Fromentitytype | VARCHAR2 | 1 | FUNDLOADUP LOADTBL |
| TOENTITYTYPE | Toentitytype | VARCHAR2 | 1 | FUNDLOADUP LOADTBL |
| PROCESSINGFREQ | Processingfreq | VARCHAR2 | 1 | FUNDLOADUP LOADTBL |
| GLACCOUNTCODE | Glaccountcode | VARCHAR2 | 10 | FUNDLOADUP LOADTBL |
| DEBITORCREDIT | Debitorcredit | VARCHAR2 | 1 | FUNDLOADUP LOADTBL |
| CONTRAACCOUNTCODE | Contraaccountcode | VARCHAR2 | 10 | FUNDLOADUP LOADTBL |
| NOOFDECIMALSFORLOAD | Noofdecimalsforload | NUMBER | 1 | FUNDLOADUP LOADTBL |
| ROUNDOFFTRUNCATEFORLO AD | Roundofftruncateforload | VARCHAR2 | 1 | FUNDLOADUP LOADTBL |
| MANDATORY | Mandatory | VARCHAR2 | 1 | FUNDLOADUP LOADTBL |
| PRIORITYNO | Priorityno | NUMBER | 22 | FUNDLOADUP LOADTBL |
| LOADVATTOPRICE | Loadvattoprice | NUMBER | 22 | FUNDLOADUP LOADTBL |
| APPLYRETVALON | Applyretvalon | VARCHAR2 | 1 | FUNDLOADUP LOADTBL |
| SENDFORGLINTERFACE | Sendforglinterface | NUMBER | 1 | FUNDLOADUP LOADTBL |
| REFTYPE | Reftype | VARCHAR2 | 4 | FUNDLOADUP LOADTBL |
| DIFFERENTIALFEE | Differentialfee | NUMBER | 1 | FUNDLOADUP LOADTBL |
| SLABBASIS | Slabbasis | VARCHAR2 | 1 | FUNDLOADUP LOADTBL |
| PRICEADDIN | Priceaddin | NUMBER | 1 | FUNDLOADUP LOADTBL |
| GROUPID | Groupid | VARCHAR2 | 6 | FUNDLOADUP LOADTBL |
| INDEXATIONONCGT | Indexationoncgt | VARCHAR2 | 1 | FUNDLOADUP LOADTBL |
| LEVELID | Levelid | NUMBER | 22 | FUNDLOADUP LOADTBL |
| DEPENDENT LEVEL | Dependentlevel | NUMBER | 22 | FUNDLOADUP LOADTBL |
| FDAPINCOME | Fdapincome | NUMBER | 1 | FUNDLOADUP LOADTBL |
Parent topic: Fund Export