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.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。