Serial Number
API Name: ProductSerial
Tracking individual product pieces.
Fields
| Field |
Type |
Required |
Description |
name |
varchar |
- |
Name |
serialNumber |
varchar |
|
Serial number (unique) |
status |
enum |
|
Status |
product |
link |
|
Product |
batchNumber |
varchar |
- |
Batch number |
manufacturedDate |
date |
- |
Manufacture date |
manufactureYear |
int |
- |
Manufacture year |
warrantyUntil |
date |
- |
Warranty until |
currentOwner |
link |
- |
Current owner |
supplier |
link |
- |
Supplier |
description |
text |
- |
Description |
notes |
text |
- |
Notes |
documentation |
attachmentMultiple |
- |
Documentation |
assignedUser |
link |
- |
Assigned user |
teams |
linkMultiple |
- |
Teams |
Enum Values status
| Value |
Description |
Style |
Active |
Active |
success |
Sold |
Sold |
primary |
Defective |
Defective |
danger |
Returned |
Returned |
warning |
Scrapped |
Scrapped |
default |
Relationships
| Relationship |
Type |
Target Entity |
product |
belongsTo |
Product |
currentOwner |
belongsTo |
Account |
supplier |
belongsTo |
Account |
assignedUser |
belongsTo |
User |
Indexes
| Index |
Columns |
Unique |
serialNumber |
serialNumber, deleted |
|
product |
productId, deleted |
- |
status |
status, deleted |
- |
warrantyUntil |
warrantyUntil, deleted |
- |
manufacturedDate |
manufacturedDate, deleted |
- |