Tableau Connector for Oracle Fusion Cloud SCM

Build 24.0.9060

WorkOrdersWorkOrderOperation

The Work Order Operations resource manages the operations that the application performs to process the work order.

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long WorkOrdersWorkOrderId of WorkOrdersWorkOrderOperation
OrganizationId Long OrganizationId of WorkOrdersWorkOrderOperation
WorkOrderId Long Value that uniquely identifies the work order. It is a primary key that the application generates when it creates the work order.
WorkOrderNumber String WorkOrderNumber of WorkOrdersWorkOrderOperation
WorkOrderOperationId [KEY] Long WorkOrderOperationId of WorkOrdersWorkOrderOperation
OperationSequenceNumber Decimal Sequence to use when performing the work order operations.
OperationName String Name of the operation.
OperationDescription String Description of the operation.
OperationType String Type of operation. It includes one of the following values. IN_HOUSE: the organization that owns the work order performs the operation. SUPPLIER: a supplier performs the operation.
OperationTypeDescription String OperationTypeDescription of WorkOrdersWorkOrderOperation
StandardOperationId Long Value that uniquely identifies the standard operation that the work order references. It is a primary key that the application generates when it creates the standard operation.
StandardOperationCode String Abbreviation that identifies the standard operation.
StandardOperationName String StandardOperationName of WorkOrdersWorkOrderOperation
WorkAreaId Long WorkAreaId of WorkOrdersWorkOrderOperation
WorkAreaCode String WorkAreaCode of WorkOrdersWorkOrderOperation
WorkAreaName String WorkAreaName of WorkOrdersWorkOrderOperation
WorkAreaDescription String WorkAreaDescription of WorkOrdersWorkOrderOperation
WorkCenterId Long Value that uniquely identifies the work center. It is a primary key that the application generates when it creates the work center.
WorkCenterCode String Abbreviation that identifies the work center.
WorkCenterName String WorkCenterName of WorkOrdersWorkOrderOperation
WorkCenterDescription String WorkCenterDescription of WorkOrdersWorkOrderOperation
OSPItemId Long Value that uniquely identifies outside processing (OSP) item. It is a primary key that the application generates when it creates an item.
OSPItemNumber String Number that identifies outside processing (OSP) item.
OSPItemDescription String OSPItemDescription of WorkOrdersWorkOrderOperation
SupplierId Long Value that uniquely identifies outside processing (OSP) supplier. It is a primary key that the application generates when it creates a supplier.
SupplierName String Name of the outside processing (OSP) supplier.
SupplierSiteId Long Value that uniquely identifies supplier site. It is a primary key that the application generates when it creates a site of a supplier.
SupplierSiteCode String Abbreviation that identifies the supplier site.
SupplierSiteDescription String SupplierSiteDescription of WorkOrdersWorkOrderOperation
FixedLeadTime Decimal Lead time to perform this outside processing (OSP) operation independent of the quantity of the OSP item.
VariableLeadTime Decimal Lead time to perform this outside processing (OSP) operation for each unit of the OSP item.
LeadTimeUOM String Abbreviation that identifies the unit of measure that the lead time uses.
LeadTimeUnitOfMeasure String LeadTimeUnitOfMeasure of WorkOrdersWorkOrderOperation
CountPointOperationFlag Bool Contains one of the following values: true or false. If true, then this operation is a count point operation. If an operation is a count point operation, then you have to manually complete it. If false, then this operation isn't a count point operation. The last operation in a work order should always be a count point operation. This attribute doesn't have a default value.
AutoTransactFlag Bool Contains one of the following values: true or false. If true, the operation is automatically reported and both resources and materials are automatically charged based on the supply type or the charge type setups. If false, then the operation isn't automatically reported. The count point attribute and the automatically transact attribute are mutually exclusive. You must make sure that each of these attributes do not both contain true. If count point and automatically transact each contain false, then the operation is optional. You can manually report component usage and resource usage for an optional operation. This attribute doesn't have a default value.
ResequenceFlag Bool Contains one of the following values: true or false. If true, then the work order has resequence operations. If false, then the work order doesn't have resequence operations. This attribute is associated with a feature that requires an opt in.
ExecutionSequence Decimal ExecutionSequence of WorkOrdersWorkOrderOperation
PORequestedQuantity Decimal PORequestedQuantity of WorkOrdersWorkOrderOperation
POApprovedQuantity Decimal POApprovedQuantity of WorkOrdersWorkOrderOperation
OverReceiptQuantity Decimal OverReceiptQuantity of WorkOrdersWorkOrderOperation
InProcessQuantity Decimal InProcessQuantity of WorkOrdersWorkOrderOperation
ReceivedQuantity Decimal ReceivedQuantity of WorkOrdersWorkOrderOperation
ShippedQuantity Decimal ShippedQuantity of WorkOrdersWorkOrderOperation
ReadyQuantity Decimal ReadyQuantity of WorkOrdersWorkOrderOperation
CompletedQuantity Decimal CompletedQuantity of WorkOrdersWorkOrderOperation
ScrappedQuantity Decimal ScrappedQuantity of WorkOrdersWorkOrderOperation
RejectedQuantity Decimal RejectedQuantity of WorkOrdersWorkOrderOperation
UnitOfMeasure String UnitOfMeasure of WorkOrdersWorkOrderOperation
PlannedStartDate Datetime Planned date and time to start the operation. The scheduling application sets this date. The planned start date must not occur before the start date of the work order or after the finish date of the work order. This attribute is required.
PlannedCompletionDate Datetime Planned date and time to finish the operation. The scheduling application sets this date. The planned completion date must not occur before the start date of the work order or after the finish date of the work order. This attribute is required.
ActualStartDate Datetime ActualStartDate of WorkOrdersWorkOrderOperation
ActualCompletionDate Datetime ActualCompletionDate of WorkOrdersWorkOrderOperation
DelayStatus Int DelayStatus of WorkOrdersWorkOrderOperation
MaterialsCount Int MaterialsCount of WorkOrdersWorkOrderOperation
ResourcesCount Int ResourcesCount of WorkOrdersWorkOrderOperation
SerialTrackingFlag Bool SerialTrackingFlag of WorkOrdersWorkOrderOperation
ShippingDocumentsFlag Bool Contains one of the following values: true or false. If true, then create shipping documents for this outside processing (OSP) operation. If false, then do not create these shipping documents. This attribute doesn't have a default value.
CreatedBy String CreatedBy of WorkOrdersWorkOrderOperation
CreationDate Datetime CreationDate of WorkOrdersWorkOrderOperation
LastUpdateDate Datetime LastUpdateDate of WorkOrdersWorkOrderOperation
LastUpdatedBy String LastUpdatedBy of WorkOrdersWorkOrderOperation
AdditionalMaterialAtManualIssue String Value that controls whether a production operator can issue more than the required quantity while manually reporting material issues. You can issue more than the required quantity without any hindrance, or prevent the material issue in case of additional material issue.
OperationCompletionWithOpenExceptions String Value that controls whether operation completion is allowed when open exceptions exist for an operation. You can complete an operation without any hindrance, allow with a warning, or prevent operation completion.
OperationCompletionWithUnderIssue String Value that controls whether operation completion is allowed when less than the required quantity of material is issued. You can complete an operation without any hindrance, allow with a warning, or prevent operation completion.
BackToBackFlag String BackToBackFlag of WorkOrdersWorkOrderOperation
ContractMfgFlag String ContractMfgFlag of WorkOrdersWorkOrderOperation
DueDays Int DueDays of WorkOrdersWorkOrderOperation
Finder String Finder of WorkOrdersWorkOrderOperation
FirmPlannedFlag String FirmPlannedFlag of WorkOrdersWorkOrderOperation
InventoryItemId Long InventoryItemId of WorkOrdersWorkOrderOperation
ItemNumber String ItemNumber of WorkOrdersWorkOrderOperation
MaterialItemId Long MaterialItemId of WorkOrdersWorkOrderOperation
ProductSerialId Long ProductSerialId of WorkOrdersWorkOrderOperation
ResourceId Long ResourceId of WorkOrdersWorkOrderOperation
SerialNumber String SerialNumber of WorkOrdersWorkOrderOperation
SourceHeaderReferenceId Long SourceHeaderReferenceId of WorkOrdersWorkOrderOperation
SourceHeaderRefId Long SourceHeaderRefId of WorkOrdersWorkOrderOperation
SourceLineReferenceId Long SourceLineReferenceId of WorkOrdersWorkOrderOperation
SourceLineRefId Long SourceLineRefId of WorkOrdersWorkOrderOperation
SourceSystemId Long SourceSystemId of WorkOrdersWorkOrderOperation
Tolerance Int Tolerance of WorkOrdersWorkOrderOperation
WoProjectNumber String WoProjectNumber of WorkOrdersWorkOrderOperation
WorkOrderStatusId Long WorkOrderStatusId of WorkOrdersWorkOrderOperation
WoTaskNumber String WoTaskNumber of WorkOrdersWorkOrderOperation

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