[Home] [Help] [Dependency Information]
Object Name: | JA_AU_CAPITAL_VALUE |
---|---|
Object Type: | TABLE |
Owner: | JA |
FND Design Data: | JA.JA_AU_CAPITAL_VALUE |
Subobject Name: | |
Status: | VALID |
JA_AU_CAPITAL_VALUE is used to store capital gains tax information.
The Asset Details function is used to create and update data
within this table. The Australian Assets Capital Gains Tax report uses
data within this table to calculate capital gains and losses for an asset.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JA_AU_CAPITAL_VALUE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
BOOK_TYPE_CODE
ASSET_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BOOK_TYPE_CODE | VARCHAR2 | (15) | Yes | Book name |
ASSET_ID | NUMBER | (15) | Yes | Asset identifier |
DEEMED_VALUE | NUMBER | Optional deemed value of the asset | ||
DEEMED_DATE | DATE | Optional deemed date of the asset | ||
INCIDENTAL_COSTS | NUMBER | Optional incidental costs applied to the asset | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment column | |
ATTRIBUTE_CATEGORY_CODE | VARCHAR2 | (30) | Descriptive Flexfield structure defining column |
Cut, paste (and edit) the following text to query this object:
SELECT BOOK_TYPE_CODE
, ASSET_ID
, DEEMED_VALUE
, DEEMED_DATE
, INCIDENTAL_COSTS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY_CODE
FROM JA.JA_AU_CAPITAL_VALUE;
JA.JA_AU_CAPITAL_VALUE does not reference any database object
JA.JA_AU_CAPITAL_VALUE is referenced by following:
|
|
|