2. Appendix A - Upload File Formats A

2.1 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 Comma
Negative Sign symbol	Hyphen Parenthesis
Time delimiter	Null Colon Semi colon Space
Column Header on first line	True / False

Note

You can maintain only one sheet in the template. For Excel upload, the data should be in text format.

2.2 Unit Holder File Format

Segment Identification number:

Segment Identification Number	Description	Segment Mandatory / Optional?
00UH	This segment is used for providing UnitHolder related Information	Mandatory
01KYC	This segment is used for providing KYC related Information	Mandatory
02BEN	This segment is used for providing Beneficiary related Information	Mandatory
03BNK	This segment is used for providing UnitHolder Bank related Information	Mandatory
04INM	This segment is used for providing UnitHolder Inter­mediary related Information	Mandatory
05DEL	This segment is used for providing UnitHolder Deliv­ery related Information	Optional
06REL	This segment is used for providing UnitHolder Related Parties related Information	Optional
07JNT	This segment is used for providing UnitHolder JointHolder related Information	Optional
08NME	This segment is used for providing Nominee related Information	Optional
09DIR	This segment is used for providing Director related Information	Optional
10ADD	This segment is used for providing Additional Infor­mation related Information	Optional

Note

For all imports of unit holder new account and information change data, the external hand-off file containing the information must:

• Always be named in the format “BulkUH*.*”
• 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.

2.2.1 Unit Holder File Format

Serial Number: 1

Segment Identification Number: 00UH

