Oracle Fusion Cloud SCM Connector Objects (ProductLifecycleManagement Schema)

note: This feature is a Beta Service. A customer may opt to try a Beta Service in its sole discretion. Any use of the Beta Service is subject to the applicable Beta Services Terms provided at Agreements and Terms. If you have questions or feedback about this Beta Service, contact the Data 360 Connector team at datacloud-connectors-beta@salesforce.com.

Objects Supported

Name	Description
Finders	Lists finder names and their attributes for easier query generation and data retrieval.
FlexFndDffDescriptiveFlexfieldContexts	Defines and retrieves contexts for descriptive flexfields, enabling data customization and classification.
FlexFndPvsCharacterIdCharacterValues	Manages character values for specific flexfield character identifiers.
FlexFndPvsCharacterValues	Provides details about character values used in flexfields for standardized data storage.
FlexFndPvsNumberIdCharacterValues	Tracks numeric identifiers and associated values for use in flexfields.
Ideas	Tracks product or process improvement suggestions, including new product or process proposals.
IdeasAttachments	Manages attachments linked to ideas for supporting documentation.
IdeasIdeaComment	Tracks comments associated with ideas to facilitate discussion and feedback.
IdeasIdeaTeam	Manages team members authorized to collaborate on specific ideas.
IdeasIdeaVote	Records votes on ideas, tracking user sentiment as Like or Dislike.
ItemCatalogs	Manages catalog hierarchies and associated categories for product organization.
ItemCatalogsattachments	Manages files or documents attached to item catalogs, providing additional information or references.
ItemCatalogsattachmentsattachmentDFF	Handles contextual descriptive fields for attachments associated with item catalogs, enabling customized data entry.
ItemCatalogscategoryHierarchies	Defines and manages hierarchical structures for organizing item catalog categories for better navigation and classification.
ItemCatalogscategoryHierarchiescategoryHierarchies	Manages the hierarchical relationships between item catalog categories, ensuring logical structuring and grouping.
ItemCatalogsDFF	Handles descriptive flexfields specific to item catalogs, allowing for tailored data capture and representation.
ItemCatalogsfunctionalAreaAssignments	Manages mappings between catalogs and functional areas, ensuring proper assignment and access control.
ItemCatalogstranslatableAttributes	Supports the management of translatable attributes within item catalogs to accommodate multi-language requirements.
ItemCategories	Manages item categories, which define the classification and organization of items within catalogs.
ItemCategoriesattachments	Handles attachments for item categories, enabling additional references or documentation to be linked to specific categories.
ItemCategoriesattachmentsattachmentDFF	Manages descriptive flexfields for category-specific attachments to support customized metadata.
ItemCategoriesDFF	Handles contextual descriptive fields for item categories, enabling additional data storage and categorization.
ItemCategoriestranslatableAttributes	Manages translatable attributes of item categories to support global operations and localization.
ItemCategoryAssignments	Defines and manages the association between items and their assigned categories for proper classification.
ItemsV2	Manages details of items such as parts, materials, and products, including attributes that uniquely define them.
ItemsV2ItemAttachment	Handles the management of item-specific attachments, linking documents or files to individual items.
ItemsV2ItemAttachmentAttachedDocumentsDFF	Manages the descriptive fields for attachments associated with items, enabling detailed metadata capture.
ItemsV2ItemCategory	Manages the relationship between items and their assigned categories within the catalog.
ItemsV2ItemDFF	Manages contextual descriptive flexfields specific to items, allowing for tailored attribute definitions.
ItemsV2ItemEffCategory	Handles extensible fields for items, enabling the capture of additional characteristics such as color or size.
ItemsV2ItemGlobalDFF	Manages global descriptive flexfields for items, standardizing attributes across the system.
ItemsV2ItemRevision	Tracks and manages revision details for items, ensuring accurate record-keeping of changes over time.
ItemsV2ItemRevisionItemRevisionDFF	Handles descriptive flexfields specific to item revisions for contextual customization.
ItemsV2ItemRevisionItemRevisionEffCategory	Manages extensible flexfields for item revisions, capturing custom attributes related to changes.
ItemsV2ItemRevisionItemRevisionTranslation	Handles translatable attributes for item revisions to support global operations and localized descriptions.
ItemsV2ItemRevisionRevisionAttachment	Manages attachments related to specific item revisions, providing additional documentation or reference.
ItemsV2ItemSupplierAssociation	Manages associations between items and their suppliers, defining supplier-specific attributes for each item.
ItemsV2ItemSupplierAssociationItemSupplierEffCategory	Handles extensible flexfields for item-supplier associations, enabling custom attribute management.
ItemsV2ItemTranslation	Manages translatable fields for items, ensuring attributes such as descriptions are accessible in multiple languages.
ItemTemplates	Manages item templates, which provide predefined sets of attributes for quicker item creation and standardization.
ItemTemplatesitemDFFs	Handles contextual descriptive flexfields in item templates, allowing for tailored data input.
ItemTemplatesitemEFFs	Manages extensible flexfields in item templates for capturing additional customizable attributes.
ItemTemplatesitemGlobalDFFs	Handles global descriptive flexfields within item templates, ensuring consistency across the system.
ItemTemplatesitemRevisions	Tracks and manages revision details within item templates for accurate version control.
ItemTemplatesitemRevisionsDFFs	Handles descriptive flexfields for item revisions in templates, enabling contextual customization.
ItemTemplatesitemRevisionsEFFs	Manages extensible flexfields for item revisions in templates to capture additional revision-specific attributes.
ItemTemplatesitemTranslations	Handles translatable attributes in item templates to support multi-language item definitions.
StandardLookupsLOV	Queries the standard lookup codes and translated meanings, supporting reference data sharing.
TradingPartnerItemRelationships	Manages relationships between internal items and trading partner items for better collaboration.
TradingPartnerItemRelationshipsDFF	Handles descriptive flexfields for trading partner item relationships to manage custom attributes.
TradingPartnerItemRelationshipstranslatableAttributes	Manages translatable attributes for trading partner item relationships to support global operations.

Finders

Name	Type	ReadOnly	FilterOnly	Description
ViewName	String	False	No	The name of the database view for which a finder needs to be identified. This view acts as a virtual table that represents a predefined query, often used for reporting or providing structured access to underlying data.
FinderName	String	False	No	The name of the finder, which is a predefined query or search mechanism associated with the view. Finders are used to retrieve specific subsets of data based on filtering criteria, improving efficiency in data retrieval operations.
AttributeFinderColumn	String	False	No	The name of the attribute within the finder that is used for searching or filtering data. This column defines which field is used as a lookup parameter when executing the finder query.
Type	String	False	No	The data type of the attribute within the finder. This data type specifies how the attribute is stored and processed, ensuring correct comparisons and query performance when filtering data using the finder mechanism.

Return to Top

FlexFndDffDescriptiveFlexfieldContexts

Name	Type	ReadOnly	FilterOnly	Description
ApplicationId [KEY]	Long	False	No	The unique identifier of the application to which this descriptive flexfield (DFF) context belongs. This identifier helps in associating the DFF with the correct Oracle application module, ensuring that data is retrieved and stored in the appropriate functional area.
DescriptiveFlexfieldCode [KEY]	String	False	No	The unique code representing the DFF. This code acts as an identifier for a group of additional attributes that extend the standard functionality of Oracle applications without requiring database schema modifications.
ContextCode [KEY]	String	False	No	The identifier for the specific context within the DFF. Context codes allow DFFs to dynamically present different sets of attributes based on business rules, providing flexibility in data capture across various use cases.
Name	String	False	No	The name of the DFF context. This human-readable identifier differentiates various DFF contexts, aiding in configuration and reporting.
Description	String	False	No	A textual description providing details about the purpose and usage of this DFF context. This field helps administrators and users understand its function within the application module.
EnabledFlag	String	False	No	A flag indicating whether the DFF context is currently active. A value of 'Y' (Yes) means it is enabled and available for use, while 'N' (No) means it is inactive.
Bind_ApplicationId	Long	False	No	The application identifier used for binding this DFF context during runtime execution. This identifier ensures that the correct set of DFF attributes is retrieved based on the application module in which it is used.
Bind_DescriptiveFlexfieldCode	String	False	No	The DFF code used in runtime binding. This code ensures that when a transaction or process references a DFF, it dynamically retrieves the relevant set of attributes associated with the given DFF code.
Finder	String	False	No	The name of the predefined finder query used to retrieve records related to this DFF context. Finders optimize search performance by providing efficient data retrieval mechanisms within Oracle applications.

Return to Top

FlexFndPvsCharacterIdCharacterValues

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	String	False	No	The unique identifier for a character value within the descriptive flexfield (DFF) value set. This identifier is used to distinguish individual values within the value set for configuration and validation.
Value	String	False	No	The actual character value stored within the DFF value set. This value represents a selectable option that users can choose from in a DFF-enabled form or lookup.
Description	String	False	No	A textual description providing details about the character value. This description helps users understand the meaning or purpose of the value when selecting from available options.
StartDateActive	Date	False	No	The date when this character value becomes active and available for selection within the DFF. This date is used for controlling the validity period of selectable values.
EndDateActive	Date	False	No	The date when this character value is no longer valid or available for use. This date ensures that deprecated values are not mistakenly selected in transactions or configurations.
EnabledFlag	String	False	No	A flag indicating whether the character value is currently active ('Y' for Yes, 'N' for No). This flag determines if the value is available for selection in the application.
SummaryFlag	String	False	No	A flag indicating whether this value serves as a summary or parent value within a hierarchical structure. This flag is used in reporting and data aggregation.
ValueSetCode	String	False	No	The code identifying the value set to which this character value belongs. This code ensures that values are grouped correctly for validation and lookup purposes.
Bind_DataSource	String	False	No	Specifies the data source associated with this value, typically used for dynamically populating values in the DFF. This data source ensures accurate and context-driven value selection.
Bind_FinderContext	String	False	No	The finder context associated with this character value, defining the scope or criteria for retrieving relevant values in dynamic lookups.
Bind_FinderDateFlag	String	False	No	A flag that determines whether date-based filtering is applied when retrieving values via the finder. This flag is used for time-sensitive data selection.
Bind_ValidationDate	Date	False	No	The date used for validating the character value within the finder context. This date ensures that only values valid as of the specified date are retrieved.
Finder	String	False	No	The name of the predefined finder query used to retrieve values dynamically. Finders improve search efficiency by providing optimized queries for data retrieval.
Flex_vst_bind1	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind10	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind11	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind12	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind13	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind14	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind15	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind16	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind17	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind18	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind19	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind2	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind20	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind3	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind4	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind5	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind6	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind7	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind8	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind9	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference.

Return to Top

FlexFndPvsCharacterValues

Name	Type	ReadOnly	FilterOnly	Description
Value [KEY]	String	False	No	The character-based value stored within the descriptive flexfield (DFF) value set. This value represents a user-selectable option used in business processes for categorization, classification, or configuration.
Description	String	False	No	A detailed description of the character value, providing context for users selecting this value in the DFF. This description helps clarify its intended purpose in data entry or reporting.
StartDateActive	Date	False	No	The date from which this character value becomes active and available for selection in the DFF. This date is used for controlling the validity period of the value.
EndDateActive	Date	False	No	The date after which this character value is no longer available for use. This date helps enforce data governance by ensuring deprecated values are not selected in new transactions.
EnabledFlag	String	False	No	A flag indicating whether this character value is currently active ('Y' for Yes, 'N' for No). When disabled, the value cannot be selected in user interfaces or transactions.
SummaryFlag	String	False	No	Indicates whether this value serves as a summary or parent value in hierarchical structures. This flag is useful for grouping values in reporting or DFF-driven rollups.
ValueSetCode	String	False	No	The unique identifier for the value set to which this character value belongs. This identifier ensures proper grouping and validation of values when used in DFF-based data entry.
Bind_AttrMap	String	False	No	Specifies an attribute mapping reference associated with this value, allowing dynamic associations between DFF values and business objects.
Bind_DataSource	String	False	No	Defines the source from which this character value originates, typically used for dynamically retrieving values from external systems or database tables.
Bind_DataSourceDiscr	String	False	No	A discriminator value for the data source, used to refine or filter dynamic value retrieval in cases where multiple sources are available.
Bind_FinderContext	String	False	No	Defines the finder context used to determine how values are retrieved dynamically. This finder context helps optimize lookups and filtering when dealing with large datasets.
Bind_FinderDateFlag	String	False	No	Indicates whether date-based filtering is applied when retrieving character values via the finder. This filtering ensures only values valid for a given date are returned.
Bind_ValidationDate	Date	False	No	The date used to validate the character value within the finder context. This date ensures compliance with effective dating requirements in business processes.
Finder	String	False	No	The predefined finder query used to dynamically retrieve matching values based on search criteria. Finders improve performance by optimizing data lookups.
Flex_vst_bind1	String	False	No	A system-defined binding parameter used for dynamic value retrieval in the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind10	String	False	No	A system-defined binding parameter used for dynamic value retrieval in the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind11	String	False	No	A system-defined binding parameter used for dynamic value retrieval in the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind12	String	False	No	A system-defined binding parameter used for dynamic value retrieval in the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind13	String	False	No	A system-defined binding parameter used for dynamic value retrieval in the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind14	String	False	No	A system-defined binding parameter used for dynamic value retrieval in the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind15	String	False	No	A system-defined binding parameter used for dynamic value retrieval in the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind16	String	False	No	A system-defined binding parameter used for dynamic value retrieval in the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind17	String	False	No	A system-defined binding parameter used for dynamic value retrieval in the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind18	String	False	No	A system-defined binding parameter used for dynamic value retrieval in the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind19	String	False	No	A system-defined binding parameter used for dynamic value retrieval in the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind2	String	False	No	A system-defined binding parameter used for dynamic value retrieval in the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind20	String	False	No	A system-defined binding parameter used for dynamic value retrieval in the DFF structure. Typically represents a contextual reference.
Flex_vst_bind3	String	False	No	A system-defined binding parameter used for dynamic value retrieval in the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind4	String	False	No	A system-defined binding parameter used for dynamic value retrieval in the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind5	String	False	No	A system-defined binding parameter used for dynamic value retrieval in the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind6	String	False	No	A system-defined binding parameter used for dynamic value retrieval in the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind7	String	False	No	A system-defined binding parameter used for dynamic value retrieval in the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind8	String	False	No	A system-defined binding parameter used for dynamic value retrieval in the DFF structure. Typically, this parameter represents a contextual reference.
Flex_vst_bind9	String	False	No	A system-defined binding parameter used for dynamic value retrieval in the DFF structure. Typically, this parameter represents a contextual reference.

Return to Top

FlexFndPvsNumberIdCharacterValues

Name	Type	ReadOnly	FilterOnly	Description
Id [KEY]	Decimal	False	No	The unique numeric identifier assigned to the character value within the descriptive flexfield (DFF) value set. This identifier ensures uniqueness and traceability of the value for validation and configuration purposes.
Value	String	False	No	The character-based value associated with the numeric ID in the DFF. This value represents a user-selectable option used in business processes for classification, categorization, or lookup purposes.
Description	String	False	No	A descriptive explanation of the character value, providing additional details to help users understand its meaning and usage within the DFF structure.
StartDateActive	Date	False	No	The date when this character value becomes available for selection within the DFF. This date helps control the validity of values over time.
EndDateActive	Date	False	No	The date when this character value is no longer available for use. This date helps enforce business rules by preventing outdated values from being used in new transactions.
EnabledFlag	String	False	No	A flag indicating whether this character value is currently active ('Y' for Yes, 'N' for No). When disabled, the value is no longer available for selection.
SummaryFlag	String	False	No	Indicates whether this value functions as a summary or parent value in hierarchical structures. This flag is used for grouping values in reporting and data analysis.
ValueSetCode	String	False	No	The identifier for the value set that this character value belongs to. Value sets define the domain of valid values available for use in DFFs.
Bind_DataSource	String	False	No	Defines the data source from which this character value is derived. This data source is useful when values are dynamically retrieved from external systems or database tables.
Bind_FinderContext	String	False	No	Defines the context used for retrieving values dynamically. This context helps optimize lookups and ensures relevant values are returned based on user selection criteria.
Bind_FinderDateFlag	String	False	No	A flag that determines whether date-based filtering is applied when retrieving values via the finder mechanism. This flag ensures values returned are valid for a given date.
Bind_ValidationDate	Date	False	No	The date used for validation when retrieving values dynamically. This date ensures compliance with effective dating requirements in business processes.
Finder	String	False	No	The name of the predefined finder query used for retrieving matching values based on search criteria. Finders improve efficiency by optimizing data lookups.
Flex_vst_bind1	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference for filtering values.
Flex_vst_bind10	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference for filtering values.
Flex_vst_bind11	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference for filtering values.
Flex_vst_bind12	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference for filtering values.
Flex_vst_bind13	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference for filtering values.
Flex_vst_bind14	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference for filtering values.
Flex_vst_bind15	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference for filtering values.
Flex_vst_bind16	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference for filtering values.
Flex_vst_bind17	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference for filtering values.
Flex_vst_bind18	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference for filtering values.
Flex_vst_bind19	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference for filtering values.
Flex_vst_bind2	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference for filtering values.
Flex_vst_bind20	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference for filtering values.
Flex_vst_bind3	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference for filtering values.
Flex_vst_bind4	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference for filtering values.
Flex_vst_bind5	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference for filtering values.
Flex_vst_bind6	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference for filtering values.
Flex_vst_bind7	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference for filtering values.
Flex_vst_bind8	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference for filtering values.
Flex_vst_bind9	String	False	No	A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference for filtering values.

Return to Top

Ideas

Name	Type	ReadOnly	FilterOnly	Description
IdeaId [KEY]	Long	False	No	The unique identifier assigned to each idea. This identifier ensures that each idea is distinctly referenced in the system for tracking and management.
Type	String	False	No	The classification type of the idea, which categorizes it based on predefined criteria. The value for this attribute can be reviewed and updated in the Setup and Maintenance work area using the Manage Product Idea Classes task.
TypeDisplayValue	String	False	No	A human-readable display value representing the type of the idea. This value is typically used in user interfaces and reports to provide a clear classification.
Name	String	False	No	The title or short name of the idea. This title is a concise representation of the concept being proposed.
IdeaNumber	String	False	No	The unique number assigned to the idea for tracking purposes. This number is often used for reference in discussions, approvals, and reports.
CreatedBy	String	False	No	The username or identifier of the user who submitted the idea. This field helps in tracking authorship and accountability.
ObjectVersionNumber	Int	False	No	A system-generated version number that tracks changes to the idea record in the database. This number is used for concurrency control and record updates.
CreationDate	Datetime	False	No	The timestamp when the idea was initially created. This timestamp helps in tracking when the idea was first proposed.
LastUpdateDate	Datetime	False	No	The timestamp of the most recent update to the idea. This timestamp ensures visibility into when changes were last made.
LastUpdatedBy	String	False	No	The username or identifier of the last user who modified the idea. This field helps in auditing and tracking updates.
Status	String	False	No	The current status of the idea, which determines its progress in the review and approval workflow. The value for this attribute can be managed in the Setup and Maintenance work area using the Manage Product Idea Statuses task.
StatusDisplayValue	String	False	No	A user-friendly display value representing the current status of the idea. This value is used in reports and UI screens for readability.
LastUpdateLogin	String	False	No	Tracks the login session of the user who last updated the idea. This login information is used for auditing and security purposes.
VoteSummaryAsText	String	False	No	A summary of votes received for the idea in a text format. This summary provides an overview of community engagement and interest.
AllowAccesstoEveryone	String	False	No	Indicates whether the idea is publicly accessible. Possible values include 'true' (all users can access) or 'false' (restricted access). The default value is 'false'.
Description	String	False	No	A detailed description of the idea, providing an overview of the proposed concept, problem statement, and intended benefits.
Content	String	False	No	A rich-text field containing a comprehensive explanation of the idea, including supporting details, images, and attachments where applicable.
Tags	String	False	No	A comma-separated list of keywords or tags associated with the idea. This list is used for categorization and improving searchability.
YesVoteCnt	Int	False	No	The total number of users who have voted 'Yes' in favor of the idea, indicating support and interest from the community.
NoVoteCnt	Int	False	No	The total number of users who have voted 'No' on the idea, indicating a lack of support from the community.
LikeIt	Int	False	No	The number of users who liked the idea. Likes provide an additional measure of engagement beyond votes.
ReferencesCnt	Int	False	No	The count of references linked to this idea. References typically represent other objects (such as projects, documents, or product requirements) that are associated with the idea.
Popularity	Int	False	No	A numeric score representing the overall popularity of the idea, based on engagement factors such as votes, likes, and comments.
HasMyVote	Bool	False	No	Indicates whether the current user has voted in favor of the idea. Possible values include 'true' (user has voted Yes) or 'false' (user has not voted in favor). The default value is 'false'.
CommentsCnt	Int	False	No	The total number of comments submitted on the idea, providing a measure of user engagement and discussion.
Customers	String	False	No	A list of customers associated with this idea. This list can be used to track customer interest or identify target users for the proposed concept.
CommentsCount	Int	False	No	The total number of comments on the idea. This metric duplicates 'CommentsCnt' and can be used in different contexts for reporting or API responses.
LikeCount	Int	False	No	The total number of likes received for the idea, representing positive engagement from users.
DisLikeCount	Int	False	No	The total number of dislikes recorded for the idea, indicating negative feedback or opposition to the concept.
ProjectedMarketDemand_c	String	False	No	An estimate of the market demand for the idea, based on research, customer interest, or internal forecasting.
CompetitiveThreat_c	String	False	No	An assessment of the competitive threat posed by similar products or ideas in the market. This assessment helps in prioritizing innovation and differentiation strategies.
ProjectedDevelopmentLOE_c	String	False	No	The estimated level of effort (LOE) required for development if the idea is pursued. This metric helps evaluate feasibility and resource allocation.
ProjectedMarketSize_c	String	False	No	An estimate of the potential market size for the idea, used for business case analysis and strategic planning.
StrategicFitWithBrandPortfolio_c	String	False	No	An evaluation of how well the idea aligns with the existing brand portfolio and overall corporate strategy.
ProjectedRevenue_c	String	False	No	An estimate of the potential revenue that could be generated if the idea is implemented. This estimate is used for financial modeling and decision-making.
IdeaPreliminaryRanking_c	String	False	No	A preliminary ranking assigned to the idea based on various criteria such as business value, feasibility, and strategic alignment.
BusinessNeed_c	String	False	No	A description of the specific business need that this idea addresses, providing justification for its consideration and development.
PotentialCustomers_c	String	False	No	A list or description of potential customers who might be interested in the idea. This field helps in market validation and targeting efforts.
CreatorIdeaDescription_c	String	False	No	A detailed explanation of the idea as provided by its creator. This field captures the original thought process and intent behind the proposal.
Finder	String	False	No	The name of the predefined finder query used to retrieve ideas dynamically based on search criteria. Finders optimize data retrieval in applications.

Return to Top

IdeasAttachments

Name	Type	ReadOnly	FilterOnly	Description
IdeasIdeaId [KEY]	Long	False	No	The unique identifier of the idea associated with this attachment. This identifier establishes the relationship between an idea and its supporting documents.
AttachedDocumentId [KEY]	Long	False	No	A system-generated unique identifier for the attached document. This identifier is used for tracking and managing attachments linked to ideas.
LastUpdateDate	Datetime	False	No	The timestamp of the most recent update to the attachment. This timestamp helps in auditing modifications and tracking the latest version.
LastUpdatedBy	String	False	No	The username or identifier of the last user who modified the attachment. This identifier is useful for monitoring document changes and accountability.
DatatypeCode	String	False	No	A short code representing the data type of the attachment, such as text, image, or PDF. This code helps in categorizing and processing attachments.
FileName	String	False	No	The original name of the uploaded file. This name provides a human-readable reference to identify the document.
DmFolderPath	String	False	No	The repository folder path where the attachment is stored. This path defines the document’s location in the content management system.
DmDocumentId	String	False	No	The unique identifier assigned to the document within the document management system. This identifier is used for version control and retrieval.
DmVersionNumber	String	False	No	The version number of the document in the document management system. This number helps in tracking changes and ensuring access to the latest version.
Url	String	False	No	The direct Uniform Resource Locator (URL) of the attachment, allowing users to access it via a web browser or API.
CategoryName	String	False	No	The classification or category assigned to the attachment. This classification helps in organizing and filtering attachments based on purpose or content type.
UserName	String	False	No	The username of the individual who uploaded or owns the attachment. This username provides visibility into content ownership.
Uri	String	False	No	The URI of the attachment, which serves as a unique reference for retrieval in content management systems.
FileUrl	String	False	No	The URL specifically pointing to the attached file, enabling direct access and downloads.
UploadedText	String	False	No	The textual content of the attachment. This field is used for storing plain text-based attachments.
UploadedFileContentType	String	False	No	The content type of the uploaded file. This content type helps in correctly handling file types in processing and display.
UploadedFileLength	Long	False	No	The file size of the uploaded attachment in bytes. This metric is used for storage management and file size restrictions.
UploadedFileName	String	False	No	The name of the file when uploaded, which can differ from the original file name if renaming occurs during processing.
ContentRepositoryFileShared	Bool	False	No	Indicates whether the attachment is shared with other users. Possible values include 'true' (shared) or 'false' (not shared). The default is 'false'.
Title	String	False	No	The title or display name of the attachment. This title is used for identifying attachments in lists and reports.
Description	String	False	No	A brief description of the attachment's contents. This description provides context for users reviewing attachments related to an idea.
ErrorStatusCode	String	False	No	A system-generated error code, if any, related to the attachment. This error code is used for diagnosing upload or processing issues.
ErrorStatusMessage	String	False	No	A descriptive error message providing details about an issue encountered while processing the attachment.
CreatedBy	String	False	No	The username or identifier of the user who originally uploaded the attachment. This identifier helps track content ownership and submission history.
CreationDate	Datetime	False	No	The timestamp when the attachment was first uploaded. This timestamp provides historical tracking of content additions.
FileContents	String	False	No	The raw content of the attachment, typically used for inline storage of file data in text-based formats.
ExpirationDate	Datetime	False	No	The date when the attachment expires or is scheduled for removal. This date helps in content lifecycle management.
LastUpdatedByUserName	String	False	No	The username of the last user who modified the attachment. This username is useful for tracking recent changes.
CreatedByUserName	String	False	No	The username of the individual who initially uploaded the attachment. This username provides a human-readable identifier for the creator.
AsyncTrackerId	String	False	No	A system-generated identifier used to track the upload process for asynchronous file processing.
FileWebImage	String	False	No	The URL or reference to a web-friendly version of the attachment, typically used for displaying images or previewing files in a browser.
DownloadInfo	String	False	No	A JSON object represented as a string containing metadata and parameters needed to programmatically retrieve a file attachment. This information is used for system integrations and automated file access.
PostProcessingAction	String	False	No	The name of the action that can be performed after an attachment is uploaded. This can include actions such as validation, conversion, or notification triggers.
Finder	String	False	No	The name of the predefined finder query used to retrieve attachments dynamically. Finders help optimize attachment searches based on criteria such as associated ideas or upload dates.
IdeaId	Long	False	No	The unique identifier of the idea associated with this attachment. This identifier establishes a direct relationship between an idea and its supporting documents.

Return to Top

IdeasIdeaComment

Name	Type	ReadOnly	FilterOnly	Description
IdeasIdeaId [KEY]	Long	False	No	The unique identifier of the idea associated with this comment. This identifier establishes the relationship between an idea and its comments for discussion tracking.
CreatedBy	String	False	No	The username or identifier of the user who posted the comment. This identifier helps in tracking the contributor of the discussion.
CreationDate	Datetime	False	No	The timestamp when the comment was initially created. This timestamp is used for chronological ordering and tracking discussion activity.
IdeaComment	String	False	No	The text content of the comment. This content provides feedback, suggestions, or discussions related to the idea.
IdeaCommentId [KEY]	Long	False	No	The unique identifier assigned to the comment. This identifier is used for tracking and managing comments within the system.
IdeaId	Long	False	No	The unique identifier of the idea that this comment is associated with. This identifier ensures comments are correctly linked to the relevant idea.
IdeaName	String	False	No	The name of the idea to which the comment belongs. This name provides a human-readable reference for easier identification.
LastUpdateDate	Datetime	False	No	The timestamp of the most recent update to the comment. The timestamp helps in auditing modifications and tracking revisions.
LastUpdatedBy	String	False	No	The username or identifier of the last user who modified the comment. This identifier is useful for monitoring changes and ensuring accountability.
ObjectVersionNumber	Int	False	No	A system-generated version number that tracks changes to the comment record in the database. This number is used for concurrency control and record updates.
UserName	String	False	No	The username of the person who posted the comment. This username is used for displaying the author of the comment in discussions.
PersonId	Long	False	No	The unique identifier of the person associated with the comment. This identifier is used for linking comments to user profiles in the system.
DisplayName	String	False	No	The display name of the user who posted the comment. The display name provides a readable user reference for UI elements and reports.
Finder	String	False	No	The name of the predefined finder query used to retrieve comments dynamically. Finders improve search and filtering of idea discussions.

