Item

item

Fields

Label ID Type UI Workbook SuiteScript / SuiteTalk REST Web Services Connect
Accounting Books accountingbookdetail sublist Yes Yes Yes
Allocation Price vsoeprice currency2 Yes Yes Yes
Allocation Type vsoesopgroup select Yes Yes Yes
Alternate Source Item alternatedemandsourceitem select Yes Yes Yes
Amortization Period amortizationperiod integer Yes Yes Yes
Amortization Template amortizationtemplate select Yes Yes Yes
Asset Account assetaccount select Yes Yes Yes
ATP Lead Time atpleadtime integer Yes Yes Yes
ATP Method atpmethod select Yes Yes Yes
Auto-Calculate autoleadtime checkbox Yes Yes Yes
Auto-Calculate autopreferredstocklevel checkbox Yes Yes Yes
Auto-Calculate autoreorderpoint checkbox Yes Yes Yes
Auto-Expansion for Revenue Management autoexpandkitforrevenuemgmt checkbox Yes Yes Yes
Available to Adv. Partners availabletopartners checkbox Yes Yes Yes
Average Cost averagecost currency Yes Yes Yes
Backward Consumption Days backwardconsumptiondays integer Yes Yes Yes
Billing Schedule billingschedule select Yes Yes Yes
Bin Numbers binnumbers sublist Yes Yes Yes
Calculate Quantity Discounts overallquantitypricingtype select Yes Yes Yes
Can be Fulfilled isfulfillable checkbox Yes Yes Yes
Class class select Yes Yes Yes
Consumption consumptionunit select Yes Yes Yes
Copy from Sales Order copydescription checkbox Yes Yes Yes
Correlated Items correlateditems sublist Yes Yes Yes
Cost Category costcategory select Yes Yes Yes
Cost Estimate Type costestimatetype select Yes Yes Yes
Costing Method costingmethod select Yes Yes Yes
Create Expense Plans On createexpenseplanson select Yes Yes Yes
Create Job createjob checkbox Yes Yes Yes
Create Revenue Plans On createrevenueplanson select Yes Yes Yes
Customer Return Variance Account custreturnvarianceaccount select Yes Yes Yes
Date Created createddate datetime Yes Yes Yes
Days preferredstockleveldays float Yes Yes Yes
Default as Delivered vsoedelivered checkbox Yes Yes Yes
Deferral vsoedeferral select Yes Yes Yes
Deferred Expense deferralaccount select Yes Yes Yes
Deferred Revenue Account deferredrevenueaccount select Yes Yes Yes
Demand Source demandsource select Yes Yes Yes
Demand Time Fence demandtimefence integer Yes Yes Yes
Department department select Yes Yes Yes
Description description textarea Yes Yes Yes
Detailed Description storedetaileddescription textarea Yes Yes Yes
Direct Revenue Posting directrevenueposting checkbox Yes Yes Yes
Display in Web Site isonline checkbox Yes Yes Yes
Display Name/Code displayname text Yes Yes Yes
Distribution Category distributioncategory select Yes Yes Yes
Distribution Network distributionnetwork select Yes Yes Yes
Don't Show Price dontshowprice checkbox Yes Yes Yes
Dropship Expense Account dropshipexpenseaccount select Yes Yes Yes
Drop Ship Item isdropshipitem checkbox Yes Yes Yes
Effective BOM Control effectivebomcontrol select Yes Yes Yes
Eligible For Contingent Revenue Handling contingentrevenuehandling checkbox Yes Yes Yes
Enforce Minimum Internally enforceminqtyinternally checkbox Yes Yes Yes
Estimated Demand Change demandmodifier percent Yes Yes Yes
Exchange Rate Variance Account billexchratevarianceacct select Yes Yes Yes
Exclude from Sitemap excludefromsitemap checkbox Yes Yes Yes
Expense/COGS Account expenseaccount select Yes Yes Yes
Expense Amortization Rule expenseamortizationrule select Yes Yes Yes
External ID externalid text Yes Yes Yes
Fixed Lot Size fixedlotsize posfloat Yes Yes Yes
Foreign Currency Adjustment Account revreclassfxaccount select Yes Yes Yes
Forward Consumption Days forwardconsumptiondays integer Yes Yes Yes
Full Name fullname text Yes Yes Yes
Gain/Loss Account gainlossaccount select Yes Yes Yes
Generate Accruals generateaccruals checkbox Yes Yes Yes
Google Base Product Feed froogleproductfeed checkbox Yes Yes Yes
Handling Cost handlingcost currency Yes Yes Yes
Hold Revenue Recognition deferrevrec checkbox Yes Yes Yes
Inactive isinactive checkbox Yes Yes Yes
Include Children includechildren checkbox Yes Yes Yes
Income Account incomeaccount select Yes Yes Yes
Intercompany Deferred Revenue Account intercodefrevaccount select Yes Yes Yes
Intercompany Expense Account intercoexpenseaccount select Yes Yes Yes
Intercompany Income Account intercoincomeaccount select Yes Yes Yes
Internal ID id integer Yes Yes Yes
Item Defined Cost costestimate currency Yes Yes Yes
Item Display Image storedisplayimage select Yes Yes Yes
Item Display Thumbnail storedisplaythumbnail select Yes Yes Yes
Item Name/Number itemid text Yes Yes Yes
Item Process Family itemprocessfamily select Yes Yes Yes
Item Process Group itemprocessgroup select Yes Yes Yes
Item Revenue Category itemrevenuecategory select Yes Yes Yes
Item Weight weight float Yes Yes Yes
Last Modified lastmodifieddate datetime Yes Yes Yes
Last Purchase Price lastpurchaseprice currency Yes Yes Yes
Lead Time leadtime integer Yes Yes Yes
Location location select Yes Yes Yes
Locations locations sublist Yes Yes Yes
Lot Numbered islotitem checkbox Yes Yes Yes
Lot Sizing Method supplylotsizingmethod select Yes Yes Yes
Manufacturer manufacturer text Yes Yes Yes
Manufacturer Country countryofmanufacture select Yes Yes Yes
Manufacturer Part Number mpn text Yes Yes Yes
Manufacturing Charge Item manufacturingchargeitem checkbox Yes Yes Yes
Mark Sub-assemblies Phantom buildentireassembly checkbox Yes Yes Yes
Match Bill To Receipt matchbilltoreceipt checkbox Yes Yes Yes
Matrix Item Name Template matrixitemnametemplate textarea Yes Yes Yes
Matrix Type matrixtype select Yes Yes Yes
Maximum Order Qty maximumquantity posinteger Yes Yes Yes
Maximum Variable Amount maxdonationamount currency2 Yes Yes Yes
Members member sublist Yes Yes Yes
Merchandise Hierarchy hierarchyversions sublist Yes Yes Yes
Meta Tag HTML metataghtml textarea Yes Yes Yes
Minimum Order Qty minimumquantity posinteger Yes Yes Yes
NexTag Category nextagcategory text Yes Yes Yes
NexTag Product Feed nextagproductfeed checkbox Yes Yes Yes
-No label- preferredstocklevelunits text Yes Yes Yes
-No label- reorderpointunits text Yes Yes Yes
-No label- safetystocklevelunits text Yes Yes Yes
No Price Message nopricemessage text Yes Yes Yes
Out Of Stock Behavior outofstockbehavior select Yes Yes Yes
Out Of Stock Message outofstockmessage textarea Yes Yes Yes
Overhead Type overheadtype select Yes Yes Yes
Package shippackage select Yes Yes Yes
Page Title pagetitle textarea Yes Yes Yes
Periods of Supply Increment periodiclotsizedays integer Yes Yes Yes
Periods of Supply Type periodiclotsizetype select Yes Yes Yes
Permit Discount vsoepermitdiscount select Yes Yes Yes
Phantom isphantom checkbox Yes Yes Yes
Planning Time Fence supplytimefence integer Yes Yes Yes
Preferred Location preferredlocation select Yes Yes Yes
Preferred Stock Level preferredstocklevel float Yes Yes Yes
Preferred Vendor vendor select Yes Yes Yes
Price rate currency2 Yes Yes Yes
Price Including Tax rateincludingtax currency2 Yes Yes Yes
Prices Include Tax pricesincludetax checkbox Yes Yes Yes
Price Variance Account billpricevarianceacct select Yes Yes Yes
Pricing price sublist Yes Yes Yes
Pricing Group pricinggroup select Yes Yes Yes
Print Items printitems checkbox Yes Yes Yes
Production Price Variance Account prodpricevarianceacct select Yes Yes Yes
Production Quantity Variance Account prodqtyvarianceacct select Yes Yes Yes
Project Expense Type projectexpensetype select Yes Yes Yes
Project Template projecttemplate select Yes Yes Yes
Purchase Description purchasedescription textarea Yes Yes Yes
Purchase Price cost currency2 Yes Yes Yes
Purchase Price (Foreign Currency) fxcost currency2 Yes Yes Yes
Purchase Price Variance Account purchasepricevarianceacct select Yes Yes Yes
Purchase Unit purchaseunit select Yes Yes Yes
Quantity Available quantityavailable float Yes Yes Yes
Quantity Back Ordered quantitybackordered float Yes Yes Yes
Quantity Committed quantitycommitted float Yes Yes Yes
Quantity On Hand quantityonhand float Yes Yes Yes
Quantity On Order quantityonorder float Yes Yes Yes
Quantity Pricing Schedule quantitypricingschedule select Yes Yes Yes
Quantity Variance Account billqtyvarianceacct select Yes Yes Yes
Reorder Multiple reordermultiple posinteger Yes Yes Yes
Reorder Point reorderpoint float Yes Yes Yes
Replenishment Method supplyreplenishmentmethod select Yes Yes Yes
Reschedule In Days rescheduleindays integer Yes Yes Yes
Reschedule Out Days rescheduleoutdays integer Yes Yes Yes
Residual residual rate Yes Yes Yes
Revenue Allocation Group revenueallocationgroup select Yes Yes Yes
Revenue Recognition Rule revenuerecognitionrule select Yes Yes Yes
Revenue Recognition Template revrecschedule select Yes Yes Yes
Rev Rec Forecast Rule revrecforecastrule select Yes Yes Yes
Rotation Type rotationtype select Yes Yes Yes
Round Up Quantity as Component roundupascomponent checkbox Yes Yes Yes
Safety Stock Level safetystocklevel float Yes Yes Yes
Safety Stock Level Days safetystockleveldays integer Yes Yes Yes
Sale Unit saleunit select Yes Yes Yes
Scrap Account scrapacct select Yes Yes Yes
Seasonal Demand seasonaldemand checkbox Yes Yes Yes
Serialized isserialitem checkbox Yes Yes Yes
Shipping Cost shippingcost currency Yes Yes Yes
Ships Individually shipindividually checkbox Yes Yes Yes
Shopping.com Category shoppingdotcomcategory text Yes Yes Yes
Shopping Product Feed shoppingproductfeed checkbox Yes Yes Yes
Shopzilla Category ID shopzillacategoryid integer Yes Yes Yes
Shopzilla Product Feed shopzillaproductfeed checkbox Yes Yes Yes
Show Default Amount showdefaultdonationamount checkbox Yes Yes Yes
Site Categories sitecategory sublist Yes Yes Yes
Sitemap Priority sitemappriority select Yes Yes Yes
Special Order Item isspecialorderitem checkbox Yes Yes Yes
Special Work Order Item isspecialworkorderitem checkbox Yes Yes Yes
Stock Description stockdescription text Yes Yes Yes
Stock Unit stockunit select Yes Yes Yes
Store Description storedescription textarea Yes Yes Yes
Store Display Name storedisplayname text Yes Yes Yes
Subitem of parent select Yes Yes Yes
Subsidiary subsidiary multiselect Yes Yes Yes
Subtype subtype select Yes Yes Yes
Supply Type supplytype select Yes Yes Yes
Total Quantity On Hand totalquantityonhand float Yes Yes Yes
Total Value totalvalue currency Yes Yes Yes
Track Landed Cost tracklandedcost checkbox Yes Yes Yes
Transfer Price transferprice currency2 Yes Yes Yes
Translations translations sublist Yes Yes Yes
Type itemtype select Yes Yes Yes
Unbuild Variance Account unbuildvarianceaccount select Yes Yes Yes
Units Type unitstype select Yes Yes Yes
UPC Code upccode text Yes Yes Yes
URL Component urlcomponent textarea Yes Yes Yes
URL Component Alias urlcomponentaliases sublist Yes Yes Yes
Use as Category Only parentonly checkbox Yes Yes Yes
Use Component Yield usecomponentyield checkbox Yes Yes Yes
Use Marginal Rates usemarginalrates checkbox Yes Yes Yes
User Notes usernotes sublist Yes Yes Yes
Variable Amount isdonationitem checkbox Yes Yes Yes
Vendor Bill - Item Receipt Amount Tolerance receiptamount posfloat Yes Yes Yes
Vendor Bill - Item Receipt Quantity Difference receiptquantitydiff posfloat Yes Yes Yes
Vendor Bill - Item Receipt Quantity Tolerance receiptquantity posfloat Yes Yes Yes
Vendor Bill - Purchase Order Amount Tolerance purchaseorderamount posfloat Yes Yes Yes
Vendor Bill - Purchase Order Quantity Difference purchaseorderquantitydiff posfloat Yes Yes Yes
Vendor Bill - Purchase Order Quantity Tolerance purchaseorderquantity posfloat Yes Yes Yes
Vendor Name/Code vendorname text Yes Yes Yes
Vendor Return Variance Account vendreturnvarianceaccount select Yes Yes Yes
Vendors itemvendor sublist Yes Yes Yes
Weight Unit weightunit select Yes Yes Yes
Weight Units weightunits text Yes Yes Yes
WIP Account wipacct select Yes Yes Yes
WIP Variance Account wipvarianceacct select Yes Yes Yes
Work Order Lead Time buildtime float Yes Yes Yes
Yahoo Shopping Product Feed yahooproductfeed checkbox Yes Yes Yes