Description: This segment is used for providing UnitHolder related Information.

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory	Characteristics/rules	Values
SEGMEN­TID	VAR­CHAR2	20	Man­datory		Segment Id. Value of Seg­ment Id is 00UH
SEQUEN­CENUM­BER	Num­ber	10	Man­datory		System generated sequence number of records in the file
PROCES­SID	String	50	Man­datory		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.
BULKCLI­ENTCODE	String	12	Man­datory		The Code of the Bulk client.
IMPORT­FILE­NAME	String	255	Man­datory		Name of the file being uploaded should be speci­fied. Each file must have a unique name.
AMCID	String	12	Man­datory		The ID of the AMC/Distribu­tor for which the bulk client has maintained the defaults details.
UPLOAD­MODE	String	1	Man­datory		“N” for New unit holder uploads and ‘I’ for Informa­tion change.
CIFNUM­BER	String	9	Optional		CIF Number
UNITHOLDERID	String	12			Is blank for new record
REFER­ENCE­NUMBER	String	12	Man­datory		Accepted from hand off file contents; or system gener­ated reference number, according to the option selected in the Bulk Account Client Defaults for “unit holder import” or “both”
ACCOUN­TOPEN­INGDATE	DATE		Optional		If this is not found in the hand off file, the application date is deemed as the account opening date by default.
TITLE	String	15	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	This should be one of the valid Title codes as main­tained in system parameters.
FIRST­NAME	String	100	Man­datory		Accepted from the user’s specification for the same in the hand off file contents
MIDDLE­NAME	String	40	Optional		Accepted from the user’s specification for the same in the hand off file contents
LAST­NAME	String	40	Optional		Accepted from the user’s specification for the same in the hand off file contents
ACCOUN­TOPERA­TIONTYPE	String	1	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Could be any of the values in the following list: S- Single, E- Either Or Survivor, J-Joint
FIRST­NOMINEE	String	60			Accepted from the user’s specification for the same in the hand off file contents – This information is manda­tory for Account Operation type as “J” – Joint
SECOND­NOMINEE	String	60			Accepted from the user’s specification for the same in the hand off file contents
THIRD­NOMINEE	String	60	Optional		Accepted from the user’s specification for the same in the hand off file contents
FATHER_SPOUSENAME	String	20	Optional		Accepted from the user’s specification for the same in the hand off file contents
INVES­TORTYPE	String	1	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Could be any of the values from the following list: I – Individual Or C – Corporate – Mandatory
CONTAC­TAD­DRESSLINE1	String	80	Optional		Accepted from the user’s specification for the same in the hand off file contents
CONTAC­TAD­DRESSLINE2	String	80	Optional		Accepted from the user’s specification for the same in the hand off file contents
PRIMARY­CITY	String	80	Optional		Accepted from the user’s specification for the same in the hand off file contents
PRIMAR­YSTATE	String	80	Optional		Accepted from the user’s specification for the same in the hand off file contents
PRIMARY­USSTATE	Num­ber	1	Optional		Should be left blank
ZIPCODE	String	10	Optional		Hand off file contents
SECOND­ARYAD­DRESSLINE1	String	80	Optional		Address Line 1
SECOND­ARYAD­DRESSLINE2	String	80	Optional		Address Line 2
SECOND­ARYCITY	String	80	Optional		Accepted from the user’s specification for the same in the hand off file contents
SECOND­ARYS­TATE	String	80	Optional		Accepted from the user’s specification for the same in the hand off file contents
SECOND­ARY­USSTATE	Num­ber	1	Optional
SECOND­ARYZIP­CODE	String	10	Optional		Accepted from the user’s specification for the same in the hand off file contents
SWIFTAD­DRESS­LINE1	String	80	Optional		Accepted from the user’s specification for the same in the hand off file contents
SWIFTAD­DRESS­LINE2	String	80	Optional		Accepted from the user’s specification for the same in the hand off file contents
SWIFTAD­DRESS­LINE3	String	80	Optional		Accepted from the user’s specification for the same in the hand off file contents
SWIFTAD­DRESS­LINE4	String	80	Optional		Address Line 4
SWIFT­COUN­TRYCODE	String	3	Optional		Country Code
BICCODE	String	12	Optional		BIC Code
HOME­TELE­PHONENUMBER	String	15	Optional		Accepted from the user’s specification for the same in the hand off file contents
OFFICET­ELE­PHONENUMBER	String	15	Optional		Accepted from the user’s specification for the same in the hand off file contents
FAXNUM­BER	String	15	Optional		Accepted from the user’s specification for the same in the hand off file contents
TAXDE­DUCTE­DATSOURCE	Num­ber	1	Optional		Could be either true (1) or false (0)
TAXID	String	15	Optional		Accepted from the user’s specification for the same in the hand off file contents
TAXCIR­CLE	String	15	Optional		Accepted from the user’s specification for the same in the hand off file contents
IDENTIFI­CATION­TYPE	String	3	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Could be any of the values maintained in Params main­tenance for Identification Type
IDENTIFI­CATION­NUMBER	String	15	Optional		Accepted from the user’s specification for the same in the hand off file contents
IDENTIFI­CATIONIS­SUEDATE	DATE		Optional		Accepted from the user’s specification for the same in the hand off file contents
IDENTIFI­CATION­EXPIRYDATE	DATE		Optional		Accepted from the user’s specification for the same in the hand off file contents
RESI­DENTSTA­TUS	String	1	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Could be any of the values from the following list: "R";"Resident";;"F";"Foreign"
UHCATE­GORY	String	2	Man­datory		Could be any of the valid val­ues from the Category list maintained
ACCOUNTSTMT­FREQ	String	1	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Could be any of the values in the following list from Fre­quency Table : D – Daily, W - Weekly, F - Fortnightly, M – Monthly, Q - Quarterly, H - Half Yearly, Y - Yearly
YTDST­MTREQD	Num­ber	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'
DATEOF­BIRTH	DATE		Optional		Accepted from the user’s specification for the same in the hand off file contents
GUARDI­ANNAME	String	70	Optional		Accepted from the user’s specification for the same in the hand off file contents
RELA­TIONSHIP	String	70	Optional		Accepted from the user’s specification for the same in the hand off file contents
BENEFI­CIARY	String	70	Optional		Accepted from the user’s specification for the same in the hand off file contents
SEX	String	1	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Could be either of the follow­ing values - “M”(Male) or ”F” (Female)
MARITAL­STATUS	String	1	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Could be either of the follow­ing values - “S” (Single) ,”M” (Married). The default status is taken to be Single.
OCCUPA­TION	String	3	Man­datory	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Could be any of the values maintained in Occupation Maintenance
NATION­ALITY	String	3	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Accepted from the user’s specification for the same in the hand off file contents
COUN­TRYOF­DOMICILE	String	3	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Could be any of the values maintained in Country Main­tenance
CORPO­RATION­TYPE	String	3	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Could be any of the valid val­ues maintained in Corpora­tion Maintenance. This information can be specified only for corporate investors (Investor Type – C)
FIRSTAU­THOR­IZEDSIGNATORY	String	70	Optional		This information can be specified only for corporate investors (Investor Type – C)
SEC­ONDAU­THORIZEDSIGNA­TORY	String	70	Optional		This information can be specified only for corporate investors (Investor Type – C)
THIRDAU­THOR­IZEDSIGNATORY	String	70	Optional		This information can be specified only for corporate investors (Investor Type – C)
CON­TACT­NAME	String	70	Optional		Accepted from the user’s specification for the same in the hand off file contents
MIN­NOOF­CORPORATESIG­NATORY	Num­ber		Optional		Accepted from the user’s specification for the same in the hand off file contents
SCHEME­CROSS­REFNO		60	Optional		Scheme/Cross Reference Number
UHBASE­CUR­RENCY	String	3	Optional		Could be any of the valid currencies maintained in Currency Maintenance. If this information is not given in the import file, then the default unit holder base cur­rency specified in the Bulk Client Defaults Maintenance for the bulk client will be used.
LAN­GUAGE	String	12	Optional		Could be any of the lan­guages defined in the sys­tem. If this information is not given in the import file, then the Default Language Value mentioned in the Bulk Client Defaults Maintenance for the bulk client will be used.
REDEMP­TIONMOP	String	1	Optional		Could be either of the follow­ing Values: “Q” - Cheque, “T” – Transfer. If this informa­tion is not given in the import file, then the Default Redemption Mode of Pay­ment specified in the Bulk Client Defaults Maintenance for the bulk client will be used.
ACCOUNTSTMT­CUR­RENCY	String	3	Optional		Could be any of the valid 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 Mainte­nance 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
FIRST­JOIN­TUHNAME	String	60	Optional		The primary unit holder name in case of joint accounts.
SECOND­JOIN­TUHNAME	String	60	Optional		The secondary unit holder name in case of joint accounts.
THIRD­JOIN­TUHNAME	String	60	Optional		The third unit holder name in case of joint accounts.
ALTAD­DRESS­FROMDATE	DATE		Optional		Alternate Address From date
ALTAD­DRESS­TODATE	DATE		Optional		Alternate Address To date
TELE­PHO­NERED	Num­ber	1	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Could be either 0 (false) or 1 (true) to indicate whether redemption transactions can be accepted through tele­phone for the unit holder or not. If null, it will be picked up from the bulk client defaults table.
TELE­PHONE­SWI	Num­ber	1	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Could be either 0 (false) or 1 (true) to indicate whether redemption transactions can be accepted through tele­phone for the unit holder or not. If null, it will be picked up from the bulk client defaults table.
WRITE­CHECK­FORMMF	Num­ber	1	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Could be either 0 (False) or 1 (True). If not supplied, will be taken from the bulk client defaults table.
FEDWIRE­ACHPAY­MENT	Num­ber	1	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Could be either 0 (False) or 1 (True). If not supplied, will be taken from the bulk client defaults table.
IRSNOTI­FICATION	String	10	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Could be either 0 (False) or 1 (True). If not supplied, will be taken from the bulk client defaults table.
ROAIN­VESTOR	Num­ber	1	Optional		Could be either 0 (False) or 1 (True). This should be read only when 'ROA Option at Investor’ in AMC policies table is true.
ALLOW­ROAATCI­FLEVEL	Num­ber	1	Optional		Could be either 0 (False) 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
UHAC­COUNT­TYPE	String	2	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Should be a valid unit holder account type as available in the Params maintenance
RPOC­ODE	String	10	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Should be a valid code as maintained in the Params table for the Param code RPOESCHCODE. If not sup­plied, will be picked up from the bulk client defaults table.
REGIS­TRATION­TYPE	String	2	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Should be a valid code as maintained in the Params table for the Param code UHREGISTRATIONTYPE. If not supplied, will be taken from the bulk client defaults table.
REGIS­TRATION­NAME	String	50	Optional		If registration type = 'SN' (Street name), only then this value is to be read.
ACCOUN­TOPEN­INGPURPOSE	String	30	Optional		Account Opening Purpose
REMARKS	String	255	Optional		Remarks
PRE­FERRED­MAILMODE	String	2	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Should be a valid code as read from the Params table for the Param code PRE­FERREDMAILMODE. If not supplied, will be taken from the bulk client defaults table.
NOTEPA­DAVAILA­BLE	Num­ber	1	Optional		Could be either 0 (False) or 1 (True). If not supplied, default will be 1 (True)
FEECATE­GORY	String	3	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Should be a valid category for the type of investor (indi­vidual or corporate). If not supplied, will be taken from the bulk client defaults table based on the investor cate­gory
FEESUB­CATE­GORY	String	6	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Should be a valid sub cate­gory for the category. If not supplied will be taken from the bulk client defaults table based on the investor cate­gory
AGENT­CODE	Num­ber	12	Man­datory		Agent Code
BRANCH­CODE	Num­ber	12	Man­datory		Branch
MAKERID	String	15	Optional		There should not be any val­idation 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
MAK­ER_DT_STAMP	DATE				If the date is not specified in the import file, the applica­tion date is considered to be the Maker Date by default.
CHECK­ERID	String	15	Optional		This field will be ignored. Always maker id in the tem­plate will be considered to update the checker id in the system.
CHECK­ER_DT_STAMP	DATE		Optional		If the date is not specified in the import file, the applica­tion date is considered to be the Checker Date by default. This information is applica­ble for authorized unit holder generation.
AUTH_STAT	VAR­CHAR2	1	Optional		Auth Status
AUTHTYPE	String	1	Man­datory		Could be either of the follow­ing values: "U" - Unauthor­ized, "A" - Authorized
STOPAC­COUN­TREASON	String	255	Optional		Must be left blank
RELEASE­DATE	DATE		Optional		Must be left blank
ALLSIG­NATO­RIESREQDTOSIGN	Num­ber	1	Optional		Must be left blank
TAXEX­EMPTED	Num­ber	1	Optional		Either 0 or 1 to indicate if tax is exempted for this Unit holder
INDEXA­TIONON­CGT	String	1	Optional		Must be left blank
CERTDE­LIVERY­PREF	String	1	Optional		Could be any of the values from the following list to indi­cate the preferred certificate delivery option: 'A','C','F','P','R'
TEM­PLATEID	String	6		Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Template ID
EFFEC­TIVEDATE	DATE		Optional		Effective Date
CELL­PHONE­NUMBER	String	16	Optional		Cell Phone Number
PRIMARY­COUN­TRYCODE	String	3	Optional		Primary Country Code
ALTCELL­PHONE­NUMBER	String	16	Optional		Alternate Cell phone Num­ber
ALTH­OME­PHONENUMBER	String	15	Optional		Alternate Home phone Num­ber
ALTOFFI­CEPHONENUMBER	String	15	Optional		Alternate Office phone Num­ber
ALTEMAI­LID	String	60	Optional		Alternate Email ID
SECOND­ARY­COUNTRYCODE	String	3	Optional		Secondary Country Code
PLA­CEOFIS­SUE	String	3	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Place of Issue
ALTCON­TACT­NAME	String	70	Optional		Alternate Contact Name
ALTFAX­NUMBER	String	15	Optional		Alternate Fax Number
PRE­FERRED­FUNDFORREDEMP­TION	String	6	Optional	Value defaulted as maintained in Bulk client defaults in the absence of infor­mation in the file	Should be a valid fund Id which would be used for redeeming the trailer com­mission to pay the intermedi­ary
GUARDI­ANPAN­GIRNO	String	15	Optional		If the unit holder is a minor then the PAN (tax id) details of the Guardian
GUARDI­ANFORM6061	Num­ber	1	Optional		Must be left blank
PRIMA­RYUH­FORM6061	Num­ber	1	Optional		Must be left blank
UNITHOL­DERNRI	Num­ber	1	Optional		Indicate if the Unit holder is a Non resident
EUSDOP­TION	String	1	Optional	Applicable only for EUSD Coun­tries Value defaulted from defaults maintenance in the absence of information in the file	W – Withholding Tax E – Exchange of Information T- Tax Certificate
TAXCER­TIFICATE­EXPDATE	Date		Optional	If the EUSD Option is ‘T’ then tax certificate expiry date is mandatory	Tax certificate expiry date
PLA­CEOF­BIRTH	String	80	Optional	If the EUSD Option is ‘T’ then tax certificate expiry date is mandatory	Unit Holder’s Place of birth
COUN­TRYOF­BIRTH	String	3	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
FATFOR­NONFATF	String	1	Optional		F – FATF Country N- Non FATF Country
CHASING­DATE	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.
ADDN­COM­MENTS	String	255	Optional		Any additional narrative, or descriptive text, if any, con­cerning the document and the chasing date
ALLKY­CRE­CIEVED	Num­ber	1	Optional		Can have a value of 0 or 1. 1 - All the requested docu­ments have been received from the unit holder.
RETAIN­TRADEACK	Num­ber	1	Optional		0 or 1 (1 to indicate that trade acknowledgements for the unitholder has to be retained.
RETAIN­CON­TRACTNOTES	Num­ber	1	Optional		0 or 1 1 implies that contract notes in respect of the unit holder should be retained.
NOTRE­PORTKY­CREQ	Num­ber	1	Optional		0 or 1 ( Value 1 to indicate that any KYC documents yet to be submitted must not be reported in trade acknowl­edgements
UHBIC­CODE	String	6	Optional		Unit holder’s swift BIC Code
ALTLANG­FIRST­NAME	String	100	Optional	Should not exist in the absence of First Name	First Name specified in alter­nate language.
ALTLANG­MIDDLE­NAME	String	40	Optional	Should not exist in the absence of Middle Name	Middle Name specified in alternate language
ALT­LANGLASTNAME	VAR­CHAR2	40	Optional		Alternate Language Last­Name
ALTLANG­FIR­STAUTHSIGN	String	70	Optional	Should not exist in the absence of First author­ized signatory	First authorized signatory specified in alternate lan­guage
ALT­LANGSECONDAUTHSIGN	String	70	Optional	Should not exist in the absence of Second authorized sig­natory	Second authorized signa­tory specified in alternate language
ALT­LANGTH­IRDAUTHSIGN	String	70	Optional	Should not exist in the absence of Third author­ized signatory	Third authorized signatory specified in alternate lan­guage
ALTLANG­CON­TACTPERSON	String	70	Optional	Should not exist in the absence of Contact per­son	Contact person specified in alternate language
ALTLANG­CORAD­DRESSLINE1	String	80	Optional	Should not exist in the absence of Correspond­ence address line 1	Correspondence address line 1 specified in alternate language
ALTLANG­CORAD­DRESSLINE2	String	80	Optional	Should not exist in the absence of Correspond­ence address line 2	Correspondence address line 2 specified in alternate language
ALTLANG­CORAD­DRESSLINE3	String	80	Optional	Should not exist in the absence of Correspond­ence address line 3	Correspondence address line 3 specified in alternate language
ALTLANG­CORAD­DRESSLINE4	String	80	Optional	Should not exist in the absence of Correspond­ence address line 4	Correspondence address line 4 specified in alternate language
ALTLAN­GALTAD­DRESSLINE1	String	80	Optional	Should not exist in the absence of address line1	address line 1 specified in alternate language
ALTLAN­GALTAD­DRESSLINE2	String	80	Optional	Should not exist in the absence of address line2	address line 2 specified in alternate language
ALTLAN­GALTAD­DRESSLINE3	String	80	Optional	Should not exist in the absence of address line 3	address line 3 specified in alternate language
ALTLAN­GALTAD­DRESSLINE4	String	80	Optional	Should not exist in the absence of address line 4	address line 4 specified in alternate language
DATEOF­CONTRI­BUTION	Date		Optional		Date Member became Con­tributory
TRANS­FERDATE	Date		Optional		Date Member details were transferred
RETIRE­MENTAGE	Num­ber	5,2	Optional		Employee Retirement Age
RETIRE­MENT­DATE	Date		Optional		Employee Retirement Date
DATEOF­DEATH	Date		Optional		Date of Death
DEATH­CAUSE	String		Optional		Cause of Death
DIS­PATCH­DATE	Date		Optional		Dispatch Date
RETURNEDDATE	Date		Optional		Returned Date
PRIMA­RYUHM­FIN	VAR­CHAR2	15	Optional	Applicable only if unitholder is major	Primary MFIN of the Primary Unitholder
GUARDI­ANMFIN	VAR­CHAR2	15	Optional	Applicable only if unitholder is minor	Mutual fund identification number of the Guardian
RECOV­ERCGT	NUM­BER	1	Optional		For Calculating Capital Gain Tax
CAM­PAIGN­CODE	String	6	Optional		Used to capture the CAM­PAIGNCODE
PROCES­SID1	VAR­CHAR2	60	Optional		Process ID
INITIALS	VAR­CHAR2	30	Optional		Initials
KYCPUR­CHASE­LIMIT	NUM­BER	30	Optional		KYC Purchase Limit
KYCAN­NUAL­DEBITORDERLIMIT	NUM­BER	30	Optional		KYC Annual Debit Order Limit
CAM­PAIGN­CODE	VAR­CHAR2	6	Optional		Campaign Code
REDEMP­TIONPAY­OUT	VAR­CHAR2	1	Optional		Redemption Payout
DIVI­DEND­PAYOUT	VAR­CHAR2	1	Optional		Dividend Payout
PRIMA­RYIN­DITELCODE1	VAR­CHAR2	10	Optional		Int. Dialing Code 1
PRIMA­RYIN­DITELCODE2	VAR­CHAR2	10	Optional		Int. Dialing Code 2
PRIMA­RYINDIP­HONECODE	VAR­CHAR2	10	Optional		Primary Phone Code
PRIMA­RYINDI­FAXCODE	VAR­CHAR2	10	Optional		Primary Fax code
SECOND­ARYIN­DITELCODE1	VAR­CHAR2	10	Optional		Int. Dialing Code 1
SECOND­ARYIN­DITELCODE2	VAR­CHAR2	10	Optional		Int. Dialing Code 2
SECOND­ARYINDI­FAXCODE	VAR­CHAR2	10	Optional		Secondary Phone Code
DUALNA­TIONAL­ITY	VAR­CHAR2	3	Optional		Dual Nationality
SUBSTAN­TIALSTAY­INUS	NUM­BER	1	Optional		Substantial Stay in US
TAXCER­TIFICA­TEEFFEDATE	DATE	10	Optional		Tax Effective Certificate Date
COUN­TRYOFIN­CORPORATION	VAR­CHAR2	3	Optional		Country Of Incorporation
SECON­DIDENTI­TYTYPE	VAR­CHAR2	12	Optional		Identification Type
SECON­DIDENTIT­YNUMBER	VAR­CHAR2	15	Optional		Identification Number
SECON­DISSUE­DATE	DATE	10	Optional		Second Issue Date
SECON­DEXPIRY­DATE	DATE	10	Optional		Second Expiry Date
SECOND­PLA­CEOFISSUE	DATE	10	Optional		Second Place Issue
DUEDILI­GENCELEVEL	VAR­CHAR2	2	Optional		Due Diligence Level
REVIEWEDBY	VAR­CHAR2	255	Optional		Reviewed By
LASTREV­IEWED­DATE	DATE	10	Optional		Last Reviewed date
CHAS­ERID	VAR­CHAR2	255	Optional		Chaser ID
CHASING­MODE	VAR­CHAR2	2	Optional		Chasing Mode
NAMES­CHECK­OPTION	VAR­CHAR2	2	Optional		Names Check Option
NAMES­CHECK­REMARKS	VAR­CHAR2	255	Optional		Names Check Remarks

2.2.2 Unit Holder KYC Details

Serial Number: 2

Segment Identification Number: 01KYC

Description: This segment is used for providing KYC related Information

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id. Value of Segment Id is 01KYC
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Sequence Number
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
BULKCLIENT­CODE	VAR­CHAR2	12	Mandatory		Bulk Client Code
IMPORTFILE­NAME	VAR­CHAR2	255	Mandatory		Import File Name
AMCID	VAR­CHAR2	12	Mandatory		AMC ID
UPLOAD­MODE	VAR­CHAR2	1	Mandatory		Upload Mode
UHKYCSLNO	NUMBER	10	Mandatory		Represents a serial number.
UNITHOLDE­RID	VAR­CHAR2	12	Optional		Unitholder ID
AUTH_STAT	VAR­CHAR2	1	Optional		Authorization Status
REQUESTED	VAR­CHAR2	1	Optional	For Stand­ard Doc’s this flag should be ‘1’	Flag which speci­fies whether the document is requested or not.
DOCUMENT­DESCRIP­TION	VAR­CHAR2	255	Optional		Represents the description of docu­ment produced for the KYC form.
FAXRE­CEIVED	VAR­CHAR2	1	Optional		Represents the Fax received is a check box field Y - Yes ,N-No
ORIGINALRE­CEIVED	VAR­CHAR2	1	Optional		Represents the Original received is a check box field Y - Yes ,Nno
RECEIVED­DATE	DATE	7	Optional		Represents the Received date
USERCOM­MENT	VAR­CHAR2	255	Optional		Represents the User comment
WORKFLOW­REFNO	VAR­CHAR2	20	Optional		Represents the Work flow refer­ence no
DOCUMENT­TYPE	VAR­CHAR2	1	Optional		Represents the Document type

2.2.3 Unit Holder Beneficiary Details

Serial Number: 3

Segment Identification Number: 02BEN

Description: This segment is used for providing Beneficiary related Information.

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Manda­tory		Segment Id. Value of Segment Id is 02BEN
SEQUENCE­NUMBER	NUMBER	10	Manda­tory		Sequence Number
PROCESSID	VAR­CHAR2	50	Manda­tory		Process ID
BENEFI­CIARYID	VAR­CHAR2	12	Manda­tory		Represents the unique identifica­tion code for the beneficary of unitholder.
BENEFICIARY­TYPE	VAR­CHAR2	2	Manda­tory		Indicates the type of beneficary.
BENEFI­CIARYNAME	VAR­CHAR2	105	Manda­tory		Indicates the descriptive name for the beneficiary.
BENEFICIARY­DOB	DATE	7	Optional		Represents the Date of Birth for the beneficiary.
BENEFI­CIARYRELA­TION	VAR­CHAR2	70	Optional		Represents the relation of benefi­cary to the men­tioned unitholder.
BENEFI­CIARYUIN	VAR­CHAR2	15	Optional		US Indicia Availa­ble
BENEFI­CIARYGROUP	VAR­CHAR2	1	Optional		Represents the group for the bene­ficiary.
BENEFICIARY­GENDER	VAR­CHAR2	1	Optional		Indicates the gen­der of beneficiary.
BENEFICIARY­IDTYPE	VAR­CHAR2	3	Optional		Indicates the iden­tification type of beneficiary.
BENEFICIARY­IDNUMBER	VAR­CHAR2	50	Optional		Indicates the unique identifica­tion number for the beneficiary
BENEFICIAR­YAWARD	NUMBER	5	Optional		Indicates the award percentage applicable for the beneficiary
BENEFICIA­RYBANKCODE	VAR­CHAR2	12	Manda­tory		Represents the bank identification code for the bene­ficiary.
BENEFICIARY­BRANCHCODE	VAR­CHAR2	12	Manda­tory		Represents the branch identificai­ton code for the beneficiary.
BENEFICIAR­YACCTYPE	VAR­CHAR2	1	Optional		Represents the beneficiary's account type.
BENEFICIAR­YACCNAME	VAR­CHAR2	105	Optional		Represents the beneficiary's account name.
BENEFICIAR­YACCCCY	VAR­CHAR2	3	Optional		Represents the account currency of the benefi­ciary's bank account.
ACCOUNT­NUMBER	VAR­CHAR2	16	Manda­tory		Indicates the account number of the beneficary
COUNTRYOF­DOMICILE	VAR­CHAR2	3	Optional		Country Of Domi­cile
IBAN	VAR­CHAR2	40	Optional		Indicates the Inter­national Bank Account Number.
FATCASTATUS	VAR­CHAR2	25	Optional		FATCA Status
ADDRESS­LINE1	VAR­CHAR2	80	Manda­tory		Represents the first line of benefi­cary's address.
ADDRESS­LINE2	VAR­CHAR2	80	Optional		Represents the second line of beneficary's address.
ADDRESS­LINE3	VAR­CHAR2	80	Optional		Represents the third line of benefi­cary's address.
ADDRESS­LINE4	VAR­CHAR2	80	Optional		Represents the fourth line of bene­ficary's address.
ZIPCODE	VAR­CHAR2	10	Manda­tory		Indicates the loca­tional ZIP code for the beneficary's address
COUNTRY	VAR­CHAR2	3	Manda­tory		Indicates the coun­try of beneficiary
TELEPHONE1	VAR­CHAR2	15	Optional		Telephone Number 1
EMAIL	VAR­CHAR2	60	Optional		Email ID
CONTACTPER­SON	VAR­CHAR2	105	Optional		Indicates the name of beneficiary's contact person.
EXISTINGU­HORCIF	VAR­CHAR2	1	Manda­tory		Indicates whether its existing UH or CIF

2.2.4 Unit Holder Bank Details

Serial Number: 4

Segment Identification Number: 03BNK

Description: This segment is used for providing UnitHolder Bank related Information

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Manda­tory		Segment Id. Value of Segment Id is 03BNK
SEQUENCE­NUMBER	NUM­BER	10	Manda­tory		Process ID
PROCESSID	VAR­CHAR2	50	Manda­tory		Sequence Number
BANKCODE	VAR­CHAR2	12	Manda­tory		Represents the Entity bank code.
BRANCHCODE	VAR­CHAR2	12	Manda­tory		Represents the Entity branch code.
ACCOUNTTYPE	VAR­CHAR2	1	Manda­tory		Represents Type of the Account.
ACCOUNTNUM­BER	VAR­CHAR2	16	Manda­tory		Represents Entity account number.
ACCOUNT­NAME	VAR­CHAR2	100	Manda­tory		Represents Entity account name.
ACCOUNTCUR­RENCY	VAR­CHAR2	3	Manda­tory		Represents Entity account currency.
DEFAULTDE­TAILS	NUM­BER	1	Manda­tory		Indicatest the default details
DIRECTDEB­ITAPPLICABLE	NUM­BER	1	Optional		Indicates whether direct debit is applica­ble for the entity. If Yes (1) else (0).
ACCOUNTCAT­EGORY	VAR­CHAR2	1	Optional		Indicates the account category for the unitholder.
INITIALS	VAR­CHAR2	10	Optional		Indicates the initials for the unitholder entity.
LASTNAME	VAR­CHAR2	40	Optional		Indicates the last name for the unitholder entity.
IDENTIFICA­TIONTYPE	VAR­CHAR2	3	Optional		Indicates the type of identification used for the unitholder.
IDENTIFICA­TIONNUMBER	VAR­CHAR2	50	Optional		Indicates the identifi­cation number used for the unitholder.
STATUS	VAR­CHAR2	1	Optional		Indicates the Transac­tion status
IBAN	VAR­CHAR2	40	Optional		Indicates the Interna­tional Bank Account Number.
UNITHOLDERID	VAR­CHAR2	12	Optional		Unitholder ID
REFERENCE­NUMBER	VAR­CHAR2	12	Optional		Indicates a unique ref­erence Number for a Transaction. It can be entered by the user, otherwise it is system generated.
FUNDID	VAR­CHAR2	6	Manda­tory		Represents a unique Identification for each Fund in the system. It consist of maximum of 6 alphanumeric char­acter.Its Foreign key is FUNDID column Of FUNDDEMOGRAPH­ICSTBL Table.
TRANSACTION­TYPE	VAR­CHAR2	3	Manda­tory		Indicates the Transac­tion Type for which Transaction Rules will be specified.
UHBICCODE	VAR­CHAR2	24	Optional		UnitHolder BIC Code
SWIFTFORMAT	VAR­CHAR2	6	Optional		Specifies Swift Format used for the entity
BANKCHARGED	VAR­CHAR2	12	Optional		Indicates bank charged
BENEFICIARY	VAR­CHAR2	35	Optional		Specifies Beneficiary name of the entity.
BENEFICIARY­ADD1	VAR­CHAR2	35	Optional		Specifies Entity's Ben­eficiary address line1.
BENEFICIARY­ADD2	VAR­CHAR2	35	Optional		Specifies Entity's Ben­eficiary address line2.
BENEFICIARY­ADD3	VAR­CHAR2	35	Optional		Specifies Entity's Ben­eficiary address line3.
BENEFICIARY­BICCODE	VAR­CHAR2	24	Optional		Specifies BIC Code of the Beneficiary.
BENEFICIAR­YACCTNO	VAR­CHAR2	24	Optional		Specifies Benefi­ciary's Account Num­ber.
BENEFICIARY­CODE	VAR­CHAR2	24	Optional		Specifies Unique code of the beneficiary.
BENEFICIARY­INFO	VAR­CHAR2	100	Optional		Specifies Additional information about the beneficiary.
INTERMEDIARY	VAR­CHAR2	35	Optional		Specifies Intermediary name of the entity.
INTERMEDIAR­YADD1	VAR­CHAR2	35	Optional		Specifies Entity's Intermediary address line1.
INTERMEDIAR­YADD2	VAR­CHAR2	35	Optional		Specifies Entity's Intermediary address line2.
INTERMEDIAR­YADD3	VAR­CHAR2	35	Optional		Specifies Entity's Intermediary address line3.
INTERMEDIA­RYBICCODE	VAR­CHAR2	24	Optional		Specifies BIC Code of the Intermediary.
INTERMEDIAR­YACCTNO	VAR­CHAR2	24	Optional		Specifies Intermedi­ary's Account number
INTERMEDI­ARYCODE	VAR­CHAR2	24	Optional		Specifies Unique code of the intermediary.
INTERMEDI­ARYINFO	VAR­CHAR2	100	Optional		Specifies Additional information about the intermediary.
FURTHER­CREDITNAME	VAR­CHAR2	35	Optional		Specifies further credit name
FURTHER­CRED­ITACCTNO	VAR­CHAR2	35	Optional		Specifies Account number to which fur­ther credits must be carried out.
REFERENCE1	VAR­CHAR2	35	Optional		Specifies Reference 1 for the Entity.
REFERENCE2	VAR­CHAR2	35	Optional		Specifies Reference 2 for the Entity.
RELATIONSHIP	VAR­CHAR2	40	Optional		Indicates the relation­ship between the ben­eficiary and the customer.
BENEFICIARY­IBAN	VAR­CHAR2	40	Optional		Specifies Benefi­ciary's International Bank Account Num­ber.
INTERMEDI­ARYIBAN	VAR­CHAR2	40	Optional		Specifies Intermedi­ary's International Bank Account Num­ber.

2.2.5 Unit Holder Intermediary Details

Serial Number: 5

Segment Identification Number: 04INM

Description: This segment is used for providing UnitHolder Intermediary related Information

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Manda­tory		Segment Id. Value of Segment Id is 04INM
SEQUENCENUM­BER	NUM­BER	10	Manda­tory		Process ID
PROCESSID	VAR­CHAR2	50	Manda­tory		Sequence Number
ENTITYTYPE	VAR­CHAR2	1	Manda­tory		Indicates the type of entity who acts as an intermediary for the unitholder. Along with UNITHOLDERID, forms the primary key of the table.
ENTITYID	VAR­CHAR2	12	Manda­tory		Represents the unique identification code for the entity who acts as the inter­mediary for the unitholder. Along with UNITHOLDERID, forms the primary key of the table.
SPLITPERCENT	NUM­BER	5	Manda­tory		Indicates the com­mission percentage entitled for the respective unitholder's interme­diary.
DEFAULTINTER­MEDIARY	NUM­BER	1	Manda­tory		Default intermediary

2.2.6 Unit Holder Delivery Details

Serial Number: 6

Segment Identification Number: 05DEL

Description: This segment is used for providing UnitHolder Delivery related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Manda­tory		Segment Id. Value of Segment Id is 05DEL
PROCESSID	VAR­CHAR2	50	Manda­tory		Sequence Number
SEQUENCENUM­BER	NUM­BER	10	Manda­tory		Process ID
ENTITYID	VAR­CHAR2	12	Manda­tory		Represents the Entityid
ACCOUNTTYPE	VAR­CHAR2	1	Manda­tory		Represents the Accounttype
ACCOUNTNUMBER	VAR­CHAR2	16	Manda­tory		Represents the Accountnumber
ACCOUNTNAME	VAR­CHAR2	105	Manda­tory		Represents the Accountname
DEFAULTDETAILS	NUM­BER	1	Manda­tory		Represents the Defaultdetails

2.2.7 Unit Holder Related Parties Details

Serial Number: 7

Segment Identification Number: 06REL

Description: This segment is used for providing UnitHolder Related Parties related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Manda­tory		Segment Id. Value of Segment Id is 06REL
PROCESSID	VAR­CHAR2	50	Manda­tory		Sequence Number
SEQUENCENUM­BER	NUM­BER	10	Manda­tory		Process ID
ENTITYID	VAR­CHAR2	12	Manda­tory		Indicates the unique identification code for the related party entity associated with the unitholder.
ENTITYTYPE	VAR­CHAR2	2	Manda­tory		Indicates the entity type of the unitholder's related party.
RELATIONSHIP	VAR­CHAR2	10	Optional		Indicates the relation­ship between the related party entity and the unitholder.
REPORTINGLEVEL	VAR­CHAR2	1	Optional		Indicates the report­ing level of the related party entity to the unitholder.
PREFMAILMODE	VAR­CHAR2	1	Optional		Indicates the preferred mail mode for the related party entity.
REMARKS	VAR­CHAR2	255	Optional		Indicates the descrip­tive remarks column for the record.

2.2.8 Unit Holder Joint Holder Details

Serial Number: 8

Segment Identification Number: 07JNT

Description: This segment is used for providing UnitHolder JointHolder related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Manda­tory		Segment Id. Value of Segment Id is 07JNT
SEQUENCE­NUMBER	NUM­BER	10	Manda­tory		Process ID
PROCESSID	VAR­CHAR2	50	Manda­tory		Sequence Number
BENEFICIARYID	VAR­CHAR2	12	Optional		Indicates the joint holder Id.
BENEFI­CIARYNAME	VAR­CHAR2	100	Optional		Indicates the descriptive name for the joint holder.
BENEFICIARY­TYPE	VAR­CHAR2	2	Manda­tory		Indicates the type of joint holder.
BENEFICIARY­DOB	DATE	10	Manda­tory		Represents the Date of Birth for the joint holder.
BENEFICIARY­GENDER	VAR­CHAR2	1	Manda­tory		Indicates the gender of joint holder
BENEFICIARYP­ANNO	VAR­CHAR2	15	Optional		Indicates the Permanent Account Number of the joint holder.
BENEFICIARY­FORM60	NUM­BER	1	Optional		Indicates whether the Form 60 is needed in case the joint holder doesn't have a valid PAN number.
BENEFICIARYM­FIN	VAR­CHAR2	15	Optional		Indicates the MFIN infor­mation for the joint holder.
COUNTRYOF­DOMICILE	VAR­CHAR2	3	Optional		Indicates the country of domicile of joint holder.
RECOVERCGT	NUM­BER	1	Optional		Indicates whether the capital gain tax is to be deducted from the trans­action or not.
ADDRESSLINE1	VAR­CHAR2	80	Optional		Represents the first line of joint holder's address.
ADDRESSLINE2	VAR­CHAR2	80	Optional		Represents the second line of joint holder's address.
ADDRESSLINE3	VAR­CHAR2	80	Optional		Represents the third line of joint holder's address.
ADDRESSLINE4	VAR­CHAR2	80	Optional		Represents the fourth line of joint holder's address.
ZIPCODE	VAR­CHAR2	10	Manda­tory		Indicates the locational ZIP code for the joint holder's address
COUNTRY	VAR­CHAR2	3	Manda­tory		Indicates the country of joint holder
EMAIL	VAR­CHAR2	60	Optional		Indicates the email address of joint holder.
CONTACTPER­SON	VAR­CHAR2	70	Optional		Indicates the name of joint holder's contact per­son.
EXISTINGU­HORCIF	VAR­CHAR2	1	Manda­tory		Indicates whether its existing UH or CIF

2.2.9 Unit Holder Nominee Details

Serial Number: 9

Segment Identification Number: 08NME

Description: This segment is used for providing Nominee related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Manda­tory		Segment Id. Value of Segment Id is 08NME
SEQUENCENUM­BER	NUM­BER	10	Manda­tory		Sequence Number
PROCESSID	VAR­CHAR2	50	Manda­tory		Process ID
BENEFICIARYID	VAR­CHAR2	12	Manda­tory		Represents the unique identification code for the nominee of unitholder.
BENEFI­CIARYNAME	VAR­CHAR2	100	Manda­tory		Indicates the type of nominee.
BENEFICIARY­TYPE	VAR­CHAR2	2	Manda­tory		Indicates the descriptive name for the nominee.
BENEFICIARY­DOB	DATE	10	Manda­tory		Represents the Date of Birth for the nominee.
BENEFICIARY­GENDER	VAR­CHAR2	1	Optional		Indicates the gender of nominee.
BENEFICIARYID­TYPE	VAR­CHAR2	3	Optional		Indicates the identifica­tion type of nominee.
BENEFICIARYID­NUMBER	VAR­CHAR2	15	Optional		Indicates the unique identification number for the nominee
BENEFICIARYP­ANNO	VAR­CHAR2	15	Optional		Indicates the Permanent Account Number of the nominee.
BENEFICIARY­FORM60	NUM­BER	1	Optional		Indicates whether the Form 60 is needed in case the nominee doesn't have a valid PAN number.
BENEFI­CIARYRELATION	VAR­CHAR2	70	Optional		Represents the relation of nominee to the men­tioned unitholder.
BENEFICIAR­YAWARD	NUM­BER	5	Optional		Indicates the award per­centage applicable for the nominee
ADDRESSLINE1	VAR­CHAR2	80	Manda­tory		Represents the first line of nominee's address.
ADDRESSLINE2	VAR­CHAR2	80	Optional		Represents the second line of nominee's address.
ADDRESSLINE3	VAR­CHAR2	80	Optional		Represents the third line of nominee's address.
ADDRESSLINE4	VAR­CHAR2	80	Optional		Represents the fourth line of nominee's address.
ZIPCODE	VAR­CHAR2	10	Manda­tory		Indicates the locational ZIP code for the nomi­nee's address
COUNTRY	VAR­CHAR2	3	Manda­tory		Indicates the country of nominee
EMAIL	VAR­CHAR2	60	Optional		Indicates the email address of nominee.
CONTACTPER­SON	VAR­CHAR2	70	Optional		Indicates the name of nominee's contact per­son.
BENEFICIA­RYBANKCODE	VAR­CHAR2	12	Manda­tory		Represents the bank identification code for the nominee.
BENEFICIARY­BRANCHCODE	VAR­CHAR2	12	Manda­tory		Represents the branch identificaiton code for the nominee.
BENEFICIAR­YACCTYPE	VAR­CHAR2	1	Optional		Represents the nomi­nee's account type.
BENEFICIAR­YACCCCY	VAR­CHAR2	3	Optional		Represents the nomi­nee's account name.
ACCOUNTNUM­BER	VAR­CHAR2	16	Manda­tory		Represents the account currency of the nomi­nee's bank account.
BENEFICIAR­YACCNAME	VAR­CHAR2	100	Optional		Indicates the account number of the nominee
IBAN	VAR­CHAR2	40	Optional		Indicates the Interna­tional Bank Account Number.
COUNTRYOF­DOMICILE	VAR­CHAR2	25	Optional		Indicates the country of domicile of nominee.
EXISTINGUHOR­CIF	VAR­CHAR2	1	Manda­tory		Indicates whether its existing UH or CIF

2.2.10 Unit Holder Director Details

Serial Number: 10

Segment Identification Number: 09DIR

Description: This segment is used for providing Director related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Manda­tory		Segment Id. Value of Segment Id is 09DIR
SEQUENCENUM­BER	NUM­BER	10	Manda­tory		Sequence Number
PROCESSID	VAR­CHAR2	50	Manda­tory		Process ID
EXISTINGUHOR­CIF	VAR­CHAR2	1	Optional		Indicates whether its existing UH or CIF
BENEFI­CIARYNAME	VAR­CHAR2	100	Optional		Indicates the descrip­tive name for the Director.
BENEFICIARYID	VAR­CHAR2	12	Manda­tory		Represents the unique identification code for the Director of unitholder.
BENEFICIARY­DOB	DATE	10	Manda­tory		Represents the Date of Birth for the Direc­tor.
BENEFICIARY­GENDER	VAR­CHAR2	1	Manda­tory		Indicates the gender of Director.
BENEFICIARYID­TYPE	VAR­CHAR2	3	Optional		Indicates the identifi­cation type of Director.
BENEFICIARYID­NUMBER	VAR­CHAR2	15	Manda­tory		Indicates the unique identification number for the Director
COUNTRYOF­DOMICILE	VAR­CHAR2	3	Optional		Indicates the country of domicile of Director.
ADDRESSLINE1	VAR­CHAR2	80	Manda­tory		Represents the first line of Director's address.
ADDRESSLINE2	VAR­CHAR2	80	Optional		Represents the sec­ond line of Director's address.
ADDRESSLINE3	VAR­CHAR2	80	Optional		Represents the third line of Director's address.
ADDRESSLINE4	VAR­CHAR2	80	Optional		Represents the fourth line of Director's address.
COUNTRY	VAR­CHAR2	3	Optional		Indicates the country of Director
ZIPCODE	VAR­CHAR2	10	Manda­tory		Indicates the loca­tional ZIP code for the Director's address
EMAIL	VAR­CHAR2	60	Optional		Indicates the email address of Director.
CONTACTPER­SON	VAR­CHAR2	70	Optional		Indicates the name of Director's contact per­son.
BENEFICIA­RYBANKCODE	VAR­CHAR2	12	Optional		Represents the bank identification code for the Director.
BENEFICIARY­BRANCHCODE	VAR­CHAR2	12	Optional		Represents the branch identificaiton code for the Director.
BENEFICIAR­YACCTYPE	VAR­CHAR2	1	Optional		Represents the Direc­tor's account type.
BENEFICIAR­YACCCCY	VAR­CHAR2	3	Optional		Represents the account currency of the Director's bank account.
ACCOUNTNUM­BER	VAR­CHAR2	16	Optional		Represents the account currency of the Director's bank account.
BENEFICIAR­YACCNAME	VAR­CHAR2	100	Optional		Represents the Direc­tor's account name.
IBAN	VAR­CHAR2	40	Optional		Indicates the Interna­tional Bank Account Number.
PERCENTHOLD­INGS	NUM­BER	5	Optional		Indicate Percentage Holding
DESIGNATION	VAR­CHAR2	100	Optional		Designation

2.2.11 Unit Holder Additional Information Details

Serial Number: 11

Segment Identification Number: 10ADD

Description: This segment is used for providing Additional Information related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Manda­tory		Segment Id. Value of Segment Id is 10ADD
SEQUENCE­NUMBER	NUMBER	22	Manda­tory		Sequence Number
PROCESSID	VAR­CHAR2	200	Manda­tory		Process ID
ADDINFOLABEL	VAR­CHAR2	120	Manda­tory		Addinfo Label
FIELDVALUE	CHAR	92	Manda­tory		Field Value

2.3 Transactions File Format

Note

For all imports of new and amended transactions data, the external hand-off file containing the information must:

• Always be named in the format “BulkTxn*.*”.
• 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:

Note

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 informa­tion 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?
00CON	This segment is used for providing Transaction related Information	Mandatory; and will be the driving header segment for all the other segments.
01SET	This segment is used for providing Transaction Settlement related Informa­tion	Mandatory
02KYC	This segment is used for providing KYC Transaction related Information	Optional
03AIF	This segment is used for providing Addi­tional Information Details	Optional
04INT	This segment is used for providing Transaction Intermediary related Infor­mation	Optional
05CER	This segment is used for providing Cer­tificate related Information	Optional
06REC	This segment is used for providing Transaction Receipt related Information	Optional
07DEL	This segment is used for providing Delivery related Information	Optional
08LMO	This segment is used for providing Limit Order related Information	Optional
09LOD	This segment is used for providing Transaction Load Override related Infor­mation	Optional
10DLO	This segment is used for providing Derived Load Override related Informa­tion	Optional
11PSE	This segment is used for providing Pseudo Switch related Information	Optional
12PSL	This segment is used for providing Switch In Fund Load Override related Information	Optional
13PSD	This segment is used for providing Switch In Fund Derived Load Override related Information	Optional

 

2.3.1 Transaction related Information

Serial Number: 1

Segment Identification Number: 00CON

Description: This segment is used for providing Transaction related Information.

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Mandatory		Segment ID - 00CON
TXNSERIAL­NUMBER	NUM­BER	10	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	10	Mandatory		Sequence Number
PROCESSID	VAR­CHAR2	50	Mandatory		Transaction Serial Number
BULKCLIENT­CODE	VAR­CHAR2	12	Mandatory		Bulk Client Code
IMPORTFILE­NAME	VAR­CHAR2	255	Mandatory		Import File Name
AMCID	VAR­CHAR2	12	Mandatory		AMC ID
UPLOADMODE	VAR­CHAR2	1	Mandatory		Mode of Transaction, N – New, E- Modify, D - Delete, A - Auth, R - Reversal
TRANSACTION­NUMBER	VAR­CHAR2	16	Mandatory		Transaction Number
REFERENCE­NUMBER	VAR­CHAR2	16	Optional		Reference Number
TRANSACTION­DATE	DATE	7	Optional		Transaction Date
UNITHOLDERID	VAR­CHAR2	60	Mandatory		Unitholder Id
REFUNITHOLD­ERID	VAR­CHAR2	12	Mandatory		Reference Unit Holder ID
AGENTCODE	VAR­CHAR2	12	Mandatory		Agent Code
BRANCHCODE	VAR­CHAR2	12	Mandatory		Branch Code
FUNDID	VAR­CHAR2	25	Mandatory		Fund ID
AMOUNT	NUM­BER	15	Optional		Amount
PAYMENTMODE	VAR­CHAR2	1	Optional		Payment Mode.C-Cash,Q-Cheque,T-Transfer,R-Card,M-Multipayment,D-Draft.
CHEQUENUM­BER	VAR­CHAR2	16	Optional		Cheque Number
CLEARINGDATE	DATE	7	Optional		Clearing Date
TRANSACTION­CURRENCY	VAR­CHAR2	3	Optional		Transaction Cur­rency
TRANSACTION­MODE	VAR­CHAR2	1	Optional		Transaction Mode.A-Amount,U-Units,P-Percentage
UNITSAPPLIED	NUM­BER	15	Optional		Units
PERCENTAP­PLIED	NUM­BER	5	Optional		Percentage
TOFUNDID	VAR­CHAR2	25	Optional		To Fund Id
TOUNITHOLDE­RID	VAR­CHAR2	60	Optional		To Unitholder Id
REFTOUNITHOLDERID	VAR­CHAR2	12	Optional		Reference To Unit Holder ID
TRANSACTION­TYPE	VAR­CHAR2	2	Mandatory		Transaction Type. 01-IPO Subscrip­tion,02-Subscrip­tion,03-Redemption,04-Switch,05-Transfer
REFTYPE	VAR­CHAR2	2	Optional		Ref Type. For exam­ple ,reftype - 56, transaction Type - 05 it will consider as "No Change of bene­ficiary ownership' Transfer transaction
REMARKS	VAR­CHAR2	255	Optional		Remarks
CIFNUMBER	VAR­CHAR2	12	Optional		CIF Number
TOCIFNUMBER	VAR­CHAR2	12	Optional		To CIF Number
GROSSORNET	VAR­CHAR2	1	Optional		Gross Or Net.G-Gross,N-Net
SUBPAYMENT­MODE	VAR­CHAR2	2	Optional		Sub Payment Mode.T-Money Transfer,Q-Cheque,R-Credit Card,D-Demand Draft,F-Against Pay­ment,I-In Kind Pay­ment,AT-Advice,BQ-Broker Cheque,CQ-Cashier cheque,DR-Debit Card,DT-Direct Debit,FQ-Foreign Cheque,GQ-Govern­ment Cheque,IQ-Other Institution Cheque,LQ-Local Cheque,OQ-Out Of Town Cheque,PD-Pay Order,PQ-Pay­roll Deduction,RQ-Reserve Bank Cheque,TT-Tel­egraphic Trans­fer,WT-Wire Transfer.
COMMUNICA­TIONMODE	VAR­CHAR2	2	Optional		Communication Mode.CW-Check Writing,DI-Direct (In Person),EM-E-Mail,IN-Internet,RA-Registered Invest­ment Advisor,RD-Registered Dealer,SP-Savings Plan,SW-SWIFT,TL-Telephone
POLICYNUM­BER	VAR­CHAR2	16	Optional		Policy Number
PRODUCTID	VAR­CHAR2	10	Optional		Product Id
LOIAPPLICABLE	NUM­BER	1	Optional		LOI Transaction.1-Yes,0-No
REFFUNDID	VAR­CHAR2	6	Optional		Reference Fund ID
REFTOFUNDID	VAR­CHAR2	6	Optional		Reference To Fund ID
ENTITYTYPE	VAR­CHAR2	1	Optional		Entity Type.A-Agent,N-Branch Code,I-IFA,O-Account Officer,B-Broker
ENTITYID	VAR­CHAR2	12	Optional		Entity Id
SETTLEMENT­DATE	DATE	7	Optional		Settlement Date
DELIVERYOP­TION	VAR­CHAR2	1	Optional		Delivery Option. Y-On,N-Off
TRANSACTION­SUBTYPE	VAR­CHAR2	1	Optional		Transaction Sub Type
REVERSAL­CODE	VAR­CHAR2	2	Optional		Reversal Code
CANCELIN­STRUCTION	VAR­CHAR2	2	Optional		Cancel Instruc­tion.SI-Standing Instruction
FROMFUND­PRICEBASIS	VAR­CHAR2	10	Optional		Fund Price Basis
TOFUNDPRICE­BASIS	VAR­CHAR2	10	Optional		Switch In Price Basis
TXN_OR_­PRICE_DATE_­FLAG	VAR­CHAR2	1	Optional		Transaction/price date
FROMPRICE­DATE	DATE	7	Optional		Price Date
TOPRICEDATE	DATE	7	Optional		Switch In Price Date
SUBSCRIP­TIONFUNDID	VAR­CHAR2	6	Optional		Subscription Fund ID
SUBSCRIP­TIONPRICEBA­SIS	VAR­CHAR2	10	Optional		Subscription Price Basis
PAYMENTAL­LOWED	NUM­BER	1	Optional		Payment Allowed
PROCESSID1	VAR­CHAR2	51	Mandatory		Process ID . Should be same as the Pro­cess ID given above.
SUBSETTLE­MENTDATE	DATE	10	Optional		Settlement Date
SUBPRICEDATE	DATE	10	Optional		Subscription price Date
BASECOST	NUM­BER	15	Optional		Base cost
EXCHANGER­ATEDETAILS	VAR­CHAR2	35	Optional		Exchange Rate Details - Unit Cur­rency,Quoted Cur­rency,Exchange Rate.Seperated by '#' for eg. ZAR#GBP#0.2#
DEALINGDATE	DATE	10	Mandatory		Dealing Date
COMPLETION­DATE	DATE	10	Mandatory		Completion Date
EUSDOPTION	VAR­CHAR2	1	Mandatory		EUSD Option.W-With Holiding Tax,E-Exchange of Infor­mation,T-Tax Exemption Certifi­cate
TODEALING­DATE	DATE	10	Mandatory		Switch In Dealing Date
KYCCHASING­DATE	DATE	10	Mandatory		Kyc Chasing Date
KYCRECEIVED	NUM­BER	1	Mandatory		Kyc Received.1-Yes,0-No
LOCKINPERI­ODFORGAIN	NUM­BER	4	Optional		Lock-In Period for Gain
SWIINEX­CHANGERATE­APPLIED	NUM­BER	15	Mandatory		Switch-In Exchange Rate Applied
AUTOCLEAR­PROVISIONAL­BALANCE	NUM­BER	1	Optional	Valid val­ues are 0, 1 and 2	Auto Clear Provi­sional Balance.1-Yes,0-No
AUTOCLEAR­REINVEST­MENTS	NUM­BER	1	Optional	Valid val­ues are 0, 1 and 2	Auto Clear Reinvest­ments.1-Yes,0-No
FEECURRENCY	VAR­CHAR2	3	Optional	Valid val­ues are ‘FBC’ and ‘TC’	Fee Currency
MATURITYDATE	DATE	10	Optional		Maturity Date
SUBSOURCEID	VAR­CHAR2	6	Optional		Subscription Source ID
CERTSPILLO­VER	NUM­BER	1	Optional		Certificate SpillOver
ISSUED	NUM­BER	1	Optional		From Issued Bal­ances.1-Yes,0-No
BLOCKTXN­NUMBER	VAR­CHAR2	16	Optional		Block Transaction Number
CPMFBONUS­PERCENT	NUM­BER	30	Optional		CPMF Bonus Per­cent
CPMFCREDIT­LAG	NUM­BER	3	Optional		CPMF Credit Lag
RETAINAGEING	NUM­BER	1	Optional		Retain Ageing
CAMPAIGN­CODE	VAR­CHAR2	6	Optional		Campaign Code
FXDEALDATE	DATE	10	Optional	Applica­ble for only IPO Subscrip­tion/Sub­scription/Redemp­tion and Pseudo Switch	FX Deal Date
FXVALUEDATE	DATE	10	Optional	Applica­ble for only IPO Subscrip­tion/Sub­scription/Redemp­tion and Pseudo Switch	FX Value Date
MAKER_ID	VAR­CHAR2	15	Mandatory		Maker Id
MAK­ER_DT_STAMP	DATE	10	Optional		Maker Date Stamp
CHECKER_ID	VAR­CHAR2	15	Optional		This field will be ignored. Always maker id in the tem­plate will be consid­ered to update the checker id in the sys­tem.
CHECK­ER_DT_STAMP	DATE	10	Optional		Checker Date Stamp
AUTH_STAT	VAR­CHAR2	1	Mandatory		Authorisation Sta­tus. A-Authorized,U-Unauthorized
ORDERRE­CEIVEDDATE	DATE	7	Optional		Order Received Date
ORDERRE­CEIVEDTIME	VAR­CHAR2	5	Optional		Order Received Time
TXNCATEGORY	VAR­CHAR2	1	Optional		Transaction Cate­gory(E-Execution­only L-Legacy A-Advise Mode)
LOADREFTYPE	VAR­CHAR2	4	Optional		Load Ref Type
SOURCEID	VAR­CHAR2	6	Optional		Source ID
KIIDRECEIVED	VAR­CHAR2	1	Optional		KIID Received

Note

If upload mode is 'R', the system will consider transaction number and reversal code in the template for the reversal of transaction.

2.3.2 Transaction Settlement related Information

Serial Number: 2

Segment Identification Number: 01SET

Description: This segment is used for providing Transaction Settlement related Information

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment ID - 01SET
TXNSERIALNUM­BER	NUM­BER	10	Mandatory		Transaction Serial Number
SEQUENCENUM­BER	NUM­BER	10	Mandatory		Sequence Number
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
BULKCLIENT­CODE	VAR­CHAR2	12	Mandatory		Bulk Client Code
IMPORTFILENAME	VAR­CHAR2	255	Mandatory		Import File Name
AMCID	VAR­CHAR2	12	Optional		AMC ID
UPLOADMODE	VAR­CHAR2	1	Optional		Upload Mode
PAYMENTREFER­ENCENUMBER	VAR­CHAR2	50	Optional		Payment Refer­ence Number
PAYMENTMODE	VAR­CHAR2	2	Optional		Payment Mode.C-Cash,Q-Cheque,T-Transfer,R-Card,M-Multipayment,D-Draft.
SUBPAYMENT­MODE	VAR­CHAR2	2	Optional		Sub Payment Mode.T-Money Transfer,Q-Cheque,R-Credit Card,D-Demand Draft,F-Against Payment,I-In Kind Payment,AT-Advice,BQ-Broker Cheque,CQ-Cash­ier cheque,DR-Debit Card,DT-Direct Debit,FQ-Foreign Cheque,GQ-Gov­ernment Cheque,IQ-Other Institution Cheque,LQ-Local Cheque,OQ-Out Of Town Cheque,PD-Pay Order,PQ-Pay­roll Deduction,RQ-Reserve Bank Cheque,TT-Tel­egraphic Trans­fer,WT-Wire Transfer.
PAYMENTCUR­RENCY	VAR­CHAR2	3	Optional		Payment Currency
PAYMENTDATE	DATE	10	Optional		Payment Date
PAYMENTAMOUNT	NUM­BER	15	Optional		Payment Amount
BANKCHARGES	NUM­BER	15	Optional		Bank Charges
PAY­MENTCHARGES	NUM­BER	15	Optional		Payment Charges
EXCHANGERATE­SOURCE	VAR­CHAR2	6	Optional		Exchange Rate Source
EXCHANGERATE	NUM­BER	15	Optional		F X Rate
PAYMENTALTER­NATEAMOUNT	NUM­BER	30	Optional		Payment Alternate Amount
PAIDDATE	DATE	10	Optional		Paid Date
AUTOSETTLE­MENT	NUM­BER	1	Optional		Auto Settle.1-Yes,0-No
SETTLEMENT­METHOD	VAR­CHAR2	5	Optional		Settlement Method
SETTLEMENTSTA­TUS	VAR­CHAR2	2	Optional		Settlement Status
CHEQUEDATE	DATE	10	Optional		Cheque Date
CHEQUENUMBER	VAR­CHAR2	16	Optional		Cheque Number
CHEQUECUR­RENCY	VAR­CHAR2	3	Optional		Cheque Currency
CHEQUEAMOUNT	NUM­BER	15	Optional		Cheque Amount
DRAWEEBANK­CODE	VAR­CHAR2	12	Optional		Drawee Bank Code
DRAWEE­BRANCHNAME	VAR­CHAR2	20	Optional		Drawee Branch Name
PAYMEN­TREMARKS	VAR­CHAR2	255	Optional		Payment Remarks
PAYMENTTYPE	VAR­CHAR2	1	Optional		Payment Type.S-Self,T-Third Party,B-Broker,R-Retained,AP-Advanced Pay­ment,A-Absorbed/Paid back
THIRDPARTYAD­DRESS	VAR­CHAR2	255	Optional		Third Party Address
THIRDPARTYAD­DRESSLINE1	VAR­CHAR2	80	Optional		Third Party Address line 1
THIRDPARTYAD­DRESSLINE2	VAR­CHAR2	80	Optional		Third Party Address line 2
THIRDPARTYAD­DRESSLINE3	VAR­CHAR2	80	Optional		Third Party Address line 3
THIRDPARTYAD­DRESSLINE4	VAR­CHAR2	80	Optional		Third Party Address line 4
THIRDPARTYBIC­CODE	VAR­CHAR2	12	Optional		Third Party BIC Code
THIRDPARTY­COUNTRYCODE	VAR­CHAR2	3	Optional		Third Party Country
THIRDPARTYPAY­MENTREFER­ENCE	VAR­CHAR2	255	Optional		Third Party Refer­ence
THIRDPARTYS­TATE	VAR­CHAR2	20	Optional		Third Party State
THIRDPARTY­USSTATE	NUM­BER	1	Optional		Third Party US State
THIRDPARTYZIP­CODE	VAR­CHAR2	10	Optional		Third Party Zip Code
TRANSFERAC­COUNTCUR­RENCY	VAR­CHAR2	3	Optional		Transfer Account Currency
TRANSFERAC­COUNTHOLDER­NAME	VAR­CHAR2	100	Optional		Transfer Account Holder Name
TRANSFERAC­COUNTNUMBER	VAR­CHAR2	16	Optional		Transfer Account Number
TRANSFERAC­COUNTTYPE	VAR­CHAR2	1	Optional		Transfer Account Type
TRANSFER­BRANCHCODE	VAR­CHAR2	12	Optional		Transfer Branch Code
TRANSFERREF­ERENCENUMBER	VAR­CHAR2	20	Optional		Transfer Refer­ence Number
CREDITCAR­DREFNO	VAR­CHAR2	16	Optional		Credit Card Refer­ence Number
INKINDPAYMENT­DETAILS	VAR­CHAR2	255	Optional		In Kind Payment Details
PAYMENTAD­DRESSDETAILS	VAR­CHAR2	255	Optional		Payment Address Details
OLDPAYMEN­TREFERENCENO	VAR­CHAR2	16	Optional		Old Payment Ref­erence Number
UHBICCODE	VAR­CHAR2	24	Optional		UH BIC Code
SWIFTFORMAT	VAR­CHAR2	6	Optional		Swift For­mat.MT103-MT103,MT202-MT202
BANKCHARGED	VAR­CHAR2	12	Optional		Bank Charged.Benefi­ciary-Benefi­ciary,Remitter-Remitter,Share-Share
BENEFICIARY	VAR­CHAR2	35	Optional		Beneficiary
BENEFICIARY­ADD1	VAR­CHAR2	35	Optional		Beneficiary Address1
BENEFICIARY­ADD2	VAR­CHAR2	35	Optional		Beneficiary Address2
BENEFICIARY­ADD3	VAR­CHAR2	35	Optional		Beneficiary Address3
BENEFICIARYBIC­CODE	VAR­CHAR2	24	Optional		Beneficiary BIC Code
BENEFICIAR­YACCTNO	VAR­CHAR2	24	Optional		Beneficiary Account Number
BENEFICIARY­CODE	VAR­CHAR2	24	Optional		Beneficiary Code
BENEFICIARY­INFO	VAR­CHAR2	100	Optional		Beneficiary Infor­mation
INTERMEDIARY	VAR­CHAR2	35	Optional		Intermediary
INTERMEDIARY­ADD1	VAR­CHAR2	35	Optional		Intermediary Address1
INTERMEDIARY­ADD2	VAR­CHAR2	35	Optional		Intermediary Address2
INTERMEDIARY­ADD3	VAR­CHAR2	35	Optional		Intermediary Address3
INTERMEDIARY­BICCODE	VAR­CHAR2	24	Optional		Intermediary BIC Code
INTERMEDIAR­YACCTNO	VAR­CHAR2	24	Optional		Intermediary Account No
INTERMEDIARY­CODE	VAR­CHAR2	24	Optional		Intermediary Code
INTERMEDIARY­INFO	VAR­CHAR2	100	Optional		Intermediary Info
FURTHERCREDIT­NAME	VAR­CHAR2	35	Optional		Further Credit Name
FURTHERCRED­ITACCTNO	VAR­CHAR2	35	Optional		Further Credit Account Number
REFERENCE1	VAR­CHAR2	35	Optional		Reference1
REFERENCE2	VAR­CHAR2	35	Optional		Reference2
ENTITYID	VAR­CHAR2	12	Optional		Entity ID
ENTITYTYPE	VAR­CHAR2	1	Optional		Entity Type
IBAN	VAR­CHAR2	40	Optional		IBAN
BENEFICIARY­IBAN	VAR­CHAR2	40	Optional		Beneficiary IBAN
INTERMEDIARY­IBAN	VAR­CHAR2	40	Optional		Intermediary IBAN
BENEFICIARYID	VAR­CHAR2	12	Optional		Beneficiary ID
BENEFI­CIARYPERCENT­AGE	NUM­BER	5	Optional		Beneficiary Per­centage
AMOUNTBLOC­KNO	VAR­CHAR2	16	Optional		Amount Block Number
SETTLED	VAR­CHAR2	1	Optional		Settled. Y- Yes , N- No
REVERSED	VAR­CHAR2	1	Optional		Reversed. Y- Yes , N- No

2.3.3 KYC Transaction related Information

Serial Number: 3

Segment Identification Number: 02KYC

Description: This segment is used for providing KYC Transaction related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Manda­tory		Segment ID - 02KYC
TXNSERIALNUM­BER	NUM­BER	10	Manda­tory		Transaction Serial Number
SEQUENCENUM­BER	NUM­BER	10	Manda­tory		Sequence Number
PROCESSID	VAR­CHAR2	50	Manda­tory		Process ID
BULKCLIENTCODE	VAR­CHAR2	12	Manda­tory		Bulk Client Code
IMPORTFILENAME	VAR­CHAR2	255	Manda­tory		Import File Name
AMCID	VAR­CHAR2	12	Optional		AMC ID
TRANSACTION­NUMBER	VAR­CHAR2	16	Manda­tory		Transaction Number
DOCUMENTDE­SCRIPTION	VAR­CHAR2	255	Optional		Document Description
RECEIVED	VAR­CHAR2	1	Optional		Received.On-Y,Off-N
RECEIVEDDATE	DATE	10	Optional		Received Date
REQUESTED	VAR­CHAR2	1	Optional		Requested.On-Y,Off-N
TAXDOCUMENT	NUM­BER	1	Optional		Tax Document.1-Yes,0-No

 

2.3.4 Transaction Additional Information Details

Serial Number: 4

Segment Identification Number: 03AIF

Description: This segment is used for providing Additional Information Details

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment ID - 03AIF
TXNSERIAL­NUMBER	NUM­BER	10	Mandatory		Transaction serial Number
SEQUENCE­NUMBER	NUM­BER	10	Mandatory		Sequence Num­ber
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
BULKCLIENT­CODE	VAR­CHAR2	12	Mandatory		Bulk Client Code
IMPORTFILE­NAME	VAR­CHAR2	255	Mandatory		Import File Name
AMCID	VAR­CHAR2	12	Mandatory		AMC ID
TRANSACTION­NUMBER	VAR­CHAR2	16	Mandatory		Transaction Num­ber
REFERENCE­NUMBER	VAR­CHAR2	12	Mandatory		Reference Num­ber
OTHERINFO1	VAR­CHAR2	60	Optional		Other Information 1
OTHERINFO2	VAR­CHAR2	60	Optional		Other Information 2
OTHERINFO3	VAR­CHAR2	60	Optional		Other Information 3
OTHERINFO4	VAR­CHAR2	60	Optional		Other Information 4
OTHERINFO5	VAR­CHAR2	60	Optional		Other Information 5
OTHERINFO6	VAR­CHAR2	60	Optional		Other Information 6
OTHERINFO7	VAR­CHAR2	60	Optional		Other Information 7
OTHERINFO8	VAR­CHAR2	60	Optional		Other Information 8
OTHERINFO9	VAR­CHAR2	60	Optional		Other Information 9
OTHERINFO10	VAR­CHAR2	60	Optional		Other Information 10
OTHERINFO11	VAR­CHAR2	60	Optional		Other Information 11
OTHERINFO12	VAR­CHAR2	60	Optional		Other Information 12
OTHERINFO13	VAR­CHAR2	60	Optional		Other Information 13
OTHERINFO14	VAR­CHAR2	60	Optional		Other Information 14
OTHERINFO15	VAR­CHAR2	60	Optional		Other Information 15
OTHERINFO16	VAR­CHAR2	60	Optional		Other Information 16
OTHERINFO17	VAR­CHAR2	60	Optional		Other Information 17
OTHERINFO18	VAR­CHAR2	60	Optional		Other Information 18
OTHERINFO19	VAR­CHAR2	60	Optional		Other Information 19
OTHERINFO20	VAR­CHAR2	60	Optional		Other Information 20
OTHERINFO21	VAR­CHAR2	60	Optional		Other Information 21
OTHERINFO22	VAR­CHAR2	60	Optional		Other Information 22
OTHERINFO23	VAR­CHAR2	60	Optional		Other Information 23
OTHERINFO24	VAR­CHAR2	60	Optional		Other Information 24
OTHERINFO25	VAR­CHAR2	60	Optional		Other Information 25
OTHERINFO26	VAR­CHAR2	60	Optional		Other Information 26
OTHERINFO27	VAR­CHAR2	60	Optional		Other Information 27
OTHERINFO28	VAR­CHAR2	60	Optional		Other Information 28
OTHERINFO29	VAR­CHAR2	60	Optional		Other Information 29
OTHERINFO30	VAR­CHAR2	60	Optional		Other Information 30

2.3.5 Transaction Intermediary related Information

Serial Number: 5

Segment Identification Number: 04INT

Description: This segment is used for providing Transaction Intermediary related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Mandatory		Segment ID - 04INT
PROCESSID	VAR­CHAR2	50	Mandatory		Process Id
SEQUENCENUM­BER	NUMBER	10	Mandatory		Transaction serial Number
TXNSERIALNUM­BER	NUMBER	10	Mandatory		Sequence Num­ber
ENTITYID	VAR­CHAR2	12	Mandatory		Entity Id
ENTITYTYPE	VAR­CHAR2	1	Mandatory		Entity Type.A-Agent,N-Branch Code,I-IFA,O-Account Officer,B-Broker
SPLITPERCENT­AGE	NUMBER	5	Optional		Split Percentage
FROMORTOLEG	VAR­CHAR2	1	Mandatory		From Or To Leg

2.3.6 Transaction Certificate related Information

Serial Number: 6

Segment Identification Number: 05CER

Description: This segment is used for providing Certificate related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Mandatory		Segment ID - 05CER
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Sequence Number
CERTIFICATE­NUMBER	NUMBER	10	Mandatory		Certificate Number
NOOFUNITS	NUMBER	27	Mandatory		Number of Units

2.3.7 Transaction Receipt related Information

Serial Number: 7

Segment Identification Number: 06REC

Description: This segment is used for providing Transaction Receipt related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Manda­tory		Segment ID - 06REC
PROCESSID	VAR­CHAR2	50	Manda­tory		Process Id
SEQUENCENUM­BER	NUMBER	10	Manda­tory		Sequence Num­ber
TRANSACTION­NUMBER	VAR­CHAR2	16	Optional		Transaction Num­ber
TRANSACTION­UNITS	NUMBER	27	Manda­tory		Transaction Units

2.3.8 Transaction Delivery related Information

Serial Number: 8

Segment Identification Number: 07DEL

Description: This segment is used for providing Delivery related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Manda­tory		Segment ID - 07DEL
PROCESSID	VAR­CHAR2	50	Manda­tory		Process ID
SEQUENCENUM­BER	NUMBER	10	Manda­tory		Sequence Number
TXNSERIALNUM­BER	NUMBER	10	Optional		Transaction serial Number
DELIVERYTYPE	VAR­CHAR2	1	Manda­tory		Transaction Units
ENTITYID	VAR­CHAR2	12	Optional		Entity ID
ACCOUNTNUM­BER	VAR­CHAR2	16	Optional		Account Number
ACCOUNTNAME	VAR­CHAR2	100	Optional		Account Name
ADDRESSTYPE	VAR­CHAR2	2	Optional		Address Type
ADDRESSLINE1	VAR­CHAR2	80	Optional		Address Line1
ADDRESSLINE2	VAR­CHAR2	80	Optional		Address Line2
ADDRESSLINE3	VAR­CHAR2	80	Optional		Address Line3
ADDRESSLINE4	VAR­CHAR2	80	Optional		Address Line4
ZIPCODE	VAR­CHAR2	10	Optional		Zipcode
COUNTRY	VAR­CHAR2	3	Optional		Country
BICCODE	VAR­CHAR2	12	Optional		BIC code
IBAN	VAR­CHAR2	40	Optional		IBAN

2.3.9 Transaction Limit Order related Information

Serial Number: 9

Segment Identification Number: 08LMO

Description: This segment is used for providing Limit Order related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Mandatory		Segment ID - 08LMO
PROCESSID	VAR­CHAR2	50	Mandatory		Process Id
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Sequence Number
TXNSERIAL­NUMBER	NUMBER	10	Optional		Transaction serial Number
LIMITORDER­TYPE	VAR­CHAR2	1	Mandatory		Limit order type
LIMITORDER­STATUS	VAR­CHAR2	1	Optional		Limit order status
LIMITPRICE	NUMBER	17	Optional		Limit price
LIMITDATE	DATE	10	Optional		Limit date
LIMITSTART­DATE	DATE	10	Optional		Limit start date
LIMITENDDATE	DATE	10	Optional		Limit end date
LIMITSTATUS	VAR­CHAR2	1	Optional		Limit status
LIMITGENDATE	DATE	10	Optional		Limit generation date

2.3.10 Transaction Load Override related Information

Serial Number: 10

Segment Identification Number: 09LOD

Description: This segment is used for providing Transaction Load Override related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Mandatory		Segment ID - 09LOD
TXNSERIAL­NUMBER	NUMBER	10	Mandatory		Process Id
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Sequence Num­ber
PROCESSID	VAR­CHAR2	50	Optional		Transaction serial Number
LOADID	NUMBER	5	Mandatory		Load ID
FUNDID	VAR­CHAR2	6	Optional		Fund ID
CHANGETYPE	VAR­CHAR2	1	Optional		Change Type
CHANGEVALUE	NUMBER	30	Optional		Change Value
GROUPID	VAR­CHAR2	6	Optional		Group Id

2.3.11 Transaction Derived Load Override related Information

Serial Number: 11

Segment Identification Number: 10DLO

Description: This segment is used for providing Derived Load Override related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Mandatory		Segment ID - 10DLO
PROCESSID	VAR­CHAR2	50	Mandatory		Process Id
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Sequence Number
TXNSERIAL­NUMBER	NUMBER	10	Optional		Transaction serial Number
DERIVEDLOA­DID	VAR­CHAR2	6	Mandatory		Load ID
FUNDID	VAR­CHAR2	6	Optional		Fund ID
PARENTLOADID	NUMBER	5	Optional		Parent Load Id
CHANGETYPE	VAR­CHAR2	1	Optional		Change Type
CHANGEVALUE	NUMBER	17	Optional		Change Value

2.3.12 Transaction Pseudo Switch related Information

Serial Number: 12

Segment Identification Number: 11PSE

Description: This segment is used for providing Pseudo Switch related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Mandatory		Segment ID - 11PSE
PROCESSID	VAR­CHAR2	50	Mandatory		Process Id
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Sequence Num­ber
TXNSERIAL­NUMBER	NUMBER	10	Optional		Transaction serial Number
REFERENCE­NUMBER	VAR­CHAR2	16	Optional		Reference Num­ber
FUNDID	VAR­CHAR2	12	Optional		Fund Id
TRANSACTION­DATE	DATE	10	Optional		Transaction Date
LOADID	NUMBER	5	Optional		Load Id
ORIGINALRE­TURNVALUE	NUMBER	30	Optional		Original Return Value
OVERRIDENRE­TURNVALUE	NUMBER	30	Optional		Overriden Return Value
CHANGETYPE	VAR­CHAR2	1	Optional		Change Type
CHANGEVALUE	NUMBER	30	Optional		Change Value
DERIVEDLOA­DID	VAR­CHAR2	6	Optional		Derived Load Id
DERORIGINAL­RETURNVALUE	NUMBER	30	Optional		Derived Original Return Value
DEROVERRID­ENRETURN­VALUE	NUMBER	30	Optional		Derived Overri­den Return Value
DER­CHANGETYPE	VAR­CHAR2	1	Optional		Derived Change Type
DER­CHANGEVALUE	NUMBER	30	Optional		Derived Change Value
SUBSCRIPTION­PRICEDATE	DATE	10	Optional		Subscription Price Date
EXCHANGERA­TEAPPLIED	NUMBER	15	Optional		Exchangerate Applied
EXCHANGERA­TEOVERRIDEN	NUMBER	15	Optional		Exchangerate Overriden
OVERRIDEEX­CHANGERATE	VAR­CHAR2	1	Optional		Override Exchangerate
EXCHANGERA­TESERIALNO	VAR­CHAR2	16	Optional		Exchangerate Serial No
EXCHANGERA­TEOVERRID­DENSERIALNO	VAR­CHAR2	16	Optional		Exchangerate Overriddens Eri­alno
EXCHANGERAT­ESTATUS	VAR­CHAR2	1	Optional		Exchangerate Sta­tus
SUBSCRIPTION­SETTLEMENT­DATE	DATE	10	Optional		Subscription Set­tlement Date
SUBSCRIPTION­SOURCEID	VAR­CHAR2	6	Optional		Subscription Source Id
SUBTRANSAC­TIONDATE	DATE	10	Optional		Subscription Transaction Date
FXDEALDATE	DATE	10	Optional		Fxdealdate
FXVALUEDATE	DATE	10	Optional		Fxvaluedate
PROJECTEDRE­TURNVALUE	VAR­CHAR2	31	Optional		Projected Return Value

2.3.13 Transaction Switch In Fund Load Override related Information

Serial Number: 13

Segment Identification Number: 12PSL

Description: This segment is used for providing Switch In Fund Load Override related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Mandatory		Segment ID - 12PSL
PROCESSID	VAR­CHAR2	50	Mandatory		Process Id
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Sequence Number
TXNSERIAL­NUMBER	NUMBER	10	Mandatory		Transaction serial Number
REFERENCE­NUMBER	VAR­CHAR2	16	Optional		Reference Num­ber
FUNDID	VAR­CHAR2	12	Optional		Load ID
LOADID	NUMBER	5	Mandatory		Fund ID
GROUPID	VAR­CHAR2	6	Optional		Group Id
CHANGETYPE	VAR­CHAR2	1	Optional		Change Type
CHANGEVALUE	NUMBER	30	Optional		Change Value

2.3.14 Transaction Switch In Fund Derived Load Override related Information

Serial Number: 14

Segment Identification Number: 13PSD

Description: This segment is used for providing Switch In Fund Derived Load Override related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Mandatory		Segment ID - 13PSD
PROCESSID	VAR­CHAR2	50	Mandatory		Process Id
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Sequence Num­ber
TXNSERIAL­NUMBER	NUMBER	10	Mandatory		Transaction serial Number
REFERENCE­NUMBER	VAR­CHAR2	16	Optional		Reference Num­ber
FUNDID	VAR­CHAR2	12	Optional		Fund ID
DERIVEDLOA­DID	VAR­CHAR2	6	Mandatory		Load ID
PARENTLOADID	VAR­CHAR2	6	Optional		Group Id
DER­CHANGETYPE	VAR­CHAR2	1	Optional		Change Type
DER­CHANGEVALUE	NUMBER	30	Optional		Change Value

 

 

2.4 Standing Instruction File Format

Segment Identification Number	Description	Segment Mandatory / Optional?
00SIN	This segment is used for providing Standing Instruction related Information	Mandatory
01BRK	This segment is used for providing SI Intermedi­ary related Information	Optional
02CHQ	This segment is used for providing SI Payment related Information	Optional
03DEL	This segment is used for providing SI Delivery related Information	Optional
04FND	This segment is used for providing SI Fund related Information	Mandatory
05CRT	This segment is used for providing SI Certificate related Information	Optional

2.4.1 Standing Instruction related Information

Serial Number: 1

Segment Identification Number: 00SIN

Description: This segment is used for providing Standing Instruction related Information

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Optional		Segment id. Value of Segment id is 00SIN
SEQUENCE­NUMBER	NUM­BER	10	Manda­tory		Sequence Number
PROCESSID	VAR­CHAR2	50	Manda­tory		Process ID
BULKCLIENT­CODE	VAR­CHAR2	12	Manda­tory		Bulk Client Code
IMPORTFILE­NAME	VAR­CHAR2	255	Manda­tory		Import File Name
AMCID	VAR­CHAR2	12	Manda­tory		AMC ID
UPLOADMODE	VAR­CHAR2	1	Manda­tory		Upload Mode
SIID	VAR­CHAR2	16	Optional		Standing Instruction ID
SIDESCRIP­TION	VAR­CHAR2	255	Optional		SI Description
FUNDID	VAR­CHAR2	25	Optional		Fundid
REFUNITHOLD­ERID	VAR­CHAR2	12	Optional		This must be blank
REFTOUNITHOLDERID	VAR­CHAR2	12	Optional		This must be blank
UNITHOLDERID	VAR­CHAR2	12	Optional		Unitholder Id
TRANSACTION­TYPE	VAR­CHAR2	2	Optional		Transaction Type . 01-IPO Subscription,02-Subscription,03-Redemption,04-Switch,05-Transfer.
EFFECTIVE­STARTDATE	DATE	10	Optional		Effective Start Date
EFFEC­TIVEENDDATE	DATE	10	Optional		Effective End Date
SIFREQUENCY	VAR­CHAR2	1	Optional		SI Frequency.M-Monthly,Q-Quartely,H-Half Yearly,Y-Yearly,W-Weekly,F-BiWeekly,D-Daily
AMOUNT	NUM­BER	30	Optional		Amount
UNITS	NUM­BER	27	Optional		Units
HOLDINGSPER­CENTAGE	NUM­BER	5	Optional		Percentage
TRANSACTION­CURRENCY	VAR­CHAR2	3	Optional		Transaction Currency.
TOUNITHOLDE­RID	VAR­CHAR2	12	Optional		To Unitholder Id
TOFUNDID	VAR­CHAR2	25	Optional		To FundId
AGENTCODE	VAR­CHAR2	12	Optional		Agent Code
BRANCHCODE	VAR­CHAR2	12	Optional		Branch Code
MODULEID	VAR­CHAR2	30	Optional		Module Id
MODEOFPAY­MENT	VAR­CHAR2	1	Optional		Mode Of Payment
PAYMENT­BRANCHCODE	VAR­CHAR2	12	Optional		Payment Branch
TRANSFERAC­COUNTTYPE	VAR­CHAR2	1	Optional		Account Type
TRANSFERAC­COUNTNUM­BER	VAR­CHAR2	16	Optional		Account Number
REMINDERBE­FOREPERIOD	NUM­BER	3	Optional		Reminder Period
REMINDERBE­FOREACTION	NUM­BER	1	Optional		Reminder Before Action
SISTATUS	VAR­CHAR2	1	Optional		SI Status
GENERATEAU­THTXN	NUM­BER	1	Optional		Generate Auth Transac­tions.1-Yes,0-No
SITYPE	VAR­CHAR2	10	Optional		This must be blank
SIESCALATION­FREQUENCY	VAR­CHAR2	1	Optional		Escalation Fre­quency.M-Monthly,Q-Quarterly,H-Half-Yearly,Y-Yearly,W-Weekly,F-Bi-Weekly,D-Daily
NEXTESCALA­TIONDATE	DATE	10	Manda­tory		Next Escalation Date
ESCALATION­TYPE	VAR­CHAR2	1	Optional		Escalation Type.A-Amount/Units,P-Per­centage.
ESCALATION­VALUE	NUM­BER	30	Optional		Escalation Value
MAKER_ID	VAR­CHAR2	15	Optional		Maker Id
MAK­ER_DT_STAMP	DATE	10	Optional		Maker Date Stamp
CHECKER_ID	VAR­CHAR2	15	Optional		Checker IdThis field will be ignored. Always maker id in the tem­plate will be considered to update the checker id in the system.
CHECK­ER_DT_STAMP	DATE	10	Optional		Checker Date Stamp
AUTH_STAT	VAR­CHAR2	1	Optional		Authorisation Status.A-Authorized,U-Unauthor­ized.
GROSSORNET	VAR­CHAR2	1	Manda­tory	Manda­tory for transac­tion types (01, 02 & 03) I.e IPO, Sub­scrip­tion and redemp­tion	Gross or Net.G-Gross,N-Net.
MEANSOFPUR­CHASE	VAR­CHAR2	2	Optional		Value should be a valid means of purchase code maintained in the system
ISSUED	VAR­CHAR2	1	Optional		Issued.1-Yes,0-No,2-Both.
CERTREQD	VAR­CHAR2	1	Optional		Certificate Required? . 1-Yes,0-No
SINGLECERT	VAR­CHAR2	1	Optional		Single Certificate? . 1-Yes , 0-No
TOSINGLECERT	VAR­CHAR2	1	Optional		Applicable for script based fund only.
SUBPAYMENT­MODE	VAR­CHAR2	2	Optional		Mode Of Payment.T-Money Transfer,Q-Cheque,R-Credit Card,D-Demand Draft,F-Against Pay­ment,I-In Kind Pay­ment,AT-Advice,BQ-Broker Cheque,CQ-Cashier cheque,DR-Debit Card,DT-Direct Debit,FQ-Foreign Cheque,GQ-Govern­ment Cheque,IQ-Other Institution Cheque,LQ-Local Cheque,OQ-Out Of Town Cheque,PD-Pay Order,PQ-Payroll Deduction,RQ-Reserve Bank Cheque,TT-Tel­egraphic Transfer,WT-Wire Transfer.
ESCALATION­STARTDATE	DATE	10	Manda­tory	Manda­tory if Escala­tion type is pro­vided	Escalation Start Date
ESCALA­TIONENDDATE	DATE	10	Manda­tory	Manda­tory if Escala­tion type is pro­vided	Escalation End Date
PAYMENTBANK­CODE	VAR­CHAR2	12	Manda­tory	Required for pay­ment modes check trans­fer, credit card and demand draft	Payment Bank Code
TRANSFERAC­COUNTHOLD­ERNAME	VAR­CHAR2	60	Optional		Account Holder Name
PAYMENTTYPE	VAR­CHAR2	1	Optional		Payment Type. S-Self,T-Third Party.
THIRDPAR­TYPAYMEN­TREFERENCE	VAR­CHAR2	255	Optional		Third Party Reference
THIRDPAR­TYZIPCODE	VAR­CHAR2	6	Optional		Third Party Zip Code
THIRDPARTY­USSTATE	NUM­BER	1	Optional		Third Party US State
DELIVERYOP­TION	VAR­CHAR2	1	Optional		Delivery Option
THIRDPARTY­BICCODE	VAR­CHAR2	12	Optional		BIC Code
THIRDPARTY­COUNTRY­CODE	VAR­CHAR2	3	Optional		Country
THIRDPART­YADDRESS­LINE1	VAR­CHAR2	80	Optional		Address Line 1
THIRDPART­YADDRESS­LINE2	VAR­CHAR2	80	Optional		Address Line 2
THIRDPART­YADDRESS­LINE3	VAR­CHAR2	80	Optional		City
THIRDPART­YADDRESS­LINE4	VAR­CHAR2	80	Optional		Country
TRANSFERREF­ERENCENUM­BER	VAR­CHAR2	20	Optional		Transfer Reference Number
CIFNUMBER	VAR­CHAR2	12	Optional		CIF Number
TOCIFNUMBER	VAR­CHAR2	12	Optional		To CIF Number
POLICYNUM­BER	VAR­CHAR2	16	Optional		This must be blank
PRODUCTID	VAR­CHAR2	10	Optional		This must be blank
ENTITYTYPE	VAR­CHAR2	1	Optional		Entity Type.B-Broker,A-Agent,I-IFA,O-Account Officer,N-Agency Branch.
ENTITYID	VAR­CHAR2	12	Optional		Broker/Intermediary
REFFUNDID	VAR­CHAR2	6	Optional		Specify the fund code here
REFTOFUNDID	VAR­CHAR2	6	Optional		Specify the fund code if the SI is switch type of instruction
MINHOLDCH­KREQ	NUM­BER	1	Optional		Minimum Holding Check Required? 1-Yes,0-No
FROMFUND­PRICEBASIS	VAR­CHAR2	10	Optional		Price Basis
TOFUNDPRICE­BASIS	VAR­CHAR2	10	Optional		This must be blank
PHASEIN	NUM­BER	1	Optional		Phase In
PHASEINTYPE	VAR­CHAR2	1	Optional	If PHA­SEIN is applica­ble then this field is manda­tory.	Phase In Type. H-Hold­ings.
PHASEINOC­CURENCES	NUM­BER	3	Optional	If PHA­SEIN is applica­ble then this field is manda­tory.	If Phase In is applicable then this field is manda­tory.
REMAININGOC­CURENCES	NUM­BER	3	Optional		This must be blank
GENERATEON	VAR­CHAR2	255	Optional		This must be blank
NOOFSI	NUM­BER	5	Optional		No. of SI Transactions
SWIFTFORMAT	VAR­CHAR2	6	Optional		Swift Format. MT103-MT103,MT202-MT202
BANKCHARGED	VAR­CHAR2	12	Optional		Bank Charged.Shared-Shared,Remit-Remit.
BENEFICIARY	VAR­CHAR2	35	Optional		Beneficiary
BENEFICIARY­ADD1	VAR­CHAR2	35	Optional		Beneficiary Address1
BENEFICIARY­ADD2	VAR­CHAR2	35	Optional		Beneficiary Address2
BENEFICIARY­ADD3	VAR­CHAR2	35	Optional		Beneficiary Address3
BENEFICIARY­BICCODE	VAR­CHAR2	24	Optional		Beneficiary BIC Code
BENEFICIAR­YACCTNO	VAR­CHAR2	24	Optional		Beneficiary Account Number
BENEFICIARY­CODE	VAR­CHAR2	24	Optional		Beneficiary Code
BENEFICIARY­INFO	VAR­CHAR2	100	Optional		Beneficiary Info
INTERMEDIARY	VAR­CHAR2	35	Optional		Intermediary
INTERMEDIAR­YADD1	VAR­CHAR2	35	Optional		Intermediary Address1
INTERMEDIAR­YADD2	VAR­CHAR2	35	Optional		Intermediary Address2
INTERMEDIAR­YADD3	VAR­CHAR2	35	Optional		Intermediary Address3
INTERMEDIA­RYBICCODE	VAR­CHAR2	24	Optional		Intermediary BIC Code
INTERMEDIAR­YACCTNO	VAR­CHAR2	24	Optional		Intermediary Account Number
INTERMEDI­ARYCODE	VAR­CHAR2	24	Optional		Intermediary Code
INTERMEDI­ARYINFO	VAR­CHAR2	100	Optional		Intermediary Info
FURTHER­CREDITNAME	VAR­CHAR2	35	Optional		Further Credit Name
FURTHER­CRED­ITACCTNO	VAR­CHAR2	35	Optional		Further Credit Account Number
REFERENCE1	VAR­CHAR2	35	Optional		Reference1
REFERENCE2	VAR­CHAR2	35	Optional		Reference2
NOOFSITRANS­ACTIONS	NUM­BER	4	Optional		No. of SI Transactions
SILEVEL	VAR­CHAR2	1	Optional	Valid values are ‘F’ and ‘P’	SI Level. P-Plan,F-Fund
PLANCODE	VAR­CHAR2	6	Optional		Plan Code
FIRSTPAY­MENTDATE	DATE	10	Optional		First Generation Date
IBAN	VAR­CHAR2	40	Optional		IBAN
CAMPAIGN­CODE	VAR­CHAR2	6	Optional		Campaign Code
BENEFICIARY­IBAN	VAR­CHAR2	40	Optional		Beneficiary IBAN
INTERMEDI­ARYIBAN	VAR­CHAR2	40	Optional		Intermediary IBAN
SIPAYMENTRE­JECTION­COUNTER	NUM­BER	3	Optional		No. of Cumulative Pay­ment Rejections
SIAUTOTERMI­NATION­COUNTER	NUM­BER	3	Optional		SI Auto-Termination Cumulative Counter
CONSSIPAYMN­TREJCNTER	NUM­BER	3	Optional		No. of Consecutive Pay­ment Rejections
CONSSIAUTO­COUNTER	NUM­BER	3	Optional		SI Auto-Termination Consecutive Counter
MAXSITXNSAL­LOWED	NUM­BER	3	Optional		Maximum SI Transac­tions Allowed

2.4.2 SI Intermediary related Information

Serial Number: 2

Segment Identification Number: 01BRK

Description: This segment is used for providing SI Intermediary related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Mandatory		Segment id. Value of Segment id is 01BRK
SEQUENCE­NUMBER	NUM­BER	10	Mandatory		Sequence Number
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
BULKCLIENT­CODE	VAR­CHAR2	12	Optional		Bulk Client Code
IMPORTFILE­NAME	VAR­CHAR2	255	Optional		Import file Name
AMCID	VAR­CHAR2	12	Optional		AMC ID
UPLOADMODE	VAR­CHAR2	1	Optional		Uplaod Mode
SIID	VAR­CHAR2	16	Optional		SI Id
ENTITYID	VAR­CHAR2	12	Optional		Broker/Intermediary
ENTITYTYPE	VAR­CHAR2	1	Optional		Entity Type. B-Bro­ker,A-Agent,I-IFA,O-Account Officer,N-Agency Branch.
SPLITPER­CENTAGE	NUM­BER	5	Optional		Split Percentage
FROMORTO­LEG	VAR­CHAR2	1	Mandatory		From Or To Leg. F-From,T-To

2.4.3 SI Payment related Information

Serial Number: 3

Segment Identification Number: 02CHQ

Description: This segment is used for providing SI Payment related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Mandatory		Segment id. Value of Segment id is 02CHQ
SEQUENCE­NUMBER	NUM­BER	10	Mandatory		Sequence Number
PROCESSID	VAR­CHAR2	50	Optional		Process ID
BULKCLIENT­CODE	VAR­CHAR2	12	Optional		Bulk Client Code
IMPORTFILE­NAME	VAR­CHAR2	255	Optional		Import file Name
AMCID	VAR­CHAR2	12	Optional		AMC ID
UPLOADMODE	VAR­CHAR2	1	Optional		Uplaod Mode
SIID	VAR­CHAR2	16	Optional		SI Id
PAYMENTMODE	VAR­CHAR2	1	Optional		Payment Mode
PAYMENTNUM­BER	VAR­CHAR2	16	Optional		Cheque Number
PAYMENTDATE	DATE	10	Optional		Payment Date
PROCESSED	NUM­BER	1	Optional		Processed. 1-Yes , 0-No

2.4.4 SI Delivery related Information

Serial Number: 4

Segment Identification Number: 03DEL

Description: This segment is used for providing SI Delivery related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Manda­tory		Segment id. Value of Segment id is 03DEL
SEQUENCE­NUMBER	NUM­BER	10	Manda­tory		Sequence Number
PROCESSID	VAR­CHAR2	50	Optional		Process ID
BULKCLIENT­CODE	VAR­CHAR2	12	Optional		Bulk Client Code
IMPORTFILE­NAME	VAR­CHAR2	255	Optional		Import file Name
AMCID	VAR­CHAR2	12	Optional		AMC ID
UPLOADMODE	VAR­CHAR2	1	Optional		Uplaod Mode
SIID	VAR­CHAR2	16	Optional		SI Id
DELIVERYTYPE	VAR­CHAR2	1	Optional		Delivery Type. S-Self ,T-Third Party
ENTITYID	VAR­CHAR2	12	Optional		Clearing Agent/Custo­dian Bank
ACCOUNTNUM­BER	VAR­CHAR2	16	Optional		Account Number
ACCOUNT­NAME	VAR­CHAR2	100	Optional		Account Name
ADDRESSTYPE	VAR­CHAR2	2	Optional		Address Type
ADDRESSLINE1	VAR­CHAR2	80	Optional		Address Line1
ADDRESSLINE2	VAR­CHAR2	80	Optional		Address Line2
ADDRESSLINE3	VAR­CHAR2	80	Optional		Address Line3
ADDRESSLINE4	VAR­CHAR2	80	Optional		Address Line4
ZIPCODE	VAR­CHAR2	10	Optional		Zip Code
COUNTRY	VAR­CHAR2	3	Optional		Country
BICCODE	VAR­CHAR2	12	Optional		BIC Code
IBAN	VAR­CHAR2	40	Optional		IBAN

2.4.5 SI Fund related Information

Serial Number: 5

Segment Identification Number: 04FND

Description: This segment is used for providing SI Fund related Information

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Mandatory		Segment id. Value of Segment id is 04FND
SEQUENCE­NUMBER	NUM­BER	10	Mandatory		Sequence Number
PROCESSID	VAR­CHAR2	50	Optional		Process ID
BULKCLIENT­CODE	VAR­CHAR2	12	Optional		Bulk Client Code
IMPORTFILE­NAME	VAR­CHAR2	255	Optional		Import file Name
AMCID	VAR­CHAR2	12	Optional		AMC ID
UPLOADMODE	VAR­CHAR2	1	Optional		Uplaod Mode
SIID	VAR­CHAR2	16	Optional		SI Id
FUNDID	VAR­CHAR2	6	Optional		FundId
ISSUED	VAR­CHAR2	1	Optional		From Issued Bal­ances. 1-Yes,0-No,2-Both
CERTREQD	VAR­CHAR2	1	Optional		Certificate Required? 1-Yes , 0-No
SINGLECERT	VAR­CHAR2	1	Optional		Single Certificate? 1-Yes , 0-No
MINHOLDCH­KREQ	NUM­BER	1	Mandatory		Minimum Holding Check Required? 1-Yes , 0-No
FROMFUND­PRICEBASIS	VAR­CHAR2	10	Optional		Price Basis
CONTRIBU­TIONPERCENT­AGE	NUM­BER	5	Optional		Contribution Percent­age
CONTRIBU­TIONAMOUNT	NUM­BER	30	Optional		Contribution Amount

2.4.6 SI Certificate related Information

Serial Number: 6

Segment Identification Number: 05CRT

Description: This segment is used for providing SI Certificate related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Mandatory
SEQUENCE­NUMBER	NUM­BER	10	Mandatory		Sequence Number
PROCESSID	VAR­CHAR2	50	Optional		Process ID
BULKCLIENT­CODE	VAR­CHAR2	12	Optional		Bulk Client Code
IMPORTFILE­NAME	VAR­CHAR2	255	Optional		Import file Name
AMCID	VAR­CHAR2	12	Optional		AMC ID
UPLOADMODE	VAR­CHAR2	1	Optional		Uplaod Mode
TRANSACTION­NUMBER	VAR­CHAR2	16	Optional		Transaction Num­ber
REFERENCE­NUMBER	VAR­CHAR2	16	Optional		Reference Number
CERTIFICATE­NUMBER	NUM­BER	10	Mandatory		Certificate Number
NOOFUNITS	NUM­BER	27	Optional		Number of Units

2.5 Income Distribution Setup File Format

Segment Identification Number	Description	Segment Mandatory / Optional?
00IDI	This segment is used for providing Income Distribution related Informa­tion	Mandatory
00IDR	This segment is used for providing Income Distribution Reinvestment related Information	Mandatory

2.5.1 Income Distribution related Information

Serial Number: 1

Segment Identification Number: 00IDI

Description: This segment is used for providing Income Distribution related Information

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Manda­tory		Segment ID - 00IDI
SEQUENCENUM­BER	NUM­BER	10	Manda­tory		Sequence Number
PROCESSID	VAR­CHAR2	50	Manda­tory		Process ID
BULKCLIENT­CODE	VAR­CHAR2	12	Manda­tory		Bulk Client Code
IMPORTFILENAME	VAR­CHAR2	255	Manda­tory		Import File Name
AMCID	VAR­CHAR2	12	Manda­tory		Upload Mode
UPLOADMODE	VAR­CHAR2	1	Optional		AMC ID
REFUNITHOLDE­RID	VAR­CHAR2	12	Optional		Reference Unit Holder ID
FUNDID	VAR­CHAR2	25	Manda­tory		Fund Id
DISTRIBUTION­MODE	VAR­CHAR2	1	Manda­tory		Distribution Mode.P-Full Payment,R-Full Reinvestment,B-Both
PAYMENTSPLIT­PERCENTAGE	NUM­BER	5	Optional		Payment Percent­age
CHEQUEPAY­MENTSPLIT	NUM­BER	5	Optional		Cheque Payment Split Percentage
TRANSFERPAY­MENTSPLIT	NUM­BER	5	Optional		Transfer Payment Split Percentage
XFERBANKCODE	VAR­CHAR2	12	Optional		Transfer Bank Code
XFERBRANCH­CODE	VAR­CHAR2	12	Optional		Transfer Branch Code
XFERACCOUNT­TYPE	VAR­CHAR2	1	Optional		Transfer Account Type
XFERACCOUNT­NUMBER	VAR­CHAR2	16	Manda­tory	Required if Pay­ment SplitPer­centage > 0 and Payment by Trans­fer	Transfer Account Number
XFERACCOUNT­CURRENCY	VAR­CHAR2	3	Optional		Transfer Account Currency
AGENTCODE	VAR­CHAR2	12	Manda­tory		Agent Code
BRANCHCODE	VAR­CHAR2	12	Manda­tory		Branch Code
RULEEFFECTIVE­DATE	DATE	7	Manda­tory		Rule Effective Date
MAKER_ID	VAR­CHAR2	15	Optional		Maker Id
MAK­ER_DT_STAMP	DATE	7	Optional		Maker Date Stamp
CHECKER_ID	VAR­CHAR2	15	Optional		Checker IdThis field will be ignored. Always maker id in the template will be considered to update the checker id in the system.
CHECK­ER_DT_STAMP	DATE	7	Optional		Checker Date Stamp
AUTH_STAT	VAR­CHAR2	1	Optional		Authorization Sta­tus.A-Authorized,U-Unauthorized
PAYMENTMODE	VAR­CHAR2	1	Optional		Payment Mode.Q-Cheque-Cheque,T-Transfer-Transfer
SUBPAYMENT­MODE	VAR­CHAR2	2	Optional		Subpayment Mode.Q-Cheque-Cheque,T-Transfer-Transfer
PAYMENTTYPE	VAR­CHAR2	1	Optional		Payment Type.S-Self,T-Third Party,E-Entity
THIRDPARTYPAY­MENTREFER­ENCE	VAR­CHAR2	255	Optional		Third Party Refer­ence
THIRDPARTYPAY­MENTADDRESS	VAR­CHAR2	255	Optional		Third Party Pay­ment Address
THIRDPARTYPAY­MENTCITY	VAR­CHAR2	20	Optional		Third Party Pay­ment City
THIRDPARTYPAY­MENTSTATE	VAR­CHAR2	20	Optional		US State/ Non-US State
USSTATE	NUM­BER	1	Optional		US State.1-Yes,0-No
THIRDPARTYPAY­MENTZIPCODE	VAR­CHAR2	10	Optional		Third Party Pay­ment Zip Code
XFERAC­COUNTHOLDER­NAME	VAR­CHAR2	100	Manda­tory	Required if Pay­ment SplitPer­centage > 0 and Payment by Trans­fer	Transfer Account Holder Name
ENTITYTYPE	VAR­CHAR2	1	Optional		Entity Type.B-Broker
ENTITYID	VAR­CHAR2	12	Optional		Entity ID
REFFUNDID	VAR­CHAR2	6	Manda­tory		Reference Fund ID
IDSENTITYTYPE	VAR­CHAR2	1	Manda­tory		Unit Holder Or Bro­ker. U-Unitholder,B-Broker
IDSENTITYID	VAR­CHAR2	12	Optional		Unitholder Id Or Bro­ker Code
SWIFTFORMAT	VAR­CHAR2	6	Optional		Swift Format
BANKCHARGED	VAR­CHAR2	12	Optional		Bank Charged
BENEFICIARY	VAR­CHAR2	35	Optional		Beneficiary
BENEFICIARY­ADD1	VAR­CHAR2	35	Optional		Beneficiary Address1
BENEFICIARY­ADD2	VAR­CHAR2	35	Optional		Beneficiary Address2
BENEFICIARY­ADD3	VAR­CHAR2	35	Optional		Beneficiary Address3
BENEFICIARYBIC­CODE	VAR­CHAR2	24	Optional		Beneficiary BIC Code
BENEFICIAR­YACCTNO	VAR­CHAR2	24	Optional		Beneficiary Account No
BENEFICIARY­CODE	VAR­CHAR2	24	Optional		Beneficiary Code
BENEFICIARY­INFO	VAR­CHAR2	100	Optional		Beneficiary Info
INTERMEDIARY	VAR­CHAR2	35	Optional		Intermediary
INTERMEDIARY­ADD1	VAR­CHAR2	35	Optional		Intermediary Address1
INTERMEDIARY­ADD2	VAR­CHAR2	35	Optional		Intermediary Address2
INTERMEDIARY­ADD3	VAR­CHAR2	35	Optional		Intermediary Address3
INTERMEDIARY­BICCODE	VAR­CHAR2	24	Optional		Intermediary BIC Code
INTERMEDIAR­YACCTNO	VAR­CHAR2	24	Optional		Intermediary Account No
INTERMEDIARY­CODE	VAR­CHAR2	24	Optional		Intermediary Code
INTERMEDIARY­INFO	VAR­CHAR2	100	Optional		Intermediary Info
FURTHERCREDIT­NAME	VAR­CHAR2	35	Optional		Further Credit Name
FURTHERCRED­ITACCTNO	VAR­CHAR2	35	Optional		Further Credit Account Number
REFERENCE1	VAR­CHAR2	35	Optional		Reference1
REFERENCE2	VAR­CHAR2	35	Optional		Reference2
POLICYNUMBER	VAR­CHAR2	16	Optional		Policy Number
PRODUCTID	VAR­CHAR2	10	Optional		Product ID
PAYMENTCUR­RENCY	VAR­CHAR2	3	Optional		Payment Currency
IBAN	VAR­CHAR2	40	Optional		IBAN
BENEFICIARY­IBAN	VAR­CHAR2	40	Optional		Beneficiary IBAN
INTERMEDIARY­IBAN	VAR­CHAR2	40	Optional		Intermediary IBAN

2.5.2 Income Distribution Reinvestment related Information

Serial Number: 2

Segment Identification Number: 00IDR

Description: This segment is used for providing Income Distribution Reinvestment related Information

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Manda­tory		Segment ID - 00IDR
SEQUENCENUM­BER	NUM­BER	10	Optional		Sequence Number
PROCESSID	VAR­CHAR2	50	Optional		Process ID
FUNDID	VAR­CHAR2	6	Manda­tory		Fund id
REINVESTMEN­TUNITHOLDERID	VAR­CHAR2	12	Manda­tory		Unitholder Id
REINVESTMENT­FUNDID	VAR­CHAR2	6	Manda­tory		TO Fund id
SPLITPERCENT­AGE	NUM­BER	5	Manda­tory		Split Percentage
RULEEFFECTIVE­DATE	DATE	20	Optional		Rule Effective date
IDSENTITYTYPE	VAR­CHAR2	1	Manda­tory		Unit Holder Or Bro­ker. U-Unitholder,B-Broker
IDSENTITYID	VAR­CHAR2	12	Manda­tory		Unitholder Id Or Bro­ker Code
POLICYNUMBER	VAR­CHAR2	16	Optional		Policy Number
PRODUCTID	VAR­CHAR2	10	Optional		Product ID

2.6 Fund Price File Format

Segment Identification Number	Description	Segment Mandatory / Optional?
00FPI	This segment is used for providing Fund Price related Information	Mandatory
01FBP	This segment is used for providing Fund Price Base Price Constant related Information	Optional
02FCT	This segment is used for providing Fund Price Components related Information	Optional
03FAI	This segment is used for providing Fund Price Addi­tional Information related Information	Optional

2.6.1 Fund Price related Information

Serial Number: 1

Segment Identification Number: 00FPI

Description: This segment is used for providing Fund Price related Information

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Manda­tory		Segment ID.Value shoule be 00FPI
SEQUENCE­NUMBER	NUMBER	22	Manda­tory		Sequence Number
PROCESSID	VAR­CHAR2	50	Manda­tory		Process ID
BULKCLI­ENTCODE	VAR­CHAR2	12	Manda­tory		Bulk Client Code
IMPORT­FILENAME	VAR­CHAR2	255	Manda­tory		Import File Name
AMCID	VAR­CHAR2	12	Manda­tory		AMC ID
FUNDID	VAR­CHAR2	25	Manda­tory		Fund ID
EFFECTIVE­DATE	DATE	10	Optional		Rule Effective Date
REALNAVPE­RUNIT	NUMBER	17	Optional		Real NAV per Unit
FLOOR­PRICE	NUMBER	17	Optional		Floor Price
CEILING­PRICE	NUMBER	17	Optional		Ceiling Price
DECLARED­NAV	NUMBER	17	Optional		Declared NAV
LATEST­PRICE	NUMBER	1	Optional		Latest Price
EUROE­QUIVA­LENTOFNAV	NUMBER	24	Optional		Euro Equivalent of NAV
AMENDTXN­FLAG	NUMBER	10	Optional		Amend Transaction Flag
HURDLER­ATE	NUMBER	10	Optional		Hurdle Rate
HWMPLUSH­URDLE	NUMBER	27	Optional		HWM + Hurdle
MAKER_ID	VAR­CHAR2	15	Manda­tory		It shows the name of the user who has created or modified the specific record
MAK­ER_DT_STAMP	DATE	10	Optional		This field specifies the date and time at which this record was created or modified. It is defaulted by system and will be in date format
CHECK­ER_ID	VAR­CHAR2	15	Optional		This field will be ignored. Always maker id in the template will be considered to update the checker id in the system.
CHECK­ER_DT_STAMP	DATE	10	Optional		This field specifies the date and time at which this record was authorized is displayed in this field. It is defaulted by system and will be in date format
UPLOAD­MODE	VAR­CHAR2	1	Manda­tory		Operation mode which will be performed on the Upload records. It can have N-New,D-Delete,A-Auth & E- Modify

2.6.2 Fund Price Base Price Constant related Information

Serial Number: 2

Segment Identification Number: 01FBP

Description: This segment is used for providing Fund Price Base Price Constant related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Manda­tory		Segment ID.Value should be 02FCT
SEQUENCE­NUMBER	NUMBER	10	Manda­tory		Sequence Number
PROCESSID	VAR­CHAR2	50	Manda­tory		Process ID
COMPONEN­TID	VAR­CHAR2	10	Optional		Component ID
COMPO­NENTVALUE	NUMBER	30	Optional		Component Value

2.6.3 Fund Price Additional Information related Information

Segment Identification Number: 03FAI

Description: This segment is used for providing Fund Price Additional Information related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Manda­tory		Segment ID.Value shoule be 03FAI
SEQUENCE­NUMBER	NUMBER	10	Manda­tory		Sequence Number
PROCESSID	VAR­CHAR2	50	Manda­tory		Process ID
ADDINFOLA­BEL	VAR­CHAR2	30	Optional		Add Information Label
FIELDVALUE	CHAR	23	Optional		Field Value

2.7 Broker File Format

Segment Identification Number	Description	Segment Mandatory / Optional?
00BRO	This segment is used for providing Broker Upload related Information	Mandatory
01CON	This segment is used for providing Broker Con­tact Information related Information	Optional
02BAN	This segment is used for providing Brokers Bank Information related details	Optional
03LEG	This segment is used for providing Brokers Leg­acy related Information	Optional
04PRE	This segment is used for providing Brokers Pref­erence related Information	Optional
05ADD	This segment is used for providing Broker Addi­tional Information related details	Optional

2.7.1 Broker Upload related Information

Serial Number: 1

Segment Identification Number: 00BRO

Description: This segment is used for providing Broker Upload related Information

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMEN­TID	VAR­CHAR2	20	Manda­tory		Segment Id. Value for Segment id is 00BRO
SEQUEN­CENUMBER	NUM­BER	10	Manda­tory		Sequence Number
PROCESSID	VAR­CHAR2	50	Manda­tory		Process ID
BULKCLI­ENTCODE	VAR­CHAR2	12	Manda­tory	Value defaulted as maintained in Bulk client defaults in the absence of informa­tion in the file	Bulk Client Code
IMPORT­FILENAME	VAR­CHAR2	255	Manda­tory		Import File Name
UPLOAD­MODE	VAR­CHAR2	1	Manda­tory		Mode of operation which has to be per­formed on the record
BROKER­CODE	VAR­CHAR2	12	Manda­tory		The code to uniquely identify the broker.
BROKER­NAME	VAR­CHAR2	105	Manda­tory		Name of the broker
PARENT­BROKER­CODE	VAR­CHAR2	12	Manda­tory		Represents the parent of the broker. The commission received by the broker is shared with this par­ent
BROKERBA­SECCY	VAR­CHAR2	3	Manda­tory	Value defaulted as maintained in Bulk client defaults in the absence of informa­tion in the file	Represents the base currency of the bro­ker. Tax and other calculations are done based on this cur­rency
AMCID	VAR­CHAR2	12	Manda­tory	Value defaulted as maintained in Bulk client defaults in the absence of informa­tion in the file	AMC ID
DELETED­STATUS	NUM­BER	1	Manda­tory	Value defaulted as maintained in Bulk client defaults in the absence of informa­tion in the file	Flag to identify whether the broker record is in any of these states 1-active or 0-closed or 2-pend­ing closure state
OVERRID­DENTAX­PERCENTAGE	NUM­BER	156	Manda­tory		The tax percentage applicable for the bro­ker can be overridden here
MAKER_ID	VAR­CHAR2	15	Manda­tory		Represents the user id who has entered the latest record.
MAK­ER_DT_STAMP	DATE	10	Manda­tory		Represents the time when the record is created
LEVELNUM­BER	NUM­BER	3	Optional		Represents at which level the broker is in the parent broker hierarchy. The top parent will have level number 0
RULEEF­FECTIVE­DATE	DATE	10	Manda­tory		The date from which the changes are appli­cable. This along with broker code forms the PRIMARY KEY
CHANGETYPE	VAR­CHAR2	1	Optional		This column is not used
VATREGIS­TERED	NUM­BER	1	Manda­tory	Value defaulted as maintained in Bulk client defaults in the absence of informa­tion in the file	Represents whether the broker is VAT Registered broker or not. If the broker is VAT registered then VAT will be applicable on the commission amount he gets
VATREGIS­TRATION­NUMBER	VAR­CHAR2	15	Manda­tory		Represents the VAT Registration number of the broker
COMMIS­SIONPER­CENTAGE	NUM­BER	52	Manda­tory	Value defaulted as maintained in Bulk client defaults in the absence of informa­tion in the file	Represents how much percentage commission should be shared with his parent broker. If the broker is the top level broker then this value should be 100
COMMIS­SIONPAY­MENTFREQ	VAR­CHAR2	1	Manda­tory	Value defaulted as maintained in Bulk client defaults in the absence of informa­tion in the file	Indicates at what fre­quency the commis­sion should be paid to the broker.
UNITHOLD­ERID	VAR­CHAR2	12	Manda­tory		Represents the default unit holder of the broker
NEXTPAY­MENTDATE	DATE	10	Manda­tory		Indicates the next payment date of the broker. Commission accumulated from last payment date to till this date will be paid on this date
CHECK­ER_ID	VAR­CHAR2	15	Manda­tory		This field will be ignored. Always maker id in the tem­plate will be consid­ered to update the checker id in the sys­tem.
CHECK­ER_DT_STAMP	DATE	10	Manda­tory		Represents the time when it was Author­ized.
BROKER­TYPE	VAR­CHAR2	6	Manda­tory	Value defaulted as maintained in Bulk client defaults in the absence of informa­tion in the file	Represents the type of the broker; user can define broker type throught broker type maintenance
USEBRO­KERTYPE­PAYMENTDATES	NUM­BER	1	Manda­tory	Value defaulted as maintained in Bulk client defaults in the absence of informa­tion in the file	Flag to identify whether the payment details based in the broker type mainte­nance or not
BROKER­CONSULT­ANT	VAR­CHAR2	40	Manda­tory	Value defaulted as maintained in Bulk client defaults in the absence of informa­tion in the file	Represents broker consultant name
BROKER­CATEGORY	VAR­CHAR2	1	Manda­tory		Represents the cate­gory of the broker, whether Individual or Corporate
HOLDBACK­PAYMENT	NUM­BER	1	Manda­tory		Flag to identify whether the payment should be kept hold for the broker
MOD_NO	NUM­BER	10	Optional		Represents the num­ber of times the record got modified
HOLDPYMT­FROMDATE	DATE	10	Manda­tory		Represents the pay­ment hold back from date
BROKER­STATUS	VAR­CHAR2	1	Manda­tory		Represents whether the broker is in normal or weeded status
REPLICATE­PARENT­DET	CHAR	1	Manda­tory		Flag to identify whether the details of the parent broker should be replicated or not. If this is true then the parent bro­kers data will be defaulted based on the template main­tained
VATREGIS­TRATION­DATE	DATE	10	Manda­tory		Represents from when the broker got VAT registered
TEM­PLATEID	VAR­CHAR2	6	Manda­tory		Represents the tem­plate id to replicate the parent details, the fields available in tem­plate will be replicated to child broker if REPLICATEPARENT­DET flag is set to true
NATIONAL­ITY	VAR­CHAR2	3	Manda­tory		Nationality of the bro­ker
COUNTRY­OFBIRTH	VAR­CHAR2	3	Manda­tory		Birth country of the broker
COUNTRY­OFDOMI­CILE	VAR­CHAR2	3	Manda­tory		Country of domicile of the broker
INCORPO­RATION­COUNTRY	VAR­CHAR2	3	Manda­tory		The country of the corporate
TAXID	VAR­CHAR2	50	Manda­tory		Tax identification
EIN	VAR­CHAR2	50	Manda­tory		Employer ID number
TAXCERTIF­ICATEEFFE­DATE	DATE	10	Manda­tory		Tax certificate effec­tive Date
TAXCERTIF­ICATEEXP­DATE	DATE	10	Manda­tory		Tax certificate expiry Date
TAXCIRCLE	VAR­CHAR2	3	Manda­tory		Name of the Place.
VATEXPIRY­DATE	DATE	10	Optional		Represents the expiry date for VAT regis­tered flag

2.7.2 Broker Contact Information related Information

Serial Number: 2

Segment Identification Number: 01CON

Description: This segment is used for providing Broker Contact Information related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMEN­TID	VAR­CHAR2	20	Manda­tory		Segment Id. Value for Segment id is 01CON
SEQUEN­CENUMBER	NUM­BER	10	Manda­tory		Sequence Number
PROCESSID	VAR­CHAR2	50	Manda­tory		Process ID
ADDRESSTYPE	VAR­CHAR2	2	Manda­tory		Represents the Addresstype
ADDRESS­LINE1	VAR­CHAR2	80	Manda­tory		Represents the Address­line1
ADDRESS­LINE2	VAR­CHAR2	80	Optional		Represents the Address­line2
ADDRESS­LINE3	VAR­CHAR2	80	Optional		Represents the Address­line3
ADDRESS­LINE4	VAR­CHAR2	80	Optional		Represents the Address­line4
ZIPCODE	VAR­CHAR2	10	Manda­tory		Represents the Zipcode
COUNTRY	VAR­CHAR2	3	Manda­tory		Represents the Country
USSTATE	NUM­BER	1	Manda­tory		Represents the US state
TELE­PHONE1	VAR­CHAR2	15	Manda­tory		Represents the Tele­phone1
TELE­PHONE2	VAR­CHAR2	15	Manda­tory		Represents the Tele­phone2
CELL­PHONE­NUMBER	VAR­CHAR2	16	Manda­tory		Represents the Cellphone number
FAX	VAR­CHAR2	15	Manda­tory		Represents the Fax Num­ber
EMAIL	VAR­CHAR2	60	Manda­tory		Represents the Email ID
CONTACT­PERSON	VAR­CHAR2	70	Manda­tory		Represents the Contact person
EFFECTIVE­FROMDATE	DATE	10	Manda­tory		Represents the Effective from date
EFFEC­TIVETO­DATE	DATE	10	Manda­tory		Represents the Effective to date
BICCODE	VAR­CHAR2	12	Manda­tory		Represents the Bic code
INTDIAL­LINGCODE­FAX	VAR­CHAR2	10	Manda­tory		International dialling code for FAX
INTDIAL­LINGCO­DEPH2	VAR­CHAR2	10	Manda­tory		International dialling code for telephone number 2
INTDIAL­LINGCO­DEPH1	VAR­CHAR2	10	Manda­tory		International dialling code for telephone number 1
INTDIAL­LINGCODE­CELL	VAR­CHAR2	10	Manda­tory		International dialling code for cellphone number

2.7.3 Brokers Bank Information related details

Serial Number: 3

Segment Identification Number: 02BAN

Description: This segment is used for providing Brokers Bank Information related details

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMEN­TID	VAR­CHAR2	20	Mandatory		Segment Id. Value for Segment id is 02BAN
SEQUEN­CENUMBER	NUM­BER	10	Mandatory		Sequence Number
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
BANKCODE	VAR­CHAR2	12	Mandatory		Indicates the Bank code.
BRANCH­CODE	VAR­CHAR2	12	Mandatory		Indicates the Branch code.
ACCOUNT­TYPE	VAR­CHAR2	1	Mandatory		Indicates Type of the account.
ACCOUNT­NUMBER	VAR­CHAR2	16	Mandatory		Indicates the Unique account number.
ACCOUNT­NAME	VAR­CHAR2	100	Mandatory		Indicates the Account holders name.
ACCOUNT­CURRENCY	VAR­CHAR2	3	Mandatory		Indicates the currency in which the account is maintained.
DEFAULT­DETAILS	NUM­BER	1	Mandatory		This Flag decides whether its default account to be used for this currency.Manda­tory to give "YES" for anyone record of each currency.
DIRECT­DEBITAP­PLICABLE	NUM­BER	1	Mandatory		This Flag decides whether direct debit is applicable for this account or not.
IBAN	VAR­CHAR2	40	Mandatory		Indicates the IBAN number of the bank.

2.7.4 Brokers Legacy related Information

Serial Number: 4

Segment Identification Number: 03LEG

Description: This segment is used for providing Brokers Legacy related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMEN­TID	VAR­CHAR2	20	Mandatory		Segment Id. Value for Segment id is 03LEG
SEQUEN­CENUMBER	NUM­BER	10	Mandatory		Sequence Number
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
BROKER­LEGACY­CODE	VAR­CHAR2	12	Mandatory		Indicates the legacy code mapped to the bro­ker

2.7.5 Broker Preference Information related details

Serial Number: 5

Segment Identification Number: 04PRE

Description: This segment is used for providing Broker Preference related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Manda­tory		Segment Id. Value for Segment id is 04PRE
SEQUENCE­NUMBER	NUM­BER	10	Manda­tory		Sequence Number
PROCESSID	VAR­CHAR2	50	Manda­tory		Process ID
FEEDTYPE	VAR­CHAR2	20	Manda­tory		Represents the FEED type preference for broker
FEEDSTRUCT	VAR­CHAR2	4	Manda­tory		Represents the FEED sttucture for the feed type
FEEDSTART­DATE	DATE	10	Manda­tory		Indicates the start date of FEED mainte­nance
FEEDFRE­QUENCY	VAR­CHAR2	20	Manda­tory		Indicates the fre­quency of FEED maintenance
FEEDFORMAT	VAR­CHAR2	6	Manda­tory		Indicates the format of FEED for broker

2.7.6 Broker Additional Information related details

Serial Number: 6

Segment Identification Number: 05ADD

Description: This segment is used for providing Broker Additional Information related details

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMEN­TID	VAR­CHAR2	20	Mandatory		Segment Id.Value for Seg­ment id is 05ADD
SEQUEN­CENUMBER	NUM­BER	10	Mandatory		Sequence Number
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
OTHERIN­FOFIELD	VAR­CHAR2	100	Mandatory		Indicates the additional field name.
FIELD­VALUE	VAR­CHAR2	60	Mandatory		Indicates the additional field informations.

2.8 Unit Holder Deal File Format

Segment Identification Number	Description	Segment Mandatory / Optional?
00UHD	This segment is used for providing UnitHolder Deal related Information	Mandatory
01ULD	This segment is used for providing UnitHolder Deal Load related Information	Optional
02UDL	This segment is used for providing UnitHolder Deal Derived Load related Information	Optional

2.8.1 UnitHolder Deal related Information

Serial Number: 1

Segment Identification Number: 00UHD

Description: This segment is used for providing UnitHolder Deal related Information

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMEN­TID	VAR­CHAR2	80	Mandatory		Segment ID. Value for Segment id is 00UHD
SEQUEN­CENUMBER	NUM­BER	10	Mandatory		Sequence Number
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
BULKCLI­ENTCODE	VAR­CHAR2	12	Mandatory		Bulk Client Code
IMPORT­FILENAME	VAR­CHAR2	255	Mandatory		Import File Name
UPLOAD­MODE	VAR­CHAR2	1	Optional		Upload Mode
AMCID	VAR­CHAR2	12	Mandatory		AMC ID
DEAL­TRANSAC­TIONNUMBER	VAR­CHAR2	16	Optional		UH Deal Transaction Number
UHIDORCIF­NUMBER	VAR­CHAR2	12	Mandatory		Unit Holder ID / CIF Num­ber
APPLYATCI­FLEVEL	NUM­BER	1	Optional		Apply At CIF Level.1-Yes,0-No
APPLYDEALAT	VAR­CHAR2	1	Mandatory		Apply Deal At.L-Load Level,G-Load Group Level,F-Fund Level,P-Product Level
STATUS	VAR­CHAR2	1	Mandatory		Status
EFFECTIVE­STARTDATE	DATE	7	Mandatory		Effective Start Date
EFFEC­TIVEEND­DATE	DATE	7	Optional		Effective End Date
AUTH_STAT	VAR­CHAR2	1	Mandatory		Authorization Status.A-Authorized,U-Unauthor­ized.
LOAD­GROUPID	VAR­CHAR2	16	Optional		Load Group Id
FUNDID	VAR­CHAR2	6	Optional		Fund ID
LOADID	NUM­BER	5	Mandatory		Load Id
APPLYRET­VALUE­TOALLSLABS	NUM­BER	1	Optional		Value for the return values are changed as in the excel only if the value for APPLYRETVALUE­TOALLSLABS is '1'.
RETURN­VALUE	VAR­CHAR2	30	Optional		Return Value
PRODUC­TID	VAR­CHAR2	10	Optional		Product Id
MAKER_ID	VAR­CHAR2	15	Optional		Maker ID
MAK­ER_DT_STAMP	DATE	7	Optional		Maker Date Stamp
POLICY­NUMBER	VAR­CHAR2	16	Optional		Policy Number
DEALBASE­DON	VAR­CHAR2	1	Optional		Deal Based On
TAXTYPE	VAR­CHAR2	1	Optional		Tax Type.D-Directive,I-Instruction

2.8.2 UnitHolder Deal Load related Information

Serial Number: 2

Segment Identification Number: 01ULD

Description: This segment is used for providing UnitHolder Deal Load related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Manda­tory		Segment ID. Value for Segment id is 01ULD
SEQUENCE­NUMBER	NUMBER	10	Manda­tory		Sequence Number
PROCESSID	VAR­CHAR2	50	Manda­tory		Process ID
SLABSEQNO	NUMBER	5	Manda­tory		Slab Sequence Num­ber
OVERRIDE­VALUE	NUMBER	30	Manda­tory		Override Value

2.8.3 UnitHolder Deal Derived Load related Information

Serial Number: 3

Segment Identification Number: 02UDL

Description: This segment is used for providing UnitHolder Deal Derived Load related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	80	Mandatory		Segment ID. Value for Segment id is 02UDL
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Sequence Number
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
LOADID	VAR­CHAR2	6	Mandatory		Load Id
OVERRIDE­VALUE	NUMBER	30	Mandatory		Override Value

2.9 Policy Transaction Upload Format

Segment Identification Number	Description	Segment Mandatory / Optional?
00PTN	This segment is used for providing information related to policy transactions that is to be uploaded into the system	Mandatory
01BRK	This segment is used for providing information related to brokers involved in the policy transac­tions	Mandatory
02FDR	This segment is used for providing information related to transaction fund ratio that is to be uploaded into the system.	Mandatory
03SET	This segment is used for providing Policy Trans­action Settlement related Information	Optional
04SFR	This segment is used for providing Policy Switch Asset Allocation related Information	Mandatory for Switch transac­tions
05FOI	This segment is used for providing Policy Trans­action Load Override related Information	Optional
06DFO	This segment is used for providing Policy Trans­action Derived Load Override related Informa­tion	Optional

2.9.1 Policy Transactions related Information

Serial Number: 1

Segment Identification Number: 00PTN

Description: This segment is used for providing information related to policy transactions that is to be uploaded into the system

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VARCHAR2	20	Mandatory		Segment ID - 00PTN
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Sequence Number
PROCESSID	VARCHAR2	50	Mandatory		Process ID
BULKCLIENT­CODE	VARCHAR2	12	Mandatory		Bulk Client Code
IMPORTFILE­NAME	VARCHAR2	255	Mandatory		Import File Name
UPLOAD­MODE	VARCHAR2	1	Mandatory		Upload Mode
AMCID	VARCHAR2	12	Mandatory		AMC ID
POLICYTXN­NUMBER	VARCHAR2	16	Mandatory		Policy Transaction Number
POLICYNUM­BER	VARCHAR2	16	Mandatory		Policy Reference Number
TXNREFER­ENCENUM­BER	VARCHAR2	16	Optional		Transaction Refer­ence Number
TXNTYPE	VARCHAR2	2	Mandatory		Transaction Type
TXNDATE	DATE	7	Mandatory		Transaction Date
TXNINPUT­DATE	DATE	7	Optional		Transaction Input Date
TXNAMT	NUMBER	15	Mandatory		Transaction Amount
NETAMT	NUMBER	15	Optional		Net Amount
TXNBASECCY	VARCHAR2	3	Optional		Transaction base currency
TXNGENFLAG	NUMBER	1	Optional		Transaction Gener­ated Flag
TXNRE­MARKS	VARCHAR2	255	Optional		Transaction Remarks
MAKER_ID	VARCHAR2	15	Optional		Maker Id
MAK­ER_DT_STAMP	DATE	7	Optional		Maker date stamp
CHECKER_ID	VARCHAR2	15	Optional		This field will be ignored. Always maker id in the tem­plate will be consid­ered to update the checker id in the system.
CHECK­ER_DT_STAMP	DATE	7	Optional		Cheker date stamp
LASTMODI­FIEDUSERID	VARCHAR2	15	Optional		Last Modified User ID
LASTMODI­FIEDUSER­DATE	DATE	7	Optional		Last Modified User Date
MOD_NO	NUMBER	38	Optional		Modification Num­ber
AUTH_STAT	VARCHAR2	1	Mandatory		Authorisation Sta­tus. A-Author­ized,U-Unauthorized
AGENTCODE	VARCHAR2	12	Mandatory		Agent Code
BRANCH­CODE	VARCHAR2	12	Mandatory		Branch Code
DRAWEE­BANKCODE	VARCHAR2	12	Optional		Drawee Bank Code
TRANSFER­BRANCH­CODE	VARCHAR2	12	Optional		Transfer Branch Code
TRANSFER­ACCOUNT­TYPE	VARCHAR2	1	Optional		Transfer Account Type
TRANSFER­ACCOUNT­NUMBER	VARCHAR2	16	Optional		Transfer Account Number
TRANSFER­ACCOUNT­CURRENCY	VARCHAR2	3	Optional		Transfer Account Currency
PAYMENT­MODE	VARCHAR2	1	Optional		Payment Mode
CHEQUE­NUMBER	VARCHAR2	16	Optional		Cheque Number
CHEQUE­DATE	DATE	7	Optional		Cheque Date
CLEARING­DATE	DATE	7	Optional		Clearing Date
CLEARING­STATUS	VARCHAR2	3	Optional		Clearing Status
PRODUCTID	VARCHAR2	10	Optional		Product ID
POLICYHOLD­ERID	VARCHAR2	12	Optional		Policy Holder ID
POLI­CYTRANSAC­TIONMODE	VARCHAR2	1	Mandatory		Policy Transaction Mode.A -Amount,U-Units,P-Percent
ALLOTTED­FLAG	NUMBER	1	Optional		Alloted Flag
TOPUPINCLU­SIVE	NUMBER	1	Optional		Top up Inclusive Flag.0 -No,1-Yes
SYNCFLAG	NUMBER	1	Optional		Sync Flag
ACKNOWL­EDGEMENT­PRINTED	NUMBER	1	Optional		Acknowledgement Printed
TRANSFER­ORID	VARCHAR2	12	Optional		Transfer Order ID
PERCENT­AGEAPPLIED	NUMBER	5	Optional		Percentage Applied
OLDPOLI­CYTXNNUM­BER	VARCHAR2	16	Optional		Old Policy Txn number
NETIN­VESTIBLEA­MOUNT	NUMBER	15	Optional		Net Investible Amount
MODULEID	VARCHAR2	30	Mandatory		Module ID
ADJUST­MENTTXN­TYPE	VARCHAR2	3	Optional		Adjustment Trans­action Type
PORTFOLI­OSWITCH	NUMBER	1	Optional		Port Folio Switch
SURRENDER­MONEYPAYA­BLE	VARCHAR2	1	Mandatory		Surrender Money Payable
FUNDING­PERCENT­AGE	NUMBER	5	Optional		Funding Percent­age
CAN­CELLED_PHASEINID	VARCHAR2	16	Optional		Cancelled Phase In ID
UNITSAP­PLIED	NUMBER	15	Optional		Units Applied
INTERESTA­MOUNT	NUMBER	15	Mandatory		Interest Amount
DATEAL­LOTED	DATE	7	Optional		Date Alloted
GROS­SAMOUNT	NUMBER	22	Optional		Gross Amount
SWITCHIN­GROSSAMT	NUMBER	15	Optional		Switch In Gross Amount
SWITCHINNE­TAMT	NUMBER	15	Optional		Switch In Net Amount
ADJUST­MENTTXN	NUMBER	1	Optional		Adjustment Trans­action
IBAN	VARCHAR2	40	Optional		Internation Bank Account Number
SOURCEID	VARCHAR2	6	Optional		Source ID
EXCHANGER­ATEAPPLIED	NUMBER	24	Optional		Exchange Rate Applied
AMOUNTAP­PLIED	NUMBER	30	Optional		Amount Applied
BALANCE­TRANSFER	NUMBER	1	Optional		Balance transfer
OVERRIDE­EXCHANGER­ATE	VARCHAR2	1	Optional		Override Exchange Rate
INTAMTINTX­NCCY	NUMBER	30	Optional		Initial amount in Transaction cur­rency
INCLUDE_IN­TER­EST_IN_INVESTMENT	VARCHAR2	1	Optional		Include Interest In Investment
FXDEALDATE	DATE	7	Optional		FX Deal Date
FXVALUE­DATE	DATE	7	Optional		FX Value Date
EXCHANGER­ATESTATUS	VARCHAR2	1	Optional		Exchange Rate Sta­tus

2.9.2 Policy Transactions related to Brokers Information

Serial Number: 2

Segment Identification Number: 01BRK

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	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VARCHAR2	20	Mandatory		Segment ID - 01BRK
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Sequence Number
PROCESSID	VARCHAR2	50	Mandatory		Process ID
POLICYTXN­NUMBER	VARCHAR2	16	Mandatory		Policy Transaction Number
BROKER­CODE	VARCHAR2	9	Optional		Broker Code
SPLITPER­CENTAGE	NUMBER	5	Mandatory		Split Percentage

2.9.3 Information related to Transaction Fund Ratio

Serial Number: 3

Segment Identification Number: 02FDR

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 Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VARCHAR2	20	Mandatory		Segment ID - 02FDR
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Sequence Number
PROCESSID	VARCHAR2	50	Mandatory		Process ID
POLICYTXN­NUMBER	VARCHAR2	16	Mandatory		Policy Transaction Number
FUNDID	VARCHAR2	6	Mandatory		Fund ID
RATIO	NUMBER	15	Optional		Ratio
TXNAMOUNT	NUMBER	15	Mandatory		Transaction Amount
UNITSAP­PLIED	NUMBER	15	Optional		Units Applied
WAC	NUMBER	15	Optional		Weighted Average Cost
AUTOCLEAR­PROVISION­ALBALANCE	VARCHAR2	1	Mandatory		Auto Clear Provi­sional balance
AUTOCLEAR­REINVEST­MENTS	VARCHAR2	1	Mandatory		Auto Clear Rein­vestments
TXNAMOUNT_IN_TXNCCY	NUMBER	30	Optional		Transaction Amount in Transaction Cur­rency
TRANSAC­TIONCUR­RENCY	VARCHAR2	3	Optional		Transaction Cur­rency
EXCHANGER­ATEAPPLIED	NUMBER	15	Optional		Exchange Rate Applied
OVERRIDE­EXCHANGER­ATE	VARCHAR2	1	Optional		Override Exchange Rate
SOURCEID	VARCHAR2	6	Optional		Source ID
FXDEALDATE	DATE	7	Optional		FX Deal Date
FXVALUE­DATE	DATE	7	Optional		FX Value Date

2.9.4 Policy Transaction Settlement related Information

Serial Number: 4

Segment Identification Number: 03SET

Description: This segment is used for providing Policy Transaction Settlement related Information.

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VARCHAR2	20	Mandatory		Segment ID - 03SET
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Sequence Number
PROCESSID	VARCHAR2	50	Mandatory		Process ID
POLICYTXN­NUMBER	VARCHAR2	16	Mandatory		Policy Transaction Number
PAYMENT­TYPE	VARCHAR2	1	Optional		Payment Type.Self-S,Prod­uct -P,Third Party -T,Beneficiary -B
PAYMENT­MODE	VARCHAR2	1	Optional		Payment Mode ,Cash -C,Cheque -Q,Demand Draft -D,Money Transfer -T
PAYMENTEN­TITY	VARCHAR2	12	Optional		Payment Entity
DRAWEE­BANKCODE	VARCHAR2	12	Optional		Drawee Bank code
TRANSFER­BRANCH­CODE	VARCHAR2	12	Optional		Transfer Branch Code
TRANSFER­ACCOUNT­TYPE	VARCHAR2	1	Optional		Transfer Account Type
TRANSFER­ACCOUNT­NUMBER	VARCHAR2	16	Optional		Transfer Account Number
TRANSFER­ACCOUNT­CURRENCY	VARCHAR2	3	Optional		Transfer Account Currency
CHEQUE­NUMBER	VARCHAR2	16	Optional		Cheque Number
CHEQUE­DATE	VARCHAR2	11	Optional		Cheque Date
CLEARING­DATE	VARCHAR2	11	Optional		Clearing Date
CLEARING­STATUS	VARCHAR2	3	Optional		Clearing Status
RATIO	NUMBER	5	Optional		Ratio
AUTH_STAT	VARCHAR2	1	Mandatory		Authorisation Sta­tus. A-Author­ized,U-Unauthorized
IDENTIFICA­TIONNUMBER	VARCHAR2	15	Optional		Identification Num­ber
CONTACT­NAME	VARCHAR2	100	Optional		Contact Name
ADDRESS­LINE1	VARCHAR2	255	Optional		Address Line 1
ADDRESS­LINE2	VARCHAR2	255	Optional		Address Line 2
TRANSFER­REFNUMBER	VARCHAR2	16	Optional		Transfer Refer­ence Number
IBAN	VARCHAR2	40	Optional		International Bank Account Number
FXDEALDATE	DATE	7	Optional		FX Deal Date
FXVALUE­DATE	DATE	7	Optional		FX Value Date
EXCHANGER­ATEAPPLIED	NUMBER	15	Optional		Exchange Rate Applied
OVERRIDE­EXCHANGER­ATE	VARCHAR2	1	Optional		Override Exchange Rate
SOURCEID	VARCHAR2	6	Optional		Source ID
PAY­MENT_CUR­RENCY	VARCHAR2	3	Optional		Payment Currency
PAYMENT_­DATE	DATE	7	Optional		Payment Date
PAY­MENT_AMOUNT	NUMBER	30	Optional		Payment amount
EXCHANGER­ATESTATUS	VARCHAR2	1	Optional		Exchange Rate Status
INTERE­STRATE	NUMBER	30	Optional		Interest Rate
INTERESTA­MOUNT	NUMBER	30	Optional		Interest Amount
NOOFDAYS	NUMBER	30	Optional		No of Days
BASISDAYS	NUMBER	30	Optional		Basis days
PAY­MENT_AMT_IN_TXNCCY	NUMBER	30	Optional		Payment amount in Transaction cur­rency
INTER­EST_AMT_IN_TXNCCY	NUMBER	30	Optional		Interest Amount in Transaction cur­rency
SEQ_NO	NUMBER	30	Optional		Sequence Number
TRANSFER­ACCOUNTHOLDERNAME	VARCHAR2	100	Optional		Transfer Account holder Name

2.9.5 Policy Transaction Settlement related Information

Serial Number: 5

Segment Identification Number: 04SFR

Description: This segment is used for providing Policy Transaction Settlement related Information.

Segment Mandatory / Optional: Mandatory for Switch Transactions

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VARCHAR2	20	Mandatory		Segment ID - 04SFR
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Sequence Number
PROCESSID	VARCHAR2	50	Mandatory		Process ID
POLICYTXN­NUMBER	VARCHAR2	16	Mandatory		Policy Transaction Number
TOFUNDID	VARCHAR2	6	Mandatory		To Fund ID
RATIO	NUMBER	9	Optional		Ratio

2.9.6 Policy Transaction Load Override related Information

Serial Number: 6

Segment Identification Number: 05FOI

Description: This segment is used for providing Policy Transaction Load Override related Information.

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VARCHAR2	20	Mandatory		Segment ID - 05FOI
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Sequence Number
PROCESSID	VARCHAR2	50	Mandatory		Process ID
POLICYNUM­BER	VARCHAR2	16	Optional		Policy Number
TRANSAC­TIONNUMBER	VARCHAR2	16	Optional		Transaction Num­ber
TRANSAC­TIONDATE	DATE	7	Mandatory		Transaction Date
FUNDID	VARCHAR2	6	Mandatory		Fund ID
POLICYHOLD­ERID	VARCHAR2	12	Optional		Policy Holder ID
LOADID	NUMBER	5	Optional		Load ID
CHANGETYPE	VARCHAR2	1	Optional		Change Type
CHANGEVALUE	NUMBER	15	Optional		Change Value
GROUPID	VARCHAR2	6	Optional		Group ID
AUTH_STAT	VARCHAR2	1	Optional		Auth Stat
TXNTYPE	VARCHAR2	2	Mandatory		Transaction Type
REFTYPE	VARCHAR2	2	Optional		Ref Type

2.9.7 Policy Transaction Derived Load Override related Information

Serial Number: 7

Segment Identification Number: 06DFO

Description: This segment is used for providing Policy Transaction Derived Load Override related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VARCHAR2	20	Optional		Segment ID - 06DFO
SEQUENCE­NUMBER	NUMBER	10	Optional		Sequence Number
PROCESSID	VARCHAR2	50	Optional		Process ID
TRANSAC­TIONNUMBER	VARCHAR2	16	Optional		Transaction Number
TRANSAC­TIONDATE	DATE	7	Optional		Transaction Date
FUNDID	VARCHAR2	6	Optional		Fund ID
POLICYHOLD­ERID	VARCHAR2	12	Optional		Policy Holder ID
DERIVEDLOA­DID	VARCHAR2	6	Optional		Derived Load ID
PARENTLOA­DID	NUMBER	5	Optional		Parent Load ID
CHANGETYPE	VARCHAR2	1	Optional		Change Type
CHANGEVALUE	NUMBER	5	Optional		Change Value
AUTH_STAT	VARCHAR2	1	Optional		Authorisation Status
TXNTYPE	VARCHAR2	2	Optional		Transaction Type
REFTYPE	VARCHAR2	2	Optional		Ref Type

2.10 Cheque Tracking File Format

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules
SEQUENCENUM­BER	NUMBER	10	Mandatory		Sequence Num­ber
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
BULKCLIENT­CODE	VAR­CHAR2	12	Mandatory		Bulk Client Code
IMPORTFILENAME	VAR­CHAR2	255	Mandatory		Import File Name
UPLOADMODE	VAR­CHAR2	1	Mandatory		Mode of opera­tion which has to be performed on the record
AMCID	VAR­CHAR2	12	Mandatory		AMC ID
CHEQUETYPE	VAR­CHAR2	3	Mandatory		Cheque Type
TRANSACTION­NUMBER	VAR­CHAR2	16	Mandatory		Transaction number
FUNDID	VAR­CHAR2	6	Mandatory		Fund Id
PAYMENTNUM­BER	NUMBER	5	Mandatory		Payment Num­ber
UNITHOLDERID	VAR­CHAR2	12	Mandatory		UnitHolder ID
PRODUCTID	VAR­CHAR2	10	Optional		Product ID
CORPORATEAC­TIONTYPE	VAR­CHAR2	1	Optional		Corporate Action Type
CHEQUEAMOUNT	NUMBER	42	Mandatory		Cheque Amount
CHEQUECUR­RENCY	VAR­CHAR2	3	Mandatory		Cheque Cur­rency
CHEQUEDATE	DATE	7	Mandatory		Cheque Date
CHEQUENUMBER	VAR­CHAR2	16	Mandatory		Cheque Num­ber
OLDCHEQUE­NUMBER	VAR­CHAR2	16	Optional		Old Cheque Number
DRAWEEBANK	VAR­CHAR2	12	Mandatory		Drawee Bank Code
DRAWEE­BRANCHCODE	VAR­CHAR2	12	Optional		Drawee Branch Code
DUPLICATE	VAR­CHAR2	1	Optional		Duplicate
TRANSACTION­TYPE	VAR­CHAR2	4	Optional		Transaction type
SPOOLSERIALNO	NUMBER	38	Optional		Spool serial number
CHECKSTATUS	VAR­CHAR2	1	Mandatory		Represents the Status CHECK­STATUSMAIN­TAINED Check Status Main­tained CHECK­BOOKAP­PLIED Check Book Applied CHECKBOOK­EXHAUSTED Check Book Exhausted SENTTOVEN­DOR Sent To Vendor DISCREPAN­CYNOTICED Discrepancy Noticed CANCELLED Check Can­celled
CHECKPRINTED­DATE	DATE	7	Optional		Cheque print Date
FILENAME	VAR­CHAR2	30	Optional		File Name
PROCESSED	VAR­CHAR2	1	Optional		Processed
TIMESTAMP	DATE	7	Optional		Time Stamp
PRINTERID	VAR­CHAR2	15	Optional		Printer ID
MAKER_ID	VAR­CHAR2	15	Optional		It shows the name of the user who has created or modi­fied the specific record.
MAK­ER_DT_STAMP	DATE	7	Optional		This field speci­fies the date and time at which this record was cre­ated or modi­fied. It is defaulted by system and will be in date for­mat.
DEPOSITRYID	VAR­CHAR2	12	Optional		Depositry ID
PAYMENTMODE	VAR­CHAR2	2	Mandatory		Payment Mode
SUBPAYMENT­MODE	VAR­CHAR2	2	Optional		Sub Payment Mode
PAYINBANK	VAR­CHAR2	12	Optional		Pay In Bank
PAYINBRANCH	VAR­CHAR2	12	Optional		Pay In Branch
PAYINNUMBER	VAR­CHAR2	12	Optional		Pay In Number
MODULEID	VAR­CHAR2	30	Mandatory		Module ID
COMMISSION	NUMBER	42	Optional		Commision
CHEQOPTYPE	VAR­CHAR2	1	Optional		Cheque Type
SYSREFERENCE­NUMBER	VAR­CHAR2	25	Mandatory		SYS Reference Number
CHECKER_ID	VAR­CHAR2	15	Optional		This field repre­sents the checker id who has authorized the latest record.
CHECK­ER_DT_STAMP	DATE	7	Optional		This field speci­fies the date and time at which this record was authorized is displayed in this field. It is defaulted by system and will be in date format.
MICRCODE	VAR­CHAR2	50	Optional		MICR Code
AUTH_STAT	VAR­CHAR2	1	Mandatory		Authorization Status. A - Authorised, U - Unauthorised
MOD_NO	NUMBER	10	Optional		Indicates the max number of times the record is modified.

2.11 Holiday Upload Format

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEQUENCE­NUMBER	NUM­BER	10	Mandatory		Sequence Number
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
BULKCLIENT­CODE	VAR­CHAR2	12	Mandatory		Bulk Client Code
IMPORTFILE­NAME	VAR­CHAR2	255	Mandatory		Import File Name
UPLOADMODE	VAR­CHAR2	1	Mandatory		Mode of operation which has to be performed on the record
AMCID	VAR­CHAR2	12	Optional		AMC ID
YEAR	NUM­BER	4	Mandatory		Year
JAN	VAR­CHAR2	100	Optional		Holiday Bits For Jan.eg) 00000000000000000011100000.
FEB	VAR­CHAR2	100	Optional		Holiday Bits For Febrauary
MAR	VAR­CHAR2	100	Optional		Holiday Bits For March
APR	VAR­CHAR2	100	Optional		Holiday Bits For April
MAY	VAR­CHAR2	100	Optional		Holiday Bits For May
JUN	VAR­CHAR2	100	Optional		Holiday Bits For June
JUL	VAR­CHAR2	100	Optional		Holiday Bits For July
AUG	VAR­CHAR2	100	Optional		Holiday Bits For August
SEP	VAR­CHAR2	100	Optional		Holiday Bits For September
OCT	VAR­CHAR2	100	Optional		Holiday Bits For October
NOV	VAR­CHAR2	100	Optional		Holiday Bits For November
DEC	VAR­CHAR2	100	Optional		Holiday Bits For December
MAKER_ID	VAR­CHAR2	15	Optional		MakerId
MAK­ER_DT_STAMP	DATE	15	Optional		Maker Date Stamp
AUTH_STAT	VAR­CHAR2	1	Mandatory		Authorisation Sta­tus. A-Author­ized,U-UnAuthorized
CHECKER_ID	VAR­CHAR2	15	Optional		This field will be ignored. Always maker id in the tem­plate will be consid­ered to update the checker id in the system.
CHECK­ER_DT_STAMP	DATE	10	Optional		Checker Date Stamp
ENTITYTYPE	VAR­CHAR2	1	Mandatory		Calendar Type
ENTITYID	VAR­CHAR2	12	Mandatory		Calendar Type

2.12 Dividend Declaration Upload

This section contains the following topics:

• Section 2.12.1, "Segment Identification Number"
• Section 2.12.2, "Dividend Declaration Upload"

2.12.1 Segment Identification Number

Segment Identification	Segment Identification
00DIV	This segment is used to provide Fund Dividend master details
01CMP	This segment is used to provide Fund Dividend EPU/Lot Component value details
02REP	This segment is used to provide Fund Dividend Report Component value details

2.12.2 Dividend Declaration Upload

Serial Number: 1

Segment Identification Number: 00DIV

Description: This segment is used to provide Fund Dividend master details

Segment Mandatory/ Optional: Mandatory

Field Name	Description	Data Type	Mandatory/ Optional	Table Name
PROCESSID	Process ID	VAR­CHAR2(50)	Mandatory	BULKFUNDDIVI­DENDDECLARETBL
SEGMENTID	Segment ID	VAR­CHAR2(50)	Mandatory	BULKFUNDDIVI­DENDDECLARETBL
SEQUENCE­NUMBER	Sequence Number	NUMBER(10)	Mandatory	BULKFUNDDIVI­DENDDECLARETBL
BULKCLIENT­CODE	Bulk Client Code	VAR­CHAR2(12)	Mandatory	BULKFUNDDIVI­DENDDECLARETBL
IMPORTFILE­NAME	Import File Name	VAR­CHAR2(255)	Mandatory	BULKFUNDDIVI­DENDDECLARETBL
UPLOADMODE	Upload Mode	VAR­CHAR2(1)	Mandatory	BULKFUNDDIVI­DENDDECLARETBL
FUNDID	Fund ID	VAR­CHAR2(6)	Mandatory	BULKFUNDDIVI­DENDDECLARETBL
CORPORATE­ACTIONTYPE	Corporate Action Type	VAR­CHAR2(1)	Mandatory	BULKFUNDDIVI­DENDDECLARETBL
DIVIDEND­NUMBER	Dividend Number	NUMBER(5)	Mandatory	BULKFUNDDIVI­DENDDECLARETBL
DIVIDEND­FROMDATE	Dividend From Date	DATE	Mandatory	BULKFUNDDIVI­DENDDECLARETBL
DIVIDENDTO­DATE	Dividend To Date	DATE	Mandatory	BULKFUNDDIVI­DENDDECLARETBL
BOOKCLOS­INGFROM­DATE	Book Closing From Date	DATE	Optional	BULKFUNDDIVI­DENDDECLARETBL
BOOKCLOS­INGTODATE	Book Closing To Date	DATE	Optional	BULKFUNDDIVI­DENDDECLARETBL
FREEZEHOLD­INGSDATE	Freeze Hold­ings Date	DATE	Optional	BULKFUNDDIVI­DENDDECLARETBL
BOARDOFDIRMTGDATE	Board of Dirmtg Date	DATE	Optional	BULKFUNDDIVI­DENDDECLARETBL
DIVIDENDDE­CLAREDATE	Dividend Declare Date	DATE	Optional	BULKFUNDDIVI­DENDDECLARETBL
EARNINGSPE­RUNIT	Earnings per Unit	NUMBER(20)	Optional	BULKFUNDDIVI­DENDDECLARETBL
PROCESSED­TYPE	Processed Type	VAR­CHAR2(1)	Mandatory	BULKFUNDDIVI­DENDDECLARETBL
EXCHANGER­ATEDATEFOR­DIVIDEND	Exchange Rate Date For Dividend	DATE	Optional	BULKFUNDDIVI­DENDDECLARETBL
STOCKDIVI­DENDPAREN­TRATIO	Stock Divi­dend Parent Ratio	NUMBER(22)	Optional	BULKFUNDDIVI­DENDDECLARETBL
STOCKDIVI­DENDRESULT­ANTRATIO	Stock Divi­dend Result­ant Ratio	NUMBER(22)	Optional	BULKFUNDDIVI­DENDDECLARETBL
NPI	NPI	NUMBER(20)	Mandatory	BULKFUNDDIVI­DENDDECLARETBL
EQUALIZA­TIONRATE	Equalization Rate	NUMBER(20)	Mandatory	BULKFUNDDIVI­DENDDECLARETBL
STOCKDIVI­DENDTYPE	Stock Divi­dend Type	VAR­CHAR2(1)	Optional	BULKFUNDDIVI­DENDDECLARETBL
OVERRIDE­FATCAWHT	Override FATCA WHT	NUMBER(1)	Optional	BULKFUNDDIVI­DENDDECLARETBL
GRANDFA­THEREDOBLI­GATION	Grand Fathered Obligation	NUMBER(1)	Optional	BULKFUNDDIVI­DENDDECLARETBL
DISTRIBU­TIONTYPE	Distribution Type	VAR­CHAR2(3)	Optional	BULKFUNDDIVI­DENDDECLARETBL
GROSS­NETEPUFLAG	Gross Net EPU Flag	VAR­CHAR2(1)	Optional	BULKFUNDDIVI­DENDDECLARETBL
GENERATERE­DEMPTION	Generate Redemption	VAR­CHAR2(1)	Optional	BULKFUNDDIVI­DENDDECLARETBL

Serial Number: 2

Segment Identification Number: 01CMP

Description: This segment is used to provide Fund Dividend EPU/Lot Component value details

Segment Mandatory/ Optional: Optional

Field Name	Description	Data Type	Mandatory/ Optional	Table Name
PROCESSID	Process ID	VARCHAR2(50)	Mandatory	BULKFUNDDIVI­DENDCOMPVAL­UESTBL
SEGMENTID	Segment ID	VARCHAR2(20)	Mandatory	BULKFUNDDIVI­DENDCOMPVAL­UESTBL
SEQUENCE­NUMBER	Sequence number	NUMBER(10)	Mandatory	BULKFUNDDIVI­DENDCOMPVAL­UESTBL
COMPONEN­TID	Component ID	VARCHAR2(2)	Mandatory	BULKFUNDDIVI­DENDCOMPVAL­UESTBL
COMPO­NENTVALUE	Component value	NUMBER(30)	Mandatory	BULKFUNDDIVI­DENDCOMPVAL­UESTBL
FDAPIN­COME	FDAP income	NUMBER(1)	Optional	BULKFUNDDIVI­DENDCOMPVAL­UESTBL

Serial Number: 3

Segment Identification Number: 02REP

Description: This segment is used to provide Fund Dividend Report Component value details

Segment Mandatory/ Optional: Optional

Field Name	Description	Data Type	Mandatory/ Optional	Table Name
PROCESSID	Process ID	VARCHAR2(50)	Mandatory	BULKFUNDDIVRE­PORTCOMPTBL
SEGMENTID	Segment ID	VARCHAR2(20)	Mandatory	BULKFUNDDIVRE­PORTCOMPTBL
SEQUENCE­NUMBER	Sequence number	NUMBER(10)	Mandatory	BULKFUNDDIVRE­PORTCOMPTBL
COMPO­NENTID	Component ID	VARCHAR2(2)	Mandatory	BULKFUNDDIVRE­PORTCOMPTBL
COMPO­NENTVALUE	Component value	NUMBER(30)	Mandatory	BULKFUNDDIVRE­PORTCOMPTBL

 

2.13 Dividend Equalization Adjustment Upload

Field Name	Data Type	Field Length	Mandatory?	Characteristics/Rules	Values
SEQUENCE­NUMBER	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.
BULKCLI­ENTCODE	String	12	Yes		The Code of the Bulk Client
IMPORT­FILENAME	String	255	Yes		Name of the file being uploaded should be speci­fied. Each file must have a unique name.
UPLOAD­MODE	String	1	Yes		‘N’ for New unit holder uploads and ‘I’ for Informa­tion change.
FUNDID	Alpha­numeric	6	Yes		ID of the fund involved in the transaction. A valid fund id maintained in the system.
UNITHOLD­ERID	String	12	Yes		The unit holder ID available in FCIS.
EFFECTIVE­DATE	Date	10	No		Effective Date
G2UNITS	Number	30,12	No		Adjustable Units
AUTH_STAT	Var­char2	1	Yes		Must be ‘A’
MAKER_ID	Var­char2	15	Yes		Maker ID
MAK­ER_DT_STAMP	Date	10	Yes		Maker Date
CHECK­ER_ID	Var­char2	15	Yes		This field will be ignored. Always maker id in the tem­plate will be considered to update the checker id in the system.
CHECK­ER_DT_STAMP	Date	10	Yes		Checker Date

 

2.14 Exchange Rate Upload Format

Field Name	Data Type	Field Length	Mandatory?	Characteristics/Rules	Values
SOURCEID	VAR­CHAR2	6	YES		Source maintained in the system
REFCUR­RENCY	VAR­CHAR2	3	YES		Base Currency of the Source
PAIRCUR­RENCY	VAR­CHAR2	3	YES		Pair Currency for the exchange rate would be made available
FXDEAL­DATE	DATE	10	YES	Should be applica­tion date	Effective date for the Exchange rate
FXVALUE­DATE	DATE	10	YES	Should be greater than or equal  to FXDEALDATE	Value date for Forward Rates
BUYRATE	NUM­BER	15	YES		Buy Rate for the mentioned currencies
SELLRATE	NUM­BER	15	YES		Sell Rate for the mentioned currencies
EXCHRATE­FORRE­PORT	NUM­BER	1	NO		Flag to set whether the maintained FX Rate is used for Reporting
USERID	VAR­CHAR2	15	YES		Maker Id of the Exchange Rate
IMPORT­STATUS	VAR­CHAR2	1	NO		Status of the Import
ERROR­DESC	VAR­CHAR2	255	NO		Error description
AUTH_STAT	VAR­CHAR2	1	NO		Authorization Status. A- Authorised. U -Unauthorised
PROCES­SID	VAR­CHAR2	50	NO		Process ID
BULKCLI­ENTCODE	VAR­CHAR2	12	NO		Bulk Client Code
IMPORT­FILENAME	VAR­CHAR2	255	NO		Import File Name
AMCID	VAR­CHAR2	12	NO		AMC ID
SERIAL­NUMBER	VAR­CHAR2	16	NO		Serial Number
MAKER_ID	VAR­CHAR2	15	NO		It shows the name of the user who has created or modified the specific record
MAK­ER_DT_STAMP	DATE	7	NO		This field specifies the date and time at which this record was created or modified. It is defaulted by system and will be in date format
CHECK­ER_ID	VAR­CHAR2	15	NO		This field will be ignored. Always maker id in the tem­plate will be considered to update the checker id in the system.
CHECK­ER_DT_­STAMP	DATE	7	NO		This field specifies the date and time at which this record was authorized is displayed in this field. It is defaulted by system and will be in date format
SEQUEN­CENUMBER	VAR­CHAR2	10	NO		Sequence Number
UPLOAD­MODE	VAR­CHAR2	1	NO		Operation mode which will be performed on the Upload records. It can have N-New,D-Delete,A-Auth & E- Modify

2.15 AuthRep Upload Format

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEQUENCENUM­BER	NUMBER	10	Manda­tory		Sequence Num­ber
PROCESSID	VAR­CHAR2	50	Manda­tory		Process ID
BULKCLIENTCODE	VAR­CHAR2	12	Manda­tory		Bulk Client Code
IMPORTFILENAME	VAR­CHAR2	255	Manda­tory		Import File Name
AMCID	VAR­CHAR2	12	Optional		AMC ID
MAKER_ID	VAR­CHAR2	15	Manda­tory		Maker of the record
MAKER_DT_STAMP	DATE	10	Optional		Date Time stamp on which the Maker created the record
CHECKER_ID	VAR­CHAR2	15	Optional		This field will be ignored. Always maker id in the template will be considered to update the checker id in the system.
CHECK­ER_DT_STAMP	DATE	10	Optional		Date Time stamp on which the record was authorised
UPLOADMODE	VAR­CHAR2	1	Manda­tory		Mode of opera­tion which has to be performed on the record
MODULEID	VAR­CHAR2	30	Manda­tory		Module ID of the Authorized repre­sentative
AUTHREPREFNO	VAR­CHAR2	12	Optional		Authorized Rep­resentative Ref­erence Number
AUTHREPID	VAR­CHAR2	12	Optional		Authorized Rep­resentative ID
AUTHREPADDRESS	VAR­CHAR2	255	Optional		Authorized Rep­resentative Address
AUTHREPZIPCODE	VAR­CHAR2	10	Optional		Authorized Rep­resentative ZIP Code
AUTH_STAT	VAR­CHAR2	1	Optional		Authorisation Status. A- Authorise, U - unauthorised
AGENTCODE	VAR­CHAR2	12	Optional		Agent Code
BRANCHCODE	VAR­CHAR2	12	Optional		Branch Code
AUTHREPSIGNA­TURE	VAR­CHAR2	255	Optional		Authorized Rep­resentative Sig­nature
IMAGEAVAILABLE	NUMBER	1	Optional		Image available or Not
AUTHREPTITLE	VAR­CHAR2	15	Optional		Authorized Rep­resentative Title
AUTHREPSTATE	VAR­CHAR2	20	Optional		Authorized Rep­resentative State
AUTHREPUSSTATE	NUMBER	1	Optional		Authorized Rep­resentative US State
AUTHREPCITY	VAR­CHAR2	10	Optional		Authorized Rep­resentative City
FIRSTNAME	VAR­CHAR2	105	Optional		First Name
MIDDLENAME	VAR­CHAR2	105	Optional		Middle Name
LASTNAME	VAR­CHAR2	105	Optional		Last Name
AUTHREPCOUNTRY	VAR­CHAR2	3	Manda­tory		Country of the authorized repre­sentative
NATIONALITY	VAR­CHAR2	3	Manda­tory		Nationality of the authorized repre­sentative
COUNTRYOFBIRTH	VAR­CHAR2	3	Manda­tory		Country of birth of the authorized representative
COUNTRYOFDOMI­CILE	VAR­CHAR2	3	Manda­tory		Country of domi­cile of the author­ized representative
TELEPHONE1	VAR­CHAR2	15	Manda­tory		Telephone 1 of the authorized representative
TELEPHONE2	VAR­CHAR2	15	Manda­tory		Telephone 2 of the authorized representative
CELLPHONENUM­BER	VAR­CHAR2	16	Manda­tory		Cellphone num­ber of the author­ized representative
INTDIALLINGCO­DEPH1	VAR­CHAR2	10	Manda­tory		International Dialling code of phone number 1
INTDIALLINGCO­DEPH2	VAR­CHAR2	10	Manda­tory		International Dialling code of phone number 2
INTDIALLINGCODE­CELL	VAR­CHAR2	10	Manda­tory		International Dialling code of cell phone num­ber
AUTHREPAD­DRESS2	VAR­CHAR2	255	Manda­tory		Address of the authorized repre­sentative
AUTHREPCATE­GORY	VAR­CHAR2	1	Manda­tory		Category of the authorized repre­sentative.
REMARKS	VAR­CHAR2	255	Optional		Remarks

2.16 Entity Upload Format

Segment Identification number:

Segment Identification Number	Description	Segment Mandatory / Optional?
00EIM	This segment is used for providing Entity Maintenance related Information	Mandatory
01EBD	This segment is used for providing Entity Bank related Information	Mandatory
02ECI	This segment is used for providing Entity Contact Information related Information	Mandatory
03EBD	This segment is used for providing Entity Broker Defi­nition related Information	Optional

Serial Number: 1

Segment Identification Number: 00EIM

Description: This segment is used for providing Entity Maintenance related Information

Segment Mandatory/ Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	16	Mandatory		Segment Id. Value for Segment id is 00EIM
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Sequence Number
BULKCLIENT­CODE	VAR­CHAR2	12	Optional		Bulk Client Code
IMPORTFILE­NAME	VAR­CHAR2	255	Optional		Import File Name
UPLOADMODE	VAR­CHAR2	1	Mandatory		Operation mode which will be per­formed on the Upload records. It can have N-New,D-Delete,A-Auth & E- Modify
ENTITYID	VAR­CHAR2	12	Mandatory		Entity ID
PARENTENTI­TYFLAG	NUMBER	1	Optional		Parent Entity Flag
ENTITYNAME	VAR­CHAR2	60	Mandatory		Entity Name
ENTITYTOBE­DELETED	VAR­CHAR2	12	Optional		Entity To be Deleted
ENTITYTYPE	VAR­CHAR2	1	Optional		Entity Type
PARENTEN­TITY	VAR­CHAR2	12	Optional		Parent Entity
EFFECTIVE­DATE	DATE	10	Optional		Effective Date
MAKER_ID	VAR­CHAR2	15	Mandatory		It shows the name of the user who has created or modified the specific record
MAK­ER_DT_STAMP	DATE	10	Optional		This field specifies the date and time at which this record was created or modi­fied. It is defaulted by system and will be in date format
CHECKER_ID	VAR­CHAR2	15	Optional		This field will be ignored. Always maker id in the tem­plate will be consid­ered to update the checker id in the system.
CHECK­ER_DT_STAMP	DATE	10	Optional		It shows the Name of the user who authorizes that spe­cific record
RECORDLINK	NUMBER	10	Optional		Record Link
NEWENTI­TYNAME	VAR­CHAR2	60	Optional		New Entity Name
NEWENTITYID	VAR­CHAR2	12	Optional		New Entity ID
ENTITYBASE­CURRENCY	VAR­CHAR2	3	Optional		Entity Base Cur­rency
ADDITIONALIN­FO1	VAR­CHAR2	60	Optional		Additional Informa­tion 1
ADDITIONALIN­FO2	VAR­CHAR2	60	Optional		Additional Informa­tion 2
ADDITIONALIN­FO3	VAR­CHAR2	60	Optional		Additional Informa­tion 3
ADDITIONALIN­FO4	VAR­CHAR2	60	Optional		Additional Informa­tion 4
ADDITIONALIN­FO5	VAR­CHAR2	60	Optional		Additional Informa­tion 5
ADDITIONALIN­FO6	VAR­CHAR2	60	Optional		Additional Informa­tion 6
ADDITIONALIN­FO7	VAR­CHAR2	60	Optional		Additional Informa­tion 7
ADDITIONALIN­FO8	VAR­CHAR2	60	Optional		Additional Informa­tion 8
ADDITIONALIN­FO9	VAR­CHAR2	60	Optional		Additional Informa­tion 9
ADDITIONALIN­FO10	VAR­CHAR2	60	Optional		Additional Informa­tion 10
ADDITIONALIN­FO11	VAR­CHAR2	60	Optional		Additional Informa­tion 11
ADDITIONALIN­FO12	VAR­CHAR2	60	Optional		Additional Informa­tion 12
ADDITIONALIN­FO13	VAR­CHAR2	60	Optional		Additional Informa­tion 13
ADDITIONALIN­FO14	VAR­CHAR2	60	Optional		Additional Informa­tion 14
ADDITIONALIN­FO15	VAR­CHAR2	60	Optional		Additional Informa­tion 15
ADDITIONALIN­FO16	VAR­CHAR2	60	Optional		Additional Informa­tion 16
ADDITIONALIN­FO17	VAR­CHAR2	60	Optional		Additional Informa­tion 17
ADDITIONALIN­FO18	VAR­CHAR2	60	Optional		Additional Informa­tion 18
ADDITIONALIN­FO19	VAR­CHAR2	60	Optional		Additional Informa­tion 19
ADDITIONALIN­FO20	VAR­CHAR2	60	Optional		Additional Informa­tion 20
ADDITIONALIN­FO21	VAR­CHAR2	60	Optional		Additional Informa­tion 21
ADDITIONALIN­FO22	VAR­CHAR2	60	Optional		Additional Informa­tion 22
ADDITIONALIN­FO23	VAR­CHAR2	60	Optional		Additional Informa­tion 23
ADDITIONALIN­FO24	VAR­CHAR2	60	Optional		Additional Informa­tion 24
ADDITIONALIN­FO25	VAR­CHAR2	60	Optional		Additional Informa­tion 25
ADDITIONALIN­FO26	VAR­CHAR2	60	Optional		Additional Informa­tion 26
ADDITIONALIN­FO27	VAR­CHAR2	60	Optional		Additional Informa­tion 27
ADDITIONALIN­FO28	VAR­CHAR2	60	Optional		Additional Informa­tion 28
ADDITIONALIN­FO29	VAR­CHAR2	60	Optional		Additional Informa­tion 29
ADDITIONALIN­FO30	VAR­CHAR2	60	Optional		Additional Informa­tion 30
AUTH_STAT	VAR­CHAR2	1	Optional		Authorisation Sta­tus. A - Authorised. U - Unauthorised
UNIQUERECORDNUMBER	NUMBER	5	Optional		Unique Record Number
MARKEDFOR­REIMP	VAR­CHAR2	1	Optional		Marked for Re-Import
ACCOUNT­TYPES	VAR­CHAR2	1000	Optional		Account Types
ENTITYCATE­GORYTYPE	VAR­CHAR2	1	Optional		Entity Category Type. I - Individual, C - Corporate
ENTITYCATE­GORY	VAR­CHAR2	2	Optional		Entity Category
AMCID	VAR­CHAR2	12	Optional		AMC ID
SWITCHIN­GLOGIC	VAR­CHAR2	12	Optional		Switching Logic
UHGENERA­TIONLOGIC	NUMBER	1	Optional		Unit Holder Genera­tion Logic. 1 - AGT, 2 - SERIAL&AMC/DIST&CHK, 3- SERIAL, 4 - No Logic, 5- Reference Number, 6 - AJF Generation Logic, 7 - Ctry(1)&Busi(1)&FMG/DIST&A-Z(1)&Num(5)
NATUREOF­BUSINESS	VAR­CHAR2	1	Optional		Nature of Business. U - UnitTrust, L - LifeProducts, B - Both
SECTION	VAR­CHAR2	40	Optional		Section
ENTITYSUB­TYPE	VAR­CHAR2	3	Optional		Module/Agent Type
CROSS­BRANCHING	NUMBER	1	Optional		Cross Branching Allowed ? 1 - Yes, 0 - No
FUNDSPOW­ERINSTALLED	NUMBER	1	Optional		FLEXCUBE-IS Installation? 1 - Yes, 0 - No
CUSTOMERIN­TERFACEKEY	VAR­CHAR2	1	Optional		Customer Interface Key. C - Customer, A - Account
ONLINEINTER­FACE	NUMBER	1	Optional		Online Interface. 1 - Yes, 0 - No
WEEKENDBITS	VAR­CHAR2	7	Optional		Weekend Bits
AUTHORIZED­SIGNATORY	VAR­CHAR2	70	Optional		Authorized Signa­tory
MOD_NO	NUMBER	5	Optional		Indicates the max number of times the record is modified
ALTLANGENTI­TYNAME	VAR­CHAR2	60	Optional		Alternate Lan­guage Entity Name
ALTLANGCON­TACTPERSON	VAR­CHAR2	70	Optional		Alternate Lan­guage Contact Per­son
ALTLANGAD­DRESS1	VAR­CHAR2	80	Optional		Alternate Lan­guage Address 1
ALTLANGAD­DRESS2	VAR­CHAR2	80	Optional		Alternate Lan­guage Address 2
ALTLANGCITY	VAR­CHAR2	80	Optional		Alternate Lan­guage City
ALTLANG­STATE	VAR­CHAR2	80	Optional		Alternate Lan­guage State
FINWARE­POSTING	NUMBER	1	Optional		Finware Posting. 1 - Yes, 0 - No
CHANNELEN­TITY	NUMBER	1	Optional		Restrict Cross Branching within Agent. 1 - Yes, 0 - No
MICRCODE	VAR­CHAR2	12	Optional		MICR Code
NATIONALITY	VAR­CHAR2	3	Optional		Nationality
COUNTRYOF­BIRTH	VAR­CHAR2	3	Optional		Represents the birth country of entity
COUNTRYOF­DOMICILE	VAR­CHAR2	3	Optional		Represents the country of domicile
INCORPORA­TIONCOUNTRY	VAR­CHAR2	3	Optional		Country of Incorpo­ration
TAXID	VAR­CHAR2	50	Optional		Tax Id
EIN	VAR­CHAR2	50	Optional		Employer ID Num­ber
TAXCERTIFI­CATEEFFED­ATE	DATE	10	Optional		Tax Certificate Effective Date
TAXCERTIFI­CATEEXPDATE	DATE	10	Optional		Tax Certificate Expiry Date
TAXCIRCLE	VAR­CHAR2	3	Optional		Tax Circle
TAXCATE­GORY	VAR­CHAR2	10	Optional		Tax Category
GIIN	VAR­CHAR2	30	Optional		Global Intermediary Identification Num­ber
CURRENCY	VAR­CHAR2	3	Optional		Currency
ISAREFEREN­CENO	VAR­CHAR2	5	Optional		ISA ReferenceNo
MINISATRANS­FEROUT	NUMBER	30	Optional		MinISATransferIn
MINISATRANS­FERIN	NUMBER	30	Optional		MinISATransferOut

Serial Number: 2

Segment Identification Number: 01EBD

Description: This segment is used for providing Entity Bank related Information

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	16	Mandatory		Segment Id. Value for Segment id is 01EBD
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Sequence Number
BULKCLIENT­CODE	VAR­CHAR2	12	Optional		Bulk Client Code
ENTITYID	VAR­CHAR2	12	Optional		Entity ID
ENTITYTYPE	VAR­CHAR2	1	Optional		Entity Type
BANKCODE	VAR­CHAR2	12	Optional		Bank Code
BRANCHCODE	VAR­CHAR2	12	Optional		Branch Code
ACCOUNT­TYPE	VAR­CHAR2	1	Optional		Account Type
ACCOUNT­NUMBER	VAR­CHAR2	16	Optional		Account Number
ACCOUNT­NAME	VAR­CHAR2	100	Optional		Account Name
ACCOUNT­CURRENCY	VAR­CHAR2	3	Optional		Account Currency
DEFAULTDE­TAILS	NUMBER	1	Optional		Default Details. 1 - Yes, 0 - No
DIRECTDEB­ITAPPLICABLE	VAR­CHAR2	1	Optional		Direct Debit Applica­ble. 1 - Yes, 0 - No
SWIFTFORMAT	VAR­CHAR2	6	Optional		Swift Format
BANK­CHARGED	VAR­CHAR2	12	Optional		Bank charged
BENEFICIARY	VAR­CHAR2	35	Optional		Beneficiary
BENEFICIARY­ADD1	VAR­CHAR2	35	Optional		Beneficiary Address 1
BENEFICIARY­ADD2	VAR­CHAR2	35	Optional		Beneficiary Address 2
BENEFICIARY­ADD3	VAR­CHAR2	35	Optional		Beneficiary Address 3
BENEFICIARY­BICCODE	VAR­CHAR2	24	Optional		Beneficiary BIC Code
BENEFICIAR­YACCTNO	VAR­CHAR2	24	Optional		Beneficiary Account Number
BENEFICIARY­CODE	VAR­CHAR2	24	Optional		Beneficiary Code
BENEFICIARY­INFO	VAR­CHAR2	100	Optional		Beneficiary Info
INTERMEDI­ARY	VAR­CHAR2	35	Optional		Intermediary
INTERMEDIAR­YADD1	VAR­CHAR2	35	Optional		Intermediary Address 1
INTERMEDIAR­YADD2	VAR­CHAR2	35	Optional		Intermediary Address 2
INTERMEDIAR­YADD3	VAR­CHAR2	35	Optional		Intermediary Address 3
INTERMEDIA­RYBICCODE	VAR­CHAR2	24	Optional		Intermediary BIC Code
INTERMEDIAR­YACCTNO	VAR­CHAR2	24	Optional		Intermediary Account Number
INTERMEDI­ARYCODE	VAR­CHAR2	24	Optional		Intermediary Code
INTERMEDI­ARYINFO	VAR­CHAR2	100	Optional		Intermediary Info
FURTHER­CREDITNAME	VAR­CHAR2	35	Optional		Further Credit Name
FURTHER­CRED­ITACCTNO	VAR­CHAR2	35	Optional		Further Credit Account Number
REFERENCE1	VAR­CHAR2	35	Optional		Reference 1
REFERENCE2	VAR­CHAR2	35	Optional		Reference 2
IBAN	VAR­CHAR2	40	Optional		International Bank Account Number
BENEFICIARY­IBAN	VAR­CHAR2	40	Optional		Beneficiary Interna­tional Bank Account Number
INTERMEDI­ARYIBAN	VAR­CHAR2	40	Optional		Intermediary Interna­tional Bank Account Number

Serial Number: 3

Segment Identification Number: 02ECI

Description: This segment is used for providing Entity Contact Information related Information

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	16	Mandatory		Segment Id. Value for Segment id is 02ECI
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Sequence Number
BULKCLIENT­CODE	VAR­CHAR2	12	Optional		Bulk Client Code
ENTITYID	VAR­CHAR2	12	Optional		Entity ID
ENTITYTYPE	VAR­CHAR2	2	Optional		Entity Type
ADDRESSTYPE	VAR­CHAR2	2	Optional		Address Type. CO - Correspondence Address, AL - Alternate Address, SW - Swift Address
ADDRESS­LINE1	VAR­CHAR2	80	Optional		Address Line 1
ADDRESS­LINE2	VAR­CHAR2	80	Optional		Address Line 2
ADDRESS­LINE3	VAR­CHAR2	80	Optional		Address Line 3
ADDRESS­LINE4	VAR­CHAR2	80	Optional		Address Line 4
ZIPCODE	VAR­CHAR2	10	Optional		ZIP Code
COUNTRY	VAR­CHAR2	3	Optional		Country
USSTATE	NUMBER	1	Optional		US State. 1 - Yes, 0 - No
TELEPHONE1	VAR­CHAR2	15	Optional		Telephone 1
TELEPHONE2	VAR­CHAR2	15	Optional		Telephone 2
CELLPHONE­NUMBER	VAR­CHAR2	16	Optional		Cellphone Number
FAX	VAR­CHAR2	15	Optional		FAX
EMAIL	VAR­CHAR2	60	Optional		Email Address
CONTACTPER­SON	VAR­CHAR2	70	Optional		Contact Person
EFFECTIVE­FROMDATE	DATE	10	Optional		Effective From Date
EFFECTIVETO­DATE	DATE	10	Optional		Effective To Date
BICCODE	VAR­CHAR2	12	Optional		BIC Code
INTDIALLING­CODEPH1	VAR­CHAR2	10	Optional		Int. Dialing Code + Telephone 1
INTDIALLING­CODEPH2	VAR­CHAR2	10	Optional		Int. Dialing Code + Telephone 2
INTDIALLING­CODECELL	VAR­CHAR2	10	Optional		Int. Dialing Code + Cellphone Number
INTDIALLING­CODEFAX	VAR­CHAR2	10	Optional		Int. Dialing Code + Fax

Serial Number: 4

Segment Identification Number: 03EBD

Description: This segment is used for providing Entity Broker Definition related Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	16	Mandatory		Segment Id. Value for Segment id is 03EBD
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Sequence Number
BULKCLIENT­CODE	VAR­CHAR2	12	Optional		Bulk Client Code
ENTITYID	VAR­CHAR2	12	Optional		Entity ID
TRANSAC­TIONTYPE	VAR­CHAR2	20	Optional		Transaction Type
BROKER­DEFTYPE	VAR­CHAR2	3	Optional		Broker Defaulting Mechanism

2.16.1 Cheque Book Request Upload Format

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Sequence Number
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
BULKCLIENT­CODE	VAR­CHAR2	12	Mandatory		Bulk Client Code
IMPORTFILE­NAME	VAR­CHAR2	255	Mandatory		Import File Name
AMCID	VAR­CHAR2	12	Mandatory		AMC ID
UNITHOLDERID	VAR­CHAR2	12	Mandatory		Unit Holder ID
FUNDID	VAR­CHAR2	6	Mandatory		Fund ID
ENTITYID	VAR­CHAR2	12	Mandatory		Entity ID
CHECKBOOK­NUMBER	VAR­CHAR2	16	Mandatory		Check Book Num­ber
STARTCHECK­NUMBER	VAR­CHAR2	12	Mandatory		Start Check Num­ber
ENDCHECK­NUMBER	VAR­CHAR2	12	Mandatory		End Check Number
CHECKCUR­RENCY	VAR­CHAR2	3	Mandatory		Check Currency
MAKER_ID	VAR­CHAR2	12	Optional		It shows the name of the user who has created or modified the specific record.
MAK­ER_DT_STAMP	DATE	10	Optional		This field specifies the date and time at which this record was created or modified. It is defaulted by sys­tem and will be in date format.
CHECKER_ID	VAR­CHAR2	12	Optional		This field will be ignored. Always maker id in the tem­plate will be consid­ered to update the checker id in the system.
CHECK­ER_DT_STAMP	DATE	10	Optional		This field specifies the date and time at which this record was authorized is dis­played in this field. It is defaulted by system and will be in date for­mat.
AUTH_STAT	VAR­CHAR2	1	Optional		This filed indicates where this particu­lar record is author­ized or not. A-Authorized U-Not Authorized
MOD_NO	NUMBER	10	Optional		Indicates the max number of times the record is modified.
RECORD_STAT	CHAR	1	Optional		Represents whether the record is open-O or closed-C
ONCE_AUTH	CHAR	1	Optional		Represents whether the record was authorized at least once after its creation. Authorized(Y)/Never Author­ized(N)
STATUS	VAR­CHAR2	50	Optional		Represents the Sta­tus CHECKSTATUS­MAINTAINED Check Status Main­tained CHECKBOOKAP­PLIED Check Book Applied CHECKBOOKEX­HAUSTED Check Book Exhausted SENTTOVENDOR Sent To Vendor DISCREPANCY­NOTICED Discrep­ancy Noticed CANCELLED Check Cancelled
REMARKS	VAR­CHAR2	200	Optional		Represents the Remarks
UPLOADMODE	VAR­CHAR2	1	Mandatory		Mode of operation which has to be performed on the record

2.17 Customer Fund Upload Format

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEQUENCE­NUMBER	NUM­BER	10	Mandatory		Sequence Number
BULKCLIENT­CODE	VAR­CHAR2	12	Mandatory		Bulk Client Code
IMPORTFILE­NAME	VAR­CHAR2	255	Mandatory		Import File Name
UPLOADMODE	VAR­CHAR2	1	Mandatory		Mode of operation which has to be per­formed on the record
CIFNUMBER	VAR­CHAR2	12	Mandatory		CIF Number
MEDIA	VAR­CHAR2	15	Optional		Media
LOCATION	VAR­CHAR2	15	Optional		Location
FUNDID	VAR­CHAR2	6	Mandatory		Fund ID
NEWFUNDID	VAR­CHAR2	6	Optional		New Fund ID
MAKER_ID	VAR­CHAR2	15	Mandatory		Represents the user id who has entered the latest record.
MAK­ER_DT_STAMP	DATE	10	Optional		Represents the time when the record is created
CHECKER_ID	VAR­CHAR2	15	Optional		This field will be ignored. Always maker id in the tem­plate will be consid­ered to update the checker id in the sys­tem.
CHECK­ER_DT_STAMP	DATE	10	Optional		Represents the time when it was Author­ized.
AUTH_STAT	VAR­CHAR2	1	Optional		Authorisation Status. A - Authorised, U - Unauthorised
MODULEID	VAR­CHAR2	30	Mandatory		Module ID
AGENTCODE	VAR­CHAR2	12	Mandatory		Agent Code
BRANCHCODE	VAR­CHAR2	12	Mandatory		Branch Code

2.18 Customer Address Upload Format

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
PROCESSID	VAR­CHAR2	50	Optional		Sequence Number
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Process ID
BULKCLI­ENTCODE	VAR­CHAR2	12	Optional		Bulk Client Code
IMPORTFILE­NAME	VAR­CHAR2	255	Optional		Import File Name
UPLOAD­MODE	VAR­CHAR2	1	Mandatory		Mode of operation which has to be per­formed on the record
CIFNUMBER	VAR­CHAR2	12	Mandatory		CIF Number
MEDIA	VAR­CHAR2	15	Mandatory		Media
LOCATION	VAR­CHAR2	15	Mandatory		Location
ADDRESS1	VAR­CHAR2	105	Mandatory		Address 1
ADDRESS2	VAR­CHAR2	105	Optional		Address 2
ADDRESS3	VAR­CHAR2	105	Optional		Address 3
ADDRESS4	VAR­CHAR2	105	Optional		Address 4
ZIPCODE	VAR­CHAR2	10	Optional		ZIP Code
COUNTRY	VAR­CHAR2	3	Optional		Country
CONTACT­PERSON	VAR­CHAR2	70	Optional		Contact Person
TELE­PHONENUM­BER1	VAR­CHAR2	15	Optional		Telephone Number 1
TELE­PHONENUM­BER2	VAR­CHAR2	15	Optional		Telephone Number 2
CELL­PHONENUM­BER	VAR­CHAR2	15	Optional		Cellphone Number
ENABLED­FLAG	VAR­CHAR2	1	Optional		Enabled Flag
MAKER_ID	VAR­CHAR2	15	Mandatory		Authorisation Sta­tus. A - Authorised. U - Unauthorised
MAK­ER_DT_STAMP	DATE	10	Optional		Represents the user id who has entered the latest record.
AUTH_STAT	VAR­CHAR2	1	Optional		Represents the time when the record is created
CHECK­ER_ID	VAR­CHAR2	15	Optional		This field will be ignored. Always maker id in the tem­plate will be consid­ered to update the checker id in the system.
CHECK­ER_DT_STAMP	DATE	10	Optional		Represents the time when it was Author­ized.
MODULEID	VAR­CHAR2	30	Mandatory		Represents the module ID
AGENTCODE	VAR­CHAR2	12	Mandatory		Represents the agent code
BRANCH­CODE	VAR­CHAR2	12	Mandatory		Represents the branch code

2.19 EMP Upload Format

Segment Identification Number

Segment Identification Number	Description	Segment Mandatory / Optional?
01HDR	This segment is used for providing information related to Employer Header details	Mandatory
02DTL	This segment is used for providing information related to Employer details	Mandatory

2.19.1 Employer Header Details

Serial Number: 1

Segment Identification Number: 01HDR

Description: This segment is used for providing information related to Employer Header details

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMEN­TID	VAR­CHAR2	25	Mandatory		Segment Id - 01HDR
EMPLOY­ERCODE	VAR­CHAR2	25	Mandatory		Employee Code
EMPLOY­ERNAME	VAR­CHAR2	100	Mandatory		Employee Name
BANKCODE	VAR­CHAR2	12	Mandatory		Bnak Code
BRANCH­CODE	VAR­CHAR2	12	Mandatory		Braanch Coe
ACCOUNT­TYPE	VAR­CHAR2	1	Mandatory		Account Type
ACCOUNT­NUMBER	VAR­CHAR2	16	Mandatory		Account Number
ACCOUNT­NAME	VAR­CHAR2	100	Mandatory		Account Name

2.19.2 Employer Details

Serial Number: 2

Segment Identification Number: 02DTL

Description: This segment is used for providing information related to Employer details

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMEN­TID	VAR­CHAR2	25	Mandatory		Segment Id - 02DTL
EMPSUR­NAME	VAR­CHAR2	100	Mandatory		Employee Sur Name
EMPNAME	VAR­CHAR2	100	Mandatory		Employee Name
BROKER­CODE	VAR­CHAR2	25	Mandatory		Broker Code
FUNDID	VAR­CHAR2	25	Mandatory		Fund Id
VALUEDATE	DATE	7	Mandatory		Value Date
UNITHOLD­ERID	VAR­CHAR2	25	Mandatory		UnitHolder Id
EMPLOY­EEID	VAR­CHAR2	25	Mandatory		Employee Id
EMPLYERID	VAR­CHAR2	25	Mandatory		Employer Id
TOTALCON­TRIBUTION	VAR­CHAR2	30	Mandatory		Total Contribution
BASICSAL­ARY	VAR­CHAR2	30	Mandatory		Basic Salary
EFFEC­TIVEEM­PLOYEEPERCENTAGE	VAR­CHAR2	30	Mandatory		Effective Employee Percentage
EFFEC­TIVEEM­PLOYERPERCENTAGE	VAR­CHAR2	30	Mandatory		Effective Employer Percentage
ADMINFEE­PERCENT­AGE	VAR­CHAR2	30	Mandatory		Admin Fee Percent­age
ADMINFEE	VAR­CHAR2	30	Mandatory		Admin Fee
ADMIN­FEEFTER­VAT	VAR­CHAR2	30	Mandatory		Admin Fee after VAT
FLATFEE	VAR­CHAR2	30	Mandatory		Flat Fee
BROKER­FEEPER­CENTAGE	VAR­CHAR2	30	Mandatory		Broker Percentage
BROKER­FEEA­MOUNT	VAR­CHAR2	30	Mandatory		Broker Fee Amount
BROKER­FEEA­MOUNTAFTERVAT	VAR­CHAR2	30	Mandatory		Broker Fee Amount after VAT
TOTALDE­DUCTIONS	VAR­CHAR2	30	Mandatory		Total Deductions
NETIN­VESTMENT	VAR­CHAR2	30	Mandatory		Net Investment
EMPLOY­ERCONTRI­BUTION	NUMBER	30	Mandatory		Employer Contribution
EMPLOY­EECONTRI­BUTION	NUMBER	30	Mandatory		Employee Contribu­tion
ADDINFO1	VAR­CHAR2	30	Mandatory		Addition Information 1
ADDINFO2	VAR­CHAR2	30	Mandatory		Additional Information 2
ADDINFO3	VAR­CHAR2	30	Mandatory		Additional Information 3

 

2.20 FATCA Upload Format

Segment Identification Number

Segment Identification Number	Description	Segment Mandatory / Optional?
00FAT	This segment is used for providing information related to FATCA Maintenance header Details	Mandatory
01DOC	This segment is used for providing information related to FATCA Maintenance Document Details	Mandatory

2.20.1 FATCA Maintenance Header Details

Serial Number: 1

Segment Identification Number: 00FAT

Description: This segment is used for providing information related to FATCA Maintenance header Details

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id - 00FAT
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Sequence Number
BULKCLIENT­CODE	VAR­CHAR2	12	Mandatory		Bulk Client Code
IMPORTFILE­NAME	VAR­CHAR2	255	Mandatory		Import File Name
UPLOAD­MODE	VAR­CHAR2	1	Mandatory		Mode of operation which has to be per­formed on the record
FAT­CAREFNO	VAR­CHAR2	16	Mandatory		Represents the FATCA Reference Number
FATCAENTI­TYTYPE	VAR­CHAR2	2	Mandatory		Represents the FATCA Entity Type
FATCAENTIT­YID	VAR­CHAR2	12	Mandatory		Represents the FATCA Entity ID
FATCAENTI­TYNAME	VAR­CHAR2	100	Mandatory		Represents the FATCA Entity name
FATCAENTI­TYCATTYPE	VAR­CHAR2	1	Mandatory		Represents the FATCA Entity Cate­gory type
FATCACLAS­SIFICATION	VAR­CHAR2	25	Mandatory		Represents the FATCA Classifica­tion
FATCACLAS­SIFICATION­REASON	VAR­CHAR2	25	Mandatory		Represents the FATCA Classifica­tion Reason
FATCACOM­PLAINTREA­SON	VAR­CHAR2	255	Optional		Represents the FATCA Complaint Reason
AUTH_STAT	VAR­CHAR2	1	Mandatory		Represents the Authorisation Sta­tus. A- Authorised, U - Unauthorised.
MAKER_ID	VAR­CHAR2	15	Mandatory		Represents the user id who has entered the latest record.
MAK­ER_DT_STAMP	DATE	10	Optional		Represents the time when the record is created
CHECKER_ID	VAR­CHAR2	15	Optional		This field will be ignored. Always maker id in the tem­plate will be consid­ered to update the checker id in the system.
CHECK­ER_DT_STAMP	DATE	10	Optional		Represents the time when it was Author­ized.
REPORTA­BLE	NUMBER	1	Optional		FATCA Reportable - Yes/No
WITHHOLDA­BLE	NUMBER	1	Optional		FATCA Withholda­ble - Yes/No

2.20.2 FATCA Maintenance Document Details

Serial Number: 2

Segment Identification Number: 01DOC

Description: This segment is used for providing information related to FATCA Maintenance Document Details

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMEN­TID	VAR­CHAR2	20	Manda­tory		Segment Id - 01DOC
PROCES­SID	VAR­CHAR2	50	Manda­tory		Process ID
SEQUEN­CENUMBER	NUM­BER	10	Manda­tory		Sequence Number
FAT­CAREFNO	VAR­CHAR2	16	Manda­tory		FATCA Reference num­ber
DOCU­MENTTYPE	VAR­CHAR2	25	Manda­tory		Represents the FATCA document type.
ISSUEDATE	DATE	10	Manda­tory		Represents the docu­ment issue date
EXPIRY­DATE	DATE	10	Manda­tory		Represents the docu­ment expiry date
COPYRE­CEIVED	VAR­CHAR2	1	Manda­tory		Represents the Flag whether the document copy is received or not. Y- Yes, N- No
ORIGINAL­RECEIVED	VAR­CHAR2	1	Manda­tory		Represents the Flag whether the document original is received or not. Y- Yes, N- No
RECEIVED­DATE	DATE	10	Manda­tory		Represents the docu­ment received date
REMARKS	VAR­CHAR2	255	Manda­tory		Represents the remarks
CHASING­DATE	DATE	10	Manda­tory		Represents the docu­ment Chasing date
DOCUMEN­TREFNO	VAR­CHAR2	255	Manda­tory		Represents the docu­ment reference number
DOCCATE­GORY	VAR­CHAR2	25	Manda­tory		Represents the docu­ment category
DOCUMEN­TID	VAR­CHAR2	25	Manda­tory		Represents the docu­ment ID
MANDA­TORY	VAR­CHAR2	1	Manda­tory		Represents the manda­tory Criteria. Either it could be 'Standard' - S nor 'Additional' - A.

2.20.3 GFR Price Upload Format

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEQUEN­CENUMBER	NUMBER	10	Man­datory		Represents the Sequence Number
PROCES­SID	VAR­CHAR2	50	Man­datory		Represents the Process ID
BULKCLI­ENTCODE	VAR­CHAR2	12	Man­datory		Represents the Bulk Cli­ent Code
IMPORT­FILENAME	VAR­CHAR2	255	Man­datory		Represents the Import File Name
UPLOAD­MODE	VAR­CHAR2	1	Man­datory		Mode of operation which has to be performed on the record
FUNDID	VAR­CHAR2	12	Man­datory		Represents the Fund ID
PRICEDATE	DATE	7	Man­datory		Represents the Price Date
REVISED­PRICE	NUMBER	17	Man­datory		Represents the revised Price
LATEST­PRICE	NUMBER	1	Man­datory		Represents the latest Price
MAKER_ID	VAR­CHAR2	15	Man­datory		Represents the user id who has entered the lat­est record.
MAK­ER_DT_STAMP	DATE	7	Man­datory		Represents the time when the record is created
CHECK­ER_ID	VAR­CHAR2	15	Man­datory		Represents the checker id who has authorized the latest record.
CHECK­ER_DT_STAMP	DATE	7	Man­datory		Represents the time when it was Authorized.
RUNTYPE	VAR­CHAR2	4	Man­datory		Represents the run type
MOCKRUN	VAR­CHAR2	1	Man­datory		Flag to represent the mock run

2.21 GIIN Upload Format

Field Name (as expected in the file)	Data type	Length	Mandatory/ Optional	Characteristics/rules	Values
SEQUENCENUM­BER	NUM­BER(10)		Yes	22	Sequence Num­ber
PROCESSID	VAR­CHAR2(50)		Yes	200	Process ID
IMPORTFILE­NAME	VAR­CHAR2(255)		Yes	1020	Import File Name
GIIN	VAR­CHAR2(19)		Yes	76	GIIN Code to be imported
FINM	VAR­CHAR2(30)		Yes	120	Describes the name field
COUNTRYNM	VAR­CHAR2(30)		Yes	120	Describes the country field

2.22 Help Desk Upload

Segment Identification Number

Segment Identification Number	Description	Segment Mandatory/ Optional?
00HDM	This segment is used for providing information related to Help desk	Mandatory
01HDE	This segment is used for providing information related to Help desk	Mandatory

2.22.1 Help Desk Information

Serial Number: 1

Segment Identification Number: 00HDM

Description: This segment is used for providing information related to Help desk

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)			Data type			Length			Mandatory/Optional			Characteristics/rules			Values
SEGMENTID			VAR­CHAR2			20			Mandatory						Segment Id - 00HDM
PROCESSID			VAR­CHAR2			50			Mandatory						Process ID
SEQUENCE­NUMBER			NUMBER			10			Mandatory						Sequence Number
BULKCLIENT­CODE			VAR­CHAR2			12			Mandatory						Bulk Client Code
IMPORTFILE­NAME			VAR­CHAR2			255			Mandatory						Import File Name
UPLOADMODE			VAR­CHAR2			10			Mandatory						Mode of operation which has to be performed on the record
HELP­DESKREFNO			VAR­CHAR2			12			Optional						Help desk Refer­ence Number
REPORTINGEN­TITYTYPE			VAR­CHAR2			30			Mandatory						Reporting Entity Type
REPORTINGEN­TITYID			VAR­CHAR2			12			Mandatory						Reporting Entity ID
QUERYTYPE			VAR­CHAR2			10			Mandatory						Query Type
QUERYSEVER­ITY			VAR­CHAR2			10			Mandatory						Query Severity
QUERYCATE­GORY			VAR­CHAR2			30			Mandatory						Query Category
PROBLEMDE­SCRIPTION			VAR­CHAR2			255			Mandatory						Problem Descrip­tion
ATTENDEDBY			VAR­CHAR2			15			Mandatory						Attended By
HELPDESKSTA­TUS			VAR­CHAR2			10			Mandatory						Help desk Status
MAKER_ID			VAR­CHAR2			15			Mandatory						Represents the user id who has entered the latest record.
MAK­ER_DT_STAMP			DATE			10			Optional						Represents the time when the record is created
MODULEID			VAR­CHAR2			30			Mandatory						Represents the module ID
AMCID			VAR­CHAR2			12			Mandatory						Represents the agent code

