CData Python Connector for Oracle Fusion Cloud SCM

Build 25.0.9454

SupplyRequestssupplyOrderLinesmakeSupply

Tracks supply details specific to work orders, supporting manufacturing and assembly operations.

Columns

Name Type Description
SupplyRequestsSupplyOrderReferenceNumber [KEY] String Reference number for the supply request associated with the manufacturing supply order.
SupplyorderlinesSupplyLineId [KEY] Long Unique identifier for the supply order line related to manufacturing supply.
SupplyTrackingLineId [KEY] Long Tracking identifier for monitoring the manufacturing supply request.
SupplyOrderHeaderId Long Unique identifier for the supply order header associated with this manufacturing request.
SupplyLineId Long Unique identifier for the supply line within the supply order.
SupplyParentTrackingLineId Long Parent tracking line identifier used to group related supply tracking lines.
SupplyTrackingLineNumber Long Sequential tracking number assigned to the supply order line.
SupplyTrackingLineStatus String Current processing status of the supply tracking line.
SupplyType String Type of supply request (for example, Make, Transfer, Buy).
SupplyOrderReferenceLineId Long Unique identifier for the reference line in the supply order.
SupplyOrderReferenceLineNumber String Reference number for the supply order line.
ItemId Long Unique identifier for the item being manufactured.
ItemNumber String Item number for the manufactured item.
ItemDescription String Description of the manufactured item.
ItemRevision String Revision number of the item being produced.
UOMCode String Unit of measure (UOM) code for the manufacturing quantity.
UOMName String UOM name for the manufacturing quantity.
Quantity Decimal Total quantity requested for manufacturing.
DestinationOrganizationId Long Unique identifier for the destination organization receiving the manufactured item.
DestinationOrganizationCode String Code of the destination organization receiving the manufactured item.
DestinationOrganizationName String Name of the destination organization receiving the manufactured item.
SupplyFulfilledQuantity Decimal Quantity of the item that has already been fulfilled.
SupplyChangePendingFlag Bool Indicates whether there are pending changes to the supply order.
SupplyExceptionFlag Bool Indicates whether there are exceptions affecting the manufacturing supply order.
BackToBackFlag Bool Indicates whether this supply request is linked to a back-to-back order.
DeliverToSubinventory String Subinventory location where the manufactured item will be delivered.
FirmPlannedFlag Bool Indicates whether the work order is firm planned.
WorkOrderId String Unique identifier for the associated work order.
WorkOrderNumber String Number assigned to the work order for manufacturing.
AllowExplosionFlag Bool Indicates whether the supply request allows BOM explosion for component breakdown.
WorkOrderStatusId Long Unique identifier for the status of the work order.
WorkDefinitionName String Name of the work definition used for the manufacturing process.
WorkDefinitionAsOfDate Datetime Effective date of the work definition used in manufacturing.
WorkOrderSubType String Subtype of the work order (for example, standard, repair, rework).
WorkDefinitionId Long Unique identifier for the work definition.
WorkMethodCode String Manufacturing method code (for example, discrete, process).
WorkOrderType String Type of work order (for example, Discrete, Process).
SourceSystemId String Unique identifier for the system that originated the supply request.
SourceSystemType String Type of source system that initiated the supply request.
SchedulingMethod String Scheduling method used for the manufacturing work order.
WorkOrderCompletionDate Datetime Scheduled completion date for the manufacturing work order.
WorkOrderStartDate Datetime Start date of the work order execution.
WorkOrderDescription String Description of the work order process.
WIPQuantity Decimal Work-in-progress quantity for the supply request.
BindDestOrganizationCode String Binding field linking the destination organization code.
BindDocumentNumber String Binding document number referencing the supply order.
BindItemNumber String Binding field for the item number in the supply request.
BindNeedByDate Datetime Binding field for the required completion date of the supply request.
BindSupplyOrderNumber String Binding field linking the supply order number.
BindSupplyOrderReferenceNumber String Binding field linking the supply order reference number.
BindSupplyOrderSource String Binding field linking the source application of the supply request.
BindSupplyRequestDate Datetime Binding field indicating when the supply request was submitted.
BindSupplyStatus String Binding field tracking the processing status of the supply request.
BindSupplyType String Binding field specifying the type of supply request (for example, Make, Buy, Transfer).
Finder String Utility field used to search for specific supply orders in the system.
SupplyOrderReferenceNumber String Reference number for tracking the supply order and its related processes.

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