Inventory Part

Internal ID: inventoryitem

Fields

Internal ID	Type	nlapiSubmitField	Label	Required	Help
alternatedemandsourceitem	select	false	Alternate Source Item	false
assetaccount	select	false	Asset Account	false
atpmethod	select	false	Default ATP Method	true
auctionquantity	posinteger	false	Auction Quantity	false
auctiontype	select	false	Auction Type	false
autoleadtime	checkbox	true	Auto-Calculate	false
autopreferredstocklevel	checkbox	true	Auto-Calculate	false
autoreorderpoint	checkbox	true	Auto-Calculate	false
availabletopartners	checkbox	false	Available to Adv. Partners	false
averagecost	currency	false	Average Cost	false
billexchratevarianceacct	select	false	Exchange Rate Variance Account	false
billingschedule	select	false	Billing Schedule	false
billpricevarianceacct	select	false	Price Variance Account	false
billqtyvarianceacct	select	false	Quantity Variance Account	false
buyitnowprice	currency	true	Buy It Now Price	false
class	select	true	Class	false	References a value from a user defined list at Setup > Company > Classifications > Classes. This field is required when the Make Classes Mandatory preference is enabled at Setup > Accounting > Accounting Preferences.
cogsaccount	select	false	COGS Account	false
conditionenabled	text	false		false
conditionhelpurl	text	false		false
copydescription	checkbox	false	Copy from Sales Order	false
cost	currency2	false	Purchase Price	false	Enter the price you pay for this item. If you do not enter a price, purchase orders for this item show the most recent purchase price by default. If you select a preferred vendor for this item, the price is shown in the currency selected on the vendor's record. If no preferred vendor is selected, the price is shown in your base currency.
costcategory	select	false	Cost Category	true
costestimate	currency	false	Item Defined Cost	false
costestimatetype	select	false	Cost Estimate Type	false
costingmethod	select	false	Costing Method	false
costingmethoddisplay	text	false	Costing Method	false
costunits	text	false		false
countryofmanufacture	select	true	Manufacturer Country	false
createddate	datetime	false	Date Created	false
currency	text	false	Currency	false	This is a read-only field. If a preferred vendor has been specified in vendorName, the field returns the currency set on that vendor record. Otherwise, the base currency for the company is returned.
customform	select	false	Custom Form	false
custreturnvarianceaccount	select	false	Customer Return Variance Account	false
deferredrevenueaccount	select	false	Deferred Revenue Account	false
deferrevrec	checkbox	false	Hold Revenue Recognition	false
demandmodifier	percent	true	Expected Demand Change	false
demandtimefence	integer	false	Demand Time Fence	false
department	select	true	Department	false	Set a department to associate with this item. For details on existing department records, in the UI go to Setup > Company > Departments.
displayinebaystore	checkbox	true	eBay Store	false
displayname	text	false	Display Name/Code	false
distributioncategory	select	false	Distribution Category	false
distributionnetwork	select	false	Distribution Network	false
dontshowprice	checkbox	false	Don't Show Price	false
dropshipexpenseaccount	select	false	Dropship Expense Account	false
ebayhandlingtime	select	false	Handling Time	false
ebayintlinsurancefee	currency	false	Insurance Amount	false
ebayintlpackagehandlingfee	currency	false	Package & Handling Fee	false
ebayintlshipinsurance	select	false	Shipping Insurance	false
ebayintlshippingitem1	select	false	Shipping Item 1	false
ebayintlshippingitem2	select	false	Shipping Item 2	false
ebayintlshippingitem3	select	false	Shipping Item 3	false
ebayisintlcalculatedrate	radio	false	Flat Rates	false
ebayisirregularpackage	checkbox	false	Irregular Package	false
ebayitemdescription	textarea	false	Item Description	false
ebayitemlocdisplay	text	false	Item Location	false
ebayitemloczipcode	text	false	Item Location Zip Code	false
ebayitemlots	integer	false	Lot Size	false
ebayitemsubtitle	text	true	Subtitle	false
ebayitemtitle	text	true	Item Title	false
ebayitemweightamt	posfloat	false	Item Weight	false
ebaylayout	select	false	Default Chart Type	false
ebaypackagetype	select	false	Package	false
ebaypagecounter	select	false	Page Counter	false
ebayrelistingoption	select	false	Relisting Option	false
ebaytheme	select	false	Theme	false
ebaythemegroup	select	false	Theme Group	false
endauctionswhenoutofstock	checkbox	true	End Auctions When Item is Out of Stock	false
enforceminqtyinternally	checkbox	false	Enforce Internally	false
excludefromsitemap	checkbox	false	Exclude From Sitemap	false
externalid	text	false	ExternalId	false
featureddescription	textarea	false	Featured Description	false
fraudrisk	select	true	Fraud Risk	false
froogleproductfeed	text	false		false
gainlossaccount	select	false	Gain/Loss Account	false
gallery	checkbox	false	Gallery	false
galleryfeatured	checkbox	false	Featured First	false
gifttypeexpressship	checkbox	false	Express shipping	false
gifttypegiftwrap	checkbox	false	Gift wrap / gift card	false
gifttypeshiptorecipient	checkbox	false	Ship to gift recipient	false
handlingcost	currency	false	Handling Cost	false
handlingcostunits	text	false		false
handlinggroup	text	false	Handling	false
imagesgroup	text	false	Images	false
imageslocation	select	false	Images Location	false
includechildren	checkbox	false	Include Children	false
incomeaccount	select	false	Income Account	false
intercocogsaccount	select	false	Intercompany COGS Account	false
intercoincomeaccount	select	false	Intercompany Income Account	false
internalid	integer	false	Internal ID	false
iscalculatedrate	radio	false	Flat Rates	false
isdonationitem	checkbox	false	Variable Amount	false
isdropshipitem	checkbox	false	Drop Ship Item	false
isgcocompliant	checkbox	true	Allow Google Checkout Purchase	false
isinactive	checkbox	false	Inactive	false
isonline	checkbox	false	Display in Web Store	false
isspecialorderitem	checkbox	false	Special Order Item	false
issueproduct	select	false	Product Name	false
itemcondition	select	false	Item Condition	false
itemhandlingfee	currency	false	Package & Handling Fee	false
itemid	text	false	Item Name/Number	true
iteminsurancefee	currency	false	Insurance Amount	false
itemoptions	select	false	Item Options	false
itemshipinsurance	select	false	Shipping Insurance	false
itemtype	text	false		false
lastmodifieddate	datetime	false	Last Modified	false
lastpurchaseprice	currency	false	Last Purchase Price	false
leadtime	integer	true	Lead Time	false
listimmediate	radio	false	Start listing when submitted	false
listingduration	select	false	Duration	false
listingstartdate	date	false	Start Date	false
listingstarttime	select	false	Start Time	false
location	select	true	Location	false
manufacturer	text	false	Manufacturer	false	Type the name of the company that manufactures this item.
manufactureraddr1	text	true	Manufacturer Address	false
manufacturercity	text	true	Manufacturer City	false
manufacturerstate	text	true	Manufacturer State	false
manufacturertariff	text	true	Manufacturer Tariff	false
manufacturertaxid	text	true	Manufacturer Tax Id	false
manufacturerzip	text	true	Manufacturer Zip	false
matchbilltoreceipt	checkbox	false	Match Bill To Receipt	false
matrixtype	select	false	Matrix Type	false
maxdonationamount	currency2	false	Maximum Variable Amount	false
metataghtml	textarea	false	Meta Tag HTML	false
minimumquantity	posinteger	true	Minimum Quantity	false
minimumquantityunits	text	false		false
mossapplies	checkbox	false	MOSS Applies	false
mpn	text	false	MPN	false	MPN (Manufacturers Part Number) - Set the part number used by the manufacturer to identify this item.
multmanufactureaddr	checkbox	true	Multiple Manufacture Addresses	false
nextagcategory	text	false	NexTag Category	false	Enter the name of the NexTag category this item should be included in. This category is included in the product feeds you can export at Setup > Web Site > Product Feeds. Go to www.nextag.com for more information on the available categories.
nextagproductfeed	text	false		false
nopricemessage	text	false	No Price Message	false
numactivelistings	integer	true	Active Listings	false
numcurrentlylisted	integer	true	Quantity Currently Listed	false
offersupport	checkbox	false	Offer Support	false
outofstockbehavior	select	false	Out Of Stock Behavior	false
outofstockmessage	textarea	false	Out Of Stock Message	false
overallquantitypricingtype	select	false	Calculate Quantity Discounts	false
packageheight	posinteger	false	Height	false
packagelength	posinteger	false	Length	false
packagewidth	posinteger	false	Width	false
pagetitle	textarea	false	Page Title	false
parent	select	false	Subitem of	false	References an existing item record. Only required if the item is a child of another item. In order to retrieve a list of available values for this field, use the GetSelectValue operation.
preferencecriterion	select	true	Preference Criterion	false
preferredlocation	select	false	Preferred Location	false
preferredstockleveldays	float	true	Days	false
pricinggroup	select	false	Pricing Group	false
primarycatdisplayname	text	false		false
primarycategory	integer	true	Primary Category	false
producer	checkbox	false	Producer	false	Set to true if you produce this item for the purposes of the NAFTA Certificate of Origin.
productfeed	select	false	Product Feed	false
purchasedescription	textarea	false	Purchase Description	false
purchaseorderamount	posfloat	false	Vendor Bill - Purchase Order Amount Tolerance	false
purchaseorderquantity	posfloat	false	Vendor Bill - Purchase Order Quantity Tolerance	false
purchaseorderquantitydiff	posfloat	false	Vendor Bill - Purchase Order Quantity Difference	false
purchasepricevarianceacct	select	false	Purchase Price Variance Account	false
purchaseunit	select	false	Purchase Units	false
quantitypricingschedule	select	false	Quantity Pricing Schedule	false
quantityreorderunits	text	false		false
receiptamount	posfloat	false	Vendor Bill - Item Receipt Amount Tolerance	false
receiptquantity	posfloat	false	Vendor Bill - Item Receipt Quantity Tolerance	false
receiptquantitydiff	posfloat	false	Vendor Bill - Item Receipt Quantity Difference	false
refundgivenas	select	false	Refund will be given as	false
relateditemsdescription	textarea	false	Related Items Description	false
reordermultiple	posinteger	false	Reorder Multiple	false
rescheduleindays	integer	false	Reschedule In Days	false
rescheduleoutdays	integer	false	Reschedule Out Days	false
reserveprice	currency	true	Reserve Price	false
returnpolicy	select	false	Return Policy	false
returnpolicydetails	textarea	false	Details	false
returnshippingpaidby	select	false	Return Shipping will be paid by	false
returnswithin	select	false	Item must be returned within	false
revrecschedule	select	false	Revenue Recognition Template	false
safetystocklevel	float	false	Safety Stock Level	false
safetystockleveldays	integer	true	Days	false
safetystocklevelunits	text	false		false
salesdescription	textarea	false	Sales Description	false
saleunit	select	false	Sale Units	false
schedulebcode	select	true	Schedule B Code	false
schedulebnumber	text	true	Schedule B Number	false
schedulebquantity	posinteger	true	Schedule B Quantity	false
searchkeywords	textarea	false	Search Keywords	false
seasonaldemand	checkbox	true	Seasonal Demand	false
secondarycatdisplayname	text	false		false
secondarycategory	integer	false	Secondary Category	false
sellonebay	checkbox	true	Sell on eBay	false
shipasia	checkbox	false	Asia	false
shipaustralia	checkbox	false	Australia	false
shipcanada	checkbox	false	Canada	false
shipeurope	checkbox	false	Europe	false
shipgermany	checkbox	false	Germany	false
shipindividually	checkbox	true	Ships Individually	false
shipjapan	checkbox	false	Japan	false
shipmexico	checkbox	false	Mexico	false
shipnorthsouthamerica	checkbox	false	North and South America	false
shippackage	select	true	Package	false
shippingcost	currency	false	Shipping Cost	false
shippingcostunits	text	false		false
shippingdomesticmethodsgroup	text	false	Shipping Methods	false
shippingdomgroup	text	false	Domestic Shipping Settings	false
shippingintlgroup	text	false	International Shipping Settings	false
shippingintlgroup1	text	false	Shipping Method 1	false
shippingintlgroup2	text	false	Shipping Method 2	false
shippingintlgroup3	text	false	Shipping Method 3	false
shippingitem1	select	false	Shipping Item 1	false
shippingitem2	select	false	Shipping Item 2	false
shippingitem3	select	false	Shipping Item 3	false
shippinglocationsgroup	text	false	Ship-to Locations	false
shippingpackaginggroup	text	false	Packaging	false
shippingrate1	currency	false	Rate	false
shippingrate2	currency	false	Rate	false
shippingrate3	currency	false	Rate	false
shipuk	checkbox	false	United Kingdom	false
shipworldwide	checkbox	false	Worldwide	false
shoppingdotcomcategory	text	false	Shopping.com Category	false	Enter the name of the Shopping.com category that this item should go under. This category is included in the product feeds that you can export from Setup > Web Site > Product Feeds. Go to www.shopping.com for more information on the categories available.
shoppingproductfeed	text	false		false
shopzillacategoryid	integer	false	Shopzilla Category ID	false	Enter the name of the Shopzilla category this item should be included in. This category is included in the product feeds you export at Setup > Web Site > Product Feeds. Go to www.shopzilla.com for more information on the available categories.
shopzillaproductfeed	text	false		false
showasgift	checkbox	false	Show as Gift	false
showdefaultdonationamount	checkbox	false	Show Default Amount	false
sitemappriority	select	false	Sitemap Priority	false
softdescriptor	select	false	Soft Descriptor	false
standardimages	radio	false	Standard	false
startingprice	currency	true	Starting Price	false
stockdescription	text	false	Stock Description	false
stockunit	select	false	Stock Units	false
storecatdisplayname	text	false		false
storecatdisplayname2	text	false		false
storecategory	integer	false	Store Category	false
storecategory2	integer	false	Secondary Store Category	false
storedescription	textarea	false	Web Store Description	false
storedetaileddescription	textarea	false	Detailed Description	false
storedisplayimage	select	false	Item Display Image	false
storedisplayname	text	false	Web Store Display Name	false
storedisplaythumbnail	select	false	Item Display Thumbnail	false
storeitemtemplate	select	false	Item Drilldown Template	false
subsidiary	select	false	Subsidiary	false
supersizeimages	checkbox	false	Supersize Pictures	false
supplyreplenishmentmethod	select	true	Replenishment Method	false
supplytimefence	integer	false	Planning Time Fence	false
taxable	checkbox	false	Taxable	false
taxschedule	select	false	Tax Schedule	true
templatesgroup	text	false	Templates	false
totalvalue	currency	false	Total Value	false
tracklandedcost	checkbox	true	Track Landed Cost	false
transferprice	currency2	false	Transfer Price	false
transferpriceunits	text	false		false
unitstype	select	false	Units Type	false
upccode	text	false	UPC Code	false
urlcomponent	textarea	false	URL Component	false
usebins	checkbox	true	Use Bins	false
usemarginalrates	checkbox	false	Use Marginal Rates	false
vendorname	text	false	Vendor Name/Code	false
vendreturnvarianceaccount	select	false	Vendor Return Variance Account	false
vsoedeferral	select	false	Deferral	false
vsoedelivered	checkbox	false	Default as Delivered	false
vsoepermitdiscount	select	false	Permit Discount	false
vsoeprice	currency2	false	VSOE Price	false
vsoesopgroup	select	false	Allocation Type	false
weight	float	false	Item Weight	false	Set the weight of this item
weightunit	select	false		false
weightunits	text	false		false
willship	radio	false	Will Ship to the US and the following:	false
yahooproductfeed	text	false		false

