ADO.NET Provider for NetSuite

Build 25.0.9434

serializedassemblyitem

Contains records for serialized assembly items, including component and serial tracking data.

Columns

Name Type References Description
alternatedemandsourceitem String Specifies an alternate item to be used as the source of demand in planning processes, particularly for Material Requirements Planning (MRP).
assetaccount String The general ledger account used to track the value of this item as an asset on the balance sheet.
atpmethod String Defines the Available to Promise (ATP) calculation method used to determine item availability based on current supply and demand.
auctionquantity String The quantity of the item available in an online auction listing, used in eCommerce integrations.
auctiontype String Specifies the type of auction, such as fixed price or reserve price, used when listing the item for sale online.
autoleadtime Boolean If the value is 'true', the lead time for the item is calculated automatically based on historical data. If the value is 'false', lead time must be set manually.
autopreferredstocklevel Boolean If the value is 'true', the system automatically determines the preferred stock level based on usage patterns. If the value is 'false', it must be entered manually.
autoreorderpoint Boolean If the value is 'true', the reorder point is calculated automatically based on demand. If the value is 'false', it must be set manually.
availabletopartners Boolean If the value is 'true', this item is visible and available for business partners (such as resellers or distributors) in their portals. If the value is 'false', it is not.
averagecost Decimal The average cost of the item based on historical purchase or production data, used in inventory valuation.
billexchratevarianceacct String The account used to track variances caused by fluctuations in exchange rates for vendor bills related to this item.
billingschedule String The billing schedule applied to the item, which defines how and when revenue is recognized or invoices are generated.
billpricevarianceacct String The account used to record differences between expected and actual prices on vendor bills for this item.
billqtyvarianceacct String The account used to record quantity differences between received goods and vendor bills for this item.
buildentireassembly Boolean If the value is 'true', the entire assembly must be built before it is available. If the value is 'false', partial builds may be allowed.
buildtime Double Estimated time, in hours or minutes, required to fully assemble this item.
buildtimelotsize Double Defines the lot size used to calculate the build time. Larger lot sizes may reduce per-unit build time due to economies of scale.
buyitnowprice Decimal The fixed price for 'Buy It Now' functionality in online marketplaces such as eBay.
class String The classification or category assigned to this item for internal reporting and segmentation purposes.
cogsaccount String The Cost of Goods Sold (COGS) account associated with this item, used when recording inventory expense.
conditionenabled String Specifies whether item conditions (such as new, refurbished, or used) are enabled for this item.
conditionhelpurl String A Uniform Resource Locator (URL) that links to help content explaining the condition options for this item on the web store.
consumptionunit String Unit of measure used to record the consumption of this item, particularly for planning or usage tracking.
copydescription Boolean If the value is 'true', the item description is automatically copied to transactions. If the value is 'false', it must be entered manually.
cost Decimal The base cost assigned to the item, which may be used in pricing and margin calculations.
costcategory String The cost category used to group and report item costs, such as labor, material, or overhead.
costestimate Decimal Estimated cost to produce or acquire the item, often used in planning and quoting.
costestimatetype String Indicates the method used to derive the cost estimate, such as standard, average, or last purchase price.
costingmethod String Specifies the inventory costing method applied to the item, such as FIFO (First In First Out), LIFO (Last In First Out), or average.
costingmethoddisplay String The user-friendly display name for the costing method shown in UI and reports.
costunits String The unit of measure used when expressing the cost of the item (for example, per unit, per dozen).
countryofmanufacture String Indicates the country where the item was manufactured, used for compliance, customs, and reporting purposes.
createddate Datetime The date and time when the item record was initially created in the system.
createrevenueplanson String Specifies the trigger for generating a revenue recognition plan for this item, such as at billing or fulfillment.
currency String The default currency associated with this item for pricing and cost calculations.
customform String References the custom form used to capture item details, enabling tailored data entry interfaces.
custreturnvarianceaccount String The general ledger account used to track financial variances arising from customer returns of this item.
defaultrevision String The default Bill of Materials (BOM) revision associated with the item for manufacturing or planning processes.
deferredrevenueaccount String The account used to hold revenue for this item until it is recognized based on revenue rules or fulfillment events.
deferrevrec Boolean If the value is 'true', revenue recognition for this item is deferred. If the value is 'false', revenue is recognized immediately upon invoicing.
demandmodifier String A planning factor applied to adjust the demand forecast for this item, useful for seasonal or promotional adjustments.
demandtimefence Integer Defines the number of days into the future for which demand is considered in supply planning calculations.
department String Specifies the internal department responsible for this item, often used for cost tracking and reporting.
description String A detailed text description of the item, used in transactions, catalogs, and web store listings.
directrevenueposting Boolean If the value is 'true', revenue from this item posts directly to the general ledger. If the value is 'false', it follows deferred revenue rules.
displayinebaystore Boolean If the value is 'true', the item is displayed in your integrated eBay store listings. If the value is 'false', it is excluded.
displayname String The name shown in user interfaces and reports to represent this item, distinct from the internal item ID.
distributioncategory String A custom grouping used to classify the item within a specific distribution or fulfillment framework.
distributionnetwork String Specifies the network of fulfillment or distribution centers where this item is stored or distributed.
dontshowprice Boolean If the value is 'true', the item price is hidden on web store listings. If the value is 'false', the price is displayed publicly.
dropshipexpenseaccount String The expense account used to record costs associated with drop-shipped orders for this item.
ebayhandlingtime String Indicates the handling time (in days) required to prepare this item for shipment in eBay listings.
ebayintlinsurancefee Decimal The international insurance fee applied when shipping this item via eBay's international programs.
ebayintlpackagehandlingfee Decimal The handling fee charged for packaging this item for international shipping via eBay.
ebayintlshipinsurance String Specifies whether international shipping insurance is enabled for this item when sold on eBay.
ebayintlshippingitem1 String Primary international shipping method configured for this item in eBay listings.
ebayintlshippingitem2 String Secondary international shipping method available for this item in eBay listings.
ebayintlshippingitem3 String Tertiary international shipping method option listed for this item in eBay.
ebayisintlcalculatedrate String Indicates whether the international shipping rate is calculated automatically in eBay based on location and weight.
ebayisirregularpackage Boolean If the value is 'true', the item is considered irregularly shaped or oversized for eBay shipping calculations. If the value is 'false', it is treated as standard packaging.
ebayitemdescription String The description used in eBay item listings to inform buyers about the product.
ebayitemlocdisplay String Specifies how the item’s location appears in eBay listings, such as a city or region name.
ebayitemloczipcode String The ZIP code displayed on eBay listings indicating where the item is located for shipping and buyer reference.
ebayitemlots Integer Specifies the quantity of items included in a single lot for eBay listings, commonly used for bulk or bundled sales.
ebayitemsubtitle String A secondary title displayed in eBay listings that provides additional marketing or descriptive information.
ebayitemtitle String The main title of the item as shown in eBay listings; should be concise and keyword-rich for search optimization.
ebayitemweightamt String Specifies the weight of the item for eBay listings, used to calculate shipping charges based on item mass.
ebaylayout String The layout template applied to the item’s eBay listing, controlling its visual structure and arrangement of elements.
ebaypackagetype String Describes the type of packaging used for this item in eBay listings, such as envelope, box, or oversized packaging.
ebaypagecounter String Determines whether a page view counter is displayed in eBay listings to show how many people have viewed the item.
ebayrelistingoption String Defines the behavior for automatically relisting the item on eBay when it doesn’t sell or after expiration.
ebaytheme String The visual theme applied to the eBay listing to influence color schemes and branding.
ebaythemegroup String A grouping of related eBay themes, often used for organizing branding or template sets within eBay integration.
effectivebomcontrol String Indicates how BOM versions are controlled for the item, such as through date effectiveness or revisions.
endauctionswhenoutofstock Boolean If the value is 'true', the item’s eBay auction will automatically end when inventory reaches zero. If the value is 'false', the auction remains active regardless of stock.
enforceminqtyinternally Boolean If the value is 'true', internal systems will prevent inventory actions that violate the minimum quantity rule. If the value is 'false', the enforcement is disabled.
excludefromsitemap Boolean If the value is 'true', the item will not be included in the website's sitemap. If the value is 'false', it will be indexed for search engine optimization.
externalid String A unique external identifier for the item, typically used for integrations with external systems or third-party platforms.
featureddescription String A short promotional description of the item, used to highlight its key features in marketing or on product listing pages.
fixedbuildtime Double Represents the fixed time (in minutes or hours) required to assemble the item, regardless of the quantity being built.
froogleproductfeed String Indicates the product feed configuration for Froogle (Google Shopping), used to sync item data with Google’s merchant listings.
futurehorizon String Defines the planning horizon for this item in demand and supply forecasting—how far ahead the system looks when creating plans.
gainlossaccount String The general ledger account used to post gains or losses due to inventory revaluation or transaction differences for this item.
gallery Boolean If the value is 'true', the item is listed in an eBay gallery view with a photo thumbnail. If the value is 'false', it will not appear in gallery format.
galleryfeatured Boolean If the value is 'true', the item is prioritized as a featured product in the eBay gallery. If the value is 'false', it displays normally.
gifttypeexpressship Boolean If the value is 'true', the item is available with an express shipping option for gifts. If the value is 'false', this option is not offered.
gifttypegiftwrap Boolean If the value is 'true', the item is eligible for gift wrapping services. If the value is 'false', gift wrapping is not available.
gifttypeshiptorecipient Boolean If the value is 'true', the item can be shipped directly to the gift recipient. If the value is 'false', shipping to the buyer is required.
handlingcost Decimal The base handling fee charged when fulfilling an order for this item, excluding shipping costs.
handlingcostunits String Specifies the unit type used to calculate handling cost, such as per item, per weight, or per shipment.
handlinggroup String Indicates the group or classification used to apply specific handling logic or rules to the item during fulfillment.
imagesgroup String The image group assigned to the item for organizing visual assets, such as thumbnails, swatches, or banners.
imageslocation String Specifies the file path or URL where images for this item are stored, typically used for external hosting or CDN integration.
includechildren Boolean If the value is 'true', the item will inherit settings or behaviors from its parent item or category. If the value is 'false', it functions independently.
incomeaccount String Specifies the general ledger income account used to record revenue generated from the sale of this item.
intercocogsaccount String Indicates the COGS account used specifically for intercompany transactions.
intercoincomeaccount String Specifies the income account used for intercompany sales revenue, typically part of internal financial reporting.
internalid Integer The system-generated unique identifier for the item, used internally for referencing the record across the platform.
iscalculatedrate String Defines whether the rate for this item is calculated dynamically, such as using formulas or pricing rules.
isdonationitem Boolean If the value is 'true', the item is marked as a donation item, often used in fundraising scenarios. If the value is 'false', it is treated as a regular inventory item.
isdropshipitem Boolean If the value is 'true', the item is fulfilled directly by a vendor through drop shipping. If the value is 'false', it is fulfilled from internal inventory.
isgcocompliant Boolean If the value is 'true', the item complies with Generally Compliant Objects (GCO) or related product compliance standards. If the value is 'false', the item has no such certification.
isinactive Boolean If the value is 'true', the item is inactive and cannot be used in transactions. If the value is 'false', the item is active and available.
isonline Boolean If the value is 'true', the item is published and visible in online channels such as web stores. If the value is 'false', the item is hidden from online listings.
isphantom Boolean If the value is 'true', the item is a phantom assembly, meaning it’s used for planning and grouping but not built physically. If the value is 'false', the item follows regular build processes.
isspecialorderitem Boolean If the value is 'true', the item is flagged as a special order, typically procured only upon customer request. If the value is 'false', it is treated as a standard item.
isspecialworkorderitem Boolean If the value is 'true', the item requires a special work order for production. If the value is 'false', it follows regular production workflows.
isstorepickupallowed Boolean If the value is 'true', customers can select store pickup as a fulfillment method for this item. If the value is 'false', this option is not available.
issueproduct String References the product associated with an issue or warranty policy, often used for serialized or returnable goods.
itemcondition String Describes the physical condition of the item (for example, new, refurbished, used), which can affect pricing and listing rules.
itemhandlingfee Decimal Specifies a fixed handling fee applied per unit of the item, in addition to standard shipping costs.
itemid String The identifier or Stock Keeping Unit (SKU) used to uniquely distinguish this item in the inventory system.
iteminsurancefee Decimal Represents the insurance cost per unit of the item, typically charged when additional shipping protection is selected.
itemnumberoptions String Lists the item number configuration options, such as variations by color or size, used in matrix items or custom products.
itemoptions String Specifies selectable item options available to customers at checkout, such as personalization, size, or bundle selections.
itemprocessfamily String Groups items by similar manufacturing or handling processes, used for production planning and reporting.
itemprocessgroup String Further categorizes items by operational or workflow similarities, often used in assembly or service delivery.
itemrevenuecategory String Defines the revenue category used for recognition purposes, aligning item sales with financial reporting standards.
itemshipinsurance String Specifies whether insurance is available or required for shipping this item, based on item value or category.
itemtype String Indicates the type of item, such as inventory item, assembly, service, non-inventory, or kit, determining its behavior in transactions.
lastmodifieddate Datetime The date and time the item record was last updated, used for audit and synchronization purposes.
lastpurchaseprice Decimal Represents the most recent purchase price paid for the item, which can influence cost estimation and vendor negotiations.
leadtime Integer The expected number of days required to procure or produce the item from the time it is ordered.
listimmediate String Specifies whether the item is immediately listed on a sales channel (for example, web store) upon creation or update.
listingduration String Specifies the duration of time the item will remain listed for sale on e-commerce platforms, such as eBay.
listingstartdate Date Indicates the calendar date when the item listing becomes active on external sales channels.
listingstarttime String Specifies the time of day when the item listing becomes active, often used in timed campaigns or auctions.
location String Denotes the physical location or warehouse where the item is stored, relevant for fulfillment and inventory tracking.
manufacturer String The name of the company or entity that produces or assembles the item.
manufactureraddr1 String First line of the manufacturer's address, typically containing the street address or PO box.
manufacturercity String The city where the manufacturer is located, used for compliance, logistics, or customs.
manufacturerstate String The state or province of the manufacturer, used for regional tracking and documentation.
manufacturertariff String The tariff code assigned by the manufacturer for customs and international trade classification.
manufacturertaxid String The tax identification number of the manufacturer, used for tax reporting and invoicing.
manufacturerzip String The ZIP or postal code of the manufacturer's address, used for geographic validation and shipping estimates.
matchbilltoreceipt Boolean If the value is 'true', the item requires the bill to be matched to the receipt before processing payment. If the value is 'false', matching is not enforced.
matrixitemnametemplate String Template used to generate display names for matrix items based on options like size and color.
maxdonationamount Decimal Specifies the maximum amount that can be accepted or recorded as a donation for this item.
maximumquantity String Defines the maximum number of units that can be ordered or shipped per transaction.
metataghtml String HTML content used in the meta tag for SEO (Search Engine Optimization) purposes in online listings.
minimumquantity String Indicates the minimum number of units that can be ordered, often used to enforce order thresholds.
minimumquantityunits String Specifies the units (for example, pieces, boxes) in which the minimum quantity is defined.
mpn String Manufacturer Part Number (MPN), used for identifying items across vendors and suppliers.
multmanufactureaddr Boolean If the value is 'true', the item supports multiple manufacturing addresses. If the value is 'false', only a single address is used.
nextagcategory String The category under which the item is listed in the Nextag comparison shopping platform.
nextagproductfeed String Product feed configuration for Nextag, determining how the item is published to that platform.
nopricemessage String Message displayed to users when pricing is unavailable, such as 'Contact us for pricing' or 'Price on request.'
numactivelistings Integer The number of active listings for this item currently published on supported sales channels.
numcurrentlylisted Integer Indicates how many instances of the item are currently listed across marketplaces.
offersupport Boolean If the value is 'true', support or after-sales service is offered with the purchase of the item. If the value is 'false', no support is provided.
outofstockbehavior String Defines how the system handles the item when it is out of stock, such as hiding the item or allowing backorders.
outofstockmessage String The message shown to users when the item is out of stock, such as 'Currently unavailable' or 'Back in stock soon.'
overallquantitypricingtype String Specifies the pricing structure used based on total quantity, such as volume discounts or tiered pricing.
packageheight String The height of the package used for this item, used in dimensional shipping calculations.
packagelength String The length of the package used for this item, important for logistics and carrier pricing.
packagewidth String The width of the item's packaging, used for dimensional shipping calculations and logistics planning.
pagetitle String Custom HTML page title used in search engine results and browser tabs for the item's online listing.
parent String References the parent item for this variant, typically used in matrix or grouped item configurations.
planningitemcategory String Specifies the item category used in supply planning and demand forecasting scenarios.
preferencecriterion String Defines the criteria that determine item preferences in sourcing or fulfillment processes.
preferredlocation String Indicates the default warehouse or inventory location where the item is expected to be stocked or fulfilled from.
preferredstockleveldays Double Specifies the number of days of supply considered optimal for this item at the preferred location.
pricinggroup String Identifies the customer pricing group associated with this item, used for applying group-specific discounts or pricing.
primarycatdisplayname String The display name of the primary category assigned to this item in online store navigation.
primarycategory Integer The internal ID of the primary category to which the item is assigned in web store taxonomy.
printitems Boolean If the value is 'true', the item is included when printing forms like packing slips or sales orders. If the value is 'false', the item is not printed.
prodpricevarianceacct String The general ledger account used to track variances between expected and actual production costs due to price differences.
prodqtyvarianceacct String The account used to record quantity-based variances in production, such as material overuse or waste.
producer Boolean If the value is 'true', indicates that the business acts as the producer or manufacturer of the item. If the value is 'false', the item is sourced externally.
productfeed String Specifies the external product feed (such as Google Shopping or Amazon) where the item is published for marketing or sales.
purchasedescription String Descriptive text used on purchase documents to describe the item to vendors or procurement teams.
purchaseorderamount String Represents the monetary value specified on purchase orders for this item.
purchaseorderquantity String The quantity of the item specified in purchase orders, typically used for procurement planning.
purchaseorderquantitydiff String Displays the difference between the ordered and received quantities for the item on purchase orders.
purchasepricevarianceacct String The general ledger account used to record variances between expected and actual purchase prices.
purchaseunit String Defines the unit of measure used when purchasing this item, such as 'box', 'dozen', or 'each'.
quantitypricingschedule String References the pricing schedule that adjusts the item's unit price based on purchase or sale quantity thresholds.
quantityreorderunits String Specifies the unit of measure used when reordering the item, typically aligned with vendor packaging standards.
receiptamount String The monetary value associated with the received quantity of the item, often used in receiving and billing.
receiptquantity String The quantity of the item received, tracked during the goods receipt process.
receiptquantitydiff String Displays the difference between expected and actual received quantities, helpful for inventory reconciliation.
refundgivenas String Specifies how refunds for this item are issued, such as credit, cash, or replacement.
relateditemsdescription String Marketing or cross-sell description that explains related items or recommended accessories.
reordermultiple String Indicates the quantity increment in which the item must be reordered, typically aligned with vendor packaging.
rescheduleindays Integer Defines how many days an order line can be rescheduled earlier during planning adjustments.
rescheduleoutdays Integer Defines how many days an order line can be pushed out or delayed in scheduling processes.
reserveprice Decimal The minimum price required to successfully sell the item in an auction listing. If bids do not meet this price, the item will not be sold.
returnpolicy String Specifies the general return policy applicable to the item, such as 'No Returns' or '30-Day Returns'.
returnpolicydetails String Provides additional text describing the return policy, such as restocking fees, conditions for returns, or return instructions.
returnshippingpaidby String Indicates whether the buyer or the seller is responsible for paying the return shipping cost.
returnswithin String Defines the allowable time frame within which the item can be returned, such as '30 Days' or '60 Days'.
revenueallocationgroup String References the revenue allocation group used to manage revenue distribution across items or components in bundled sales.
revenuerecognitionrule String Specifies the rule used to determine when and how revenue for this item is recognized according to accounting standards.
revrecforecastrule String Indicates the revenue forecast rule that governs expected revenue timing, particularly for subscription or installment-based sales.
revrecschedule String References the revenue recognition schedule that outlines the specific time periods and amounts for recognizing revenue for this item.
safetystocklevel Double The quantity of the item that should be maintained in inventory at all times to prevent stockouts due to demand spikes or delays.
safetystockleveldays Integer The number of days' worth of inventory to maintain as safety stock based on forecasted demand and lead time.
safetystocklevelunits String The unit of measure (such as 'Each' or 'Case') used to express the safety stock level.
saleunit String Specifies the unit of measure used when selling the item, which may differ from purchasing or stocking units.
schedulebcode String The Schedule B classification code used for exporting goods from the United States, required for customs documentation.
schedulebnumber String The numeric portion of the Schedule B code used for trade compliance reporting.
schedulebquantity String The unit of quantity required for Schedule B reporting, such as 'Kilograms' or 'Liters'.
scrapacct String The general ledger account used to record the cost of scrapped or unusable inventory for this item.
searchkeywords String Comma-separated list of keywords used to improve the item's visibility in search results on web stores or marketplaces.
seasonaldemand Boolean If the value is 'true', indicates that the item experiences fluctuations in demand during specific times of year. If the value is 'false', demand is considered stable year-round.
secondarycatdisplayname String The display name of the secondary category under which the item is listed on a web store or catalog.
secondarycategory Integer The internal ID of the secondary category used to classify the item for online browsing and sorting.
sellonebay Boolean If the value is 'true', the item is listed for sale on eBay. If the value is 'false', it is not available through eBay listings.
shipasia Boolean If the value is 'true', the item is eligible for shipping to countries in Asia. If the value is 'false', shipping to Asia is disabled.
shipaustralia Boolean If the value is 'true', the item can be shipped to Australia. If the value is 'false', the item cannot be shipped there.
shipcanada Boolean If the value is 'true', the item is available for shipment to Canada. If the value is 'false', shipping to Canada is not permitted.
shipeurope Boolean If the value is 'true', the item is available for shipping to European countries. If the value is 'false', shipping to Europe is disabled.
shipgermany Boolean If the value is 'true', the item can be shipped to Germany. If the value is 'false', shipping to Germany is restricted.
shipindividually Boolean If the value is 'true', the item must be shipped separately from other items in the same order due to packaging or handling constraints. If the value is 'false', it can be shipped with other items.
shipjapan Boolean If the value is 'true', the item is eligible for shipment to Japan. If the value is 'false', it is not allowed for shipping there.
shipmexico Boolean If the value is 'true', the item can be shipped to Mexico. If the value is 'false', it is restricted from shipping to Mexico.
shipnorthsouthamerica Boolean If the value is 'true', the item is allowed to ship to countries in North and South America. If the value is 'false', it is excluded from those regions.
shippackage String Specifies the packaging type or container used when shipping the item, such as a box, envelope, or custom packaging.
shippingcost Decimal The base cost charged to the customer for shipping this item, excluding taxes or surcharges.
shippingcostunits String The unit of measure for the shipping cost, typically aligned with the item’s unit (such as per item or per package).
shippingdomesticmethodsgroup String References a predefined group of domestic shipping methods available for this item, used to simplify shipping rule assignments.
shippingdomgroup String Identifies the group of domestic shipping options configured for this item, often tied to regions or zones.
shippingintlgroup String Specifies the set of international shipping methods allowed for this item, applied across all export destinations.
shippingintlgroup1 String The first tier or category of international shipping options available for this item, usually region-specific.
shippingintlgroup2 String The second category of international shipping methods available for this item, allowing further customization by country or service level.
shippingintlgroup3 String The third group of international shipping options, providing additional control over how the item is shipped globally.
shippingitem1 String Specifies the first shipping method or carrier assigned to this item for use in rate calculation and delivery preferences.
shippingitem2 String Defines an alternate shipping method that can be used if the primary method is unavailable or not preferred.
shippingitem3 String Specifies a third fallback shipping method available for delivering the item under certain conditions.
shippinglocationsgroup String Indicates the group of fulfillment or shipping locations authorized to ship this item, used for inventory routing.
shippingpackaginggroup String Defines the group of packaging types or standards associated with this item, used to optimize packing logic.
shippingrate1 Decimal The first tiered shipping rate assigned to this item, often tied to quantity breaks or shipping zones.
shippingrate2 Decimal A secondary tiered shipping rate, used when multiple pricing rules apply for shipping based on destination or method.
shippingrate3 Decimal The third shipping rate tier, useful for offering more granular control over total shipping charges.
shipuk Boolean If the value is 'true', the item is eligible for shipping to the United Kingdom. If the value is 'false', it is restricted from being shipped there.
shipworldwide Boolean If the value is 'true', the item can be shipped to any international destination. If the value is 'false', international shipping is limited or disabled.
shoppingdotcomcategory String The category under which the item is listed on the Shopping.com platform, used for marketing and product feed classification.
shoppingproductfeed String Identifies the product feed configuration used for exporting item data to Shopping.com for external advertising.
shopzillacategoryid Integer The internal ID of the item's category on the Shopzilla marketplace, used to align the product with the correct taxonomy.
shopzillaproductfeed String Defines the product feed assigned to export this item to Shopzilla for inclusion in comparison shopping listings.
showasgift Boolean If the value is 'true', the item is displayed with a 'Gift' label on storefronts or checkout pages. If the value is 'false', it is not marketed as a gift.
showdefaultdonationamount Boolean If the value is 'true', a default donation amount is pre-selected for this item. If the value is 'false', the donation field is left empty.
sitemappriority String Defines the priority level of the item in the website sitemap, used to influence search engine crawling and indexing frequency.
softdescriptor String Specifies the soft descriptor text shown on customer credit card statements, helping identify the merchant or item purpose.
standardimages String References standard product images used across the web store or marketplaces to visually represent the item.
startingprice Decimal The initial price for listing the item in auction-style or tiered pricing formats, such as on eBay.
stockdescription String A brief internal or external description of the item’s inventory characteristics, condition, or special notes.
stockunit String The unit of measure used for tracking the item in inventory, such as 'Each', 'Case', or 'Dozen'.
storecatdisplayname String The display name of the item's primary store category, shown to customers on the e-commerce storefront.
storecatdisplayname2 String The display name of the item's secondary store category, allowing additional classification in the store hierarchy.
storecategory Integer The internal ID referencing the item's primary category within the web store.
storecategory2 Integer The internal ID referencing the item's secondary category within the web store.
storedescription String A brief marketing description of the item shown on the store’s product listing page.
storedetaileddescription String A longer, formatted HTML description that provides in-depth product information for display on the product detail page.
storedisplayimage String The main image file used to represent the item visually in online listings and catalog views.
storedisplayname String The name of the item as displayed on the storefront, typically more user-friendly than the internal name.
storedisplaythumbnail String The thumbnail image of the item used in smaller views, such as product carousels or search results.
storeitemtemplate String Specifies the website item template applied when rendering the item’s product page.
subsidiary String Identifies the subsidiary that owns or manages this item, relevant in multi-entity NetSuite deployments.
supersizeimages Boolean If the value is 'true', the item allows high-resolution images to be displayed in a zoomable format. If the value is 'false', standard resolution applies.
supplyreplenishmentmethod String The method used to restock this item, such as purchasing, manufacturing, or transferring inventory.
supplytimefence Integer Defines the number of days into the future to consider supply planning, limiting how far demand triggers replenishment actions.
taxable Boolean If the value is 'true', the item is subject to sales tax calculations. If the value is 'false', the item is exempt from tax.
taxschedule String The tax schedule that determines how tax is calculated for the item across different regions and jurisdictions.
templatesgroup String References a group of templates used for presenting or printing item data, such as labels, invoices, or listings.
totalvalue Decimal The total inventory value of this item, calculated as cost multiplied by quantity on hand.
tracklandedcost Boolean If the value is 'true', the item tracks landed costs, such as shipping, customs, and insurance. If the value is 'false', these are excluded from cost calculations.
transferprice Decimal The price used when transferring this item between subsidiaries or locations for intercompany transactions.
transferpriceunits String The unit of measure associated with the transfer price, such as 'Each' or 'Pound'.
unbuildvarianceaccount String The general ledger account used to record cost differences that occur when disassembling items.
unitstype String References the set of units (for example, 'Each', 'Box', 'Carton') that the item can be transacted in.
upccode String The Universal Product Code (UPC) assigned to this item for barcode scanning and product identification.
urlcomponent String The URL fragment used to construct the product page’s web address, often based on item name or SKU.
usebins Boolean If the value is 'true', the item participates in bin management within the warehouse. If the value is 'false', bin tracking is not used.
usemarginalrates Boolean If the value is 'true', tax is calculated using marginal tax rates. If the value is 'false', standard rates are used.
vendorname String The default vendor or supplier name associated with the item, used for purchasing and reporting.
vendreturnvarianceaccount String Specifies the account to track cost differences resulting from vendor returns.
vsoedeferral String Determines how revenue for this item is deferred under Vendor-Specific Objective Evidence (VSOE) accounting rules.
vsoedelivered Boolean If the value is 'true', the item is marked as delivered for VSOE revenue recognition. If the value is 'false', delivery is pending.
vsoepermitdiscount String Defines the allowed discount treatment under VSOE guidelines for this item.
vsoeprice Decimal The VSOE price used in revenue allocation calculations.
vsoesopgroup String Groups the item for VSOE purposes to determine how items are bundled and evaluated for revenue allocation.
weight Double The physical weight of the item, typically used for shipping calculations.
weightunit String The unit of measure for the item's weight, such as 'Pounds' or 'Kilograms'.
weightunits String Alternate field specifying available units for weight, relevant for multi-unit tracking.
willship String Indicates whether the item is available for shipping and under what conditions (for example, 'Always', 'Sometimes').
wipacct String The Work-in-Process (WIP) account used to track costs while the item is being manufactured.
wipvarianceacct String The account used to capture cost differences during the production process.
yahooproductfeed String Defines the product feed configuration for publishing this item to Yahoo Shopping or related marketplaces.

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