JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial

WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long WorkOrdersWorkOrderId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
WorkorderassemblycomponentWoOperationMaterialId [KEY] Long WorkorderassemblycomponentWoOperationMaterialId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
WoOperationMaterialSerialId [KEY] Long WoOperationMaterialSerialId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
OrganizationId Long OrganizationId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
WorkOrderId Long WorkOrderId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
WoOperationMaterialId Long Value that uniquely identifies the reworked assembly. It is a primary key that the application generates when it creates the item.
WoOperationMaterialLotId Long WoOperationMaterialLotId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
LotNumber String Lot number of the reworked assembly.
InventoryItemId Long InventoryItemId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
SerialNumber String Serial number that identifies the reworked assembly.

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
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