Work Order Operation Material Serial

The Work Order Operation Material Serial view object contains information about the serials for reworked assembly item.

Data Store Key : FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WOOperationMaterialSerialExtractPVO

Primary Keys : WOOpMatSerialPEOWoOpMaterialSerialId

Initial Extract Date : WOOpMatSerialPEOCreationDate

Incremental Extract Date : WOOpMatSerialPEOLastUpdateDate

Attributes

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

Name Description
WOOpMatSerialPEOAttributeCategory Context name for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeChar1 Character segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeChar10 Character segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeChar11 Character segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeChar12 Character segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeChar13 Character segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeChar14 Character segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeChar15 Character segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeChar16 Character segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeChar17 Character segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeChar18 Character segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeChar19 Character segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeChar2 Character segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeChar20 Character segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeChar3 Character segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeChar4 Character segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeChar5 Character segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeChar6 Character segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeChar7 Character segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeChar8 Character segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeChar9 Character segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeDate1 Date segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeDate2 Date segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeDate3 Date segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeDate4 Date segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeDate5 Date segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeNumber1 Number segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeNumber10 Number segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeNumber2 Number segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeNumber3 Number segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeNumber4 Number segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeNumber5 Number segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeNumber6 Number segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeNumber7 Number segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeNumber8 Number segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeNumber9 Number segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeTimestamp1 Date and Time segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeTimestamp2 Date and Time segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeTimestamp3 Date and Time segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeTimestamp4 Date and Time segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOAttributeTimestamp5 Date and Time segment for the Work Order Operation Material Serial descriptive flexfield.
WOOpMatSerialPEOCreatedBy User who created the work order operation material serial record.
WOOpMatSerialPEOCreationDate Date and time when the user created the work order operation material serial record.
WOOpMatSerialPEOInventoryItemId Value that uniquely identifies the reworked assembly item in the work order operation material serial.
WOOpMatSerialPEOJobDefinitionName This is populated via Enterprise Service Scheduler. It indicates the name of the job that created or last updated the row.
WOOpMatSerialPEOJobDefinitionPackage This is populated via Enterprise Service Scheduler. It indicates the package name of the job that created or last updated the row.
WOOpMatSerialPEOLastUpdateDate Date and time when the user last updated the work order operation material serial record.
WOOpMatSerialPEOLastUpdateLogin Session login associated with the user who last updated the work order operation material serial record.
WOOpMatSerialPEOLastUpdatedBy User who last updated the work order operation material serial record.
WOOpMatSerialPEOObjectVersionNumber 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.
WOOpMatSerialPEOOrganizationId Value that uniquely identifies the manufacturing plant to which this work order operation material serial belongs.
WOOpMatSerialPEORequestId Indicates the request ID of the job that created or last updated the row. This is populated through Enterprise Service Scheduler.
WOOpMatSerialPEOSerialNumber Serial number that identifies the reworked assembly item.
WOOpMatSerialPEOSerialStatus Status of the serial of the reworked assembly item.
WOOpMatSerialPEOWoOpMaterialLotId Value that uniquely identifies the work order operation material lot of the reworked assembly item when it's both serial and lot controlled in the Work Order Operation Material Serial view object. This is a foreign key to the Work Order Operation Material Lot view object.
WOOpMatSerialPEOWoOpMaterialSerialId Value that uniquely identifies the work order operation material serial. This is the primary key of the Work Order Operation Material Serial view object.
WOOpMatSerialPEOWoOperationMaterialId Value that uniquely identifies the work order operation material in the Work Order Operation Material Serial view object. This is a foreign key to the Work Order Operation Material view object.
WOOpMatSerialPEOWorkOrderId Value that uniquely identifies the work order in the Work Order Operation Material Serial view object. This is a foreign key to the Work Order view object.