[Home] [Help] [Dependency Information]
Object Name: | OKL_TXD_ASSETS_B |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_TXD_ASSETS_B |
Subobject Name: | |
Status: | VALID |
A transaction table to record various Tax book related assets attributes needed by Fixed Asset Module before activating the contract and additionaly to store the split asset transaction attributes needed by Fixed Asset Moulde before activating the contract.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_TXD_ASSETS_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ID |
OKL_TXD_ASSETS_B_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TAL_ID |
OKL_TXD_ASSETS_B_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ASSET_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
TAL_ID | NUMBER | Yes | Foreign key to table OKL_TXL_ASSETS_B | |
TARGET_KLE_ID | NUMBER | Foreign Key to table OKC_K_LINES_B.ID , will be populated as a resultant of Split Asset Process | ||
LINE_DETAIL_NUMBER | NUMBER | Sequencial line number. | ||
ASSET_NUMBER | VARCHAR2 | (15) | Yes | Asset number |
QUANTITY | NUMBER | Quanity of the assets | ||
COST | NUMBER | (15) | Cost of the asset for tax book level | |
TAX_BOOK | VARCHAR2 | (15) | Tax Book | |
LIFE_IN_MONTHS_TAX | NUMBER | (15) | Life of asset in total months for tax book level | |
DEPRN_METHOD_TAX | VARCHAR2 | (12) | Name of the depreciation method for the asset for tax book level | |
DEPRN_RATE_TAX | NUMBER | Effective depreciation rate for Flate rate methods | ||
SALVAGE_VALUE | NUMBER | (15) | Asset salvage value for tax book level | |
SPLIT_PERCENT | NUMBER | Split percent for split asset component | ||
INVENTORY_ITEM_ID | NUMBER | Invnetory item id for split asset component | ||
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 | |
CURRENCY_CODE | VARCHAR2 | (15) | Currency code | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency conversion type | |
CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion rate | ||
CURRENCY_CONVERSION_DATE | DATE | Currency conversion date |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, OBJECT_VERSION_NUMBER
, TAL_ID
, TARGET_KLE_ID
, LINE_DETAIL_NUMBER
, ASSET_NUMBER
, QUANTITY
, COST
, TAX_BOOK
, LIFE_IN_MONTHS_TAX
, DEPRN_METHOD_TAX
, DEPRN_RATE_TAX
, SALVAGE_VALUE
, SPLIT_PERCENT
, INVENTORY_ITEM_ID
, 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
, CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE
FROM OKL.OKL_TXD_ASSETS_B;
OKL.OKL_TXD_ASSETS_B does not reference any database object
OKL.OKL_TXD_ASSETS_B is referenced by following:
|
|
|