2.22.2 Help Desk Information

Serial Number: 2

Segment Identification Number: 01HDE

Description: This segment is used for providing information related to Help desk

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id - 01HDE
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUMBER	10	Mandatory		Sequence Number
HELP­DESKREFNO	VAR­CHAR2	12	Optional		Help desk Refer­ence Number
EVENTDATE	DATE	10	Mandatory		Event Date
HELPDESK­MODE	VAR­CHAR2	1	Mandatory		Help Desk Mode
EVENTMODE	VAR­CHAR2	1	Mandatory		Event Mode
EVENTDESCRIP­TION	VAR­CHAR2	255	Mandatory		Event Description

2.23 Gen EPU Upload Format

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
FUNDID	VAR­CHAR2	6	Mandatory		Dividend Distribution Fund ID
DIVIDEND­FROMDATE	DATE	7	Optional		Dividend Period - From Date If not provided, defaulted to Dividend Declaration Date.
DIVIDEND­TODATE	DATE	7	Optional		Dividend Period - To Date If not provided, defaulted to Dividend Declaration Date.
DIVIDEND­FREEZE­HOLDINGSDATE	DATE	7	Optional		Dividend Freeze Holdings Date If not provided, defaulted to Dividend Declaration Date.
DIVIDEND­DECLARA­TIONDATE	DATE	7	Mandatory		Dividend Declara­tion Date for the Fund,
COMPO­NENTVAL­UES	VAR­CHAR2	2000	Optional		Component Values with Component ID as ^ separator. For instance, ID^.10;FD^.22;FI^.12;LI^.32;TA^-.2; Pls note that tax/deduction needs to be provided with -ve sign, system derives EPU and it will be summation of the components. Optional, Then EPU to be provided in the below field
EPU	NUM­BER	22	Optional		Earnings Per Unit. If the Components are provided this will be ignored
PAYMENT­DATE	DATE	7	Optional		Dividend Payment Date for the Fund If not provided, while processing dividend system considers application date when the batch exe­cuted.
REINVEST­MENTDATE	DATE	7	Optional		Dividend Reinvest­ment Date for the Fund. If not provided, while processing reinvest­ments system con­siders application date when the batch executed as rein­vestment date.
NPICOMPO­NENT	VAR­CHAR2	1	Mandatory		NPI Component for the fund

