Inventory Detail

Internal ID: inventorydetail

Subrecord

Fields

Internal ID	Type	nlapiSubmitField	Label	Required	Help
customform	select	false	Custom Form	false	Select the form you want to use to enter this record. You can select the standard form, a custom form you have already created, or select New to create a custom form.
externalid	text	false	ExternalId	false
item	select	false	Item	false	Enter or select one or more items to determine which items the attributes are copied to. Click the Select Multiple icon to open the Choose Item window and select more than one item. Note: If the source item is a different item type than the target item, data in extraneous fields is copied over but does not affect calculations. For example, if the source item processed is a time-phased planning item but the target item is not a time-phased planning item, fields relevant to time-phased planning will be populated on the target item but the data is not used for calculations.
itemdescription	text	false	Description	false	A more complete Description of the item.
location	select	false	Location	false	Select a location to associate with this item. To use a location, the Multi-Location Inventory feature must be enabled. * If the Multi-Location Inventory feature is not enabled: Selecting an item record location limits the items that certain roles can access. For example, Role A is set up to access only items associated with Location One. Therefore, employees who have Role A can access only items associated with Location One. Note: If the Multi-Location Inventory feature is not enabled, you cannot use this field to track inventory by locations. For example, you cannot track how many widgets you have in stock in Location One. For more information click here. * If the Multi-Location Inventory feature is enabled: Selecting an item record location classifies the item by that location to limit the items that certain roles can access. To track inventory per location, use the Locations subtab at the bottom of this form. For more information click here. Select New to enter a new location record. Go to Setup > Company > Locations for details about existing location records.
quantity	float	false	Quantity	false	In the Quantity to Build field, enter the number of assembly items you want to build. You cannot enter a quantity that exceeds the amount displayed in the Buildable Quantity field.
tolocation	text	false	Location	false
unit	select	false	Units	false	If the assembly uses Units of Measure, the base units are displayed in the Units field.

Sublists

inventoryassignment - Inventory Detail

Internal ID	Type	Label	Required	Help
binnumber	select	Bin	true
expirationdate	date	Expiration Date	false
internalid	integer		false
inventorydetail	integer		false
inventorystatus	select	Status	true
issueinventorynumber	select	Serial/Lot Number	true
lotquantityavailable	float	Lot Qty Available Across Bins	false
packcarton	text	Pack Carton	false
pickcarton	text	Pick Carton	false
quantity	float	Quantity	true
quantityavailable	posfloat	Available	false
quantitystaged	posfloat	Quantity Staged	false
tobinnumber	select	Bin	true
toinventorystatus	select	Status	true

Search Joins

Join ID	Join Description	Actual Join Name
inventorynumber	Inventory Number	Inventory Numbers

Search Filters

Internal ID	Type	Label
binnumber	select	Bin Number
expirationdate	date	Expiration Date
externalid	select	External ID
externalidstring	text	External ID (Text)
formuladate	date	Formula (Date)
formulanumeric	float	Formula (Numeric)
formulatext	text	Formula (Text)
internalid	select	Internal ID
internalidnumber	integer	Internal ID (Number)
inventorynumber	select	Number
packcarton	text	Pack Carton
pickcarton	text	Pick Carton
quantity	float	Quantity
quantitystaged	float	Staged Quantity
status	select	Status

Search Columns

Internal ID	Type	Label
binnumber	select	Bin Number
expirationdate	date	Expiration Date
externalid	select	External ID
formulacurrency	currency	Formula (Currency)
formuladate	date	Formula (Date)
formuladatetime	datetime	Formula (Date/Time)
formulanumeric	float	Formula (Numeric)
formulapercent	percent	Formula (Percent)
formulatext	text	Formula (Text)
internalid	select	Internal ID
inventorynumber	select	Number
packcarton	text	Pack Carton
pickcarton	text	Pick Carton
quantity	float	Quantity
status	select	Status