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:
|
| 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:
|
| PAYMENTMODE | VARCHAR2 | 1 | Optional | - | Payment Mode:
|
| SUBPAYMENTMODE | VARCHAR2 | 2 | Optional | - | Subpayment Mode:
|
| PAYMENTTYPE | VARCHAR2 | 1 | Optional | - | Payment Type:
|
| 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 |
Parent topic: Income Distribution Setup File Format