assemblyItemItemVendor
The AssemblyItemItemVendor table manages vendor relationships for assembly items, recording preferred suppliers, cost structures, and sourcing details.
Columns
| Name | Type | References | Description |
| item | String | The unique identifier (Id) for the assembly item being sourced from a vendor. This Id ensures accurate tracking of supplier relationships, procurement costs, and vendor-specific pricing. | |
| preferredvendor | Boolean | Indicates whether this vendor is the preferred supplier for this item. A preferred vendor is prioritized for purchase orders and procurement planning to maintain supplier consistency and favorable pricing agreements. | |
| purchaseprice | String | The price at which this item is purchased from the vendor. This price is essential for cost tracking, profitability analysis, and purchase order creation. | |
| schedule | String | The purchasing schedule that is associated with this vendor for this item. This schedule defines order frequency, delivery timelines, and contract-based supply agreements. | |
| subsidiary | String | The subsidiary or business entity that procures this item from the specified vendor. This entity is used for multi-entity financial reporting and internal cost allocations. | |
| vendor | String | The name of the vendor supplying this item. This information is crucial for managing supplier relationships, purchase negotiations, and sourcing strategies. | |
| vendorcode | String | A unique Id or code that is assigned to the vendor in the system. This code facilitates streamlined vendor management, procurement automation, and supplier compliance tracking. | |
| vendorcostentered | Decimal | The cost of this item as entered by the vendor. This cost reflects the agreed purchase price before adjustments, taxes, or volume discounts. | |
| vendorcurrencyid | String | The currency in which the vendor's purchase price is denominated. This field ensures proper multi-currency financial tracking, exchange rate calculations, and international procurement compliance. |