1.12.2 Dividend Declaration Upload
This topic provides information on dividend declaration upload.
Serial Number: 1
Segment Identification Number: 00DIV
Description: This segment is used to provide Fund Dividend master details.
Attributes: Mandatory
Table 1-79 Dividend Declaration Upload
| Field Name | Description | Data Type | Attributes | Table Name |
|---|---|---|---|---|
| PROCESSID | Process ID | VARCHAR2( 50) | Mandatory | BULKFUNDDIVIDENDDECLARETBL |
| SEGMENTID | Segment ID | VARCHAR2( 50) | Mandatory | BULKFUNDDIVIDENDDECLARETBL |
| SEQUENCENUMBER | Sequence Number | NUMBER(10) | Mandatory | BULKFUNDDIVIDENDDECLARETBL |
| BULKCLIENTCODE | Bulk Client Code | VARCHAR2( 12) | Mandatory | BULKFUNDDIVIDENDDECLARETBL |
| IMPORTFILENAME | Import File Name | VARCHAR2( 255) | Mandatory | BULKFUNDDIVIDENDDECLARETBL |
| UPLOADMODE | Upload Mode | VARCHAR2( 1) | Mandatory | BULKFUNDDIVIDENDDECLARETBL |
| FUNDID | Fund ID | VARCHAR2( 6) | Mandatory | BULKFUNDDIVIDENDDECLARETBL |
| CORPORATEACTIONTYPE | Corporate Action Type | VARCHAR2( 1) | Mandatory | BULKFUNDDIVIDENDDECLARETBL |
| DIVIDENDNUMBER | Dividend Number | NUMBER(5) | Optional | BULKFUNDDIVIDENDDECLARETBL |
| DIVIDENDFROMDATE | Dividend From Date | DATE | Mandatory | BULKFUNDDIVIDENDDECLARETBL |
| DIVIDENDTODATE | Dividend To Date | DATE | Mandatory | BULKFUNDDIVIDENDDECLARETBL |
| BOOKCLOSINGFROMDATE | Book Closing From Date | DATE | Optional | BULKFUNDDIVIDENDDECLARETBL |
| BOOKCLOSINGTODATE | Book Closing To Date | DATE | Optional | BULKFUNDDIVIDENDDECLARETBL |
| FREEZEHOLDINGSDATE | Freeze Holdings Date | DATE | Optional | BULKFUNDDIVIDENDDECLARETBL |
| BOARDOFDIR MTGDATE | Board of Dirmtg Date | DATE | Optional | BULKFUNDDIVIDENDDECLARETBL |
| DIVIDENDDECLAREDATE | Dividend Declare Date | DATE | Optional | BULKFUNDDIVIDENDDECLARETBL |
| EARNINGSPERUNIT | Earnings per Unit | NUMBER(20) | Optional | BULKFUNDDIVIDENDDECLARETBL |
| PROCESSEDTYPE | Processed Type | VARCHAR2( 1) | Mandatory | BULKFUNDDIVIDENDDECLARETBL |
| EXCHANGERATEDATEFORDIVIDEND | Exchange Rate Date For Dividend | DATE | Optional | BULKFUNDDIVIDENDDECLARETBL |
| STOCKDIVIDENDPARENTRATIO | Stock Dividend Parent Ratio | NUMBER(22) | Optional | BULKFUNDDIVIDENDDECLARETBL |
| STOCKDIVIDENDRESULTANTRATIO | Stock Dividend Resultant Ratio | NUMBER(22) | Optional | BULKFUNDDIVIDENDDECLARETBL |
| NPI | NPI | NUMBER(20) | Mandatory | BULKFUNDDIVIDENDDECLARETBL |
| EQUALIZATIONRATE | Equalization Rate | NUMBER(20) | Mandatory | BULKFUNDDIVIDENDDECLARETBL |
| STOCKDIVIDENDTYPE | Stock Dividend Type | VARCHAR2( 1) | Optional | BULKFUNDDIVIDENDDECLARETBL |
| OVERRIDEFATCAWHT | Override FATCA WHT | NUMBER(1) | Optional | BULKFUNDDIVIDENDDECLARETBL |
| GRANDFATHEREDOBLIGATION | Grand Fathered Obligation | NUMBER(1) | Optional | BULKFUNDDIVIDENDDECLARETBL |
| DISTRIBUTIONTYPE | Distribution Type | VARCHAR2( 3) | Optional | BULKFUNDDIVIDENDDECLARETBL |
| GROSSNETEPUFLAG | Gross Net EPU Flag | VARCHAR2( 1) | Optional | BULKFUNDDIVIDENDDECLARETBL |
| GENERATEREDEMPTION | Generate Redemption | VARCHAR2( 1) | Optional | BULKFUNDDIVIDENDDECLARETBL |
Serial Number: 2
Segment Identification Number: 01CMP
Description: This segment is used to provide Fund Dividend EPU/Lot Component value details.
Attributes: Optional
Table 1-80 Dividend Declaration Upload
| Field Name | Description | Data Type | Attributes | Table Name |
|---|---|---|---|---|
| PROCESSID | Process ID | VARCHAR2(50) | Mandatory | BULKFUNDDIVIDENDCOMPVALUESTBL |
| SEGMENTID | Segment ID | VARCHAR2(20) | Mandatory | BULKFUNDDIVIDENDCOMPVALUESTBL |
| SEQUENCENUMBER | Sequence Number | NUMBER(10) | Mandatory | BULKFUNDDIVIDENDCOMPVALUESTBL |
| COMPONENTID | Component ID | VARCHAR2(2) | Mandatory | BULKFUNDDIVIDENDCOMPVALUESTBL |
| COMPONENTVALUE | Component value | NUMBER(30) | Mandatory | BULKFUNDDIVIDENDCOMPVALUESTBL |
| FDAPINCOME | FDAP income | NUMBER(1) | Optional | BULKFUNDDIVIDENDCOMPVALUESTBL |
Serial Number: 3
Segment Identification Number: 02REP
Description: This segment is used to provide Fund Dividend Report Component value details.
Attributes: Optional
Table 1-81 Dividend Declaration Upload
| Field Name | Description | Data Type | Attributes | Table Name |
|---|---|---|---|---|
| PROCESSID | Process ID | VARCHAR2(50) | Mandatory | BULKFUNDDIVREPORTCOMPTBL |
| SEGMENTID | Segment ID | VARCHAR2(20) | Mandatory | BULKFUNDDIVREPORTCOMPTBL |
| SEQUENCENUMBER | Sequence Number | NUMBER(10) | Mandatory | BULKFUNDDIVREPORTCOMPTBL |
| COMPONENTID | Component ID | VARCHAR2(2) | Mandatory | BULKFUNDDIVREPORTCOMPTBL |
| COMPONENTVALUE | Component value | NUMBER(30) | Mandatory | BULKFUNDDIVREPORTCOMPTBL |
Parent topic: Dividend Declaration Upload