JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

WorkOrdersWorkOrderActiveOperation

The Active Operations for Work Orders resource manages each active operation. An active operation is an operation that contains a quantity that's greater than zero.

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long WorkOrdersWorkOrderId of WorkOrdersWorkOrderActiveOperation
OrganizationId Long OrganizationId of WorkOrdersWorkOrderActiveOperation
WorkOrderId Long WorkOrderId of WorkOrdersWorkOrderActiveOperation
WorkOrderNumber String WorkOrderNumber of WorkOrdersWorkOrderActiveOperation
WorkOrderOperationId [KEY] Long WorkOrderOperationId of WorkOrdersWorkOrderActiveOperation
OperationSequenceNumber Decimal OperationSequenceNumber of WorkOrdersWorkOrderActiveOperation
OperationName String OperationName of WorkOrdersWorkOrderActiveOperation
OperationDescription String OperationDescription of WorkOrdersWorkOrderActiveOperation
OperationType String OperationType of WorkOrdersWorkOrderActiveOperation
OperationTypeDescription String OperationTypeDescription of WorkOrdersWorkOrderActiveOperation
StandardOperationId Long StandardOperationId of WorkOrdersWorkOrderActiveOperation
StandardOperationCode String StandardOperationCode of WorkOrdersWorkOrderActiveOperation
StandardOperationName String StandardOperationName of WorkOrdersWorkOrderActiveOperation
WorkAreaId Long WorkAreaId of WorkOrdersWorkOrderActiveOperation
WorkAreaCode String WorkAreaCode of WorkOrdersWorkOrderActiveOperation
WorkAreaName String WorkAreaName of WorkOrdersWorkOrderActiveOperation
WorkAreaDescription String WorkAreaDescription of WorkOrdersWorkOrderActiveOperation
WorkCenterId Long WorkCenterId of WorkOrdersWorkOrderActiveOperation
WorkCenterCode String WorkCenterCode of WorkOrdersWorkOrderActiveOperation
WorkCenterName String WorkCenterName of WorkOrdersWorkOrderActiveOperation
WorkCenterDescription String WorkCenterDescription of WorkOrdersWorkOrderActiveOperation
OSPItemId Long OSPItemId of WorkOrdersWorkOrderActiveOperation
OSPItemNumber String OSPItemNumber of WorkOrdersWorkOrderActiveOperation
OSPItemDescription String OSPItemDescription of WorkOrdersWorkOrderActiveOperation
SupplierId Long SupplierId of WorkOrdersWorkOrderActiveOperation
SupplierName String SupplierName of WorkOrdersWorkOrderActiveOperation
SupplierSiteId Long SupplierSiteId of WorkOrdersWorkOrderActiveOperation
SupplierSiteCode String SupplierSiteCode of WorkOrdersWorkOrderActiveOperation
SupplierSiteDescription String SupplierSiteDescription of WorkOrdersWorkOrderActiveOperation
FixedLeadTime Decimal FixedLeadTime of WorkOrdersWorkOrderActiveOperation
VariableLeadTime Decimal VariableLeadTime of WorkOrdersWorkOrderActiveOperation
LeadTimeUOM String LeadTimeUOM of WorkOrdersWorkOrderActiveOperation
LeadTimeUnitOfMeasure String LeadTimeUnitOfMeasure of WorkOrdersWorkOrderActiveOperation
CountPointOperationFlag Bool CountPointOperationFlag of WorkOrdersWorkOrderActiveOperation
AutoTransactFlag Bool AutoTransactFlag of WorkOrdersWorkOrderActiveOperation
ResequenceFlag Bool ResequenceFlag of WorkOrdersWorkOrderActiveOperation
ExecutionSequence Decimal ExecutionSequence of WorkOrdersWorkOrderActiveOperation
PORequestedQuantity Decimal PORequestedQuantity of WorkOrdersWorkOrderActiveOperation
POApprovedQuantity Decimal POApprovedQuantity of WorkOrdersWorkOrderActiveOperation
OverReceiptQuantity Decimal OverReceiptQuantity of WorkOrdersWorkOrderActiveOperation
InProcessQuantity Decimal InProcessQuantity of WorkOrdersWorkOrderActiveOperation
ReceivedQuantity Decimal ReceivedQuantity of WorkOrdersWorkOrderActiveOperation
ShippedQuantity Decimal ShippedQuantity of WorkOrdersWorkOrderActiveOperation
ReadyQuantity Decimal ReadyQuantity of WorkOrdersWorkOrderActiveOperation
CompletedQuantity Decimal CompletedQuantity of WorkOrdersWorkOrderActiveOperation
ScrappedQuantity Decimal ScrappedQuantity of WorkOrdersWorkOrderActiveOperation
RejectedQuantity Decimal RejectedQuantity of WorkOrdersWorkOrderActiveOperation
UnitOfMeasure String UnitOfMeasure of WorkOrdersWorkOrderActiveOperation
PlannedStartDate Datetime PlannedStartDate of WorkOrdersWorkOrderActiveOperation
PlannedCompletionDate Datetime PlannedCompletionDate of WorkOrdersWorkOrderActiveOperation
ActualStartDate Datetime ActualStartDate of WorkOrdersWorkOrderActiveOperation
ActualCompletionDate Datetime ActualCompletionDate of WorkOrdersWorkOrderActiveOperation
DelayStatus Int DelayStatus of WorkOrdersWorkOrderActiveOperation
MaterialsCount Int MaterialsCount of WorkOrdersWorkOrderActiveOperation
ResourcesCount Int ResourcesCount of WorkOrdersWorkOrderActiveOperation
SerialTrackingFlag Bool SerialTrackingFlag of WorkOrdersWorkOrderActiveOperation
ShippingDocumentsFlag Bool ShippingDocumentsFlag of WorkOrdersWorkOrderActiveOperation
CreatedBy String CreatedBy of WorkOrdersWorkOrderActiveOperation
CreationDate Datetime CreationDate of WorkOrdersWorkOrderActiveOperation
LastUpdateDate Datetime LastUpdateDate of WorkOrdersWorkOrderActiveOperation
LastUpdatedBy String LastUpdatedBy of WorkOrdersWorkOrderActiveOperation
AdditionalMaterialAtManualIssue String AdditionalMaterialAtManualIssue of WorkOrdersWorkOrderActiveOperation
OperationCompletionWithOpenExceptions String OperationCompletionWithOpenExceptions of WorkOrdersWorkOrderActiveOperation
OperationCompletionWithUnderIssue String OperationCompletionWithUnderIssue of WorkOrdersWorkOrderActiveOperation
BackToBackFlag String BackToBackFlag of WorkOrdersWorkOrderActiveOperation
ContractMfgFlag String ContractMfgFlag of WorkOrdersWorkOrderActiveOperation
DueDays Int DueDays of WorkOrdersWorkOrderActiveOperation
Finder String Finder of WorkOrdersWorkOrderActiveOperation
FirmPlannedFlag String FirmPlannedFlag of WorkOrdersWorkOrderActiveOperation
InventoryItemId Long InventoryItemId of WorkOrdersWorkOrderActiveOperation
ItemNumber String ItemNumber of WorkOrdersWorkOrderActiveOperation
MaterialItemId Long MaterialItemId of WorkOrdersWorkOrderActiveOperation
ProductSerialId Long ProductSerialId of WorkOrdersWorkOrderActiveOperation
ResourceId Long ResourceId of WorkOrdersWorkOrderActiveOperation
SerialNumber String SerialNumber of WorkOrdersWorkOrderActiveOperation
SourceHeaderReferenceId Long SourceHeaderReferenceId of WorkOrdersWorkOrderActiveOperation
SourceHeaderRefId Long SourceHeaderRefId of WorkOrdersWorkOrderActiveOperation
SourceLineReferenceId Long SourceLineReferenceId of WorkOrdersWorkOrderActiveOperation
SourceLineRefId Long SourceLineRefId of WorkOrdersWorkOrderActiveOperation
SourceSystemId Long SourceSystemId of WorkOrdersWorkOrderActiveOperation
Tolerance Int Tolerance of WorkOrdersWorkOrderActiveOperation
WoProjectNumber String WoProjectNumber of WorkOrdersWorkOrderActiveOperation
WorkOrderStatusId Long WorkOrderStatusId of WorkOrdersWorkOrderActiveOperation
WoTaskNumber String WoTaskNumber of WorkOrdersWorkOrderActiveOperation

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