[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | XTR_DEALS |
|---|---|
| Object Type: | TABLE |
| Owner: | XTR |
| FND Design Data: |  XTR.XTR_DEALS
|
| Subobject Name: | |
| Status: | VALID |
XTR_DEALS contains information for all financial instrument deals except exposure transactions. Each row corresponds to a deal. A deal consists of its deal type, deal subtype, company, counterparty, deal amounts, dates, dealer, and other financial instrument-specific information. Bond options, FRAs, foreign exchange deals, foreign exchange options, interest rate options, and swaptions are recorded only in this table because they have only one transaction per deal. Deals with multiple transactions, such as bonds, interest rate swaps, discounted securities, short term money, retail term money, and wholesale term money, have their common header information stored in this table and their transaction details stored in XTR_ROLLOVER_TRANSACTIONS.
When you create a deal, database triggers automatically insert multiple rows into XTR_DEAL_DATE_AMOUNTS each with a different date type, amount type, and action code combination, depending on the type of deal you created. When you update the deal status, database triggers maintain the XTR_DEAL_DATE_AMOUNTS table accordingly.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| XTR_DEALS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 DEAL_NO
|
| XTR_DEALS_N18 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SETTLE_ACTION
SETTLE_AMOUNT_TYPE
DEAL_TYPE
|
| XTR_DEALS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BUY_ACCOUNT_NO
COMPANY_CODE
|
| XTR_DEALS_N21 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
COMPANY_CODE
|
| XTR_DEALS_N22 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CPARTY_CODE
|
| XTR_DEALS_N26 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FIRST_REVAL_BATCH_ID
|
| XTR_DEALS_N27 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LAST_REVAL_BATCH_ID
|
| XTR_DEALS_N28 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DEAL_TYPE
EXTERNAL_DEAL_ID
|
| XTR_DEALS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CURRENCY_BUY
CURRENCY_SELL
|
| XTR_DEALS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DEAL_TYPE
DEAL_SUBTYPE
|
| XTR_DEALS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LIMIT_CODE
CPARTY_CODE
COMPANY_CODE
|
| XTR_DEALS_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
STATUS_CODE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ACCEPTOR_CODE | VARCHAR2 | (7) | Acceptor code (party in a discounted securities deal who is responsible for the payment at maturity) | |
| ACCEPTOR_NAME | VARCHAR2 | (20) | Acceptor name | |
| ACCRUAL_FROM | DATE | Not currently used | ||
| ACCRUAL_TO | DATE | Not currently used | ||
| ACCRUED_INTEREST_PRICE | NUMBER | Accrued interest of the bond | ||
| ACTION_STATUS | VARCHAR2 | (20) | Not currently used | |
| 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 | |
| BASE_DATE | DATE | Deal date | ||
| BASE_RATE | NUMBER | Spot rate from which points are added or subtracted to produce the forward rate | ||
| BKGE_SETTLED_REFERENCE | NUMBER | Brokerage settlement reference number (all transactions with the same reference number were settled together in one settle action) | ||
| BOND_ISSUE | VARCHAR2 | (30) | Bond or Stock issue code | |
| BOND_PROFIT_LOSS | NUMBER | Profit or loss of a bond type deal | ||
| BOND_RENEG_DATE | DATE | Date the bond deal was resold | ||
| BOND_RESALE_DATE | DATE | Not currently used | ||
| BROKER | VARCHAR2 | (7) | Code to identify the broker | |
| BROKERAGE_AMOUNT | NUMBER | Fee paid to a broker to execute a trade | ||
| BROKERAGE_AMOUNT_HCE | NUMBER | Brokerage amount in reporting currency equivalent | ||
| BROKERAGE_CODE | VARCHAR2 | (7) | Brokerage code | |
| BOND_SALE_DATE | DATE | Date a bond deal is sold | ||
| BROKERAGE_CURRENCY | VARCHAR2 | (15) | Currency code of brokerage amount | |
| BROKERAGE_RATE | NUMBER | Rate that a company charges a counterparty or that a counterparty pays to a company for brokered deals | ||
| BUY_ACCOUNT_NO | VARCHAR2 | (20) | Company account that serves as the receiver of the settlement in the buy currency of a foreign exchange deal | |
| BUY_AMOUNT | NUMBER | Amount in the buy currency of a foreign exchange deal | ||
| BUY_HCE_AMOUNT | NUMBER | Buy amount in reporting currency equivalent | ||
| CALC_BASIS | VARCHAR2 | (8) | Method of calculating interest (for example, discount basis or yield basis) | |
| CAPITAL_PRICE | NUMBER | Dirty price of the bond (full market value of the bond issue minus the accrued interest, expressed as a percentage of the issue?s face value) | ||
| CAP_OR_FLOOR | VARCHAR2 | (5) | Type of option Call (C) or Put (P) | |
| CLIENT_ADVICE | VARCHAR2 | (1) | Not currently used | |
| CLIENT_CODE | VARCHAR2 | (7) | Type of option (C for Call or P for Put) | |
| CLIENT_REF | VARCHAR2 | (7) | Client account reference | |
| COMMENCE_DATE | DATE | Not currently used | ||
| COMMENTS | VARCHAR2 | (255) | Internal comments | |
| COMPANY_CODE | VARCHAR2 | (7) | Yes | Company code |
| CONTRACT_COMMISSION | NUMBER | Not currently used | ||
| CONTRACT_FEES | NUMBER | Not currently used | ||
| CONTRACT_NOS | NUMBER | Not currently used | ||
| CONTRACT_RATE | NUMBER | Not currently used | ||
| COUPON_ACTION | VARCHAR2 | (3) | Code to identify coupon action | |
| COUPON_RATE | NUMBER | Interest rate that the issuer agrees to pay the investor | ||
| CPARTY_ADVICE | VARCHAR2 | (1) | Not currently used | |
| CPARTY_CODE | VARCHAR2 | (7) | Yes | Counterparty code |
| CPARTY_REF | VARCHAR2 | (7) | Counterparty account reference code | |
| CREATED_BY | VARCHAR2 | (30) | Yes | User who created this record |
| CREATED_ON | DATE | Yes | Date this record was created | |
| CTY_CCY | VARCHAR2 | (15) | Contra currency in a foreign exchange currency quote | |
| CUM_COUPON_DATE | DATE | Upcoming coupon date | ||
| CURRENCY | VARCHAR2 | (15) | Currency code | |
| CURRENCY_BUY | VARCHAR2 | (15) | Currency code of buy amount | |
| CURRENCY_SELL | VARCHAR2 | (15) | Currency code of sell amount | |
| DEALER_CODE | VARCHAR2 | (10) | Yes | Code for Treasury users |
| DEAL_DATE | DATE | Yes | Date the deal is made | |
| DEAL_LINKING_CODE | VARCHAR2 | (8) | Code to identify the group of linked deals | |
| DEAL_NO | NUMBER | Yes | Unique number assigned to each deal | |
| DEAL_SUBTYPE | VARCHAR2 | (7) | Yes | Code to sub-categorize deals within each deal type |
| DEAL_TYPE | VARCHAR2 | (7) | Yes | Code to identify a deal or instrument type |
| DISCOUNT | VARCHAR2 | (1) | Flag to indicate if the interest rate is of discount (Y) or yield basis (N) | |
| DRAWER_CODE | VARCHAR2 | (7) | Drawer code (party in a discounted securities deal who is responsible for paying if the acceptor and endorser defaults on the payment) | |
| DRAWER_NAME | VARCHAR2 | (20) | Drawer name | |
| DUAL_AUTHORISATION_BY | VARCHAR2 | (30) | Login name of user who created the deal (only applies if the Treasury system parameter, DUAL_AUTHORISE, is set to Y) | |
| DUAL_AUTHORISATION_ON | DATE | Date the user created the deal (only applies if the Treasury system parameter, DUAL_AUTHORISE, is set to Y) | ||
| ENDORSER_CODE | VARCHAR2 | (7) | Endorser code (party in a discounted securities deal who is responsible for paying the negotiable instruments if the acceptor defaults on the payment) | |
| ENDORSER_NAME | VARCHAR2 | (20) | Endorser name | |
| ENTER_INTO_SWAP | VARCHAR2 | (1) | Reference number for an interest rate swap | |
| EXCHANGE_CODE | VARCHAR2 | (7) | Not currently used | |
| EXERCISE | VARCHAR2 | (1) | Flag to indicate if an option has been exercised (Y), or not (N) | |
| EXPIRY_DATE | DATE | Price at which the security underlying the options contract may be bought or sold | ||
| EXTERNAL_COMMENTS | VARCHAR2 | (255) | External comments | |
| EXTERNAL_CPARTY_NO | VARCHAR2 | (15) | External reference | |
| FACE_VALUE_AMOUNT | NUMBER | Amount that the issuer agrees to pay at maturity date | ||
| FACE_VALUE_HCE_AMOUNT | NUMBER | Face value in reporting currency equivalent | ||
| FIRST_REVAL | VARCHAR2 | (1) | Not currently used | |
| FIXED_OR_FLOATING_RATE | VARCHAR2 | (5) | Code to indicate if the interest rate is fixed (FIXED) or floating (FLOAT) | |
| FIXED_TERM_MY | VARCHAR2 | (3) | Code to identify the term of the fixed interest rate period (M for month, or Y for year) | |
| FORWARD_HCE_AMOUNT | NUMBER | Amount difference in reporting currency equivalent between the buy and sell amounts in a forward foregin echange deal | ||
| FRA_DESCRIPTION | VARCHAR2 | (20) | Not currently used | |
| FREQUENCY | NUMBER | Payment frequency | ||
| FXD_DEAL_NO | NUMBER | Deal number of the first part of a foreign exchange swap deal | ||
| FXO_DEAL_NO | NUMBER | Deal number of the foreign exchange option deal from which this deal was generated | ||
| FX_COVER_CROSS_REF | NUMBER | Deal number of the bond that was partially sold | ||
| FX_PD_DEAL_NO | NUMBER | Number of the deal from which deal was pre-delivered | ||
| FX_REVALUED_ON_DATE | DATE | Date the foreign exchange deal was valued | ||
| FX_RO_DEAL_NO | NUMBER | Number of the deal from which this foreign exchange deal was rolled over | ||
| FX_SUBSIDIARY_BALANCE_AMOUNT | NUMBER | Not currently used | ||
| FX_WHOLESALE_REF | NUMBER | Number of the parent deal for this subsidiary foreign exchange deal | ||
| INSERT_FOR_CASHFLOW | VARCHAR2 | (1) | Flag to indicate if the cashflow row of a foreign exchange option is to be inserted into XTR_DEAL_DATE_AMOUNTS table (Y), or not (N) | |
| INTEREST_AMOUNT | NUMBER | Interest amount | ||
| INTEREST_CUTOFF | VARCHAR2 | (1) | Not currently used | |
| INTEREST_HCE_AMOUNT | NUMBER | Interest amount in reporting currency equivalent | ||
| INTEREST_RATE | NUMBER | Agreed upon rate expressed as a percentage per annum | ||
| INTERNAL_TICKET_NO | VARCHAR2 | (15) | Internal reference | |
| INT_SWAP_REF | VARCHAR2 | (10) | Unique reference for interest rate swap deals | |
| KNOCK_EXECUTED_BY | VARCHAR2 | (10) | Treasury user who executed the foreign exchange knock option | |
| KNOCK_EXECUTED_ON | DATE | Date the foreign exchange knock option is executed | ||
| KNOCK_INSERT_TYPE | VARCHAR2 | (1) | Not currently used | |
| KNOCK_LEVEL | NUMBER | Knock rate | ||
| KNOCK_TYPE | VARCHAR2 | (10) | Flag to indicate if the foreign exchange option deal is an knock in (I), knock out (O), or standard (null) option type | |
| LIMIT_AMOUNT | NUMBER | Maximum amount allowed by the limit | ||
| LIMIT_CODE | VARCHAR2 | (7) | Code for user-defined limits imposed on deals and transactions | |
| MARGIN | NUMBER | Not currently used | ||
| MATURITY_ACCOUNT_NO | VARCHAR2 | (20) | Company account for the face value settlement for discounted securities deals | |
| MATURITY_AMOUNT | NUMBER | Amount that the issuer agrees to pay at the maturity date | ||
| MATURITY_BALANCE_AMOUNT | NUMBER | Face value balance of discounted securities deals | ||
| MATURITY_BALANCE_HCE_AMOUNT | NUMBER | Face value balance in reporting currency equivalent | ||
| MATURITY_DATE | DATE | Date the deal matures or an action is required | ||
| MATURITY_HCE_AMOUNT | NUMBER | Maturity amount in reporting currency equivalent | ||
| NEXT_COUPON_DATE | DATE | Maturity amount in reporting currency equivalent | ||
| NI_DEAL_NO | NUMBER | Not currently used | ||
| NI_PROFIT_LOSS | NUMBER | Profit or loss amount for discounted securities deals | ||
| NO_OF_DAYS | NUMBER | Number of days used to calculate interest | ||
| OPTION_AMOUNT | NUMBER | Not currently used | ||
| OPTION_COMMENCEMENT | DATE | Date the option can start to be exercised | ||
| OPTION_HCE_AMOUNT | NUMBER | Not currently used | ||
| OPTION_POINTS | NUMBER | Break even rate for an option deal (the rate at which the premium is recovered) | ||
| OPTION_TYPE | VARCHAR2 | (8) | Code to indicate whether the option is American (AMERICAN) or European (EUROPEAN) | |
| PAYMENT_FREQ | VARCHAR2 | (12) | Payment frequency for retail and wholesale term money deals | |
| PAYMENT_SCHEDULE_CODE | VARCHAR2 | (7) | Payment schedule code | |
| PI_AMOUNT_DUE | NUMBER | Total amount of principal and interest for retail term money deals | ||
| PORTFOLIO_AMOUNT | NUMBER | Portfolio amount | ||
| PORTFOLIO_CODE | VARCHAR2 | (7) | Yes | Code for grouping deals under a single portfolio |
| PREMIUM_ACCOUNT_NO | VARCHAR2 | (20) | Code for grouping deals under a single portfolio | |
| PREMIUM_ACTION | VARCHAR2 | (7) | Premium action code | |
| PREMIUM_AMOUNT | NUMBER | Option premium amount | ||
| PREMIUM_AMOUNT_TYPE | VARCHAR2 | (7) | Not currently used | |
| PREMIUM_CURRENCY | VARCHAR2 | (15) | Currency code of the option premium | |
| PREMIUM_DATE | DATE | Date the option premium is paid or received | ||
| PREMIUM_HCE_AMOUNT | NUMBER | Premium in reporting currency equivalent | ||
| PREMIUM_NO_OF_DAYS | NUMBER | Not currently used | ||
| PRINCIPAL_SETTLED_BY | VARCHAR2 | (1) | Client settlement action code (C for Clearing Account, D for Direct To Counterparty, or A for Account) | |
| PRINTED_CPARTY_ADVICE | VARCHAR2 | (1) | Not currently used | |
| PRINTED_YN | VARCHAR2 | (1) | Flag to indicate if the confirmation letter is printed (Y), or not (N) | |
| PRODUCT_TYPE | VARCHAR2 | (10) | Code for products used in a deal type | |
| QUICK_INPUT | VARCHAR2 | (1) | Flag to indicate if the deal is generated from a quick input deal (Y), or not (N) | |
| RATE_BASIS | VARCHAR2 | (20) | Source for interest rate quotes (for example, LIBOR) | |
| REF_CCY | VARCHAR2 | (15) | Base currency code | |
| RENEG_DATE | DATE | Not currently used | ||
| RISKPARTY_CODE | VARCHAR2 | (7) | Code to identify the risk party | |
| RISKPARTY_LIMIT_CODE | VARCHAR2 | (7) | Limit code against the risk party | |
| SECURITY_NAME | VARCHAR2 | (10) | Security name | |
| SELL_ACCOUNT_NO | VARCHAR2 | (20) | Company account that serves as the source of the settlement in the sell currency of a foreign exchange deal | |
| SELL_AMOUNT | NUMBER | Amount in the sell currency of a foreign exchange deal | ||
| SELL_HCE_AMOUNT | NUMBER | Amount in the sell currency of a foreign exchange deal in reporting currency equivalent | ||
| SETTLE_ACCOUNT_NO | VARCHAR2 | (20) | Company account used for the settlement funds on deal exercise or settlement | |
| SETTLE_ACTION | VARCHAR2 | (7) | Code to identify the settlement action | |
| SETTLE_AMOUNT | NUMBER | Amount settled | ||
| SETTLE_AMOUNT_TYPE | VARCHAR2 | (7) | Not currently used | |
| SETTLE_DATE | DATE | Settlement date | ||
| SETTLE_DUAL_AUTHORISATION_BY | VARCHAR2 | (30) | User who authorized the deal settlement | |
| SETTLE_DUAL_AUTHORISATION_ON | DATE | Date the deal settlement is authorized | ||
| SETTLE_HCE_AMOUNT | NUMBER | Settlement amount in reporting currency equivalent | ||
| SETTLE_NO_OF_DAYS | NUMBER | Not currently used | ||
| SETTLE_RATE | NUMBER | Current market rate on which settlement funds are calculated on deal exercise or settlement | ||
| SPOT_RATE_ON_VALUATION | NUMBER | Not currently used | ||
| START_ACCOUNT_NO | VARCHAR2 | (20) | Company settlement account number for short term money deals | |
| START_AMOUNT | NUMBER | Amount to be settled on the start date for discounted securities deals | ||
| START_DATE | DATE | Date the deal starts | ||
| START_HCE_AMOUNT | NUMBER | Consideration value in reporting currency equivalent | ||
| STATUS_CODE | VARCHAR2 | (10) | Yes | Code for the execution status of deals and transactions |
| SWAP_DEPO_ADJUSTMENT | NUMBER | Not currently used | ||
| SWAP_DEPO_FLAG | VARCHAR2 | (1) | Not currently used | |
| SWAP_DEPO_INT_RATE | NUMBER | Not currently used | ||
| SWAP_DEPO_TOTAL_RECEIPT | NUMBER | Not currently used | ||
| SWAP_REF | VARCHAR2 | (10) | Number (or swap reference) of the bond (or interest rate swap) generated by exercising the option | |
| SYNTHETIC_PRINTED_YN | VARCHAR2 | (1) | Not currently used | |
| TAX_AMOUNT | NUMBER | Tax amount | ||
| TAX_AMOUNT_HCE | NUMBER | Tax amount in reporting currency equivalent | ||
| TAX_CODE | VARCHAR2 | (7) | Code to indentify the tax | |
| TAX_RATE | NUMBER | Withholding tax rate | ||
| TAX_SETTLED_REFERENCE | NUMBER | Reference number of the tax settlement of the deal | ||
| TERM_MY | VARCHAR2 | (4) | Not currently used | |
| TOTAL_PRICE | NUMBER | Full market value of a bond, including accrued interest, expressed as a percentage of its face value | ||
| TRANSACTION_CROSS_REF | VARCHAR2 | (7) | Not currently used | |
| TRANSACTION_NO | NUMBER | Unique reference number assigned to a transaction | ||
| TRANSACTION_RATE | NUMBER | Foreign exchange rate | ||
| UPDATED_BY | VARCHAR2 | (30) | User who last updated this record | |
| UPDATED_ON | DATE | Date this record was last updated | ||
| VALUE_DATE | DATE | Date the foreign exchange deal takes place | ||
| YEAR_BASIS | NUMBER | Number of days in a year to use in calculate interest (for example, 360 and 365) | ||
| YEAR_CALC_TYPE | VARCHAR2 | (15) | Day count basis which defines the way in which interest accrues over time | |
| YIELD_AMOUNT | NUMBER | Interest amount | ||
| YIELD_HCE_AMOUNT | NUMBER | Interest amount in reporting currency equivalent | ||
| RATE_FIXING_DATE | DATE | Date the deal rate changes from fixed to floating | ||
| SECURITY_ID | VARCHAR2 | (10) | Bond issue unique identifier issued by the government (for example, CUSSIP) | |
| EXERCISE_PRICE | NUMBER | Price at which the security underlying the options contract may be bought or sold | ||
| KNOCK_EXECUTE_DATE | DATE | The effective date on which the knock is executed | ||
| PRICING_MODEL | VARCHAR2 | (30) | Specifies the pricing model used by this deal. Derived from the CODE column of the XTR_PRICE_MODELS table. All deals will have a pricing model. | |
| MARKET_DATA_SET | VARCHAR2 | (30) | Specifies the market data set used by the pricing model. | |
| INITIAL_FAIR_VALUE | NUMBER | Stores the calculated initial fair value | ||
| EXCHANGE_RATE_ONE | NUMBER | This exchange rate is mandatory for all single and double currency deal types. | ||
| EXCHANGE_RATE_TWO | NUMBER | This exchange rate is used for double currency deal types. | ||
| FIRST_REVAL_BATCH_ID | NUMBER | (15) | Denotes the number of the first revaluation batch that this rollover transaction belongs to. | |
| LAST_REVAL_BATCH_ID | NUMBER | (15) | The batch id in which the realized gain/loss of the deal/transaction was calculated. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | For Descriptive Flexfield | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield | |
| PROFIT_LOSS | NUMBER | Realized gain/loss of the original FX deal, if the deal is rollover or predelivered. | ||
| FX_RO_PD_RATE | NUMBER | The transaction rate of the rollover/predelivered deal. | ||
| FX_M1_DEAL_NO | NUMBER | The deal number of the new rollover/predelivery deal for multiple deals that are rolled/predelivered into a single deal. | ||
| EXTERNAL_DEAL_ID | VARCHAR2 | (240) | This stores the external unique primary identifier for each deal. | |
| REQUEST_ID | NUMBER | (15) | Keeps track of the concurrent request during which this row was created or updated. | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | With PROGRAM_ID, keeps track of which concurrent program created or updated each row. | |
| PROGRAM_ID | NUMBER | (15) | With PROGRAM_APPLICATION_ID, keeps track of which concurrent program created or updated each row. | |
| PROGRAM_UPDATE_DATE | DATE | Stores the data on which the concurrent program | ||
| FORCE_MONTH_END | VARCHAR2 | (1) | ndicates whether a start date of 28, 29, 30 was forced for a month end for subsequent records or not. | |
| QUANTITY | NUMBER | Not currently used | ||
| REMAINING_QUANTITY | NUMBER | Not currently used | ||
| ROUNDING_TYPE | VARCHAR2 | (1) | Not currently used | |
| SETTLE_ROUNDING_TYPE | VARCHAR2 | (1) | Not currently used | |
| SETTLE_DAY_COUNT_TYPE | VARCHAR2 | (1) | Not currently used | |
| ORIGINAL_AMOUNT | NUMBER | Not currently used | ||
| DAY_COUNT_TYPE | VARCHAR2 | (1) | Not currently used | |
| INCOME_TAX_CODE | VARCHAR2 | (7) | Not currently used | |
| INCOME_TAX_RATE | NUMBER | Not currently used | ||
| PREPAID_INTEREST | VARCHAR2 | (1) | Identify whether it is prepaid interest deal | |
| INCOME_TAX_AMOUNT | NUMBER | Income Tax Amount. | ||
| INCOME_TAX_SETTLED_REF | NUMBER | Income Tax Settled Reference. | ||
| CPARTY_ACCOUNT_NO | VARCHAR2 | (20) | Counterparty bank account number | |
| MATURE_SETTLEMENT_BASIS | VARCHAR2 | (2) | Business day convention for maturity dates | |
| PAYMENT_SETTLEMENT_BASIS | VARCHAR2 | (2) | Business day convention for interest due on dates. | |
| BUY_ACCT_USE_ID | NUMBER | (15) | Company account for the receiver of the settlement in the buy currency of a foreign exchange deal | |
| SELL_ACCT_USE_ID | NUMBER | (15) | Company account for the source of the settlement in the sell currency of a foreign exchange deal | |
| MATURITY_ACCT_USE_ID | NUMBER | (15) | Company account for the face value settlement for discounted securities deal | |
| PREMIUM_ACCT_USE_ID | NUMBER | (15) | Company account used for premiums | |
| SETTLE_ACCT_USE_ID | NUMBER | (15) | Company account used for the settlement funds on deal exercise or settlement | |
| START_ACCT_USE_ID | NUMBER | (15) | Company settlement account ID for short term money deals | |
| CPARTY_ACCT_USE_ID | NUMBER | (15) | Counterparty account ID | |
| CLIENT_ACCOUNT_NO | VARCHAR2 | (20) | Client bank account number | |
| CLIENT_ACCT_USE_ID | NUMBER | (15) | Client account ID |
Cut, paste (and edit) the following text to query this object:
SELECT ACCEPTOR_CODE
, ACCEPTOR_NAME
, ACCRUAL_FROM
, ACCRUAL_TO
, ACCRUED_INTEREST_PRICE
, ACTION_STATUS
, ARCHIVE_BY
, ARCHIVE_DATE
, ATTACHMENT_EXISTS
, AUDIT_INDICATOR
, BASE_DATE
, BASE_RATE
, BKGE_SETTLED_REFERENCE
, BOND_ISSUE
, BOND_PROFIT_LOSS
, BOND_RENEG_DATE
, BOND_RESALE_DATE
, BROKER
, BROKERAGE_AMOUNT
, BROKERAGE_AMOUNT_HCE
, BROKERAGE_CODE
, BOND_SALE_DATE
, BROKERAGE_CURRENCY
, BROKERAGE_RATE
, BUY_ACCOUNT_NO
, BUY_AMOUNT
, BUY_HCE_AMOUNT
, CALC_BASIS
, CAPITAL_PRICE
, CAP_OR_FLOOR
, CLIENT_ADVICE
, CLIENT_CODE
, CLIENT_REF
, COMMENCE_DATE
, COMMENTS
, COMPANY_CODE
, CONTRACT_COMMISSION
, CONTRACT_FEES
, CONTRACT_NOS
, CONTRACT_RATE
, COUPON_ACTION
, COUPON_RATE
, CPARTY_ADVICE
, CPARTY_CODE
, CPARTY_REF
, CREATED_BY
, CREATED_ON
, CTY_CCY
, CUM_COUPON_DATE
, CURRENCY
, CURRENCY_BUY
, CURRENCY_SELL
, DEALER_CODE
, DEAL_DATE
, DEAL_LINKING_CODE
, DEAL_NO
, DEAL_SUBTYPE
, DEAL_TYPE
, DISCOUNT
, DRAWER_CODE
, DRAWER_NAME
, DUAL_AUTHORISATION_BY
, DUAL_AUTHORISATION_ON
, ENDORSER_CODE
, ENDORSER_NAME
, ENTER_INTO_SWAP
, EXCHANGE_CODE
, EXERCISE
, EXPIRY_DATE
, EXTERNAL_COMMENTS
, EXTERNAL_CPARTY_NO
, FACE_VALUE_AMOUNT
, FACE_VALUE_HCE_AMOUNT
, FIRST_REVAL
, FIXED_OR_FLOATING_RATE
, FIXED_TERM_MY
, FORWARD_HCE_AMOUNT
, FRA_DESCRIPTION
, FREQUENCY
, FXD_DEAL_NO
, FXO_DEAL_NO
, FX_COVER_CROSS_REF
, FX_PD_DEAL_NO
, FX_REVALUED_ON_DATE
, FX_RO_DEAL_NO
, FX_SUBSIDIARY_BALANCE_AMOUNT
, FX_WHOLESALE_REF
, INSERT_FOR_CASHFLOW
, INTEREST_AMOUNT
, INTEREST_CUTOFF
, INTEREST_HCE_AMOUNT
, INTEREST_RATE
, INTERNAL_TICKET_NO
, INT_SWAP_REF
, KNOCK_EXECUTED_BY
, KNOCK_EXECUTED_ON
, KNOCK_INSERT_TYPE
, KNOCK_LEVEL
, KNOCK_TYPE
, LIMIT_AMOUNT
, LIMIT_CODE
, MARGIN
, MATURITY_ACCOUNT_NO
, MATURITY_AMOUNT
, MATURITY_BALANCE_AMOUNT
, MATURITY_BALANCE_HCE_AMOUNT
, MATURITY_DATE
, MATURITY_HCE_AMOUNT
, NEXT_COUPON_DATE
, NI_DEAL_NO
, NI_PROFIT_LOSS
, NO_OF_DAYS
, OPTION_AMOUNT
, OPTION_COMMENCEMENT
, OPTION_HCE_AMOUNT
, OPTION_POINTS
, OPTION_TYPE
, PAYMENT_FREQ
, PAYMENT_SCHEDULE_CODE
, PI_AMOUNT_DUE
, PORTFOLIO_AMOUNT
, PORTFOLIO_CODE
, PREMIUM_ACCOUNT_NO
, PREMIUM_ACTION
, PREMIUM_AMOUNT
, PREMIUM_AMOUNT_TYPE
, PREMIUM_CURRENCY
, PREMIUM_DATE
, PREMIUM_HCE_AMOUNT
, PREMIUM_NO_OF_DAYS
, PRINCIPAL_SETTLED_BY
, PRINTED_CPARTY_ADVICE
, PRINTED_YN
, PRODUCT_TYPE
, QUICK_INPUT
, RATE_BASIS
, REF_CCY
, RENEG_DATE
, RISKPARTY_CODE
, RISKPARTY_LIMIT_CODE
, SECURITY_NAME
, SELL_ACCOUNT_NO
, SELL_AMOUNT
, SELL_HCE_AMOUNT
, SETTLE_ACCOUNT_NO
, SETTLE_ACTION
, SETTLE_AMOUNT
, SETTLE_AMOUNT_TYPE
, SETTLE_DATE
, SETTLE_DUAL_AUTHORISATION_BY
, SETTLE_DUAL_AUTHORISATION_ON
, SETTLE_HCE_AMOUNT
, SETTLE_NO_OF_DAYS
, SETTLE_RATE
, SPOT_RATE_ON_VALUATION
, START_ACCOUNT_NO
, START_AMOUNT
, START_DATE
, START_HCE_AMOUNT
, STATUS_CODE
, SWAP_DEPO_ADJUSTMENT
, SWAP_DEPO_FLAG
, SWAP_DEPO_INT_RATE
, SWAP_DEPO_TOTAL_RECEIPT
, SWAP_REF
, SYNTHETIC_PRINTED_YN
, TAX_AMOUNT
, TAX_AMOUNT_HCE
, TAX_CODE
, TAX_RATE
, TAX_SETTLED_REFERENCE
, TERM_MY
, TOTAL_PRICE
, TRANSACTION_CROSS_REF
, TRANSACTION_NO
, TRANSACTION_RATE
, UPDATED_BY
, UPDATED_ON
, VALUE_DATE
, YEAR_BASIS
, YEAR_CALC_TYPE
, YIELD_AMOUNT
, YIELD_HCE_AMOUNT
, RATE_FIXING_DATE
, SECURITY_ID
, EXERCISE_PRICE
, KNOCK_EXECUTE_DATE
, PRICING_MODEL
, MARKET_DATA_SET
, INITIAL_FAIR_VALUE
, EXCHANGE_RATE_ONE
, EXCHANGE_RATE_TWO
, FIRST_REVAL_BATCH_ID
, LAST_REVAL_BATCH_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, PROFIT_LOSS
, FX_RO_PD_RATE
, FX_M1_DEAL_NO
, EXTERNAL_DEAL_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, FORCE_MONTH_END
, QUANTITY
, REMAINING_QUANTITY
, ROUNDING_TYPE
, SETTLE_ROUNDING_TYPE
, SETTLE_DAY_COUNT_TYPE
, ORIGINAL_AMOUNT
, DAY_COUNT_TYPE
, INCOME_TAX_CODE
, INCOME_TAX_RATE
, PREPAID_INTEREST
, INCOME_TAX_AMOUNT
, INCOME_TAX_SETTLED_REF
, CPARTY_ACCOUNT_NO
, MATURE_SETTLEMENT_BASIS
, PAYMENT_SETTLEMENT_BASIS
, BUY_ACCT_USE_ID
, SELL_ACCT_USE_ID
, MATURITY_ACCT_USE_ID
, PREMIUM_ACCT_USE_ID
, SETTLE_ACCT_USE_ID
, START_ACCT_USE_ID
, CPARTY_ACCT_USE_ID
, CLIENT_ACCOUNT_NO
, CLIENT_ACCT_USE_ID
FROM XTR.XTR_DEALS;
XTR.XTR_DEALS does not reference any database object
XTR.XTR_DEALS is referenced by following:
XTR
XTR_DEALS#
|
|
|
|