WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance
Columns
| Name | Type | Description |
| WorkOrdersWorkOrderId [KEY] | Long | WorkOrdersWorkOrderId of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance |
| WorkorderresourceWorkOrderOperationResourceId [KEY] | Long | WorkorderresourceWorkOrderOperationResourceId of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance |
| WorkOrderOperationResourceInstanceId [KEY] | Long | Value that uniquely identifies the resource instance of a work order operation resource. It is a primary key that the application generates when it creates the resource instance for the work order operation resource. |
| WorkOrderOperationResourceId | Long | Value that uniquely identifies the resource of a work order operation. It is a primary key that the application generates when it creates the resource for the work order operation. |
| WorkOrderOperationId | Long | WorkOrderOperationId of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance |
| WorkOrderId | Long | WorkOrderId of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance |
| OrganizationId | Long | OrganizationId of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance |
| LaborInstanceId | Long | Value that uniquely identifies the labor resource instance. It is a primary key that the application generates when it creates a labor instance. |
| LaborInstanceCode | String | Abbreviation that identifies the labor resource instance. |
| LaborInstanceName | String | LaborInstanceName of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance |
| EquipmentInstanceId | Long | Value that uniquely identifies the equipment resource instance. It is a primary key that the application generates when it creates a equipment instance. |
| EquipmentInstanceCode | String | Abbreviation that identifies the equipment resource instance. |
| EquipmentInstanceName | String | EquipmentInstanceName of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance |
| ChargedQuantity | Double | ChargedQuantity of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance |
| ResourceType | String | ResourceType of WorkOrdersWorkOrderResourceWorkOrderOperationResourceInstance |
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 |
| 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 |