ProductReturn
| 📊 Overview: 9 Fields | 3 Indexes | 1 Many-to-One Relations | 1 One-to-Many Relations |
📝 Description
🗨️ Transaction table for customer product returns and RMAs. Tracks returned products, reasons, and links to replacement or credit processing.
- Table ID: 30
- UUID: 84D5CEC865744441A28B55BDFF4F334A
- Primary Key: 🔑
ID - Generated: 🕐 2025-12-04T14:33:56Z
📑 Table of Contents
📋 Fields
| Field | Type | Constraints | Description |
| ReturnID_l | Long Integer | 🚫 Not Null | - |
| DateOfReturn_d | Date | 🚫 Not Null | - |
| ReturnNotes_txt | String | 🚫 Not Null | - |
| PQI_No_s | String (15) | 🚫 Not Null | - |
| CustomerOrderDetails_s | String (50) | 🚫 Not Null | - |
| ProductID_l | Long Integer | 🚫 Not Null | - |
| CustomerCode_s | String (3) | 🚫 Not Null | - |
| ReturnClosed_b | Boolean | 🚫 Not Null | - |
| 🔑 ID | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto, 🚫 Not Null | - |
🔍 Indexes
| Field | Type | Kind | Unique |
ID | B-Tree | regular | ✨ Yes |
ProductID_l | Keywords | regular | - |
ReturnID_l | Keywords | regular | - |
🔗 Many-to-One Relations
| Relation Name | Destination Table | Source → Destination | State | Description |
ProductEntity | Product | ProductID_l → Product_ID | Active | - |
🔗 One-to-Many Relations
| Relation Name | Source Table | Source → Destination | State | Description |
ProductReturnWorksOrderSelection | ProductReturnWorksOrder | ReturnID_l → ReturnID_l | Active | - |
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:33:56Z