JDBC Driver for Oracle SCM

Build 22.0.8462

ItemsLOV

The Items List of Values resource gets the object that can be transacted, such as a physical product or a service offering.

Columns

Name Type Description
OrganizationId String Value that uniquely identifies the organization. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task.
ItemId String Value that uniquely identifies the part, item, product, or service.
ItemClassId String Value that uniquely identifies the item class.
OrganizationCode String Abbreviation that identifies the organization. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task.
ItemClass String Name of the item class. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Classes task.
ItemNumber String Name or number of the part, item, product, or service.
ItemDescription String Description of the part, item, product, or service.
PrimaryUOMCode String Abbreviation that identifies the unit of measure that is used to determine pricing for an item. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Unit of Measures task.
InventoryItemStatusCode String Abbreviation that identifies the item status. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Statuses task.
CurrentPhaseCode String Abbreviation that identifies the lifecycle phase of the item. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Lifecycle Phases task.
ItemType String Type of the item. A list of accepted values is defined in the lookup type EGP_ITEM_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
ApprovalStatus String Approval status of the item. A list of accepted values is defined in the lookup type EGP_APPROVAL_STATUS. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
ItemDefinitionOrgId String Value that uniquely identifies the definition organization associated with the item.
CreationDate Datetime Date when the user created the item.
LastUpdateDate Datetime Date and time when the user most recently updated the item.
Keyword String Value that represents a string of characters used for searching using keywords.
PlanningMethodValue String Value that indicates the type of planning that will be used for the item. A list of accepted values is defined in the lookup type EGP_MATERIAL_PLANNING. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is Not Planned. For a list of attribute value interdependencies, refer to Interdependent Item Attributes.
BackToBackEnabledFlag Bool Contains one of the following values: true or false. If true, then enable the item for back-to-back ordering. If false, then do not enable the item for back-to-back ordering. The default value is false. For a list of attribute value interdependencies, refer to Interdependent Item Attributes.
SerialGenerationValue String Value that indicates the number assigned to each unit of an item and is used to track the item. A list of accepted values is defined in the lookup type EGP_SERIAL_NUMBER_CONTROL_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is 1. For a list of attribute value interdependencies, refer to Interdependent Item Attributes.
UserItemTypeValue String Type of the item. A list of accepted values is defined in the lookup type EGP_ITEM_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task.
ItemStatusValue String Value that identifies the item status. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Statuses task.

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