ODBC Driver for NetSuite

Build 25.0.9434

noninventoryitem

Stores data for non-inventory items, which are products not tracked for quantity in stock.

Columns

Name Type References Description
amortizationperiod Integer The number of periods over which the cost is amortized.
amortizationtemplate String The template used for amortization schedules.
auctionquantity String The quantity of items available in an auction listing.
auctiontype String The type of auction, such as standard or reserve.
availabletopartners Boolean Indicates whether the item is available to partners.
billexchratevarianceacct String The account used for bill exchange rate variance adjustments.
billingschedule String The billing schedule applied to this item.
billpricevarianceacct String The account for tracking price variances on bills.
billqtyvarianceacct String The account for tracking quantity variances on bills.
buyitnowprice Decimal The price at which an item can be purchased immediately in an auction.
class String The classification category assigned to the item.
conditionenabled String Indicates whether item condition settings are enabled.
conditionhelpurl String The URL providing help information about item conditions.
consumptionunit String The unit of measurement for item consumption, such as liters or kilograms.
contingentrevenuehandling Boolean Indicates whether revenue recognition is contingent on conditions being met.
copydescription Boolean Indicates whether the item description is copied from another source.
cost Decimal The base cost of the item.
costcategory String The cost category associated with the item.
costestimate Decimal The estimated cost of the item based on standard calculations.
costestimatetype String The method used to estimate costs, such as standard or average.
costunits String The unit of measurement for cost calculations.
countryofmanufacture String The country where the item was manufactured.
createddate Datetime The date and time when the record was created.
createrevenueplanson String Specifies when revenue plans should be created for this item.
currency String The currency associated with the item's financial transactions.
customform String The custom form used for entering or displaying this record.
deferralaccount String The account used for deferring revenue or expenses.
deferredrevenueaccount String The account used for recognizing deferred revenue.
deferrevrec Boolean Indicates whether revenue recognition should be deferred.
department String The department associated with this item.
directrevenueposting Boolean Indicates whether revenue is posted directly to accounts without deferrals.
displayinebaystore Boolean Specifies whether the item is displayed in an eBay store.
displayname String The name displayed for the item in listings and reports.
dontshowprice Boolean Indicates whether the price should be hidden from customer views.
dropshipexpenseaccount String The account used for expenses related to drop-shipped items.
ebayhandlingtime String The estimated handling time before the item is shipped on eBay.
ebayintlinsurancefee Decimal The international insurance fee for eBay shipments.
ebayintlpackagehandlingfee Decimal The additional handling fee for international shipments on eBay.
ebayintlshipinsurance String Specifies whether international shipping insurance is offered on eBay.
ebayintlshippingitem1 String The first international shipping option for eBay listings.
ebayintlshippingitem2 String The second international shipping option for eBay listings.
ebayintlshippingitem3 String The third international shipping option for eBay listings.
ebayisintlcalculatedrate String Indicates whether international shipping rates are calculated automatically on eBay.
ebayisirregularpackage Boolean Indicates whether the package has irregular dimensions for eBay shipping.
ebayitemdescription String The detailed description of the item as listed on eBay.
ebayitemlocdisplay String The location information displayed on the eBay listing.
ebayitemloczipcode String The ZIP code of the item's location for eBay shipping.
ebayitemlots Integer The number of lots available for this item on eBay.
ebayitemsubtitle String The optional subtitle displayed on the eBay listing.
ebayitemtitle String The main title of the item in eBay listings.
ebayitemweightamt String The weight of the item for eBay shipping calculations.
ebaylayout String The layout template used for displaying the item on eBay.
ebaypackagetype String The type of packaging used for the eBay shipment.
ebaypagecounter String The page counter setting for tracking eBay listing views.
ebayrelistingoption String Specifies whether and how the item should be relisted on eBay.
ebaytheme String The visual theme applied to the eBay listing.
ebaythemegroup String The theme group associated with the eBay listing.
endauctionswhenoutofstock Boolean Indicates whether auctions automatically end when the item is out of stock.
enforceminqtyinternally Boolean Specifies if the system enforces a minimum quantity for transactions.
excludefromsitemap Boolean Indicates whether this item should be excluded from website sitemaps.
expenseaccount String The account used for tracking expenses related to the item.
externalid String An external identifier for integration with other systems.
featureddescription String A highlighted description used for marketing or special display purposes.
froogleproductfeed String Specifies whether the item is included in Google Shopping product feeds.
gallery Boolean Indicates whether the item is displayed in a gallery format.
galleryfeatured Boolean Indicates whether the item is featured in the gallery display.
generateaccruals Boolean Specifies if accruals should be automatically generated for this item.
gifttypeexpressship Boolean Indicates whether express shipping is available for gift orders.
gifttypegiftwrap Boolean Indicates whether gift wrapping is available for this item.
gifttypeshiptorecipient Boolean Indicates whether the gift can be shipped directly to the recipient.
handlingcost Decimal The handling cost associated with shipping this item.
handlingcostunits String The unit of measurement used for handling cost calculations.
handlinggroup String The grouping used for handling charges.
imagesgroup String The image group assigned to this item.
imageslocation String The location where the item's images are stored.
includechildren Boolean Specifies if child items should be included in item listings.
incomeaccount String The income account associated with the item.
intercodefrevaccount String The intercompany deferred revenue account for financial transactions.
intercoexpenseaccount String The intercompany expense account used for cost tracking.
intercoincomeaccount String The intercompany income account for revenue tracking.
internalid Integer The unique system-generated identifier for this record.
iscalculatedrate String Indicates whether the rate is calculated automatically.
isdonationitem Boolean Specifies if this item is designated as a donation item.
isdropshipitem Boolean Indicates whether this item is drop-shipped directly to customers.
isfulfillable Boolean Specifies if this item can be fulfilled through standard order processing.
isgcocompliant Boolean Indicates whether the item complies with Google Checkout requirements.
isinactive Boolean Indicates whether the item is inactive in the system.
isonline Boolean Specifies if the item is available for online sales.
isspecialorderitem Boolean Indicates whether the item is designated for special order fulfillment.
issueproduct String The associated product that is issued as part of this item.
itemcondition String The condition of the item, such as new, used, or refurbished.
itemhandlingfee Decimal The handling fee associated with processing this item.
itemid String The unique identifier for the item in the system.
iteminsurancefee Decimal The fee for insuring the item during shipping.
itemoptions String The available options or variations for the item.
itemrevenuecategory String The revenue category assigned to this item.
itemshipinsurance String Specifies whether shipping insurance is required for this item.
itemtype String The type of item, such as inventory, service, or non-inventory.
lastmodifieddate Datetime The date and time when the record was last modified.
listimmediate String Indicates whether the item is immediately available for listing.
listingduration String The duration for which the item will remain listed.
listingstartdate Date The date when the listing becomes active.
listingstarttime String The time when the listing becomes active.
location String The storage location or warehouse where the item is kept.
manufacturer String The name of the company that manufactures the item.
manufactureraddr1 String The primary address of the manufacturer.
manufacturercity String The city where the manufacturer is located.
manufacturerstate String The state or region where the manufacturer operates.
manufacturertariff String The tariff classification code assigned to the manufacturer.
manufacturertaxid String The tax identification number of the manufacturer.
manufacturerzip String The postal code for the manufacturer’s location.
matrixitemnametemplate String The template used for generating matrix item names.
matrixtype String Indicates whether the item is part of a matrix structure, such as parent or child.
maxdonationamount Decimal The maximum allowable donation amount for the item.
maximumquantity String The highest quantity of this item that can be purchased in a single transaction.
metataghtml String HTML metadata tags for search engine optimization (SEO).
minimumquantity String The minimum quantity of this item that can be purchased in a single transaction.
minimumquantityunits String The unit of measure associated with the minimum quantity.
mossapplies Boolean Indicates whether the Mini One Stop Shop (MOSS) VAT rules apply to this item.
mpn String The manufacturer’s part number (MPN) for the item.
multmanufactureaddr Boolean Indicates whether the item is manufactured at multiple addresses.
nextagcategory String The Nextag category associated with this item for product listings.
nextagproductfeed String Specifies if the item is included in Nextag product feeds.
nopricemessage String The message displayed when the item has no listed price.
numactivelistings Integer The number of active listings for this item.
numcurrentlylisted Integer The number of times the item is currently listed for sale.
offersupport Boolean Indicates whether customer support is offered for this item.
outofstockbehavior String Specifies how the system handles out-of-stock situations.
outofstockmessage String The message displayed when the item is out of stock.
overallquantitypricingtype String The pricing strategy applied based on total quantity purchased.
overheadtype String The type of overhead costs associated with the item.
packageheight String The height of the item’s package.
packagelength String The length of the item’s package.
packagewidth String The width of the item’s package.
pagetitle String The title displayed on the webpage for this item.
parent String The parent item in a hierarchical product structure.
preferencecriterion String The criterion used for sorting or prioritizing the item.
pricinggroup String The pricing group to which the item belongs.
primarycatdisplayname String The primary category display name for the item.
primarycategory Integer The main category identifier for the item.
producer Boolean Indicates whether the entity producing this item is also its vendor.
productfeed String Specifies if the item is included in product feed submissions.
purchasedescription String The description of the item used in purchase transactions.
purchaseorderamount String The total amount associated with purchase orders for this item.
purchaseorderquantity String The quantity of this item specified in purchase orders.
purchaseorderquantitydiff String The variance between ordered and received quantities.
purchaseunit String The unit of measure used for purchasing this item.
quantitypricingschedule String The pricing schedule based on purchase quantity tiers.
receiptamount String The total value of received inventory for this item.
receiptquantity String The total quantity of this item received.
receiptquantitydiff String The difference between expected and received item quantities.
refundgivenas String The form in which refunds are issued, such as credit or cash.
relateditemsdescription String A description of related or complementary items.
reserveprice Decimal The minimum price required for an auction to be completed.
residual String The remaining value or cost after deductions.
returnpolicy String The general return policy applicable to this item.
returnpolicydetails String Additional details about the item’s return policy.
returnshippingpaidby String Specifies whether the buyer or seller pays for return shipping.
returnswithin String The timeframe within which returns are accepted.
revenueallocationgroup String The group used for revenue allocation across multiple items.
revenuerecognitionrule String The rule governing when and how revenue is recognized.
revrecforecastrule String The rule used for forecasting revenue recognition.
revreclassfxaccount String The account used for foreign exchange reclassification of revenue.
revrecschedule String The schedule for recognizing revenue over time.
salesdescription String The description of the item used in sales transactions.
saleunit String The unit of measure used when selling this item.
schedulebcode String The Schedule B classification code for export reporting.
schedulebnumber String The Schedule B number assigned for export transactions.
schedulebquantity String The quantity associated with Schedule B export reporting.
searchkeywords String Keywords used for improving item search visibility.
secondarycatdisplayname String The secondary category display name for the item.
secondarycategory Integer The secondary category identifier for the item.
sellonebay Boolean Indicates whether this item is available for sale on eBay.
shipasia Boolean Indicates whether the item can be shipped to Asia.
shipaustralia Boolean Indicates whether the item can be shipped to Australia.
shipcanada Boolean Indicates whether the item can be shipped to Canada.
shipeurope Boolean Indicates whether the item can be shipped to Europe.
shipgermany Boolean Indicates whether the item can be shipped to Germany.
shipindividually Boolean Specifies if this item requires separate shipping from other items.
shipjapan Boolean Indicates whether the item can be shipped to Japan.
shipmexico Boolean Indicates whether the item can be shipped to Mexico.
shipnorthsouthamerica Boolean Indicates whether the item can be shipped to North and South America.
shippackage String The shipping package type used for this item.
shippingcost Decimal The cost associated with shipping this item.
shippingcostunits String The unit of measurement used for shipping cost calculations.
shippingdomesticmethodsgroup String The group of available domestic shipping methods.
shippingdomgroup String The shipping group used for domestic shipments.
shippingintlgroup String The shipping group used for international shipments.
shippingintlgroup1 String The first predefined international shipping group.
shippingintlgroup2 String The second predefined international shipping group.
shippingintlgroup3 String The third predefined international shipping group.
shippingitem1 String The first shipping method available for this item.
shippingitem2 String The second shipping method available for this item.
shippingitem3 String The third shipping method available for this item.
shippinglocationsgroup String The group of geographical locations where the item ships.
shippingpackaginggroup String The group that determines the packaging type for shipping.
shippingrate1 Decimal The primary shipping rate applied to this item.
shippingrate2 Decimal The secondary shipping rate applied to this item.
shippingrate3 Decimal The tertiary shipping rate applied to this item.
shipuk Boolean Indicates whether the item can be shipped to the United Kingdom.
shipworldwide Boolean Indicates whether the item is available for worldwide shipping.
shoppingdotcomcategory String The Shopping.com category assigned to this item.
shoppingproductfeed String Specifies whether the item is included in Shopping.com product feeds.
shopzillacategoryid Integer The Shopzilla category ID for this item.
shopzillaproductfeed String Indicates whether the item is included in the Shopzilla product feed.
showasgift Boolean Specifies whether the item can be purchased as a gift.
showdefaultdonationamount Boolean Indicates whether the default donation amount is displayed for this item.
sitemappriority String The priority level assigned to the item in the website’s sitemap.
softdescriptor String The billing descriptor that appears on customer statements.
standardimages String The standard images associated with the item.
startingprice Decimal The initial listing price for the item in auctions.
stockdescription String A brief description of the item’s stock status or availability.
storecatdisplayname String The display name of the primary store category.
storecatdisplayname2 String The display name of the secondary store category.
storecategory Integer The primary store category assigned to the item.
storecategory2 Integer The secondary store category assigned to the item.
storedescription String The description of the item as displayed in the online store.
storedetaileddescription String A detailed description of the item for the store listing.
storedisplayimage String The main image displayed for the item in the store.
storedisplayname String The name of the item displayed in the store.
storedisplaythumbnail String The thumbnail image used for the item in the store.
storeitemtemplate String The template applied to the store’s item listing.
subsidiary String The subsidiary company associated with this item.
subtype String The subtype of the item, if applicable.
supersizeimages Boolean Indicates whether larger images are available for the item.
taxable Boolean Specifies if the item is subject to taxation.
taxschedule String The tax schedule that applies to this item.
templatesgroup String The group of templates used for displaying the item.
unitstype String The type of unit measurement used for the item.
upccode String The Universal Product Code (UPC) assigned to the item.
urlcomponent String The SEO-friendly URL component used for the item’s web address.
usemarginalrates Boolean Indicates whether marginal tax rates are applied to this item.
vendorname String The name of the vendor supplying this item.
vsoedeferral String The method used for deferring revenue under VSOE rules.
vsoedelivered Boolean Indicates whether the item has been delivered under VSOE accounting rules.
vsoepermitdiscount String Specifies if discounts are permitted under VSOE rules.
vsoeprice Decimal The VSOE-compliant price of the item.
vsoesopgroup String The VSOE Statement of Position group assigned to the item.
weight Double The weight of the item.
weightunit String The unit of measurement for the item's weight.
weightunits String The number of weight units applicable to the item.
willship String Specifies the regions or conditions under which the item will ship.
yahooproductfeed String Indicates whether the item is included in Yahoo product feeds.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434