BoxLabels
| 📊 Overview: 36 Fields | 19 Indexes | 8 Many-to-One Relations |
📝 Description
🗨️ Testing boxlabels manual comment
- Table ID: 76
- UUID: 0B40C76291EE2E44AC3F733AD8213391
- Primary Key: 🔑
ID - Generated: 🕐 2025-12-04T14:34:38Z
📑 Table of Contents
📋 Fields
| Field | Type | Constraints | Description |
| 🔑 ID | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto | - |
| WorksOrder | Long Integer | 🚫 Not Null | - |
| BoxNumber | Long Integer | 🚫 Not Null | - |
| RouteCard | Integer | 🚫 Not Null | - |
| PackedBy | String (255) | 🚫 Not Null | - |
| Date | Date | 🚫 Not Null | - |
| Time | Time | 🚫 Not Null | - |
| DateTime | String (255) | 🚫 Not Null | - |
| ToolID | Long Integer | 🚫 Not Null | - |
| Parts | Long Integer | 🚫 Not Null | - |
| Shift | Long Integer | 🚫 Not Null | - |
| WORC | Long Integer | 🚫 Not Null | - |
| Mandrels | Integer | 🚫 Not Null | - |
| NotMade | Boolean | 🚫 Not Null | - |
| NotMadeWho | String (255) | 🚫 Not Null | - |
| TimeToPack | Real | 🚫 Not Null | - |
| StockInput | Boolean | 🚫 Not Null | - |
| TimeProcessed | Boolean | 🚫 Not Null | - |
| StandardHours | Real | 🚫 Not Null | - |
| ShiftDate | Long Integer | 🚫 Not Null | - |
| PartBoxCode | String (5) | 🚫 Not Null | - |
| LinkedBoxID | Long Integer | 🚫 Not Null | - |
| RemoveFromStock | Boolean | 🚫 Not Null | - |
| StockRemovedBy | String | 🚫 Not Null | - |
| PalletID | Long Integer | 🚫 Not Null | - |
| WhenAddedToPallet | String (255) | - | - |
| OrderPickRequestID | Long Integer | - | - |
| Version | Integer | - | - |
| CofCID | Long Integer | - | - |
| Stock_LocationID | Long Integer | - | - |
| Comments | String | - | - |
| StatusUpdatedStaffID | Long Integer | - | - |
| StatusUpdatedWhen | String (255) | - | - |
| UUID | String | - | - |
| MigrationID | Long Integer | - | - |
| LastMigration | String (255) | - | - |
🔍 Indexes
| Field | Type | Kind | Unique |
PalletID | Keywords | regular | - |
WorksOrder | Cluster | regular | - |
UUID | Keywords | regular | - |
ToolID | Keywords | regular | - |
ID | Keywords | regular | ✨ Yes |
Shift | Keywords | regular | - |
StockRemovedBy | Keywords | regular | - |
RemoveFromStock | Cluster | regular | - |
Stock_LocationID | Keywords | regular | - |
LinkedBoxID | Keywords | regular | - |
TimeProcessed | Keywords | regular | - |
PackedBy | Keywords | regular | - |
CofCID | Keywords | regular | - |
Version | Keywords | regular | - |
StockInput | Cluster | regular | - |
OrderPickRequestID | Keywords | regular | - |
ShiftDate | Keywords | regular | - |
PartBoxCode | Keywords | regular | - |
NotMade | Cluster | regular | - |
🔗 Many-to-One Relations
| Relation Name | Destination Table | Source → Destination | State | Description |
WorksOrderEntity | WorksOrder | WorksOrder → Works_Order_No | Active | - |
LinkedBoxLabelsEntity | BoxLabels | LinkedBoxID → ID | Active | - |
ToolsEntity | Tools | ToolID → Tool_ID | Active | - |
PalletEntity | Pallet | PalletID → ID | Active | - |
OrderPickRequestEntity | OrderPickRequest | OrderPickRequestID → ID | Active | - |
CofCEntity | CofC | CofCID → Cert_Of_Conformance_No | Active | - |
Stock_LocationEntity | Stock_Location | Stock_LocationID → StockLocationID_l | Active | - |
StatusUpdatedStaffEntity | Staff | StatusUpdatedStaffID → StaffID | Active | - |
📦 Classes
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:34:38Z