Work Center Resource Exceptions for Extraction

The Work Center Resource Exceptions for Extraction view object collects the exceptions associated to work center resources in a production schedule.

Data Store Key : FscmTopModelAM.ScmExtractAM.ScmRcsBiccExtractAM.WorkCenterResourceExceptionExtractPVO

Primary Keys : WcResourceExcId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
AssociatedShiftId Value that uniquely identifies the shift associated to the work center resources in this exception.
CreatedBy User who created the row.
CreationDate Date and time of the creation of the row.
EndDate Date when the work center resource exception ends. This value is required. The value must be in the ISO8601 format for example, YYYY-MM-DD.
ExcEndTime Time when the work center resource exception ends.
ExcStartTime Time when the work center resource exception starts.
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.
OrganizationId Value that uniquely identifies the inventory organization that's the plant.
PlantShiftExcId Value that uniquely identifies a shift exception in the production calendar of a plant. If a shift exception is defined for specific work center resources, a work center resource exception is created to store the details for the specified resources.
ScheduleId Value that uniquely identifies the schedule that the organization references as the manufacturing or production calendar. It corresponds to the manufacturing calendar that's specified in the Manage Plant Parameters task for the inventory organization in the request.
StandaloneWcExcFlag Value that indicates that the work center resource exception is standalone, meaning it isn't associated to a shift exception.
StartDate Date when the work center resource exception starts. This value is required. The value must be in the ISO8601 format for example, YYYY-MM-DD.
WcResourceExcId Value that uniquely identifies the work center resource exception in the production calendar of a plant. The application generates this value when it creates the exception.