Scrap
| 📊 Overview: 15 Fields | 3 Indexes | 1 Many-to-One Relations |
📝 Description
🗨️ Transaction table recording scrap and waste from production runs. Tracks quantities, reasons, and costs for waste reduction analysis.
- Table ID: 47
- UUID: B91E3A24E0704F41AAE38F93EE48B9E6
- Primary Key: 🔑
ID - Generated: 🕐 2025-12-04T14:34:10Z
📑 Table of Contents
📋 Fields
| Field | Type | Constraints | Description |
| DateScrapped | Date | 🚫 Not Null | - |
| WorksOrder | Long Integer | 🚫 Not Null | - |
| DateProduced | Date | 🚫 Not Null | - |
| Fault | String (255) | 🚫 Not Null | - |
| Reason | String (255) | 🚫 Not Null | - |
| Quantity | Long Integer | 🚫 Not Null | - |
| Location | String (255) | 🚫 Not Null | - |
| 🔑 ID | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto, 🚫 Not Null | - |
| ScrappedBy | String (255) | 🚫 Not Null | - |
| New | Boolean | 🚫 Not Null | - |
| Shift | Long Integer | 🚫 Not Null | - |
| Sequence | Integer | 🚫 Not Null | - |
| Comment | String (255) | 🚫 Not Null | - |
| DateTimeScrapped | String (255) | 🚫 Not Null | - |
| ShiftDate | Long Integer | 🚫 Not Null | - |
🔍 Indexes
| Field | Type | Kind | Unique |
ShiftDate | Keywords | regular | - |
WorksOrder | Keywords | regular | - |
ID | Keywords | regular | ✨ Yes |
🔗 Many-to-One Relations
| Relation Name | Destination Table | Source → Destination | State | Description |
WorksOrderEntity | WorksOrder | WorksOrder → Works_Order_No | Active | - |
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:34:10Z