[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | XTR_DEAL_DATE_AMOUNTS |
|---|---|
| Object Type: | TABLE |
| Owner: | XTR |
| FND Design Data: |  XTR.XTR_DEAL_DATE_AMOUNTS
|
| Subobject Name: | |
| Status: | VALID |
XTR_DEAL_DATE_AMOUNTS contains deal transaction information broken down by the date type, amount type, and amount action combinations that are used to structure journals and track outstanding cashflows. Each row corresponds to the different amounts and dates that result from specific actions performed on a deal, such as exercising an option or settling a FRA. For each deal transaction, only one row contains the limit code that specifies which cashflow amount should be applied to which applicable limit. This table uses database triggers to pull information from any row where the limit code is not null to populate the XTR_MIRROR_DDA_LIMIT_ROW table.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| XTR_DEAL_DATE_AMOUNTS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 DEAL_NUMBER
TRANSACTION_NUMBER
TRANSACTION_DATE
DEAL_TYPE
DATE_TYPE
AMOUNT_TYPE
AMOUNT_DATE
SETTLEMENT_NUMBER
CASHFLOW_AMOUNT
|
| XTR_DEAL_DATE_AMOUNTS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
DEAL_DATE_AMOUNT_ID
|
| XTR_DEAL_DATE_AMOUNTS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ACCOUNT_NO
|
| XTR_DEAL_DATE_AMOUNTS_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
COMPANY_CODE
AMOUNT_DATE
|
| XTR_DEAL_DATE_AMOUNTS_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SETTLEMENT_NUMBER
|
| XTR_DEAL_DATE_AMOUNTS_N14 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
EXP_SETTLE_REQD
|
| XTR_DEAL_DATE_AMOUNTS_N15 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
NETOFF_NUMBER
|
| XTR_DEAL_DATE_AMOUNTS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
AMOUNT_TYPE
DATE_TYPE
DEAL_TYPE
|
| XTR_DEAL_DATE_AMOUNTS_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CURRENCY
COMPANY_CODE
|
| XTR_DEAL_DATE_AMOUNTS_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ACTION_CODE
AMOUNT_TYPE
DEAL_TYPE
|
| XTR_DEAL_DATE_AMOUNTS_N8 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
STATUS_CODE
|
| XTR_DEAL_DATE_AMOUNTS_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DEAL_TYPE
DEAL_NUMBER
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ACCOUNT_NO | VARCHAR2 | (20) | Settlement account number | |
| ACCRUAL_FROM | DATE | Not currently used | ||
| ACCRUAL_TO | DATE | Not currently used | ||
| ACTION_CODE | VARCHAR2 | (7) | Code for actions involved in executing deals | |
| ACTION_COMPLETED | VARCHAR2 | (1) | Not currently used | |
| ACTUAL_SETTLEMENT_DATE | DATE | Settlement date | ||
| AMOUNT | NUMBER | Yes | Transaction amount | |
| 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. | ||
| AMOUNT_TYPE | VARCHAR2 | (7) | Yes | Code that identifies the purpose of the amounts for a deal type |
| ARCHIVE_BY | VARCHAR2 | (30) | Not currently used | |
| ARCHIVE_DATE | DATE | Not currently used | ||
| ATTACHMENT_EXISTS | VARCHAR2 | (1) | Not currently used | |
| AUDIT_INDICATOR | VARCHAR2 | (1) | Not currently used | |
| AUTHORISED | VARCHAR2 | (1) | Not currently used | |
| BALANCE_SHEET_EXPOSURE | VARCHAR2 | (1) | Flag indicates if the exposure type is in balance sheet (Y), or not (N) | |
| BENEFICIARY_ACCOUNT_NO | VARCHAR2 | (20) | Settlement beneficiary party account number | |
| BENEFICIARY_PARTY | VARCHAR2 | (7) | Settlement beneficiary party | |
| CASHFLOW_AMOUNT | NUMBER | Cash flow amount | ||
| CHQ_REQD | VARCHAR2 | (1) | Flag to indicate if user selects check as method of payment for settlement (Y), or not (N) | |
| 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) | |
| CLIENT_CODE | VARCHAR2 | (7) | Client for which the deal is made | |
| COMMENCE_DATE | DATE | Date the deal can start to be exercised | ||
| COMMENTS | VARCHAR2 | (255) | Settlement comments | |
| COMPANY_CODE | VARCHAR2 | (7) | Company code | |
| CONTRACT_CODE | VARCHAR2 | (7) | Not currently used | |
| CPARTY_ACCOUNT_NO | VARCHAR2 | (20) | Alpha-numeric reference of counterparty financial account | |
| CPARTY_CODE | VARCHAR2 | (7) | Counterparty code | |
| CURRENCY | VARCHAR2 | (15) | Yes | Currency code |
| CURRENCY_COMBINATION | VARCHAR2 | (31) | Currency quotations which combine a base and a contra currency | |
| DATE_TYPE | VARCHAR2 | (7) | Yes | Date type tied to specific deal types (for example, accrual, maturity, start, and dealt dates) |
| DEALER_CODE | VARCHAR2 | (10) | Code for Treasury users | |
| DEAL_NUMBER | NUMBER | Yes | Unique number assigned to each deal | |
| DEAL_ORDERS | VARCHAR2 | (255) | Not currently used | |
| DEAL_SUBTYPE | VARCHAR2 | (7) | Code for deal executions permissible within a deal type | |
| DEAL_TYPE | VARCHAR2 | (7) | Yes | Code for high level deals |
| DIARY_CREATED_BY | VARCHAR2 | (30) | Not currently used | |
| DIARY_NOTE | VARCHAR2 | (255) | 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) | |
| 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 | |
| DUAL_AUTHORISATION_ON | DATE | Date on which the user created the deal, to be included only if parameter DUAL_AUTHORISE is set to Y | ||
| EXPOSURE_REF_DATE | DATE | Not currently used | ||
| EXP_SETTLE_REQD | VARCHAR2 | (1) | Flag to indicate if Treasury user wants to automatically initiate a payment for the exposure (Y), or not (N) | |
| EXTERNAL_COMMENTS | VARCHAR2 | (255) | Not currently used | |
| FIRST_ACCRUAL | DATE | Not currently used | ||
| FRA_DESCRIPTION | VARCHAR2 | (20) | Not currently used | |
| GENERAL_OR_PRIVATE_ACCESS | VARCHAR2 | (7) | Not currently used | |
| CODE_COMBINATION_ID | NUMBER | (15) | Unique key for identifying GL account references | |
| GOOD_VALUE_CLAIM | VARCHAR2 | (1) | Not currently used | |
| HCE_AMOUNT | NUMBER | Amount in reporting currency equivalent | ||
| JOURNAL_CREATED | VARCHAR2 | (1) | No longer used. | |
| LIMIT_CODE | VARCHAR2 | (7) | Code for user-defined limits imposed on deals and transactions | |
| LIMIT_PARTY | VARCHAR2 | (7) | Party against which limits are checked | |
| MULTIPLE_REFERENCE_NUMBER | NUMBER | Original settlement number which indicates where this split settlement comes from | ||
| 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) | |
| NETOFF_GROUP_FLAG | VARCHAR2 | (1) | Flag to indicate the method of settlement groupings (Netoff (N), Sum (S), None (O), and Not Set (T)) | |
| NETOFF_NUMBER | NUMBER | Unique reference number assigned to a netting group | ||
| PORTFOLIO_CODE | VARCHAR2 | (7) | Code for grouping deals under a single portfolio | |
| PRINTED_MATURITY_YN | VARCHAR2 | (1) | Not currently used | |
| PRODUCT_TYPE | VARCHAR2 | (10) | Code for products used in a deal type | |
| QUICK_INPUT | VARCHAR2 | (1) | Flag to indicate if the deal is generaged from a quick input deal (Y), or not (N) | |
| RECONCILED_DAYS_ADJUST | NUMBER | Days adjusted for bank statement reconciliation | ||
| 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 | ||
| SERIAL_REFERENCE | VARCHAR2 | (12) | Internal reference | |
| SETTLE | VARCHAR2 | (1) | Flag to indicate if the settlement has been authorized (Y), or not (N) | |
| 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 | |
| SETTLEMENT_AUTHORISED_BY | VARCHAR2 | (30) | Treasury user who authorized the settlement | |
| SETTLEMENT_NUMBER | NUMBER | Unique reference number assigned to a settlement | ||
| SETTLEMENT_PARTY | VARCHAR2 | (7) | Not currently used | |
| STATUS_CODE | VARCHAR2 | (10) | Code for the execution status of deals and transactions | |
| TRANSACTION_DATE | DATE | Yes | Date the transaction is made | |
| TRANSACTION_NUMBER | NUMBER | Unique reference number assigned to a transaction | ||
| TRANSACTION_RATE | NUMBER | Transaction rate | ||
| 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) | |
| UPDATED_BY | VARCHAR2 | (30) | User who last updated this record | |
| UPDATED_ON | DATE | Date this record was last updated | ||
| 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 | ||
| BATCH_ID | NUMBER | (15) | Identifier that groups events into one process flow. | |
| DEAL_DATE_AMOUNT_ID | NUMBER | Yes | Unique reference number assigned to each deal date amount. | |
| COMPANY_ACCT_USE_ID | NUMBER | (15) | Settlement account ID | |
| CPARTY_ACCT_USE_ID | NUMBER | (15) | Counterparty account ID | |
| BENEFECIARY_ACCT_USE_ID | NUMBER | (15) | Settlement beneficiary party account ID |
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_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
, BATCH_ID
, DEAL_DATE_AMOUNT_ID
, COMPANY_ACCT_USE_ID
, CPARTY_ACCT_USE_ID
, BENEFECIARY_ACCT_USE_ID
FROM XTR.XTR_DEAL_DATE_AMOUNTS;
XTR.XTR_DEAL_DATE_AMOUNTS does not reference any database object
XTR.XTR_DEAL_DATE_AMOUNTS is referenced by following:
XTR
XTR_DEAL_DATE_AMOUNTS#
|
|
|
|