Purchases

📊 Overview: 18 Fields 3 Indexes 1 Many-to-One Relations 1 One-to-Many Relations

📝 Description

🗨️ Transaction table for purchase orders sent to suppliers. Tracks material and supplies orders, delivery schedules, and purchase order status.

ℹ️ Table Information

  • Table ID: 21
  • UUID: 0816EE7668E03647A01F7EB009589E04
  • Primary Key: 🔑 OrderNo_l
  • Generated: 🕐 2025-12-04T14:33:47Z

📑 Table of Contents

📋 Fields

Field Type Constraints Description
🔑 OrderNo_l Long Integer 🔑 PK, ✨ Unique, ⚡ Auto, ⚠️ Required, 🚫 Not Null -
DateRaised_d Date 🚫 Not Null -
Confirmed Boolean 🚫 Not Null -
RaisedBy_s String (30) 🚫 Not Null -
SupplierID_l Long Integer 🚫 Not Null -
GoodsReceived_b Boolean 🚫 Not Null -
InvoiceAuthorised_b Boolean 🚫 Not Null -
AdditionalInfo_txt String 🚫 Not Null -
Archived_b Boolean 🚫 Not Null -
VATRate_r Real 🚫 Not Null -
Received Boolean 🚫 Not Null -
Invoiced Boolean 🚫 Not Null -
Approved Boolean 🚫 Not Null -
ApprovedBy String (255) 🚫 Not Null -
ApprovalRequested Boolean 🚫 Not Null -
OrderPrinted Boolean 🚫 Not Null -
Revision Integer 🚫 Not Null -
ApprovedDate Date 🚫 Not Null -

🔍 Indexes

Field Type Kind Unique
OrderNo_l Keywords regular ✨ Yes
SupplierID_l Keywords regular -
Archived_b Keywords regular -

🔗 Many-to-One Relations

Relation Name Destination Table Source → Destination State Description
SuppliersEntity Suppliers SupplierID_l → SupplierID_l Active -

🔗 One-to-Many Relations

Relation Name Source Table Source → Destination State Description
PurchaseInfoSelection PurchaseInfo OrderNo_l → OrderNo_l Active -

🔗 Related Items

📦 Classes

📄 Forms

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