Add Equity Securities
To manually add an equity security:
In Accounting Center, in the left navigation pane, click Setup > Securities > Manage Securities > Issue Viewer.
You see the Issue Viewer tool.Click the Add arrow.
Point to Equities and click Equity/Mutual Fund.
You see the Equity/Mutual Fund panel.Complete the options on the Equity/Mutual Fund panel.
The following fields are required to set up an equity security: Issue Name, Primary Asset ID Type, Primary Asset ID, Processing Security Type, Issue Country Code, Asset Currency, Settlement Currency, Income Currency, Primary Exchange Code, and Maturity Price.Click Submit.
Change Equity Securities
Some fields are locked when there is an existing position on the security. This is because a change would impact the existing position. These fields include Asset Currency, Investment Type, Processing Security Type, Quantity Type, Price Multiplier, and Quantity Scale. Other fields are locked so they cannot be changed. See the About Locked Security Master Record Fields in Issue Viewer page for more information.
Tip |
---|
If you need to change a security master record, Eagle recommends canceling the security, making changes to the security master record, and rebooking the security. |
To manually change an equity security:
In Accounting Center, in the left navigation pane, click Setup > Securities > Manage Securities > Issue Viewer.
You see the Issue Viewer tool.Enter the query parameters and click Search.
You see a list of security records that meet your selection criteria in the Query Result window.Select the security record you want to update, click the Change arrow, and then click Change/Equity/Mutual Fund/Cost Method. Or double-click the security record.
You see the Change Equity/Mutual Fund/Cost Method panel.Change the options on the Change Equity/Mutual Fund/Cost Method panel.
Click Submit.
Equity/Mutual Fund Panel Options
The following are the options in the Equity/Mutual Fund panel. Note options may vary according to your selections.
Option | Tag | Description |
---|---|---|
SRM Status Flag | ||
Release Status | 614 | Displays the release status of the Security Reference Manager (SRM) record. This field is null when you are adding a new security. |
Validation Process Flag | 4569 | Flags records that have been reviewed in the Security Reference Manager (SRM). |
Authorize Flag | 11742 | Flags records that have been authorized. |
Equity/Mutual Fund Identification | ||
Issue Name | 961 | Specifies the name of the security. |
Issue Description | 962 | Describes the security. |
Ticker | 13 | Specifies the system of letters used to uniquely identify a security. |
CUSIP/SEDOL Check Digit Control Flag | 2292 | Indicates whether you want to generate or validate CUSIP and SEDOL numbers. Options include:
|
Primary Asset ID Type | 1432 | Specifies the primary asset identifier type for the security, such as CUSIP, ISIN, and SEDOL. |
Primary Asset ID | 14 | Specifies the primary asset identifier for the security. |
Alt Asset ID Type | 5501 | Specifies an alternate asset identifier type for the security. |
Alt Asset ID | 1795 | Specifies the alternate asset identifier for the security. |
Equity/Mutual Fund Xreference Identification | ||
CUSIP | 1952 | Specifies the Committee of Uniform Security Identification Procedure (CUSIP), a unique identification number that identifies the security issue. |
ISIN | 1955 | Specifies the International Security Identification (ISIN), a unique international identification number that identifies the security issue. |
Sedol | 1958 | Specifies the Stock Exchange Daily Official List (SEDOL) number, a unique identification number that identifies the security issue. |
Reuters | 1961 | Specifies the Reuters identification number that identifies the security issue. |
Bloomberg ID | 1964 | Specifies the Bloomberg identification number that identifies the security issue. |
SICOVM | 1967 | Specifies the SICOVM identification number that identifies the security issue. |
Valoren | 1970 | Specifies the Valoren identification number that identifies the security issue. |
Cash Matching ID | 1973 | Identifies the security issue for use in cash matching when you use cash segregation. If you set up security cross reference identifiers of CMM for use with cash matching, you can provide a Cash Matching ID for each security you plan to use in cash matching. |
INTERNAL | 1976 | Specifies the internal identification number that identifies the security issue. |
CINS | 1979 | Specifies the CINS identification number that identifies a foreign security issue. The CINS numbering system is an extension of the CUSIP numbering system. |
Xref Exchange | 1981 | Specifies the exchange where the security is traded. |
Equity/Mutual Fund Details | ||
Investment Type | 11 | Displays the type of investment you are adding. For example EQ (equity). Or if you use the equity method of accounting and create a Joint Venture/Limited Liability/Partnership security, EC (Equity/Cost). |
Processing Security Type | 3931 | Specifies the code that the system uses to identify the type of security you are adding. Options include:
For information about creating a Mutual Fund (EQEQMF) security, see Manage Mutual Funds in Issue Viewer. For information about creating a Joint Venture/Limited Liability/Partnership (JVLCLP) security, see Manage Joint Venture/Limited Liability/Partnership Securities in Issue Viewer. |
Security Type | 82 | Specifies the security type. |
Sub Security Type | 1464 | Specifies the sub security type. |
Granularity Category | 11476 | Specifies the asset's classification for ledger granularity purposes. If the security attributes available for ledger granularity account breakouts (security type, long/short indicator, Federal tax indicator, market sector description, affiliated/unaffiliated, and issue country) do not provide enough detail, you can use a granularity category to classify the asset for ledger reporting. Code values are maintained under the GRANULARITY_CAT code category. |
Cost Basis Rule Type | 2817 | Specifies the cost basis rule type for cost basis reporting. |
Quantity Type | 12 | Displays the quantity generally accepted as a standard for exchange, such as Shares. For a Joint Venture/Limited Liability/Partnership security, options include Shares, Units, or Percentage. |
Price Multiplier | 18 | Determines what the system uses for a price. In the case of an equity security, the system defaults to a price of 1.00. You should not change this value once a position exists. |
Quantity Scale | 19 | Calculates the ratio of units bought to units used for earnings. The default is 1, so that 1 unit of par purchased equals one unit of earnings. You should not change this value once a position exists. |
Country of Risk | 2288 | Specifies the issuer of the security's principal place of business. |
Country of Risk Code | 10536 | Specifies the code of the issuer of the security's principal place of business. |
Issue Country | 2290 | Specifies the name of the country that issued the security. |
Issue Country Code | 1418 | Specifies the identification number that represents the country that issued the security. |
Asset Currency | 85 | Specifies the currency in which the security is priced. |
Settlement Currency | 63 | Specifies the currency in which the security is settled. |
Income Currency | 1186 | Specifies the currency in which the security pays income. |
Issue Tax Type | 668 | Identifies the security's tax structure. It is used with global tax withholding and tax reclaim processing. NOTE: Do not select All when setting up the tax structure for a security using this panel. |
Primary Exchange | 2291 | Specifies the marketplace in which the security is traded. |
Primary Exchange Code | 17 | Specifies the code of the marketplace in which the security is traded. |
Region | 5423 | Specifies a region. It does not necessarily mean the location of the exchange in which a security is traded. For example, suppose you have a Canadian bond that trades in the London Stock Exchange. You may want to set the region to Canada or North America. |
State Code | 1343 | Specifies the state in which the security is issued. |
Dividend Frequency | 3213 | Projects cash flows and processes PIK preferred corporate actions. Options include:
|
Indicated Annual Dividend | 3233 | Specifies the expected amount of the dividend. |
Shares Outstanding | 3244 | Specifies the remaining shares in the hands of investors. |
SIC Code | 1789 | Specifies the Standard Industry Classification (SIC), a code used to categorize and uniquely identify business activities. |
GL Product Code | 11094 | Specifies the GL product code. |
Equity/Mutual Fund Flags | ||
Convertible Indicator | 3246 | Indicates whether the security is a convertible bond. Options include:
|
Close End Flag Fund | 1792 | Indicates whether the security is part of an open end fund. Options include:
This field is used with mutual fund securities only. |
RIC Flag | 1445 | Indicates whether the security is issued from a Registered Investment Company (RIC). Options include:
|
REIT Flag | 16159 | Indicates whether the security is a Real Estate Investment Trust (REIT). Options include:
|
PIK Flag | 1777 | Indicates whether the security is a PIK (payment in kind) preferred stock. Options include:
NOTE: This field must be set to Yes to add a PIK preferred corporate action. |
Restricted Flag | 1139 | Indicates any trade restrictions on the security. Options include:
|
Multi Listed Flag | 4565 | Indicates whether the security is listed, traded, and priced on multiple trading exchanges. Options include:
|
Refund Indicator | 3132 | Indicates whether the security is eligible for pre-refunding, an entire issue call, or a mandatory put. Options include:
|
144A Eligible Indicator | 1301 | Indicates whether the security is 144A eligible. Options include:
This field applies to debt instruments and is used for reference only. |
Look Thru Value | 1808 | Specifies the underlying security. |
Look Thru Ind | 1776 | Used to view exposure to the underlying security, index, or portfolio. |
QDI Eligible Flag | 2905 | Identifies securities that are QDI (qualified dividend income) eligible. Options include:
NOTE: You must set the QDI Eligible Flag field (tag 4487) to No at the entity or master fund level. Otherwise, the system uses dividends with countries populated on the QDI Tax Treaty table to determine QDI eligibility. |
PFIC Flag | 2906 | Indicates PFIC (passive foreign investment company) security eligibility. Options include:
NOTE: Dividends from PFICs, foreign personal holding companies, and foreign investment companies are not QDI eligible. To manually exclude PFICs from QDI eligibility, use the Create Security Processing Rule panel to add a security processing rule. Once you add the rule, use the Edit Security Processing Rule panel to set the PFIC Flag field (tag 2906) to Yes. You can then update the security master file record by setting the PFIC Flag field (tag 2906) to Yes and applying the security processing rule by selecting a value from the Security Processing Rule ID field (tag 2964). Next, use the Create Basis Processing Rule panel to add a basis processing rule. You can add different processing rules with different securities in the event that all security PFIC rules do not apply to all entities. Once you add the rule, use the Edit Basis Processing Rule panel to add additional securities. Finally, add the Basis Processing Rule ID field (tag 2965) at the entity level. |
DRD Flag | 2907 | Indicates DRD (dividend received deduction) eligibility. Options include:
|
Hybrid Flag | 2908 | (For future use) Indicates whether the security is a hybrid. Options include:
|
SVO Category | 5856 | Specifies the Securities Valuation Office category for the security. |
Inactive Flag | 11043 | Indicates whether the security is inactive. Options include:
NOTE: If this field is set to Yes, no trades are allowed. |
Convertible/Underlying Information | ||
Underlying Security ID | 1348 | Specifies the identifier of the security in which a convertible bond is converted. |
Underlying Issue Name | 1141 | Specifies the name of the security in which a convertible bond is converted. |
Underlying Ticker | 1349 | Specifies the ticker of the underlying security. |
Underlying Type | 916 | Specifies the underlying security type. |
Conversion Ratio | 215 | Specifies the number of shares of the underlying security the owner of the parent security receives based on converting 1000 units of the parent security. |
GICS Industry Information | ||
GICS Sector | 10181 | Specifies the GICS sector code for the security. Code values are maintained under the GICSSECTOR code category. |
GICS Sector Name | 10182 | Displays the GICS sector name for the security associated with the GICS sector. |
GICS Industry Group | 10183 | Specifies the GICS industry group code for the security. Code values are maintained under the GICSINDGROUP code category. |
GICS Industry Group Name | 10184 | Displays the GICS industry group name for the security associated with the GICS industry group. |
GICS Industry | 10185 | Specifies the GICS industry code for the security. Code values are maintained under the GICSINDUSTRY code category. |
GICS Industry Name | 10186 | Displays the GICS industry name for the security associated with the GICS industry. |
GICS Sub Industry | 10187 | Specifies the GICS sub industry code for the security. Code values are maintained under the GICSSUBIND code category. |
GICS Sub Industry Name | 10188 | Displays the GICS sub industry name for the security associated with the GICS sub industry. |
Issuer Information | ||
Credit Enhancement | 1532 | Indicates whether the security is credit enhanced. Options include:
|
Issue Name | 2285 | Specifies the name of the issuer. |
Issuer ID | 1413 | Specifies the identifier of the company or municipality that offered the equity security for sale. |
Country of Incorporation Code | 1174 | Specifies the ISO country code in which the issuer of the security was incorporated. |
Issuer Industry | 1417 | Specifies the issuer industry. |
Legal Entity Identifier (LEI) | 5089 | Displays the Legal Entity Identifier (LEI) that identifies the issuer as a financial party. If an LEI value is present, the Legal Entity Identifier Details section displays additional information. |
Legal Entity Identifier Details | ||
Legal Name | 5090 | Displays the legal name of the issuer as the financial party registered with the LEI. |
Entity Status | 5091 | Displays the status of the issuer. For example, ACTIVE and INACTIVE. |
Legal Form | 5092 | Displays the legal form of the issuer as financial party registered with the LEI. For example, CORPORATION. |
Assigned Date | 5093 | Displays the date when the issuer's LEI was assigned. |
Last Update Date | 5094 | Displays the date when the issuer's LEI information was last updated. |
Disabled Date | 5095 | Displays the date when the issuer's LEI information was disabled. |
Record State | 5096 | Displays the record state for the issuer's LEI. The record state indicates the current process status of the CFTC Interim Compliant Identifier (CICI) record. For example, UNDER_REVIEW, DUPLICATE, CONFLICTING_SOURCES, INADEQUATE_SOURCES, VALIDATED, PENDING_REMOVAL. |
Certification State | 5097 | Displays the certification state used to register the issuer's LEI. For example, CERTIFIED, NOT_CERTIFIED, STALE. |
Street | 5098 | Displays the street address used to register the issuer's LEI. |
City | 5099 | Displays the city used to register the issuer's LEI. |
State | 5100 | Displays the state code used to register the issuer's LEI. |
Zip | 5180 | Displays the ZIP code used to register the issuer's LEI. |
Country Code | 5181 | Displays the country code used to register the issuer's LEI. |
Accrual Information | ||
Security Processing Rule Name | 3197 | Specifies the name of the security processing rule used for the security. |
Security Processing Rule ID | 2964 | Displays the rule instance for the security processing rule. |
Accrual Flag | 2932 | Displays whether the selected security processing rule indicates that the security associated with that rule is eligible for accrual processing. This field is for information only; Eagle Accounting does not use this value during processing. Options include:Yes or No. |
Amortization Flag | 11104 | Displays whether the selected security processing rule indicates that the security associated with that rule is eligible for amortization. Options include Yes or No. |
Debt Coupon Periods | ||
Coupon | 70 | Specifies the rate at which the security accrues interest. It is expressed as an accrual rate. A value of zero is required for zero coupon bonds. |
Coupon Type Code | 97 | Indicates the type of coupon associated with the security. Options include:
|
Day Count Basis | 471 | Specifies the number of days assumed in a month or year when interest rates are quoted. |
Payment Frequency | 2287 | Specifies the frequency at which the security pays interest. |
Payment Frequency Code | 472 | Specifies the code that represents the payment frequency. |
Business Day Convention | 1536 | Determines when a coupon should pay interest should the scheduled coupon due date occur on a non-business day. |
Business Calendar Name | 1480 | Specifies the business calendar for the security. The system uses the value to identify business days and non business days for the purposes of determining the coupon payment date and coupon payment schedules. |
Day of Month Override | 1533 | Identifies the day of the month or business day of the month on which the security is to pay income. This is based on the business calendar. |
Interest Payment Timing | 1523 | Specifies the day of the month in which interest is paid. Options include:
|
Delay Days | 1799 | Specifies the number of days between the end of the accrual period and the actual receipt of the coupon and principal payment. The system uses this value in the creation of coupons, paydown transactions, and payup transactions, as well as in the Cash Flow Projections report. Utilizes the Day Count Basis (tag 471) value to determine the actual receipts and settlements of the paydown and payup transactions. |
Coupon Delay Days | 4908 | Specifies the number of days to extend the coupon period. |
Coupon Delay Days Type | 3999 | Specifies the coupon delay days type. Options include:
This field is not required for an equity security. |
Maturity Delay Days | 3997 | Specifies the number of days to delay generation of the maturity transaction. |
Maturity Delay Days Type | 3998 | Specifies the maturity delay days type. Options include:
This field is not required for an equity security. |
Debt Dates | ||
Issue Price | 69 | Specifies the original issue price of the security. |
Issue Date | 68 | Specifies the original date of issue. |
Dated Date | 1183 | Specifies the date the security first begins to accrue interest. |
First Coupon Date | 473 | Specifies the date of the first coupon payment. |
Last Coupon Date | 474 | Specifies the date of the last normal length coupon period. Eagle recommends that you enter penultimate. |
Maturity Date | 38 | Specifies the date that the security repays all outstanding principal and stops earning interest. |
Maturity Price | 42 | Specifies the price at which the security returns principal. This field must be set to 0, 1, or 100. |
Variable Rate Next Reset Date | 3006 | Specifies the date of the next rate reset for a security with a variable rate coupon type. |
Debt Flags | ||
Trading Flat | 3949 | Indicates whether the security is trading with or without interest. Options include:
|
OID Indicator | 218 | Indicates whether the security is OID (original issue discount) eligible. Options include:
|
Zero Coupon Indicator | 1300 | Indicates if a zero in the Coupon field represents a zero coupon bond. Options include:
|
Convertible Indicator | 1531 | Indicates whether the security is a convertible bond. Options include:
|
Call Flag | 1182 | Indicates whether the security has a call option. Options include:
NOTE: This field must be set to Yes to add a call corporate action. |
Put Flag | 1546 | Indicates whether the security has a put option. Options include:
NOTE: This field must be set to Yes to add a put corporate action. |
Sink Flag | 1780 | Indicates whether the security is eligible for sinking fund payments. Options include:
NOTE: This field must be set to Yes to add a sink schedule corporate action. |
Federal Tax Indicator | 1545 | Indicates whether the security has a U.S. Federal Tax Indicator. It is used in the SEC Yield calculation. Options include:
|
Muni Funding Flag | 3131 | Indicates whether an interest bearing municipal security is eligible for pre-refunding. Options include:
|
AMT Flag | 3113 | Indicates whether a security is subject to the Alternative Minimum Tax (ATM) for individuals. Options include:
|
Insured Flag | 3104 | Indicates whether a security is insured from defaulting. Options include:
|
Default Indicator | 1551 | Indicates whether a bond is in default. Options include:
|
Default Date | 10142 | Specifies the date on which the security went into default. |
IO/PO Flag | 10143 | Identifies interest only (IO) and principal only (PO) securities. Options include:
|
Eusd Eligible | 11529 | Indicates whether the security is eligible for the tax equalization process. Options include:
|
Financial Innovation | 11530 | Indicates whether the security is eligible for financial innovation. Options include:
|
Govt Bond Flag | 10347 | Indicates whether the security is a government bond. Options include:
|
2a7 Flag | 11811 | Specifies 2a7 WAM processing. Options include:
|
Time Sensitive Indicator | 11926 | Specifies whether the security uses floating rate data that changes over time if you set the Coupon Type field to Floating Rate. Options include:
|
Synthetic Eligible | 12024 | Indicates whether the security is synthetic eligible. Options include:
|
Muni State Taxable Flag | 10248 | Indicates whether the security is subject to municipal state taxes. Options include:
|
Private Registration | 10528 | Indicates whether the security is a private registration. Options include:
This field applies to debt instruments and is used for reporting and reference only. |
Minimum Piece | 1540 | Specifies the minimum original tradable amount. This field applies to debt instruments and is used for reporting and reference only. |
Private Placement | 1421 | Indicates whether the security is a private placement. Options include:
This field applies to debt instruments and is used for reporting and reference only. |
Floating Rate Information | ||
Inverse Floater Rate | 1553 | Identifies the inverse floater rate, a debt instrument with a coupon rate that is calculated inversely to the underlying index that is attached to it. This field is part of the fixed rate component of the inverse floating coupon rate calculation. It becomes visible and is required when you select a Coupon Type Code of Inverse Floating. |
Inverse Floater Multiple | 4532 | Stores the number that is multiplied by the coupon rate of the underlying index, when calculating the inverse floating rate. |
Dated Date CPI | 1550 | Specifies the consumer price index (CPI) value for the dated date of the security. This becomes the base value for measuring inflation for the security. |
Compound Information | ||
Compounding Indicator | 11875 | Specifies whether the security compounds unpaid interest. Options include:
If you set this field to Yes, the remaining compound information fields are required. |
Compounding Method | 11876 | Identifies the method used for compounding interest. Options include:
|
Compounding Frequency | 11877 | Specifies the frequency at which the security compounds interest. |
First Compounding Date | 11878 | Specifies the first date on which the compounding begins. |
Last Compounding Date | 11879 | Specifies the end date of interest compounding. |