Genealogy Where Used Aggregate

The Genealogy Where Used Aggregates view object is used to generate data such as material transactions for the Genealogy Where Used subject area.

Data Store Key : FscmTopModelAM.ScmExtractAM.CseBiccExtractAM.GenealogyWhereUsedExtractPVO

Primary Keys : ParentGenObjectId, ChildGenObjectId, RelationshipTypeCode

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
ChildGenObjectId	Value that identifies the child genealogy object recorded in the genealogy where used view objects.
ChildItemId	Value that identifies the item belonging to the child genealogy where used view object.
ChildLotNumber	Value that identifies the lot number corresponding to the child genealogy where used view object.
ChildOrganizationId	Value that identifies the organization corresponding to the child genealogy where used view object.
ChildOrigDate	Value that identifies the origination date corresponding to the child genealogy where used view object.
ChildOrigDocNumber	Value that identifies the origination document number corresponding to the child genealogy where used view object.
ChildOrigDocType	Value that identifies the origination document type corresponding to the child genealogy where used view object.
ChildOrigQuantity	Value that identifies the origination quantity corresponding to the child genealogy where used view object.
ChildSerialNumber	Value that identifies the serial number corresponding to the child genealogy where used view object.
CreatedBy	User who created the asset genealogy where used record.
CreationDate	Date and time when the user created the genealogy where used record.
LastUpdateDate	Date and time when the user most recently updated the genealogy where used record.
LastUpdateLogin	Session login associated with the user who most recently updated the genealogy where used record.
LastUpdatedBy	User who most recently updated the genealogy where used record.
LeafChildGenObjectId	Value that identifies the leaf child genealogy object in the hierarchy of genealogy where used objects .
LeafChildItemId	Value that identifies the item corresponding to the leaf child genealogy where used object.
LeafChildLotNumber	Value that identifies the lot number corresponding to the leaf child genealogy where used object.
LeafChildOrganizationId	Value that identifies the organization corresponding to the leaf child genealogy where used object.
LeafChildOrigDate	Value that identifies the origination date corresponding to the leaf child genealogy where used object.
LeafChildOrigDocNumber	Value that identifies the origination document number corresponding to the leaf child genealogy where used object.
LeafChildOrigDocType	Value that identifies the origination document type corresponding to the leaf child genealogy where used object.
LeafChildOrigQuantity	Value that identifies the origination quantity corresponding to the leaf child genealogy where used object.
LeafChildSerialNumber	Value that identifies the serial number corresponding to the leaf child genealogy where used object.
ParentGenObjectId	Value that identifies the parent genealogy object in the hierarchy of genealogy where used objects.
ParentItemId	Value the identifies the item corresponding to the parent genealogy where used object.
ParentLevel	Value that identifies the level at which the parent is located on the hierarchy of the genealogy where used object.
ParentLotNumber	Value that identifies the lot number corresponding to the parent genealogy where used view object.
ParentOrganizationId	Value that identifies the organization corresponding to the parent genealogy where used view object.
ParentOrigDate	Value that identifies the origination date corresponding to the parent genealogy where used view object.
ParentOrigDocNumber	Value that identifies the origination document number corresponding to the parent genealogy where used view object.
ParentOrigDocType	Value that identifies the origination document type corresponding to the parent genealogy where used view object.
ParentOrigQuantity	Value that identifies the origination quantity corresponding to the parent genealogy where used view object.
ParentSerialNumber	Value that identifies the serial number corresponding to the parent genealogy where used view object.
RelationshipTypeCode	Value the set the relationship type code that's established between the parent and child genealogy where used objects.