[Home] [Help] [Dependency Information]
Object Name: | XTR_DEAL_SUBTYPES |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_DEAL_SUBTYPES |
Subobject Name: | |
Status: | VALID |
XTR_DEAL_SUBTYPES contains deal subtypes information. Each row in this table corresponds to a deal type, deal subtype combination and the tolerance level for that combination. The deal type must exist in the XTR_DEAL_TYPES table. Each deal transaction must be associated with a deal subtype that belongs to the deal type of your deal transaction.
This table corresponds to the Deal Subtypes tabbed region in the Deal Types/Product Types window.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_DEAL_SUBTYPES_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
DEAL_TYPE
DEAL_SUBTYPE ZD_EDITION_NAME |
XTR_DEAL_SUBTYPES_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
DEAL_TYPE
USER_DEAL_SUBTYPE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUTHORISED | VARCHAR2 | (1) | Flag to indicate if the deal subtype is authorized for use (Y), or not (N) | |
DEAL_SUBTYPE | VARCHAR2 | (7) | Yes | Code for deal executions permissible within a deal type |
USER_DEAL_SUBTYPE | VARCHAR2 | (7) | Yes | User-defined deal subtype code |
DEAL_TYPE | VARCHAR2 | (7) | Yes | Code for high level deals |
LIMIT_WEIGHTING | NUMBER | Percentage of a deal's face value considered as risk | ||
NAME | VARCHAR2 | (80) | Yes | Deal subtype name |
PRICE_ROUNDING | NUMBER | Not currently used | ||
TOLERANCE | NUMBER | Tolerence level (as a percentage) | ||
YIELD_ROUNDING | NUMBER | Not currently used | ||
SEEDED_DESCRIPTION | VARCHAR2 | (80) | Yes | Pre-defined deal subtype description |
UPDATED_BY | VARCHAR2 | (30) | User who last updated this record | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT AUTHORISED
, DEAL_SUBTYPE
, USER_DEAL_SUBTYPE
, DEAL_TYPE
, LIMIT_WEIGHTING
, NAME
, PRICE_ROUNDING
, TOLERANCE
, YIELD_ROUNDING
, SEEDED_DESCRIPTION
, UPDATED_BY
, ZD_EDITION_NAME
FROM XTR.XTR_DEAL_SUBTYPES;
XTR.XTR_DEAL_SUBTYPES does not reference any database object
XTR.XTR_DEAL_SUBTYPES is referenced by following:
|
|
|