Work Center Resource Exception Details for Extraction
The Work Center Resource Exception Details for Extraction view object collects the exceptions associated to individual work center resources in a production schedule.
Data Store Key : FscmTopModelAM.ScmExtractAM.ScmRcsBiccExtractAM.WorkCenterResourceExceptionDetailsExtractPVO
Primary Keys : WcResExcDetailId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| CreatedBy | User who created the row. |
| CreationDate | Date and time of the creation of the row. |
| ExcUnitsAvailable | Value that identifies an override quantity of available units in the exception. This value will override the assigned quantity for the work center resource. |
| LastUpdateDate | Date and time of the last update of the row. |
| LastUpdateLogin | Session login associated to the user who last updated the row. |
| LastUpdatedBy | User who last updated the row. |
| ObjectVersionNumber | Used to implement optimistic locking. This number is incremented every time that 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. |
| ResourceId | Value that uniquely identifies the resource. |
| WcId | Value that uniquely identifies the work center. |
| WcResExcDetailId | Value that uniquely identifies the work center resource exception detail in the production calendar of a plant. Each resource specified in the work center resource exception will have a separate detail record. The application generates this value when it creates the exception. |
| WcResourceExcId | Value that uniquely identifies the parent work center resource exception in the production calendar of a plant. |