Sales price lists
A source of selling prices for one sales context, one currency, and one catalog, with validity dates.
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 | |
| Customer group | customergroupId | Reference | Customer group this list applies to. It outranks the sales context and yields to a customer list. | |
| Customer | customerId | Reference | Customer this list applies to. It outranks the group, the sales context, and the organization list. | |
| Catalog | catalog | Constant | Yes | Item type this list applies to: products, services, or engineering. |
| Quote currency | currency | Constant | Yes | Value from the table catalog for this field. |
| Valid from | dateFrom | Date | First day this list applies, inclusive. Resolved against the document date. | |
| Valid until | dateTo | Date | Last day this list applies, inclusive. Leave empty for an open-ended list. | |
| Price basis | priceBasis | Constant | Yes | Whether list prices include tax (gross) or exclude tax (net). It must match the document. |
| Tags | tagIds | Tags | ||
| 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 | |
| Published by | publishedBy | User | ||
| Published at | publishedAt | Date and Time | ||
| Disabled by | disabledBy | User | ||
| Disabled at | disabledAt | Date and Time | ||
| Blocked by | blockedBy | User | ||
| Blocked at | blockedAt | Date and Time | ||
| Archived by | archivedBy | User | ||
| Archived at | archivedAt | Date and Time |
Relations
Owned records (solid line) are deleted with their owner. Grouped records (dashed line) can exist alone.
| Field | Points to | Kind |
|---|---|---|
Customer group customergroupId | Customer groups | reference |
Customer customerId | Customers | reference |
Tags tagIds | Tags | reference |
Actions
What you can do with a record. Every action also sends the webhook event salespricelists.<action>. Reads (find, get, count) work on every table.
| Name | API name | Description | Where |
|---|---|---|---|
| Create | create | Add a new price list. | App · WebMCP · API · MCP · CLI |
| Edit | update | Save changes to this price list. | App · WebMCP · API · MCP · CLI |
| Disable | disable | Turn this price list off for new use. Existing references stay. Enable it again to use it. | App · WebMCP · API · MCP · CLI |
| Enable | undisable | Turn this price list back on for new use. | App · WebMCP · API · MCP · CLI |
| Publish | publish | Make this price list available for use. | App · WebMCP · API · MCP · CLI |
| Block | block | Stop edits and deletion of this price list. 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 price list again. | App · WebMCP · API · MCP · CLI |
| Archive | archive | Retire this price list 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 price list to active lists and actions. | App · WebMCP · API · MCP · CLI |
| Delete | delete | Delete this price list and the data that belongs with it. This cannot be undone. | App · WebMCP · API · MCP · CLI |
States
How a record moves from state to state. Archive and block can happen in any state.