OrderPickRequest
| π Overview: 4 Fields | 3 Indexes | 2 Many-to-One Relations | 2 One-to-Many Relations |
π Description
π¨οΈ Transaction table linking customer orders to warehouse pick requests. Generates picking tasks for order fulfillment workflow.
- Table ID: 124
- UUID: 2BE22D1782098249A524034DE15E0047
- Primary Key: π
ID - Generated: π 2025-12-04T14:35:24Z
π Table of Contents
π Fields
| Field | Type | Constraints | Description |
| π ID | Long Integer | π PK, β¨ Unique, β‘ Auto | - |
| PickRequestID | Long Integer | - | - |
| CustomerOrderID | Long Integer | - | - |
| Quantity | Long Integer | - | - |
π Indexes
| Field | Type | Kind | Unique |
CustomerOrderID | Keywords | regular | - |
PickRequestID | Keywords | regular | - |
ID | Keywords | regular | β¨ Yes |
π Many-to-One Relations
| Relation Name | Destination Table | Source β Destination | State | Description |
PickRequestEntity | PickRequest | PickRequestID β ID | Active | - |
Customer_OrderEntity | Customer_Order | CustomerOrderID β Petes_No | Active | - |
π One-to-Many Relations
| Relation Name | Source Table | Source β Destination | State | Description |
PalletSelection | Pallet | OrderPickRequestID β ID | Active | - |
BoxLabelsSelection | BoxLabels | OrderPickRequestID β ID | Active | - |
π¦ Classes
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:35:24Z