2.24 Bank Statement Upload Format

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
KEYSTRING	VAR­CHAR2	50	No		Keystring
STATEMENT­TYPE	VAR­CHAR2	7	Yes		Statement type
TRANSACTION­DATE	VAR­CHAR2	10	Yes		Transaction date field. If transaction type ref field is branch, this field should be valid branch number. If transaction ref type field is acc-no then transaction date field should be a valid account num­ber else transation date should be a valid date.
TRANSACTION­TYPEREF	VAR­CHAR2	9	Yes		Transaction type ref. This field should have BRANCH, ACC-NO, OPEN, CLOSE as mandatory . Other transaction types also can be included.
CREDI­TORDEBIT	VAR­CHAR2	1	Yes		Credit or debit. Credit is + and debit is -
TRANSACTION­AMOUNT	VAR­CHAR2	17	Yes		Transaction amount
STATEMEN­TREFERENCE	VAR­CHAR2	41	Yes		Statement refer­ence
TRANSACTION­CODE	VAR­CHAR2	7	Yes		Transaction code
SERVICEFEE	VAR­CHAR2	6	Yes		Service fee

2.25 Bulk GL Setup Upload Format

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
PROCESSID	VAR­CHAR2	200	Mandatory		Process ID
BULKCLIENT­CODE	VAR­CHAR2	48	Mandatory		Bulk Client Code
IMPORTFILE­NAME	VAR­CHAR2	1020	Mandatory		Import File Name
FUNDID	VAR­CHAR2	24	Optional		Valid FundID in FCIS
GLTEM­PLATEID	VAR­CHAR2	40	Mandatory		Valid GL Template ID
ACCOUNT­TYPE	VAR­CHAR2	8	Mandatory		Valid Account Type
BUSINESSEV­ENT	VAR­CHAR2	8	Mandatory		Valid Business event
TRIGGEREV­ENT	VAR­CHAR2	60	Mandatory		Valid Trigger Event
THEROITICAL­FLAG	VAR­CHAR2	4	Mandatory		Theoritcak Flag, Yes/No
SETUPENA­BLED	VAR­CHAR2	4	Mandatory		GL setup enable disa­ble flag, Yes/No
COMPONEN­TID	VAR­CHAR2	80	Mandatory		GL Component ID
COMPONENT­DESCRIPTION	VAR­CHAR2	1020	Mandatory		GL Component Description
DEBITCREDIT­FLAG	VAR­CHAR2	8	Mandatory		Debit or Credit Flag
GLSETUPFOR­PRIMARY	VAR­CHAR2	4	Mandatory		GL Setup for Primary
PRIMARYENTI­TYTYPE	VAR­CHAR2	4	Mandatory		Primary Entity Type
ACCOUNT­NUMBER	VAR­CHAR2	64	Mandatory		GL Account number for Primary
ACCOUNT­CURRENCY	VAR­CHAR2	12	Mandatory		GL Account Currency for Primary
TRANSAC­TIONCUR­RENCY	VAR­CHAR2	12	Mandatory		Transaction Currency
BANKBRANCH	VAR­CHAR2	48	Optional		Bank Branch
DIRECTDEB­ITAPPLICABLE	VAR­CHAR2	4	Mandatory		Direct Debit applicable Yes/No
GLSETUP­FORCONTRA	VAR­CHAR2	4	Mandatory		GL Setup for Contra
CONTRAPRI­MARYENTITY­TYPE	VAR­CHAR2	4	Mandatory		Contra Entity Type
CONTRAAC­COUNTNUM­BER	VAR­CHAR2	64	Mandatory		Contra GL Account Number
CONTRAAC­COUNTCUR­RENCY	VAR­CHAR2	12	Mandatory		Contra GL Account Currency
CON­TRATRANSAC­TIONCURRENCY	VAR­CHAR2	12	Mandatory		Contra Transaction Currency
CONTRABANK­BRANCH	VAR­CHAR2	48	Optional		Contra Brank Branch
CONTRADI­RECTDEBITAP­PLICABLE	VAR­CHAR2	4	Mandatory		Contra Direct Debit Applicable Yes/No
RESTRICTED­REFTYPES	VAR­CHAR2	1020	Optional		Restricted Ref types for the GL setup(Delimited with ':')
GLCURRENCY	VAR­CHAR2	12	Mandatory		GL Currency
GLREFEREN­CENUMBER	VAR­CHAR2	40	Mandatory		GL Reference Number
PRODUCTID	VAR­CHAR2	40	Optional		Valid FCIS ProductID
PRODUCTOR­FUNDLEVEL	VAR­CHAR2	4	Mandatory		Indicates the GL setup is at fund level or prod­uct level
MODEODUP­LOAD	VAR­CHAR2	4	Mandatory		Upload Mode
AUTH_STAT	VAR­CHAR2	4	Optional		Auth Status
RESTRICTED­SUBTYPES	VAR­CHAR2	1020	Optional		Restricted sub types for the GL setup(Delimited with ':')

