ODBC Driver for NetSuite

Build 25.0.9434

inventoryItemItemVendor

Manages the association between inventory items and their approved vendors, including supplier details and purchasing terms.

Columns

Name Type References Description
item String The unique identifier or name of the inventory item associated with a specific vendor.
preferredvendor Boolean Indicates whether this vendor is the preferred supplier for the given inventory item. A value of 'true' means the vendor is preferred.
purchaseprice String The cost at which the inventory item is purchased from the vendor. This value reflects the agreed-upon price before any discounts or taxes.
schedule String The purchasing schedule or frequency with which the inventory item is ordered from the vendor. This can represent predefined procurement cycles.
subsidiary String The specific subsidiary within the organization that is responsible for purchasing the inventory item from the vendor. Useful for multi-entity organizations.
vendor String The name or identifier of the vendor supplying the inventory item. This links the item to its supplier in the procurement system.
vendorcode String The internal or vendor-provided code used to identify the inventory item in the vendor’s catalog. Helps match vendor-specific product references.
vendorcostentered Decimal The cost of the inventory item as entered in the system, which can include vendor-specific pricing considerations before conversion or adjustments.
vendorcurrencyid String The currency in which the vendor's pricing is recorded. Ensures accurate cost tracking across international transactions.

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