Work Order Product Serial

The Work Order Product Serial view object contains information about the serial numbers of the product item used in a serialized manufacturing work order.

Data Store Key : FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WOProductSerialExtractPVO

Primary Keys : WOProductSerialPEOWoProductSerialId

Initial Extract Date : WOProductSerialPEOCreationDate

Incremental Extract Date : WOProductSerialPEOLastUpdateDate

Attributes

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

Name	Description
WOProductSerialPEOAttributeCategory	Context name for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeChar1	Character segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeChar10	Character segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeChar11	Character segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeChar12	Character segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeChar13	Character segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeChar14	Character segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeChar15	Character segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeChar16	Character segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeChar17	Character segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeChar18	Character segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeChar19	Character segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeChar2	Character segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeChar20	Character segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeChar3	Character segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeChar4	Character segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeChar5	Character segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeChar6	Character segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeChar7	Character segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeChar8	Character segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeChar9	Character segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeDate1	Date segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeDate2	Date segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeDate3	Date segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeDate4	Date segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeDate5	Date segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeNumber1	Number segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeNumber10	Number segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeNumber2	Number segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeNumber3	Number segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeNumber4	Number segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeNumber5	Number segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeNumber6	Number segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeNumber7	Number segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeNumber8	Number segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeNumber9	Number segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeTimestamp1	Date and Time segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeTimestamp2	Date and Time segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeTimestamp3	Date and Time segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeTimestamp4	Date and Time segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOAttributeTimestamp5	Date and Time segment for the Work Order Product Serial descriptive flexfield.
WOProductSerialPEOCreatedBy	User who created the work order product serial record.
WOProductSerialPEOCreationDate	Date and time when the work order product serial record was created.
WOProductSerialPEOExecutionSequence	Identifies the execution sequence number of the operation where the serial is last completed for a resequence work order.
WOProductSerialPEOInventoryItemId	Value that uniquely identifies the product item in the work order product serial.
WOProductSerialPEOJobDefinitionName	Indicates the name of the job that created or last updated the row. This is populated through Enterprise Service Scheduler.
WOProductSerialPEOJobDefinitionPackage	Indicates the package name of the job that created or last updated the row. This is populated through Enterprise Service Scheduler.
WOProductSerialPEOLastUpdateDate	Date and time when the user last updated the work order product serial record.
WOProductSerialPEOLastUpdateLogin	Session login associated with the user who last updated the work order product serial record.
WOProductSerialPEOLastUpdatedBy	User who last updated the work order product serial record.
WOProductSerialPEOObjectVersionNumber	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.
WOProductSerialPEOOperationSeqNumber	Sequence number of the work order operations.
WOProductSerialPEOOrganizationId	Value that uniquely identifies the manufacturing plant to which this work order product serial belongs.
WOProductSerialPEORequestId	Indicates the request ID of the job that created or last updated the row. This is populated through Enterprise Service Scheduler.
WOProductSerialPEOSerialNumber	Represents the predefined serial numbers that are tied to the product item of the work order.
WOProductSerialPEOSerialStatus	Indicates an internal work execution status for the serial number. A list of accepted values is defined in the lookup type. ORA_WIE_SERIAL_STATUS.
WOProductSerialPEOWoOperationId	Value that uniquely identifies the work order operation in the Work Order Product Serial view object. This is a foreign key to the Work Order Operation view object.
WOProductSerialPEOWoOperationMaterialId	Value that uniquely identifies the work order operation material in the Work Order Product Serial view object. This is a foreign key to the Work Order Operation Material view object.
WOProductSerialPEOWoProductSerialId	Value that uniquely identifies the work order product serial. This is the primary key of the Work Order Product Serial view object.
WOProductSerialPEOWorkOrderId	Value that uniquely identifies the work order in the Work Order Product Serial view object. This is a foreign key to the Work Order view object.