CData Python Connector for Oracle Fusion Cloud SCM

Build 24.0.9175

ProcessWorkOrdersProcessWorkOrderReservation

Manages demand documents to reserve output quantities for work orders, optimizing inventory allocation.

Columns

Name Type Description
ProcessWorkOrdersWorkOrderId [KEY] Long The unique identifier linking the process work order to its reservation details, allowing tracking of material reservations for production.
OrganizationId Long The unique identifier for the organization where the reservation is created, representing a specific manufacturing plant or warehouse.
InventoryItemId Long The unique identifier for the inventory item associated with the reservation. This identifier tracks the reserved material in the inventory system.
CustomerName String The name of the customer for whom the reservation is made. This name helps in linking the reservation to specific customer orders.
DemandSourceHeaderNumber String The number assigned to the demand source header, such as a sales order or forecast, associated with the reservation.
DemandSourceLineNumber String The line number of the demand source that specifies the particular item or quantity reserved.
DemandSourceTypeName String Specifies the type of demand source associated with the reservation (for example, 'Sales Order,' 'Forecast,' or 'Requisition').
DueDate Date The date when the reserved material is required for production or fulfillment. This metric helps in planning and scheduling.
ReservationId [KEY] Long The unique identifier for the reservation record. This identifier tracks the specific reservation instance within the system.
ReservationQuantity Decimal The quantity of material reserved for the work order or demand source. This value Ensures accurate allocation of inventory.
ReservationUnitOfMeasure String The unit of measure for the reserved quantity (for example, 'Each,' 'Kilogram,' or 'Box'). This measure provides clarity on the reservation size.
SupplySourceHeaderId Long The unique identifier for the supply source header associated with the reservation (for example, a purchase order or transfer order).
BackToBackFlag String Indicates whether the reservation is part of a back-to-back process, where the supply is directly linked to specific customer demand.
ContractMfgFlag String Indicates whether the reservation is associated with contract manufacturing, where production tasks are outsourced to external suppliers.
DueDays Int The number of days remaining until the reserved material is required for production or fulfillment.
Finder String Represents the search mechanism or criteria used to locate specific reservation records within the system.
FirmPlannedFlag String Indicates whether the reservation is firm planned, preventing changes to the allocation by planning or scheduling tools.
ItemNumber String The unique number assigned to the inventory item associated with the reservation. This number aids in identifying and tracking reserved materials.
LastUpdateDate Datetime The date and time when the reservation record was last updated, providing an audit trail for modifications.
MaterialItemId Long The unique identifier for the material item associated with the reservation, allowing detailed tracking of reserved materials.
PlannedCompletionDate Datetime The planned date and time for completing the work order associated with the reservation. These metrics help in aligning reservations with production schedules.
PlannedStartDate Datetime The planned date and time for starting the work order or operation linked to the reservation.
ProductSerialId Long The unique identifier for the product serial number associated with the reservation. This identifier facilitates serialized tracking of reserved materials.
ResourceId Long The unique identifier for the resource associated with the reservation (for example, equipment or personnel). This identifier links reserved materials to specific resources.
SerialNumber String The serial number of the reserved material or product, enabling precise tracking and traceability for serialized items.
SourceHeaderReferenceId Long The unique identifier for the source header linking the reservation to its originating transaction, such as a sales order or production request.
SourceHeaderRefId Long An alternate unique identifier for the source header associated with the reservation, providing additional linkage to its origin.
SourceLineReferenceId Long The unique identifier for the source line linking the reservation to a specific line item in the originating document.
SourceLineRefId Long An alternate unique identifier for the source line reference associated with the reservation, offering additional traceability.
SourceSystemId Long The unique identifier for the source system that provided the data related to the reservation. This identifier is useful for tracking integrations with external systems.
Tolerance Int The allowable tolerance level for the reservation, such as acceptable variances in reserved quantity or timing.
WoProjectNumber String The project number associated with the work order reservation. This number links the reservation to project-specific tasks or deliverables.
WorkAreaId Long The unique identifier for the work area where the reserved material is used. This identifier organizes reservations by production zones.
WorkCenterId Long The unique identifier for the work center where the reserved material is consumed. This identifier tracks reservations at specific locations.
WorkOrderId Long The unique identifier for the work order associated with the reservation. This identifier links the reservation to the broader production process.
WorkOrderNumber String The unique number assigned to the work order associated with the reservation. This number helps in tracking reservations within the context of broader production workflows.
WorkOrderStatusId Long The unique identifier for the current status of the work order associated with the reservation. This identifier indicates whether the work order is 'Open,' 'In Progress,' or 'Completed.'
WoTaskNumber String The task number within the work order associated with the reservation. This attribute enables task-level tracking and management of reserved materials for specific production steps.

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