DBA Data[Home] [Help] [Dependency Information]

TABLE: XTR.XTR_ACCRLS_AMORT

Object Details
Object Name: XTR_ACCRLS_AMORT
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_ACCRLS_AMORT
Subobject Name:
Status: VALID


XTR_ACCRLS_AMORT contains the accrual amounts for deal transactions. Each row contains the calculated accrual amount of a deal transaction for a specific accrual period and amount type. Only those accruals that match the deal type, amount type combination set up in the journals structure are transferred to journals.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_ACCRLS_AMORT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERIOD_FROM
ColumnPERIOD_TO
ColumnCOMPANY_CODE
XTR_ACCRLS_AMORT_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCURRENCY
ColumnDEAL_TYPE
XTR_ACCRLS_AMORT_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnDEAL_NO
ColumnTRANS_NO
Columns
Name Datatype Length Mandatory Comments
DEAL_NO NUMBER
Yes Unique number assigned to each deal
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
AUTHORIZE_JOURNAL_CREATION VARCHAR2 (1)
No longer used.
JOURNAL_CREATED DATE

No longer used.
BATCH_ID NUMBER (15) Yes Identifier that groups events into one process flow.
CALC_FACE_VALUE NUMBER

Calc face value
EFFINT_ACCRLS_AMOUNT_BAL NUMBER

Effint accruals amort balance.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DEAL_NO
,      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
,      AUTHORIZE_JOURNAL_CREATION
,      JOURNAL_CREATED
,      BATCH_ID
,      CALC_FACE_VALUE
,      EFFINT_ACCRLS_AMOUNT_BAL
FROM XTR.XTR_ACCRLS_AMORT;

Dependencies

[top of page]

XTR.XTR_ACCRLS_AMORT does not reference any database object

XTR.XTR_ACCRLS_AMORT is referenced by following:

SchemaXTR
ViewXTR_ACCRLS_AMORT#