[Home] [Help] [Dependency Information]
Object Name: | XTR_DEALS_INTERFACE |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_DEALS_INTERFACE |
Subobject Name: | |
Status: | VALID |
It is a temporary staging area for deal data awaiting for transfer to the actual deal tables.
Scope: public
Product: XTR
Lifecycle: active
Display Name: Treasury Deal Data Import Interface
Category: BUSINESS_ENTITY XTR_DEAL_DATA
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_DEALS_INTERFACE_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE |
DEAL_TYPE
EXTERNAL_DEAL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXTERNAL_DEAL_ID | VARCHAR2 | (240) | Yes | This stores the external unique primary identifier for each deal. |
DEAL_TYPE | VARCHAR2 | (7) | Yes | Code to identify a deal or instrument type. |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO column |
CREATION_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATE_DATE | DATE | Standard WHO column | ||
LAST_UPDATED_BY | NUMBER | Standard WHO column | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column | |
LOAD_STATUS_CODE | VARCHAR2 | (30) | Flag that denotes the transfer status of the deal in this record. 'NEW' or null = New deal. 'UPDATED' = Updated Deal. 'ERROR' = Error deal. 'SUBMIT' = Submitted Deal. 'DEAL_TYPE_ERROR' = for non-supported deal type for transfer 'DUPLICATE_DEAL_ID' = for duplicate import deals. | |
BROKERAGE_CODE | VARCHAR2 | (7) | Brokerage code. | |
BROKERAGE_CURRENCY | VARCHAR2 | (15) | Currency code of brokerage amount. | |
ACCOUNT_NO_A | VARCHAR2 | (20) | First account number. | |
ACCOUNT_NO_B | VARCHAR2 | (80) | Second account number. | |
CLIENT_CODE | VARCHAR2 | (7) | Client code. | |
COMMENTS | VARCHAR2 | (255) | Internal comments. | |
COMPANY_CODE | VARCHAR2 | (7) | Yes | Company code. |
CPARTY_CODE | VARCHAR2 | (7) | Counterparty code. This column is also used to store THIRDPARTY_CODE for EXP deals. | |
CPARTY_REF | VARCHAR2 | (80) | Counterparty account reference code. | |
CURRENCY_A | VARCHAR2 | (15) | First currency. | |
CURRENCY_B | VARCHAR2 | (15) | Second currency. | |
DEALER_CODE | VARCHAR2 | (10) | Code for Treasury users. | |
DEAL_LINKING_CODE | VARCHAR2 | (8) | Code to identify the group of linked deals. | |
DEAL_SUBTYPE | VARCHAR2 | (7) | Code to sub-categorize deals within each deal type. | |
EXTERNAL_COMMENTS | VARCHAR2 | (255) | External comments. | |
EXTERNAL_CPARTY_NO | VARCHAR2 | (15) | External reference. | |
INTERNAL_TICKET_NO | VARCHAR2 | (15) | Internal reference. | |
LIMIT_CODE | VARCHAR2 | (7) | Code for user-defined limits imposed on deals and transactions. | |
PORTFOLIO_CODE | VARCHAR2 | (7) | Yes | Code for grouping deals under a single portfolio. |
PRODUCT_TYPE | VARCHAR2 | (10) | Code for products used in a deal type. | |
STATUS_CODE | VARCHAR2 | (10) | Yes | Code for the execution status of deals and transactions. |
AMOUNT_A | NUMBER | First amount. | ||
AMOUNT_B | NUMBER | Second amount. | ||
AMOUNT_C | NUMBER | Third amount. | ||
RATE_A | NUMBER | First rate. | ||
RATE_B | NUMBER | Second rate. | ||
RATE_C | NUMBER | Third rate. | ||
DATE_A | DATE | First date. | ||
DATE_B | DATE | Second date. | ||
NO_OF_DAYS | NUMBER | Number of days used to calculate interest. | ||
ACTION_CODE | VARCHAR2 | (7) | Amount action. | |
AMOUNT_TYPE | VARCHAR2 | (7) | Amount type. | |
AMOUNT_HCE | NUMBER | Reporting currency amount. | ||
EXPOSURE_TYPE | VARCHAR2 | (10) | Exposure type. | |
SETTLE_ACTION_REQD | VARCHAR2 | (80) | Flag that indicates whether Treasury to settle the transaction. | |
BANK_CODE_FROM | VARCHAR2 | (7) | Stores the origin bank code. | |
BANK_CODE_TO | VARCHAR2 | (7) | Stores the destination bank code. | |
MARKET_DATA_SET | VARCHAR2 | (30) | Market Data Set. | |
PRICING_MODEL | VARCHAR2 | (80) | Pricing Model. | |
OVERRIDE_LIMIT | VARCHAR2 | (1) | Override Limit Flag 'Y' or NULL = override, 'N' = do not override limit, limit is flagged as error. | |
DUAL_AUTHORIZATION_BY | VARCHAR2 | (30) | Validator. | |
DUAL_AUTHORIZATION_ON | DATE | Date of deal validation. | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Category for Descriptive Flexfields. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Flexfield. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Flexfield. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Flexfield. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Flexfield. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Flexfield. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Flexfield. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Flexfield. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Flexfield. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Flexfield. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Flexfield. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Flexfield. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Flexfield. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Flexfield. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Flexfield. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Flexfield. | |
LIMIT_CODE_B | VARCHAR2 | (7) | The user-defined invest limit types assigned to the deals and transactions. | |
MIRROR_PORTFOLIO_CODE | VARCHAR2 | (7) | Portfolio code for the mirror transaction. | |
MIRROR_PRODUCT_TYPE | VARCHAR2 | (10) | Product type for the mirror transaction. | |
MIRROR_LIMIT_CODE_INVEST | VARCHAR2 | (7) | Investment limit code for the mirror | |
MIRROR_LIMIT_CODE_FUND | VARCHAR2 | (7) | Funding limit code for the mirror. | |
ROUNDING_TYPE | VARCHAR2 | (80) | Not currently used | |
DAY_COUNT_TYPE | VARCHAR2 | (80) | Not currently used | |
ORIGINAL_AMOUNT | NUMBER | Not currently used | ||
YEAR_CALC_TYPE | VARCHAR2 | (80) | Field for year calculation type. See documentation for more details | |
DATE_C | DATE | Generic field for holding dates. See documentation for field field mappings for each deal type | ||
BASIS_TYPE | VARCHAR2 | (80) | Field for holding calculation basis. See documentation for more details | |
SECURITY_ID | VARCHAR2 | (10) | Field for holding security id. See documentation for more details | |
ACCEPTOR_CODE | VARCHAR2 | (7) | Field for holding risk party acceptor code. See documentation for more details | |
DRAWER_CODE | VARCHAR2 | (7) | Field for holding risk party drawer code. See documentation for more details | |
ENDORSER_CODE | VARCHAR2 | (7) | Field for holding risk party endorser code. See documentation for more details | |
SCHEDULE_A | VARCHAR2 | (7) | Generic field for holding schedule codes. See documentation for field mappings for each deal type | |
SCHEDULE_B | VARCHAR2 | (7) | Generic field for holding schedule codes. See documentation for field mappings for each deal type | |
OPTION_A | VARCHAR2 | (1) | Generic field for holding options. See documentation for field mappings for each deal type | |
MIRROR_PRICING_MODEL | VARCHAR2 | (80) | Mirror pricing model | |
FROM_BANK_BRANCH_ID | NUMBER | (15) | Stores the origin bank ID. | |
TO_BANK_BRANCH_ID | NUMBER | (15) | Stores the destination bank ID. | |
COMPANY_ACCT_A_USE_ID | NUMBER | (15) | First account ID | |
COMPANY_ACCT_B_USE_ID | NUMBER | (15) | Second account ID | |
CPARTY_ACCT_USE_ID | NUMBER | (15) | Counterparty account ID | |
CPARTY_ACCOUNT_NO | VARCHAR2 | (20) | Counterparty bank account number | |
MIRROR_DEAL_LINKING_CODE | VARCHAR2 | (8) | Code to identify the group of linked deals | |
MIRROR_DEALER_CODE | VARCHAR2 | (10) | Code for Treasury users | |
EXTERNAL_SOURCE | VARCHAR2 | (30) | The source of the transactions | |
VALIDATION_FLAG | VARCHAR2 | (1) | Flag for validation | |
SETTLEMENT_FLAG | VARCHAR2 | (1) | Flag for settlement |
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 does not reference any database object
XTR.XTR_DEALS_INTERFACE is referenced by following:
|
|
|