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 Information

  • 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

πŸ“„ Forms


Generated from catalog.4DCatalog Generated at: 2025-12-04T14:35:24Z