inventoryItemLocations
Tracks inventory levels and location-specific attributes, enabling multi-location inventory management and stock visibility.
Columns
| Name | Type | References | Description |
| atpleadtime | Integer | The number of days required before an item becomes available for promise to customers based on available-to-promise (ATP) calculations. | |
| averagecostmli | Decimal | The average cost of an inventory item across all transactions and locations, calculated based on the costing method applied. | |
| backwardconsumptiondays | Integer | The number of days before a demand requirement date within which forecasted demand can be adjusted or consumed by actual orders. | |
| cost | Decimal | The standard unit cost assigned to the inventory item, typically used for cost accounting and valuation purposes. | |
| costaccountingstatus | String | The current status of the item within cost accounting processes, indicating whether cost calculations are pending, completed, or require updates. | |
| costinglotsize | Double | The predefined lot size used to calculate per-unit costs in cost accounting, influencing standard and weighted average costing calculations. | |
| currentstandardcost | Decimal | The most recent standard cost assigned to the item, reflecting its predetermined valuation for cost management and financial reporting. | |
| currentstandardcosteffectivedate | Date | The date when the current standard cost of the item became effective, marking the point at which cost updates were applied. | |
| defaultreturncost | Decimal | The cost value applied when an item is returned to inventory, often based on average cost, last purchase price, or a predefined default. | |
| demandsource | String | The origin of demand for the item, specifying whether it arises from sales orders, production orders, transfer orders, or forecasts. | |
| demandtimefence | Integer | The number of days within which demand is considered firm and not subject to changes due to forecast adjustments. | |
| fixedlotsize | Double | The fixed quantity used when replenishing inventory, ensuring that orders or production runs adhere to a predefined batch size. | |
| forwardconsumptiondays | Integer | The number of days after a demand requirement date within which forecasted demand can be adjusted or consumed by actual orders. | |
| inventorycosttemplate | String | A predefined template that dictates how inventory costs are calculated and applied based on selected costing methods and parameters. | |
| invtclassification | String | The categorization of the inventory item based on predefined criteria, such as A, B, or C classifications for cycle counting or stock priority. | |
| invtcountinterval | Integer | The number of days between scheduled inventory counts, determining how frequently the item should be counted in cycle counting procedures. | |
| item | String | The unique identifier or name of the inventory item, representing a specific SKU or product within the system. | |
| lastinvtcountdate | Date | The most recent date on which a physical inventory count was conducted for this item at the specified location. | |
| lastpurchasepricemli | Decimal | The most recent purchase price paid for the item, recorded from supplier transactions and used for procurement analysis. | |
| location | String | The specific warehouse, store, or inventory location where the item is stored and tracked within the system. | |
| nextinvtcountdate | Date | The next scheduled date for performing an inventory count of this item based on cycle count frequency and classification. | |
| periodiclotsizedays | Integer | The number of days in each periodic lot size increment, determining the batch intervals for ordering or production replenishments. | |
| periodiclotsizetype | String | The method used for periodic lot sizing, specifying whether lots are calculated based on fixed periods, dynamic intervals, or other strategies. | |
| preferredstocklevel | Double | The optimal quantity of an item that should be maintained in inventory to ensure smooth operations without overstocking. | |
| qtyintransitexternal | Double | The total quantity of this item currently in transit from an external supplier or source, not yet received into inventory. | |
| quantityavailable | Double | The total quantity of the item that is currently available for sale or internal use, excluding committed and back-ordered quantities. | |
| quantitybackordered | Double | The total quantity of this item that has been ordered by customers but is not yet fulfilled due to insufficient stock. | |
| quantitycommitted | Double | The total quantity of this item that has been allocated to fulfill open orders but is not yet shipped or consumed. | |
| quantityintransit | Double | The total quantity of the item currently being transferred between internal locations, warehouses, or distribution centers. | |
| quantityonhand | Double | The total physical quantity of the item currently in stock at the specified location, including available and committed inventory. | |
| quantityonorder | Double | The total quantity of this item that has been ordered from suppliers or through internal production but has not yet been received. | |
| reorderpoint | Double | The inventory threshold at which a replenishment order should be triggered to prevent stockouts, based on demand and lead time calculations. | |
| rescheduleindays | Integer | The number of days by which an inbound supply order can be rescheduled earlier to align with changing demand requirements. | |
| rescheduleoutdays | Integer | The number of days by which an inbound supply order can be rescheduled later due to shifts in demand or supply constraints. | |
| supplylotsizingmethod | String | The method used to determine how lot sizes are calculated for supply planning, such as fixed lot sizes or economic order quantity (EOQ). | |
| supplytimefence | Integer | The number of days within which planned supply orders are considered firm and not subject to automatic rescheduling by the system. | |
| supplytype | String | The categorization of supply sources, indicating whether the item is replenished through purchase, production, transfers, or other methods. |