servicePurchaseItemItemVendor
Lists vendors tied to specific service purchase items.
Columns
| Name | Type | References | Description |
| item | String | The internal ID of the service purchase item associated with this vendor record. | |
| preferredvendor | Boolean | If the value is 'true', this vendor is marked as the preferred vendor for the item. If the value is 'false', the vendor is not preferred. | |
| purchaseprice | String | The standard purchase price for the item as agreed with the vendor. | |
| schedule | String | The pricing schedule or vendor contract schedule applied to this item. | |
| subsidiary | String | The subsidiary to which this vendor-item relationship applies, used in multi-subsidiary configurations. | |
| vendor | String | The internal ID or name of the vendor supplying the item. | |
| vendorcode | String | The vendor's internal or external code used to reference the item in their system. | |
| vendorcostentered | Decimal | The manually entered purchase price of the item from the vendor, used for pricing or audit purposes. | |
| vendorcurrencyid | String | The currency in which the vendor's purchase price is denominated, matching the vendor’s default currency or contract. |