[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | XTR_CE_DEAL_DATE_AMOUNTS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  XTR.XTR_CE_DEAL_DATE_AMOUNTS_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ACCOUNT_NO | VARCHAR2 | (20) | Settlement account number | |
| ACCRUAL_FROM | DATE | Not currently used | ||
| ACCRUAL_TO | DATE | Not currently used | ||
| ACTION_CODE | VARCHAR2 | (7) | Code for actions involved in executing deals | |
| ACTION_COMPLETED | VARCHAR2 | (1) | Not currently used | |
| ACTUAL_SETTLEMENT_DATE | DATE | Settlement date | ||
| AMOUNT | NUMBER | Yes | Transaction amount | |
| AMOUNT_DATE | DATE | Date the deal finishes and is paid off, or date the principal amount of a note, draft, acceptance, bond, short term or other debt instrument becomes due and payable. | ||
| AMOUNT_TYPE | VARCHAR2 | (7) | Yes | Code that identifies the purpose of the amounts for a deal type |
| ARCHIVE_BY | VARCHAR2 | (30) | Not currently used | |
| ARCHIVE_DATE | DATE | Not currently used | ||
| ATTACHMENT_EXISTS | VARCHAR2 | (1) | Not currently used | |
| AUDIT_INDICATOR | VARCHAR2 | (1) | Not currently used | |
| AUTHORISED | VARCHAR2 | (1) | Not currently used | |
| BALANCE_SHEET_EXPOSURE | VARCHAR2 | (1) | Flag indicates if the exposure type is in balance sheet (Y), or not (N) | |
| BENEFICIARY_ACCOUNT_NO | VARCHAR2 | (20) | Settlement beneficiary party account number | |
| BENEFICIARY_PARTY | VARCHAR2 | (7) | Settlement beneficiary party | |
| CASHFLOW_AMOUNT | NUMBER | Cash flow amount | ||
| CHQ_REQD | VARCHAR2 | (1) | Flag to indicate if user selects check as method of payment for settlement (Y), or not (N) | |
| CLIENT_BROKER_CLRACCT | VARCHAR2 | (1) | Flag to indicate if the client has settled with the counteryparty via the company clearing account (Y), or not (N) | |
| CLIENT_CODE | VARCHAR2 | (7) | Client for which the deal is made | |
| COMMENCE_DATE | DATE | Date the deal can start to be exercised | ||
| COMMENTS | VARCHAR2 | (255) | Settlement comments | |
| COMPANY_CODE | VARCHAR2 | (7) | Company code | |
| CONTRACT_CODE | VARCHAR2 | (7) | Not currently used | |
| CPARTY_ACCOUNT_NO | VARCHAR2 | (20) | Alpha-numeric reference of counterparty financial account | |
| CPARTY_CODE | VARCHAR2 | (7) | Counterparty code | |
| CURRENCY | VARCHAR2 | (15) | Yes | Currency code |
| CURRENCY_COMBINATION | VARCHAR2 | (31) | Currency quotations which combine a base and a contra currency | |
| DATE_TYPE | VARCHAR2 | (7) | Yes | Date type tied to specific deal types (for example, accrual, maturity, start, and dealt dates) |
| DEALER_CODE | VARCHAR2 | (10) | Code for Treasury users | |
| DEAL_NUMBER | NUMBER | Yes | Unique number assigned to each deal | |
| DEAL_ORDERS | VARCHAR2 | (255) | Not currently used | |
| DEAL_SUBTYPE | VARCHAR2 | (7) | Code for deal executions permissible within a deal type | |
| DEAL_TYPE | VARCHAR2 | (7) | Yes | Code for high level deals |
| DIARY_CREATED_BY | VARCHAR2 | (30) | Not currently used | |
| DIARY_NOTE | VARCHAR2 | (255) | Not currently used | |
| DIRECT_DEBIT | VARCHAR2 | (1) | Flag to indicate if user selects direct debit as method of payment for settlement (Y), or not (N) | |
| DUAL_AUTHORISATION_BY | VARCHAR2 | (30) | Login name of user who created the deal, to be included only if parameter DUAL_AUTHORISE is set to Y | |
| DUAL_AUTHORISATION_ON | DATE | Date on which the user created the deal, to be included only if parameter DUAL_AUTHORISE is set to Y | ||
| EXPOSURE_REF_DATE | DATE | Not currently used | ||
| EXP_SETTLE_REQD | VARCHAR2 | (1) | Flag to indicate if Treasury user wants to automatically initiate a payment for the exposure (Y), or not (N) | |
| EXTERNAL_COMMENTS | VARCHAR2 | (255) | Not currently used | |
| FIRST_ACCRUAL | DATE | Not currently used | ||
| FRA_DESCRIPTION | VARCHAR2 | (20) | Not currently used | |
| GENERAL_OR_PRIVATE_ACCESS | VARCHAR2 | (7) | Not currently used | |
| CODE_COMBINATION_ID | NUMBER | (15) | Unique key for identifying GL account references | |
| GOOD_VALUE_CLAIM | VARCHAR2 | (1) | Not currently used | |
| HCE_AMOUNT | NUMBER | Amount in reporting currency equivalent | ||
| JOURNAL_CREATED | VARCHAR2 | (1) | No longer used. | |
| LIMIT_CODE | VARCHAR2 | (7) | Code for user-defined limits imposed on deals and transactions | |
| LIMIT_PARTY | VARCHAR2 | (7) | Party against which limits are checked | |
| MULTIPLE_REFERENCE_NUMBER | NUMBER | Original settlement number which indicates where this split settlement comes from | ||
| MULTIPLE_SETTLEMENTS | VARCHAR2 | (1) | Flag to indicate if the settlement is split into more than one company or one bank account (Y), or not (N) | |
| NETOFF_GROUP_FLAG | VARCHAR2 | (1) | Flag to indicate the method of settlement groupings (Netoff (N), Sum (S), None (O), and Not Set (T)) | |
| NETOFF_NUMBER | NUMBER | Unique reference number assigned to a netting group | ||
| PORTFOLIO_CODE | VARCHAR2 | (7) | Code for grouping deals under a single portfolio | |
| PRINTED_MATURITY_YN | VARCHAR2 | (1) | Not currently used | |
| PRODUCT_TYPE | VARCHAR2 | (10) | Code for products used in a deal type | |
| QUICK_INPUT | VARCHAR2 | (1) | Flag to indicate if the deal is generaged from a quick input deal (Y), or not (N) | |
| RECONCILED_DAYS_ADJUST | NUMBER | Days adjusted for bank statement reconciliation | ||
| RECONCILED_PASS_CODE | VARCHAR2 | (3) | Set of selection criteria used for reconciliation | |
| RECONCILED_REFERENCE | NUMBER | Reference number to the statement line against which this transaction is reconciled | ||
| SERIAL_REFERENCE | VARCHAR2 | (12) | Internal reference | |
| SETTLE | VARCHAR2 | (1) | Flag to indicate if the settlement has been authorized (Y), or not (N) | |
| SETTLEMENT_ACTIONED | VARCHAR2 | (1) | Flag to indicate if the settlement has been processed (Y), or not (N) | |
| SETTLEMENT_ACTIONED_FILE | VARCHAR2 | (255) | Not currently used | |
| SETTLEMENT_AUTHORISED_BY | VARCHAR2 | (30) | Treasury user who authorized the settlement | |
| SETTLEMENT_NUMBER | NUMBER | Unique reference number assigned to a settlement | ||
| SETTLEMENT_PARTY | VARCHAR2 | (7) | Not currently used | |
| STATUS_CODE | VARCHAR2 | (10) | Code for the execution status of deals and transactions | |
| TRANSACTION_DATE | DATE | Yes | Date the transaction is made | |
| TRANSACTION_NUMBER | NUMBER | Unique reference number assigned to a transaction | ||
| TRANSACTION_RATE | NUMBER | Transaction rate | ||
| TRANS_MTS | VARCHAR2 | (1) | Flag to indicate if user has selected EFT (Electronic Funds Transfer) as method of payment for settlement (Y), or not (N) | |
| UPDATED_BY | VARCHAR2 | (30) | User who last updated this record | |
| UPDATED_ON | DATE | Date this record was last updated | ||
| ORIGINAL_SETTLEMENT_CURRENCY | VARCHAR2 | (15) | Not currently used | |
| ORIGINAL_SETTLEMENT_AMOUNT | NUMBER | Not currently used | ||
| COMPANY_HCE_AMOUNT | NUMBER | Not currently used | ||
| CREATED_BY | VARCHAR2 | (30) | User who created this record | |
| CREATED_ON | DATE | Date this record was created | ||
| BATCH_ID | NUMBER | (15) | Identifier that groups events into one process flow. | |
| DEAL_DATE_AMOUNT_ID | NUMBER | Yes | Unique reference number assigned to each deal date amount. | |
| COMPANY_ACCT_USE_ID | NUMBER | (15) | Settlement account ID | |
| CPARTY_ACCT_USE_ID | NUMBER | (15) | Counterparty account ID | |
| BENEFECIARY_ACCT_USE_ID | NUMBER | (15) | Settlement beneficiary party account ID | |
| LEGAL_ENTITY_ID | NUMBER | (15) | Legal entity identifier |
Cut, paste (and edit) the following text to query this object:
SELECT ACCOUNT_NO
, ACCRUAL_FROM
, ACCRUAL_TO
, ACTION_CODE
, ACTION_COMPLETED
, ACTUAL_SETTLEMENT_DATE
, AMOUNT
, AMOUNT_DATE
, AMOUNT_TYPE
, ARCHIVE_BY
, ARCHIVE_DATE
, ATTACHMENT_EXISTS
, AUDIT_INDICATOR
, AUTHORISED
, BALANCE_SHEET_EXPOSURE
, BENEFICIARY_ACCOUNT_NO
, BENEFICIARY_PARTY
, CASHFLOW_AMOUNT
, CHQ_REQD
, CLIENT_BROKER_CLRACCT
, CLIENT_CODE
, COMMENCE_DATE
, COMMENTS
, COMPANY_CODE
, CONTRACT_CODE
, CPARTY_ACCOUNT_NO
, CPARTY_CODE
, CURRENCY
, CURRENCY_COMBINATION
, DATE_TYPE
, DEALER_CODE
, DEAL_NUMBER
, DEAL_ORDERS
, DEAL_SUBTYPE
, DEAL_TYPE
, DIARY_CREATED_BY
, DIARY_NOTE
, DIRECT_DEBIT
, DUAL_AUTHORISATION_BY
, DUAL_AUTHORISATION_ON
, EXPOSURE_REF_DATE
, EXP_SETTLE_REQD
, EXTERNAL_COMMENTS
, FIRST_ACCRUAL
, FRA_DESCRIPTION
, GENERAL_OR_PRIVATE_ACCESS
, CODE_COMBINATION_ID
, GOOD_VALUE_CLAIM
, HCE_AMOUNT
, JOURNAL_CREATED
, LIMIT_CODE
, LIMIT_PARTY
, MULTIPLE_REFERENCE_NUMBER
, MULTIPLE_SETTLEMENTS
, NETOFF_GROUP_FLAG
, NETOFF_NUMBER
, PORTFOLIO_CODE
, PRINTED_MATURITY_YN
, PRODUCT_TYPE
, QUICK_INPUT
, RECONCILED_DAYS_ADJUST
, RECONCILED_PASS_CODE
, RECONCILED_REFERENCE
, SERIAL_REFERENCE
, SETTLE
, SETTLEMENT_ACTIONED
, SETTLEMENT_ACTIONED_FILE
, SETTLEMENT_AUTHORISED_BY
, SETTLEMENT_NUMBER
, SETTLEMENT_PARTY
, STATUS_CODE
, TRANSACTION_DATE
, TRANSACTION_NUMBER
, TRANSACTION_RATE
, TRANS_MTS
, UPDATED_BY
, UPDATED_ON
, ORIGINAL_SETTLEMENT_CURRENCY
, ORIGINAL_SETTLEMENT_AMOUNT
, COMPANY_HCE_AMOUNT
, CREATED_BY
, CREATED_ON
, BATCH_ID
, DEAL_DATE_AMOUNT_ID
, COMPANY_ACCT_USE_ID
, CPARTY_ACCT_USE_ID
, BENEFECIARY_ACCT_USE_ID
, LEGAL_ENTITY_ID
FROM APPS.XTR_CE_DEAL_DATE_AMOUNTS_V;
APPS
XTR_DEAL_DATE_AMOUNTS
XTR_PARTY_INFO
APPS.XTR_CE_DEAL_DATE_AMOUNTS_V is not referenced by any database object
|
|
|
|