Route Association Attributes

The Route Associations Attributes view object provides information about the required attributes of all the business entities of the new item request definition setup and workflow.

Data Store Key : FscmTopModelAM.ScmExtractAM.EgoBiccExtractAM.RouteAssocAttrsExtractPVO

Primary Keys : RouteAssocAttrsPEORouteAttrId

Initial Extract Date :

Incremental Extract Date :

Attributes

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

Name Description
RouteAssocAttrsPEOAttrGroupInternalName Internal name of the attribute group associated with the new item request definition step.
RouteAssocAttrsPEOAttrInternalName Internal name of an attribute within the attribute group associated to the new item request definition step.
RouteAssocAttrsPEOAttrType Attribute type that's associated with the new item request definition setup and workflow. Values are EGO_ITEM or EGO_ITEM_EFF.
RouteAssocAttrsPEOCreatedBy User who created the row.
RouteAssocAttrsPEOCreationDate Date and time of the creation of the row.
RouteAssocAttrsPEOInheritedFlag Value that identifies whether the attribute is inherited or not. Contains one of the following values: Y and N.
RouteAssocAttrsPEOLastUpdateDate Date and time when the row was last updated.
RouteAssocAttrsPEOLastUpdateLogin Session login details associated to the user who last updated the row.
RouteAssocAttrsPEOLastUpdatedBy User who last updated the row.
RouteAssocAttrsPEOObjectName Object name to which this association attribute belongs. Contains one of the following values: EGO_NEW_ITEM or EGO_CATALOG_GROUP.
RouteAssocAttrsPEOObjectPk1 Value that identifies the item or the item class based on the object name, with the object name being either EGO_NEW_ITEM or EGO_CATALOG_GROUP.
RouteAssocAttrsPEOObjectPk2 Value that identifies data from other tables.
RouteAssocAttrsPEOObjectPk3 Value that identifies data from other tables.
RouteAssocAttrsPEOObjectPk4 Value that identifies data from other tables.
RouteAssocAttrsPEOObjectPk5 Value that identifies data from other tables.
RouteAssocAttrsPEOObjectVersionNumber 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.
RouteAssocAttrsPEORouteAssocId Value that uniquely identifies the route association to which this attribute belongs. This is the foreign key to the Route Associations view object.
RouteAssocAttrsPEORouteAttrId Value that uniquely identifies the defined association attributes. This is the primary key of the Route Association Attributes view object.