Return to Top

IdeasIdeaTeam

Name	Type	ReadOnly	FilterOnly	Description
IdeasIdeaId [KEY]	Long	False	No	The unique identifier of the idea associated with this team member. This identifier establishes the relationship between an idea and its assigned team members.
UserId	Long	False	No	The unique identifier of the user who is a team member for the idea. This identifier is used to link users to idea collaboration efforts.
UserName	String	False	No	The name of the user assigned as a team member for the idea. This name is typically used in UI displays and reports.
CreatedBy	String	False	No	The username or identifier of the user who added this team member to the idea. This identifier helps track ownership and changes in team composition.
CreationDate	Datetime	False	No	The timestamp when the team member was added to the idea. This timestamp is used for auditing and tracking collaboration history.
LastUpdatedBy	String	False	No	The username or identifier of the last user who modified the team assignment. This identifier is useful for monitoring updates and maintaining accountability.
LastUpdateDate	Datetime	False	No	The timestamp of the most recent update to the team assignment. This timestamp helps track changes to the idea's collaboration team.
Finder	String	False	No	The name of the predefined finder query used to retrieve team members dynamically. Finders improve performance in searching for idea contributors.
IdeaId	Long	False	No	The unique identifier for the idea. This identifier ensures that team members are correctly associated with the corresponding idea.

Return to Top

IdeasIdeaVote

Name	Type	ReadOnly	FilterOnly	Description
IdeasIdeaId [KEY]	Long	False	No	The unique identifier of the idea associated with this vote. This identifier establishes the relationship between an idea and the votes it has received.
CreatedBy	String	False	No	The username or identifier of the user who cast the vote. This identifier helps track voter participation and engagement with the idea.
CreationDate	Datetime	False	No	The timestamp when the vote was submitted. This timestamp is used for tracking voting trends and engagement over time.
IdeaId	Long	False	No	The unique identifier of the idea being voted on. This identifier ensures that votes are correctly linked to the relevant idea.
IdeaName	String	False	No	The name of the idea receiving the vote. This field provides a human-readable reference to the idea in reports and UI displays.
IdeaVoteId [KEY]	Long	False	No	A unique identifier assigned to the vote. This identifier is used for tracking and managing votes within the system.
LastUpdateDate	Datetime	False	No	The timestamp of the most recent update to the vote. This timestamp helps in auditing modifications or tracking vote retractions.
LastUpdatedBy	String	False	No	The username or identifier of the last user who modified the vote. this identifier is useful for monitoring changes and maintaining accountability.
ObjectVersionNumber	Int	False	No	A system-generated version number that tracks changes to the vote record in the database. This version number is used for concurrency control and maintaining data integrity.
UserName	String	False	No	The username associated with the login session when the vote was submitted. This login information is used for tracking voter activity.
Vote	String	False	No	Indicates whether the user voted in favor or against the idea. Typically, this field stores values such as 'Yes' or 'No' to reflect support or opposition.
Finder	String	False	No	The name of the predefined finder query used to retrieve vote records dynamically. Finders improve efficiency in vote-related data retrieval.

Return to Top

ItemCatalogs

Name	Type	ReadOnly	FilterOnly	Description
CatalogId [KEY]	Long	False	No	The unique identifier assigned to the item catalog. This identifier is used for tracking and managing catalogs within the system.
CatalogCode	String	False	No	The unique code assigned to the catalog. This catalog is often used for quick reference in integrations, reports, and user interfaces.
CatalogName	String	False	No	The name of the item catalog, providing a user-friendly identifier for the catalog in the system.
Description	String	False	No	A detailed description of the catalog, explaining its purpose, scope, and any relevant business context.
MasterControlledFlag	Bool	False	No	Indicates whether the catalog is controlled at the master level. If set to 'true', changes to the catalog are managed centrally and inherited by subordinate catalogs.
StartDate	Date	False	No	The date from which the catalog becomes active and available for use. This date helps in controlling catalog availability over time.
EndDate	Date	False	No	The date after which the catalog is no longer valid or available. This date is used to phase out catalogs that are no longer needed.
AssignItemsToLeafOnlyFlag	Bool	False	No	Indicates whether items can only be assigned to leaf categories (for example, the lowest level in the category hierarchy). This flag ensures correct item categorization based on business rules.
AllowItemToMultipleCategoriesFlag	Bool	False	No	Indicates whether an item can be assigned to multiple categories within the catalog. If set to 'false', items must belong to a single category.
PublicCatalogFlag	Bool	False	No	Indicates whether the catalog is public and accessible to all users. If set to 'false', access can be restricted based on roles or permissions.
DefaultCategoryCode	String	False	No	The default category code assigned to items in this catalog when no other category is specified. This code helps standardize item categorization.
HierarchyEnabledFlag	Bool	False	No	Indicates whether hierarchical categorization is enabled for this catalog. If set to 'true', categories can be structured in parent-child relationships.
CreationDateTime	Datetime	False	No	The timestamp when the catalog was created. This timestamp is used for historical tracking and auditing.
LastUpdateDateTime	Datetime	False	No	The timestamp of the most recent update to the catalog. This timestamp helps track modifications over time.
Finder	String	False	No	The name of the predefined finder query used to retrieve catalog records dynamically. Finders improve efficiency in catalog searches and reporting.

Return to Top

ItemCatalogsattachments

Name	Type	ReadOnly	FilterOnly	Description
ItemCatalogsCatalogId [KEY]	Long	False	No	The unique identifier of the catalog associated with this attachment. This identifier establishes the relationship between an item catalog and its supporting documents.
LastUpdateDate	Datetime	False	No	The timestamp of the most recent update to the attachment. This timestamp is used for tracking modifications and maintaining version history.
LastUpdatedBy	String	False	No	The username or identifier of the user who last modified the attachment. This identifier helps track changes and maintain accountability.
DatatypeCode	String	False	No	The data type code representing the type of the attachment (for example, 'text', 'image', or 'PDF'). This code is used for categorizing and processing attachments.
FileName	String	False	No	The original name of the uploaded file. This name provides a human-readable reference for identifying documents.
DmFolderPath	String	False	No	The repository folder path where the attachment is stored. This path defines the attachment’s location in the document management system.
Url	String	False	No	The direct Uniform Resource Locator (URL) of the attachment, allowing users to access it via a web browser or API. This URL ensures quick retrieval of stored files.
CategoryName	String	False	No	The classification or category assigned to the attachment. This category helps in organizing and filtering attachments based on purpose or content type.
UserName	String	False	No	The username of the individual who uploaded or owns the attachment. This username provides visibility into content ownership.
Uri	String	False	No	The Uniform Resource Identifier (URI) of the attachment, which serves as a unique reference for retrieval in content management systems. This identifier ensures system-wide consistency in referencing files.
FileUrl	String	False	No	The URL specifically pointing to the attached file, enabling direct access and downloads. This URL provides an alternative method for retrieving stored documents.
UploadedText	String	False	No	The textual content of the attachment. This content is used for storing plain text-based attachments.
UploadedFileContentType	String	False	No	The content type of the uploaded file. This type helps in correctly handling file types in processing and display.
UploadedFileLength	Long	False	No	The file size of the uploaded attachment in bytes. This metric is used for storage management and enforcing file size restrictions.
UploadedFileName	String	False	No	The name of the file when uploaded, which can differ from the original file name if renaming occurs during processing. This name is essential for maintaining accurate file records.
ContentRepositoryFileShared	Bool	False	No	Indicates whether the attachment is shared with other users. A value of 'true' means the attachment is shared, while 'false' means it is not shared. The default value is 'false'.
Title	String	False	No	The title or display name of the attachment. This title is used for identifying attachments in lists and reports.
Description	String	False	No	A brief description of the attachment's contents. This description provides context for users reviewing attachments related to an item catalog.
ErrorStatusCode	String	False	No	A system-generated error code, if any, related to the attachment. This code is used for diagnosing upload or processing issues.
ErrorStatusMessage	String	False	No	A descriptive error message providing details about an issue encountered while processing the attachment. This message assists in troubleshooting errors.
CreatedBy	String	False	No	The username or identifier of the user who originally uploaded the attachment. This field helps track content ownership and submission history.
CreationDate	Datetime	False	No	The timestamp when the attachment was first uploaded. This timestamp provides historical tracking of content additions.
DownloadInfo	String	False	No	A JSON object containing metadata and parameters needed to programmatically retrieve a file attachment. This information is used for system integrations and automated file access.
DocumentURL	String	False	No	The URL of the document stored in the content repository. This URL enables direct access for viewing or downloading the document.
CatalogId	Long	False	No	The unique identifier of the item catalog associated with the attachment. This identifier ensures attachments are correctly linked to the appropriate catalog.
Finder	String	False	No	The name of the predefined finder query used to retrieve attachment records dynamically. This query improves efficiency in attachment searches and reporting.

Return to Top

ItemCatalogsattachmentsattachmentDFF

Name	Type	ReadOnly	FilterOnly	Description
ItemCatalogsCatalogId [KEY]	Long	False	No	The unique identifier of the catalog associated with this attachment. This identifier establishes the relationship between an item catalog and its descriptive flexfield (DFF) attachment data.
AttachedDocumentId [KEY]	Long	False	No	The unique identifier assigned to the attached document. This identifier ensures accurate tracking and retrieval of specific attachments related to the item catalog.
_FLEX_Context	String	False	No	The name of the DFF context associated with the item catalog attachment. This context determines the additional attributes or fields available for the attachment.
_FLEX_Context_DisplayValue	String	False	No	The display value of the DFF context for the item catalog attachment. This value is used in user interfaces and reports to present a readable representation of the DFF context.
CatalogId	Long	False	No	The unique identifier of the item catalog that this attachment belongs to. This identifier ensures attachments are correctly associated with the appropriate catalog.
Finder	String	False	No	The name of the predefined finder query used to retrieve DFF attachment records dynamically. This query enhances search efficiency and facilitates attachment retrieval.

Return to Top

ItemCatalogscategoryHierarchies

Name	Type	ReadOnly	FilterOnly	Description
ItemCatalogsCatalogId [KEY]	Long	False	No	The unique identifier of the catalog associated with this category hierarchy. This identifier establishes the relationship between an item catalog and its category structure.
CategoryId [KEY]	Long	False	No	The unique identifier assigned to the category within the catalog hierarchy. This identifier is used to track and manage category-level details.
CategoryCode	String	False	No	The code that uniquely identifies the category within the catalog. This code is used in reports, integrations, and user interfaces to reference specific categories.
CategoryName	String	False	No	The name of the category within the catalog hierarchy. This name provides a human-readable identifier for organizing and displaying category information.
CatalogId [KEY]	Long	False	No	The unique identifier of the catalog that contains this category hierarchy. This identifier ensures that categories are correctly linked to their respective catalogs.
CatalogCode	String	False	No	The unique code assigned to the catalog that contains this category hierarchy. This code is used for quick identification and reference within the system.
ParentCategoryId	Long	False	No	The unique identifier of the parent category in the hierarchy. This identifier establishes the parent-child relationship between categories, enabling hierarchical organization.
ParentCategoryCode	String	False	No	The unique code assigned to the parent category. This code helps define category structures where multiple subcategories exist under a single parent category.
Description	String	False	No	A detailed description of the category hierarchy. This field provides additional information on the category's purpose, usage, and scope within the catalog.
StartDate	Date	False	No	The date when this category hierarchy becomes active. This date ensures that categories are available only during the intended time period.
EndDate	Date	False	No	The date when this category hierarchy is no longer valid. This date prevents deprecated categories from being assigned to new items.
ItemsOnlyFlag	Bool	False	No	Indicates whether only items can be assigned to this category. If set to 'true', the category cannot have subcategories and is used exclusively for item assignments.
SharedFlag	Bool	False	No	Indicates whether the category hierarchy is shared across multiple catalogs. If set to 'true', the category can be used in multiple item catalogs.
CreationDateTime	Datetime	False	No	The timestamp when the category hierarchy was created. This timestamp is used for historical tracking and auditing purposes.
LastUpdateDateTime	Datetime	False	No	The timestamp of the most recent update to the category hierarchy. This timestamp helps track modifications and maintain version control.
Finder	String	False	No	The name of the predefined finder query used to retrieve category hierarchy records dynamically. This query improves efficiency in category structure searches and reporting.

Return to Top

ItemCatalogscategoryHierarchiescategoryHierarchies

Name	Type	ReadOnly	FilterOnly	Description
ItemCatalogsCatalogId [KEY]	Long	False	No	The unique identifier of the item catalog associated with this category hierarchy. This identifier establishes the link between an item catalog and its hierarchical category structure.
CategoryhierarchiesCatalogId [KEY]	Long	False	No	The unique identifier of the catalog that contains the category hierarchy. This identifier ensures that hierarchical relationships between categories are maintained within the correct catalog.
CategoryhierarchiesCategoryId [KEY]	Long	False	No	The unique identifier of the category within the hierarchy. This identifier is used to track and manage category relationships across multiple hierarchies.
CategoryId [KEY]	Long	False	No	The unique identifier assigned to the category in the catalog hierarchy. This identifier ensures accurate categorization and data integrity.
CategoryCode	String	False	No	The code that uniquely identifies the category within the catalog hierarchy. This code is used in integrations, reporting, and user interfaces to reference specific categories.
CategoryName	String	False	No	The name of the category in the catalog hierarchy. This name provides a human-readable reference for organizing and displaying category information.
CatalogId [KEY]	Long	False	No	The unique identifier of the catalog that contains this category hierarchy. This identifier ensures proper association between catalogs and their hierarchical structures.
CatalogCode	String	False	No	The unique code assigned to the catalog that contains this category hierarchy. This code is used for quick identification and reference in system processes.
ParentCategoryId	Long	False	No	The unique identifier of the parent category within the hierarchy. This identifier establishes the parent-child relationship between categories, enabling hierarchical organization.
ParentCategoryCode	String	False	No	The unique code assigned to the parent category in the hierarchy. This code defines category structures where multiple subcategories exist under a single parent category.
Description	String	False	No	A detailed description of the category hierarchy. This field provides context for the category’s purpose, use cases, and functional role in the catalog.
StartDate	Date	False	No	The date when this category hierarchy becomes active. This date ensures that categories are available only within the intended time period.
EndDate	Date	False	No	The date when this category hierarchy is no longer valid. This date prevents inactive or obsolete categories from being assigned to new items.
ItemsOnlyFlag	Bool	False	No	Indicates whether only items can be assigned to this category. If set to 'true', the category cannot have subcategories and is used exclusively for item assignments.
SharedFlag	Bool	False	No	Indicates whether this category hierarchy is shared across multiple catalogs. A value of 'true' means the category can be used in multiple item catalogs, allowing for cross-catalog relationships.
CreationDateTime	Datetime	False	No	The timestamp when the category hierarchy was created. This timestamp is used for historical tracking, auditing, and reporting purposes.
LastUpdateDateTime	Datetime	False	No	The timestamp of the most recent update to the category hierarchy. This timestamp helps track modifications, ensuring data integrity and version control.
Finder	String	False	No	The name of the predefined finder query used to retrieve category hierarchy records dynamically. This query optimizes search performance and facilitates efficient category management.

Return to Top

ItemCatalogsDFF

Name	Type	ReadOnly	FilterOnly	Description
ItemCatalogsCatalogId [KEY]	Long	False	No	The unique identifier of the item catalog associated with this descriptive flexfield (DFF). This identifier links the catalog to its configurable DFF attributes.
CategorySetId [KEY]	Long	False	No	The unique identifier for the category set associated with the catalog. This identifier ensures that the correct category structure is applied to the catalog.
_FLEX_ValidationDate	Date	False	No	The date used for validating the DFF values. This date determines whether the DFF configuration is applicable at a specific point in time.
_FLEX_Context	String	False	No	The DFF context associated with the catalog. This context defines which additional attributes or segments are available for a specific catalog.
_FLEX_NumOfSegments	Int	False	No	The total number of segments defined in the DFF for this catalog. This value indicates the number of configurable fields available in the DFF.
_FLEX_NumOfVisibleSegments	Int	False	No	The number of DFF segments that are visible to users for data entry. This value ensures that only relevant fields are displayed based on the DFF configuration.
CatalogId	Long	False	No	The unique identifier of the catalog that this DFF is associated with. This identifier ensures proper linkage between the catalog and its DFF attributes.
Finder	String	False	No	The name of the predefined finder query used to retrieve DFF records dynamically. This query improves efficiency when searching for catalog DFF data.

Return to Top

ItemCatalogsfunctionalAreaAssignments

Name	Type	ReadOnly	FilterOnly	Description
ItemCatalogsCatalogId [KEY]	Long	False	No	The unique identifier of the item catalog associated with this functional area assignment. This identifier links the catalog to its respective functional area assignments.
FunctionalAreaId [KEY]	Long	False	No	The unique identifier of the functional area that this catalog is assigned to. This identifier ensures proper association between catalogs and specific business functions.
FunctionalAreaName	String	False	No	The name of the functional area associated with the catalog. This name provides a human-readable reference for identifying the business function to which the catalog applies.
LastUpdateDateTime	Datetime	False	No	The timestamp of the most recent update to the functional area assignment. This timestamp helps track modifications and ensures version control.
CatalogId	Long	False	No	The unique identifier of the catalog that is linked to this functional area assignment. This identifier ensures that assignments are correctly associated with the appropriate catalog.
Finder	String	False	No	The name of the predefined finder query used to retrieve functional area assignment records dynamically. This query improves efficiency in searching for catalog-functional area relationships.

Return to Top

ItemCatalogstranslatableAttributes

Name	Type	ReadOnly	FilterOnly	Description
ItemCatalogsCatalogId [KEY]	Long	False	No	The unique identifier of the item catalog associated with this translatable attribute entry. This identifier links the catalog to its multilingual attribute records.
CatalogId [KEY]	Long	False	No	The unique identifier assigned to the catalog. This identifier is used for reference but should not be included in service calls to create new catalogs.
CatalogName	String	False	No	The translated name of the catalog in the specified language. This field supports localization for users in different regions.
Description	String	False	No	The translated description of the catalog in the specified language. This description ensures that catalog details are accessible to users in their preferred language.
Language [KEY]	String	False	No	The language code representing the translated attributes for the catalog. This code follows ISO language standards to specify the language used.
SourceLanguage	String	False	No	The original language code of the catalog attributes before translation. This field helps track the source language for multilingual catalog entries.
CreationDateTime	Datetime	False	No	The timestamp when the translated catalog attributes were created. This timestamp provides historical tracking for multilingual data management.
LastUpdateDateTime	Datetime	False	No	The timestamp of the most recent update to the translated catalog attributes. This timestamp helps track modifications and ensures version control.
Finder	String	False	No	The name of the predefined finder query used to retrieve translatable catalog attribute records dynamically. This query improves efficiency in searching for catalog translations.

Return to Top

ItemCategories

Name	Type	ReadOnly	FilterOnly	Description
CategoryId [KEY]	Long	False	No	The unique identifier assigned to the item category. This identifier is used for reference but should not be included in service calls to create categories within catalogs.
CategoryCode	String	False	No	The unique code that identifies the item category in the user interface. This code is used for quick reference and system integration.
CategoryName	String	False	No	The name of the category, providing a human-readable identifier for organizing and managing item classifications.
CatalogId [KEY]	Long	False	No	The unique identifier assigned to the catalog that contains this category. This identifier ensures that the category is correctly linked to the appropriate catalog.
CatalogCode	String	False	No	The unique code that identifies the catalog in which this category resides. This code is used for navigation and reporting within the system.
ParentCategoryCode	String	False	No	The unique code that identifies the parent category in a category hierarchy. This code establishes the hierarchical relationship between parent and child categories.
Description	String	False	No	A detailed description of the item category. This field provides context on the category’s intended purpose, scope, and business use case.
StartDate	Date	False	No	The date when the item category becomes active. This date determines when the category is available for use in item classification.
EndDate	Date	False	No	The date when the item category becomes inactive. This date prevents the use of obsolete categories in new assignments.
ItemsOnlyFlag	Bool	False	No	Indicates whether the category can contain only items or both items and child categories. A value of 'true' means the category is restricted to items only, while 'false' allows both items and subcategories.
SharedFlag	Bool	False	No	Indicates whether the category is shared across multiple catalogs. A value of 'true' means the category is available for use in multiple item catalogs.
CreationDateTime	Datetime	False	No	The timestamp when the category was created. This timestamp helps track the category's creation for auditing and historical reference.
LastUpdateDateTime	Datetime	False	No	The timestamp of the most recent update to the category. This timestamp ensures proper version control and change tracking.
Bind_CatalogCode	String	False	No	The catalog code used for binding category data during service calls or data retrieval operations. This code ensures consistency in catalog-category relationships.
Finder	String	False	No	The name of the predefined finder query used to retrieve category records dynamically. This query improves search efficiency and category management.
FunctionalAreaId	Long	False	No	The unique identifier of the functional area associated with this category. This identifier ensures that categories are correctly linked to relevant business functions.

Return to Top

ItemCategoriesattachments

Name	Type	ReadOnly	FilterOnly	Description
ItemCategoriesCatalogId [KEY]	Long	False	No	The unique identifier of the catalog associated with this category attachment. This identifier ensures that the attachment is linked to the correct catalog.
ItemCategoriesCategoryId [KEY]	Long	False	No	The unique identifier of the category to which the attachment belongs. This identifier establishes the relationship between the category and its supporting documents.
LastUpdateDate	Datetime	False	No	The timestamp of the most recent update to the attachment. This timestamp is used for tracking modifications and maintaining version history.
LastUpdatedBy	String	False	No	The username or identifier of the user who last modified the attachment. This field helps track changes and maintain accountability.
DatatypeCode	String	False	No	The data type code representing the type of the attachment (for example, 'text', 'image', or 'PDF'). This code is used for categorizing and processing attachments.
FileName	String	False	No	The original name of the uploaded file. This name provides a human-readable reference for identifying documents.
DmFolderPath	String	False	No	The repository folder path where the attachment is stored. This path defines the attachment’s location in the document management system.
Url	String	False	No	The direct Uniform Resource Locator (URL) of the attachment, allowing users to access it via a web browser or API. This URL ensures quick retrieval of stored files.
CategoryName	String	False	No	The name of the category associated with the attachment. This name provides a human-readable reference for categorization.
UserName	String	False	No	The username of the individual who uploaded or owns the attachment. This username provides visibility into content ownership.
Uri	String	False	No	The URI (Uniform Resource Identifier) of the attachment, which serves as a unique reference for retrieval in content management systems. This identifier ensures system-wide consistency in referencing files.
FileUrl	String	False	No	The URL specifically pointing to the attached file, enabling direct access and downloads. This URL provides an alternative method for retrieving stored documents.
UploadedText	String	False	No	The textual content of the attachment. This content is used for storing plain text-based attachments.
UploadedFileContentType	String	False	No	The content type of the uploaded file. This type helps in correctly handling file types in processing and display.
UploadedFileLength	Long	False	No	The file size of the uploaded attachment in bytes. This metric is used for storage management and enforcing file size restrictions.
UploadedFileName	String	False	No	The name of the file when uploaded, which can differ from the original file name if renaming occurs during processing. This name is essential for maintaining accurate file records.
ContentRepositoryFileShared	Bool	False	No	Indicates whether the attachment is shared with other users. A value of 'true' means the attachment is shared, while 'false' means it is not shared. The default value is 'false'.
Title	String	False	No	The title or display name of the attachment. This title is used for identifying attachments in lists and reports.
Description	String	False	No	A brief description of the attachment's contents. This description provides context for users reviewing attachments related to an item category.
ErrorStatusCode	String	False	No	A system-generated error code, if any, related to the attachment. This code is used for diagnosing upload or processing issues.
ErrorStatusMessage	String	False	No	A descriptive error message providing details about an issue encountered while processing the attachment. This message assists in troubleshooting errors.
CreatedBy	String	False	No	The username or identifier of the user who originally uploaded the attachment. This field helps track content ownership and submission history.
CreationDate	Datetime	False	No	The timestamp when the attachment was first uploaded. This timestamp provides historical tracking of content additions.
DownloadInfo	String	False	No	A JSON object containing metadata and parameters needed to programmatically retrieve a file attachment. This information is used for system integrations and automated file access.
DocumentURL	String	False	No	The URL of the document stored in the content repository. This URL enables direct access for viewing or downloading the document.
Bind_CatalogCode	String	False	No	The catalog code used for binding category attachment data during service calls or data retrieval operations. This code ensures consistency in catalog-category relationships.
CatalogId	Long	False	No	The unique identifier of the catalog associated with the attachment. This identifier ensures attachments are correctly linked to the appropriate catalog.
CategoryId	Long	False	No	The unique identifier of the item category associated with this attachment. This identifier ensures that attachments are linked to the correct category within the catalog.
Finder	String	False	No	The name of the predefined finder query used to retrieve category attachment records dynamically. This query improves efficiency in searching for category attachments.
FunctionalAreaId	Long	False	No	The unique identifier of the functional area associated with this category attachment. This identifier ensures that attachments are linked to relevant business functions.

Return to Top

ItemCategoriesattachmentsattachmentDFF

Name	Type	ReadOnly	FilterOnly	Description
ItemCategoriesCatalogId [KEY]	Long	False	No	The unique identifier of the catalog associated with this category attachment. This identifier ensures that the attachment is correctly linked to the appropriate item catalog.
ItemCategoriesCategoryId [KEY]	Long	False	No	The unique identifier of the category to which the attachment belongs. This identifier establishes the relationship between an item category and its associated attachment.
AttachedDocumentId [KEY]	Long	False	No	The unique identifier assigned to the attached document. This identifier ensures accurate tracking and retrieval of category-specific attachments within the system.
_FLEX_Context	String	False	No	The descriptive flexfield (DFF) context associated with the category attachment. This context defines the specific set of additional attributes available for the attachment.
_FLEX_Context_DisplayValue	String	False	No	The user-friendly display value of the DFF context for category attachments. This value is used in UI screens and reports to present meaningful information.
Bind_CatalogCode	String	False	No	The catalog code used for binding category attachment data during service calls or data retrieval operations. This code ensures data consistency in catalog-category relationships.
CatalogId	Long	False	No	The unique identifier of the catalog to which the item category and its attachments belong. This identifier ensures that category attachments are properly associated with their catalog.
CategoryId	Long	False	No	The unique identifier of the item category associated with this attachment. This identifier ensures that attachments are correctly linked to their respective item categories.
Finder	String	False	No	The name of the predefined finder query used to retrieve DFF attachment records dynamically. This query improves efficiency in searching for and managing category attachments.
FunctionalAreaId	Long	False	No	The unique identifier of the functional area associated with this category attachment. This identifier ensures that attachments are correctly linked to relevant business functions within the system.

Return to Top

ItemCategoriesDFF

Name	Type	ReadOnly	FilterOnly	Description
ItemCategoriesCatalogId [KEY]	Long	False	No	The unique identifier of the catalog associated with this category descriptive flexfield (DFF). This identifier ensures that the category's flexfield data is correctly linked to the appropriate item catalog.
ItemCategoriesCategoryId [KEY]	Long	False	No	The unique identifier of the category associated with this descriptive flexfield (DFF). This identifier establishes the relationship between an item category and its extended attributes.
CategoryId [KEY]	Long	False	No	The default category identifier associated with this descriptive flexfield (DFF). This identifier is used when a category is automatically assigned based on predefined rules.
_FLEX_ValidationDate	Date	False	No	The date used for validating the descriptive flexfield (DFF) values. This date ensures that flexfield configurations are correctly applied based on the effective date.
_FLEX_Context	String	False	No	The descriptive flexfield (DFF) context associated with the category. This context determines which set of additional attributes are applicable for the category.
_FLEX_NumOfSegments	Int	False	No	The total number of segments defined in the descriptive flexfield (DFF) for this category. This value indicates the number of configurable fields available in the flexfield.
_FLEX_NumOfVisibleSegments	Int	False	No	The number of flexfield segments that are visible to users for data entry. This value ensures that only relevant fields are displayed based on the flexfield configuration.
Bind_CatalogCode	String	False	No	The catalog code used for binding category data during service calls or data retrieval operations. This binding ensures consistency in catalog-category relationships.
CatalogId	Long	False	No	The unique identifier of the catalog to which the item category and its descriptive flexfield attributes belong. This identifier ensures that category flexfields are properly associated with their catalog.
Finder	String	False	No	The name of the predefined finder query used to retrieve descriptive flexfield (DFF) records dynamically. This query improves efficiency in searching for category flexfield data.
FunctionalAreaId	Long	False	No	The unique identifier of the functional area associated with this category flexfield. This identifier ensures that the category attributes are correctly linked to relevant business functions within the system.

