Plant Shift Exceptions for Extraction

The Plant Shift Exceptions for Extraction view object collects the exceptions associated to shifts in a production schedule.

Data Store Key : FscmTopModelAM.ScmExtractAM.ScmRcsBiccExtractAM.PlantShiftExceptionExtractPVO

Primary Keys : PlantShiftExcId

Initial Extract Date : PlantShiftExceptionPEOCreationDate

Incremental Extract Date : PlantShiftExceptionPEOLastUpdateDate

Attributes

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

Name	Description
PlantShiftExcId	Value that uniquely identifies the shift exception in the production calendar of a plant. The application generates this value when it creates the exception.
PlantShiftExceptionPEOAssociatedShiftId	Value that uniquely identifies the shift that the exception will be applied to.
PlantShiftExceptionPEOCreatedBy	User who created the row.
PlantShiftExceptionPEOCreationDate	Date and time of the creation of the row.
PlantShiftExceptionPEOEndDate	Date when the shift exception ends. This value is optional and defaults to the start date if it's not supplied. The value must be in the ISO8601 format for example, YYYY-MM-DD.
PlantShiftExceptionPEOExcDuration	Value the identifies the duration in hours for the shift exception. This value is required.
PlantShiftExceptionPEOExcEndTime	Value that identifies the time when the shift exception ends. It's derived from the start time and duration and isn't a user input.
PlantShiftExceptionPEOExcStartTime	Value that identifies the time when the shift exception starts. This value is required. It must be formatted as, HH:MM AM|PM.
PlantShiftExceptionPEOExceptionType	Value that identifies the type of shift exception being created. Valid values are Change Shift, Remove Shift, Split Shift, and Add Shift.
PlantShiftExceptionPEOLastUpdateDate	Date and time of the last update of the row.
PlantShiftExceptionPEOLastUpdateLogin	Session login associated to the user who last updated the row.
PlantShiftExceptionPEOLastUpdatedBy	User who last updated the row.
PlantShiftExceptionPEOMfgWcId	Value that uniquely identifies the work center that the exception is for. If the work center supports override calendars, then an exception may be created that's specific to the work center, instead of to the plant.
PlantShiftExceptionPEOObjectVersionNumber	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.
PlantShiftExceptionPEOOrganizationId	Value that uniquely identifies the inventory organization that's the plant.
PlantShiftExceptionPEOScheduleId	Value that uniquely identifies the schedule that the organization references as the manufacturing or production calendar. It corresponds to the manufacturing calendar specified in the Manage Plant Parameters task for the inventory organization in the request.
PlantShiftExceptionPEOStartDate	Date when the shift exception starts. This value is required. The value must be in the ISO8601 format for example, YYYY-MM-DD.
PlantShiftExceptionTranslationPEOLanguage	Indicates the code of the language into which the contents of the translatable columns are translated.
PlantShiftExceptionTranslationPEOName	Value that identifies the user-supplied name for the shift exception. This value is required.
PlantShiftExceptionTranslationPEOPlantShiftExcId1	Value that uniquely identifies the shift exception in the production calendar of a plant. The application generates this value when it creates the exception.
PlantShiftExceptionTranslationPEOReason	Value that identifies the user-supplied reason for the shift exception.