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. |