RMC
| 📊 Overview: 12 Fields | 4 Indexes | 2 Many-to-One Relations | 6 One-to-Many Relations |
📝 Description
🗨️ Transaction table for Raw Material Certificates tracking material certifications and test results. Links material batches to supplier certificates and quality data.
ℹ️ Table Information
- Table ID: 27
- UUID: 888FFBDAC9DEBA469795A94E15901BAE
- Primary Key: 🔑
RMCNo_l - Generated: 🕐 2025-12-04T14:33:53Z
📑 Table of Contents
- 📋 Fields (12)
- 🔍 Indexes (4)
- 🔗 Many-to-One Relations (2)
- 🔗 One-to-Many Relations (6)
- 🔗 Related Items
📋 Fields
| Field | Type | Constraints | Description |
|---|---|---|---|
| 🔑 RMCNo_l | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto, 🚫 Not Null | - |
| MaterialID_l | Long Integer | 🚫 Not Null | - |
| RMCDate_d | Date | 🚫 Not Null | - |
| BatchNo_s | String (25) | 🚫 Not Null | - |
| Quantity_l | Long Integer | 🚫 Not Null | - |
| OrderNo_l | Long Integer | 🚫 Not Null | - |
| Name_s | String (30) | 🚫 Not Null | - |
| Remarks_s | String (20) | 🚫 Not Null | - |
| CofA_BLOB | BLOB Scalar | 🚫 Not Null | - |
| CofA_Filename | String (255) | 🚫 Not Null | - |
| CofA_Requested | Date | 🚫 Not Null | - |
| PurchaseInfoID | Long Integer | 🚫 Not Null | - |
🔍 Indexes
| Field | Type | Kind | Unique |
|---|---|---|---|
MaterialID_l | Keywords | regular | - |
PurchaseInfoID | Keywords | regular | - |
RMCNo_l | Keywords | regular | ✨ Yes |
RMCDate_d | Keywords | regular | - |
🔗 Many-to-One Relations
| Relation Name | Destination Table | Source → Destination | State | Description |
|---|---|---|---|---|
MaterialEntity | Material | MaterialID_l → Unique_ID | Active | - |
PurchaseInfoEntity | PurchaseInfo | PurchaseInfoID → UniqueID_l | Active | - |
🔗 One-to-Many Relations
| Relation Name | Source Table | Source → Destination | State | Description |
|---|---|---|---|---|
PurchaseReceiptsSelection | PurchaseReceipts | RMC → RMCNo_l | Active | - |
MaterialStockTakeSelection | MaterialStockTake | RMC → RMCNo_l | Active | - |
MaterialCheckHistorySelection1 | MaterialCheckHistory | RMC1 → RMCNo_l | Active | - |
MaterialCheckHistorySelection2 | MaterialCheckHistory | RMC2 → RMCNo_l | Active | - |
MaterialCheckHistorySelection3 | MaterialCheckHistory | RMC3 → RMCNo_l | Active | - |
MaterialStockSelection | MaterialStock | RMC → RMCNo_l | Active | - |
🔗 Related Items
📦 Classes
- RMCEntity - ORDA Entity class for RMC table
📄 Forms
- CreateRMC - Data source for CreateRMC form
- MaterialManagement - Data source for MaterialManagement form
- RMCs - Data source for RMCs form
- StockTakeInput - Data source for StockTakeInput form
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:33:53Z