Return to Top

ItemCategoriestranslatableAttributes

Name	Type	ReadOnly	FilterOnly	Description
ItemCategoriesCatalogId [KEY]	Long	False	No	The unique identifier of the catalog associated with this translatable category attribute entry. This identifier links the category's multilingual attributes to the correct catalog.
ItemCategoriesCategoryId [KEY]	Long	False	No	The unique identifier of the category associated with this translatable attribute entry. This identifier ensures that the translated attributes are correctly linked to the appropriate category.
CategoryId [KEY]	Long	False	No	The unique identifier assigned to the category. This identifier ensures accurate reference and tracking of the category across multiple languages.
CategoryName	String	False	No	The translated name of the category in the specified language. This field supports localization to ensure users in different regions can view the category in their preferred language.
Description	String	False	No	The translated description of the category in the specified language. This field ensures that category details are accurately represented across different languages.
Language [KEY]	String	False	No	The language code representing the translated attributes for the category. This code follows ISO language standards to specify the language used for translation.
SourceLanguage	String	False	No	The original language code of the category attributes before translation. This field tracks the source language from which translations are derived.
CreationDateTime	Datetime	False	No	The timestamp when the translated category attributes were created. This timestamp provides historical tracking for multilingual data management.
LastUpdateDateTime	Datetime	False	No	The timestamp of the most recent update to the translated category attributes. This timestamp helps track modifications and ensures version control.
Bind_CatalogCode	String	False	No	The catalog code used for binding category translation data during service calls or data retrieval operations. This binding ensures consistency in catalog-category relationships across different languages.
CatalogId	Long	False	No	The unique identifier of the catalog to which the translated category attributes belong. This identifier ensures that translations are correctly linked to their respective catalogs.
Finder	String	False	No	The name of the predefined finder query used to retrieve translatable category attribute records dynamically. This query improves efficiency in searching for and managing multilingual category data.
FunctionalAreaId	Long	False	No	The unique identifier of the functional area associated with this category translation. This identifier ensures that translated attributes are correctly linked to relevant business functions within the system.

Return to Top

ItemCategoryAssignments

Name	Type	ReadOnly	FilterOnly	Description
CatalogId [KEY]	Long	False	No	The unique identifier of the catalog associated with this item category assignment. This identifier ensures that the category assignment is correctly linked to the appropriate catalog.
CatalogCode	String	False	No	The unique code assigned to the catalog. This code is used for quick reference and helps identify which catalog the category assignment belongs to.
CatalogName	String	False	No	The name of the catalog associated with the category assignment. This name provides a human-readable identifier for easier navigation and reporting.
CategoryId [KEY]	Long	False	No	The unique identifier of the category to which the item is assigned. This identifier ensures that items are correctly classified within the catalog structure.
CategoryCode	String	False	No	The unique code that identifies the item category. This code is used for reporting, system integration, and quick reference.
CategoryName	String	False	No	The name of the category associated with the item. This name provides a user-friendly reference to categorize items effectively.
ItemId [KEY]	Long	False	No	The unique identifier of the item being assigned to a category. This identifier ensures that each item is correctly linked to a category within the catalog.
OrganizationId [KEY]	Long	False	No	The unique identifier of the organization associated with the item category assignment. This identifier ensures that category assignments are properly scoped within the enterprise structure.
Item	String	False	No	The name or unique identifier of the item being assigned to the category. This identifier is used for product tracking and classification.
OrganizationCode	String	False	No	The unique code representing the organization associated with the item category assignment. This code ensures proper assignment across different organizational units.
ItemDescription	String	False	No	A detailed description of the item being assigned to the category. This description provides additional context for item classification and reporting.
ItemClassId	Long	False	No	The unique identifier of the item class associated with the item. This identifier ensures that the item classification follows predefined categorization standards.
ItemClassName	String	False	No	The name of the item class to which the item belongs. This name provides a human-readable reference to item classifications within the catalog structure.
StartDate	Date	False	No	The date when the item category assignment becomes active. This date ensures that the assignment is valid within a specific time range.
EndDate	Date	False	No	The date when the item category assignment expires. This date prevents the use of obsolete category assignments for items.
Finder	String	False	No	The name of the predefined finder query used to retrieve item category assignment records dynamically. This query improves efficiency in searching and managing category assignments.

Return to Top

ItemsV2

Name	Type	ReadOnly	FilterOnly	Description
ItemId [KEY]	Long	False	No	The unique identifier assigned to the item. This identifier is used for tracking and managing the item across different modules and transactions.
OrganizationId [KEY]	Long	False	No	The unique identifier of the organization associated with the item. This identifier ensures that the item is properly linked to a specific business unit or facility.
OrganizationCode	String	False	No	The unique code representing the organization that owns or manages the item. This code is used for inventory, procurement, and operational tracking.
ItemClass	String	False	No	The classification of the item within the catalog structure. This value determines the item’s grouping based on predefined business rules.
Template	String	False	No	The item template applied to define default attributes for item creation. Templates standardize item setup and reduce manual data entry.
ItemNumber	String	False	No	The unique identifier assigned to the item, typically used for reference in transactions, reports, and system integrations.
ItemDescription	String	False	No	A short description of the item, providing key details for easy identification and usage.
ApprovalStatusValue	String	False	No	The approval status of the item, indicating whether it is pending approval, approved, or rejected within workflows.
ItemStatusValue	String	False	No	The current lifecycle status of the item, such as 'Active', 'Inactive', or 'Obsolete'. This status determines its usability in business processes.
LifecyclePhaseValue	String	False	No	The lifecycle phase that the item is in, such as 'Prototype', 'Production', or 'End of Life'. This value helps in managing product transitions.
StyleItemFlag	Bool	False	No	Indicates whether the item is a style item. A value of 'true' means the item represents a product family with multiple variations.
StyleItemNumberValue	String	False	No	The style item number associated with the item, used to group similar products under a common style reference.
Keyword	String	False	No	A keyword associated with the item to enhance searchability and improve catalog navigation.
IgnoreDuplicateItemFlag	Bool	False	No	Indicates whether duplicate item checks should be ignored when creating or updating the item. A value of 'true' bypasses duplicate validation.
UserItemTypeValue	String	False	No	The user-defined item type, which categorizes the item based on business-specific classification.
PackTypeValue	String	False	No	The packaging type assigned to the item, such as 'Box', 'Pallet', or 'Unit'. This value impacts logistics and shipping.
LongDescription	String	False	No	A detailed description of the item, providing additional context for procurement, sales, and inventory management.
FormattedDescription	String	False	No	A structured version of the item description with formatted content for improved readability and presentation.
PrimaryUOMValue	String	False	No	The primary unit of measure (UOM) used for the item, such as 'Each', 'Kilogram', or 'Liter'. This value standardizes item transactions.
TransactionConversionValue	String	False	No	The conversion factor applied to the primary UOM for transactional purposes. This field is useful when managing different unit conversions.
DefaultingControlValue	String	False	No	The defaulting control settings that define how item attributes are populated automatically during item creation.
PositiveDeviationFactor	Decimal	False	No	The allowable positive deviation percentage for the item, typically used in quality control and inventory tolerances.
NegativeDeviationFactor	Decimal	False	No	The allowable negative deviation percentage for the item. This metric defines acceptable variation limits in measurements or transactions.
CopyItemAndApplyTemplatesFlag	Bool	False	No	Indicates whether an existing item should be copied with applied templates. A value of 'true' enables item replication with standardized attributes.
CopyAssociationsFlag	Bool	False	No	Indicates whether associations (such as related items, substitute items, or cross-references) should be copied from the source item.
CopyAttachmentsFlag	Bool	False	No	Indicates whether file attachments linked to the source item should be copied when creating a new item.
CopyCategoriesFlag	Bool	False	No	Indicates whether category assignments should be copied from the source item. This ensures that the new item retains the same categorization.
CopyFromItemValue	String	False	No	Specifies the item number of the source item to be copied when creating a new item.
CopyFromRevisionValue	String	False	No	Specifies the revision number of the source item to be copied when creating a new item.
CopyFromVersionValue	String	False	No	Specifies the version number of the source item to be copied when creating a new item.
CopyOrganizationAssignmentsFlag	Bool	False	No	Indicates whether organization-specific assignments should be copied from the source item. A value of 'true' enables replication across organizations.
LastSubmittedNewItemRequest	String	False	No	The reference to the last new item request submitted for this item. This reference helps track item creation requests in workflow approvals.
ChangeNotice	String	False	No	The change notice associated with the item, indicating modifications or updates made as part of an engineering change process.
ChangeOrderLineSequenceNumber	Int	False	No	The sequence number of the item within a change order. This field determines the order of execution for changes applied to the item.
StructureItemTypeValue	String	False	No	Specifies the type of item structure, such as 'Standard', 'Model', or 'Configurable'. This value determines how the item is structured in the product definition.
CreateConfiguredItem	String	False	No	Indicates whether a configured item should be created dynamically based on customer or manufacturing requirements.
ConfigModelTypeValue	String	False	No	Defines the type of configuration model associated with the item, such as Pick-to-Order or Assemble-to-Order. This classification influences order management and fulfillment processes.
EffectivityControlValue	String	False	No	Specifies the method used to determine when an item configuration becomes effective, such as 'Date' or 'Revision-based control'.
BaseItemValue	String	False	No	Represents the base item from which a configured item is derived. This is used in engineering and configurable product setups.
AutoCreatedConfigurationFlag	Bool	False	No	Indicates whether the system automatically creates a configuration for the item when needed. A value of 'true' enables automated configuration generation.
PickComponentsFlag	Bool	False	No	Indicates whether components of the item can be picked from inventory. This flag is relevant for Make-to-Order and Configure-to-Order processes.
AssembleToOrderFlag	Bool	False	No	Indicates whether the item is assembled upon order placement. This is commonly used in Assemble-to-Order manufacturing environments.
CostingEnabledFlag	Bool	False	No	Indicates whether the item is included in costing calculations. A value of 'true' ensures that the item is factored into cost roll-ups and inventory valuation.
IncludeInRollUpFlag	Bool	False	No	Indicates whether the item’s cost should be included in cost roll-up calculations. This flag ensures accurate cost accounting for assemblies and subassemblies.
StandardLotSize	Decimal	False	No	Defines the standard production or purchasing lot size for the item. This value helps in inventory planning and economic order quantity calculations.
InventoryAssetFlag	Bool	False	No	Indicates whether the item is tracked as an asset in inventory. A value of 'true' ensures that the item is accounted for as an inventory asset.
BuildInWIPFlag	Bool	False	No	Indicates whether the item can be built in Work-in-Process (WIP) manufacturing. A value of 'true' enables tracking of the item in WIP transactions.
WIPSupplyTypeValue	String	False	No	Specifies the type of supply source for the item in Work-in-Process (WIP), such as 'Push', 'Pull', or 'Assembly Pick'.
WIPSupplyLocatorValue	String	False	No	Defines the specific inventory locator used to source components for WIP transactions. This ensures that materials are sourced from the correct location.
WIPSupplySubinventoryValue	String	False	No	Defines the subinventory from which materials are issued for WIP manufacturing. This value helps in inventory tracking and material flow management.
OvercompletionToleranceTypeValue	String	False	No	Defines the type of tolerance allowed for overcompletion of manufacturing work orders. Common values include 'Percentage' or 'Fixed Quantity'.
OvercompletionToleranceValue	Decimal	False	No	Specifies the allowed overcompletion percentage or quantity for the item in manufacturing processes. This prevents excessive production beyond planned quantities.
InventoryCarryPenalty	Decimal	False	No	Specifies the penalty cost associated with carrying excess inventory for this item. This value is used in cost optimization and inventory management models.
OperationSlackPenalty	Decimal	False	No	Defines the penalty cost applied when an operation is delayed. This value helps in scheduling optimization and production efficiency analysis.
RecipeEnabledFlag	Bool	False	No	Indicates whether the item is enabled for recipe-based production. This flag is commonly used in process manufacturing industries such as chemicals and food production.
ProcessQualityEnabledFlag	Bool	False	No	Indicates whether the item requires process quality tracking. A value of 'true' ensures that quality parameters are monitored during production.
ProcessCostingEnabledFlag	Bool	False	No	Indicates whether the item is included in process costing calculations. This flag is critical for tracking costs in batch and continuous production environments.
ProcessExecutionEnabledFlag	Bool	False	No	Indicates whether the item is eligible for execution in a process manufacturing workflow. A value of 'true' ensures that the item follows process-based routing.
ProcessSupplySubinventoryValue	String	False	No	Defines the subinventory from which raw materials are supplied for process manufacturing. This field ensures correct inventory allocation.
ProcessSupplyLocatorValue	String	False	No	Defines the inventory locator for sourcing raw materials in process manufacturing. This locator value helps manage warehouse locations efficiently.
ProcessYieldSubinventoryValue	String	False	No	Defines the subinventory where yield or output from a process is stored. This field ensures that finished goods are properly accounted for in inventory.
ProcessYieldLocatorValue	String	False	No	Defines the inventory locator where yield from a process is stored. This locator value helps in tracking production outputs within the warehouse.
HazardousMaterialFlag	Bool	False	No	Indicates whether the item is classified as hazardous material. A value of 'true' ensures compliance with regulatory requirements for hazardous goods handling.
CASNumber	String	False	No	The Chemical Abstracts Service (CAS) number associated with the item. This number is used for identifying and tracking chemical substances.
AssetTrackedFlag	Bool	False	No	Indicates whether the item is tracked as a capital asset. A value of 'true' ensures that the item is included in asset management and depreciation calculations.
AssetClassValue	String	False	No	Defines the asset class to which the item belongs. This classification is used for asset categorization and financial reporting.
ServiceRequestEnabledValue	String	False	No	Indicates whether service requests can be created for the item. This value ensures that the item is included in service management workflows.
DefectTrackingOnFlag	Bool	False	No	Indicates whether defect tracking is enabled for the item. A value of 'true' ensures that quality issues are recorded and monitored.
ServiceDurationTypeValue	String	False	No	Defines the duration type associated with the service linked to the item, such as 'Fixed' or 'Variable' duration. This value is used in service contracts and warranties.
ServiceDuration	Decimal	False	No	Specifies the duration of the service associated with the item. This value defines how long the service is valid or active.
ServiceDurationPeriodValue	String	False	No	Defines the unit of time for the service duration, such as 'Days', 'Months', or 'Years'. This metric determines how service contracts and warranties are structured.
ServiceStartTypeValue	String	False	No	Indicates how the service start date is determined, such as 'Immediate', 'On Activation', or 'On Shipment'. This setting controls when service coverage begins.
ServiceStartDelay	Decimal	False	No	Defines a delay period before the service starts. This metric is useful for contracts where service begins after a predefined waiting period.
AllowSuspendFlag	Bool	False	No	Indicates whether the service can be suspended temporarily. A value of 'true' allows service to be paused and resumed later.
AllowTerminateFlag	Bool	False	No	Indicates whether the service can be terminated before its scheduled end. A value of 'true' allows early termination with possible financial implications.
RequiresItemAssociationFlag	Bool	False	No	Specifies whether the service requires an associated item. This flag ensures that the service is only applicable when linked to a product or asset.
CreateFixedAssetFlag	Bool	False	No	Indicates whether the item should be created as a fixed asset upon acquisition. This flag is relevant for capital goods and long-term asset tracking.
InstanceClassValue	String	False	No	Defines the classification of the item instance, such as 'Serialized' or 'Lot-Controlled'. This classification helps in tracking and managing item uniqueness.
BillingTypeValue	String	False	No	Specifies the billing type associated with the item, such as 'One-Time', 'Subscription', or 'Recurring'. This value impacts revenue recognition and invoicing.
ServiceBillingEnabledFlag	Bool	False	No	Indicates whether service billing is enabled for the item. A value of 'true' ensures that the service can be included in customer billing cycles.
RecoveredPartDispositionValue	String	False	No	Defines the disposition of recovered parts when servicing the item, such as 'Refurbish', 'Scrap', or 'Return to Inventory'.
InventoryItemFlag	Bool	False	No	Indicates whether the item is managed in inventory. A value of 'true' ensures that the item can be stocked and tracked within warehouse operations.
StockEnabledFlag	Bool	False	No	Indicates whether the item is available for stocking in inventory. A value of 'true' allows the item to be physically stored and managed in warehouses.
MaterialTransactionEnabledFlag	Bool	False	No	Indicates whether material transactions can be performed on the item. This flag controls whether inventory movements are allowed.
ReservableFlag	Bool	False	No	Indicates whether the item can be reserved for future transactions. A value of 'true' ensures availability for sales orders, work orders, or other allocations.
CheckMaterialShortageFlag	Bool	False	No	Determines whether the system should check for material shortages when processing transactions. A value of 'true' triggers inventory checks.
RevisionQuantityControlFlag	Bool	False	No	Indicates whether item quantity is controlled based on revision. This flag is used when tracking quantity changes across item revisions.
BulkPickedFlag	Bool	False	No	Specifies whether the item is picked in bulk during warehouse operations. A value of 'true' optimizes batch picking processes.
LotControlValue	String	False	No	Defines the lot control method for the item, such as 'Full Lot Control', 'No Lot Control', or 'User-Defined'. This value impacts traceability and inventory tracking.
StartingLotPrefix	String	False	No	Defines the prefix used for generating lot numbers. This prefix standardizes lot numbering conventions within the organization.
StartingLotNumber	String	False	No	Specifies the starting number for lot generation. This value ensures consistency in lot tracking across inventory records.
MaturityDays	Decimal	False	No	Defines the number of days required for the item to reach maturity. This metric is commonly used in process industries where aging or curing is required.
HoldDays	Decimal	False	No	Specifies the number of days an item must be held before it is available for use or sale. This metric is useful for quarantine or compliance checks.
LotExpirationControlValue	String	False	No	Defines the expiration control method for lot-managed items, such as 'None', 'Shelf Life', or 'User-Defined'. This setting determines how expiration is managed.
ShelfLifeDays	Decimal	False	No	Specifies the number of days an item remains usable before expiration. This metric is critical for perishable goods and regulated materials.
RetestInterval	Decimal	False	No	Defines the interval at which the item must be retested for quality compliance. This interval ensures ongoing product viability and adherence to standards.
ExpirationActionValue	String	False	No	Specifies the action taken when an item reaches expiration, such as 'Dispose', 'Rework', or 'Extend Shelf Life'.
ExpirationActionInterval	Decimal	False	No	Defines the number of days before or after expiration when the expiration action should be triggered. This metric helps in proactive inventory management.
ChildLotEnabledFlag	Bool	False	No	Indicates whether child lots are allowed for the item. A value of 'true' allows hierarchical lot structuring.
ChildLotFormatValidationFlag	Bool	False	No	Determines whether child lot numbers must follow a specific format. This flag ensures compliance with lot numbering policies.
CopyLotAttributeFlag	Bool	False	No	Indicates whether lot attributes should be copied when creating new lots. A value of 'true' ensures attribute consistency across lots.
ChildLotPrefix	String	False	No	Defines the prefix for child lot numbers. This prefix maintains a structured naming convention for sub-lots.
ChildLotStartingNumber	Decimal	False	No	Specifies the starting number for generating child lots. This value ensures sequential tracking of sub-lots.
ChildLotParent	String	False	No	Defines the parent lot to which a child lot belongs. This value establishes hierarchical relationships between primary and secondary lots.
LotTranslateEnabledFlag	Bool	False	No	Indicates whether lot translation is enabled for the item. A value of 'true' allows lots to be translated into alternative identifiers for business operations.
LotSplitEnabledFlag	Bool	False	No	Determines whether an existing lot can be split into multiple smaller lots. This flag is useful for inventory management and partial allocations.
LotDivisibleFlag	Bool	False	No	Indicates whether a lot-controlled item can be divided into smaller quantities. A value of 'true' allows fractional lot transactions.
LotSubstitutionEnabledFlag	Bool	False	No	Specifies whether the system allows lot substitution for this item. This flag enables flexibility in fulfilling orders when the primary lot is unavailable.
LotMergeEnabledFlag	Bool	False	No	Indicates whether multiple lots can be merged into a single lot. A value of 'true' allows consolidation of inventory under one lot number.
GradeControlFlag	Bool	False	No	Specifies whether grade control is enabled for the item. Grade control is used for quality-based inventory classification.
DefaultGradeValue	String	False	No	Defines the default grade assigned to the item when grade control is enabled. This value helps standardize quality levels in inventory.
SerialGenerationValue	String	False	No	Determines how serial numbers are generated for the item, such as 'Predefined', 'Manual', or 'Dynamic assignment'.
SerialStartingPrefix	String	False	No	Specifies the prefix used when generating serial numbers. This prefix standardizes serial number formatting across the organization.
SerialStartingNumber	String	False	No	Defines the starting number for serial-number generation. This number ensures sequential numbering for serialized items.
NegativeMeasurementError	Decimal	False	No	Specifies the allowable negative measurement error for the item. This value defines acceptable tolerance in inventory and production processes.
PositiveMeasurementError	Decimal	False	No	Defines the allowable positive measurement error for the item. This setting ensures consistency in measurement-based transactions.
CycleCountEnabledFlag	Bool	False	No	Indicates whether the item is included in cycle counting programs. A value of 'true' ensures that the item is subject to regular inventory audits.
LotStatusEnabledFlag	Bool	False	No	Determines whether lot status tracking is enabled for the item. A value of 'true' allows specific lots to be designated with status labels such as 'Quarantine' or 'Released'.
SerialStatusEnabledFlag	Bool	False	No	Indicates whether serial number status tracking is enabled. A value of 'true' allows individual serial numbers to have assigned statuses.
DefaultLotStatusValue	String	False	No	Defines the default status assigned to new lots of this item. This value helps enforce inventory controls upon lot creation.
DefaultSerialStatusValue	String	False	No	Specifies the default status assigned to new serial numbers. This setting ensures proper tracking and control of serialized inventory.
RestrictSubinventoriesFlag	Bool	False	No	Indicates whether the item is restricted to specific subinventories. A value of 'true' ensures that the item can only be stored in predefined subinventories.
RestrictLocatorsFlag	Bool	False	No	Determines whether the item is restricted to specific locators within the warehouse. A value of 'true' enforces precise location control.
StockLocatorControlValue	String	False	No	Defines how stock locator control is applied, such as 'Predefined', 'Dynamic', or 'None'. This setting determines warehouse location tracking.
DimensionUOMValue	String	False	No	Specifies the UOM for item dimensions, such as 'Inches', 'Centimeters', or 'Meters'.
UnitWidthQuantity	Decimal	False	No	Defines the width of the item based on the specified dimension UOM. This value is used in packing, logistics, and warehouse optimization.
UnitLengthQuantity	Decimal	False	No	Specifies the length of the item based on the defined dimension UOM. This metric helps in calculating storage and shipping requirements.
UnitHeightQuantity	Decimal	False	No	Defines the height of the item in the specified dimension UOM. This metric is critical for packaging and warehouse slotting.
WeightUOMValue	String	False	No	Specifies the UOM used for item weight, such as 'Pounds', 'Kilograms', or 'Ounces'.
UnitWeightQuantity	Decimal	False	No	Defines the weight of a single unit of the item. This metric is used for shipping calculations and inventory valuation.
VolumeUOMValue	String	False	No	Specifies the UOM for volume, such as 'Liters' or 'Cubic Meters'. This metric is useful for capacity planning and logistics.
UnitVolumeQuantity	Decimal	False	No	Defines the volume occupied by a single unit of the item. This value is important for storage, handling, and freight calculations.
ContainerItemFlag	Bool	False	No	Indicates whether the item is a container that holds other items. A value of 'true' allows the item to be used as packaging or a shipping container.
ContainerTypeValue	String	False	No	Defines the type of container used, such as 'Box', 'Pallet', or 'Crate'. This value impacts packaging and transportation planning.
MaximumLoadWeight	Decimal	False	No	Specifies the maximum allowable weight that the item (if used as a container) can hold. This metric helps in capacity planning and shipping regulations.
VehicleItemFlag	Bool	False	No	Indicates whether the item is classified as a vehicle. A value of 'true' designates the item for fleet or transportation management.
InternalVolume	Decimal	False	No	Defines the internal volume of the item when used as a container or storage unit. This value determines how much material it can hold.
MinimumFillPercent	Decimal	False	No	Specifies the minimum fill percentage required before the item (as a container) can be processed for shipment or storage.
WarehouseEquipmentFlag	Bool	False	No	Indicates whether the item is classified as warehouse equipment. A value of 'true' designates the item for logistics, storage, or material handling operations.
EventFlag	Bool	False	No	Indicates whether the item is used in event-driven transactions. A value of 'true' ensures the item is included in event-based workflows, such as promotional events or demand planning.
CollateralFlag	Bool	False	No	Specifies whether the item is classified as collateral, such as marketing materials or promotional assets. A value of 'true' allows the item to be tracked as non-revenue inventory.
CustomerOrderFlag	Bool	False	No	Indicates whether the item can be ordered by customers. A value of 'true' makes the item available for sales orders.
CustomerOrderEnabledFlag	Bool	False	No	Determines whether the item is enabled for customer order processing. A value of 'true' allows the item to be included in order fulfillment workflows.
ATPComponentsValue	String	False	No	Defines the Available-to-Promise (ATP) components that are considered when determining item availability for customer orders.
PickingRuleValue	String	False	No	Specifies the picking rule applied to the item in warehouse management. This rule determines how the item is allocated during order fulfillment.
RMAInspectionRequiredFlag	Bool	False	No	Indicates whether returned items require inspection before processing a return merchandise authorization (RMA). A value of 'true' enforces a quality check before accepting returns.
EligibilityRuleFlag	Bool	False	No	Specifies whether eligibility rules apply to the item, such as customer-specific pricing, discounts, or promotional eligibility.
ReturnableFlag	Bool	False	No	Indicates whether the item is eligible for customer returns. A value of 'true' allows the item to be processed through return order transactions.
ATPValue	String	False	No	Defines the Available-to-Promise (ATP) method used to determine item availability for customer sales and replenishment planning.
FinancingAllowedFlag	Bool	False	No	Indicates whether financing options are available for the item. A value of 'true' enables installment payments or credit-based purchasing.
SalesProductTypeValue	String	False	No	Defines the sales product type classification for the item, such as 'Physical Goods', 'Services', or 'Subscriptions'.
TransactionEnabledFlag	Bool	False	No	Specifies whether the item can be included in financial and operational transactions, such as sales, procurement, and inventory movements.
OrderManagementIndivisibleFlag	Bool	False	No	Indicates whether the item must be ordered in whole quantities. A value of 'true' prevents partial quantities in sales and fulfillment transactions.
DefaultSalesOrderSourceTypeValue	String	False	No	Defines the default sales order source type for the item, such as 'Manual Entry', 'EDI', or 'Web Order'.
ElectronicFormatFlag	Bool	False	No	Specifies whether the item is available in electronic format. A value of 'true' applies to downloadable goods such as software, e-books, or digital media.
ShippableFlag	Bool	False	No	Indicates whether the item is a physical good that requires shipping. A value of 'true' ensures the item is included in logistics and fulfillment operations.
DefaultShippingOrganizationValue	String	False	No	Specifies the default shipping organization responsible for fulfilling orders for this item.
ShipModelCompleteFlag	Bool	False	No	Indicates whether the item must be shipped as a complete model rather than as separate components. A value of 'true' ensures the item is shipped in its entirety.
DownloadableFlag	Bool	False	No	Specifies whether the item is available for digital download. A value of 'true' applies to items such as software, music, or digital documents.
OverShipmentTolerance	Decimal	False	No	Defines the allowable percentage or quantity of over-shipment for the item. This value ensures order fulfillment flexibility.
UnderShipmentTolerance	Decimal	False	No	Specifies the allowable percentage or quantity of under-shipment for the item. This setting ensures partial fulfillment compliance.
OverReturnTolerance	Decimal	False	No	Defines the allowable percentage or quantity of over-returned items. This metric ensures flexibility in customer returns beyond the original order quantity.
UnderReturnTolerance	Decimal	False	No	Specifies the allowable percentage or quantity of under-returned items. This setting helps manage partial returns.
InvoiceEnabledFlag	Bool	False	No	Indicates whether the item is eligible for invoicing. A value of 'true' ensures that the item is included in accounts receivable processing.
AccountingRuleValue	String	False	No	Specifies the accounting rule applied to revenue recognition for the item, such as 'Immediate Recognition' or 'Deferred Revenue'.
PaymentTermsValue	String	False	No	Defines the default payment terms applicable to the item, such as 'Net 30' or 'Due on Receipt'.
OutputTaxClassificationCodeValue	String	False	No	Specifies the tax classification code applied to sales transactions for this item. This value determines tax calculations based on jurisdictional rules.
InvoicedFlag	Bool	False	No	Indicates whether the item has been invoiced. A value of 'true' confirms that the item has been billed to the customer.
InvoicingRuleValue	String	False	No	Defines the invoicing rule applied to the item, such as 'Advance Invoicing', 'Periodic Invoicing', or 'On-Demand Invoicing'.
SalesAccountValue	String	False	No	Specifies the general ledger sales account associated with revenue generated from this item.
WebStatusValue	String	False	No	Defines the availability status of the item for online ordering, such as 'Available', 'Backorder', or 'Discontinued'.
BackOrderableFlag	Bool	False	No	Indicates whether the item can be backordered when stock is unavailable. A value of 'true' allows orders to be placed even if inventory is not on hand.
OrderableOnWebFlag	Bool	False	No	Specifies whether the item is available for ordering through web-based sales channels. A value of 'true' enables e-commerce availability.
MinimumLicenseQuantity	Decimal	False	No	Defines the minimum quantity required for licensing purchases, applicable to software and subscription-based products.
InventoryPlanningMethodValue	String	False	No	Defines the inventory planning method used for the item, such as Min-Max, Reorder Point, or MRP. This value determines how inventory replenishment is managed.
PlanningMakeBuyValue	String	False	No	Specifies whether the item is made in-house ('Make') or procured from a supplier ('Buy'). This value impacts sourcing and supply chain planning.
Planner	String	False	No	The name or identifier of the planner responsible for managing demand and supply planning for this item.
SubcontractingComponentValue	String	False	No	Indicates whether the item is used as a subcontracted component. This value is relevant for outsourced manufacturing processes.
MinimumMinmaxQuantity	Decimal	False	No	Defines the minimum inventory level for the item in a Min-Max planning scenario. When inventory falls below this level, replenishment is triggered.
MaximumMinmaxQuantity	Decimal	False	No	Specifies the maximum inventory level allowed for the item in a Min-Max planning method. Inventory replenishment will not exceed this limit.
MinimumOrderQuantity	Decimal	False	No	Defines the smallest quantity of the item that can be ordered. This value helps enforce economic order quantities and supplier constraints.
MaximumOrderQuantity	Decimal	False	No	Specifies the maximum quantity that can be ordered for the item in a single transaction. This metric ensures alignment with supplier and storage limitations.
OrderCost	Decimal	False	No	Represents the fixed cost associated with placing an order for this item. This value is used in cost analysis and economic order quantity (EOQ) calculations.
SourceOrganizationValue	String	False	No	Specifies the default source organization for the item when using transfer orders or internal sourcing. This value ensures correct material flow between locations.
SourceSubinventoryOrganizationValue	String	False	No	Defines the source subinventory within the organization from which the item is sourced. This value supports detailed inventory allocation.
SourceSubinventoryValue	String	False	No	Indicates the specific subinventory location from which the item is replenished. This value is used for inventory transfers and internal requisitions.
FixedOrderQuantity	Decimal	False	No	Specifies a fixed quantity that must be ordered whenever a replenishment order is placed. This metric is useful for bulk purchasing and batch production.
FixedDaysSupply	Decimal	False	No	Defines the fixed number of days' worth of supply that should be ordered when replenishing inventory. This metric ensures a consistent inventory level.
FixedLotSizeMultiplier	Decimal	False	No	Represents a lot-sizing rule that ensures order quantities are multiples of a predefined amount. This rule prevents inefficient order sizes.
ReleaseAuthorizationRequiredValue	String	False	No	Specifies whether additional authorization is required before releasing a replenishment or manufacturing order.
AutomaticallyExpireASNFlag	Bool	False	No	Indicates whether Advance Shipment Notices (ASNs) for this item should automatically expire if not received within the expected timeframe.
ConsignedFlag	Bool	False	No	Specifies whether the item is managed under a consignment inventory agreement. A value of 'true' means the supplier retains ownership until usage.
ReplenishmentMinimumOrder	Decimal	False	No	Defines the minimum order quantity when replenishing inventory through automated planning or supplier agreements.
ReplenishmentMaximumOrder	Decimal	False	No	Specifies the maximum quantity that can be ordered for replenishment in a single order. This metric prevents excessive procurement.
VMIFixedOrderQuantity	Decimal	False	No	Defines the fixed order quantity used for vendor-managed inventory (VMI). This value ensures consistency in supplier-driven replenishment.
ForecastTypelValue	String	False	No	Specifies the type of demand forecast applied to the item, such as 'Statistical', 'Manual', or 'Consensus'.
ForecastHorizon	Decimal	False	No	Defines the number of periods into the future for which the forecast is generated. This metric helps determine long-term supply planning.
PlanningMethodValue	String	False	No	Indicates the method used for production and procurement planning, such as MRP (Material Requirements Planning) or DRP (Distribution Requirements Planning).
RoundingControlTypeFlag	Bool	False	No	Determines whether rounding rules should be applied to planned order quantities. This flag ensures order quantities align with operational constraints.
CreateSupplyFlag	Bool	False	No	Indicates whether supply should be automatically created for the item when demand is identified. A value of 'true' ensures continuous supply availability.
PlanningTimeFence	String	False	No	Defines the time period within which no automatic changes can be made to the item’s planned supply. This value protects firm orders from being altered.
DemandTimeFence	String	False	No	Specifies the time period within which forecasted demand is considered firm. This value ensures stability in order processing and material planning.
ReleaseTimeFence	String	False	No	Defines the time period within which planned orders are firm and cannot be automatically modified. This value helps stabilize production scheduling.
ShrinkageRate	Decimal	False	No	Represents the expected percentage of shrinkage or loss for the item during manufacturing or storage. This metric accounts for yield losses in planning calculations.
ForecastControlValue	String	False	No	Specifies how the item is handled in forecasting, such as 'Consume', 'Do Not Consume', or 'Manual Forecast Entry'.
AcceptableEarlyDays	Decimal	False	No	Defines the number of days in advance that an order can be fulfilled without being considered early. This ensures flexibility in order fulfillment.
PlanningTimeDays	Decimal	False	No	Specifies the number of days required for planning lead time. This metric affects material and production scheduling.
DemandTimeDays	Decimal	False	No	Defines the number of days within which demand is considered valid for planning and scheduling purposes.
ReleaseTimeDays	Decimal	False	No	Indicates the number of days in advance an order should be released to suppliers or production. This metric ensures timely fulfillment of planned supply.
MRPCalculateATPFlag	Bool	False	No	Indicates whether Available-to-Promise (ATP) is calculated for the item in Material Requirements Planning (MRP). A value of 'true' ensures ATP consideration in supply planning.
RepairLeadtime	Decimal	False	No	Defines the lead time required to repair a defective unit of this item. This value is critical for service parts and maintenance planning.
RepairYield	Decimal	False	No	Specifies the expected percentage of repaired units that meet quality standards. A lower yield can indicate potential rework or scrap losses.
PreprocessingDays	Decimal	False	No	Defines the number of days required before production or procurement activities begin. This metric includes administrative approvals and material preparations.
PostprocessingDays	Decimal	False	No	Indicates the number of days required after production or procurement completion, such as final inspections, packaging, and staging for shipment.
ProcessingDays	Decimal	False	No	Specifies the total number of days required for production, excluding preprocessing and postprocessing. This value is crucial for lead time calculations.
VariableLeadTime	Decimal	False	No	Represents the variable portion of lead time that depends on factors like order quantity and resource availability. This value is used in dynamic scheduling.
CumulativeTotalLeadTime	Decimal	False	No	Defines the total time required to acquire or manufacture the item, including preprocessing, production, postprocessing, and transit time.
FixedLeadTime	Decimal	False	No	Specifies the fixed portion of the lead time that remains constant, regardless of order quantity. This metric accounts for setup and processing overhead.
CumulativeManufacturingLeadTime	Decimal	False	No	Represents the total time required to manufacture the item, including all production stages and interdependencies.
LeadTimeLotSize	Decimal	False	No	Defines the lot size used for calculating lead time. This metric ensures that lead times are adjusted based on batch sizes rather than per-unit calculations.
PurchasingFlag	Bool	False	No	Indicates whether the item can be procured through purchasing transactions. A value of 'true' allows the item to be included in purchase orders.
UseApprovedSupplierFlag	Bool	False	No	Specifies whether the item must be purchased only from approved suppliers. A value of 'true' ensures compliance with procurement policies.
NegotiationRequiredFlag	Bool	False	No	Indicates whether price or terms negotiation is required before issuing a purchase order for this item. A value of 'true' enforces an approval process.
PurchasingInputTaxClassificationValue	String	False	No	Defines the tax classification code applied to the item for purchasing transactions. This code determines applicable tax rates for procurement.
InvoiceCloseTolerancePercentage	Decimal	False	No	Specifies the percentage variance allowed between the invoice amount and purchase order before requiring manual reconciliation.
HazardClassValue	String	False	No	Indicates the hazardous material classification for the item. This classification is used for compliance with transportation and safety regulations.
AssetCategoryValue	String	False	No	Defines the asset category to which the item belongs. This classification is used for financial reporting and asset tracking.
PurchasableFlag	Bool	False	No	Indicates whether the item can be included in purchase orders. A value of 'true' enables procurement transactions for the item.
TaxableFlag	Bool	False	No	Specifies whether the item is subject to tax in purchasing transactions. A value of 'true' applies applicable tax rates.
BuyerOrganizationValue	String	False	No	Defines the organization responsible for purchasing the item. This value ensures proper assignment of procurement responsibilities.
DefaultBuyerValue	String	False	No	Specifies the default buyer assigned to procurement activities for this item. This value streamlines the purchasing workflow.
ReceiptCloseTolerancePercentage	Decimal	False	No	Defines the percentage tolerance for discrepancies between ordered and received quantities before closing the receipt.
UNNumberValue	String	False	No	Represents the United Nations (UN) number assigned to hazardous materials for regulatory compliance and transport classification.
ListPrice	Decimal	False	No	Specifies the standard list price of the item before discounts or negotiated pricing adjustments.
PriceTolerancePercentage	Decimal	False	No	Defines the allowable percentage variation between the purchase price and the standard price before requiring approval.
MarketPrice	Decimal	False	No	Represents the estimated current market price of the item. This estimation is used for benchmarking and pricing analysis.
RoundingFactor	Decimal	False	No	Defines the rounding factor applied when calculating unit prices or order quantities to ensure pricing precision.
MatchApprovalLevelValue	String	False	No	Specifies the required level of approval for matching invoices to purchase orders and receipts, such as 'Two-Way Match' or 'Three-Way Match'.
MatchConfigurationOptionValue	String	False	No	Defines the configuration option used for matching supplier invoices, purchase orders, and receipts to ensure compliance with procurement policies.
ReceiptDateActionValue	String	False	No	Specifies the action taken when an item is received earlier or later than expected, such as 'Accept Early Receipts' or 'Reject Late Receipts'.
DaysEarlyReceiptAllowed	Decimal	False	No	Defines the number of days before the scheduled delivery date that an item can be received without triggering an exception.
DaysLateReceiptAllowed	Decimal	False	No	Defines the number of days after the scheduled receipt date that an item can still be accepted without triggering an exception.
AllowSubstituteReceiptsFlag	Bool	False	No	Indicates whether substitute items can be received in place of the original ordered item. A value of 'true' enables substitution flexibility.
AllowUnorderedReceiptsFlag	Bool	False	No	Specifies whether receipts can be processed for items not explicitly listed on a purchase order. A value of 'true' allows receiving unordered items.
QuantityReceivedToleranceAction	String	False	No	Defines the action taken when received quantity exceeds tolerance limits, such as 'Accept', 'Reject', or 'Require Approval'.
QuantityReceivedTolerancePercentage	Decimal	False	No	Specifies the percentage variance allowed between ordered and received quantities before triggering an exception.
ItemExtensibleFlexfieldCategoryCode	String	False	No	Defines the category code associated with extensible flexfields (EFF) for this item, enabling additional attributes customization.
CreationDate	Datetime	False	No	Indicates the date when the item was originally created in the system. This timestamp is used for auditing and tracking.
LastUpdateDate	Datetime	False	No	Specifies the most recent date when the item record was updated. This timestamp helps track modifications and version control.
BackToBackEnabledFlag	Bool	False	No	Indicates whether back-to-back order fulfillment is enabled for the item. A value of 'true' ensures direct procurement or production upon order placement.
ContractManufacturingFlag	Bool	False	No	Specifies whether the item is used in contract manufacturing scenarios where production is outsourced to third-party manufacturers.
DaysOfCover	Decimal	False	No	Defines the number of days the available inventory is expected to cover demand before requiring replenishment.
DemandPeriod	Decimal	False	No	Indicates the period over which demand is assessed for planning purposes, such as 'daily', 'weekly', or 'monthly'.
SafetyStockPlanningMethodValue	String	False	No	Specifies the safety stock planning method applied to the item, such as Fixed Quantity, Statistical, or Min-Max based calculation.
OutsideProcessServiceFlag	Bool	False	No	Indicates whether the item is associated with outside processing services, commonly used in subcontracting manufacturing workflows.
AllowMaintenanceAssetFlag	Bool	False	No	Specifies whether the item can be used as a maintenance asset. A value of 'true' enables tracking of the item in asset management.
EnableGenealogyTrackingFlag	Bool	False	No	Indicates whether genealogy tracking is enabled for the item, allowing traceability of lot and serial numbers through the supply chain.
EngineeredItemFlag	Bool	False	No	Specifies whether the item is an engineered product requiring controlled design revisions and approvals before release.
ProcurementBusinessUnitName	String	False	No	Defines the business unit responsible for procurement activities related to this item.
ForcePurchaseLeadTimeFlag	Bool	False	No	Indicates whether the item must adhere to a fixed purchase lead time, overriding dynamic calculations.
ReplacementTypeValue	String	False	No	Specifies the type of replacement allowed for the item, such as 'Alternate', 'Substitute', or 'Upgrade'.
BuyerEmailAddress	String	False	No	Stores the email address of the assigned buyer responsible for purchasing this item.
AssetTrackedValue	String	False	No	Indicates how the item is tracked as an asset, such as 'Serial-Controlled' or 'Fixed Asset'.
RequestId	Long	False	No	Represents the system-generated request identifier associated with item creation or updates, used for tracking transactions.
CreatedBy	String	False	No	Specifies the user who originally created the item record.
CreationDateTime	Datetime	False	No	Indicates the exact timestamp when the item record was created in the system.
LastUpdateDateTime	Datetime	False	No	Indicates the exact timestamp when the item record was last updated, ensuring auditability of changes.
LastUpdateLogin	String	False	No	Records the login credentials of the user who last updated the item.
LastUpdatedBy	String	False	No	Specifies the user who made the most recent updates to the item record.
InternallyTransferableFlag	Bool	False	No	Indicates whether the item can be internally transferred between different inventory organizations within the enterprise.
TransferOrdersEnabledFlag	Bool	False	No	Specifies whether transfer orders can be created for this item, allowing movement across different warehouses or locations.
ReplenishmentMaximumDaysOfSupply	Decimal	False	No	Defines the maximum number of days' worth of supply that should be maintained for replenishment planning.
CustomerSelfServiceEnabledFlag	Bool	False	No	Indicates whether customers can view and manage this item via self-service portals. A value of 'true' enables customer access.
AllowPurchasingDocumentDescriptionUpdateFlag	Bool	False	No	Determines whether the description of the item can be modified in purchasing documents, such as purchase orders or requisitions.
EnableContractCoverage	Bool	False	No	Indicates whether the item is covered under a contractual service agreement or extended warranty.
CarryingCostPercentage	Decimal	False	No	Specifies the percentage of carrying cost associated with holding the item in inventory, impacting cost analysis and financial planning.
ReplenishmentMinimumDaysOfSupply	Decimal	False	No	The minimum number of days’ worth of supply required for inventory replenishment planning. This ensures adequate stock availability without overstocking.
AllowExpressTransactionsFlag	Bool	False	No	Indicates whether express transactions are enabled for the item. When set to 'true', it allows for streamlined inventory movements.
ReceiptRoutingValue	String	False	No	Defines the routing method for received goods, such as 'Direct', 'Inspection Required', or 'Standard Receipt'. This value impacts warehouse receiving workflows.
InvoiceMatchOptionValue	String	False	No	Specifies the invoice matching option for procurement transactions, including 'Two-Way Match', 'Three-Way Match', or 'Four-Way Match'.
CommsActivationRequiredFlag	Bool	False	No	Indicates whether communication activation is required for the item, typically used in telecommunications, software licensing, or subscription-based products.
RequiresFulfillmentLocationFlag	Bool	False	No	Specifies whether a fulfillment location must be assigned when processing orders for this item. This value ensures proper inventory allocation and shipping logistics.
IssueUOMValue	String	False	No	Defines the UOM used when issuing the item from inventory, such as 'Each', 'Case', or 'Box'. This impacts material tracking and consumption.
EnforceShipToLocationValue	String	False	No	Determines whether a predefined 'Ship To' location must be strictly followed when fulfilling orders for this item.
StandardCoverageValue	String	False	No	Defines the standard coverage period for the item in supply planning, such as 'Weekly', 'Monthly', or 'Quarterly'. This value impacts replenishment frequency.
ReplenishmentSourceTypeValue	String	False	No	Specifies the replenishment source type for the item, such as 'Supplier', 'Internal Transfer', or 'Subinventory'. This value determines sourcing logic.
TrackingUOMValue	String	False	No	Defines the UOM used for tracking the item, ensuring consistency in inventory transactions.
SecondaryUOMValue	String	False	No	Specifies an alternative unit of measure used for dual-unit tracking of the item, such as conversions between weight and volume.
PricingUOMValue	String	False	No	Defines the UOM used for pricing transactions, ensuring consistency across sales and procurement.
HardPeggingLevelValue	String	False	No	Specifies the pegging level for demand and supply, such as 'Project', 'Task', or 'None'. This determines how inventory is allocated based on constraints.
CommonSupplyProjectDemandFlag	Bool	False	No	Indicates whether common supply can be used to fulfill multiple project demands. A value of 'true' enables pooled inventory management.
EnableIotFlag	Bool	False	No	Specifies whether the item is enabled for Internet of Things (IoT) tracking, allowing integration with smart devices for real-time monitoring.
ExpenditureTypeValue	String	False	No	Defines the expenditure type associated with the item, used for cost tracking and financial reporting.
PackagingStringValue	String	False	No	Represents the packaging configuration of the item, such as 'Bundle', 'Carton', or 'Pallet'. This value impacts shipping and warehouse storage.
CreateSupplyAfterDate	Date	False	No	Specifies the earliest date after which supply can be created for this item. This date ensures planned supply aligns with business demand.
CreateFixedAssetValue	String	False	No	Indicates whether the item should be treated as a fixed asset upon acquisition. This value impacts asset capitalization and financial tracking.
UnderCompletionToleranceTypeValue	String	False	No	Defines the type of tolerance allowed for under-completion of manufacturing or supply chain transactions, such as 'Percentage' or 'Fixed Quantity'.
UnderCompletionToleranceValue	Decimal	False	No	Specifies the allowed under-completion percentage or quantity for the item in manufacturing or procurement. This metric prevents early work closure with insufficient output.
DefaultRepairTransactionName	String	False	No	Defines the default repair transaction name associated with the item, used in service and maintenance operations.
CreatedFromItemId	Long	False	No	Specifies the unique identifier of the source item from which this item was created. This identifier is used in item versioning and lifecycle management.
CreatedFromItemNumber	String	False	No	Indicates the item number of the source item from which this item was derived, ensuring traceability in the supply chain.
CreatedFromItemRevision	String	False	No	Defines the revision of the source item used to create this item. This revision ensures consistency in engineering and manufacturing records.
ItemObjectTypeValue	String	False	No	Specifies the object type of the item, such as 'Standard Item', 'Kit', or 'Bundle'. This classification influences processing rules and business logic.
AcdType	String	False	No	Represents the Automated Call Distribution (ACD) type if applicable, typically used in telecommunications or customer service inventory.
ChangeLineId	Long	False	No	Identifies the unique change line associated with this item. This value is used for engineering change management and product lifecycle tracking.
Finder	String	False	No	Specifies the name of the predefined finder query used to dynamically retrieve this item in system transactions.
InventoryOrganizationId	Long	False	No	Represents the unique identifier of the inventory organization responsible for managing this item within a specific business unit.
VersionId	Long	False	No	Defines the version identifier associated with the item. This identifier ensures traceability in product lifecycle management and revision tracking.

