Module: Service Request Management
ASSET_ID
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.