CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

WorkDefinitionNames

Defines methods for manufacturing products through work definitions, enabling standardized production planning.

Columns

Name Type Description
WorkDefinitionNameId [KEY] Long The unique identifier for the work definition name record. This primary key ensures that each work definition name is uniquely identifiable for production, planning, and reporting purposes.
WorkDefinitionCode String A short code representing the work definition name. This code simplifies referencing and managing work definitions in configurations, reports, and operational workflows.
WorkDefName String The name of the work definition. This descriptive label identifies specific work definitions, enabling users to easily associate them with production processes or planning scenarios.
WorkDefNameDescription String A detailed description of the work definition name. This description provides additional context about the purpose or scope of the work definition, aiding in understanding and usability.
WorkDefinitionType String Specifies the type of work definition (for example, 'Standard,' 'Maintenance,' or 'Prototype'). This classification helps categorize work definitions based on their role in the production lifecycle.
UsedInPlanningFlag Bool Indicates whether the work definition is used in planning. If this value is 'true', the work definition is included in planning processes like capacity or material planning; otherwise, it is excluded.
EffectiveFromDate Date The date when the work definition becomes effective. This metric ensures that the work definition is applied only within its valid time range, supporting lifecycle management.
EffectiveToDate Date The date when the work definition expires or is no longer effective. This metric prevents outdated work definitions from being used in active processes.
CreatedBy String The username or identifier of the person who created the work definition record. This identifier field provides accountability and traceability for the creation process.
CreationDate Datetime The date and time when the work definition record was created. These metrics support audit trails and provides historical context.
LastUpdatedBy String The username or identifier of the person who last updated the work definition record. This identifier ensures accountability for modifications and enables tracking of changes.
LastUpdateDate Datetime The date and time when the work definition record was most recently updated. These metrics provide traceability and ensures the data reflects the most recent changes.
WorkDefinitionTypeMeaning String A user-friendly description of the work definition type. This description clarifies the purpose or role of the work definition for end-users, enhancing usability.
BindInventoryItemId Long The identifier of the inventory item associated with the work definition. This identifier ensures that the work definition is tied to the correct inventory item for production or planning.
BindOrganizationId Long The unique identifier for the organization associated with the work definition. This identifier ensures that work definitions are correctly mapped to the relevant organizational unit.
BindVersionStartDate Date The start date for the version of the work definition. This metric helps track different versions of work definitions over time, supporting version control and historical analysis.
Finder String A utility field enabling advanced search and filtering capabilities for work definition records. This field helps users efficiently locate specific work definitions based on various attributes.

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