ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

ProductionResourcesResourceDFF

Enables detailed customization of production resource tracking through descriptive flexfields.

Columns

Name Type Description
ProductionResourcesResourceId [KEY] Long The unique identifier linking this descriptive flexfield (DFF) record to the associated production resource. This identifier enables the system to capture and manage custom attributes specific to a resource, enhancing flexibility for organizational needs.
ResourceId [KEY] Long The system-generated primary key that uniquely identifies a production resource. The flexfield functionality allows organizations to add context-specific data without programming, making it adaptable to unique operational requirements.
_FLEX_Context String The name of the descriptive flexfield (DFF) context associated with the resource. This field allows customization by defining categories or scenarios where specific attributes are relevant.
_FLEX_Context_DisplayValue String A user-friendly display value for the descriptive flexfield context. This value makes it easier for users to interpret the custom data linked to a production resource.
AssetItemId Long The unique identifier for the asset item associated with the resource. This identifier enables integration with asset management systems for tracking, costing, and maintenance purposes.
AssetItemNumber String The short code or identifier representing the asset item linked to the resource. This code helps users quickly reference assets in reports, operational planning, or maintenance schedules.
AssetNumber String The unique number assigned to the asset related to the production resource. This number ensuring precise tracking of physical or virtual assets within the system.
ChangedDate Date The date when updates were last made to the resource's descriptive flexfield attributes. This metric is critical for maintaining an audit trail and ensuring that the latest resource information is accessible.
EquipmentIdentifier String The short code or identifier for the equipment associated with this resource. This code allows users to link a resource to specific tools or machines used in production.
EquipmentInstanceId Long The unique identifier for a specific instance of equipment associated with this resource. This identifier supports detailed tracking and management of resource-equipment relationships.
Finder String A utility field used for advanced search or filtering of descriptive flexfield records associated with production resources. This field improves user efficiency by simplifying record retrieval.
FirstName String The first name of the person associated with this production resource, where applicable. This name is useful for labor-related resources or for identifying individual operators.
LaborIdentifier String The short code or identifier for the labor resource associated with this production resource. This code helps in categorizing and managing workforce resources linked to specific operations.
LaborInstanceId Long The unique identifier for a specific instance of a labor resource connected to this production resource. This identifier supports detailed tracking of workforce involvement in production processes.
LastName String The last name of the individual linked to the production resource. This name aids in workforce management and tracking personnel tied to resource usage.
MiddleName String The middle name of the individual associated with the resource. This name ensures precise identification of personnel, especially in cases where names are similar.
OrganizationId Long The unique identifier for the organization managing this production resource. This identifier allows segmentation and reporting of resources by organizational units or divisions.
PartyId Long The foreign key linking this production resource to a party in Oracle Trading Community Architecture. This key facilitates integration with external entities like contractors, suppliers, or employees.
PersonName String The full name of the person associated with this resource. This name simplifies personnel tracking and ensures resources are clearly linked to their respective operators or managers.
PersonType String Specifies the classification of the person associated with this resource (for example, 'Employee,' 'Contractor,' or 'Supervisor'). This classification supports effective workforce planning and reporting.
PrimaryWorkCenterCode String The short code or abbreviation representing the primary work center where this resource is primarily used. This code is often displayed in dashboards and reports for operational clarity.
PrimaryWorkCenterId Long The unique identifier for the primary work center assigned to this resource. This identifier ensures accurate resource allocation and helps with scheduling and planning of production operations.
ResourceType String Indicates the type of the production resource (for example, 'Labor,' 'Equipment,' or 'Material') This categorization helps in managing and allocating resources effectively based on their role in production.
WorkCenterId Long The unique identifier for the work center where this resource is used. This identifier supports resource tracking, planning, and reporting across multiple production units.

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