Work Center Calendar
The Work Center Calendar view object contains the plant and override calendars associated to the work center for an effective date range.
Data Store Key : FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.WorkCenterProductionCalendarExtractPVO
Primary Keys : WcProdCalendarId
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 work center calendar record. |
CreationDate | Date and time when the user created the work center calendar record. |
EffectiveFromDate | Date and time from when the work center calendar is effective. |
EffectiveToDate | Date and time when the work center calendar is effective. |
LastUpdateDate | Date and time when the user last updated the work center calendar record. |
LastUpdateLogin | Session login associated with the user who most recently updated the work center calendar record. |
LastUpdatedBy | User who last updated the work center calendar record. |
MfgCalendarId | Value that uniquely identifies the calendar in the resource shift. This is a foreign key to the Schedule view object. |
ObjectVersionNumber | Number of times the object row was updated. This attribute is used to implement optimistic locking. This number is incremented every time 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. |
WcProdCalendarId | Value that uniquely identifies the work center calendar. This is the primary key of the Work Center Calendar view object. |
WorkCenterId | Value that uniquely identifies the work center in the resource shift. This is a foreign key to the Work Center view object. |