PickRequest
| 📊 Overview: 8 Fields | 7 Indexes | 2 Many-to-One Relations | 1 One-to-Many Relations |
📝 Description
🗨️ Transaction table managing warehouse picking tasks. Generates pick lists for order fulfillment and tracks pick completion status.
ℹ️ Table Information
- Table ID: 123
- UUID: 6D98803393505545A137D7224E5DC09F
- Primary Key: 🔑
ID - Generated: 🕐 2025-12-04T14:35:23Z
📑 Table of Contents
- 📋 Fields (8)
- 🔍 Indexes (7)
- 🔗 Many-to-One Relations (2)
- 🔗 One-to-Many Relations (1)
- 🔗 Related Items
📋 Fields
| Field | Type | Constraints | Description |
|---|---|---|---|
| 🔑 ID | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto | - |
| Customer | String (255) | - | - |
| DespatchDate | Date | - | - |
| Processed | Boolean | 🚫 Not Null | - |
| ReadyToPick | Boolean | 🚫 Not Null | - |
| AdviceNoteID | Long Integer | - | - |
| Type | Integer | - | - |
| PickedNotificationSent | Boolean | 🚫 Not Null | - |
🔍 Indexes
| Field | Type | Kind | Unique |
|---|---|---|---|
Customer | Keywords | regular | - |
PickedNotificationSent | Keywords | regular | - |
ReadyToPick | Keywords | regular | - |
Type | Keywords | regular | - |
Processed | Keywords | regular | - |
ID | Keywords | regular | ✨ Yes |
AdviceNoteID | Keywords | regular | - |
🔗 Many-to-One Relations
| Relation Name | Destination Table | Source → Destination | State | Description |
|---|---|---|---|---|
CustomerEntity | Customer | Customer → Customer_Code | Active | - |
Advice_NoteEntity | Advice_Note | AdviceNoteID → ID | Active | - |
🔗 One-to-Many Relations
| Relation Name | Source Table | Source → Destination | State | Description |
|---|---|---|---|---|
OrderPickRequestSelection | OrderPickRequest | PickRequestID → ID | Active | - |
🔗 Related Items
📦 Classes
- PickRequest - ORDA DataClass class for PickRequest table
- PickRequestEntity - ORDA Entity class for PickRequest table
📄 Forms
- %2AOrderPicking - Data source for %2AOrderPicking form
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:35:23Z