ODBC Driver for Oracle Fusion Cloud SCM

Build 25.0.9434

WorkCenters

Manages work centers within work areas, tracking resources and capacities for efficient production planning.

Columns

Name Type Description
OrganizationId Long The unique identifier for the inventory organization managing the work center. This identifier is a primary key generated by the application to ensure that work centers are correctly linked to the appropriate organizational unit, supporting multi-organization environments.
OrganizationCode String A short code or abbreviation representing the inventory organization. This code is used for quick identification and reference in reports, dashboards, and system interfaces.
OrganizationName String The full name of the inventory organization associated with the work center. This descriptive name provides clarity for users managing or analyzing work centers across multiple organizations.
WorkCenterId [KEY] Long The system-generated unique identifier for the work center. This identifier is primary key ensures each work center is distinctly identifiable for production scheduling, resource allocation, and reporting.
WorkCenterCode String A short code or abbreviation assigned to the work center. This code simplifies referencing work centers in system configurations, schedules, and operational reports.
WorkCenterName String The name of the work center, providing a user-friendly label that helps identify the specific production or operational area it represents.
WorkCenterDescription String A detailed description of the work center, explaining its purpose, capabilities, or role in the production process. This description helps users understand how the work center fits into the overall operational workflow.
InactiveDate Date The date when the work center becomes inactive. This value is used for lifecycle management to ensure inactive work centers are excluded from active production schedules and resource planning.
WorkAreaId Long The unique identifier linking the work center to its associated work area. This connection helps organize and align work centers within specific operational zones or production lines.
WorkAreaCode String The code or abbreviation representing the work area to which the work center belongs. This code ensures consistency and clarity when managing work center relationships.
WorkAreaName String The full name of the work area linked to the work center. This name provides additional context for users navigating the hierarchical structure of work areas and work centers.
WorkAreaDescription String A detailed description of the work area associated with the work center. This description helps users understand the broader operational context in which the work center operates.
OverrideScheduleFlag Bool Indicates whether the work center has one or more override calendars. If the value is 'true', the work center follows a custom schedule instead of the default work area or organizational calendar, allowing for specialized operations or unique shifts.
ChangedDate Date The date when changes were last made to the work center's configuration or attributes. This value provides an audit trail and ensures that updates are tracked for reporting and troubleshooting.
Finder String A utility field that supports advanced search and filtering of work center records. This field helps users efficiently locate specific work centers based on various attributes.
ResourceId Long The unique identifier for the resource associated with the work center. This linkage ensures that resources such as machines, tools, or personnel are correctly allocated to the work center for production processes.
SubinventoryName String The name of the subinventory associated with the work center. This name identifies the inventory location where materials or components are stored for use within the work center, supporting inventory and production integration.

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