2.26 GO Confirmation Upload Format

Field Name (as expected in the file)	Data type			Length		Mandatory/Optional		Characteristics/rules		Values
TXNSERIAL­NUMBER	NUMBER			22		Manda­tory				Specifies the Trans­action Serial Num­ber
SEQUENCE­NUMBER	NUMBER			22		Manda­tory				Specifies the Sequence Number
PROCESSID	VAR­CHAR2			50		Manda­tory				Specifies the Pro­cess ID
BULKCLIENT­CODE	VAR­CHAR2			12		Optional				Specifies the Bulk Client code
IMPORTFILE­NAME	VAR­CHAR2			255		Optional				Specifies the Import File Name
AMCID	VAR­CHAR2			12		Manda­tory				Specifies the AMC of the Global order
UPLOADMODE	VAR­CHAR2			1		Manda­tory				Upload Mode.Value should be 'N'
GONUMBER	VAR­CHAR2			16		Manda­tory				Specifies the GO Number of the record
ALLOTEDUN­ITS	NUMBER			22		Manda­tory				Specifies the Alloted units of Global order
CONFIRME­DUNITS	NUMBER			22		Manda­tory				Specifies the Con­firmed units of Global order
UNITPRICE	NUMBER			22		Manda­tory				Specifies the unit Price used for allo­cation of Global order
CONFIRMA­TIONDATE	DATE			7		Manda­tory				Specifies the Confir­mation date of Global order
PRICEDATE	DATE			7		Manda­tory				Specifies the Price date of Global order
AMOUNT	VAR­CHAR2			22		Manda­tory				Specifies the Amount confirmed of Global order

