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.