ProductReturnWorksOrder
| 📊 Overview: 8 Fields | 3 Indexes | 2 Many-to-One Relations |
📝 Description
🗨️ Junction table linking ProductReturns to WorksOrders that produced the returned items. Enables traceability for quality analysis.
ℹ️ Table Information
- Table ID: 31
- UUID: 130945D5E0DF0E4498FBB20449311F51
- Primary Key: 🔑
WOReturnID_l - Generated: 🕐 2025-12-04T14:33:57Z
📑 Table of Contents
- 📋 Fields (8)
- 🔍 Indexes (3)
- 🔗 Many-to-One Relations (2)
- 🔗 Related Items
- Classes (1)
📋 Fields
| Field | Type | Constraints | Description |
|---|---|---|---|
| 🔑 WOReturnID_l | Long Integer | 🔑 PK, ✨ Unique, 🚫 Not Null | - |
| ReturnID_l | Long Integer | 🚫 Not Null | - |
| Works_Order_No_l | Long Integer | 🚫 Not Null | - |
| ReturnedQuantity_l | Long Integer | 🚫 Not Null | - |
| Scrapped_b | Boolean | 🚫 Not Null | - |
| Restocked_b | Boolean | 🚫 Not Null | - |
| ScrappedQuantity_l | Long Integer | 🚫 Not Null | - |
| RestockedQuantity_l | Long Integer | 🚫 Not Null | - |
🔍 Indexes
| Field | Type | Kind | Unique |
|---|---|---|---|
ReturnID_l | Keywords | regular | - |
WOReturnID_l | Keywords | regular | ✨ Yes |
Works_Order_No_l | Keywords | regular | - |
🔗 Many-to-One Relations
| Relation Name | Destination Table | Source → Destination | State | Description |
|---|---|---|---|---|
ProductReturnEntity | ProductReturn | ReturnID_l → ReturnID_l | Active | - |
WorksOrderEntity | WorksOrder | Works_Order_No_l → Works_Order_No | Active | - |
🔗 Related Items
📦 Classes
- ProductReturnWorksOrderEntity - ORDA Entity class for ProductReturnWorksOrder table
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:33:57Z