[Home] [Help] [Dependency Information]
Object Name: | CE_XTR_CASHFLOWS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CE.CE_XTR_CASHFLOWS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
The CE_XTR_CASHFLOWS_V view contains treasury deal transactions for forecasting. The Cash Forecasting program uses this view to generate projected cash inflow and outflow amounts from the trading activities and the exposures. Based on the forecast template definition and forecast submission criteria, the Cash Forecasting program selects only the applicable deals from this view to determine forecast amounts.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEAL_NUMBER | NUMBER | Yes | Deal number | |
DDA_DEAL_TYPE | VARCHAR2 | (7) | Yes | Deal type code |
DDA_DEAL_SUBTYPE | VARCHAR2 | (7) | Deal subtype code | |
TRANSACTION_RATE | NUMBER | Deal rate | ||
STATUS_CODE | VARCHAR2 | (10) | Deal status | |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code of deal |
TRX_DATE | DATE | Deal transaction date | ||
AMOUNT | NUMBER | Deal amount | ||
COMPANY_CODE | VARCHAR2 | (7) | Company | |
COMPANY_ACCOUNT | VARCHAR2 | (20) | Company account number | |
PRODUCT_TYPE | VARCHAR2 | (10) | Product | |
PORTFOLIO_CODE | VARCHAR2 | (7) | Portfolio | |
CPARTY_CODE | VARCHAR2 | (7) | Counter party | |
CLIENT_CODE | VARCHAR2 | (7) | Client | |
DEAL_TYPE | VARCHAR2 | (7) | Yes | Deal type |
CATEGORY | VARCHAR2 | (2) | Yes | Deal category |
DEAL_SUBTYPE | VARCHAR2 | (7) | Yes | Deal subtype |
TYPE_OF_AMOUNT | VARCHAR2 | (7) | Yes | Amount type |
TRANSACTION_NUMBER | NUMBER | Deal transaction number | ||
DEALER | VARCHAR2 | (10) | Dealer | |
SETTLE | VARCHAR2 | (1) | Settlement indicator | |
CONTRACT_TYPE | VARCHAR2 | (7) | Yes | Contract type |
SET_OF_BOOKS_ID | NUMBER | (15) | Identifier for set of books | |
MULTIPLE_SETTLEMENTS | VARCHAR2 | (1) | Indicator for multiple settlements | |
RECONCILED_REFERENCE | NUMBER | Reference number to the statement line against which this transaction is reconciled | ||
DDA_DEAL_TYPE_NAME | VARCHAR2 | (80) | Yes | Deal Type Name |
DDA_DEAL_SUBTYPE_NAME | VARCHAR2 | (80) | Yes | Deal Subtype Name |
COUNTERPARTY | VARCHAR2 | (50) | Counterparty | |
AMOUNT_TYPE_NAME | VARCHAR2 | (80) | Yes | Amount Type Name |
ORG_ID | NUMBER | (15) | Legal Entity identifier | |
BANK_ACCOUNT_ID | NUMBER | (15) | Bank account identifier | |
REFERENCE_ID | NUMBER | Yes | Reference identifier |
Cut, paste (and edit) the following text to query this object:
SELECT DEAL_NUMBER
, DDA_DEAL_TYPE
, DDA_DEAL_SUBTYPE
, TRANSACTION_RATE
, STATUS_CODE
, CURRENCY_CODE
, TRX_DATE
, AMOUNT
, COMPANY_CODE
, COMPANY_ACCOUNT
, PRODUCT_TYPE
, PORTFOLIO_CODE
, CPARTY_CODE
, CLIENT_CODE
, DEAL_TYPE
, CATEGORY
, DEAL_SUBTYPE
, TYPE_OF_AMOUNT
, TRANSACTION_NUMBER
, DEALER
, SETTLE
, CONTRACT_TYPE
, SET_OF_BOOKS_ID
, MULTIPLE_SETTLEMENTS
, RECONCILED_REFERENCE
, DDA_DEAL_TYPE_NAME
, DDA_DEAL_SUBTYPE_NAME
, COUNTERPARTY
, AMOUNT_TYPE_NAME
, ORG_ID
, BANK_ACCOUNT_ID
, REFERENCE_ID
FROM APPS.CE_XTR_CASHFLOWS_V;
|
|
|