aggregateItemLocation
The AggregateItemLocation table consolidates item availability data across multiple locations to support inventory planning and fulfillment processes.
Columns
| Name | Type | References | Description |
| atpleadtime | Integer | The available-to-promise (ATP) lead time for the item at the specified location. This field determines the estimated number of days required to fulfill an order based on current and expected inventory availability. | |
| averagecostmli | Decimal | The average cost per unit of the item at the specified location. This value is calculated based on historical purchase costs, production costs, and inventory valuation methods. | |
| backwardconsumptiondays | Integer | The number of days before a forecasted demand date that inventory consumption can be applied. This setting ensures proper demand allocation by considering past inventory usage patterns. | |
| cost | Decimal | The standard cost assigned to the item at this location. This value is used for inventory valuation, cost accounting, and financial reporting. | |
| costaccountingstatus | String | The current cost accounting status of the item at this location. This status helps track whether the cost is under review, approved, or pending updates. | |
| costinglotsize | Double | The lot size used for cost calculations in this location. This lot size determines the economic order quantity (EOQ) for cost accounting and inventory planning. | |
| currentstandardcost | Decimal | The most recently defined standard cost for the item at this location. This cost is used for financial reporting and inventory valuation. | |
| currentstandardcosteffectivedate | Date | The date on which the current standard cost became effective. This date ensures accurate cost tracking and historical cost analysis. | |
| defaultreturncost | Decimal | The default cost applied when returning an item to inventory. This cost value helps determine the financial impact of returns and restocking decisions. | |
| demandsource | String | The origin of demand for the item at this location. This field helps differentiate between customer orders, internal stock transfers, and manufacturing requirements. | |
| demandtimefence | Integer | The number of days within which demand changes are restricted. This setting ensures that short-term planning remains stable and minimizes disruptions in supply chain management. | |
| fixedlotsize | Double | The fixed lot size used when ordering or manufacturing the item at this location. This lot size ensures consistent replenishment quantities and improves procurement efficiency. | |
| forwardconsumptiondays | Integer | The number of days after a forecasted demand date that inventory consumption can be applied. This setting allows for future demand smoothing and planning flexibility. | |
| inventorycosttemplate | String | The cost template applied to the item at this location. This template defines cost allocation methods and is critical for financial reporting and inventory valuation. | |
| invtclassification | String | The inventory classification assigned to the item at this location. This field helps categorize items based on turnover rates, demand patterns, or ABC analysis. | |
| invtcountinterval | Integer | The number of days between inventory counts for the item at this location. This field supports cycle counting and stock accuracy initiatives. | |
| item | String | The unique identifier (Id) of the item for which this location-specific record applies. This Id links inventory records to specific SKUs or product identifiers. | |
| lastinvtcountdate | Date | The date on which the item was last physically counted at this location. This date helps track cycle count accuracy and audit compliance. | |
| lastpurchasepricemli | Decimal | The most recent purchase price of the item at this location. This value provides visibility into supplier pricing trends and cost fluctuations. | |
| location | String | The specific inventory location where the item is stored. This location ensures accurate stock tracking and replenishment planning across multiple warehouses or distribution centers. | |
| nextinvtcountdate | Date | The next scheduled date for inventory counting of this item at the location. This field supports inventory accuracy initiatives and compliance with stock audits. | |
| periodiclotsizedays | Integer | The number of days used to calculate the periodic lot size for replenishment. This value determines the frequency of supply orders based on expected demand. | |
| periodiclotsizetype | String | The type of periodic lot size calculation used for the item at this location. This setting affects how supply chain planners determine order quantities. | |
| preferredstocklevel | Double | The optimal inventory level that should be maintained for the item at this location. This value is used to minimize stockouts while controlling holding costs. | |
| qtyintransitexternal | Double | The quantity of the item currently in transit from external suppliers. This field provides visibility into incoming shipments that have not yet been received. | |
| quantityavailable | Double | The total quantity of the item available for sale or use at this location. This value excludes quantities that are committed to existing orders. | |
| quantitybackordered | Double | The total quantity of the item that has been ordered but is currently out of stock at this location. This field provides insights into fulfillment delays and inventory shortages. | |
| quantitycommitted | Double | The total quantity of the item that has been allocated to sales or production orders at this location. This value ensures that reserved stock is not used for other transactions. | |
| quantityintransit | Double | The total quantity of the item currently being transferred between locations. This value helps track inventory movement within a multi-location supply chain. | |
| quantityonhand | Double | The total physical quantity of the item currently stored at this location. This value is used for stock verification, financial reporting, and inventory reconciliation. | |
| quantityonorder | Double | The total quantity of the item that has been ordered but not yet received at this location. This value provides insight into expected inventory replenishments. | |
| reorderpoint | Double | The minimum inventory level at which a reorder is triggered for the item at this location. This value ensures that stock is replenished before depletion occurs. | |
| rescheduleindays | Integer | The number of days an inbound supply order can be moved forward to meet demand. This setting helps optimize inventory flow by adjusting delivery schedules. | |
| rescheduleoutdays | Integer | The number of days an inbound supply order can be pushed back due to changes in demand. This setting ensures efficient order management and prevents overstocking. | |
| supplylotsizingmethod | String | The lot sizing method used for supply planning at this location. This method determines how order quantities are calculated based on demand patterns and inventory policies. | |
| supplytimefence | Integer | The number of days within which supply changes are restricted. This setting stabilizes short-term production and procurement planning. | |
| supplytype | String | The type of supply source that is used for replenishing the item at this location. This field differentiates between purchased items, manufactured goods, and internal stock transfers. |