InstalledBaseAssetsfixedAssetAssociations
InstalledBaseAssetsfixedAssetAssociations
Columns
Name | Type | Description |
InstalledBaseAssetsAssetId [KEY] | Long | InstalledBaseAssetsAssetId of InstalledBaseAssetsfixedAssetAssociations |
ActiveEndDate | Datetime | Date and time when the association between installed base and fixed asset becomes inactive. |
ActiveStartDate | Datetime | Date and time when the association between installed base and fixed asset becomes active. |
AutoTerminationFlag | String | Contains one of the following values: true or false. If true, then the association is made inactive automatically. If false, then the association is not inactivated automatically. This attribute value is set conditionally during the updation of the asset. |
FixedAssetId | Long | Value that uniquely identifies the fixed asset. |
TerminationReasonCode | String | Contains a value when the autoTerminationFlag is set to yes. The value indicates the message code and the message text is displayed in the UI conditionally. |
FixedAssetNumber | String | Number that uniquely identifies the fixed asset. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
AssetId | Long | AssetId |
Finder | String | finder |