Sublists

accountingbookdetail - Accounting Books

Internal ID	Type	Label	Required
revrecschedule	select	Revenue Recognition Template	false
sameasprimaryrevrec	checkbox	Same as Primary Book Rev Rec	false

binnumber - Bin Numbers

Internal ID	Type	Label	Required
binnumber	select	Bin Number	true
location	text		false
locationactive	text	Location Active	false
onhand	float	On Hand	false
onhandavail	float	Available	false
preferredbin	checkbox	Preferred (per Location)	false

price1 - US Dollar

Internal ID	Type	Label	Required
currency	text	Currency	false
discount	percent	Default Discount %	false
discountdisplay	percent	Default Discount %	false
pricelevel	text	Price Level	false

price2 - British pound

Internal ID	Type	Label	Required
currency	text	Currency	false
discount	percent	Default Discount %	false
discountdisplay	percent	Default Discount %	false
pricelevel	text	Price Level	false

price3 - Canadian Dollar

Internal ID	Type	Label	Required
currency	text	Currency	false
discount	percent	Default Discount %	false
discountdisplay	percent	Default Discount %	false
pricelevel	text	Price Level	false

price4 - Euro

Internal ID	Type	Label	Required
currency	text	Currency	false
discount	percent	Default Discount %	false
discountdisplay	percent	Default Discount %	false
pricelevel	text	Price Level	false

