[Home] [Help] [Dependency Information]
Object Name: | XTR_DEAL_DATE_AMOUNTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XTR.XTR_DEAL_DATE_AMOUNTS_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEAL_TYPE | VARCHAR2 | (7) | Yes | Code for high level deals |
BATCH_ID | NUMBER | (15) | Identifier that groups events into one process flow. | |
AMOUNT_TYPE | VARCHAR2 | (7) | Yes | Code that identifies the purpose of the amounts for a deal type |
DATE_TYPE | VARCHAR2 | (7) | Yes | Date type tied to specific deal types (for example, accrual, maturity, start, and dealt dates) |
DEAL_NUMBER | NUMBER | Yes | Unique number assigned to each deal | |
TRANSACTION_DATE | DATE | Yes | Date the transaction is made | |
CURRENCY | VARCHAR2 | (15) | Yes | Currency code |
AMOUNT | NUMBER | Yes | Transaction amount | |
HCE_AMOUNT | NUMBER | Amount in reporting currency equivalent | ||
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. | ||
TRANSACTION_RATE | NUMBER | Transaction rate | ||
CASHFLOW_AMOUNT | NUMBER | Cash flow amount | ||
COMPANY_CODE | VARCHAR2 | (7) | Company code | |
ACCOUNT_NO | VARCHAR2 | (20) | Settlement account number | |
CPARTY_ACCOUNT_NO | VARCHAR2 | (20) | Alpha-numeric reference of counterparty financial account | |
CHQ_REQD | VARCHAR2 | (1) | Flag to indicate if user selects check as method of payment for settlement (Y), or not (N) | |
ACTION_CODE | VARCHAR2 | (7) | Code for actions involved in executing deals | |
TRANSACTION_NUMBER | NUMBER | Unique reference number assigned to a transaction | ||
DIARY_NOTE | VARCHAR2 | (255) | Not currently used | |
AUTHORISED | VARCHAR2 | (1) | 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) | |
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) | |
SETTLE | VARCHAR2 | (1) | Flag to indicate if the settlement has been authorized (Y), or not (N) | |
DEAL_SUBTYPE | VARCHAR2 | (7) | Code for deal executions permissible within a deal type | |
PRODUCT_TYPE | VARCHAR2 | (10) | Code for products used in a deal type | |
LIMIT_CODE | VARCHAR2 | (7) | Code for user-defined limits imposed on deals and transactions | |
STATUS_CODE | VARCHAR2 | (10) | Code for the execution status of deals and transactions | |
CLIENT_CODE | VARCHAR2 | (7) | Client for which the deal is made | |
CPARTY_CODE | VARCHAR2 | (7) | Counterparty code | |
PORTFOLIO_CODE | VARCHAR2 | (7) | Code for grouping deals under a single portfolio | |
DIARY_CREATED_BY | VARCHAR2 | (30) | Not currently used | |
DEAL_ORDERS | VARCHAR2 | (255) | Not currently used | |
DEALER_CODE | VARCHAR2 | (10) | Code for Treasury users | |
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 | |
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) | |
MULTIPLE_REFERENCE_NUMBER | NUMBER | Original settlement number which indicates where this split settlement comes from | ||
SETTLEMENT_NUMBER | NUMBER | Unique reference number assigned to a settlement | ||
SETTLEMENT_AUTHORISED_BY | VARCHAR2 | (30) | Treasury user who authorized the settlement | |
SETTLEMENT_PARTY | VARCHAR2 | (7) | Not currently used | |
COMMENTS | VARCHAR2 | (255) | Settlement comments | |
CODE_COMBINATION_ID | NUMBER | (15) | Unique key for identifying GL account references | |
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) | |
EXP_SETTLE_REQD | VARCHAR2 | (1) | Flag to indicate if Treasury user wants to automatically initiate a payment for the exposure (Y), or not (N) | |
LIMIT_PARTY | VARCHAR2 | (7) | Party against which limits are checked | |
DUAL_AUTHORISATION_ON | DATE | Date on which the user created the deal, to be included only if parameter DUAL_AUTHORISE is set to Y | ||
ARCHIVE_DATE | DATE | Not currently used | ||
ARCHIVE_BY | VARCHAR2 | (30) | Not currently used | |
CONTRACT_CODE | VARCHAR2 | (7) | Not currently used | |
NETOFF_NUMBER | NUMBER | Unique reference number assigned to a netting group | ||
BENEFICIARY_PARTY | VARCHAR2 | (7) | Settlement beneficiary party | |
UPDATED_BY | VARCHAR2 | (30) | User who last updated this record | |
UPDATED_ON | DATE | Date this record was last updated | ||
AUDIT_INDICATOR | VARCHAR2 | (1) | Not currently used | |
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 | ||
RECONCILED_DAYS_ADJUST | NUMBER | Days adjusted for bank statement reconciliation | ||
SERIAL_REFERENCE | VARCHAR2 | (12) | Internal reference | |
BENEFICIARY_ACCOUNT_NO | VARCHAR2 | (20) | Settlement beneficiary party account number | |
FIRST_ACCRUAL | DATE | Not currently used | ||
ACCRUAL_FROM | DATE | Not currently used | ||
ACCRUAL_TO | DATE | Not currently used | ||
FRA_DESCRIPTION | VARCHAR2 | (20) | Not currently used | |
GENERAL_OR_PRIVATE_ACCESS | VARCHAR2 | (7) | Not currently used | |
CURRENCY_COMBINATION | VARCHAR2 | (31) | Currency quotations which combine a base and a contra currency | |
ACTUAL_SETTLEMENT_DATE | DATE | Settlement date | ||
GOOD_VALUE_CLAIM | VARCHAR2 | (1) | Not currently used | |
NETOFF_GROUP_FLAG | VARCHAR2 | (1) | Flag to indicate the method of settlement groupings (Netoff (N), Sum (S), None (O), and Not Set (T)) | |
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 | |
QUICK_INPUT | VARCHAR2 | (1) | Flag to indicate if the deal is generaged from a quick input deal (Y), or not (N) | |
EXTERNAL_COMMENTS | VARCHAR2 | (255) | Not currently used | |
EXPOSURE_REF_DATE | DATE | Not currently used | ||
ATTACHMENT_EXISTS | VARCHAR2 | (1) | Not currently used | |
COMMENCE_DATE | DATE | Date the deal can start to be exercised | ||
PRINTED_MATURITY_YN | VARCHAR2 | (1) | Not currently used | |
BALANCE_SHEET_EXPOSURE | VARCHAR2 | (1) | Flag indicates if the exposure type is in balance sheet (Y), or not (N) | |
ACTION_COMPLETED | VARCHAR2 | (1) | Not currently used | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT DEAL_TYPE
, BATCH_ID
, AMOUNT_TYPE
, DATE_TYPE
, DEAL_NUMBER
, TRANSACTION_DATE
, CURRENCY
, AMOUNT
, HCE_AMOUNT
, AMOUNT_DATE
, TRANSACTION_RATE
, CASHFLOW_AMOUNT
, COMPANY_CODE
, ACCOUNT_NO
, CPARTY_ACCOUNT_NO
, CHQ_REQD
, ACTION_CODE
, TRANSACTION_NUMBER
, DIARY_NOTE
, AUTHORISED
, DIRECT_DEBIT
, TRANS_MTS
, SETTLE
, DEAL_SUBTYPE
, PRODUCT_TYPE
, LIMIT_CODE
, STATUS_CODE
, CLIENT_CODE
, CPARTY_CODE
, PORTFOLIO_CODE
, DIARY_CREATED_BY
, DEAL_ORDERS
, DEALER_CODE
, DUAL_AUTHORISATION_BY
, MULTIPLE_SETTLEMENTS
, MULTIPLE_REFERENCE_NUMBER
, SETTLEMENT_NUMBER
, SETTLEMENT_AUTHORISED_BY
, SETTLEMENT_PARTY
, COMMENTS
, CODE_COMBINATION_ID
, CLIENT_BROKER_CLRACCT
, EXP_SETTLE_REQD
, LIMIT_PARTY
, DUAL_AUTHORISATION_ON
, ARCHIVE_DATE
, ARCHIVE_BY
, CONTRACT_CODE
, NETOFF_NUMBER
, BENEFICIARY_PARTY
, UPDATED_BY
, UPDATED_ON
, AUDIT_INDICATOR
, RECONCILED_PASS_CODE
, RECONCILED_REFERENCE
, RECONCILED_DAYS_ADJUST
, SERIAL_REFERENCE
, BENEFICIARY_ACCOUNT_NO
, FIRST_ACCRUAL
, ACCRUAL_FROM
, ACCRUAL_TO
, FRA_DESCRIPTION
, GENERAL_OR_PRIVATE_ACCESS
, CURRENCY_COMBINATION
, ACTUAL_SETTLEMENT_DATE
, GOOD_VALUE_CLAIM
, NETOFF_GROUP_FLAG
, SETTLEMENT_ACTIONED
, SETTLEMENT_ACTIONED_FILE
, QUICK_INPUT
, EXTERNAL_COMMENTS
, EXPOSURE_REF_DATE
, ATTACHMENT_EXISTS
, COMMENCE_DATE
, PRINTED_MATURITY_YN
, BALANCE_SHEET_EXPOSURE
, ACTION_COMPLETED
, ORIGINAL_SETTLEMENT_CURRENCY
, ORIGINAL_SETTLEMENT_AMOUNT
, COMPANY_HCE_AMOUNT
, CREATED_BY
, CREATED_ON
FROM APPS.XTR_DEAL_DATE_AMOUNTS_V;
|
|
|