SSIS Components for Oracle Fusion Cloud SCM

Build 24.0.9060

WorkOrdersWorkOrderExceptionCount

The Work Order Exceptions resource gets the count of exceptions for the work order.

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long WorkOrdersWorkOrderId of WorkOrdersWorkOrderExceptionCount
WorkOrderExceptionCount Long WorkOrderExceptionCount of WorkOrdersWorkOrderExceptionCount
WorkOrderId [KEY] Long WorkOrderId of WorkOrdersWorkOrderExceptionCount
BackToBackFlag String BackToBackFlag of WorkOrdersWorkOrderExceptionCount
ContractMfgFlag String ContractMfgFlag of WorkOrdersWorkOrderExceptionCount
DueDays Int DueDays of WorkOrdersWorkOrderExceptionCount
Finder String Finder of WorkOrdersWorkOrderExceptionCount
FirmPlannedFlag String FirmPlannedFlag of WorkOrdersWorkOrderExceptionCount
InventoryItemId Long InventoryItemId of WorkOrdersWorkOrderExceptionCount
ItemNumber String ItemNumber of WorkOrdersWorkOrderExceptionCount
LastUpdateDate Datetime LastUpdateDate of WorkOrdersWorkOrderExceptionCount
MaterialItemId Long MaterialItemId of WorkOrdersWorkOrderExceptionCount
OrganizationId Long OrganizationId of WorkOrdersWorkOrderExceptionCount
PlannedCompletionDate Datetime PlannedCompletionDate of WorkOrdersWorkOrderExceptionCount
PlannedStartDate Datetime PlannedStartDate of WorkOrdersWorkOrderExceptionCount
ProductSerialId Long ProductSerialId of WorkOrdersWorkOrderExceptionCount
ResourceId Long ResourceId of WorkOrdersWorkOrderExceptionCount
SerialNumber String SerialNumber of WorkOrdersWorkOrderExceptionCount
SourceHeaderReferenceId Long SourceHeaderReferenceId of WorkOrdersWorkOrderExceptionCount
SourceHeaderRefId Long SourceHeaderRefId of WorkOrdersWorkOrderExceptionCount
SourceLineReferenceId Long SourceLineReferenceId of WorkOrdersWorkOrderExceptionCount
SourceLineRefId Long SourceLineRefId of WorkOrdersWorkOrderExceptionCount
SourceSystemId Long SourceSystemId of WorkOrdersWorkOrderExceptionCount
Tolerance Int Tolerance of WorkOrdersWorkOrderExceptionCount
WoProjectNumber String WoProjectNumber of WorkOrdersWorkOrderExceptionCount
WorkAreaId Long WorkAreaId of WorkOrdersWorkOrderExceptionCount
WorkCenterId Long WorkCenterId of WorkOrdersWorkOrderExceptionCount
WorkOrderNumber String WorkOrderNumber of WorkOrdersWorkOrderExceptionCount
WorkOrderStatusId Long WorkOrderStatusId of WorkOrdersWorkOrderExceptionCount
WoTaskNumber String WoTaskNumber of WorkOrdersWorkOrderExceptionCount

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