Third Party Bank Accounts Report

Provides a report on Main Product Level of all Bank Accounts for Third Party Payments linked to a third party payee.

 

Select Third Party Bank Accounts Report from the sub-menu on the left.

 

 

Click  alongside Third Party Bank Accounts Report on the sub-menu on the left.  Additional options will be displayed.

 

 

New

Select New below Third Party Bank Accounts Report.  The Third Party Bank Accounts Report screen will be displayed.

 

 

Capture data as follows:

 

Scheme

The Scheme for the report.

 

Click LIST to display a list of schemes.

 

The following screen is displayed for scheme selection.

 

 

Click on a Scheme Code and click SELECT.

From Date

The start date of the reporting period.

 

Mandatory

To Date

The end date of the reporting period.

 

Mandatory

Payee

The Third Part Payee.

 

Select a value from the drop-down list.

 

Note:

A list of Payees will not be displayed for selection until a Scheme has been selected.

 

Click GENERATE REPORT.

 

Processing

When GENERATE REPORT is selected, the following information will be extracted:

 

FIELD NAME

SOURCE OF INFORMATION

Main Scheme Code

Pooling Status equal to MAIN UMBRELLA or MAIN FUND.

Sub Scheme Code

Pooling Status equal to SUB UMBRELLA.

User ID

DOER USERID.

Client Code

Code of the Corporate Client linked as Bank Account for the Scheme.

Client Name

Name of the Corporate Client linked as Bank Account for the Scheme.

Bank Name

Name of the Bank Account of the Corporate Client linked to the Scheme.

Bank Branch

Name of Bank Branch of the Corporate Client linked to the Scheme.

Bank Code

Code on the JU1AR Bank List linked to the Bank Account of the Corporate Client linked to the scheme.

Account Number

Account Number of the Bank Account for the Corporate Client linked to the Scheme.

Account Name

Accountholder Description on JU1CC Product Bank Account List for Corporate Client linked to the Scheme.

Start Date

Start Date on JU1CC Product Bank Account List for the Corporate Client linked to the Scheme.

End Date

End Date on JU1CC Product Bank Account List for the Corporate Client linked to the Scheme.

Bank Interface

Bank Interface on JU1CC Product Bank Account Detail for the Corporate Client linked to the Scheme.

Amount Paid

For the Account BANK, retrieve the business transactions with transaction dates greater than or equal to the From Date and less or equal to the To Date of the criteria provided.

Payment Date

The Timestamp when the business transaction was authorised.

 

View

Select View below Third Party Bank Accounts Report.  The Third Party Bank Accounts Report screen will be displayed.

 

 

The following columns are displayed:

 

-  Scheme

-  Processing Timestamp

-  Date Captured

-  Report Type

-  Sequence Number

-  Status

-  Action

 

To view the details of a report, click on the hyperlinked display in the Action column.  The Third Party Bank Acc Report screen will be displayed.

 

 

The following columns are displayed:

 

-  Main Scheme

-  Sub Scheme

-  User ID

-  Client Code

-  Client Name

-  Bank Name

-  Bank Branch

-  Bank Code

-  Account Number (for each Account)

-  Account Name (for each Account)

-  Start Date

-  End Date

-  Bank Interface

-  Amount Paid

-  Payment Date