Joins

Join Target Record UI Workbook SuiteScript / SuiteTalk REST Web Services Connect
Members to Item Revision (itemRevision.id) members (itemmember, itemmember.effectiverevision) No Yes Yes
Members to Item (item.id) members (itemmember, itemmember.item) No Yes Yes
Members to Item Source (itemSource.key) members (itemmember, itemmember.itemsource) Yes Yes Yes
Members to Item Revision (itemRevision.id) members (itemmember, itemmember.obsoleterevision) No Yes Yes
Members to Type (vsoeDeferralType.key) members (itemmember, itemmember.vsoedeferral) Yes Yes Yes
Members to Type (vsoeDiscountType.key) members (itemmember, itemmember.vsoepermitdiscount) Yes Yes Yes
Related Items to Type (presentationItemType.key) related items (itempresentationitem, itempresentationitem.itemtype) Yes Yes Yes
Item Quantity to Item (item.id) item quantity (itemquantity, itemquantity.item) No Yes Yes
Bin Numbers to Item (item.id) bin numbers (itembinquantity, itembinquantity.item) No Yes Yes
Correlated Items to Item (item.id) correlated items (itemcorrelateditem, itemcorrelateditem.item) No Yes Yes
Item to Account (account.id) item (item, item.dropshipexpenseaccount) No Yes Yes
Item to Expense Amortization Rule (expenseAmortizationRule.id) item (item, item.expenseamortizationrule) No Yes Yes
Hierarchy Versions to Item (item.id) hierarchy versions (itemmerchandisehierarchynoninventorysaleitemversion, itemmerchandisehierarchynoninventorysaleitemversion.item) No Yes Yes
Associated Images to Item (item.id) associated images (itemimage, itemimage.item) No Yes Yes
Vendors to Item (item.id) vendors (itemvendor, itemvendor.item) No Yes Yes
Members to Item (item.id) members (itemmember, itemmember.parentitem) No Yes Yes
Item to Item (item.id) item (item, item.parent) No Yes Yes
Related Items to Item (item.id) related items (itempresentationitem, itempresentationitem.superitem) No Yes Yes
Levels to Item (item.id) levels (itemquantitypricingdiscount, itemquantitypricingdiscount.parentitem) No Yes Yes
Levels to Item (item.id) levels (itemquantitypricinglevel, itemquantitypricinglevel.item) No Yes Yes
Site Categories to Item (item.id) site categories (itemsitecategory, itemsitecategory.item) No Yes Yes
Item to Supply Type (itemSupplyType.key) item (item, item.supplytype) Yes Yes Yes
Translation to Item (item.id) translation (itemtranslation, itemtranslation.item) No Yes Yes
URL Component Alias to Item (item.id) url component alias (itemurlcomponentaliases, itemurlcomponentaliases.item) No Yes Yes