1. Tables and Views for SCM
  2. MNT_ASSETS_EXT

MNT_ASSETS_EXT

Entity that holds all the physical attributes of the operational assets that are staged to be exported to the IoT machine learning data lake.

Details

  • Schema: FUSION

  • Object owner: MNT

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

MNT_ASSETS_EXT_PK

DATA_ROW_ID

Columns

Name Datatype Length Precision Not-null Comments
DATA_ROW_ID NUMBER 18 Yes The primary key column. Auto generated.
RUN_ID NUMBER 18 Yes Data gathered for a specific run will have this foreign key reference to the MNT_LEARNING_RUNS table.
ASSET_ID NUMBER 18 Unique identifier and Primary Key for the asset. System Generated using the Fusion Global Unique ID generator
ASSET_OVN NUMBER 9 Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
ASSET_NUMBER VARCHAR2 80 An user identifier for the asset object. This is the user primary key for the asset. If user does not enter a value then it is system generated using the Asset Document Number Sequence.
ASSET_TAG VARCHAR2 240 Asset Tag. This is an additional way of identifying the asset.
ITEM_ID NUMBER 18 Product/Item reference as defined in the Fusion Item Master.
ITEM_NUMBER VARCHAR2 300 User identifier of the item/product.
ITEM_ORGANIZATION_ID NUMBER 18 The organization id where this product instance is instantiated. This is usually the context organization when done from the workarea landing page. However transactional instantians will inherit the organization context of the transaction.
ITEM_ORGANIZATION_CODE VARCHAR2 18 The organization code of the operating organization that is associated to the asset.
ITEM_REVISION VARCHAR2 18 The current revision of the product. As captured from the latest transaction.
SERIAL_NUMBER VARCHAR2 80 The Serial Number of the product. Which uniquely identifies the product instance that is either manufactured as an end assembly product or as components bought from the supplier.
LOT_NUMBER VARCHAR2 80 The unique lot number at the product instance level that tracks the batch of assemblies that are manufactured or procured from supplier.
QUANTITY NUMBER Product Instance Quantity. It is always 1 for the serialized product instance. For the lot, it is the lot quantity at the tracked location.
UOM_CODE VARCHAR2 3 The primary unit of measure that tracks the product instance quantity.
STATUS_CODE VARCHAR2 30 The status of the Asset. Product instance when tracked in the Inventory or WIP location may not have a status to be tracked.
ACTIVE_END_DATE TIMESTAMP The date when the asset is terminated.
IOT_ENABLED_FLAG VARCHAR2 1 This flag indicates whether the asset is enabled to be synced to the IOT application. IOT enabled assets will be automatically synced to the IOT application when the SCM cloud env is wired to the native Oracle Asset Monitoring IOT app.
CURRENT_LOCATION_CONTEXT VARCHAR2 80 The current location context. This identifies the asset being located in the work center, inventory, wip job or in a customer location.
CURRENT_LOCATION_ID NUMBER 18 Current Location Identifier. The address location identifier.
LOCATION_ORGANIZATION_ID NUMBER 18 The organization id where the asset is located now. This works in conjunction with the other location columns like the work_center_id and the subinventory and locator.
SUBINVENTORY_CODE VARCHAR2 30 Subinventory Identifier. The inventory warehouse location.
INVENTORY_LOCATOR_ID NUMBER 18 The inventory item locator identifier.
WORK_ORDER_ID NUMBER 18 Work Order Reference when the component is issues to the work order.
WORK_ORDER_NUMBER VARCHAR2 120 Represents the user-facing identifier of the work order.
WORK_ORDER_OPERATION_ID NUMBER 18 Work Order Operation Identifier.
WO_OPERATION_SEQ_NUMBER NUMBER Indicates the execution sequence of the operation.
WO_OPERATION_NAME VARCHAR2 120 Indicates the name of the work definition operation.
WORK_CENTER_ID NUMBER 18 Work Center Identifier. The foreign key to the work center entity.
WORK_CENTER_CODE VARCHAR2 30 A code that represents the user key to the work center.
WORK_CENTER_NAME VARCHAR2 120 This field represents the name of the work center.
EXTERNAL_LOCATION VARCHAR2 240 An external location which is defined in the third party system and is not a defined location either in TCA or HR fusion system is captured in this column. A free format non translatable value is captured.
SALES_ORDER_SOURCE_SYSTEM_TYPE VARCHAR2 30 The type of the source sales order system.
SALES_ORDER_SOURCE_SYSTEM VARCHAR2 30 The source sales order system from which the order is captured.
SALES_ORDER_NUMBER VARCHAR2 120 The user key to the sales order business object
SALES_ORDER_ID NUMBER 18 Sales Order Identifier. Foreign key to the FOM Sales Order Entity.
SALES_ORDER_LINE_NUMBER VARCHAR2 120 The user key to the sales order lines entity.
SALES_ORDER_LINE_ID NUMBER 18 Sales Order Line Identifier. Foreign key to the FOM Sales Order Lines entity.
INSTALLED_LOCATION_CONTEXT VARCHAR2 80 The installed location context. The type of location where the asset is installed.
INSTALLED_LOCATION_ID NUMBER 18 Installed Location Identifier. Foreign key to either the hr location or hz location.
SHIPMENT_DATE DATE Date when the asset is shipped to the customer.
INSTALLED_DATE DATE Installation Date. Date when the equipment/asset is installed.
IN_SERVICE_DATE DATE Date when the asset is placed in service.
PURCHASE_DATE DATE Procurement Date. Date when the asset is procured from the Supplier.
ORIGINATION_DATE TIMESTAMP The original creation date of the Lot Number or Serial Number.
SOLD_BY_BUSINESS_UNIT_ID NUMBER 18 Sold By Business Unit Identifier
REGISTERED_FLAG VARCHAR2 1 Flag to indicate if the customer asset is registered or not.
REGISTRATION_DATE DATE Date when the asset is registered as a customer asset.
CUSTOMER_ASSET_START_DATE TIMESTAMP The date when the customer asset was instantiated. Either during the creation of the asset when the item was set to track customer assets only or updated to the customer asset when the item is enabled for lifecycle tracking.
CUSTOMER_ASSET_END_DATE TIMESTAMP The date when the asset is no longer a customer asset. Either during the return of the asset back to the enterprise for good or when manually terminated from being a customer asset.
CUSTOMER_ID NUMBER 18 Customer Identifier. This is the sold to party id for which the asset is sold to. Sales order issue inventory transaction populates this value by reading this from the shipping details table.
CUSTOMER_SITE_PARTY_ID NUMBER 18 The ship to party identifier captured at ths shiment transaction.
CUSTOMER_SITE_ID NUMBER 18 Customer Site Identifier. This is the ship to party site id of the customer that bought the customer asset.
CUSTOMER_BILLING_PARTY_ID NUMBER 18 The billing party that bought the asset.
CUSTOMER_BILLING_PARTY_SITE_ID NUMBER 18 The billing party site identifier. This is used in the derivation of the bill to location and there by the address of the billing party.
CUSTOMER_ACCOUNT_ID NUMBER 18 The billing customer account identifier.
CUSTOMER_ACCOUNT_SITE_ID NUMBER 18 The customer account site identifier.
CUSTOMER_ACCOUNT_SITE_USE_ID NUMBER 18 The identifier of the bill to account site use.
SUPPLIER_ID NUMBER 18 Supplier Identifier. The supplier from whom the asset was purchased.
SUPPLIER_SITE_ID NUMBER 18 Supplier Site Identifier. The primary key of the supplier site.
NEW_WO_ALLOWED_FLAG VARCHAR2 1 This flag denotes whether the asset is maintainable or not. When the asset is not maintainable (New WO Allowed Flag = 'N'), a new work order cannot be created for the asset.
DFLT_WO_TYPE VARCHAR2 30 The work order type captured at the asset for the purpose of defaulting in the work order when created.
DFLT_WO_SUB_TYPE VARCHAR2 30 The work order sub type captured at the asset for the purpose of defaulting in the work order when created.
MAINTAINABLE_FLAG VARCHAR2 1 Flag indicating whether the asset is used to drive maintenance management functions.
LOGICAL_FLAG VARCHAR2 1 Flag to indicate if this asset is for the purpose of logically grouping the tangible or software assets underneath the option class or model to project a sales view of the asset tree. More specifically to present the "As Sold" view.
ASSET_CREATION_DATE TIMESTAMP Indicates the date and time of the creation of the Asset.
ASSET_LAST_UPDATE_DATE TIMESTAMP Indicates the date and time of the last update of the Asset.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.

Indexes

Index Uniqueness Tablespace Columns
MNT_ASSETS_EXT_U1 Unique Default DATA_ROW_ID