Sales price list line items
The selling unit price of one product or service item on a sales price list.
Fields
The API name is what the API, MCP and the CLI use.
| Name | API name | Type | Required | Description |
|---|---|---|---|---|
| ID | id | Record ID | Yes | |
| Price list | salespricelistId | Reference | Yes | |
| Item | productitemId | Reference | ||
| Minimum quantity | quantityMin | Quantity | Yes | Half-open band start. Line quantity must be greater than or equal to this value. |
| Maximum quantity | quantityMax | Quantity | Half-open band end. Line quantity must be less than this value. Leave empty for no upper bound. | |
| Unit | catalogunit | Unit | ||
| Item | serviceitemId | Reference | ||
| Engineering item | customitemId | Reference | Engineering item this price applies to. | |
| Material | materialId | Reference | ||
| Rate basis | rateBasis | Constant | Yes | Value from the table catalog for this field. |
| Unit price | unitPrice | Unit price | Price for one unit, before line discount. Includes tax only when the document price basis is gross. | |
| Approval floor | unitPriceFloor | Unit price | Optional unit price threshold for approval. A lower line price does not block save. | |
| 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 | ||
| 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 |
|---|---|---|
Price list salespricelistId | Sales price lists | owned by |
Actions
What you can do with a record. Every action also sends the webhook event salespricelistitems.<action>. Reads (find, get, count) work on every table.
| Name | API name | Description | Where |
|---|---|---|---|
| Create | create | Add a new line item. | App · WebMCP · API · MCP · CLI |
| Edit | update | Save changes to this line item. | App · API · MCP · CLI |
| Delete | delete | Delete this line item and the data that belongs with it. This cannot be undone. | App · WebMCP · API · MCP · CLI |