About the Variable Rates Default Message Stream

The Variable Rate default messages stream loads variable rates.

Variable rates are processed using the following streams:

• eagle_default_in_csv_variable_rates

• eagle_default_in_star_variable_rates

You must set Event Type (tag 55) to ADDVARRATE to process transactions using this stream.

Sample records, required fields, as well as panels, binds, and stored procedures for the Variable Rates stream are described in the following pages.

To review the results of processing in the database, use Issue Viewer under the Reference category in Eagle Accounting, or use the List Variable Rates query.

Resolve Security Alias for Variable Rates Stream

This section describes guidelines for resolving the security alias (tag 10) using the XREFERENCE table, for records processed by the Variable Rates default message stream.

To resolve security alias when using the Variable Rates default message stream:

1. Use the tag series 7052 to 7080 to specify an ordered list of xreference ID and types to use for security resolution using the XREFERENCE table. The XREFERENCE table is not updated by the actions of this step. Security resolution is handled by a LOOKUP statement in the rule. To refine the security lookup, you can specify several secondary fields that, when present, must also match to the table information for a successful security resolution:

   • Asset Currency (tag 85)

   • Xref Exchange (tag 1981)

   • Inactive Flag (tag 11043)

   • Maturity Date (tag 38) 

2. If unresolved, use the Primary Asset ID (tag 14) to resolve the security.

3. If not resolved using any of the arguments, a new security is assumed and a new security alias is generated.