JDBC Driver for Oracle SCM

Build 22.0.8462

ProductChangeOrdersV2changeOrderAffectedObjectchangeOrderAffectedItemStructureaffectedItemStructureComponent

The Structure Components resource gets the components in a structure of an affected item.

Columns

Name Type Description
ProductChangeOrdersV2ChangeId String Finds product change order by change ID.
ChangeorderaffectedobjectChangeLineId String Find change order affected object by change line ID.
ChangeorderaffecteditemstructureBillSequenceId String Finds the change order affected item structure by bill sequence ID.
ComponentQuantity String Quantity value of the component that is used to build the structure.
ComponentYieldFactor String Planned or actual output of a process, relevant to the quantity. The yield includes a loss, an increase, or no change in the planned or actual output quantity of affected item structure component
ComponentRemarks String Comments entered by the user for the affected item structure component.
OldComponentSequenceId String Replaced component sequence ID in the affected item structure
ComponentSequenceId String Value that uniquely identifies the component that is currently in the affected item structure component
BillSequenceId String Value that uniquely identifies the structure associated with the item.
ChangeId String Value that uniquely identifies the change affected item structure component
ChangeLineId String Value that uniquely identifies the change line associated with the affected item structure component.
PrimaryUomCode String Value that indicates the unit of measure of the affected item structure component as used in a bill of materials.
ACDTypeCode Long Abbreviation that indicates whether the component is being added, changed, or deleted through a change line.
ComponentItemId String Value that uniquely identifies the item associated with the component.
OrganizationId String Value that uniquely identifies the organization of the change object.
AlternateBOMDesignator String Value that identifies the alternate bill of material designator of the item.
OrganizationCode String Abbreviation that identifies the organization of the change object.
ChangeNotice String Value that uniquely identifies the change object.
ComponentItemClass String Class of the component item. This attribute is read-only and is not required for an update operation.
QuantityRelatedFlag Bool Quantity of the redline substitute component
ItemSequenceNumber String The component item sequence number of the structure component
ComponentItemNumber String The component item number of the structure component
PrimaryUOMValue String Primary UOM value of a structure component
LastUpdateDateTime Datetime Date when affected item structure component was last updated
CreationDateTime Datetime Date when the affected item structure component was added to the change object.
EffectivityDateTime Datetime Date when the affected item structure component became effective to be used in the structure.
ImplementationDateTime Datetime Date when the affected item structure component was implemented via change order
DisableDateTime Datetime Date when the component was disabled or redline component
Replaces String Value that identifies the name of the item that was replaced by another item.
ReplacedBy String Value that identifies the name of the item that replaced another item.

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