1.8.2 Unit Holder Deal Related Information

This topic provides information on unit holder deal related information.

Serial Number: 1

Segment Identification Number: 00UHD

Description: This segment is used for providing Unit Holder Deal Related Information.

Attributes: Mandatory

Table 1-62 Unit Holder Deal Related Information

Field Name (as expected in the file)	Data type	Length	Attributes	Characteristics/rules	Values
SEGMENTID	VARCHAR2	80	Mandatory	-	Segment ID. Value for Segment ID is 00UHD
SEQUENCENUMBER	NUMBER	10	Mandatory	-	Sequence Number
PROCESSID	VARCHAR2	50	Mandatory	-	Process ID
BULKCLIENTCODE	VARCHAR2	12	Mandatory	-	Bulk Client Code
IMPORTFILENAME	VARCHAR2	255	Mandatory	-	Import File Name
UPLOADMODE	VARCHAR2	1	Optional	-	Upload Mode
AMCID	VARCHAR2	12	Mandatory	-	AMC ID
DEALTRANSACTIONNUMB ER	VARCHAR2	16	Optional	-	UH Deal Transaction Number
UHIDORCIFNUMBER	VARCHAR2	12	Mandatory	-	Unit Holder ID / CIF NUMBER
APPLYATCIFLEVEL	NUMBER	1	Optional	-	Apply At CIF Level. 1-Yes 0-No
APPLYDEALAT	VARCHAR2	1	Mandatory	-	Apply Deal At. L-Load Level G-Load Group Level F-Fund Level P- Product Level
STATUS	VARCHAR2	1	Mandatory	-	Status
EFFECTIVESTARTDATE	DATE	7	Mandatory	-	Effective Start Date
EFFECTIVEENDDATE	DATE	7	Optional	-	Effective End Date
AUTH_STAT	VARCHAR2	1	Mandatory	-	Authorization Status. A- Authorized U-Unauthorized
LOADGROUPID	VARCHAR2	16	Optional	-	Load Group ID
FUNDID	VARCHAR2	6	Optional	-	Fund ID
LOADID	NUMBER	5	Mandatory	-	Load ID
APPLYRETVALUETOALLSLABS	NUMBER	1	Optional	-	Value for the return values are changed as in the excel only if the value for APPLYRETVALUE- TOALLSLABS is '1'.
RETURNVALUE	VARCHAR2	30	Optional	-	Return Value
PRODUCTID	VARCHAR2	10	Optional	-	Product ID
USERID	VARCHAR2	320	Mandatory	-	Indicates the user ID who has entered the latest record
POLICYNUMBER	VARCHAR2	16	Optional	-	Policy Number
DEALBASEDON	VARCHAR2	1	Optional	-	Deal Based On
TAXTYPE	VARCHAR2	1	Optional	-	Tax Type: D-Directive I- Instruction