Return to Top

ItemsV2ItemAttachment

Name	Type	ReadOnly	FilterOnly	Description
ItemsV2ItemId [KEY]	Long	False	No	The unique identifier for an item in the ItemsV2 module, which links attachments to specific inventory records. This identifier ensures traceability of documents related to a particular item.
ItemsV2OrganizationId [KEY]	Long	False	No	The unique identifier for the organization that owns or manages the item. This identifier ensures that attachments are properly associated with the correct business unit or entity.
AttachedDocumentId [KEY]	Long	False	No	The unique system-generated identifier for a document attached to an item. This identifier serves as a reference to locate the document in the document management system.
LastUpdateDate	Datetime	False	No	The timestamp indicating when the attachment record was last modified. This timestamp is crucial for tracking updates and maintaining version control.
LastUpdatedBy	String	False	No	The username or system entity that performed the last modification on the attachment. This username or entity is used for audit logging and accountability.
DatatypeCode	String	False	No	The code representing the data type of the attached document (for example, 'text', 'image', or 'PDF'). This code determines how the file should be processed and displayed.
FileName	String	False	No	The original name of the attached file as uploaded by the user. This name is retained for user reference and easy identification of attachments.
DmFolderPath	String	False	No	The structured file path where the attachment is stored within the document management system. This path aids in locating files within a complex directory structure.
DmDocumentId	String	False	No	The unique identifier assigned to the document within the document management system. This identifier ensures a reliable reference to the document for retrieval and updates.
DmVersionNumber	String	False	No	The version number of the document in the document management system. This number helps in maintaining a history of document revisions and preventing overwrites.
Url	String	False	No	The direct Uniform Resource Locator (URL) reference for accessing the attached document. This URL enables users to quickly retrieve the file from the system.
CategoryName	String	False	No	The classification category assigned to the attachment. This category helps in organizing and filtering attachments based on their purpose or content type.
UserName	String	False	No	The name of the user who uploaded the attachment. This name is used for tracking document ownership and accountability.
Uri	String	False	No	The Uniform Resource Identifier (URI) that uniquely references the stored attachment within the system. This URI ensures reliable file access.
FileUrl	String	False	No	The web-accessible URL for downloading or viewing the attached file. This URL is useful for remote users who need access to documents without system login.
UploadedText	String	False	No	The extracted text content from an uploaded file, applicable for text-based attachments such as plain text or scanned documents with OCR processing.
UploadedFileContentType	String	False	No	The content type of the uploaded file. This content type determines how the file should be handled by the system.
UploadedFileLength	Long	False	No	The size of the uploaded file in bytes. This metric information is useful for storage management and ensuring file size limitations are adhered to.
UploadedFileName	String	False	No	The original name of the uploaded attachment before being stored in the system. This name helps users recognize files at a glance.
ContentRepositoryFileShared	Bool	False	No	The flag indicating whether the file is shared within the content repository. If set to 'true', multiple users or departments can access the same file.
Title	String	False	No	The title or display name of the attached document. This title or name provides a human-readable identifier for the file.
Description	String	False	No	The detailed description of the attached document, explaining its purpose and contents for better understanding.
ErrorStatusCode	String	False	No	A system-generated error code indicating any issues encountered while processing the attachment. This error code helps in debugging failures.
ErrorStatusMessage	String	False	No	A detailed message associated with an error status code. This message provides human-readable troubleshooting information.
CreatedBy	String	False	No	The username or system entity that originally created the attachment record. This username or entity helps track the source of the document.
CreationDate	Datetime	False	No	The timestamp of when the attachment record was initially created. This timestamp is useful for tracking document history and lifecycle.
FileContents	String	False	No	The binary or textual representation of the attachment's data. This representation can be used for direct storage of file content within the database.
ExpirationDate	Datetime	False	No	The optional expiration date indicating when the attachment should no longer be considered valid or relevant.
LastUpdatedByUserName	String	False	No	The full username of the individual who last updated the attachment. This username provides a clear audit trail for modifications.
CreatedByUserName	String	False	No	The full username of the individual who created the attachment. This username helps track the origin of documents in the system.
DownloadInfo	String	False	No	The metadata related to file downloads, including user activity and download history for audit purposes.
DocumentURL	String	False	No	The direct hyperlink to the document stored in an external document management system, allowing seamless access.
AcdType	String	False	No	The classification type of the attachment, which determines how it is processed and categorized within the system.
ChangeLineId	Long	False	No	The identifier linking the attachment to a specific change record. This identifier ensures traceability of modifications related to a product or process.
Finder	String	False	No	The reference to an internal search or retrieval mechanism that assists users in locating the attachment efficiently.
InventoryOrganizationId	Long	False	No	The unique identifier of the inventory organization responsible for managing the item associated with the attachment.
ItemId	Long	False	No	The unique identifier of the item that the attachment is linked to. This identifier ensures that documents are correctly associated with inventory records.
ItemNumber	String	False	No	The human-readable item number associated with the attachment. This item number provides an easily recognizable reference.
OrganizationCode	String	False	No	The standardized code representing the organization. This code is used for categorization and reporting purposes.
OrganizationId	Long	False	No	The unique identifier of the organization associated with the attachment. This identifier ensures proper organizational mapping.
VersionId	Long	False	No	The identifier representing the version of the attachment record. This identifier allows version control and historical tracking of file changes.

Return to Top

ItemsV2ItemAttachmentAttachedDocumentsDFF

Name	Type	ReadOnly	FilterOnly	Description
ItemsV2ItemId [KEY]	Long	False	No	The unique identifier for an item in the ItemsV2 module, linking attachments to specific inventory records. This identifier ensures traceability of documents related to a particular item.
ItemsV2OrganizationId [KEY]	Long	False	No	The unique identifier for the organization that owns or manages the item. This identifier ensures that attachments are properly associated with the correct business unit or entity.
ItemattachmentAttachedDocumentId [KEY]	Long	False	No	The system-generated unique identifier for an item attachment document. This identifier is used to track specific document records linked to an item.
AttachedDocumentId [KEY]	Long	False	No	The unique identifier for a document that has been attached to an item. This identifier serves as a reference to locate the document in the document management system.
_FLEX_Context	String	False	No	The descriptive flexfield (DFF) context name associated with the item attachment. This context name helps define the specific use case or configuration of the DFF.
_FLEX_Context_DisplayValue	String	False	No	The display value of the DFF context for the item attachment. This value is a human-readable representation of the context name.
AcdType	String	False	No	The classification type of the attached document. This classification type defines its processing rules and categorization within the system.
ChangeLineId	Long	False	No	The identifier linking the attachment to a specific change record. This identifier ensures traceability of modifications related to a product or process.
Finder	String	False	No	The reference to an internal search or retrieval mechanism that assists users in locating the attachment efficiently.
InventoryOrganizationId	Long	False	No	The unique identifier of the inventory organization responsible for managing the item associated with the attachment. This identifier ensures accurate record-keeping and inventory tracking.
ItemId	Long	False	No	The unique identifier of the item that the attachment is linked to. This identifier ensures that documents are correctly associated with inventory records.
ItemNumber	String	False	No	The human-readable item number associated with the attachment. This item number provides an easily recognizable reference.
OrganizationCode	String	False	No	The standardized code representing the organization. This code is used for categorization and reporting purposes.
OrganizationId	Long	False	No	The unique identifier of the organization associated with the attachment. This identifier ensures proper organizational mapping.
VersionId	Long	False	No	The identifier representing the version of the attachment record. This identifier allows version control and historical tracking of file changes.

Return to Top

ItemsV2ItemCategory

