[Home] [Help] [Dependency Information]
Object Name: | XTR_ACCRLS_AMORT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XTR.XTR_ACCRLS_AMORT_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_NO | NUMBER | Yes | Unique number assigned to each deal | |
BATCH_ID | NUMBER | (15) | Yes | Identifier that groups events into one process flow. |
TRANS_NO | NUMBER | Yes | Unique reference number assigned to a transaction | |
PERIOD_FROM | DATE | Yes | Start date of accrual period | |
PERIOD_TO | DATE | Yes | End date of accrual period | |
COMPANY_CODE | VARCHAR2 | (7) | Yes | Company code |
DEAL_TYPE | VARCHAR2 | (7) | Yes | Code for high level deals |
DEAL_SUBTYPE | VARCHAR2 | (7) | Code for deal executions permissible within a deal type | |
CPARTY_CODE | VARCHAR2 | (7) | Counterparty code | |
CURRENCY | VARCHAR2 | (15) | Currency code | |
PRODUCT_TYPE | VARCHAR2 | (10) | Code for products used in a deal type | |
PORTFOLIO_CODE | VARCHAR2 | (7) | Code for grouping deals under a single portfolio | |
AMOUNT_TYPE | VARCHAR2 | (7) | Yes | Amount type used in accruals |
ACTION_CODE | VARCHAR2 | (7) | Yes | Code for actions involved in executing deals |
TRANSACTION_AMOUNT | NUMBER | Transaction amount used to calculate the accrual amount | ||
ACTUAL_START_DATE | DATE | Start date used in accrual calculations | ||
ACTUAL_MATURITY_DATE | DATE | Maturity date used in accrual calculations | ||
INTEREST_RATE | NUMBER | Interest rate at which a deal or transaction is executed | ||
NO_OF_DAYS | NUMBER | Number of days used to calculate interest | ||
YEAR_BASIS | NUMBER | Number of days in a year used in calculations | ||
ACCRLS_AMOUNT | NUMBER | Accrual amount | ||
FIRST_ACCRUAL_INDIC | VARCHAR2 | (1) | Flag to indicate if this is the first accrual or amortization for this deal (Y), or not (N) | |
TRANSFERED_ON | DATE | Not currently used | ||
REVERSAL_DATE | DATE | Date accrual is reversed | ||
CREATED_ON | DATE | Date this record was created | ||
CREATED_BY | VARCHAR2 | (20) | User who created this record | |
ACCRLS_AMOUNT_BAL | NUMBER | Running balance of the accrual amount for the deal and transaction | ||
EFFECTIVE_CALCULATED_VALUE | NUMBER | Running balance of the discounted amount for the accrual period for the deal and transaction | ||
CALC_FACE_VALUE | NUMBER | |||
EFFINT_ACCRLS_AMOUNT_BAL | NUMBER | Effint accruals amount balance. |
Cut, paste (and edit) the following text to query this object:
SELECT DEAL_NO
, BATCH_ID
, TRANS_NO
, PERIOD_FROM
, PERIOD_TO
, COMPANY_CODE
, DEAL_TYPE
, DEAL_SUBTYPE
, CPARTY_CODE
, CURRENCY
, PRODUCT_TYPE
, PORTFOLIO_CODE
, AMOUNT_TYPE
, ACTION_CODE
, TRANSACTION_AMOUNT
, ACTUAL_START_DATE
, ACTUAL_MATURITY_DATE
, INTEREST_RATE
, NO_OF_DAYS
, YEAR_BASIS
, ACCRLS_AMOUNT
, FIRST_ACCRUAL_INDIC
, TRANSFERED_ON
, REVERSAL_DATE
, CREATED_ON
, CREATED_BY
, ACCRLS_AMOUNT_BAL
, EFFECTIVE_CALCULATED_VALUE
, CALC_FACE_VALUE
, EFFINT_ACCRLS_AMOUNT_BAL
FROM APPS.XTR_ACCRLS_AMORT_V;
APPS.XTR_ACCRLS_AMORT_V is not referenced by any database object
|
|
|