1.5.2 Income Distribution Related Information

This topic provides information on income distribution related information.

Serial Number: 1

Segment Identification Number: 00IDI

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

Attributes: Mandatory

Table 1-43 Income Distribution Related Information

Field Name (as expected in the file) Data type Length Attributes Characteristics/rules Values
SEGMENTID VARCHAR2 20 Mandatory - Segment ID. Value should be 00IDI
SEQUENCENUMBER NUMBER 22 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 Mandatory - Upload Mode
AMCID VARCHAR2 12 Optional - AMC ID
REFUNITHOLDERID VARCHAR2 12 Optional - Reference UnitHolder ID
FUNDID VARCHAR2 25 Mandatory - Fund ID
DISTRIBUTIONMODE VARCHAR2 1 Optional -
Distribution Mode:
  • P - Full Payment
  • R - Full Reinvestment
  • B - Both
PAYMENTSPLITPERCENTAGE NUMBER 22 Optional - Payment Percentage
CHEQUEPAYMENTSPLIT NUMBER 22 Optional - Cheque Payment Split Percentage
TRANSFERPAYMENTSPLIT NUMBER 22 Optional - Transfer Payment Split Percentage
XFERBANKCODE VARCHAR2 12 Optional - Transfer Bank Code
XFERBRANCHCODE VARCHAR2 12 Optional - Transfer Branch Code
XFERACCOUNTTYPE VARCHAR2 1 Optional - Transfer Account Type
XFERACCOUNTNUMBER VARCHAR2 20 Mandatory - Transfer Account Number
XFERACCOUNTCURRENCY VARCHAR2 3 Optional - Transfer Account Currency
AGENTCODE VARCHAR2 12 Mandatory - Agent Code
BRANCHCODE VARCHAR2 12 Mandatory - Branch Code
RULEEFFECTIVEDATE DATE 7 Mandatory - Rule Effective Date
USERID VARCHAR2 15 Mandatory - Represents the user ID who has entered the latest record
AUTH_STAT VARCHAR2 1 Optional -
Authorization Status:
  • A - Authorized
  • U - Unauthorized
PAYMENTMODE VARCHAR2 1 Optional -
Payment Mode:
  • Q - Cheque - Cheque
  • T - Transfer - Transfer
SUBPAYMENTMODE VARCHAR2 2 Optional -
Subpayment Mode:
  • Q - Cheque - Cheque
  • T - Transfer - Transfer
PAYMENTTYPE VARCHAR2 1 Optional -
Payment Type:
  • S - Self
  • T - Third Party
  • E - Entity
THIRDPARTYPAYMENTREFERENCE VARCHAR2 255 Optional - Third Party Reference
THIRDPARTYPAYMENTADDRESS VARCHAR2 255 Optional - Third Party Payment Address
THIRDPARTYPAYMENTCITY VARCHAR2 20 Optional - Third Party Payment City
THIRDPARTYPAYMENTSTATE VARCHAR2 20 Optional - US State / Non-US State
USSTATE NUMBER 22 Optional -

US State:

1 - Yes

0 - No

THIRDPARTYPAYMENTZIPCODE VARCHAR2 10 Optional - Third Party Payment Zip Code
XFERACCOUNTHOLDERNAME VARCHAR2 100 Mandatory - Transfer Account Holder Name
ENTITYTYPE VARCHAR2 1 Optional -

Entity Type:

B - Broker

ENTITYID VARCHAR2 12 Optional - Entity ID
REFFUNDID VARCHAR2 6 Mandatory - Reference Fund ID
IDSENTITYTYPE VARCHAR2 1 Mandatory -

Unit Holder Or Broker

U - Unitholder, B - Broker

IDSENTITYID VARCHAR2 12 Optional - Unitholder ID Or Broker Code
SWIFTFORMAT VARCHAR2 6 Optional - Swift Format
BANKCHARGED VARCHAR2 12 Optional - Bank Charged
BENEFICIARY VARCHAR2 35 Optional - Beneficiary
BENEFICIARYADD1 VARCHAR2 105 Optional - Beneficiary Address1
BENEFICIARYADD2 VARCHAR2 105 Optional - Beneficiary Address2
BENEFICIARYADD3 VARCHAR2 105 Optional - Beneficiary Address3
BENEFICIARYBICCODE VARCHAR2 24 Optional - Beneficiary BIC Code
BENEFICIARYACCTNO VARCHAR2 34 Optional - Beneficiary Account No
BENEFICIARYCODE VARCHAR2 24 Optional - Beneficiary Code
BENEFICIARYINFO VARCHAR2 100 Optional - Beneficiary Info
INTERMEDIARY VARCHAR2 35 Optional - Intermediary
INTERMEDIARYADD1 VARCHAR2 105 Optional - Intermediary Address1
INTERMEDIARYADD2 VARCHAR2 105 Optional - Intermediary Address2
INTERMEDIARYADD3 VARCHAR2 105 Optional - Intermediary Address3
INTERMEDIARYBICCODE VARCHAR2 24 Optional - Intermediary BIC Code
INTERMEDIARYACCTNO VARCHAR2 34 Optional - Intermediary Account No
INTERMEDIARYCODE VARCHAR2 24 Optional - Intermediary Code
INTERMEDIARYINFO VARCHAR2 100 Optional - Intermediary Info
FURTHERCREDITNAME VARCHAR2 35 Optional - Further Credit Name
FURTHERCREDITACCTNO VARCHAR2 35 Optional - Further Credit Account Number
REFERENCE1 VARCHAR2 35 Optional - Reference1
REFERENCE2 VARCHAR2 35 Optional - Reference2
POLICYNUMBER VARCHAR2 16 Optional - Policy Number
PRODUCTID VARCHAR2 10 Optional - Product ID
PAYMENTCURRENCY VARCHAR2 3 Optional - Payment Currency
IBAN VARCHAR2 40 Optional - IBAN
BENEFICIARYIBAN VARCHAR2 40 Optional - Beneficiary IBAN
INTERMEDIARYIBAN VARCHAR2 40 Optional - Intermediary IBAN