assemblyitem
The AssemblyItem table contains information about assembly items, which are manufactured products composed of multiple components.
Columns
| Name | Type | References | Description |
| alternatedemandsourceitem | String | The designated alternative item that can be used to fulfill demand when the primary item is unavailable. This item supports business continuity by reducing stockouts, ensuring customer satisfaction, and maintaining supply chain flexibility. | |
| assetaccount | String | The general ledger account that is used to track the financial value of this assembly item as an asset. This account ensures proper accounting for inventory valuation, asset depreciation, and balance sheet reporting. | |
| atpmethod | String | The Available-to-Promise (ATP) method that is used to calculate whether inventory is available to meet demand. This method can be based on supply chain forecasts, existing stock, and lead times to optimize order fulfillment. | |
| auctionquantity | String | The quantity of this item available for auction-based sales. This field is used in online marketplaces and dynamic pricing strategies to manage bidding constraints and stock availability. | |
| auctiontype | String | The type of auction applicable to this item (for example, such as 'standard,' 'reserve,' or 'buy-it-now'). The auction type determines the bidding structure and sale conditions for this product. | |
| autoleadtime | Boolean | Indicates whether the system automatically calculates the lead time that is required to procure or manufacture this item. This value ensures that replenishment cycles align with demand fluctuations and supplier performance. | |
| autopreferredstocklevel | Boolean | Specifies whether the preferred stock level for this item is dynamically determined based on historical sales, demand forecasting, and inventory turnover rates. This feature helps maintain optimal stock levels. | |
| autoreorderpoint | Boolean | Indicates whether the system should automatically calculate the reorder point for this item, ensuring that stock is replenished before running out. This field prevents stockouts and maintains efficient supply chain operations. | |
| availabletopartners | Boolean | Defines whether this item is visible and available for purchase by business partners in a multiple-tier distribution model. This field enables controlled sharing of inventory within partner networks, supporting business-to-business (B2B) sales and collaborative supply chain management. | |
| averagecost | Decimal | The system-calculated average cost per unit of this item, based on purchase history, production expenses, and costing methods. This cost is used in financial reporting, profitability analysis, and inventory valuation. | |
| billexchratevarianceacct | String | The general ledger account that records exchange rate variances related to supplier billing. This account ensures that fluctuations in currency conversion are properly accounted for in financial statements. | |
| billingschedule | String | The predefined invoicing schedule associated with this item, specifying how and when customers are billed. This schedule is commonly used for recurring revenue models, installment payments, or subscription-based services. | |
| billpricevarianceacct | String | The general ledger account that captures discrepancies between estimated and actual billed prices. This account is crucial for variance analysis, contract compliance, and profitability tracking. | |
| billqtyvarianceacct | String | The account that is used to track differences between estimated and actual billed quantities. This account ensures accurate financial reconciliation, helping organizations detect billing discrepancies and prevent revenue leakage. | |
| buildentireassembly | Boolean | Indicates whether this item must be fully assembled in one production run or whether partial builds are allowed. This setting impacts production scheduling, labor allocation, and supply chain planning. | |
| buildtime | Double | The estimated time that is required to fully assemble one unit of this item. This field is used in production planning, labor scheduling, and efficiency analysis to optimize manufacturing workflows. | |
| buildtimelotsize | Double | The standard lot size for which build time is calculated. This lot size ensures accurate estimates for assembly duration and supports batch processing in production environments. | |
| buyitnowprice | Decimal | The fixed price at which customers can immediately purchase this item in an auction-based marketplace, bypassing the bidding process. This strategy is commonly used for high-demand products to encourage instant purchases. | |
| class | String | The classification or category that is assigned to this item, which helps in financial segmentation, inventory organization, and reporting. This classification can influence taxation, pricing strategies, and cost allocation. | |
| cogsaccount | String | The general ledger account that records the cost of goods sold (COGS) for this item. This account is a critical component of financial accounting, used for calculating gross margins and tracking profitability. | |
| conditionenabled | String | Indicates whether conditional rules are applied to this item. This field is useful for dynamic pricing, promotional eligibility, or specific workflow requirements based on predefined conditions. | |
| conditionhelpurl | String | A Uniform Resource Locator (URL) link to documentation or help resources explaining the conditions and rules applied to this item. This URL assists users in configuring and troubleshooting item-specific conditions. | |
| consumptionunit | String | The unit of measure (UOM) in which this item is consumed or used (for example, 'pieces,' 'kilograms,' or 'liters'). This UOM ensures accurate inventory tracking, pricing, and billing calculations. | |
| copydescription | Boolean | Determines whether the item's description should be automatically copied to related transactions such as sales orders, invoices, or purchase orders. This field maintains consistency and saves manual entry time. | |
| cost | Decimal | The standard or base cost of the item, which is used for financial forecasting, pricing strategies, and margin analysis. This cost value affects profitability calculations and cost-based pricing models. | |
| costcategory | String | The predefined cost category that is associated with this item, which is used for financial reporting, cost allocation, and budget tracking. This cost category helps in grouping expenses under relevant accounting categories. | |
| costestimate | Decimal | The projected cost to produce or procure this item. This estimate is used for budgeting, financial planning, and cost control in supply chain management (SCM). | |
| costestimatetype | String | The methodology that is used to estimate costs for this item (for example, 'standard cost,' 'average cost,' or 'last purchase cost'). This selection determines how cost calculations impact financial statements. | |
| costingmethod | String | The inventory costing method that is assigned to this item (for example, First-In, First-Out [FIFO]; Last-In, First Out [LIFO]; or weighted average cost). This costing method impacts cost accounting and inventory valuation. | |
| costingmethoddisplay | String | A user-friendly display format of the costing method that is used for this item. This display format ensures transparency and understanding in financial reports and inventory management. | |
| costunits | String | The UOM that is used in cost calculations, ensuring consistency in pricing, inventory valuation, and financial reporting. | |
| countryofmanufacture | String | The country where this item is manufactured. This field is crucial for compliance with import/export regulations, country-of-origin labeling, and tariff applications. | |
| createddate | Datetime | The date and time when this item record was created. This timestamp is used for audit tracking, historical analysis, and system monitoring. | |
| createrevenueplanson | String | Specifies the conditions under which revenue plans are generated for this item. This field is important for revenue recognition policies, contract-based billing, and financial forecasting. | |
| currency | String | The currency in which financial transactions that are related to this item are recorded. This field ensures accuracy in multi-currency environments, supports global financial compliance, and maintains consistent pricing strategies. | |
| customform | String | The predefined custom form that is associated with this item, determining the layout and fields used when entering or editing records in the system. This custom form supports process customization and compliance with business workflows. | |
| custreturnvarianceaccount | String | The general ledger account used to track discrepancies in customer returns, such as differences in refund amounts or returned quantities. This account ensures accurate reconciliation in financial statements. | |
| defaultrevision | String | The default revision level that is assigned to this item. This revision level ensures that product updates, design modifications, or quality improvements are version-controlled for manufacturing, inventory, and sales tracking. | |
| deferredrevenueaccount | String | The general ledger account that is used to record deferred revenue for this item. This account is critical for compliance with revenue recognition policies, ensuring that revenue is reported in the appropriate period. | |
| deferrevrec | Boolean | Indicates whether revenue recognition for this item is deferred. If this field is enabled, revenue from this item is recognized over time rather than immediately upon sale, in accordance with accounting standards. | |
| demandmodifier | String | A variable that is used to adjust demand calculations for this item based on market conditions, promotional campaigns, or seasonality. This variable helps refine demand forecasting and inventory planning. | |
| demandtimefence | Integer | The number of days within which demand changes are restricted, preventing late-stage fluctuations from affecting supply chain planning. This information stabilizes production schedules and procurement strategies. | |
| department | String | The department that is responsible for managing this item, used for financial tracking, budget allocation, and reporting purposes within the organization. | |
| description | String | A detailed text description of this item, providing essential information for purchasing, sales, and inventory management. This description can be displayed in catalogs, invoices, and online listings. | |
| directrevenueposting | Boolean | Determines whether revenue from this item is posted directly to the general ledger without being deferred. This setting is important for cash-flow management and revenue-recognition compliance. | |
| displayinebaystore | Boolean | Indicates whether this item is listed and visible in an eBay store. If this field is enabled, it allows the item to be sold through an online marketplace, expanding sales channels. | |
| displayname | String | The name of this item as displayed in user interfaces, product catalogs, and reports. This name is used to improve searchability and consistency in item identification. | |
| distributioncategory | String | A classification that is used to categorize this item within a distribution network. This classification helps in organizing supply chain logistics, warehouse storage, and shipping prioritization. | |
| distributionnetwork | String | The specific distribution network or supply-chain channel through which this item is allocated. This field ensures proper routing for fulfillment, regional availability, and inventory optimization. | |
| dontshowprice | Boolean | Specifies whether this item's price should be hidden on public-facing sales channels, catalogs, or customer portals. This field is useful for negotiated pricing models and tiered discount structures. | |
| dropshipexpenseaccount | String | The general ledger account used to track expenses related to drop-shipped items. This account ensures proper financial reporting for cost of sales without affecting internal inventory balances. | |
| ebayhandlingtime | String | The estimated time that is required to process and prepare this item for shipment when sold on eBay. This estimation affects customer expectations and delivery commitments. | |
| ebayintlinsurancefee | Decimal | The insurance fee that is applied to international eBay shipments for this item, covering potential loss or damage during transit. | |
| ebayintlpackagehandlingfee | Decimal | An additional handling fee that is charged for international shipments of this item, accounting for packaging, customs processing, or extra handling requirements. | |
| ebayintlshipinsurance | String | Indicates whether international shipping insurance is available for this item when sold on eBay. This field impacts customer confidence and risk mitigation in cross-border transactions. | |
| ebayisintlcalculatedrate | String | Specifies whether international shipping rates for this item are dynamically calculated based on its weight, dimensions, and destination. This field ensures accurate shipping cost estimation. | |
| ebayisirregularpackage | Boolean | Determines whether this item is classified as an irregular package for eBay shipping. If this field is enabled, special shipping requirements or additional charges might apply. | |
| ebayitemdescription | String | The description of this item as it appears on its eBay listing. This text provides potential buyers with relevant product details, specifications, and selling points. | |
| ebayitemlocdisplay | String | Determines whether the item's location is displayed on its eBay listing. This field helps buyers assess shipping times and potential regional restrictions. | |
| ebayitemloczipcode | String | The ZIP code of the item's shipping location for eBay transactions. This ZIP code is used to calculate shipping rates, delivery estimates, and location-based fees. | |
| ebayitemlots | Integer | The number of units that are included per lot when selling this item on eBay. This number defines bulk-sale pricing and ensures proper inventory tracking for lot-based transactions. | |
| ebayitemsubtitle | String | An optional subtitle that is displayed beneath the main title of the eBay listing. This subtitle is used to add additional promotional details or highlight unique selling points of the product. | |
| ebayitemtitle | String | The main title that is used for this item’s eBay listing, serving as the primary identifier in search results and product pages. This title should be optimized for discoverability and relevance. | |
| ebayitemweightamt | String | The recorded weight of the item for eBay transactions. This weight is used in shipping cost calculations and carrier selection. | |
| ebaylayout | String | The selected eBay layout template that defines the appearance and design of the listing. This template helps maintain a consistent branding and presentation strategy. | |
| ebaypackagetype | String | The packaging type that is used for shipping this item via eBay. Examples include 'Box,' 'Envelope,' or 'Tube,' which impact carrier options and shipping rates. | |
| ebaypagecounter | String | Indicates whether an eBay page counter is displayed on the listing, tracking the number of views and visitor engagement metrics. | |
| ebayrelistingoption | String | The selected relisting option for this item on eBay. This option determines whether an item is automatically relisted if it does not sell within the initial listing period. | |
| ebaytheme | String | The applied theme for the eBay store in which this item is listed. This theme ensures branding consistency and a visually appealing online storefront. | |
| ebaythemegroup | String | The designated theme group for this item’s eBay listing, ensuring branding consistency and alignment with predefined store aesthetics. This field helps maintain a cohesive visual presentation across multiple product listings. | |
| effectivebomcontrol | String | The control method used for managing the Bill of Materials (BOM) that is associated with this item. This method determines how and when changes to the BOM take effect in production, ensuring accurate tracking of components, costs, and materials. | |
| endauctionswhenoutofstock | Boolean | Specifies whether active eBay auctions for this item should automatically end when the inventory level reaches zero. Enabling this feature prevents overselling and ensures accurate stock availability across sales channels. | |
| enforceminqtyinternally | Boolean | Indicates whether the system enforces a predefined minimum quantity threshold when processing transactions. This prevents depletion of essential inventory levels, ensuring stock availability for critical operations and customer orders. | |
| excludefromsitemap | Boolean | Determines whether this item should be excluded from the website’s sitemap, preventing search engines from indexing it. This field is useful for items not meant for public sale, internal-use products, or restricted-access inventory. | |
| externalid | String | A unique identifier (Id) that is assigned to this item for integration with external systems, such as third-party e-commerce platforms, enterprise resource planning (ERP) solutions, or supply-chain networks. This Id ensures seamless data synchronization across multiple business applications. | |
| fixedbuildtime | Double | The standard fixed time that is required to assemble this item, irrespective of the quantity produced. This fixed time is a critical factor in production planning, labor scheduling, and efficiency calculations for manufacturing operations. | |
| froogleproductfeed | String | Indicates whether this item is included in Google Shopping (formerly Froogle) product feeds. Ensuring inclusion in product feeds improves discoverability and enhances online marketing strategies. | |
| futurehorizon | String | The timeframe that is used for demand forecasting and long-term planning for this item. This setting helps businesses anticipate future inventory needs, align production schedules, and mitigate supply chain risks. | |
| gainlossaccount | String | The general ledger account used to track gains or losses resulting from fluctuations in foreign exchange rates when transactions involving this item are processed in multiple currencies. This account is critical for financial reconciliation and compliance. | |
| gallery | Boolean | Specifies whether this item is eligible to be displayed in an eBay gallery. Featuring products in an eBay gallery improves visibility, increasing the likelihood of attracting potential buyers. | |
| galleryfeatured | Boolean | Determines whether this item should receive premium placement as a featured product in an eBay gallery. Featured items gain increased exposure and priority placement in search results, boosting sales potential. | |
| gifttypeexpressship | Boolean | Indicates whether this item qualifies for express shipping when purchased as a gift. Enabling this feature provides buyers with faster shipping options, improving customer satisfaction and service levels. | |
| gifttypegiftwrap | Boolean | Specifies whether this item is eligible for gift wrapping during the checkout process. Enabling this feature enhances the customer experience by offering additional customization and presentation options for gift purchases. | |
| gifttypeshiptorecipient | Boolean | Determines whether this item can be shipped directly to a recipient as part of a gift purchase. This field is essential for gift services, corporate gifting programs, and personalized order fulfillment. | |
| handlingcost | Decimal | The additional cost that is incurred for handling this item during fulfillment, including packaging, special processing, and labor expenses. This cost is factored into shipping calculations to ensure profitability and cost recovery. | |
| handlingcostunits | String | The UOM that is used for calculating handling costs (for example, 'per item,' 'per order,' or 'per shipment'). Defining this UOM ensures accurate pricing and cost allocation in financial reporting and invoicing. | |
| handlinggroup | String | The designated handling group for this item, which determines the specific fulfillment rules, shipping restrictions, and additional processing requirements based on business policies. | |
| imagesgroup | String | A grouping of images that are associated with this item. This grouping ensures a structured approach to managing product visuals across online listings, marketing materials, and internal documentation. | |
| imageslocation | String | The location or URL path where this item's images are stored, either in a digital asset-management system, an e-commerce platform, or an internal server. This location enables efficient retrieval and display of product visuals. | |
| includechildren | Boolean | Indicates whether child items (such as components, variations, or sub-assemblies) should be included when referencing this assembly item. This field ensures accurate BOM processing, inventory tracking, and cost roll-up calculations. | |
| incomeaccount | String | The general ledger account where revenue from the sale of this item is recorded. Assigning the correct income account ensures accurate financial reporting and revenue recognition compliance. | |
| intercocogsaccount | String | The intercompany Cost of Goods Sold (COGS) account that is used for transactions involving sales between different business entities or subsidiaries within the same organization. This account ensures correct internal cost allocations and eliminates duplicate expense recognition. | |
| intercoincomeaccount | String | The intercompany income account that is used to recognize revenue when this item is sold between different legal entities within the organization. Proper account mapping ensures financial compliance and consistency in intercompany transactions. | |
| internalid | Integer | The system-generated unique Id that is assigned to this item within the database. This internal Id is used for record tracking, reporting, and system automation purposes. | |
| iscalculatedrate | String | Specifies whether the pricing or shipping rate for this item is dynamically calculated based on predefined formulas, such as weight-based shipping, volume pricing, or real-time carrier rates. | |
| isdonationitem | Boolean | Indicates whether this item is classified as a donation, meaning it is provided to customers, charities, or organizations without direct revenue generation. This classification is important for tax reporting and charitable contribution tracking. | |
| isdropshipitem | Boolean | Determines whether this item is eligible for drop-shipping, meaning it is fulfilled directly by a third-party supplier rather than being stocked in internal inventory. Drop-shipping reduces holding costs and expands product availability without requiring warehouse storage. | |
| isgcocompliant | Boolean | Specifies whether this item complies with Google Checkout (GCO) payment-processing requirements. This field ensures compatibility with Google’s payment and order processing systems for seamless e-commerce transactions. | |
| isinactive | Boolean | Indicates whether this item is currently inactive, meaning it is not available for sale, purchase, or inventory tracking. Inactive items remain in the system for historical records and audit purposes but cannot be used in transactions. | |
| isonline | Boolean | Determines whether this item is available for online sales through e-commerce platforms, marketplaces, or customer portals. If this field is enabled, this item can be purchased through digital channels. | |
| isphantom | Boolean | Specifies whether this item is a phantom item, meaning it is used only for planning purposes and does not exist as a physical stock item. Phantom items are commonly used in kitting, virtual bundling, or production-planning scenarios. | |
| isspecialorderitem | Boolean | Indicates whether this item is a special order item, meaning it is not regularly stocked and must be specifically requested from a supplier upon customer purchase. | |
| isspecialworkorderitem | Boolean | Determines whether this item requires a specialized work order for manufacturing or assembly. Special work-order items often involve custom builds, unique configurations, or made-to-order production. | |
| isstorepickupallowed | Boolean | Specifies whether this item is eligible for in-store pickup as a fulfillment option. Enabling this field supports omnichannel retail strategies by allowing customers to purchase online and collect in person. | |
| issueproduct | String | Defines the related product that is issued when this item is sold or consumed in inventory. This field ensures correct tracking of inventory adjustments, replacements, or substitute products. | |
| itemcondition | String | Specifies the condition of this item (for example, 'New,' 'Refurbished,' or 'Used'). Proper classification ensures accurate pricing, compliance with marketplace standards, and clear customer expectations. | |
| itemhandlingfee | Decimal | The additional handling fee charged for this item, covering extra costs related to special packaging, fragile item processing, or labor-intensive fulfillment. | |
| itemid | String | The unique system-generated Id for this item, which is used for inventory tracking, sales processing, and reporting purposes. This Id ensures consistency across transactions and business applications. | |
| iteminsurancefee | Decimal | The insurance fee that is applied to this item during shipping, providing coverage against loss, theft, or damage while in transit. This fee is an optional charge based on carrier policies or customer preferences. | |
| itemoptions | String | A list of customizable options available for this item (for example, size, color, or material). These options allow for product variations and enhance customer selection in sales and e-commerce environments. | |
| itemrevenuecategory | String | The revenue category that is assigned to this item, which determines how its sales revenue is classified in financial reporting. This category is essential for revenue tracking, tax compliance, and financial analysis. | |
| itemshipinsurance | String | Indicates whether shipping insurance is available for this item, protecting against loss or damage in transit. This field can be optional or required based on shipping policies. | |
| itemtype | String | The classification of this item (for example, 'inventory item,' 'assembly item,' 'non-inventory item,' or 'service'). The item type determines how it is managed in inventory, sales, and financial accounting. | |
| lastmodifieddate | Datetime | The date and time when this item record was last updated. This timestamp is useful for audit tracking, synchronization with external systems, and change history management. | |
| lastpurchaseprice | Decimal | The most recent purchase price of this item, reflecting the last recorded cost from a vendor or supplier. This purchase price is important for cost tracking, pricing strategies, and margin analysis. | |
| leadtime | Integer | The estimated number of days that are required to procure or manufacture this item before it becomes available for sale or use. Lead time is crucial for demand planning and inventory management. | |
| listimmediate | String | Indicates whether this item should be immediately listed for sale upon entry into the system. This setting is commonly used in e-commerce and online marketplace integrations. | |
| listingduration | String | The period for which this item remains listed for sale on an online platform, such as eBay or an e-commerce website. This period affects the visibility and expiration of the listing. | |
| listingstartdate | Date | The date on which this item's listing becomes active in an online marketplace. This date ensures coordinated product launches and marketing campaigns. | |
| listingstarttime | String | The specific time of day when this item's listing becomes active. This timestamp is often used for timed product releases, auction start times, or flash sales. | |
| location | String | The primary location where this item is stored, shipped from, or available for purchase. Location tracking is essential for inventory management, logistics, and fulfillment operations. | |
| manufacturer | String | The name of the company or entity that manufactures this item. This information is used for vendor management, sourcing, and compliance with regulatory requirements. | |
| manufactureraddr1 | String | The first line of the manufacturer's address, typically including the street address or P.O. Box. This address line is used for supplier tracking, regulatory filings, and logistics coordination. | |
| manufacturercity | String | The city where the manufacturer is located, relevant for regulatory compliance, shipping calculations, and supplier relationship management. | |
| manufacturerstate | String | The state or province in which the manufacturer is based. This field is important for tax calculations, trade compliance, and logistics planning. | |
| manufacturertariff | String | The tariff code or Harmonized System (HS) code that is assigned to this item by the manufacturer. This code is crucial for international trade, customs clearance, and import/export documentation. | |
| manufacturertaxid | String | The tax identification number (TIN) of the manufacturer, which is used for tax reporting, invoicing, and compliance with VAT/GST regulations. | |
| manufacturerzip | String | The postal or ZIP code of the manufacturer’s location, supporting logistics, tax calculations, and supply-chain management. | |
| matchbilltoreceipt | Boolean | Specifies whether billing for this item should be matched to the receipt of goods, ensuring accurate financial reconciliation and fraud prevention. | |
| matrixitemnametemplate | String | A naming convention template that is used to generate names for matrix (variant) items. This template ensures consistency in product catalogs and inventory records. | |
| maxdonationamount | Decimal | The maximum monetary value or quantity that is allowed for donation transactions involving this item. This quantity is used for tax deductions, corporate giving programs, and donation limits. | |
| maximumquantity | String | The highest quantity of this item that can be purchased in a single transaction. This quantity helps enforce inventory controls, bulk purchase restrictions, and promotional limits. | |
| metataghtml | String | HTML metadata tags that are associated with this item, which are used for search engine optimization (SEO) in e-commerce platforms and product listing pages. | |
| minimumquantity | String | The lowest allowable quantity of this item that can be ordered or maintained in stock. This quantity is essential for order processing, bulk discounts, and procurement controls. | |
| minimumquantityunits | String | The UOM that is used when enforcing minimum quantity requirements (for example, 'pieces,' 'boxes,' or 'kilograms'). This UOM ensures accurate inventory tracking and purchasing rules. | |
| mpn | String | The Manufacturer Part Number (MPN) for this item, assigned by the manufacturer to uniquely identify it. MPNs help in supply-chain standardization, product identification, and cross-referencing in procurement. | |
| multmanufactureaddr | Boolean | Indicates whether this item has multiple manufacturer addresses, supporting complex supply chain structures, vendor diversification, and sourcing flexibility. | |
| nextagcategory | String | The assigned product category for Nextag, an online comparison shopping engine. Categorization improves search visibility and ensures proper listing placement in Nextag’s marketplace. | |
| nextagproductfeed | String | Indicates whether this item is included in the Nextag product feed, enabling its visibility on the price comparison platform and supporting e-commerce marketing efforts. | |
| nopricemessage | String | A message that is displayed when the item’s price is not available or hidden from the public. This message is often used for custom quotes, special promotions, or B2B pricing models. | |
| numactivelistings | Integer | The total number of active listings for this item across various online marketplaces. This number helps track product availability and monitor e-commerce performance. | |
| numcurrentlylisted | Integer | The number of instances of this item that is currently listed for sale on online platforms. This number is useful for monitoring stock levels and preventing duplicate listings. | |
| offersupport | Boolean | Indicates whether this item includes customer support or warranty services, helping businesses communicate post-purchase support options to customers. | |
| outofstockbehavior | String | Defines the system behavior when this item goes out of stock (for example, 'hide listing,' 'allow backorders,' or 'notify customers'). This setting ensures proper inventory management and customer communication. | |
| outofstockmessage | String | A customizable message displayed to customers when this item is out of stock. This message can inform buyers about restocking dates, backorder options, or alternative products. | |
| overallquantitypricingtype | String | Specifies the pricing type that is applied when calculating quantity-based pricing for bulk purchases. This pricing type helps businesses implement tiered pricing strategies to encourage larger orders. | |
| packageheight | String | The height of the packaged item, used for shipping calculations, carrier rate determination, and warehouse storage planning. | |
| packagelength | String | The length of the packaged item, essential for logistics, dimensional weight pricing, and warehouse storage allocation. | |
| packagewidth | String | The width of the packaged item, used for optimizing shipping costs, pallet configuration, and fulfillment processes. | |
| pagetitle | String | The title of the item's webpage or product listing, optimized for search engines (SEO) and online marketplace visibility. | |
| parent | String | The parent item that is associated with this product. Typically, this item is used in item hierarchies such as matrix items, kits, or assemblies to establish relationships between variations. | |
| planningitemcategory | String | The planning category that is assigned to this item, determining how it is managed in supply-chain planning, inventory forecasting, and replenishment strategies. | |
| preferencecriterion | String | Defines the criteria that is used to determine the preferred supplier or fulfillment source for this item. This criteria ensures optimal procurement and stock allocation. | |
| preferredlocation | String | The default warehouse or inventory location that is designated for storing or fulfilling this item. This setting optimizes logistics, fulfillment efficiency, and stock replenishment. | |
| preferredstockleveldays | Double | The number of days of inventory supply to maintain at the preferred stock level. This information helps businesses balance inventory turnover with demand forecasting. | |
| pricinggroup | String | The pricing group to which this item belongs. This pricing group is used for managing bulk discounts, promotional pricing, or customer-specific price lists. | |
| primarycatdisplayname | String | The display name of the primary category that is assigned to this item. This display name ensures proper categorization and discoverability in online stores and product catalogs. | |
| primarycategory | Integer | The primary category Id that is assigned to this item. This Id determines its classification in product hierarchies, inventory reports, and e-commerce platforms. | |
| printitems | Boolean | Specifies whether this item should be included in printed sales documents such as invoices, packing slips, and order confirmations. | |
| prodpricevarianceacct | String | The general ledger account that is used to track variances in the production cost of this item due to price fluctuations in raw materials or manufacturing expenses. | |
| prodqtyvarianceacct | String | The account that is used to track discrepancies between expected and actual production quantities. This account ensures accurate financial reconciliation and cost control. | |
| producer | Boolean | Indicates whether this item is classified as a producer item, meaning it generates another item or is part of a production process. This field affects manufacturing workflows and cost tracking. | |
| productfeed | String | Defines whether this item is included in external product feeds for online marketplaces, comparison shopping engines, and advertising platforms such as Google Shopping. | |
| purchasedescription | String | The description of this item as it appears on purchase orders. This description is used for supplier communication, procurement documentation, and receiving processes. | |
| purchaseorderamount | String | The total monetary amount for this item in purchase orders, reflecting procurement costs and budget allocations. | |
| purchaseorderquantity | String | The quantity of this item that is included in purchase orders. This quantity ensures accurate inventory replenishment and vendor fulfillment tracking. | |
| purchaseorderquantitydiff | String | The difference between the ordered and received quantities for this item in purchase orders. This difference helps identify discrepancies and manage supplier performance. | |
| purchasepricevarianceacct | String | The account that is used to track price variances between the standard purchase price and the actual cost paid. This account ensures financial transparency and budget control. | |
| purchaseunit | String | The UOM in which this item is purchased from suppliers (for example, 'cases,' 'pallets,' or 'kilograms'). This UOM affects procurement and inventory tracking. | |
| quantitypricingschedule | String | The predefined pricing schedule for quantity-based discounts. This schedule allows businesses to offer lower prices for bulk purchases. | |
| quantityreorderunits | String | The standard unit in which this item is reordered, ensuring consistency in procurement and inventory replenishment strategies. | |
| receiptamount | String | The total monetary value of this item received from suppliers. This value helps reconcile payments with purchase orders and financial records. | |
| receiptquantity | String | The actual quantity of this item received in inventory upon delivery. This quantity ensures alignment between purchase orders and received stock. | |
| receiptquantitydiff | String | The difference between the ordered and received quantities of this item. This information identifies potential errors, supplier inconsistencies, or inventory miscounts. | |
| refundgivenas | String | The method by which refunds for this item are issued (for example, store credit, cash, or replacement items). This method ensures compliance with return policies. | |
| relateditemsdescription | String | A description of related items commonly purchased with this product. This description supports upselling and cross-selling strategies in e-commerce and retail environments. | |
| reordermultiple | String | The fixed quantity in which this item should be reordered. This quantity ensures efficient stock replenishment and supplier order fulfillment. | |
| rescheduleindays | Integer | The number of days an incoming order for this item can be rescheduled earlier based on demand fluctuations and inventory needs. | |
| rescheduleoutdays | Integer | The number of days an order for this item can be postponed without disrupting supply chain operations or order fulfillment schedules. | |
| reserveprice | Decimal | The minimum price that must be met in an online auction before the item can be sold. This minimum price prevents the item from being sold below a set threshold, ensuring profitability in auction-based sales. | |
| returnpolicy | String | The general return policy for this item, outlining the conditions under which returns are accepted. This field is critical for customer satisfaction and regulatory compliance. | |
| returnpolicydetails | String | Additional details about the return policy, such as restocking fees, condition requirements, or special terms applicable to specific customer groups or markets. | |
| returnshippingpaidby | String | Specifies who is responsible for paying the return shipping costs, either the buyer or seller. This specification affects return policies and customer service strategies. | |
| returnswithin | String | Defines the timeframe within which a return request must be initiated after purchase. This timeframe is used to enforce return policies and protect both buyers and sellers. | |
| revenueallocationgroup | String | The revenue allocation group that determines how revenue is distributed across multiple products or services in a bundled sale. This information ensures compliance with revenue recognition standards. | |
| revenuerecognitionrule | String | The specific revenue recognition rule that is applied to this item. This rule determines when and how revenue from its sale is recorded in financial statements. | |
| revrecforecastrule | String | The revenue recognition forecast rule used to project revenue over a period of time. This rule ensures alignment with accounting principles and financial forecasting. | |
| revrecschedule | String | The predefined schedule dictating how revenue from this item is recognized over time, such as immediate recognition, percentage-of-completion, or deferred revenue models. | |
| safetystocklevel | Double | The minimum quantity of this item that should always be maintained in stock to prevent shortages. This quantity is used in inventory management to reduce the risk of stockouts. | |
| safetystockleveldays | Integer | The number of days of inventory coverage the safety stock level should provide. This number ensures that fluctuations in demand or supply-chain delays do not disrupt operations. | |
| safetystocklevelunits | String | The UOM that is used for tracking the safety stock level (for example, 'units,' 'cases,' or 'pallets'). This UOM ensures accurate replenishment calculations. | |
| saleunit | String | The UOM in which this item is sold. This UOM ensures consistent pricing, inventory tracking, and order fulfillment. | |
| schedulebcode | String | The Schedule B code that is used for U.S. export reporting. This cod ensures compliance with international trade regulations and facilitating customs documentation. | |
| schedulebnumber | String | The classification number that is assigned under the Schedule B system for tracking exported goods, required for regulatory reporting and trade compliance. | |
| schedulebquantity | String | The quantity unit that is required for Schedule B export reporting (for example, 'dozen' or 'kilograms'). This unit ensures standardized measurement for trade reporting. | |
| scrapacct | String | The general ledger account used to record the cost of scrapped or discarded items. This account ensures proper tracking of waste and inventory write-offs. | |
| searchkeywords | String | A list of keywords associated with this item to improve search engine discoverability in e-commerce platforms, online marketplaces, and internal catalogs. | |
| seasonaldemand | Boolean | Indicates whether this item experiences seasonal fluctuations in demand. This value affects inventory planning, marketing strategies, and production scheduling. | |
| secondarycatdisplayname | String | The display name of the secondary category assigned to this item. This display name ensures proper classification and searchability in product catalogs and e-commerce sites. | |
| secondarycategory | Integer | The secondary category Id that is assigned to this item. This Id provides additional classification beyond the primary category for better product organization. | |
| sellonebay | Boolean | Specifies whether this item is listed for sale on eBay. This field enables businesses to expand their online marketplace presence. | |
| shipasia | Boolean | Indicates whether this item can be shipped to countries in Asia. This field ensures accurate shipping policy enforcement and international order processing. | |
| shipaustralia | Boolean | Indicates whether this item can be shipped to Australia, ensuring compliance with regional shipping restrictions and fulfillment options. | |
| shipcanada | Boolean | Determines whether this item is available for shipping to Canada. This field allows businesses to manage cross-border sales and logistics efficiently. | |
| shipeurope | Boolean | Indicates whether this item can be shipped to European countries. This field ensures that proper tax, customs, and shipping regulations are accounted for. | |
| shipgermany | Boolean | Specifies whether this item can be shipped to Germany. This field ensures compliance with EU trade regulations and shipping policies. | |
| shipindividually | Boolean | Indicates whether this item must be shipped separately from other items in an order due to size, weight, or packaging constraints, affecting fulfillment and shipping costs. | |
| shipjapan | Boolean | Determines whether this item is available for shipping to Japan. This field ensures proper international shipping logistics and compliance with customs regulations. | |
| shipmexico | Boolean | Indicates whether this item can be shipped to Mexico. This field ensures proper tax calculation and cross-border shipping compliance. | |
| shipnorthsouthamerica | Boolean | Determines whether this item is available for shipping to countries in North and South America, affecting international fulfillment strategies. | |
| shippackage | String | The package type that is used for shipping this item (for example, 'box,' 'envelope,' or 'tube'). This package type ensures compatibility with carrier shipping policies. | |
| shippingcost | Decimal | The cost that is associated with shipping this item, either as a fixed amount or dynamically calculated based on carrier rates and customer location. | |
| shippingcostunits | String | The UOM that is used to calculate shipping costs (for example, 'per item,' 'per weight unit,' or 'per order'). This UOM ensures accurate pricing. | |
| shippingdomesticmethodsgroup | String | A grouping of domestic shipping methods available for this item (for example, standard, expedited, or overnight shipping). | |
| shippingdomgroup | String | Defines the domestic shipping-policy group for this item. This field ensures that shipping options are properly assigned based on customer location. | |
| shippingintlgroup | String | Defines the international shipping-policy group for this item. This field ensures compliance with regional carrier availability, customs duties, and international shipping restrictions. | |
| shippingintlgroup1 | String | The first set of international shipping methods assigned to this item. This method set helps businesses manage country-specific logistics options. | |
| shippingintlgroup2 | String | The second set of international shipping options available for this item. This method set ensures flexibility in global shipping strategies. | |
| shippingintlgroup3 | String | The third set of international shipping methods assigned to this item. This method set allows for diversified shipping options across multiple regions. | |
| shippingitem1 | String | The first designated shipping item or method that is associated with this product. This item or method defines specific carrier options, shipping tiers, or flat-rate shipping for fulfillment operations. | |
| shippingitem2 | String | The second designated shipping item or method for this product. This item or method provides an alternative shipping option for different regions, customer preferences, or delivery timeframes. | |
| shippingitem3 | String | The third designated shipping item or method available for this product. This item or method enables multiple shipping choices across various fulfillment strategies. | |
| shippinglocationsgroup | String | The predefined group of shipping locations where this item is available for fulfillment. This information helps streamline logistics by restricting or prioritizing fulfillment centers based on location. | |
| shippingpackaginggroup | String | The assigned packaging group that determines the type of packaging used for this item. This information impacts shipping costs, weight calculations, and dimensional pricing. | |
| shippingrate1 | Decimal | The primary shipping rate associated with this item. This rate defines the base shipping cost for domestic or international deliveries. | |
| shippingrate2 | Decimal | The secondary shipping rate applied when alternative shipping methods, weight classes, or regional adjustments are required. | |
| shippingrate3 | Decimal | The tertiary shipping rate option used for specific conditions such as expedited shipping, bulk orders, or tiered pricing structures. | |
| shipuk | Boolean | Indicates whether this item is eligible for shipping to the United Kingdom. This field ensures compliance with regional shipping policies and tax regulations. | |
| shipworldwide | Boolean | Specifies whether this item can be shipped globally. This field allows for international sales and fulfillment without geographic restrictions. | |
| shoppingdotcomcategory | String | The product category that is assigned for listings on Shopping.com. This category ensures accurate product classification and improved visibility in online comparison shopping engines. | |
| shoppingproductfeed | String | Indicates whether this item is included in Shopping.com’s product feed. This field enables automated updates to pricing, availability, and product details. | |
| shopzillacategoryid | Integer | The category Id that is assigned to this item in Shopzilla’s marketplace. This Id ensures proper classification and search optimization in online comparison shopping platforms. | |
| shopzillaproductfeed | String | Specifies whether this item is included in Shopzilla’s product feed.This field ensures regular data synchronization for online visibility and competitive pricing strategies. | |
| showasgift | Boolean | Indicates whether this item can be purchased as a gift. This field enables additional checkout options such as gift wrapping or customized messaging. | |
| showdefaultdonationamount | Boolean | Determines whether a default donation amount is displayed for this item. This donation amount is commonly used in charitable or fundraising sales models. | |
| sitemappriority | String | The priority level that is assigned to this item in the website’s sitemap. This priority level influences how search engines rank its importance relative to other products. | |
| softdescriptor | String | A custom descriptor that appears on customer bank statements for transactions involving this item. This descriptor helps identify purchases clearly and reduces chargeback disputes. | |
| standardimages | String | A set of predefined standard images that are associated with this item. This image set is used in product catalogs, online listings, and marketing materials. | |
| startingprice | Decimal | The minimum starting price for an auction or promotional sale of this item. This price defines the initial bid or entry-level discount. | |
| stockdescription | String | A brief summary of the stock availability and status for this item. This summary provides key inventory insights for sales and logistics teams. | |
| stockunit | String | The UOM that is used to track this item in inventory (for example, 'pieces,' 'packs,' or 'boxes'). This UOM ensures consistency in stock management. | |
| storecatdisplayname | String | The display name of the primary store category assigned to this item. This display name ensures organized product placement in online and physical store catalogs. | |
| storecatdisplayname2 | String | The secondary store-category display name. This display name provides an additional classification for multi-category listings in online stores. | |
| storecategory | Integer | The primary store category Id that is associated with this item. This Id enables accurate product classification for store navigation and merchandising. | |
| storecategory2 | Integer | The secondary store category Id for this item. This Id allows businesses to assign multiple product categories for better cross-selling and search visibility. | |
| storedescription | String | A general description of this item as it appears in the store. This description ensures informative and engaging product listings. | |
| storedetaileddescription | String | An extended, detailed description of this item, often including technical specifications, features, and benefits to assist potential buyers. | |
| storedisplayimage | String | The main product image that is displayed in the online store or catalog. This image is used for visual representation and marketing purposes. | |
| storedisplayname | String | The name of this item as it appears in store listings. This item name ensures clear and recognizable product identification for customers. | |
| storedisplaythumbnail | String | A smaller, thumbnail-sized version of the product image that is used in search results, category pages, and recommendation sections. | |
| storeitemtemplate | String | The predefined store template that is used for this item’s online listing. This template ensures consistent branding and layout in digital storefronts. | |
| subsidiary | String | The subsidiary or business entity that is responsible for managing, selling, or reporting on this item. This entity ensures proper financial and operational segmentation. | |
| supersizeimages | Boolean | Determines whether high-resolution, supersized images should be used for this item. This option enhances visual clarity in online product listings. | |
| supplyreplenishmentmethod | String | The method that is used to replenish stock for this item, such as manual ordering, automated reorder points, or just-in-time inventory management. This method ensures optimal stock levels and reduces shortages or excess inventory. | |
| supplytimefence | Integer | The number of days within which supply orders (for example, purchase orders, manufacturing orders) should not be rescheduled or adjusted. This information prevents last-minute disruptions in procurement and production planning. | |
| taxable | Boolean | Indicates whether this item is subject to taxation. If this field is enabled, sales transactions will include applicable taxes based on regional tax rules and tax schedules. | |
| taxschedule | String | The tax schedule that is assigned to this item, determining the tax rates and rules applicable in different jurisdictions. This tax schedule ensures compliance with local and international tax regulations. | |
| templatesgroup | String | The predefined group of templates that is associated with this item. These templates are used for generating sales orders, purchase orders, and other transactional documents. | |
| totalvalue | Decimal | The total financial value of this item in inventory, calculated as unit cost multiplied by available quantity. This value is essential for financial reporting, cost accounting, and asset valuation. | |
| tracklandedcost | Boolean | Indicates whether landed costs (for example, shipping, customs duties, insurance) should be tracked for this item. This information helps in calculating the true cost of goods for profitability analysis. | |
| transferprice | Decimal | The price at which this item is transferred between different business entities, warehouses, or subsidiaries within an organization. This price is essential for intercompany transactions and cost allocation. | |
| transferpriceunits | String | The UOM that is used for transfer pricing. This UOM ensures consistency in cost tracking when moving inventory between locations or business entities. | |
| unbuildvarianceaccount | String | The general ledger account that is used to record cost variances when this item is unbuilt (disassembled). This account ensures accurate financial tracking in manufacturing operations. | |
| unitstype | String | The classification of units that is used for this item, such as 'weight-based' or 'volume-based'. This classification ensures consistency in inventory measurements and transactions. | |
| upccode | String | The Universal Product Code (UPC) that is assigned to this item. This UPC is used for barcode scanning, product identification, and retail transactions. | |
| urlcomponent | String | The SEO-friendly URL slug for this item’s product page. This URL slug ensures improved search engine rankings and easy navigation in e-commerce platforms. | |
| usebins | Boolean | Indicates whether this item uses bin tracking in inventory management. This value ensures accurate stock control by specifying bin locations within warehouses. | |
| usemarginalrates | Boolean | Determines whether marginal tax rates apply to this item, impacting how tax calculations are performed for progressive tax structures. | |
| vendorname | String | The name of the preferred vendor or supplier for this item. This information is used for procurement, purchase order processing, and vendor performance tracking. | |
| vendreturnvarianceaccount | String | The general ledger account that isused to track variances related to vendor returns (for example, price differences or quantity discrepancies). This account ensures accurate reconciliation. | |
| vsoedeferral | String | Specifies how revenue for this item should be deferred under Vendor-Specific Objective Evidence (VSOE) accounting rules. This field ensures compliance with revenue recognition standards. | |
| vsoedelivered | Boolean | Indicates whether this item has been delivered in a transaction that follows VSOE revenue recognition rules. This information determines when revenue can be recognized. | |
| vsoepermitdiscount | String | Defines whether this item is eligible for discounts under VSOE accounting. This field ensures compliance with financial reporting standards. | |
| vsoeprice | Decimal | The price used for Vendor-Specific Objective Evidence (VSOE) compliance. This price ensures that revenue is recognized correctly for bundled sales or software transactions. | |
| vsoesopgroup | String | The VSOE Standard Operating Procedure (SOP) group that is assigned to this item. This information ensures proper revenue allocation and compliance with financial regulations. | |
| weight | Double | The physical weight of this item, which is used for shipping cost calculations, carrier selection, and warehouse storage optimization. | |
| weightunit | String | The UOM for the item's weight (for example, 'pounds,' 'kilograms,' or 'grams'). This UOM ensures accurate shipping and handling calculations. | |
| weightunits | String | The plural form of the UOM for the item's weight, which ensures consistency in reporting and documentation. | |
| willship | String | Indicates whether this item is available for shipping. This field helps businesses manage fulfillment strategies and logistics constraints. | |
| wipacct | String | The Work-In-Progress (WIP) general ledger account that is used to track the value of partially completed goods in the production process. | |
| wipvarianceacct | String | The general ledger account that is used to record cost variances that occur during the Work-In-Progress (WIP) phase of manufacturing. This account ensures accurate cost tracking. | |
| yahooproductfeed | String | Specifies whether this item is included in Yahoo’s product feed. This field ensures accurate data synchronization for e-commerce listings and online advertising campaigns. |