2.27 Fund Upload Format

Segment Identification Number

Segment Identification Number	Description					Segment Mandatory / Optional?
00FDR	This segment is used for providing information related to Fund Demographics					Mandatory
01FLT	This segment is used for providing information related to Fund Language					Optional
02SCR	This segment is used for providing information related to Shares Characteristics					Mandatory
03FUH	This segment is used for providing information related to Fund Unitholder Category Registered Capital					Optional
04GOR	This segment is used for providing information related to General Operating Rules					Mandatory
05TRP	This segment is used for providing information related to Transaction Processing Rules					Mandatory
06TRC	This segment is used for providing information related to Transaction Processing Rules Commu­nication Mode					Optional
07FIC	This segment is used for providing information related to Fund Investor Category Transaction Limits					Optional
08FSF	This segment is used for providing information related to Fund SI Frequency Details					Optional
09FSC	This segment is used for providing information related to Fund Sale Country					Optional
10FRL	This segment is used for providing information related to Fund Residency Country					Optional
11FTC	This segment is used for providing information related to Fund Transaction Currency					Optional
12IDR	This segment is used for providing information related to Income Distribution Rule					Optional
13FLM	This segment is used for providing information related to Fund Load Maintenance					Optional
14FFM	This segment is used for providing information related to Fund Formula Maintenance					Optional
15FAI	This segment is used for providing information related to Fund Additional Information					Optional
16SDS	This segment is used for providing information related to Specific Fund Price date Setup					Optional
17FPD	This segment is used for providing information related to Fund User Defined Price Dates					Optional
18IRA	This segment is used for providing information related to Fund IRA					Optional
19FDI	This segment is used for providing information related to Fund Delivery Instruction					Optional
20FIA	This segment is used for providing information related to Fund Investment Account					Optional
21FIS	This segment is used for providing information related to Fund investment Account SI					Optional
22KYC	This segment is used for providing information related to KYC Fund					Optional
23HFR	This segment is used for providing information related to Hedge Fund Rules					Optional
24HFL	This segment is used for providing information related to Hedge Fund Link					Optional
25HFC	This segment is used for providing information related to Hedge Fund Investor Category Perfor­mance Fee					Optional
26MID	This segment is used for providing information related to Multi Distribution Details					Optional