Name	Type	ReadOnly	FilterOnly	Description
ItemsV2ItemId [KEY]	Long	False	No	The unique identifier for an item in the ItemsV2 module, establishing a direct link between the item and its category assignment. This identifier ensures proper classification within the inventory system.
ItemsV2OrganizationId [KEY]	Long	False	No	The unique identifier for the organization that owns or manages the item. This identifier ensures that the item's category assignment is correctly linked to the appropriate business entity.
ItemId	Long	False	No	The unique identifier assigned to a specific part, item, product, or service. This identifier is essential for accurately categorizing and managing items across multiple catalogs and classifications.
OrganizationId	Long	False	No	The unique identifier for the organization associated with the item category assignment. This identifier ensures that the categorization aligns with the correct business unit, controlling visibility and access.
ItemCatalog	String	False	No	The name of the item catalog that organizes and classifies items. Item catalogs help standardize product groupings, streamline searches, and support procurement and inventory workflows.
CategoryName	String	False	No	The name of the item category that defines how an item is classified within a catalog. Categories are used for reporting, searching, and enforcing business rules related to items.
SequenceNumber	Int	False	No	The numerical sequence used internally for organizing and ordering category assignments. This numerical sequence is system-managed and not exposed in application code but ensures structured category hierarchies.
ItemCategoryAssignmentId [KEY]	Long	False	No	The unique identifier for the assignment of an item to a category. This identifier record tracks the specific categorization of an item and allows users to audit classification changes over time.
CreationDateTime	Datetime	False	No	The timestamp indicating when the item category assignment was first created. This timestamp is useful for maintaining historical records and ensuring traceability of when an item was classified into a category.
LastUpdateDateTime	Datetime	False	No	The timestamp of the most recent update to the item category assignment. This timestamp helps track when and why an item’s category was modified and ensures up-to-date classification data.
CategoryCode	String	False	No	The standardized abbreviation used to identify an item category. This abbreviation is used in various system transactions and can be configured using the Setup and Maintenance work area in the Manage Catalogs task.
CreatedBy	String	False	No	The username or system entity that originally created the item category assignment. This username or system entity is essential for auditing, as it provides accountability for changes to item classifications.
LastUpdateLogin	String	False	No	The login session or system reference associated with the most recent update to the item category assignment. This value helps administrators track user activity and session-based modifications.
LastUpdatedBy	String	False	No	The username or system entity responsible for the latest modification to the item category assignment. This username or system entity is used for audit logging and tracking classification updates.
ItemCategoryHierarchyName	String	False	No	The name of the hierarchy structure in which the item category is placed. Item-category hierarchies provide multi-level categorization for grouping related products and services.
ItemCategoryHierarchyCode	String	False	No	The unique system-generated code that identifies a specific item category hierarchy. This code ensures standardization across multiple catalogs and supports structured reporting.
StartDate	Date	False	No	The date when the item category assignment becomes active. This date determines when an item is considered part of a category and affects category-driven system processes such as pricing and availability. Functional area catalogs, except those assigned to service logistics, do not allow a start date.
EndDate	Date	False	No	The date when the item category assignment is no longer valid. This date defines the end of an item's association with a specific category and is important for phasing out obsolete classifications. Functional area catalogs, except those assigned to service logistics, do not allow an end date.
RequestId	Long	False	No	The unique identifier assigned to an import request that processes item category assignments. This identifier is generated automatically during import and is used for tracking and validating item publishing operations.
AcdType	String	False	No	The classification type assigned to the item category, which determines its processing logic within the system. This classification type can influence reporting, workflows, and downstream transactions.
ChangeLineId	Long	False	No	The identifier linking an item category assignment to a specific change request. This identifier ensures traceability of modifications related to category updates, product reclassifications, or organizational changes.
Finder	String	False	No	The reference to an internal search or retrieval mechanism that allows users to quickly locate item category assignments based on filters or search parameters.
InventoryOrganizationId	Long	False	No	The unique identifier for the inventory organization responsible for managing the item. This identifier ensures that categorization is aligned with inventory tracking and warehouse management processes.
ItemNumber	String	False	No	The human-readable item number assigned to an item. This item number provides an easily recognizable reference for users searching for items in catalogs and category assignments.
OrganizationCode	String	False	No	The standardized alphanumeric code representing the organization responsible for the item category assignment. This code ensures consistency across reports and integrations.
VersionId	Long	False	No	The system-generated identifier representing the version of an item category assignment. Versioning allows tracking of changes over time, ensuring that users can reference historical classification data.

Return to Top

ItemsV2ItemDFF

Name	Type	ReadOnly	FilterOnly	Description
ItemsV2ItemId [KEY]	Long	False	No	The unique identifier for an item within the ItemsV2 module. This identifier serves as a primary key that links item records to their associated descriptive flexfields (DFFs), ensuring accurate classification, reporting, and business rule enforcement.
ItemsV2OrganizationId [KEY]	Long	False	No	The unique identifier for the organization managing the item. This identifier ensures that item-related DFFs are correctly mapped to the relevant business unit, supporting access control and data segregation.
InventoryItemId [KEY]	Long	False	No	The unique identifier assigned to a specific inventory part, item, product, or service. This identifier is critical for tracking products across procurement, warehouse management, sales, and financial reporting.
OrganizationId [KEY]	Long	False	No	The identifier representing the organization to which the item belongs. This identifier is essential for maintaining accurate inventory and financial records and should be reviewed and updated using the Setup and Maintenance work area under the Manage Inventory Organizations task.
_FLEX_Context	String	False	No	The DFF context name assigned to the item. This field is used to capture additional custom attributes that vary based on business requirements, allowing greater flexibility in item classification and reporting.
_FLEX_Context_DisplayValue	String	False	No	The human-readable display value of the DFF context. This value provides a user-friendly label for custom attributes associated with the item.
AcdType	String	False	No	The classification type assigned to the item, which determines how it is processed within the system. This classification type is essential for defining item behavior, influencing workflows such as pricing models, tax applicability, and supply chain rules.
ChangeLineId	Long	False	No	The unique identifier that links the item record to a specific change request or modification. This identifier ensures traceability of changes made to items, supporting version control and audit tracking.
Finder	String	False	No	The reference to an internal search or query mechanism that helps users efficiently locate item records within the system. This field improves navigation and usability, particularly in environments with large datasets.
InventoryOrganizationId	Long	False	No	The unique identifier of the inventory organization responsible for managing the item. This identifier is critical for aligning inventory transactions, ensuring stock availability, and managing warehouse operations.
ItemId	Long	False	No	The unique identifier for the item, serving as a key reference for inventory, procurement, and product lifecycle management. This identifier is crucial for linking items to DFFs and ensuring accurate data tracking.
ItemNumber	String	False	No	The human-readable item number assigned to a product, part, or service. This item number is used across procurement, sales, and inventory management for quick reference and item identification.
OrganizationCode	String	False	No	The standardized alphanumeric code representing the organization responsible for the item. This code ensures consistency across financial reporting, inventory tracking, and business unit operations.
VersionId	Long	False	No	The system-generated identifier representing the version of the item record. This identifier allows historical tracking of changes, ensuring compliance with regulatory and business reporting requirements.

Return to Top

ItemsV2ItemEffCategory

Name	Type	ReadOnly	FilterOnly	Description
ItemsV2ItemId [KEY]	Long	False	No	The unique identifier for an item within the ItemsV2 module. This identifier serves as a primary key that links item records to their associated effective categories, ensuring proper classification and business rule enforcement.
ItemsV2OrganizationId [KEY]	Long	False	No	The unique identifier for the organization managing the item. This identifier ensures that item-related effective categories are correctly mapped to the relevant business unit, supporting access control and data integrity.
InventoryItemId [KEY]	Long	False	No	The unique identifier assigned to an inventory-managed part, item, product, or service. This identifier plays a crucial role in inventory tracking, procurement, and demand planning processes.
OrganizationId [KEY]	Long	False	No	The unique identifier representing the organization to which the item belongs. Proper assignment of this identifier ensures that category management and classification rules are applied to the correct business unit.
StyleItemId	Long	False	No	The unique identifier assigned to a style item, which represents a base model or template for configurable or variant items. This identifier is essential for managing items with multiple styles or variations in industries such as fashion and manufacturing.
MasterOrganizationId	Long	False	No	The unique identifier for the master organization that governs the item and its associated category across multiple inventory organizations. This identifier enables central management of item definitions while allowing local customization.
CategoryCode	String	False	No	The standardized category code assigned to the item for classification purposes. Categories help group similar items together, enabling structured inventory management, pricing models, and reporting consistency.
StyleItemFlag	Bool	False	No	A flag that indicates whether the item is a style item. A style item serves as a base template for different product variations, commonly used in industries that support configurable items, such as apparel and electronics.
TemplateItemFlag	String	False	No	A flag that determines whether the item serves as a template for predefined item configurations. Template items are often used to streamline the creation of new products with predefined attributes.
AcdType	String	False	No	The classification type assigned to the item, determining how it is processed within the system. This classification type is essential for defining item behavior, influencing workflows such as pricing models, tax applicability, and supply chain rules.
ChangeLineId	Long	False	No	The unique identifier that links the item record to a specific change request or modification. This identifier ensures traceability of changes made to items, supporting version control and audit tracking.
Finder	String	False	No	The reference to an internal search or query mechanism that helps users efficiently locate item records within the system. This reference improves navigation and usability, particularly in environments with large datasets.
InventoryOrganizationId	Long	False	No	The unique identifier of the inventory organization responsible for managing the item. This identifier is critical for aligning inventory transactions, ensuring stock availability, and managing warehouse operations.
ItemId	Long	False	No	The unique identifier for the item, serving as a key reference for inventory, procurement, and product lifecycle management. This identifier is crucial for linking items to effective categories and ensuring accurate data tracking.
ItemNumber	String	False	No	A human-readable item number assigned to a product, part, or service. This item number is used across procurement, sales, and inventory management for quick reference and item identification.
OrganizationCode	String	False	No	The standardized alphanumeric code representing the organization responsible for the item. This code ensures consistency across financial reporting, inventory tracking, and business unit operations.
VersionId	Long	False	No	The system-generated identifier representing the version of the item record. This identifier allows historical tracking of changes, ensuring compliance with regulatory and business reporting requirements.

Return to Top

ItemsV2ItemGlobalDFF

Name	Type	ReadOnly	FilterOnly	Description
ItemsV2ItemId [KEY]	Long	False	No	The unique identifier for an item within the ItemsV2 module. This identifier serves as a key reference linking item records to global descriptive flexfields (DFFs), allowing customization of item attributes for different business needs.
ItemsV2OrganizationId [KEY]	Long	False	No	The unique identifier for the organization that owns or manages the item. This identifier ensures that global DFFs are properly associated with the relevant business unit, supporting access control and organizational data governance.
InventoryItemId [KEY]	Long	False	No	The unique identifier assigned to an inventory-managed part, item, product, or service. This identifier plays a crucial role in inventory tracking, procurement, and demand planning processes, ensuring accurate classification of globally defined item attributes.
OrganizationId [KEY]	Long	False	No	The unique identifier representing the organization to which the item belongs. This identifier ensures that item-level global DFFs are correctly applied across business units and align with enterprise reporting standards.
_FLEX_Context	String	False	No	The DFF context name assigned to the item. This context name determines how additional attributes are applied to items globally, enabling customization of item records based on operational needs.
_FLEX_Context_DisplayValue	String	False	No	A human-readable display value for the DFF context. This value provides an easy-to-understand label for users interacting with item attributes in various modules such as procurement, sales, and inventory.
AcdType	String	False	No	The classification type assigned to the item, which determines how the item is processed within the system. This classification type affects workflows such as tax determination, pricing structures, and business rules related to global product categorization.
ChangeLineId	Long	False	No	The unique identifier that links the item record to a specific change request or modification. This identifier ensures traceability of changes made to items at a global level, supporting version control, audit tracking, and compliance.
Finder	String	False	No	The reference to an internal search or query mechanism that allows users to efficiently locate item records with associated global DFFs. This reference enhances navigation and usability within enterprise applications.
InventoryOrganizationId	Long	False	No	The unique identifier of the inventory organization responsible for managing the item. This identifier ensures that globally defined item attributes align with inventory processes, stock movement, and warehouse management.
ItemId	Long	False	No	The unique identifier for the item, serving as a reference for inventory, procurement, and product lifecycle management. This identifier is crucial for linking items to their global DFFs and ensuring accurate data tracking.
ItemNumber	String	False	No	A human-readable item number assigned to a product, part, or service. This item number is used across procurement, sales, and inventory management to provide quick reference and ensure consistency in global item tracking.
OrganizationCode	String	False	No	The standardized alphanumeric code representing the organization responsible for the item. This code ensures uniformity across financial reporting, inventory tracking, and business unit operations.
VersionId	Long	False	No	The system-generated identifier representing the version of the item record. This identifier allows historical tracking of modifications to global DFFs, ensuring compliance with regulatory and business reporting requirements.

Return to Top

ItemsV2ItemRevision

Name	Type	ReadOnly	FilterOnly	Description
ItemsV2ItemId [KEY]	Long	False	No	The unique identifier for an item within the ItemsV2 module. This identifier serves as a key reference linking item records to their associated revisions, ensuring traceability of changes and historical tracking of modifications.
ItemsV2OrganizationId [KEY]	Long	False	No	The unique identifier for the organization that owns or manages the item. This identifier ensures that revisions are correctly mapped to the appropriate business unit, supporting compliance and revision control.
RevisionId [KEY]	Long	False	No	The unique system-generated identifier that distinguishes a specific revision of an item. This identifier allows businesses to track modifications over time and manage engineering or design updates.
ItemId	Long	False	No	The unique identifier assigned to a specific part, item, product, or service. This identifier is crucial for maintaining the link between items and their revision history, ensuring that updates and modifications are properly recorded.
OrganizationId [KEY]	Long	False	No	The unique identifier representing the organization to which the item belongs. Proper assignment ensures that revision control aligns with the correct business unit and operational processes.
RevisionCode	String	False	No	The code assigned to the revision of an item. This helps categorize and track changes. This code allows businesses to differentiate between multiple versions of a product or component.
ItemRevisionDescription	String	False	No	The detailed description of the item revision. This description provides insight into the purpose of the revision, documenting changes such as design updates, compliance modifications, or process improvements.
RevisionReasonValue	String	False	No	The reason for the revision, selected from a predefined list of accepted values under the lookup type ORA_EGP_SAFETY_STK_PLN_METHOD. This field provides structured documentation of why an item was revised, supporting compliance and process standardization.
EffectivityDate	Datetime	False	No	The date when the revision goes into effect. This date ensures that business processes such as manufacturing, procurement, and sales recognize the correct version of the item at the appropriate time.
ImplementationDate	Datetime	False	No	The date when the revised item is officially implemented in operations. This date is critical for synchronizing production schedules, supplier updates, and inventory adjustments.
EndEffectivityDate	Datetime	False	No	The date when the item revision is no longer in effect. This date businesses transition to newer revisions while maintaining accurate historical records for audit and compliance.
RevisionExtensibleFlexfieldCategoryCode	String	False	No	The abbreviation that identifies the item class associated with the item revision's extensible flexfield (EFF). This abbreviation allows for additional customized attributes relevant to specific product categories and can be configured using the Manage Item Classes task in the Setup and Maintenance work area.
CreationDateTime	Datetime	False	No	The timestamp indicating when the item revision was first created. This timestamp helps track historical changes and ensure proper version control.
LastUpdateDateTime	Datetime	False	No	The timestamp of the most recent update to the item revision record. This timestamp ensures traceability of modifications and supports compliance with revision control policies.
CreatedBy	String	False	No	The username or system entity that originally created the item revision. This username or entity is essential for audit trails and accountability in revision management.
LastUpdateLogin	String	False	No	The session login or system reference associated with the last update to the item revision. This information is useful for security audits and tracking user activity.
LastUpdatedBy	String	False	No	The username or system entity responsible for the most recent modification to the item revision. This username or entity helps maintain accountability and track changes made to revision records.
RequestId	Long	False	No	The unique identifier assigned to an import request related to item revisions. This identifier is generated during data imports and is used for tracking and verifying the success or failure of revision updates.
AcdType	String	False	No	The classification type assigned to the item revision, determining how the revision is processed within the system. This classification type is critical for business rules such as compliance tracking, engineering change orders, and procurement updates.
ChangeLineId	Long	False	No	The unique identifier linking the item revision to a specific change request or modification. This identifier ensures traceability of changes made to items, supporting version control and audit tracking.
Finder	String	False	No	The reference to an internal search or query mechanism that allows users to efficiently locate item revision records. This reference improves usability and enables quick retrieval of historical revisions.
InventoryOrganizationId	Long	False	No	The unique identifier of the inventory organization responsible for managing the item revision. This identifier ensures that revisions are properly accounted for within inventory tracking, warehouse management, and supply chain operations.
ItemNumber	String	False	No	A human-readable item number assigned to a product, part, or service. This item number is used across procurement, sales, and inventory management to provide quick reference and ensure consistency in revision tracking.
OrganizationCode	String	False	No	The standardized alphanumeric code representing the organization responsible for the item. This code ensures uniformity across financial reporting, inventory tracking, and business unit operations.
VersionId	Long	False	No	The system-generated identifier representing the version of the item revision record. This identifier allows historical tracking of modifications, ensuring compliance with regulatory and business reporting requirements.

Return to Top

ItemsV2ItemRevisionItemRevisionDFF

Name	Type	ReadOnly	FilterOnly	Description
ItemsV2ItemId [KEY]	Long	False	No	The unique identifier for an item within the ItemsV2 module. This identifier serves as a primary key that links item records to their associated revision-level descriptive flexfields (DFFs), allowing customization of attributes specific to item revisions.
ItemsV2OrganizationId [KEY]	Long	False	No	The unique identifier for the organization managing the item. This identifier ensures that item revision-level DFFs are correctly assigned to the appropriate business unit, supporting data governance and access control.
ItemrevisionInventoryItemId [KEY]	Long	False	No	The unique identifier assigned to an inventory-managed part, item, product, or service that has undergone a revision. This identifier ensures proper classification and version tracking within inventory management processes.
ItemrevisionOrganizationId [KEY]	Long	False	No	The identifier representing the organization responsible for managing the item revision. This identifier helps maintain accurate revision tracking and ensures compliance with organizational structures and business rules.
ItemrevisionRevisionId [KEY]	Long	False	No	The unique identifier that links the inventory item to a specific revision. This identifier ensures traceability of changes to the item and aligns with product lifecycle management (PLM) and engineering change order (ECO) processes.
RevisionId [KEY]	Long	False	No	The system-generated identifier that uniquely defines a specific revision of an item. This identifier supports revision control, enabling businesses to manage engineering changes, compliance updates, and version tracking.
_FLEX_ValidationDate	Date	False	No	The date when the DFF attributes for the item revision were validated. This date helps enforce data accuracy and ensures that DFF attributes comply with predefined validation rules.
_FLEX_Context	String	False	No	The DFF context name assigned to the item revision. This context name determines how additional attributes are applied to revisions, allowing flexibility in managing item-specific and industry-specific details.
_FLEX_NumOfSegments	Int	False	No	The total number of segments (fields) configured within the DFF structure for item revisions. This field helps define how much metadata is associated with a revision.
_FLEX_NumOfVisibleSegments	Int	False	No	The number of segments (fields) that are visible to users within the DFF structure. This field determines the level of detail available for viewing or editing revision-specific attributes.
AcdType	String	False	No	The classification type assigned to the item revision, determining how it is processed within the system. This classification type influences business rules such as compliance tracking, product change approvals, and workflow automation.
ChangeLineId	Long	False	No	The unique identifier that links the item revision DFF record to a specific change request or modification. This identifier ensures traceability of revisions and supports audit tracking and compliance verification.
Finder	String	False	No	The reference to an internal search or query mechanism that helps users efficiently locate item revision records within the system. This reference enhances usability and enables quick retrieval of historical revisions.
InventoryOrganizationId	Long	False	No	The unique identifier of the inventory organization responsible for managing the item revision. This identifier ensures that revisions are properly accounted for in inventory tracking, warehouse management, and supply chain operations.
ItemId	Long	False	No	The unique identifier for the item, serving as a reference for inventory, procurement, and product lifecycle management. This identifier is crucial for linking items to their revision-specific DFFs.
ItemNumber	String	False	No	A human-readable item number assigned to a product, part, or service. This item number is used across procurement, sales, and inventory management for quick reference and revision tracking.
OrganizationCode	String	False	No	The standardized alphanumeric code representing the organization responsible for the item revision. This code ensures uniformity across financial reporting, inventory tracking, and business unit operations.
OrganizationId	Long	False	No	The unique identifier representing the organization associated with the item revision DFF record. This identifier ensures proper mapping of revisions within business units and aligns with enterprise reporting standards.
VersionId	Long	False	No	The system-generated identifier representing the version of the item revision DFF record. This identifier allows historical tracking of modifications, ensuring compliance with regulatory and business reporting requirements.

Return to Top

ItemsV2ItemRevisionItemRevisionEffCategory

Name	Type	ReadOnly	FilterOnly	Description
ItemsV2ItemId [KEY]	Long	False	No	The unique identifier for an item within the ItemsV2 module. This identifier serves as a primary key that links item records to their associated revision-effective categories, ensuring structured classification and version control.
ItemsV2OrganizationId [KEY]	Long	False	No	The unique identifier for the organization managing the item. This identifier ensures that item revision-effective categories are correctly mapped to the appropriate business unit, supporting governance, access control, and reporting.
ItemrevisionInventoryItemId [KEY]	Long	False	No	The unique identifier assigned to an inventory-managed part, item, product, or service that has undergone a revision. This identifier plays a crucial role in ensuring that revised items are accurately tracked within inventory management.
ItemrevisionOrganizationId [KEY]	Long	False	No	The identifier representing the organization responsible for managing the item revision. This identifier at the revision is assigned to the correct organization, maintaining data integrity across business units.
ItemrevisionRevisionId [KEY]	Long	False	No	The unique identifier that links the inventory item to a specific revision. This identifier ensures traceability of changes to the item and supports version tracking across engineering, procurement, and inventory processes.
RevisionId [KEY]	Long	False	No	The system-generated identifier that uniquely defines a specific revision of an item. This identifier is essential for revision control, enabling businesses to manage product lifecycle changes, compliance updates, and engineering modifications.
CategoryCode	String	False	No	The standardized category code assigned to the item revision, determining how the revised item is classified. Categories help group similar revisions together, enabling structured management of versioned products and components.
VersionId	Long	False	No	The system-generated identifier representing the version of the item revision-effective category record. This identifier supports historical tracking of changes to item classification, ensuring compliance with regulatory and business reporting standards.
AcdType	String	False	No	The classification type assigned to the item revision, defining how it is processed within the system. This classification type affects workflows such as compliance tracking, approval processes, and category-specific business rules.
ChangeLineId	Long	False	No	The unique identifier that links the item revision record to a specific change request or engineering change order (ECO). This identifier ensures traceability of revisions and supports controlled change management processes.
Finder	String	False	No	The reference to an internal search or query mechanism that allows users to efficiently locate item revision-effective category records within the system. This reference enhances usability and enables quick retrieval of classified revisions.
InventoryOrganizationId	Long	False	No	The unique identifier of the inventory organization responsible for managing the item revision. This identifier ensures that revisions are properly accounted for in inventory tracking, warehouse operations, and supply chain workflows.
ItemId	Long	False	No	The unique identifier for the item, serving as a reference for inventory, procurement, and product lifecycle management. This identifier is crucial for linking items to their revision-effective category assignments.
ItemNumber	String	False	No	A human-readable item number assigned to a product, part, or service. This item number is used across procurement, sales, and inventory management to provide quick reference and ensure consistency in revision tracking.
OrganizationCode	String	False	No	The standardized alphanumeric code representing the organization responsible for the item revision. This code ensures consistency across financial reporting, inventory tracking, and business unit operations.
OrganizationId	Long	False	No	The unique identifier representing the organization associated with the item revision-effective category. This identifier ensures proper mapping of revisions within business units and aligns with enterprise reporting standards.

Return to Top

ItemsV2ItemRevisionItemRevisionTranslation

Name	Type	ReadOnly	FilterOnly	Description
ItemsV2ItemId [KEY]	Long	False	No	The unique identifier for an item within the ItemsV2 module. This identifier serves as a key reference linking item records to their associated revision-level translations, ensuring accurate multilingual descriptions for global business operations.
ItemsV2OrganizationId [KEY]	Long	False	No	The unique identifier for the organization managing the item. This identifier ensures that item revision translations are correctly associated with the appropriate business unit, supporting localization and international compliance.
ItemrevisionInventoryItemId [KEY]	Long	False	No	The unique identifier assigned to an inventory-managed part, item, product, or service that has undergone a revision. This identifier ensures proper classification and tracking of item revisions in multilingual environments.
ItemrevisionOrganizationId [KEY]	Long	False	No	The identifier representing the organization responsible for managing the item revision translation. This identifier ensures that translated item descriptions are correctly assigned to the right organization.
ItemrevisionRevisionId [KEY]	Long	False	No	The unique identifier that links the inventory item to a specific revision. This identifier ensures traceability of changes to the item revision while supporting multilingual descriptions for international markets.
RevisionId [KEY]	Long	False	No	The system-generated identifier that uniquely defines a specific revision of an item. This identifier is crucial for managing product updates, ensuring that translated descriptions remain aligned with the correct revision version.
Description	String	False	No	The translated long description of the item revision, which provides detailed product information in the target language. This description supports global business operations, multilingual catalogs, and international compliance.
Language [KEY]	String	False	No	The language associated with the translated item revision description. This field ensures that the correct translation is displayed based on the user's language settings or business requirements.
SourceLanguage	String	False	No	The original language from which the item revision descriptions are translated. This field is useful for tracking translation processes and ensuring consistency across multilingual product descriptions.
CreationDateTime	Datetime	False	No	The timestamp indicating when the translated item revision description was first created. This timestamp helps track translation efforts and ensures proper version control.
LastUpdateDateTime	Datetime	False	No	The timestamp of the most recent update to the translated item revision description. This timestamp ensures visibility into when and why translations were modified, supporting localization quality control.
CreatedBy	String	False	No	The username or system entity that originally created the item revision translation record. This username or system entity is crucial for audit trails and tracking translation ownership.
LastUpdateLogin	String	False	No	The session login or system reference associated with the last update to the item revision translation. This information is useful for security audits and tracking user activity related to translations.
LastUpdatedBy	String	False	No	The username or system entity responsible for the most recent modification to the item revision translation. This username or system entity helps maintain accountability and track changes made to translation records.
AcdType	String	False	No	The classification type assigned to the item revision translation, determining how the translation is processed within the system. This classification type supports workflows related to language localization and multilingual content management.
ChangeLineId	Long	False	No	The unique identifier that links the item revision translation record to a specific change request or modification. This identifier ensures traceability of multilingual updates and supports compliance with localization policies.
Finder	String	False	No	The reference to an internal search or query mechanism that helps users efficiently locate translated item revision descriptions. This reference enhances usability and enables quick retrieval of localized product descriptions.
InventoryOrganizationId	Long	False	No	The unique identifier of the inventory organization responsible for managing the item revision translation. This identifier ensures that multilingual descriptions align with inventory processes, supply chain documentation, and sales catalogs.
ItemId	Long	False	No	The unique identifier for the item, serving as a reference for inventory, procurement, and multilingual product management. This identifier is crucial for linking items to their translated revision descriptions.
ItemNumber	String	False	No	A human-readable item number assigned to a product, part, or service. This item number is used across procurement, sales, and inventory management to provide quick reference and ensure consistency in revision tracking and multilingual catalogs.
OrganizationCode	String	False	No	The standardized alphanumeric code representing the organization responsible for the item revision translation. This code ensures uniformity across global business operations and multilingual content management.
OrganizationId	Long	False	No	The unique identifier representing the organization associated with the item revision translation. This identifier ensures proper mapping of translated revisions within business units and aligns with enterprise localization standards.
VersionId	Long	False	No	The system-generated identifier representing the version of the item revision translation record. This identifier allows historical tracking of translated modifications, ensuring compliance with global reporting and localization requirements.

Return to Top

ItemsV2ItemRevisionRevisionAttachment

