[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | XTR_DEALS_INTERFACE# |
|---|---|
| Object Type: | VIEW |
| Owner: | XTR |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EXTERNAL_DEAL_ID | VARCHAR2 | (240) | Yes | |
| DEAL_TYPE | VARCHAR2 | (7) | Yes | |
| CREATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| LAST_UPDATE_DATE | DATE | |||
| LAST_UPDATED_BY | NUMBER | |||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| LOAD_STATUS_CODE | VARCHAR2 | (30) | ||
| BROKERAGE_CODE | VARCHAR2 | (7) | ||
| BROKERAGE_CURRENCY | VARCHAR2 | (15) | ||
| ACCOUNT_NO_A | VARCHAR2 | (20) | ||
| ACCOUNT_NO_B | VARCHAR2 | (80) | ||
| CLIENT_CODE | VARCHAR2 | (7) | ||
| COMMENTS | VARCHAR2 | (255) | ||
| COMPANY_CODE | VARCHAR2 | (7) | Yes | |
| CPARTY_CODE | VARCHAR2 | (7) | ||
| CPARTY_REF | VARCHAR2 | (80) | ||
| CURRENCY_A | VARCHAR2 | (15) | ||
| CURRENCY_B | VARCHAR2 | (15) | ||
| DEALER_CODE | VARCHAR2 | (10) | ||
| DEAL_LINKING_CODE | VARCHAR2 | (8) | ||
| DEAL_SUBTYPE | VARCHAR2 | (7) | ||
| EXTERNAL_COMMENTS | VARCHAR2 | (255) | ||
| EXTERNAL_CPARTY_NO | VARCHAR2 | (15) | ||
| INTERNAL_TICKET_NO | VARCHAR2 | (15) | ||
| LIMIT_CODE | VARCHAR2 | (7) | ||
| PORTFOLIO_CODE | VARCHAR2 | (7) | Yes | |
| PRODUCT_TYPE | VARCHAR2 | (10) | ||
| STATUS_CODE | VARCHAR2 | (10) | Yes | |
| AMOUNT_A | NUMBER | |||
| AMOUNT_B | NUMBER | |||
| AMOUNT_C | NUMBER | |||
| RATE_A | NUMBER | |||
| RATE_B | NUMBER | |||
| RATE_C | NUMBER | |||
| DATE_A | DATE | |||
| DATE_B | DATE | |||
| NO_OF_DAYS | NUMBER | |||
| ACTION_CODE | VARCHAR2 | (7) | ||
| AMOUNT_TYPE | VARCHAR2 | (7) | ||
| AMOUNT_HCE | NUMBER | |||
| EXPOSURE_TYPE | VARCHAR2 | (10) | ||
| SETTLE_ACTION_REQD | VARCHAR2 | (80) | ||
| BANK_CODE_FROM | VARCHAR2 | (7) | ||
| BANK_CODE_TO | VARCHAR2 | (7) | ||
| MARKET_DATA_SET | VARCHAR2 | (30) | ||
| PRICING_MODEL | VARCHAR2 | (80) | ||
| OVERRIDE_LIMIT | VARCHAR2 | (1) | ||
| DUAL_AUTHORIZATION_BY | VARCHAR2 | (30) | ||
| DUAL_AUTHORIZATION_ON | DATE | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| LIMIT_CODE_B | VARCHAR2 | (7) | ||
| MIRROR_PORTFOLIO_CODE | VARCHAR2 | (7) | ||
| MIRROR_PRODUCT_TYPE | VARCHAR2 | (10) | ||
| MIRROR_LIMIT_CODE_INVEST | VARCHAR2 | (7) | ||
| MIRROR_LIMIT_CODE_FUND | VARCHAR2 | (7) | ||
| ROUNDING_TYPE | VARCHAR2 | (80) | ||
| DAY_COUNT_TYPE | VARCHAR2 | (80) | ||
| ORIGINAL_AMOUNT | NUMBER | |||
| YEAR_CALC_TYPE | VARCHAR2 | (80) | ||
| DATE_C | DATE | |||
| BASIS_TYPE | VARCHAR2 | (80) | ||
| SECURITY_ID | VARCHAR2 | (10) | ||
| ACCEPTOR_CODE | VARCHAR2 | (7) | ||
| DRAWER_CODE | VARCHAR2 | (7) | ||
| ENDORSER_CODE | VARCHAR2 | (7) | ||
| SCHEDULE_A | VARCHAR2 | (7) | ||
| SCHEDULE_B | VARCHAR2 | (7) | ||
| OPTION_A | VARCHAR2 | (1) | ||
| MIRROR_PRICING_MODEL | VARCHAR2 | (80) | ||
| FROM_BANK_BRANCH_ID | NUMBER | (15) | ||
| TO_BANK_BRANCH_ID | NUMBER | (15) | ||
| COMPANY_ACCT_A_USE_ID | NUMBER | (15) | ||
| COMPANY_ACCT_B_USE_ID | NUMBER | (15) | ||
| CPARTY_ACCT_USE_ID | NUMBER | (15) | ||
| CPARTY_ACCOUNT_NO | VARCHAR2 | (20) | ||
| MIRROR_DEAL_LINKING_CODE | VARCHAR2 | (8) | ||
| MIRROR_DEALER_CODE | VARCHAR2 | (10) | ||
| EXTERNAL_SOURCE | VARCHAR2 | (30) | ||
| VALIDATION_FLAG | VARCHAR2 | (1) | ||
| SETTLEMENT_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT EXTERNAL_DEAL_ID
, DEAL_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LOAD_STATUS_CODE
, BROKERAGE_CODE
, BROKERAGE_CURRENCY
, ACCOUNT_NO_A
, ACCOUNT_NO_B
, CLIENT_CODE
, COMMENTS
, COMPANY_CODE
, CPARTY_CODE
, CPARTY_REF
, CURRENCY_A
, CURRENCY_B
, DEALER_CODE
, DEAL_LINKING_CODE
, DEAL_SUBTYPE
, EXTERNAL_COMMENTS
, EXTERNAL_CPARTY_NO
, INTERNAL_TICKET_NO
, LIMIT_CODE
, PORTFOLIO_CODE
, PRODUCT_TYPE
, STATUS_CODE
, AMOUNT_A
, AMOUNT_B
, AMOUNT_C
, RATE_A
, RATE_B
, RATE_C
, DATE_A
, DATE_B
, NO_OF_DAYS
, ACTION_CODE
, AMOUNT_TYPE
, AMOUNT_HCE
, EXPOSURE_TYPE
, SETTLE_ACTION_REQD
, BANK_CODE_FROM
, BANK_CODE_TO
, MARKET_DATA_SET
, PRICING_MODEL
, OVERRIDE_LIMIT
, DUAL_AUTHORIZATION_BY
, DUAL_AUTHORIZATION_ON
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, LIMIT_CODE_B
, MIRROR_PORTFOLIO_CODE
, MIRROR_PRODUCT_TYPE
, MIRROR_LIMIT_CODE_INVEST
, MIRROR_LIMIT_CODE_FUND
, ROUNDING_TYPE
, DAY_COUNT_TYPE
, ORIGINAL_AMOUNT
, YEAR_CALC_TYPE
, DATE_C
, BASIS_TYPE
, SECURITY_ID
, ACCEPTOR_CODE
, DRAWER_CODE
, ENDORSER_CODE
, SCHEDULE_A
, SCHEDULE_B
, OPTION_A
, MIRROR_PRICING_MODEL
, FROM_BANK_BRANCH_ID
, TO_BANK_BRANCH_ID
, COMPANY_ACCT_A_USE_ID
, COMPANY_ACCT_B_USE_ID
, CPARTY_ACCT_USE_ID
, CPARTY_ACCOUNT_NO
, MIRROR_DEAL_LINKING_CODE
, MIRROR_DEALER_CODE
, EXTERNAL_SOURCE
, VALIDATION_FLAG
, SETTLEMENT_FLAG
FROM XTR.XTR_DEALS_INTERFACE#;
XTR
XTR_DEALS_INTERFACE
APPS
XTR_DEALS_INTERFACE
|
|
|
|