[Home] [Help]
[Dependency Information]
Object Name: | XTR_GROUP_LIMITS |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
XTR_GROUP_LIMITS contains group limit information. Each row corresponds to a limit placed on a company against a counterparty group for a limit type. Currently, three limit types are derived from the FX_INVEST_FUND_TYPE column in the XTR_LIMIT_TYPES table: F or fund, I or invest and X or foreign exchange, are derived from the. The fourth limit type is XI, or foreign exchange and invest.
This table corresponds to the Group Limits tabbed region in the Limits window.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUDIT_INDICATOR | VARCHAR2 | (1) | Not currently used | |
AUTHORISED | VARCHAR2 | (1) | Flag to indicate if the limit is authorized (Y), or not (N) | |
COMPANY_CODE | VARCHAR2 | (7) | Yes | Company code |
CPARTY_CODE | VARCHAR2 | (7) | Yes | Counterparty code |
CREATED_BY | VARCHAR2 | (30) | Yes | User who created this record |
CREATED_ON | DATE | Yes | Date this record was created | |
EXPIRY_DATE | DATE | Expiration date for the limit | ||
LIMIT_AMOUNT | NUMBER | Maximum amount allowed by the limit | ||
LIMIT_TYPE | VARCHAR2 | (2) | Yes | Limit categories to which the group limit belongs (F, I, X or XI) |
UPDATED_BY | VARCHAR2 | (30) | User who last updated this record | |
UPDATED_ON | DATE | Date this record was last updated | ||
UTILISED_AMOUNT | NUMBER | Total amount that deal transactions have applied to the limit |
Cut, paste (and edit) the following text to query this object:
SELECT AUDIT_INDICATOR
, AUTHORISED
, COMPANY_CODE
, CPARTY_CODE
, CREATED_BY
, CREATED_ON
, EXPIRY_DATE
, LIMIT_AMOUNT
, LIMIT_TYPE
, UPDATED_BY
, UPDATED_ON
, UTILISED_AMOUNT
FROM XTR.XTR_GROUP_LIMITS;
XTR.XTR_GROUP_LIMITS does not reference any database object
XTR.XTR_GROUP_LIMITS is referenced by following:
|
|
|