[Home] [Help] [Dependency Information]
Object Name: | XTR_DEALER_LIMITS |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_DEALER_LIMITS |
Subobject Name: | |
Status: | VALID |
XTR_DEALER_LIMITS contains information about the limits a dealer has when making deals. Dealer limits can be applied to a deal type or to a product type. The unique key for this table consists of dealer, deal type, and product type. This table has no primary key because the product type can be null.
This table corresponds to the Dealer Limits tabbed region of the Limits window.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_DEALER_LIMITS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
DEALER_CODE
DEAL_TYPE PRODUCT_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUDIT_INDICATOR | VARCHAR2 | (1) | Not currently used | |
AUTHORISED | VARCHAR2 | (1) | Flag to indicatethat indicates if the limit is authorized (Y), or not (N) | |
CREATED_BY | VARCHAR2 | (30) | User who created this record | |
CREATED_ON | DATE | Date this record was created | ||
DEALER_CODE | VARCHAR2 | (10) | Yes | Code for Treasury users |
DEAL_TYPE | VARCHAR2 | (7) | Yes | Code for high level deals |
LIMIT_AMOUNT | NUMBER | Yes | Not currently used | |
PRODUCT_TYPE | VARCHAR2 | (10) | Code for products used in a deal type | |
SINGLE_DEAL_LIMIT_AMOUNT | NUMBER | Yes | Maximum amount a dealer is allowed for each deal for a deal type, product type combination | |
UPDATED_ON | DATE | Date this record was last updated | ||
UTILISED_AMOUNT | NUMBER | Total amount that deal transactions have applied to the limit | ||
UPDATED_BY | VARCHAR2 | (30) | User who last updated this record |
Cut, paste (and edit) the following text to query this object:
SELECT AUDIT_INDICATOR
, AUTHORISED
, CREATED_BY
, CREATED_ON
, DEALER_CODE
, DEAL_TYPE
, LIMIT_AMOUNT
, PRODUCT_TYPE
, SINGLE_DEAL_LIMIT_AMOUNT
, UPDATED_ON
, UTILISED_AMOUNT
, UPDATED_BY
FROM XTR.XTR_DEALER_LIMITS;
XTR.XTR_DEALER_LIMITS does not reference any database object
XTR.XTR_DEALER_LIMITS is referenced by following:
|
|
|