1.2.5 Unit Holder Bank Details

This topic provides information on Unit Holder Bank Details.

Serial Number: 4

Segment Identification Number: 03BNK

Description: This segment is used for providing Unit Holder Bank related Information

Attributes: Mandatory

Table 1-6 Unit Holder Bank Details

Field Name (as expected in the file)	Data type	Length	Attributes	Characteristics/rules	Values
SEGMENTID	VARCHAR2	80	Mandatory	-	Segment ID. Value of Segment ID is 03BNK
SEQUENCENUMBER	NUMBER	10	Mandatory	-	Process ID
PROCESSID	VARCHAR2	50	Mandatory	-	Sequence Number
BANKCODE	VARCHAR2	12	Mandatory	-	Indicates the Entity bank code.
BRANCHCODE	VARCHAR2	12	Mandatory	-	Indicates the Entity branch code.
ACCOUNTTYPE	VARCHAR2	1	Mandatory	-	Indicates Type of the Account.
ACCOUNTNUMBER	VARCHAR2	34	Mandatory	-	Indicates Entity account number.
ACCOUNTNAME	VARCHAR2	140	Mandatory	-	Indicates Entity account name.
ACCOUNTCURRENCY	VARCHAR2	3	Mandatory	-	Indicates Entity account currency.
DEFAULTDETAILS	NUMBER	1	Mandatory	-	Indicates the default details
DIRECTDEBITAPPLICABLE	NUMBER	1	Optional	-	Indicates whether direct debit is applicable for the entity. If Yes (1) else (0).
ACCOUNTCATEGORY	VARCHAR2	1	Optional	-	Indicates the account category for the unitholder.
INITIALS	VARCHAR2	10	Optional	-	Indicates the initials for the unitholder entity.
LASTNAME	VARCHAR2	40	Optional	-	Indicates the last name for the unitholder entity.
IDENTIFICATIONTYPE	VARCHAR2	3	Optional	-	Indicates the type of identification used for the unitholder.
IDENTIFICATIONNUMBER	VARCHAR2	50	Mandatory	-	Indicates the identification number used for the unitholder.
STATUS	VARCHAR2	1	Optional	-	Indicates the Transaction status
IBAN	VARCHAR2	40	Optional	-	Indicates the International Bank Account Number.
UNITHOLDERID	VARCHAR2	12	Mandatory	-	Unitholder ID
REFERENCENUMBER	VARCHAR2	12	Optional	-	Indicates a unique reference Number for a Transaction. It can be entered by the user, otherwise it is system generated.
FUNDID	VARCHAR2	6	Mandatory	-	Indicates a unique Identification for each Fund in the system. It consists of maximum of 6 alphanumeric character. Its Foreign key is FUNDID column of FUNDDEMOGRAPHICSTBL Table.
TRANSACTIONTYPE	VARCHAR2	3	Mandatory	-	Indicates the Transaction Type for which Transaction Rules will be specified.
UHBICCODE	VARCHAR2	24	Optional	-	Unit Holder BIC Code
SWIFTFORMAT	VARCHAR2	6	Optional	-	Specifies Swift Format used for the entity
BANKCHARGED	VARCHAR2	12	Optional	-	Indicates bank charged
BENEFICIARY	VARCHAR2	35	Optional	-	Specifies Beneficiary name of the entity.
BENEFICIARYADD1	VARCHAR2	105	Optional	-	Specifies Entity's Beneficiary address line1.
BENEFICIARYADD2	VARCHAR2	105	Optional	-	Specifies Entity's Beneficiary address line2.
BENEFICIARYADD3	VARCHAR2	105	Optional	-	Specifies Entity's Beneficiary address line3.
BENEFICIARYBICCODE	VARCHAR2	24	Optional	-	Specifies BIC Code of the Beneficiary.
BENEFICIARYACCT NO	VARCHAR2	34	Optional	-	Specifies Beneficiary's Account NUMBER.
BENEFICIARYCODE	VARCHAR2	24	Optional	-	Specifies Unique code of the beneficiary.
BENEFICIARYINFO	VARCHAR2	100	Optional	-	Specifies Additional information about the beneficiary.
INTERMEDIARY	VARCHAR2	35	Optional	-	Specifies Intermediary name of the entity.
INTERMEDIARYADD1	VARCHAR2	105	Optional	-	Specifies Entity's Intermediary address line1.
INTERMEDIARYADD2	VARCHAR2	105	Optional	-	Specifies Entity's Intermediary address line2.
INTERMEDIARYADD3	VARCHAR2	105	Optional	-	Specifies Entity's Intermediary address line3.
INTERMEDIAYBICCODE	VARCHAR2	24	Optional	-	Specifies BIC Code of the Intermediary.
INTERMEDIARYACCTNO	VARCHAR2	34	Optional	-	Specifies Intermediary's Account number
INTERMEDIARYCODE	VARCHAR2	24	Optional	-	Specifies Unique code of the intermediary.
INTERMEDIARYINFO	VARCHAR2	100	Optional	-	Specifies Additional information about the intermediary.
FURTHERCREDITNAME	VARCHAR2	35	Optional	-	Specifies further credit name
FURTH-CREDITACCTNO	VARCHAR2	35	Optional	-	Specifies Account number to which further credits must be carried out.
REFERENCE1	VARCHAR2	35	Optional	-	Specifies Reference 1 for the Entity.
REFERENCE2	VARCHAR2	35	Optional	-	Specifies Reference 2 for the Entity.
RELATIONSHIP	VARCHAR2	40	Optional	-	Indicates the relationship between the Beneficiary and the customer.
BENEFICIARYIBAN	VARCHAR2	40	Optional	-	Specifies Beneficiary's International Bank Account NUMBER.
INTERMEDIARYIBAN	VARCHAR2	40	Optional	-	Specifies Intermediary's International Bank Account NUMBER.