[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | XTR_A_DEAL_DATE_AMOUNTS |
|---|---|
| Object Type: | TABLE |
| Owner: | XTR |
| FND Design Data: |  XTR.XTR_A_DEAL_DATE_AMOUNTS
|
| 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_DEAL_DATE_AMOUNTS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
 UPDATED_ON
|
| XTR_A_DEAL_DATE_AMOUNTS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DEAL_NUMBER
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ACCOUNT_NO | VARCHAR2 | (20) | Settlement account number. | |
| ACCRUAL_FROM | DATE | Start date of accrual. | ||
| ACCRUAL_TO | DATE | End date of accrual. | ||
| ACTION_CODE | VARCHAR2 | (7) | ||
| ACTION_COMPLETED | VARCHAR2 | (1) | ||
| ACTUAL_SETTLEMENT_DATE | DATE | Date of actual settlement. | ||
| AMOUNT | NUMBER | Yes | ||
| AMOUNT_DATE | DATE | |||
| AMOUNT_TYPE | VARCHAR2 | (7) | Yes | Identifies the purpose of the amount. For example, 'PREMIUM', 'FEE', 'SETTLE'. Composite key to XTR_AMOUNT_TYPES. |
| ARCHIVE_BY | VARCHAR2 | (30) | User who archived this record. | |
| ARCHIVE_DATE | DATE | Date on which this record is archived. | ||
| ATTACHMENT_EXISTS | VARCHAR2 | (1) | Indicates if any document is attached to this record. Valid values are: Y (document attached) or N (no document attached). | |
| AUDIT_DATE_STORED | DATE | Date on which this record is audited. | ||
| AUDIT_INDICATOR | VARCHAR2 | (1) | ||
| AUTHORISED | VARCHAR2 | (1) | Indicates if this record is authorised to be used. Valid values are: Y (authorised) or N (not authorised). | |
| BALANCE_SHEET_EXPOSURE | VARCHAR2 | (1) | ||
| BENEFICIARY_ACCOUNT_NO | VARCHAR2 | (20) | ||
| BENEFICIARY_PARTY | VARCHAR2 | (7) | ||
| CASHFLOW_AMOUNT | NUMBER | |||
| CHQ_REQD | VARCHAR2 | (1) | ||
| CLIENT_BROKER_CLRACCT | VARCHAR2 | (1) | ||
| CLIENT_CODE | VARCHAR2 | (7) | Client identifier. Foreign key to XTR_PARTIES_V. | |
| COMMENCE_DATE | DATE | |||
| COMMENTS | VARCHAR2 | (255) | Additional note. | |
| COMPANY_CODE | VARCHAR2 | (7) | Company identifier. Foreign key to XTR_PARTIES_V. | |
| CONTRACT_CODE | VARCHAR2 | (7) | ||
| CPARTY_ACCOUNT_NO | VARCHAR2 | (20) | ||
| CPARTY_CODE | VARCHAR2 | (7) | Counterparty identifier. Foreign key to XTR_PARTIES_V. | |
| CURRENCY | VARCHAR2 | (15) | Yes | |
| CURRENCY_COMBINATION | VARCHAR2 | (31) | ||
| DATE_TYPE | VARCHAR2 | (7) | Yes | Identifies the purpose of the date. For example, 'DEALT', 'EXPIRY', 'MATURE'. Composite key to XTR_DATE_TYPES. |
| DEALER_CODE | VARCHAR2 | (10) | Dealer identifier. Foreign key to XTR_DEALER_CODES. | |
| DEAL_NUMBER | NUMBER | Yes | Deal identifier. Foreign key to XTR_DEALS. | |
| DEAL_ORDERS | VARCHAR2 | (255) | ||
| DEAL_SUBTYPE | VARCHAR2 | (7) | Deal subtype identifier. Composite key to XTR_DEAL_SUBTYPES. | |
| DEAL_TYPE | VARCHAR2 | (7) | Yes | 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. |
| DIARY_CREATED_BY | VARCHAR2 | (30) | ||
| DIARY_NOTE | VARCHAR2 | (255) | ||
| DIRECT_DEBIT | VARCHAR2 | (1) | ||
| DUAL_AUTHORISATION_BY | VARCHAR2 | (30) | User who dual authorised this record. | |
| DUAL_AUTHORISATION_ON | DATE | Date on which this record is dual authorised. | ||
| EXPOSURE_REF_DATE | DATE | |||
| EXP_SETTLE_REQD | VARCHAR2 | (1) | ||
| EXTERNAL_COMMENTS | VARCHAR2 | (255) | ||
| FIRST_ACCRUAL | DATE | |||
| FRA_DESCRIPTION | VARCHAR2 | (20) | ||
| GENERAL_OR_PRIVATE_ACCESS | VARCHAR2 | (7) | ||
| CODE_COMBINATION_ID | NUMBER | (15) | ||
| GOOD_VALUE_CLAIM | VARCHAR2 | (1) | ||
| HCE_AMOUNT | NUMBER | Amount in home currency. | ||
| JOURNAL_CREATED | VARCHAR2 | (1) | ||
| LIMIT_CODE | VARCHAR2 | (7) | Limit code identifier. Composite key to XTR_COMPANY_LIMITS. | |
| LIMIT_PARTY | VARCHAR2 | (7) | ||
| MULTIPLE_REFERENCE_NUMBER | NUMBER | |||
| MULTIPLE_SETTLEMENTS | VARCHAR2 | (1) | ||
| NETOFF_GROUP_FLAG | VARCHAR2 | (1) | ||
| NETOFF_NUMBER | NUMBER | |||
| PORTFOLIO_CODE | VARCHAR2 | (7) | ||
| PRINTED_MATURITY_YN | VARCHAR2 | (1) | ||
| PRODUCT_TYPE | VARCHAR2 | (10) | Deal product type identifier. Composite key to XTR_PRODUCT_TYPES. | |
| QUICK_INPUT | VARCHAR2 | (1) | ||
| RECONCILED_DAYS_ADJUST | NUMBER | |||
| RECONCILED_PASS_CODE | VARCHAR2 | (3) | ||
| RECONCILED_REFERENCE | NUMBER | |||
| SERIAL_REFERENCE | VARCHAR2 | (12) | ||
| SETTLE | VARCHAR2 | (1) | ||
| SETTLEMENT_ACTIONED | VARCHAR2 | (1) | ||
| SETTLEMENT_ACTIONED_FILE | VARCHAR2 | (50) | ||
| SETTLEMENT_AUTHORISED_BY | VARCHAR2 | (30) | ||
| SETTLEMENT_NUMBER | NUMBER | |||
| SETTLEMENT_PARTY | VARCHAR2 | (7) | ||
| STATUS_CODE | VARCHAR2 | (10) | Deal status. For example, 'CURRENT', 'EXERCISED', 'EXPIRIED'. | |
| TRANSACTION_DATE | DATE | Yes | ||
| TRANSACTION_NUMBER | NUMBER | Rollover transaction identifier. Composite key to XTR_ROLLOVER_TRANSACTIONS. | ||
| TRANSACTION_RATE | NUMBER | |||
| TRANS_MTS | VARCHAR2 | (1) | ||
| UPDATED_BY | VARCHAR2 | (30) | Last updated user. | |
| UPDATED_ON | DATE | Last updated date. | ||
| ORIGINAL_SETTLEMENT_CURRENCY | VARCHAR2 | (15) | ||
| ORIGINAL_SETTLEMENT_AMOUNT | NUMBER | |||
| COMPANY_HCE_AMOUNT | NUMBER | |||
| CREATED_BY | VARCHAR2 | (30) | ||
| CREATED_ON | DATE |
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_DATE_STORED
, 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
FROM XTR.XTR_A_DEAL_DATE_AMOUNTS;
XTR.XTR_A_DEAL_DATE_AMOUNTS does not reference any database object
XTR.XTR_A_DEAL_DATE_AMOUNTS is referenced by following:
APPS
XTR_A_DEAL_DATE_AMOUNTS
|
|
|
|