JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot

WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long WorkOrdersWorkOrderId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
WorkorderassemblycomponentWoOperationMaterialId [KEY] Long WorkorderassemblycomponentWoOperationMaterialId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
WoOperationMaterialLotId [KEY] Long WoOperationMaterialLotId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
WorkOrderId Long WorkOrderId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
LotNumber String Lot number of the reworked assembly.
AssociatedQuantity Double Quantity for the lot number to issue for the reworked work order.
IssuedQuantity Double IssuedQuantity of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentLot
WoOperationMaterialId Long Value that uniquely identifies the reworked assembly. It is a primary key that the application generates when it creates the item.

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