DW_CXSR_INSTALLED_BASE_ASSETS_D_TL
Details
Module: Service Request Management
Key Columns
ASSET_ID
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 |