JDBC Driver for Oracle SCM

Build 22.0.8462

ProductChangeOrdersAffectedObjectAffectedItemAML

The Affected Item AMLs resource gets the approved manufacturers of an item in a change order.

Columns

Name Type Description
ProductChangeOrdersChangeId String ProductChangeOrdersChangeId of ProductChangeOrdersAffectedObjectAffectedItemAML
AffectedobjectChangeLineId String AffectedobjectChangeLineId of ProductChangeOrdersAffectedObjectAffectedItemAML
ChangeLineId String ChangeLineId of ProductChangeOrdersAffectedObjectAffectedItemAML
CreatedBy String CreatedBy of ProductChangeOrdersAffectedObjectAffectedItemAML
CreationDate Datetime CreationDate of ProductChangeOrdersAffectedObjectAffectedItemAML
Description String Description of ProductChangeOrdersAffectedObjectAffectedItemAML
EndDateActive Datetime EndDateActive of ProductChangeOrdersAffectedObjectAffectedItemAML
ImplementationDate Datetime ImplementationDate of ProductChangeOrdersAffectedObjectAffectedItemAML
InventoryItemId String Value that uniquely identifies an item.
ItemRelationshipId String Value that uniquely identifies the relationship between an item and a manufacturer part.
ItemRelationshipType String ItemRelationshipType of ProductChangeOrdersAffectedObjectAffectedItemAML
LastUpdateDate Datetime LastUpdateDate of ProductChangeOrdersAffectedObjectAffectedItemAML
LastUpdateLogin String LastUpdateLogin of ProductChangeOrdersAffectedObjectAffectedItemAML
LastUpdatedBy String LastUpdatedBy of ProductChangeOrdersAffectedObjectAffectedItemAML
MasterOrganizationId String Value that uniquely identifies the master organization of the relationship.
ObjectVersionNumber Int ObjectVersionNumber of ProductChangeOrdersAffectedObjectAffectedItemAML
OrganizationId String Value that uniquely identifies the organization of the relationship.
StartDateActive Datetime StartDateActive of ProductChangeOrdersAffectedObjectAffectedItemAML
StatusCode String Status of the relationship between the item and the manufacturer part. Valid values include approved, pending and obsolete. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Product Development Lookups task.
RedLineDescription String RedLineDescription of ProductChangeOrdersAffectedObjectAffectedItemAML
RedLineStatusCode String RedLineStatusCode of ProductChangeOrdersAffectedObjectAffectedItemAML
ACDTypeCode String ACDTypeCode of ProductChangeOrdersAffectedObjectAffectedItemAML
TradingPartnerItemId String Value that uniquely identifies the manufacturer part number.
TradingPartnerName String TradingPartnerName of ProductChangeOrdersAffectedObjectAffectedItemAML
TradingPartnerItem String TradingPartnerItem of ProductChangeOrdersAffectedObjectAffectedItemAML
ItemNumber String Number that identifies the item.
OrganizationCode String Abbreviation that identifies the organization of the item.

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