Tax Certificate Query
Summary
The Tax Certificate query allows you to retrieve the related data.
You can refine your query by specifying particular parameters.
By default, the returned list view is in ascending order
Tax Certificate Query
- Predefined
The Predefined section in the Tax Certificate query gives the ability to save and manage your own queries.
Field Description
| Filed Name | Field Type | Description |
| Query name | Drop Down (simple select) | This field contains all saved queries name that you are able to select. |
Predefined Actions Description
| Save query | Button | When clicking on the action button, a pop up will appears asking you to provide a name and description to the query that you are saving. All the query parameters takes into account in the query saved. |
| Delete query | Button | This will allows you to delete your saved queries. |
| Set as default | Button | Once clicking on this button action, you will set the query, specified in the "Query name" field, will execute by default when you land the Tax certificate query. The query executes automatically. |
- Tax Refund search
Field Description
| Filed Name | Field Type | Description |
| Safekeeping Account | Input text | Contains the account id input by the user or selected via the lookup. |
| Safekeeping Account Name | Output text | Contains the name of the account selected. This field is not editable. |
| Market | Select many list box | The list will contain the markets (countries names) activated in Tax Application. |
| Financial Instrument | Input text |
Contains the ISIN of the instrument input manually or selected via the lookup (to access to all financial instruments). Input of multiple Financial instruments allowed. |
| Description | Output text | This non-editable field displays the instrument's description, once a selection has been made via the financial instrument lookup or added manually. |
| Place of Safekeeping | Output text |
This non-editable field displays the place of safekeeping related to the Financial Instrument selected, once a selection has been made via the financial instrument lookup or added manually. |
| Event Type | Select many list box |
Drop down list containing the 16 event types from table TAX_EVNT_TYP in Tax Application. The drop down list will display the decode value next to the code:
|
| Instrument Type | Select many list box |
Breakdown of instruments categories. The following decodes will be shown in the drop down list:
|
| Income Payment | Radio Button |
Group of two radio buttons:
Record Date = The date at which, after the daytime processing, Clearstream Banking records holdings in the security as being an entitled position. Value Date = Value date applied to the proceeds |
| Income Payment | Date picker | |
| Reference | Radio button (group) |
A radio button group to determine whether customer wants to use Clearstream reference or his own reference to query. The group has the following values:
|
| Reference | Input text |
This can be either the Customer reference, either the Clearstream reference depending on the radio button selected by the user. This field supports only the exact reference. |
| Document Description | Select many list box | The drop down list will contain the documents descriptions |
| Document Type | Select one Menu |
There are 3 possible values:
|
| Document Status | Select many list box |
There are 3 possible values:
|
| Expiry Date | Date picker | |
| Until Revoked | Checkbox |
|
| Italian Fiscal Status | Select many list box |
The drop down list will contain the list of the Italian Fiscal Status:
|
| Beneficial Owner | Input text (wildcard, at least 3 alphanumeric characters must be entered.) | The search of the beneficial owner must be limited to the beneficial owners linked to the Account(s) and Market(s) selected. |
| TIN | Input text | The Taxpayer Identification Number. This number can be a social security number assigned to individuals by the Social Security Administration or an Employer Identification Number assigned to businesses and other entities by local fiscal authorities. |
- Ordering
Field Description
| Filed Name | Field Type | Description |
| Sort by | Select one menu | It contains the complete list of visible columns in the specific List view. |
| Then by | Select one menu | It contains the complete list of visible columns in the specific List view. |
- Tax Certificate List View
Once the query has executed, you are prompted with the list of Tax certificate related to the query parameters provided.
The list view is composed with:
- Column Headers: these are the columns related to your configuration (by using the “Configure” button… see below list).
- Results: the actual results of the query you defined
Fields Description
Below is the list of fields displayed (by default or by adding them with the “Configure” option to add more fields):
| List View Field Name | Fields displayed by default or configured |
| Clearstream’s Reference | Default field |
| Market | Default field |
| Safekeeping Account | Default field |
| Fin. Instrument | Default field |
| Common Code | Configure List |
| Instrument Type | Configure List |
| Place of Safekeeping | Configure List |
| Clearstream’s Depository BIC | Default field |
| Clearstream’s Depository Name | Default field |
| Document Description | Default field |
| Type | Default field |
| Status | Default field |
|
Valid From |
Default field |
|
Expiry Date |
Default field |
|
Italian Fiscal Status |
Default field |
|
Beneficial Owner |
Default field |
|
TIN |
Default field |
| Customer Reference | Default field |
List View Actions Description
| Action Name | Action Type | Description |
| Export - all | Button | it will export all the rows returned by the query (whatever if selected or not). |
| Export - list | Button | it will export the current list displayed at the screen. |
| Export - selected | Button | it will export the selected rows |
| Print - all | Button | it will print all the rows returned by the query (whatever if selected or not). |
| Print - list | Button | it will print the current list displayed at the screen. |
| Print - selected | Button | it will print the selected rows |
| Refresh | Button | it will re-execute the current query and will refresh the rows displayed. |
| Configure | Button | it will allow you to configure the column that you want to display in the list view |
Open Details
When the user click on one line then another button will display, i.e. “Open Details” which brings you to the full detail view of that selected item
Tax Certificate details view:
| List View Field Name | Description |
| Safekeeping Account | The Clearstream Account Number Associated with the Tax Document |
| Safekeeping Account Name | The Safekeeping Account Name Associated with the Tax Document |
| Holding Quantity | Quantity of Financial Instrument held for this account |
| Name | Name of the Beneficial Owner |
| Classification | The BO classification to which belongs the Beneficiary type |
| Type |
The BO type. One BO can have multiple BO types, for example one FATCA BO type and one QI BO type, i.e. all the BO types must be displayed" |
| TIN Type | Tax Identification Number Type of the Beneficial Owner (may have more than 1) |
| TIN | Tax Identification Number of the Beneficial Owner (1 for each TIN Type) |
| Address | Address of the Beneficial Owner |
| Country | Country of the Beneficial Owner |
| Holding Quantity | Holding Quantity of the beneficial Owner. |
| TWR |
Beneficial Owner’s Transfer of Withholding Responsibility status The field is only meaningful for US Certificates. |
| Clearstream Reference | Clearstream reference |
| Customer Reference | Customer reference |
| Type | Document type |
| Status | Document status. To be decoded. Yes if Valid. |
| Description | Document description |
| Italian Fiscal Status | Italian Fiscal Status |
| Valid Date From | Document validity start date |
| Valid Date To | Document validity end date. If blank, has to be decoded as “Until Revoked” |
| Category | Category of the Tax Certificate |
| Number | Clearstream Reference of the related Tax Certificate |
| Category | Category of the related Tax Certificate |
| Italian Fiscal Status | Italian Fiscal Status of the related Tax Certificate |
| Start | Start Date of the related Tax Certificate |
| End | End Date of the related Tax Certificate |
| Document Status | Document Status of the related Tax Certificate |
| Market | Country of the Market. Decoded in full name. |
| Event Type | Event type |
| ISIN Code | Identification of the financial instrument using the ISIN Code |
| Description |
Description of the financial instrument Will be “UNPUBLISHED” for unpublished securities. |
| Common Code | Identification of the financial instrument using the Common Code |
| Common Code Type | The type (i.e. ‘Single’, ‘Home’ or ‘Remote’) of the Common Code of the Financial Instrument |
| Place of Safekeeping |
The BIC + the name of the place of safekeeping of the financial instrument |
| Instrument Type | Type of the financial instrument. Null if the document is related to all Securities of the specified account/Benef Owner. |
| Clearstream Depository BIC | The BIC of the depository of the financial instrument |
| Clearstream Depository Name | The name of the depository of the financial instrument |
| Record Date | Can be “Unknown” if the security ref data does not provide the depository information. |
| Value Date | Event value date |