ProductionResourcesLaborInstance
ProductionResourcesLaborInstance
Columns
| Name | Type | Description |
| ProductionResourcesResourceId [KEY] | Long | ProductionResourcesResourceId of ProductionResourcesLaborInstance |
| LaborInstanceId [KEY] | Long | Value that uniquely identifies the labor resource instance. It is a primary key that the application generates when it creates a labor instance. |
| LaborIdentifier | String | Abbreviation that identifies the labor resource instance. |
| LaborInstanceName | String | Name of the labor resource instance. |
| PartyId | Long | Value that identifies the party table in Oracle Trading Community Architecture. It is a foreign key. |
| RegistryId | String | Value that identifies the registry from the Oracle Trading Community Architecture. This attribute is a foreign key. |
| PersonName | String | PersonName of ProductionResourcesLaborInstance |
| PersonType | String | PersonType of ProductionResourcesLaborInstance |
| OrganizationId | Long | Value that uniquely identifies the inventory organization. It is a primary key that the application generates when it creates an inventory organization. |
| 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 ProductionResourcesLaborInstance |
| 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 assigned to this equipment instance. |
| PrimaryWorkCenterCode | String | Abbreviation that identifies the primary work center. |
| InactiveDate | Date | Date when the labor instance becomes inactive. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| AssetItemId | Long | AssetItemId |
| AssetItemNumber | String | AssetItemNumber |
| AssetNumber | String | AssetNumber |
| ChangedDate | Date | ChangedDate |
| EquipmentIdentifier | String | EquipmentIdentifier |
| EquipmentInstanceId | Long | EquipmentInstanceId |
| FirstName | String | FirstName |
| LastName | String | LastName |
| MiddleName | String | MiddleName |
| ResourceType | String | ResourceType |
| Finder | String | finder |