Name	Type	ReadOnly	FilterOnly	Description
ItemsV2ItemId [KEY]	Long	False	No	The unique identifier for an item within the ItemsV2 module. This identifier serves as a key reference linking item records to revision-level document attachments, ensuring proper documentation control and compliance.
ItemsV2OrganizationId [KEY]	Long	False	No	The unique identifier for the organization managing the item. This identifier ensures that attachments related to item revisions are correctly associated with the appropriate business unit, supporting document governance and access control.
ItemrevisionInventoryItemId [KEY]	Long	False	No	The unique identifier assigned to an inventory-managed part, item, product, or service that has undergone a revision. This identifier ensures accurate document attachment to revised inventory items for reference and compliance tracking.
ItemrevisionOrganizationId [KEY]	Long	False	No	The identifier representing the organization responsible for managing the item revision. This identifier ensures that document attachments are linked to the correct organization for regulatory compliance and internal audit purposes.
ItemrevisionRevisionId [KEY]	Long	False	No	The unique identifier that links the inventory item to a specific revision. This identifier ensures traceability of engineering, manufacturing, or compliance-related document attachments for historical reference.
AttachedDocumentId [KEY]	Long	False	No	The system-generated unique identifier for the document attached to the item revision. This identifier serves as a reference for retrieving engineering drawings, compliance documents, or other supporting files.
LastUpdateDate	Datetime	False	No	The timestamp indicating the most recent update to the attached document record. This timestamp helps track modifications and ensures users access the latest version of the document.
LastUpdatedBy	String	False	No	The username or system entity responsible for the most recent modification of the document attachment. This user name or system entity supports audit tracking and accountability.
DatatypeCode	String	False	No	The code representing the type of data stored in the attachment, such as PDF, DOCX, or CAD file formats. This code helps categorize and control document handling.
FileName	String	False	No	The original name of the attached file as uploaded by the user. This field provides visibility into the document’s content and helps users locate relevant files.
DmFolderPath	String	False	No	The structured folder path within the document management system (DMS) where the file is stored. This path ensures easy retrieval and organization of attachments.
DmDocumentId	String	False	No	The unique identifier assigned to the document in the document management system. This identifier ensures accurate referencing and integration with external systems.
DmVersionNumber	String	False	No	The version number of the document within the document management system. This number supports revision control by maintaining a historical record of document updates.
Url	String	False	No	The direct Uniform Resource Locator (URL) reference for accessing the attached document. This URL allows users to quickly retrieve and view the file.
CategoryName	String	False	No	The category assigned to the attachment, enabling structured classification of documents based on purpose, such as engineering, compliance, or manufacturing.
UserName	String	False	No	The name of the user who uploaded the document attachment. This name helps track ownership and accountability for document submissions.
Uri	String	False	No	The Uniform Resource Identifier (URI) linking to the stored document. This URI ensures a globally unique reference for document retrieval.
FileUrl	String	False	No	The web-accessible URL for downloading or viewing the attached file. This URL facilitates remote access to important revision-related documents.
UploadedText	String	False	No	The extracted text content from an uploaded document, applicable to text-based attachments. This extracted content allows for content indexing and searching within the document repository.
UploadedFileContentType	String	False	No	The content type of the uploaded file, indicating its format. This content type helps determine how the file should be handled in system workflows.
UploadedFileLength	Long	False	No	The file size of the uploaded document in bytes. This metric helps manage storage allocation and ensure file size limitations are adhered to.
UploadedFileName	String	False	No	The original file name of the uploaded attachment, retained for reference and document tracking.
ContentRepositoryFileShared	Bool	False	No	A flag indicating whether the document is shared within the content repository. If set to 'true', multiple users or departments can access the same document.
Title	String	False	No	The title or display name of the attached document. This title or name provides a user-friendly identifier for document searches and references.
Description	String	False	No	The detailed description of the attached document. This description provides context about its purpose and contents.
ErrorStatusCode	String	False	No	The system-generated error code related to any issues encountered while processing the document attachment. This error code aids in troubleshooting and system monitoring.
ErrorStatusMessage	String	False	No	A human-readable error message explaining the status code. This error message helps users understand and resolve document-related issues.
CreatedBy	String	False	No	The username or system entity that originally created the attachment record. This username or system entity is essential for audit tracking and document lifecycle management.
CreationDate	Datetime	False	No	The timestamp indicating when the document attachment record was initially created. This timestamp ensures proper tracking of document history.
FileContents	String	False	No	The binary or text representation of the attachment's contents. This representation can be used for direct storage of document data within the database.
ExpirationDate	Datetime	False	No	The optional expiration date for the attached document. This date indicates when it should no longer be considered valid or relevant.
LastUpdatedByUserName	String	False	No	The full username of the individual who last updated the attachment. This field supports document lifecycle tracking and accountability.
CreatedByUserName	String	False	No	The full username of the individual who created the attachment record. This field helps maintain a clear history of document origin.
DownloadInfo	String	False	No	Metadata related to file downloads, including access logs and download status. This metadata supports document audit and security tracking.
DocumentURL	String	False	No	The direct hyperlink to the document stored in an external document management system, ensuring seamless access to supporting files.
AcdType	String	False	No	The classification type associated with the attachment. This classification type defines its relevance within business workflows such as compliance audits or engineering change orders.
ChangeLineId	Long	False	No	The unique identifier linking the document attachment to a specific change request or engineering change order (ECO). This identifier ensures traceability of document revisions related to item changes.
Finder	String	False	No	The reference to an internal search or query mechanism that allows users to efficiently locate document attachments. This reference enhances usability and document retrieval efficiency.
InventoryOrganizationId	Long	False	No	The unique identifier of the inventory organization responsible for managing the attached document. This identifier ensures proper linkage of documents to inventory operations and business units.
ItemId	Long	False	No	The unique identifier for the item to which the document is attached. This identifier ensures that documents are correctly associated with the appropriate product or component.
ItemNumber	String	False	No	A human-readable item number assigned to a product, part, or service. This item number is used across procurement, sales, and inventory management for quick reference.
OrganizationCode	String	False	No	The standardized alphanumeric code representing the organization responsible for the document attachment. This code ensures consistency in record-keeping across multiple business units.
OrganizationId	Long	False	No	The unique identifier representing the organization associated with the attached document. This identifier ensures that documents are linked to the correct business entity for governance and compliance.
VersionId	Long	False	No	The system-generated identifier representing the version of the document attachment record. This identifier allows historical tracking of changes to attached files, ensuring regulatory and business compliance.

Return to Top

ItemsV2ItemSupplierAssociation

Name	Type	ReadOnly	FilterOnly	Description
ItemsV2ItemId [KEY]	Long	False	No	The unique identifier for an item within the ItemsV2 module. This identifier serves as a key reference linking items to their supplier associations, ensuring accurate tracking of supplier relationships and procurement workflows.
ItemsV2OrganizationId [KEY]	Long	False	No	The unique identifier for the organization managing the item. This identifier ensures that item-supplier associations are correctly assigned to the relevant business unit, supporting procurement, inventory management, and compliance.
AssociationId	Long	False	No	The unique system-generated identifier that defines the relationship between an item and its associated supplier. This identifier allows businesses to manage supplier contracts, pricing agreements, and preferred sourcing.
ItemId [KEY]	Long	False	No	The unique identifier assigned to a part, item, product, or service. This identifier ensures that supplier associations are correctly linked to specific items for procurement and inventory purposes.
OrganizationId [KEY]	Long	False	No	The unique identifier representing the organization associated with the item-supplier relationship. This identifier ensures that supplier sourcing rules align with the correct business unit and regulatory requirements.
SupplierId [KEY]	Long	False	No	This attribute is currently not used but is intended to store the unique identifier for the supplier in future implementations.
SupplierName	String	False	No	The name of the supplier providing the item. This name is managed in the Suppliers work area under the Manage Suppliers task and is essential for procurement, supplier performance tracking, and financial transactions.
AlternateSupplierNumber	String	False	No	An alternate identification number for the supplier, often used for internal tracking or legacy system compatibility. This number can be reviewed and updated in the Suppliers work area under the Manage Suppliers task.
SupplierSiteId [KEY]	Long	False	No	The unique identifier assigned to a specific supplier address. This identifier ensures that purchase orders, invoices, and shipments are routed to the correct supplier location. It can be managed in the Suppliers work area under the Manage Suppliers task.
PartySiteNumber	String	False	No	The unique number that identifies the supplier site within the supplier’s business structure. This identifier helps in differentiating multiple supplier locations.
AddressName	String	False	No	The name of the supplier's address, which provides a user-friendly reference to supplier sites. This information can be reviewed and updated in the Suppliers work area under the Manage Suppliers task.
Address	String	False	No	The physical address of the supplier, which is critical for logistics, invoicing, and compliance with tax and trade regulations. This information is maintained in the Suppliers work area under the Manage Suppliers task.
SupplierItemNumber	String	False	No	This attribute is currently not used but is intended to store the supplier-provided item number in future implementations.
PrimaryFlag	Bool	False	No	Indicates whether this supplier is the primary source for the item. A value of 'true' designates the supplier as the preferred vendor for procurement, while 'false' indicates an alternate or secondary supplier.
SupplierExtensibleFlexfieldCategoryCode	String	False	No	The classification code that identifies the item class associated with supplier-specific extensible flexfields. This code allows for additional supplier-related attributes and can be configured in the Setup and Maintenance work area under the Manage Item Classes task.
CreationDateTime	Datetime	False	No	The timestamp indicating when the item-supplier association was first created. This timestamp is important for tracking supplier onboarding and contract initiation dates.
LastUpdateDateTime	Datetime	False	No	The timestamp of the most recent update to the item-supplier association record. This timestamp ensures traceability of modifications and supports supplier performance management.
RegistryId	String	False	No	The unique identifier in the supplier registry. This identifier helps track supplier records across multiple procurement systems.
SupplierSiteAssociationStatusValue	String	False	No	The current status of the item-supplier association, indicating whether the relationship is active, pending approval, or inactive. This status affects procurement and supplier sourcing decisions.
RequestId	Long	False	No	The unique identifier assigned to a data import request related to item-supplier associations. This identifier is generated during supplier data imports and is used for tracking and validating supplier relationships.
AcdType	String	False	No	The classification type associated with the item-supplier association. This classification type determines how the relationship is processed in procurement and sourcing workflows.
ChangeLineId	Long	False	No	The unique identifier that links the item-supplier association record to a specific change request or supplier update process. This identifier ensures traceability of modifications.
Finder	String	False	No	The reference to an internal search or query mechanism that allows users to efficiently locate item-supplier association records within the system. This reference enhances usability and data retrieval for procurement teams.
InventoryOrganizationId	Long	False	No	The unique identifier of the inventory organization responsible for managing the item-supplier association. This identifier ensures that sourcing rules align with inventory planning and supplier selection.
ItemNumber	String	False	No	A human-readable item number assigned to the product, part, or service. This item number is used in procurement transactions and supplier catalogs to ensure consistency in sourcing.
OrganizationCode	String	False	No	The standardized alphanumeric code representing the organization responsible for the item-supplier association. This code ensures consistency in procurement reporting and compliance tracking.
VersionId	Long	False	No	The system-generated identifier representing the version of the item-supplier association record. This identifier allows historical tracking of supplier relationships and ensures compliance with supplier contract versioning.

Return to Top

ItemsV2ItemSupplierAssociationItemSupplierEffCategory

Name	Type	ReadOnly	FilterOnly	Description
ItemsV2ItemId [KEY]	Long	False	No	The unique identifier for an item within the ItemsV2 module. This identifier links item records to their supplier association category, ensuring structured supplier management and classification.
ItemsV2OrganizationId [KEY]	Long	False	No	The unique identifier for the organization managing the item. This identifier ensures that supplier associations and their corresponding categories are correctly mapped to the appropriate business unit, supporting procurement and compliance workflows.
ItemsupplierassociationAcdType [KEY]	String	False	No	The classification type assigned to the supplier-item association, determining how the supplier relationship is processed within procurement, sourcing, and supply chain management workflows.
ItemsupplierassociationChangeLineId [KEY]	Int	False	No	The unique identifier that links the supplier association category record to a specific change request. This identifier ensures traceability of modifications related to supplier classification updates.
ItemsupplierassociationInventoryItemId [KEY]	Long	False	No	The unique identifier assigned to an inventory-managed item, product, or service associated with a supplier. This identifier plays a key role in managing supplier sourcing and inventory tracking.
ItemsupplierassociationItemId [KEY]	Long	False	No	The unique identifier for the item that is associated with the supplier. This identifier ensures correct linkage between suppliers and their assigned items within procurement and sourcing systems.
ItemsupplierassociationOrganizationId [KEY]	Long	False	No	The unique identifier representing the organization that manages the supplier association. This identifier ensures that supplier relationships align with the correct business unit and regulatory requirements.
ItemsupplierassociationOrganizationId1 [KEY]	Long	False	No	An additional identifier for the organization that manages the supplier association. This identifier can be used for hierarchical or multi-entity supplier relationships.
ItemsupplierassociationSupplierId [KEY]	Long	False	No	The unique identifier for the supplier associated with the item. This identifier is a key reference for managing supplier relationships, purchase agreements, and sourcing decisions.
ItemsupplierassociationSupplierSiteId [KEY]	Long	False	No	The unique identifier assigned to the supplier's specific site location. This identifier ensures that purchase orders, deliveries, and payments are correctly associated with the right supplier site.
ItemsupplierassociationVersionId [KEY]	Long	False	No	The system-generated identifier representing the version of the supplier association category record. This identifier enables historical tracking of supplier classifications and version control.
AcdType [KEY]	String	False	No	The classification type assigned to the item-supplier association category. This classification type determines how supplier-related transactions and business rules are applied.
AssociationId	Long	False	No	The unique identifier defining the relationship between an item and its supplier. This identifier is essential for tracking supplier agreements, preferred sourcing, and supplier qualification processes.
OrganizationId [KEY]	Long	False	No	The unique identifier representing the organization that manages the supplier relationship. This identifier ensures supplier classification is correctly aligned with company structures and regulatory policies.
VersionId [KEY]	Long	False	No	The system-generated identifier representing the version of the supplier-item association record. This identifier enables audit tracking and version control of supplier relationships.
MasterOrganizationId	Long	False	No	The unique identifier for the master organization overseeing the supplier association. This identifier is used in global supplier management to ensure consistency across multiple business units.
SupplierId [KEY]	Long	False	No	The unique identifier assigned to the supplier. This identifier plays a key role in procurement, contract management, and financial transactions with the supplier.
SupplierSiteId [KEY]	Long	False	No	The unique identifier for a specific supplier site. This identifier ensures that supplier transactions, including shipments and invoices, are assigned to the correct location.
CategoryCode	String	False	No	The category assigned to the supplier-item association. This categorization enables businesses to classify suppliers based on factors such as commodity type, regulatory status, or business impact.
ChangeLineId	Long	False	No	The unique identifier that links the supplier association category record to a specific change request. This identifier ensures traceability of modifications related to supplier classification updates.
Finder	String	False	No	The reference to an internal search or query mechanism that allows users to efficiently locate supplier association category records. This reference enhances usability and data retrieval in procurement processes.
InventoryOrganizationId	Long	False	No	The unique identifier of the inventory organization responsible for managing the supplier association. This identifier ensures that supplier sourcing rules align with inventory planning and procurement strategies.
ItemId	Long	False	No	The unique identifier for the item linked to the supplier association category. This identifier ensures correct classification of supplier-item relationships within the sourcing system.
ItemNumber	String	False	No	A human-readable item number assigned to the product, part, or service. This item number is used in procurement transactions and supplier catalogs to ensure consistency in sourcing and supplier classification.
OrganizationCode	String	False	No	The standardized alphanumeric code representing the organization responsible for managing the supplier association category. This code ensures uniformity across procurement reporting and compliance tracking.

Return to Top

ItemsV2ItemTranslation

Name	Type	ReadOnly	FilterOnly	Description
ItemsV2ItemId [KEY]	Long	False	No	The unique identifier for an item within the ItemsV2 module. This identifier serves as a primary key linking item records to their multilingual translations, ensuring accurate localization of item descriptions for global business operations.
ItemsV2OrganizationId [KEY]	Long	False	No	The unique identifier for the organization managing the item. This identifier ensures that translated item descriptions are correctly assigned to the appropriate business unit, supporting localization and compliance with regional regulations.
OrganizationId [KEY]	Long	False	No	The unique identifier representing the organization that owns or manages the translated item description. This identifier ensures that item descriptions are aligned with the correct organization for reporting and compliance.
ItemId [KEY]	Long	False	No	The unique identifier assigned to a part, item, product, or service. This identifier ensures that the correct translated description is associated with each item across different languages.
ItemDescription	String	False	No	The short description of the part, item, product, or service. This field provides a concise label for the item that may be used across procurement, sales, and inventory applications.
LongDescription	String	False	No	The detailed textual description of the item, product, or service. This field provides additional context about the item's purpose, features, and specifications in a translated language.
HTMLLongDescription	String	False	No	The formatted long description of the item, provided in rich text or HTML format. This field allows enhanced formatting, including bold text, bullet points, and hyperlinks for product catalogs and digital storefronts.
Language [KEY]	String	False	No	The language associated with the translated item long description. This field ensures that users in different regions can view item descriptions in their preferred language.
SourceLanguage	String	False	No	The original language from which the item descriptions are translated. This field helps track the translation process and maintain consistency across multilingual descriptions.
CreationDateTime	Datetime	False	No	The timestamp indicating when the translated item description was first created. This timestamp helps track localization efforts and ensures proper version control.
LastUpdateDateTime	Datetime	False	No	The timestamp of the most recent update to the translated item description. This timestamp ensures visibility into when and why translations were modified, supporting localization quality control and version tracking.
AcdType	String	False	No	The classification type assigned to the item translation, determining how the translation is processed within the system. This classification type supports workflows related to language localization and multilingual content management.
ChangeLineId	Long	False	No	The unique identifier linking the translated item record to a specific change request or modification. This identifier ensures traceability of multilingual updates and supports compliance with localization policies.
Finder	String	False	No	The reference to an internal search or query mechanism that allows users to efficiently locate translated item descriptions. This reference enhances usability and enables quick retrieval of localized product descriptions.
InventoryOrganizationId	Long	False	No	The unique identifier of the inventory organization responsible for managing the translated item description. This identifier ensures that multilingual descriptions align with inventory processes, supply chain documentation, and sales catalogs.
ItemNumber	String	False	No	A human-readable item number assigned to a product, part, or service. This item number is used across procurement, sales, and inventory management to provide quick reference and ensure consistency in multilingual catalogs.
OrganizationCode	String	False	No	The standardized alphanumeric code representing the organization responsible for the translated item description. This code ensures uniformity across global business operations and multilingual content management.
VersionId	Long	False	No	The system-generated identifier representing the version of the item translation record. This identifier allows historical tracking of translated modifications, ensuring compliance with global reporting and localization requirements.

Return to Top

ItemTemplates