2.27.1 Fund Demographics Details

Serial Number: 1

Segment Identification Number: 00FDR

Description: This segment is used for providing information related to Fund Demographics

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Manda­tory		Segment Id - 00FDR
PROCESSID	VAR­CHAR2	50	Manda­tory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Manda­tory		Sequence Number
BULKCLIENT­CODE	VAR­CHAR2	12	Optional		Bulk Client Code
IMPORTFILE­NAME	VAR­CHAR2	255	Optional		Import File Name
MAKER_ID	VAR­CHAR2	15	Manda­tory		It shows the name of the user who has cre­ated or modified the specific record
MAK­ER_DT_STAMP	DATE	7	Optional		This field specifies the date and time at which this record was created or modified. It is defaulted by system and will be in date for­mat
CHECKER_ID	VAR­CHAR2	15	Optional		This field will be ignored. Always maker id in the template will be considered to update the checker id in the system.
CHECK­ER_DT_STAMP	DATE	7	Optional		This field specifies the date and time at which this record was authorized is displayed in this field. It is defaulted by system and will be in date format
UPLOADMODE	VAR­CHAR2	1	Manda­tory		Operation mode which will be performed on the Upload records. It can have N-New,D-Delete,A-Auth & E- Modify
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Manda­tory		Rule Effective Date
FUNDSTART­DATE	DATE	7	Manda­tory		Fund Start Date
FUNDNAME	VAR­CHAR2	60	Manda­tory		Fund Name
FUND­NAMESHORT	VAR­CHAR2	15	Manda­tory		Fund Name Short
FUNDCLASS	VAR­CHAR2	1	Optional		Fund Class. O - Open-Ended, C - Close-Ended
FUNDTYPE	NUM­BER	22	Optional		Fund Type
FUNDFAMILY	VAR­CHAR2	6	Optional		Fund Family
FUNDBASE­CURRENCY	VAR­CHAR2	3	Optional		Fund Base Currency
FUNDCOUN­TRY	VAR­CHAR2	3	Optional		Fund Country
FISCALSTART­YEAR	DATE	7	Optional		Fiscal Year Start Date
FISCALEND­YEAR	DATE	7	Optional		Fiscal Year End Date
AMCID	VAR­CHAR2	12	Optional		AMC ID
BROKERSAL­LOWED	NUM­BER	22	Optional		Brokers Mandatory? 1 - Yes, 0 - No
REGISTRARID	VAR­CHAR2	12	Optional		Registrar ID
TRUSTEEID	VAR­CHAR2	12	Optional		Trustee ID
FUNDENA­BLED	NUM­BER	22	Optional		Fund Enabled? 1 - Yes, 0 - No
MINHOLDING­PERIOD	NUM­BER	22	Optional		Minimum Holding Period
PRIMARYRE­GADDRESS	VAR­CHAR2	255	Optional		Primary Registration Address
FUNDTAXID	VAR­CHAR2	25	Optional		Fund Tax ID
FUNDIDENTIFI­CATIONNUM­BER	VAR­CHAR2	25	Optional		Fund Identification Number
FUNDTICKER­SYMBOL	VAR­CHAR2	25	Optional		Fund Ticker Symbol
ALLOWIRAIN­VESTMENTS	NUM­BER	22	Optional		IRA Investments Allowed? 1 - Yes, 0 - No
EXISTING­FUND	VAR­CHAR2	1	Optional		Existing Fund ? 1 - Yes, 0 - No
CUSTODIAN	VAR­CHAR2	12	Optional		Custodian
FUNDSUS­PENDED	NUM­BER	22	Optional		Fund Suspended ? 1 - Yes, 0 - No
MINAMOUNT­FORTAX­IDINDV	NUM­BER	22	Optional		Min Amt for Tax ID-Indv
MINAMOUNT­FORTAXIDCOR	NUM­BER	22	Optional		Min Amt for Tax ID-Corp
HEDGEFUND	VAR­CHAR2	1	Optional		Hedge Fund ? Y - Yes, N - No
DEFAULTOP­TION	VAR­CHAR2	15	Optional		Default Option

2.27.2 Fund Language Details

Serial Number: 2

Segment Identification Number: 01FLT

Description: This segment is used for providing information related to Fund Language

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id - 01FLT
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Optional		Fund ID
FUNDID	VAR­CHAR2	6	Mandatory		Rule Effective Date
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Language Code
LANGUAGE­CODE	VAR­CHAR2	12	Mandatory		Sequence Number
FUNDNAME	VAR­CHAR2	60	Optional		Fund Name

2.27.3 Shares Characteristics Details

Serial Number: 3

Segment Identification Number: 02SCR

Description: This segment is used for providing information related to Shares Characteristics

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type		Length		Mandatory/Optional		Characteristics/rules		Values
SEGMENTID	VAR­CHAR2		20		Mandatory				Segment Id- 02SCR
PROCESSID	VAR­CHAR2		50		Mandatory				Process ID
SEQUENCE­NUMBER	NUM­BER		22		Optional				Sequence Number
FUNDID	VAR­CHAR2		6		Mandatory				Fund ID
RULEEFFEC­TIVEDATE	DATE		7		Optional				Rule Effective Date
SCRIPBASED	NUM­BER		22		Optional				ScripBased. 2 - Cer­tificate -Option, 1 - Scrip Based, 0 - Scrip Less
PARVALUE	NUM­BER		22		Optional				Unit Par Value
NOOFDECI­MALSFO­RUNITS	NUM­BER		22		Optional				Rounding Precision For Units
ROUND­OFFTRUN­CATE	VAR­CHAR2		1		Optional				Rounding Option For Units. R - Round Off, T - Round Down, U - Round Up
MINNOOFU­NITHOLDERS	NUM­BER		22		Optional				Min No Of Unit Hold­ers
MAXNOOFU­NITHOLDERS	NUM­BER		22		Optional				Max No Of Unit Hold­ers
MINREGIS­TEREDCAPI­TAL	NUM­BER		22		Optional				Min Registered Capi­tal
MAXREGIS­TEREDCAPI­TAL	NUM­BER		22		Optional				Max Registered Cap­ital
CAPINDICA­TOR	VAR­CHAR2		1		Optional				Limit By. A - Amount, P - Percentage
FOREIGNIN­VESTORS­LIMIT	NUM­BER		22		Optional				Limit Value
ACCOUNT­STATEMENT­FREQ	VAR­CHAR2		20		Optional				Account statement frequency
ACCOUNT­STATE­MENTLEADTIME	NUM­BER		22		Optional				A/c Statement Lead Time
PRINTAC­COUNT­STATEMENT	NUM­BER		22		Optional				Print Account State­ment
PRINTHOLD­INGSSTATE­MENT	NUM­BER		22		Optional				Print Holding State­ment
LASTSTATE­MENTNUM­BER	NUM­BER		22		Optional				Last Statement Num­ber
STANDARD­LOT	NUM­BER		22		Optional				Standard Lot
PREFIXCERT­CODE	VAR­CHAR2		1		Optional				Prefix Code
STARTCER­TISSUEDNO	NUM­BER		22		Optional				Start Issue No
LASTCERTIS­SUEDNO	NUM­BER		22		Optional				Last Issue No
PREFIXDNR­CODE	VAR­CHAR2		1		Optional				Prefix DNR Code
STARTDNRIS­SUEDNO	NUM­BER		22		Optional				Start DNR No.
LASTDNRIS­SUEDNO	NUM­BER		22		Optional				Last DNR No.
SINGLECER­TALLOWED	NUM­BER		22		Optional				Single Certificate Allowed ? 1 - Yes, 0 - No
MINCERTDE­NOMINATION	NUM­BER		22		Optional				Min Cert Denomina­tion
MAXCERTDE­NOMINATION	NUM­BER		22		Optional				Max Cert Denomina­tion
USEROVER­RIDEAL­LOWED	NUM­BER		22		Optional				User Override Allowed
CERTREQD	NUM­BER		22		Optional				Certificate Required For Block ? 1 - Yes, 0 - No
MAXREGIS­TEREDUNITS	NUM­BER		22		Optional				Maximum Regis­tered Units
UHCATREG­CAPITAL	VAR­CHAR2		2000		Optional				Unit Holder Category Registered Capital

2.27.4 Fund Unitholder Category Registered Capital Details

Serial Number: 4

Segment Identification Number: 03FUH

Description: This segment is used for providing information related to Fund Unitholder Category Registered Capital

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment ID - 03FUH
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective Date
UHCATE­GORY	VAR­CHAR2	2	Mandatory		UnitHolder Category
MAXRE­GUNITS	NUM­BER	22	Optional		Maximum Registered Units

2.27.5 General Operating Rules

Serial Number: 5

Segment Identification Number: 04GOR

