itemlocationconfiguration
Holds configuration settings related to how items are managed across different locations within an organization.
Columns
| Name | Type | References | Description |
| advancewarningthreshold | Integer | Specifies the threshold value for advance warning notifications related to inventory levels or order processing. | |
| atpleadtime | Integer | Represents the lead time used in Available to Promise (ATP) calculations, determining how long it takes an item to be available for fulfillment. | |
| backwardconsumptiondays | Integer | Defines the number of days before the current date within which demand consumption is backtracked for planning purposes. | |
| buildtime | Double | Indicates the time required to assemble or manufacture an item, measured in days or another relevant unit. | |
| cost | Decimal | Represents the monetary value associated with producing, purchasing, or holding an item in inventory. | |
| costinglotsize | Double | Determines the standard lot size used in cost calculations for inventory valuation and financial reporting. | |
| customform | String | Identifies the custom form associated with the item-location configuration, which can influence UI display and data entry options. | |
| defaultreturncost | Decimal | Specifies the default cost applied when an item is returned, often used in Return Merchandise Authorization (RMA) processes. | |
| demandsource | String | Indicates the origin of demand for the item at this location, such as sales orders, work orders, or transfer orders. | |
| demandtimefence | Integer | Sets the time fence for considering demand signals, preventing short-term fluctuations from disrupting planning. | |
| externalid | String | Stores an external identifier that can be used for integrations or cross-referencing with other systems. | |
| fixedlotsize | String | Defines a fixed quantity for lot-sizing purposes, ensuring consistent order or production batch sizes. | |
| forwardconsumptiondays | Integer | Specifies the number of days ahead of the current date within which demand consumption is forecasted for planning purposes. | |
| id | Integer | A unique identifier for the item-location configuration record, ensuring each entry is uniquely distinguishable from others. | |
| inventorycosttemplate | String | References the cost template used for inventory valuation, impacting how costs are applied to this item at the given location. | |
| invtclassification | String | Categorizes the inventory based on predefined classifications, such as high-turnover or slow-moving items. | |
| invtcountinterval | String | Defines the frequency at which inventory counts should be conducted for this item at the specified location. | |
| isautolocassignmentallowed | Boolean | Indicates whether automatic location assignment is permitted when fulfilling orders or receiving inventory. | |
| isautolocassignmentsuspended | Boolean | Specifies whether automatic location assignment is temporarily suspended, preventing system-driven location selection. | |
| iswip | Boolean | Denotes whether the item is considered Work In Progress (WIP), meaning it is in the process of being manufactured but not yet completed. | |
| item | String | Specifies the item associated with this configuration, linking to the item master record. | |
| latedemandthreshold | Double | Defines the acceptable threshold for late demand fulfillment before triggering alerts or rescheduling actions. | |
| leadtime | Integer | Indicates the time required to replenish inventory, from order placement to item availability at the specified location. | |
| location | String | Represents the physical or logical location where this configuration applies, such as a warehouse or store. | |
| locationallowstorepickup | Boolean | Determines whether this location allows customers to pick up items in-store as part of the fulfillment process. | |
| locationstorepickupbufferstock | Integer | Specifies the buffer stock level maintained at the location to support store pickup orders and prevent stockouts. | |
| memo | String | A free-text field for notes or additional details about the item-location configuration. | |
| minimumrescheduledays | Integer | Defines the minimum number of days before a scheduled order can be rescheduled, preventing frequent last-minute changes. | |
| name | String | The name or label associated with this item-location configuration record, used for identification. | |
| nextinvtcountdate | Date | Indicates the next scheduled inventory count date for the item at the specified location. | |
| pastdueforecastdays | Integer | Determines the number of past due days to consider when forecasting demand, ensuring overdue orders are factored in. | |
| periodiclotsizedays | Integer | Defines the interval in days for periodic lot sizing, determining when batch orders should be placed. | |
| periodiclotsizetype | String | Specifies the type of periodic lot sizing strategy applied, such as fixed interval or variable interval ordering. | |
| poreceiptcost | Decimal | Represents the cost assigned to inventory received via purchase orders, impacting cost accounting and valuation. | |
| preferredstocklevel | Double | Specifies the optimal stock level to maintain at the location, helping to avoid shortages and excess inventory. | |
| reorderpoint | Double | Defines the inventory level at which a reorder should be triggered to replenish stock before running out. | |
| rescheduleindays | Integer | Specifies the number of days by which an inbound supply order can be rescheduled earlier based on demand changes. | |
| rescheduleoutdays | Integer | Indicates the number of days an inbound supply order can be postponed to better align with inventory needs. | |
| safetystocklevel | Double | Represents the buffer stock maintained to mitigate demand fluctuations and supply chain disruptions. | |
| savedleadtime | Integer | Stores the previously calculated lead time value for reference in supply chain planning and adjustments. | |
| savedpreferredstocklevel | Double | Holds the last recorded preferred stock level before updates, useful for historical comparison. | |
| savedreorderpoint | Double | Maintains the previous reorder point value before any modifications, aiding in tracking adjustments. | |
| subsidiary | String | Specifies the business subsidiary that owns or manages this item-location configuration. | |
| supplylotsizingmethod | String | Defines the method used to determine lot sizes for supply orders, such as fixed lot size or economic order quantity. | |
| supplytimefence | Integer | Sets the time boundary for supply planning, restricting last-minute changes to incoming supply orders. | |
| supplytype | String | Indicates the type of supply for the item at this location, such as purchased, manufactured, or transferred. | |
| templatestored | Boolean | Specifies whether this configuration is stored as a template for use in future item-location setups. |