WorkOrdersWorkOrderResource
WorkOrdersWorkOrderResource
Columns
| Name | Type | Description |
| WorkOrdersWorkOrderId [KEY] | Long | WorkOrdersWorkOrderId of WorkOrdersWorkOrderResource |
| OrganizationId | Long | OrganizationId of WorkOrdersWorkOrderResource |
| ResourceSequenceNumber | Double | ResourceSequenceNumber of WorkOrdersWorkOrderResource |
| WorkOrderOperationResourceId [KEY] | Long | WorkOrderOperationResourceId of WorkOrdersWorkOrderResource |
| ResourceId | Long | ResourceId of WorkOrdersWorkOrderResource |
| ResourceCode | String | ResourceCode of WorkOrdersWorkOrderResource |
| ResourceDescription | String | ResourceDescription of WorkOrdersWorkOrderResource |
| ResourceName | String | ResourceName of WorkOrdersWorkOrderResource |
| ResourceType | String | ResourceType of WorkOrdersWorkOrderResource |
| WorkAreaId | Long | WorkAreaId of WorkOrdersWorkOrderResource |
| WorkAreaName | String | WorkAreaName of WorkOrdersWorkOrderResource |
| WorkAreaCode | String | WorkAreaCode of WorkOrdersWorkOrderResource |
| WorkAreaDescription | String | WorkAreaDescription of WorkOrdersWorkOrderResource |
| WorkCenterId | Long | WorkCenterId of WorkOrdersWorkOrderResource |
| WorkCenterName | String | WorkCenterName of WorkOrdersWorkOrderResource |
| WorkCenterCode | String | WorkCenterCode of WorkOrdersWorkOrderResource |
| WorkCenterDescription | String | WorkCenterDescription of WorkOrdersWorkOrderResource |
| WorkOrderId | Long | WorkOrderId of WorkOrdersWorkOrderResource |
| WorkOrderOperationId | Long | WorkOrderOperationId of WorkOrdersWorkOrderResource |
| OperationSequenceNumber | Double | OperationSequenceNumber of WorkOrdersWorkOrderResource |
| OperationName | String | OperationName of WorkOrdersWorkOrderResource |
| StandardOperationId | Long | StandardOperationId of WorkOrdersWorkOrderResource |
| StandardOperationCode | String | StandardOperationCode of WorkOrdersWorkOrderResource |
| PrincipalFlag | Bool | PrincipalFlag of WorkOrdersWorkOrderResource |
| UsageRate | Double | UsageRate of WorkOrdersWorkOrderResource |
| BasisType | String | BasisType of WorkOrdersWorkOrderResource |
| RequiredUsage | Double | RequiredUsage of WorkOrdersWorkOrderResource |
| InverseRequiredUsage | Double | InverseRequiredUsage of WorkOrdersWorkOrderResource |
| UOMCode | String | UOMCode of WorkOrdersWorkOrderResource |
| UnitOfMeasure | String | UnitOfMeasure of WorkOrdersWorkOrderResource |
| ChargeType | String | ChargeType of WorkOrdersWorkOrderResource |
| AssignedUnits | Double | AssignedUnits of WorkOrdersWorkOrderResource |
| PlannedStartDate | Datetime | PlannedStartDate of WorkOrdersWorkOrderResource |
| PlannedCompletionDate | Datetime | PlannedCompletionDate of WorkOrdersWorkOrderResource |
| ResourceActivityCode | String | ResourceActivityCode of WorkOrdersWorkOrderResource |
| ScheduledIndicator | String | ScheduledIndicator of WorkOrdersWorkOrderResource |
| PhantomFlag | Bool | PhantomFlag of WorkOrdersWorkOrderResource |
| ActualResourceUsage | Double | ActualResourceUsage of WorkOrdersWorkOrderResource |
| CreatedBy | String | CreatedBy of WorkOrdersWorkOrderResource |
| CreationDate | Datetime | CreationDate of WorkOrdersWorkOrderResource |
| LastUpdateDate | Datetime | LastUpdateDate of WorkOrdersWorkOrderResource |
| LastUpdatedBy | String | LastUpdatedBy of WorkOrdersWorkOrderResource |
| ProfileId | Long | ProfileId of WorkOrdersWorkOrderResource |
| ProfileCode | String | ProfileCode of WorkOrdersWorkOrderResource |
| EquipmentProfileId | Long | EquipmentProfileId of WorkOrdersWorkOrderResource |
| EquipmentProfileCode | String | EquipmentProfileCode of WorkOrdersWorkOrderResource |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| BackToBackFlag | String | BackToBackFlag |
| ContractMfgFlag | String | ContractMfgFlag |
| DueDays | Int | DueDays |
| FirmPlannedFlag | String | FirmPlannedFlag |
| InventoryItemId | Long | InventoryItemId |
| ItemNumber | String | ItemNumber |
| MaterialItemId | Long | MaterialItemId |
| 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 |
| WorkOrderNumber | String | WorkOrderNumber |
| WorkOrderStatusId | Long | WorkOrderStatusId |
| Finder | String | finder |