Description: This segment is used for providing information related to General Operating Rules

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id - 04GOR
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective Date
POSTPRICED	NUM­BER	22	Optional		Post Priced ? 1 - Yes, 0 - No
NEXTPRICE­DECLARE­DATE	DATE	7	Optional		Next Price Declare Date
PRICEDE­CLAREFREQ	VAR­CHAR2	1	Optional		Price Declare Fre­quency
NOOFDECI­MALSFORNAV	NUM­BER	22	Optional		No of Decimals for NAV
ROUND­OFFTRUN­CATE	VAR­CHAR2	1	Optional		Rounding Options for NAV. R - Round Off, T - Round Down, U - Round Up
MATURITY­DATE	DATE	7	Optional		Maturity Date
RETAINIPO­BALANCE	NUM­BER	22	Optional		Retain IPO Balance? 1 - Yes, 0 - No
CONFBEFAL­CREQUIRED	NUM­BER	22	Optional		Allow Rejections Before Allocation? 1 - Yes, 0 - No
AUTORE­DEMPTIONAL­LOWED	NUM­BER	22	Optional		Automatic Redemp­tion Allowed? 1 - Yes, 0 - No
MINIMUMBAL­ANCETYPE	VAR­CHAR2	1	Optional		Minimum Balance Type. A - Amount, U - Units
MINIMUMBAL­ANCE	NUM­BER	22	Optional		Minimum Balance
ELAPSED­DAYSBE­FOREAUTORED	NUM­BER	22	Optional		Elapsed Days
CHQALLO­TONCLGDATE	NUM­BER	22	Optional		Allotment On Check Clearing. 1 - Yes, 0 - No
AGEINGBASE­DON	VAR­CHAR2	1	Optional		Ageing Policy. F - FIFO, I - IOF/IRRF Optimization, T - Txn-Receipts, P - FIFO Across Products, H - Hierarchy
MAINTAIN­TRADINGBOX	NUM­BER	22	Optional		Maintain Trading Box ? 1 - Yes, 0 - No
NAVLOT	NUM­BER	22	Optional		NAV Lot
CDSCFUND	VAR­CHAR2	2	Optional		CDSC Fund ?
CDSCAPPLI­CABLEFOR­SWITCHES	NUM­BER	22	Optional		CDSC Applicable for Switches? 1 - Yes, 0 - No
REINVEST­MENTFIRST	NUM­BER	22	Optional		Reinvestment First. 1 - Yes, 0 - No
VATVALUE	NUM­BER	22	Optional		VAT Percentage
CHECKFEA­TUREEXISTS	NUM­BER	22	Optional		Allow Check Writing. 1 - Yes, 0 - No
MINCHECKA­MOUNT	NUM­BER	22	Optional		Minimum Amount For Checks
MAXCHECKA­MOUNT	NUM­BER	22	Optional		Maximum Amount For Checks
MINCHECK­HOLDING­PERIOD	NUM­BER	22	Optional		Minimum Holding Period (Days)
CHECKAC­COUNTCLO­SURE	NUM­BER	22	Optional		Account Closure? 1 - Yes, 0 - No
CHECKREDEMPTIONPEN­ALTY	NUM­BER	22	Optional		Penalty Applicable ? 1 - Yes, 0 - No
HOLDING­PERIODPEN­ALTY	NUM­BER	22	Optional		Minimum Holding Period Violation . 1 - Yes, 0 - No
BALAN­CEPENALTY	NUM­BER	22	Optional		Insufficient Account Balance. 1 - Yes, 0 - No
STOPPAY­MENTPEN­ALTY	NUM­BER	22	Optional		Stop Payment Request on Check. 1 - Yes, 0 - No
AMTLIMIT­PENALTY	NUM­BER	22	Optional		Minimum And Maxi­mum Check Amount Violation. 1 - Yes, 0 - No
INTERE­STRATE	NUM­BER	22	Optional		Interest Rate
PERFOR­MANCEFEE­THRESHOLD	NUM­BER	22	Optional		Performance Fee Threshold
LIMITORDER­ALLOWED	NUM­BER	22	Optional		Allow Limit Order. 1 - Yes, 0 - No
FUTURELIMI­TORDERAL­LOWED	NUM­BER	22	Optional		Allow Future Dates Txn. 1 - Yes, 0 - No
AUTOLIMI­TORDERPRO­CESS	NUM­BER	22	Optional		Automatic Process­ing. 1 - Yes, 0 - No
PRICINGRULE	VAR­CHAR2	1	Optional		Pricing Rule. P - Prior, A - After
MULTIPLE­PRICEBASIS	NUM­BER	22	Mandatory		Multiple Price Basis. 1 - Yes, 0 - No
MIN­HOLDINGA­MOUNT	NUM­BER	22	Optional		Minimum Holdings Amount
MINHOLDIN­GUNITS	NUM­BER	22	Optional		Minimum Holdings Units
MINHOLDIN­GAPPLYFOR	VAR­CHAR2	1	Optional		Minimum Holdings Apply For. C - CIF, U - Unit Holder
CANCELIN­STRUCTION	VAR­CHAR2	2	Optional		Cancel Instruction
MINHOLDIN­GINDICATOR	VAR­CHAR2	1	Optional		Minimum Holdings Indicator. N - Not Applicable, A - Amount, U - Units, L - Lower of Amount/Units, H - Higher of Amount/Units
TXNCANCEL­LATIONAL­LOWED	NUM­BER	22	Optional		Transaction Cancella­tion Allowed. 1 - Yes, 0 - No
TXNCANCEL­LATION­PERIOD	NUM­BER	22	Optional		Transaction Cancella­tion Period
ALLOW­SWITCHING­INCANCELPERIOD	NUM­BER	22	Optional		Allow Switching in Cancellation Period. 1 - Yes, 0 - No
CANCELLA­TIONPRICE­BASIS	VAR­CHAR2	10	Optional		Cancellation Price Basis
MINTHRESH­HOLDLIMIT	NUM­BER	22	Optional		Minimum Threshold Limit
EUSDSCOPE	VAR­CHAR2	1	Optional		EUSD Scope. R - Redemption and Switch, D - Dividend, B - Both
AGEINGDATE	VAR­CHAR2	1	Optional		Ageing Date. T - Transaction Date, C - Confirmation Date, D - Dealing Date
INVESTMENT­SIMULATION­METHOD	VAR­CHAR2	1	Optional		Investment Simulation Method. N - Not Allowed, H - Historic NAV Based
MINLOCKIN­PERIODFOR­GAIN	NUM­BER	22	Optional		Min Lock-In Period for Gain(Days)
MAXLOCKIN­PERIODFOR­GAIN	NUM­BER	22	Optional		Max Lock-In Period for Gain(Days
DEFAULT­LOCKINPERI­ODFORGAIN	NUM­BER	22	Optional		Default Lock-In Period for Gain(Days)
AMOUNT­BLOCK­ALLOWED	NUM­BER	22	Optional		Amount Block Allowed. 1 - Yes, 0 - No
CALCULATE­FEEINTX­NCCY	NUM­BER	22	Mandatory		Allow Fee Calculation In Transaction Cur­rency. 1 - Yes, 0 - No
INCLUDE­HOLDING­PERIOD	VAR­CHAR2	1	Optional		Include Holding Period. 1 - Yes, 0 - No
BLOCKPRIOR­ITYNO	NUM­BER	22	Optional		Block Priority Number
DIVIDENDE­QAPPLICABLE	NUM­BER	22	Optional		Dividend Equalization Applicable. 1 - Yes, 0 - No
FATCAAPPLI­CABLE	NUM­BER	1	Optional		FATCA Applicable
FATCACLAS­SIFICATION	VAR­CHAR2	25	Optional		FATCA Classification
FATCAREA­SON	VAR­CHAR2	255	Optional		FATCA Reason
FATCAEIN	VAR­CHAR2	50	Optional		Employer ID Number
FATCAEFFEC­TIVEDATE	DATE	10	Optional		FATCA Effective Date
UCITSFUND	NUM­BER	1	Optional		UCITS Fund 1 - Yes, 0 - No
DILUTION­LEVYAPPLI­CABLE	VAR­CHAR2	5	Optional		Dilution Levy Applica­ble Y - Yes, N - No
INFLOW­BREACHFAC­TOR	NUM­BER	5	Optional		Inflow Breach Fac­tor%
OUTFLOW­BREACHFAC­TOR	NUM­BER	5	Optional		Outflow Breach Fac­tor%
THRESHOLD­BASIS	VAR­CHAR2	12	Optional		Threshold Basis A- Amount ,P- Percent­age
THRESHOLD­VALUE	NUM­BER	30	Optional		Threshold Value
SWINGPRICE­BASIS	NUM­BER	1	Optional		Swinging Price Basis 1 - Yes, 0 - No,Semi-swingingPrice - 2

2.27.6 Transaction Processing Rules Details

Serial Number: 6

Segment Identification Number: 05TRP

Description: This segment is used for providing information related to Transaction Processing Rules

Segment Mandatory / Optional: Mandatory

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment ID - 05TRP
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective Date
TRANSAC­TIONTYPE	VAR­CHAR2	2	Mandatory		Transaction Type
GROSSOR­NET	VAR­CHAR2	1	Optional		Gross or Net
TRANSAC­TIONSTART­DATE	DATE	7	Optional		Start Date
TRANSAC­TIONEND­DATE	DATE	7	Optional		End Date
TRANSAC­TIONFRE­QUENCY	VAR­CHAR2	1	Optional		Transaction Fre­quency
TRANSAC­TIONSTART­PERIOD	NUM­BER	22	Optional		Start Period
TRANSAC­TIONEND­PERIOD	NUM­BER	22	Optional		End Period
TRANSAC­TIONSTART­TIME	DATE	7	Optional		Start Time (HH24:MI:SS)
TRANSAC­TIONENDTIME	DATE	7	Optional		End Time (HH24:MI:SS)
MINTRANS­ACTION­AMOUNT	NUM­BER	22	Optional		Minimum Amount
STEPAMOUNT	VAR­CHAR2	22	Optional		Step Amount
MAXTRANS­ACTION­AMOUNT	NUM­BER	22	Optional		Maximum Amount
MINTRANS­ACTIONUNITS	NUM­BER	22	Optional		Minimum Units
STEPUNITS	NUM­BER	22	Optional		Step Units
MAXTRANS­ACTIONUNITS	NUM­BER	22	Optional		Maximum Units
ONLINEALLO­CATION	NUM­BER	22	Optional		Online Allocation? 1 - Yes, 0 - No
ALLOCATION­PERVSREG­CAPITAL	NUM­BER	22	Optional		Allocation Percent­age Versus Regis­tered Capital
ALLOCATION­POLICY	VAR­CHAR2	1	Optional		Allocation Policy. F - FIFO, P - Proportion­ate
NOOFTXNAL­LOWEDFOR­FREQ	VAR­CHAR2	1	Optional		Frequency.D - Daily, W - Weekly, F - Bi-Weekly, M - Monthly, Q - Quarterly, H - Half Yearly, Y - Yearly
NOOFTXNAL­LOWEDPE­RUH	NUM­BER	22	Optional		Limit(No of Txn Allowed per UH)
NOOF­FREETXNAL­LOWEDPERUH	NUM­BER	22	Optional		Free(No of Free Txn Allowed per UH)
ALLOWBACK­DATING	NUM­BER	22	Optional		Back-Dating Allowed.1 - Yes, 0 - No
BACKDATIN­GLIMIT	NUM­BER	22	Optional		Back-Dating Limit
FUNDTRANS­ACTION­COUNTER	NUM­BER	22	Optional		Counter(Fund Txn Counter)
ACKNOWL­EDGEMEN­TREQUIRED	NUM­BER	22	Optional		Acknowledgement Note Required.1 - Yes, 0 - No
CONFIRMA­TIONRE­QUIRED	NUM­BER	22	Optional		Confirmation Note Required.1 - Yes, 0 - No
BASEPRICE­DEFINITION	VAR­CHAR2	60	Optional		Base Price Definition
BASEPRICE­FACTOR	NUM­BER	22	Optional		Base Price Factor (%)
NOOFDECI­MALSFOR­BASEPRICE	NUM­BER	22	Optional		Rounding Precision For Base Price
ROUND­OFFTRUN­CATEBASEPRICE	VAR­CHAR2	1	Optional		Rounding Options For Base Price. R - Round Off, T - Truncate
TRANSAC­TIONENA­BLED	NUM­BER	22	Optional		Transaction Ena­bled.1 - Yes, 0 - No
CROSS­BRANCHAL­LOWED	NUM­BER	22	Optional		Cross-Branching Allowed. 1 - Yes, 0 - No
PRICELAG	NUM­BER	22	Optional		Price Lag
ALLOCATION­LAG	NUM­BER	22	Optional		Allocation Lag
CONFIRMA­TIONLAG	NUM­BER	22	Optional		Confirmation Lag
CHQALLO­CONPAR­WITHCASH	NUM­BER	22	Optional		Check On Par With Cash. 1 - Yes, 0 - No
HOLDING­PERIODAP­PLICABLE	NUM­BER	22	Optional		Holding Period Appli­cable. 1 - Yes, 0 - No
RETAINAGE­INGTOSUB­SCRIPTION	NUM­BER	22	Optional		Retain Ageing To Subscription. 1 - Yes, 0 - No
CREDITCARD­ALLOCON­PARWITHCASH	NUM­BER	22	Optional		Credit Card On Par With Cash. 1 - Yes, 0 - No
LIMITRE­DEMPTION­MODE	VAR­CHAR2	1	Optional		Limit Mode. P - Per­cent, A - Amount, U - Units
NATUREOF­LIMIT	VAR­CHAR2	1	Optional		Carry Forward. C - Carry
TRANSFE­RALLOCON­PARWITHCASH	NUM­BER	22	Optional		Transfer On Par With Cash. 1 - Yes, 0 - No
MININITIALTX­NAMOUNT	NUM­BER	22	Optional		Min. Initial Transac­tion Amount
MININITIALTX­NUNITS	NUM­BER	22	Optional		Min. Initial Transac­tion Units
MINSITX­NAMOUNT	NUM­BER	22	Optional		SI Minimum Amount
MAXSITX­NAMOUNT	NUM­BER	22	Optional		SI Maximum Amount
MINSITXN­UNITS	NUM­BER	22	Optional		SI Minimum Units
MAXSITXN­UNITS	NUM­BER	22	Optional		SI Maximum Units
EXISTINGUH	VAR­CHAR2	2	Optional		Restrict Sale to Inves­tor. 1 - Yes, 0 - No
NOOFDECI­MALSFO­RUNITPRICE	NUM­BER	22	Optional		Rounding Precision For Units
ROUND­OFFTRUNCA­TEUNITPRICE	VAR­CHAR2	1	Optional		Rounding Options For Unit Price.R - Round Off, T - Round Down, U - Round Up
ROUND­OFFTRUNCA­TEUNITS	VAR­CHAR2	1	Optional		Rounding Options For Units.R - Round Off, T - Round Down, U - Round Up
PAYMENTLAG	NUM­BER	22	Optional		Payment Lag (Days)
TRANSAC­TIONCUTOFF­TIME	DATE	7	Optional		Cut Off Time(HH24:MI)
CUTOFFTIME	VAR­CHAR2	8	Optional		Cut Off Time(HH24:MI)
ENFORCE­HOLDING­PERIOD	NUM­BER	22	Optional		Enforce Holding Period. 1 - Yes, 0 - No
APPLYENTRY­TIMELOAD	NUM­BER	22	Optional		Apply Entry Time Load. 1 - Yes, 0 - No
IPOMAX­ISSUESIZE	NUM­BER	22	Optional		Maximum IPO Issue Size
TRANSAC­TIONSUS­PENDED	NUM­BER	1	Optional		Transaction Sus­pended. 1 - Yes, 0 - No
MINSI­HOLDINGA­MOUNT	NUM­BER	22	Optional		SI Minimum Holdings Amount
MINSIHOLDIN­GUNITS	NUM­BER	22	Optional		SI Minimum Holdings Units
MINSIHOLDIN­GAPPLYFOR	VAR­CHAR2	1	Optional		SI Minimum Holdings Apply For. C - CIF, U - Unit Holder
MINSIHOLDIN­GINDICATOR	VAR­CHAR2	1	Optional		SI Minimum Holdings Indicator.N - Not Applicable, A - Amount, U - Units, L - Lower of Amount/Units, H - Higher of Amount/Units
PRICELAG­CALENDAR­BASIS	VAR­CHAR2	1	Optional		Price Lag Calendar Basis. C - Actual Cal­endar, S - System Calendar, F - Fund Calendar
SIDESCRIP­TION	VAR­CHAR2	255	Optional		Default SI Description
SIHOLIDAY­RULE	VAR­CHAR2	1	Optional		Holiday Rule. P - Prior, A - After
SICALENDER­BASIS	VAR­CHAR2	1	Optional		Calendar Basis. C - Actual Calendar, S - System Calendar, F - Fund Calendar
SIGENDAY	VAR­CHAR2	3	Optional		Specific Gen.Day
SIFRE­QUENCY	VAR­CHAR2	1	Optional		Default SI Frequency
SIGENCYCLE	VAR­CHAR2	1	Optional		SI Generation Freq. M - Monthly, Q - Quar­terly, H - Half Yearly, Y - Yearly
SICUTOFF­DAY	NUM­BER	22	Optional		SI Cut-Off Day
SICUT­OFFLAG	NUM­BER	22	Optional		SI Cut-off Lag
ENFORCESIR­ULE	NUM­BER	22	Optional		Enforce Generation
PAYMENT­LAGCALEN­DARBASIS	VAR­CHAR2	1	Optional		Payment Lag Calen­dar Basis. C - Actual Calendar, Y - Cur­rency Calendar, S - System Calendar, F - Fund Calendar
AMOUNTO­RUNITS	VAR­CHAR2	1	Optional		Amounts OR Units
LINKTOUN­SETTLEDIN­FLOWS	NUM­BER	22	Optional		Link To Unsettled Trades?. 1 - Yes, 0 - No
PSEU­DOSWITCH­LAG	NUM­BER	22	Optional		Pseudo Switch Lag
ALLOWSYS­TEMAT­ICPLANS	NUM­BER	22	Optional		Allow Systematic Plans?. 1 - Yes, 0 - No
MAXINI­TIALTX­NAMOUNT	NUM­BER	22	Optional		Max. Initial Transac­tion Amount
MAXINI­TIALTXN­UNITS	NUM­BER	22	Optional		Max. Initial Transac­tion Units
PSEU­DOSWITCH­LAGCALENDARBASIS	VAR­CHAR2	1	Optional		Pseudo Switch Calen­dar Basis. C - Actual Calendar, S - System Calendar, F - Fund Calendar
FULLOUT­FLOW	NUM­BER	22	Optional		Full Outflow. 1 - Yes, 0 - No
MAXNOOFSI­TRANSAC­TIONS	NUM­BER	22	Optional		Max No. of SI Txns
MAXVALIDITY	NUM­BER	22	Optional		Max. Validity(Days)
SILEADTIME	NUM­BER	22	Optional		SI Lead Time
APPLICABLE­ACCOUNT­TYPES	VAR­CHAR2	255	Optional		Applicable Account Types
INFLOW­OVERRIDA­BLEMSG	NUM­BER	22	Optional		Inflow Overridable Msg. 1 - Yes, 0 - No
MINMATURI­TYPERIOD	NUM­BER	22	Optional		Min. Maturity Period (Days)
MAXMATURI­TYPERIOD	NUM­BER	22	Optional		Max. Maturity Period (Days)
FUTURE­DATELIMIT	NUM­BER	22	Optional		Future Date Limit
UHCALEN­DARBASIS	VAR­CHAR2	2	Optional		Cycle Basis
NOOFDECI­MALSFO­RUNITS	NUM­BER	22	Optional		No. of Decimals
NOTICEPERI­ODDATEBA­SIS	VAR­CHAR2	1	Optional		Notice Period Date Basis.C - Actual Cal­endar, S - System Calendar
NOTICEPER­IOD	NUM­BER	22	Optional		Notice Period
SIAUTOTER­MINATION­COUNTER	VAR­CHAR2	3	Optional		SI Auto-Termination Cumulative Counter
CONSSIAUTO­COUNTER	NUM­BER	22	Optional		SI Auto-Termination Consecutive Counter
THRESHOL­DAMOUNT	NUM­BER	22	Optional		Transaction Thresh­old Amount
GOCUT­OFFLAG	VAR­CHAR2	8	Optional		GO Cut Off Lag(HH24:MI)
GOTHRESH­OLDUNITS	NUM­BER	27	Optional		GO Threshold Units
GOSETTLE­MENTLAG	NUM­BER	22	Optional		GO Settlement Lag
GOSETTLAG­CALENDAR	VAR­CHAR2	1	Optional		GO Settlement Lag Calendar

2.27.7 Transaction Processing Rules Communication Mode Details

Serial Number: 7

Segment Identification Number: 06TRC

Description: This segment is used for providing information related to Transaction Processing Rules Communication Mode

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id - 06TRC
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective Date
TRANSAC­TIONTYPE	VAR­CHAR2	2	Mandatory		Transaction Type. 02 - Subscription, 03 - Redemption, 04 - Switch, 54 - Transfer
COMMUNICA­TIONMODE	VAR­CHAR2	2	Mandatory		Communication Mode
MINTRANS­ACTION­AMOUNT	NUM­BER	22	Optional		Minimum Transaction Amount
MAXTRANS­ACTION­AMOUNT	NUM­BER	22	Optional		Maximum Transac­tion Amount
MINTRANS­ACTIONUNITS	NUM­BER	22	Optional		Minimum Transaction Units
MAXTRANS­ACTIONUNITS	NUM­BER	22	Optional		Maximum Transac­tion Units
DISALLOW­FIRSTTRANS­ACTION	NUM­BER	22	Optional		Disallow First Trans­action. 0 - No, 1 - Yes

2.27.8 Fund Investor Category Transaction Limits Details

Serial Number: 8

Segment Identification Number: 07FIC

Description: This segment is used for providing information related to Fund Investor Category Transaction Limits

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id - 07FIC
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective Date
INVESTOR­CATEGORY	VAR­CHAR2	2	Mandatory		Investor Category
TRANSAC­TIONTYPE	VAR­CHAR2	2	Mandatory		Transaction Type
MINTRANS­ACTION­AMOUNT	NUM­BER	22	Optional		Minimum Transaction Amount
STEPAMOUNT	VAR­CHAR2	22	Optional		Step Amount
MAXTRANS­ACTION­AMOUNT	NUM­BER	22	Optional		Maximum Transac­tion Amount
MINTRANS­ACTIONUNITS	NUM­BER	22	Optional		Minimum Transaction Units
STEPUNITS	NUM­BER	22	Optional		Step Units
MAXTRANS­ACTIONUNITS	NUM­BER	22	Optional		Maximum Transac­tion Units

2.27.9 Fund SI Frequency Details

Serial Number: 9

Segment Identification Number: 08FSF

Description: This segment is used for providing information related to Fund SI Frequency Details

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment id - 08FSF
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
TRANSAC­TIONTYPE	VAR­CHAR2	2	Mandatory		Transaction Type
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective Date
FREQUENCY	VAR­CHAR2	1	Mandatory		Frequency
FREQID	VAR­CHAR2	10	Mandatory		Freq ID
MINSITX­NAMOUNT	NUM­BER	22	Optional		Minimum SI Transac­tion Amount
MAXSITX­NAMOUNT	NUM­BER	22	Optional		Maximum SI Transac­tion Amount
MINSITXN­UNITS	NUM­BER	22	Optional		Minimum SI Transac­tion Units
MAXSITXN­UNITS	NUM­BER	22	Optional		Maximum SI Transac­tion Units
MINSI­HOLDINGA­MOUNT	NUM­BER	22	Optional		Minimum SI Holding Amount
MINSIHOLDIN­GUNITS	NUM­BER	22	Optional		Minimum SI Holding Units
MINSIHOLDIN­GAPPLYFOR	VAR­CHAR2	1	Optional		SI Minimum Holdings Apply For. C - CIF, H - Unit Holder
MINSIHOLDIN­GINDICATOR	VAR­CHAR2	1	Mandatory		SI Minimum Holdings Indicator.N - Not Applicable, A - Amount, U - Units, L - Lower of Amount/Units, H - Higher of Amount/Units
MINNOOFSI	NUM­BER	22	Optional		Minimum Number of SI
NOOFFAIL­URESAL­LOWED	NUM­BER	22	Optional		Number of failures Allowed
HOLIDAY­RULE	VAR­CHAR2	1	Optional		Holiday Rule
SIAUTOTER­MINATION­COUNTER	VAR­CHAR2	3	Optional		Maximum SI Transac­tion Allowed
CONSSIAUTO­COUNTER	NUM­BER	22	Optional		SI Auto Termination Counter
MAXSITXN­SALLOWED	NUM­BER	22	Optional		SI Auto-Termination Consecutive Counter

2.27.10 Fund Sale Country Details

Serial Number: 10

Segment Identification Number: 09FSC

Description: This segment is used for providing information related to Fund Sale Country

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id - 09FSC
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective Date
COUNTRY­CODE	VAR­CHAR2	3	Optional		Country Code

2.27.11 Fund Residency Country Details

Serial Number: 11

Segment Identification Number: 10FRL

Description: This segment is used for providing information related to Fund Residency Country

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id - 10FRL
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective Date
COUNTRY­CODE	VAR­CHAR2	3	Optional		Country Code

2.27.12 Fund Transaction Currency Details

Serial Number: 12

Segment Identification Number: 11FTC

Description: This segment is used for providing information related to Fund Transaction Currency

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id - 11FTC
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective Date
COUNTRY­CODE	VAR­CHAR2	3	Optional		Country Code

2.27.13 Income Distribution Rule Details

Serial Number: 13

Segment Identification Number: 12IDR

Description: This segment is used for providing information related to Income Distribution Rule

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id - 11FTC
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective Date
DIVIDENDDE­CLAREFREQ	VAR­CHAR2	1	Optional		Dividend Declare Fre­quency.D - Daily, F - Bi-Weekly, H - Half-Yearly, M - Monthly, Q - Quarterly, W - Weekly, Y - Yearly
DIVIDEND­PAYMENT­FREQ	VAR­CHAR2	1	Optional		Dividend Payment Frequency.D - Daily, F - Bi-Weekly, H - Half-Yearly, M - Monthly, Q - Quarterly, W - Weekly, Y - Yearly
REINVEST­MENTAL­LOWED	NUM­BER	22	Optional		Reinvestment Allowed ? 1 - Yes, 0 - No
TAXID	VAR­CHAR2	15	Optional		Tax ID
BOOKCLOS­INGLEADTIME	NUM­BER	22	Optional		Book Closing Lead Time
FREEZE­HOLDING­LEADTIME	NUM­BER	22	Optional		Freeze Holding Lead Time
BOARDMEET­INGLEADTIME	NUM­BER	22	Optional		Board Meeting Lead Time
DIVIDEND­PAY­MENTLEADTIME	NUM­BER	22	Optional		Dividend Payment Lead Time
NOOFDECI­MALSFORDIV­IDEND	NUM­BER	22	Optional		Number of Decimals For Dividend
ROUND­OFFTRUNCA­TEDIVIDEND	VAR­CHAR2	1	Optional		Round OFF Truncate Dividend
TDSBASIS	VAR­CHAR2	1	Optional		TDS Basis.D - Each Dividend, U - Fiscal Year, E - Tax Exempt
EPUCOMPO­NENTS	NUM­BER	22	Optional		EPU Based on Com­ponents?1 - Yes, 0 - No
DEFAULTDIS­TRIBUTION­MODE	VAR­CHAR2	1	Optional		Default Distribution Mode. T - Payout-A/C Transfer, Q - Payout-Check, R - Full Rein­vestment
EXCHANGER­ATEDATEBA­SIS	VAR­CHAR2	1	Optional		Dividend Exchange Rate Basis.P - Pay­ment Date, R - Refer­ence Date
RESTRICTIDS	NUM­BER	22	Optional		Restrict IDS For Unit Holder?1 - Yes, 0 - No
EPULOT	NUM­BER	22	Optional		EPU Lot
DIVLOOKA­HEAD	NUM­BER	22	Optional		Look Ahead Process­ing? 1 - Yes, 0 - No
CORPORATE­ACTIONTYPE	VAR­CHAR2	1	Mandatory		Corporate Action Type
UNITSFOR­FREEZE­HOLDINGS	VAR­CHAR2	1	Optional		Units For Freeze Holdings. A - All Units As Of Allocation Date, C - Confirmed Units As Of Allocation Date, P - All Units As Of Price Date, T - Con­firmed Units As Of Transaction Date, D - All Units As Of Trans­action Date, U - All Units As Of Dealing Date
FIRSTDIVI­DENDDE­CLAREDATE	DATE	7	Optional		First Dividend Declare Date
SPECIALDIVI­DEND	NUM­BER	22	Optional		Special Dividend.1 - Yes, 0 - No
MOCKDIVI­DEND	NUM­BER	22	Optional		Mock Dividend.1 - Yes, 0 - No
HOLIDAY­RULE	VAR­CHAR2	1	Optional		Holiday Rule.
PAYMENTLAG	NUM­BER	22	Optional		Payment Lag (Days)
PAYDIVI­DENDDURIN­GRED	NUM­BER	22	Optional		Pay Dividend During Redemption.1 - Yes, 0 - No
REINVEST­MENTPRICE­BASIS	VAR­CHAR2	10	Optional		Reinvestment Price Basis
IRACOMPUL­SORYREIN­VEST	NUM­BER	22	Optional		Compulsory Reinvest­ment For Retirement Account? 1 - Yes, 0 - No
DISTRIBU­TIONMODE­FORMINBALANCE	VAR­CHAR2	1	Mandatory		Distribution Mode For Minimum Balance. P - Forced Payout, I - According To Unit Holder IDS
DEFAULT­EPUOFPREV­DAY	VAR­CHAR2	1	Optional		Default EPU to previ­ous Declared EPU? 1 - Yes, 0 - No
INTEREST­COM­POUNDED	VAR­CHAR2	1	Optional		Interest to be com­pounded for the pay­ment Period? Y - Yes, N - No
NPISUPPORT	VAR­CHAR2	1	Mandatory		NPI Applicable.Y - Yes, N - No
NPIPAYMENT	VAR­CHAR2	3	Optional		NPI Payment
NPIUHOVER­RIDE	VAR­CHAR2	1	Mandatory		Override Unit holder preference? Y - Yes, N - No
FLGUNSET­TLEUNITS	VAR­CHAR2	1	Mandatory		Force Reinvestment of Uncleared units
MIMAMTTOB­EPAIDOUT	NUM­BER	22	Optional		Minimum Amount for Payment
ACTION	VAR­CHAR2	1	Optional		Action
OVERRAT­PAYTIME	NUM­BER	22	Optional		Override at Pay Time Y - Yes, N - No
AUTOREINV­FORUNCL­CHQ	NUM­BER	22	Optional		Auto Reinvestment for Unclaimed Dividend. 1 - Yes, 0 - No
AUTOREINV­FORUNCLCH­QFZB	NUM­BER	22	Optional		Auto Reinvestment for Unclaimed Dividend When No Balance Left. 1 - Yes, 0 - No
TRACKUN­CLEAREDTXNS	VAR­CHAR2	1	Optional		Track Dividend For Uncleared Transac­tion? 1 - Yes, 0 - No
TRACK­BLOCKED­TXNS	VAR­CHAR2	1	Optional		Track Dividend for Blocked Transac­tions? 1 - Yes, 0 - No
PAYUNGEN­REINVEST­MENT	VAR­CHAR2	1	Optional		Pay Ungenerated Reinvestments? 1 - Yes, 0 - No
TDSAPPLICA­BLEFORAL­LUH	NUM­BER	22	Optional		TDS Applicable for all UH. 1 - Yes, 0 - No
MINAMT­TOREINVEST	NUM­BER	30	Optional		Minimum Amount for Reinvestment

2.27.14 Fund Load Maintenance Details

Serial Number: 14

Segment Identification Number: 13FLM

Description: This segment is used for providing information related to Fund Load Maintenance

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id - 13FLM
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective date
TRANSAC­TIONTYPE	VAR­CHAR2	2	Mandatory		Transaction Type
LOADID	NUM­BER	22	Mandatory		Load ID
LOADTO­PRICE	NUM­BER	22	Optional		Load To Price
FROMENTITY­TYPE	VAR­CHAR2	1	Mandatory		From EntityType
TOENTITY­TYPE	VAR­CHAR2	1	Mandatory		To Entity Type
PROCESS­INGFREQ	VAR­CHAR2	1	Optional		Processing Fre­quency
GLACCOUNT­CODE	VAR­CHAR2	10	Optional		GL account Code
DEBITOR­CREDIT	VAR­CHAR2	1	Optional		Debit or Credit
CONTRAAC­COUNTCODE	VAR­CHAR2	10	Optional		Contra Account Code
NOOFDECI­MALSFOR­LOAD	NUM­BER	22	Optional		Number of Decimals For Load
ROUND­OFFTRUN­CATEFORLOAD	VAR­CHAR2	1	Optional		Round OFF Truncate For Load
MANDATORY	VAR­CHAR2	1	Optional		Mandatory
PRIORITYNO	NUM­BER	22	Optional		Priority Number
LOADVATTO­PRICE	NUM­BER	22	Optional		Load VAT To Price
APPLYRETVA­LON	VAR­CHAR2	1	Optional		Based On Income? G - Capital Gains - Gross, N - Non Capi­tal Gains - Net, C - Capital Gains, S - CDSC, P - Perfor­mance Based, I - IOF, D - Default IRRF, O - Optional IRRF
SENDFOR­GLINTER­FACE	NUM­BER	22	Optional		Send For GL Inter­face. 1 - Yes, 0 - No
DIFFEREN­TIALFEE	NUM­BER	22	Optional		Differential Fee? 1 - Yes, 0 - No
SLABBASIS	VAR­CHAR2	1	Optional		Slab Basis. G - Gross Amount, N - Net Amount, A - Average Cost
PRICEADDIN	NUM­BER	22	Optional		Price Add In. 1 - Yes, 0 - No
INDEXATION­ONCGT	VAR­CHAR2	1	Optional		Apply Indexation on CGT? 1 - Yes, 0 - No
LEVELID	NUM­BER	22	Optional		Level ID
GROUPID	VAR­CHAR2	6	Mandatory		Group Id
DEPENDENTLEVEL	NUM­BER	22	Optional		Dependent Level
REFTYPE	VAR­CHAR2	2	Mandatory		RefType

2.27.15 Fund Formula Maintenance Details

Serial Number: 15

Segment Identification Number: 14FFM

Description: This segment is used for providing information related to Fund Formula Maintenance

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id - 14FFM
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective date
COMPONEN­TID	VAR­CHAR2	10	Mandatory		Component ID
COMPONENT­DESC	VAR­CHAR2	50	Optional		Component Descrip­tion
COMPONENT­TYPE	VAR­CHAR2	5	Optional		Component Type
FORMULA	VAR­CHAR2	255	Optional		Formula
DEFAULT­VALUE	NUM­BER	22	Optional		Default Value
EXCLUDE­FROMCAPI­TALGAINS	NUM­BER	22	Optional		Exclude From Capital Gains? 1 - Yes, 0 - No
USEDFORFP­COMPUTA­TION	NUM­BER	22	Mandatory		Used for FP Compu­tation ? 1 - Yes, 0 - No
PRICEBASIS	VAR­CHAR2	1	Mandatory		Price Basis. Y - Yes, N - No
PARENT­PRICEBASIS	VAR­CHAR2	10	Optional		Parent Basis
INHERENT­FEE	NUM­BER	22	Optional		Inherent Fee
INHERENTIN­CENTIVE	NUM­BER	22	Optional		Inherent Incentive
DEFAULT­PRICEBASE	VAR­CHAR2	1	Mandatory		Default Price Basis. ON - Y, OFF - N

2.27.16 Fund Additional Information Details

Serial Number: 16

Segment Identification Number: 15FAI

Description: This segment is used for providing information related to Fund Additional Information

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id - 15FAI
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	12	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective Date
OTHERINFO1	VAR­CHAR2	60	Optional		Other Information 1
OTHERINFO2	VAR­CHAR2	60	Optional		Other Information 2
OTHERINFO3	VAR­CHAR2	60	Optional		Other Information 3
OTHERINFO4	VAR­CHAR2	60	Optional		Other Information 4
OTHERINFO5	VAR­CHAR2	60	Optional		Other Information 5
OTHERINFO6	VAR­CHAR2	60	Optional		Other Information 6
OTHERINFO7	VAR­CHAR2	60	Optional		Other Information 7
OTHERINFO8	VAR­CHAR2	60	Optional		Other Information 8
OTHERINFO9	VAR­CHAR2	60	Optional		Other Information 9
OTHERIN­FO10	VAR­CHAR2	60	Optional		Other Information 10
OTHERINFO11	VAR­CHAR2	60	Optional		Other Information 11
OTHERIN­FO12	VAR­CHAR2	60	Optional		Other Information 12
OTHERIN­FO13	VAR­CHAR2	60	Optional		Other Information 13
OTHERIN­FO14	VAR­CHAR2	60	Optional		Other Information 14
OTHERIN­FO15	VAR­CHAR2	60	Optional		Other Information 15
OTHERIN­FO16	VAR­CHAR2	60	Optional		Other Information 16
OTHERIN­FO17	VAR­CHAR2	60	Optional		Other Information 17
OTHERIN­FO18	VAR­CHAR2	60	Optional		Other Information 18
OTHERIN­FO19	VAR­CHAR2	60	Optional		Other Information 19
OTHERIN­FO20	VAR­CHAR2	60	Optional		Other Information 20
OTHERIN­FO21	VAR­CHAR2	60	Optional		Other Information 21
OTHERIN­FO22	VAR­CHAR2	60	Optional		Other Information 22
OTHERIN­FO23	VAR­CHAR2	60	Optional		Other Information 23
OTHERIN­FO24	VAR­CHAR2	60	Optional		Other Information 24
OTHERIN­FO25	VAR­CHAR2	60	Optional		Other Information 25
OTHERIN­FO26	VAR­CHAR2	60	Optional		Other Information 26
OTHERIN­FO27	VAR­CHAR2	60	Optional		Other Information 27
OTHERIN­FO28	VAR­CHAR2	60	Optional		Other Information 28
OTHERIN­FO29	VAR­CHAR2	60	Optional		Other Information 29
OTHERIN­FO30	VAR­CHAR2	60	Optional		Other Information 30

2.27.17 Specific Fund Price Date Setup Details

Serial Number: 17

Segment Identification Number: 16SDS

Description: This segment is used for providing information related to Specific Fund Price date Setup

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id - 16SDS
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective Date
TRANSAC­TIONTYPE	VAR­CHAR2	2	Mandatory		Transaction Type
FIRSTPRICE­DATE	DATE	7	Mandatory		First Price Date
PRICEFRE­QUENCY	VAR­CHAR2	1	Mandatory		Price Frequency.D - Daily, W - Weekly, F - Fortnightly, M - Monthly, Q - Quar­terly, H - Half-Yearly, Y - Yearly, U - User Defined
HOLIDAY­RULE	VAR­CHAR2	1	Mandatory		Holiday Rule. P - Prior, A - After
LASTPRICE­DATE	DATE	7	Mandatory		Last Price Date
FORWARD­PRICING	NUM­BER	22	Mandatory		Forward Pricing Appli­cable. 0 - No, 1 - Yes
CALENDAR­BASIS	VAR­CHAR2	1	Optional		Calendar Basis. S - System Calender, C - Actual Calender, F - Fund Calender
PRICEDAY	NUM­BER	22	Optional		Price Day
PRICEWEEK	NUM­BER	22	Optional		Price Week
PRICEMONTH	NUM­BER	22	Optional		Price Month
CUTOFFDAY	NUM­BER	22	Optional		Cut OFF Day
CUTOFF­WEEK	NUM­BER	22	Optional		Cut OFF Week
CUTOFF­MONTH	NUM­BER	22	Optional		Cut OFF Month
AUTOGEN­ERATE	NUM­BER	22	Optional		Auto Generate ?
GENERATION­TYPE	VAR­CHAR2	1	Optional		Auto Generation Of Fund Prices. A - Auto Generate Fund Prices using the last availa­ble Price and Author­ize the same, U - Auto Generate Fund Prices using the last availa­ble Price but do not Authorize the same, "" - Do not Auto Gener­ate Fund Prices
CUTOFFFRE­QUENCY	VAR­CHAR2	1	Optional		Cut-Off Frequency. D - Daily, W - Weekly, F - Fortnightly, M - Monthly, Q - Quar­terly, H - Half-Yearly, Y - Yearly
LASTWORK­INGDAY	NUM­BER	22	Optional		Last Working Day. ON - Y, OFF - N
DEALINGLAG	NUM­BER	22	Optional		Dealing Lag (in days)
DEALIN­GRULE	VAR­CHAR2	1	Optional		Dealing Rule. P - Prior, A - After
PRICEDEFBA­SIS	VAR­CHAR2	1	Optional		Price Frequency Defi­nition

2.27.18 Fund User Defined Price Dates Details

Serial Number: 18

Segment Identification Number: 17FPD

Description: This segment is used for providing information related to Fund User Defined Price Dates

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id - 17FPD
PROCESSID	VAR­CHAR2	50	Optional		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective Date
PRICEDATE	DATE	7	Mandatory		Price Date

2.27.19 Fund IRA Details

Serial Number: 19

Segment Identification Number: 18IRA

Description: This segment is used for providing information related to Fund IRA

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id - 18IRA
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective Date
MININITIALIN­VESTMEN­TAMT	NUM­BER	22	Optional		Minimum Initial Investment amount
MAXINITIALIN­VESTMEN­TAMT	NUM­BER	22	Optional		Maximum Initial Investment amount
MININVEST­MENTAMT	NUM­BER	22	Optional		Minimum Investment amount
MAXINVEST­MENTAMT	NUM­BER	22	Optional		Maximum Investment amount
MINWITH­DRAWALAMT	NUM­BER	22	Optional		Minimum Withdrawal amount
MAXWITH­DRAWALAMT	NUM­BER	22	Optional		Maximum Withdrawal amount

2.27.20 Fund Delivery Instruction Details

Serial Number: 20

Segment Identification Number: 19FDI

Description: This segment is used for providing information related to Fund Delivery Instruction

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id - 19FDI
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective Date
REGISTERE­DACCOUNT	NUM­BER	22	Optional		Registered Unit Holder Account. 0 - No, 1 - Yes
DELIVERYTO­CUSTODIAN	NUM­BER	22	Optional		Deliver to Custodian Account. 0 - No, 1 - Yes
DELIVERYTO­CLGAGENT	NUM­BER	22	Optional		Deliver to Clearing Agent. 0 - No, 1 - Yes
PHYSI­CALCERTDE­LIVERY	NUM­BER	22	Optional		Physical Delivery-Certificate option. 0 - No, 1 - Yes
DEFAULTDE­LIVERY	VAR­CHAR2	1	Optional		Default Account. R - Registered Unit Holder Account, C - Deliver to Custodian Account, A - Deliver to Clearing Agent, P - Physical Delivery-Certificate option
CERTIFICAT­EDENOMINA­TIONS	VAR­CHAR2	200	Optional		Certificate Denomina­tion
PUEV	NUM­BER	22	Optional		PUEV.0 - No, 1 - Yes

2.27.21 Fund Investment Account Details

Serial Number: 21

Segment Identification Number: 20FIA

Description: This segment is used for providing information related to Fund Investment Account

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id -20FIA
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective Date
ACCOUNT­TYPE	VAR­CHAR2	2	Optional		Account Type
STARTDATE	DATE	7	Optional		Start Date
ENDDATE	DATE	7	Mandatory		End Date
MINORAGE	NUM­BER	22	Mandatory		Minor Age

2.27.22 Fund investment Account SI Details

Serial Number: 22

Segment Identification Number: 21FIS

Description: This segment is used for providing information related to Fund investment Account SI

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id -21FIS
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective Date
TRANSAC­TIONTYPE	VAR­CHAR2	2	Mandatory		Transaction Type
ACCOUNT­TYPE	VAR­CHAR2	2	Mandatory		Account Type
SIDESCRIP­TION	VAR­CHAR2	255	Optional		SI Description
SIFRE­QUENCY	VAR­CHAR2	1	Optional		SI Frequency. D - Daily, M - Monthly, Q - Quarterly, W - Weekly, Y - Yearly, F - Bi-Weekly, H - Half-Yearly
SIGENDAY	VAR­CHAR2	3	Optional		SI Generation day
SIGENCYCLE	VAR­CHAR2	1	Optional		SI Generation day. M - Monthly, Q - Quar­terly, H - Half Yearly, Y - Yearly
MINSITX­NAMOUNT	NUM­BER	22	Optional		SI Minimum Amount
MAXSITX­NAMOUNT	NUM­BER	22	Optional		SI Maximum Amount
MINSITXN­UNITS	NUM­BER	22	Optional		SI Minimum Units
MAXSITXN­UNITS	NUM­BER	22	Optional		SI Maximum Units
HOLIDAY­RULE	VAR­CHAR2	1	Mandatory		Holiday Rule. P - Prior, A - After
CALENDER­BASIS	VAR­CHAR2	1	Mandatory		Calender Basis. S - System Calender, C - Actual Calender, F - Fund Calender
SICUTOFF­DAY	NUM­BER	22	Optional		SI Cut-Off Day
SICUT­OFFLAG	NUM­BER	22	Mandatory		SI Cut-off Lag
ENFORCESIR­ULE	VAR­CHAR2	1	Mandatory		Enforce Generation. 0 - No, 1 - Yes
MAXNOOFSI­TRANSAC­TIONS	NUM­BER	22	Optional		Max No. of SI Txns
MAXVALIDITY	NUM­BER	22	Optional		Max. Validity(Days)
SIAUTOTER­MINATION­COUNTER	VAR­CHAR2	3	Optional		SI Auto-Termination Counter
LASTDAYOF­SIGENCYCLE	NUM­BER	22	Optional		Last Day of SI Gen Cycle. 0 - No, 1 - Yes
CONSSIAUTO­COUNTER	NUM­BER	22	Optional		SI Auto-Termination Consecutive Counter
MAXSITXN­SALLOWED	NUM­BER	22	Optional		Maximum SI Transac­tions Allowed

2.27.23 KYC Fund Details

Serial Number: 23

Segment Identification Number: 22KYC

Description: This segment is used for providing information related to KYC Fund

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id -22KYC
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective Date
DOCUMENT­DESCRIPTION	VAR­CHAR2	255	Mandatory		Document Description

2.27.24 Hedge Fund Rules Details

Serial Number: 24

Segment Identification Number: 23HFR

Description: This segment is used for providing information related to Hedge Fund Rules

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id -23HFR
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective Date
HFUNDTYPE	VAR­CHAR2	1	Mandatory		Hedge Fund Type. S - Single/Simple, M - Master, O - Fund of Hedge Funds, P - Side Pockets, L - Lead Series, F - Fol­low Up Series
TXNGENERA­TIONBASIS	VAR­CHAR2	1	Optional		Transaction Genera­tion Basis. N - Net, O - Non Net, T - Non Net Transaction
MASTERFUN­DUHID	VAR­CHAR2	12	Optional		Master Fund UH ID
PFCOMPU­METHOD	VAR­CHAR2	4	Optional		Computation Method
PFACCRUAL­FREQ	VAR­CHAR2	1	Optional		Accrual Frequency. D - Daily, W - Weekly, M - Monthly, Q - Quar­terly, Y - Yearly
PFPAYMENT­FREQ	VAR­CHAR2	1	Optional		Payment Frequency. M - Monthly, Q - Quar­terly, H - Half Yearly, Y - Yearly
HURDLERA­TEAPPLICA­BLE	VAR­CHAR2	1	Optional		Hurdle Rate Applica­ble.Y - Yes, N - No
HURDLETYPE	VAR­CHAR2	1	Optional		Hurdle Type. C - Cumulative, N - Non Cumulative
RESETHUR­DLE	VAR­CHAR2	1	Optional		Reset Hurdle.Y - Yes, N - No
HURDLERA­TETYPE	VAR­CHAR2	20	Optional		Hurdle Rate Type. F - Fixed, V - Variable, S - Semi Variable
PERFOR­MANCE­FEEPER	NUM­BER	22	Optional		Performance Fee (%)
RATECODE	VAR­CHAR2	10	Optional		Rate Code
HFUNDMAN­AGER	VAR­CHAR2	12	Mandatory		Hedge Fund Manager
RATEBASIS	VAR­CHAR2	1	Optional		Rate Basis. 1 - Per­centage (%), 2 - Basic Points
RATE	NUM­BER	22	Optional		Rate
LASTACCRU­ALDATE	DATE	7	Optional		Last Accrual Date
LASTPAY­MENTDATE	DATE	7	Optional		Last Payment Date
NEXTACCRU­ALDATE	DATE	7	Optional		Next accrual Date
NEXTPAY­MENTDATE	DATE	7	Optional		Next Payment Date
GROUPID	VAR­CHAR2	10	Optional		Group ID
HURDLECAL­CMETHOD	VAR­CHAR2	1	Optional		Hurdle Calculation Method. S - Simple, C - Compound
DAYBASIS	VAR­CHAR2	1	Optional		Day Basis.1 - Actual, 2 - 360, 3 - 365

2.27.25 Hedge Fund Link Details

Serial Number: 25

Segment Identification Number: 24HFL

Description: This segment is used for providing information related to Hedge Fund Link

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id -24HFL
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective Date
HEDGEFUN­DID	VAR­CHAR2	6	Optional		Hedge Fund ID
PERCENTAGE	NUM­BER	22	Optional		Percentage
UNITHOLDE­RID	VAR­CHAR2	12	Optional		Unit Holder ID

2.27.26 Hedge Fund Investor Category Performance Fee Details

Serial Number: 26

Segment Identification Number: 25HFC

Description: This segment is used for providing information related to Hedge Fund Investor Category Performance Fee

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id -25HFC
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective Date
INVCATEGO­RYID	VAR­CHAR2	12	Optional		Investor Category ID
PERFOR­MANCEFEE	NUM­BER	22	Optional		Performance Fee

2.27.27 Multi Distribution Details

Serial Number: 27

Segment Identification Number: 26MID

Description: This segment is used for providing information related to Multi Distribution Details

Segment Mandatory / Optional: Optional

Field Name (as expected in the file)	Data type	Length	Mandatory/Optional	Characteristics/rules	Values
SEGMENTID	VAR­CHAR2	20	Mandatory		Segment Id -26MID
PROCESSID	VAR­CHAR2	50	Mandatory		Process ID
SEQUENCE­NUMBER	NUM­BER	22	Mandatory		Sequence Number
FUNDID	VAR­CHAR2	6	Optional		Fund ID
RULEEFFEC­TIVEDATE	DATE	7	Mandatory		Rule Effective Date
CORPORATE­ACTIONTYPE	VAR­CHAR2	3	Optional		Corporate Action Type
DISTRIBU­TIONTYPE	VAR­CHAR2	3	Optional		Distribution Type

2.27.28 Reinvestment Details Format

Column name (as expected in the file)	Data type	Length	Mandatory?	Description
REINVESTMEN­TUNITHOLDE­RID	String	12	Man­datory	For unit holder income distribution setup records, this is the same as the unit holder ID and is defaulted during process­ing.
REINVEST­MENTFUNDID	String	6	Man­datory	The ID of the fund into which the income is being reinvested. The reinvestment fund ID should be unique for an income distribution setup record.
SPLITPER­CENTAGE	Num­ber	5, 2	Man­datory	The split percentage to indicate the per­centage of income that must be rein­vested into the reinvestment fund. The sum of the split percentages for an income distribution setup should add up to one hundred.

•  
•  

2.28 Unit Holder Deal File Format

Note

For all imports of unit holder deal information, the external hand-off file containing the in­formation 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 Name (as expected in the file)	Data type	Field length	Mandatory	Characteristics / rules	Values
  SEQUEN­CENUM­BER	Num­ber	num­ber(10)	Man­datory		System generated sequence number for the records in the file
  PROCES­SID	String	var­char2(50)	Man­datory		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.
  BULKCLI­ENTCODE	String	var­char2(12)	Man­datory		The Code of the Bulk client.
  IMPORT­FILE­NAME	String	var­char2(255)	Man­datory		Name of the file being uploaded should be specified. Each file must have a unique name.
  UPLOAD­MODE	String	var­char2(1)	Man­datory		Upload mode can be “N” for New unit holder uploads and ‘I’ for Information change.
  AMCID	String	var­char2(12)	Man­datory		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.
  DEAL­TRANS­ACTIONNUMBER	String	VAR­CHAR2(16)	Optional		Null for a new mode. It may or may not be passed for other modes.
  UHIDOR­CIFNUM­BER	String	VAR­CHAR2(12)	Man­datory		Could be any valid unit holder ID or CIF number maintained in the system.
  APPLYAT­CIFLEVEL	Num­ber	NUM­BER(1)	Optional		Could be either 0- No or 1-Yes. If not supplied, value to be taken from bulk client defaults
  APPLYDEALAT	String	VAR­CHAR2(1)	Man­datory		Could be any of the following val­ues: G- Group Level, P- Product Level, F-Fund Level, L-Load level.
  STATUS	String	VAR­CHAR2(1)	Man­datory		Could be either A- Active or C-Cancelled.
  EFFEC­TIVE­STARTDATE	date	DATE	Man­datory		The effective date from which the deal is applicable
  EFFEC­TIVEEND­DATE	date	DATE	Optional		The effective date on which the deal ends. In case of null values it will take the default value as the system high date.
  AUTHSTA­TUS	String	VAR­CHAR2(1)	Man­datory		Could be either A- Authorized or U- Unauthorized.
  LOAD­GROUPID	String	VAR­CHAR2(16)	Optional		Could be any valid group ID maintained in system.
  FUNDID	String	VAR­CHAR2(6)	Optional		Could be any valid fund ID main­tained in the system.
  LOADID	Num­ber	NUM­BER(5)	Man­datory		Could be any valid load ID main­tained in the system.
  LOAD­SLABDE­TAILS	String	VAR­CHAR2(2000)	Optional		Could be any valid slab details maintained for the load in the system. It should have the slab number and the return value. Field separator is "," and record separator is ";". slabno>, <returnvalue>;
  DERIVED­LOAD­SLABDETAILS	String	VAR­CHAR2(2000)	Optional		Could be any valid slab details maintained for the derived load in the system. It has derived load id, and return value. Field separator is "," and record separator is ";". <derivedloadid> ,<returnvalue>;
  APPLY­RETVAL­UETOALLSLABS	Num­ber	NUM­BER(1)	Optional		Could be either 0-No or 1-Yes
  RETURN­VALUE	Num­ber	NUM­BER(15,6)	Optional		If the above field is ‘1’, then return value is applicable to all the slabs
  PRODUC­TID	String	VAR­CHAR2(10)	Optional		Could be any valid product ID maintained in the system. For UT it should be 'UT'. ‘ALL’ – Option would be applica­ble for all products.
  MAKERID	String	VAR­CHAR2(15)	Optional		If not supplied in the handoff file, value is defaulted as maintained in Bulk client defaults.
  MAKER­DATE	date	DATE	Optional		If not supplied in the handoff file, value is defaulted as maintained in Bulk client defaults.
  CHECK­ERID	String	VAR­CHAR2(15)	Optional		This field will be ignored. Always maker id in the template will be considered to update the checker id in the system.
  CHECK­ERDATE	date	DATE	Optional		If not supplied in the handoff file, value is defaulted as maintained in Bulk client defaults.
  POLICY­NUMBER	String	Var­char2(16)	Optional		Could be any valid Policy main­tained in the system. For UT, it should be 'UT'.
  DealBase­dOn	String	Varcahr2(1)	Optional		I – Inclusion Percentage A – Flat Rate Amount P – Flat Rate Percentage

2.29 Cheque Tracking File Format

For all imports of new and amended Cheque Tracking data, the external hand-off file containing the information must:

• 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 Name (as expected in the file)	Data type	Field length	Mandatory?	Characteristics / rules	Values
  SEGMENTID	String	20	Man­datory		Sequence no. of records in the file
  SEQUENCE­NUMBER	Num­ber	10	Man­datory		Sequence no. of records in the file
  PROCESSID	String	50	Man­datory		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.
  BULKCLI­ENTCODE	String	12	Man­datory		The Code of the Bulk client.
  IMPORTFILE­NAME	String	255	Man­datory		Name of the file being uploaded should be specified. Each file must have a unique name.
  AMCID	String	12	Man­datory		The ID of the AMC/Distributor for which the bulk client has maintained the defaults details.
  UPLOAD­MODE	String	1	Man­datory		“N” for New Mode and ‘E’ for Edit Mode, “M” for modify mode , “D” for delete mode.
  CHEQUETYPE	String	3	Man­datory		Should be valid type as main­tained in the system.
  TRANSAC­TIONNUM­BER	String	16			Transaction number should be specified if the Transaction Type is “RED”.
  FUNDID	String	6	Man­datory		The ID of a valid and enabled fund maintained in the system
  PAYMENT­NUMBER	Num­ber	5	Man­datory		Payment number should be specified if the Transaction Type is “UHD”.
  UNITHOLDE­RID	String	12	Man­datory		The Unit holder ID to identify a unit holder in the system, depending on the scheme/cross reference number.
  PRODUCTID	String	10	Optional		ID of the product under which the corresponding Policy has been created.
  CORPORA­TEACTION­TYPE	String	1	Optional		C- Cash Dividend S – Stock Dividend
  CHEQUEA­MOUNT	Num­ber	30,12	Man­datory		This field denotes the cheque Amount
  CHEQUE­CURRENCY	String	3	Man­datory		This field denotes the cheque currency
  CHEQUE­DATE	Date	10	Man­datory		For check payment modes, this is the date of issue of the check. Must not be later than the cur­rent application date..
  CHEQUE­NUMBER	String	16	Man­datory		Indicates the check number for Payment mode (Q) and Credit card number for pay­ment mode (R). This is man­datory if mode of Payment is check (Q) or credit card (R).
  OLD­CHEQUE­NUMBER	String	16	Optional		This field denotes the previ­ous cheque number.
  DRAWEE­BANK	String	12	Man­datory		Should be a valid Bank Code as defined in the system
  DRAWEE­BRANCH­CODE	String	12	Optional	Manda­tory	Should be a valid Branch Code as defined in the sys­tem
  DUPLICATE	String	1	Optional
  TRANSAC­TIONTYPE	String	4	Optional	Manda­tory	Should valid type as main­tained in the system.
  SPOOLSERI­ALNO	Num­ber	10	Optional		Unique Serial No.
  CHECKSTA­TUS	String	1	Man­datory		Check Status( N- New, A – Active, D- Duplicate, C- Cleared, I – Invalid)
  CHECK­PRINTED­DATE	Date	10	Optional		Actual Chq Printed Date
  FILENAME	String	30	Optional		Chq Upload File Name
  PROCESSED	String	1	Optional	Manda­tory	Unique Sequence number
  TIMESTAMP	Date	10	Optional		Date Time Stamp
  PRINTERID	String	15	Optional		Unique Sequence number
  MAKERID	String	15	Optional		There should not be any vali­dation 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
  MAKERDATE	Date	10	Optional		If the date is not specified in the import file, the application date is considered to be the Maker Date by default.
  DEPOSIT­RYID	String	12	Optional		DP Id
  PAYMENT­MODE	String	2	Man­datory		Indicates mode of payment. Can be any of the following values. Q-Cheque, T-Trans­fer, R-Credit card, C-Cash, D-Draft
  SUBPAY­MENTMODE	String	2	Optional		Can have valid values as defined in the mode of pay­ment table
  PAYINBANK	String	12	Optional		Should be a valid Bank as defined in the system.
  PAYIN­BRANCH	String	12	Optional		Should be a valid Brach as defined in the system.
  PAYINNUM­BER	String	12	Optional		Unique Serial Number
  MODULEID	String	30	Man­datory		Should be a valid module id as defined in the system.
  COMMIS­SION	Num­ber	30,12	Optional		Entity Commission Amount
  CHEQOP­TYPE	String	1	Optional		0 – Cheque 3 – Demand Draft 4 – Outstation Cheques/DD 5 - Others
  SYSREFER­ENCENUM­BER	String	25	Man­datory		Unique Serial number
  CHECKERID	String	15	Optional		This field represents the checker id who has author­ized the latest record.
  CHECKER­DATE	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 genera­tion.
  MICRCODE	String	40			Cheque MICR Code
  AUTHTYPE	String	1	Man­datory		Could be either of the follow­ing values: "U" - Unauthor­ized, "A" – Authorized
  IBAN	String	36	Optional		Used to capture the IBAN