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