JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

InstalledBaseAssetspartsListComponents

InstalledBaseAssetspartsListComponents

Columns

Name Type Description
InstalledBaseAssetsAssetId [KEY] Long InstalledBaseAssetsAssetId of InstalledBaseAssetspartsListComponents
ItemOrganizationId Long Value that uniquely identifies the organization to which the part list item is assigned to. This is a required attribute.
AssetId Long AssetId of InstalledBaseAssetspartsListComponents
ComponentQuantity Double Quantity of each part list component for the asset.
ItemId Long Value that uniquely identifies the item that is part of the part list for the asset. Asset item cannot be part of the part list for the same asset.
ListComponentId [KEY] Long Value that uniquely identifies the parts list item that the asset references.
ItemNumber String Number that uniquely identifies the item that is part of the part list for the asset. An asset item cannot be part of the part list for the same asset.
SecondaryQuantity Double Secondary quantity of product that the asset references. If item is not defined as dual UOM item or if conversion for the secondary UOM is set to fix, this quantity is not required. If dual UOM conversion is set to default, this quantity will override the defaulted quantity. If conversion is no default, this quantity is required. Secondary UOM is defaulted from setup.
SecondaryUOMCode String Abbreviation that identifies the asset secondary quantity unit of measure. The secondary unit of measure is not required to create an asset. If provided it must be the same than the asset item secondary unit of measure. If not provided the value is defaulted from the asset item secondary unit of measure.

Pseudo-Columns

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

Name Type Description
Finder String finder

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839