JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9060

WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial

The Serials for Assemblies resource manages serial that the application issued for the assembly that the rework work order uses.

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.
BackToBackFlag String BackToBackFlag of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
ContractMfgFlag String ContractMfgFlag of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
DueDays Int DueDays of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
Finder String Finder of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
FirmPlannedFlag String FirmPlannedFlag of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
ItemNumber String ItemNumber of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
LastUpdateDate Datetime LastUpdateDate of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
MaterialItemId Long MaterialItemId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
PlannedCompletionDate Datetime PlannedCompletionDate of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
PlannedStartDate Datetime PlannedStartDate of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
ProductSerialId Long ProductSerialId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
ResourceId Long ResourceId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
SourceHeaderReferenceId Long SourceHeaderReferenceId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
SourceHeaderRefId Long SourceHeaderRefId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
SourceLineReferenceId Long SourceLineReferenceId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
SourceLineRefId Long SourceLineRefId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
SourceSystemId Long SourceSystemId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
Tolerance Int Tolerance of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
WoProjectNumber String WoProjectNumber of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
WorkAreaId Long WorkAreaId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
WorkCenterId Long WorkCenterId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
WorkOrderNumber String WorkOrderNumber of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
WorkOrderStatusId Long WorkOrderStatusId of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial
WoTaskNumber String WoTaskNumber of WorkOrdersWorkOrderAssemblyComponentWorkOrderAssemblyComponentSerial

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