JDBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9062

InstalledBaseAssetspartsListComponents

The Parts resource manages the asset parts list used for maintaining the asset. You can add, remove, and view the list of the asset part components.

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 Decimal 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 Decimal 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.
Finder String Finder of InstalledBaseAssetspartsListComponents

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