CData Python Connector for Oracle Fusion Cloud SCM

Build 23.0.8839

WorkOrdersWorkOrderResourceWorkOrderResourceExceptionCount

WorkOrdersWorkOrderResourceWorkOrderResourceExceptionCount

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long WorkOrdersWorkOrderId of WorkOrdersWorkOrderResourceWorkOrderResourceExceptionCount
WorkorderresourceWorkOrderOperationResourceId [KEY] Long WorkorderresourceWorkOrderOperationResourceId of WorkOrdersWorkOrderResourceWorkOrderResourceExceptionCount
WorkOrderResourceExceptionCount Long WorkOrderResourceExceptionCount of WorkOrdersWorkOrderResourceWorkOrderResourceExceptionCount
ResourceId [KEY] Long ResourceId of WorkOrdersWorkOrderResourceWorkOrderResourceExceptionCount
WorkOrderOperationId [KEY] Long WorkOrderOperationId of WorkOrdersWorkOrderResourceWorkOrderResourceExceptionCount

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
BackToBackFlag String BackToBackFlag
ContractMfgFlag String ContractMfgFlag
DueDays Int DueDays
FirmPlannedFlag String FirmPlannedFlag
InventoryItemId Long InventoryItemId
ItemNumber String ItemNumber
LastUpdateDate Datetime LastUpdateDate
MaterialItemId Long MaterialItemId
OrganizationId Long OrganizationId
PlannedCompletionDate Datetime PlannedCompletionDate
PlannedStartDate Datetime PlannedStartDate
ProductSerialId Long ProductSerialId
SerialNumber String SerialNumber
SourceHeaderRefId Long SourceHeaderRefId
SourceHeaderReferenceId Long SourceHeaderReferenceId
SourceLineRefId Long SourceLineRefId
SourceLineReferenceId Long SourceLineReferenceId
SourceSystemId Long SourceSystemId
Tolerance Int Tolerance
WoProjectNumber String WoProjectNumber
WoTaskNumber String WoTaskNumber
WorkAreaId Long WorkAreaId
WorkCenterId Long WorkCenterId
WorkOrderId Long WorkOrderId
WorkOrderNumber String WorkOrderNumber
WorkOrderStatusId Long WorkOrderStatusId
Finder String finder

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