JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber

WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long WorkOrdersWorkOrderId of WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber
WorkorderoperationWorkOrderOperationId [KEY] Long WorkorderoperationWorkOrderOperationId of WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber
OrganizationId Long OrganizationId of WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber
WorkOrderProductSerialId [KEY] Long WorkOrderProductSerialId of WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber
WorkOrderId Long WorkOrderId of WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber
WorkOrderOperationMaterialId Long WorkOrderOperationMaterialId of WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber
WorkOrderOperationId Long WorkOrderOperationId of WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber
OperationSequenceNumber Double OperationSequenceNumber of WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber
OperationName String OperationName of WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber
StandardOperationId Long StandardOperationId of WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber
StandardOperationCode String StandardOperationCode of WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber
WorkAreaId Long WorkAreaId of WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber
WorkAreaName String WorkAreaName of WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber
WorkCenterId Long WorkCenterId of WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber
WorkCenterName String WorkCenterName of WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber
InventoryItemId Long InventoryItemId of WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber
SerialNumber String SerialNumber of WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber
SerialStatus String SerialStatus of WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber
SerialStatusDescription String SerialStatusDescription of WorkOrdersWorkOrderOperationWorkOrderOperationSerialNumber

Pseudo-Columns

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

Name Type Description
BackToBackFlag String BackToBackFlag
ContractMfgFlag String ContractMfgFlag
DueDays Int DueDays
FirmPlannedFlag String FirmPlannedFlag
ItemNumber String ItemNumber
LastUpdateDate Datetime LastUpdateDate
MaterialItemId Long MaterialItemId
PlannedCompletionDate Datetime PlannedCompletionDate
PlannedStartDate Datetime PlannedStartDate
ProductSerialId Long ProductSerialId
ResourceId Long ResourceId
SourceHeaderRefId Long SourceHeaderRefId
SourceHeaderReferenceId Long SourceHeaderReferenceId
SourceLineRefId Long SourceLineRefId
SourceLineReferenceId Long SourceLineReferenceId
SourceSystemId Long SourceSystemId
Tolerance Int Tolerance
WoProjectNumber String WoProjectNumber
WoTaskNumber String WoTaskNumber
WorkOrderNumber String WorkOrderNumber
WorkOrderStatusId Long WorkOrderStatusId
Finder String finder

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