Name	Type	ReadOnly	FilterOnly	Description
ItemId [KEY]	Long	False	No	The unique identifier assigned to an item template within the system. This identifier serves as the primary reference for managing item templates and their associated attributes.
OrganizationId [KEY]	Long	False	No	A system-generated identifier that links the item template to a specific organization. This identifier ensures that item templates are managed within the correct organizational structure.
OrganizationCode	String	False	No	The unique alphanumeric code assigned to an organization, identifying which entity owns or controls the item template. This code is essential for multi-organization setups where items are managed across different business units.
ItemClass	String	False	No	The classification code that categorizes the item template based on predefined item classification rules. This classification is used for reporting, searchability, and process automation.
ItemNumber	String	False	No	The unique item number assigned to the item template. Typically, this item number is used as a key reference in transactions, inventory management, and procurement processes.
ItemDescription	String	False	No	A brief textual description providing an overview of the item template. This description helps users identify the item quickly in searches, reports, and selection lists.
ApprovalStatusValue	String	False	No	The current approval status of the item template, which determines whether it is pending approval, approved for use, or rejected. Approval processes are often tied to workflow automation for governance.
ItemStatusValue	String	False	No	The operational status of the item template within the system. Common statuses include 'Active' (available for transactions), 'Inactive' (not available for new transactions), and 'Obsolete' (discontinued or replaced).
LifecyclePhaseValue	String	False	No	The lifecycle phase of the item template, defining where the item stands in its overall lifecycle, such as 'Concept', 'Design', 'Production', or 'End of Life'. This phase influences availability and business rules.
StyleItemFlag	Bool	False	No	Indicates whether the item template represents a style item. Typically, this flag is used in industries like fashion or retail where variations (for example, size or color) are managed under a single style identifier.
Keyword	String	False	No	A keyword or set of keywords associated with the item template to enhance searchability. These keywords allow users to find relevant items more easily in catalogs, databases, or procurement systems.
IgnoreDuplicateItemFlag	Bool	False	No	Indicates whether duplicate item validation should be bypassed when creating or modifying the item template. This flag is useful in scenarios where duplicate detection is intentionally disabled for efficiency.
UserItemTypeValue	String	False	No	A user-defined item type that classifies the item template based on business-specific criteria. This value can be used for internal categorization, reporting, or system rules.
PackTypeValue	String	False	No	The packaging type applicable to the item template. This type defines how the item is packed for storage, transportation, or sale (for example, 'Box', 'Pallet', and 'Individual Unit'.
LongDescription	String	False	No	A comprehensive description providing in-depth details about the item template. This description includes specifications, intended usage, and other relevant attributes.
FormattedDescription	String	False	No	A structured, formatted version of the item description, often used in catalogs, customer-facing documents, and system-generated reports where text formatting is important.
PrimaryUOMValue	String	False	No	The primary unit of measure (UOM) assigned to the item template. This UOM defines how the item is quantified in transactions (for example, 'Kilogram' or 'Liter').
TransactionConversionValue	String	False	No	The conversion factor applied when this item template is used in transactions that require unit conversions. This factor ensures consistent measurement across different UOMs.
DefaultingControlValue	String	False	No	The system rule that determines how default values are assigned to this item template when used in transactions, configurations, or order management processes.
PositiveDeviationFactor	Decimal	False	No	The acceptable positive deviation percentage or factor for this item template. This metric defines how much variance is allowed beyond the standard measurement or tolerance limit.
NegativeDeviationFactor	Decimal	False	No	The acceptable negative deviation percentage or factor for this item template. This metric defines how much variance is allowed below the standard measurement or tolerance limit.
CopyItemAndApplyTemplatesFlag	Bool	False	No	Indicates whether the item template should be copied along with any associated templates when duplicating an item. This flag ensures consistency when reusing configurations.
CopyAssociationsFlag	Bool	False	No	Indicates whether associations linked to the item template (for example, supplier relationships, sourcing rules, or planning parameters) should be copied during item duplication.
CopyAttachmentsFlag	Bool	False	No	Indicates whether attachments (such as specifications, images, or compliance documents) associated with the item template should be copied when duplicating the item.
CopyCategoriesFlag	Bool	False	No	Indicates whether category assignments for the item template should be retained when copying the item. Categories help classify items for reporting and workflow automation.
CopyOrganizationAssignmentsFlag	Bool	False	No	Indicates whether organization-level assignments should be copied when duplicating the item template. This flag ensures the new item remains available in the same organizations as the original.
LastSubmittedNewItemRequest	String	False	No	The reference identifier for the most recent new item request submitted for this item template. This identifier helps track approval processes and item introduction workflows.
ChangeNotice	String	False	No	The identifier of the change notice associated with modifications made to the item template. Change notices document updates, approvals, and compliance tracking.
ChangeOrderLineSequenceNumber	Int	False	No	The sequence number of the item template within a change order. This sequence helps track the order of changes applied to multiple items within a single change request.
StructureItemTypeValue	String	False	No	The type of structure associated with the item template, such as 'Phantom' (for virtual groupings), 'Finished Goods' (for sellable items), or 'Subassembly' (for components used in manufacturing).
CreateConfiguredItem	String	False	No	Indicates whether a configured item should be automatically created based on this template, typically in configurable manufacturing or custom product setups.
ConfigModelTypeValue	String	False	No	The configuration model type assigned to the item template, defining its customization rules. Examples include 'Make-to-Order (MTO)', 'Engineer-to-Order (ETO)', and 'Assemble-to-Order (ATO)'.
EffectivityControlValue	String	False	No	The control mechanism that governs when changes to the item template become effective. Effectivity can be based on dates, serial numbers, or lot numbers.
BaseItemValue	String	False	No	The reference base item from which this item template is derived. This value is commonly used for template-driven item creation where a standardized base item serves as the foundation.
AutoCreatedConfigurationFlag	Bool	False	No	Indicates whether configurations for this item template are automatically generated based on predefined rules. This flag is commonly used in configure-to-order processes.
PickComponentsFlag	Bool	False	No	Indicates whether components of this item template can be picked individually in inventory transactions. Typically, this flag is used in kit or assembly management.
AssembleToOrderFlag	Bool	False	No	Specifies whether this item template follows an assemble-to-order process, meaning components are assembled only upon order demand rather than pre-built inventory.
CostingEnabledFlag	Bool	False	No	Indicates whether cost tracking is enabled for this item template. When enables, this flag allows cost calculations for valuation, financial reporting, and cost roll-ups.
IncludeInRollUpFlag	Bool	False	No	Determines whether this item template's costs should be included in cost roll-ups, which aggregate costs from lower-level components in a bill of materials.
StandardLotSize	Decimal	False	No	Defines the standard production or procurement lot size for this item template. This lot size influences supply planning and inventory replenishment decisions.
InventoryAssetFlag	Bool	False	No	Indicates whether this item template is treated as an inventory asset, meaning it is considered in financial asset tracking and valuation calculations.
BuildInWIPFlag	Bool	False	No	Specifies whether this item template is built directly in Work in Process (WIP), commonly used for manufacturing workflows where production occurs incrementally.
WIPSupplyTypeValue	String	False	No	Defines the supply type used for issuing this item in a WIP environment (for example,'push', 'pull', or 'direct issue').
WIPSupplyLocatorValue	String	False	No	The default locator assigned to supply this item template in WIP transactions. This locator ensures proper tracking of materials within storage locations.
WIPSupplySubinventoryValue	String	False	No	The default subinventory from which this item template is supplied for WIP operations. This information determines the material source within inventory.
OvercompletionToleranceTypeValue	String	False	No	Specifies the type of tolerance allowed for overcompletion in WIP, such as percentage-based or absolute quantity-based thresholds.
OvercompletionToleranceValue	Decimal	False	No	Defines the acceptable level of overproduction beyond the planned quantity for this item template in WIP, preventing excessive overproduction.
InventoryCarryPenalty	Decimal	False	No	Represents the penalty cost assigned to carrying excess inventory for this item template. This value is used in cost analysis and inventory optimization calculations.
OperationSlackPenalty	Decimal	False	No	Specifies the penalty cost associated with delays in operations related to this item template. This value is commonly used in scheduling and production planning models.
RecipeEnabledFlag	Bool	False	No	Indicates whether this item template supports recipes. Typically, this flag is used in process manufacturing for defining ingredient formulations and batch production processes.
ProcessQualityEnabledFlag	Bool	False	No	Determines whether quality tracking and process inspections are enabled for this item template, ensuring compliance with quality control standards.
ProcessCostingEnabledFlag	Bool	False	No	Indicates whether process costing is enabled for this item template. This flag allows for cost tracking in process manufacturing environments where costs accumulate over multiple steps.
ProcessExecutionEnabledFlag	Bool	False	No	Specifies whether this item template can be used in process execution workflows. This template supports manufacturing operations that involve batch or continuous production.
ProcessSupplySubinventoryValue	String	False	No	Defines the subinventory from which supply materials are drawn for process manufacturing involving this item template.
ProcessSupplyLocatorValue	String	False	No	Specifies the locator within the supply subinventory that is designated for storing materials used in process manufacturing for this item template.
ProcessYieldSubinventoryValue	String	False	No	Defines the subinventory where yield or finished goods from a process manufacturing operation involving this item template are stored.
ProcessYieldLocatorValue	String	False	No	Specifies the locator within the yield subinventory for storing completed output from process manufacturing of this item template.
HazardousMaterialFlag	Bool	False	No	Indicates whether this item template is classified as hazardous material, requiring special handling, compliance documentation, and regulatory controls.
CASNumber	String	False	No	The Chemical Abstracts Service (CAS) registry number associated with this item template. This registry number is used for identifying and tracking chemical substances.
AssetTrackedFlag	Bool	False	No	Specifies whether this item template is tracked as an asset, enabling asset-management features such as depreciation, maintenance, and lifecycle tracking.
AssetClassValue	String	False	No	Defines the asset classification assigned to this item template, categorizing it for asset management and financial reporting purposes.
ServiceRequestEnabledValue	String	False	No	Indicates whether service requests can be created for this item template, allowing tracking of service activities such as repairs or maintenance.
DefectTrackingOnFlag	Bool	False	No	Determines whether defect tracking is enabled for this item template, allowing users to log, monitor, and resolve quality issues.
ServiceDurationTypeValue	String	False	No	Specifies the type of service duration applicable to this item template, such as fixed period, variable duration, or based on contract terms.
ServiceDuration	Decimal	False	No	Defines the duration for which a service associated with this item template is valid. Typically, this duration is measured in days, months, or years.
ServiceDurationPeriodValue	String	False	No	Specifies the unit of time for the service duration (for example, days, weeks, months, or years). This value defines how the service period is calculated.
ServiceStartTypeValue	String	False	No	Determines how the service start date is defined for this item template, such as upon shipment, installation, or activation.
ServiceStartDelay	Decimal	False	No	Defines the delay period before service starts for this item template, commonly used when service begins after a set period from sale or activation.
AllowSuspendFlag	Bool	False	No	Indicates whether the service or subscription associated with this item template can be temporarily suspended and resumed later.
AllowTerminateFlag	Bool	False	No	Indicates whether the item template allows termination of associated services, contracts, or warranties before their scheduled end date.
RequiresItemAssociationFlag	Bool	False	No	Specifies whether this item template requires an association with another item, such as in configurations where dependent components must be linked.
CreateFixedAssetFlag	Bool	False	No	Indicates whether an item created from this template should be registered as a fixed asset for financial tracking and depreciation purposes.
InstanceClassValue	String	False	No	Defines the classification of item instances created from this template, commonly used in asset tracking and serialized inventory management.
BillingTypeValue	String	False	No	Specifies the billing type applicable to this item template, such as one-time, recurring, or usage-based billing, for financial and subscription management.
ServiceBillingEnabledFlag	Bool	False	No	Indicates whether service billing is enabled for this item template, allowing charges for service-related activities like maintenance or support.
RecoveredPartDispositionValue	String	False	No	Defines the disposition method for recovered parts associated with this item template, such as refurbishment, disposal, or reuse in inventory.
InventoryItemFlag	Bool	False	No	Indicates whether this item template represents an inventory item, meaning it is managed within stock control and inventory transactions.
StockEnabledFlag	Bool	False	No	Determines whether stock tracking is enabled for this item template, allowing it to be stored, counted, and transacted within inventory.
MaterialTransactionEnabledFlag	Bool	False	No	Indicates whether this item template can be included in material transactions such as receipts, issues, transfers, and returns.
ReservableFlag	Bool	False	No	Specifies whether this item template can be reserved in inventory for specific orders, ensuring availability for future demand.
CheckMaterialShortageFlag	Bool	False	No	Determines whether material shortage checks are enforced for this item template, preventing transactions if stock is insufficient.
RevisionQuantityControlFlag	Bool	False	No	Indicates whether quantity control is enforced for different revisions of the item, ensuring version-specific inventory tracking.
BulkPickedFlag	Bool	False	No	Specifies whether this item template is eligible for bulk picking, where large quantities are picked together instead of individual units.
LotControlValue	String	False	No	Defines the lot control method for this item template, such as 'Full Lot Control', 'No Lot Control', or 'User-Defined Control'. This method impacts traceability and compliance.
StartingLotPrefix	String	False	No	Specifies the prefix used when generating lot numbers for this item template. This prefix ensures consistent identification of lot-controlled inventory.
StartingLotNumber	String	False	No	Defines the starting numeric value for lot numbers assigned to this item template. This value is used for sequential lot tracking.
MaturityDays	Decimal	False	No	Specifies the number of days required for this item to reach maturity. This value is commonly used for perishable or aging-sensitive inventory.
HoldDays	Decimal	False	No	Defines the number of days an item must be held before it can be released for use. This value is often applied to quality control or quarantine processes.
LotExpirationControlValue	String	False	No	Determines the lot expiration control method for this item template, such as 'None', 'Shelf Life Days', or 'User-Defined Expiry'.
ShelfLifeDays	Decimal	False	No	Specifies the number of days this item remains usable before expiration. This value is critical for perishable goods and regulated inventory.
RetestInterval	Decimal	False	No	Defines the interval at which this item should be retested for quality or compliance before expiration or continued use.
ExpirationActionValue	String	False	No	Specifies the action to be taken when the lot reaches expiration (for example, quarantine, disposal, or extension based on testing).
ExpirationActionInterval	Decimal	False	No	Defines the time interval before or after expiration when the specified expiration action should be executed.
ChildLotEnabledFlag	Bool	False	No	Indicates whether child lots can be created for this item template. This information allows hierarchical lot management and sub-lot tracking.
ChildLotFormatValidationFlag	Bool	False	No	Specifies whether format validation rules should be enforced when generating child lot numbers for this item template.
CopyLotAttributeFlag	Bool	False	No	Determines whether lot attributes should be copied when creating child lots from this item template. This information maintains consistency in lot characteristics.
ChildLotPrefix	String	False	No	Defines the prefix used when generating child lot numbers. This prefix ensures a structured and traceable lot numbering system.
ChildLotStartingNumber	Decimal	False	No	Specifies the starting numeric value for child lot numbers. This value is used for sequential tracking of sub-lots.
ChildLotParent	String	False	No	Indicates the parent lot from which child lots are derived. This information enables hierarchical tracking of lot-based inventory.
LotTranslateEnabledFlag	Bool	False	No	Determines whether lot translation is enabled. This information allows conversion of one lot number to another for traceability or compliance.
LotSplitEnabledFlag	Bool	False	No	Indicates whether this item template supports lot splitting. This information allows a single lot to be divided into multiple smaller lots.
LotDivisibleFlag	Bool	False	No	Specifies whether the lot can be divided into fractional quantities. This flag is commonly used in industries requiring precise inventory control.
LotSubstitutionEnabledFlag	Bool	False	No	Indicates whether lot substitution is allowed for this item template. This information enables replacement of one lot with another based on business rules.
LotMergeEnabledFlag	Bool	False	No	Determines whether multiple lots can be merged into a single lot for inventory simplification and batch consolidation.
GradeControlFlag	Bool	False	No	Indicates whether grade control is enabled for this item template. This flag allows classification based on quality or specification standards.
DefaultGradeValue	String	False	No	Specifies the default grade assigned to items created from this template. This grade is used for categorization in quality control and procurement.
SerialGenerationValue	String	False	No	Defines the serial-number generation method for this item template, such as manual, preassigned, or dynamically assigned at transaction time.
SerialStartingPrefix	String	False	No	Specifies the prefix applied to serial numbers generated for this item template. This prefix ensures structured and recognizable serial tracking.
SerialStartingNumber	String	False	No	Defines the starting numeric value for serial numbers assigned to this item template. This value is used for sequential tracking.
NegativeMeasurementError	Decimal	False	No	Specifies the acceptable negative-measurement error tolerance for this item template. This metric ensures quality compliance and precision in manufacturing.
PositiveMeasurementError	Decimal	False	No	Defines the acceptable positive-measurement error tolerance for this item template. This metric ensures accurate measurement within defined limits.
CycleCountEnabledFlag	Bool	False	No	Indicates whether this item template is eligible for cycle counting. This flag allows regular stock audits to improve inventory accuracy.
LotStatusEnabledFlag	Bool	False	No	Determines whether lot status tracking is enabled for this item template. This flag ensures control over lot usage based on status settings.
SerialStatusEnabledFlag	Bool	False	No	Specifies whether serial-number status tracking is enabled for this item template. This flag allows serialized items to have distinct operational states.
DefaultLotStatusValue	String	False	No	Defines the default lot status assigned to new lots created from this item template. This lot status determines initial usability or restrictions.
DefaultSerialStatusValue	String	False	No	Specifies the default serial status assigned to newly created serialized items. This serial status influences transactions and usability.
RestrictSubinventoriesFlag	Bool	False	No	Indicates whether this item template restricts the use of specific subinventories. This flag limits storage locations based on predefined rules.
RestrictLocatorsFlag	Bool	False	No	Determines whether locators are restricted for this item template. This flag enforce specific storage assignments within inventory locations.
StockLocatorControlValue	String	False	No	Defines the stock-locator control method for this item template. This method specifies how items are assigned to storage locations.
DimensionUOMValue	String	False	No	Specifies the unit of measure (UOM) used for dimensional attributes of this item template, such as inches, centimeters, or meters.
UnitWidthQuantity	Decimal	False	No	Defines the standard width measurement of a single unit of this item template. This metric isused for packaging and storage calculations.
UnitLengthQuantity	Decimal	False	No	Specifies the standard length measurement of a single unit of this item template. this metric is relevant for dimensional planning and shipping.
UnitHeightQuantity	Decimal	False	No	Defines the standard height measurement of a single unit of this item template. This metric is used for stacking and storage optimization.
WeightUOMValue	String	False	No	Specifies the UOM used for weight attributes of this item template (for example, 'Grams', 'Kilograms', or 'Pounds'.
UnitWeightQuantity	Decimal	False	No	Defines the standard weight of a single unit of this item template. This value impacts shipping costs and handling requirements.
VolumeUOMValue	String	False	No	Specifies the UOM used for volume attributes of this item template (for example, 'Cubic Inches', 'Liters', or 'Cubic meters'.
UnitVolumeQuantity	Decimal	False	No	Defines the volume occupied by a single unit of this item template. This value is relevant for packaging, transportation, and storage planning.
ContainerItemFlag	Bool	False	No	Indicates whether this item template represents a container, which is used for packaging or storing other items during handling and shipping.
ContainerTypeValue	String	False	No	Defines the type of container represented by this item template (for example, 'Box', 'Pallet', 'Drum', or 'Crate'.
MaximumLoadWeight	Decimal	False	No	Specifies the maximum allowable weight capacity for a container defined by this item template. This value ensures compliance with load restrictions.
VehicleItemFlag	Bool	False	No	Indicates whether this item template represents a vehicle, which can be used for material movement, logistics, or operational purposes.
InternalVolume	Decimal	False	No	Defines the internal volume capacity of an item template designated as a container or vehicle. This information ensures space optimization for storage or transportation.
MinimumFillPercent	Decimal	False	No	Specifies the minimum fill percentage required for a container or vehicle before shipment. This value ensures efficient space utilization.
WarehouseEquipmentFlag	Bool	False	No	Indicates whether this item template represents warehouse equipment (for example, forklifts, shelving units, or conveyor belts) for operational tracking.
EventFlag	Bool	False	No	Specifies whether this item template is associated with event-driven processes. This field enables triggers for workflow automation or business rules.
CollateralFlag	Bool	False	No	Indicates whether this item template represents collateral such as promotional materials, marketing brochures, or bundled non-saleable items.
CustomerOrderFlag	Bool	False	No	Specifies whether this item template can be included in customer orders, determining its availability for direct sales.
CustomerOrderEnabledFlag	Bool	False	No	Indicates whether this item template is enabled for customer orders. When enabled, this flag allows it to be sold through order management processes.
ATPComponentsValue	String	False	No	Defines the Available-to-Promise (ATP) calculation method for components within this item template. This calculation method ensures accurate supply commitments.
PickingRuleValue	String	False	No	Specifies the picking rule associated with this item template. This rule determines how inventory is selected for order fulfillment.
RMAInspectionRequiredFlag	Bool	False	No	Indicates whether a Return Material Authorization (RMA) inspection is required when this item template is returned by a customer.
EligibilityRuleFlag	Bool	False	No	Determines whether an eligibility rule applies to this item template. This rule controls who can purchase or use the item based on predefined criteria.
ReturnableFlag	Bool	False	No	Specifies whether this item template can be returned by customers. This flag defines its eligibility for refunds, replacements, or credits.
ATPValue	String	False	No	Defines the ATP method for this item template. This method determines how availability is calculated for sales commitments.
FinancingAllowedFlag	Bool	False	No	Indicates whether financing options are available for this item template, enabling installment payments or lease agreements.
SalesProductTypeValue	String	False	No	Specifies the sales-product type classification assigned to this item template, such as tangible goods, services, or subscriptions.
TransactionEnabledFlag	Bool	False	No	Determines whether this item template is allowed for transactions. This flag enables the item template's use in sales, purchasing, and inventory movements.
OrderManagementIndivisibleFlag	Bool	False	No	Indicates whether this item template must be ordered as a whole unit. This flag prevents partial order fulfillment or fractional quantities.
DefaultSalesOrderSourceTypeValue	String	False	No	Specifies the default source type for sales orders associated with this item template (for example, 'direct sale', 'subscription', or 'bundled offering'.
ElectronicFormatFlag	Bool	False	No	Indicates whether this item template is available in electronic format. This flag is commonly used for digital products, software, or downloadable content.
ShippableFlag	Bool	False	No	Specifies whether this item template is eligible for shipping. This specification ensures the item template can be included in logistics and fulfillment processes.
DefaultShippingOrganizationValue	String	False	No	Defines the default shipping organization responsible for fulfilling orders containing this item template, optimizing supply chain operations.
ShipModelCompleteFlag	Bool	False	No	Determines whether this item template must be shipped as a complete model, preventing partial shipments of its components.
DownloadableFlag	Bool	False	No	Indicates whether this item template represents a downloadable product (for example, digital media, software, or electronic documents).
OverShipmentTolerance	Decimal	False	No	Defines the allowable percentage or quantity variance for over-shipment beyond the ordered amount of this item template.
UnderShipmentTolerance	Decimal	False	No	Specifies the allowable percentage or quantity variance for under-shipment when fulfilling orders for this item template.
OverReturnTolerance	Decimal	False	No	Defines the maximum allowable percentage or quantity variance for over-returns beyond the originally purchased quantity of this item template.
UnderReturnTolerance	Decimal	False	No	Specifies the minimum allowable percentage or quantity variance for under-returns. This specification ensures compliance with return policies.
InvoiceEnabledFlag	Bool	False	No	Indicates whether invoicing is enabled for this item template. This flag allows the item template to be included in billing and financial transactions.
AccountingRuleValue	String	False	No	Defines the accounting rule applied to this item template. This rule determines how revenue and expenses are recognized in financial reporting.
PaymentTermsValue	String	False	No	Specifies the payment terms applicable to this item template, such as 'Net 30', 'Due on Receipt', or nstallment-based agreements).
OutputTaxClassificationCodeValue	String	False	No	Defines the tax classification code for sales transactions involving this item template. This code ensures compliance with tax regulations.
InvoicedFlag	Bool	False	No	Indicates whether this item template has already been invoiced. This flag tracks its financial status in sales transactions.
InvoicingRuleValue	String	False	No	Specifies the invoicing rule used for this item template. This rule determines how and when invoices are generated for sales transactions.
SalesAccountValue	String	False	No	Defines the sales account associated with this item template. This account ensures proper financial tracking and revenue allocation.
WebStatusValue	String	False	No	Indicates the web status of this item template (for example, 'available', 'discontinued', or 'hidden') for online storefront visibility.
BackOrderableFlag	Bool	False	No	Specifies whether this item template can be placed on backorder. This flag allows orders to be accepted even when stock is unavailable.
OrderableOnWebFlag	Bool	False	No	Determines whether this item template can be ordered online. This flage enables e-commerce sales and digital storefront integration.
MinimumLicenseQuantity	Decimal	False	No	Defines the minimum quantity required for licensing this item template. Typically, this value is used for software, subscriptions, or enterprise agreements.
InventoryPlanningMethodValue	String	False	No	Specifies the inventory planning method used for this item template, such as 'Min-Max Planning', 'Reorder Point', or 'Forecast-Based Planning'.
PlanningMakeBuyValue	String	False	No	Indicates whether this item template is planned for in-house manufacturing (Make) or procurement from suppliers (Buy). This value affects sourcing decisions.
Planner	String	False	No	Defines the designated planner responsible for managing replenishment, forecasting, and inventory control for this item template.
SubcontractingComponentValue	String	False	No	Indicates whether this item template is used as a subcontracted component, where external vendors perform partial or full assembly.
MinimumMinmaxQuantity	Decimal	False	No	Specifies the minimum inventory level for Min-Max planning. This value ensures stock does not fall below the defined threshold.
MaximumMinmaxQuantity	Decimal	False	No	Defines the maximum inventory level for Min-Max planning. This value prevents excessive stock accumulation.
MinimumOrderQuantity	Decimal	False	No	Specifies the smallest allowable order quantity when procuring or manufacturing this item template. This value ensuring efficient purchasing and production.
MaximumOrderQuantity	Decimal	False	No	Defines the largest allowable order quantity for procurement or production. This value prevents overordering and excessive inventory costs.
OrderCost	Decimal	False	No	Represents the fixed cost associated with placing an order for this item template. This fixed cost used in cost calculations and economic order quantity (EOQ) models.
SourceOrganizationValue	String	False	No	Specifies the source organization responsible for supplying this item template in an internal transfer or supply chain network.
SourceSubinventoryOrganizationValue	String	False	No	Defines the organization associated with the source subinventory for this item template. This value ensures accurate material sourcing.
SourceSubinventoryValue	String	False	No	Specifies the subinventory from which this item template is sourced. This information is used in inventory transfers and replenishment processes.
FixedOrderQuantity	Decimal	False	No	Defines the fixed quantity for replenishment orders of this item template. This value ensures consistent order sizes in planning and procurement.
FixedDaysSupply	Decimal	False	No	Specifies the number of days’ worth of supply that should be maintained for this item template. This value aids in demand-based planning.
FixedLotSizeMultiplier	Decimal	False	No	Defines the lot-size multiplier used for ordering or manufacturing this item template. This value ensures that order quantities adhere to specific increments.
ReleaseAuthorizationRequiredValue	String	False	No	Indicates whether release authorization is required before processing supply orders for this item template. This informaton ensures controlled procurement or production.
AutomaticallyExpireASNFlag	Bool	False	No	Specifies whether Advanced Shipment Notices (ASNs) for this item template expire automatically if not received within a predefined timeframe.
ConsignedFlag	Bool	False	No	Indicates whether this item template is managed under a consignment arrangement, where inventory remains supplier-owned until used or sold.
ReplenishmentMinimumOrder	Decimal	False	No	Defines the minimum quantity required when generating replenishment orders for this item template. This value prevents inefficient small orders.
ReplenishmentMaximumOrder	Decimal	False	No	Specifies the maximum allowable replenishment order quantity. This value controls excessive stock accumulation.
VMIFixedOrderQuantity	Decimal	False	No	Defines the fixed-order quantity for Vendor-Managed Inventory (VMI) scenarios. This value ensures consistent replenishment practices.
ForecastTypelValue	String	False	No	Specifies the type of forecast applied to this item template, such as 'Demand Forecast', 'Supply Forecast', or 'Consumption-Based Forecasting'.
ForecastHorizon	Decimal	False	No	Defines the forecast horizon for this item template. This information indicates how far into the future demand is projected for planning purposes.
PlanningMethodValue	String	False	No	Indicates the planning method assigned to this item template. This method determines whether it follows manual, automated, or system-driven planning rules.
RoundingControlTypeFlag	Bool	False	No	Determines whether rounding controls are applied to order quantities for this item template. These controls ensure compliance with unit increments.
CreateSupplyFlag	Bool	False	No	Indicates whether supply is automatically created for this item template. This information ensures continuous availability in planning workflows.
PlanningTimeFence	String	False	No	Defines the planning time fence for this item template. This information restricts automatic changes to supply plans within a certain time frame.
DemandTimeFence	String	False	No	Specifies the demand time fence. This information prevents last-minute demand changes from affecting planned supply decisions.
ReleaseTimeFence	String	False	No	Defines the release time fence. This information ensures supply orders for this item template are released only within a predefined planning window.
ShrinkageRate	Decimal	False	No	Represents the expected shrinkage rate for this item template. This value accounts for losses due to damage, spoilage, or process inefficiencies.
ForecastControlValue	String	False	No	Specifies the forecast control method used for this item template. This method determines whether forecast data influences planning decisions.
AcceptableEarlyDays	Decimal	False	No	Defines the acceptable number of days an order for this item template can be received early without impacting planning calculations.
PlanningTimeDays	Decimal	False	No	Indicates the number of days used in planning calculations for this item template. This value determines lead time and scheduling accuracy.
DemandTimeDays	Decimal	False	No	Defines the number of days within which demand for this item template is considered stable. This value prevents late changes to orders.
ReleaseTimeDays	Decimal	False	No	Specifies the number of days within which supply releases are controlled for this item template. This value ensures proper execution timing.
MRPCalculateATPFlag	Bool	False	No	Indicates whether ATP is calculated for this item template in Material Requirements Planning (MRP).
RepairLeadtime	Decimal	False	No	Defines the lead time required to repair or refurbish this item template. This information ensures accurate scheduling for service operations.
RepairYield	Decimal	False	No	Specifies the expected yield percentage after repairs. This metric determines how much of the repaired quantity remains usable.
PreprocessingDays	Decimal	False	No	Represents the number of days required for preprocessing activities, such as inspection or preparation, before manufacturing or fulfillment.
PostprocessingDays	Decimal	False	No	Defines the number of days needed for postprocessing activities after production or fulfillment, including packaging and quality checks.
ProcessingDays	Decimal	False	No	Indicates the total number of days required to process this item template through manufacturing or order fulfillment cycles.
VariableLeadTime	Decimal	False	No	Represents the variable lead-time component for this item template. This component accounts for fluctuations in production or procurement duration.
CumulativeTotalLeadTime	Decimal	False	No	Defines the total lead time for this item template. This lead time includes all processing, transportation, and waiting periods.
FixedLeadTime	Decimal	False	No	Specifies the fixed lead time required for this item template. This lead time represents standard processing duration regardless of order quantity.
CumulativeManufacturingLeadTime	Decimal	False	No	Defines the total lead time for manufacturing this item template, including all production steps and dependencies.
LeadTimeLotSize	Decimal	False	No	Defines the lot size used for calculating lead times in procurement and production planning. This lot size ensures accurate scheduling and order quantities.
PurchasingFlag	Bool	False	No	Indicates whether this item template is available for purchasing. This flag allows it to be procured through the purchasing system.
UseApprovedSupplierFlag	Bool	False	No	Specifies whether this item template must be purchased only from approved suppliers. This flag ensures compliance with sourcing policies.
NegotiationRequiredFlag	Bool	False	No	Indicates whether supplier negotiations are required before purchasing this item template. Typically, this informaton is used for high-value or strategic purchases.
PurchasingInputTaxClassificationValue	String	False	No	Defines the tax classification applied to incoming purchases of this item template. This classification ensures proper tax calculation and reporting.
InvoiceCloseTolerancePercentage	Decimal	False	No	Specifies the allowable variance percentage between the invoiced amount and the expected amount before an invoice can be closed.
HazardClassValue	String	False	No	Indicates the hazard classification for this item template. This classification ensures proper handling, storage, and transportation compliance with safety regulations.
AssetCategoryValue	String	False	No	Defines the asset category associated with this item template. This categorization is used for financial tracking, depreciation, and asset management.
PurchasableFlag	Bool	False	No	Specifies whether this item template is eligible for procurement transactions. This flag allows it to be purchased from suppliers.
TaxableFlag	Bool	False	No	Indicates whether this item template is subject to sales or use tax in purchasing transactions. This flag ensures tax compliance in procurement.
BuyerOrganizationValue	String	False	No	Specifies the buyer organization responsible for managing procurement transactions involving this item template.
DefaultBuyerValue	String	False	No	Defines the default buyer assigned to this item template. This information ensures consistent purchasing responsibility within the organization.
ReceiptCloseTolerancePercentage	Decimal	False	No	Specifies the allowable variance percentage for received quantities before the receipt transaction can be closed.
UNNumberValue	String	False	No	Defines the United Nations (UN) number for hazardous materials associated with this item template. This number is used for global transportation compliance.
ListPrice	Decimal	False	No	Specifies the standard list price of this item template. This value is used as a reference price in procurement and sales transactions.
PriceTolerancePercentage	Decimal	False	No	Defines the maximum allowable percentage variance in price before requiring approval or triggering alerts in purchasing transactions.
MarketPrice	Decimal	False	No	Represents the current market price of this item template. This value is used for comparison in procurement and cost analysis.
RoundingFactor	Decimal	False	No	Defines the rounding factor applied to pricing, order quantities, or transaction values for this item template, ensuring consistent calculations.
MatchApprovalLevelValue	String	False	No	Specifies the level of approval required for matching purchase orders, invoices, and receipts for this item template.
MatchConfigurationOptionValue	String	False	No	Defines the matching configuration rule for this item template. This rule determines how invoice and receipt matching processes are executed.
ReceiptDateActionValue	String	False	No	Specifies the action taken when a receipt is outside the allowed receipt date tolerance for this item template (for example, 'accept', 'warn', or 'reject').
DaysEarlyReceiptAllowed	Decimal	False	No	Defines the number of days before the scheduled receipt date that this item template can be received without triggering exceptions.
DaysLateReceiptAllowed	Decimal	False	No	Specifies the number of days after the scheduled receipt date that this item template can be received before impacting compliance or planning.
AllowSubstituteReceiptsFlag	Bool	False	No	Indicates whether substitute receipts are allowed for this item template. This flag enables alternate items to be received in place of the ordered item.
AllowUnorderedReceiptsFlag	Bool	False	No	Specifies whether receipts can be processed for this item template without an associated purchase order. Typically, this flag is used for miscellaneous receipts.
QuantityReceivedToleranceAction	String	False	No	Defines the system action taken when the received quantity exceeds the allowed tolerance for this item template (for example, 'accept', 'warn', or 'reject').
QuantityReceivedTolerancePercentage	Decimal	False	No	Specifies the acceptable percentage variance for received quantities before triggering exceptions or requiring manual intervention.
ItemExtensibleFlexfieldCategoryCode	String	False	No	Defines the category code associated with this item template’s extensible flexfields (EFFs). This code allows for additional attribute customization.
CreationDate	Datetime	False	No	Specifies the date when this item template was created in the system. This date serves as a reference for auditing and historical tracking.
LastUpdateDate	Datetime	False	No	Indicates the most recent date when this item template was updated,. This date ensures visibility into changes and modifications.
BackToBackEnabledFlag	Bool	False	No	Indicates whether this item template supports back-to-back ordering, where sales orders trigger automatic purchase or manufacturing orders.
ContractManufacturingFlag	Bool	False	No	Specifies whether this item template is eligible for contract manufacturing, where production is outsourced to external suppliers.
DaysOfCover	Decimal	False	No	Defines the number of days of supply coverage required for this item template. This value ensures adequate stock availability in planning models.
DemandPeriod	Decimal	False	No	Specifies the length of time used for demand aggregation in planning calculations for this item template. This value influences forecasting and replenishment.
SafetyStockPlanningMethodValue	String	False	No	Specifies the safety stock planning method used for this item template (for example, 'Min-Max', 'Statistical', or 'Fixed Quantity'). This information ensures adequate inventory levels.
OutsideProcessServiceFlag	Bool	False	No	Indicates whether this item template is used for outside processing services, where production steps are outsourced to external suppliers.
AllowMaintenanceAssetFlag	Bool	False	No	Specifies whether this item template can be assigned as a maintenance asset. This flag enables it to be tracked for servicing and repairs.
EnableGenealogyTrackingFlag	Bool	False	No	Indicates whether genealogy tracking is enabled for this item template. This flag allows traceability of components and materials throughout production and usage.
EngineeredItemFlag	Bool	False	No	Specifies whether this item template represents an engineered item, which is typically subject to design control and revision management.
ProcurementBusinessUnitName	String	False	No	Defines the business unit responsible for procurement activities related to this item template. This value ensures proper financial and purchasing assignment.
ForcePurchaseLeadTimeFlag	Bool	False	No	Indicates whether purchase lead-time enforcement is required for this item template. This flag prevents transactions that do not meet lead time criteria.
ReplacementTypeValue	String	False	No	Specifies the type of replacement strategy applicable to this item template (for example, 'alternate item', 'substitute item', or 'standard replacement'.
BuyerEmailAddress	String	False	No	Defines the email address of the designated buyer responsible for purchasing this item template. This information enables procurement communication and approvals.
AssetTrackedValue	String	False	No	Indicates whether this item template is tracked as an asset. This information determines whether depreciation and lifecycle management apply.
RequestId	Long	False	No	The unique identifier for the request associated with this item template,. This identifier is used for tracking system-generated changes and approvals.
CreatedBy	String	False	No	Specifies the user who created this item template. This information ensures accountability and traceability in system records.
CreationDateTime	Datetime	False	No	Indicates the exact date and time when this item template was created in the system. This information is used for historical tracking and auditing.
LastUpdateDateTime	Datetime	False	No	Represents the most recent date and time when this item template was updated. This information ensures visibility into modifications.
LastUpdateLogin	String	False	No	Defines the system login identifier used when the last update was performed on this item template. This identifier provides an audit trail.
LastUpdatedBy	String	False	No	Indicates the user who last updated this item template. This information ensures traceability of modifications.
InternallyTransferableFlag	Bool	False	No	Specifies whether this item template is eligible for internal transfers between organizations or locations.
TransferOrdersEnabledFlag	Bool	False	No	Indicates whether transfer orders (TOs) are enabled for this item template. This flag allows movement between inventory locations through formal transfer documents.
ReplenishmentMaximumDaysOfSupply	Decimal	False	No	Defines the maximum number of days of supply allowed for replenishment planning. This information prevents excessive inventory accumulation.
CustomerSelfServiceEnabledFlag	Bool	False	No	Specifies whether this item template is available for customer self-service transactions, such as direct ordering through a web portal.
AllowPurchasingDocumentDescriptionUpdateFlag	Bool	False	No	Indicates whether users can modify the item description on purchasing documents. This information allows flexibility in procurement transactions.
EnableContractCoverage	Bool	False	No	Determines whether contract coverage is enabled for this item template. This information ensures service or warranty agreements apply.
CarryingCostPercentage	Decimal	False	No	Specifies the percentage cost associated with holding inventory for this item template. This cost is used in cost analysis and financial planning.
ReplenishmentMinimumDaysOfSupply	Decimal	False	No	Defines the minimum number of days of supply required for replenishment planning. This value ensures stock availability without excess.
AllowExpressTransactionsFlag	Bool	False	No	Indicates whether express transactions, such as fast-track receiving or expedited processing, are allowed for this item template.
ReceiptRoutingValue	String	False	No	Specifies the default receipt routing method for this item template, such as 'Standard Receipt', 'Inspection Required', or 'Direct Delivery'.
InvoiceMatchOptionValue	String	False	No	Defines the invoice matching rule applicable to this item template, determining how purchase orders, receipts, and invoices are reconciled.
CommsActivationRequiredFlag	Bool	False	No	Indicates whether communications activation is required for this item template. This flag is commonly used for networked or subscription-based products.
RequiresFulfillmentLocationFlag	Bool	False	No	Specifies whether a fulfillment location must be assigned when processing orders for this item template. This flag ensures accurate delivery routing.
IssueUOMValue	String	False	No	Defines the UOM used when issuing this item template from inventory. This UOM ensures accurate transaction quantities.
EnforceShipToLocationValue	String	False	No	Specifies whether shipping transactions must adhere to predefined ship-to locations for this item template. This information ensures compliance with fulfillment policies.
StandardCoverageValue	String	False	No	Defines the standard coverage applicable to this item template, such as service warranties or contractual guarantees.
ReplenishmentSourceTypeValue	String	False	No	Specifies the source type for replenishing this item template, such as 'supplier procurement', 'internal transfer', or 'contract manufacturing'.
TrackingUOMValue	String	False	No	Defines the UOM used for tracking this item template. This UOM ensures proper inventory control at a granular level.
SecondaryUOMValue	String	False	No	Specifies the secondary UOM for this item template. This UOM is used in dual UOM tracks scenarios where conversion is required.
PricingUOMValue	String	False	No	Defines the UOM used for pricing transactions related to this item template. This UOM ensures consistency in financial calculations.
HardPeggingLevelValue	String	False	No	Indicates the level of hard pegging required for this item template. This value ensures that demand is linked to specific supply sources.
CommonSupplyProjectDemandFlag	Bool	False	No	Specifies whether this item template supports common supply across multiple projects, consolidating inventory demand.
EnableIotFlag	Bool	False	No	Indicates whether Internet of Things (IoT) tracking is enabled for this item template. This flag allows integration with connected devices and real-time monitoring.
ExpenditureTypeValue	String	False	No	Defines the expenditure type assigned to this item template. This type determines how costs are categorized in financial tracking.
PackagingStringValue	String	False	No	Specifies the packaging description for this item template. This description details how it is packed for storage or shipping.
CreateSupplyAfterDate	Date	False	No	Indicates the date after which supply creation is allowed for this item template. This date ensures demand-driven production or procurement.
CreateFixedAssetValue	String	False	No	Determines whether this item template is designated as a fixed asset upon acquisition. This information ensures proper financial classification.
UnderCompletionToleranceTypeValue	String	False	No	Specifies the tolerance type allowed for under-completion of manufacturing orders for this item template.
UnderCompletionToleranceValue	Decimal	False	No	Defines the acceptable under-completion percentage or quantity for manufacturing or assembly processes of this item template.
DefaultRepairTransactionName	String	False	No	Defines the default repair transaction type for this item template. This information ensures consistent processing of maintenance or refurbishment activities.
TemplateName	String	False	No	Specifies the name of the item template. This name is used for categorization and reference in system configurations.
Finder	String	False	No	Defines the search criteria or query used for locating this item template within the system. This criteria or query facilitates quick access.

Return to Top

ItemTemplatesitemDFFs

Name	Type	ReadOnly	FilterOnly	Description
ItemTemplatesItemId [KEY]	Long	False	No	Specifies the unique identifier for an item within the ItemTemplatesitemDFFs module. This identifier links item template records to their associated descriptive flexfields (DFFs), ensuring consistency in custom attributes.
ItemTemplatesOrganizationId [KEY]	Long	False	No	Defines the unique identifier for the organization managing the item template. This identifier ensures that DFFs are correctly mapped to the appropriate business unit for classification and reporting.
InventoryItemId [KEY]	Long	False	No	Represents the unique identifier for the part, item, product, or service within the inventory system. This identifier is used to track and manage inventory records across procurement, sales, and manufacturing workflows.
OrganizationId [KEY]	Long	False	No	Defines the unique identifier for the organization that owns or manages the inventory item. This identifier ensures proper assignment of inventory items to the correct business unit, enabling financial reporting and operational planning.
_FLEX_Context	String	False	No	Specifies the DFF context name associated with the item. This context name determines how additional custom attributes are structured and applied to item records.
_FLEX_Context_DisplayValue	String	False	No	Represents the display value of the DFF context name. This context name provides a user-friendly reference for managing custom item attributes.
Finder	String	False	No	Defines the search mechanism or query criteria used to locate records in the ItemTemplatesitemDFFs module. This value enhances system usability by allowing efficient data retrieval for item templates and DFFs.
ItemId	Long	False	No	Specifies the unique identifier for the item within the item template module. This identifier ensures accurate tracking and association of item attributes across descriptive DFFs.

Return to Top

ItemTemplatesitemEFFs

Name	Type	ReadOnly	FilterOnly	Description
ItemTemplatesItemId [KEY]	Long	False	No	Specifies the unique identifier for an item within the ItemTemplatesitemEFFs module. This identifier links item template records to their associated extensible flexfields (EFFs), allowing for additional custom attributes.
ItemTemplatesOrganizationId [KEY]	Long	False	No	Defines the unique identifier for the organization managing the item template. This identifier ensures that EFFs are applied correctly within the appropriate business unit, supporting classification and reporting.
InventoryItemId [KEY]	Long	False	No	Represents the unique identifier for the part, item, product, or service within the inventory system. This identifier is used to track and manage inventory records across procurement, sales, and manufacturing workflows.
OrganizationId [KEY]	Long	False	No	Defines the unique identifier for the organization that owns or manages the inventory item. This identifier ensures proper assignment of inventory items to the correct business unit, enabling financial reporting and operational planning.
StyleItemId	Long	False	No	Specifies the unique identifier for a style item, which serves as a base model for configurable product variations. This identifier is commonly used in industries like fashion, automotive, and consumer electronics.
MasterOrganizationId	Long	False	No	Represents the unique identifier of the master organization responsible for managing the item template. This identifier ensures consistency in item attributes across multiple inventory organizations.
CategoryCode	String	False	No	Defines the category code assigned to the item, which classifies it within the organization's item hierarchy. This category code is critical for catalog management, reporting, and searchability.
StyleItemFlag	Bool	False	No	Indicates whether the item is classified as a style item. If set to 'true', the item serves as a template for creating variations, such as different sizes or colors.
TemplateItemFlag	String	False	No	Specifies whether the item functions as a template item. Template items define standard attributes and configurations used to create new items efficiently.
Finder	String	False	No	Defines the search mechanism or query criteria used to locate records in the ItemTemplatesitemEFFs module. This field enhances system usability by enabling efficient data retrieval for item templates and EFFs.
ItemId	Long	False	No	Specifies the unique identifier for the item within the item template module. This identifier ensures accurate tracking and association of item attributes across EFFs.

Return to Top

ItemTemplatesitemGlobalDFFs

Name	Type	ReadOnly	FilterOnly	Description
ItemTemplatesItemId [KEY]	Long	False	No	Specifies the unique identifier for an item within the ItemTemplatesitemGlobalDFFs module. This identifier links item template records to their associated global descriptive flexfields (DFFs), allowing for additional standardized attributes.
ItemTemplatesOrganizationId [KEY]	Long	False	No	Defines the unique identifier for the organization managing the item template. This identifier ensures that global DFFs are applied consistently across business units for classification and reporting.
InventoryItemId [KEY]	Long	False	No	Represents the unique identifier for the part, item, product, or service within the inventory system. This identifier is used to track and manage inventory records across procurement, sales, and manufacturing workflows.
OrganizationId [KEY]	Long	False	No	Defines the unique identifier for the organization that owns or manages the inventory item. This identifier ensures proper assignment of inventory items to the correct business unit, enabling financial reporting and operational planning.
_FLEX_Context	String	False	No	Specifies the DFF context name assigned to the item globally. This context name determines how additional custom attributes are structured and applied consistently across all business units.
_FLEX_Context_DisplayValue	String	False	No	Represents the display value of the DFF context name. This context name provides a user-friendly reference for managing custom item attributes at a global level.
Finder	String	False	No	Defines the search mechanism or query criteria used to locate records in the ItemTemplatesitemGlobalDFFs module. This field enhances system usability by enabling efficient data retrieval for global DFFs.
ItemId	Long	False	No	Specifies the unique identifier for the item within the item template module. This identifier ensures accurate tracking and association of item attributes across global DFFs.

Return to Top

ItemTemplatesitemRevisions

Name	Type	ReadOnly	FilterOnly	Description
ItemTemplatesItemId [KEY]	Long	False	No	Specifies the unique identifier for an item within the ItemTemplatesitemRevisions module. This identifier links item template records to their associated revision details, ensuring version control and historical tracking.
ItemTemplatesOrganizationId [KEY]	Long	False	No	Defines the unique identifier for the organization managing the item template. This identifier ensures that item revision data is correctly associated with the appropriate business unit for compliance and reporting.
RevisionExtensibleFlexfieldCategoryCode	String	False	No	Represents the abbreviation that identifies the item class associated with the item revision extensible flexfield (EFF). This classification helps apply structured attributes to item revisions for improved tracking and management. The value can be reviewed and updated using the Setup and Maintenance work area and the Manage Item Classes task.
Finder	String	False	No	Defines the search mechanism or query criteria used to locate records in the ItemTemplatesitemRevisions module. This field enhances system usability by enabling efficient data retrieval for item revision tracking and version control.
ItemId	Long	False	No	Specifies the unique identifier for the item within the item template module. This identifier ensures accurate tracking of item revisions and associations with extensible flexfields.
OrganizationId	Long	False	No	Defines the unique identifier for the organization that manages the item revision. This identifier ensures proper assignment of revision-controlled items to the correct business unit, enabling accurate lifecycle management and compliance tracking.

Return to Top

ItemTemplatesitemRevisionsDFFs

Name	Type	ReadOnly	FilterOnly	Description
ItemTemplatesItemId [KEY]	Long	False	No	Specifies the unique identifier for an item within the ItemTemplatesitemRevisionsDFFs module. This identifier links item template records to their associated revision descriptive flexfields (DFFs), allowing for the inclusion of custom attributes.
ItemTemplatesOrganizationId [KEY]	Long	False	No	Defines the unique identifier for the organization managing the item template. This identifier ensures that item revision descriptive flexfields (DFFs) are correctly associated with the appropriate business unit for classification and reporting.
RevisionId [KEY]	Long	False	No	Represents the unique identifier for a specific revision of the item. This identifier is used to track changes to the item over time, ensuring proper version control and historical tracking.
_FLEX_ValidationDate	Date	False	No	Specifies the date on which the descriptive flexfield (DFF) attributes for the item revision were last validated. This date helps ensure data accuracy and compliance with predefined attribute rules.
_FLEX_Context	String	False	No	Defines the descriptive flexfield (DFF) context name assigned to the item revision. This context name determines how additional custom attributes are structured and applied.
_FLEX_NumOfSegments	Int	False	No	Indicates the total number of segments within the descriptive flexfield (DFF) for the item revision. This value determines the number of attributes available for customization.
_FLEX_NumOfVisibleSegments	Int	False	No	Specifies the number of visible segments within the descriptive flexfield (DFF) for the item revision. This value controls which attributes are displayed to users during item management.
Finder	String	False	No	Defines the search mechanism or query criteria used to locate records in the ItemTemplatesitemRevisionsDFFs module. This field enhances system usability by enabling efficient data retrieval for item revisions and associated flexfields.
ItemId	Long	False	No	Specifies the unique identifier for the item within the item template module. This identifier ensures accurate tracking of item revisions and associations with descriptive flexfields.
OrganizationId	Long	False	No	Defines the unique identifier for the organization that manages the item revision. This identifier ensures proper assignment of revision-controlled items to the correct business unit, enabling accurate lifecycle management and compliance tracking.

Return to Top

ItemTemplatesitemRevisionsEFFs

Name	Type	ReadOnly	FilterOnly	Description
ItemTemplatesItemId [KEY]	Long	False	No	Specifies the unique identifier for an item within the ItemTemplatesitemRevisionsEFFs module. This identifier links item template records to their associated revision extensible flexfields (EFFs), allowing for additional structured attributes.
ItemTemplatesOrganizationId [KEY]	Long	False	No	Defines the unique identifier for the organization managing the item template. This identifier ensures that revision extensible flexfields (EFFs) are correctly associated with the appropriate business unit for classification and reporting.
RevisionId [KEY]	Long	False	No	Represents the unique identifier for a specific revision of the item. This identifier is used to track changes to the item over time, ensuring proper version control and historical tracking.
CategoryCode	String	False	No	Defines the category code assigned to the item revision. This classification helps in organizing and managing item revisions based on business-specific categories.
VersionId	Long	False	No	Specifies the version identifier for the item revision. This identifier tracks the evolution of item revisions over time, ensuring consistency and historical traceability.
Finder	String	False	No	Defines the search mechanism or query criteria used to locate records in the ItemTemplatesitemRevisionsEFFs module. This field enhances system usability by enabling efficient data retrieval for item revisions and associated extensible flexfields.
ItemId	Long	False	No	Specifies the unique identifier for the item within the item template module. This identifier ensures accurate tracking of item revisions and associations with extensible flexfields.
OrganizationId	Long	False	No	Defines the unique identifier for the organization that manages the item revision. This identifier ensures proper assignment of revision-controlled items to the correct business unit, enabling accurate lifecycle management and compliance tracking.

Return to Top

ItemTemplatesitemTranslations

Name	Type	ReadOnly	FilterOnly	Description
ItemTemplatesItemId [KEY]	Long	False	No	Specifies the unique identifier for an item within the ItemTemplatesitemTranslations module. This identifier links item template records to their associated translations, ensuring multilingual support and consistency across global operations.
ItemTemplatesOrganizationId [KEY]	Long	False	No	Defines the unique identifier for the organization managing the item template. This identifier ensures that translated item attributes are correctly associated with the appropriate business unit for classification and reporting.
OrganizationId [KEY]	Long	False	No	Represents the unique identifier for the organization that owns or manages the inventory item. This identifier ensures that translations are aligned with the correct business unit, facilitating accurate localization and compliance.
ItemId [KEY]	Long	False	No	Defines the unique identifier for the part, item, product, or service. This identifier allows organizations to track and manage items across different languages without losing core item attributes.
ItemDescription	String	False	No	Provides a short textual description of the part, item, product, or service in the designated language. This description ensures that users in different regions can easily identify the item.
LongDescription	String	False	No	Specifies the detailed text description of the item in the designated language. This description may contain product specifications, features, or usage instructions.
HTMLLongDescription	String	False	No	Contains the formatted description of the item using rich text or HTML. This description allows for enhanced visual presentation in catalogs, online stores, or product documentation.
Language [KEY]	String	False	No	Indicates the language associated with the item description. This field ensures that the correct translated values are applied to items based on regional and customer requirements.
SourceLanguage	String	False	No	Defines the original language from which item attributes are translated. This field helps track the source of translations and maintain consistency across multilingual catalogs.
TemplateName	String	False	No	Specifies the name of the item template used for creating standardized item records. This field ensures uniformity across multiple item translations.
CreationDateTime	Datetime	False	No	Represents the date and time when the item translation record was created. This field is useful for auditing and version control of translated content.
LastUpdateDateTime	Datetime	False	No	Indicates the date and time when the item translation record was last updated. This field helps track modifications and ensures the most recent translations are applied.
Finder	String	False	No	Defines the search mechanism or query criteria used to locate records in the ItemTemplatesitemTranslations module. This field enhances system usability by enabling efficient data retrieval for multilingual item descriptions.

Return to Top

StandardLookupsLOV

Name	Type	ReadOnly	FilterOnly	Description
LookupType [KEY]	String	False	No	Specifies the type of lookup, which categorizes different sets of predefined values used in system configurations. Lookup types help standardize data entry by restricting user inputs to predefined options.
LookupCode [KEY]	String	False	No	Defines the specific code associated with a lookup type. This code serves as the unique identifier for a value within a lookup type and is used in various system processes and validations.
Meaning	String	False	No	Provides a user-friendly label or description of the lookup code. This value is typically displayed in application interfaces for easier reference by end users.
Description	String	False	No	Contains additional details explaining the purpose or usage of the lookup code. These details help users understand the context of the lookup value in business processes.
Tag	String	False	No	Specifies an optional tag associated with the lookup entry. Tags are used for additional classification or grouping of lookup values for reporting and filtering purposes.
ActiveDate	Date	False	No	Indicates the date when the lookup code becomes active. Before this date, the lookup value is considered inactive and cannot be used in transactions or selections.
Bind_ParentLookupCode	String	False	No	Defines the parent lookup code that links to the current lookup value. This lookup code establishes hierarchical relationships between lookup values to enable dependent selections.
Bind_ParentSetidDetermType	String	False	No	Specifies the determination type for the parent set identifier. This value helps in configuring hierarchical relationships between lookup sets based on business rules.
Bind_ParentSetidDetermValue	String	False	No	Represents the determination value for the parent set identifier. This value is used to dynamically establish parent-child relationships in lookup configurations.
Bind_RelationshipId	Long	False	No	Contains a unique identifier representing the relationship between lookup values. This identifier is used to enforce dependencies and ensure consistency in related lookups.
BindActiveDate	Date	False	No	Specifies the activation date of a bound lookup value. This date helps manage effective dating for lookup relationships, ensuring that related values are activated together.
BindLookupCode	String	False	No	Represents a secondary lookup code that is bound to the current lookup value. This lookup code enables cross-referencing between different lookup types and values.
BindLookupType	String	False	No	Defines the type of lookup that is bound to the current lookup entry. This value allows for relationships between multiple lookup types to support complex configurations.
BindTag	String	False	No	Specifies a tag for the bound lookup value. This tag enables additional classification or filtering options when managing lookup relationships.
Finder	String	False	No	Defines the search mechanism or query criteria used to locate records in the StandardLookupsLOV module. This field enhances system usability by enabling efficient data retrieval for lookup values.
NewLookupCode1	String	False	No	Represents an additional lookup code for future expansion or mapping. This lookup code is used when new lookup values need to be added dynamically without modifying core configurations.
NewLookupCode2	String	False	No	Specifies a secondary new lookup code that can be used for mapping or future expansion. This lookup code provides flexibility in lookup management.
NewLookupCode3	String	False	No	Contains a third optional lookup code that can be used for additional classification, reporting, or extended configuration needs.
NewLookupCode4	String	False	No	Represents another lookup code reserved for future enhancements. This lookup codee allows for greater adaptability in lookup-based configurations.
NewLookupCode5	String	False	No	Defines a fifth optional lookup code that provides additional flexibility for extending predefined lookup values without requiring immediate system modifications.

Return to Top

TradingPartnerItemRelationships

Name	Type	ReadOnly	FilterOnly	Description
ItemRelationshipId [KEY]	Long	False	No	Specifies the unique identifier for the trading partner item relationship. This identifier is used to establish and track the association between an organization's item and a trading partner's corresponding item.
OrganizationId	Long	False	No	Defines the unique identifier for the organization that manages the item relationship. This identifier ensures that item trading relationships are properly assigned to the correct business entity.
OrganizationCode	String	False	No	Represents the abbreviated code that uniquely identifies the organization. This code helps link trading partner item relationships to specific business units.
InventoryItemId	Long	False	No	Contains the unique identifier for the inventory item in the organization's system. This identifier ensures that the correct internal item is linked to its external trading partner equivalent.
Item	String	False	No	Specifies the name or number of the part, item, product, or service within the organization’s inventory. This value is commonly used in procurement, sales, and inventory tracking.
TradingPartnerType	String	False	No	Indicates the type of trading partner, such as 'supplier', 'customer', 'distributor', 'manufacturer', or 'competitor'. This classification helps in managing item relationships with different business entities.
TradingPartnerId	String	False	No	Defines the unique identifier for the trading partner. This identifier ensures accurate mapping between the organization's items and the external trading partner's records.
TradingPartnerName	String	False	No	Represents the name of the trading partner associated with the item relationship. This name helps users identify the external entity that supplies, sells, or competes with the organization’s item.
RegistryId	String	False	No	Specifies the unique identifier for the trading partner within a registry system. This identifier is used for legal, compliance, and supplier/customer relationship management.
TradingPartnerItemId	Long	False	No	Contains the unique identifier for the trading partner’s item. This identifier ensures that each external item is correctly linked to the corresponding internal item.
TradingPartnerItemNumber	String	False	No	Represents the number assigned to a trading partner’s item, such as a supplier item number, customer item number, manufacturer part number, or competitor reference number.
RelationshipDescription	String	False	No	Provides a textual description of the trading partner item relationship. This description helps document the nature of the association, such as supply agreements, resale partnerships, or competitive analysis.
StartDateTime	Datetime	False	No	Indicates the date and time when the trading partner item relationship becomes active. This information ensures proper tracking of when an item relationship is valid for transactions or reporting.
EndDateTime	Datetime	False	No	Defines the date and time when the trading partner item relationship expires or becomes inactive. This information ensures proper governance of outdated or terminated relationships.
CustomerItemRelationshipRank	Long	False	No	Specifies the ranking used within a customer item relationship. This ranking helps prioritize multiple customer item mappings based on importance or usage frequency.
CompetitorItemRelationshipType	String	False	No	Indicates the type of competitor associated with the item relationship, such as 'direct competitor', 'indirect competitor', or 'substitute provider'.
RelationshipStatus	String	False	No	Represents the current status of the trading partner item relationship, such as 'Active', 'Inactive', 'Pending Approval', or 'Obsolete'. This status helps in managing the lifecycle of item relationships.
CreationDateTime	Datetime	False	No	Specifies the date and time when the trading partner item relationship record was created. This information is useful for auditing and historical tracking of item relationships.
LastUpdateDateTime	Datetime	False	No	Indicates the date and time when the trading partner item relationship was last updated. This information ensures that the latest changes are captured for reporting and analysis.
CreatedBy	String	False	No	Represents the user who initially created the trading partner item relationship record. This value is important for audit trails and accountability.
LastUpdateLogin	String	False	No	Defines the user session that last updated the trading partner item relationship record. This information helps track system access and modification history.
LastUpdatedBy	String	False	No	Specifies the user who made the most recent changes to the trading partner item relationship. This value is useful for maintaining audit logs and security compliance.
TradingPartnerItemDescription	String	False	No	Provides a detailed description of the trading partner’s item. This description helps users understand the external item’s specifications, features, or intended use.
TradingPartnerItemStatus	String	False	No	Indicates the status of the trading partner’s item, such as 'Active', 'Discontinued', or 'Pending Approval'. This status ensures that only valid items are used in transactions.
TradingPartnerStatus	String	False	No	Represents the overall status of the trading partner, such as 'Approved', 'On Hold', or 'Blacklisted'. This status helps in enforcing supplier or customer management policies.
EffectiveDate	Datetime	False	No	Specifies the date when the trading partner item relationship becomes effective for transactions and reporting. This date ensures proper activation timing for business processes.
Finder	String	False	No	Defines the search mechanism or query criteria used to locate records in the TradingPartnerItemRelationships module. This value enhances system usability by enabling efficient data retrieval for item relationships.
ItemNumber	String	False	No	Represents the internal item number used by the organization. This item number ensures that internal records are accurately linked to external trading partner items for seamless integration.

Return to Top

TradingPartnerItemRelationshipsDFF

Name	Type	ReadOnly	FilterOnly	Description
TradingPartnerItemRelationshipsItemRelationshipId [KEY]	Long	False	No	Specifies the unique identifier for the trading partner item relationship within the TradingPartnerItemRelationshipsDFF module. This identifier links item relationship records to their associated descriptive flexfields (DFFs), allowing for additional custom attributes.
ItemRelationshipId [KEY]	Long	False	No	Defines the unique identifier for the item relationship between the organization and its trading partner. This identifier ensures that the association between internal and external items is correctly tracked and managed.
ItemRelationshipType	String	False	No	Represents the type of item relationship established with the trading partner. This relationship can indicate whether the item is a supplier item, customer item, competitor item, or any other business-specific relationship.
_FLEX_ValidationDate	Date	False	No	Specifies the date on which the DFF attributes for the trading partner item relationship were last validated. This date ensures data accuracy and compliance with predefined attribute rules.
_FLEX_Context	String	False	No	Defines the DFF context name assigned to the trading partner item relationship. This context name determines how additional custom attributes are structured and applied to the relationship.
_FLEX_NumOfSegments	Int	False	No	Indicates the total number of segments within the DFF for the trading partner item relationship. This value determines how many attributes can be customized for classification and reporting.
_FLEX_NumOfVisibleSegments	Int	False	No	Specifies the number of visible segments within the DFF for the trading partner item relationship. This value controls which attributes are displayed to users when managing item relationships.
EffectiveDate	Datetime	False	No	Indicates the date when the trading partner item relationship becomes effective. This date ensures proper activation timing for transactions, reporting, and supplier or customer interactions.
Finder	String	False	No	Defines the search mechanism or query criteria used to locate records in the TradingPartnerItemRelationshipsDFF module. This value enhances system usability by enabling efficient data retrieval for item relationships and associated DFFs.
ItemNumber	String	False	No	Represents the internal item number used by the organization. This item number ensures that internal records are accurately linked to external trading partner items for seamless integration and traceability.

Return to Top

TradingPartnerItemRelationshipstranslatableAttributes

Name	Type	ReadOnly	FilterOnly	Description
TradingPartnerItemRelationshipsItemRelationshipId [KEY]	Long	False	No	Specifies the unique identifier for the trading partner item relationship within the TradingPartnerItemRelationshipstranslatableAttributes module. This identifier links item relationship records to their translatable attributes, ensuring multilingual support.
ItemRelationshipId [KEY]	Long	False	No	Defines the unique identifier for the item relationship between the organization and its trading partner. This identifier ensures accurate tracking of item associations across different languages.
RelationshipDescription	String	False	No	Provides a textual description of the item relationship in the designated language. This description helps document the nature of the association, such as supplier agreements, resale partnerships, or competitive analysis.
Language [KEY]	String	False	No	Indicates the language used for the translatable attributes of the item relationship. This field ensures that descriptions and other attributes are correctly localized for different regions.
SourceLanguage	String	False	No	Specifies the original language from which the relationship description is translated. This field helps track the source of translations and maintain consistency across multilingual records.
CreationDateTime	Datetime	False	No	Represents the date and time when the translatable attributes for the trading partner item relationship were created. This information is useful for auditing and version control of translated content.
LastUpdateDateTime	Datetime	False	No	Indicates the date and time when the translatable attributes for the trading partner item relationship were last updated. This information ensures that the most recent translations are applied and maintained.
CreatedBy	String	False	No	Identifies the user who initially created the translatable attributes for the item relationship. This value is important for audit trails and accountability.
LastUpdateLogin	String	False	No	Defines the user session that last updated the translatable attributes for the item relationship. This information helps track system access and modification history.
LastUpdatedBy	String	False	No	Specifies the user who made the most recent changes to the translatable attributes. This value is useful for maintaining audit logs and ensuring compliance with translation policies.
EffectiveDate	Datetime	False	No	Specifies the date when the translated attributes for the item relationship become effective. This date ensures proper activation timing for multilingual business operations and reporting.
Finder	String	False	No	Defines the search mechanism or query criteria used to locate records in the TradingPartnerItemRelationshipstranslatableAttributes module. This value enhances system usability by enabling efficient data retrieval for multilingual item relationship descriptions.
ItemNumber	String	False	No	Represents the internal item number used by the organization. This item number ensures that internal records are accurately linked to external trading partner items while maintaining consistency across different languages.

Return to Top