sitecategory - Web Site Categories

Internal ID	Type	Label	Required
category	select	Site Category	true
categorydescription	text	Description	false
isdefault	checkbox	Preferred Category	false
website	select	Site	true

Tabs

Name	Label
basic	Basic
custom	Custom
history	History
inventory	Inventory
inventorydetail	Inventory Detail
inventorynumbers	Inventory Numbers
matrix	Matrix
pricing	Pricing
relitems	Related Items
specials	Specials
store	Store
translation	Translation
vsoepricing	Rev Rec / Amort
workflow	Workflow

Search Joins

Join ID	Join Description	Actual Join Name
effectiverevision	Effective Revision	Item Revision
inventorydetail	Inventory Detail	Inventory Detail
inventorylocation	Inventory Location	Location
inventorynumber	Inventory Number	Inventory Numbers
obsoleterevision	Obsolete Revision	Item Revision
preferredlocation	Preferred Location	Location
preferredvendor	Preferred Vendor	Vendor
shopper	Shopper	Customer
vendor	Vendor	Vendor

Search Filters

Internal ID	Type	Label
account	select	Account
accountingbook	select	Accounting Book
accountingbookamortization	select	Accounting Book Amortization Schedule
accountingbookrevrecschedule	select	Accounting Book Rev. Rec. Schedule
alternatedemandsourceitem	select	Alternate Source Item
atpleadtime	float	ATP Lead Time
atpmethod	select	Default ATP Method
autoleadtime	checkbox	Auto-Calculate Lead Time
autopreferredstocklevel	checkbox	Auto-Calculate Preferred Stock Level
autoreorderpoint	checkbox	Auto-Calculate Reorder Point
availabletopartners	checkbox	Available to Partners
averagecost	currency	Average Cost
binnumber	text	Bin Number
binonhandavail	float	Bin On Hand Available
binonhandcount	float	Bin On Hand Count
buildentireassembly	checkbox	Build Sub-Assemblies
buildtime	float	Work Order Lead Time
buyitnowprice	currency	eBay Buy It Now Price
caption	text	Store Display Name
category	multiselect	Category
class	select	Class
component	select	Component Item
componentof	select	Component Of
copydescription	checkbox	Copy SO Descr.
correlateditem	select	Correlated Item
correlateditemcorrelation	float	Correlated Item Correlation
correlateditemcount	integer	Correlated Item Count
correlateditemlift	float	Correlated Item Lift
correlateditempurchaserate	float	Correlated Item PurchaseRate
cost	currency	Purchase Price
costaccountingstatus	select	Cost Accounting Status
costcategory	select	Cost Category
costestimate	float	Item Defined Cost
costestimatetype	select	Cost Estimate Type
costingmethod	select	Costing Method
countryofmanufacture	select	Manufacturer Country
created	datetime	Date Created
createjob	checkbox	Create Job
currentstandardcost	currency	Current Standard Cost
currentstdcosteffectivedate	date	Current Standard Cost Effective Date
dateviewed	datetime	Date Viewed
daysbeforeexpiration	float	Days Before Expiration
defaultreturncost	currency	Default Return Cost
deferrevrec	checkbox	Hold Revenue Recognition
demandmodifier	percent	Estimated Demand Change
demandsource	select	Demand Source
department	select	Department
displayinebaystore	checkbox	eBay Store
displayname	text	Display Name
distributioncategory	select	Distribution Category
distributionnetwork	select	Distribution Network
dontshowprice	checkbox	Don't Show Price
ebayitemdescription	clobtext	eBay Description
ebayitemsubtitle	text	eBay Subtitle
ebayitemtitle	text	eBay Title
ebayrelistingoption	select	eBay Relisting Option
effectivebomcontrol	select	Effective BOM Control
effectivedate	date	Effective Date
effectiverevision	select	Effective Revision
endauctionswhenoutofstock	checkbox	eBay End Auctions When Out of Stock
excludefromsitemap	checkbox	Exclude From Sitemap
externalid	select	External ID
externalidstring	text	External ID (Text)
featureddescription	clobtext	Featured Description
feeddescription	clobtext	Feed Description
feedname	text	Feed Name
fixedlotsize	float	Fixed Lot Size
formuladate	date	Formula (Date)
formulanumeric	float	Formula (Numeric)
formulatext	text	Formula (Text)
fraudrisk	select	Fraud Risk
froogleproductfeed	checkbox	Google Base Product Feed
fxcost	currency	Purchase Price (Foreign Currency)
generateaccruals	checkbox	Generate Accruals
giftcertauthcode	text	Gift Certificate Code
giftcertemail	text	Gift Certificate To (Email)
giftcertexpdate	date	Gift Certificate Expiration Date
giftcertfrom	text	Gift Certificate From (Name)
giftcertmsg	text	Gift Certificate Message
giftcertorigamt	text	Gift Certificate Original Amount
giftcertrecipient	text	Gift Certificate To (Name)
imageurl	text	Image URL
internalid	select	Internal ID
internalidnumber	integer	Internal ID (Number)
inventorylocation	select	Inventory Location
invtclassification	select	Inventory Classification
invtcountinterval	integer	Inventory Count Interval
isavailable	checkbox	Is Available?
isdropshipitem	checkbox	Drop Ship Item
isfulfillable	checkbox	Can be Fulfilled
isgcocompliant	checkbox	Google Checkout Compliant
isinactive	checkbox	Inactive
islotitem	checkbox	Is Lot Numbered Item
isonline	checkbox	Display in Web Site
ispreferredvendor	checkbox	Vendor is Preferred
isserialitem	checkbox	Is Serialized Item
isspecialorderitem	checkbox	Special Order Item
isspecialworkorderitem	checkbox	Special Work Order Item
issueproduct	select	Product
istaxable	checkbox	Taxable
isvsoebundle	checkbox	Is VSOE Bundle?
iswip	checkbox	WIP
itemid	text	Name
itemurl	text	Item URL
lastinvtcountdate	date	Last Inventory Count Date
lastmodifieddate	datetime	Last Modified
lastpurchaseprice	currency	Last Purchase Price
lastquantityavailablechange	datetime	Last Quantity Available Change
leadtime	integer	Lead Time
listingduration	select	eBay Duration
location	select	Location
locationatpleadtime	float	Location ATP Lead Time
locationaveragecost	currency	Location Average Cost
locationbuildtime	float	Location Work Order Lead Time
locationcost	currency	Location Standard Cost
locationcostaccountingstatus	select	Location Cost Accounting Status
locationdefaultreturncost	currency	Location Default Return Cost
locationdemandsource	select	Location Demand Source
locationfixedlotsize	float	Location Fixed Lot Size
locationinvtclassification	select	Location Inventory Classification
locationinvtcountinterval	integer	Location Inventory Count Interval
locationlastinvtcountdate	date	Location Last Inventory Count Date
locationleadtime	integer	Location Lead Time
locationnextinvtcountdate	date	Location Next Inventory Count Date
locationpreferredstocklevel	float	Location Preferred Stock Level
locationquantityavailable	float	Location Available
locationquantitybackordered	float	Location Back Ordered
locationquantitycommitted	float	Location Committed
locationquantityintransit	float	Location In Transit
locationquantityonhand	float	Location On Hand
locationquantityonorder	float	Location On Order
locationreorderpoint	float	Location Reorder Point
locationsafetystocklevel	float	Location Safety Stock Level
locationsupplylotsizingmethod	select	Location Supply Lot Sizing Method
locationsupplytype	select	Location Supply Type
locationtotalvalue	currency	Location Total Value
manufacturer	text	Manufacturer
manufactureraddr1	text	Manufacturer Address
manufacturercity	text	Manufacturer City
manufacturerstate	text	Manufacturer State
manufacturertariff	text	Manufacturer Tariff
manufacturertaxid	text	Manufacturer Tax Id
manufacturerzip	text	Manufacturer Zip
matchbilltoreceipt	checkbox	Match Bill To Receipt
matrix	checkbox	Matrix Item
matrixchild	checkbox	Matrix Child Item
metataghtml	clobtext	Meta Tag Html
minimumquantity	integer	Minimum Quantity
mossapplies	checkbox	MOSS Applies
mpn	text	MPN
multmanufactureaddr	checkbox	Multiple Manufacture Addresses
nextagcategory	text	NexTag Category
nextagproductfeed	checkbox	NexTag Product Feed
nextinvtcountdate	date	Next Inventory Count Date
numactivelistings	integer	eBay Active Listings
numberalloweddownloads	float	Number of Allowed Downloads
numcurrentlylisted	integer	eBay Quantity Currently Listed
obsoletedate	date	Obsolete Date
obsoleterevision	select	Obsolete Revision
offersupport	checkbox	Offer Support
onlinecustomerprice	currency	Online Customer Price
onspecial	checkbox	On Special
othervendor	select	Vendor
outofstockbehavior	select	Out Of Stock Behavior
overallquantitypricingtype	select	Overall Qty. Pricing Type
pagetitle	text	Page Title
parent	select	Sub-Item Of
preferencecriterion	text	Preference Criterion
preferredbin	checkbox	Preferred Bin
preferredlocation	select	Preferred Location
preferredstocklevel	float	Preferred Stock Level
preferredstockleveldays	integer	Preferred Stock Level Days
price	currency	Sales Price
pricesincludetax	checkbox	Prices Include Tax
pricinggroup	select	Pricing Group
primarycategory	integer	eBay Category Id
purchaseorderamount	float	Vendor Bill - Purchase Order Amount Tolerance
purchaseorderquantity	float	Vendor Bill - Purchase Order Quantity Tolerance
purchaseorderquantitydiff	float	Vendor Bill - Purchase Order Quantity Difference
purchaseunit	select	Purchase Unit
quantityavailable	float	Available
quantitybackordered	float	Back Ordered
quantitycommitted	float	Committed
quantityonhand	float	On Hand
quantityonorder	float	On Order
quantitypricingschedule	select	Qty. Pricing Schedule
receiptamount	float	Vendor Bill - Item Receipt Amount Tolerance
receiptquantity	float	Vendor Bill - Item Receipt Quantity Tolerance
receiptquantitydiff	float	Vendor Bill - Item Receipt Quantity Difference
reordermultiple	integer	Reorder Multiple
reorderpoint	float	Reorder Point
reserveprice	currency	eBay Reserve Price
revrecschedule	select	Rev. Rec. Schedule
safetystocklevel	float	Safety Stock Level
safetystockleveldays	integer	Safety Stock Level Days
salesdescription	text	Description
saleunit	select	Sale Unit
schedulebcode	select	Schedule B Code
schedulebnumber	text	Schedule B Number
schedulebquantity	text	Schedule B Quantity
searchkeywords	text	Search Keywords
seasonaldemand	checkbox	Seasonal Demand
sellonebay	checkbox	eBay Auction
serialnumber	text	Serial/Lot Number
serialnumberlocation	select	Serial/Lot Number Location
shipindividually	checkbox	Ships Individually
shippackage	select	Shipping Package
shippingrate	currency	Shipping Rate
shoppingdotcomcategory	text	Shopping Category
shoppingproductfeed	checkbox	Shopping Product Feed
shopzillacategoryid	integer	Shopzilla Category Id
shopzillaproductfeed	checkbox	Shopzilla Product Feed
sitemappriority	float	Sitemap Priority
softdescriptor	select	Soft Descriptor
startingprice	currency	eBay Starting Price
stockdescription	text	Stock Description
stockunit	select	Stock Unit
storedescription	clobtext	Store Description
subsidiary	select	Subsidiary
subtype	select	Sub Type
supplylotsizingmethod	select	Supply Lot Sizing Method
supplyreplenishmentmethod	select	Replenishment Method
supplytype	select	Supply Type
taxcode	select	Tax Code
taxschedule	select	Tax Schedule
thumbnailurl	text	Thumbnail URL
totalvalue	currency	Total Value
tracklandedcost	checkbox	Track Landed Cost
transferprice	float	Transfer Price
type	select	Type
unitstype	select	Units Type
upccode	text	UPC Code
urlcomponent	text	URL Component
usebins	checkbox	Use Bins
usemarginalrates	checkbox	Use Marginal Rates
vendor	select	Preferred Vendor
vendorcode	text	Vendor Code
vendorcost	currency	Vendor Price
vendorcostentered	currency	Vendor Price (Entered)
vendorname	text	Vendor Name
vendorpricecurrency	select	Vendor Price Currency
vsoedeferral	select	Deferral
vsoedelivered	checkbox	Default as Delivered
vsoepermitdiscount	select	Permit Discount
vsoeprice	float	VSOE Price
website	select	Web Site
weight	float	Weight
yahooproductfeed	checkbox	Yahoo Shopping Product Feed

