[Home] [Help] [Dependency Information]
Object Name: | XTR_DEALS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | XTR.XTR_DEALS_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
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 | ||
BOND_SALE_DATE | DATE | Date a bond deal is sold | ||
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 | |
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 | |
QUANTITY | NUMBER | Not currently used | ||
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 | |
REMAINING_QUANTITY | NUMBER | Not currently used | ||
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 | ||
INCOME_TAX_CODE | VARCHAR2 | (7) | Not currently used | |
INCOME_TAX_RATE | NUMBER | Not currently used | ||
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 | ||
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. | |
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 | ||
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 | |
KNOCK_EXECUTE_DATE | DATE | The effective date on which the knock is executed | ||
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. | ||
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. | |
ROUNDING_TYPE | VARCHAR2 | (1) | Not currently used | |
DAY_COUNT_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 | ||
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 | |
CLIENT_ACCOUNT_NO | VARCHAR2 | (20) | Client 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. |
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
, BOND_SALE_DATE
, BROKER
, BROKERAGE_AMOUNT
, BROKERAGE_AMOUNT_HCE
, BROKERAGE_CODE
, 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
, QUANTITY
, QUICK_INPUT
, RATE_BASIS
, REF_CCY
, REMAINING_QUANTITY
, 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
, INCOME_TAX_CODE
, INCOME_TAX_RATE
, 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
, PRICING_MODEL
, MARKET_DATA_SET
, INITIAL_FAIR_VALUE
, EXCHANGE_RATE_ONE
, EXCHANGE_RATE_TWO
, FIRST_REVAL_BATCH_ID
, LAST_REVAL_BATCH_ID
, EXTERNAL_DEAL_ID
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, KNOCK_EXECUTE_DATE
, PROFIT_LOSS
, FX_RO_PD_RATE
, FX_M1_DEAL_NO
, FORCE_MONTH_END
, ROUNDING_TYPE
, DAY_COUNT_TYPE
, SETTLE_ROUNDING_TYPE
, SETTLE_DAY_COUNT_TYPE
, ORIGINAL_AMOUNT
, PREPAID_INTEREST
, INCOME_TAX_AMOUNT
, INCOME_TAX_SETTLED_REF
, CPARTY_ACCOUNT_NO
, CLIENT_ACCOUNT_NO
, MATURE_SETTLEMENT_BASIS
, PAYMENT_SETTLEMENT_BASIS
FROM APPS.XTR_DEALS_V;
|
|
|