Workstations

The Workstations view object contains locations assigned to operators to perform their job in a manufacturing plant. A workstation could be a device or a workbench.

Data Store Key : FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.WorkstationExtractPVO

Primary Keys : WorkstationId

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 workstation record.
CreationDate Date and time when the user created the workstation record.
LastUpdateDate Date and time when the user most recently updated the workstation record.
LastUpdateLogin Session login associated with the user who most recently updated the workstation record.
LastUpdatedBy User who most recently updated the workstation 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 inventory organization. It's a primary key that the application generates when it creates an inventory organization.
WorkCenterId Value that uniquely identifies the parent work center. It's a primary key that the application generates when it creates a work center.
WorkstationCode Abbreviation that identifies the parent work center.
WorkstationDescription Description of the workstation.
WorkstationId Value that uniquely identifies the workstation. It's a primary key that the application generates when it creates a workstation.
WorkstationName Name of the workstation.