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