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

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

Generated from catalog.4DCatalog Generated at: 2025-12-04T14:33:53Z