Work Order Asset

The Work Order Asset view object contains details of the asset linked to the work order in a maintenance plant.

Data Store Key : FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WOAssetExtractPVO

Primary Keys : WOAssetPEOWoAssetId

Initial Extract Date : WOAssetPEOCreationDate

Incremental Extract Date : WOAssetPEOLastUpdateDate

Attributes

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

Name	Description
WOAssetPEOAssetId	Value that uniquely identifies the asset number. This is a foreign key to the Asset view object.
WOAssetPEOCreatedBy	User who created the work order asset record.
WOAssetPEOCreationDate	Date and time when the user created the work order for the work order asset record.
WOAssetPEOJobDefinitionName	Indicates the name of the job that created or last updated the work order asset record. This is populated through Enterprise Service Scheduler.
WOAssetPEOJobDefinitionPackage	Indicates the package name of the job that created or last updated the work order asset record. This is populated through Enterprise Service Scheduler.
WOAssetPEOLastUpdateDate	Date and time when the user last updated the work order asset record.
WOAssetPEOLastUpdateLogin	Session login associated with the user who last updated the work order asset record.
WOAssetPEOLastUpdatedBy	User who last updated the work order asset record.
WOAssetPEOLastWoOperationId	Value that uniquely identifies the work order operation in the Work Order Asset view object. This is a foreign key to the Work Order Operation view object.
WOAssetPEOMntCompleteFlag	Indicates whether the maintenance work order operation is completed for the asset. Contains one of the following values: Y or N.
WOAssetPEOObjectVersionNumber	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.
WOAssetPEOOrganizationId	Value that uniquely identifies the inventory organization that the application has enabled for maintenance.
WOAssetPEORequestId	Indicates the request ID of the job that created or last updated work order asset record. This is populated through Enterprise Service Scheduler.
WOAssetPEOWoAssetId	Value that uniquely identifies the asset associated to a work order. This is the primary key of the Work Order Asset view object.
WOAssetPEOWorkOrderId	Value that uniquely identifies the work order for the asset. This is a foreign key to the Work Order view object.