JDBC Driver for Oracle SCM

Build 22.0.8462

ProductChangeOrdersV2changeOrderAffectedObjectchangeOrderAffectedItemAML

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

Columns

Name Type Description
ProductChangeOrdersV2ChangeId String Finds product change order by change ID.
ChangeorderaffectedobjectChangeLineId String Find change order affected object by change line ID.
ChangeLineId String Value that uniquely identifies the change line associated with the component.
CreatedBy String User who created the change object.
Description String Description of the change object.
InventoryItemId String The inventory affected item ID of an affected item AML.
ItemRelationshipId String The item relationship ID of an affected item AML.
LastUpdateLogin String Login that the user used when updating the affected item AML in the change order.
LastUpdatedBy String User who most recently updated the change object.
OrganizationId String Value that uniquely identifies the organization of the change object.
StatusCode String Abbreviation that identifies the status of the change object.
ACDTypeCode String Value that indicates whether the component is being added, changed, or deleted through a change line.
TradingPartnerItemId String The trading partner item ID of an affected item AML.
TradingPartnerName String The trading partner name of an affected item AML.
TradingPartnerItem String The trading partner item number of an affected item AML.
ItemNumber String Number that identifies the item corresponding to the component.
OrganizationCode String Abbreviation that identifies the organization of the change object.
StatusCodeValue String Status code value of the change object
ACDTypeValue String Value that indicates whether the component is being added, changed, or deleted through a change line.
CreationDateTime Datetime Date when the change object was created.
ActiveEndDateTime Datetime The end date of an active AML.
ImplementationDateTime Datetime Date when this affected item AML in the change order was implemented.
LastUpdateDateTime Datetime Date when the change object was updated.
ActiveStartDateTime Datetime The start date of an affected item AML.

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