[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | XTR_SETTLEMENTS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  XTR.XTR_SETTLEMENTS_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
XTR_SETTLEMENTS_V contains settlement information from theXTR_DEAL_DATE_AMOUNTS table for deals that meet the following criteria:
- do not have Cancelled status.
- are not a foreign exchange option.
- have a non-zero cash flow amount.
- have the deal type ?EXP? for exposures and ?EXT? for external exposures where the transaction is firm and Treasury is to settle the cash flow. For example, EXP_SETTLE_REQD = ?Y? and DEAL_SUBTYPEE <<> ?INDIC?.
- is not a split settlement MULTIPLE_SETTLEMENTS = ?N?.
This view corresponds to the Settlements window.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| DEAL_NUMBER | NUMBER | Yes | Unique number assigned to each deal | |
| TRANSACTION_NUMBER | NUMBER | Unique reference number assigned to a transaction | ||
| AMOUNT_DATE | DATE | Actual settlement date or amount date of the deal | ||
| DAY_VARIANCE | NUMBER | Number of days between actual settlement date and amount date | ||
| GOOD_VALUE_CLAIM | VARCHAR2 | (1) | Not currently used | |
| CURRENCY | VARCHAR2 | (15) | Yes | Currency code |
| TYPE_OF_AMOUNT | VARCHAR2 | (7) | Yes | Code that identifies the purpose of the amounts for a deal type |
| AMOUNT | NUMBER | Yes | Transaction amount | |
| CASHFLOW_AMOUNT | NUMBER | Amount of cash flow | ||
| COMPANY | VARCHAR2 | (7) | Company code | |
| CPARTY | VARCHAR2 | (7) | Counterparty code | |
| CLIENT | VARCHAR2 | (7) | Client for which the deal is made | |
| DEALER | VARCHAR2 | (10) | Code for Treasury users | |
| CONTRACT_TYPE | VARCHAR2 | (7) | Yes | Code for high level deals |
| SUBTYPE | VARCHAR2 | (7) | Code for deal executions permissible within a deal type | |
| PRODUCT | VARCHAR2 | (10) | Code for products used in a deal type | |
| PORTFOLIO | VARCHAR2 | (7) | Code for grouping deals under a single portfolio | |
| CODE_COMBINATION_ID | NUMBER | (15) | Unique key for identifying GL account references | |
| RATE | NUMBER | Transaction rate | ||
| COMPANY_ACCOUNT | VARCHAR2 | (20) | Settlement account number | |
| HCE_AMOUNT | NUMBER | Transaction amount in reporting currency equivalent | ||
| CONTRACT_STATUS | VARCHAR2 | (10) | Code for the execution status of deals and transactions | |
| DIARY_NOTE_DETAILS | VARCHAR2 | (255) | Not currently used | |
| AUTHORISED_BY | VARCHAR2 | (30) | Login name of user who created the deal, to be included only if parameter DUAL_AUTHORISE is set to Y | |
| AUTHORISED_ON | DATE | Date on which the user created the deal, to be included only if parameter DUAL_AUTHORISE is set to Y | ||
| SETTLE | VARCHAR2 | (1) | Flag to indicate if the settlement has been authorized (Y), or not (N) | |
| CPARTY_ACCOUNT | VARCHAR2 | (20) | Alpha-numeric reference of counterparty financial account | |
| DIRECT_DEBIT | VARCHAR2 | (1) | Flag to indicate if user selects direct debit as method of payment for settlement (Y), or not (N) | |
| CHQ_REQD | VARCHAR2 | (1) | Flag to indicate if user selects check as method of payment for settlement (Y), or not (N) | |
| COMMENTS | VARCHAR2 | (255) | Settlement comment | |
| ACTION_CODE | VARCHAR2 | (7) | Code for actions involved in executing deals | |
| ATTACHMENT_EXISTS | VARCHAR2 | (1) | Not currently used | |
| CURRENCY_COMBINATION | VARCHAR2 | (31) | Currency quotations which combine a base and a contra currency | |
| BENEFICIARY_PARTY | VARCHAR2 | (7) | Settlement beneficiary party | |
| BENEFICIARY_ACCOUNT | VARCHAR2 | (20) | Settlement beneficiary party account number | |
| SETTLEMENT_NUMBER | NUMBER | Stores the settlement number for an authorised deal/transaction | ||
| LIMIT_PARTY | VARCHAR2 | (7) | Party against which limits are applied (only applies to counterparty, group, and settlement limits) |
Cut, paste (and edit) the following text to query this object:
SELECT DEAL_NUMBER
, TRANSACTION_NUMBER
, AMOUNT_DATE
, DAY_VARIANCE
, GOOD_VALUE_CLAIM
, CURRENCY
, TYPE_OF_AMOUNT
, AMOUNT
, CASHFLOW_AMOUNT
, COMPANY
, CPARTY
, CLIENT
, DEALER
, CONTRACT_TYPE
, SUBTYPE
, PRODUCT
, PORTFOLIO
, CODE_COMBINATION_ID
, RATE
, COMPANY_ACCOUNT
, HCE_AMOUNT
, CONTRACT_STATUS
, DIARY_NOTE_DETAILS
, AUTHORISED_BY
, AUTHORISED_ON
, SETTLE
, CPARTY_ACCOUNT
, DIRECT_DEBIT
, CHQ_REQD
, COMMENTS
, ACTION_CODE
, ATTACHMENT_EXISTS
, CURRENCY_COMBINATION
, BENEFICIARY_PARTY
, BENEFICIARY_ACCOUNT
, SETTLEMENT_NUMBER
, LIMIT_PARTY
FROM APPS.XTR_SETTLEMENTS_V;
APPS
XTR_DEAL_DATE_AMOUNTS_V
XTR_USER_ACCESS
- show dependent code
APPS
XTR_LIMITS_P
- show dependent code
XTR_LIMIT_OVERVIEW_V
XTR_MISC_P
- show dependent code
XTR_SETTLE_ROW_UTILISED_V
|
|
|
|