[Home] [Help] [Dependency Information]
Object Name: | XTR_COUNTERPARTY_LIMITS |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_COUNTERPARTY_LIMITS |
Subobject Name: | |
Status: | VALID |
XTR_COUNTERPARTY_LIMITS contains information regarding the limits a company has with its counterparties. Each row corresponds to a counterparty limit for a company. The company and limit code in each row are derived from XTR_COMPANY_LIMITS, with the exception of settlement limits. The limit code for settlement limits is always SETTLE.
This table corresponds to the Counterparty Limits and Settlement Limits tabbed regions in the Limits window.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_COUNTERPARTY_LIMITS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LIMIT_CODE
CPARTY_CODE COMPANY_CODE |
XTR_COUNTERPARTY_LIMITS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CPARTY_CODE
COMPANY_CODE LIMIT_CODE LIMIT_AMOUNT |
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) | |
BENCHMARK_REF | VARCHAR2 | (20) | Not currently used | |
COMMITMENT_FEE_PERCENT | NUMBER | Not currently used | ||
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 | |
CROSS_ALLOCATION_GROUP_CODE | VARCHAR2 | (15) | Not currently used | |
EXPIRY_DATE | DATE | Expiration date for the limit | ||
FREQUENCY | NUMBER | Not currently used | ||
INITIAL_FEE_DATE | DATE | Not currently used | ||
LIMIT_AMOUNT | NUMBER | Maximum amount allowed by the limit | ||
LIMIT_CODE | VARCHAR2 | (7) | Yes | Code for user-defined limits imposed on deals and transactions |
LIMIT_TYPE | VARCHAR2 | (2) | Limit type code (tied to one of four limit categories) | |
SEQUENCE_NUMBER | NUMBER | Not currently used | ||
UPDATED_BY | VARCHAR2 | (30) | User who last updated this record | |
UPDATED_ON | DATE | Date this record was last updated | ||
UTILISATION_CALC_BASIS | VARCHAR2 | (1) | Not currently used | |
UTILISATION_FEE_PERCENT | NUMBER | Not currently used | ||
UTILISED_AMOUNT | NUMBER | Total amount that deal transactions have applied to the limit | ||
UTILIZATION_STRUCTURE_BASIS | VARCHAR2 | (1) | Not currently used | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Contains descriptive flexfield context value | |
ATTRIBUTE1 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE2 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE3 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE4 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE5 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE6 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE7 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE8 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE9 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE10 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE11 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE12 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE13 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE14 | VARCHAR2 | (256) | Descriptive flexfield segment column | |
ATTRIBUTE15 | VARCHAR2 | (256) | Descriptive flexfield segment column |
Cut, paste (and edit) the following text to query this object:
SELECT AUDIT_INDICATOR
, AUTHORISED
, BENCHMARK_REF
, COMMITMENT_FEE_PERCENT
, COMPANY_CODE
, CPARTY_CODE
, CREATED_BY
, CREATED_ON
, CROSS_ALLOCATION_GROUP_CODE
, EXPIRY_DATE
, FREQUENCY
, INITIAL_FEE_DATE
, LIMIT_AMOUNT
, LIMIT_CODE
, LIMIT_TYPE
, SEQUENCE_NUMBER
, UPDATED_BY
, UPDATED_ON
, UTILISATION_CALC_BASIS
, UTILISATION_FEE_PERCENT
, UTILISED_AMOUNT
, UTILIZATION_STRUCTURE_BASIS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM XTR.XTR_COUNTERPARTY_LIMITS;
XTR.XTR_COUNTERPARTY_LIMITS does not reference any database object
XTR.XTR_COUNTERPARTY_LIMITS is referenced by following:
|
|
|