Home

Upload Format - Oracle Documentation

1. UPLOADMODE VARCHAR2 1 Mandatory N for new transactions P for amended transactions and D for transactions to be deleted TRANSACTION VARCHAR2 16 Mandatory Transaction Number NUMBER REFERENCENU VARCHAR2 12 Mandatory Transaction Ref Number MBER OTHERINFO1 VARCHAR2 60 Optional Txn Add Info 1 OTHERINFO2 VARCHAR2 60 Optional Txn Add Info 2 OTHERINFO3 VARCHAR2 60 Optional Txn Add Info 3 OTHERINFO4 VARCHAR2 60 Optional Txn Add Info 4 OTHERINFOS5 VARCHAR2 60 Optional Txn Add Info 5 OTHERINFO6 VARCHAR2 60 Optional Txn Add Info 6 OTHERINFO7 VARCHAR2 60 Optional Txn Add Info 7 OTHERINFO8 VARCHAR2 60 Optional Txn Add Info 8 OTHERINFO9 VARCHAR2 60 Optional Txn Add Info 9 OTHERINFO10 VARCHAR2 60 Optional Txn Add Info 10 OTHERINFO11 VARCHAR2 60 Optional Txn Add Info 11 OTHERINFO12 VARCHAR2 60 Optional Txn Add Info 12 OTHERINFO13 VARCHAR2 60 Optional Txn Add Info 13 OTHERINFO14 VARCHAR2 60 Optional Txn Add Info 14 OTHERINFO15 VARCHAR2 60 Optional Txn Add Info 15 OTHERINFO16 VARCHAR2 60 Optional Txn Add Info 16 OTHERINFO17 VARCHAR2 60 Optional Txn Add Info 17 OTHERINFO18 VARCHAR2 60 Optional Txn Add Info 18 OTHERINFO19 VARCHAR2 60 Optional Txn Add Info 19 OTHERINFO20 VARCHAR2 60 Optional Txn Add Info 20 2 54 ORACLE OTHERINFO21 VARCHAR2 60 Optional Txn Add Info 21 OTHERINFO22 VARCHAR2 60 Optional
2. TaxYear The tax year applicable in Char 8 dd mm ccyy format TaxMonth Month of the year Char 2 PARM ProductCode Char 8 Agreement_Code Contract Number Char 12 The policy number Sequence Numeric Count Char 4 This fiekld will be ignored LOB Line of Business GAL Char 3 This field will be ignored Owner_Client_Id Client Number or Owner of the Char 9 The unitholder contract id in FCIS Tax_Number Nulls Char 12 TrustNumber Nulls Char 16 AnnuType C for compulsory V for voluntary Char 1 GN18 Yor N Char 1 FundName Nulls Char 30 Frequency Frequency of the annuity income Char 1 Payments_Left No of payments left within the tax Char 2 year TaxEarnings_YTD The taxable earning to date for the Char 16 tax year TAXDEDUCTED_YTD The tax deducted for that tax year Char 16 TaxEarnings Taxable earnings for this annuity Char 16 income TaxDeducted Tax to be deducted for that annuity Char 16 income Scheme Nulls Char 10 Tax_Recalc Tax amount that should be Char 16 deducted 3 103 ORACLE Tax_Deffer The difference between what should be deducted and what was calculated by the product admin system Char 16 the Old Mutual group Monthly_ Adjust Not applicable Char 16 Systemld The system ID as defined by the Char 10 tax aggregation module Tax_Remuneration The total taxable income across Char 16
3. Field Name Type Maximu Mandatory Characteristics Description m Optional Validations Length applicable 3 64 ORACLE SEGMENTID Alphanumeric 20 Mandatory Default value Standard value 11FLM of 11FLM to uniquely identify Fund load related information PROCESSID Alphanumeric 50 Mandatory Same value as This should in OOGEN identify the ProcessID upload uniquely This should also be unique within a file and it allows to identify imported records later FUNDID Alphanumeric 6 Mandatory The Fund ID is a unique Identification for each Fund and it indicates the fund for which Fund load information has to be uploaded RULEEFFECT Date 8 Mandatory The Fund ID The rule IVEDATE and Rule effective date effective date for which fund combination load should be the information for same as defined the fund has to in 01FDR be maintained TRANSACTIO Alphanumeric 2 Mandatory Valid values are This is to NTYPE from 01 to 10 indicate the ranging from transaction IPO to Re issue type for which the loads are being defined LOADID Number 5 Mandatory Valid load ID Specify the defined in the name of the system Load fee incentive that must be applied for the selected Fund 3 65 ORACLE LOADTOPRIC Number Optional Valid values are This is to E 0 and 1 indicate that this load is to be loa
4. Field Name Type Maximum Length Mandatory Optional MAXNOOFSITRANSACTIONS NUMBER 4 Optional MAXVALIDITY NUMBER 4 Optional Serial Number 20 Segment Identification Number 20HFP Description This segment is used for providing hedge fund parameters Segment Mandatory Optional Optional Field Name Type Maximum Length Mandatory Optional SegmentID VARCHAR2 20 Mandatory ProcessID VARCHAR2 50 Mandatory FundID VARCHAR2 6 Mandatory RuleEffectiveDate DATE 7 Mandatory HedgeFundType VARCHAR2 1 Mandatory HedgeFundManager VARCHAR2 12 Mandatory TxnGenerationBasis VARCHAR2 1 Optional MasterFundUHID VARCHAR2 12 Optional NoticePeriodforRed NUMBER 5 Optional ComputationMethod VARCHAR2 4 Optional RuleGroup ID VARCHAR2 10 Optional PerformancefeePer NUMBER 3 Optional AccrualFrequency VARCHAR2 1 Optional 3 83 ORACLE NextAccrualDate DATE 7 Optional PaymentFrequency VARCHAR2 1 Optional NextPaymentDate DATE 7 Optional HurdleRateApplicable VARCHAR2 1 Optional HurdleType VARCHAR2 1 Optional ResetHurdle VARCHAR2 1 Optional HurdleRateT ype VARCHAR2 1 Optional CalculationMethod VARCHAR2 1 Optional DayBasis VARCHAR2 1 Optional RateCode VARCHAR2 15 Optional RateBasis VARCHAR2 1 Optional Rate NUMBER 20 Optional Serial Number 21 Segment Identification Number 21HFL Description This segment is used for providin
5. IMPORTFILENA Alphanumeric 255 Mandatory This is the name of ME the file being uploaded into the FCIS system 3 3 ORACLE AMCID Alphanumeric Mandatory Valid authorized enabled AMC maintained in the system as a part of Entity Maintenance The fund rule upload defaulting would be based on both AMCID and the Bulk client code USERID Alphanumeric Mandatory The fund rule MakerID would have the value of UserID as a part of data storage in all the fund rule tables UPLOADMODE Alphanumeric a Mandatory Valid values are N and l Should be N for New fund rule and I for amending an existing authorized fund rule GENERATEAUT HFUNDRULE Alphanumeric a4 Optional Valid values are A and U This indicates whether the fund rule uploaded should be a authorized fund rule or un authorized fund rule 3 4 ORACLE N DEFAULTOPTIO Alphanumeric 15 Optional Valid values are Null which means No defaulting BULKCLI ENTCODE means defaulting informatio n based on Bulk Client code mentioned as a part of this segment existing valid template id based on which defaulting would happen needs to be any existing Serial Number 2 Segment Identification Number 01FDR Description This segment is used for providing Fund demographics related informa
6. Mandatory Either 0 or 1 to indicate if the bank details is default or not The default bank is considered as the one with the 1 value FUNDID String 6 Mandatory Fund ID If the fundid is null then system will default to ALL There is no specific value then mention ALL in the upload file TRANSACTIONTYPE Number 3 Mandatory Subscription 02 Redemption 03 IPO Subscription 01 If the Transaction type is null then system will default to ALL There is no specific value then mention ALL in the upload file UHBICCODE String 24 Optional Unit Holder s swift BIC Code SWIFTFORMAT String 6 Optional MT103 MT202 BANKCHARGED String 12 Optional Indicate whether the bank charges must be levied upon the beneficiary the remitter or must be shared between the two BENEFICIARY String 35 Optional Enter the name of the beneficiary BENEFICIARYADD1 String 35 Optional Enter the address line 1 of the beneficiary BENEFICIARYADD2 String 35 Optional Enter the address line 2 of the beneficiary BENEFICIARYADD3 String 35 Optional Enter the address line 3 of the beneficiary BENEFICIARYBICCODE String 24 Optional Beneficiary Bank Identifier Code BENEFICIARYACCTNO String 24 Optional Beneficiary Account Number an ORACLE BENEFICIARYCODE String 24 Optional Enter the code assigned to the beneficiary BENEFICIARYINFO S
7. The Control Record for the import of information pertaining to tax aggregation should be in the following format product admin system Field Name Description Data Remarks Type Record CONTROL Char 7 This field will be ignored Systemld The system ID as defined by the tax Char 10 This field will aggregation module be ignored Entries Number of entries on the file Number This field will 8 be ignored TaxEarnings YTD The taxable earning to date for the tax year Number This field will 13 2 be ignored TaxDeducted_YTD The tax deducted for that tax year Number This field will 13 2 be ignored TaxEarnings The taxable earnings for this annuity income Number This field will 13 2 be ignored TaxDeducted The tax to be deducted for that annuity Number This field will income 13 2 be ignored Tax_Recalc The tax amount that should be deducted Number This field will 13 2 be ignored Tax_Differ The difference between what should be Number This field will deducted and what was calculated by the 13 2 be ignored Monthly_ Adjust Not applicable 3 1 7 Agent Reference File 3 104 ORACLE The files uploaded using the Agent Reference File have to be imported and the broker details updated They should have the following format Field Name Format Comments Remarks Mapping Intermediary or Broker Char Intermediary Code and No Brok
8. If this is not specified in the import file it will be defaulted to initiating broker of unit holder 2 34 ORACLE PAYMENTMOD E String i Optional Indicates mode of payment Can be any of the following values Q Cheque T Transfer R Credit card C Cash D Draft CLEARINGDAT E Date Optional The date on which the check is expected to be cleared If specified in the import file it must not be earlier than the application date If not the system computes the same as a date Cheque Date Clearing Period and this computed date is considered by default to be the clearing date TRANSACTION CURRENCY String Optional A valid currency maintained in the system TRANSACTION MODE String i Optional Indicates the mode of the transaction Can be any of the following A Amount U Units P Percentage UNITSAPPLIED Number 15 6 Optional Mandatory if Transaction mode is Units Should be greater than 0 and not less than Min Transaction Units It should not exceed max Transaction Units specified for the Fund PERCENTAPPLI ED Number 5 2 Optional Mandatory if Transaction mode is percentage 2 35 ORACLE TOFUNDID String 25 Optional Valid fund maintained in the system to which the units are to be switched TOUNITHOLDE RID String 60 Optional Valid Unit holde
9. RECEIVED VARCHAR2 1 Optional 0 1 1 means KYC Doc Received RECIEVEDDAT DATE Optional If the received flag is 1 E then received date is mandatory Segment Identification Number O3AIF Transaction Add Info Information Field Name as Data type Field length Mandatory Values expected in the file SEGMENTID VARCHAR2 20 Mandatory SegmeniID is used for identifying the settlement details In this case Segment ID will be O1SET TXNSERIALNU NUMBER 10 Mandatory This number is used to MBER identify for which transaction this settlement details are used i e if the TxnSerialNumber of a transaction is 1 then the TxnSerialNumber should be same for the settlement details also SEQUENCENU NUMBER 10 Mandatory This is used for mentioning MBER the sequence for the settlement details of a transaction PROCESSID VARCHAR2 50 Mandatory This ID should be unique for each upload of transactions BULKCLIENTCO VARCHAR2 12 Mandatory All the defaults values for DE transaction will be taken up based on this Bulk Client Code IMPORTFILENA VARCHAR2 255 Optional File name should be the ME same as defined in File specifications of Interface definition AMCID VARCHAR2 12 Mandatory The ID of the AMC for which the bulk client has maintained the default details This should be same within a file for all the ae ORACLE records
10. CONTROL Char 7 This field will be set as CONTROL Systemld The system ID as defined by the Char 10 Will be set as FCIS tax aggregation module Entries Number of entries on the file Number The number of entries in 8 the file TaxEarnings YTD The taxable earning to date for Number The sum of all the the tax year 13 2 TaxEarnings_YTD in the file TaxDeducted_YTD The tax deducted for that tax Number The sum of all the year 13 2 TaxDeducted_YTD in the file TaxEarnings The taxable earnings for this Number The sum of all the annuity income 13 2 TaxEarnings in the file TaxDeducted The tax to be deducted for that Number The sum of all the annuity income 13 2 TaxDeducted in the file Tax_Recalc The tax amount that should be Number This will be set to null deducted 13 2 Tax_Differ The difference between what Number This will be set to null should be deducted and what 13 2 was calculated by the product admin system Monthly_ Adjust Not applicable This will be set to null The Record Specifications for the import of tax aggregation information into FCIS is as indicated below The import will only log the data in the designated tables of FCIS There is no processing carried out on the data imported Field Name Description Data Type Remarks GCS_CLNO The group client id Char 20 This field will be ignored 3 102 ORACLE
11. e Always contain the information in the exact format and serial order shown in the Field Name column with values according to the validations mentioned in the table below Field Name Data Field Mandatory Characteristi Values as expected type length cs rules in the file SEQUENCE Number 10 Mandatory System generated sequence NUMBER number for the records in the file PROCESSID String 50 Mandatory Process Id along with the system generated sequence number identifies the uploaded record uniquely Each file should have a unique process id BULKCLIEN String 12 Mandatory Value This is the bulk client code TCODE defaulted as maintained in Bulk client defaults in the absence of information in the file IMPORTFILE String 255 Mandatory Name of the file being NAME uploaded should be specified This should be unique within a file 2 84 ORACLE UPLOADMO String 1 Mandatory Should be N for New unit DE holder uploads and I for Information change AMCID String 12 Mandatory Value The Id of the AMC Distributor defaulted as for which the bulk client has maintained in maintained the default details Bulk client defaults in the absence of information in the file BROKERCO String 9 Mandatory Accepted from the user s DE specification for the same in the hand off file contents BROKERNA String 100 Mandatory Accepted from t
12. 36 Optional Used to capture the DIARYIBA INTERMEDIARYIBAN N SIPAYME NTREJEC TIONCOU NTER SIAUTOTE RMINATIO NCOUNTE R ae ORACLE BulkSIFundTbl field name as Data type Field length Mandatory Values expected in the file SEQUENCEN Number 10 Mandatory System generated UMBER sequence number for the records in the file PROCESSID _ String 50 Mandatory The Process ID along with the system generated sequence number identifies the uploaded record uniquely Each file must have a unique Process ID and should be same for all records within a single file SIID String 16 Mandatory For a new record this will be blank For amendment of an existing standing instruction either the SI ID or the fund unit holder transaction type should be supplied FUNDID String 6 Mandatory The ID of a valid and enabled fund maintained in the system ISSUED String 1 Optional CERTREQD String 1 Optional SINGLECERT String 1 Optional MINHOLDCH _ Number 1 Optional KREQ FROMFUNDP String 10 Optional RICEBASIS CONTRIBUTI Number 5 2 Optional ONPERCENT AGE CONTRIBUTI Number 30 12 Optional ONAMOUNT ene ORACLE REFFUNDID String Optional AUTHSTATUS String 1 Optional 2 7 1 Standing Instructions Check Details Format 2 8 Column name as Data Length Mandatory Descript
13. 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO 13 String 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO 14 String 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO 15 String 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file 2 91 ORACLE OTHERINFO 16 String 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO 17 String 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO 18 String 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO 19 String 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO 20 String 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO 21 String 60 Optional Value defaulted as maintained in
14. FUNDID Alphanumeric Mandatory The Fund ID is a unique Identification for each Fund and it indicates the fund for which Fund IRA information has to be uploaded 3 76 ORACLE RULEEFFECT Date 8 Mandatory The Fund ID The rule IVEDATE and Rule effective date effective date for which fund combination IRA should be the information for same as defined the fund has in 01FDR to be maintained MININITIALIN Number 15 Mandatory Minimum VESTMENTA initial MT investment amount MAXINITIALIN Number 15 Mandatory Maximum VESTMENTA initial MT investment amount MININVESTM Number 15 Mandatory Minimum ENTAMT investment amount MAXINVESTM Number 15 Mandatory Maximum ENTAMT investment amount MINWITHDRA Number 15 Mandatory Minimum WALAMT Withdrawal amount MAXWITHDR Number 15 Mandatory Maximum AWALAMT Withdrawal amount Serial Number 16 Segment Identification Number 15FDI 3 77 ORACLE Description This segment is used for providing Fund delivery instruction information if applicable Segment Mandatory Optional Optional Multiple records allowed for the same Fund and Rule Effective Date No Field Name Type Maximum Length Mandatory Optional Characteristics Validations applicable Description SEGMENTID Alphanumeric 20 Mandatory Default value 15FDI Standard value of 15FDI to uniquely identify F
15. String 60 Optional ORMATIONS ADDITIONALINF String 60 Optional ORMATION10 ADDITIONALINF String 60 Optional ORMATION11 ADDITIONALINF String 60 Optional ORMATION12 ADDITIONALINF String 60 Optional ORMATION13 ADDITIONALINF String 60 Optional ORMATION14 ADDITIONALINF String 60 Optional ORMATION15 ADDITIONALINF String 60 Optional ORMATION16 ADDITIONALINF String 60 Optional ORMATION17 ADDITIONALINF String 60 Optional ORMATION18 ADDITIONALINF String 60 Optional ORMATION19 ADDITIONALINF String 60 Optional ORMATION20 ADDITIONALINF String 60 Optional ORMATION21 ADDITIONALINF String 60 Optional ORMATION22 ADDITIONALINF String 60 Optional ORMATION23 ADDITIONALINF String 60 Optional ORMATION24 2 15 ORACLE ADDITIONALINF String 60 Optional ORMATION25 ADDITIONALINF String 60 Optional ORMATION26 ADDITIONALINF String 60 Optional ORMATION27 ADDITIONALINF String 60 Optional ORMATION28 ADDITIONALINF String 60 Optional ORMATION29 ADDITIONALINF String 60 Optional ORMATION30 AGENTCODE Number 12 Mandatory BRANCHCODE Number 12 Mandatory MAKERID String 15 Optional There should not be any validation on Maker ID field with regards to the user profile maintenance in FCIS if it is supplied with the import file If it is not supplied default it to the logged in user id DATE If the date is not sp
16. TC Transaction Currency MATURITYDAT Date Optional E AUTOCLEARRE String 1 Optional Valid values are This is Applicable INVESTMENTS 0 1and2 only for transaction type should be Percentage and Percentage should be 100 AUTOCLEARPR String 1 Optional Valid values are This is Applicable OVISIONALBAL 0 1 and2 only for transaction ANCE type should be Percentage and Percentage should be 100 SUBSOURCEID VARCH 6 Optional AR2 CERTSPILLOVE NUMBE 1 Optional Valid values are 0 R R 1 and 2 ISSUED NUMBE 1 Optional Valid values 0 1 R and 2 BLOCKTXNNUM VARCH 16 Optional Enter this field for 2 42 ORACLE BER AR2 unblock transactions CPMFBONUSPE NUMBE Optional Should be between RCENT R 1 to 100 FXDEALDATE DATE 10 Optional Applicable for Would be defaulted only IPO by the system if not Subscription specified Used to Subscription Red derive the emption and exchange rate Pseudo Switch FXVALUEDATE DATE 10 Optional Applicable for only IPO Subscription Would be defaulted Subscription Red by the system if not emption and specified Used to Pseudo Switch derive the exchange rate CPMFCREDITL NUMBE 3 Optional No of Days AG R RETAINAGEING NUMBE 1 Optional Valid values 0 1 2 R TXNSERIALNU MBER DEALINGDATE COMPLETIOND ATE EUSDOPTION TODEALINGDA TE 2 43 ORACLE KYCCHASINGD ATE KYCRECEIVED
17. This is applicable only for Limit orders Hence it can be left blank LIMITORDERDE TAILS String 2000 Optional This is applicable only for Limit orders Hence it can be left blank REVERSALCOD E String Optional This is not used for New mode This is applicable only for Reversals In case of reversals this should be one of the valid reversals as maintained in the Params maintenance CANCELINSTR UCTION String Optional Should be left blank FROMFUNDPRI CEBASIS String Optional If price basis is applicable for the fund then a valid price basis code maintained in the system should be provided TOFUNDPRICE BASIS String Optional If Switch then If price basis is applicable for the fund then a valid price basis code maintained in the system should be provided TXN_OR_PRICE _DATE_FLAG String Optional Applicable only for price basis funds INTERMEDIARY DETAILS String 2000 Optional Concatenated value of broker and split If not provided default at the 2 40 ORACLE customer account level is picked up FROMPRICEDA Date Optional Applicable only for TE price basis funds TOPRICEDATE Date Optional Applicable only for price basis funds SUBSCRIPTION String 6 Optional Applicable for FUNDID pseudo switches SUBSCRIPTION String 10 Optional Applicable for PRICEBASIS pseudo switche
18. 15 file value is defaulted as maintained in Bulk client defaults MAKERD date DATE Optional If not supplied in the handoff ATE file value is defaulted as maintained in Bulk client defaults CHECKE String VARCHARZ2 Optional If not supplied in the handoff RID 15 file value is defaulted as maintained in Bulk client defaults CHECKE date DATE Optional If not supplied in the handoff RDATE file value is defaulted as maintained in Bulk client defaults POLICYN String Varchar2 16 Optional Could be any valid Policy UMBER maintained in the system For UT it should be UT 2 101 ORACLE DealBase String Varcahr2 1 Optional Inclusion Percentage dOn A Flat Rate Amount P Flat Rate Percentage 2 13 Policy Transaction Upload Formats The upload file would contain various segment identification numbers in the first column to indicate the type of data that is present in that entire row Each segment identified by a unique tag indicates the type of information such as policy transaction details transaction broker details transaction fund ratio details and so on Multiple transactions can be uploaded through in an upload file The possible segments that would be used in policy transaction upload are given below for reference Segment Description Segment Identification Mandatory Number Optional OOPXN This segment is used for providing
19. Char 150 Empty Empty 3 111 ORACLE Attribute2 Descriptive FlexField Char 150 Source id Source Product ULA refno Request type OASULA Other OASOTH GL_SL_LINK_ID Not Used Char 15 Empty Empty GL_SL_LINK_TB Not Used Char 30 Empty Empty L Attributes Descriptive FlexField Char 150 Empty Empty Attribute4 Descriptive FlexField Char 150 Empty Empty Attribute5 Descriptive FlexField Char 150 To be determined Buiness run number 3 digits Attribute6 Descriptive FlexField Char 150 To be determined Product ULA OASULA Other OASOTH Attribute7 Descriptive FlexField Char 150 To be determined Buiness run number 3 digits Attributes Descriptive FlexField Char 150 Empty Empty Attribute9 Descriptive FlexField Char 150 Empty Empty Attribute 10 Descriptive FlexField Char 150 Empty Empty Attribute 1 Descriptive FlexField Char 150 Empty Empty Attribute 12 Descriptive FlexField Char 150 Empty Empty Attribute13 Descriptive FlexField Char 150 Empty Empty Attribute 14 Descriptive FlexField Char 150 Empty Empty Attribute15 Descriptive FlexField Char 150 Empty Empty Attribute16 Descriptive FlexField Char 150 Empty Empty Attribute 17 Descriptive FlexField Char 150 Empty Empty Attribute18 Descriptive FlexField Char 150 Empty Empty Attribute 19 Descriptive FlexFi
20. Date Optional IBUTION TRANSFERDAT Date Optional E RETIREMENTA Number 5 2 Optional GE RETIREMENTD Date Optional ATE 2 22 ORACLE 2 2 1 DATEOFDEATH Date Optional DEATHCAUSE String Optional DISPATCHDATE Date Optional RETURNEDDAT Date Optional E PRIMARYUHMFI VARCH 15 Optional Applicable Primary MFIN of the N AR2 only if Primary Unitholder unitholder is major GUARDIANMFIN VARCH 15 Optional Applicable Mutual fund identification AR2 only if number of the Guardian unitholder is minor RECOVERCGT NUMBE 1 Optional EA Calculating Capital Gain R ax CAMPAIGNCOD String 6 Optional Used to capture the E CAMPAIGNCODE Segment ID Unit Holder Bank Details Column name as Datatype Field Mandatory Description expected in the file length BANKCODE Number 9 Mandatory Any valid bank code maintained in the system BRANCHCODE Number 9 Mandatory Any valid branch code maintained in the system ACCOUNTTYPE String 1 Mandatory Mandatory ACCOUNTNUMBER String 16 Mandatory Mandatory RELATIONSHIP VARCHAR 40 Optional Relationship with respect to unitholder incase of Money transfer and third party payment mode ACCOUNTNAME String 100 Mandatory If this is not specified the first name of the unit holder is considered to be the account name 2 23 ORACLE ACCOUNTCURRENCY String 3 Mandatory Mandatory DEFAULTDETAILS Number
21. If the date is not specified in the import file the application date is considered to be the Checker Date by default This information is applicable for the generation of authorized transactions SICHEQU EDETAILS String 2000 Optional The information for the standing instruction checks This would contain details of the cheque ID cheque date and cheque processed The appropriate field and record separators would separate the details AUTH_ST String Mandatory Optional Could be either of the following values U 2 62 ORACLE AT Unauthorized A Authorized GROSSOR String 1 Mandatory Optional Values can be G Gross N NET for Net transaction types 01 02 amp 03 l e IPO Subscription and redemption MEANSOF String 2 Optional Optional Value should be a valid PURCHAS means of purchase code E maintained in the system ISSUED String 1 Optional Applicable for scrip based funds only CERTREQ String 1 Optional Applicable for scrip based D funds only SINGLECE String 1 Optional Applicable for scrip based RT funds only TOSINGLE String 1 Optional Applicable for scrip based CERT funds only SUBPAYM String 2 Optional Optional Should be a valid sub ENTMODE payment mode maintained in the system ESCALATI Date 10 Mandatory if Optional Date gt SI start date and lt ONSTART Escalation SI end dat
22. JUL VARCHAR2 100 Optional Y AUG VARCHAR2 100 Optional Y SEP VARCHAR2 100 Optional Y OCT VARCHAR2 100 Optional Y NOV VARCHAR2 100 Optional Y DEC VARCHAR2 100 Optional Y MAKER_ID VARCHAR2 15 Optional Y MAKER_DT_STAMP DATE 10 Optional Y AUTH_STAT VARCHAR2 1 Mandatory N CHECKER_ID VARCHAR2 15 Optional Y CHECKER_DT_STAMP DATE 10 Optional Y LASTMODIFIEDUSERID VARCHAR2 15 Optional Y 2 123 ORACLE LASTMODIFIEDDATE DATE 10 Optional ENTITYTYPE VARCHAR2 1 Mandatory ENTITYID VARCHAR2 15 Mandatory 2 16 Dividend Equalization Adjustment Upload Field Name Data Type Field Length Mandatory Chara cterist ics Ru les Values SEQUENCENUMBER Number 10 Yes System generated sequence number of records in the file PROCESSID String 50 Yes The Process ID along with the system generated sequence number identifies the uploaded record uniquely Each file must have a unique Process ID This should be same for all records within a file BULKCLIENTCODE String 12 Yes The Code of the Bulk Client IMPORTFILENAME String 255 Yes Name of the file being uploaded should be specified Each file must have a unique name UPLOADMODE String 1 Yes N for New unit holder uploads and I for Information change FUNDID Alphanumeric 6 Yes ID of the fund involved in the transaction A valid fund id maintained in
23. SWIINEXCHAN GERATEAPPLIE D AUTOCLEARRE INVESTMENTS AUTOCLEARPR OVISIONALBAL ANCE Segment Identification Number 01SET Settlement Information Field Name as expected Data type Field Mandatory Values in the file length SEGMENTID VARCHARZ2 20 Mandatory SegmenitID is used for identifying the settlement details In this case Segment ID will be 01SET TXNSERIALNUMBER NUMBER 10 Mandatory This number is used to identify for which transaction this settlement details are used i e if the TxnSerialNumber of a transaction is 1 then the TxnSerialNumber should be same for the settlement details also oye ORACLE SEQUENCENUMBER NUMBER Mandatory This is used for mentioning the sequence for the settlement details of a transaction PROCESSID VARCHAR2 50 Mandatory This ID should be unique for each upload of transactions BULKCLIENTCODE VARCHAR2 12 Mandatory All the defaults values for transaction will be taken up based on this Bulk Client Code IMPORTFILENAME VARCHAR2 255 Optional File name should be the same as defined in File specifications of Interface definition AMCID VARCHAR2 12 Mandatory The ID of the AMC for which the bulk client has maintained the default details This should be same within a file for all the records UPLOADMODE VARCHAR2 Mandatory N for
24. String varchar2 25 Mandatory Name of the file being ILENAME 5 uploaded should be specified Each file must have a unique name UPLOAD String varchar2 1 Mandatory Upload mode can be N for MODE New unit holder uploads and l for Information change AMCID String varchar2 12 Mandatory The ID of the AMC for which the bulk client has maintained the default details This should be same within a file for all the 2 99 ORACLE records DEALTR String VARCHARZ2 Optional Null for a new mode It may ANSACTI 16 or may not be passed for ONNUMB other modes ER UHIDOR _ String VARCHAR2 Mandatory Could be any valid unit CIFNUMB 12 holder ID or CIF number ER maintained in the system APPLYAT Number NUMBER 1 Optional Could be either 0 No or 1 CIFLEVE Yes If not supplied value to L be taken from bulk client defaults APPLYD String VARCHAR2 Mandatory Could be any of the EALAT 1 following values G Group Level P Product Level F Fund Level L Load level STATUS String VARCHAR2 Mandatory Could be either A Active or 1 C Cancelled EFFECTI date DATE Mandatory The effective date from VESTAR which the deal is applicable TDATE EFFECTI date DATE Optional The effective date on which VEENDD the deal ends In case of ATE null values it will take the default value as the system high date AUTHST String VARCHAR2
25. VAT Value Added Tax WAUC Weighted Average Unit Cost 1 8 Getting Help Online help is available for all tasks You can get help for any function by clicking the help icon provided or by pressing F1 1 4 ORACLE 2 1 2 Appendix A Upload File Formats A Upload File Formats The external files containing the information that is to be imported from the bulk client are required to be in the following format File Type ASCII EXCEL ASCII file format Delimited Fixed width Field delimiter Comma Tab Colon Semi colon Space String delimiter Single quotes Double quotes NULL Date Format all dates will have 4 digit years DMY MDY DMonY YMD Date delimiter Slash Hyphen Space From registry Decimal symbol Point Comma Digit grouping symbol Point 2 1 ORACLE Comma Negative Sign symbol Hyphen Parenthesis Time delimiter Null Colon Semi colon Space Column Header on first line True False 2 2 Unit Holder File Format For all imports of unit holder new account and information change data the external hand off file containing the information must e Always be named in the format BulkUH e Always contain all information marked as mandatory in the table below e Always contain the information in the exact format and serial order shown in the Field Name column with values according
26. for Cash and S for Stock dividends For cash dividend EPU should be mentioned whereas for Stock dividend Parent Resulta nt ratio should be mentioned UNITSFORF REEZEHOLD INGS Alphanum eric Optional Valid values A for all units and C for Confirmed units Specify the units to be considered for dividend eligibility as on the freeze holdings date You can specify that all units including unconfirmed units must be considered or that only confirmed units are to be considered as on the freeze holdings date FIRSTDIVID ENDDECLA REDATE Date Optional Specify the first date for dividend declaration for the fund SPECIALDIV IDEND Number Optional This is to indicate that special dividends are applicable for the fund This feature is only available if your installation has requested for it MOCKDIVID END Number Optional Not applicable now 3 56 ORACLE HOLIDAYRU LE Alphanum eric Optional A for After and P for prior Select the rule to be applied if the dividend processing date falls on a holiday You can select either the PRIOR rule the previous working day is considered or the AFTER rule the next working day is considered for the dividend type The holiday rule you select here will be applicable to all dividend processing dates that have been arrived at u
27. indicate the add in factor that is to be applicable for computing the return value for the load for the selected transaction type The add in factor is used to arrive at the return value fora load at the time of allocation GROUPID Alphanumeric Optional Valid Group Id present in the system INDEXATION ONCGT Alphanumeric Optional Valid values are Y for Yes and N for No LevellD Number Optional Used for capturing the LevellD 3 70 ORACLE DependentLev Number Optional Used for el capturing Dependent level Serial Number 13 Segment Identification Number 12FTC Description This segment is used for providing Fund transaction currency information Segment Mandatory Optional Mandatory Multiple records allowed for the same Fund and Rule Effective Date Yes Field Name Type Maximum Mandatory Characteristic Description Length Optional s Validations applicable SEGMENTID Alphanumeric 20 Mandatory Default value Standard value 12FTC of 12FTC to uniquely identify Fund transaction currency information PROCESSID Alphanumeric 50 Mandatory Same value as This should in OOGEN identify the ProcessID upload uniquely This should also be unique within a file and it allows to identify imported records later FUNDID Alphanumeric 6 Mandatory The Fund ID is a unique Identificatio
28. records within a file BULKCLIENTCO DE String Mandatory The Code of the Bulk client IMPORTFILENAM E String Mandatory Name of the file being uploaded should be specified Each file must have a unique name AMCID String Mandatory The ID of the AMC Distributor for which the bulk client has maintained the defaults details UPLOADMODE String Mandatory N for New Mode and E for Edit Mode M for modify mode D for delete mode CHEQUETYPE String Mandatory Should be valid type as maintained in the system TRANSACTIONN UMBER String Transaction number should be specified if the Transaction Type is RED FUNDID String Mandatory The ID of a valid and enabled fund maintained in the system PAYMENTNUMB ER Number Mandatory Payment number should be specified if the Transaction Type is UHD UNITHOLDERID String Mandatory The Unit holder ID to identify a unit holder in the system depending on the scheme cross 2 119 ORACLE reference number PRODUCTID String 10 Optional ID of the product under which the corresponding Policy has been created CORPORATEAC String 1 Optional C Cash Dividend TIONTYPE S Stock Dividend CHEQUEAMOUN Number 30 12 Mandatory This field denotes the T cheque Amoun
29. 02 Number The commission amount for the 2 year Life Credit Character Not mandatory can be left blank Commission Year Number It indicates the year for which the commission is Indicator applicable Commission Content Number It contains the commission amount for the two years Commission Scaling Number The amount agreed between the client and the broker Factor Commission Frequency Character It is optional left blank Commission Type Character This field is left blank Current Potential Number It is applicable for only recurring business input Commission Primary display shows 000000000000000 Future Potential Number It is applicable for only recurring business input Commission Secondary display shows 000000000000000 3 119 ORACLE VAT Number It is the value added tax not required as input Broker Reference Character It is the reference as specified on the application form Currency Indicator Character It indicates the currency type selected Agents Commission Number It is not applicable in this case displayed as 000000000000000 Commission Allowance Number It is the waiver amount on the broker s commission New Business Date Number It is the transaction date Total Investment Number It is the total amount of investments Investment Type Character An optional field can be left blank Fund Value Number It is the sum of the average of the a
30. 10 Optional If the date is not specified in the import file the application date is considered to be the Maker Date by default ene ORACLE CHECKERID String 15 Optional If this information is specified in the import file no validation is made with regards to the user profile maintenance in the FCIS system If it is not specified it is defaulted to SYSTEM This information is applicable for the generation of authorized fund price records CHECKERDATE Date 10 Optional If the date is not specified in the import file the application date is considered to be the Checker Date by default This information is applicable for the generation of authorized fund price records PRICECOMPDETAILS String 2000 Optional The details of the price components This would contain the component ID and component value required for the fund and effective date with suitable field oe ORACLE and record separators AUTHTYPE String 1 Mandatory Could be either of the following values U Unauthorized A D Authorized BASEPRICECONSTANT String 500 Optional 2 11 Broker File Format For all imports of broker data the external hand off file containing the information must e Always be named in the format BulkBRK e Always contain all information marked as mandatory in the table below
31. 2 0 and 1 PAYUNGEN VARCHAR 1 Optional Valid values are REINVESTM 2 ENT 0 and 1 TDS Number 1 Optional Valid values are TDS Applicable APPLICABLE for all UH flag FOR ALL UH 0 No and could be set to 1 Yes 1 only if dividend equalization is applicable for the fund Serial Number 9 Segment Identification Number 08FSC Description This segment is used for providing Fund Sale Country information Segment Mandatory Optional Mandatory Multiple records allowed for the same Fund and Rule Effective Date Yes Field Name Type Maximum Mandatory Characteristics Description Length Optional Validations applicable 3 59 ORACLE SEGMENTID Alphanumeric 20 Mandatory Default value O8FSC Standard value of O8FSC to uniquely identify Fund sale country information PROCESSID Alphanumeric 50 Mandatory Same value as in OOGEN Process ID This should identify the upload uniquely This should also be unique within a file and it allows to identify imported records later FUNDID Alphanumeric Mandatory The Fund ID is a unique Identification for each Fund and it indicates the fund for which Fund sale country information has to be uploaded RULEEFFEC TIVEDATE Date Mandatory The Fund ID and Rule effective date combination should be the same as defined in 01FDR The rule effective date for which fund sale country information for the fund h
32. 35 Optional Used to capture the Reference as apart of Payment routing details REFERENCE2 VARCHARZ2 35 Optional Used to capture the Reference as apart of Payment routing details POLICYNUMBER String 16 Optional PRODUCTID String 10 Optional PAYMENTCURRE String 3 Optional Valid Currency Code being NCY maintained in the system IBAN String 36 Optional Used to capture the IBAN BENEFICIARYIBA String 36 Optional Used to capture the N BENEFICIARYIBAN INTERMEDIARYIB String 36 Optional Used to capture the AN INTERMEDIARYIBAN 2 8 1 Reinvestment Details Format Column name as expected in Data Length Mandatory Description the file type REINVESTMENTUNITHOLDERID String 12 Mandatory For unit holder income distribution setup records this is the same as the unit holder ID and is defaulted during processing REINVESTMENTFUNDID String 6 Mandatory The ID of the fund into which the income is being reinvested The reinvestment fund ID should be unique for an income distribution 2 77 ORACLE setup record SPLITPERCENTAGE Number 5 2 Mandatory The split percentage to indicate the percentage of income that must be reinvested into the reinvestment fund The sum of the split percentages for an income distribution setup should add up to one hundred 2 9 Transaction Load Override File Format For all imports of transaction load override data the external hand off file containing
33. Amount Derived 0 Yes Amount with ve sign Disinvestment Amount Amount with ve sign Disinvestment Units N A Yes 0 Manco Initial Unit Trust Fee N A 0 Yes Transaction Type Name Transaction Descriptions Yes Yes as available in the system Internal Reference Number Running serial per batch Yes Yes 3 1 10 GL Setup Upload Interface Format Files uploaded using the GL Setup Upload should have the following format Field Name Data Type Details Fund ld Character 6 GL Template Id Character 10 The template Id of the GL set up Adummy value to be provided for this Account type Character 2 The account type of the GL set up Business Event Character 2 One of the valid codes for business events Trigger Event Character 15 The triggering event One of the valid enumerations for the triggering event Theoretical Flag Character 1 Y Theoretical N Actual Setup Enabled Character 1 Y Enabled N Disabled Component Id Character 20 One of the valid codes for business events Component Description Character 255 Description of the component code Debit credit Flag Character 2 Dr Debit Cr Credit GL set up for primary Character 1 C CASA G GL S SAP P Payment Primary Entity Type Character 1 The primary entity type of the GL set up U Uniholder D Distributor M AMC F Fund 3 115 ORACLE Ac
34. DATE is expected to be cleared If specified in the import file it must not be earlier than the application date If not the system computes the same as a date Cheque Date Clearing Period and this computed date is considered by default to be the clearing date CLEARING Optional The Cheque clearing status STATUS PRODUCTI String 10 Optional ID of the product under which D the corresponding Policy has been created POLICYHO Optional Identification number of the LDERID Policy Holder 2 107 ORACLE POLICYTR String 1 Mandatory Indicates the mode of the ANSACTIO transaction Can be any of NMODE the following A Amount U Units P Percentage TOPUPING 1 Optional Indicates whether top up is LUSIVE inclusive If yes the top up amount is considered immediately for the next annuity payment TRANSFER Optional ORID PERCENTA Number 5 2 Optional Mandatory if Transaction GEAPPLIE mode is percentage D OLDPOLIC Optional YTXNNUMB ER MODULEID String 30 Mandatory ADJUSTME Optional Adjustment Transaction Type NTTXNTYP E PORTFOLI Optional Indicates whether the switch OSWITCH is a complete or partial switch transaction Portfolio switch is applicable to both transaction put through by amount or by percentage of holdings SURRENDE String Mandatory Indicates whom the RMONEYP surrender money is payable AYABLE FUNDINGP Number 5 Optional Th
35. DENOMINATI should be applicable ONS specified with only in case of necessary field scripless and record funds having separator as Physical shown below delivery as 10 0 100 1 500 one of the 0 1000 0 where delivery the field instruction separator between Denomination value and Default is and the record separator is colon PUEV NUMBER 1 Optional Valid values are This is anew 0 and 1 delivery option 3 1 2 PROCESSINGFREQ ref 11FLM 12 10 3 79 ORACLE Allocation This will mean that you will be charging the investor a fee or giving an incentive at the time of allocation of units Allocation time loads cannot be designated for any transaction types other than IPO subscription redemption and switch Transaction The charge fee or incentive will be applied at the time the transaction request is accepted from the investor Post Allocation This frequency is applicable typically to the Capital Gains Tax which may be applied after allocation on the gross amount Capital Gains Tax may also be designated as an allocation time load Serial Number 17 Segment Identification Number 17KYC Description This segment is used for capturing the Document information if applicable Segment Mandatory Optional Optional Multiple records allowed for the same Fund and Rule Effective Date Yes Field Name Type Maximum Mandatory Characteristics Description Length Option
36. FORMAT aert ca dostsssnvevasenstugevovhdedtetensaddcsencerigtan cag Aechoveedsencudevetbeetig tne gugevevyoosevienss 2 2 2 2 1 Unit Holder Bank Detail ss cicccves cccsvseesessians r o a a eo henaint 2 23 23 UNIT HOLDER KYC DETATIS ox piceceshesdscstetadecsasvevigedncugsveckaveeettncestvcenvestestecugevoes ooteviznasdevestessdgednrigeendedeteteas 2 26 2 4 UNIT HOLDER BENEFICIARY DETAILS irer eaer eea a or ae ier i 2 28 25 TRANSACTIONS FILE FORMAT 5 5s3sscei3 c2a53csags coestetas steve ceseinaa ce svav vibe aaa Aaa 2 31 2 6 FILE FORMAT FOR CONVERSION TRANSACTIONS cceseceessecesreesseceeceecsaeceneecsaeceneecsaeceneecnaeceneecaeensees 2 56 2 7 STANDING INSTRUCTIONS FILE FORMAT coreia aeaa aaa a i ia ia aaa EEEE AT i eaaa ii 2 58 2 7 1 Standing Instructions Check Details Format sseseseseseeseeeeseeeserseresrsrrerrsreeresrerrnserrresesreereseee 2 71 2 8 INCOME DISTRIBUTION SETUP FILE FORMAT cccsssceseceesseceseeeessececeeesaeceneecsaeceneecsaeceneecsaeceeneesaeeeses 2 71 2 8 1 Reinvestment Details FOrmat cccccccccccccccssssccccceceseesuscecececssussaeceeececssssseceeececseseaeseeececeeseqssaeeeeeceesenaae 2 77 2 9 TRANSACTION LOAD OVERRIDE FILE FORMAT ssccesscesssecesreeesseceeceecsaeceneecsaeceeneecsaeceneecsaeceeneesaeensees 2 78 2 10 RUND PRICE FILEFORMAT iiaae e a dads vesoevaseesbte A E aaa Ea aE teen E R E ia 2 80 2T 1 BROKER PILEPORMAT e a e aa aa aa a E AE Ea A EE A Eea 2 84 2 12 UNIT HOLDER DEAL BILE FORMAT
37. Fund client agency branch defaults back dated limit this field needs to be value could maintained either be FundlD Fund Identification number or Fund ticker symbol YEAR Number 4 Optional The year for which the calendar need to be maintained for the fund 3 94 ORACLE DEFAULTOPTI Alphanumeric 15 Optional Valid values If the default ON are null option is null BULKCLIEN then all values TCODE or provided by the any valid user for entity Fund Id type entity id available in and Restrictive the system list should be used If the value BULKCLIENTC ODE is mentioned then default the information based on the bulk client code mentioned as a part of header segment If any other Fund ID value is mentioned then default values based on the latest available record for the Fund mentioned UPLOADMODE Alphanumeric 1 Optional Valid values Should be N for are null N New fund rule and l This And I for is to override Amending an the value existing mentioned authorized fund as a part of rule header segment GENERATEAUT Alphanumeric 1 Optional Valid values This indicates HFUNDRULE are null A whether the and U This fund rule is to override uploaded should the value be a authorized mentioned fund rule or un as a part of authorized fund header rule segment 3 1 4 Fund Template based Upload Format For funds uploaded using a f
38. Lag can only be positive 3 36 ORACLE CONFIRMAT NUMBER Optional Enter a value to IONLAG specify when the redemption transaction should be picked for confirmation after allocation T X where X will be days of Lag Lag can only be positive i CHQALLOC NUMBER 1 Optional Valid values This is used to ONPARWITH are 0 and 1 specify that all CASH check Demand Draft transactions are to be treated on par with cash transactions If this is true then during allocation the check demand draft transactions will be taken for allocation for the same day The units allocated will be provisional and will be confirmed only after the check is cleared HOLDINGPE NUMBER 1 Optional Valid values This is used to RIODAPPLIC are 0 and 1 indicate ABLE whether a lock in period is applicable for the investors investing in the fund for the transaction type mar ORACLE RETAINAGEI NUMBER 1 Optional Valid values This is used to NGTOSUBS are 0 and 1 indicate that the CRIPTION aging principle must be applied to subscription transactions in the fund Aging is the process of keeping track of a transaction from the transaction date right up to when it is cleared in full from the account of the unit holder Depending upon the policy specified to be followed for aging i e either FIFO or proportionate aging is applied
39. No 10 FROMCOUNTRY Alphanumeric No 3 2 56 ORACLE FROMBICCODE Alphanumeric No 12 FROMCERTIFICATEDETAILS Alphanumeric No 200 TODELIVERYOPTION Alphanumeric No 1 TODELIVERYTYPE Alphanumeric No 1 TOENTITYID Alphanumeric No 12 TOACCOUNTNUMBER Alphanumeric No 16 TOACCOUNTNAME Alphanumeric No 100 TOADDRESSTYPE Alphanumeric No 2 TOADDRESSLINE1 Alphanumeric No 80 TOADDRESSLINE2 Alphanumeric No 80 TOADDRESSLINE3 Alphanumeric No 80 TOADDRESSLINE4 Alphanumeric No 80 TOZIPCODE Alphanumeric No 10 TOCOUNTRY Alphanumeric No 3 TOBICCODE Alphanumeric No 12 TOCERTIFICATEDETAILS Alphanumeric No 200 AUTHREJECTSTATUS Alphanumeric Yes 1 MAKERID Alphanumeric No 15 MAKERDATE Date No CHECKERID Alphanumeric No 15 CHECKERDATE Date No MODULEID Alphanumeric No 30 REMARKS Alphanumeric No 255 2 57 ORACLE Standing Instructions File Format For all imports of new and amended standing instructions data the external hand off file containing the information must e Always be named in the format BulkSI e Always contain all information marked as mandatory in the table below e Always contain the information in the exact format and serial order shown in the Field Name column with values according to the validations mentioned in the table below Field Data Field Mandatory Characteristics Values name as type len
40. ORACLE of Payment routing details INTERMEDIARYINFO VARCHARZ2 100 Optional Used to capture the Intermediary Information other information as a part of Payment routing details FURTHERCREDITNAME VARCHAR2 35 Optional Used to capture the Credit Name as a part of Payment routing details FURTHERCREDITACCT VARCHAR2 35 Optional Used to capture the Credit NO Account Number as a part of Payment routing details REFERENCE VARCHARZ2 35 Optional Used to capture the Reference as a part of Payment routing details REFERENCE2 VARCHARZ2 35 Optional Used to capture the Reference as a part of Payment routing details ENTITYID VARCHAR2 12 Optional If the payment type is B Broker then this field will have a valid broker id as defined in the system ENTITYTYPE VARCHARZ2 1 Optional If the payment type B then Entity type would be B IBAN String 36 Optional Used to capture the IBAN BENEFICIARYIBAN String 36 Optional Used to capture the BENEFICIARYIBAN INTERMEDIARYIBAN String 36 Optional Used to capture the INTERMEDIARYIBAN CAMPAIGNCODE String 6 Optional Used to capture the CAMPAIGNCODE Segment Identification Number 02KYC Transaction KYC Information Field Name as Data type Field length Mandatory Values expected in the file SEGMENTID VARCHAR2 20 Mandatory SegmentID is used for identifying the settlement details In this ca
41. Txn Add Info 22 OTHERINFO23 VARCHAR2 60 Optional Txn Add Info 23 OTHERINFO24 VARCHAR2 60 Optional Txn Add Info 24 OTHERINFO25 VARCHAR2 60 Optional Txn Add Info 25 OTHERINFO26 VARCHAR2 60 Optional Txn Add Info 26 OTHERINFO27 VARCHAR2 60 Optional Txn Add Info 27 OTHERINFO28 VARCHAR2 60 Optional Txn Add Info 28 OTHERINFO29 VARCHAR2 60 Optional Txn Add Info 29 OTHERINFO30 VARCHAR2 60 Optional Txn Add Info 30 aoe ORACLE 2 6 File Format for Conversion Transactions The following file format would need to be adhered to for upload of conversion transactions Field Name as expected in the file Data Type Mandatory Field Length PROCESSID Alphanumeric Yes 50 BULKCLIENTCODE Alphanumeric Yes 12 IMPORTFILENAME Alphanumeric No 255 AMCID Alphanumeric No 12 UPLOADMODE Alphanumeric Yes 1 TRANSACTIONNUMBER Alphanumeric No 16 REFERENCENUMBER Alphanumeric No 16 TRANSACTIONDATE Date Yes UNITHOLDERID Alphanumeric Yes 12 FUNDID Alphanumeric Yes 25 UNITSAPPLIED Numeric No 15 6 FROMDELIVERYOPTION Alphanumeric No 1 FROMDELIVERYTYPE Alphanumeric No 1 FROMENTITYID Alphanumeric No 12 FROMACCOUNTNUMBER Alphanumeric No 16 FROMACCOUNTNAME Alphanumeric No 100 FROMADDRESSTYPE Alphanumeric No 2 FROMADDRESSLINE1 Alphanumeric No 80 FROMADDRESSLINE2 Alphanumeric No 80 FROMADDRESSLINE3 Alphanumeric No 80 FROMADDRESSLINE4 Alphanumeric No 80 FROMZIPCODE Alphanumeric
42. VARC 24 Optional Used to capture the ARYBICC HAR2 Biccode for the Beneficiary ODE as a part of Payment routing details BENEFICI VARC 24 Optional Used to capture the ARYACCT HAR2 Account Number for the NO Beneficiary as a part of Payment routing details BENEFICI VARC 24 Optional Used to capture the Code ARYCODE HAR2 for the Beneficiary as a part of Payment routing details BENEFICI VARC 100 Optional Used to capture the ARYINFO HAR2 Information free format text for the Beneficiary as a part of Payment routing details INTERME VARC 35 Optional Used to capture the DIARY HAR2 Intermediary as a part of Payment routing details INTERME VARC 35 Optional Used to capture the DIARYAD HAR2 Intermediary address as a D1 part of Payment routing details 2 67 ORACLE INTERME VARC 35 Optional Used to capture the DIARYAD HAR2 Intermediary address as a D2 part of Payment routing details INTERME VARC 35 Optional Used to capture the DIARYAD HAR2 Intermediary address as a D3 part of Payment routing details INTERME VARC 24 Optional Used to capture the DIARYBIC HAR2 Intermediary Biccode as a CODE part of Payment routing details INTERME VARC 24 Optional Used to capture the DIARYAC HAR2 Intermediary Account CTNO Number as a part of Payment routing details INTERME VARC 24 Optional Used to capture the DIARYCO HAR2 Intermediary Code as a D
43. W frequency with Q for Weekly F which the or B for Bi dividend is to weekly M for be declared Monthly Q for Quarterly H for Half yearly Y for Yearly 3 51 ORACLE DIVIDENDPA YMENTFRE Q Alphanum eric Optional Valid values are D for Daily W for Weekly F or B for Bi weekly M for Monthly Q for Quarterly H for Half yearly Y for Yearly Enter the frequency with which the declared dividends are to be paid As the system supports accumulation of dividends the payment could be for any dividend that has been declared earlier The Dividend Payment Frequency must not be less than Dividend Declaration Frequency REINVESTM ENTALLOW ED Number Optional Valid values are O and 1 This is used to indicate if reinvestment is allowed for the fund TAXID Alphanum eric 15 Optional Enter the tax ID for the fund that is being set up BOOKCLOSI NGLEADTIM E Number Optional Enter a lead time in days FREEZEHOL DINGLEADTI ME Number Optional This data is also in days and the Freeze Holding Date is the date on which the balances held by all unit holders in the fund will be consolidated 3 52 ORACLE BOARDMEE Number 5 Optional Enter a lead TINGLEADTI time in days ME This is captured for information purposes o
44. aier aaa E E La E aA EEEE A E R ai 2 99 2 13 POLICY TRANSACTION UPLOAD FORMATS ieaie irarri aa a aaea a i E aia iiaia 2 102 2 13 1 Policy Transaction Upload Segment Formats ccccsccescceseceseceecuseenseeseeeseesseeeeeeseceecesecnsecaeenas 2 103 2 13 2 Policy transaction broker related segment formats ccscccsccesecesecnseenseeseeeseeeseeeeeesecesecnsecnsecnaeenas 2 109 2 13 3 Policy Transaction Fund Ratio Related Segment Formats 1 c1cccsccssseesseeseeseeeeeeeecesecnsecnsecnseents 2 110 2 13 4 Policy transaction fee settlement details related segment formats osson 2 112 2 13 5 Policy Transaction Switch Fund related Segment FOrimats 1 c1 ccscccssessseesseeseeeeceeecesecesecnsecnseense 2 114 2 13 6 Policy Transaction Fee Override related Segment Formats 1 sccscccssesseeseeseeeeeetecesecnecesecuseenes 2 115 2 13 7 Policy Transaction Derived Fee Override related Segment FOrmat ccccsccsscesceseceseceeeeee 2 118 2 14 CHEQUE TRACKING FILE FORMAT ccseccccccecsessssscecececsessaeaecececseseascaececececsesaaesecececsesnaaesecececsensaaeeeeecs 2 118 2 15 HOLIDAY UPLOAD FILE FORMAT c scssccesssecssccesscecnsccesscecsccesseecsecessssecseceesssecnecessceecnsceeseeseceesnee es 2 122 2 16 DIVIDEND EQUALIZATION ADJUSTMENT UPLOAD cccsessscecececsessssececcceceesesseaeceeeceesessaeceeeceesesaaeeeeees 2 124 2 17 EXCHANGE RATE UPLOAD FORMAT ccssccesscecsseceescecsscceeneecsacceneecsaeces
45. also be unique within a file and it allows to identify imported records later FUNDID Alphanumeric Mandatory The Fund ID is a unique Identification for each Fund and it indicates the fund for which Fund additional information has to be uploaded RULEEFFECT IVEDATE Date Mandatory The Fund ID and Rule effective date combination should be the same as defined in 01FDR The rule effective date for which fund additional information for the fund has to be maintained 3 73 ORACLE OTHERINFO1 Alphanumeric 60 Optional Additional information could be maintained in the system as a art of Add Info Maintenance Once this is done fora specific AMC the additional information can be mapped for the entity type Fund Hence as a part of Fund additional information maintenance the values could be captured Any such additional information can be captured using these fields OTHERINFO2 Alphanumeric 60 Optional OTHERINFOS Alphanumeric 60 Optional OTHERINFO4 Alphanumeric 60 Optional OTHERINFOS Alphanumeric 60 Optional OTHERINFO6 Alphanumeric 60 Optional OTHERINFO7 Alphanumeric 60 Optional OTHERINFO8 Alphanumeric 60 Optional OTHERINFO9 Alphanumeric 60 Optional OTHERINFO1 Alphanumeric 60 Optional 0 OTHERINFO1 Alphanumeric 60 Optional 1 OTHERINFO1 Alpha
46. any given date for this transaction type the system will allow the user to enter transactions dated earlier to the current date 3 33 ORACLE BACKDATIN NUMBER 1 Optional Valid values This is GLIMIT are 0 and 1 applicable only if Allow Back Dating is True This has to be later than the transaction start date Fund Price as effective on that date will be taken into account during allocation FUNDTRAN NUMBER Optional Enter a value to SACTIONCO specify the total UNTER number of transactions to be allowed in this transaction type ACKNOWLE NUMBER Optional This is to DGEMENTR indicate if the EQUIRED Acknowledgme nt Slip is to be printed after every transaction Otherwise this can be printed on receiving specific request from the User CONFIRMAT NUMBER Optional Valid values This is to IONREQUIR 0 and 1 indicate ED whether confirmation Slip is to be printed after every transaction entry Otherwise this can be user initiated after allocation of the transaction 3 34 ORACLE NOTICEPERI VARCHAR2 ODDATEBA SIS i Optional NOTICEPERI NUMBER 3 Optional OD BASEPRICE Alphanumeric Optional Valid values This indicates DEFINITION are P for the Base Price Par Value definition for the and N for transaction The declared Unit Price will NAV be calculated based on this price and loads defined f
47. as defined in the system DRAWEEBRANCHNAME VARCHARZ2 20 Optional NA To be Blank PAYMENTREMARKS VARCHARZ2 255 Optional NA To be Blank PAYMENTTYPE VARCHARZ2 1 Optional Should be a valid Payment type as defined in Parameter Definition Setup S Self T Third Party B Broker A Absorbed Paid Back R Retained by AP Advanced Payment THIRDPARTYADDRESS VARCHARZ2 255 Optional In Case of Redemption if Payment type is Third Party then this field is used for mentioning the Third party Address THIRDPARTYADDRESSL VARCHAR2 80 Optional NA To be Blank INE1 THIRDPARTYADDRESSL VARCHAR2 80 Optional NA To be Blank INE2 THIRDPARTYADDRESSL VARCHAR2 80 Optional NA To be Blank INE3 THIRDPARTYADDRESSL VARCHAR2 80 Optional NA To be Blank INE4 THIRDPARTYBICCODE VARCHARZ2 12 Optional NA To be Blank THIRDPARTYCOUNTRY VARCHARZ2 3 Optional NA To be Blank 2 47 ORACLE CODE THIRDPARTYPAYMENT REFERENCE VARCHAR2 255 Optional NA To be Blank THIRDPARTYSTATE VARCHAR2 20 Optional In Case of Redemption if Payment type is Third Party then this field is used for mentioning the Third party State THIRDPARTYUSSTATE NUMBER Optional In Case of Redemption if Payment type is Third Party then this field is used for mentioning the Third party US State THIRDPARTYZIPCODE VARCHAR2 10 Optional I
48. effective date effective date for which combination transaction should be the processing same as defined investor in 01FDR category information for the fund has to be maintained TRANSACTI Alphanum 2 Mandatory Valid values are Indicate the ONTYPE eric 01 for IPO 02 value for which for Subscription the transaction 03 for type for which Redemption the rules are 04 for Switch being set up from operation 05 for transfers and so on up to 10 INVESTORC Alphanum 2 Mandatory Valid ATEGORY eric Corporate and Individual categories defined as a part of Params Maintenance MINTRANSA Number 15 Optional Decimal values Minimum CTIONAMOU up to maximum transaction NT of 3 digits are amount allowed allowed for the transaction type and investor category 3 49 ORACLE STEPAMOU Number 15 Optional Decimal values NT up to maximum of 3 digits are allowed MAXTRANS Number 15 Optional Decimal values Maximum ACTIONAMO up to maximum transaction UNT of 3 digits are amount allowed allowed for the transaction type and investor category MINTRANSA Number 15 Optional Decimal values Minimum CTIONUNITS up to maximum transaction unit of 6 digits are allowed for the allowed transaction type and investor category STEPUNITS Number 15 Optional Decimal values up to maximum of 6 digits are allowed MAXTRANS Number 15 Optional Decimal values Maximum ACTIONUNIT up to
49. entity The Entity ID ID which belongs maintained to the entity type in the system specified as a part of Single entity maintenance for the respective entity type DISABLE Number 1 Optional Valid values This is to are 0 and 1 indicate whether the definition should be disabled or enabled RESTRICTIVELI Number 1 Optional Valid values Indicates ST are 0 and 1 whether the mapping is a positive list or negative list The value of 1 indicates that it is a negative list and vice versa ORACLE DEFAULTOPTI Alphanumeric 15 Optional Valid values If the default ON are null option is null BULKCLIEN then all values TCODE or provided by the any valid user for entity Fund Id type entity id available in and Restrictive the system list should be used If the value BULKCLIENTC ODE is mentioned then default the information based on the bulk client code mentioned as a part of header segment If any other Fund ID value is mentioned then default values based on the latest available record for the Fund mentioned UPLOADMODE Alphanumeric 1 Optional Valid values Should be N for are null N New fund rule and l This And I for is to override Amending an the value existing mentioned authorized fund as a part of rule header segment GENERATEAUT Alphanumeric 1 Optional Valid values This indicates HFUNDRULE are null A whether the an
50. file contents SWIFTADDRES String 80 Optional Accepted from the user s SLINE1 specification for the same in the hand off file contents SWIFTADDRES String 80 Optional Accepted from the user s SLINE2 specification for the same in the hand off file contents SWIFTADDRES String 80 Optional Accepted from the user s SLINE3 specification for the same in the hand off file contents SWIFTADDRES String 80 Optional 2 5 ORACLE SLINE4 SWIFTCOUNTR String 3 Optional YCODE BICCODE String 12 Optional HOMETELEPHO String 15 Optional Accepted from the user s NENUMBER specification for the same in the hand off file contents OFFICETELEPH String 15 Optional Accepted from the user s ONENUMBER specification for the same in the hand off file contents FAXNUMBER String 15 Optional Accepted from the user s specification for the same in the hand off file contents TAXDEDUCTED Number 1 Optional Could be either true 1 or ATSOURCE false 0 TAXID String 15 Optional Accepted from the user s specification for the same in the hand off file contents TAXCIRCLE String 15 Optional Accepted from the user s specification for the same in the hand off file contents IDENTIFICATIO String 3 Optional Value Could be any of the NTYPE defaulted as values maintained in maintained Params maintenance for in Bulk client Identification Type defaults in the a
51. for the records in the file PROCESSID String 50 Mandatory The Process ID along with the system generated sequence number identifies the uploaded record uniquely Each file must have a unique Process ID BULKCLIENTCODE String 12 Mandatory The Code of the bulk client This should be same within a file IMPORTFILENAME String 255 Mandatory Name of the file being uploaded should be specified Each file must have a unique name AMCID String 12 Mandatory The ID of the AMC for which the bulk client has maintained the default details FUNDID String 25 Mandatory The ID of the fund that is valid and enabled in the system EFFECTIVEDATE Date 10 Optional The date on which the uploaded ane ORACLE price is effective REALNAVPERUNIT Number 15 6 Optional The Real NAV per Unit for the fund on the effective date TOTALNETASSET Number 28 6 Optional The total value of the net assets for the fund FLOORPRICE Number 15 6 Optional The floor price for the fund CEILINGPRICE Number 15 6 Optional The ceiling price for the fund MAKERID String 15 Optional If this information is specified in the import file no validation is made with regards to the user profile maintenance in the FCIS system If it is not specified the ID of the logged in user at the time of import is taken by default as the Maker ID MAKERDATE Date
52. for the same in the hand off file contents INVESTORTYPE String 1 Optional Value Could be any of the defaulted as values from the following maintained list Individual Or C in Bulk client Corporate Mandatory defaults in the absence of information in the file CONTACTADDR String 80 Optional Accepted from the user s ESSLINE1 specification for the same in the hand off file contents CONTACTADDR String 80 Optional Accepted from the user s ESSLINE2 specification for the same in the hand off file contents PRIMARYCITY String 80 Optional Accepted from the user s 2 4 ORACLE specification for the same in the hand off file contents PRIMARYSTAT String 80 Optional Accepted from the user s E specification for the same in the hand off file contents PRIMARYUSST Number 1 Optional Should be left blank ATE ZIPCODE String 10 Optional Hand off file contents SECONDARYAD String 80 Optional DRESSLINE1 SECONDARYAD String 80 Optional DRESSLINE2 SECONDARYCI String 80 Optional Accepted from the user s TY specification for the same in the hand off file contents SECONDARYST String 80 Optional Accepted from the user s ATE specification for the same in the hand off file contents SECONDARYUS Number 1 Optional STATE SECONDARYZI String 10 Optional Accepted from the user s PCODE specification for the same in the hand off
53. in the absence of information in the file OTHERINFO String 60 Optional Value 3 defaulted as maintained in Bulk client defaults in the absence of information in the file 2 89 ORACLE OTHERINFO 4 String 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO 5 String 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO 6 String 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO 7 String 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO 8 String 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO 9 String 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file 2 90 ORACLE OTHERINFO 10 String 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO 11 String 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO 12 String
54. in the file EFFECTIVEDAT DATE Optional E CELLPHONENU String 16 Optional MBER PRIMARYCOUN String 3 Optional TRYCODE 2 17 ORACLE ALTCELLPHON String 16 Optional ENUMBER ALTHOMEPHON String 15 Optional ENUMBER ALTOFFICEPHO String 15 Optional NENUMBER ALTEMAILID String 60 Optional SECONDARYC String 3 Optional OUNTRYCODE PLACEOFISSUE String 3 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file ALTCONTACTN String 70 Optional AME ALTFAXNUMBE String 15 Optional R PREFERREDFU String 6 Optional Value Should be a valid fund Id NDFORREDEM defaulted as which would be used for PTION maintained redeeming the trailer in Bulk client commission to pay the defaults in intermediary the absence of information in the file GUARDIANPAN String 15 Optional If the unit holder is a GIRNO minor then the PAN tax id details of the Guardian GUARDIANFOR Number 1 Optional Must be left blank M6061 PRIMARYUHFO Number 1 Optional Must be left blank RM6061 2 18 ORACLE JOINTNOMINEE String 2000 Optional List of beneficiaries DETAILS separated by Each record can contain the following BENEFICIARYID BENEFICIARYTYPE BENEFICIARYNAME Beneficiary date of birth Beneficiary address separated by ADDRESSLINE1 ADDRESSLINE2 ADDRESSLINES ADDRESSLI
55. level then the investor will be intimated about it and will be provided with some lead time to either increase the balance above the minimum level or redeem all his units After the elapsed lead time if the unit holder balance still lies below the defined minimum level then the automatic redemption of those units will be done MINIMUMBA LANCETYPE Alphanumeric Optional Valid values are A and U Enter the type of Minimum balance amount units to be maintained for Automatic Redemption MINIMUMBA LANCE Number 20 Optional Enter the minimum balance in amounts units based on what balance type has been specified above to be maintained for Automatic Redemption 3 21 ORACLE ELAPSEDDA YSBEFOREA UTORED Number Optional Enter the number of days from the date of intimation after which Automatic Redemption will be initiated This is the lead time provided to the investor CHQALLOT ONCLGDAT E Number Optional Valid values are 0 and 1 This is used to indicate whether allocation must be done on the transaction date or on the check clearing date using the price prevailing on that date for transactions in which the payment mode is Check AGEINGBAS EDON Alphanumeric Optional Valid values are F for FIFO T for Transaction Receipts and P for FIFO across products This is used
56. maximum transaction unit S of 6 digits are allowed for the allowed transaction type and investor category Serial Number 8 Segment Identification Number 07IDR Description This segment is used for providing Corporate Action related information Segment Mandatory Optional Optional Multiple records allowed for the same Fund and Rule Effective Date Yes For cash and Stock dividend information Field Name Type Maximum Mandatory Characteristics Description Length Optional Validations applicable 3 50 ORACLE SEGMENTID Alphanum 20 Mandatory Default value Standard value eric 07IDR of 07IDR to uniquely identify Transaction processing communication mode information PROCESSID Alphanum 50 Mandatory Same value as This should eric in OOGEN identify the ProcessID upload uniquely This should also be unique within a file and it allows to identify imported records later FUNDID Alphanum 6 Mandatory The Fund ID is eric a unique Identification for each Fund and it indicates the fund for which Corporate action has to be uploaded RULEEFFEC Date 8 Mandatory The Fund ID The rule TIVEDATE and Rule effective date effective date for which combination corporate should be the action for the same as defined fund has to be in 01FDR maintained DIVIDENDD Alphanum 1 Optional Valid values are Enter the ECLAREFRE eric D for Daily
57. new transactions I for amended transactions and D for transactions to be deleted PAYMENTREFERENCEN UMBER VARCHAR2 50 Optional Used for entering the reference number for a payment PAYMENTMODE VARCHAR2 Should be a valid payment mode It cannot be Multi Payment Facility M which is not allowed at Settlement Level If Payment Mode for Transaction is other than Multi Payment facility then Payment mode for settlement should be same as that for the transaction SUBPAYMENTMODE VARCHAR2 Optional Should be a valid Sub payment mode It cannot be Multi Payment Facility M which is not allowed at Settlement Level If Payment Mode for Transaction is other than Multi Payment facility then Sub Payment mode for 2 45 ORACLE settlement should be same as that for the transaction PAYMENTCURRENCY VARCHAR2 Optional Should be a valid Currency as defined in the system PAYMENTDATE DATE 10 Optional Date at which the payment has happened PAYMENTAMOUNT NUMBER 15 Optional Amount for which the payment has happened BANKCHARGES NUMBER 15 Optional This field is used for capturing any charges that are bourned by the Bank PAYMENTCHARGES NUMBER 15 Optional This field is used for capturing any charges that are bourned by the Customer EXCHANGERATESOURG E VARCHAR2 Optiona
58. processing information PROCESSID Alphanumeric 50 Mandatory Same value This should as in 00GEN identify the ProcessID upload uniquely This should also be unique within a file and it allows to identify imported records later 3 27 ORACLE FUNDID Alphanumeric Mandatory The Fund ID is a unique Identification for each Fund and it indicates the fund for which Transaction processing information has to be uploaded RULEEFFEC Date Mandatory The Fund ID The rule TIVEDATE and Rule effective date effective for which date transaction combination processing should be information for the same as the fund has to defined in be maintained 01FDR TRANSACTI Alphanumeric Mandatory Valid values Indicate the ONTYPE are 01 for value for which IPO 02 for the transaction Subscription type for which 03 for the rules are Redemption being set up 04 for Switch from operation 05 for transfers and so on upto 10 3 28 ORACLE i GROSSORN Alphanumeric Optional G for Gross Opting for a ET N for Net gross or net and B for mode in Both transaction processing is mode is only available for IPO subscription or redemption transactions For transactions with a gross processing mode the value of the transaction whether as an amount or a number of units will be processed as a gross value from which any applicable charges will be deducted For trans
59. set to null ClientType N for naturals Char 1 This will be set to null Tax_Number Nulls Char 12 This will be set to null TRUSTNUMBER Nulls Char 12 This will be set to null AnnuType C for compulsory V for Char 1 This will be set to C voluntary GN18 Y or N Char 1 This will be set to N FundName The pension Fund Name Char 70 Fund Name Frequency Frequency of the annuity Char 1 The frequency of the annuity income Payments_left No of payments left within Number The remaining number of the tax year 2 annuities to be executed TaxEarnings YTD The taxable earning to date Number The total annuity till date for the tax year 8 2 including the tax already applied TaxDeducted_YTD Tax deducted for the tax Number The tax deducted for the year 8 2 current fiscal year TaxEarnings Taxable earnings for this Number Taxable earnings for this annuity income 8 2 annuity income TaxDeducted Tax to be deducted for that Number Tax to be deducted for that annuity income 8 2 annuity income 3 101 ORACLE Systemld The system ID as defined Char 10 This will be set to FCIS by the tax aggregation module Scheme Nulls Char 30 This will be set to null The control record for the export of information relating to tax has the following format Field Name Description Data Remarks Type Record
60. the system UNITHOLDERID String 12 Yes The unit holder ID available in FCIS EFFECTIVEDATE Date 10 No Effective Date 2 124 ORACLE G2UNITS Number 30 12 No Adjustable Units AUTH_STAT Varchar2 1 Yes Must be A ONCE_AUTH Varchar2 1 No RECORD_STAT Varchar2 1 No MAKER_ID Varchar2 15 Yes Maker ID MAKER_DT_STAMP Date 10 Yes Maker Date CHECKER_ID Varchare 15 Yes Checker ID CHECKER_DT_STAM Date 10 Yes Checker Date P MOD_NO Number 2 No Modification Number 2 17 Exchange Rate Upload Format Field Name Data Type Field Mandatory Chara Values Length cterist ics Ru les SOURCEID VARCHAR2 6 YES Source maintained in the system REECURRENCY VARCHAR2 3 YES non Currency of the ource VARCHAR2 3 YES Pair Currency for the EAIRCURRENCY exchange rate would be made available FXDEALDATE DATE 10 YES Should Effective date for the be Exchange rate applic ation date DATE 10 YES Should Value date for FXVALUEDATE be Forward Rates greate r than or equal to FXDE ALDA 2 125 ORACLE TE BUYRATE NUMBER 15 YES Buy Rate for the mentioned currencies NUMBER 15 YES Sell Rate for the SELLRATE mentioned currencies EXCHRATEFORREP NUMBER NO Flag to set whether ORT the maintained FX Rate is used for Reporting VARCHAR2 15 YES Maker Id of the USERID Exchange Rate IMPORTSTATUS VARCHA
61. the upload uniquely This should also be unique within a file and it allows to identify imported records later BULKCLIENTC ODE Alphanumeric Mandatory Valid authorized enabled Bulk client codes maintained in the system as a part of Entity maintenance IMPORTFILENA ME Alphanumeric 255 Mandatory This is the name of the file being uploaded into the FCIS system 3 86 ORACLE AMCID Alphanumeric 12 Mandatory Valid authorized enabled AMC maintained in the system as a part of Entity maintenance The fund rule upload defaulting would be based on both AMCID and the Bulk client code USERID Alphanumeric 15 Mandatory The fund rule MakerID would have the value of UserlD asa part of data storage in all the fund rule tables UPLOADMODE Alphanumeric 1 Mandatory Valid values Should be N for are N and l New fund rule And I for Amending an existing authorized fund rule GENERATEAUT Alphanumeric 1 Optional Valid values This indicates HFUNDRULE are A and whether the U fund rule uploaded should be a authorized fund rule or un authorized fund rule Serial Number 2 Segment Identification Number 01FEM Description This segment is used for providing Fund entity related information Segment Mandatory Optional Optional Multiple records allowed for the same Fund and Rule Effective Date Yes For vario
62. the Param code in Bulk client PREFERREDMAILMODE defaults in If not supplied will be the absence taken from the bulk client of defaults table information in the file NOTEPADAVAIL Number 1 Optional Could be either 0 False ABLE or 1 True If not supplied default will be 1 True FEECATEGORY String 3 Optional Value Should be a valid defaulted as category for the type of maintained investor individual or in Bulk client corporate If not defaults in supplied will be taken the absence from the bulk client of defaults table based on information the investor category in the file FEESUBCATEG String 6 Optional Value Should be a valid sub ORY defaulted as category for the category maintained If not supplied will be in Bulk client taken from the bulk client defaults in defaults table based on the absence the investor category of information in the file ADDITIONALINF String 60 Optional If not supplied will be ORMATION1 taken from the bulk client defaults table ADDITIONALINF String 60 Optional ORMATION2 ADDITIONALINF String 60 Optional ORMATIONS ADDITIONALINF String 60 Optional ORMATION4 ADDITIONALINF String 60 Optional ORMATIONS5 ADDITIONALINF String 60 Optional ORMATION6 2 14 ORACLE ADDITIONALINF String 60 Optional ORMATION7 ADDITIONALINF String 60 Optional ORMATION8 ADDITIONALINF
63. the Rule Effective Date of the fund FISCALE DATE 8 Optional The Fiscal End Enter the date on NDYEAR Date should be which the Fiscal later than or Year should end for same as the the fund current date of the system It should also be later than or same as the Rule Effective Date of the fund that is being set up 3 7 ORACLE AMCID Alphanumeric 12 Optional Valid authorized Specify the AMC that AMC defined in this Fund will be the system asa operative in part of entity maintenance BROKER Number 1 Optional Valid values are if brokers are to be SALLOW 1 and 0 mandatory for the ED given Fund then a value of 1 should be entered else enter 0 REGIST Alphanumeric 12 Optional Valid Registrar Enter the Registrar RARID defined in the ID for the fund being system as a part set up of Entity maintenance TRUSTE Alphanumeric 12 Optional Valid Trustee Enter the Trustee ID EID defined in the for the fund being set system as a part up of Entity maintenance FUNDEN Number 1 Optional Valid values are Every new fund is ABLED 1 and 0 created in the system initially as an enabled fund Hence the value can be defaulted to 1 MINHOL Number Optional Enter the lock in DINGPE period for the RIOD investors investing in the fund so that outflow transaction would be possible only after this period MINAMO Number 15 Optional Maximum of 3 Enter the minimum UNTFOR de
64. the absence telephone for the unit of holder or not If null it will information be picked up from the in the file bulk client defaults table TELEPHONESW Number 1 Optional Value Could be either 0 false defaulted as or 1 true to indicate maintained whether redemption in Bulk client transactions can be defaults in accepted through the absence telephone for the unit of holder or not If null it will information be picked up from the in the file bulk client defaults table WRITECHECKF Number 1 Optional Value Could be either 0 False ORMMF defaulted as or 1 True If not maintained supplied will be taken in Bulk client from the bulk client defaults in defaults table the absence of information in the file FEDWIREACHP Number 1 Optional Value Could be either 0 False AYMENT defaulted as or 1 True If not maintained supplied will be taken in Bulk client from the bulk client defaults in defaults table the absence of information in the file IRSNOTIFICATI String 10 Optional Value Could be either 0 False ON defaulted as or 1 True If not maintained supplied will be taken in Bulk client from the bulk client defaults in defaults table the absence of information in the file 2 12 ORACLE ROAINVESTOR_ Number 1 Optional Could be either 0 False or 1 True This should be read only when ROA Option at Investor in AMC policies table i
65. to indicate if the unit holder has specified as to how transactions are to be ordered FIFO Tansaction receipts and FIFO across products MAINTAINTR ADINGBOX Number Optional Valid values are 0 and 1 This is used to indicate to the system that the trading functions must be enabled for the fund This means that for the fund all trading transactions and the relevant processing are allowed 3 22 ORACLE NAVLOT Number Optional Specify the number of units for which the NAV quote is deemed to be applicable for the fund CDSCFUND Varchar2 Optional Valid values This is used to 1 LOCOM indicate that the Contingent Deferred Sales A Manket Charge CDSC Price is applicable for the transactions 3 Not in this fund Applicable 4 CDSC Class B Default Not Applicable L M N B CDSCAPPLI Number Optional Valid values This is used to CABLEFORS are 0 and 1 indicate that the WITCHES Contingent Deferred Sales Charge CDSC is applicable to switch or exchange for the transactions in this fund REINVESTM Number Optional Valid values This is used to ENTFIRST are 0 and 1 indicate that reinvestment transactions must be taken up first for aging during computation of Contingent Deferred Sales Charge for redemption transactions in this fund VATVALUE Number Optional Maximum of 2 Value added tax deci
66. which the bulk client has maintained the default details UPLOADMODE String 1 Mandatory Upload mode can be N for new transactions and for amended transactions REFUNITHOLDERI String 12 Optional Must be left blank D FUNDID String 25 Mandatory The ID of a valid fund maintained in the system DISTRIBUTIONMO String 1 Mandatory The mode of distribution could DE be any of the following R Reinvest P Pay and B Both PAYMENTSPLITP Number 5 2 Optional Percentage in a valid ERCENTAGE percentage format This will be one hundred percent for Pay distribution mode and is mandatory information for both Pay and Both distribution modes 2 72 ORACLE CHEQUEPAYMEN Number 5 2 Optional Percentage in a valid TSPLIT percentage format Sum of check payment split and transfer payment split should be equal to 100 TRANSFERPAYM Number 5 2 Optional Percentage in a valid ENTSPLIT percentage format Sum of check payment split and transfer payment split should be equal to 100 XFERBANKCODE String 12 Optional The Code of a valid bank maintained in the system XFERBRANCHCO String 12 Optional The Code of a valid branch DE maintained in the system XFERACCOUNTT String 1 Optional A valid Account Type YPE maintained in the system XFERACCOUNTN String 16 Required if The account number of the UMBER PaymentSp transfer account litPercenta ge gt 0 and Payment by Transfer XFE
67. 1 ORACLE PAYMENTLA NUMBER Optional In the case of G redemption transactions specify a value to indicate the number of days by which the resulted redemption payouts would be lagged or deferred after the redemption transaction has been allotted and confirmed To arrive at the actual date of redemption payment both the confirmation lag if specified and the payment lag if specified here are taken into consideration For instance if the redemption transaction was allocated on 15th January and both the confirmation lag and payment lag were specified as 2 then the actual redemption payout to the unit holder would be effected on 19th January 15 2 2 provided itis nota holiday in the system and provided there are no intervening holidays i 3 42 ORACLE TRANSACTI DATE DATE Optional Specify the ONCUTOFF time on a given TIME working day before which a transaction of the selected type will be accepted with the transaction date being the current date Beyond this time ona working day the transaction date will be set by default to be the next working date ENFORCEH NUMBER 1 Optional You can OLDINGPER indicate that the IOD minimum holding period specified for the fund in the Fund Demographics profile must be enforced as mandatory for the transaction type by selecting this option APPLYENTR NUMBER 1 Optional Applica
68. 6 Mandatory ID of the fund the funds into which the investment amount is being moved RATIO Number 3 Optional Indicates the percentage of the amount that must be invested in the above fund 2 13 6 Policy Transaction Fee Override related Segment Formats Serial Number 6 Segment Identification Number OOFO ae ORACLE Description This segment is used for providing information related to fee override that is to be uploaded into the system Segment Mandatory Optional Optional Field Name as expected in the file Data type Field length Mandatory Characteristics rules Values SEQUENCENUM BER Number 10 Mandatory Sequence no of transaction record in the file Each uploaded transaction has a unique sequence number PROCESSID String 50 Mandatory The Process ID along with the system generated sequence number identifies the uploaded record uniquely Each file must have a unique Process ID and it should be same within a file for all the records POLICYTXNNUM BER String Mandatory Is blank for new transactions For amendment deletion and edition either the reference number or transaction number should be specified TXNDATE Date Mandatory Indicates the value date of transaction If this is specified in the import file it must be on or later than the current application date If
69. BPAYME String 2 Optional Value Could be either of the NTMODE defaulted as following values Q Cheque maintained in T Third Party Bulk client defaults in the absence of information in the file PAYMENTTY String 1 Optional Value Could be either of the PE defaulted as following values S Self T maintained in third Party Bulk client defaults in the absence of information in the file THIRDPART String 255 Optional Accepted from the User YPAYMENT REFERENC E THIRDPART String 20 Optional Accepted from the User YPAYMENT ADDRESS 2 95 ORACLE THIRDPART String 20 Optional Accepted from the User YPAYMENT CITY THIRDPART String 20 Optional Accepted from the User YPAYMENT STATE IDSUSSTAT Number 1 Optional Accepted from the User E String 10 Optional Accepted from the User THIRDPART YPAYMENTZ IPCODE String 100 Optional Accepted from the User XFERACCO UNTHOLDE RNAME ENTITYTYP String 1 Optional Could be any valid entity type E from Entity table ENTITYID String 12 Optional Could be any valid entity Id from Entity table REINVESTM String 2000 Optional The following values would ENTDETAIL have to be supplied with S delimiters in case of more than one set of reinvestment Details The delimiter would be either comma for each set and a semi colon to separate the two sets of reinvestment details AUTHTYPE String 1 Mandatory Value Could be either of t
70. Bulk client defaults in the absence of information in the file 2 92 ORACLE OTHERINFO 22 String 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO 23 String 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO 24 String 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO 25 String 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO 26 String 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO 27 String 60 Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file 2 93 ORACLE OTHERINFO String 60 Optional Value 28 defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO String 60 Optional Value 29 defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO String 60 Optional Value 30 defaulted as maintained in Bulk client defaults in the absence of informa
71. CREDITCAR NUMBER 1 Optional Valid values This is used to DALLOCON are 0 and 1 indicate if all PARWITHCA credit card SH transactions to be treated on par with cash transactions If this is true then during allocation the credit card transactions will be taken for allocation for the same day The units allocated will be provisional and will be confirmed only after the credit card transaction is cleared 3 38 ORACLE LIMITREDE Alphanumeric 1 Optional Valid values The mode MPTIONMO are P for based on which DE Percent U redemption will for Units and be limited A for Amount NATUREOFL Alphanumeric 1 Optional Indicates IMIT whether it is A or U or B TRANSFERA NUMBER 1 Optional Mark this check LLOCONPA box if you want RWITHCASH all transfer transactions to be treated on par with cash transactions If this is true then during allocation the transfer transactions will be taken for allocation for the same day The units allocated will be provisional and will be confirmed only after the bank transfers are cleared MININITIALT NUMBER 15 Optional Maximum of Minimum XNAMOUNT 3 decimals amount allowed applicable for initial transaction MININITIALT NUMBER 15 Optional Maximum of Minimum units XNUNITS 3 decimals applicable for allowed initial transaction MINSITXNA NUMBER 15 Optional Maximum of Minimum MOUNT 3 decimals amount allowe
72. D along with the ID system generated sequence number identifies the uploaded record uniquely Each file must have a unique Process ID and it should be same within a file for all the records POLICYTX String 16 Mandatory Is blank for new transactions For NNUMBER amendment deletion and edition either the reference number or transaction number should be specified FUNDID Alphan 6 Mandatory ID of the fund involved in the umeric transaction A valid fund id maintained in the system RATIO 3 Optional Indicates the investment ratio in the fund specified out of the total contribution towards the Policy TXNAMOU Number Mandatory The investment amount of the NT transaction UNITSAPP Number 15 6 Optional The number of units to be made in LIED the fund out of the total contribution towards the Policy WAG Optional The take on WAC This will be used as the opening WAC in the fund CGT computation for initial investment transaction will be based on the take on WAC AUTOCLE 1 Mandatory Indicates whether 100 outflow ARPROVI transactions include provisionally SIONALBA allotted units LANCE Either 1 or 0 AUTOCLE 1 Mandatory Indicates whether 100 outflow 2 111 ORACLE ARREINVE STMENTS transactions include freeze held and reinvestment units Either 1 or 0 Serial Number 4 Segment Identification Number OOSTL 2 13 4 Policy transaction fee settlement details re
73. DDRE payments only SSLINE4 TRANSFE String 20 Optional Required for payment by RREFERE credit cards NCENUMB ER 2 64 ORACLE CIFNUMB String 12 Optional CIF Number of the unit ER holder If not provided it is picked from the system TOCIFNU String 12 Optional Required only if the MBER standing instruction is for the transfer case POLICYNU String 16 Optional At present not required as MBER itis for the LEP PRODUCT String 10 Optional At present not required as ID it is for the LEP ENTITYTY String 1 Optional If the payment mode is by PE transfer and the payment type is broker then this should be B else it can be left blank ENTITYID String 12 Optional For the above condition if the entity type is B then a valid broker code should be specified REFFUNDI String 6 Optional Specify the Fund code D here REFTOFU String 6 Specify the Fund code if NDID the standing instruction is for switch type of instruction DELIVERY String 2000 Optional Must be left blank DETAILS CERTIFIC String 2000 Optional Applicable only for Scrip ATEDETAI based funds LS MINHOLD Numb 1 Optional Should be 0 CHKREQ er FROMFUN String 10 Optional DPRICEBA SIS TOFUNDP String 10 Optional RICEBASI S 2 65 ORACLE SIINTERM String 2000 Optional Concatenated val
74. Date OOGEN This segment is used for Mandatory and will No providing information that is be the driving common to the other fund header segment for related rules that need to be all the other uploaded in the system segments 01FEM This segment is used for Optional Yes For various providing Fund entity related entity types and information that needs to be entity ids uploaded in the system for the Fund 02FAB This segment is used for Optional Yes For various providing Fund agency branch transaction types back dating information that needs to be uploaded in the system for the Fund 3 85 ORACLE 03FBC This segment is used for providing Fund based calendar related information that needs to be uploaded in the system for the Fund Optional Yes For various years Serial Number 1 3 1 3 1 Fund Related Information Seqments Formats Segment Identification Number OOGEN Description This segment is used for providing information that is common to the other fund related rules that need to be uploaded in the system Segment Mandatory Optional Mandatory and will be the driving header segment for all the other segments Multiple records allowed for the same Fund and Rule Effective Date No Field Name Type Maximum Length Mandatory Optional Characterist ics Validations applicable Description PROCESSID Alphanumeric 50 Mandatory This should identify
75. E part of Payment routing details INTERME VARC_ 100 Optional Used to capture the DIARYINF HAR2 Intermediary Information O other information as a part of Payment routing details FURTHER VARC 35 Optional Used to capture the Credit CREDITNA HAR2 Name as a part of ME Payment routing details FURTHER VARC 35 Optional Used to capture the Credit CREDITAC HAR2 Account Number as a part CTNO of Payment routing details REFEREN VARC 35 Optional Used to capture the CE1 HAR2 Reference as a part of Payment routing details REFEREN VARC 35 Optional Used to capture the CE2 HAR2 Reference as a part of Payment routing details 2 68 ORACLE NOOFSIT Numb 4 Optional RANSACTI er ONS SILEVEL String 1 Optional Valid values are Could be either of the F and P following values F Fund Level and P Plan Level PLANCOD String 6 Optional E FUNDDET String 4000 Optional Fund details should be in AILS the following format separated by semicolon Fundid lssueid CertReqd S ingleCert MinHoldChkReq FromFundBasis contributio npercentage contributiona mount RefFundid AuthStat us FIRSTPAY Date Optional MENTDAT E IBAN String 36 Optional Used to capture the IBAN CAMPAIG String 6 Optional Used to capture the NCODE CAMPAIGNCODE BENEFICI String 36 Optional Used to capture the ARYIBAN BENEFICIARYIBAN INTERME String
76. Format Bank Charged Beneficiary Beneficiary Add1 Beneficiary Add2 Beneficiary Add3 Beneficiary BIC Code Beneficiary Acct No ae ORACLE Beneficiary Info Intermediary Intermediary Add1 Intermediary Add2 Intermediary Add3 Intermediary BIC Code Intermediary Acct No Intermediary Info Further Credit Name Further Credit Acct No Reference 1 Reference 2 INTERMEDIARY String 2000 Optional Intermediary details are DETAILS separated by for each intermediary Each intermediary should have the following fields separated ENTITYTYPE ENTITID SPLITPERCENT INTRODUCER DEFAULTINTERMEDIAR y Entity Type should be B Entity ID would be a valid Broker in the system ACCOUNTSTMT String 1 Optional Value Could be any of the FREQ defaulted as values in the following list maintained from Frequency Table D in Bulk client Daily W Weekly F defaults in Fortnightly M Monthly the absence Q Quarterly H Half of Yearly Y Yearly information in the file YTDSTMTREQD Number 1 Optional Accepted from the user s specification for the same in the hand off file contents By default it is deemed to be No DATEOFBIRTH DATE Optional Accepted from the user s specification for the same in the hand off file contents GUARDIANNAM String 70 Optional Accepted from the user s E specification for the same in the hand off file content
77. ID and Rule effective date combination should be the same as defined in 01FDR The rule effective date for which fund residency list information for the fund has to be maintained 3 61 ORACLE COUNTRYCO DE Alphanumeri c Valid country code present in the system as a part of Domicile in Params maintenance If no country code is mentioned and this field is left blank then it means that there is no restriction on the investor residing in any domicile However if valid value is entered then the fund would be restricted for investors residing in that domicile Serial Number 11 Segment Identification Number 10FFM Description This segment is used for providing Fund formula information Segment Mandatory Optional Optional Multiple records allowed for the same Fund and Rule Effective Date Yes Field Name Type Maximu Mandatory Characteristics Description m Optional Validations Length applicable SEGMENTID Alphanumeric 20 Mandatory Default value Standard value 10FFM of 10FFM to uniquely identify Fund formula related information PROCESSID Alphanumeric 50 Mandatory Same value as This should in OOGEN identify the ProcessID upload uniquely This should also be unique within a file and it allows to identify imported records later 3 62 ORACLE FUNDID Alphanumeric 6 Mandatory The Fund ID is a unique Ide
78. Interface Format cccccccccsccsescesscesscesecusecusecseeseecseeeseeeseeeseeseeeeeuseceseenseenaeenas 3 115 Interface to Check for Transaction Unrelated to GL Extraction 3 116 File Format for OMIPAY FILE INTERFACE w esccesccesceseesseesseeeeeeseeseeesecesecesecnseceaecnsecneeeneeeneees 3 117 File format for Header Record 02 2 sss sssessnseaseasesassusees cane cies casesvegsasnasvacadesuecisaaveasusnnseseaseapigagdesnress 3 117 File format for Detailed Record wossccsissssssssessssessesassvsees case cena casecegeascasvasasesevesigaavoasusnnveseaseasepsgeesnress 3 118 1 1 1 2 1 3 1 4 1 5 1 5 1 1 About This Manual Introduction Welcome to Oracle FLEXCUBE Investor Servicing a comprehensive mutual funds automation software from Oracle Financial Servicing Software Ltd This Oracle FLEXCUBE Investor Servicing User Manual helps you use the system to achieve optimum automation of all your mutual fund investor servicing processes It contains guidelines for specific tasks descriptions of various features and processes in the system and general information Related Documents The User Manual is organized in to various parts each discussing a component of the Oracle FLEXCUBE Investor Servicing system Audience This Fund Manager User Manual is intended for the Fund Administrator users and system operators in the AMC Organization This volume of the Fund Manager User manual is organized under the follow
79. LEPHON specification E2 SECONDAR String 15 Optional Accepted from the user s YFAX specification SECONDAR String 60 Optional Accepted from the user s YEMAIL specification EFFECTIVEF DATE Optional Accepted from the user s ROMDATE specification EFFECTIVET DATE Optional Accepted from the user s ODATE specification SWIFTADDR String 80 Optional Accepted from the user s ESSLINE1 specification SWIFTADDR String 80 Optional Accepted from the user s ESSLINE2 specification 2 88 ORACLE SWIFTADDR String 80 Optional Accepted from the user s ESSLINE3 specification SWIFTADDR String 80 Optional Accepted from the user s ESSLINE4 specification SWIFTCOUN String 3 Optional Accepted from the user s TRY specification SWIFTBICC STring 12 Optional Accepted from the user s ODE specification BANKDETAI String 2000 Optional The following values would LS have to be supplied with delimiters in case of more than one set of Bank Details is maintained Bank Code Branch Code Account Type Account Number Account name Account Currency Default The delimiter would be either comma for each set and a semi colon to separate the two sets of bank details OTHERINFO String 60 Optional Value 1 defaulted as maintained in Bulk client defaults in the absence of information in the file OTHERINFO String 60 Optional Value 2 defaulted as maintained in Bulk client defaults
80. MINLOCKIN Number Optional Valid values PERIODFOR are Greater GAIN than or equal to the Min Lock in Period and Less than or equal to the Max Lock in Period AMOUNTBL_ NUMBER Optional Valid values OCKALLOW are 0 and 1 ED CALCULATE NUMBER Optional Valid values FEEINTXNC are 0 and 1 CY INCLUDEHO VARCHAR2 Optional Valid Values LDINGPERI are 0 and 1 OD 3 26 ORACLE BLOCKPRIO RITYNO NUMBER Optional Block priority For amount should not be block the priority a numeric will be derived value with this number and for amount unblock the priority would be reverse of this order DIVIDENDE QUALIZATIO NAPPLICAB LE NUMBER Optional Valid Values Dividend are 0 No equalization and 1 Yes applicable flag should be set to 1 to support dividend income equalization funds Serial Number 5 Segment Identification Number 04TPR Description This segment is used for providing Transaction processing rules information Segment Mandatory Optional Mandatory Multiple records allowed for the same Fund and Rule Effective Date Yes For each transaction type there is a separate record Field Name Type Maximum Mandatory Characterist Description Length Optional ics Validations applicable SEGMENTID Alphanumeric 20 Mandatory Default value Standard value 04TPR of O04TPR to uniquely identify Transaction
81. Mandatory Characteristic Description Length Optional s Validations applicable SEGMENTID Alphanumeri 20 Mandatory Default value Standard value of c 02SCR 02SCR to uniquely identify Shares characteristics information 3 9 ORACLE PROCESSID Alphanumeri 50 Cc Mandatory Same value as in OOGEN Process ID This should identify the upload uniquely This should also be unique within a file and it allows to identify imported records later FUNDID Alphanumeri 6 Cc Mandatory The Fund ID is a unique Identification for each Fund and it indicates the fund for which Shares characteristics information has to be uploaded RULEEFFEC TIVEDATE Date 8 Mandatory The Fund ID and Rule effective date combination should be the same as defined in 01FDR The rule effective date for which share characteristic information for the fund has to be maintained SCRIPBASE Number 1 Optional D Valid values are 0 1 and 2 This field is used to designate the applicability of certificate issue for investment in the fund The value 0 indicates Scripless 1 indicates Scrip based and 2 indicates Certificate option PARVALUE Number 15 Optional Maximum of 6 decimal places allowed Enter the Par Value for the fund Normally this will be the base price for Initial Public Offer IPO period However you can change the base price f
82. Mandatory Could be either A ATUS 1 Authorized or U Unauthorized LOADGR String VARCHARZ2 Optional Could be any valid group ID OUPID 16 maintained in system FUNDID String VARCHARZ Optional Could be any valid fund ID 6 maintained in the system LOADID Number NUMBER 5 Mandatory Could be any valid load ID maintained in the system LOADSL String VARCHARZ Optional Could be any valid slab ABDETAI 2000 details maintained for the LS load in the system It should have the slab number and the return value Field separator is and record separator is slabno gt 2 100 ORACLE lt returnvalue gt DERIVED String VARCHARZ Optional Could be any valid slab LOADSL 2000 details maintained for the ABDETAI derived load in the system LS It has derived load id and return value Field separator is and record separator is lt derivedioadid gt lt returnvalue gt APPLYR Number NUMBER 1 Optional Could be either 0 No or 1 ETVALUE Yes TOALLSL ABS RETURN Number NUMBER 1 Optional If the above field is 1 then VALUE 5 6 return value is applicable to all the slabs PRODUC String VARCHARZ2 Optional Could be any valid product TID 10 ID maintained in the system For UT it should be UT ALL Option would be applicable for all products MAKERID String VARCHAR2 Optional If not supplied in the handoff
83. N for are null N New fund rule and l This And I for is to override Amending an the value existing mentioned authorized fund as a part of rule header segment GENERATEAUT Alphanumeric 1 Optional Valid values This indicates HFUNDRULE are null A whether the and U This fund rule is to override uploaded should the value be an mentioned authorized fund as a part of rule or un header authorized fund segment rule Serial Number 4 Segment Identification Number 03FBC 3 93 ORACLE Description This segment is used for providing Fund based calendar information Segment Mandatory Optional Optional Multiple records allowed for the same Fund and Rule Effective Date Yes for various years Field Name Type Maximum Mandatory Characterist Description Length Optional ics Validations applicable SEGMENTID Alphanumeric 20 Mandatory Default value Standard value 03FBC of O3FBC to uniquely identify Fund agency branch back dating limit information PROCESSID Alphanumeric 50 Mandatory Same value This should as inOOGEN identify the ProcessID upload uniquely This should also be unique within a file and it allows to identify imported records later FUNDID Alphanumeric 6 Mandatory Depending The Fund ID isa upon the unique scheme Identification for cross each Fund in reference the system maintained Enter the fund at the Bulk for which a
84. NE4 COUNTRY ZIPCODE EMAIL CONTACTPERSON Beneficiary Relation Beneficiary Tax id 0 0 UNITHOLDERN Number 1 Optional Indicate if the Unit holder RI is a Non resident EUSDOPTION String 1 Optional Applicable W Withholding Tax only for E Exchange of EUSD Information Countries T Tax Certificate Value defaulted from defaults maintenance in the absence of information in the file TAXCERTIFICA Date Optional Ifthe EUSD Tax certificate expiry date TEEXPDATE Option is T then tax certificate expiry date is mandatory PLACEOFBIRTH String 80 Optional Ifthe EUSD Unit Holder s Place of Option is T 2 19 ORACLE then tax certificate expiry date is mandatory birth COUNTRYOFBI RTH String Optional If the EUSD Option is T then tax certificate expiry date is mandatory Unit Holder s Country of birth It should be the country code of the country FATFORNONFA TF String 4 Optional F FATF Country N Non FATF Country CHASINGDATE Date Optional In case the KYC list is incomplete for a unit holder and the document has been requested the date on which the document chasing action must be initiated ADDNCOMMEN TS String 255 Optional Any additional narrative or descriptive text if any concerning the document and the chasing date ALLKYCRECIEV ED Number Optional Can have a value of 0 or 1 1 All the reque
85. R Full Reinvestment If the Income Distribution Setup for the unit holder has not yet been specified the fund level default Unit Holder Distribution Mode to be considered for the unit holder can be specified here For stock dividends the only possible option is Reinvestment as others would not be applicable 3 54 ORACLE EXCHANGE RATEDATEB ASIS Alphanum eric Optional Valid values are P Payment Date R Reference Date Specify the basis upon which the exchange rate will be applied for dividend processing The system provides two options Reference Date and Payment Date RESTRICTID S Number Optional Valid values are 0 and 1 This is used to indicate that specific income distribution setups for unit holders may be overridden For stock dividends this value should always be set EPULOT Number Optional Specify the number of units for which the EPU quote is deemed to be applicable for the fund Setting up EPU components is not applicable for stock dividends DIVLOOKAH EAD Number Optional This is to indicate that in the event of intervening holidays the system would obtain the EPU information and process dividends for the holiday period ahead of the prior business day for the fund 3 55 ORACLE CORPORAT EACTIONTY PE Alphanum eric Mandatory Valid values are C
86. R2 1 NO Status of the Import ERRORDESC VARCHAR2 255 NO Error description 2 126 ORACLE 3 1 3 Appendix B Upload File Formats B Fund Rules Upload Formats The upload file would contain various segment identification number in the first column to indicate the type of data that is present in that entire row Each segment identified by a unique tag indicates the type of fund rule information such as Demographics Shares Characteristics and so on The possible segments that would be used in Fund upload are given below for reference Segment Description Segment Multiple records Identification Mandatory allowed for the Number Optional same Fund and Rule Effective Date OOGEN This segment is used for Mandatory and will No providing information common be the driving to the other fund rules that header segment for need to be uploaded in the all the other system segments 01FDR This segment is used for Mandatory No providing Fund Demographics related information 02SCR This segment is used for Mandatory No providing Shares Characteristics related information 03GOR This segment is used for Mandatory No providing General Operating rules information 04TPR This segment is used for Mandatory Yes For each providing Transaction transaction type processing rules information there is a separate record O5TCM This segment is used for Mandatory Yes For each providing Transaction transaction type P
87. RACCOUNTC String 3 A valid currency maintained in URRENCY the Currency Maintenance AGENTCODE String 12 Mandatory The Code of a valid agent maintained in the system BRANCHCODE String 12 Mandatory Valid branch maintained in the system RULEEFFECTIVE Date 10 Mandatory FCIS System Date DATE MAKERID String 15 Optional If this information is specified in the import file no validation is made with regards to the user profile maintenance in the FCIS system If it is not specified the ID of the logged in user at the time of import is taken by default as the Maker ID MAKERDATE Date 10 Optional If the date is not specified in the import file the application date is considered to be the 2 73 ORACLE Maker Date by default CHECKERID String Optional If this information is specified in the import file no validation is made with regards to the user profile maintenance in the FCIS system If it is not specified it is defaulted to SYSTEM This information is applicable for the generation of authorized income distribution records CHECKERDATE Date Optional If the date is not specified in the import file the application date is considered to be the Checker Date by default This information is applicable for the generation of authorized income distribution records REINVESTMENTD ETAILS String 2000 Optional The data required for the reinvestment details The fi
88. RATION String 3 Optional Value Could be any of the valid TYPE defaulted as values maintained in maintained Corporation Maintenance in Bulk client defaults in This information can be the absence specified only for of corporate investors information Investor Type C in the file FIRSTAUTHORI String 70 Optional This information can be ZEDSIGNATOR specified only for Y corporate investors Investor Type SECONDAUTH String 70 Optional This information can be ORIZEDSIGNAT specified only for ORY corporate investors Investor Type THIRDAUTHORI String 70 Optional This information can be ZEDSIGNATOR specified only for Y corporate investors Investor Type CONTACTNAME String 70 Optional Accepted from the user s specification for the same in the hand off file contents MINNOOFCORP Number Optional Accepted from the user s ORATESIGNAT specification for the same ORY in the hand off file contents SCHEMECROS 60 Optional SREFNO UHBASECURRE String 3 Optional Could be any of the valid NCY currencies maintained in Currency Maintenance If this information is not given in the import file then the default unit holder base currency specified in the Bulk Client Defaults Maintenance for the bulk client will be used 2 10 ORACLE LANGUAGE String 12 Optional Could be any of the languages defined in the system If this information is not given in the import file then the Default Language Value menti
89. Serial Number 1 Segment Identification Number OOPXN 2 13 1 Policy Transaction Upload Segment Formats Description This segment is used for providing information related to policy transactions that is to be uploaded into the system Mandatory Mandatory and will be the driving header segment for all the other segments Field Name Data Field Mandatory Characteristics Values as type length rules expected in the file SEQUENCE Number 10 Mandatory Sequence no of transaction NUMBER record in the file Each uploaded transaction has a unique sequence number PROCESSI String 50 Mandatory The Process ID along with D the system generated sequence number identifies the uploaded record uniquely Each file must have a unique Process ID and it should be same within a file for all the records BULKCLIEN String 12 Mandatory The Code of the bulk client TCODE IMPORTFIL String 255 Mandatory The name of the file as ENAME specified in the interface details UPLOADM String 1 Mandatory N for new ODE D for transactions to be deleted 2 103 ORACLE R for reversal of transactions A for authorization of transactions E for transactions to be edited AMCID String Mandatory The ID of the AMC for which the bulk client has maintained the default details This should be same within a file for all the records POLICYT
90. UMBE String 16 Optional Should be left R blank This field is not used as it is for Life and Endowment products PRODUCTID String 10 Optional Should be left blank This field is ae ORACLE not used as it is for Life and Endowment products LOIAPPLICABLE Number Optional 0 or 1 field If supplied would be validated to check if the unit holder is an LOI investor or not REFFUNDID String Optional Should be left Blank REFTOFUNDID String Optional Should be Blank ENTITYTYPE String Optional If the payment mode is by transfer and the payment type is broker then this has to be B Else it can be left ENTITYID String Optional For the above condition if the entity type is B then a valid broker code should be entered CERTIFICATEM ESSAGE String 2000 Optional Applicable only for certificate based funds SETTLEMENTD ATE Date Optional System would default based on the Transaction processing rules specified DELIVERYDETA ILS String 2000 Optional Should be left blank Applicable only if Delivery options have been specified for the fund DELIVERYOPTI ON String i Optional Should be left blank Applicable only if Delivery options have been specified for the 2 39 ORACLE fund TRANSACTION SUBTYPE String i Optional
91. Upload Format Oracle FLEXCUBE Investor Servicing Release 12 0 April 2012 Oracle Part Number E51528 01 ORACLE FINANCIAL SERVICES Upload Format 1 gt Table of Contents ABOUT THIS MANUA LisssssscccavisssssssccstessascnccsssscsstessantsesasisesesesscssnscescactsessceseasansceeasachiecsGacesteosssassssscesdecsvauese 1 1 1 1 INTRODUCTION 5 i sesevscs shes secuscncthds coevssGaab desea AE A A E RI 1 1 1 2 RELATED DOCUMENTS vies sce cicshossceed Seas cetsws eben aaa dsce E a a a a a A Eaei Ea a NA 1 1 1 3 ANUIDIENGE EARE E AE EAE EEA AANE 1 1 1 4 OI LENNAN U ONERE EE A E E E ei soeveseeseieas 1 1 1 5 CONVENTIONS USED IN THIS MANUAL c cessscceseeecsseceseeecsaeceeeecsaecesceecsaecssceecsaeeesneecsaecesaeecsaeeseneecsaeeseaeess 1 1 1 5 1 General Conventions nriran e A A AR E E E vdetabesessddiwerdesidbevdsssbecteecdbea sens l 1 1 5 2 Keyboard Conventions ndana eiee a E E EE EE E E EAER 1 2 1 6 GLOSSARY ORICONS nenien e n a a e a e e a a a 1 2 1 7 ABBREVIATIONS AND ACRONYMS ssccesseessseceseeecssecesceecsaecesneecsaecesneecsaecesneecsaeesneecsaeceeeeecsaeeeeeeeceaeeseneess 1 3 1 8 GETTING HELP eon Shee cebetaceuen seb tated desta ceubened oh cca et beh but tagn decent bees deen a opbeh lobes a va ddennt e A e ai 1 4 APPENDIX A UPLOAD FILE FORMATS A ccscsssssssssssssscsssscsssscssssssssscsssssssecsssssssescssssssnssessssssssseseses 2 1 2 1 UPLOAD FILE FORMATS i i nar i n e aii e E OER 2 1 2 2 UNITHOLDER FILE
92. X NNUMBER String Mandatory Is blank for new transactions For amendment deletion and edition either the reference number or transaction number should be specified POLICYNU MBER String Mandatory Any additional reference number that can be given optionally No validations will be made for the same The system will generate and update the Reference Number based on the Bulk Client Default Maintenance For amendment deletion or rejection either the reference number or transaction number is mandatory TXNREFER ENCENUM BER String Optional Any additional reference number that can be given optionally for new transactions No validations will be made for the same The system will generate and update the Reference Number based on the Bulk Client Default Maintenance For amendment deletion or rejection either the reference number or transaction number is mandatory 2 104 ORACLE TXNTYPE Mandatory Type of the Transaction The following are the valid transaction types allowed for bulk upload 62 Top up transaction 65 Surrender transaction 66 Switch transaction TXNDATE Date Mandatory Indicates the value date of transaction If this is specified in the import file it must be on or later than the current application date If not the application date is considered by default to be the transaction date Backdated transactio
93. actions with a net processing mode the amount value of the transaction will be processed as a net value apart from the charges TRANSACTI DATE 8 Optional Enter a date to ONSTARTD specify that the ATE above mentioned transaction type will start from this date TRANSACTI DATE 8 Optional Enter a date to ONENDDAT specify that the E above mentioned transaction type will end on this date 3 29 ORACLE i TRANSACTI Alphanumeric Optional Valid values Enter a value to ONFREQUE are D for specify the NCY Daily W for frequency with Weekly F which the or B for Bi transaction type weekly M will operate for Monthly Q for Quarterly H for Half yearly Y for Yearly TRANSACTI NUMBER Optional Enter a value to ONSTARTPE specify the Start RIOD Period within the frequency mentioned above Within a particular frequency you have an option to restrict it to a particular period For example if the transaction Frequency is WEEKLY Start Period is 2 and End Period is 5 This means that the Fund is open for this transaction from second day till the fifth day of the week TRANSACTI NUMBER Optional The End period ONENDPERI has to be within OD the Transaction Frequency i e it can take values up to 7 weekly and not greater than that 3 30 ORACLE DATE DATE O
94. al Validations applicable SEGMENTID Alphanumeric 20 Mandatory Default value Standard 17KYC value of 17KYC is to uniquely identify Fund document description PROCESSID Alphanumeric 50 Mandatory Same value as This should in OOGEN identify the ProcessID upload uniquely This should also be unique within a file and it allows to identify imported records later 3 80 ORACLE FUNDID Alphanumeric 6 Mandatory The Fund ID is a unique Identification for each Fund and it indicates the fund for which Fund delivery instruction has to be uploaded RULEEFFECT Date 8 Mandatory The Fund ID The rule IVEDATE and Rule effective date effective date for which combination Fund delivery should be the instruction same as defined information for in 01FDR the fund has to be maintained DocumentDes Alphanumeric 255 Optional Captured only if Used for cription Code the KYCAML capturing the parameter is set document to True description Serial Number 18 Segment Identification Number 18MLD Description This segment is used for capturing the information in multiple languages against the language codes Segment Mandatory Optional Optional Multiple records allowed for the same Fund and Rule Effective Date Yes Field Name Type Maximum Mandatory Characteristics Description Length Optional Validations appl
95. along with the system generated sequence number identifies the uploaded record uniquely Each file must have a unique Process ID and it should be same within a file for all the records POLICYTXNNUMBER String Mandatory Is blank for new transactions For amendment deletion and edition either the reference number or transaction number should be specified BROKERCODE String Optional A valid broker code in the system should be entered SPLITPERCENTAGE Number 5 2 Mandatory if a broker is the Intermediary Percentage ina valid percentage format Percentage of the commission that the selected broker is entitled to receive on any transactions put through for the investor 2 13 3 Policy Transaction Fund Ratio Related Segment Formats Serial Number 3 Segment Identification Number OOFND Description This segment is used for providing information related to transaction fund ratio that is to be uploaded into the system Segment Mandatory Optional Mandatory Field Data Field Mandatory Characteris 2 110 ORACLE Name as type length tics rules expected in the file SEQUENC Number 10 Mandatory Sequence no of transaction record ENUMBER in the file Each uploaded transaction has a unique sequence number PROCESS String 50 Mandatory The Process I
96. ames are hard coded in DIVIDENDEPUIMPTBL Field Name Data Remarks Type Fund Id Char The fund id in FCIS 3 Distribution Type Char This field will be ignored and the dividend type in FCIS will 1 be treated as cash dividend Gross Or Net Char This field will be ignored Distribution 1 Declaration Date Date The interface will verify if there is any generated cash dividend record for this date and will update that record with the required EPU 3 99 ORACLE Payment Date Re Date This field will be ignored by the interface investment Date Gross Amount Float This will be a dividend component Component code GA Dividend Amount Float This will be a dividend component Component code DA Dividend Amount Float This will be a dividend component Component code AF Foreign Dividend Amount Float This will be a dividend component Component code WP Foreign Withholding Tax Dividend Amount Float This will be a dividend component Component code EF Foreign Exempt Interest Amount Float This will be a dividend component Component code IA Interest Amount Local Float This will be a dividend component Component code IL Interest Amount Float This will be a dividend component Component code IF Foreign Interest Amount Float This will be a dividend component Component code TF Foreign Withholding Tax NPI A
97. as to be maintained COUNTRYC ODE Alphanumeric Valid country code present in the system as a part of Domicile in Params maintenance If no country code is mentioned and this field is left blank then it means that there is no restriction on the sale of the fund However if valid value is entered then the fund would be restricted for sale in those countries 3 60 ORACLE Serial Number 10 Segment Identification Number O9FRL Description This segment is used for providing Fund residency list information Segment Mandatory Optional Mandatory Multiple records allowed for the same Fund and Rule Effective Date Yes Field Name Type Maximum Length Mandatory Optional Characteristics Validations applicable Description SEGMENTID Alphanumeri c 20 Mandatory Default value O9FRL Standard value of O9FRL to uniquely identify Fund residency list information PROCESSID Alphanumeri c 50 Mandatory Same value as in OOGEN Process ID This should identify the upload uniquely This should also be unique within a file and it allows to identify imported records later FUNDID Alphanumeri c Mandatory The Fund ID is a unique Identification for each Fund and it indicates the fund for which Fund residency list information has to be uploaded RULEEFFECT IVEDATE Date Mandatory The Fund
98. ased on the transaction type and reftype 2 13 7 Policy Transaction Derived Fee Override related Seqment Formats 2 14 Serial Number 7 Segment Identification Number OODFO Description This segment is used for providing information related to derived fee override Segment Mandatory Optional Optional The file format is similar to the transaction fee override file format Refer the section Policy transaction fee override related segment formats explained earlier in the chapter for the file format Cheque Tracking File Format For all imports of new and amended Cheque Tracking data the external hand off file containing the information must e Always contain all information marked as mandatory in the table below e Always contain the information in the exact format and serial order shown in the Field Name column with values according to the validations mentioned in the table below Field Name as Data Field Mandatory Characteris Values expected in the type length tics rules file SEGMENTID String 20 Mandatory Sequence no of records in the file 2 118 ORACLE SEQUENCENUM BER Number Mandatory Sequence no of records in the file PROCESSID String 50 Mandatory The Process ID along with the system generated sequence number identifies the uploaded record uniquely Each file must have a unique Process ID This should be same for all
99. ation is applicable for absence of authorized unit holder information in generation the file XFERIBAN String 36 Optional Used to capture the XFERIBAN RULEEFFEC DATE TIVEDATE BrokerStatus 2 97 ORACLE LEGACYDET AILS FEEDPREFE RENCES BENEFICIAR YIBAN INTERMEDI ARYIBAN SEGMENTID PRIMARYCO UNTRY PRIMARYUS STATE 2 98 ORACLE 2 12 Unit Holder Deal File Format For all imports of unit holder deal information the external hand off file containing the information must Always be named in the format Always contain all information marked as mandatory in the table below Always contain the information in the exact format and serial order shown in the Field Name column with values according to the validations mentioned in the table below Field Data Field length Mandatory Characteristi Values Name as type cs rules expected in the file SEQUEN Number number 10 Mandatory System generated CENUMB sequence number for the ER records in the file PROCES String varchar2 50 Mandatory The Process ID along with SID the system generated sequence number identifies the uploaded record uniquely Each file must have a unique Process ID This should be same for all records within a file BULKCLI String varchar2 12 Mandatory The Code of the Bulk client ENTCOD E IMPORTF
100. ber OASULA Other OASOTH Referenced Journal Description Char 240 Empty Empty Reference6 Journal Entry Char 100 Empty Empty reference Reference7 Journal entry Char 100 Empty will default to Empty will Reversal flag NO default to NO References Journal Entry reversal Char 100 Empty Empty period or effective date Reference9 MUST BE NULLS Char 100 Empty Empty used for internal processing Reference10 Journal Entry line Char 240 Empty Empty description Reference11 Not Used Char 100 Empty Empty 3 109 ORACLE Reference12 Not Used Char 100 Empty Empty Reference13 Not Used Char 100 Empty Empty Reference14 Not Used Char 100 Empty Empty Reference15 Not Used Char 100 Empty Empty Reference16 Not Used Char 100 Empty Empty Reference17 Not Used Char 100 Empty Empty Reference18 Not Used Char 100 Empty Empty Reference19 Not Used Char 100 Empty Empty Reference20 Not Used Char 100 Empty Empty Reference21 Not Used Char 100 Empty Empty Reference22 Not Used Char 100 Empty Empty Reference23 Not Used Char 100 Empty Empty Reference24 Not Used Char 100 Empty Empty Reference25 Not Used Char 100 Empty Empty Reference26 Not Used Char 100 Empty Empty Reference27 Not Used Char 100 Empty Empty Reference28 Not Used Char 100 Empty Empty Reference29 Not Used Char 100 Empty Empty Re
101. blank ENTITYID String 12 Optional Must be left blank REFFUNDID String 6 Optional Must be left blank IDSENTITYTYPE String 1 Mandatory Should be U to indicate Unit Holder IDSENTITYID String 12 Mandatory Unit Holder ID SWIFTFORMAT VARCHARZ2 6 Optional Used to capture the Swift Format as a part of Payment routing details BANKCHARGED VARCHAR2 12 Optional Used to capture the Bank Charged as a part of Payment routing details BENEFICIARY VARCHARZ2 35 Optional Used to capture the Beneficiary details as a part of Payment routing details BENEFICIARYADD VARCHAR2 35 Optional Used to capture the 1 Beneficiary address details as a part of Payment routing details BENEFICIARYADD VARCHAR2 35 Optional Used to capture the 2 Beneficiary address details as a part of Payment routing details 2 75 ORACLE BENEFICIARYADD VARCHAR2 35 Optional Used to capture the 3 Beneficiary address details as a part of Payment routing details BENEFICIARYBIC VARCHAR2 24 Optional Used to capture the Biccode CODE for the Beneficiary as a part of Payment routing details BENEFICIARYACC VARCHARZ2 24 Optional Used to capture the Account TNO Number for the Beneficiary as a part of Payment routing details BENEFICIARYCO VARCHAR2 24 Optional Used to capture the Code for DE the Beneficiary as a part of Payment routing details BENEFICIARYINF VARCHAR2 100 Optional Use
102. ble for YTIMELOAD Exit transactions Pseudoswitc Number Optional Used for hlag capturing Pseudo Switch lag AllowSystem Number 1 Optional aticPlans MaxinitialTxn Number 15 Optional Maximum of Used for Amount 3 decimals capturing the allowed maximum initial transaction amount 3 43 ORACLE MaxlInitialTxn Number 15 Optional Maximum of Used for Units 6 decimals capturing allowed maximum initial transaction units Pseudoswitc Alphanumeric 1 Optional Specify whether hlagcalendar Code the ps lag days basis should be considered based on the holiday calendar for the fund the actual calendar or the System calendar FULLOUTFL NUMBER 1 Optional Valid values OW are 0 and 1 MAXNOOFSI NUMBER 4 Optional MaxNoofSITr TRANSACTI ansactions ONS value should be Greater than 0 MAXVALIDIT NUMBER 4 Optional Maxvalidy Y value should be Greater than 0 SILEADTIME NUMBER 4 Optional APPLICABLE Alphanumeric 255 Optional ACCOUNTT YPES INFLOWOVE NUMBER 1 Optional Valid values RRIDABLEM are 0 and 1 SG MINMATURI NNUMBER 4 Optional Min Maturity TYPERIOD Period value sholud be greater than 0 3 44 ORACLE MAXMATURI NNUMBER 4 Optional Max Maturity TYPERIOD Period value sholud be greater than 0 and greater than or equal to Min Maturity Period FUTUREDAT NUMBER 1 Optional Valid values To facilitate ELIMIT are pos
103. bsence of information in the file IDENTIFICATIO String 15 Optional Accepted from the user s NNUMBER specification for the same in the hand off file contents IDENTIFICATIO DATE Optional Accepted from the user s NISSUEDATE specification for the same in the hand off file contents 2 6 ORACLE IDENTIFICATIO DATE Optional Accepted from the user s NEXPIRYDATE specification for the same in the hand off file contents RESIDENTSTAT String 1 Optional Value Could be any of the US defaulted as values from the following maintained list in Bulk client R Resident F Forei defaults in gn the absence of information in the file UHCATEGORY _ String 2 Mandatory Could be any of the valid values from the Category list maintained ANKDETAILS String 2000 Optional T The following values would have to be supplied with delimiters in cases where more than one set of Bank Details is maintained Bank Code Branch Code Account Type Account Number Account name Relationship Account Currency Default The delimiter would be a comma for each set and a semi colon to separate two sets of Bank Details The Default values should be either 0 or 1 with 1 indicating the default bank detail for the unit holder There can be one and only one default bank detail for a unit holder For the below entity details see Unit Holder Bank Details Fund id Transaction Type Swift
104. bsolute values of the fund of the client Layer type Character This field is left blank Layer Number Number This field displays 00 Reject ID Number This field is not required for entry it displays 00000000 Adjustment Indicator Character This field is not required for entry and is left blank Territory Character This field is not required for entry Annual Fund Total Number This field is not required for entry it displays 000000000000000 Distribution Fee Number This field is not required for entry it displays Channel 000000000000000 Maximum Commission Number This field is not required for entry it displays 000000000000000 Instance Number Character This field is not required for entry BEN Type Character This field is not required for entry EMM Client Number Character This field is not required for entry Sales Instance Number This field is not required for entry it displays 000 Transaction Instance Number This field is not required for entry it displays 000 3 120 ORACLE ORACLE Upload Format April 2012 Version 12 0 Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores CA 94065 U S A Worldwide Inquiries Phone 1 650 506 7000 Fax 1 650 506 7200 www oracle com financial_services Copyright 2012 Oracle Financial Services Software Limited All rights reserved No part of this work may be reproduced stored in a retrieval system adopted or transmitted in a
105. cimal places subscription IPO TAXID allowed subscription amount beyond which it is necessary preferable to capture the Tax details for any unit holder PRIMAR Alphanumeric 255 Optional Registered Address YREGAD for the fund DRESS FUNDTA Alphanumeric 25 Optional Unique Tax ID for XID the fund 3 8 ORACLE FUNDID Alphanumeric 25 Mandatory Fund ISIN number ENTIFIC for DEKA that helps to ATIONN Installation uniquely identify the UMBER For others fund this is optional FUNDTIC Alphanumeric 25 Optional This is another value KERSYM that helps to BOL uniquely identify the fund However if this is not applicable it can be entered as null also ALLOWI Number 1 Optional Valid values are Only if IRA RAINVES 0 and 1 transactions are TMENTS allowed the value should be specified as 1 Else specify 0 CUSTOD Alphanumeric 12 Optional Valid custodian Enter the Custodian IAN defined in the for the fund being set system as a part up of Entity maintenance HEDGE Alphanumeric 1 Optional Valid values are Indicate whether the FUND 0 and 1 fund is a hedge fund Serial Number 3 Segment Identification Number 02SCR Description This segment is used for providing Shares Characteristics related information Segment Mandatory Optional Mandatory Multiple records allowed for the same Fund and Rule Effective Date No Field Name Type Maximum
106. count Number Character 16 AccountCurrency Character 3 Transaction Currency Character 3 Bank branch Character 12 Direct DebitApplicable Character 1 1 Applicable 0 Not applicable GL setup for Contra Character 1 C CASA G GL S SAP P Payment Contra Primary Entity Type Character 1 U Uniholder D Distributor M AMC F Fund Contra Account Number Character 16 Contra Account Currency Character 3 Contra Transaction Currency Character 3 Contra Bank branch Character 12 Contra Direct DebitApplicable Character 1 1 Applicable 0 Not applicable Restricted reference types Character 255 A semicolon separated list of the restricted reference types GL Currency Character 3 GL reference number Character 10 Product Id Character 10 Product or Fund Level Character 1 F Fund Level P Product level Mode of upload Character 1 N new mode A Amend mode 3 1 11 Interface to Check for Transaction Unrelated to GL Extraction Files uploaded for checking the transaction unrelated to GL Extraction Interface should have the format mentioned below Field Name Data Type Details IFaceRefNo Character 25 The reference number of the entry in the AMInterfacemasterTbl 3 116 ORACLE TransactionT ype Character 2 The transaction type of the entry Component Character 20 The component code of the entry TransactionNumber Character 16 The transaction number of the missin
107. d U This fund rule is to override uploaded should the value be a authorized mentioned fund rule or un as a part of authorized fund header rule segment Serial Number 3 Segment Identification Number 02FAB 3 90 ORACLE Description This segment is used for providing Fund agency branch back dated related information Segment Mandatory Optional Optional Multiple records allowed for the same Fund and Rule Effective Date Yes For various transaction types Field Name Type Maximum Mandatory Characterist Description Length Optional ics Validations applicable SEGMENTID Alphanumeric 20 Mandatory Default value Standard value 02FAB of 02FAB to uniquely identify Fund agency branch back dating limit information PROCESSID Alphanumeric 50 Mandatory Same value This should as inOOGEN identify the ProcessID upload uniquely This should also be unique within a file and it allows to identify imported records later FUNDID Alphanumeric 6 Mandatory Depending The Fund ID isa upon the unique scheme Identification for cross each Fund in reference the system maintained Enter the fund at the Bulk for which a Fund client agency branch defaults back dated limit this field needs to be value could maintained either be FundlD Fund Identification number or Fund ticker symbol AGENTCODE Alphanumeric 12 Optional Valid agent Valid entity
108. d applicable for Standing instructions 3 39 ORACLE MAXSITXNA_ NUMBER 15 Optional Maximum of Maximum MOUNT 3 decimals amount allowed applicable for Standing instructions MINSITXNU NUMBER 15 Optional Maximum of Minimum units NITS 3 decimals applicable for allowed Standing instructions MAXSITXNU_ NUMBER 15 Optional Maximum of Maximum units NITS 3 decimals applicable for allowed Standing instructions EXISTINGUH Alphanumeric 2 Optional Valid values This is to are 0 and 1 indicate that the subscription transactions for the fund must only be available to existing customers and not to new customers NOOFDECIM NUMBER 1 Optional Indicate the ALSFORUNI maximum TPRICE number of decimals that would be reckoned for rounding precision for the unit price You cannot indicate a precision higher than 6 decimal places ROUNDOFF Alphanumeric 1 Optional Valid values Indicate the TRUNCATE are R for rounding UNITPRICE Round off T options for the for Round value of the Down and U number of for Round up allotted units designated for the fund 3 40 ORACLE ROUNDOFF Alphanumeric 1 Optional Valid values Indicate the TRUNCATE are R for rounding UNITS Round off T options for the for Round value of the Down and U number of for Round up allotted units designated for the fund 3 4
109. d to SYSTEM This information is applicable for authorized unit holder generation CHECKERDATE Date 10 Optional If the date is not specified in the import file the application date is considered to be the Checker Date by default This information is applicable for authorized unit holder generation MICRCODE String 40 Cheque MICR Code AUTHTYPE String 1 Mandatory Could be either of the following values U Unauthorized A Authorized IBAN String 36 Optional Used to capture the IBAN 2 15 Holiday Upload File Format For all imports of new and amended Holiday data the external hand off file containing the information must e Always contain all information marked as mandatory in the table below e Always contain the information in the exact format and serial order shown in the Field Name column in the table below noes ORACLE Field Name Data Type Field Mandatory Nullable Length SEQUENCENUMBER Number 10 Mandatory N PROCESSID VARCHAR2 50 Mandatory N BULKCLIENTCODE VARCHAR2 12 Mandatory N IMPORTFILENAME VARCHAR2 255 Mandatory N UPLOADMODE VARCHAR2 1 Mandatory N AMCID VARCHAR2 12 Optional Y YEAR NUMBER 4 Mandatory N JAN VARCHAR2 100 Optional Y FEB VARCHAR2 100 Optional Y MAR VARCHAR2 100 Optional Y APR VARCHAR2 100 Optional Y MAY VARCHAR2 100 Optional Y JUN VARCHAR2 100 Optional Y
110. d to capture the O Information free format text for the Beneficiary as a part of Payment routing details INTERMEDIARY VARCHAR2 35 Optional Used to capture the Intermediary as a part of Payment routing details INTERMEDIARYA VARCHARZ2 35 Optional Used to capture the DD1 Intermediary address as a part of Payment routing details INTERMEDIARYA VARCHARZ2 35 Optional Used to capture the DD2 Intermediary address as a part of Payment routing details INTERMEDIARYA VARCHARZ2 35 Optional Used to capture the DD3 Intermediary address as a part of Payment routing details INTERMEDIARYBI VARCHAR2 24 Optional Used to capture the CCODE Intermediary BIC code as a part of Payment routing details INTERMEDIARYA VARCHAR2 24 Optional Used to capture the CCTNO Intermediary Account Number as apart of Payment routing details INTERMEDIARYC VARCHAR2 24 Optional Used to capture the ODE Intermediary Code as a part of Payment routing details INTERMEDIARYIN VARCHAR2 100 Optional Used to capture the 2 76 ORACLE FO Intermediary Information other information as a part of Payment routing details FURTHERCREDIT VARCHARZ2 35 Optional Used to capture the Credit NAME Name as a part of Payment routing details FURTHERCREDIT VARCHARZ2 35 Optional Used to capture the Credit ACCTNO Account Number as a part of Payment routing details REFERENCE VARCHARZ2
111. dditional information to identify a unit holder in the system depending on the scheme cross reference number TRANSAC String 2 Optional Valid transaction type in TIONTYPE the system The following are the valid transaction types allowed for bulk upload 01 IPO 02 Subscription 03 Redemption 04 Switch 05 Transfer EFFECTIV Date 10 Optional Should be greater than or ESTARTD equal to application date ATE EFFECTIV Date 10 Optional Should be greater than EENDDAT effective start date E SIFREQUE String 1 Optional A valid frequency in the NCY system D Daily Could be any of the following F Fortnightly H Half yearly M Monthly Q Quarterly W Weekly Y Yearly 2 59 ORACLE AMOUNT Numb 15 3 Optional The amount of the transaction Either amount number of units or holdings percentage should be specified UNITS Numb er 15 6 Optional The number of units applied for the transaction Either amount number of units or holdings percentage should be specified HOLDING SPERCEN TAGE Numb er 5 2 Optional The holdings percentage applied for the transaction Either amount number of units or holdings percentage should be specified TRANSAG TIONCUR RENCY String Optional A valid currency maintained in the system TOUNITH OLDERID String Optional For standing instructions involving transfer transactions this i
112. ded to the base price FROMENTITY Alphanumeric 1 Mandatory Valid values are This is to TYPE M for AMC A indicate the for Agent B for entity type from Broker D for which the load Distributor F is applied for Fund R for Registrar T for Trustee U for Unit Holder S for Custodian TOENTITYTY Alphanumeric 1 Mandatory Valid values are This is to PE M for AMC A indicate the for Agent B for entity type to Broker D for which the load Distributor F is applied for Fund R for Registrar T for Trustee U for Unit Holder S for Custodian PROCESSIN Alphanumeric 1 Optional Valid values are Specify the GFREQ A T and P frequency at which this load is to be applied Loads can be applied at any of three possible frequencies Allocation time Transaction time and Post allocation Refer the table marked PROCESSING FREQ at the end of this document 3 66 ORACLE GLACCOUNT CODE Alphanumeric Optional When transaction information is exported to an external system if separate books of accounts are to be posted for different loads this code will be used to identify this load information in the export data DEBITORCRE DIT Alphanumeric k Optional Valid values are D and C This is used to indicate that the applied load would result in a debit or credit for the fund This data is captured for informati
113. e DATE type is provided ESCALATI Date 10 Mandatory if Optional Date gt Escalation start ONENDDA Escalation date and lt SI end date TE type is provided PAYMENT String 12 Required for Optional BANKCOD payment E modes check transfer credit card and demand draft 2 63 ORACLE TRANSFE String 60 Optional Account holder name as RACCOUN maintained with the bank THOLDER required for Transfer NAME payment mode PAYMENT String 1 Optional Could be any of the values TYPE in the following list S Self T Third party E Entity THIRDPAR String 255 Optional Applicable for third party TYPAYME payments only NTREFER ENCE THIRDPAR String 6 Optional Applicable for third party TYZIPCOD payments only E THIRDPAR Numb _ 14 Optional Applicable for third party TYUSSTA er payments only TE DELIVERY String 1 Optional Must be R OPTION THIRDPAR String 12 Optional Applicable for third party TYBICCO payments only DE THIRDPAR String 3 Optional Applicable for third party TYCOUNT payments only RYCODE THIRDPAR String 80 Optional Applicable for third party TYADDRE payments only SSLINE1 THIRDPAR String 80 Optional Applicable for third party TYADDRE payments only SSLINE2 THIRDPAR String 80 Optional Applicable for third party TYADDRE payments only SSLINE3 THIRDPAR String 80 Optional Applicable for third party TYA
114. e ED unit holder s request can override the default denominations defined If the User override is allowed then system will allow the teller to override the fund default denominations This is true only for minimum and maximum denominations The Standard lot cannot be changed This is applicable only to scrip based funds CERTREQD Number 1 Optional Valid values For scrip less are 0 and 1 funds this value is to indicate that certificates must be issued to investors for block transactions in the fund MAXREGIST NUMBER 5 Optional Capture the EREDUNITS Maximum Units Registered Capital UHCATREG VARCHAR2 2000 Optional Tilde separated CAPITAL string with Inv Category and Max Reg Units Eg PB 100 CO 200 Serial Number 4 Segment Identification Number 03GOR 3 17 ORACLE Description This segment is used for providing General Operating rules information Segment Mandatory Optional Mandatory Multiple records allowed for the same Fund and Rule Effective Date No Field Name Type Maximum Mandatory Characteristi Description Length Optional cs Validations applicable SEGMENTID Alphanumeric 20 Mandatory Default value Standard value of 03GOR 03GOR to uniquely identify General Operating Rules information PROCESSID Alphanumeric 50 Mandatory Same value This should as in OOGEN identify the ProcessID u
115. e only if the fund is pre priced For Post Priced Fund with Allocation as Online the Transaction Frequency is Allocation ALLOCATION NUMBER Optional Should be Specify the PERVSREGC below 100 percentage up APITAL to which allocation can be allowed for a given registered amount on the day 4 ALLOCATION Alphanumeric Optional Enter F for First POLICY In First Out or P Proportionate to specify the policy for allocation in case the maximum limit is reached for a given day This policy is with respect to the allocation percentage that is allowed against the fund corpus 3 32 ORACLE NOOFTXNAL LOWEDFOR FREQ NUMBER i Optional This is to specify the number of transactions allowed restriction within this frequency NOOFTXNAL LOWEDPER UH NUMBER Optional Enter a value to specify the number of transactions that are allowed for a unit holder You can restrict the unit holder from operating more than the specified limit for transactions NOOFFREE TXNALLOW EDPERUH NUMBER Optional Enter a value to specify the number of free transactions within the permitted transactions This definition will override all loads that will be set for this transaction ALLOWBAC KDATING NUMBER a4 Optional This is used to indicate whether backdating should be allowed for this fund This means that on
116. e check this field would be made mandatory or optional FUNDTICKERS YMBOL Alphanumeric 25 Optional Ticker symbol for the fund whose rule is set up FUNDNAMESH ORT Alphanumeric Mandatory Short name for the fund FUNDNAME Alphanumeric Mandatory Fund name USERID Alphanumeric Mandatory The fund rule MakerID would have the value of UserlD as a part of data storage in all the fund rule tables GENERATEAUT HFUNDRULE Alphanumeric Optional Valid values are A and U This indicates whether the fund rule uploaded should be a authorized fund rule or un authorized fund rule FDR Alphanumeric Mandatory Valid values are NO and YES Fund demographics information GOR Alphanumeric Optional Valid values are NULL NO and YES General operating rules information 3 97 ORACLE SCR Alphanumeric Optional Valid values Shares are NULL characteristics NO and information YES IDR Alphanumeric Optional Valid values Corporate are NULL actions NO and information YES TPR Alphanumeric Optional Valid values Transaction are NULL processing rules NO and information YES TPRCOMMMOD Alphanumeric Optional Valid values Transaction E are NULL processing rules NO and Communication YES mode information TPRINVCATEG Alphanumeric Optional Valid value
117. e funding factor that is ERCENTAG applicable to the Policy E transaction CANCELLE Optional The cancelled IDs of the D_PHASEI active Phaseln setup NID 2 108 ORACLE INTERESTA Number 15 Mandatory The interest amount based MOUNT on the interest calculation days and interest rate provided If interest amount is not provided then specify 0 AdjustmentT Number 1 Optional Valid values 0 1 ransaction IBAN String 36 Optional Used to capture the IBAN SOURCEID VARCH 6 Optional The source from which the AR2 exchange rate is obtained in case of multi currency transactions EXCHANGE NUMBE 15 9 Optional The exchange rate RATEAPPLI R corresponding to the ED combination of policy base currency and policy transaction currency 2 13 2 Policy transaction broker related segment formats Serial Number 2 Segment Identification Number OOBRK Description This segment is used for providing information related to brokers involved in the policy transactions Segment Mandatory Optional Mandatory Field Name as expected in the file Data type Field Mandatory length Characteristics Values rules SEQUENCENUMBER Number 10 Mandatory Sequence no of transaction record in the file Each uploaded transaction has a unique sequence number 2 109 ORACLE PROCESSID String 50 Mandatory The Process ID
118. e of Fund Value amounts on the Input File 3 117 ORACLE Current Potential Number Applicable to recurring business only Commission Future Potential Commission Number Applicable to recurring business only Numeric Field 11 Number Provide preceding zeros as 0000000 3 1 14 File format for Detailed Record The Detail Record File format is the record of all the Broker details involved in all the transactions for that day taken individually The file containing the Detailed records for all the individual Brokers The file format used for Detailed records is Field Name Data Details Type Record Category Number It is displayed as 00 Transaction Sequence Number Unique identifier of transaction in the source external Number interface Product Provider Character The code for which the file is processed to calculate commission For example Unit Trust UT Cycle Number Number Preceded by zeros Intermediary Code Sales Number The intermediary s sales code as supplied on the Code policy proposal application form It consists of six digits preceded by zeros Intermediary Type Sales Number Code for the intermediary who has initiated the sale of Type that policy 0 is for the Sales Staff 1 is for the Office staff Intermediary Commission Number The percentage of commission as indicated in the Percentage Direct policy application form Share Intermediary Fi
119. ecified oo in the import file the application date is considered to be the Maker Date by default CHECKERID String 15 Optional this information is specified in the import file no validation is made with regards to the user profile maintenance in the FCIS system If it is not specified it is defaulted to SYSTEM This information is applicable for authorized unit holder generation CHECKER_DT_ DATE Optional If the date is not specified STAMP in the import file the application date is considered to be the Checker Date by default 2 16 ORACLE This information is applicable for authorized unit holder generation AUTHTYPE String 1 Mandatory Could be either of the following values U Unauthorized A Authorized STOPACCOUNT String 255 Optional Must be left blank REASON RELEASEDATE DATE Optional Must be left blank ALLSIGNATORI Number 1 Optional Must be left blank ESREQDTOSIG N TAXEXEMPTED Number 1 Optional Either 0 or 1 to indicate if tax is exempted for this Unit holder INDEXATIONON String 1 Optional Must be left blank CGT CERTDELIVERY String 1 Optional Could be any of the PREF values from the following list to indicate the preferred certificate delivery option A C F P R DELIVERYDETA String 2000 Optional ILS TEMPLATEID String 6 Value defaulted as maintained in Bulk client defaults in the absence of information
120. eld Char 150 Empty Empty 3 112 ORACLE Attribute20 Descriptive FlexField Char 150 Empty Empty Context Define structure of Char 150 JE_SRC_NAME Product ULA descriptive flexfields OASULA Journals journal Entry Line Other ATTRIBUTE21 22 OASOTH CONTEXT2 Used to indicate if Char 150 Empty Empty journal is a tax item YES To identify YES To the VAT Descriptive identify the flexfields VAT Descriptive NO To indicate flexfields that the journal entry is not a tax item NO To VAT Descriptive indicate that flexfields must be the journal nulls entry is nota tax item VAT Descriptive flexfields must be nulls INVOICE_DATE Date on which you Char 11 Empty Empty paid collected tax on the tax journal line TAX_CODE Identifies the type of Char 15 Empty Empty tax paid for this invoice INVOICE_ID Reference info about Char 20 Empty Empty the source document or invoice upon which tax was paid collected INVOICE_AMOU Net invoice amount Char 15 Empty Empty NT relating to your tax journal Context3 Define structure if Char 150 JE_SRC_NAME Product ULA descriptive flexfields OASULA Journals Captured Information Other ATTRIBUTE11 20 OASOTH USSGL_TRANS_ Not Used Char 30 Empty Empty CODE 3 113 ORACLE DESC_FLEX_ER_ MUST BE NULLS Char 240 Empty Empty RMSG used for i
121. eld will contain a string with the values of fund ID reinvestment unit holder ID reinvestment fund ID and split percentage separated by the appropriate field and record separators AUTHTYPE String Mandatory Could be either of the following values U Unauthorized A Authorized PAYMENTMODE String Optional Indicates mode of payment If the mode of payment is not Reinvestment R you may specify the mode as T for Transfer or Q for Cheque SUBPAYMENTMO DE String Optional Could be either of the following values T Transfer or Q Cheque PAYMENTTYPE String Optional Can be T or S to indicate third party or self THIRDPARTYPAY MENTREFERENC String 255 Optional From file Applicable for third party payments 2 74 ORACLE E THIRDPARTYPAY String 255 Optional From file Applicable for third MENTADDRESS party payments THIRDPARTYPAY String 20 Optional From file Applicable for third MENTCITY party payments THIRDPARTYPAY String 20 Optional From file Applicable for third MENTSTATE party payments USSTATE Number 1 Optional Could be either 0 for No or 1 for Yes THIRDPARTYPAY String 10 Optional From file Applicable for third MENTZIPCODE party payments XFERACCOUNTH String 100 Required if OLDERNAME PaymentSp litPercenta ge gt 0 ENTITYTYPE String 1 Optional Must be left
122. ended transactions data the external hand off file containing the information must e Always be named in the format BulkTxn e Always contain all information marked as mandatory in the table below e Always contain the information in the exact format and serial order shown in the Field Name column with values according to the validations mentioned in the table below If you have disallowed upload of amended transactions for a particular client by selecting the No option in the Allow Amendment field when you are setting up the default information for the bulk client amended orders are not imported for the bulk client but errors are logged in respect of them The upload file would contain various segment identification numbers in the first column to indicate the type of data that is present in that entire row Each segment identified by a unique tag indicates the type of transaction information such as Transaction Settlement info and so on The possible segments that would be used in Transaction upload are given below for reference Segment Identification Number Description Segment Mandatory Optional Multiple records allowed for the same Fund and 2 31 ORACLE Rule Effective Date OOCON This segment is used for Mandatory and willbe No providing information the driving header common to A segment for all the TRANSACTION other segments 01SET Thi
123. ent24 Not Used Char 25 Empty Empty Segment25 Not Used Char 25 Empty Empty Segment26 Not Used Char 25 Empty Empty Segment27 Not Used Char 25 Empty Empty Segment28 Not Used Char 25 Empty Empty Segment29 Not Used Char 25 Empty Empty Segment30 Not Used Char 25 Empty Empty ENTERED _DR Debit Amount Number Debit Amount of Debit Amount 12 2 journal of journal Empty if ENTERED CR Absolute value Absolute value populated 000000000000 00 00000000000 0 00 Transaction value Transaction value ENTERED_CR Credit Amount Number Credit Amount of Credit Amount 12 2 journal Absolute of journal Empty if value Absolute value ENTERED_DR populated 000000000000 00 00000000000 0 00 Transaction value 3 108 ORACLE ACCOUNTED_D If CUR_CONV_ Char 15 Empty Empty R used populate with converted amount ENTERED_DR must be populated as well with original amount This is not used ACCOUNTED _C_ If CUR_CONV_ Char 15 Empty Empty R used populate with converted amount ENTERED_CR must be populated as well with original amount TRANS_DATE Must be nulls used Char 11 Empty Empty for internal processing Reference 1 Batch Name Char 100 Empty Empty Reference2 Batch Description Char 240 Empty Empty Reference3 Must be nulls Used Empty Empty for internal processing Reference4 Journal Name Char 100 JE SRCE_NAME amp Product ULA Run num
124. er Code Code 10 Broker Category Char 1 Corporate Individual Broker Category Broker Name Char Individual name or corporate Broker Name 50 name Broker Type Char For example Platinum Gold Broker Type Silver Parent Broker Char Channel For example PFA BD Parent Broker Code Active Flag Char Y N Broker Enabled Date Effective Date Rule effective date 3 1 8 Oracle Financial Interface Files uploaded using the Oracle Financial Interface should have the following format Field Name Description Data type OMUT Data Galaxy Data amp Format Status Indicates that its new Char 50 NEW NEW data you are bringing into the General Ledger This is a compulsory field Set_Of_Books_ld This is a compulsory Char 15 OMUT Product field Appropriate set 000000000001140 of books id Should ULA be present on NAM 00000000000 Oracle s SET OF 000000000001150 0235 BOOKS table OTHER 00000000000 0236 Accounting Date This is a compulsory Char 11 Date the transaction Date the field occurred transaction occurred 3 105 ORACLE Currency_Code Transaction Currency Char 15 ZAR South Africa ZAR South This is a compulsory or NAD Namibia Africa or NAD field or GBP Britian Namibia or GBP Britian Date_Created Da
125. er profile maintenance in FCIS if it is supplied with the import file If it is not supplied default it to the logged in user id MAKERDATE Date Optional If the date is not specified in the import file the application date is considered to be the Maker Date by default DEPOSITRYID String Optional DP Id PAYMENTMODE String Mandatory Indicates mode of payment Can be any of the following values Q Cheque T Transfer R Credit card C Cash D Draft SUBPAYMENTM ODE String Optional Can have valid values as defined in the mode of payment table PAYINBANK String Optional Should be a valid Bank as defined in the system PAYINBRANCH String Optional Should be a valid Brach as defined in the system PAYINNUMBER String Optional Unique Serial Number MODULEID String 30 Mandatory Should be a valid module id as defined in the system COMMISSION Number 30 12 Optional Entity Commission 2 121 ORACLE Amount CHEQOPTYPE String 1 Optional 0 Cheque 3 Demand Draft 4 Outstation Cheques DD 5 Others SYSREFERENCE String 25 Mandatory Unique Serial number NUMBER CHECKERID String 15 Optional This information is specified in the import file no validation is made with regards to the user profile maintenance in the FCIS system If it is not specified it is defaulte
126. estors limit to be defined either in percentage of fund corpus or a flat Amount Enter A if the foreign investors limit is in terms of an Amount and P for a percentage of the Registered Capital FOREIGNIN Number NUMBER Optional Maximum of 6 Enter a value to VESTORSLI 30 12 decimal places specify the MIT allowed percentage of fund corpus that foreigners are allowed to hold This could be either a percentage of Fund Corpus or a flat Amount If it is a percentage then it cannot be greater than 100 ACCOUNTS Alphanumeri 20 Optional Valid values This is to indicate TATEMENTF c are F or B for the frequency REQ Bi weekly M with which the for Monthly Q system should for Quarterly initiate the H for Half Account yearly Y for Statement Yearly processing ACCOUNTS Number 3 Optional Enter a lead time TATEMENTL in days EADTIME 3 12 ORACLE PRINTACCO UNTSTATEM ENT Number Optional Valid values are 1 to print and 0 for not to print account statement This is to indicate that the Account Statement to be printed for the fund that is being set up PRINTHOLDI NGSSTATE MENT Number Optional Valid values are 1 to print and 0 for not to print holding statement This is to indicate that if the Holding Statement to be printed for the fund that is being set up STANDARDL OT Number Optio
127. f the following icons Icons Function New Copy Ll Save Pas Delete S Unlock f Print ay Close Roy Re open B Reverse W Template 2 Roll over fl Hold 1 2 ORACLE 1 7 Icons Function EJ Authorize ts Liquidate Exit Sign off Help Add HEHE eS Delete Refer the Procedures User Manual for further details about the icons Abbreviations and Acronyms The following acronyms and abbreviations are adhered to in this User Manual Abbreviation Acronym Meaning ADMIN User Administrator AGY The Agency Branch component of the system AMC Asset Management Company BOD Beginning of Day CDSC Contingent Deferred Sales Charge CGT Capital Gains Tax CIF Customer Information File EOD End of Day EPU Earnings per unit FC IS Oracle FLEXCUBE Investor Servicing FMG The Fund Manager component of the system FPADMIN Oracle FLEXCUBE Administrator ID Identification IHPP Inflation Hedged Pension Plan ORACLE Abbreviation Acronym Meaning IPO Initial Public Offering LEP Life and Endowment Products LOI Letter of Intent NAV Net Asset Value REG The Registrar component of the system ROA Rights of Accumulation ROI Return on Investment SI Standing Instructions SMS Security Management System URL Uniform Resource Locator
128. ference30 Not Used Char 100 Empty Empty JE BATCH_ID Must be nulls Used Char 15 Empty Empty for internal processing only PERIOD_NAME If ACTUAL_FLAG Char 15 Empty Empty B must be populated instead of ACCOUNTING_DAT E JE _HEADER_ID MUST BE NULLS Char 15 Empty Empty used for internal processing 3 110 ORACLE JE _LINE_NO MUST BE NULLS Char 15 Empty Empty used for internal processing COA_ID MUST BE NULLS Char 15 Empty Empty used for internal processing FUNC_CURR_C_ MUST BE NULLS Char 15 Empty Empty ODE used for internal processing CODE_COMB_ID Code Combination ID Char 15 Empty Empty Not used Values entered in Segment1 11 DATE_CREATED MUST BE NULLS Char 11 Empty Empty _GL used for internal WARNING_COD_ MUST BE NULLS Char 4 Empty Empty E used for internal processing STATUS_DESC MUST BE NULLS Char 240 Empty Empty used for internal processing STAT_AMOUNT Statistical amount Char 15 Empty Empty associated with the journal Group_Id Unique Group Char 15 Empty Empty Number to distinguish import data within a source Request_ld MUST BE NULLS Char 15 Empty Empty used for internal processing SUBL_DOC_SEQ MUST BE NULLS Char 15 Empty Empty _ID used for internal processing SUBL_DOC_SEQ MUST BE NULLS Char 15 Empty Empty _VAL used for internal processing Attribute 1 Descriptive FlexField
129. g entry Valuedate Date The date on which the entry was expected to be passed 3 1 12 File Format for OMIPAY FILE INTERFACE The interface is capable of exporting the details in two separate formats These are e The detailed format includes all the records of the day for every individual broker e The Header record for OMIPAY contains the sum of all the brokers Commission accounts which have been listed in the Detailed Record The system extracts commission details for upfront and trailer periodic load commission 3 1 13 File format for Header Record The File format for the Header Record is as follows Records 01 Category Field Name Data Details Type Record Category Number It is displayed as 00 Trigger System Character Ensures the entries which require to be entered for calculation of Commission Product Provider Character The code for which the file is processed to calculate commission For example Unit Trust UT Cycle Number Number The number of the cycle for which the export action is being processed Interface Date Number The date of generation of the interface file Number Of Transaction Number Total Number of transaction records on input file Commission Total Number The total value of Premium amount on the Input File Commission Allowance Total Number Value of Commission Allowance amounts on the Input File Fund Value Total Number The total valu
130. g hedge fund linkage details Segment Mandatory Optional Optional Field Name Type Maximum Length Mandatory Optional SegmentlD VARCHARZ2 20 Mandatory ProcessID VARCHARZ2 50 Mandatory FundID VARCHARZ2 6 Mandatory RuleEffectiveDate DATE 7 Mandatory LinkFundID VARCHAR2 6 Mandatory Percentage NUMBER 3 Optional Unit holder ID VARCHARZ2 12 Optional Serial Number 22 3 84 ORACLE Segment Identification Number 21HFD Description This segment is used for providing investor category details for hedge funds Segment Mandatory Optional Optional Field Name Type Maximum Length Mandatory Optional SegmentlD VARCHAR2 20 Mandatory ProcessID VARCHAR2 50 Mandatory FundlD VARCHARZ2 6 Mandatory RuleEffectiveDate DATE 7 Mandatory InvestorCategory VARCHAR2 25 Mandatory PerformanceFeeRate NUMBER 20 Mandatory 3 1 3 Fund Related Information Upload Segments Format The upload file would contain various segment identification numbers in the first column to indicate the type of data that is present in that entire row Each segment identified by a unique tag indicates the type of Fund rule related information like Fund entity Fund calendar and Fund Agency Branch Back dating limit Segment Description Segment Multiple records Identification Mandatory allowed for the Number Optional same Fund and Rule Effective
131. gth rules expected in the file SEQUENC Numb 10 Mandatory System generated ENUMBER er sequence number for the records in the file PROCESS String 50 Mandatory The Process ID along with ID the system generated sequence number identifies the uploaded record uniquely Each file must have a unique Process ID and should be same for all records within a single file BULKCLIE String 12 Mandatory The code for the bulk NTCODE client IMPORTFI String 255 Mandatory Name of the file being LENAME uploaded should be specified Each file must have a unique name AMCID String 12 Mandatory The ID of the AMC for which the bulk client has maintained the default details This should be same within a file for all the records UPLOADM String 1 Mandatory Upload mode can be N for ODE New and for amended transactions 2 58 ORACLE SIID String 16 Optional For a new record this will be blank For amendment of an existing standing instruction either the SI ID or the fund unit holder transaction type should be supplied SIDESCRI String 255 Optional Hand off file contents PTION FUNDID String 25 Optional The ID of a valid and enabled fund maintained in the system REFUNITH String 12 Optional This must be left blank OLDERID REFTOUNI String 12 Optional This must be left blank THOLDERI D UNITHOLD String 12 Optional The unit holder ID or ERID a
132. gure Numeric The percentage of indirect commission as indicated in Percentage Indirect the policy application form Share Sales Centre branch Character An optional field team structure code Sale Type Character Not applicable can be left blank Policy Number Contract Character It is the Policy or Contract number Number 3 118 ORACLE Policy Type Contract Type Character Only applicable for recurring business types can be left blank Policy Term Number It is applicable for recurring business only default set at 01 Product Code Character The selection is available from a drop down list Premium Amount Number The amount of the premium for a transaction Premium Frequency Character You can select from a list for the type of premium applicable Premium Term Number The term for which the premium is applicable Movement Code Number It is the number code for the type of transaction Transaction Date Number The date on which the transaction takes place Entry Date Number The date from which the new business policy is started Effective Date Number The date from which the policy becomes effective Client or Entity Number Character It is an optional field Client Name Character The name as mentioned in description Fees Character Optional field Commission Amount 01 Number The commission amount for 1 year Commission Amount
133. hars 00 Eight chars 00000 00 00000 Channel code Segment3 Account Value Char 25 Seven chars Seven chars 0000000 0000000 Account code Segment4 Realted Party Value Char Four Chars 0000 Four Chars 0000 Derived from channel and account code combination Segment5 Product Value Char 25 Five Chars 00000 Five Chars 00000 Derived from fund code Segment6 Project value Char 25 Four chars 0000 Four chars 0000 Segment7 Investment Value Char 25 Four chars 0000 Four chars 0000 Segment8 Scheme Value Char 25 Four chars 0000 Four chars 0000 Segment9 Tax Fund value Char 25 Three Chars 000 Three Chars 000 Segment10 VAT Segment Char 25 Four Chars 0000 Four Chars non vat portion 0000 non vat portion 0001 unprocessed vat 0002 processed vat Segmenti 1 Spare 2 Char 25 0000 4 Zeroes 0000 4 Zeroes Segmenti12 Not Used Char 25 Empty Empty Segment13 Not Used Char 25 Empty Empty Segment14 Not Used Char 25 Empty Empty 3 107 ORACLE Segment15 Not Used Char 25 Empty Empty Segment16 Not Used Char 25 Empty Empty Segment17 Not Used Char 25 Empty Empty Segment18 Not Used Char 25 Empty Empty Segment19 Not Used Char 25 Empty Empty Segment20 Not Used Char 25 Empty Empty Segment21 Not Used Char 25 Empty Empty Segment22 Not Used Char 25 Empty Empty Segment23 Not Used Char 25 Empty Empty Segm
134. he defaulted as following values U maintained in Unauthorized A Bulk client Authorized defaults in the absence of information in the file MAKERID String 15 optional Value If this information is specified defaulted as in the import file no validation maintained in is made with regards to the Bulk client user profile maintenance in defaults in the the FCIS system If it is not absence of specified the ID of the logged information in in user at the time of import is the file taken by default as the Maker 2 96 ORACLE MAKERDAT DATE optional Value If the date is not specified in E defaulted as the import file the application maintained in date is considered to be the Bulk client Maker Date by default defaults in the absence of information in the file CHECKERID String 15 optional Value If this information is specified defaulted as in the import file no validation maintained in is made with regards to the Bulk client user profile maintenance in defaults in the the FCIS system If it is not absence of specified it is defaulted to information in SYSTEM This information is the file applicable for authorized unit holder generation CHECKERD DATE optional Value If the date is not specified in ATE defaulted as the import file the application maintained in date is considered to be the Bulk client Checker Date by default This defaults in the inform
135. he broker AGE maintained in Bulk client defaults in the absence of information in the file COMMISSIO String 1 Optional Value Could be any of the values in NPAYMENT defaulted as the following list from FREQ maintained in Frequency Table B Bi Weekly Bulk client W Weekly F Fortnightly M defaults in the Monthly Q Quarterly H absence of Half Yearly Y Yearly information in the file UNITHOLDE String 12 Optional RID NEXTPAYM DATE Mandatory Gives the next payment date ENTDATE of the broker BROKERTY String 6 Optional Value Could be any of the valid PE defaulted as Broker types maintained maintained in Bulk client defaults in the absence of information in the file USEBROKE String 1 Optional Value Could be either 0 and 1 RTYPEPAY defaulted as MENTDATE maintained in S Bulk client defaults in the absence of information in the file 2 86 ORACLE BROKERCO String 40 Optional Accepted from the user NSULTANT BROKERCA String 1 Optional Value Could be either of the values TEGORY defaulted as in the following list maintained in Individual Or C Corporate Bulk client defaults in the absence of information in the file HOLDBACK Number 1 Optional Could be either 0 and 1 PAYMENT PRIMARYAD String 80 Mandatory Accepted from the user s DRESSLINE specification 1 PRIMARYAD String 80 Mandatory Accepted from the user s DRESSLINE
136. he user s ME specification for the same in the hand off file contents PARENTBR String 9 Mandatory Accepted from the user s OKERCODE specification for the same in the hand off file contents BROKERBA String 3 Optional Value Could be any of the valid SECCY defaulted as values maintained in Currency maintained in Maintenance If value is not Bulk client given in the import file then defaults in the the Default broker base absence of currency value mentioned in information in the Bulk Client Defaults the file Maintenance for the bulk client will be used DELETEDST Number 1 Optional Value Indicates whether the record is ATUS defaulted as already deleted 0 or not maintained in Bulk client defaults in the absence of information in the file OVERRIDEN Number 15 6 Optional TAXPERCEN TAGE LEVELNUMB Number 3 Optional If the parent broker code is ER same as the broker code then the level number is 1 Else the level number is parent broker code level number 1 2 85 ORACLE VATREGIST Number 1 Optional Value Indicates whether the VAT is ERED defaulted as registered or not maintained in Bulk client defaults in the absence of information in the file VATREGIST String 15 Optional If vat is registered then this RATIONNUM field gives the information BER about the VAT COMMISSIO Number 5 2 Mandatory Value Percentage of commission to NPERCENT defaulted as t
137. icable SEGMENTID Alphanumeric 20 Mandatory Default value Standard 18MLD value of 18MLD is to uniquely identify multiple languages 3 81 ORACLE PROCESSID Alphanumeric 50 Mandatory Same value as in OOGEN Process ID This should identify the upload uniquely This should also be unique within a file and it allows to identify imported records later FUNDID Alphanumeric Mandatory The Fund ID is a unique Identification for each Fund and it indicates the fund for which Fund delivery instruction has to be uploaded RULEEFFECT IVEDATE Date Mandatory The Fund ID and Rule effective date combination should be the same as defined in 01FDR The rule effective date for which Fund delivery instruction information for the fund has to be maintained LanguageCod e Alphanumeric Code 12 Optional Used for capturing the information in multiple languages against the language code FundName Alphanumeric Code 60 Optional Enter the name of the fund for which the Fund Demographic s profile is being set up in this record Serial Number 19 3 82 ORACLE Segment Identification Number 19FSI Description This segment is used for providing Fund Investment Account Sl if applicable Segment Mandatory Optional Optional Multiple records allowed for the same Fund and Rule Effective Date Yes
138. id in as a part of the system for entity which entity type maintenance is A 3 91 ORACLE AGENCYBRAN _ Alphanumeric 12 Optional Valid agency Valid entity id in CHCODE branch asa_ the system for part of entity which the parent maintenance code is Agent code mentioned in the previous column TRANSACTION Alphanumeric 2 Optional Valid values Transaction type TYPE are 01 for for which back IPO 02 for dating limit is Subscription maintained 03 for Valid values are Redemption 01 to 10 and so on ranging from IPO to Re issue BACKDATINGP Number Optional Back dating ERIOD limit in days DISABLE Number 1 Optional Valid values This is to are 0 and 1 indicate whether the definition should be disabled or enabled 3 92 ORACLE DEFAULTOPTI Alphanumeric 15 Optional Valid values If the default ON are null option is null BULKCLIEN then all values TCODE or provided by the any valid user for entity Fund Id type entity id available in and Restrictive the system list should be used If the value BULKCLIENTC ODE is mentioned then default the information based on the bulk client code mentioned as a part of header segment If any other Fund ID value is mentioned then default values based on the latest available record for the Fund mentioned UPLOADMODE Alphanumeric 1 Optional Valid values Should be
139. imals for Units field in this screen LASTDNRIS SUEDNO Number Optional Enter a value for this field This is to specify that this was the last DNR number that has been issued so far and system needs to start from next number For new funds this could be zero This is also equal to the Start Certificate Issue Number in the case of new Funds This information is only applicable if you have specified the number of decimals for units as zero in the Number of Decimals for Units field in this screen 3 15 ORACLE SINGLECER TALLOWED Number Optional Valid values are 0 and 1 This is to indicate whether a single certificate is needed for the transaction or multiple certificates are needed Valid values are 0 and 1 indicating No and Yes option for Single certificate allowed MINCERTDE NOMINATIO N Number Optional Enter a value to specify the minimum certificate denomination l e the next level of denomination after the standard lot The system will use this after exhausting the maximum certificate denominations MAXCERTD ENOMINATI ON Number Optional Enter a value to specify the maximum certificate denomination This is the first level of denomination used by the system 3 16 ORACLE USEROVER Number 1 Optional Valid values Enter value as 1 RIDEALLOW are 0 and 1 if the user on th
140. information Mandatory common to the other policy transaction details OOBRK This segment is used for providing transaction Mandatory broker related information OOFND This segment is used for providing transaction Mandatory fund ratio related information OOSTL This segment is used for providing transaction Optional settlement related information OOSWF This segment is used for providing transaction Mandatory for switch switch fund related information transactions OOFOI This segment is used for providing transaction Optional fee override related information OODFO This segment is used for providing transaction Optional derived fee override related information Each of the segments have variable list of fields stored as information pertaining to that segment The list of fields for each segment is mentioned in the following tables along with the description of the segment For all imports of new and amended transactions data the external hand off file containing the information must e Always contain all information marked as mandatory in the table below aoe ORACLE e Always contain the information in the exact format and serial order shown in the Field Name column with values according to the validations mentioned in the table below e The Column Header on first line for Interface description of Policy transaction should always be false e All the fields in the file should be of the format Text
141. ing chapter sequence Chapter 1 About This Manual explains the structure audience organization and related documents of this manual Chapter 2 Upload Format Appendix Upload File Formats A explains various upload file formats for external files containing the information that is to be imported from the bulk client Chapter 3 Upload Format Appendix Upload File Formats B explains segment identification numbers their descriptions whether the segment is mandatory or optional etc Conventions Used in this Manual Before you begin using this User Manual it is important to understand the typographical conventions used in it General Conventions Convention Type of Information Italic type Functional foreign terms Names of fields on a screen Validations for fields on a screen ORACLE Convention Type of Information References to related Headings Users Manuals For emphasis Numbered Bullet Step by step procedures This symbol when placed before text indicates a warning or an important note that you should read 1 5 2 Keyboard Conventions Convention Type of Information Keys All keys of the keyboard are represented in capital letters For example lt CTRL gt Shortcut keys All short cut keys are contained in brackets For example lt ALT SHIFT gt 1 6 Glossary of Icons This User Manual may refer to all or some o
142. ion expected in the file type CHEQUENUMBER String 16 Mandatory Each standing instruction must have a unique cheque number as mandatory information CHEQUEDATE Date 10 Mandatory The date of issue of the standing instruction check Mandatory information Income Distribution Setup File Format For all imports of unit holder income distribution setup data the external hand off file containing the information must e Always be named in the format BulkIDS e Always contain all information marked as mandatory in the table below e Always contain the information in the exact format and serial order shown in the Field Name column with values according to the validations mentioned in the table as shown 2 71 ORACLE Field Name as Data type Field Mandatory Values expected in the length file SEQUENCENUMB Number 10 Mandatory System generated sequence ER number for the records in the file PROCESSID String 50 Mandatory The Process ID along with the system generated sequence number identifies the uploaded record uniquely Each file must have a unique Process ID BULKCLIENTCOD String 12 Mandatory The Code of the bulk client E This must remain same within a file IMPORTFILENAM String 255 Mandatory Name of the file being E uploaded should be specified Each file must have a unique name AMCID String 12 Mandatory The ID of the AMC for
143. itive users to input integer future dated transactions UHCALEND VARCHAR2 1 1 Optional Valid values ARBASIS are T and C NOOFDECIM NUMBER 1 Optional Valid values ALSFORUNI are TS 1 to 9 CONSSIAUT NUMBER 3 Optional Used to capture OCOUNTER consecutive payment rejections allowed for the SI THRESHOL NUMBER 30 12 Optional Threshold DAMOUNT Amount Serial Number 6 Segment Identification Number 05TCM Description This segment is used for providing Transaction processing communication mode information Segment Mandatory Optional Mandatory Multiple records allowed for the same Fund and Rule Effective Date Yes For each transaction type there is a separate record Field Name Type Maximum Mandatory Characteristics Description Length Optional Validations applicable 3 45 ORACLE SEGMENTID Alphanum eric 20 Mandatory Default value O5TCM Standard value of O5TCM to uniquely identify Transaction processing communication mode information PROCESSID Alphanum eric 50 Mandatory Same value as in OOGEN Process ID This should identify the upload uniquely This should also be unique within a file and it allows to identify imported records later FUNDID Alphanum eric Mandatory The Fund ID is a unique Identification for each Fund and it indicates the fund for which Transaction processing commu
144. jection either the reference number or transaction number should be specified REFERENCENU String 16 Any additional MBER reference number that can be given optionally No validations will be made for the same The system will generate and update the Reference Number based on the Bulk Client Default Maintenance For amendment deletion or rejection either the reference number or transaction number is mandatory mop ORACLE TRANSACTION DATE Date Optional Indicates the value date of transaction If this is specified in the import file it must be on or later than the current application date If not the application date is considered by default to be the transaction date This date must be within the backdating limits if any set for the relevant transaction type in transaction processing rules UNITHOLDERID String 60 Mandatory The Unit holder ID or additional information to identify a unit holder in the system depending on the scheme cross reference number REFUNITHOLD ERID String Should be left blank AGENTCODE Number Mandatory Valid agent code maintained in the system BRANCHCODE Number Mandatory Valid branch code maintained in the system FUNDID String 25 Mandatory The ID of a valid and enabled fund maintained in the system AMOUNT Number 15 3 Optional
145. l Should be a valid Exchange Rate source defined in the system EXCHANGERATE NUMBER 15 Optional Should be a numeric value which is used for calculating the FBC TC equivalent PAIDDATE DATE 10 Optional This field denotes the date at which the Clearing of the payment has happened AUTOSETTLEMENT NUMBER Optional This field denotes whether manual clearing is required or auto clearing is required 1 Auto Clearing and 0 Manual Clearing SETTLEMENTMETHOD VARCHAR2 Optional Method based on which SETTLEMENTSTATUS VARCHAR2 Optional Settlement amount is computed and matched with the payment amount in FBC TC Valid values are GA Gross Amount NF Net of FM Fees NA Net of Agent Fees NAL Net of All Fees CHEQUEDATE DATE 10 Optional If payment mode is by cheque then this field denotes the date at which the cheque is drawn 2 46 ORACLE CHEQUENUMBER VARCHARZ2 16 Optional If payment mode is by cheque then this field denotes the cheque number CHEQUECURRENCY VARCHARZ2 3 Optional If payment mode is by cheque then this field denotes the cheque currency CHEQUEAMOUNT NUMBER 15 Optional If payment mode is by cheque then this field denotes the amount for which the cheque is drawn DRAWEEBANKCODE VARCHARZ2 12 Optional Should be a valid Bank Code
146. lated seqment formats Description This segment is used to provide transaction settlement related information Segment Mandatory Optional Optional Field Data Field Mandatory Characteris Values Name as type length tics rules expected in the file SEQUENC Number 10 Mandatory Sequence no of transaction record ENUMBER in the file Each uploaded transaction has a unique sequence number PROCESS String 50 Mandatory The Process ID along with the ID system generated sequence number identifies the uploaded record uniquely Each file must have a unique Process ID and it should be same within a file for all the records POLICYTX String 16 Mandatory Is blank for new transactions For NNUMBER amendment deletion and edition either the reference number or transaction number should be specified PAYMENT String 1 Optional Can have values as S or T TYPE Means Self or Third Party Mandatory field for new mode PAYMENT String 1 Optional Indicates mode of payment Can MODE be any of the following values Q Cheque T Transfer R Credit card C Cash D Draft PAYMENT String 1 Optional If the payment mode is by transfer ENTITY and the payment type is broker then this should be B else it can 2 112 ORACLE be left blank DRAWEEB Number 12 Optional Valid bank code maintained in the ANKCODE system TRANSFE Nu
147. mals value for the fund possible 3 23 ORACLE CHECKFEAT Number 1 Optional Valid values Indicates whether UREEXISTS are 0 and 1 the check writing facility is allowed for the fund or not MINCHECKA Number 15 Optional Maximum of 3 If check writing MOUNT decimals facility is allowed possible then the minimum check amount possible is indicated here MAXCHECK Number 15 Optional Maximum of 3 If check writing AMOUNT decimals facility is allowed possible then the maximum check amount possible is indicated here MINCHECKH Number 5 Optional If check writing OLDINGPER facility is allowed IOD then the minimum holding period required is indicated here CHECKACC Number 1 Optional OUNTCLOS URE CHECKRED Number 1 Optional Valid values If check writing EMPTIONPE are O and 1 facility is allowed NALTY then various penalties applicable or not is indicated by values 0 and 1 HOLDINGPE Number 1 Optional RIODPENAL TY BALANCEPE Number 1 Optional NALTY STOPPAYM Number 1 Optional ENTPENALT Y AMTLIMITPE Number 1 Optional NALTY 3 24 ORACLE INTERESTR Number 15 Optional Maximum of 6 ATE decimals possible PERFORMA Number 5 Optional Maximum of 2 NCEFEETHR decimals ESHOLD possible LIMITORDE Number 1 Optional Valid values This indicates RALLOWED are 0 and 1 whether limit orde
148. mber 12 Optional Valid bank code maintained in the RBRANCH system CODE TRANSFE String 1 Optional Valid Account Type maintained in RACCOUN the system TTYPE TRANSFE String 16 Optional RACCOUN TNUMBER TRANSFE String 3 Optional A valid currency maintained in the RACCOUN system TCURREN CY CHEQUEN String 16 Optional Indicates the check number for UMBER Payment mode Q and Credit card number for payment mode R This is mandatory if mode of Payment is check Q or credit card R CHEQUED Date Optional For check payment modes this is ATE the date of issue of the check Must not be later than the current application date CLEARING Date Optional The date on which the check is DATE expected to be cleared If specified in the import file it must not be earlier than the application date If not the system computes the same as a date Cheque Date Clearing Period and this computed date is considered by default to be the clearing date CLEARING Optional The Cheque clearing status STATUS RATIO Number 3 Optional Indicates the ratio of payment to be made in the specified payment mode 2 113 ORACLE AUTHREJ String 1 Mandatory Values can be A Authorized U ECTSTAT Unauthorized R Rejected US IDENTIFIC Number Optional Indicates the identification number ATIONNU assigned to the third party MBER CONTACT Optional Indicates the name
149. mount Float This will be a dividend component Component code NP Interest Withheld Tax Float This will be a dividend component Component code IT Amount Property Dividend Float This will be a dividend component Component code PD Amount 3 1 6 Tax Aggregation Interface Format The formats for export and import of files for transfer of tax information are given below This is applicable to annuity taxes only The Record Specifications for the export file containing tax is as follows Field Name Description Data Remarks Type Tax Year The tax year applicable Number This will be set to the last day format ddmmccyy 8 of the fiscal year in he required format LOB Line of Business code String 3 Will be set as GAL GAL 3 100 ORACLE Agreement_Code Contract number Char 12 Policy number Product_Code Product Code Char 10 Product code Sequence Numeric Count Number Record number incremented 4 sequentially Owner_Client_Id Client Number or owner of Char 9 The unitholder id the contract Title Null Char 12 This will be set to null Initials Null Char 15 This will be set to null Surname Null Char 64 This will be set to null IDNumber Null Char 15 This will be set to null IDType Null Char 2 This will be set to null DOB Nulls Char 10 This will be
150. n for each Fund and it indicates the fund for which Fund transaction currency information has to be uploaded 3 71 ORACLE the system RULEEFFECT Date 8 Mandatory The Fund ID The rule IVEDATE and Rule effective date effective date for which fund combination transaction should be the currency same as information for defined in the fund has to 01FDR be maintained CURRENCYC Alphanumeric 3 Optional Valid currency If no currency ODE maintained in code is mentioned and this field is left blank then it means that there is no restriction on the currency used for transaction for this fund However if valid value is entered then the fund would be restricted for transaction in those currencies Serial Number 14 Segment Identification Number 13FAl Description This segment is used for providing Fund additional information Segment Mandatory Optional Mandatory Multiple records allowed for the same Fund and Rule Effective Date No Field Name Type Maximum Mandatory Characteristic Description Length Optional s Validations applicable SEGMENTID Alphanumeric 20 Mandatory Default value Standard value 13FAl of 13FAl to uniquely identify Fund additional information 3 72 ORACLE PROCESSID Alphanumeric 50 Mandatory Same value as in OOGEN Process ID This should identify the upload uniquely This should
151. n Case of Redemption if Payment type is Third Party then this field is used for mentioning the Third party Zip Code TRANSFERACCOUNTCU RRENCY VARCHAR2 Optional If the payment mode is Transfer then this field is used to denote the Currency of the Account Should be a valid currency as defined in the system Should be same as that of the payment currency TRANSFERACCOUNTHO LDERNAME VARCHAR2 100 Optional If the payment mode is Transfer then this field is used to denote the account holder name TRANSFERACCOUNTNU MBER VARCHAR2 16 Optional If the payment mode is Transfer then this field is used to denote the account number used for transfer TRANSFERACCOUNTTY PE VARCHAR2 Optional If the payment mode is Transfer then this field is used to denote the account type Should be a valid account type as defined in Parameters setup TRANSFERBRANCHCOD E VARCHAR2 12 Optional If the payment mode is Transfer then this field is used to denote the Branch code where the account is maintained Should be a 2 48 ORACLE valid Branch Code TRANSFERREFERENCE NUMBER VARCHAR2 20 Optional If the payment mode is Transfer then this field is used to denote the Reference number for the transfer account details CREDITCARDREFNO VARCHAR2 16 Optional If the payment mode is Credit Card then this field is used to denote the
152. n can be entered if backdated transactions are allowed in the corresponding product backdated transactions are not allowed then this date must not be earlier than the Application Date TXNAMT Number Mandatory The investment amount of the transaction NETAMT Number Optional TXNBASEC CY String Optional A valid currency maintained in the system TXNREMAR KS String 255 Optional Brief description of the transaction or any applicable remarks about the transaction MAKERID String Optional If this information is specified in the import file no validation is made with regards to the user profile maintenance in the FCIS system If it is not specified the ID of the logged in user at the time of import is taken by default as the Maker ID 2 105 ORACLE MAKERDAT Date 10 Optional If the date is not specified in E the import file the application date is considered to be the Maker Date by default CHECKERI String 10 If this information is specified D Optional in the import file no validation is made with regards to the user profile maintenance in the FCIS system If it is not specified it is defaulted to SYSTEM This information is applicable for the generation of authorized transactions CHECKERD Date 10 Optional If the date is not specified in ATE the import file the a
153. nal Enter a value to specify the standard lot for fund This is also the marketable lot PREFIXCER TCODE Alphanumeri c Optional Enter a character for this field This will be used as prefix to the Certificate Number STARTCERT ISSUEDNO Number Optional Enter a value for this field This is just for information For a new Fund the Certificate Numbers will start from this number 3 13 ORACLE LASTCERTI Number 5 Optional Enter a value for SSUEDNO this field This is to specify that this was the last certificate number that has been issued so far and system needs to start from next number For new funds this could be zero This is also equal to the Start Certificate Issue Number in the case of new Funds PREFIXDNR Number 1 Optional Enter a character CODE for this field This will be used as prefix to the Distinctive Number Record DNR Number This information is only applicable if you have specified the number of decimals for units as zero in the Number of Decimals for Units field in this screen 3 14 ORACLE STARTDNRI SSUEDNO Alphanumeri c k Optional Enter a value for this field This is just for information For new funds this will be same as last DNR issued number This information is only applicable if you have specified the number of decimals for units as zero in the Number of Dec
154. nce number or transaction number is mandatory BENEFICIARYID VARCH 12 Mandatory AR2 BENEFICIARYTYPE VARCH 2 Mandatory AR2 2 29 ORACLE BENEFICIARYNAME VARCH 100 Optional AR2 BENEFICIARYDOB DATE 7 Optional BENEFICIARYADDRE VARCH 255 Optional It should be SS AR2 separated by ADDRESSLINE1 ADDRESSLINE2 ADDRESSLINE3S ADDRESSLINE4 COUNTRY ZIPCODE EMAIL CONTACTPERSON BENEFICIARYRELATI VARCH 70 Optional ON AR2 BENEFICIARYPANNO VARCH 15 Optional AR2 BENEFICIARYFORM6 NUMBE 1 Optional 0 R BENEFICIARYUIN VARCH 15 Optional AR2 BENEFICIARYGROUP VARCH 1 Optional AR2 BENEFICIARYGENDE VARCH 1 Optional R AR2 BENEFICIARYIDTYPE VARCH 3 Optional AR2 BENEFICIARYIDNUM VARCH 15 Optional BER AR2 BENEFICIARYAWAR_ NUMBE 5 Optional D R BENEFICIARYBANKC VARCH 12 Optional ODE AR2 2 30 ORACLE 2 5 BENEFICIARYBRANC VARCH 12 Optional HCODE AR2 BENEFICIARYACCTY VARCH 1 Optional PE AR2 BENEFICIARYACCNA VARCH 100 Optional ME AR2 BENEFICIARYACCCC VARCH 3 Optional Y AR2 ACCOUNTNUMBER VARCH 16 Optional AR2 BENEFICIARYMFIN VARCH 15 Optional AR2 COUNTRYOFDOMICI VARCH 3 Optional LE AR2 RECOVERCGT NUMBE 1 Optional R BENEFICIARYIBAN String 36 Optional Used to capture the BENEFICIARYIBAN Transactions File Format For all imports of new and am
155. neecsaecesneecsaecssneecsaeceseeecsaeeeenee es 2 125 APPENDIX B UPLOAD FILE FORMATS B u csssccssscssssscssscesssscsssssssescssssssescssssssnsscsscssssessssssssssssnsses 3 1 3 1 FUND RULES UPLOAD FORMATS ss cies ssc abcess cc coete sds seca a a co s0es a aeaa eTo aE aa aii 3 1 3 1 1 Fund Rules Upload Segment Formats ccccccccsccesscesscesecesecnseenseessesseesseeseeesecesecesecaeceaecaeenaeeaeeeaeees 3 3 3 1 2 PROCESSINGFREGQ ref 11FLM T210 nierien pnn eiee eie ai e e eei ea nia eei 3 79 3 1 3 Fund Related Information Upload Segments Format s seseseesseeeeesseseresrereerseresssrreresesreesesreers 3 85 3 1 4 Fund Template based Upload Formdt cccccccccssccesscesscesecesecusecusecsseessesseeeaeeseeeseeeseceseensecnseeaeenss 3 95 3 1 5 EPU Upload File FOrmat s ssciscssasvssty sos aacbsicussessaseiecisatvas oveesesoiidecseeseasetosscatesssveasesusgeasadseseasetves eiS 3 99 3 1 6 Tax Aggregation Interface Format ccsscccsecesssecsenceessecesnceesecesneecsseceeeeecsaeeseneecsaecseneecaeeseaeecsaeeesaes 3 100 3 1 7 Agent Reference File i yero ea DEES AESA EEA E AE EEES 3 104 3 1 8 3 1 9 3 1 10 3 1 11 3 1 12 3 1 13 3 1 14 Oracle Financial Interface issccesveecssssssses sovsessassaseitasesstecsnsieesaseneuseasedbag bgsedteesasestassasesnescassseescbensebens 3 105 Global Order Placement Interface ccccccccccsccesscesscesecesecusecusecsecseecseesseesseeeseesseesceeceseenaecnaeenas 3 114 GL Setup Upload
156. ng precision for the NAV You cannot indicate a precision higher than 6 decimal places ROUNDOFF Alphanumeric 1 Optional Valid values Indicate the TRUNCATE are R for rounding options Round off T for the value of for Round the number of Down and U allotted units for Round up designated for the fund 3 19 ORACLE MATURITYD ATE DATE DATE Optional Indicate the maturity date for the fund This is applicable only if the fund is closed ended fund RETAINIPOB ALANCE Number Optional Valid values are 0 and 1 This is used to indicate if the IPO Balance of unit holders must to be stored for later use 1 indicate maintenance of IPO balance of Unit holders and 0 indicates that it need not be maintained separately CONFBEFAL CREQUIRED Number Optional Valid values are 0 and 1 This is used to indicate that a rejection of a transaction as applicable for all authorized transactions prior to allocation If this is not specified then all authorized transactions will be taken up for allocation directly 3 20 ORACLE AUTOREDE MPTIONALL OWED Number Optional Valid values are 0 and 1 This is used to indicate if Automatic Redemption is to be allowed for the fund This is applicable only for Open Ended funds When the balance the unit holder falls below a defined minimum
157. nication mode information has to be uploaded RULEEFFEC TIVEDATE Date Mandatory The Fund ID and Rule effective date combination should be the same as defined in 01FDR The rule effective date for which transaction processing communication mode information for the fund has to be maintained 3 46 ORACLE TRANSACTI Alphanum 2 Mandatory Valid values are Indicate the ONTYPE eric 01 for IPO 02 value for which for Subscription the transaction 03 for type for which Redemption the rules are 04 for Switch being set up from operation 05 for transfers and so on up to 10 COMMUNIC Alphanum 2 Mandatory Valid ATIONMODE eric Communicatio n mode code indicated as a part of Params Maintenance MINTRANSA Number 15 Optional Decimal values Minimum CTIONAMOU up to maximum transaction NT of 3 digits are amount allowed allowed for the transaction type and communication mode MAXTRANS Number 15 Optional Decimal values Maximum ACTIONAMO up to maximum transaction UNT of 3 digits are amount allowed allowed for the transaction type and communication mode MINTRANSA Number 15 Optional Decimal values Minimum CTIONUNITS up to maximum transaction of 6 digits are units allowed allowed for the transaction type and communication mode MAXTRANS Number 15 Optional Decimal values Maximum ACTIONUNIT up to maximum tran
158. nly DIVIDENDPA Number 5 Optional The lead time YMENTLEAD entered is in TIME days Each of the lead times must be less than the Dividend Declaration Frequency For example if the Dividend Declaration Frequency is WEEKLY the Board Meeting Lead Time cannot be 8 days NOOFDECIM Number 5 Optional Indicate the ALSFORDIVI maximum DEND number of decimals that would be reckoned for rounding precision for the dividend You cannot indicate a precision higher than 6 decimal places ROUNDOFF Alphanum 1 Optional Valid values are Indicate the TRUNCATE eric R for Round rounding DIVIDEND off T for Round options for the Down and U for value of the Round up dividend designated for the fund 3 53 ORACLE TDSBASIS Alphanum eric Optional D Each Dividend U Fiscal year This is to indicate whether slab should be looked for every dividend payment separately or whether consolidated on a fiscal year basis EPUCOMPO NENTS Number Optional Valid values are 0 and 1 This indicates the applicability of Earnings Per Unit and that the earnings per unit must be defined in terms of components or as a single value Setting up EPU components is not applicable for stock dividends DEFAULTDI STRIBUTION MODE Alphanum eric Optional Valid values are T Payout A C Transfer Q Payout Cheque and
159. not the application date is considered by default to be the transaction date Backdated 2 116 ORACLE transaction can be entered if backdated transactions are allowed in the corresponding product If backdated transactions are not allowed then this date must not be earlier than the Application Date FUNDID Alphanum 6 Mandatory ID of the fund eric involved in the transaction A valid fund id maintained in the system POLICYHOLDERI Optional Identification D number of the Policy Holder DERIVEDLOADID Optional Indicates the ID of the derived load mapped to the fund PARENTLOADID Optional Indicates the ID of the load mapped to the fund CHANGETYPE Optional Indicates the type of load override Discount Increase or Return value CHANGEVALUE Optional Indicates the altered return value for the allocation time load being overridden AUTHREJECTST String 1 Mandatory Values can be A ATUS Authorized U Unauthorized R Rejected TXNTYPE Mandatory Type of the Transaction The following are the valid transaction types allowed for bulk upload Bere ORACLE 62 Top up transaction 65 Surrender transaction 66 Switch transaction REFTYPE String Optional Can be same as the transaction type If left blank the system defaults internally to BT System picks up the load mapped to the fund b
160. nternal processing JGZZ_ RECON _R Not Used Char 240 Nulls Nulls EF Control Record The sum of the transaction amount for each day is recorded in the Control Record The file upload should have the following format on the file 8 Field Name Description Data OMUT Value Galaxy Value Type RECORD _ID Indicates it s the Char All 9s All 9s trailer record 50 GROUP_ID Unique Group Char Source file id amp run Source file id amp run Number to 15 number number distinguish import data within a source TOTAL_AMT_DR Total monetary Char Format Format amount of debits on 15 999999999999 99 999999999999 99 the file TOTAL_CNT_DR Total count of debits Char Format 99999999 Format 99999999 on the file 8 TOTAL_AMT_CR Total monetary Char Format Format amount of credits on 15 999999999999 99 999999999999 99 the file TOTAL_CNT_CR Total count of credits Char Format 99999999 Format 99999999 3 1 9 Global Order Placement Interface Files uploaded using the Global Order Placement should have the following format Field Name Calculation Disinvestments Investments Transaction Date N A Transaction Transaction Date Date Asset Code For each Product Fund Yes Yes combination an asset code would be maintained Fund Name N A Yes Yes 3 114 ORACLE Product Name N A Yes Yes Net Investment
161. ntification for each Fund and it indicates the fund for which Fund formula information has to be uploaded RULEEFFECT Date 8 Mandatory The Fund ID The rule IVEDATE and Rule effective date effective date for which fund combination formula should be the information for same as defined the fund has to in 01FDR be maintained COMPONENT Alphanumeric 10 Mandatory Valid ID components maintained in the system as a part of Params maintenance This also depends on whether this is used for Fund price computation or not 3 63 ORACLE FUNDPRICEC OMPUTATIO N Alphanumeric a4 Optional Indicates whether the data has to be used for Fund price computation or not This value should remain the same for the fund and Rule effective date combination In other words for a fund and Rule effective date we cannot have one component used for fund price computation and the other component not used for fund price computation FORMULA Alphanumeric 255 Optional DEFAULTVAL UE Number Optional Maximum of 6 decimals allowed EXCLUDEFR OMCAPITALG AINS Number Optional Serial Number 12 Segment Identification Number 11FLM Description This segment is used for providing Fund load information Segment Mandatory Optional Optional Multiple records allowed for the same Fund and Rule Effective Date Yes
162. numeric 60 Optional 2 3 74 ORACLE ee Alphanumeric 60 Optional ee Alphanumeric 60 Optional puree Alphanumeric 60 Optional penn n Alphanumeric 60 Optional a Alphanumeric 60 Optional ners Alphanumeric 60 Optional n Alphanumeric 60 Optional oer Alphanumeric 60 Optional peda Alphanumeric 60 Optional ee Alphanumeric 60 Optional aici Alphanumeric 60 Optional oe Alphanumeric 60 Optional Ai a Alphanumeric 60 Optional E Alphanumeric 60 Optional PREE Alphanumeric 60 Optional EE Alphanumeric 60 Optional E Alphanumeric 60 Optional aia Alphanumeric 60 Optional 3 75 ORACLE Serial Number 15 Segment Identification Number 14IRA Description This segment is used for providing Fund IRA information if applicable Segment Mandatory Optional Optional Multiple records allowed for the same Fund and Rule Effective Date No Field Name Type Maximum Length Mandatory Optional Characteristics Validations applicable Description SEGMENTID Alphanumeric 20 Mandatory Default value 14IRA Standard value of 14IRA to uniquely identify Fund IRA information PROCESSID Alphanumeric 50 Mandatory Same value as in OOGEN Process ID This should identify the upload uniquely This should also be unique within a file and it allows to identify imported records later
163. ny form or by any means electronic mechanical photographic graphic optic recording or otherwise translated in any language or computer language without the prior written permission of Oracle Financial Services Software Limited Due care has been taken to make this document and accompanying software package as accurate as possible However Oracle Financial Services Software Limited makes no representation or warranties with respect to the contents hereof and shall not be responsible for any loss or damage caused to the user by the direct or indirect use of this document and the accompanying Software System Furthermore Oracle Financial Services Software Limited reserves the right to alter modify or otherwise change in any manner the content hereof without obligation of Oracle Financial Services Software Limited to notify any person of such revision or changes All company and product names are trademarks of the respective companies with which they are associated 3 2 ORACLE
164. oad is a LON G Capital Capital Gains Gains Gross N Tax and it is to Non capital be applied gains Net and based on the C Capital gross amount gains and after allocation choose the P Capital Gains Performance Gross option in Based and I this field for IOF and D such a load Default IRRF and O Optional IRRF and S CDSC SENDFORGLI Number 1 Optional Valid values are This is used to NTERFACE 0 and 1 indicate that accounting entries due only to the selected load must be posted to the external asset management system for the fund REFTYPE Alphanumeric 2 Mandatory Validreference When load type as per the needs to be pre shipped mapped to a data in reference RefTypeTbl transaction type like Reinvestment and if the system supports the mapping of the Ref Type to any load then such RefTypes can be indicated here 3 69 ORACLE DIFFERENTIA LFEE Number Optional Valid values are O and 1 This is to indicate whether differential fee in the case of switch transactions for any fund is to be applicable SLABBASIS Alphanumeric Optional Valid values are G for Gross and N for Net W Weighted Average This is to Indicate the basis on which the slabs will be reckoned for an amount based load that you are designating as applicable for the fund PRICEADDIN Number Optional This is used to
165. of the contact NAME person ADDRESS Optional Indicates the address of the third LINE1 party to whom the transfer payment must be made ADDRESS Optional Indicates the address of the third LINE2 party to whom the transfer payment must be made TRANSFE Optional Indicates the reference number of RREFNUM the transfer transaction BER IBAN String 36 Optional Used to capture the IBAN Serial Number 5 Segment Identification Number OOSWF 2 13 5 Policy Transaction Switch Fund related Seqment Formats Description This segment provides transaction switch fund related information Segment Mandatory Optional Mandatory for Switch transactions Field Name as expected in the file Data type Field length Mandatory Characteristics Values rules SEQUENCENUMBER Number 10 Mandatory Sequence no of transaction record in the file Each uploaded transaction has a unique sequence number 2 114 ORACLE PROCESSID String 50 Mandatory The Process ID along with the system generated sequence number identifies the uploaded record uniquely Each file must have a unique Process ID and it should be same within a file for all the records POLICYTXNNUMBER String 16 Mandatory Is blank for new transactions For amendment deletion and edition either the reference number or transaction number should be specified TOFUNDID Alphanumeric
166. on purposes only and has no processing implications in the system database CONTRAACG OUNTCODE Alphanumeric Optional Specify the code that will be used to identify the second leg of accounting entries for any transaction in the event of exporting of transaction information to an external system 3 67 ORACLE NOOFDECIM Number Optional Valid values are Indicate the ALSFORLOA R for Round rounding D off T for Round options for the Down and U for value of the Round up load designated for the fund ROUNDOFFT Alphanumeric Optional Indicate the RUNCATEFO maximum RLOAD number of decimals that would be reckoned for rounding precision for the load You cannot indicate a precision higher than 6 decimal places MANDATORY Alphanumeric Optional Valid values are Select M and O Mandatory or Optional to specify whether the load is mandatory or optional PRIORITYNO Number Optional For a mandatory Enter a value load the priority to specify the number is setto priority number 0 and for an in case of optional load the optional loads priority number should be unique i e for a given Fund no more than one load can have the same priority number LOADVATTO Number Optional Valid values are PRICE 1 and0 3 68 ORACLE APPLYRETVA Alphanumeric 1 Optional Valid vales are If the l
167. oned in the Bulk Client Defaults Maintenance for the bulk client will be used REDEMPTIONM String Optional Could be either of the OP following Values Q Cheque T Transfer If this information is not given in the import file then the Default Redemption Mode of Payment specified in the Bulk Client Defaults Maintenance for the bulk client will be used i ACCOUNTSTMT String 3 Optional Could be any of the valid CURRENCY currencies maintained in Currency Maintenance If this information is not given in the import file then the Default Account Statement Currency mentioned in the Bulk Client Defaults Maintenance for the bulk client will be used EMAILID String 60 Optional Accepted from the user s specification for the same in the hand off file contents FIRSTJOINTUH String 60 Optional The primary unit holder NAME name in case of joint accounts SECONDUJOINT String 60 Optional The secondary unit UHNAME holder name in case of joint accounts THIRDJOINTUH String 60 Optional The third unit holder NAME name in case of joint accounts ALTADDRESSF DATE Optional ROMDATE aa ORACLE ALTADDRESST DATE Optional ODATE TELEPHONERE Number 1 Optional Value Could be either 0 false D defaulted as or 1 true to indicate maintained whether redemption in Bulk client transactions can be defaults in accepted through
168. or IPO 3 10 ORACLE NOOFDECIM ALSFORUNI TS Number Optional Indicate the maximum number of decimals that would be reckoned for rounding precision for the number of allotted units You cannot indicate a precision higher than 6 decimal places ROUNDOFF TRUNCATE Alphanumeri c Optional Valid values are R for Round off T for Round Down and U for Round up Indicate the rounding options for the value of the number of allotted units designated for the fund MINNOOFU NITHOLDER S Number Optional At any point of time when the fund is enabled the number of unit holders cannot fall below this value This value must not be lower than zero MAXNOOFU NITHOLDER S Number Optional At any point of time when the fund is enabled the number of unit holders cannot go above this value MINREGIST EREDCAPIT AL Number 20 Optional Maximum of 6 decimal places allowed At any point of time when the fund is enabled the fund corpus registered capital cannot go below this value ORACLE MAXREGIST Number NUMBER Optional Maximum of 6 At any point of EREDCAPIT 30 12 decimal places time when the AL allowed fund is enabled the fund corpus registered capital cannot go above this value CAPINDICAT Alphanumeri 1 Optional Valid values This is to specify OR c are A and P the foreign inv
169. or this transaction BASEPRICE NUMBER Optional This percentage FACTOR will be applied to the price arrived from the above calculations to arrive at the Base Price for this transaction type for the fund NOOFDECIM NUMBER Optional Indicate the ALSFORBAS maximum EPRICE number of decimals that would be reckoned for rounding precision for the base price You cannot indicate a precision higher than 6 decimal places i 3 35 ORACLE ROUNDOFF TRUNCATEB ASEPRICE Alphanumeric i Optional Valid values are R for Round off T for Round Down and U for Round up Indicate the rounding options for the value of the number of allotted units designated for the fund TRANSACTI ONENABLE D NUMBER Optional This is used to indicate whether the transaction is enabled for the fund Itis possible to set up a temporary suspension of transactions even if the transactions are open for the fund CROSSBRA NCHALLOW ED NUMBER Optional Valid values are 0 and 1 PRICELAG NUMBER Optional This cannot have negative value This indicates the price date to be used for the transaction during allocation process ALLOCATIO NLAG NUMBER a4 Optional Enter a value to specify when the transaction should be allocated if the transaction is T T X where X will be days of Lag
170. ot specified it is defaulted to SYSTEM This information is applicable for the generation of authorized transactions CHECKER_DT_ STAMP Date Optional If the date is not specified in the import file the application date is considered to be the Checker Date by default This information is applicable for the generation of authorized transactions AUTHTYPE String Mandatory Values can be A Authorized U Unauthorized R Rejected CIFNUMBER String Optional If value is given then it is validated against the unit holder CIF else the unit holder CIF is 2 37 ORACLE populated TOCIFNUMBER String 12 Optional If value is given it is validated against the CIF of the To unit holder Else the CIF of the to unit holder id is populated GROSSORNET _ String 1 Optional Can have values of G or N Is mandatory for new mode SUBPAYMENTM String 2 Optional Can have valid ODE values as defined in the mode of payment table This is also mandatory for new mode The mode of payment given should correspond to the sub payment mode COMMUNICATI String 2 Optional Communication ONMODE mode should be validated against the param values stored in the Params table for the Param Code COMMUNICATION MODE If no communication mode is specified then the first communication mode stored in the Params table is defaulted POLICYN
171. ould not Contact person specified ACTPERSON exist in the in alternate language absence of Contact person ALTLANGCORA String 80 Optional Should not Correspondence address DDRESSLINE1 exist in the line 1 specified in absence of alternate language Correspond ence address line 1 ALTLANGCORA String 80 Optional Should not Correspondence address DDRESSLINE2 exist in the line 2 specified in absence of alternate language Correspond ence address line 2 21 ORACLE ALTLANGCORA String 80 Optional Should not Correspondence address DDRESSLINE3 exist in the line 3 specified in absence of alternate language Correspond ence address line 3 ALTLANGCORA String 80 Optional Should not Correspondence address DDRESSLINE4 exist in the line 4 specified in absence of alternate language Correspond ence address line 4 ALTLANGALTA String 80 Optional Should not address line 1 specified in DDRESSLINE1 exist in the alternate language absence of address line1 ALTLANGALTA String 80 Optional Should not address line 2 specified in DDRESSLINE2 exist in the alternate language absence of address line2 ALTLANGALTA String 80 Optional Should not address line 3 specified in DDRESSLINE3 exist in the alternate language absence of address line 3 ALTLANGALTA String 80 Optional Should not address line 4 specified in DDRESSLINE4 exist in the alternate language absence of address line 4 DATEOFCONTR
172. oviding Fund Investment Account Sl if applicable Optional Yes 20HFP This segment is used to include hedge fund parameters Optional No 21HFL This segment is used to provide hedge fund linkage details Optional Yes 3 2 ORACLE 22HFD This segment is used to Optional Yes provide investor category details for hedge funds Each of the segments have variable list of fields stored as information pertaining to that segment The list of fields for each segment is mentioned in the following tables along with the description of the segment 3 1 1 Fund Rules Upload Segment Formats Serial Number 1 Segment Identification Number OOGEN Description This segment is used for providing information that is common to the other fund rules that need to be uploaded in the system Mandatory Mandatory and will be the driving header segment for all the other segments Multiple records allowed for the same fund and Rule Effective Date No Field Name Type Maximum Mandatory Character Description Length Optional istics Validation s applicable PROCESSID Alphanumeric 50 Mandatory This should identify the upload uniquely This should also be unique within a file and it allows to identify imported records later BULKCLIENTCO Alphanumeric 12 Mandatory Valid authorized DE enabled Bulk client codes maintained in the system as a part of Entity Maintenance
173. pload uniquely This should also be unique within a file and it allows to identify imported records later FUNDID Alphanumeric 6 Mandatory The Fund ID is a unique Identification for each Fund and it indicates the fund for which General operating rules information has to be uploaded RULEEFFEC Date 8 Mandatory The Fund ID The rule effective TIVEDATE and Rule date for which effective date general operating combination rules information should be the for the fund has same as to be maintained defined in 01FDR 3 18 ORACLE POSTPRICE Number 1 Optional Valid values Enter 1 if the D are 0 and 1 price for the fund will be announced Post Transactions Else enter 0 if it is a pre priced fund NEXTPRICE DATE DATE Optional Specify the next DECLAREDA date upon which TE the fund price is to be declared This date must be after the Rule Effective Date of the fund and the current system date PRICEDECL Alphanumeric 1 Optional Valid values This is used to AREFREQ are D for indicate the Daily W for frequency with Weekly F or which the price B for Bi will be weekly M announced If the for Monthly fund is Post Q for priced Fund you Quarterly must specify this H for Half frequency as yearly Y for Daily Yearly NOOFDECIM Number 1 Optional Indicate the ALSFORNAV maximum number of decimals that would be reckoned for roundi
174. pplication date is considered to be the Checker Date by default This information is applicable for the generation of authorized transactions COUNTUP Optional DATESERI AL AUTHREJE String 1 Mandatory Values can be A Authorized CTSTATUS U Unauthorized R Rejected AGENTCO Number 12 Mandatory Valid agent code maintained DE in the system BRANCHC Number 12 Mandatory Valid branch code ODE maintained in the system DRAWEEB Number 12 Optional Valid bank code maintained ANKCODE in the system TRANSFER Number 12 Optional Valid bank code maintained BRANCHC in the system ODE TRANSFER String 1 Optional Valid Account Type ACCOUNTT maintained in the system YPE 2 106 ORACLE TRANSFER String 16 Optional ACCOUNT NUMBER TRANSFER String 3 Optional A valid currency maintained ACCOUNT in the system CURRENC Y PAYMENT String 1 Optional Indicates mode of payment MODE Can be any of the following values Q Cheque T Transfer R Credit card C Cash D Draft CHEQUEN _ String 16 Optional Indicates the check number UMBER for Payment mode Q and Credit card number for payment mode R This is mandatory if mode of Payment is check Q or credit card R CHEQUED Date Optional For check payment modes ATE this is the date of issue of the check Must not be later than the current application date CLEARING Date Optional The date on which the check
175. ptional Enter a time to specify the start time for a given working date On a given day when the fund is open for this transaction you can start entering transactions from this time MINTRANSAC TIONAMOUNT NUMBER Optional Maximum of 3 decimals allowed The minimum transaction amount allowed for this transaction type in this fund STEPAMOUN T NUMBER Optional Maximum of 3 decimals allowed Enter a value to specify the steps of amount in which a unit holder can invest or redeem This will operate above the Minimum Transaction Amount MAXTRANS ACTIONAMO UNT NUMBER Optional Maximum of 3 decimals allowed The maximum transaction amount allowed for this transaction type in this fund MINTRANSA CTIONUNITS NUMBER Optional Maximum of 6 decimals allowed The minimum transaction units allowed for this transaction type in this fund STEPUNITS NUMBER Optional Maximum of 6 decimals allowed The unit steps applicable for a unit holder to invest do any operation 3 31 ORACLE MAXTRANS NUMBER 15 Optional Maximum of The maximum ACTIONUNIT 6 decimals transaction S allowed units allowed for this transaction type in this fund ONLINEALL NUMBER 1 Optional Valid values This is to OCATION O and 1 indicate if Online Allocation is to be allowed for the given transaction type This can be applicabl
176. r ID maintained in the system REFTOUNITHO LDERID Optional Should be left blank TRANSACTION TYPE String Mandatory Type of the Transaction The following are the valid transaction types allowed for bulk upload 02 Subscription 03 Redemption 04 Switch 05 Transfer REFTYPE String Optional Can be same as the transaction type If left blank the system defaults internally to BT System picks up the load mapped to the fund based on the transaction type and reftype REMARKS String 255 Optional Hand off file contents CERTIFICATE String 2000 Optional Concatenated string of certificate details used for the transaction Applicable only for certificate base transaction MAKERID String Optional If this information is specified in the import file no validation is made with regards to the user profile maintenance in the FCIS system If it is 2 36 ORACLE not specified the ID of the logged in user at the time of import is taken by default as the Maker ID MAKER_DT_ST AMP Date Optional If the date is not specified in the import file the application date is considered to be the Maker Date by default CHECKERID String Optional If this information is specified in the import file no validation is made with regards to the user profile maintenance in the FCIS system If it is n
177. r fax received ORIGINALRECEIVED Numb 1 Optional 0 1 1 to indicate er Original received RECEIVEDDATE Date Optional USERCOMMENT String 255 Optional Additional information related to the KYC Doc WORKFLOWREFNO Numb 20 Optional Enter the workflow er reference number number of the corresponding document from the external imaging system here DOCUMENTTYPE String 1 Mandatory A S A Additional S Standard PROCESSID1 Varch 60 Optional Added processid1 ar2 for Benchmarking RECORD_STAT Varch 1 Optional For audit fields ar2 ONCE_AUTH Varch 1 Optional For audit fields ar2 INITIALS Varch 10 Optional Initials for the ar2 unitholder KYCPURCHASELIMIT Numb 30 12 Optional This should be er taken from 8 0 doc 2 27 ORACLE 2 4 KYCANNUALDEBITOR Numb 30 12 Optional This should be DERLIMIT er taken from 8 0 doc RELATEDPARTIES Varch 2000 Optional Unitholder related ar parties information with semicolon separator REDEMPTIONPAYOUT VARC 1 Optional Value Used to capture the HAR defaults to Redemption Payout N in the flag absence of information in the file DIVIDENDPAYOUT VARC 1 Optional Value Used to capture the HAR defaults to Dividend Payout N in the flag absence of information in the file Unit Holder Beneficiary Details Field Name as Data Field Mandatory Charact Values expected in the file type length eristics
178. r is applicable for the fund depending upon the price FUTURELIMI Number 1 Optional Valid values Indicates limit TORDERALL are 0 and 1 order based on OWED Date AUTOLIMITO Number 1 Optional Valid values If limit order is RDERPROC are 0 and 1 based on price ESS indicates whether automatic triggering of processing is required or not PRICINGRU Alphanumeric 1 Optional Valid values Rule to be LE are A for applied for pricing After and P for Prior MinThreshHo Number 5 Optional Maximum of 2 Used for IdLimit decimals capturing possible Minimum Threshold Limit EUSDSCOP Alphanumeric 1 Optional Valid values Used to cater E are R for EUSD Redemption amp requirements Switch Out and D for Dividend and B for Both Shown only for EUSD applicable segments 3 25 ORACLE AgeingDate Alphanumeric Optional Valid values Used to store are T for Ageing basis Transaction value Date and C for Confirmation date and D for Dealing date INVESTMEN Alphanumeric Optional Valid values This indicates TSIMULATIO are N and H whether the NMETHOD Investment Simulation Method should be a Not Allowed or Historic Based NAV MINLOCKIN Number Optional Valid values PERIODFOR are Greater GAIN than or equal to 0 MAXLOCKIN Number Optional Valid values PERIODFOR are Greater GAIN than or equal to the Min Lock in Period
179. reference number for the same INKINDPAYMENTDETAIL S VARCHAR2 255 Optional If the payment mode is In Kind Payment then this field is used to capture the Payment details PAYMENTADDRESSDET AILS VARCHAR2 255 Optional If the payment mode is Cheque Then this field is used to capture the UH Address details This is done only in case of any change in the same OLDPAYMENTREFEREN CENO VARCHAR2 16 Optional NA Should be Blank UHBICCODE VARCHAR2 24 Optional Used to capture the Biccode as a part of Payment routing details SWIFTFORMAT VARCHAR2 Optional Used to capture the Swift Format as a part of Payment routing details BANKCHARGED VARCHAR2 12 Optional Used to capture the Bank Charged as a part of Payment routing details BENEFICIARY VARCHAR2 35 Optional Used to capture the Beneficiary details as a part of Payment routing details BENEFICIARYADD1 VARCHAR2 35 Optional Used to capture the Beneficiary address details as a part of Payment routing details BENEFICIARYADD2 VARCHAR2 35 Optional Used to capture the Beneficiary address details as a part of Payment routing details 2 49 ORACLE BENEFICIARYADD3 VARCHAR2 35 Optional Used to capture the Beneficiary address details as a part of Payment routing details BENEFICIARYBICCODE VARCHAR2 24 Optional U
180. rocessing Communication there is a separate Mode information record O6INV This segment is used for Mandatory Yes For each providing Transaction transaction type Processing Investor Category there is a separate related information record 07IDR This segment is used for Optional Yes For cash and providing Corporate Action Stock dividend related information information 3 1 ORACLE O08FSC This segment is used for providing Fund Sale Country information Mandatory Yes O9FRL This segment is used for providing Fund Residency List information Mandatory Yes 10FFM This segment is used for providing Fund Formula information Optional Yes 11FLM This segment is used for providing Fund Load information Optional Yes 12FTC This segment is used for providing Fund Transaction Currency information Mandatory Yes 13FAl This segment is used for providing Fund Additional Information Mandatory No 14IRA This segment is used for providing Fund IRA Information if applicable Optional No 15FDI This segment is used for providing Fund Delivery Instructions if applicable Optional No 17KYC This segment is used for providing the Customer document details if applicable Optional Yes 18MLD This segment is used for providing Multi language details if applicable Optional Yes 19FSI This segment is used for pr
181. rules SEGMENTID VARCH 20 Mandatory SegmentID is used AR2 for identifying the settlement details In this case Segment ID will be O1SET SEQUENCENUMBER NUMBE 10 Mandatory This is used for R mentioning the sequence for the settlement details of a transaction PROCESSID VARCH 50 Mandatory The Process ID AR2 along with the system generated sequence number identifies the uploaded record uniquely Each file must have a unique Process ID This should be same for all records within a file 2 28 ORACLE BULKCLIENTCODE VARCH 12 Mandatory The Code of the Bulk AR2 client IMPORTFILENAME VARCH 255 Mandatory Name of the file AR2 being uploaded should be specified Each file must have a unique name AMCID VARCH 12 Mandatory The ID of the AR2 AMC Distributor for which the bulk client has maintained the defaults details UPLOADMODE VARCH 1 Mandatory N for New unit AR2 holder uploads and T for Information change UNITHOLDERID VARCH 12 Optional AR2 AUTHREJECTSTATU VARCH 1 Optional A U A Authorised S AR2 Record U Unauthorised Record REFERENCENUMBE VARCH 12 Optional Any additional R AR2 reference number that can be given optionally No validations will be made for the same The system will generate and update the Reference Number based on the Bulk Client Default Maintenance For amendment deletion or rejection either the refere
182. s ae ORACLE RELATIONSHIP String 70 Optional Accepted from the user s specification for the same in the hand off file contents BENEFICIARY String 70 Optional Accepted from the user s specification for the same in the hand off file contents SEX String 1 Optional Value Could be either of the defaulted as following values maintained M Male or F Female in Bulk client defaults in the absence of information in the file MARITALSTATU String 1 Optional Value Could be either of the S defaulted as following values S maintained Single M Married in Bulk client The default status is defaults in taken to be Single the absence of information in the file OCCUPATION String 3 Mandatory Value Could be any of the defaulted as values maintained in maintained Occupation Maintenance in Bulk client defaults in the absence of information in the file NATIONALITY String 3 Optional Value Accepted from the user s defaulted as specification for the same maintained in the hand off file in Bulk client contents defaults in the absence of information in the file COUNTRYOFD _ String 3 Optional Value Could be any of the OMICILE defaulted as values maintained in maintained Country Maintenance in Bulk client defaults in 2 9 ORACLE the absence of information in the file CORPO
183. s Transaction ORY are NULL processing rules NO and Investor YES category information FSC Alphanumeric Optional Valid values Fund sale are NULL country NO and information YES FRR Alphanumeric Optional Valid values Fund residency are NULL list information NO and YES FTC Alphanumeric Optional Valid values Fund are NULL transaction NO and currency YES information FFM Alphanumeric Optional Valid values Fund formula are NULL maintenance NO and information YES FLM Alphanumeric Optional Valid values Fund load are NULL maintenance NO and information YES 3 98 ORACLE FAI Alphanumeric 3 Optional Valid values Fund additional are NULL information NO and YES IRA Alphanumeric 3 Optional Valid values IRA information are NULL NO and YES FDI Alphanumeric 3 Optional Valid values Fund delivery are NULL instruction NO and information YES FEM Alphanumeric 3 Optional Valid values Fund entity are NULL maintenance NO and information YES FAB Alphanumeric 3 Optional Valid values Fund agency are NULL branch back NO and dating limit YES information FBC Alphanumeric 3 Optional Valid values Fund based are NULL calendar NO and information YES 3 1 5 EPU Upload File Format EPU upload is specific to OMSTA as the assumption is that OMSTA maintains the following components and those component n
184. s PAYMENTALLO Number 1 Optional Should be left WED blank LOADOVERRID String 2000 Optional Load override EINFO information list of records separated by Each record represents load override for a specific load Each record is of the form LOADID FUNDID CHANGETYPE CH ANGEVALUE GRO UPID where Load ID Valid load id as maintained in the system Fund ld Current fund Id Change type Should I D or R representing Increase Decrease or Return value respectively Change value The override value DERIVEDLOAD String 2000 Optional Similar to Load for OVERRIDEINFO Derived Load PROCESSID1 String 51 Mandatory Should be same as the Process ld SUBLOADOVER String 2000 Optional Applicable for RIDEDETAILS pseudo switches aoe ORACLE SUBDERIVEDL String 2000 Optional Applicable for OADDETAILS pseudo switches SUBSETTLEME Date Optional Applicable for NTDATE pseudo switches SUBPRICEDAT _ Date Optional Applicable for E pseudo switches SUBEXCHRATE String 2000 Optional Applicable for OVERRIDEDET pseudo switches AILS BASECOST Number 15 6 Optional Should be left blank EXCHANGERAT String 35 Optional Should be left blank EDETAILS LOCKINPERIOD Number 4 Optional FORGAIN FEECURRENCY String 3 Optional Valid values are Could be either FBC and TC FBC Fundbase Currency and
185. s true ALLOWROAATC Number 1 Optional Could be either 0 False IFLEVEL or 1 True If an investor is an ROA investor then this option will be set based on the value of the Allow ROA LOI at CIF level in the AMC policies table UHACCOUNTTY String 2 Optional Value Should be a valid unit PE defaulted as holder account type as maintained available in the Params in Bulk client maintenance defaults in the absence of information in the file RPOCODE String 10 Optional Value Should be a valid code as defaulted as maintained in the maintained Params table for the in Bulk client Param code defaults in RPOESCHCODE If not the absence supplied will be picked of up from the bulk client information defaults table in the file REGISTRATION String 2 Optional Value Should be a valid code as TYPE defaulted as maintained in the Params maintained table for the Param code in Bulk client UVHREGISTRATIONTYP defaults in E If not supplied will be the absence taken from the bulk client of defaults table information in the file REGISTRATION String 50 Optional If registration type SN NAME Street name only then this value is to be read ACCOUNTOPE _ String 30 Optional NINGPURPOSE REMARKS String 255 Optional 2 13 ORACLE PREFERREDMA String 2 Optional Value Should be a valid code as ILMODE defaulted as read from the Params maintained table for
186. s segment is used for Mandatory Yes providing settlement information for a transaction 02KYC This segment is used for Optional Yes providing KYC related information O3AIF This segment is used for Optional No providing Txn add info related information Segment Identification Number 0OOCON General Transaction Information Field Name as Data Field Mandatory Characteristics Values expected inthe type length rules file SEQUENCENU Number 10 Mandatory Sequence no of MBER records in the file PROCESSID String 50 Mandatory The Process ID along with the system generated sequence number identifies the uploaded record uniquely Each file must have a unique Process ID and it should be same within a file for all the records BULKCLIENTCO String 12 Mandatory The Code of the DE bulk client IMPORTFILENA String 255 Mandatory The name of the file ME being uploaded should be specified Each file must have 2 32 ORACLE a unique name AMCID String 12 Mandatory The ID of the AMC for which the bulk client has maintained the default details This should be same within a file for all the records UPLOADMODE String k Mandatory N for new transactions I for amended transactions and D for transactions to be deleted TRANSACTION String 16 Mandatory Is blank for new NUMBER transactions For amendment deletion and re
187. s the unit holder ID or additional information to identify a unit holder in the system depending on the scheme cross reference number TOFUNDI D String 25 Optional For standing instructions involving switch transactions this is the ID of a valid fund maintained in the system to which the investment will be switched It cannot be the same as the Fund ID AGENTCO DE String Optional The Code of a valid agent maintained in the system BRANCHG ODE String Optional The Code of a valid branch maintained in the system MODULE String 30 Optional 2 60 ORACLE D MODEOFP String 1 Optional Indicates the mode of AYMENT payment Can be any of the following values Q Cheque T Transfer R Credit card C Cash D Draft PAYMENT String 12 Optional The Code of a valid branch BRANCHC maintained in the system ODE TRANSFE String 1 Optional A valid Account Type RACCOUN maintained in the system TTYPE TRANSFE String 16 Optional The number of the transfer RACCOUN account for transfer and TNUMBER credit card payments REMINDE Numb 3 Optional Valid number RBEFORE er PERIOD REMINDE Numb 1 Optional RBEFORE er ACTION SISTATUS String 1 Optional The status of the standing instruction It can be A Active P Paused C Cancelled GENERAT Numb 1 Op
188. saction S of 6 digits are units allowed allowed for the transaction type and communication mode 3 47 ORACLE DISALLOWFI RSTTRANSA CTION Number Optional Valid values are 0 and 1 Serial Number 7 Segment Identification Number O6INV Description This segment is used for providing Transaction processing investor category related information Segment Mandatory Optional Mandatory Multiple records allowed for the same Fund and Rule Effective Date Yes For each transaction type there is a separate record Field Name Type Maximum Length Mandatory Optional Characteristics Validations applicable Description SEGMENTID Alphanum eric 20 Mandatory Default value O6INV Standard value of O6INV to uniquely identify Transaction processing communication mode information PROCESSID Alphanum eric 50 Mandatory Same value as in OOGEN Process ID This should identify the upload uniquely This should also be unique within a file and it allows to identify imported records later 3 48 ORACLE FUNDID Alphanum 6 Mandatory The Fund ID is eric a unique Identification for each Fund and it indicates the fund for which Transaction processing investor category information has to be uploaded RULEEFFEC Date 8 Mandatory The Fund ID The rule TIVEDATE and Rule
189. se Segment ID will be ao ORACLE O1SET TXNSERIALNU MBER NUMBER Mandatory This number is used to identify for which transaction this settlement details are used i e if the TxnSerialNumber of a transaction is 1 then the TxnSerialNumber should be same for the settlement details also SEQUENCENU MBER NUMBER Mandatory This is used for mentioning the sequence for the settlement details of a transaction PROCESSID VARCHAR2 50 Mandatory This ID should be unique for each upload of transactions BULKCLIENTCO DE VARCHAR2 12 Mandatory All the defaults values for transaction will be taken up based on this Bulk Client Code IMPORTFILENA ME VARCHAR2 255 File name should be the same as defined in File specifications of Interface definition AMCID VARCHAR2 12 Mandatory The ID of the AMC for which the bulk client has maintained the default details This should be same within a file for all the records UPLOADMODE VARCHAR2 Mandatory N for new transactions P for amended transactions and D for transactions to be deleted TRANSACTION NUMBER VARCHAR2 16 Mandatory Transaction Number REQUESTED VARCHAR2 Optional 1 0 1 means requested the KYC Doc DOCUMENTDE SCRIPTION VARCHAR2 255 Optional KYC Doc Description 2 52 ORACLE
190. sed to capture the Biccode for the Beneficiary as a part of Payment routing details BENEFICIARYACCTNO VARCHAR2 24 Optional Used to capture the Account Number for the Beneficiary as a part of Payment routing details BENEFICIARYCODE VARCHAR2 24 Optional Used to capture the Code for the Beneficiary as a part of Payment routing details BENEFICIARYINFO VARCHAR2 100 Optional Used to capture the Information free format text for the Beneficiary as a part of Payment routing details INTERMEDIARY VARCHAR2 35 Optional Used to capture the Intermediary as a part of Payment routing details INTERMEDIARYADD1 VARCHAR2 35 Optional Used to capture the Intermediary address as a part of Payment routing details INTERMEDIARYADD2 VARCHAR2 35 Optional Used to capture the Intermediary address as a part of Payment routing details INTERMEDIARYADD3 VARCHAR2 35 Optional Used to capture the Intermediary address as a part of Payment routing details INTERMEDIARYBICCOD E VARCHAR2 24 Optional Used to capture the Intermediary Biccode as a part of Payment routing details INTERMEDIARYACCTNO VARCHAR2 24 Optional Used to capture the Intermediary Account Number as a part of Payment routing details INTERMEDIARYCODE VARCHAR2 24 Optional Used to capture the Intermediary Code as a part 2 50
191. sing a frequency They are not applicable to dates arrived at using lead times or lag periods 3 57 ORACLE PAYMENTLA Number Optional Specify a lag G period in days for the payment of dividend The lag value is interpreted in calendar days and is used to arrive at the payment date for the dividend The payment date is arrived at as follows Dividend Payment Date Dividend Declaration Date Payment Lag PAYDIVIDEN Number Optional This is used to DDURINGRE indicate that D dividends may be paid during redemption REINVESTM Alphanum Optional ENTPRICEB eric ASIS IRACOMPUL Number Optional Applicable only SORYREINV if IRA is EST applicable for the fund NPISUPPOR Alphanum Optional T eric NPIPAYMEN Alphanum Optional T eric NPIUHOverri Alphanum Optional de eric FlgUnsettleU Alphanum Optional nits eric MIMAMTTOB NUMBER Optional EPAIDOUT 3 58 ORACLE ACTION VARCHAR 1 Optional Valid values are 2 L and R OVERRATP NUMBER 1 Optional Valid values are AYTIME 0 and 1 AUTOREINV NUMBER 1 Optional Valid values are FORUNCLC HQ 0 and 1 AUTOREINV NUMBER 1 Optional Valid values are FORUNCLC HQFZB 0 and 1 TRACKUNCL VARCHAR 1 Optional Valid values are EAREDTXNS 2 0 and 1 TRACKBLOC VARCHAR 1 Optional Valid values are KEDTXNS
192. specification 2 PRIMARYAD String 80 Optional Accepted from the user s DRESSLINE specification 3 PRIMARYAD String 80 Optional Accepted from the user s DRESSLINE specification 4 PRIMARYZIP String 10 Optional Accepted from the user s CODE specification PRIMARYTE String 15 Optional Accepted from the user s LEPHONE1 specification PRIMARYTE String 15 Optional Accepted from the user s LEPHONE2 specification PRIMARYCE String 16 Optional Accepted from the user s LLPHONENU specification MBER PRIMARYFA String 15 Optional Accepted from the user s X specification PRIMARYEM String 60 Optional Accepted from the user s AIL specification 2 87 ORACLE SECONDAR String 80 Optional Accepted from the user s YADDRESSL specification INE1 SECONDAR String 80 Optional Accepted from the user s YADDRESSL specification INE2 SECONDAR String 80 Optional Accepted from the user s YADDRESSL specification INE3 SECONDAR String 80 Optional Accepted from the user s YADDRESSL specification INE4 SECONDAR Number 10 Optional Accepted from the user s YZIPCODE specification String 3 Optional Accepted from the user s SECONDAR specification YCOUNTRY SECONDAR_ Number 1 Optional Accepted from the user s YUSSTATE specification SECONDAR String 15 Optional Accepted from the user s YTELEPHON specification E1 SECONDAR String 15 Optional Accepted from the user s YTE
193. sted documents have been received from the unit holder RETAINTRADEA CK Number Optional O or 1 1 to indicate that trade acknowledgements for the unitholder has to be retained RETAINCONTR ACTNOTES Number Optional Oor1 1 implies that contract notes in respect of the unit holder should be retained NOTREPORTKY CREQ Number Optional Oor 1 Value 1 to indicate that any KYC documents yet to be submitted must not be reported in trade acknowledgements UHBICCODE String Optional Unit holder s swift BIC 2 20 ORACLE Code ALTLANGFIRST String 100 Optional Should not First Name specified in NAME exist in the alternate language absence of First Name ALTLANGMIDDL String 40 Optional Should not Middle Name specified in ENAME exist in the alternate language absence of Middle Name ALTLANGFIRST String 70 Optional Should not First authorized signatory AUTHSIGN exist in the specified in alternate absence of language First authorized signatory ALTLANGSECO String 70 Optional Should not Second authorized NDAUTHSIGN exist in the signatory specified in absence of alternate language Second authorized signatory ALTLANGTHIRD String 70 Optional Should not Third authorized AUTHSIGN exist in the signatory specified in absence of alternate language Third authorized signatory ALTLANGCONT String 70 Optional Sh
194. t CHEQUECURRE String 3 Mandatory This field denotes the NCY cheque currency CHEQUEDATE Date 10 Mandatory For check payment modes this is the date of issue of the check Must not be later than the current application date CHEQUENUMBE String 16 Mandatory Indicates the check R number for Payment mode Q and Credit card number for payment mode R This is mandatory if mode of Payment is check Q or credit card R OLDCHEQUENU String 16 Optional This field denotes the MBER previous cheque number DRAWEEBANK String 12 Mandatory Should be a valid Bank Code as defined in the system DRAWEEBRANC String 12 Optional Mandatory Should be a valid Branch HCODE Code as defined in the system DUPLICATE String 1 Optional TRANSACTIONT String 4 Optional Mandatory Should valid type as YPE maintained in the system SPOOLSERIALN Number 10 Optional Unique Serial No O CHECKSTATUS String 1 Mandatory Check Status N New A Active D Duplicate C Cleared Invalid 2 120 ORACLE CHECKPRINTED DATE Date Optional Actual Chq Printed Date FILENAME String Optional Chq Upload File Name PROCESSED String Optional Mandatory Unique Sequence number TIMESTAMP Date Optional Date Time Stamp PRINTERID String Optional Unique Sequence number MAKERID String Optional There should not be any validation on Maker ID field with regards to the us
195. t specified in the import file the application date is considered to be the Maker Date by default CHECKERID Optional If this information is specified in the import file no validation is made with regards to the user profile maintenance in the FCIS system If it is not specified it is defaulted to SYSTEM This information is applicable for the generation of authorized load override records CHECKERDATE Optional If the date is not specified in the import file the application date is considered to be the Checker Date by default This information is applicable for the generation of authorized load override records AUTHTYPE Mandatory Could be either of the following values U Unauthorized A Authorized 2 10 Fund Price File Format For all imports of transaction fund price data the external hand off file containing the information must e Always be named in the format BulkFP e Always contain all information marked as mandatory in the table below e Always contain the information in the exact format and serial order shown in the Field Name column with values according to the validations mentioned in the table below Field Name as expected in the file Data type Field length Mandatory Characteristics rules Values 2 80 ORACLE SEQUENCENUMBER Number 10 Mandatory System generated sequence number
196. te by default TITLE String Optional Value defaulted as maintained in Bulk client defaults in the absence of information in the file This should be one of the valid Title codes as maintained in system parameters FIRSTNAME String 100 Mandatory Accepted from the user s specification for the same in the hand off file contents MIDDLENAME String 40 Optional Accepted from the user s specification for the same in the hand off file contents LASTNAME String 40 Optional Accepted from the user s specification for the same in the hand off file contents 2 3 ORACLE ACCOUNTOPE _ String 1 Optional Value Could be any of the RATIONTYPE defaulted as values in the following maintained list S Single E Either in Bulk client Or Survivor J Joint defaults in the absence of information in the file FIRSTNOMINEE String 60 Accepted from the user s specification for the same in the hand off file contents This information is mandatory for Account Operation type as J Joint SECONDNOMIN String 60 Accepted from the user s EE specification for the same in the hand off file contents THIRDNOMINEE String 60 Optional Accepted from the user s specification for the same in the hand off file contents FATHER_SPOU String 20 Optional Accepted from the user s SENAME specification
197. te the journal was Char 11 System Date System Date created This is a compulsory field Created_By ID to identify the data Char 15 Use your own unique 99999999999 from feeder system number must be the 9999 for audit trail This is a same for all files compulsory field Actual_ Flag Indicates type of Char 1 A Actual A journal B Budget E Encumbrance not used JE_CAT_ NAME Journal Category Char 25 INTERFACE INTERFACE Name JE_SRC_NAME Journal entry Source Char 25 To be determine Product ULA name from where the from values intable OASULA Journal comes This JE SOURCES is a compulsory field HYPHEN to use Product ULA FACSSO OASOTH Cur_Conv_Date Used if currency of Char 11 Empty Empty journal is different from Set of books currency ENCUM_TYP_ID Used if the Char 15 Empty Empty ACTUAL_FLAG F This is not used BUDGET_VERS If ACTUAL_FLAG Char 15 Empty Empty N_ID B CUR_CONV_TYP Currency Conversion Char 30 Empty Empty E Type CUR_CONV_RA_ Currency Conversion Char 15 Empty Empty TE Rate AVERAGE_JRNL Not Used Char 1 Empty Empty ORG_BAL_SEG_ Noy used Char 25 Empty Empty VAL 3 106 ORACLE Segmenti Balancing entity value Char 25 Four chars 0000 Four chars 0000 OMUT SA 1140 OMUT NAM 1156 Segment2 Budget Centre Value Char 25 Eight c
198. the information must e Always be named in the format BulkTxnOverride e Always contain all information marked as mandatory in the table below e Always contain the information in the exact format and serial order shown in the Field Name column with values according to the validations mentioned in the table below Field Name as Data Field Mandatory Values expected in the file type length PROCESSID 50 Mandatory The Process ID along with the system generated sequence number identifies the uploaded record uniquely Each file must have a unique Process ID BULKCLIENTCODE 9 Mandatory The Code of the bulk client IMPORTFILENAME 2000 Mandatory The name of the file being uploaded should be specified Each file must have a unique name AMCID 6 Mandatory The ID of the AMC for which the bulk client has maintained the default details UPLOADMODE 1 Mandatory N for new transactions I for amended transactions TRANSACTIONNUMBE 16 Optional The number of the transaction R for which override is performed ee ORACLE Either the transaction number or reference number must be specified as mandatory information REFERENCENUMBER 16 Optional The reference number of the transaction for which override is performed Either the transaction number or reference number must be specified as mandatory information LOADFROMENTITYTY 1 Mandatory The From entit
199. tion Segment Mandatory Optional Mandatory Multiple records allowed for the same Fund and Rule Effective Date No Field Type Maximum Mandatory Characteristics Description Name Length Optional Validations applicable SEGMEN Alphanumeric 20 Mandatory Default value Standard value of TID 01FDR 01FDR to uniquely identify Fund demographics information 3 5 ORACLE This indicates if data defaulted based on templates or based on bulk client code PROCES Alphanumeric 50 Mandatory Same value as This should identify SID in OOGEN the upload uniquely ProcessID This should also be unique within a file and it allows to identify imported records later FUNDID Alphanumeric 6 Mandatory The Fund ID is a unique Identification for each Fund in the system Enter a unique value for the fund for which a Fund Demographics record is being set up RULEEF Date 8 Mandatory The Rule Specify the date FECTIVE Effective Date from when the Fund DATE should be later Demographics Rule than or same that is currently as the Fund being set up should Start Date and it become effective should also be later than or same as the current application date of the system FUNDST Date 8 Mandatory Specify the date ARTDAT upon which the fund E is to begin operations FUNDNA Alphanumeric 60 Mandatory Enter the name of ME the fund for which the F
200. tion in the file DISTRIBUTI String 1 Mandatory Value Could be any of the values ONMODE defaulted as from the following list P maintained in Payment Mode R Bulk client Reinvestment Mode or B Both defaults in the absence of information in the file PAYMENTS Number 5 2 Optional Should be 100 if distribution PLITPERCE mode is P If the distribution NTAGE mode is R the total count of the Reinvestment details payment Split percentage should be zero CHEQUEPA Number 5 2 Optional Should be 0 if the distribution YMENTSPLI mode is R If the payment T mode is check it should be 100 other wise zero TRANSFERP Number 5 2 Optional If the distribution mode is R it AYMENTSPL should be 0 If the payment IT mode is transfer it should be 100 other wise zero 2 94 ORACLE XFERBANKC String 12 Optional Could be any valid bank code ODE maintained in the system XFERBRAN _ String 12 Optional Could be any valid branch CHCODE code maintained in the system XFERACCO String 1 Optional Could be any valid Account UNTTYPE Type XFERACCO_ Number 16 Optional Could be nay valid Account UNTNUMBE Number R XFERACCO String 3 Optional Could be any valid Account UNTCURRE Currency NCY PAYMENTM String 1 Optional Value Could be either of the ODE defaulted as following values Q Check T maintained in Third Party Bulk client defaults in the absence of information in the file SU
201. tional Values can be O or 1 A 1 EAUTHTX er value indicates that N authorized transactions must be generated SITYPE String 10 Optional SIESCALA String 1 Optional Could be either 0 or 1 A TIONFRE value of 1 indicates that QUENCY authorized transactions must be generated NEXTESC Date 10 Mandatory if ALATIOND Escalation ATE type is provided ESCALATI String 1 Optional The escalation can be of ONTYPE any of the following types A Amount or P Percent 2 61 ORACLE ESCALATI ONVALUE Numb 20 6 Optional The value by which the standing instruction amount must be escalated MAKERID String Optional If this information is specified in the import file no validation is made with regards to the user profile maintenance in the FCIS system If it is not specified the ID of the logged in user at the time of import is taken by default as the Maker ID Maker_DT _ STAMP Date Optional If the date is not specified in the import file the application date is considered to be the Maker Date by default CHECKER ID String Optional If this information is specified in the import file no validation is made with regards to the user profile maintenance in the FCIS system If it is not specified it is defaulted to SYSTEM This information is applicable for the generation of authorized transactions CHECKER _DT_STA MP Date Optional
202. to the validations mentioned in the table below Field Name as Data Length Mandatory Characteris Values expected inthe type tics rules file SEQUENCENU Number 10 Mandatory System generated MBER sequence number of records in the file PROCESSID String 50 Mandatory The Process ID along with the system generated sequence number identifies the uploaded record uniquely Each file must have a unique Process ID This should be same for all records within a file BULKCLIENTCO String 12 Mandatory The Code of the Bulk DE client IMPORTFILENA String 255 Mandatory Name of the file being ME uploaded should be specified Each file must have a unique name oe ORACLE AMCID String Mandatory The ID of the AMC Distributor for which the bulk client has maintained the defaults details UPLOADMODE String Mandatory N for New unit holder uploads and l for Information change CIFNUMBER String Optional UNITHOLDERID String Is blank for new record REFERENCENU MBER String Mandatory Accepted from hand off file contents or system generated reference number according to the option selected in the Bulk Account Client Defaults for unit holder import or both ACCOUNTOPE NINGDATE DATE Optional If this is not found in the hand off file the application date is deemed as the account opening da
203. tring 100 Optional You may enter any additional information regarding the beneficiary if necessary INTERMEDIARY String 35 Optional In this section specify any intermediary that is to be deemed as applicable for the transactions generated for the unit holder INTERMEDIARYADD1 String 35 Optional Enter the address line 1 of the intermediary INTERMEDIARYADD2 String 35 Optional Enter the address line 2 of the intermediary INTERMEDIARYADD3 String 35 Optional Enter the address line 3 of the intermediary INTERMEDIARYBICCODE _ String 24 Optional intermediary Bank Identifier Code INTERMEDIARY ACCTNO String 24 Optional intermediary Account Number INTERMEDIARYCODE String 24 Optional Enter the code assigned to the intermediary INTERMEDIARYINFO String 100 Optional You may enter any additional information regarding the intermediary if necessary FURTHERCREDITNAME String 35 Optional Indicate the alternate credit name if any FURTHERCREDITACCTNO String 35 Optional Enter the alternate account number if any REFERENCE1 String 35 Optional Reference 1 REFERENCE2 String 35 Optional Reference 2 IBAN String 36 Optional Used to capture the IBAN BENEFICIARYIBAN String 36 Optional Used to capture the BENEFICIARYIBAN E ORACLE 2 3 INTERMEDIARYIBAN String 36 Optional Used to capture the INTERMEDIARYIBAN Unit Holder KYC Details Field Name as e
204. ue of EDIARYDE broker and split TAILS percentage If not provided in the handoff file default at the customer account level is picked up PHASEIN Numb 1 Optional 0 1 1 means Phasin er applicable PHASEINT String 1 Optional If PHASEIN is YPE applicable then this field is mandatory PHASEIN Numb 3 Optional If PHASEIN is If PHASEIN is applicable OCCUREN er applicable then then this field is CES this field is mandatory mandatory No of Phasein occurrences REMAININ Numb 3 Optional System would update No GOCCURE er need to input while SI NCES Upload GENERAT String 255 Optional EON NOOFSI Numb 2 Optional er SWIFTFO VARC 6 Optional Used to capture the Swift RMAT HAR2 Format as a part of Payment routing details BANKCHA VARC 12 Optional Used to capture the Bank RGED HAR2 Charged as a part of Payment routing details 2 66 ORACLE BENEFICI VARC 35 Optional Used to capture the ARY HAR2 Beneficiary details as a part of Payment routing details BENEFICI VARC 35 Optional Used to capture the ARYADD1 HAR2 Beneficiary address details as a part of Payment routing details BENEFICI VARC 35 Optional Used to capture the ARYADD2 HAR2 Beneficiary address details as a part of Payment routing details BENEFICI VARC 35 Optional Used to capture the ARYADD3 HAR2 Beneficiary address details as a part of Payment routing details BENEFICI
205. und Demographics profile is being set up in this record FUNDNA Alphanumeric 15 Mandatory Enter the short name MESHOR of the fund for which T the Fund Demographics profile is being set up in this record FUNDCL Alphanumeric 1 Optional Valid values are Enter the fund class ASS O for Open as either Open ended and C Ended and Closed for Closed Ended Funds ended 3 6 ORACLE FUNDTY Number 38 Optional Valid Fund Enter the value of PE types defined in Fund Type The the system Fund Types are set up as a part of the Fund Type Maintenance FUNDFA Alphanumeric 2 Optional Valid Fund Enter the fund family MILY families defined under which the fund in the system must be placed FUNDBA Alphanumeric 3 Optional Valid Currency Specify the currency SECURR code defined in code in which the ENCY the system fund will be denominated The NAV and dividend declarations for the fund will be in this base currency FUNDCO Alphanumeric 3 Optional Valid Domicile Enter the country of UNTRY code defined in domicile of the fund the system asa This information will part of Params be used to determine Maintenance whether a unit holder that subscribes to the fund must be considered a Foreign unit holder or not FISCALS DATE 8 Optional The Fiscal Start Enter the date from TARTYE Date must be when the Fiscal Year AR earlier than the should start for the application date fund and
206. und transaction currency information PROCESSID Alphanumeric 50 Mandatory Same value as in OOGEN Process ID This should identify the upload uniquely This should also be unique within a file and it allows to identify imported records later FUNDID Alphanumeric Mandatory The Fund ID is a unique Identification for each Fund and it indicates the fund for which Fund delivery instruction has to be uploaded RULEEFFECT IVEDATE Date Mandatory The Fund ID and Rule effective date combination should be the same as defined in 01FDR The rule effective date for which Fund delivery instruction information for the fund has to be maintained 3 78 ORACLE REGISTERED Number 1 Mandatory Valid values are Indicate as 1 ACCOUNT O and 1 if the respective delivery mode is applicable for the fund DELIVERYTO Number 1 Mandatory Valid values are CUSTODIAN O and 1 DELIVERYTO Number 1 Mandatory Valid values are CLGAGENT O and 1 PHYSICALCE Number 1 Mandatory Valid values are RTDELIVERY O and 1 DEFAULTDEL Alphanumeric 2 Mandatory Valid values are Should be IVERY RA for based on Registered allowed account CU for delivery Deliver to modes Custodian CL for Deliver to Clearing Agent and PD for Physical delivery CERTIFICATE Alphanumeric 200 Optional This value This is
207. und template the required format must be as shown below 3 95 ORACLE Field Name Type Maximum Length Mandatory Optional Characterist ics Validations applicable Description PROCESSID Alphanumeric 50 Mandatory This should identify the upload uniquely This should also be unique within a file and it allows to identify imported records later BULKCLIENTC ODE Alphanumeric Mandatory Valid authorized enabled Bulk client codes maintained in the system as a part of Entity maintenance IMPORTFILENA ME Alphanumeric 255 Mandatory This is the name of the file being uploaded into the FCIS system AMCID Alphanumeric Mandatory Valid authorized enabled AMC maintained in the system as a part of Entity maintenance The fund rule upload defaulting would be based on both AMCID and the Bulk client code TEMPLATEID Alphanumeric Mandatory Valid authorized template present in the system FUNDID Alphanumeric Mandatory The new fund id for which fund rule has to be set up 3 96 ORACLE RULEEFFECTIV EDATE Date Mandatory The rule effective date on which the fund rule would be effective FUNDTAXID Alphanumeric 25 Optional Fund tax id if any FUNDIDENTIFI CATIONNUMBE R Alphanumeric 25 Optional Fund ISIN number depending upon the installation typ
208. us entity types and entity IDs 3 87 ORACLE Field Name Type Maximum Mandatory Characterist Description Length Optional ics Validations applicable SEGMENTID Alphanumeric 20 Mandatory Default value Standard value 01FEM of 01FEM to uniquely identify Fund entity information PROCESSID Alphanumeric 50 Mandatory Same value This should as in OOGEN identify the ProcessID upload uniquely This should also be unique within a file and it allows to identify imported records later FUNDID Alphanumeric 6 Mandatory Depending The Fund ID isa upon the unique scheme Identification for cross each Fund in reference the system maintained Enter the fund at the Bulk for which a Fund client entity mapping defaults needs to be this field maintained value could either be FundlD Fund Identification number or Fund ticker symbol 3 88 ORACLE ENTITYTYPE Alphanumeric 2 Optional Valid values The entity type are A for for which the Agent Q for fund is mapped Check This helps us to Vendor U understand for Investor whether itis a L for Fund Agent Clearing mapping Fund Agent IC Check Vendor for Individual mapping Fund customer Clearing Agent category and mapping Fund CC for Investor Corporate mapping Fund customer Individual category category mapping or Fund Corporate category mapping ENTITYID Alphanumeric 12 Optional Valid
209. xpected in the file Data type Field length Mandatory Characteri stics rules Values SEQUENCENUMBER Numb er 10 Mandatory System generated sequence number of records in the file PROCESSID String 50 Mandatory The Process ID along with the system generated sequence number identifies the uploaded record uniquely Each file must have a unique Process ID This should be same for all records within a file BULKCLIENTCODE String Mandatory The Code of the Bulk client IMPORTFILENAME String 255 Mandatory Name of the file being uploaded should be specified Each file must have a unique name AMCID String Mandatory The ID of the AMC Distributor for which the bulk client has maintained the defaults details UPLOADMODE String Mandatory N for New unit holder uploads and T for Information change UHKYCSLNO Numb er Mandatory KYC Document Serial Number UNITHOLDERID String Mandatory Unit Holder ID 2 26 ORACLE AUTHTYPE String 1 Mandatory A U A Authorized Record U Unauthorized Record REQUESTED String 1 Optional For 1 0 Standard Doc s this flag should be 1 DOCUMENTDESCRIPT String 255 Optional Description of KYC ION Document FAXRECEIVED Numb 1 Optional 0 1 1 to indicate e
210. y type for the PE load being overridden The entity type should be a valid entity maintained in the system and can be any of the following A Agent B Broker D Distributor M AMC N Branch R Registrar T Trustee U Unit holder F Fund The From and To entity types cannot be the same LOADTOENTITYTYPE 1 Mandatory The To entity type for the load being overridden The From and To entity types are used to identify the load being overridden In case two loads have the same From and To entities for a particular transaction number all records corresponding to that transaction number are rejected Must be a valid entity as listed in previous row OVERRIDELOADAMO 15 6 Optional The overridden load amount UNT Either the overridden load amount or the overridden return value must be specified as mandatory information OVERRIDERETURNVA 15 6 Optional The overridden load return LUE value Either the overridden load amount or the overridden return value must be specified as ets ORACLE mandatory information MAKERID Optional If this information is specified in the import file no validation is made with regards to the user profile maintenance in the FCIS system If it is not specified the ID of the logged in user at the time of import is taken by default as the Maker ID MAKERDATE Optional If the date is no

Upload Format - Oracle Documentation

Contents

Download Pdf Manuals

Related Search

Related Contents