JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

WorkOrdersWorkOrderDFF

WorkOrdersWorkOrderDFF

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long WorkOrdersWorkOrderId of WorkOrdersWorkOrderDFF
WorkOrderId [KEY] Long Value that uniquely identifies the work order. It is a primary key that the application generates when it creates the work order.
_FLEX_Context String Descriptive flexfield context name for work orders.
_FLEX_Context_DisplayValue String Descriptive flexfield context display value for work orders.

Pseudo-Columns

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

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

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