JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

OperationStartStops

OperationStartStops

Columns

Name Type Description
WoOperationStartStopId [KEY] Long Value that uniquely identifies the start and stop for the work order operation. You must make sure this attribute does not contain a value when you start the work order operation. The response will include value for this attribute. This attribute is required when you stop an operation.
OperationStartTime Datetime Date and time when the work order operation starts. You must make sure OperationStartTime does not contain a value when you stop the operation.
OperationStopTime Datetime Date and time when the work order operation stops. You must make sure OperationStopTime does not contain a value when you start the operation.
OrganizationId Long Value that uniquely identifies the inventory organization that the application enabled for manufacturing. It is a primary key that the application generates when it creates the inventory organization.
WoOperationId Long Value that uniquely identifies the work order operation. It is a primary key that the application generates when it creates the work order operation. If you provide a value for the WoOperationId attribute, then it is not necessary to provide a value for these attributes: OrganizationId, OrganizationCode, WorkOrderNumber, WorkOrderId, and OperationSequenceNumber.
WoProductSerialId Long Value that uniquely identifies the product serial in the work order. It is a primary key that the application generates when it creates the serial number. If you are performing a serialized operation, then you must provide a value for the WoProductSerialId attribute or for the SerialNumber attribute.
WorkOrderNumber String Number that identifies the work order. This number is unique in the manufacturing organization. It is a unique number from the numbering scheme defined by these plant parameters: Work Order Prefix or Work Order Starting Number.
OrganizationCode String Abbreviation that identifies the inventory organization that the application enabled for manufacturing.
SerialNumber String Serial number that the work order item references.
OperationSequenceNumber Double Sequence to use when performing the work order operations.
WorkOrderId Long Value that uniquely identifies the work order. It is a primary key that the application generates when it creates the work order.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Finder String finder

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839