Oracle Fusion Cloud SCM Connector Objects (ProductLifecycleManagement Schema)
| 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |
| Name | Type | ReadOnly | References | 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. |