[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;
|
|
|