CData Python Connector for NetSuite

Build 25.0.9454

item

Holds details about inventory and non-inventory items, including products, materials, and services available in NetSuite.

Columns

Name Type References Description
id [KEY] Integer Unique internal identifier assigned to each item within NetSuite. This identifier is used for tracking and referencing the item across the system.
accbookrevrecforecastrule String Defines the revenue recognition forecast rule associated with a specific accounting book, determining how revenue is calculated and reported.
account String Specifies the general ledger account to which the item is linked, defining financial transactions related to the item.
accountingbook String Indicates the specific accounting book in which financial transactions related to the item are recorded, allowing multi-book accounting.
amortizationperiod Integer Defines the duration, in accounting periods, over which an asset’s cost is amortized for financial reporting purposes.
amortizationtemplate Integer References a predefined amortization template that dictates the schedule and method for expense or revenue amortization.
assetaccount Integer Identifies the asset account in the general ledger that tracks the value of the item when classified as an asset.
accountingbookamortization String Indicates the amortization schedule associated with a specific accounting book, used for expense recognition over time.
accountingbookcreateplanson String Specifies the criteria or event that triggers the creation of revenue plans within a particular accounting book.
accountingbookrevrecrule String Determines the revenue recognition rule applied within an accounting book, guiding how revenue is realized over time.
accountingbookrevrecschedule String Defines the revenue recognition schedule for an item, outlining when and how revenue is recognized in a given accounting book.
alternatedemandsourceitem String Specifies an alternative item that can be used to meet demand when the primary item is unavailable. Helps manage stock shortages efficiently.
atpleadtime Double Represents the Available to Promise (ATP) lead time, which is the estimated time required for an item to be available for sale or fulfillment.
atpmethod String Specifies the default ATP calculation method used to determine item availability based on supply and demand.
autoleadtime Boolean Indicates whether the system automatically calculates lead time for the item based on historical data and supplier performance.
autopreferredstocklevel Boolean Determines whether the preferred stock level should be automatically calculated based on demand trends and replenishment schedules.
autoreorderpoint Boolean Specifies whether the reorder point is automatically determined based on sales history, demand forecasting, and replenishment cycles.
availabletopartners Boolean Indicates whether the item is visible and available to business partners, such as resellers or distributors, within the NetSuite system.
averagecost Decimal Represents the average cost of the item, calculated based on historical purchase prices and inventory valuation methods.
backwardconsumptiondays Integer Defines the number of days in the past that the system looks at to consume demand for planning and forecasting purposes.
binnumber String Identifies the specific bin or storage location where the item is stored within a warehouse or inventory facility.
binonhandavail Double Indicates the total quantity of the item available in bins that can be used for order fulfillment.
binonhandcount Double Represents the total physical quantity of the item currently stored in bins, including allocated and reserved stock.
bomquantity Double Specifies the quantity of the item required in a Bill of Materials (BOM) for manufacturing or assembly processes.
buildentireassembly Boolean Indicates whether all sub-assemblies of the item should be built together when creating a work order.
buildtime Double Defines the variable lead time required to manufacture or assemble an item when fulfilling a work order.
buildtimelotsize Double Specifies the lot size used to determine lead time calculations for work orders, affecting production efficiency.
buyitnowprice Decimal Indicates the price at which an item can be purchased immediately on eBay without bidding.
billexchratevarianceacct Integer References the exchange rate variance account used to track currency fluctuations related to item purchases and supplier payments.
billingschedule Integer Identifies the billing schedule associated with the item, determining how and when customers are invoiced.
billpricevarianceacct Integer Specifies the general ledger account used to track price variances between expected and actual supplier invoice amounts.
billqtyvarianceacct Integer References the account used to track variances in quantities received versus quantities billed by suppliers.
caption String Stores the display name for the item as shown on an e-commerce website or storefront.
category String Categorizes the item within NetSuite for classification, reporting, and filtering purposes.
class String Assigns a classification to the item for financial segmentation and reporting, often used for departmental tracking.
commercecatalogid String References the identifier for the e-commerce catalog in which the item is listed.
commercecategoryenddate Datetime Specifies the date and time when an item’s association with a commerce category expires, affecting online visibility.
commercecategoryid String Identifies the category under which the item is classified in an e-commerce system.
commercecategoryisinactive Boolean Indicates whether the e-commerce category assigned to the item is inactive and no longer in use.
commercecategoryisprimary Boolean Specifies whether the assigned commerce category is the primary classification for the item.
commercecategoryname String Displays the name of the commerce category associated with the item.
commercecategorystartdate Datetime Specifies the date and time when an item becomes associated with a commerce category, affecting online visibility.
component String Identifies an item that is used as a component in the assembly or manufacturing of another item.
componentof String Indicates the parent item that includes this item as a component in its BOM.
componentyield Double Represents the expected yield percentage of a component item used in a manufacturing process, accounting for losses.
consumptionunit String Defines the unit of measure in which the item is consumed during manufacturing or production processes.
contingentrevenuehandling Boolean Indicates whether an item is eligible for contingent revenue handling, affecting revenue recognition timing and rules.
conversionrate Double Specifies the rate at which one unit of the item converts into another unit, often used for inventory or sales tracking.
copydescription Boolean Indicates whether the item description should be automatically copied to sales orders when the item is selected.
correlateditem String References an item that is commonly purchased alongside the current item, useful for upselling and recommendations.
correlateditemcorrelation Double Represents the correlation factor between this item and another frequently purchased item, based on sales data.
correlateditemcount Integer Indicates the number of times the correlated item has been purchased with this item in transaction history.
correlateditemlift Double Represents the increase in likelihood that a correlated item is purchased when this item is bought.
correlateditempurchaserate Double Indicates the probability that a customer purchasing this item will also purchase the correlated item.
cost Decimal Specifies the purchase price of the item from suppliers, used in cost accounting and profitability analysis.
costaccountingstatus String Indicates the current cost accounting status of the item, which affects inventory valuation and reporting.
costcategory String Assigns a cost category to the item for grouping and financial analysis.
costestimate Double Represents an estimated cost for the item, defined by internal calculations or external price sources.
costestimatetype String Specifies the methodology used to estimate the cost of the item, such as standard cost or average cost.
costingmethod String Indicates the cost accounting method used for the item, such as FIFO, LIFO, or weighted average cost.
countryofmanufacture String The country where the item was manufactured, used for compliance, reporting, and supply chain tracking.
created Datetime The date and time when the item record was initially created in the system.
createjob Boolean Indicates whether a job record should be created when this item is used in a transaction or process.
createrevenueplanson String Defines the event or condition upon which revenue plans should be generated for this item.
currentstandardcost Decimal The most recent standard cost assigned to this item, used for accounting and cost analysis.
currentstdcosteffectivedate Date The effective date from which the current standard cost of the item is applicable.
createddate Date The date when the item record was first added to the system.
createexpenseplanson Integer Specifies when expense plans should be created for this item based on predefined criteria.
custreturnvarianceaccount Integer The general ledger account used to record variances in customer returns, ensuring accurate financial tracking.
dateviewed Datetime The most recent date and time when this item record was accessed or viewed in the system.
daysbeforeexpiration Double The number of days remaining before the item reaches its expiration date, useful for inventory management.
deferralaccount Integer The deferred expense account associated with this item for managing revenue recognition and expense deferrals.
defaultreturncost Decimal The default cost assigned when a returned item is processed, helping with accurate return valuations.
deferrevrec Boolean Indicates whether revenue recognition for this item should be deferred based on specific accounting rules.
demandmodifier Double A factor used to adjust the estimated demand for this item in demand planning calculations.
demandsource String Identifies the source of demand for this item, such as sales orders, work orders, or purchase requests.
department String The department associated with this item, typically used for financial segmentation and reporting.
description String A detailed textual description of the item, providing additional context for users and customers.
directrevenueposting Boolean Indicates whether revenue transactions for this item should be posted directly to the general ledger without deferrals.
displayinebaystore Boolean Specifies whether this item should be displayed for sale in the associated eBay store.
displayname String The public-facing name of the item, used in sales channels, web stores, and reports.
distributioncategory String The category under which this item falls within the distribution network, used for logistics and classification.
distributionnetwork String Defines the network or channel through which this item is distributed to customers.
dontshowprice Boolean Indicates whether the item's price should be hidden from public or customer-facing displays.
demandtimefence Integer The number of days within which demand planning should not change orders for this item.
dropshipexpenseaccount Integer The general ledger account used to track expenses associated with drop-ship orders for this item.
ebayitemdescription String A detailed product description specifically formatted for eBay listings.
ebayitemsubtitle String A secondary title used in eBay listings to provide additional context and marketing appeal.
ebayitemtitle String The main title used for this item in eBay listings, designed for search optimization and visibility.
ebayrelistingoption String Specifies the automatic relisting options available for this item in eBay if it does not sell.
enforceminqtyinternally Boolean Indicates whether internal sales and stock tracking should enforce the minimum order quantity requirement.
effectivebomcontrol String Defines the BOM control strategy applied to this item for manufacturing processes.
effectivedate Date The date when the current configuration, cost, or pricing of this item becomes active.
effectiverevision String The active product revision or version of the item, useful in manufacturing and inventory management.
expenseamortizationrule Integer The predefined rule that determines how expenses for this item should be amortized over time.
enablecatchweight Boolean Indicates whether this item supports catch weight tracking, used in industries with variable unit weights.
endauctionswhenoutofstock Boolean Specifies whether eBay auctions for this item should automatically end when stock is depleted.
excludefromsitemap Boolean Indicates whether this item should be excluded from website sitemaps to prevent it from appearing in search results.
externalid String A unique identifier for this item used for integration with external systems and third-party applications.
externalidstring String A text-based version of the external identifier, often used for display and reporting purposes.
featureddescription String A highlighted description used for marketing purposes, such as in promotions or featured listings.
feeddescription String The description of this item as it appears in product feeds for marketplaces and advertising channels.
feedname String The name assigned to this item in external product feeds, used for online selling and syndication.
fixedbuildtime Double The fixed lead time required to build this item in a work order, measured in days.
fixedlotsize Double The predefined lot size for manufacturing or ordering this item, ensuring efficiency in procurement and production.
formuladate Date A calculated date based on a predefined formula, often used for reporting or automation.
formulanumeric Double A numeric value derived from a formula, commonly used for analytics and custom calculations.
formulatext String A text value generated by a formula, often utilized for labeling or classification purposes.
forwardconsumptiondays Integer The number of future days considered when consuming forecasted demand for this item.
fraudrisk String The assessed fraud risk level associated with this item, used in fraud detection and mitigation strategies.
froogleproductfeed Boolean Indicates whether this item should be included in the Google Base product feed now known as Google Merchant Center.
futurehorizon Integer The time horizon, measured in days, used for future demand and supply planning for this item.
fxcost Decimal The purchase price of this item in foreign currency, used for international procurement and cost tracking.
generateaccruals Boolean Specifies whether accrual transactions should be automatically generated for this item.
giftcertauthcode String The unique authorization code assigned to a gift certificate item, required for redemption.
giftcertemail String The email address of the recipient for electronic gift certificates, used for delivery and communication.
fullname String The full name of the item, including any additional identifiers used for internal or customer reference.
gainlossaccount Integer The general ledger account used to record gains or losses associated with currency fluctuations or cost changes.
giftcertexpdate Date The expiration date of a gift certificate associated with this item, determining its validity period.
giftcertfrom String The name of the individual or entity that purchased the gift certificate, typically used for tracking the buyer's information.
giftcertmsg String A personalized message included with the gift certificate, which is displayed to the recipient when they receive their gift certificate.
giftcertorigamt String The original monetary value assigned to the gift certificate at the time of purchase, which remains fixed and does not change with usage.
giftcertrecipient String The name of the individual or entity to whom the gift certificate is issued, which helps identify the intended recipient of the gift certificate.
handlingcost Decimal The cost associated with handling an item, including packaging, processing, and administrative fees, which is separate from shipping costs.
imageurl String A URL that links to the image associated with the item is used for displaying product images in web stores or internal systems.
internalid String A unique identifier assigned to the item within the system is used internally for database referencing and record management.
includechildren Boolean Indicates whether child items associated with a parent item should be included in searches and reports, useful for managing families or kits.
internalidnumber Integer The numerical representation of the internal ID, providing an alternative reference for sorting and identification.
incomeaccount Integer The financial account where income generated from the sale of this item is recorded, which is crucial for accounting and financial reporting.
inventorylocation String The physical or virtual location where the item is stored,which helps in inventory tracking and order fulfillment.
invtclassification String The classification assigned to the item based on inventory management policies, such as high-priority, slow-moving, or discontinued.
invtcountinterval Integer The number of days between scheduled inventory counts for this item, ensuring accurate stock tracking and reduces discrepancies.
isavailable Boolean Indicates whether the item is currently available for sale or fulfillment. This helps prevent overselling or inaccurate stock representation.
isdonationitem Boolean Indicates whether the item is classified as a variable-amount donation item, typically used for charitable contributions.
isdropshipitem Boolean Specifies whether the item is designated as a drop-ship item, which ships directly from the supplier to the customer without being stocked in inventory.
isfulfillable Boolean Indicates whether the item can be included in a sales order for fulfillment, which is important for items that can be informational or non-deliverable.
isgcocompliant Boolean Specifies whether the item meets compliance requirements, ensuring compatibility with payment processing system.
isinactive Boolean Indicates whether the item is currently inactive in the system, typically hidden from searches and transactions.
islotitem Boolean Indicates whether the item requires lot tracking is useful for inventory control, particularly for perishable or regulated items.
isonline Boolean Determines whether the item is displayed on the company's web store. If set to 'false', the item remains hidden from online listings.
ispreferredvendor Boolean Indicates whether a specific vendor is the preferred supplier for this item, which helps streamline purchasing decisions.
isserialitem Boolean Specifies whether the item requires serial number tracking, which is essential for high-value or regulated goods.
isspecialorderitem Boolean Indicates whether the item is a special order item, typically ordered upon customer request rather than kept in stock.
isspecialworkorderitem Boolean Determines whether the item is designated as a special work order item, requiring customized processing or manufacturing.
isstorepickupallowed Boolean Indicates whether customers can pick up this item at a physical store location instead of having it shipped.
issueproduct String Defines the associated product issued for specific transactions, often used in service-related or bundled item scenarios.
isphantom Boolean Indicates whether the item is a phantom item, meaning it is used for assembly tracking but does not physically exist in stock.
istaxable Boolean Specifies whether the item is subject to sales tax crucial for compliance with tax regulations.
isvsoebundle Boolean Determines whether the item is classified as a Vendor-Specific Objective Evidence (VSOE) bundle for revenue recognition purposes.
iswip Boolean Indicates whether the item is considered Work In Progress (WIP) inventory, commonly used in manufacturing environments.
itemid String The internal name or identifier assigned to the item for referencing within the system, which can differ from the public-facing item name.
itemprocessfamily String The category or family to which the item belongs, typically used for organizing items based on production or processing characteristics.
itemprocessgroup String A subgroup classification within an item process family, allowing for further segmentation of items based on manufacturing or handling requirements.
itemurl String A URL linking to the item’s detailed page, often used for web store listings or internal documentation.
itemtype String The type of item, such as inventory, non-inventory, service, or assembly. This classification affects how the item is managed in the system.
lastinvtcountdate Date The most recent date on which a physical inventory count was conducted for this item. This helps track stock accuracy.
lastmodifieddate Datetime The timestamp of the most recent modification made to the item record. This is useful for auditing and tracking changes.
lastpurchaseprice Decimal The last recorded purchase price for the item. This provides insight into cost trends and supplier pricing.
lastquantityavailablechange Datetime The timestamp of the last change made to the available quantity of this item in inventory. This helps track fluctuations in stock levels.
leadtime Integer The estimated number of days required to replenish stock for this item, assisting in inventory planning and reorder strategies.
listingduration String The duration for which an item listing remains active on eBay when integrated with NetSuite, which helps in managing online sales.
location String The specific location or warehouse where the item is stored is essential for inventory tracking and fulfillment.
locationadvwarningthreshold Integer The threshold number of days before an item’s release status triggers an advance warning, which helps with production and planning.
locationallowstorepickup Boolean Indicates whether store pickup is allowed for the item, which helps customers choose their preferred fulfillment method.
locationatpleadtime Double The ATP lead time for the item at this location, affecting order fulfillment expectations.
locationaveragecost Decimal The average cost of the item at this specific location, assisting in financial analysis and pricing strategies.
locationbuildtime Double The estimated lead time required to build or assemble the item at this location, which is critical for production planning.
locationbuildtimelotsize Double The standard lot size used when calculating build time at this location, ensuring consistency in manufacturing schedules.
locationcost Decimal The standard cost of the item at this location is used for cost accounting and inventory valuation.
locationcostaccountingstatus String The cost accounting status of the item at this location, indicating whether costs are current, pending, or outdated.
locationdefaultreturncost Decimal The default cost used when processing returns for this item at the specified location, which helps in managing return-related finances.
locationdemandsource String Specifies the primary demand source for this item at this location, such as sales orders, work orders, or intercompany transfers.
locationfixedbuildtime Integer The fixed lead time required to build the item at this location, irrespective of order quantity, which assists in scheduling production.
locationfixedlotsize Double The fixed lot size applicable when planning production runs at this location, which helps optimize manufacturing efficiency.
locationinvtclassification String The inventory classification of the item at this location, such as high-turnover, slow-moving, or obsolete.
locationinvtcountinterval Integer The interval in days between scheduled inventory counts for this item at this location, ensuring inventory accuracy.
locationlastinvtcountdate Date The most recent inventory count date for this item at the specified location, which helps track stock accuracy.
locationlatedemandthreshold Double The threshold for late demand impact at this location, used to identify critical delays in order fulfillment.
locationlateperioddays Integer The number of days defining the late period for demand at this location, helping to track and mitigate delays.
locationleadtime Integer The number of days required for inventory to be transferred or replenished at a specific location.
locationminimumrescheduledays Integer The minimum number of days required before a rescheduling action can be performed at a given location.
locationnextinvtcountdate Date The scheduled date for the next inventory count at the specified location, aiding in stock accuracy.
locationpastdueforecastdays Integer The number of days past due for forecasted demand at a location, impacting inventory planning.
locationpreferredstocklevel Double The ideal stock level for an item at a given location to prevent stockouts while avoiding overstocking.
locationqtyavailforstorepickup Double The quantity of an item available at a location for customers selecting in-store pickup.
locationquantityavailable Double The total quantity of an item currently available for sale or fulfillment at a specific location.
locationquantitybackordered Double The number of units that have been ordered but are currently out of stock and awaiting replenishment.
locationquantitycommitted Double The number of units already allocated to sales orders or other commitments at a given location.
locationquantityintransit Double The number of units currently being transferred from one location to another but not yet received.
locationquantityonhand Double The actual physical quantity of an item stored at a location, including reserved stock.
locationquantityonorder Double The number of units that have been ordered from suppliers or other sources but have not yet been received.
locationreorderpoint Double The inventory level at which an automatic reorder is triggered to replenish stock at a specific location.
locationreschedulehorizon Integer The time horizon in days within which inventory rescheduling adjustments can be made.
locationrescheduleindays Integer The number of days within which an inbound shipment or order can be rescheduled earlier.
locationrescheduleoutdays Integer The number of days within which an inbound shipment or order can be postponed.
locationsafetystocklevel Double The buffer inventory level maintained at a location to prevent stockouts due to demand fluctuations or supply chain delays.
locationstorepickupbufferstock Double The quantity of stock reserved at a location specifically for store pickup orders to ensure availability.
locationsupplylotsizingmethod String The method used for determining the lot size when replenishing inventory, such as fixed order quantity or lot-for-lot.
locationsupplytype String The sourcing method used for inventory at a given location, such as stocked, drop-shipped, or externally procured.
locationtotalvalue Decimal The total monetary value of inventory held at a specific location, based on cost or valuation method.
lowerwarninglimit Double The lower threshold for acceptable stock levels before triggering alerts or replenishment actions.
manufacturer String The name of the company that produces the item, helping track the item's origin and supplier details.
manufactureraddr1 String The primary street address of the manufacturer is useful for shipping, compliance, and supplier management.
manufacturercity String The city where the manufacturer is located, providing geographic context for supply chain and logistics operations.
manufacturerstate String The state or province where the manufacturer is based, which is important for tax, regulatory compliance, and shipping considerations.
manufacturertariff String The tariff classification code associated with the manufacturer, often required for import/export compliance.
manufacturertaxid String The tax identification number assigned to the manufacturer for regulatory and financial reporting purposes.
manufacturerzip String The postal or ZIP code associated with the manufacturer of the item is used for shipping calculations, tax determination, and compliance reporting.
matchbilltoreceipt Boolean Indicates whether an invoice should be matched against the corresponding receipt before processing payment.
matrix Boolean Indicates whether the item is part of a matrix configuration, typically used for items with variations such as size or color.
maxdonationamount String The maximum amount that can be donated or allocated as a variable contribution for the item.
manufacturingchargeitem Boolean Specifies whether the item is a chargeable component within a manufacturing process.
matrixchild Boolean Indicates whether the item is a child item within a matrix structure, inheriting attributes from its parent item.
matrixitemnametemplate String The naming convention template applied to matrix items to standardize item descriptions across variations.
matrixtype String Indicates the type of matrix used for the item, typically relevant for items with variations, such as apparel or electronics.
maximumquantity Integer The maximum number of units that can be purchased or ordered for a given transaction.
metataghtml String Custom HyperText Markup Language (HTML) meta tags used for SEO purposes to enhance the item's visibility in search engines.
minimumquantity Integer The minimum number of units that must be purchased or ordered in a single transaction.
mossapplies Boolean Indicates whether the item is subject to the Mini One Stop Shop (MOSS) tax scheme, applicable to digital goods in certain regions.
mpn String The Manufacturer Part Number (MPN), a unique identifier assigned by the manufacturer to distinguish the product.
multmanufactureaddr Boolean Indicates whether multiple manufacturing addresses are supported for this item. This is useful for businesses with multiple production facilities.
nextagcategory String Specifies the product category assigned to this item for NexTag, a price comparison website.
nextagproductfeed Boolean Determines whether this item is included in the NexTag product feed, allowing it to appear in online price comparisons.
nextinvtcountdate Date Represents the scheduled date for the next physical inventory count of this item to ensure stock accuracy.
numactivelistings Integer Displays the number of active listings for this item on eBay, reflecting current sales availability.
numberalloweddownloads Double Specifies the total number of downloads allowed for this digital product before access is restricted.
numcurrentlylisted Integer Indicates the quantity of this item currently listed for sale on eBay, helping track marketplace stock levels.
obsoletedate Date The date on which this item becomes obsolete and is no longer considered for inventory, sales, or production.
nopricemessage String A custom message displayed when no price is available for this item, often used for request-based pricing.
obsoleterevision String Specifies the obsolete revision of this item, typically referring to discontinued or outdated product versions.
offersupport Boolean Indicates whether customer support is offered for this item, helping buyers understand service availability.
onlinecustomerprice Decimal The price of this item for customers purchasing online, distinct from in-store or bulk pricing.
onspecial Boolean Denotes whether this item is currently part of a special promotion or discount campaign.
othervendor String The name of an alternate vendor that supplies this item, providing sourcing flexibility.
outofstockbehavior String Defines how the system handles out-of-stock situations for this item, such as backordering or preventing purchases.
overheadtype String Specifies the overhead cost classification assigned to this item, used in cost accounting and pricing strategies.
overallquantitypricingtype String Determines how quantity-based pricing is applied to this item, affecting discounts and bulk order calculations.
pagetitle String The title displayed on the product's web page, optimizing search visibility and customer engagement.
parent String Indicates the parent item to which this item is related, commonly used for sub-items or product variations.
periodiclotsizetype String Defines the type of periodic lot sizing used for this item in inventory planning, influencing reorder strategies.
preferredlocation Integer Specifies the default storage location where this item is primarily kept within inventory.
planningitemcategory String Categorizes this item for planning purposes, helping with demand forecasting and resource allocation.
outofstockmessage String The message displayed to customers when this item is out of stock, guiding purchasing decisions.
preferencecriterion String Specifies the preference criterion used for trade compliance, such as origin-based customs classification.
preferredbin Boolean Indicates whether this item is assigned to a preferred bin location within a warehouse for optimized picking.
preferredlocation String The default or primary inventory location assigned to an item within the system.
preferredstocklevel Double Defines the ideal stock level to maintain for this item to ensure consistent availability without overstocking.
preferredstockleveldays Integer Represents the number of days of supply the preferred stock level should cover, aiding in inventory management.
price Decimal The standard sales price of this item, used for customer transactions and pricing calculations.
pricesincludetax Boolean Indicates whether item prices include tax when displayed or processed in transactions, which affects how tax calculations are applied.
pricinggroup String Defines the pricing group to which the item belongs, which helps manage discounts and special pricing rules for related items.
primarycategory Integer Represents the primary eBay category ID for the item when listed on eBay, categorizing the item appropriately in online marketplaces.
purchaseorderamount Double Specifies the allowable variance in the total amount of a vendor bill compared to its associated purchase order.
purchaseorderquantity Double Defines the acceptable variance in quantity between a vendor bill and its corresponding purchase order, which helps manage discrepancies.
purchaseorderquantitydiff Double Records the actual difference in quantity between a vendor bill and its associated purchase order, tracking purchase discrepancies.
printitems Boolean Indicates whether items should be printed on forms such as invoices and packing slip for managing item visibility on documents.
prodpricevarianceacct Integer Represents the general ledger account used to track price variances in production costs in manufacturing.
prodqtyvarianceacct Integer Specifies the general ledger account for recording quantity variances in production, which helps monitor discrepancies in production.
projecttemplate Integer Identifies the default project template associated with this item used in service-based operations.
purchasedescription String Provides a detailed description of the item for purchasing purposes, appearing on purchase orders and vendor-related transactions.
purchaseunit String Defines the unit of measurement used when purchasing this item. Examples include 'Each,' 'Box,' or 'Case,' depending on how the item is ordered.
purchasepricevarianceacct Integer Specifies the general ledger account used to track purchase price variances, helping businesses analyze differences between costs.
quantityavailable Double Represents the current quantity of the item that is available for sale or use, excluding committed stock.
quantitybackordered Double Tracks the number of units currently on backorder, indicating demand for an item that exceeds the available stock and is awaiting fulfillment.
quantitycommitted Double Shows the quantity of this item that has been allocated to sales orders but not yet shipped. Helps ensure accurate inventory tracking.
quantityonhand Double Indicates the total quantity of the item physically available in inventory, including both committed and uncommitted stock.
quantityonorder Double Displays the total number of units currently on order from suppliers, which helps businesses anticipate stock replenishments.
quantitypricingschedule String Links the item to a quantity-based pricing schedule, which defines pricing tiers based on order quantities.
receiptamount Double Specifies the allowable tolerance for discrepancies between a vendor bill and the amount recorded on an item receipt.
receiptquantity Double Defines the acceptable variance in quantity between an item receipt and the vendor bill, which helps control inventory discrepancies.
receiptquantitydiff Double Records the actual difference in quantity between an item receipt and a vendor bill is useful for reconciling purchase and inventory.
reordermultiple Integer Determines the minimum quantity multiple required when reordering the item, ensuring purchases align with supplier packaging.
reorderpoint Double Specifies the inventory level at which a reorder is triggered to prevent stockouts, maintaining adequate stock levels based on demand.
rescheduleindays Integer Defines the number of days an inbound order can be rescheduled earlier to align with changing demand forecasts.
rescheduleoutdays Integer Specifies the number of days an order can be pushed out when supply chain delays occur or demand decreases.
reserveprice Decimal Represents the minimum price at which an item can be sold on eBay, ensuring sellers do not accept bids below a certain threshold.
relateditemsdescription String Provides additional details about related items is used to display complementary or alternative products.
revrecforecastrule String Determines the rule applied for forecasting revenue recognition, aligning revenue recognition practices with accounting policies.
revrecschedule String Specifies the revenue recognition schedule associated with the item, defining how revenue is recognized over time.
residual Double Represents the remaining value of an asset or item after depreciation or usage, which helps in financial reporting and asset valuation.
roundupascomponent Boolean Indicates whether the item quantity should be rounded up when used as a component in a bill of materials or production process.
rotationtype String Defines the stock rotation method for the item, such as FIFO (First In, First Out) or LIFO (Last In, First Out), managing inventory flow.
safetystocklevel Double Specifies the minimum inventory level that should be maintained to prevent stockouts, which acts as a buffer against demand fluctuations.
safetystockleveldays Integer Defines the number of days of stock coverage provided by the safety stock level, helping businesses plan for supply chain variability.
salesdescription String Contains the product description displayed on sales transactions, such as quotes, orders, and invoices.
saleunit String Specifies the unit of measurement in which the item is sold, such as 'Each,' 'Pack,' or 'Pallet' ensuring clarity in sales transactions.
sameasprimarybookamortization Boolean Indicates whether amortization settings for this item match those of the primary accounting book.
sameasprimarybookrevrec Boolean Specifies whether revenue recognition settings match those of the primary accounting book, ensuring compliance with accounting standards.
schedulebcode String Represents the Schedule B export code used for international trade reporting and classifying goods for customs declarations.
schedulebnumber String The Schedule B Number is a unique identifier for classifying exported goods, ensuring compliance with international trade regulations.
schedulebquantity String The Schedule B Quantity, indicating the number of units of an item being exported, as required for customs declarations and reporting.
searchkeywords String A list of keywords used to improve searchability for the item within catalogs, online marketplaces, and internal searches.
scrapacct Integer The general ledger account designated to record the cost of scrapped or discarded inventory, useful for financial tracking and reporting.
seasonaldemand Boolean Indicates whether the item experiences seasonal fluctuations in demand, which can impact inventory planning and sales forecasting.
secondaryconsumptionunit String The alternative unit of measure used when tracking the consumption of this item in production or internal processes.
secondarypurchaseunit String An alternate unit of measure that can be used for purchasing this item, differing from the standard purchase unit.
secondarysaleunit String A secondary unit of measure that can be used when selling this item, allowing flexibility in sales transactions.
secondarystockunit String An additional unit of measure used for tracking inventory levels in a format different from the primary stock unit.
secondaryunitstype String The classification of secondary units of measure associated with this item, ensuring consistency across various unit conversions.
sellonebay Boolean Indicates whether this item is listed for auction or sale on eBay, enabling synchronization with online marketplaces.
serialnumber String The unique serial or lot number assigned to this item, used for tracking, warranty management, and quality control.
serialnumberlocation String The designated location within the inventory system where serial or lot numbers are stored, helping streamline retrieval and tracking.
shipindividually Boolean Specifies whether this item must be shipped separately from other items, often due to size, fragility, or regulatory requirements.
shippackage String The type of package or packaging specification recommended for shipping this item, ensuring proper handling and protection.
shippingrate Decimal The cost of shipping this item, calculated based on carrier rates, item weight, dimensions, and destination.
shoppingdotcomcategory String The category under which this item is listed on Shopping.com, improving visibility in online product searches.
shippingcost Decimal The total cost associated with shipping this item, including handling fees, carrier charges, and any additional surcharges.
shoppingproductfeed Boolean Indicates whether this item is included in an automated product feed for online shopping platforms to enhance product discoverability.
shopzillacategoryid Integer The unique category identifier assigned to this item in the Shopzilla product catalog, used for accurate categorization in marketplace listings.
shopzillaproductfeed Boolean Determines whether this item is part of the automated product feed sent to Shopzilla for online advertising and sales.
sitemappriority Double The priority level assigned to this item’s webpage in the website’s sitemap, influencing search engine optimization (SEO) rankings.
softdescriptor String A short description used for credit card statements, helping customers recognize transactions related to this item purchase.
startingprice Decimal The initial price set for this item when listed on eBay auctions, serving as the minimum acceptable bid.
stockdescription String A brief but informative description of the item, typically used for internal inventory management and reporting.
stockunit String The primary unit of measure in which this item is stocked, such as pieces, kilograms, or liters, ensuring accurate inventory tracking.
storedescription String A detailed description of the item as displayed in an online or physical store, providing customers with relevant product information.
showdefaultdonationamount Boolean Indicates whether a default donation amount should be displayed when this item is associated with a charitable contribution option.
subsidiary String The specific subsidiary or business entity within the organization that owns or manages this item, aiding in financial reporting and allocation.
subtype String A classification of this item that provides additional categorization beyond the primary item type, often used for reporting and organization.
supplylotsizingmethod String The methodology used to determine the lot size for replenishing inventory, such as fixed order quantity or economic order quantity.
supplyreplenishmentmethod String The strategy used for restocking this item, such as Make-to-Stock (MTS), Make-to-Order (MTO), or Just-in-Time (JIT) inventory management.
storedetaileddescription String A comprehensive, rich-text description of this item, often used for marketing and detailed product specifications in an online store.
supplytype String Indicates whether the item is a manufactured, purchased, or drop-shipped product, affecting supply chain and procurement processes.
storedisplayimage Integer The reference ID of the main product image displayed in the store, used to visually represent the item to customers.
storedisplayname String The name of the item as displayed in the online store, which can differ from the internal item name.
storedisplaythumbnail Integer The reference ID of the thumbnail image for the item, shown in smaller previews on product listings and search results.
supplytimefence Integer The planning time fence in days, defining the period during which supply changes are restricted to avoid last-minute disruptions.
taxcode String The tax classification code assigned to this item, used for calculating applicable sales tax rates.
taxschedule String The tax schedule associated with this item, defining how sales tax is applied across different regions or jurisdictions.
thumbnailurl String The URL of the thumbnail image for this item, typically used in online product listings and search results.
totalvalue Decimal The total value of this item in inventory, calculated as the unit cost multiplied by the total quantity on hand.
totalquantityonhand Double The current total stock available for this item across all locations, helping with inventory management and replenishment planning.
tracklandedcost Boolean Indicates whether the total landed cost, including shipping, duties, and other expenses, is tracked, aiding in cost analysis.
transferprice Double The price at which inventory items are transferred between locations within the company. This is used for internal cost tracking.
type String The classification of the item, such as inventory, non-inventory, service, or other types defined within NetSuite.
unitstype String The unit type associated with the item, determining the measurement system used, such as each, dozen, or box.
unbuildvarianceaccount Integer The general ledger account where cost variances related to unbuilding assemblies are recorded.
upccode String The Universal Product Code (UPC) assigned to the item for barcode scanning and product identification.
upperwarninglimit Double The maximum threshold for a specified parameter before triggering a warning, such as inventory levels or quality control measures.
urlcomponent String A segment of the URL specific to the item, typically used for e-commerce and online catalog display.
usebins Boolean Indicates whether the item is stored in designated bins within warehouses for inventory management.
usecomponentyield Boolean Determines whether the system accounts for component yield variations when manufacturing an assembly item.
usemarginalrates Boolean Indicates whether marginal tax rates apply to this item in tax calculations for transactions.
vendor String The preferred vendor from whom the item is primarily sourced, used in procurement and purchase order processing.
vendorcode String A unique identifier assigned by the vendor to this item, often used for cross-referencing vendor catalogs.
vendorcost Decimal The cost at which the vendor sells the item to the company, used for procurement and pricing calculations.
vendreturnvarianceaccount Integer The account where cost variances related to vendor returns are recorded, ensuring accurate financial tracking.
vendorcostentered Decimal The manually entered cost of the item from the vendor, which may differ from system-calculated costs.
vendorname String The name of the vendor providing the item, used in reporting and purchase order management.
vendorpricecurrency String The currency in which the vendor cost is denominated, ensuring accurate multi-currency transactions.
vsoedeferral String Indicates the revenue deferral method applied to this item, used in revenue recognition calculations.
vsoedelivered Boolean Specifies whether the item has been delivered, often defaulting to 'Delivered' status for fulfillment tracking.
vsoepermitdiscount String Determines whether and how discounts are allowed for this item within sales transactions.
vsoeprice Double Represents the VSOE price of an item used in revenue recognition processes, particularly for allocating revenue in a sales transaction.
vsoesopgroup String Defines the allocation type used for revenue recognition purposes, ensuring compliance with accounting standards.
website String Stores the associated website URL or identifier where this item is listed or available for purchase.
weight Double Records the physical weight of the item, typically used for shipping calculations and logistics management.
weightunit Integer The unit of measurement for weight, such as grams, kilograms, or pounds, based on the unit type settings.
weightunits String The textual representation of the weight unit, such as 'kg' or 'lbs', used in user interfaces and reports.
wipacct Integer The WIP account associated with an inventory item used in manufacturing or assembly processes where costs are accumulated for partially completed items.
wipvarianceacct Integer The account used to track variances between estimated and actual work-in-progress costs in manufacturing.
yahooproductfeed Boolean Indicates whether the item is included in the Yahoo Shopping product feed for online sales and marketing.

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