InventoryItemLocations

Namespace: urn:accounting.lists.webservices.netsuite.com

Fields

NameTypeCardinalityLabelRequiredHelp
alternateDemandSourceItem RecordRef 0..1 Alternate Source Item F
averageCostMli double 0..1
backwardConsumptionDays long 0..1 Backward Consumption Days F
buildTime double 0..1
buildTimeLotSize double 0..1
cost double 0..1 Purchase Price F
costingLotSize double 0..1
defaultReturnCost double 0..1 Default Return Cost F
demandSource RecordRef 0..1 Demand Source F
demandTimeFence long 0..1 Demand Time Fence F
fixedBuildTime double 0..1
fixedLotSize double 0..1 Fixed Lot Size F
forwardConsumptionDays long 0..1 Forward Consumption Days F
inventoryCostTemplate RecordRef 0..1
invtClassification ItemInvtClassification 0..1 Classification F
invtCountInterval long 0..1 Count Interval F
isWip boolean 0..1
lastInvtCountDate dateTime 0..1 Last Count Date F
lastPurchasePriceMli double 0..1
leadTime long 0..1 Purchase Lead Time F
location string 0..1 Location F Choose a location to associate with this item. Note: If you have not enabled the Multi-Location Inventory feature, the location you select is used for role restriction purposes only. Select New to enter a new location record. Go to Lists > Locations for details about existing location records.
locationAllowStorePickup boolean 0..1
locationId RecordRef 0..1
locationQtyAvailForStorePickup double 0..1
locationStorePickupBufferStock double 0..1
nextInvtCountDate dateTime 0..1 Next Count Date F
onHandValueMli double 0..1
periodicLotSizeDays long 0..1 Periods of Supply Increment F
periodicLotSizeType PeriodicLotSizeType 0..1 Periods of Supply Type F
preferredStockLevel double 0..1 Preferred Stock Level F The preferred stock level is the optimum quantity to maintain in stock of an item. The quantity you enter here is used to determine your replenishment needs on the Order Items page. It is the quantity you want to have in stock after an order is placed. * Auto-Calculating – Check the Auto-Calculate box if you want NetSuite to calculate the preferred stock level based on demand for the item. The preferred stock level is calculated as: (daily demand * number of days supply preferred). If no preferred stock level is identified, then the default preferred stock level is used from the Set Up Inventory Management page. * Manually Calculating – Clear the Auto-Calculate box to manually enter the preferred stock quantity. The preferred stock level you set is used to calculate the quantity of items to be ordered on the Order Items page.
quantityAvailable double 0..1 Quantity Available F
quantityBackOrdered double 0..1 Quantity Back Ordered F
quantityCommitted double 0..1 Quantity Committed F
quantityOnHand double 0..1 Quantity On Hand F
quantityOnOrder double 0..1 Quantity On Order F
reorderPoint double 0..1 Reorder Point F Enter the point at which to reorder or build more of this item. The Reorder Point is the quantity level at which you need to reorder or build more of this item. * Auto-Calculating – Check the Auto-Calculate box if you want NetSuite to calculate the reorder point based on demand for the item over time. The reorder point depends on the safety stock definition and is calculated as follows: o Without safety stock defined: Reorder point = (average lead time days * demand) o With safety stock defined in days: Reorder point = [(average lead time days + safety stock days) * demand] o With safety stock quantity defined: Reorder point = [(average lead time days * demand) + safety stock quantity) * Manually Calculating – Clear the Auto-Calculate box if you want to manually enter the point at which to reorder or build more of this item. Go to Home > Set Preferences and place a check mark in the
rescheduleInDays long 0..1 Reschedule In Days F
rescheduleOutDays long 0..1 Reschedule Out Days F
safetyStockLevel double 0..1 Safety Stock Level F
supplyLotSizingMethod RecordRef 0..1 Lot Sizing Method F
supplyReplenishmentMethod RecordRef 0..1 Replenishment Method F
supplyTimeFence long 0..1 Planning Time Fence F
supplyType RecordRef 0..1 Supply Type F