[Home] [Help] [Dependency Information]
Object Name: | XTR_A_JOURNALS |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_A_JOURNALS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_A_JOURNALS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | UPDATED_ON |
XTR_A_JOURNALS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
JOURNAL_DATE
DEAL_NUMBER TRANSACTION_NUMBER COMPANY_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AMOUNT_TYPE | VARCHAR2 | (7) | Identifies the purpose of the amount. For example, 'PREMIUM', 'FEE', 'SETTLE'. Composite key to XTR_AMOUNT_TYPES. | |
AUDIT_DATE_STORED | DATE | Date on which this record is audited. | ||
AUDIT_INDICATOR | VARCHAR2 | (1) | ||
CANCELLED_IN_GL | VARCHAR2 | (1) | ||
COMMENTS | VARCHAR2 | (255) | Additional note. | |
COMPANY_CODE | VARCHAR2 | (7) | Yes | Company identifier. Foreign key to XTR_PARTIES_V. |
CREATED_BY | VARCHAR2 | (30) | Yes | User who created this record. |
CREATED_ON | DATE | Yes | Date on which this record is created. | |
CREDIT_AMOUNT | NUMBER | |||
CURRENCY | VARCHAR2 | (15) | ||
DEAL_NUMBER | NUMBER | Yes | Deal identifier. Foreign key to XTR_DEALS. | |
DEAL_SUBTYPE | VARCHAR2 | (7) | Deal subtype identifier. Composite key to XTR_DEAL_SUBTYPES. | |
DEAL_TYPE | VARCHAR2 | (7) | Deal type identifier. Foreign key to XTR_DEAL_TYPES. Valid values are: BOND, CA, CMF, DEB, EQ, EXP, FRA, FUT, FX, FXO, IG, IRO, IRS, NI, ONC, SWPTN, TMM. | |
DEBIT_AMOUNT | NUMBER | |||
CODE_COMBINATION_ID | NUMBER | (15) | Yes | |
GL_TRANSFER_DATE | DATE | |||
JNL_REVERSAL_IND | VARCHAR2 | (1) | ||
JOURNAL_DATE | DATE | Yes | ||
PORTFOLIO_CODE | VARCHAR2 | (7) | ||
PRODUCT_TYPE | VARCHAR2 | (10) | Deal product type identifier. Composite key to XTR_PRODUCT_TYPES. | |
TRANSACTION_NUMBER | NUMBER | Yes | ||
TRANSFER_TO_EXTERNAL_GL | DATE | |||
UPDATED_BY | VARCHAR2 | (30) | Last updated user. | |
UPDATED_ON | DATE | Last updated date. | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | |
SUSPENSE_GL | VARCHAR2 | (1) | ||
ACCOUNTED_DR | NUMBER | |||
ACCOUNTED_CR | NUMBER | |||
GL_SL_LINK_ID | NUMBER | (15) | ||
SETTLEMENT_NUMBER | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT AMOUNT_TYPE
, AUDIT_DATE_STORED
, AUDIT_INDICATOR
, CANCELLED_IN_GL
, COMMENTS
, COMPANY_CODE
, CREATED_BY
, CREATED_ON
, CREDIT_AMOUNT
, CURRENCY
, DEAL_NUMBER
, DEAL_SUBTYPE
, DEAL_TYPE
, DEBIT_AMOUNT
, CODE_COMBINATION_ID
, GL_TRANSFER_DATE
, JNL_REVERSAL_IND
, JOURNAL_DATE
, PORTFOLIO_CODE
, PRODUCT_TYPE
, TRANSACTION_NUMBER
, TRANSFER_TO_EXTERNAL_GL
, UPDATED_BY
, UPDATED_ON
, SET_OF_BOOKS_ID
, SUSPENSE_GL
, ACCOUNTED_DR
, ACCOUNTED_CR
, GL_SL_LINK_ID
, SETTLEMENT_NUMBER
FROM XTR.XTR_A_JOURNALS;
XTR.XTR_A_JOURNALS does not reference any database object
XTR.XTR_A_JOURNALS is referenced by following:
|
|
|