JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9060

WorkOrdersWorkOrderSerialNumber

The Work Order Serials resource manages serial numbers that identify the assemblies that the work order references.

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long WorkOrdersWorkOrderId of WorkOrdersWorkOrderSerialNumber
OrganizationId Long OrganizationId of WorkOrdersWorkOrderSerialNumber
WorkOrderProductSerialId [KEY] Long WorkOrderProductSerialId of WorkOrdersWorkOrderSerialNumber
WorkOrderId Long Value that uniquely identifies the work order that this serial number references. It is a primary key that the application generates when it creates the work order.
WorkOrderOperationMaterialId Long WorkOrderOperationMaterialId of WorkOrdersWorkOrderSerialNumber
WorkOrderOperationId Long WorkOrderOperationId of WorkOrdersWorkOrderSerialNumber
OperationSequenceNumber Decimal OperationSequenceNumber of WorkOrdersWorkOrderSerialNumber
OperationName String OperationName of WorkOrdersWorkOrderSerialNumber
StandardOperationId Long StandardOperationId of WorkOrdersWorkOrderSerialNumber
StandardOperationCode String StandardOperationCode of WorkOrdersWorkOrderSerialNumber
WorkAreaId Long WorkAreaId of WorkOrdersWorkOrderSerialNumber
WorkAreaName String WorkAreaName of WorkOrdersWorkOrderSerialNumber
WorkCenterId Long WorkCenterId of WorkOrdersWorkOrderSerialNumber
WorkCenterName String WorkCenterName of WorkOrdersWorkOrderSerialNumber
InventoryItemId Long InventoryItemId of WorkOrdersWorkOrderSerialNumber
SerialNumber String Serial number that the work order product references.
SerialStatus String SerialStatus of WorkOrdersWorkOrderSerialNumber
SerialStatusDescription String SerialStatusDescription of WorkOrdersWorkOrderSerialNumber
BackToBackFlag String BackToBackFlag of WorkOrdersWorkOrderSerialNumber
ContractMfgFlag String ContractMfgFlag of WorkOrdersWorkOrderSerialNumber
DueDays Int DueDays of WorkOrdersWorkOrderSerialNumber
Finder String Finder of WorkOrdersWorkOrderSerialNumber
FirmPlannedFlag String FirmPlannedFlag of WorkOrdersWorkOrderSerialNumber
ItemNumber String ItemNumber of WorkOrdersWorkOrderSerialNumber
LastUpdateDate Datetime LastUpdateDate of WorkOrdersWorkOrderSerialNumber
MaterialItemId Long MaterialItemId of WorkOrdersWorkOrderSerialNumber
PlannedCompletionDate Datetime PlannedCompletionDate of WorkOrdersWorkOrderSerialNumber
PlannedStartDate Datetime PlannedStartDate of WorkOrdersWorkOrderSerialNumber
ProductSerialId Long ProductSerialId of WorkOrdersWorkOrderSerialNumber
ResourceId Long ResourceId of WorkOrdersWorkOrderSerialNumber
SourceHeaderReferenceId Long SourceHeaderReferenceId of WorkOrdersWorkOrderSerialNumber
SourceHeaderRefId Long SourceHeaderRefId of WorkOrdersWorkOrderSerialNumber
SourceLineReferenceId Long SourceLineReferenceId of WorkOrdersWorkOrderSerialNumber
SourceLineRefId Long SourceLineRefId of WorkOrdersWorkOrderSerialNumber
SourceSystemId Long SourceSystemId of WorkOrdersWorkOrderSerialNumber
Tolerance Int Tolerance of WorkOrdersWorkOrderSerialNumber
WoProjectNumber String WoProjectNumber of WorkOrdersWorkOrderSerialNumber
WorkOrderNumber String WorkOrderNumber of WorkOrdersWorkOrderSerialNumber
WorkOrderStatusId Long WorkOrderStatusId of WorkOrdersWorkOrderSerialNumber
WoTaskNumber String WoTaskNumber of WorkOrdersWorkOrderSerialNumber

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