# DW_FA_DISTRIBUTION_HISTORY_D

This is the Dimension table for Fixed asset Distribution History details

## Details

Module: Assets

## Key Columns

DISTRIBUTION_ID, BOOK_TYPE_CODE

## Columns

Columns
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 |  |  | This column is for Oracle Internal use only. 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_EFFECTIVE_1 | DATE |  |  |  | Date when the row became effective. |  |
DATE_INEFFECTIVE | TIMESTAMP |  |  |  | Date when the row became effective. |  |
DATE_INEFFECTIVE_1 | DATE |  |  |  | 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, 2025, Oracle and/or its affiliates.