1.66.2 Asset Import from TA
This topic provides detailed information on the Asset Import from TA for segment identification numbers.
Table 1-202 Asset Import from TA
| Field name | Description | Data type | Length | Table Name |
|---|---|---|---|---|
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_ASSETUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 22 | PATB_ASSETUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_ASSETUPLOAD |
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PATB_ASSETUPLOAD |
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PATB_ASSETUPLOAD |
| IMPORTFILENAME | Importfilename | VARCHAR2 | 255 | PATB_ASSETUPLOAD |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 50 | PATB_ASSETUPLOAD |
| FUNDID | Fundid | VARCHAR2 | 6 | PATB_ASSETUPLOAD |
| RULEEFFECTIVEDATE | Ruleeffectivedate | DATE | 7 | PATB_ASSETUPLOAD |
| AUTH_STAT | Auth_Stat | VARCHAR2 | 1 | PATB_ASSETUPLOAD |
| FUNDSTARTDATE | Fundstartdate | DATE | 7 | PATB_ASSETUPLOAD |
| FUNDNAME | Fundname | VARCHAR2 | 60 | PATB_ASSETUPLOAD |
| FUNDNAMESHORT | Fundnameshort | VARCHAR2 | 90 | PATB_ASSETUPLOAD |
| FUNDCLASS | Fundclass | VARCHAR2 | 1 | PATB_ASSETUPLOAD |
| FUNDTYPE | Fundtype | NUMBER | 38 | PATB_ASSETUPLOAD |
| FUNDFAMILY | Fundfamily | VARCHAR2 | 6 | PATB_ASSETUPLOAD |
| FUNDBASECURRENCY | Fundbasecurrency | VARCHAR2 | 3 | PATB_ASSETUPLOAD |
| FUNDCOUNTRY | Fundcountry | VARCHAR2 | 3 | PATB_ASSETUPLOAD |
| FISCALSTARTYEAR | Fiscalstartyear | DATE | 7 | PATB_ASSETUPLOAD |
| FISCALENDYEAR | Fiscalendyear | DATE | 7 | PATB_ASSETUPLOAD |
| AMCID | Amcid | VARCHAR2 | 12 | PATB_ASSETUPLOAD |
| BROKERSALLOWED | Brokersallowed | DATE | 1 | PATB_ASSETUPLOAD |
| REGISTRARID | Registrarid | VARCHAR2 | 12 | PATB_ASSETUPLOAD |
| TRUSTEEID | Trusteeid | VARCHAR2 | 12 | PATB_ASSETUPLOAD |
| LATESTRULE | Latestrule | NUMBER | 1 | PATB_ASSETUPLOAD |
| MOD_NO | Mod_No | NUMBER | 22 | PATB_ASSETUPLOAD |
| MAKER_ID | Maker_Id | VARCHAR2 | 320 | PATB_ASSETUPLOAD |
| MAKER_DT_STAMP | Maker_Dt_Stamp | DATE | 7 | PATB_ASSETUPLOAD |
| CHECKER_ID | Checker_Id | VARCHAR2 | 320 | PATB_ASSETUPLOAD |
| CHECKER_DT_STAMP | Checker_Dt_Stamp | DATE | 7 | PATB_ASSETUPLOAD |
| MINHOLDINGPERIOD | Minholdingperiod | NUMBER | 22 | PATB_ASSETUPLOAD |
| PRIMARYREGADDRESS | Primaryregaddress | VARCHAR2 | 255 | PATB_ASSETUPLOAD |
| FUNDTAXID | Fundtaxid | VARCHAR2 | 25 | PATB_ASSETUPLOAD |
| FUNDIDENTIFICATIONNUMBER | Fundidentificationnumber | VARCHAR2 | 25 | PATB_ASSETUPLOAD |
| FUNDTICKERSYMBOL | Fundtickersymbol | VARCHAR2 | 25 | PATB_ASSETUPLOAD |
| ALLOWIRAINVESTMENTS | Allowirainvestments | NUMBER | 1 | PATB_ASSETUPLOAD |
| CUSTODIAN | Custodian | VARCHAR2 | 12 | PATB_ASSETUPLOAD |
| FUNDSUSPENDED | Fundsuspended | NUMBER | 1 | PATB_ASSETUPLOAD |
| MINAMOUNTFORTAXIDINDV | Minamountfortaxidindv | NUMBER | 30 | PATB_ASSETUPLOAD |
| MINAMOUNTFORTAXIDCOR | Minamountfortaxidcor | NUMBER | 30 | PATB_ASSETUPLOAD |
| RECORD_STAT | Record_Stat | CHAR | 1 | PATB_ASSETUPLOAD |
| ONCE_AUTH | Once_Auth | CHAR | 1 | PATB_ASSETUPLOAD |
| EXISTINGFUND | Existingfund | NUMBER | 1 | PATB_ASSETUPLOAD |
| UMBRELLAFUND | Umbrellafund | NUMBER | 1 | PATB_ASSETUPLOAD |
| HEDGEFUND | Hedgefund | VARCHAR2 | 1 | PATB_ASSETUPLOAD |
| FUNDENABLED | Fundenabled | NUMBER | 1 | PATB_ASSETUPLOAD |
| COEENABLED | Coeenabled | VARCHAR2 | 1 | PATB_ASSETUPLOAD |
| LEGALENTITY | Legalentity | VARCHAR2 | 12 | PATB_ASSETUPLOAD |
| FUNDCLOSEDDATE | Fundcloseddate | DATE | 7 | PATB_ASSETUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_ASSETTPRUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 22 | PATB_ASSETTPRUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_ASSETTPRUPLOAD |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 50 | PATB_ASSETTPRUPLOAD |
| FUNDID | Fundid | VARCHAR2 | 6 | PATB_ASSETTPRUPLOAD |
| RULEEFFECTIVEDATE | Ruleeffectivedate | DATE | 7 | PATB_ASSETTPRUPLOAD |
| TRANSACTIONTYPE | Transactiontype | VARCHAR2 | 2 | PATB_ASSETTPRUPLOAD |
| TRANSACTIONSTARTDATE | Transactionstartdate | DATE | 7 | PATB_ASSETTPRUPLOAD |
| TRANSACTIONENDDATE | Transactionenddate | DATE | 7 | PATB_ASSETTPRUPLOAD |
| TRANSACTIONFREQUENCY | Transactionfrequency | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| TRANSACTIONSTARTPERIOD | Transactionstartperiod | NUMBER | 22 | PATB_ASSETTPRUPLOAD |
| TRANSACTIONENDPERIOD | Transactionendperiod | NUMBER | 22 | PATB_ASSETTPRUPLOAD |
| TRANSACTIONSTARTTIME | Transactionstarttime | DATE | 7 | PATB_ASSETTPRUPLOAD |
| TRANSACTIONENDTIME | Transactionendtime | DATE | 7 | PATB_ASSETTPRUPLOAD |
| MINTRANSACTIONAMOUNT | Mintransactionamount | NUMBER | 30 | PATB_ASSETTPRUPLOAD |
| STEPAMOUNT | Stepamount | NUMBER | 30 | PATB_ASSETTPRUPLOAD |
| MAXTRANSACTIONAMOUNT | Maxtransactionamount | NUMBER | 30 | PATB_ASSETTPRUPLOAD |
| MINTRANSACTIONUNITS | Mintransactionunits | NUMBER | 27 | PATB_ASSETTPRUPLOAD |
| STEPUNITS | Stepunits | NUMBER | 27 | PATB_ASSETTPRUPLOAD |
| MAXTRANSACTIONUNITS | Maxtransactionunits | NUMBER | 27 | PATB_ASSETTPRUPLOAD |
| ONLINEALLOCATION | Onlineallocation | NUMBER | 1 | PATB_ASSETTPRUPLOAD |
| ALLOCATIONPERVSREGCAPITAL | Allocationpervsregcapital | NUMBER | 20 | PATB_ASSETTPRUPLOAD |
| ALLOCATIONPOLICY | Allocationpolicy | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| NOOFTXNALLOWEDFORFREQ | Nooftxnallowedforfreq | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| NOOFTXNALLOWEDPERUH | Nooftxnallowedperuh | NUMBER | 22 | PATB_ASSETTPRUPLOAD |
| NOOFFREETXNALLOWEDPERUH | Nooffreetxnallowedperuh | NUMBER | 22 | PATB_ASSETTPRUPLOAD |
| ALLOWBACKDATING | Allowbackdating | NUMBER | 1 | PATB_ASSETTPRUPLOAD |
| BACKDATINGLIMIT | Backdatinglimit | NUMBER | 22 | PATB_ASSETTPRUPLOAD |
| FUNDTRANSACTIONCOUNTER | Fundtransactioncounter | NUMBER | 22 | PATB_ASSETTPRUPLOAD |
| ACKNOWLEDGEMENTREQUIRED | Acknowledgementrequired | NUMBER | 1 | PATB_ASSETTPRUPLOAD |
| CONFIRMATIONREQUIRED | Confirmationrequired | NUMBER | 1 | PATB_ASSETTPRUPLOAD |
| BASEPRICEDEFINITION | Basepricedefinition | VARCHAR2 | 60 | PATB_ASSETTPRUPLOAD |
| BASEPRICEFACTOR | Basepricefactor | NUMBER | 7 | PATB_ASSETTPRUPLOAD |
| NOOFDECIMALSFORBASEPRICE | Noofdecimalsforbaseprice | NUMBER | 22 | PATB_ASSETTPRUPLOAD |
| ROUNDOFFTRUNCATEBASEPRICE | Roundofftruncatebaseprice | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| TRANSACTIONENABLED | Transactionenabled | NUMBER | 1 | PATB_ASSETTPRUPLOAD |
| CROSSBRANCHALLOWED | Crossbranchallowed | NUMBER | 1 | PATB_ASSETTPRUPLOAD |
| PRICELAG | Pricelag | NUMBER | 22 | PATB_ASSETTPRUPLOAD |
| ALLOCATIONLAG | Allocationlag | NUMBER | 22 | PATB_ASSETTPRUPLOAD |
| CONFIRMATIONLAG | Confirmationlag | NUMBER | 22 | PATB_ASSETTPRUPLOAD |
| CHQALLOCONPARWITHCASH | Chqalloconparwithcash | NUMBER | 1 | PATB_ASSETTPRUPLOAD |
| HOLDINGPERIODAPPLICABLE | Holdingperiodapplicable | NUMBER | 1 | PATB_ASSETTPRUPLOAD |
| RETAINAGEINGTOSUBSCRIPTION | Retainageingtosubscription | NUMBER | 1 | PATB_ASSETTPRUPLOAD |
| CREDITCARDALLOCONPARWITHCASH | Creditcardalloconparwithcash | NUMBER | 1 | PATB_ASSETTPRUPLOAD |
| LIMITREDEMPTIONMODE | Limitredemptionmode | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| NATUREOFLIMIT | Natureoflimit | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| TRANSFERALLOCONPARWITHCASH | Transferalloconparwithcash | NUMBER | 1 | PATB_ASSETTPRUPLOAD |
| GROSSAMOUNT | Grossamount | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| GROSSUNITS | Grossunits | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| NETAMOUNT | Netamount | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| NETUNITS | Netunits | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| MININITIALTXNAMOUNT | Mininitialtxnamount | NUMBER | 30 | PATB_ASSETTPRUPLOAD |
| MININITIALTXNUNITS | Mininitialtxnunits | NUMBER | 27 | PATB_ASSETTPRUPLOAD |
| MINSITXNAMOUNT | Minsitxnamount | NUMBER | 30 | PATB_ASSETTPRUPLOAD |
| MAXSITXNAMOUNT | Maxsitxnamount | NUMBER | 30 | PATB_ASSETTPRUPLOAD |
| MINSITXNUNITS | Minsitxnunits | NUMBER | 27 | PATB_ASSETTPRUPLOAD |
| MAXSITXNUNITS | Maxsitxnunits | NUMBER | 27 | PATB_ASSETTPRUPLOAD |
| EXISTINGUH | Existinguh | VARCHAR2 | 2 | PATB_ASSETTPRUPLOAD |
| NOOFDECIMALSFORUNITPRICE | Noofdecimalsforunitprice | NUMBER | 22 | PATB_ASSETTPRUPLOAD |
| ROUNDOFFTRUNCATEUNITPRICE | Roundofftruncateunitprice | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| ROUNDOFFTRUNCATEUNITS | Roundofftruncateunits | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| PAYMENTLAG | Paymentlag | NUMBER | 22 | PATB_ASSETTPRUPLOAD |
| TRANSACTIONCUTOFFTIME | Transactioncutofftime | DATE | 7 | PATB_ASSETTPRUPLOAD |
| ENFORCEHOLDINGPERIOD | Enforceholdingperiod | NUMBER | 1 | PATB_ASSETTPRUPLOAD |
| APPLYENTRYTIMELOAD | Applyentrytimeload | NUMBER | 1 | PATB_ASSETTPRUPLOAD |
| IPOMAXISSUESIZE | Ipomaxissuesize | NUMBER | 27 | PATB_ASSETTPRUPLOAD |
| FLUCTUATIONALLOWED | Fluctuationallowed | NUMBER | 5 | PATB_ASSETTPRUPLOAD |
| TRANSACTIONSUSPENDED | Transactionsuspended | NUMBER | 1 | PATB_ASSETTPRUPLOAD |
| MINSIHOLDINGAMOUNT | Minsiholdingamount | NUMBER | 30 | PATB_ASSETTPRUPLOAD |
| MINSIHOLDINGUNITS | Minsiholdingunits | NUMBER | 27 | PATB_ASSETTPRUPLOAD |
| MINSIHOLDINGAPPLYFOR | Minsiholdingapplyfor | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| MINSIHOLDINGINDICATOR | Minsiholdingindicator | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| PRICELAGCALENDARBASIS | Pricelagcalendarbasis | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| ALLOCLAGCALENDARBASIS | Alloclagcalendarbasis | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| SIDESCRIPTION | Sidescription | VARCHAR2 | 255 | PATB_ASSETTPRUPLOAD |
| SIHOLIDAYRULE | Siholidayrule | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| SICALENDERBASIS | Sicalenderbasis | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| SIGENDAY | Sigenday | VARCHAR2 | 3 | PATB_ASSETTPRUPLOAD |
| SIFREQUENCY | Sifrequency | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| SIGENCYCLE | Sigencycle | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| SICUTOFFDAY | Sicutoffday | NUMBER | 22 | PATB_ASSETTPRUPLOAD |
| SICUTOFFLAG | Sicutofflag | NUMBER | 22 | PATB_ASSETTPRUPLOAD |
| ENFORCESIRULE | Enforcesirule | NUMBER | 22 | PATB_ASSETTPRUPLOAD |
| PAYMENTLAGCALENDARBASIS | Paymentlagcalendarbasis | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| LINKTOUNSETTLEDINFLOWS | Linktounsettledinflows | NUMBER | 1 | PATB_ASSETTPRUPLOAD |
| PSEUDOSWITCHLAG | Pseudoswitchlag | NUMBER | 22 | PATB_ASSETTPRUPLOAD |
| ALLOWSYSTEMATICPLANS | Allowsystematicplans | NUMBER | 1 | PATB_ASSETTPRUPLOAD |
| MAXINITIALTXNAMOUNT | Maxinitialtxnamount | NUMBER | 30 | PATB_ASSETTPRUPLOAD |
| MAXINITIALTXNUNITS | Maxinitialtxnunits | NUMBER | 27 | PATB_ASSETTPRUPLOAD |
| PSEUDOSWITCHLAGCALENDARBASI S | Pseudoswitchlagcalendarbasis | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| FULLOUTFLOW | Fulloutflow | NUMBER | 1 | PATB_ASSETTPRUPLOAD |
| MAXNOOFSITRANSACTIONS | Maxnoofsitransactions | NUMBER | 4 | PATB_ASSETTPRUPLOAD |
| MAXVALIDITY | Maxvalidity | NUMBER | 4 | PATB_ASSETTPRUPLOAD |
| SILEADTIME | Sileadtime | NUMBER | 22 | PATB_ASSETTPRUPLOAD |
| APPLICABLEACCOUNTTYPES | Applicableaccounttypes | VARCHAR2 | 255 | PATB_ASSETTPRUPLOAD |
| INFLOWOVERRIDABLEMSG | Inflowoverridablemsg | NUMBER | 1 | PATB_ASSETTPRUPLOAD |
| MINMATURITYPERIOD | Minmaturityperiod | NUMBER | 4 | PATB_ASSETTPRUPLOAD |
| MAXMATURITYPERIOD | Maxmaturityperiod | NUMBER | 4 | PATB_ASSETTPRUPLOAD |
| FUTUREDATELIMIT | Futuredatelimit | NUMBER | 22 | PATB_ASSETTPRUPLOAD |
| UHCALENDARBASIS | Uhcalendarbasis | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| NOOFDECIMALSFORUNITS | Noofdecimalsforunits | NUMBER | 22 | PATB_ASSETTPRUPLOAD |
| NOTICEPERIODDATEBASIS | Noticeperioddatebasis | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| NOTICEPERIOD | Noticeperiod | NUMBER | 3 | PATB_ASSETTPRUPLOAD |
| SIAUTOTERMINATIONCOUNTER | Siautoterminationcounter | NUMBER | 3 | PATB_ASSETTPRUPLOAD |
| THRESHOLDAMOUNT | Thresholdamount | NUMBER | 30 | PATB_ASSETTPRUPLOAD |
| CONSSIAUTOCOUNTER | Conssiautocounter | NUMBER | 3 | PATB_ASSETTPRUPLOAD |
| MAXSITXNSALLOWED | Maxsitxnsallowed | NUMBER | 3 | PATB_ASSETTPRUPLOAD |
| STARTTIME | Starttime | VARCHAR2 | 8 | PATB_ASSETTPRUPLOAD |
| ENDTIME | Endtime | VARCHAR2 | 8 | PATB_ASSETTPRUPLOAD |
| CUTOFFTIME | Cutofftime | VARCHAR2 | 8 | PATB_ASSETTPRUPLOAD |
| GOCUTOFFLAG | Gocutofflag | VARCHAR2 | 8 | PATB_ASSETTPRUPLOAD |
| GOTHRESHOLDUNITS | Gothresholdunits | NUMBER | 27 | PATB_ASSETTPRUPLOAD |
| GOSETTLEMENTLAG | Gosettlementlag | NUMBER | 22 | PATB_ASSETTPRUPLOAD |
| GOSETTLAGCALENDAR | Gosettlagcalendar | VARCHAR2 | 1 | PATB_ASSETTPRUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_ASSETLOADUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 22 | PATB_ASSETLOADUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_ASSETLOADUPLOAD |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 50 | PATB_ASSETLOADUPLOAD |
| FUNDID | Fundid | VARCHAR2 | 6 | PATB_ASSETLOADUPLOAD |
| RULEEFFECTIVEDATE | Ruleeffectivedate | DATE | 7 | PATB_ASSETLOADUPLOAD |
| TRANSACTIONTYPE | Transactiontype | VARCHAR2 | 2 | PATB_ASSETLOADUPLOAD |
| LOADID | Loadid | NUMBER | 5 | PATB_ASSETLOADUPLOAD |
| LOADTOPRICE | Loadtoprice | NUMBER | 22 | PATB_ASSETLOADUPLOAD |
| FROMENTITYTYPE | Fromentitytype | VARCHAR2 | 1 | PATB_ASSETLOADUPLOAD |
| TOENTITYTYPE | Toentitytype | VARCHAR2 | 1 | PATB_ASSETLOADUPLOAD |
| PROCESSINGFREQ | Processingfreq | VARCHAR2 | 1 | PATB_ASSETLOADUPLOAD |
| GLACCOUNTCODE | Glaccountcode | VARCHAR2 | 10 | PATB_ASSETLOADUPLOAD |
| DEBITORCREDIT | Debitorcredit | VARCHAR2 | 1 | PATB_ASSETLOADUPLOAD |
| CONTRAACCOUNTCODE | Contraaccountcode | VARCHAR2 | 10 | PATB_ASSETLOADUPLOAD |
| NOOFDECIMALSFORLOAD | Noofdecimalsforload | NUMBER | 1 | PATB_ASSETLOADUPLOAD |
| ROUNDOFFTRUNCATEFORLOAD | Roundofftruncateforload | VARCHAR2 | 1 | PATB_ASSETLOADUPLOAD |
| MANDATORY | Mandatory | VARCHAR2 | 1 | PATB_ASSETLOADUPLOAD |
| PRIORITYNO | Priorityno | NUMBER | 22 | PATB_ASSETLOADUPLOAD |
| LOADVATTOPRICE | Loadvattoprice | NUMBER | 22 | PATB_ASSETLOADUPLOAD |
| APPLYRETVALON | Applyretvalon | VARCHAR2 | 1 | PATB_ASSETLOADUPLOAD |
| SENDFORGLINTERFACE | Sendforglinterface | NUMBER | 1 | PATB_ASSETLOADUPLOAD |
| REFTYPE | Reftype | VARCHAR2 | 4 | PATB_ASSETLOADUPLOAD |
| DIFFERENTIALFEE | Differentialfee | NUMBER | 1 | PATB_ASSETLOADUPLOAD |
| SLABBASIS | Slabbasis | VARCHAR2 | 1 | PATB_ASSETLOADUPLOAD |
| PRICEADDIN | Priceaddin | NUMBER | 1 | PATB_ASSETLOADUPLOAD |
| GROUPID | Groupid | VARCHAR2 | 6 | PATB_ASSETLOADUPLOAD |
| INDEXATIONONCGT | Indexationoncgt | VARCHAR2 | 1 | PATB_ASSETLOADUPLOAD |
| LEVELID | Levelid | NUMBER | 22 | PATB_ASSETLOADUPLOAD |
| DEPENDENTLEVEL | Dependentlevel | NUMBER | 22 | PATB_ASSETLOADUPLOAD |
| FDAPINCOME | Fdapincome | NUMBER | 1 | PATB_ASSETLOADUPLOAD |
Parent topic: Asset Import from TA