JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

WorkOrdersWorkOrderStatusHistory

The Status History resource gets the status history for the work order.

Columns

Name Type Description
WorkOrdersWorkOrderId [KEY] Long WorkOrdersWorkOrderId of WorkOrdersWorkOrderStatusHistory
WoStatusHistoryId [KEY] Long WoStatusHistoryId of WorkOrdersWorkOrderStatusHistory
OrganizationId Long OrganizationId of WorkOrdersWorkOrderStatusHistory
WorkOrderId [KEY] Long WorkOrderId of WorkOrdersWorkOrderStatusHistory
StatusChangeDate Datetime StatusChangeDate of WorkOrdersWorkOrderStatusHistory
FromStatusId Long FromStatusId of WorkOrdersWorkOrderStatusHistory
FromStatusCode String FromStatusCode of WorkOrdersWorkOrderStatusHistory
FromSystemStatusCode String FromSystemStatusCode of WorkOrdersWorkOrderStatusHistory
FromStatusName String FromStatusName of WorkOrdersWorkOrderStatusHistory
ToStatusId Long ToStatusId of WorkOrdersWorkOrderStatusHistory
ToStatusCode String ToStatusCode of WorkOrdersWorkOrderStatusHistory
ToSystemStatusCode String ToSystemStatusCode of WorkOrdersWorkOrderStatusHistory
ToStatusName String ToStatusName of WorkOrdersWorkOrderStatusHistory
Reason String Reason of WorkOrdersWorkOrderStatusHistory
User String User of WorkOrdersWorkOrderStatusHistory
BackToBackFlag String BackToBackFlag of WorkOrdersWorkOrderStatusHistory
ContractMfgFlag String ContractMfgFlag of WorkOrdersWorkOrderStatusHistory
DueDays Int DueDays of WorkOrdersWorkOrderStatusHistory
Finder String Finder of WorkOrdersWorkOrderStatusHistory
FirmPlannedFlag String FirmPlannedFlag of WorkOrdersWorkOrderStatusHistory
InventoryItemId Long InventoryItemId of WorkOrdersWorkOrderStatusHistory
ItemNumber String ItemNumber of WorkOrdersWorkOrderStatusHistory
LastUpdateDate Datetime LastUpdateDate of WorkOrdersWorkOrderStatusHistory
MaterialItemId Long MaterialItemId of WorkOrdersWorkOrderStatusHistory
PlannedCompletionDate Datetime PlannedCompletionDate of WorkOrdersWorkOrderStatusHistory
PlannedStartDate Datetime PlannedStartDate of WorkOrdersWorkOrderStatusHistory
ProductSerialId Long ProductSerialId of WorkOrdersWorkOrderStatusHistory
ResourceId Long ResourceId of WorkOrdersWorkOrderStatusHistory
SerialNumber String SerialNumber of WorkOrdersWorkOrderStatusHistory
SourceHeaderReferenceId Long SourceHeaderReferenceId of WorkOrdersWorkOrderStatusHistory
SourceHeaderRefId Long SourceHeaderRefId of WorkOrdersWorkOrderStatusHistory
SourceLineReferenceId Long SourceLineReferenceId of WorkOrdersWorkOrderStatusHistory
SourceLineRefId Long SourceLineRefId of WorkOrdersWorkOrderStatusHistory
SourceSystemId Long SourceSystemId of WorkOrdersWorkOrderStatusHistory
Tolerance Int Tolerance of WorkOrdersWorkOrderStatusHistory
WoProjectNumber String WoProjectNumber of WorkOrdersWorkOrderStatusHistory
WorkAreaId Long WorkAreaId of WorkOrdersWorkOrderStatusHistory
WorkCenterId Long WorkCenterId of WorkOrdersWorkOrderStatusHistory
WorkOrderNumber String WorkOrderNumber of WorkOrdersWorkOrderStatusHistory
WorkOrderStatusId Long WorkOrderStatusId of WorkOrdersWorkOrderStatusHistory
WoTaskNumber String WoTaskNumber of WorkOrdersWorkOrderStatusHistory

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