JDBC Driver for Oracle SCM

Build 22.0.8462

ItemStructuresComponentWhereUsed

The Where Used for Item Structures resource gets the items in which this structure is used.

Columns

Name Type Description
ItemStructuresBillSequenceId String ItemStructuresBillSequenceId of ItemStructuresComponentWhereUsed
ComponentComponentSequenceId String ComponentComponentSequenceId of ItemStructuresComponentWhereUsed
OrganizationCode String A name of an organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting.
ParentItemNumber String An attribute for the parent of an identifier for a part, material, product or service that is unique as compared with other items by the nature of its attributes.
StructureName String An attribute which value represents the name of a structure.
ParentBillSequenceId String A unique identifier for parent structure.
TopItemFlag Bool A flag that identifies the root item for the explosion of the structure.
EffectivityControlValue String An attribute which value indicates the way effectively is controlled within a structure. The values include Date, Unit Number, or Serial Number.
ComponentPath String An attribute value that represents the hierarchical Path of a component item to the root item in a structure.
ComponentItemNumber String An attribute value that represents the item number of a component.
ComponentItemDescription String An attribute value that represents the item description of a component.
ComponentBillSequenceId String A unique identifier of the parent structure.
ComponentSequenceId String A unique identifier for an Component in a structure.
Quantity String An attribute value which represent the quantity of a component in structure.
ItemClassName String An attribute that value provides metadata common to all items that share the category.
ItemTypeValue String An attribute that indicates a grouping of all items of a particular category that share the same set of item attributes, used as a high-level grouping for processes. For example, each account generator item type (such as FA account generator) contains a group of processes for determining how an accounting flexfield code combination is created.
ItemStatusValue String An attribute that defines codes used to control the transaction activity of an item. For example, an item in active status can be customer order enabled.
BasisValue String An attribute value that indicates how the component quantity is consumed in an assembly. The values include item and lot.
FromSerialNumber String Starting Item serial number that a component is effective in a structure. Valid only for serial effective structures.
ToSerialNumber String An attribute value which represents the serial number at the beginning of the end item (or root item) serial number range during which a given record is available.
FromUnitNumber String Starting Item Unit Number or starting Item Serial Number that a component is effective in a structure. Valid only for unit effective structures.
ToUnitNumber String An attribute value which represents the Unit number at the beginning of the end item (or root item) unit number range during which a given record is available.
StartDateTime Datetime The date and time on which a component in a structure begins.
EndDateTime Datetime The date and time on which a component in a structure ends.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462