Skip to content

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 -