Tableau Connector for Oracle Fusion Cloud SCM

Build 24.0.9060

ProcessWorkOrdersOperation

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

Columns

Name Type Description
ProcessWorkOrdersWorkOrderId [KEY] Long ProcessWorkOrdersWorkOrderId of ProcessWorkOrdersOperation
OrganizationId Long OrganizationId of ProcessWorkOrdersOperation
WorkOrderId Long Value that uniquely identifies the work order. It's a primary key that the application generates when it creates the work order.
WorkOrderNumber String WorkOrderNumber of ProcessWorkOrdersOperation
WorkOrderOperationId [KEY] Long WorkOrderOperationId of ProcessWorkOrdersOperation
OperationSequenceNumber Decimal Number that indicates the sequence to use when performing the work order operations.
OperationName String Name of the operation.
OperationDescription String Description of the operation.
OperationType String Value that specifies the type of the operation. A list of accepted values is defined in the lookup type ORA_WIS_OPERATION_TYPE.
OperationTypeDescription String OperationTypeDescription of ProcessWorkOrdersOperation
StandardOperationId Long Value that uniquely identifies the operation that the work order references. It's a primary key that the application generates when it creates the operation.
StandardOperationCode String Abbreviation that identifies the operation.
StandardOperationName String StandardOperationName of ProcessWorkOrdersOperation
WorkAreaId Long WorkAreaId of ProcessWorkOrdersOperation
WorkAreaCode String WorkAreaCode of ProcessWorkOrdersOperation
WorkAreaName String WorkAreaName of ProcessWorkOrdersOperation
WorkAreaDescription String WorkAreaDescription of ProcessWorkOrdersOperation
WorkCenterId Long Value that uniquely identifies the work center. It's 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 ProcessWorkOrdersOperation
WorkCenterDescription String WorkCenterDescription of ProcessWorkOrdersOperation
OSPItemId Long Value that uniquely identifies the outside-processing item. It's a primary key that the application generates when it creates an item
OSPItemNumber String Number that identifies outside-processing item.
OSPItemDescription String OSPItemDescription of ProcessWorkOrdersOperation
SupplierId Long Value that uniquely identifies the outside-processing supplier. It's a primary key that the application generates when it creates a supplier.
SupplierName String Name of the outside-processing supplier.
SupplierSiteId Long Value that uniquely identifies the supplier site. It's a primary key that the application generates when it creates a supplier site.
SupplierSiteCode String Abbreviation that identifies the supplier site.
SupplierSiteDescription String SupplierSiteDescription of ProcessWorkOrdersOperation
FixedLeadTime Decimal Lead time to perform this outside-processing operation, independent of the quantity of the outside-processing item.
VariableLeadTime Decimal Lead time to perform this outside-processing operation for each unit of the outside-processing item.
LeadTimeUOM String Abbreviation that identifies the unit of measure that the lead time uses.
LeadTimeUnitOfMeasure String LeadTimeUnitOfMeasure of ProcessWorkOrdersOperation
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 is not a count point operation. The last operation in a work order should always be a count point operation. This attribute does not 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 is not 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 does not 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 ProcessWorkOrdersOperation
PORequestedQuantity Decimal PORequestedQuantity of ProcessWorkOrdersOperation
POApprovedQuantity Decimal POApprovedQuantity of ProcessWorkOrdersOperation
OverReceiptQuantity Decimal OverReceiptQuantity of ProcessWorkOrdersOperation
InProcessQuantity Decimal InProcessQuantity of ProcessWorkOrdersOperation
ReceivedQuantity Decimal ReceivedQuantity of ProcessWorkOrdersOperation
ShippedQuantity Decimal ShippedQuantity of ProcessWorkOrdersOperation
ReadyQuantity Decimal ReadyQuantity of ProcessWorkOrdersOperation
CompletedQuantity Decimal CompletedQuantity of ProcessWorkOrdersOperation
ScrappedQuantity Decimal ScrappedQuantity of ProcessWorkOrdersOperation
RejectedQuantity Decimal RejectedQuantity of ProcessWorkOrdersOperation
UnitOfMeasure String UnitOfMeasure of ProcessWorkOrdersOperation
PlannedStartDate Datetime Date and time when the user planned to start the operation. This date is set by the scheduling application. 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 Date and time when the user planned to complete the operation. This date is set by the scheduling application. 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 ProcessWorkOrdersOperation
ActualCompletionDate Datetime ActualCompletionDate of ProcessWorkOrdersOperation
DelayStatus Int DelayStatus of ProcessWorkOrdersOperation
MaterialsCount Int MaterialsCount of ProcessWorkOrdersOperation
ResourcesCount Int ResourcesCount of ProcessWorkOrdersOperation
SerialTrackingFlag Bool SerialTrackingFlag of ProcessWorkOrdersOperation
ShippingDocumentsFlag Bool Contains one of the following values: true or false. If true, then create shipping documents for this outside-processing operation. If false, then do not create these shipping documents. This attribute does not have a default value.
CreatedBy String CreatedBy of ProcessWorkOrdersOperation
CreationDate Datetime CreationDate of ProcessWorkOrdersOperation
LastUpdateDate Datetime LastUpdateDate of ProcessWorkOrdersOperation
LastUpdatedBy String LastUpdatedBy of ProcessWorkOrdersOperation
AdditionalMaterialAtManualIssue String Name that identifies a list of values that control whether a production operator can issue more than the required quantity while manually reporting material issues. You can allow issuing more than the required quantity without any hindrance, or prevent the material issue in case of additional material issue.
OperationCompletionWithOpenExceptions String Name that identifies a list of values that control whether operation completion should be allowed when open exceptions exist for an operation. You can allow operation completion without any hindrance, allow with a warning, or prevent the operation completion.
OperationCompletionWithUnderIssue String Name that identifies a list of values that control whether operation completion should be allowed when less than the required quantity of material is issued. You can allow operation completion without any hindrance, allow with a warning, or prevent the operation completion.
BackToBackFlag String BackToBackFlag of ProcessWorkOrdersOperation
ContractMfgFlag String ContractMfgFlag of ProcessWorkOrdersOperation
DueDays Int DueDays of ProcessWorkOrdersOperation
Finder String Finder of ProcessWorkOrdersOperation
FirmPlannedFlag String FirmPlannedFlag of ProcessWorkOrdersOperation
InventoryItemId Long InventoryItemId of ProcessWorkOrdersOperation
ItemNumber String ItemNumber of ProcessWorkOrdersOperation
MaterialItemId Long MaterialItemId of ProcessWorkOrdersOperation
ProductSerialId Long ProductSerialId of ProcessWorkOrdersOperation
ResourceId Long ResourceId of ProcessWorkOrdersOperation
SerialNumber String SerialNumber of ProcessWorkOrdersOperation
SourceHeaderReferenceId Long SourceHeaderReferenceId of ProcessWorkOrdersOperation
SourceHeaderRefId Long SourceHeaderRefId of ProcessWorkOrdersOperation
SourceLineReferenceId Long SourceLineReferenceId of ProcessWorkOrdersOperation
SourceLineRefId Long SourceLineRefId of ProcessWorkOrdersOperation
SourceSystemId Long SourceSystemId of ProcessWorkOrdersOperation
Tolerance Int Tolerance of ProcessWorkOrdersOperation
WoProjectNumber String WoProjectNumber of ProcessWorkOrdersOperation
WorkOrderStatusId Long WorkOrderStatusId of ProcessWorkOrdersOperation
WoTaskNumber String WoTaskNumber of ProcessWorkOrdersOperation

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