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