InstalledBaseAssetsfixedAssetAssociations
Maintains associations between installed base assets and fixed assets, including updates and terminations.
Columns
Name | Type | Description |
InstalledBaseAssetsAssetId [KEY] | Long | The unique identifier for the asset in the InstalledBaseAssets table. This attribute is used to associate the asset with a fixed asset in the InstalledBaseAssetsfixedAssetAssociations table. |
ActiveEndDate | Datetime | The date and time when the association between the installed base asset and the fixed asset becomes inactive. This marks the end of the relationship between the two assets. |
ActiveStartDate | Datetime | The date and time when the association between the installed base asset and the fixed asset becomes active. This marks the beginning of the relationship between the two assets. |
AutoTerminationFlag | String | Indicates whether the association will be automatically terminated. If true, the association is automatically deactivated; if false, it is not. The flag is set conditionally during asset updates based on certain criteria. |
FixedAssetId | Long | The unique identifier for the fixed asset in the table. This attribute establishes the link between an installed base asset and a fixed asset. |
TerminationReasonCode | String | The message code for the reason behind the auto-termination of the association, provided when the 'AutoTerminationFlag' is set to true. This code is conditionally displayed in the user interface and explains why the association was terminated. |
FixedAssetNumber | String | The unique identifier for the fixed asset, usually an asset number assigned to the fixed asset. |
AssetId | Long | The unique identifier for the asset in the InstalledBaseAssets table. This attribute is used in the InstalledBaseAssetsfixedAssetAssociations table to associate the fixed asset with an installed base asset. |
Finder | String | The finder used to search for and retrieve the asset associations based on specific criteria. |