WorkOrdersWorkOrderStatusHistory
WorkOrdersWorkOrderStatusHistory
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 |
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 |
| PlannedCompletionDate | Datetime | PlannedCompletionDate |
| PlannedStartDate | Datetime | PlannedStartDate |
| ProductSerialId | Long | ProductSerialId |
| ResourceId | Long | ResourceId |
| 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 |
| WorkOrderNumber | String | WorkOrderNumber |
| WorkOrderStatusId | Long | WorkOrderStatusId |
| Finder | String | finder |