As an example, you might create a field attribute with a name of Ask Price to represent the SECURITYDBO.PRICE_EXCHANGE.PX_ASK database field. If you were to setup a source rule, you would see the Ask Price name displayed as an option in the user interface and understand it represents Ask prices in the database, without having to know the specific underlying database field.
For system purposes, one or more field attributes may be created that reference the same field. In the image below, the Ask Price is associated with ID 6666 which is what you would select to use.
When working with field attributes, be sure to check the Show this Field option in order for the field to be displayed.
RDC Prices requires you to have two types of field attributes setup in an environment. These are vendor price type field attributes, and gold copy price type field attributes.
Vendor Price Type
The vendor price type field attributes represent the types of prices you request from various vendors. For each vendor price type you plan to request, a field attribute needs to be created. For example, if you plan to request Ask, Bid, Mid, Open and Mean prices, you need to create a field attribute for each of those price types. They are created against the PRICE_EXCHANGE table in the SECURITY database as illustrated in the example below.
Gold Copy Price Type
The Gold Copy price type field attribute is the field that Gold Copy prices are composited to, once a Best of Breed price has been determined. They are created against the PRICE table in the SECURITY database.
This can be any field in the PRICE table, but is typically the SECURITY.PRICE.PRICE field for Eagle Accounting clients.
0 Comments