Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

ItemTemplates

Manages item templates, which provide predefined sets of attributes for quicker item creation and standardization.

Columns

Name Type Description
ItemId [KEY] Long 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 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 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 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 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 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 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 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 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 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 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 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 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 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 A comprehensive description providing in-depth details about the item template. This description includes specifications, intended usage, and other relevant attributes.
FormattedDescription String 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 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 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 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 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 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 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 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 Indicates whether attachments (such as specifications, images, or compliance documents) associated with the item template should be copied when duplicating the item.
CopyCategoriesFlag Bool 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 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 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 The identifier of the change notice associated with modifications made to the item template. Change notices document updates, approvals, and compliance tracking.
ChangeOrderLineSequenceNumber Int 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 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 Indicates whether a configured item should be automatically created based on this template, typically in configurable manufacturing or custom product setups.
ConfigModelTypeValue String 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 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 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 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 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 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 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 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 Defines the standard production or procurement lot size for this item template. This lot size influences supply planning and inventory replenishment decisions.
InventoryAssetFlag Bool Indicates whether this item template is treated as an inventory asset, meaning it is considered in financial asset tracking and valuation calculations.
BuildInWIPFlag Bool Specifies whether this item template is built directly in Work in Process (WIP), commonly used for manufacturing workflows where production occurs incrementally.
WIPSupplyTypeValue String Defines the supply type used for issuing this item in a WIP environment (for example,'push', 'pull', or 'direct issue').
WIPSupplyLocatorValue String The default locator assigned to supply this item template in WIP transactions. This locator ensures proper tracking of materials within storage locations.
WIPSupplySubinventoryValue String The default subinventory from which this item template is supplied for WIP operations. This information determines the material source within inventory.
OvercompletionToleranceTypeValue String Specifies the type of tolerance allowed for overcompletion in WIP, such as percentage-based or absolute quantity-based thresholds.
OvercompletionToleranceValue Decimal Defines the acceptable level of overproduction beyond the planned quantity for this item template in WIP, preventing excessive overproduction.
InventoryCarryPenalty Decimal 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 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 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 Determines whether quality tracking and process inspections are enabled for this item template, ensuring compliance with quality control standards.
ProcessCostingEnabledFlag Bool 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 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 Defines the subinventory from which supply materials are drawn for process manufacturing involving this item template.
ProcessSupplyLocatorValue String Specifies the locator within the supply subinventory that is designated for storing materials used in process manufacturing for this item template.
ProcessYieldSubinventoryValue String Defines the subinventory where yield or finished goods from a process manufacturing operation involving this item template are stored.
ProcessYieldLocatorValue String Specifies the locator within the yield subinventory for storing completed output from process manufacturing of this item template.
HazardousMaterialFlag Bool Indicates whether this item template is classified as hazardous material, requiring special handling, compliance documentation, and regulatory controls.
CASNumber String 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 Specifies whether this item template is tracked as an asset, enabling asset-management features such as depreciation, maintenance, and lifecycle tracking.
AssetClassValue String Defines the asset classification assigned to this item template, categorizing it for asset management and financial reporting purposes.
ServiceRequestEnabledValue String Indicates whether service requests can be created for this item template, allowing tracking of service activities such as repairs or maintenance.
DefectTrackingOnFlag Bool Determines whether defect tracking is enabled for this item template, allowing users to log, monitor, and resolve quality issues.
ServiceDurationTypeValue String Specifies the type of service duration applicable to this item template, such as fixed period, variable duration, or based on contract terms.
ServiceDuration Decimal 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 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 Determines how the service start date is defined for this item template, such as upon shipment, installation, or activation.
ServiceStartDelay Decimal 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 Indicates whether the service or subscription associated with this item template can be temporarily suspended and resumed later.
AllowTerminateFlag Bool Indicates whether the item template allows termination of associated services, contracts, or warranties before their scheduled end date.
RequiresItemAssociationFlag Bool Specifies whether this item template requires an association with another item, such as in configurations where dependent components must be linked.
CreateFixedAssetFlag Bool Indicates whether an item created from this template should be registered as a fixed asset for financial tracking and depreciation purposes.
InstanceClassValue String Defines the classification of item instances created from this template, commonly used in asset tracking and serialized inventory management.
BillingTypeValue String 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 Indicates whether service billing is enabled for this item template, allowing charges for service-related activities like maintenance or support.
RecoveredPartDispositionValue String Defines the disposition method for recovered parts associated with this item template, such as refurbishment, disposal, or reuse in inventory.
InventoryItemFlag Bool Indicates whether this item template represents an inventory item, meaning it is managed within stock control and inventory transactions.
StockEnabledFlag Bool Determines whether stock tracking is enabled for this item template, allowing it to be stored, counted, and transacted within inventory.
MaterialTransactionEnabledFlag Bool Indicates whether this item template can be included in material transactions such as receipts, issues, transfers, and returns.
ReservableFlag Bool Specifies whether this item template can be reserved in inventory for specific orders, ensuring availability for future demand.
CheckMaterialShortageFlag Bool Determines whether material shortage checks are enforced for this item template, preventing transactions if stock is insufficient.
RevisionQuantityControlFlag Bool Indicates whether quantity control is enforced for different revisions of the item, ensuring version-specific inventory tracking.
BulkPickedFlag Bool Specifies whether this item template is eligible for bulk picking, where large quantities are picked together instead of individual units.
LotControlValue String 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 Specifies the prefix used when generating lot numbers for this item template. This prefix ensures consistent identification of lot-controlled inventory.
StartingLotNumber String Defines the starting numeric value for lot numbers assigned to this item template. This value is used for sequential lot tracking.
MaturityDays Decimal 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 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 Determines the lot expiration control method for this item template, such as 'None', 'Shelf Life Days', or 'User-Defined Expiry'.
ShelfLifeDays Decimal Specifies the number of days this item remains usable before expiration. This value is critical for perishable goods and regulated inventory.
RetestInterval Decimal Defines the interval at which this item should be retested for quality or compliance before expiration or continued use.
ExpirationActionValue String Specifies the action to be taken when the lot reaches expiration (for example, quarantine, disposal, or extension based on testing).
ExpirationActionInterval Decimal Defines the time interval before or after expiration when the specified expiration action should be executed.
ChildLotEnabledFlag Bool Indicates whether child lots can be created for this item template. This information allows hierarchical lot management and sub-lot tracking.
ChildLotFormatValidationFlag Bool Specifies whether format validation rules should be enforced when generating child lot numbers for this item template.
CopyLotAttributeFlag Bool Determines whether lot attributes should be copied when creating child lots from this item template. This information maintains consistency in lot characteristics.
ChildLotPrefix String Defines the prefix used when generating child lot numbers. This prefix ensures a structured and traceable lot numbering system.
ChildLotStartingNumber Decimal Specifies the starting numeric value for child lot numbers. This value is used for sequential tracking of sub-lots.
ChildLotParent String Indicates the parent lot from which child lots are derived. This information enables hierarchical tracking of lot-based inventory.
LotTranslateEnabledFlag Bool Determines whether lot translation is enabled. This information allows conversion of one lot number to another for traceability or compliance.
LotSplitEnabledFlag Bool Indicates whether this item template supports lot splitting. This information allows a single lot to be divided into multiple smaller lots.
LotDivisibleFlag Bool Specifies whether the lot can be divided into fractional quantities. This flag is commonly used in industries requiring precise inventory control.
LotSubstitutionEnabledFlag Bool 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 Determines whether multiple lots can be merged into a single lot for inventory simplification and batch consolidation.
GradeControlFlag Bool Indicates whether grade control is enabled for this item template. This flag allows classification based on quality or specification standards.
DefaultGradeValue String Specifies the default grade assigned to items created from this template. This grade is used for categorization in quality control and procurement.
SerialGenerationValue String Defines the serial-number generation method for this item template, such as manual, preassigned, or dynamically assigned at transaction time.
SerialStartingPrefix String Specifies the prefix applied to serial numbers generated for this item template. This prefix ensures structured and recognizable serial tracking.
SerialStartingNumber String Defines the starting numeric value for serial numbers assigned to this item template. This value is used for sequential tracking.
NegativeMeasurementError Decimal Specifies the acceptable negative-measurement error tolerance for this item template. This metric ensures quality compliance and precision in manufacturing.
PositiveMeasurementError Decimal Defines the acceptable positive-measurement error tolerance for this item template. This metric ensures accurate measurement within defined limits.
CycleCountEnabledFlag Bool Indicates whether this item template is eligible for cycle counting. This flag allows regular stock audits to improve inventory accuracy.
LotStatusEnabledFlag Bool Determines whether lot status tracking is enabled for this item template. This flag ensures control over lot usage based on status settings.
SerialStatusEnabledFlag Bool Specifies whether serial-number status tracking is enabled for this item template. This flag allows serialized items to have distinct operational states.
DefaultLotStatusValue String Defines the default lot status assigned to new lots created from this item template. This lot status determines initial usability or restrictions.
DefaultSerialStatusValue String Specifies the default serial status assigned to newly created serialized items. This serial status influences transactions and usability.
RestrictSubinventoriesFlag Bool Indicates whether this item template restricts the use of specific subinventories. This flag limits storage locations based on predefined rules.
RestrictLocatorsFlag Bool Determines whether locators are restricted for this item template. This flag enforce specific storage assignments within inventory locations.
StockLocatorControlValue String Defines the stock-locator control method for this item template. This method specifies how items are assigned to storage locations.
DimensionUOMValue String Specifies the unit of measure (UOM) used for dimensional attributes of this item template, such as inches, centimeters, or meters.
UnitWidthQuantity Decimal Defines the standard width measurement of a single unit of this item template. This metric isused for packaging and storage calculations.
UnitLengthQuantity Decimal Specifies the standard length measurement of a single unit of this item template. this metric is relevant for dimensional planning and shipping.
UnitHeightQuantity Decimal Defines the standard height measurement of a single unit of this item template. This metric is used for stacking and storage optimization.
WeightUOMValue String Specifies the UOM used for weight attributes of this item template (for example, 'Grams', 'Kilograms', or 'Pounds'.
UnitWeightQuantity Decimal Defines the standard weight of a single unit of this item template. This value impacts shipping costs and handling requirements.
VolumeUOMValue String Specifies the UOM used for volume attributes of this item template (for example, 'Cubic Inches', 'Liters', or 'Cubic meters'.
UnitVolumeQuantity Decimal Defines the volume occupied by a single unit of this item template. This value is relevant for packaging, transportation, and storage planning.
ContainerItemFlag Bool Indicates whether this item template represents a container, which is used for packaging or storing other items during handling and shipping.
ContainerTypeValue String Defines the type of container represented by this item template (for example, 'Box', 'Pallet', 'Drum', or 'Crate'.
MaximumLoadWeight Decimal Specifies the maximum allowable weight capacity for a container defined by this item template. This value ensures compliance with load restrictions.
VehicleItemFlag Bool Indicates whether this item template represents a vehicle, which can be used for material movement, logistics, or operational purposes.
InternalVolume Decimal 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 Specifies the minimum fill percentage required for a container or vehicle before shipment. This value ensures efficient space utilization.
WarehouseEquipmentFlag Bool Indicates whether this item template represents warehouse equipment (for example, forklifts, shelving units, or conveyor belts) for operational tracking.
EventFlag Bool Specifies whether this item template is associated with event-driven processes. This field enables triggers for workflow automation or business rules.
CollateralFlag Bool Indicates whether this item template represents collateral such as promotional materials, marketing brochures, or bundled non-saleable items.
CustomerOrderFlag Bool Specifies whether this item template can be included in customer orders, determining its availability for direct sales.
CustomerOrderEnabledFlag Bool 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 Defines the Available-to-Promise (ATP) calculation method for components within this item template. This calculation method ensures accurate supply commitments.
PickingRuleValue String Specifies the picking rule associated with this item template. This rule determines how inventory is selected for order fulfillment.
RMAInspectionRequiredFlag Bool Indicates whether a Return Material Authorization (RMA) inspection is required when this item template is returned by a customer.
EligibilityRuleFlag Bool 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 Specifies whether this item template can be returned by customers. This flag defines its eligibility for refunds, replacements, or credits.
ATPValue String Defines the ATP method for this item template. This method determines how availability is calculated for sales commitments.
FinancingAllowedFlag Bool Indicates whether financing options are available for this item template, enabling installment payments or lease agreements.
SalesProductTypeValue String Specifies the sales-product type classification assigned to this item template, such as tangible goods, services, or subscriptions.
TransactionEnabledFlag Bool 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 Indicates whether this item template must be ordered as a whole unit. This flag prevents partial order fulfillment or fractional quantities.
DefaultSalesOrderSourceTypeValue String Specifies the default source type for sales orders associated with this item template (for example, 'direct sale', 'subscription', or 'bundled offering'.
ElectronicFormatFlag Bool Indicates whether this item template is available in electronic format. This flag is commonly used for digital products, software, or downloadable content.
ShippableFlag Bool 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 Defines the default shipping organization responsible for fulfilling orders containing this item template, optimizing supply chain operations.
ShipModelCompleteFlag Bool Determines whether this item template must be shipped as a complete model, preventing partial shipments of its components.
DownloadableFlag Bool Indicates whether this item template represents a downloadable product (for example, digital media, software, or electronic documents).
OverShipmentTolerance Decimal Defines the allowable percentage or quantity variance for over-shipment beyond the ordered amount of this item template.
UnderShipmentTolerance Decimal Specifies the allowable percentage or quantity variance for under-shipment when fulfilling orders for this item template.
OverReturnTolerance Decimal Defines the maximum allowable percentage or quantity variance for over-returns beyond the originally purchased quantity of this item template.
UnderReturnTolerance Decimal Specifies the minimum allowable percentage or quantity variance for under-returns. This specification ensures compliance with return policies.
InvoiceEnabledFlag Bool 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 Defines the accounting rule applied to this item template. This rule determines how revenue and expenses are recognized in financial reporting.
PaymentTermsValue String Specifies the payment terms applicable to this item template, such as 'Net 30', 'Due on Receipt', or nstallment-based agreements).
OutputTaxClassificationCodeValue String Defines the tax classification code for sales transactions involving this item template. This code ensures compliance with tax regulations.
InvoicedFlag Bool Indicates whether this item template has already been invoiced. This flag tracks its financial status in sales transactions.
InvoicingRuleValue String Specifies the invoicing rule used for this item template. This rule determines how and when invoices are generated for sales transactions.
SalesAccountValue String Defines the sales account associated with this item template. This account ensures proper financial tracking and revenue allocation.
WebStatusValue String Indicates the web status of this item template (for example, 'available', 'discontinued', or 'hidden') for online storefront visibility.
BackOrderableFlag Bool Specifies whether this item template can be placed on backorder. This flag allows orders to be accepted even when stock is unavailable.
OrderableOnWebFlag Bool Determines whether this item template can be ordered online. This flage enables e-commerce sales and digital storefront integration.
MinimumLicenseQuantity Decimal Defines the minimum quantity required for licensing this item template. Typically, this value is used for software, subscriptions, or enterprise agreements.
InventoryPlanningMethodValue String Specifies the inventory planning method used for this item template, such as 'Min-Max Planning', 'Reorder Point', or 'Forecast-Based Planning'.
PlanningMakeBuyValue String Indicates whether this item template is planned for in-house manufacturing (Make) or procurement from suppliers (Buy). This value affects sourcing decisions.
Planner String Defines the designated planner responsible for managing replenishment, forecasting, and inventory control for this item template.
SubcontractingComponentValue String Indicates whether this item template is used as a subcontracted component, where external vendors perform partial or full assembly.
MinimumMinmaxQuantity Decimal Specifies the minimum inventory level for Min-Max planning. This value ensures stock does not fall below the defined threshold.
MaximumMinmaxQuantity Decimal Defines the maximum inventory level for Min-Max planning. This value prevents excessive stock accumulation.
MinimumOrderQuantity Decimal Specifies the smallest allowable order quantity when procuring or manufacturing this item template. This value ensuring efficient purchasing and production.
MaximumOrderQuantity Decimal Defines the largest allowable order quantity for procurement or production. This value prevents overordering and excessive inventory costs.
OrderCost Decimal 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 Specifies the source organization responsible for supplying this item template in an internal transfer or supply chain network.
SourceSubinventoryOrganizationValue String Defines the organization associated with the source subinventory for this item template. This value ensures accurate material sourcing.
SourceSubinventoryValue String Specifies the subinventory from which this item template is sourced. This information is used in inventory transfers and replenishment processes.
FixedOrderQuantity Decimal Defines the fixed quantity for replenishment orders of this item template. This value ensures consistent order sizes in planning and procurement.
FixedDaysSupply Decimal 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 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 Indicates whether release authorization is required before processing supply orders for this item template. This informaton ensures controlled procurement or production.
AutomaticallyExpireASNFlag Bool Specifies whether Advanced Shipment Notices (ASNs) for this item template expire automatically if not received within a predefined timeframe.
ConsignedFlag Bool Indicates whether this item template is managed under a consignment arrangement, where inventory remains supplier-owned until used or sold.
ReplenishmentMinimumOrder Decimal Defines the minimum quantity required when generating replenishment orders for this item template. This value prevents inefficient small orders.
ReplenishmentMaximumOrder Decimal Specifies the maximum allowable replenishment order quantity. This value controls excessive stock accumulation.
VMIFixedOrderQuantity Decimal Defines the fixed-order quantity for Vendor-Managed Inventory (VMI) scenarios. This value ensures consistent replenishment practices.
ForecastTypelValue String Specifies the type of forecast applied to this item template, such as 'Demand Forecast', 'Supply Forecast', or 'Consumption-Based Forecasting'.
ForecastHorizon Decimal Defines the forecast horizon for this item template. This information indicates how far into the future demand is projected for planning purposes.
PlanningMethodValue String Indicates the planning method assigned to this item template. This method determines whether it follows manual, automated, or system-driven planning rules.
RoundingControlTypeFlag Bool Determines whether rounding controls are applied to order quantities for this item template. These controls ensure compliance with unit increments.
CreateSupplyFlag Bool Indicates whether supply is automatically created for this item template. This information ensures continuous availability in planning workflows.
PlanningTimeFence String Defines the planning time fence for this item template. This information restricts automatic changes to supply plans within a certain time frame.
DemandTimeFence String Specifies the demand time fence. This information prevents last-minute demand changes from affecting planned supply decisions.
ReleaseTimeFence String Defines the release time fence. This information ensures supply orders for this item template are released only within a predefined planning window.
ShrinkageRate Decimal Represents the expected shrinkage rate for this item template. This value accounts for losses due to damage, spoilage, or process inefficiencies.
ForecastControlValue String Specifies the forecast control method used for this item template. This method determines whether forecast data influences planning decisions.
AcceptableEarlyDays Decimal Defines the acceptable number of days an order for this item template can be received early without impacting planning calculations.
PlanningTimeDays Decimal Indicates the number of days used in planning calculations for this item template. This value determines lead time and scheduling accuracy.
DemandTimeDays Decimal Defines the number of days within which demand for this item template is considered stable. This value prevents late changes to orders.
ReleaseTimeDays Decimal Specifies the number of days within which supply releases are controlled for this item template. This value ensures proper execution timing.
MRPCalculateATPFlag Bool Indicates whether ATP is calculated for this item template in Material Requirements Planning (MRP).
RepairLeadtime Decimal Defines the lead time required to repair or refurbish this item template. This information ensures accurate scheduling for service operations.
RepairYield Decimal Specifies the expected yield percentage after repairs. This metric determines how much of the repaired quantity remains usable.
PreprocessingDays Decimal Represents the number of days required for preprocessing activities, such as inspection or preparation, before manufacturing or fulfillment.
PostprocessingDays Decimal Defines the number of days needed for postprocessing activities after production or fulfillment, including packaging and quality checks.
ProcessingDays Decimal Indicates the total number of days required to process this item template through manufacturing or order fulfillment cycles.
VariableLeadTime Decimal Represents the variable lead-time component for this item template. This component accounts for fluctuations in production or procurement duration.
CumulativeTotalLeadTime Decimal Defines the total lead time for this item template. This lead time includes all processing, transportation, and waiting periods.
FixedLeadTime Decimal Specifies the fixed lead time required for this item template. This lead time represents standard processing duration regardless of order quantity.
CumulativeManufacturingLeadTime Decimal Defines the total lead time for manufacturing this item template, including all production steps and dependencies.
LeadTimeLotSize Decimal 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 Indicates whether this item template is available for purchasing. This flag allows it to be procured through the purchasing system.
UseApprovedSupplierFlag Bool Specifies whether this item template must be purchased only from approved suppliers. This flag ensures compliance with sourcing policies.
NegotiationRequiredFlag Bool Indicates whether supplier negotiations are required before purchasing this item template. Typically, this informaton is used for high-value or strategic purchases.
PurchasingInputTaxClassificationValue String Defines the tax classification applied to incoming purchases of this item template. This classification ensures proper tax calculation and reporting.
InvoiceCloseTolerancePercentage Decimal Specifies the allowable variance percentage between the invoiced amount and the expected amount before an invoice can be closed.
HazardClassValue String Indicates the hazard classification for this item template. This classification ensures proper handling, storage, and transportation compliance with safety regulations.
AssetCategoryValue String Defines the asset category associated with this item template. This categorization is used for financial tracking, depreciation, and asset management.
PurchasableFlag Bool Specifies whether this item template is eligible for procurement transactions. This flag allows it to be purchased from suppliers.
TaxableFlag Bool Indicates whether this item template is subject to sales or use tax in purchasing transactions. This flag ensures tax compliance in procurement.
BuyerOrganizationValue String Specifies the buyer organization responsible for managing procurement transactions involving this item template.
DefaultBuyerValue String Defines the default buyer assigned to this item template. This information ensures consistent purchasing responsibility within the organization.
ReceiptCloseTolerancePercentage Decimal Specifies the allowable variance percentage for received quantities before the receipt transaction can be closed.
UNNumberValue String Defines the United Nations (UN) number for hazardous materials associated with this item template. This number is used for global transportation compliance.
ListPrice Decimal Specifies the standard list price of this item template. This value is used as a reference price in procurement and sales transactions.
PriceTolerancePercentage Decimal Defines the maximum allowable percentage variance in price before requiring approval or triggering alerts in purchasing transactions.
MarketPrice Decimal Represents the current market price of this item template. This value is used for comparison in procurement and cost analysis.
RoundingFactor Decimal Defines the rounding factor applied to pricing, order quantities, or transaction values for this item template, ensuring consistent calculations.
MatchApprovalLevelValue String Specifies the level of approval required for matching purchase orders, invoices, and receipts for this item template.
MatchConfigurationOptionValue String Defines the matching configuration rule for this item template. This rule determines how invoice and receipt matching processes are executed.
ReceiptDateActionValue String 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 Defines the number of days before the scheduled receipt date that this item template can be received without triggering exceptions.
DaysLateReceiptAllowed Decimal Specifies the number of days after the scheduled receipt date that this item template can be received before impacting compliance or planning.
AllowSubstituteReceiptsFlag Bool 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 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 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 Specifies the acceptable percentage variance for received quantities before triggering exceptions or requiring manual intervention.
ItemExtensibleFlexfieldCategoryCode String Defines the category code associated with this item template’s extensible flexfields (EFFs). This code allows for additional attribute customization.
CreationDate Datetime 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 Indicates the most recent date when this item template was updated,. This date ensures visibility into changes and modifications.
BackToBackEnabledFlag Bool Indicates whether this item template supports back-to-back ordering, where sales orders trigger automatic purchase or manufacturing orders.
ContractManufacturingFlag Bool Specifies whether this item template is eligible for contract manufacturing, where production is outsourced to external suppliers.
DaysOfCover Decimal Defines the number of days of supply coverage required for this item template. This value ensures adequate stock availability in planning models.
DemandPeriod Decimal Specifies the length of time used for demand aggregation in planning calculations for this item template. This value influences forecasting and replenishment.
SafetyStockPlanningMethodValue String 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 Indicates whether this item template is used for outside processing services, where production steps are outsourced to external suppliers.
AllowMaintenanceAssetFlag Bool 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 Indicates whether genealogy tracking is enabled for this item template. This flag allows traceability of components and materials throughout production and usage.
EngineeredItemFlag Bool Specifies whether this item template represents an engineered item, which is typically subject to design control and revision management.
ProcurementBusinessUnitName String Defines the business unit responsible for procurement activities related to this item template. This value ensures proper financial and purchasing assignment.
ForcePurchaseLeadTimeFlag Bool 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 Specifies the type of replacement strategy applicable to this item template (for example, 'alternate item', 'substitute item', or 'standard replacement'.
BuyerEmailAddress String Defines the email address of the designated buyer responsible for purchasing this item template. This information enables procurement communication and approvals.
AssetTrackedValue String Indicates whether this item template is tracked as an asset. This information determines whether depreciation and lifecycle management apply.
RequestId Long The unique identifier for the request associated with this item template,. This identifier is used for tracking system-generated changes and approvals.
CreatedBy String Specifies the user who created this item template. This information ensures accountability and traceability in system records.
CreationDateTime Datetime 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 Represents the most recent date and time when this item template was updated. This information ensures visibility into modifications.
LastUpdateLogin String Defines the system login identifier used when the last update was performed on this item template. This identifier provides an audit trail.
LastUpdatedBy String Indicates the user who last updated this item template. This information ensures traceability of modifications.
InternallyTransferableFlag Bool Specifies whether this item template is eligible for internal transfers between organizations or locations.
TransferOrdersEnabledFlag Bool Indicates whether transfer orders (TOs) are enabled for this item template. This flag allows movement between inventory locations through formal transfer documents.
ReplenishmentMaximumDaysOfSupply Decimal Defines the maximum number of days of supply allowed for replenishment planning. This information prevents excessive inventory accumulation.
CustomerSelfServiceEnabledFlag Bool Specifies whether this item template is available for customer self-service transactions, such as direct ordering through a web portal.
AllowPurchasingDocumentDescriptionUpdateFlag Bool Indicates whether users can modify the item description on purchasing documents. This information allows flexibility in procurement transactions.
EnableContractCoverage Bool Determines whether contract coverage is enabled for this item template. This information ensures service or warranty agreements apply.
CarryingCostPercentage Decimal Specifies the percentage cost associated with holding inventory for this item template. This cost is used in cost analysis and financial planning.
ReplenishmentMinimumDaysOfSupply Decimal Defines the minimum number of days of supply required for replenishment planning. This value ensures stock availability without excess.
AllowExpressTransactionsFlag Bool Indicates whether express transactions, such as fast-track receiving or expedited processing, are allowed for this item template.
ReceiptRoutingValue String Specifies the default receipt routing method for this item template, such as 'Standard Receipt', 'Inspection Required', or 'Direct Delivery'.
InvoiceMatchOptionValue String Defines the invoice matching rule applicable to this item template, determining how purchase orders, receipts, and invoices are reconciled.
CommsActivationRequiredFlag Bool Indicates whether communications activation is required for this item template. This flag is commonly used for networked or subscription-based products.
RequiresFulfillmentLocationFlag Bool Specifies whether a fulfillment location must be assigned when processing orders for this item template. This flag ensures accurate delivery routing.
IssueUOMValue String Defines the UOM used when issuing this item template from inventory. This UOM ensures accurate transaction quantities.
EnforceShipToLocationValue String Specifies whether shipping transactions must adhere to predefined ship-to locations for this item template. This information ensures compliance with fulfillment policies.
StandardCoverageValue String Defines the standard coverage applicable to this item template, such as service warranties or contractual guarantees.
ReplenishmentSourceTypeValue String Specifies the source type for replenishing this item template, such as 'supplier procurement', 'internal transfer', or 'contract manufacturing'.
TrackingUOMValue String Defines the UOM used for tracking this item template. This UOM ensures proper inventory control at a granular level.
SecondaryUOMValue String Specifies the secondary UOM for this item template. This UOM is used in dual UOM tracks scenarios where conversion is required.
PricingUOMValue String Defines the UOM used for pricing transactions related to this item template. This UOM ensures consistency in financial calculations.
HardPeggingLevelValue String Indicates the level of hard pegging required for this item template. This value ensures that demand is linked to specific supply sources.
CommonSupplyProjectDemandFlag Bool Specifies whether this item template supports common supply across multiple projects, consolidating inventory demand.
EnableIotFlag Bool 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 Defines the expenditure type assigned to this item template. This type determines how costs are categorized in financial tracking.
PackagingStringValue String Specifies the packaging description for this item template. This description details how it is packed for storage or shipping.
CreateSupplyAfterDate Date Indicates the date after which supply creation is allowed for this item template. This date ensures demand-driven production or procurement.
CreateFixedAssetValue String Determines whether this item template is designated as a fixed asset upon acquisition. This information ensures proper financial classification.
UnderCompletionToleranceTypeValue String Specifies the tolerance type allowed for under-completion of manufacturing orders for this item template.
UnderCompletionToleranceValue Decimal Defines the acceptable under-completion percentage or quantity for manufacturing or assembly processes of this item template.
DefaultRepairTransactionName String Defines the default repair transaction type for this item template. This information ensures consistent processing of maintenance or refurbishment activities.
TemplateName String Specifies the name of the item template. This name is used for categorization and reference in system configurations.
Finder String Defines the search criteria or query used for locating this item template within the system. This criteria or query facilitates quick access.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175