JDBC Driver for Oracle SCM

Build 22.0.8462

ProductChangeOrdersV2changeOrderAffectedObjectchangeOrderAffectedItem

The Affected Items resource gets the items in the 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.
ItemId String The item identifier value of the change order affected item.
ItemClass String The Item class value of the change order affected item
ItemNumber String Number that identifies the item corresponding to the component.
ItemDescription String The Item description value of the change order affected item
ApprovalStatus String The approval status of the affected item in the change order.
ApprovalStatusValue String Value that indicates the approval status of the change object. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Change Order Types task.
InventoryItemStatusCode String Inventory Item Status Code of a change affected item.
ItemStatusValue String The Item status value of the change order affected item
CurrentPhaseCode String The Current phase code value of the change order affected item
LifecyclePhaseValue String The Lifecycle phase value of the change order affected item
ItemType String The Item type value of the change order affected item
UserItemTypeValue String User Item Type value for change order affected item.
PrimaryUOMCode String Value that indicates the unit of measure of the component as used in a bill of materials.
PrimaryUOMValue String The Primary UOM value of the change order affected item
EligibilityRuleFlag Bool Value that indicates the eligibility rule for the change order affected item.
SalesProductTypeValue String Value that indicates the sales product type for the change order affected item.
QuantityReceivedTolerancePercentage String Value that indicates the tolerance percentage of the quantity received for the change order affected item.
ChangeLineId String Value that uniquely identifies the change line associated with the component.
ForcePurchaseLeadTimeFlag Bool Value that indicates the force purchase lead time for the change order affected item.
ReplacementTypeValue String Value that indicates the replacement type for the change order affected item.
BuyerEmailAddress String The Buyer email address value of the change order affected item
AssetTrackedValue String The Asset tracked value of the change order affected item
CreatedBy String User who created the change object.
CreationDateTime Datetime Date and time when the reference designator was created.
LastUpdateDateTime Datetime Date and time when the reference designator was most recently updated.
LastUpdateLogin String Login that the user used when updating the affected item in the change order .
LastUpdatedBy String User who most recently updated the change object.
CommsActivationRequiredFlag Bool The COMMS activation required check box value of the change order affected item.
RequiresFulfillmentLocationFlag Bool The check box value of the requires fulfillment location of the change order affected item.
IssueUOMValue String The Issue UOM value of the change order affected item
EnforceShipToLocationValue String The Enforce ship to location value of the change order affected item
StandardCoverageValue String The standard coverage value of the change order affected item.
ReplenishmentSourceTypeValue String The Replenishment Source Type value of the change order affected item.
TrackingUOMValue String The Tracking UOM value of the change order affected item
SecondaryUOMValue String The secondary UOM value of the change order affected item
PricingUOMValue String The Pricing UOM value of the change order affected item
HardPeggingLevelValue String The Hard pegging value of the change order affected item
CommonSupplyProjectDemandFlag Bool The common supply project demand check box value of the change order affected item.
EnableIotFlag Bool The enable check box value of the change order affected item.
ExpenditureTypeValue String The Expenditure type value of the change order affected item
PackagingStringValue String The Packaging String value of the change order affected item
CreateSupplyAfterDate Date Create supply after date attribute of an affected item
CreateFixedAssetValue String Value that indicates the create fixed asset for the change order affected item.
UnderCompletionToleranceTypeValue String Value that indicates the under-completion tolerance type for the change order affected item.
UnderCompletionToleranceValue String Value that indicates the under-completion tolerance value of the change order affected item.
CategoryCode String The category code value of the change order affected item
ImplementationDateTime Datetime Date when the affected item on a change order was implemented.
ACDTypeCode String Value that indicates if the substitute component is being added, modified, or deleted through a change line.

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