Work Center

The Work Center view object contains information about the work centers that the work area contains. A work center is a production unit that consists of labor or equipment resources that have similar capabilities. Each work center is part of a work area. You can use it to plan capacity requirements and to schedule detailed work.

Data Store Key : FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.WorkCenterExtractPVO

Primary Keys : WorkCenterId, WorkCenterTranslationPEOLanguage, WorkCenterTranslationPEOWorkCenterId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name Description
AttributeCategory Context name for the Work Center descriptive flexfield.
AttributeChar1 Character segment for the Work Center descriptive flexfield.
AttributeChar10 Character segment for the Work Center descriptive flexfield.
AttributeChar11 Character segment for the Work Center descriptive flexfield.
AttributeChar12 Character segment for the Work Center descriptive flexfield.
AttributeChar13 Character segment for the Work Center descriptive flexfield.
AttributeChar14 Character segment for the Work Center descriptive flexfield.
AttributeChar15 Character segment for the Work Center descriptive flexfield.
AttributeChar16 Character segment for the Work Center descriptive flexfield.
AttributeChar17 Character segment for the Work Center descriptive flexfield.
AttributeChar18 Character segment for the Work Center descriptive flexfield.
AttributeChar19 Character segment for the Work Center descriptive flexfield.
AttributeChar2 Character segment for the Work Center descriptive flexfield.
AttributeChar20 Character segment for the Work Center descriptive flexfield.
AttributeChar3 Character segment for the Work Center descriptive flexfield.
AttributeChar4 Character segment for the Work Center descriptive flexfield.
AttributeChar5 Character segment for the Work Center descriptive flexfield.
AttributeChar6 Character segment for the Work Center descriptive flexfield.
AttributeChar7 Character segment for the Work Center descriptive flexfield.
AttributeChar8 Character segment for the Work Center descriptive flexfield.
AttributeChar9 Character segment for the Work Center descriptive flexfield.
AttributeDate1 Date segment for the Work Center descriptive flexfield.
AttributeDate2 Date segment for the Work Center descriptive flexfield.
AttributeDate3 Date segment for the Work Center descriptive flexfield.
AttributeDate4 Date segment for the Work Center descriptive flexfield.
AttributeDate5 Date segment for the Work Center descriptive flexfield.
AttributeNumber1 Number segment for the Work Center descriptive flexfield.
AttributeNumber10 Number segment for the Work Center descriptive flexfield.
AttributeNumber2 Number segment for the Work Center descriptive flexfield.
AttributeNumber3 Number segment for the Work Center descriptive flexfield.
AttributeNumber4 Number segment for the Work Center descriptive flexfield.
AttributeNumber5 Number segment for the Work Center descriptive flexfield.
AttributeNumber6 Number segment for the Work Center descriptive flexfield.
AttributeNumber7 Number segment for the Work Center descriptive flexfield.
AttributeNumber8 Number segment for the Work Center descriptive flexfield.
AttributeNumber9 Number segment for the Work Center descriptive flexfield.
AttributeTimestamp1 Date and time segment for the Work Center descriptive flexfield.
AttributeTimestamp2 Date and time segment for the Work Center descriptive flexfield.
AttributeTimestamp3 Date and time segment for the Work Center descriptive flexfield.
AttributeTimestamp4 Date and time segment for the Work Center descriptive flexfield.
AttributeTimestamp5 Date and time segment for the Work Center descriptive flexfield.
CreatedBy User who created the work center record.
CreationDate Date and time when the user created the work center record.
InactiveDate Date when the work center becomes inactive.
Language Code of the language into which the contents of the translatable columns are translated.
LastUpdateDate Date and time when the user last updated the work center record.
LastUpdateLogin Session login associated with the user who last updated the work center record.
LastUpdatedBy User who last updated the work center record.
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.
OrganizationId Value that uniquely identifies the manufacturing plant to which this work center belongs.
OverrideCalendarFlag Value that indicates if the work center is enabled for override calendars.
WorkAreaId Value that uniquely identifies the work area in the work center. This is a foreign key to the Work Area view object.
WorkCenterCode A code used to identify a work center. This code uniquely identifies a work center within a manufacturing plant.
WorkCenterId Value that uniquely identifies the work center. This is the primary key of the Work Center view object.
WorkCenterTranslationPEOCreatedBy User who created the work center record.
WorkCenterTranslationPEOCreationDate Date and time when the user created the work center record.
WorkCenterTranslationPEOLanguage Code of the language into which the contents of the translatable columns are translated.
WorkCenterTranslationPEOLastUpdateDate Date and time when the user last updated the work center record.
WorkCenterTranslationPEOLastUpdateLogin Session login associated with the user who last updated the work center record.
WorkCenterTranslationPEOLastUpdatedBy User who last updated the work center record.
WorkCenterTranslationPEOObjectVersionNumber 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.
WorkCenterTranslationPEOSourceLang Code of the language in which the contents of the translatable columns were originally created.
WorkCenterTranslationPEOWorkCenterDescription Description of the work center.
WorkCenterTranslationPEOWorkCenterId Value that uniquely identifies the work center. This is the primary key of the Work Center view object.
WorkCenterTranslationPEOWorkCenterName Name of the work center.