Work Order Status

The Work Order Status view object contains information about the seeded and user defined statuses that are used in the work order.

Data Store Key : FscmTopModelAM.ScmExtractAM.WieBiccExtractAM.WOStatusExtractPVO

Primary Keys : WOStatusPEOWoStatusId

Initial Extract Date : WOStatusPEOCreationDate

Incremental Extract Date : WOStatusPEOLastUpdateDate

Attributes

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

Name Description
WOStatusPEOAttributeCategory Context name for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeChar1 Character segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeChar10 Character segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeChar11 Character segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeChar12 Character segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeChar13 Character segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeChar14 Character segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeChar15 Character segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeChar16 Character segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeChar17 Character segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeChar18 Character segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeChar19 Character segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeChar2 Character segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeChar20 Character segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeChar3 Character segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeChar4 Character segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeChar5 Character segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeChar6 Character segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeChar7 Character segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeChar8 Character segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeChar9 Character segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeDate1 Date segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeDate2 Date segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeDate3 Date segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeDate4 Date segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeDate5 Date segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeNumber1 Number segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeNumber10 Number segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeNumber2 Number segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeNumber3 Number segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeNumber4 Number segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeNumber5 Number segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeNumber6 Number segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeNumber7 Number segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeNumber8 Number segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeNumber9 Number segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeTimestamp1 Date and Time segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeTimestamp2 Date and Time segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeTimestamp3 Date and Time segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeTimestamp4 Date and Time segment for the Work Order Status descriptive flexfield.
WOStatusPEOAttributeTimestamp5 Date and Time segment for the Work Order Status descriptive flexfield.
WOStatusPEOCreatedBy User who created the work order status record.
WOStatusPEOCreationDate Date and time when the work order status record was created.
WOStatusPEOInactiveDate Date when the work order status becomes inactive.
WOStatusPEOLanguage Code of the language into which the contents of the translatable columns are translated.
WOStatusPEOLastUpdateDate Date and time when the user last updated the work order status record.
WOStatusPEOLastUpdateLogin Session login associated with the user who last updated the work order status record.
WOStatusPEOLastUpdatedBy User who last updated the work order status record.
WOStatusPEOObjectVersionNumber Number of times the object row was updated. This attribute is used to implement optimistic locking. This number is incremented every time that 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.
WOStatusPEOSeededFlag Indicates if the status record is seeded.
WOStatusPEOWoStatusCode Code that identifies the work order status.
WOStatusPEOWoStatusId Value that uniquely identifies the work order status. This is the primary key of the Work Order Status view object.
WOStatusPEOWoSystemStatusCode Code that identifies the system status of the work order.
WOStatusTLPEOCreatedBy User who created the work order status record.
WOStatusTLPEOCreationDate Date and time when the user created the work order status record.
WOStatusTLPEOLanguage Code of the language into which the contents of the translatable columns are translated.
WOStatusTLPEOLastUpdateDate Date and time when the user last updated the work order status record.
WOStatusTLPEOLastUpdateLogin Session login associated with the user who last updated the work order status record.
WOStatusTLPEOLastUpdatedBy User who last updated the work order status record.
WOStatusTLPEOObjectVersionNumber Number of times the object row was updated. This attribute is used to implement optimistic locking. This number is incremented every time that 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.
WOStatusTLPEOSourceLang Code of the language in which the contents of the translatable columns were originally created.
WOStatusTLPEOWoStatusDescription Description of the work order status.
WOStatusTLPEOWoStatusId Value that uniquely identifies the work order status. This is the primary key of the Work Order Status view object.
WOStatusTLPEOWoStatusName Name of the work order status.