Inventory Detail

Internal ID: inventorydetail

Subrecord

Fields

Internal ID	Type	nlapiSubmitField	Label	Required	Help
customform	select	false	Custom Form	false
externalid	text	false	ExternalId	false
item	select	false	Item	false
itemdescription	text	false	Description	false
location	select	false	Location	false
quantity	float	false	Quantity	false
tolocation	text	false	Location	false
unit	select	false	Units	false

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
quantity	float	Quantity	true
quantityavailable	posfloat	Available	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
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
quantity	float	Quantity

Search Columns

Internal ID	Type	Label
binnumber	select	Bin Number
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
quantity	float	Quantity