InventoryItem

Namespace: urn:accounting.lists.webservices.netsuite.com

Fields

NameTypeCardinalityLabelRequiredHelp
accountingBookDetailList ItemAccountingBookDetailList 0..1
alternateDemandSourceItem RecordRef 0..1 For demand planning purposes, choose another item if you want to examine the historical sales of an item other than the one on the current record. When this field is left blank, the source for historical data is the original item. For example, if you are setting up Item A for demand planning, but Item A does not have an extensive sales history, you can choose Item B as an alternate source for historical data. Then, when demand calculations need to be made for Item A, NetSuite uses Item B’s history for the calculations. Note: You can select only an item that is of the same item type to be an alternate source. For example, if the original item is an inventory item, the alternate source item must also be an inventory item.
assetAccount RecordRef 0..1 Asset Account F References an existing asset account at Lists > Accounting > Accounts. In order to retrieve a list of available values for this field, use the GetSelectValue operation.
autoLeadTime boolean 0..1 Auto-Calculate F Lead time is the average number of days between ordering this item from the vendor and receiving it. * Check the Auto-Calculate box if you want NetSuite to calculate the lead time based on the most recent order history of this item. This is calculated by taking the number of days between the order entry and receipt on the three most recent purchase orders, and dividing by three. o If there are multiple receipts for the item against the same purchase order, only the first receipt is used for the calculation. o Lead time calculation is not weighted by number of units received. o More recent purchase orders without receipts are ignored. * Clear the Auto-Calculate box to manually enter a lead time value in days. If the Auto-Calculate box is cleared and no value is entered, then the default value from the Set Up Inventory Management page is used.
autoPreferredStockLevel boolean 0..1 Auto-Calculate F The preferred stock level is the optimum quantity to maintain in stock of an item. Set to true if you want NetSuite to calculate the preferred stock level based on demand for the item. The preferred stock level is calculated as: (daily demand * number of days supply preferred)
autoReorderPoint boolean 0..1 Auto-Calculate F The Reorder Point is the quantity level at which you need to reorder or build more of this item. Set this field to false to manually calculate the point at which to reorder or build more of this item Set this field to true if you want NetSuite to calculate the reorder point based on demand for the item over time. The reorder point depends on the safety stock definition and is calculated as follows: Without safety stock defined: Reorder point = (average lead time days * demand) With safety stock defined in days: Reorder point = [(average lead time days + safety stock days) * demand] With safety stock quantity defined: Reorder point = [(average lead time days * demand) + safety stock quantity)
availableToPartners boolean 0..1 Available to Adv. Partners F If true, this item is available in the Advanced Partner Center.
averageCost double 0..1 Average Cost F This field displays the current average cost of the item across all locations. Using the weighted-average method, the average cost is calculated as the total units available during a period divided by the beginning inventory cost plus the cost of additions to inventory. Note: The average cost calculated per location is listed for each location on the Locations subtab. If you use Multiple Units of Measure, average cost is calculated using stock units.
backwardConsumptionDays long 0..1 Backward Consumption Days F
billExchRateVarianceAcct RecordRef 0..1 Select the account to post to for variances in exchange rates associated with this item. These variances occur when there are exchange rate differences between the receipt and the bill for an item. Note: After you select a variance account in this field, you can select another account at a later date if a change is necessary. Account changes are noted on the System Notes subtab of the History subtab of item records.
billingSchedule RecordRef 0..1 Billing Schedule F Allows users to reference default Billing Schedules for items. In order to retrieve a list of available values for this field, use the GetSelectValue operation.
billPriceVarianceAcct RecordRef 0..1 Select the account to post to for variances in billing prices associated with this item. These variances occur when there is a difference in the price of an item showing on the purchase order and the price of an item showing on the bill. Note: After you select a variance account in this field, you can select another account at a later date if a change is necessary. Account changes are noted on the System Notes subtab of the History subtab of item records.
billQtyVarianceAcct RecordRef 0..1 Select the account to post to for variances in billing quantities associated with this item. These variances occur when there is a difference in the quantity of an item showing on the receipt and the quantity of an item showing on the bill. Note: After you select a variance account in this field, you can select another account at a later date if a change is necessary. Account changes are noted on the System Notes subtab of the History subtab of item records.
binNumberList InventoryItemBinNumberList 0..1
class RecordRef 0..1 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 RecordRef 0..1 COGS Account F References an existing COGs account at Lists > Accounting > Accounts. In order to retrieve a list of available values for this field, use the GetSelectValue operation.
copyDescription boolean 0..1 Copy from Sales Order F Sets the description from a sales order.
cost double 0..1 Purchase Price F 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 RecordRef 0..1 Select a cost category to associate with this item. View existing cost categories at <_TABNAME=LIST_ACCOUNTINGOTHERLIST_> > <_TASKCATEGORY= LIST_ACCOUNTINGOTHERLIST_> > Accounting Lists > Cost Category. For more details, click Help and read Creating Cost Categories.
costEstimate double 0..1 Item Defined Cost F A user-defined amount, entered into the Item Defined Cost field on the Item definition page.
costEstimateType ItemCostEstimateType 0..1 Cost Estimate Type F The Cost Estimate Type determines what value NetSuite uses to calculate estimated Gross Profit. The estimated Gross Profit for Items on a transaction provides the data needed to calculate the total estimated Gross Profit on that transaction. The individual line items that you enter in a transaction determine the amounts that post in NetSuite when you process that transaction. The following Cost Estimate Types on Items are available: * Item Defined Cost - a user-defined amount, entered into the Item Defined Cost field on the Item definition page. * Average Cost - NetSuite calculates an average cost of the units purchased. With Multi-Location Inventory enabled, NetSuite calculates the average across all locations. Otherwise, the average calculation uses location-specific costs. * Last Purchase Price - This field displays the most recent purchase price of the item as determined by purchase order receipt transactions. If you make multiple purchases on the same day that use different rates, this field shows the highest purchase price on that day, per location if applicable. When you use the Multiple-Location Inventory feature, the last purchase price reflects the most recent receipt at any location. If you track Cost of Goods Sold (COGS), NetSuite identifies the cost of the item based on your COGS settings. * Purchase Price - Enter the price that you pay for this item. If you do not enter a price, then the most recent purchase price from purchase orders provides the price for this item by default. * Preferred Vendor Rate - This option is only meaningful if the Multi-Vendor feature is enabled and multiple vendors supply the same item. In order of precedence: o Preferred vendor rate, if defined on the Item record Purchase price o Purchase Order Rate - Initially uses the Preferred Vendor Rate cost, and then after a purchase order is entered, this type uses the most recent actual purchase order rate. Special orders and drop-shipped items use this cost information. * Derived from Member Items - Total costs of items currently included in a kit. This Cost Estimate Type only applies to kits and sums the estimated costs of each item in the kit, based on each of their individual Cost Estimate Types. Uses the latest definition of the kit, not its historical definition.
costEstimateUnits string 0..1
costingMethod ItemCostingMethod 0..1 Costing Method F Because the costingMethod field becomes read-only when set, it is not returned in get and basic search operations. Instead, the read-only field costingMethodDisplay is returned. The costingMethod field can be used only for addRecord operations and in searches.
costingMethodDisplay string 0..1 Costing Method F This is a read-only value that returns the costing method for the item. Because the costingMethod field becomes read-only when set, it is not returned in get and basic search operations. Instead, the read-only field CostingMethodDisplay is returned.
costUnits string 0..1
countryOfManufacture Country 0..1 Manufacturer Country F References a value in a system list. Values are listed at platformCommonTyp:Country.
createdDate dateTime 0..1 Date Created F When adding a record, this field defaults to the current system date and time. This field cannot be overwritten. The default value is set regardless of any use default settings.
createRevenuePlansOn ItemCreateRevenuePlansOn 0..1 Create Revenue Plans On F Select the event that triggers creation of revenue recognition plans. Match the event with the amount source of the item's revenue recognition rule. * Revenue Arrangement Creation - Revenue plans can be created when the revenue arrangement is created. Use this option with rules that have Event-Amount as the Amount Source. * Billing - Revenue plans can be created when the sales order is billed and from stand-alone cash sales, invoices, credit memos, and cash refunds. Use this option with rules that have Event-Percent based on amount as the Amount Source. * Fulfillment - This option is available only when Advanced Shipping is enabled. Revenue plans can be created upon fulfillment. Use this option with rules that have Event-Percent based on quantity as the Amount Source. * Project Progress - This option is available only when the Projects feature is enabled. Use this option with rules that have Event-Percent Complete as the Amount Source.
currency string 0..1 Currency F 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.
customFieldList CustomFieldList 0..1
customForm RecordRef 0..1 Custom Form F References an existing custom form for this record type. To ensure that field relationships defined within a desired custom form are maintained, you must provide the customForm value. Also, if defaults are off, then customForm is required, if defaults are on then the default form is used. Internal ID values for existing forms can be found at Setup > Customization > Entry Forms. In order to retrieve a list of available values for this field, use the GetSelectValue operation.
dateConvertedToInv dateTime 0..1
defaultItemShipMethod RecordRef 0..1 Default Shipping Method F Select the shipping method to display by default when adding the item to a sales order. You can override the default shipping method and enter any shipping method when fulfilling an order.
defaultReturnCost double 0..1
deferredRevenueAccount RecordRef 0..1 Deferred Revenue Account F Set the deferred revenue account to associate with this item. Then, when this item is sold and associated with a revenue recognition template, the revenue from the sale is deferred. The sale amount is posted to a deferred revenue account, as opposed to a standard income account. In order to retrieve a list of available values for this field, use the GetSelectValue operation.
deferRevRec boolean 0..1 Hold Revenue Recognition F Check this box to delay recognizing revenue from the sale of this item. When this box is check, revenue recognition schedules or revenue plans are created with the status On Hold. For more information, see the help topic Delaying Revenue Recognition for an Item.
demandModifier double 0..1 Estimated Demand Change F Set the default percentage of expected demand change to use for calculating item demand. For example, if you know that new customers will increase sales of this item in the future, you can enter 10% expected demand change to be added on to previous sales totals. If no expected demand change percentage is set, then the default value from the Set Up Inventory Management page is used.
demandSource RecordRef 0..1 Demand Source F
demandTimeFence long 0..1 Demand Time Fence F
department RecordRef 0..1 Set a department to associate with this item. For details on existing department records, in the UI go to Setup > Company > Departments.
displayName string 0..1 Display Name/Code F You can set an optional name for this item in addition to the item name. If you are integrating with a Yahoo! store, this field is imported from Yahoo!. The display name prints in the Item column of the sales form. If this item is a member of a kit, this name appears in the Item column when the Print Items box is checked. If you do not set a display name, then item name appears on printed forms.
distributionCategory RecordRef 0..1 Distribution Category F Choose the appropriate category. Once a distribution category is defined on the item record, NetSuite can incorporate network transfers into demand planning for the item. Note: The network and category you select must be associated with the subsidiary selected for the item in the Classifications section of the item record. For details about how categories are associated with subsidiaries, click Help and read Creating Distribution Categories.
distributionNetwork RecordRef 0..1 Distribution Network F Choose the appropriate network. The network you select determines the distribution categories available for you to choose. If the distribution network field is blank, then distribution category must also be blank. Note: The network and category you select must be associated with the subsidiary selected for the item in the Classifications section of the item record. For details about how networks are associated with subsidiaries, click Help and read Creating a Distribution Network.
dontShowPrice boolean 0..1 Don't Show Price F Check this box to hide the price of this item online. This is useful for items you want to advertise but don't want to sell or for items that you track inventory for and want to display but are offered in combination with other items.
dropshipExpenseAccount RecordRef 0..1 Dropship expense account F When the Automated Intercompany Drop Ship feature is enabled, this field defaults to the account specified in the Default Expense Account on Accounting Preference page, but you can override this account. The account you select must have the Eliminate Intercompany Transactions box checked.
enforceMinQtyInternally boolean 0..1 Enforce Internally F Check this box to only allow sales orders created in NetSuite to be submitted when the minimum quantity of this item is ordered. When the item is selected on a sales order, the quantity is set to the minimum by default. If the quantity is edited below the minimum amount, an alert pops up, and the item cannot be added to the order. When you clear this box but enter a number in the Minimum Quantity field, the minimum only applies in the Web store.
excludeFromSitemap boolean 0..1 Exclude from Sitemap F Check this box to exclude a tab, category or item page from the site map.
expenseAccount RecordRef 0..1 Expense Account F In order to retrieve a list of available values for this field, use the GetSelectValue operation.
featuredDescription string 0..1 Featured Description F Settable only if item is featured. You can provide letters, numbers and basic HTML code.
fixedLotSize double 0..1 Fixed Lot Size F
forwardConsumptionDays long 0..1 Forward Consumption Days F
fraudRisk InventoryItemFraudRisk 0..1 Fraud Risk F Choose the fraud risk level for this item. This setting is used by the CyberSource Decision Manager when determining which transactions might be fraudulent.
gainLossAccount RecordRef 0..1 When the Use Item Cost as Transfer Cost preference is disabled, the transfer price on a transfer order is used as the item cost on the item receipt. Any difference between the actual cost and the transfer price posts to a Gain/Loss account when the item is shipped. In this field, select the Gain/Loss account you prefer to use to post transfer cost discrepancies. The account you select must be different than the Asset or Cost of Goods Sold (COGS) account for the item. You can choose an Income account, Other Income account, Expense account, or Other Expense account. Note: If you have enabled the Expand Account Lists preference, you can choose any account in this field. If you leave this field blank or select Use Income Account, then the income account for the item is used.
handlingCost double 0..1 Handling Cost F As an option, you set a handling cost for this item in dollars. You must also create a shipping item for per-item shipping and handling costs at Lists > Accounting > Shipping Items > New. When this item is set on sales orders, invoices or cash sales, the appropriate shipping and handling charges are automatically calculated.
handlingCostUnits string 0..1
hazmatHazardClass string 0..1 Enter the DOT hazardous material class or division.
hazmatId string 0..1 Enter the regulatory identifier for the commodity from the Federal Express Ground Hazardous Materials Shipping Guide. The format is UNXXXX, where XXXX is a four digit number.
hazmatItemUnits string 0..1 Enter the unit of measure for this item, such as kg or ml.
hazmatItemUnitsQty double 0..1 Enter the quantity for the item units.
hazmatPackingGroup HazmatPackingGroup 0..1 Select the hazardous material packaging group for the item.
hazmatShippingName string 0..1 Enter the shipping name for the ID as listed in the Federal Express Ground Hazardous Materials Shipping Guide. This item appears on the OP950 form.
includeChildren boolean 0..1 Include Children F Check the Include Children box to share the item with all the sub-subsidiaries associated with each subsidiary selected in the Subsidiary field. Note: When sharing items across subsidiaries, all of the options selected on the item record must be compatible across subsidiaries. For example, when entering an inventory item to be shared across subsidiaries, you should select Income and Asset accounts on the item record that are also shared across the same subsidiaries.
incomeAccount RecordRef 0..1 Income Account F References an existing income account at Lists > Accounting > Accounts. In order to retrieve a list of available values for this field, use the GetSelectValue operation.
intercoCogsAccount RecordRef 0..1
intercoIncomeAccount RecordRef 0..1
invtClassification ItemInvtClassification 0..1 Classification F
invtCountInterval long 0..1
isDonationItem boolean 0..1 Variable Amount F If true, the item is set as a variable-priced donation item. This enables customers to enter their own prices for this item, such as for donations.
isDropShipItem boolean 0..1 Drop Ship Item F If isDropShipItem is set to true, isSpecialOrderItem can NOT be true.
isGcoCompliant boolean 0..1 Google Checkout Compliant F Check this box to make the item available for purchase with Google Checkout.
isHazmatItem boolean 0..1 Check this box if this item is categorized as either hazardous material or dangerous goods. These items can only be shipped using FedEx integration.
isInactive boolean 0..1 Inactive F Sets the item as inactive. By default, this field is set to false.
isOnline boolean 0..1 Display in Web Site F Set to true to make this item available online in your Web site. You cannot sell this item online unless this field is set to true.
isSpecialOrderItem boolean 0..1 Special Order Item F If isSpecialOrderItem is set to true, isDropShipItem can NOT be true.
issueProduct RecordRef 0..1 Product F Select the product this item is associated with. Product records are tracked with versions and builds for issue management. To create product records, go to <_TABNAME=ADMI_ISSUEPRODUCT_> > <_TASKCATEGORY=ADMI_ISSUEPRODUCT_> > Products > New.
isTaxable boolean 0..1 Taxable F Check this box if the item is subject to sales tax.
itemCarrier ShippingCarrier 0..1 Carrier F Select the default shipping carrier for the item.
itemId string 0..1 Item Name/Number T Type up to 60 characters for the name of this item. This name appears in lists on transactions. If you have the option of entering a display name and do not, the item name prints in the Item column of sales forms. If you have the option to enter a vendor name and do not, the item name prints in the Item column of purchase forms. If you have entered a display name, it will print on purchases instead of the item name.
itemOptionsList ItemOptionsList 0..1 Provides a list of custom options available for this item. Transaction item options must first be defined at Setup > Customization > Transaction Item Options
itemRevenueCategory RecordRef 0..1 Item Revenue Category F The item revenue category is a classification for items that have similar characteristics and revenue allocation requirements. It is used in the fair value price list.
itemShipMethodList RecordRefList 0..1
itemVendorList ItemVendorList 0..1
lastInvtCountDate dateTime 0..1
lastModifiedDate dateTime 0..1 Last Modified F
lastPurchasePrice double 0..1 Last Purchase Price F This field displays the most recent purchase price of the item. This price is determined by the most recent transaction for the item that added positive inventory, such as a purchase receipt, inventory transfer or inventory adjustment. (This does not include item returns or assembly unbuilds.) If two transactions are entered on the same day, the one entered later takes precedence and is used to calculate the last purchase price. When you use the Multiple-Location Inventory feature, the following is true: * The last purchase price reflects the most recent transaction at any location. * The Inventory subtab of inventory item records includes a link to the last positive-inventory transaction per location. * If multiple purchases are made on the same day with different prices and locations, then the highest price paid on that day becomes the last purchase price. If you use Multiple Units of Measure, the last purchase price is calculated using purchase units.
leadTime long 0..1 Lead Time F Lead time is the average number of days between ordering this item from the vendor and receiving it. * Auto-Calculating &#x2013; Check the Auto-Calculate box if you want NetSuite to calculate the lead time based on the most recent order history of this item. Lead time is calculated by taking the number of days between the order entry and receipt on the three most recent purchase orders, and dividing by three. If more than three purchase orders exist, all purchase orders within the period specified in the Order Analysis Interval field on the Inventory Management Preferences dialog will be used. o If there are multiple receipts for the item against the same purchase order, the calculation is made using the difference between the purchase order and the last receipt (the receipt that fully receives the order). o Lead time calculation is not weighted by number of units received. o More recent purchase orders without receipts are ignored. * Manually Calculating &#x2013; Clear the Auto-Calculate box to manually enter a lead time value in days. If the Auto-Calculate box is cleared and no value is entered, then the default value from the Set Up Inventory Management page is used.
location RecordRef 0..1
locationsList InventoryItemLocationsList 0..1
manufacturer string 0..1 Manufacturer F Type the name of the company that manufactures this item.
manufacturerAddr1 string 0..1 Manufacturer Address F Set the address of the manufacturer. This is necessary to fill out international shipping forms when you sell and ship this item.
manufacturerCity string 0..1 Manufacturer City F Set the city location of the manufacturer of this item. This is necessary to automatically fill out international forms when you ship this item across borders.
manufacturerState string 0..1 Manufacturer State F Set the state where this item's manufacturer is located.
manufacturerTariff string 0..1 HS Tariff Number F Set the Harmonized System (HS) tariff code number or the Harmonized Tariff Schedule (HTS) code number. This number should be six to ten characters.
manufacturerTaxId string 0..1 Manufacturer Tax Id F Enter the Tax ID Number (TIN) for the manufacturer.
manufacturerZip string 0..1 Manufacturer Zip Code F Set the postal code of the location of this manufacturer.
matchBillToReceipt boolean 0..1 Check the Match Bill to Receipt box if you want the Match Bill to Receipt box on transaction lines to be checked by default for this item. This enables you to generate variances based on vendor bill lines. Then, on the Post Vendor Bill Variances page, you must select Bill in the Transaction Type field to generate the variance postings. Purchase orders that include this item default to have this box checked and variances are generated based on vendor bill lines. Clear this box if you want to generate variance postings based on purchase order lines rather than vendor bill lines and do not want the Match Bill to Receipt box to be checked by default on transaction lines for this item. Then, on the Post Vendor Bill Variances page, you must select Purchase Order in the Transaction Type field to generate the variance postings. This preference defaults to be disabled. Even when enabled, this option can be changed on individual purchase order lines.
matrixItemNameTemplate string 0..1 This field is used to control how the matrix item will be displayed in the Matrix Item Name/Number field. Compose the order in which attributes and matrix options are displayed by selecting from the Insert Item Attribute and Insert Matrix Option dropdown lists. Add custom separator characters to easier distinguish the various options. Example: Item Name: Fabric / Color / Waist / Length [Location]
matrixOptionList MatrixOptionList 0..1
matrixType ItemMatrixType 0..1 Matrix Type F
maxDonationAmount double 0..1 Maximum Variable Amount F If isDonationItem is set to true, set this field to the maximum amount that can be paid or donated for this item.
metaTagHtml string 0..1 Meta Tag HTML F Sets the metatag information for the item page in web store.
minimumQuantity long 0..1 Minimum Order Qty F Enter the smallest quantity you allow customers to purchase for this item. When customers add this item to their carts in the Web store, the quantity for this item is defaulted to the minimum number of items. Leave this field empty to allow customers to check out with no minimum quantity restrictions.
minimumQuantityUnits string 0..1
mpn string 0..1 Manufacturer Part Number F MPN (Manufacturers Part Number) - Set the part number used by the manufacturer to identify this item.
multManufactureAddr boolean 0..1 Multiple Manufacturer Addresses F
nexTagCategory string 0..1 NexTag Category F Set 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. This is an optional field only displayed for the following item records: Kit/Package, Non-inventory Item for Sale, Non-inventory Item for Resale, Assembly (lot and serialized), and Inventory (lot and serialized).
nextInvtCountDate dateTime 0..1
noPriceMessage string 0..1 No Price Message F If you opted to not show a price online, enter the message that should show instead of the price. For example, you might enter "Call for Price."
offerSupport boolean 0..1 Offer Support F When enabled, items can be referenced on case records either through the UI or via web services using the item field.
onHandValueMli double 0..1 Value F A read-only field that returns the result of Quantity on Hand multiplied by Purchase Price.
onSpecial boolean 0..1 On Special F Set to true if you want to put this item on special. The item then appears in the Specials category in your store or site.
originalItemSubtype ItemSubType 0..1
originalItemType ItemType 0..1
outOfStockBehavior ItemOutOfStockBehavior 0..1 Out Of Stock Behavior F Select a custom out of stock behavior for this item. It overwrites the overall site&#x2019;s out of stock behavior. Your choices are: * Default - Uses the behavior selected in the Web Store Out of Stock Items field at Setup > Web Site > Setup Tasks > Set Up Web Site > Shopping. * Disallow back orders but display out of stock messages * Allow back orders but display out of stock messages * Remove items when out of stock * Allow back orders with no out of stock message
outOfStockMessage string 0..1 Out Of Stock Message F You can enter a custom out of stock message for this item. The message here replaces the default out of stock message.
overallQuantityPricingType ItemOverallQuantityPricingType 0..1 Calculate Quantity Discounts F Available values are: _byLineQuantity _byOverallItemQuantity _byOverallParentQuantity _byOverallScheduleQuantity
pageTitle string 0..1 Page Title F Sets the display title in the upper-left corner of an Internet browser when customers view this item in your Web store.
parent RecordRef 0..1 Subitem of F 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.
periodicLotSizeDays long 0..1 Periods of Supply Increment F
periodicLotSizeType PeriodicLotSizeType 0..1 Periods of Supply Type F
preferenceCriterion ItemPreferenceCriterion 0..1 Preference Criterion F Set the NAFTA criterion for this item. Available values are: _A _B _C _D _E _F
preferredLocation RecordRef 0..1 Preferred {1} F References an existing location record at Setup > Company > Classifications > Locations. This is only settable if the Multi-Location Inventory feature is enabled at Setup > Company > Setup Tasks > Enable Features > Items & Inventory. In order to retrieve a list of available values for this field, use the GetSelectValue operation.
preferredStockLevel double 0..1 Preferred Stock Level F Enter the quantity you prefer to maintain in inventory. NetSuite uses this information to calculate how many items to replenish on the Order Items page.
preferredStockLevelDays double 0..1 Days F The preferred stock level is the optimum quantity to maintain in stock of an item. The quantity you enter here is used to determine your replenishment needs on the Order Items page. It is the quantity you want to have in stock after an order is placed. * Auto-Calculating &#x2013; Check the Auto-Calculate box if you want NetSuite to calculate the preferred stock level based on demand for the item. The preferred stock level is calculated as: (daily demand * number of days supply preferred). If no preferred stock level is identified, then the default preferred stock level is used from the Set Up Inventory Management page. * Manually Calculating &#x2013; Clear the Auto-Calculate box to manually enter the preferred stock quantity. The preferred stock level you set is used to calculate the quantity of items to be ordered on the Order Items page.
preferredStockLevelUnits string 0..1
presentationItemList PresentationItemList 0..1
pricesIncludeTax boolean 0..1 Prices Include Tax F Check this box to save the base price as the tax inclusive price. Clear this box to save the base price as the tax exclusive price.
pricingGroup RecordRef 0..1 Pricing Group F Select the pricing group this item is a member of. Using pricing groups allows you to assign customer-specific price levels for a group of items. You can create new pricing groups at <_TABNAME=EDIT_OTHERLIST_> > <_TABNAME=EDIT_OTHERLIST_> > Accounting Lists > New > Pricing Group.
pricingMatrix PricingMatrix 0..1 Sets the pricing matrix for this item.
producer boolean 0..1 Producer F Set to true if you produce this item for the purposes of the NAFTA Certificate of Origin.
productFeedList ProductFeedList 0..1 Set the sites where you want to export information on this item. Available values are: _googleBase _nexTag _shoppingCom _shopzilla _yahooShopping This is an optional field only displayed for the following item records: Kit/Package, Non-inventory Item for Sale, Non-inventory Item for Resale, Assembly (lot and serialized), and Inventory (lot and serialized).
purchaseDescription string 0..1 Purchase Description F Sets the description of this item that is displayed on vendor orders. You should include the unit of measure in this description.
purchaseOrderAmount double 0..1 Vendor Bill - Purchase Order Amount Tolerance F Enter the tolerance limit for the discrepancy between the amount on the vendor bill and purchase order.
purchaseOrderQuantity double 0..1 Vendor Bill - Purchase Order Quantity Tolerance F Enter the tolerance limit for the discrepancy between the quantity on the vendor bill and purchase order.
purchaseOrderQuantityDiff double 0..1 Vendor Bill - Purchase Order Quantity Difference F Enter the difference limit for the discrepancy between the quantity on the vendor bill and purchase order.
purchasePriceVarianceAcct RecordRef 0..1 In the Purchase Price Variance Account field, choose the account to post a variance to when a purchase transaction calculates a cost variance.
purchaseTaxCode RecordRef 0..1 Purchase Tax Code F This field is required for customers subscribing to International versions of NetSuite. Sets the default tax code to be used on purchase transactions. In order to retrieve a list of available values for this field, use the GetSelectValue operation.
purchaseUnit RecordRef 0..1 {1} Units F Select the unit you use to purchase this item from the vendor.
quantityAvailable double 0..1 Quantity Available F
quantityAvailableUnits string 0..1
quantityBackOrdered double 0..1 Quantity Back Ordered F A read-only field that returns the Quantitiy Back Ordered.
quantityCommitted double 0..1 Quantity Committed F A read-only field that returns the Quantitiy Committed.
quantityCommittedUnits string 0..1
quantityOnHand double 0..1 Quantity On Hand F Sets the quantity on hand for this item. This is settable only on an add. Otherwise this is a read-only field that provides the known quantity on hand based on items received.
quantityOnHandUnits string 0..1
quantityOnOrder double 0..1 Quantity On Order F A read-only field that returns the Quantitiy on Order.
quantityOnOrderUnits string 0..1
quantityPricingSchedule RecordRef 0..1 Schedule F Set the pricing schedule you want to use to set prices for this item. You can create new pricing schedules at Lists > Accounting > Quantity Pricing Schedules > New. Selecting a pricing schedule sets the Use Marginal Rates and Calculate Quantity Discounts fields.
quantityReorderUnits string 0..1
rate double 0..1 Sales Price F Defines the rate for this item. If a value is entered followed by the percentage sign, the discount is interpreted as a percentage discount (i.e. -.10% sets a ten percent discount for the item). If a value without the percentage sign is entered, the rate is interpreted as a flat dollar value.
receiptAmount double 0..1 Vendor Bill - Item Receipt Amount Tolerance F Enter the tolerance limit for the discrepancy between the amount on the vendor bill and item receipt.
receiptQuantity double 0..1 Vendor Bill - Item Receipt Quantity Tolerance F Enter the tolerance limit for the discrepancy between the quantity on the vendor bill and item receipt.
receiptQuantityDiff double 0..1 Vendor Bill - Item Receipt Quantity Difference F Enter the difference limit for the discrepancy between the quantity on the vendor bill and item receipt.
relatedItemsDescription string 0..1 Related Items Description F Sets the description displayed for a group of related items.
reorderMultiple long 0..1 Reorder Multiple F Enter the quantity you prefer to order of this item each time. Then, the Order Items page suggests ordering a quantity of this item that is always a multiple of the number you enter. For example, if the vendor only accepts orders in multiples of one thousand, you would enter 1000 in this field. Then, the Order items page might suggest that you order 1000 or 2000, but not 1500. Note: If you use the Multiple Units of Measure feature, the reorder multiple always functions in base units.
reorderPoint double 0..1 Reorder Point F Sets the minimum quantity that when reached triggers a warning to reorder or rebuild this item.
reorderPointUnits string 0..1
rescheduleInDays long 0..1 Reschedule In Days F
rescheduleOutDays long 0..1 Reschedule Out Days F
revenueAllocationGroup RecordRef 0..1 Revenue Allocation Group F Select a revenue allocation group to use in GroupSum functions in fair value formulas. The value you select here is the default. You can change it on the revenue element.
revenueRecognitionRule RecordRef 0..1 Revenue Recognition Rule T Select the revenue rule to use by default for this item in a revenue arrangement. Be sure the rule you select has an Amount Source that is appropriate for the value you select in the Create Revenue Plans On field. For more information, see the field level help for Create Revenue Plans On.
revRecSchedule RecordRef 0..1 Revenue Recognition Template F Sets the revenue recognition template that will be applied to this item. In order to set this field, the item record referenced in the item field must have a deferred revenue account associated with it. This field then defaults to the rev. rec. template associated to the item on the item record. In order to retrieve a list of available values for this field, use the GetSelectValue operation.
roundUpAsComponent boolean 0..1 Round Up Quantity as Component F If you use the component yield preference, depending on your settings, the component yield calculation may result in a fractional quantity. You can use this setting so that the quantity for a component on a work order automatically rounds up to a whole number in base units. For example, you have an assembly that requires 2 units of Component A. The component yield is 99%. To build 5 of these assemblies requires 10.1 units of Component A. Since you can consume components only in whole numbers, you cannot consume 10.1 units. Therefore, you need to round up to the next highest whole number in base units. Check the Round Up Quantity as Component box to enable NetSuite to round up the quantity consumed for this item. Clear this box if you do not want NetSuite to round up the quantity consumed for this item.
safetyStockLevel double 0..1 Safety Stock Level F Enter the amount of an item you prefer to keep in stock at all times. Safety stock can be a quantity or a number of days worth of stock. This amount is used to auto-calculate the reorder point of an item. * To define safety stock as a quantity, enter a value. * To define safety stock as a number of days, enter a value in the field next to Days. If no safety stock value is entered, then the default value from the Set Up Inventory Management page is used.
safetyStockLevelDays long 0..1 Days F Enter the amount of an item you prefer to keep in stock at all times. Safety stock can be a quantity or a number of days worth of stock. This amount is used to auto-calculate the reorder point of an item. * To define safety stock as a quantity, enter a value. * To define safety stock as a number of days, enter a value in the field next to Days. If no safety stock value is entered, then the default value from the Set Up Inventory Management page is used.
safetyStockLevelUnits string 0..1
salesDescription string 0..1 Sales Description F Sets the description displayed when an item's store display name is clicked.
salesTaxCode RecordRef 0..1 Sales Tax Code T This field is required for customers subscribing to International versions on NetSuite. Sets the default tax code to be used on sales transactions. In order to retrieve a list of available values for this field, use the GetSelectValue operation.
saleUnit RecordRef 0..1 {1} Units F Select the unit you use to sell this item to customers on sales transactions.
scheduleBCode ScheduleBCode 0..1 Select the code for the Schedule B form for this item. Available values are: _1000, _1000cubicMeters, _barrels, _carat, _cleanYieldKilogram, _contentKilogram, _contentTon, _cubicMeters, _curie, _dozen, _dozenPairs, _dozenPieces, _fiberMeter, _gram, _gross, _grossContainers, _hundred, _kilogram, _kilogramTotalSugars, _liter, _meter, _millicurie, _noQuantityReq, _number, _pack, _pairs, _pieces, _proofLiter, _runningBales, _square, _squareCentimeters, _squareMeters, _ton
scheduleBNumber string 0..1 Schedule B Number F Enter the number for the Schedule B form for this item.
scheduleBQuantity long 0..1 Schedule B Quantity F Enter the quantity for the Schedule B form for this item.
searchKeywords string 0..1 Search Keywords F Enter alternative search keywords that customers might use to find this item using your Web store&#xfffd;s internal search. These can include synonyms, acronyms, alternate languages or misspellings. These keywords are seen as equally important as the item name when searches are conducted.
seasonalDemand boolean 0..1 Seasonal Demand F This setting defines the way NetSuite analyzes customer demand for this item. Customer demand for an item is used to auto-calculate reorder points and preferred stock levels. An item&#x2019;s demand rate is calculated as the average sales quantity per day. * Historical Demand &#x2013; Clear the Seasonal Demand box if you prefer to calculate the demand as average sales per day over a specific period. To set the number of months interval between analysis to evaluate sales orders and calculate item demand, go to Setup > Accounting > Set Up Inventory Management > Order Analysis Interval field. * Seasonal Demand &#x2013; Check the Seasonal Demand box to calculate the reorder quantity for this item based on inventory demand changes through the year. To set the number of months interval between analysis to evaluate sales orders and calculate item demand, go to Setup > Accounting > Set Up Inventory Management > Order Analysis Interval field.
shipIndividually boolean 0..1 Ships Individually F Check this box if this item always ships alone and with no other items in the same package. This helps determine the number of packages needed and the shipping rate on order fulfillments.
shipPackage RecordRef 0..1 Package F Select the type of package this item normally ships in. The information for this package type automatically fills in on order fulfillments for this item. Setting up and assigning package types helps determine the number of packages on an order and helps return accurate real-time shipping rates. Create package types at Setup > Accounting > Shipping > Packages subtab.
shippingCost double 0..1 Shipping cost F As an option, you may set a shipping cost for this item in dollars. You must also create a shipping item for per-item shipping costs at Lists > Accounting > Shipping Items > New. When this item is set on sales orders, invoices or cash sales, the appropriate shipping charges are automatically calculated.
shippingCostUnits string 0..1
shoppingDotComCategory string 0..1 Shopping.com Category F Set 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. This is an optional field only available for following item records: Kit/Package, Non-inventory Item for Sale, Non-inventory Item for Resale, Assembly (lot and serialized), and Inventory (lot and serialized).
shopzillaCategoryId long 0..1 Shopzilla Category ID F Set 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. This is an optional field only displayed for the following item records: Kit/Package, Non-inventory Item for Sale, Non-inventory Item for Resale, Assembly (lot and serialized), and Inventory (lot and serialized).
showDefaultDonationAmount boolean 0..1 Show Default Amount F Can only be set when isDonation is set to True. If true, the item's online price is displayed as a suggested price.
siteCategoryList SiteCategoryList 0..1
sitemapPriority SitemapPriority 0..1 Sitemap Priority F Use the Sitemap Priority list to indicate the relative importance of your Web site URLs. You can select a priority ranging from 0.0 to 1.0 on item, category, and tab records. NetSuite assigns the default priority &#x201c;Auto&#x201d; to all new and existing tab, category and item records in your account. The priority is calculated based on the position of the item or category in the hierarchy of your Web site. For example, your Web site tabs automatically generate a default priority value of 1.0 because they are top level pages. A category published to a tab gets a priority of 0.5. An item published to a category on a tab gets a priority of 0.3.
softDescriptor RecordRef 0..1 Soft Descriptor F Select the brand name or name that should appear on customers' credit card statements when this item is purchased. Enter soft descriptors to select in this field at Setup > Accounting > Payment Processing > Credit Card Soft Descriptors.
specialsDescription string 0..1 Specials Description F Settable only if onSpecial is set to True. You can provide letters, numbers and basic HTML code.
stockDescription string 0..1 Stock Description F Enter up to 21 characters to specify information about this item, such as New, Refurbished or Ships 2-3 days.
stockUnit RecordRef 0..1 {1} Units F Select the unit you use to stock this item in inventory.
storeDescription string 0..1 Store Description F Sets the item description. This field can contain plain text as well as basic html code.
storeDetailedDescription string 0..1 Detailed Description F Sets the detailed item description. This field can contain plain text as well as basic html code.
storeDisplayImage RecordRef 0..1 Item Display Image F References an existing image file in the file cabinet. In order to retrieve a list of available values for this field, use the GetSelectValue operation.
storeDisplayName string 0..1 Store Display Name F Sets the item name for your Web site.
storeDisplayThumbnail RecordRef 0..1 Item Display Thumbnail F References an existing image file in the file cabinet. In order to retrieve a list of available values for this field, use the GetSelectValue operation.
storeItemTemplate RecordRef 0..1 Item Drilldown Template F References an existing item template at Setup > Web Site > Item/Category Templates.
subsidiaryList RecordRefList 0..1
supplyLotSizingMethod RecordRef 0..1 Lot Sizing Method F
supplyReplenishmentMethod RecordRef 0..1 Choose a method to use for calculating item replenishment requirements: * Reorder Point &#x2013; Choose this setting to use Advanced Inventory Management settings for demand calculations instead of using Demand Planning. This is the default setting for new item records. Orders are created based on replenishment reminders generated from the Order Items page, Replenish Items, and Mass Create Work Orders. * Time Phased &#x2013; When you choose this setting, orders are created based on item demand plans instead of the Advanced Inventory Management settings. When you choose this setting, other fields on the record that are used by Advanced Inventory Management to calculate demand are no longer available. These unavailable fields are: Seasonal Demand, Build Point, Reorder Point, Preferred Stock Level, Safety Stock Days. The Auto calculate settings are cleared and cannot be changed for Demand Per Day, Reorder Point, Preferred Stock Level, Lead Time.
supplyTimeFence long 0..1 Planning Time Fence F
supplyType RecordRef 0..1 Supply Type F
taxSchedule RecordRef 0..1 Schedule T
totalValue double 0..1 Total Value F By default this field is the result of multiplying the purchase price by the quantity on hand. If the Multi-Location Inventory feature is enabled, the sum of this result for each location populates this field by default.
trackLandedCost boolean 0..1 Track Landed Cost F Set to true to track landed costs associated with this item. Note: You must include an item that tracks landed costs on transactions you want to source for landed costs.
transferPrice double 0..1 Enter a transfer price on an item record to set the default value used as the transfer price on transfer orders. You can still override this default by entering a new transfer price for an item on the transfer order. The use of the value in the Transfer Price field on a transfer order depends on your setting for the Use Item Cost as Transfer Cost preference. When the Use Item Cost as Transfer Cost preference is enabled, the transfer price on a transfer order is not considered for posting cost accounting of line items. In the Transfer Price field, enter a declared value for the item to be used for shipping purposes only. When the Use Item Cost as Transfer Cost preference is disabled, the transfer price on a transfer order is considered for posting cost accounting of line items. Items that do not have a transfer price set on a transfer order use a zero value for cost accounting calculations when the item is received. Note: If the Transfer Price field is blank on the item record, a value of zero shows by default on the transfer order. Unless a transfer price value is entered on the transfer order, a value of zero is used for COGS calculations when the item is received.
translationsList TranslationList 0..1
unitsType RecordRef 0..1 Units Type F In order to retrieve a list of available values for this field, use the GetSelectValue operation.
upcCode string 0..1 UPC Code F Defines whether this is a unv part code. Bar codes for items are generated in Code 128 by default. If you prefer to use the UPC code format, set this field to True on each item record.
urlComponent string 0..1 URL Component F Enter a short, descriptive name for this item to appear as part of its URL in the Web store. Setting a name to show in the URL can result in better ranking from search engines. If you leave this field blank, NetSuite terms and numbers are used as identifiers in the URL. Note: Descriptive URL components are case sensitive. Descriptive URLs must match the case used in the URL Component field of an item record to point to the correct page.
useBins boolean 0..1 Use Bins F Set to true if you want to track bin locations for this item. If you choose to use bins for this item, you must associate at least one bin with the item using the Bin Numbers subtab. You can associate multiple items with one bin and multiple bins with one item. You can also designate one preferred bin per location. The preferred bin is listed by default on receipt and fulfillment transactions. To create bin records that can be entered here, go to Lists > Accounting > Bins > New.
useMarginalRates boolean 0..1 Use Marginal Rates F Set to true if you want the quantity discounts in the schedule to be applied to each pricing bracket separately. For example, a schedule offers no discount for the first 100 items sold and a 5% discount if more than 100 are sold. If 150 items are sold, the first 100 are at normal price, and the other fifty items are sold at 5% discount. The fault value is false, which applies the discount to all items sold.
vendor RecordRef 0..1 Preferred {1} F References an existing vendor record. This is required for each vendor being defined. In order to retrieve a list of available values for this field, use the GetSelectValue operation.
vendorName string 0..1 Vendor Name/Code F Sets the preferred vendor for this item. If the Multiple Vendors feature is enabled, this field is unavailable and you must set the preferred vendor in the itemVendorsList.
vsoeDeferral VsoeDeferral 0..1 Deferral F In this field set how to handle deferment when this item is sold as part of a bundle. The available options are: _deferBundleUntilDelivered &#xfffd; Until this item is marked delivered, the revenue recognition of all items in the bundle is deferred. A typical use for this option is to identify items whose revenue recognition depends on the delivery of the item itself, in addition to the delivery of a separate service. For example, a specified upgrade would typically be marked Defer Bundle Until Delivered. _deferUntilItemDelivered &#xfffd; Until this item is marked delivered, the revenue recognition of this item is deferred. This setting is the default for this field. Note: The deferral setting you set for each item in a bundle works together with the deferral settings for other items in the bundle.
vsoeDelivered boolean 0..1 Default as Delivered F Check this box to automatically set this item to a Delivered status when this item is added to a transaction. Clear this box to leave the delivery status clear by default.
vsoePermitDiscount VsoePermitDiscount 0..1 Permit Discount F Set one of the following options to determine how discounts are handled for this item. _asAllowed - Allows a portion of an applicable discount to be applied against this item if its status is Delivered when the VSOE allocation is performed. _never - Does not allow a discount to be applied against this item when the VSOE allocation is performed. This selection would be common for a Specified Upgrade. Note: The default for this field is _asAllowed.
vsoePrice double 0..1 Allocation Price F Set the VSOE price for this item, if the price is known. Note: If you need to use more than one VSOE price for an item, you can set the most common price here and then change the price on each order manually.
vsoeSopGroup VsoeSopGroup 0..1 Select an allocation type to associate with this item on sales transactions. * Normal - Revenue allocation follows EITF 08-01 rules when you use VSOE and the fair value price list with advanced revenue management. * Exclude - This item is excluded from revenue allocation. The item discounted sales amount is the revenue amount. * Software - The item is software. When you use VSOE with the EITF SuiteApp, both EITF 08-01 and SOP 97-2 rules apply for revenue allocation. When you use advanced revenue management, revenue allocation follows the fair value price list. Then if the fair value prices for any of the items in the allocation are estimates rather than VSOE, the allocation is recalculated using the residual method. Note: Do not select the Software value unless you are using VSOE with the EITF SuiteApp or Advanced Revenue Management.
weight double 0..1 Item Weight F Set the weight of this item
weightUnit ItemWeightUnit 0..1 References a value in a system list. Values include: _lb, _oz, _kg, _g.
weightUnits string 0..1

Attributes

NameType
externalId string
internalId string