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     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, 2023, Oracle and/or its affiliates.