Power BI Connector for Oracle Fusion Cloud SCM

Build 25.0.9454

ProductionResourcesEquipmentInstanceEquipmentInstanceDFF

Customizes tracking for equipment instances with descriptive flexfields, enabling detailed equipment insights.

Columns

Name Type Description
ProductionResourcesResourceId [KEY] Long The unique identifier linking this equipment instance to the parent production resource. This identifier enables traceability of equipment usage within the production environment and supporting resource planning and management.
EquipmentinstanceEquipmentInstanceId [KEY] Long The system-generated primary key uniquely identifying an individual instance of equipment within the schema. This primary key ensures differentiation between multiple equipment instances of the same type.
EquipmentInstanceId [KEY] Long The unique identifier for the equipment resource instance. This primary key is used to manage individual equipment resources in operations, tracking, and reporting.
_FLEX_Context String The descriptive flexfield (DFF) context name that provides additional metadata about the equipment instance, enabling the system to support customer-specific configurations and extendability.
_FLEX_Context_DisplayValue String A user-friendly display value for the descriptive flexfield context that allows end-users to interpret the additional context-specific attributes of the equipment instance.
AssetItemId Long The unique identifier for the specific item type associated with the asset in the organization's asset management system. This identifier ties equipment to its asset category or classification for better asset tracking and reporting.
AssetItemNumber String The short code or number that identifies the asset item linked to the equipment instance, simplifying reference in operations and asset records.
AssetNumber String The unique number assigned to the asset that represents this equipment instance. This number facilitates detailed tracking, management, and audit of the equipment lifecycle.
ChangedDate Date The date on which the details of the equipment instance were last modified. This metric ensures that users can track recent updates and maintain accurate records for audits or troubleshooting.
EquipmentIdentifier String A concise abbreviation or identifier assigned to the equipment resource instance, enabling users to quickly locate and reference it within the system or in operational reports.
Finder String A utility field used for advanced search or filtering capabilities in the system to locate specific equipment instances based on various attributes.
FirstName String The first name of the person associated with the equipment instance. Typically, this name is used when linking equipment to a labor resource or an individual responsible for its operation or maintenance.
LaborIdentifier String A unique code or identifier representing a labor resource connected to this equipment instance. This identifier tracks personnel responsible for equipment operation or production tasks.
LaborInstanceId Long A unique identifier for a specific instance of a labor resource tied to this equipment instance. This identifier ensures detailed traceability of human resources in production processes.
LastName String The last name of the individual linked to the equipment instance. This name adds full identification details for labor resource tracking.
MiddleName String The middle name of the person associated with the equipment instance. This name provides additional context for uniquely identifying the individual.
OrganizationId Long A unique identifier for the organization managing this equipment instance. This identifier allows the system to segment and report on resources at an organizational level.
PartyId Long A unique identifier for an external party (for example, 'supplier' or 'contractor') associated with this equipment instance, supporting integration with external stakeholders or third-party resources.
PersonName String The full name of the individual linked to this equipment instance. This name is particularly useful for tracking labor resources assigned to or responsible for the equipment.
PersonType String Specifies the classification of the individual associated with the equipment instance (for example, 'Employee,' 'Contractor,' or 'Supervisor'), aiding in personnel categorization and workforce planning.
PrimaryWorkCenterCode String The short code or abbreviation for the primary work center where this equipment instance is typically used. This code simplifies resource allocation and operational planning.
PrimaryWorkCenterId Long The system-generated unique identifier for the primary work center assigned to this equipment instance. This identifier ensures that the equipment is linked to its default operational location.
ResourceId Long The unique identifier for the parent production resource associated with this equipment instance. This identifier enables traceability and effective management of the resource hierarchy.
ResourceType String Specifies the type of resource this equipment instance represents (for example, 'labor,' 'equipment,' or 'tool'). This classification aids in resource categorization and operational decision-making.
WorkCenterId Long The unique identifier for the work center where the equipment instance is actively used. This identifier supports efficient resource allocation and reporting across work centers.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454