Supplier prices
Purchase price a supplier charges for one item, by minimum quantity and validity window.
- API name:
purchasepricelists - Domain: Purchases
- Modules: Purchasing
Fields
The API name is what the API, MCP and the CLI use.
| Name | API name | Type | Required | Description |
|---|---|---|---|---|
| ID | id | Record ID | Yes | |
| Name | label | Text | Yes | |
| Supplier | supplierId | Reference | Yes | |
| Minimum quantity | quantityMin | Quantity | Yes | Quantity in the catalog unit after any unit conversion on the line. |
| Catalog | catalog | Constant | Yes | |
| Unit | catalogunit | Unit | ||
| Item | productitemId | Reference | ||
| Item | customitemId | Reference | ||
| Material | materialId | Reference | ||
| Quote currency | currency | Constant | Yes | |
| Unit price | unitPrice | Unit price | Yes | Price for one unit, before line discount. Includes tax only when the document price basis is gross. |
| Discount (%) | discountPercent | Percent | Percentage discount applied to the line subtotal. | |
| Priority | priority | Whole Number | Yes | Whole number without fractional part. |
| Valid from | dateFrom | Date | First calendar date this record applies. | |
| Valid to | dateTo | Date | Last calendar date this record applies, if any. | |
| Price basis | priceBasis | Constant | Yes | Whether unit prices include tax (gross) or exclude tax (net). |
| Tags | tagIds | Tags | ||
| Description | description | Text Area | ||
| Data | data | Data | ||
| Created by | createdBy | User | ||
| Created at | createdAt | Date and Time | Yes | |
| Updated by | updatedBy | User | ||
| Updated at | updatedAt | Date and Time | Yes | |
| Blocked by | blockedBy | User | ||
| Blocked at | blockedAt | Date and Time | ||
| Archived by | archivedBy | User | ||
| Archived at | archivedAt | Date and Time |
Relations
Actions
What you can do with a record. Every action also sends the webhook event purchasepricelists.<action>. Reads (find, get, count) work on every table.
| Name | API name | Description | Where |
|---|---|---|---|
| Create | create | Add a new supplier price. | App · WebMCP · API · MCP · CLI |
| Edit | update | Save changes to this supplier price. | App · WebMCP · API · MCP · CLI |
| Block | block | Stop edits and deletion of this supplier price. It stays visible and can still appear on existing documents. Unblock to edit again. | App · WebMCP · API · MCP · CLI |
| Unblock | unblock | Allow edits and deletion of this supplier price again. | App · WebMCP · API · MCP · CLI |
| Archive | archive | Retire this supplier price from daily use. It leaves active lists and pickers, and most actions stop. Unarchive to restore it. | App · WebMCP · API · MCP · CLI |
| Restore | unarchive | Return this supplier price to active lists and actions. | App · WebMCP · API · MCP · CLI |
| Delete | delete | Delete this supplier price and the data that belongs with it. This cannot be undone. | App · WebMCP · API · CLI |