Search Columns

Internal ID	Type	Label
accountingbook	select	Accounting Book
accountingbookamortization	select	Accounting Book Amortization Schedule
accountingbookrevrecschedule	select	Accounting Book Rev. Rec. Schedule
alternatedemandsourceitem	text	Alternate Source Item
assetaccount	select	Asset Account
atpleadtime	float	ATP Lead Time
atpmethod	text	Default ATP Method
autoleadtime	checkbox	Auto Lead Time
autopreferredstocklevel	checkbox	Auto Stock Level
autoreorderpoint	checkbox	Auto Reorder Point
availabletopartners	checkbox	Available to Partners
averagecost	currency2	Average Cost
baseprice	currency2	Base Price
billexchratevarianceacct	select	Bill Exchange Rate Variance Account
billpricevarianceacct	select	Bill Price Variance Account
billqtyvarianceacct	select	Bill Quantity Variance Account
binnumber	text	Bin Number
binonhandavail	float	Bin On Hand Available
binonhandcount	float	Bin On Hand Count
buildentireassembly	checkbox	Build Sub-Assemblies
buildtime	float	Work Order Lead Time
buyitnowprice	currency	eBay Buy It Now Price
category	text	Category
categorynohierarchy	text	Category (no hierarchy)
categorypreferred	text	Category (preferred)
class	select	Class
classnohierarchy	select	Class (no hierarchy)
copydescription	checkbox	Copy SO Descr.
correlateditem	select	Correlated Item
correlateditemcorrelation	float	Correlated Item Correlation
correlateditemcount	integer	Correlated Item Count
correlateditemlift	float	Correlated Item Lift
correlateditempurchaserate	float	Correlated Item Purchase Rate
cost	currency2	Purchase Price
costaccountingstatus	text	Cost Accounting Status
costcategory	text	Cost Category
costestimate	currency2	Item Defined Cost
costestimatetype	text	Cost Estimate Type
costingmethod	select	Costing Method
countryofmanufacture	text	Manufacturer Country
created	datetime	Date Created
createjob	checkbox	Create Job
currentstandardcost	currency2	Current Standard Cost
currentstdcosteffectivedate	date	Current Standard Cost Effective Date
custreturnvarianceaccount	select	Customer Return Variance Account
dateviewed	datetime	Date Viewed
daysbeforeexpiration	text	Days Before Expiration
defaultreturncost	currency2	Default Return Cost
deferredexpenseaccount	select	Deferred Expense Account
deferredrevenueaccount	select	Deferred Revenue Account
deferrevrec	checkbox	Hold Revenue Recognition
demandmodifier	percent	Expected Demand Change
demandsource	text	Demand Source
department	select	Department
departmentnohierarchy	select	Department (no hierarchy)
displayinebaystore	checkbox	eBay Store
displayname	text	Display Name
distributioncategory	text	Distribution Category
distributionnetwork	text	Distribution Network
dontshowprice	checkbox	Don't Show Price
ebayitemdescription	clobtext	eBay Description
ebayitemsubtitle	text	eBay Subtitle
ebayitemtitle	text	eBay Title
ebayrelistingoption	text	eBay Relisting Option
effectivebomcontrol	text	Effective BOM Control
effectivedate	date	Effective Date
effectiverevision	select	Effective Revision
endauctionswhenoutofstock	checkbox	eBay End Auctions When Out of Stock
excludefromsitemap	checkbox	Exclude from Sitemap
expenseaccount	select	Expense/COGS Account
externalid	select	External ID
featureddescription	clobtext	Featured Description
feeddescription	text	Feed Description
feedname	text	Feed Name
fixedlotsize	float	Fixed Lot Size
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)
fraudrisk	select	Fraud Risk
froogleproductfeed	checkbox	Google Base Product Feed
fxcost	currency2	Purchase Price (Foreign Currency)
gainlossaccount	select	Gain/Loss Account
generateaccruals	checkbox	Generate Accruals
giftcertauthcode	text	Gift Certificate Auth Code
giftcertemail	text	Gift Certificate To (Email)
giftcertexpirationdate	text	Gift Certificate Exp Date
giftcertfrom	text	Gift Certificate From (Name)
giftcertmessage	text	Gift Certificate Message
giftcertoriginalamount	text	Gift Certificate Orig Amount
giftcertrecipient	text	Gift Certificate To (Name)
hits	integer	# Times Viewed
imageurl	text	Image URL
incomeaccount	select	Income Account
intercoexpenseaccount	select	Intercompany Expense/COGS Account
intercoincomeaccount	select	Intercompany Income Account
internalid	select	Internal ID
inventorylocation	select	Inventory Location
invtclassification	text	Inventory Classification
invtcountinterval	integer	Inventory Count Interval
isavailable	checkbox	Is Available?
isdropshipitem	checkbox	Drop Ship Item
isfulfillable	checkbox	Can be Fulfilled
isgcocompliant	checkbox	Google Checkout Compliant
isinactive	checkbox	Inactive
islotitem	checkbox	Is Lot Numbered Item
isonline	checkbox	Display in Web Site
isserialitem	checkbox	Is Serialized Item
isspecialorderitem	checkbox	Special Order Item
isspecialworkorderitem	checkbox	Special Work Order Item
issueproduct	select	Product
istaxable	checkbox	Taxable
isvsoebundle	checkbox	Is VSOE Bundle?
iswip	checkbox	WIP
itemid	text	Name
itemurl	text	Item URL
lastinvtcountdate	date	Last Inventory Count Date
lastpurchaseprice	currency	Last Purchase Price
lastquantityavailablechange	datetime	Last Quantity Available Change
lastviewed	datetime	Last Viewed
leadtime	integer	Lead Time
liabilityaccount	select	Liability Account
listingduration	text	eBay Duration
location	select	Location
locationatpleadtime	float	Location ATP Lead Time
locationaveragecost	currency2	Location Average Cost
locationbinquantityavailable	float	Location Bin Available
locationbuildtime	float	Location Work Order Lead Time
locationcost	currency	Location Standard Cost
locationcostaccountingstatus	text	Location Cost Accounting Status
locationdefaultreturncost	currency2	Location Default Return Cost
locationdemandsource	text	Location Demand Source
locationfixedlotsize	float	Location Fixed Lot Size
locationinvtclassification	text	Location Inventory Classification
locationinvtcountinterval	integer	Location Inventory Count Interval
locationlastinvtcountdate	date	Location Last Inventory Count Date
locationleadtime	integer	Location Lead Time
locationnextinvtcountdate	date	Location Next Inventory Count Date
locationnohierarchy	select	Location (no hierarchy)
locationpreferredstocklevel	float	Location Preferred Stock Level
locationquantityavailable	float	Location Available
locationquantitybackordered	float	Location Back Ordered
locationquantitycommitted	float	Location Committed
locationquantityintransit	float	Location In Transit
locationquantityonhand	float	Location On Hand
locationquantityonorder	float	Location On Order
locationreorderpoint	float	Location Reorder Point
locationsafetystocklevel	float	Location Safety Stock Level
locationsupplylotsizingmethod	text	Location Supply Lot Sizing Method
locationsupplytype	text	Location Supply Type
locationtotalvalue	currency2	Location Total Value
manufacturer	text	Manufacturer
manufactureraddr1	text	Manufacturer Address
manufacturercity	text	Manufacturer City
manufacturerstate	text	Manufacturer State
manufacturertariff	text	Manufacturer Tariff
manufacturertaxid	text	Manufacturer Tax Id
manufacturerzip	text	Manufacturer Zip
matchbilltoreceipt	checkbox	Match Bill To Receipt
memberitem	select	Member Item
memberquantity	float	Member Quantity
metataghtml	clobtext	Meta Tag Html
minimumquantity	text	Minimum Quantity
modified	datetime	Last Modified
mossapplies	checkbox	MOSS Applies
mpn	text	MPN
multmanufactureaddr	checkbox	Multiple Manufacture Addresses
nextagcategory	text	NexTag Category
nextagproductfeed	checkbox	NexTag Product Feed
nextinvtcountdate	date	Next Inventory Count Date
nopricemessage	text	No Price Message
numactivelistings	integer	eBay Active Listings
numberalloweddownloads	text	Number of Allowed Downloads
numcurrentlylisted	integer	eBay Quantity Currently Listed
obsoletedate	date	Obsolete Date
obsoleterevision	select	Obsolete Revision
offersupport	checkbox	Offer Support
onlinecustomerprice	currency	Online Customer Price
onlineprice	currency	Online Price
onspecial	checkbox	On Special
otherprices	currency	Other Prices
othervendor	select	Vendor
outofstockbehavior	text	Out Of Stock Behavior
outofstockmessage	text	Out Of Stock Message
overallquantitypricingtype	select	Overall Qty. Pricing Type
pagetitle	textarea	Page Title
parent	select	Parent
preferencecriterion	text	Preference Criterion
preferredbin	checkbox	Preferred Bin
preferredlocation	select	Preferred Location
preferredstocklevel	float	Preferred Stock Level
preferredstockleveldays	integer	Days Supply
pricesincludetax	checkbox	Prices Include Tax
pricinggroup	select	Pricing Group
primarycategory	text	eBay Category Id
prodpricevarianceacct	select	Production Price Variance Account
prodqtyvarianceacct	select	Production Quantity Variance Account
purchasedescription	text	Purchase Description
purchaseorderamount	float	Vendor Bill - Purchase Order Amount Tolerance
purchaseorderquantity	float	Vendor Bill - Purchase Order Quantity Tolerance
purchaseorderquantitydiff	float	Vendor Bill - Purchase Order Quantity Difference
purchasepricevarianceacct	select	Purchase Price Variance Account
purchaseunit	select	Purchase Unit
quantityavailable	float	Available
quantitybackordered	float	Back Ordered
quantitycommitted	float	Committed
quantityonhand	float	On Hand
quantityonorder	float	On Order
quantitypricingschedule	select	Quantity Pricing Schedule
receiptamount	float	Vendor Bill - Item Receipt Amount Tolerance
receiptquantity	float	Vendor Bill - Item Receipt Quantity Tolerance
receiptquantitydiff	float	Vendor Bill - Item Receipt Quantity Difference
reordermultiple	integer	Reorder Multiple
reorderpoint	float	Reorder Point
reserveprice	currency	eBay Reserve Price
revrecschedule	select	Rev. Rec. Schedule
safetystocklevel	float	Safety Stock Level
safetystockleveldays	integer	Safety Stock Days
salesdescription	text	Description
salestaxcode	select	Tax Code
saleunit	select	Sale Unit
schedulebcode	text	Schedule B Code
schedulebnumber	text	Schedule B Number
schedulebquantity	text	Schedule B Quantity
scrapacct	select	Scrap Account
searchkeywords	text	Search Keywords
seasonaldemand	checkbox	Seasonal Demand
sellonebay	checkbox	eBay Auction
serialnumber	text	Serial/Lot Number
serialnumberlocation	text	Serial/Lot Number Location
shipindividually	checkbox	Ships Individually
shippackage	select	Shipping Package
shippingrate	currency	Shipping Rate
shoppingdotcomcategory	text	Shopping.com Category
shoppingproductfeed	checkbox	Shopping.com Product Feed
shopzillacategoryid	integer	Shopzilla Category Id
shopzillaproductfeed	checkbox	Shopzilla Product Feed
sitemappriority	float	Sitemap Priority
softdescriptor	select	Soft Descriptor
startingprice	currency	eBay Starting Price
stockdescription	text	Stock Description
stockunit	select	Stock Unit
storedescription	text	Store Description
storedetaileddescription	clobtext	Detailed Description
storedisplayimage	select	Store Display Image
storedisplayname	text	Store Display Name
storedisplaythumbnail	select	Store Display Thumbnail
subsidiary	select	Subsidiary
subsidiarynohierarchy	select	Subsidiary (no hierarchy)
subtype	text	SubType
supplylotsizingmethod	text	Supply Lot Sizing Method
supplyreplenishmentmethod	text	Replenishment Method
supplytype	text	Supply Type
taxschedule	select	Tax Schedule
thumbnailurl	text	Thumbnail URL
totalvalue	currency2	Total Value
tracklandedcost	checkbox	Track Landed Cost
transferprice	currency2	Transfer Price
type	select	Type
unbuildvarianceaccount	select	Unbuild Variance Account
unitstype	select	Units Type
upccode	text	UPC Code
urlcomponent	text	URL Component
usebins	checkbox	Use Bins
usemarginalrates	checkbox	Use Marginal Rates
vendor	select	Preferred Vendor
vendorcode	text	Vendor Code
vendorcost	currency	Vendor Price
vendorcostentered	currency	Vendor Price (Entered)
vendorname	text	Vendor Name
vendorpricecurrency	text	Vendor Price Currency
vendorschedule	select	Vendor Schedule
vendreturnvarianceaccount	select	Vendor Return Variance Account
vsoedeferral	select	Deferral
vsoedelivered	checkbox	Default as Delivered
vsoepermitdiscount	select	Permit Discount
vsoeprice	currency2	VSOE Price
website	select	Web Site
weight	float	Weight
weightunit	select	Weight Units
wipacct	select	WIP Account
wipvarianceacct	select	WIP Cost Variance Account
yahooproductfeed	checkbox	Yahoo Shopping Product Feed