Installed Base Asset Structure
The Installed Base Asset Structure view object contains information about the asset hierarchy created either from bill of material or manually created by user.
Data Store Key : FscmTopModelAM.ScmExtractAM.CseBiccExtractAM.AssetStructureExtractPVO
Primary Keys : RelationshipId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| ActiveEndDate | Active end date and time when the user end dated the asset structure record. |
| ActiveStartDate | Date and time when the user created the asset structure record. |
| AttributeCategory | Context name for the asset structure descriptive flexfield. |
| AttributeChar1 | Character segment for the asset structure descriptive flexfield. |
| AttributeChar10 | Character segment for the asset structure descriptive flexfield. |
| AttributeChar11 | Character segment for the asset structure descriptive flexfield. |
| AttributeChar12 | Character segment for the asset structure descriptive flexfield. |
| AttributeChar13 | Character segment for the asset structure descriptive flexfield. |
| AttributeChar14 | Character segment for the asset structure descriptive flexfield. |
| AttributeChar15 | Character segment for the asset structure descriptive flexfield. |
| AttributeChar16 | Character segment for the asset structure descriptive flexfield. |
| AttributeChar17 | Character segment for the asset structure descriptive flexfield. |
| AttributeChar18 | Character segment for the asset structure descriptive flexfield. |
| AttributeChar19 | Character segment for the asset structure descriptive flexfield. |
| AttributeChar2 | Character segment for the asset structure descriptive flexfield. |
| AttributeChar20 | Character segment for the asset structure descriptive flexfield. |
| AttributeChar3 | Character segment for the asset structure descriptive flexfield. |
| AttributeChar4 | Character segment for the asset structure descriptive flexfield. |
| AttributeChar5 | Character segment for the asset structure descriptive flexfield. |
| AttributeChar6 | Character segment for the asset structure descriptive flexfield. |
| AttributeChar7 | Character segment for the asset structure descriptive flexfield. |
| AttributeChar8 | Character segment for the asset structure descriptive flexfield. |
| AttributeChar9 | Character segment for the asset structure descriptive flexfield. |
| AttributeDate1 | Date segment for the asset structure descriptive flexfield. |
| AttributeDate2 | Date segment for the asset structure descriptive flexfield. |
| AttributeDate3 | Date segment for the asset structure descriptive flexfield. |
| AttributeDate4 | Date segment for the asset structure descriptive flexfield. |
| AttributeDate5 | Date segment for the asset structure descriptive flexfield. |
| AttributeNumber1 | Number segment for the asset structure descriptive flexfield. |
| AttributeNumber10 | Number segment for the asset structure descriptive flexfield. |
| AttributeNumber2 | Number segment for the asset structure descriptive flexfield. |
| AttributeNumber3 | Number segment for the asset structure descriptive flexfield. |
| AttributeNumber4 | Number segment for the asset structure descriptive flexfield. |
| AttributeNumber5 | Number segment for the asset structure descriptive flexfield. |
| AttributeNumber6 | Number segment for the asset structure descriptive flexfield. |
| AttributeNumber7 | Number segment for the asset structure descriptive flexfield. |
| AttributeNumber8 | Number segment for the asset structure descriptive flexfield. |
| AttributeNumber9 | Number segment for the asset structure descriptive flexfield. |
| AttributeTimestamp1 | Date and Time segment for the asset structure descriptive flexfield. |
| AttributeTimestamp2 | Date and Time segment for the asset structure descriptive flexfield. |
| AttributeTimestamp3 | Date and Time segment for the asset structure descriptive flexfield. |
| AttributeTimestamp4 | Date and Time segment for the asset structure descriptive flexfield. |
| AttributeTimestamp5 | Date and Time segment for the asset structure descriptive flexfield. |
| CreatedBy | User who created the asset structure record. |
| CreationDate | Date and time when the user created the asset structure record. |
| JobDefinitionName | Name of the job that created or most recently updated the row for the asset structure record. This is populated through Enterprise Service Scheduler. |
| JobDefinitionPackage | Package name of the job that created or most recently updated the row for the asset structure record. This is populated through Enterprise Service Scheduler. |
| LastUpdateDate | Date and time when the user most recently updated the asset structure record. |
| LastUpdateLogin | Session login associated with the user who most recently updated the asset structure record. |
| LastUpdatedBy | User who most recently updated the asset structure record. |
| LogicalObjectId | Indicates a superlative relationship As Sold Structure is built using the subject identifier for a logical object identifier self hierarchy to present the sales view of the customer assets. This column is used purely for that purpose. |
| MergeFlag | Value of the asset structure merge reference. |
| ObjectId | This is the parent asset number reference. This is a foreign key to the Asset entity of the Installed Base Asset Structure view object. |
| ObjectType | Type of the object reference. It could be either an A for Asset or G for Genealogy Object. When the object type is A, the object_id column stores the asset_id. When the object type is G, the object_id column stores the genealogy_object_id. |
| 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. |
| PotentialFlag | Use cases in the manufacturing flow where a component of relationship is assumed based on the delayed biting point of the assembly serial number. In such cases, the component takes on a Many-to-Many relationship with multiple parent serial numbers. These relationships are marked as potential relationships with this attribute. |
| RelationshipId | Value that identifies the asset relationship. This is the primary key column for the asset structure record. |
| RelationshipTypeCode | Values that indicates the type of relationship between the parent asset or object_id and the child asset or subject_id. |
| RequestId | Request identifier of the job that created or most recently updated the row. This is populated through Enterprise Service Scheduler. |
| SplitFlag | Value that indicates the asset structure split reference. |
| SubjectId | This is the child asset reference. This is a foreign key to the Installed Base Asset Structure view object. |
| SubjectType | Value that indicates the type of the subject reference. It could be A for Asset or G for Genealogy Object. When the subject type is A, the subject_id column stores the asset_id. When the subject type is G, the subject_id column stores the genealogy_object_id. |
| TranslateFlag | Language into which the contents of the asset structure are translated. |