You must define entity bank relationships when Custodian cash activity records contain internal custodian account numbers requiring translation to the Eagle Accounting entity id values. For a given custodian bank code, the Entity Bank Relationship feature provides a unique mapping for a custodian account to an Eagle STAR entity id. The entity bank relationship mappings are required when using the local MSGCENTER tables when loaded by custodian message streams.
To define an Entity Bank Relationship:
- From the Accounting Center window, click Accounts and then click Account Setup and Maintenance and Entity-Custodian Relationships.
- Double click Add Entity Bank Relationship.
You see the Add Entity Bank Relationships panel. - Complete the options on the panel.
- Click Submit.
...
Note |
---|
The Code Values table stores custodian bank codes using code category CUSTODIAN_BANK. |
Anchor | ||||
---|---|---|---|---|
|
Anchor | ||||
---|---|---|---|---|
|
...
- DataSetOption. Specifies the mode of comparison for Cash reconciliation. Refer to the Decide on the Mode of Comparison section for additional information.
- LoadSTARActivityStream. Specifies the stream to load pre-settled activity.
- LoadCUSTActivityStream. Specifies the stream to load custodian CSV files.
- LoadSettledActivityStream. Specifies the stream to load settled activity.
- MatchStream. Specifies the stream to match cash records from two sources on local tables in the MSGCENTER database.
- ResultsStream. Specifies the stream to post exceptions and establish downstream messages to adjust settled cash.
- AddCashStream. Specifies the stream to add cash transactions equal to the custodian cash transaction amount.
- RecPayStream. Specifies the stream to load pre-settled cash activity.
- CashTranStream. Specifies the stream to load settled cash activity.
- MatchStreamWH. Specifies the stream to match cash records from two sources on the CASH_ACTIVITY tables in the CASH database or one source and the ESTAR database traded/settled cash activity tables.