[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#;
|
|
|