PurchaseReceipts
| 📊 Overview: 8 Fields | 3 Indexes | 2 Many-to-One Relations |
📝 Description
🗨️ Transaction table recording goods receipts for purchase orders. Tracks received quantities, dates, batch numbers, and quality checks.
- Table ID: 109
- UUID: BE29EC2C2AE9BF4496D0A54958A42DA5
- Primary Key: 🔑
ID - Generated: 🕐 2025-12-04T14:35:09Z
📑 Table of Contents
📋 Fields
| Field | Type | Constraints | Description |
| 🔑 ID | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto | - |
| PurchaseInfoID | Long Integer | 🚫 Not Null | - |
| DateReceived | Date | 🚫 Not Null | - |
| QuantityRecieved | Real | 🚫 Not Null | - |
| ReceivedBy | String (255) | 🚫 Not Null | - |
| ProofOfReceiptFile | BLOB Scalar | 🚫 Not Null | - |
| ProofOfReceiptName | String (255) | 🚫 Not Null | - |
| RMC | Long Integer | 🚫 Not Null | - |
🔍 Indexes
| Field | Type | Kind | Unique |
ID | Keywords | regular | ✨ Yes |
RMC | Keywords | regular | - |
PurchaseInfoID | Keywords | regular | - |
🔗 Many-to-One Relations
| Relation Name | Destination Table | Source → Destination | State | Description |
PurchaseInfoEntity | PurchaseInfo | PurchaseInfoID → UniqueID_l | Active | - |
RMCEntity | RMC | RMC → RMCNo_l | Active | - |
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:35:09Z