This is the Dimension table for Fixed asset Distribution History details
Module: Assets
BOOK_TYPE_CODE, DISTRIBUTION_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
BOOK_TYPE_CODE | VARCHAR2 | 32 | True | Unique book identification name. | |||
DISTRIBUTION_ID | NUMBER | 38 | 0 | True | Identifier of the asset distribution. | ||
SOURCE_RECORD_ID | VARCHAR2 | 128 | Source record identifier. Value is derived from a combination of Asset Distribution identifier. | ||||
TRANSACTION_HEADER_ID_IN | NUMBER | 38 | 0 | Identifier of the transaction that created the row. | |||
TRANSACTION_HEADER_ID_OUT | NUMBER | 38 | 0 | Identifier of the transaction that terminated the row. | |||
DATE_EFFECTIVE | TIMESTAMP | Date when the row became effective. | |||||
DATE_INEFFECTIVE | TIMESTAMP | Date when the row became effective. | |||||
ASSET_ID | NUMBER | 38 | 0 | Identifier of the asset number. | |||
LOCATION_ID | NUMBER | 38 | 0 | Location flexfield identification number. | |||
ASSIGNED_TO_ID | NUMBER | 38 | 0 | Identifier of the employee to whom the asset is assigned. | |||
DEPRN_EXPENSE_CCID | NUMBER | 38 | 0 | Identifier of the account code combination for the depreciation expense account. | |||
INVENTORY_DATE_TAKEN | DATE | User-defined inventory taken date. | |||||
UNITS_ASSIGNED | NUMBER | Number of units assigned to the distribution. | |||||
TRANSACTION_UNITS | NUMBER | Number of units involved in the transaction. Negative value for the row from which the units were transferred away or retired. Positive value for the row to which the units were transferred to or added. | |||||
RETIREMENT_ID | NUMBER | 38 | 0 | Identifier of the asset retirement transaction. | |||
CREATION_DATE | TIMESTAMP | Creation Date |
Copyright © 2019, 2023, Oracle and/or its affiliates.