CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

ProductionResourcesEquipmentInstance

Tracks individual instances of equipment resources, supporting detailed equipment management.

Columns

Name Type Description
ProductionResourcesResourceId [KEY] Long The unique identifier that links this equipment instance to its associated production resource. This relationship allows the system to manage the connection between resources and their physical or virtual instances, ensuring traceability in production operations.
EquipmentInstanceId [KEY] Long The system-generated primary key that uniquely identifies a specific instance of an equipment resource. This primary key is used to distinguish between multiple instances of the same resource type in the production environment.
EquipmentIdentifier String A short code or abbreviation assigned to the equipment instance to simplify identification. This code is commonly used in reports or operational interfaces to quickly reference the equipment.
EquipmentInstanceName String The full name of the equipment resource instance, providing a descriptive label that helps operators and managers easily identify the instance.
AssetId Long The unique identifier for the asset associated with the equipment instance in the maintenance organization. This identifier links the equipment to the organization's asset management system for lifecycle tracking.
AssetNumber String The unique number assigned to the asset. This serves as a critical reference for tracking and managing the asset throughout its lifecycle, from acquisition to retirement.
AssetDescription String A detailed description of the asset associated with this equipment instance, outlining its purpose, specifications, or other relevant details.
AssetItemId Long The identifier for the item type associated with the asset. This identifier links the asset to its classification or category in the system, facilitating asset reporting and analysis.
AssetItemNumber String The code or number that identifies the asset item. This code is used to group similar assets or track specific items in maintenance and resource planning.
AssetItemDescription String A description of the asset item type, providing additional context about its role or usage within production or maintenance operations.
OrganizationId Long The unique identifier for the organization managing the equipment instance. This identifier enables the system to segregate resources by organization and maintain clear operational boundaries.
ResourceId Long The primary key generated by the system to uniquely identify the production resource associated with this equipment instance. This resource can represent equipment, labor, or tools.
ResourceCode String A short code or identifier assigned to the resource linked to this equipment instance. This code simplifies resource identification and integration with production systems.
PrimaryWorkCenterId Long The system-generated identifier for the primary work center where this equipment instance is primarily used. This identifier establishes the default location for resource scheduling and allocation.
PrimaryWorkCenterCode String an abbreviation or short code representing the primary work center. This code is commonly used in reports and dashboards to display the location of the resource.
InactiveDate Date The date on which this equipment instance becomes inactive and is no longer used in production. This timestamp helps manage active and retired resources within the system.
ChangedDate Date The date when the details of the equipment instance were last updated. This timestamp is critical for auditing changes and ensuring up-to-date records.
Finder String A utility field that allows users to locate or filter equipment instances in the system. Typically. this field is used in search or query functionalities.
FirstName String The first name of the person associated with this equipment instance. This field is applicable if the equipment instance is linked to a labor resource.
LaborIdentifier String The unique identifier for the labor resource associated with this equipment instance. This identifier helps track specific individuals or labor groups contributing to production.
LaborInstanceId Long The unique identifier for a specific instance of a labor resource, allowing the system to track detailed information about personnel involved in production tasks.
LastName String The last name of the person associated with this equipment instance, enabling detailed tracking of labor resources.
MiddleName String The middle name of the person associated with this equipment instance, providing full identification details for the labor resource.
PartyId Long The unique identifier for the external party or entity associated with this equipment instance. This identifier is used for integration with external business entities such as suppliers or contractors.
PersonName String The full name of the person associated with this equipment instance. This field provides a human-readable name for easier identification in personnel management.
PersonType String The classification of the person associated with this equipment instance (for example, 'Employee' or 'Contractor') for workforce planning and reporting.
ResourceType String Specifies the type of resource associated with this equipment instance (for example, 'Labor', 'Machine', or 'Tool'). This categorization helps organize and allocate resources efficiently.
WorkCenterId Long The unique identifier for the work center where the equipment instance is used. This identifier ensures accurate allocation of resources to production operations.

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