JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

ProcessWorkOrdersProcessWorkOrderStatusHistory

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

Columns

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

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