Genealogy Composition

The Genealogy Composition view object stores the aggregated date to generated for the genealogy composition subject area.

Data Store Key : FscmTopModelAM.ScmExtractAM.CseBiccExtractAM.GenealogyCompositionExtractPVO

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 hierarchy of genealogy view objects.
ChildItemId Value that identifies the item belonging to the child genealogy view object.
ChildLevel Value that indicates the level at which the child component is located on.
ChildLotNumber Value that identifies the lot number corresponding to the child genealogy view object.
ChildOrganizationId Value that identifies the organization corresponding to the child genealogy view object.
ChildOrigDate Value that identifies the origination date corresponding to the child genealogy view object.
ChildOrigDocNumber Value that identifies the origination document number corresponding to the child genealogy view object.
ChildOrigDocType Value that identifies the origination document type corresponding to the child genealogy view object.
ChildOrigQuantity Value that identifies the origination quantity corresponding to the child genealogy view object.
ChildSerialNumber Value that identifies the serial number corresponding to the child genealogy view object.
CreatedBy User who created the asset genealogy composition record.
CreationDate Date and time when the user created the genealogy composition record.
LastUpdateDate Date and time when the user most recently updated the genealogy composition record.
LastUpdateLogin Session login associated with the user who most recently updated the genealogy composition record.
LastUpdatedBy User who most recently updated the genealogy composition record.
ParentGenObjectId Value the uniquely identifies the parent genealogy object in the hierarchy of genealogy view objects .
ParentItemId Value that uniquely identifies the item corresponding to the parent genealogy view object.
ParentLotNumber Value that identifies the lot number corresponding to the parent genealogy view object.
ParentOrganizationId Value that identifies the organization corresponding to the parent genealogy view object.
ParentOrigDate Value that identifies the origination date corresponding to the parent genealogy view object.
ParentOrigDocNumber Value that identifies the origination document number corresponding to the parent genealogy view object.
ParentOrigDocType Value that identifies the origination document type corresponding to the parent genealogy view object.
ParentOrigQuantity Value that identifies the origination quantity corresponding to the parent genealogy view object.
ParentSerialNumber Value that identifies the serial number corresponding to the parent genealogy view object.
RelationshipTypeCode Value the identifies the relationship type code that's established between the parent and child genealogy view objects
RootGenObjectId Value that uniquely identifies the root genealogy object in the hierarchy of genealogy view objects.
RootItemId Value that uniquely identifies the item corresponding to the root genealogy view object.
RootLotNumber Value that identifies the lot number corresponding to the root genealogy view object.
RootOrganizationId Value that identifies the organization corresponding to the root genealogy view object.
RootOrigDate Value that identifies the origination date corresponding to the root genealogy view object.
RootOrigDocNumber Value that identifies the origination document number corresponding to the root genealogy view object.
RootOrigDocType Value that identifies the origination document type corresponding to the root genealogy view object.
RootOrigQuantity Value that identifies the origination quantity corresponding to the root genealogy view object.
RootSerialNumber Value that identifies the serial number corresponding to the root genealogy view object.