Pallet
| 📊 Overview: 28 Fields | 12 Indexes | 4 Many-to-One Relations | 2 One-to-Many Relations |
📝 Description
🗨️ Inventory table tracking palletized finished goods. Records pallet contents, locations, and status for warehouse management and shipping.
- Table ID: 71
- UUID: 33A92733465ACC42A746A5DD7A56B429
- Primary Key: 🔑
ID - Generated: 🕐 2025-12-04T14:34:33Z
📑 Table of Contents
📋 Fields
| Field | Type | Constraints | Description |
| 🔑 ID | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto | - |
| Location | Long Integer | 🚫 Not Null | - |
| WO1 | Long Integer | 🚫 Not Null | - |
| WO1Qty | Long Integer | 🚫 Not Null | - |
| WO2 | Long Integer | 🚫 Not Null | - |
| WO2Qty | Long Integer | 🚫 Not Null | - |
| ProductID | Long Integer | 🚫 Not Null | - |
| Created | Date | 🚫 Not Null | - |
| CreatedBy | String (255) | 🚫 Not Null | - |
| Transfer | Boolean | 🚫 Not Null | - |
| CreationTime | Time | 🚫 Not Null | - |
| AdviceNote | Long Integer | 🚫 Not Null | - |
| OrderID | Long Integer | 🚫 Not Null | - |
| Printed | Boolean | 🚫 Not Null | - |
| Verified | Boolean | 🚫 Not Null | - |
| NewSystem | Boolean | 🚫 Not Null | - |
| VerifiedBy | String (255) | 🚫 Not Null | - |
| PrintedBy | String (255) | 🚫 Not Null | - |
| Completed | Boolean | 🚫 Not Null | - |
| LocationID | String | - | - |
| LocatedBy | String (255) | - | - |
| OrderPickRequestID | Long Integer | - | - |
| CofCID | Long Integer | - | - |
| UUID | String | ✨ Unique | - |
| Version | Integer | 🚫 Not Null | - |
| Despatched | Boolean | 🚫 Not Null | - |
| MigrationID | Long Integer | - | - |
| LastMigration | String (255) | - | - |
🔍 Indexes
| Field | Type | Kind | Unique |
Version | Keywords | regular | - |
ID | Keywords | regular | ✨ Yes |
Despatched | Keywords | regular | - |
OrderPickRequestID | Keywords | regular | - |
CofCID | Keywords | regular | - |
Verified | Keywords | regular | - |
UUID | Keywords | regular | ✨ Yes |
ProductID | Keywords | regular | - |
Printed | Keywords | regular | - |
Completed | Keywords | regular | - |
LocationID | Keywords | regular | - |
NewSystem | Keywords | regular | - |
🔗 Many-to-One Relations
| Relation Name | Destination Table | Source → Destination | State | Description |
ProductEntity | Product | ProductID → Product_ID | Active | - |
LocationEntity | Location | LocationID → ID | Active | - |
OrderPickRequestEntity | OrderPickRequest | OrderPickRequestID → ID | Active | - |
CofCEntity | CofC | CofCID → Cert_Of_Conformance_No | Active | - |
🔗 One-to-Many Relations
| Relation Name | Source Table | Source → Destination | State | Description |
BoxLabelsSelection | BoxLabels | PalletID → ID | Active | - |
PrintJobSelection | PrintJob | RelatedUUID → UUID | Active | - |
📦 Classes
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:34:33Z