ProductionResources
ProductionResources
Columns
| Name | Type | Description |
| OrganizationId | Long | Value that uniquely identifies the inventory organization. It is a primary key that the application generates when it creates an inventory organization. |
| OrganizationCode | String | Abbreviation that identifies the inventory organization. |
| OrganizationName | String | OrganizationName of ProductionResources |
| ResourceId [KEY] | Long | Value that uniquely identifies the production resource. It is a primary key that the application generates when it creates a production resource. |
| ResourceName | String | Name of the production resource. |
| ResourceDescription | String | Description of the production resource. |
| ResourceCode | String | Abbreviation that identifies the production resource. |
| ResourceType | String | Value that indicates the type of the production resource. A list of accepted values is defined in the lookup type ORA_WIS_RESOURCE_TYPE. |
| UOMCode | String | Abbreviation that identifies the unit of measure. The application uses this code for scheduling and for resource charge. To use this resource for scheduling, it must be part of a valid Time UOM class. |
| UnitOfMeasure | String | UnitOfMeasure of ProductionResources |
| ResourceClassCode | String | Abbreviation that identifies the class that groups production resources. A list of accepted values is defined in the lookup type ORA_WIS_RESOURCE_CLASS. |
| CostedFlag | Bool | Contains one of the following values: true or false. If true, then consider resource costs in work order costing. If false, then do not consider these costs. The default value is false. |
| InactiveDate | Date | Date when the resource becomes inactive. If date is not specified, the resource is considered active. |
| DefaultExpenditureTypeId | Long | Value that uniquely identifies the expenditure type used for project-related transaction distributions. This attribute is associated with a feature that requires opt in. |
| DefaultExpenditureTypeName | String | Name of the cost classification assigned to each expenditure item. Expenditure types are grouped into cost groups and revenue groups. This attribute is associated with a feature that requires opt in. |
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 |
| LaborIdentifier | String | LaborIdentifier |
| LaborInstanceId | Long | LaborInstanceId |
| LastName | String | LastName |
| MiddleName | String | MiddleName |
| PartyId | Long | PartyId |
| PersonName | String | PersonName |
| PersonType | String | PersonType |
| PrimaryWorkCenterCode | String | PrimaryWorkCenterCode |
| PrimaryWorkCenterId | Long | PrimaryWorkCenterId |
| Finder | String | finder |