2.1.5 EPU Upload File Format

This topic explains the information about the details of EPU Upload File Format.

EPU upload is specific to OMSTA, as the assumption is that OMSTA maintains the following components and those component names are hard-coded in DIVIDENDEPUIMPTBL:

Table 2-28 EPU Upload File Format

Field Name	Data Type	Remarks
Fund Id	Char (3)	The fund id in FCIS.
Distribution Type	Char (1)	This field will be ignored and the dividend type in FCIS will be treated as cash dividend.
Gross Or Net Distribu- tion	Char (1)	This field will be ignored.
Declaration Date	Date	The interface will verify if there is any generated cash dividend record for this date, and will update that record with the required EPU.
Payment Date/Reinvestment Date	Date	This field will be ignored by the interface.
Gross Amount	Float	This will be a dividend component. Component code ‘GA’.
Dividend Amount	Float	This will be a dividend component. Component code ‘DA’.
Dividend Amount Foreign	Float	This will be a dividend component. Component code ‘AF’.
Dividend Amount Foreign Withholding Tax	Float	This will be a dividend component. Component code ‘WF’.
Dividend Amount Foreign Exempt	Float	This will be a dividend component. Component code ‘EF’.
Interest Amount	Float	This will be a dividend component. Component code ‘IA’.
Interest Amount Local	Float	This will be a dividend component. Component code ‘IL’.
Interest Amount Foreign	Float	This will be a dividend component. Component code ‘IF’.
Interest Amount Foreign Withholding Tax	Float	This will be a dividend component. Component code ‘TF’.
NPI Amount	Float	This will be a dividend component. Component code ‘NP’.
Interest Withheld Tax Amount	Float	This will be a dividend component. Component code ‘IT’.
Property Dividend Amount	Float	This will be a dividend component. Component code ‘PD’.