 |
Home > Cash and liquidity > Credit and Collateral Usage Query
|
When a query is triggered, the system provides positions at the time of the query initiation.
The
positions change constantly;
therefore, they might be different after resubmitting/refreshing
the query.
Query View
Fields, which are available, or automatically filled in according to the provided data
Query Name |
A drop down field with the list of created queries. |
Save Query |
Once a user wants to save the query, by clicking on the button a pop-up screen appears in the following format: Name Description By filling these fields and clicking on the OK button, the query gets saved for the future use. |
Delete Query |
This button appear when users selects a saved query in the Query Name field. By clicking on this button, the selected query gets deleted. |
Set as Default |
This button appear when users selects a saved query in the Query Name field. By clicking on this button, the selected query becomes default. |
Account |
Enter the account, that you want to query Credit & Collateral position on. |
|
Lookup for an account function. By clicking on this icon and filling in search detail the user can select an account. |
Account name |
Once an account is selected the system pulls account name into this field. The fields is not editable. |
List view
|
Leads to the positions detail screen |
Account Id |
Account ID entered in the query |
Account Name |
Account name associated to the queried account |
Business Date |
Business date of the positions. |
Detail screen
Case 1: An account, which falls under an umbrella account structure. By querying on this type of account, the system returns positions of the queried account (highlighted) and all other accounts, which belong to the umbrella account.
Case 2: An account, which does not fall under any umbrella account. By querying on this type of account, the system returns positions of the queried account only.
|
|
Account under an umbrella account structure |
Account not under an umbrella account structure |
|
Section: Credit & Collateral Usage – Never collapsed, no possibility to collapse |
X |
X |
||
Umbrella |
Umbrella account number |
X |
- |
|
Account ID |
Account number |
- |
X |
|
Account Name |
Account name associated to the queried account |
- |
X |
|
Business date |
Business date of the positions |
X |
X |
|
Total Credit Line Usage |
Total real-time credit line usage for the current processing day |
X |
X |
|
Used Collateral |
Real-time collateral that is not available for the current processing day |
X |
X |
|
Available Collateral |
Real-time collateral that is available for the current processing day |
X |
X |
|
Total Collateral |
Real-time collateral overview for the current processing day |
X |
X |
|
Total % Collateral Used |
Total % of available Collateral Used of the account |
- |
X |
|
↓Section: Current Usage Details – Not collapsed, with possibility to collapse |
X |
- |
||
Account |
Account which is part of the umbrella account structure |
X |
|
|
|
|
|
||
|
|
|
||
Currency |
Currency |
X |
||
Credit Line Usage |
Real-time credit line usage of the corresponding account under the umbrella account structure for the current processing |
X |
||
Collateral Used |
Real-time collateral of the corresponding account under the umbrella account structure that is not available for the current processing day |
X |
||
% Collateral Used |
% Collateral Used of the corresponding account under the umbrella account structure |
X |
||
Shared Credit Line |
If “Y” the account shares the credit line with the umbrella account structure |
X |
||
Shared Collateral |
If “Y” the account shares the Collateral with the umbrella account structure |
X |
||
Shared Contributor |
If “Y” the collateral of this account is used for the umbrella account structure |
X |
||
↓Section: Forecast Usage Details – Collapsed, with possibility to expand |
X |
X |
||
Account |
Account which is part of the umbrella account structure |
X |
X |
|
Instruction Type |
Provides information on Instruction type, which contributes to the forecast balances. The values are visible after the account row is expanded. Securities Instructions - Delivery Free (DF) External - Delivery Free (DF) Internal - Delivery against payment (DVP) Internal - Delivery against payment (DVP) External - Received free (RF) External - Received free (RF_ Internal - Received against payment (RVP) External - Received against payment (RVP) - Internal
Cash Instructions - Pre-Advice of Funds - Withdrawal of Funds
Income Pre/Advice - IPAR – Income Pre-Advice Report
|
X |
X |
|
Currency |
Currency |
X |
X |
|
Cash Impact |
At account level, it is a sum of all positions At break down level, it provides a cash impact position according to the corresponding instruction type
|
X |
X |
|
Securities Collateral Impact |
Collateral balance contributes to the overall account’s collateral position. At account level, it provides the Sum of all positions. Once expanded, it breaks down onto: RVP Internal, DF Internal, RVP External, DF External and IPAR |
X |
X |
|
Shared Credit Line |
If “Y” the account shares the credit line with the umbrella account structure. Empty when row is expanded |
X |
- |
|
Shared Collateral |
If “N” the account shares the Collateral with the umbrella account structure. Empty when row is expanded |
X |
- |
|
Shared Contributor |
If “Y” the collateral of this account is used for the entire umbrella account structure. Empty when row is expanded |
X |
- |
|
SA = Settlement Account
