[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKL_CONTRACT_ASSET_H |
|---|---|
| Object Type: | TABLE |
| Owner: | OKL |
| FND Design Data: |  OKL.OKL_CONTRACT_ASSET_H
|
| Subobject Name: | |
| Status: | VALID |
History table for recording attributes of Fixed Asset module when a contract is versioned.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ID | NUMBER | Yes | Primary key column | |
| MAJOR_VERSION | NUMBER | (4) | Yes | Major version |
| OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
| DNZ_CHR_ID | NUMBER | Yes | Contract ID | |
| FA_CLE_ID | NUMBER | Yes | Contract line ID having Fixed Asset line style | |
| NAME | VARCHAR2 | (15) | Column used for locking records during updates | |
| DESCRIPTION | VARCHAR2 | (80) | User entered description | |
| ASSET_ID | NUMBER | (15) | System generated asset identification number generated by fixed asset module | |
| ASSET_NUMBER | VARCHAR2 | (15) | Asset number | |
| CORPORATE_BOOK | VARCHAR2 | (15) | Book name | |
| LIFE_IN_MONTHS | NUMBER | (4) | Life of asset in total months | |
| ORIGINAL_COST | NUMBER | Original cost of the asset | ||
| COST | NUMBER | Current cost of asset | ||
| ADJUSTED_COST | NUMBER | Recoverable cost less depreciation reserve. Reset when you perform an amortizedadjustment or revaluation | ||
| CURRENT_UNITS | NUMBER | Current number of units for the asset | ||
| NEW_USED | VARCHAR2 | (4) | Indicates whether asset is new or used | |
| IN_SERVICE_DATE | DATE | Date the asset was placed in service | ||
| MODEL_NUMBER | VARCHAR2 | (40) | Model Number of asset | |
| ASSET_TYPE | VARCHAR2 | (11) | Indicates whether the asset is CIP, capitalized, or expensed | |
| SALVAGE_VALUE | NUMBER | Asset salvage value | ||
| PERCENT_SALVAGE_VALUE | NUMBER | Salvage value percentage amount | ||
| DEPRECIATION_CATEGORY | NUMBER | (15) | Identifies category to which the asset belongs | |
| DEPRN_METHOD_CODE | VARCHAR2 | (12) | Name of the depreciation method for the asset | |
| DEPRN_START_DATE | DATE | Date the asset started to depreciate | ||
| RATE_ADJUSTMENT_FACTOR | NUMBER | Percent of remaining depreciation after a revaluation or an amortized change, or 1 | ||
| BASIC_RATE | NUMBER | Base rate used to calculate depreciation amount for flat-rate methods | ||
| ADJUSTED_RATE | NUMBER | Actual rate used to calculate depreciation for flat-rate methods | ||
| START_DATE_ACTIVE | DATE | Date which the row became effective | ||
| END_DATE_ACTIVE | DATE | Date which the row became ineffective | ||
| STATUS | VARCHAR2 | (1) | Status | |
| PRIMARY_UOM_CODE | VARCHAR2 | (50) | Primary UOM code , not used | |
| RECOVERABLE_COST | NUMBER | Cost minus salvage value, or depreciation ceiling, whichever is lower | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column | |
| ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column | |
| ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column |
| CREATION_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
| ASSET_KEY_ID | NUMBER | Asset key code combination identifier | ||
| LEGAL_ENTITY_ID | NUMBER | Stores the Legal Entity Id. Foreign Key to XLE_ENTITY_PROFILES |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, MAJOR_VERSION
, OBJECT_VERSION_NUMBER
, DNZ_CHR_ID
, FA_CLE_ID
, NAME
, DESCRIPTION
, ASSET_ID
, ASSET_NUMBER
, CORPORATE_BOOK
, LIFE_IN_MONTHS
, ORIGINAL_COST
, COST
, ADJUSTED_COST
, CURRENT_UNITS
, NEW_USED
, IN_SERVICE_DATE
, MODEL_NUMBER
, ASSET_TYPE
, SALVAGE_VALUE
, PERCENT_SALVAGE_VALUE
, DEPRECIATION_CATEGORY
, DEPRN_METHOD_CODE
, DEPRN_START_DATE
, RATE_ADJUSTMENT_FACTOR
, BASIC_RATE
, ADJUSTED_RATE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, STATUS
, PRIMARY_UOM_CODE
, RECOVERABLE_COST
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ASSET_KEY_ID
, LEGAL_ENTITY_ID
FROM OKL.OKL_CONTRACT_ASSET_H;
OKL.OKL_CONTRACT_ASSET_H does not reference any database object
OKL.OKL_CONTRACT_ASSET_H is referenced by following:
OKL
OKL_CONTRACT_ASSET_H#
|
|
|
|