Work Definition Version
The Work Definition Version view object contains information about work definition attributes that are valid for the version, as identified by its Effective From and Effective To dates.
Data Store Key : FscmTopModelAM.ScmExtractAM.WisBiccExtractAM.WDVersionExtractPVO
Primary Keys : WorkDefinitionVersionId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| ApprovalStatusCode | Indicates the status of the work definition version. A list of accepted values is defined in the lookup type ORA_WIS_WD_VERSION_STATUS. |
| AttributeCategory | Context name for the Work Definition Version descriptive flexfield. |
| AttributeChar1 | Character segment for the Work Definition Version descriptive flexfield. |
| AttributeChar10 | Character segment for the Work Definition Version descriptive flexfield. |
| AttributeChar11 | Character segment for the Work Definition Version descriptive flexfield. |
| AttributeChar12 | Character segment for the Work Definition Version descriptive flexfield. |
| AttributeChar13 | Character segment for the Work Definition Version descriptive flexfield. |
| AttributeChar14 | Character segment for the Work Definition Version descriptive flexfield. |
| AttributeChar15 | Character segment for the Work Definition Version descriptive flexfield. |
| AttributeChar16 | Character segment for the Work Definition Version descriptive flexfield. |
| AttributeChar17 | Character segment for the Work Definition Version descriptive flexfield. |
| AttributeChar18 | Character segment for the Work Definition Version descriptive flexfield. |
| AttributeChar19 | Character segment for the Work Definition Version descriptive flexfield. |
| AttributeChar2 | Character segment for the Work Definition Version descriptive flexfield. |
| AttributeChar20 | Character segment for the Work Definition Version descriptive flexfield. |
| AttributeChar3 | Character segment for the Work Definition Version descriptive flexfield. |
| AttributeChar4 | Character segment for the Work Definition Version descriptive flexfield. |
| AttributeChar5 | Character segment for the Work Definition Version descriptive flexfield. |
| AttributeChar6 | Character segment for the Work Definition Version descriptive flexfield. |
| AttributeChar7 | Character segment for the Work Definition Version descriptive flexfield. |
| AttributeChar8 | Character segment for the Work Definition Version descriptive flexfield. |
| AttributeChar9 | Character segment for the Work Definition Version descriptive flexfield. |
| AttributeDate1 | Date segment for the Work Definition Version descriptive flexfield. |
| AttributeDate2 | Date segment for the Work Definition Version descriptive flexfield. |
| AttributeDate3 | Date segment for the Work Definition Version descriptive flexfield. |
| AttributeDate4 | Date segment for the Work Definition Version descriptive flexfield. |
| AttributeDate5 | Date segment for the Work Definition Version descriptive flexfield. |
| AttributeNumber1 | Number segment for the Work Definition Version descriptive flexfield. |
| AttributeNumber10 | Number segment for the Work Definition Version descriptive flexfield. |
| AttributeNumber2 | Number segment for the Work Definition Version descriptive flexfield. |
| AttributeNumber3 | Number segment for the Work Definition Version descriptive flexfield. |
| AttributeNumber4 | Number segment for the Work Definition Version descriptive flexfield. |
| AttributeNumber5 | Number segment for the Work Definition Version descriptive flexfield. |
| AttributeNumber6 | Number segment for the Work Definition Version descriptive flexfield. |
| AttributeNumber7 | Number segment for the Work Definition Version descriptive flexfield. |
| AttributeNumber8 | Number segment for the Work Definition Version descriptive flexfield. |
| AttributeNumber9 | Number segment for the Work Definition Version descriptive flexfield. |
| AttributeTimestamp1 | Date and Time segment for the Work Definition Version descriptive flexfield. |
| AttributeTimestamp2 | Date and Time segment for the Work Definition Version descriptive flexfield. |
| AttributeTimestamp3 | Date and Time segment for the Work Definition Version descriptive flexfield. |
| AttributeTimestamp4 | Date and Time segment for the Work Definition Version descriptive flexfield. |
| AttributeTimestamp5 | Date and Time segment for the Work Definition Version descriptive flexfield. |
| CompletionLocatorId | Value that uniquely identifies the default locator the product is completed into. |
| CompletionSubinventoryName | Default subinventory in which the product is stored after product completion. |
| CostingBatchOutputSize | Assumed batch size used for the purposes of cost planning and simulation. For discrete manufacturing, it's defaulted from the Standard Lot Size, if defined for the work definition item. If not, Costing considers the value of 1. |
| CreatedBy | User who created the work definition version record. |
| CreationDate | Date when the work definition version record was created. |
| EffectiveFromDate | Date and time from when this work definition version is effective. |
| EffectiveToDate | Date and time from when this work definition version is no longer effective. |
| LastUpdateDate | Date and time when the user last updated the work definition version record. |
| LastUpdateLogin | Session login associated with the user who last updated the work definition version record. |
| LastUpdatedBy | User who last updated the work definition version record. |
| ObjectVersionNumber | 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. |
| OrganizationId | Value that uniquely identifies the manufacturing plant to which this work definition version belongs. |
| VersionNumber | Alphanumeric value that identifies the version of the work definition. |
| WorkDefinitionId | Value that uniquely identifies the work definition in the Work Definition Version view object. This is a foreign key to the Work Definition view object. |
| WorkDefinitionVersionId | Value that uniquely identifies the work definition version. This is the primary key of the Work Definition Version view object. |