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. |