Product item customers
A customer of one product item, with its trade codes, name and optional sell unit.
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 I18n | Short name or description the customer uses for this item. | |
| SKU | sku | Text | Customer-side SKU for this item. | |
| GTIN barcode | gtin | GTIN barcode | Optional GTIN (8, 12, 13, or 14 digits) to identify the item by scan. | |
| Customer | customerId | Reference | Yes | Customer that uses these codes for the item. |
| Item | productitemId | Reference | Yes | Sellable catalog line the customer codes apply to. |
| Unit of measure | productitemuomId | Reference | Sell unit when it differs from the item base unit. Leave empty when the base unit applies. | |
| Drawing reference | drawingRef | Text | Customer or engineering drawing identifier for this item. | |
| Revision | revision | Text | Whole number without fractional part. | |
| Links | links | Link | Links | ||
| Tags | tagIds | Tags | Tags on this item–customer relationship, not on the item master. | |
| Description | description | Text Area I18n | Customer notes about this item in their catalog. | |
| Data | data | Data | ||
| External identifiers | identifiers | External identifier | External identifiers | Remote system keys and optional id types. One value per system and type pair on this record. | |
| 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
Owned records (solid line) are deleted with their owner. Grouped records (dashed line) can exist alone.
| Field | Points to | Kind |
|---|---|---|
Customer customerId | Customers | grouped by |
Item productitemId | Product items | grouped by |
Unit of measure productitemuomId | Product item units of measure | reference |
Tags tagIds | Tags | reference |
Actions
What you can do with a record. Every action also sends the webhook event productitemcustomers.<action>. Reads (find, get, count) work on every table.
| Name | API name | Description | Where |
|---|---|---|---|
| Create | create | Link a customer to this product item. | App · WebMCP · API · MCP · CLI |
| Edit | update | Save changes to this customer link. | App · WebMCP · API · MCP · CLI |
| Block | block | Stop edits and deletion of this customer link. It stays visible and can still appear on existing documents. Unblock to edit again. | App · API · CLI |
| Unblock | unblock | Allow edits and deletion of this customer link again. | App · API · CLI |
| Archive | archive | Retire this customer link from the product item. It leaves active lists and pickers, and most actions stop. The customer itself is kept. Unarchive to restore the link. | App · WebMCP · API · MCP · CLI |
| Restore | unarchive | Return this customer link to active lists and actions. | App · WebMCP · API · MCP · CLI |
| Delete | delete | Remove this customer from the product item. The customer itself is kept. This cannot be undone. | App · WebMCP · API · MCP · CLI |