# DW_CXSR_INSTALLED_BASE_ASSETS_D_TL

## Details

Module: Service Request Management

## Key Columns

ASSET_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ASSET_ID | NUMBER | 38 | 0 | True | Category |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. System |  |
ASSET_NUMBER | VARCHAR2 | 128 |  |  | Asset Number |  |
SERIAL_NUMBER | VARCHAR2 | 128 |  |  | Serial Number |  |
DESCRIPTION | VARCHAR2 | 256 |  |  | Asset Description |  |
ACTIVE_END_DATE | TIMESTAMP |  |  |  | Active end date |  |
CREATED_BY | VARCHAR2 | 64 |  |  | Indicates the user who created the asset |  |
CREATION_DATE | TIMESTAMP |  |  |  | Indicates the date and time of the creation of the row. |  |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 |  |  | indicates the session login associated to the user who last updated the row. |  |
LAST_UPDATED_BY | VARCHAR2 | 64 |  |  | Indicates the user who last updated the asset |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Indicates the date and time of the last update of the row. |  |
CURRENT_LOCATION_CONTEXT | VARCHAR2 | 128 |  |  | Current location context code |  |
CUSTOMER_ASSET_START_DATE | TIMESTAMP |  |  |  | Customer Asset start date |  |
CUSTOMER_ASSET_END_DATE | TIMESTAMP |  |  |  | Customer Asset end date |  |
CUSTOMER_ID | NUMBER | 38 | 0 |  | Unique Customer id |  |
PURCHASE_DATE | DATE |  |  |  | Date of purchase of asset |  |
IN_SERVICE_DATE | DATE |  |  |  | in service date |  |
INSTALLED_DATE | DATE |  |  |  | Installation date of asset |  |
ITEM_ID | NUMBER | 38 | 0 |  | Product id |  |
ITEM_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Stores the Business Unit Org Id of the category. | DW_INTERNAL_ORG_D_TL | ORGANIZATION_ID
LANGUAGE | VARCHAR2 | 16 |  |  | Language |  |
MAINTAINABLE_FLAG | VARCHAR2 | 16 |  |  | maintainable flag |  |
ORIGINATION_DATE | TIMESTAMP |  |  |  | origination date |  |
LOT_NUMBER | VARCHAR2 | 128 |  |  | lot number of asset |  |
ITEM_REVISION | VARCHAR2 | 32 |  |  | item revision |  |
REGISTERED_FLAG | VARCHAR2 | 16 |  |  | registered flag |  |
SHIPMENT_DATE | DATE |  |  |  | shipment date of asset |  |
SOURCE_LANGUAGE | VARCHAR2 | 16 |  |  | Source Language |  |
UOM_CODE | VARCHAR2 | 16 |  |  | Lookup code that indicates the unit of measure |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.