CData Python Connector for Oracle Fusion Cloud SCM

Build 25.0.9454

InstalledBaseAssetspartsListComponents

Tracks components of an asset's parts list for maintenance and inventory control.

Columns

Name Type Description
InstalledBaseAssetsAssetId [KEY] Long The unique identifier for the asset in the InstalledBaseAssets table. This value links the parts list component to a specific asset.
ItemOrganizationId Long The unique identifier for the organization to which the part list item is assigned. This is a required attribute to ensure proper inventory management and organization of parts.
AssetId Long The unique identifier for the asset that the part list component is associated with. This attribute links the part to a specific asset in the system.
ComponentQuantity Decimal The quantity of each part in the part list that is required for the asset. This specifies how many units of the part are needed to complete the asset configuration.
ItemId Long The unique identifier for the item that is part of the asset's part list. This value represents a specific item in the inventory that is associated with the asset.
ListComponentId [KEY] Long The unique identifier for the part list item. This is used to reference a specific component in the asset's part list, ensuring that the right parts are assigned to the asset.
ItemNumber String The number that uniquely identifies the item within the part list for the asset. This number helps in identifying specific components and ensures that the correct item is referenced in the part list.
SecondaryQuantity Decimal The secondary quantity of the product referenced by the asset. This is used when dual unit of measure (UOM) is configured, allowing for additional measurement or conversion of the product quantity.
SecondaryUOMCode String The unit of measure code for the secondary quantity of the part. This field is used to track and convert quantities if the item uses a secondary UOM. It must match the UOM set up for the item.
Finder String The finder associated with the parts list component. This is used for searching and retrieving specific part list items based on criteria in the system.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454