[Home] [Help] [Dependency Information]
Object Name: | AR_CMGT_COLLATERAL_DATA |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.AR_CMGT_COLLATERAL_DATA |
Subobject Name: | |
Status: | VALID |
The AR_CMGT_COLLATERAL_DATA table stores detailed information about assets that can be pledged to secure credit available by the company under credit review pledged to secure credit. Common types of collateral include real estate, stock and bonds, and equipment. In the event that the company fails to meet its financial obligations, collateral can be seized to reduce the debt.
The primary key for this table is DATAPOINT_IDID and CREDIT_REQUEST_ID.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AR_CMGT_COLLATERAL_DATA_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | DATAPOINT_ID |
AR_CMGT_COLLATERAL_DATA_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CREDIT_REQUEST_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATAPOINT_ID | NUMBER | (15) | Yes | Unique data point identifier for collateral information used in displaying the value of the data in the case folder. |
CREDIT_REQUEST_ID | NUMBER | (15) | Yes | Identifier of the credit request for which Ccollateral information is reported for the company under credit review. |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
COLLATERAL_DESCRIPTION | VARCHAR2 | (100) | Description of the collateral provided for securing funding for the company under credit review. | |
COLLATERAL_CATEGORY | VARCHAR2 | (30) | Yes | Category of the collateral for the company under credit review. |
COLLATERAL_VALUE | NUMBER | Value of the collateral for the company under credit review. | ||
COLLATERAL_CURRENCY | VARCHAR2 | (30) | Currency of the collateral value. | |
VALUATION_TYPE | VARCHAR2 | (30) | Type of appraisal conducted to determine the collateral value. | |
VALUATION_DATE | DATE | Date of the collateral appraisal. | ||
PREV_VALUATION_DATE | DATE | Date of the previous collateral appraisal. | ||
APPRAISER_NAME | VARCHAR2 | (50) | Name of the person who conducted the collateral appraisal. | |
APPRAISER_PHONE_NUMBER | VARCHAR2 | (20) | Phone number of the person who conducted the appraisal of the collateral. | |
COLLATERAL_LOCATION | VARCHAR2 | (50) | Physical location of the collateral, e.g.,such as bank vault. | |
CASE_FOLDER_ID | NUMBER | (15) | Case folder identifier for Collateral information used in displaying the value of the data in the case folder. | |
NOTES | VARCHAR2 | (2000) | Free- form text area to provide additional information about the collateral available for secured funding for the company under credit review. |
Cut, paste (and edit) the following text to query this object:
SELECT DATAPOINT_ID
, CREDIT_REQUEST_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, COLLATERAL_DESCRIPTION
, COLLATERAL_CATEGORY
, COLLATERAL_VALUE
, COLLATERAL_CURRENCY
, VALUATION_TYPE
, VALUATION_DATE
, PREV_VALUATION_DATE
, APPRAISER_NAME
, APPRAISER_PHONE_NUMBER
, COLLATERAL_LOCATION
, CASE_FOLDER_ID
, NOTES
FROM AR.AR_CMGT_COLLATERAL_DATA;
AR.AR_CMGT_COLLATERAL_DATA does not reference any database object
AR.AR_CMGT_COLLATERAL_DATA is referenced by following:
|
|
|