ProductionResourcesEquipmentInstance
ProductionResourcesEquipmentInstance
Columns
| Name | Type | Description |
| ProductionResourcesResourceId [KEY] | Long | ProductionResourcesResourceId of ProductionResourcesEquipmentInstance |
| EquipmentInstanceId [KEY] | Long | Value that uniquely identifies the equipment resource instance. It is a primary key that the application generates when it creates a equipment instance. |
| EquipmentIdentifier | String | Abbreviation that identifies the equipment resource instance. |
| EquipmentInstanceName | String | Name of the equipment resource instance. |
| AssetId | Long | Value that uniquely identifies the item associated with the asset in the maintenance organization. |
| AssetNumber | String | Unique asset number that identifies the equipment instance. |
| AssetDescription | String | AssetDescription of ProductionResourcesEquipmentInstance |
| AssetItemId | Long | AssetItemId of ProductionResourcesEquipmentInstance |
| AssetItemNumber | String | AssetItemNumber of ProductionResourcesEquipmentInstance |
| AssetItemDescription | String | AssetItemDescription of ProductionResourcesEquipmentInstance |
| OrganizationId | Long | OrganizationId of ProductionResourcesEquipmentInstance |
| ResourceId | Long | Value that uniquely identifies the production resource. It is a primary key that the application generates when it creates a production resource. |
| ResourceCode | String | ResourceCode of ProductionResourcesEquipmentInstance |
| PrimaryWorkCenterId | Long | Value that uniquely identifies the work center. It is a primary key that the application generates when it creates a work center. This is the default work center that the application assigns to this equipment instance. |
| PrimaryWorkCenterCode | String | Abbreviation that identifies the primary work center. |
| InactiveDate | Date | Date when the equipment instance becomes inactive. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| ChangedDate | Date | ChangedDate |
| FirstName | String | FirstName |
| LaborIdentifier | String | LaborIdentifier |
| LaborInstanceId | Long | LaborInstanceId |
| LastName | String | LastName |
| MiddleName | String | MiddleName |
| PartyId | Long | PartyId |
| PersonName | String | PersonName |
| PersonType | String | PersonType |
| ResourceType | String | ResourceType |
| Finder | String | finder |