inventoryitem
The inventoryitem table.
Columns
| Name | Type | References | Description |
| alternatedemandsourceitem | String | Alternatedemandsourceitem | |
| assetaccount | String | Assetaccount | |
| atpmethod | String | Atpmethod | |
| auctionquantity | String | Auctionquantity | |
| auctiontype | String | Auctiontype | |
| autoleadtime | Boolean | Autoleadtime | |
| autopreferredstocklevel | Boolean | Autopreferredstocklevel | |
| autoreorderpoint | Boolean | Autoreorderpoint | |
| availabletopartners | Boolean | Availabletopartners | |
| averagecost | Decimal | Averagecost | |
| billexchratevarianceacct | String | Billexchratevarianceacct | |
| billingschedule | String | Billingschedule | |
| billpricevarianceacct | String | Billpricevarianceacct | |
| billqtyvarianceacct | String | Billqtyvarianceacct | |
| buyitnowprice | Decimal | Buyitnowprice | |
| class | String | Class | |
| cogsaccount | String | Cogsaccount | |
| conditionenabled | String | Conditionenabled | |
| conditionhelpurl | String | Conditionhelpurl | |
| consumptionunit | String | Consumptionunit | |
| contingentrevenuehandling | Boolean | Contingentrevenuehandling | |
| conversionrate | String | Conversionrate | |
| copydescription | Boolean | Copydescription | |
| cost | Decimal | Cost | |
| costcategory | String | Costcategory | |
| costestimate | Decimal | Costestimate | |
| costestimatetype | String | Costestimatetype | |
| costingmethod | String | Costingmethod | |
| costingmethoddisplay | String | Costingmethoddisplay | |
| costunits | String | Costunits | |
| countryofmanufacture | String | Countryofmanufacture | |
| createddate | Datetime | Createddate | |
| createrevenueplanson | String | Createrevenueplanson | |
| currency | String | Currency | |
| customform | String | Customform | |
| custreturnvarianceaccount | String | Custreturnvarianceaccount | |
| deferredrevenueaccount | String | Deferredrevenueaccount | |
| deferrevrec | Boolean | Deferrevrec | |
| demandmodifier | String | Demandmodifier | |
| demandtimefence | Integer | Demandtimefence | |
| department | String | Department | |
| directrevenueposting | Boolean | Directrevenueposting | |
| displayinebaystore | Boolean | Displayinebaystore | |
| displayname | String | Displayname | |
| distributioncategory | String | Distributioncategory | |
| distributionnetwork | String | Distributionnetwork | |
| dontshowprice | Boolean | Dontshowprice | |
| dropshipexpenseaccount | String | Dropshipexpenseaccount | |
| ebayhandlingtime | String | Ebayhandlingtime | |
| ebayintlinsurancefee | Decimal | Ebayintlinsurancefee | |
| ebayintlpackagehandlingfee | Decimal | Ebayintlpackagehandlingfee | |
| ebayintlshipinsurance | String | Ebayintlshipinsurance | |
| ebayintlshippingitem1 | String | Ebayintlshippingitem1 | |
| ebayintlshippingitem2 | String | Ebayintlshippingitem2 | |
| ebayintlshippingitem3 | String | Ebayintlshippingitem3 | |
| ebayisintlcalculatedrate | String | Ebayisintlcalculatedrate | |
| ebayisirregularpackage | Boolean | Ebayisirregularpackage | |
| ebayitemdescription | String | Ebayitemdescription | |
| ebayitemlocdisplay | String | Ebayitemlocdisplay | |
| ebayitemloczipcode | String | Ebayitemloczipcode | |
| ebayitemlots | Integer | Ebayitemlots | |
| ebayitemsubtitle | String | Ebayitemsubtitle | |
| ebayitemtitle | String | Ebayitemtitle | |
| ebayitemweightamt | String | Ebayitemweightamt | |
| ebaylayout | String | Ebaylayout | |
| ebaypackagetype | String | Ebaypackagetype | |
| ebaypagecounter | String | Ebaypagecounter | |
| ebayrelistingoption | String | Ebayrelistingoption | |
| ebaytheme | String | Ebaytheme | |
| ebaythemegroup | String | Ebaythemegroup | |
| enablecatchweight | Boolean | Enablecatchweight | |
| endauctionswhenoutofstock | Boolean | Endauctionswhenoutofstock | |
| enforceminqtyinternally | Boolean | Enforceminqtyinternally | |
| excludefromsitemap | Boolean | Excludefromsitemap | |
| externalid | String | Externalid | |
| featureddescription | String | Featureddescription | |
| fraudrisk | String | Fraudrisk | |
| froogleproductfeed | String | Froogleproductfeed | |
| futurehorizon | String | Futurehorizon | |
| gainlossaccount | String | Gainlossaccount | |
| gallery | Boolean | Gallery | |
| galleryfeatured | Boolean | Galleryfeatured | |
| gifttypeexpressship | Boolean | Gifttypeexpressship | |
| gifttypegiftwrap | Boolean | Gifttypegiftwrap | |
| gifttypeshiptorecipient | Boolean | Gifttypeshiptorecipient | |
| handlingcost | Decimal | Handlingcost | |
| handlingcostunits | String | Handlingcostunits | |
| handlinggroup | String | Handlinggroup | |
| imagesgroup | String | Imagesgroup | |
| imageslocation | String | Imageslocation | |
| includechildren | Boolean | Includechildren | |
| incomeaccount | String | Incomeaccount | |
| intercocogsaccount | String | Intercocogsaccount | |
| intercodefrevaccount | String | Intercodefrevaccount | |
| intercoincomeaccount | String | Intercoincomeaccount | |
| internalid | Integer | Internalid | |
| iscalculatedrate | String | Iscalculatedrate | |
| isdonationitem | Boolean | Isdonationitem | |
| isdropshipitem | Boolean | Isdropshipitem | |
| isgcocompliant | Boolean | Isgcocompliant | |
| isinactive | Boolean | Isinactive | |
| isonline | Boolean | Isonline | |
| isspecialorderitem | Boolean | Isspecialorderitem | |
| isstorepickupallowed | Boolean | Isstorepickupallowed | |
| issueproduct | String | Issueproduct | |
| itemcondition | String | Itemcondition | |
| itemhandlingfee | Decimal | Itemhandlingfee | |
| itemid | String | Itemid | |
| iteminsurancefee | Decimal | Iteminsurancefee | |
| itemoptions | String | Itemoptions | |
| itemprocessfamily | String | Itemprocessfamily | |
| itemprocessgroup | String | Itemprocessgroup | |
| itemrevenuecategory | String | Itemrevenuecategory | |
| itemshipinsurance | String | Itemshipinsurance | |
| itemtype | String | Itemtype | |
| lastmodifieddate | Datetime | Lastmodifieddate | |
| lastpurchaseprice | Decimal | Lastpurchaseprice | |
| leadtime | Integer | Leadtime | |
| listimmediate | String | Listimmediate | |
| listingduration | String | Listingduration | |
| listingstartdate | Date | Listingstartdate | |
| listingstarttime | String | Listingstarttime | |
| location | String | Location | |
| lowerwarninglimit | Double | Lowerwarninglimit | |
| manufacturer | String | Manufacturer | |
| manufactureraddr1 | String | Manufactureraddr1 | |
| manufacturercity | String | Manufacturercity | |
| manufacturerstate | String | Manufacturerstate | |
| manufacturertariff | String | Manufacturertariff | |
| manufacturertaxid | String | Manufacturertaxid | |
| manufacturerzip | String | Manufacturerzip | |
| matchbilltoreceipt | Boolean | Matchbilltoreceipt | |
| matrixitemnametemplate | String | Matrixitemnametemplate | |
| matrixtype | String | Matrixtype | |
| maxdonationamount | Decimal | Maxdonationamount | |
| maximumquantity | String | Maximumquantity | |
| metataghtml | String | Metataghtml | |
| minimumquantity | String | Minimumquantity | |
| minimumquantityunits | String | Minimumquantityunits | |
| mossapplies | Boolean | Mossapplies | |
| mpn | String | Mpn | |
| multmanufactureaddr | Boolean | Multmanufactureaddr | |
| nextagcategory | String | Nextagcategory | |
| nextagproductfeed | String | Nextagproductfeed | |
| nopricemessage | String | Nopricemessage | |
| numactivelistings | Integer | Numactivelistings | |
| numcurrentlylisted | Integer | Numcurrentlylisted | |
| offersupport | Boolean | Offersupport | |
| outofstockbehavior | String | Outofstockbehavior | |
| outofstockmessage | String | Outofstockmessage | |
| overallquantitypricingtype | String | Overallquantitypricingtype | |
| packageheight | String | Packageheight | |
| packagelength | String | Packagelength | |
| packagewidth | String | Packagewidth | |
| pagetitle | String | Pagetitle | |
| parent | String | Parent | |
| planningitemcategory | String | Planningitemcategory | |
| preferencecriterion | String | Preferencecriterion | |
| preferredlocation | String | Preferredlocation | |
| preferredstockleveldays | Double | Preferredstockleveldays | |
| pricinggroup | String | Pricinggroup | |
| primarycatdisplayname | String | Primarycatdisplayname | |
| primarycategory | Integer | Primarycategory | |
| producer | Boolean | Producer | |
| productfeed | String | Productfeed | |
| purchasedescription | String | Purchasedescription | |
| purchaseorderamount | String | Purchaseorderamount | |
| purchaseorderquantity | String | Purchaseorderquantity | |
| purchaseorderquantitydiff | String | Purchaseorderquantitydiff | |
| purchasepricevarianceacct | String | Purchasepricevarianceacct | |
| purchaseunit | String | Purchaseunit | |
| quantitypricingschedule | String | Quantitypricingschedule | |
| quantityreorderunits | String | Quantityreorderunits | |
| receiptamount | String | Receiptamount | |
| receiptquantity | String | Receiptquantity | |
| receiptquantitydiff | String | Receiptquantitydiff | |
| refundgivenas | String | Refundgivenas | |
| relateditemsdescription | String | Relateditemsdescription | |
| reordermultiple | String | Reordermultiple | |
| rescheduleindays | Integer | Rescheduleindays | |
| rescheduleoutdays | Integer | Rescheduleoutdays | |
| reserveprice | Decimal | Reserveprice | |
| returnpolicy | String | Returnpolicy | |
| returnpolicydetails | String | Returnpolicydetails | |
| returnshippingpaidby | String | Returnshippingpaidby | |
| returnswithin | String | Returnswithin | |
| revenueallocationgroup | String | Revenueallocationgroup | |
| revenuerecognitionrule | String | Revenuerecognitionrule | |
| revrecforecastrule | String | Revrecforecastrule | |
| revreclassfxaccount | String | Revreclassfxaccount | |
| revrecschedule | String | Revrecschedule | |
| safetystocklevel | Double | Safetystocklevel | |
| safetystockleveldays | Integer | Safetystockleveldays | |
| safetystocklevelunits | String | Safetystocklevelunits | |
| salesdescription | String | Salesdescription | |
| saleunit | String | Saleunit | |
| schedulebcode | String | Schedulebcode | |
| schedulebnumber | String | Schedulebnumber | |
| schedulebquantity | String | Schedulebquantity | |
| searchkeywords | String | Searchkeywords | |
| seasonaldemand | Boolean | Seasonaldemand | |
| secondarybaseunit | String | Secondarybaseunit | |
| secondarycatdisplayname | String | Secondarycatdisplayname | |
| secondarycategory | Integer | Secondarycategory | |
| secondaryconsumptionunit | String | Secondaryconsumptionunit | |
| secondarypurchaseunit | String | Secondarypurchaseunit | |
| secondarysaleunit | String | Secondarysaleunit | |
| secondarystockunit | String | Secondarystockunit | |
| secondaryunitstype | String | Secondaryunitstype | |
| sellonebay | Boolean | Sellonebay | |
| shipasia | Boolean | Shipasia | |
| shipaustralia | Boolean | Shipaustralia | |
| shipcanada | Boolean | Shipcanada | |
| shipeurope | Boolean | Shipeurope | |
| shipgermany | Boolean | Shipgermany | |
| shipindividually | Boolean | Shipindividually | |
| shipjapan | Boolean | Shipjapan | |
| shipmexico | Boolean | Shipmexico | |
| shipnorthsouthamerica | Boolean | Shipnorthsouthamerica | |
| shippackage | String | Shippackage | |
| shippingcost | Decimal | Shippingcost | |
| shippingcostunits | String | Shippingcostunits | |
| shippingdomesticmethodsgroup | String | Shippingdomesticmethodsgroup | |
| shippingdomgroup | String | Shippingdomgroup | |
| shippingintlgroup | String | Shippingintlgroup | |
| shippingintlgroup1 | String | Shippingintlgroup1 | |
| shippingintlgroup2 | String | Shippingintlgroup2 | |
| shippingintlgroup3 | String | Shippingintlgroup3 | |
| shippingitem1 | String | Shippingitem1 | |
| shippingitem2 | String | Shippingitem2 | |
| shippingitem3 | String | Shippingitem3 | |
| shippinglocationsgroup | String | Shippinglocationsgroup | |
| shippingpackaginggroup | String | Shippingpackaginggroup | |
| shippingrate1 | Decimal | Shippingrate1 | |
| shippingrate2 | Decimal | Shippingrate2 | |
| shippingrate3 | Decimal | Shippingrate3 | |
| shipuk | Boolean | Shipuk | |
| shipworldwide | Boolean | Shipworldwide | |
| shoppingdotcomcategory | String | Shoppingdotcomcategory | |
| shoppingproductfeed | String | Shoppingproductfeed | |
| shopzillacategoryid | Integer | Shopzillacategoryid | |
| shopzillaproductfeed | String | Shopzillaproductfeed | |
| showasgift | Boolean | Showasgift | |
| showdefaultdonationamount | Boolean | Showdefaultdonationamount | |
| sitemappriority | String | Sitemappriority | |
| softdescriptor | String | Softdescriptor | |
| standardimages | String | Standardimages | |
| startingprice | Decimal | Startingprice | |
| stockdescription | String | Stockdescription | |
| stockunit | String | Stockunit | |
| storecatdisplayname | String | Storecatdisplayname | |
| storecatdisplayname2 | String | Storecatdisplayname2 | |
| storecategory | Integer | Storecategory | |
| storecategory2 | Integer | Storecategory2 | |
| storedescription | String | Storedescription | |
| storedetaileddescription | String | Storedetaileddescription | |
| storedisplayimage | String | Storedisplayimage | |
| storedisplayname | String | Storedisplayname | |
| storedisplaythumbnail | String | Storedisplaythumbnail | |
| storeitemtemplate | String | Storeitemtemplate | |
| subsidiary | String | Subsidiary | |
| supersizeimages | Boolean | Supersizeimages | |
| supplyreplenishmentmethod | String | Supplyreplenishmentmethod | |
| supplytimefence | Integer | Supplytimefence | |
| taxable | Boolean | Taxable | |
| taxschedule | String | Taxschedule | |
| templatesgroup | String | Templatesgroup | |
| totalvalue | Decimal | Totalvalue | |
| tracklandedcost | Boolean | Tracklandedcost | |
| transferprice | Decimal | Transferprice | |
| transferpriceunits | String | Transferpriceunits | |
| unitstype | String | Unitstype | |
| upccode | String | Upccode | |
| upperwarninglimit | Double | Upperwarninglimit | |
| urlcomponent | String | Urlcomponent | |
| usebins | Boolean | Usebins | |
| usemarginalrates | Boolean | Usemarginalrates | |
| vendorname | String | Vendorname | |
| vendreturnvarianceaccount | String | Vendreturnvarianceaccount | |
| vsoedeferral | String | Vsoedeferral | |
| vsoedelivered | Boolean | Vsoedelivered | |
| vsoepermitdiscount | String | Vsoepermitdiscount | |
| vsoeprice | Decimal | Vsoeprice | |
| vsoesopgroup | String | Vsoesopgroup | |
| weight | Double | Weight | |
| weightunit | String | Weightunit | |
| weightunits | String | Weightunits | |
| willship | String | Willship | |
| yahooproductfeed | String | Yahooproductfeed |