JDBC Driver for Oracle SCM

Build 22.0.8462

NewItemRequestsnewItemRequestAffectedItems

The New Item Request Affected Items resource contains details of the items in the new item request.

Columns

Name Type Description
NewItemRequestsNewItemRequestId String NewItemRequestsNewItemRequestId of NewItemRequestsnewItemRequestAffectedItems
ItemNumber String An attribute that is an identifier for a part, material, product or service that is unique as compared with other items by the nature of its attributes.
ItemClassCode String Item class code.
Description String An attribute value that describes the item.
CreatedBy String The user who created the new item line.
CreationDate Datetime The date when the new item line was created.
LastUpdateDate Datetime The date when the new item line was last updated.
LastUpdatedBy String The user who last updated the record.
ItemClass String An attribute value that provides metadata common to all items that share the category.
ItemStatus String The current status of the item.
LineStatus String New item line status.
NewItemRequestLineId String Line ID of the new item request.
ItemStatusCode String Item status code.
LineStatusCode String New item line status code.
ItemRevisionId String Value that uniquely identifies the item revision.
ItemId String A unique identifier for a part, material, product or service that is unique as compared with other items by the nature of its attributes.
EffectiveDate Datetime Effective date of the new item line.
NewItemRequestId String NewItemRequestId of NewItemRequestsnewItemRequestAffectedItems
ItemRevision String Revision of the item.
NewItemRequestNumber String NewItemRequestNumber of NewItemRequestsnewItemRequestAffectedItems

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