1.7.8 Broker Related Party Related Information

This topic provides information on broker related party related details.

Serial Number: 7

Segment Identification Number: 06REL

Description: This segment is used for providing Broker Related Party related details.

Attributes: Optional

Table 1-60 Broker Related Party Related Information

Field Name (as expected in the file)	Data type	Length	Attributes	Characteristics/rules	Values
SEGMENTID	VARCHAR2	80	Optional	-	Segment ID. Value for Segment ID is 06REL
SEQUENCENUMBER	NUMBER	22	Mandatory	-	Sequence Number
PROCESSID	VARCHAR2	50	Mandatory	-	Process ID
BROKERCODE	VARCHAR2	12	Mandatory	-	The code to uniquely identify the broker. Broker code and rule effective date forms a PRIMARY KEY combination.
RULEEFFECTIVEDATE	DATE	-	Mandatory	-	The date from which the changes are applicable. This along with broker code forms the PRIMARY KEY.
RPENTITYID	VARCHAR2	12	Mandatory	-	Indicates the unique identification code for the related party entity associated with the unitholder.
RPENTITYTYPE	VARCHAR2	1	Mandatory	-	Indicates the entity type of the unitholder's related party.
PREFMAILMODE	VARCHAR2	1	Optional	-	Indicates the preferred mail mode for the related party entity.
REPORTINGLEVEL	VARCHAR2	1	Optional	-	Indicates which all reports to be sent to the entities mapped.
REMARKS	VARCHAR2	255	Optional	-	Indicates the descriptive remarks column for the record.
APPLYTO	VARCHAR2	12	Yes	-	Based on the level selected in the Related party Level field ,the user can either select fund ID (if he has selected Fund in Related Party Level) or AMC ID (if he has selected AMC Related Party Level) etc. If the user selects ALL in the Related Party Level then the system will default ALL in this field also and the user will not be allowed to edit it.
APPLYLEV EL	VARCHAR2	3	Yes	-	Related party level would specify at which level does the user wants to associate the Related Party. The possible LOV values are – ALL, AMC, Fund, Fund Family, Legal entity