Resource
The Resource view object contains information about the resources of a manufacturing plant. A resource can include labor, equipment, and tools that you allocate to a work center. You can categorize a resource as either Labor or Equipment.
Data Store Key : FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.ResourceExtractPVO
Primary Keys : ResourceId, ResourceTranslationPEOLanguage, ResourceTranslationPEOResourceId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AttributeCategory | Context name for the Resource descriptive flexfield. |
| AttributeChar1 | Character segment for the Resource descriptive flexfield. |
| AttributeChar10 | Character segment for the Resource descriptive flexfield. |
| AttributeChar11 | Character segment for the Resource descriptive flexfield. |
| AttributeChar12 | Character segment for the Resource descriptive flexfield. |
| AttributeChar13 | Character segment for the Resource descriptive flexfield. |
| AttributeChar14 | Character segment for the Resource descriptive flexfield. |
| AttributeChar15 | Character segment for the Resource descriptive flexfield. |
| AttributeChar16 | Character segment for the Resource descriptive flexfield. |
| AttributeChar17 | Character segment for the Resource descriptive flexfield. |
| AttributeChar18 | Character segment for the Resource descriptive flexfield. |
| AttributeChar19 | Character segment for the Resource descriptive flexfield. |
| AttributeChar2 | Character segment for the Resource descriptive flexfield. |
| AttributeChar20 | Character segment for the Resource descriptive flexfield. |
| AttributeChar3 | Character segment for the Resource descriptive flexfield. |
| AttributeChar4 | Character segment for the Resource descriptive flexfield. |
| AttributeChar5 | Character segment for the Resource descriptive flexfield. |
| AttributeChar6 | Character segment for the Resource descriptive flexfield. |
| AttributeChar7 | Character segment for the Resource descriptive flexfield. |
| AttributeChar8 | Character segment for the Resource descriptive flexfield. |
| AttributeChar9 | Character segment for the Resource descriptive flexfield. |
| AttributeDate1 | Date segment for the Resource descriptive flexfield. |
| AttributeDate2 | Date segment for the Resource descriptive flexfield. |
| AttributeDate3 | Date segment for the Resource descriptive flexfield. |
| AttributeDate4 | Date segment for the Resource descriptive flexfield. |
| AttributeDate5 | Date segment for the Resource descriptive flexfield. |
| AttributeNumber1 | Number segment for the Resource descriptive flexfield. |
| AttributeNumber10 | Number segment for the Resource descriptive flexfield. |
| AttributeNumber2 | Number segment for the Resource descriptive flexfield. |
| AttributeNumber3 | Number segment for the Resource descriptive flexfield. |
| AttributeNumber4 | Number segment for the Resource descriptive flexfield. |
| AttributeNumber5 | Number segment for the Resource descriptive flexfield. |
| AttributeNumber6 | Number segment for the Resource descriptive flexfield. |
| AttributeNumber7 | Number segment for the Resource descriptive flexfield. |
| AttributeNumber8 | Number segment for the Resource descriptive flexfield. |
| AttributeNumber9 | Number segment for the Resource descriptive flexfield. |
| AttributeTimestamp1 | Date and Time segment for the Resource descriptive flexfield. |
| AttributeTimestamp2 | Date and Time segment for the Resource descriptive flexfield. |
| AttributeTimestamp3 | Date and Time segment for the Resource descriptive flexfield. |
| AttributeTimestamp4 | Date and Time segment for the Resource descriptive flexfield. |
| AttributeTimestamp5 | Date and Time segment for the Resource descriptive flexfield. |
| AutoEquipmentFlag | Indicates if the resource is a robot or an industrial equipment that can automatically perform an operation. |
| CostedFlag | Indicates if the application considers the resource costs in work order costing. |
| CreatedBy | User who created the Resource record. |
| CreationDate | Date and time when the user created the resource record. |
| InactiveDate | Date when the resource becomes inactive. |
| Language | Code of the language into which the contents of the translatable columns are translated. |
| LastUpdateDate | Date and time when the user last updated the resource record. |
| LastUpdateLogin | Session login associated with the user who last updated the resource record. |
| LastUpdatedBy | User who last updated the resource record. |
| ObjectVersionNumber | Number of times the object row was updated. This attribute is used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
| OrganizationId | Value that uniquely identifies the manufacturing plant to which this resource belongs. |
| PjcExpenditureTypeId | Value that uniquely identifies the expenditure type used for project-related transaction distributions. |
| ResourceClassCode | Code that identifies the class that groups resources. A list of accepted values is defined in the lookup type ORA_WIS_RESOURCE_CLASS. |
| ResourceCode | Code that identifies a resource. This code uniquely identifies a resource within a manufacturing plant. |
| ResourceId | Value that uniquely identifies the resource. This is the primary key of the Resource view object. |
| ResourceTranslationPEOCreatedBy | User who created the resource record. |
| ResourceTranslationPEOCreationDate | Date and time when the user created the resource record. |
| ResourceTranslationPEOLanguage | Code of the language into which the contents of the translatable columns are translated. |
| ResourceTranslationPEOLastUpdateDate | Date and time when the user last updated the resource record. |
| ResourceTranslationPEOLastUpdateLogin | Session login associated with the user who last updated the resource record. |
| ResourceTranslationPEOLastUpdatedBy | User who last updated the resource record. |
| ResourceTranslationPEOObjectVersionNumber | Number of times the object row was updated. This attribute is used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
| ResourceTranslationPEOResourceDescription | Description of the resource. |
| ResourceTranslationPEOResourceId | Value that uniquely identifies the resource. This is the primary key of the Resource view object. |
| ResourceTranslationPEOResourceName | Name of the resource. |
| ResourceTranslationPEOSourceLang | Code of the language in which the contents of the translatable columns were originally created. |
| ResourceType | Value that indicates the type of the resource. A list of accepted values is defined in the lookup type ORA_WIS_RESOURCE_TYPE. |
| UomCode | Code 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. |