Suppliers

📊 Overview: 25 Fields

3 Indexes

3 One-to-Many Relations

📝 Description

🗨️ Master data table for material and equipment suppliers. Stores supplier contact details, payment terms, and performance metrics. Links to Materials and Purchases.

ℹ️ Table Information

• Table ID: 18
• UUID: DD48C27A4EEF9442A7DB4C93B8CD90D3
• Primary Key: 🔑 SupplierID_l
• Generated: 🕐 2025-12-04T14:33:44Z

---

📑 Table of Contents

• 📋 Fields (25)
• 🔍 Indexes (3)
• 🔗 One-to-Many Relations (3)
• 🔗 Related Items
  • Classes (1)
  • Forms (5)

---

📋 Fields

Field	Type	Constraints	Description
🔑 SupplierID_l	Long Integer	🔑 PK, ✨ Unique, ⚡ Auto, 🚫 Not Null, ��� Not Modifiable	-
Name_s	String (31)	⚠️ Required, 🚫 Not Null	-
Address1_s	String (41)	🚫 Not Null	-
Address2_s	String (41)	🚫 Not Null	-
Address3_s	String (41)	🚫 Not Null	-
County_s	String (21)	🚫 Not Null	-
Postcode_s	String (11)	🚫 Not Null	-
TelephoneNo_s	String (15)	🚫 Not Null	-
FaxNo_s	String (21)	🚫 Not Null	-
AccountsCode_s	String (5)	🚫 Not Null	-
TypeOfSupply_s	String (25)	🚫 Not Null	-
AdditionalInfo_txt	String	🚫 Not Null	-
ContactName_s	String (31)	🚫 Not Null	-
EMailAddress_s	String (51)	🚫 Not Null	-
ConfirmationR	Boolean	🚫 Not Null	-
FaxNo2_s	String (30)	🚫 Not Null	-
EMailAddress2_s	String (51)	🚫 Not Null	-
Position_s	String (21)	🚫 Not Null	-
Archived_b	Boolean	🚫 Not Null	-
ContactName2_s	String (21)	🚫 Not Null	-
VATRate_r	Real	🚫 Not Null	-
TelephneNo1_s	String (15)	🚫 Not Null	-
LastOrdered	Date	🚫 Not Null	-
ApprovalStatus	String (255)	🚫 Not Null	-
CofaEmailContact	String (255)	🚫 Not Null	-

🔍 Indexes

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

🔗 One-to-Many Relations

Relation Name	Source Table	Source → Destination	State	Description
SuppliesSelection	Supplies	SupplierID_l → SupplierID_l	Active	-
PurchasesSelection	Purchases	SupplierID_l → SupplierID_l	Active	-
SupplierDocumentationSelection	SupplierDocumentation	SupplierID → SupplierID_l	Active	-

🔗 Related Items

📦 Classes

• SuppliersEntity - ORDA Entity class for Suppliers table

📄 Forms

• MaterialCalendar - Data source for MaterialCalendar form
• PurchaseOrders - Data source for PurchaseOrders form
• SupplierDocumentationAdd - Data source for SupplierDocumentationAdd form
• SupplierManager - Data source for SupplierManager form
• TransferSupply - Data source for TransferSupply form

---

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