Advice_Note

📊 Overview: 6 Fields

2 Indexes

2 One-to-Many Relations

📝 Description

🗨️ Transaction table for delivery advice notes sent to customers. Documents shipment details and tracking information for product deliveries.

ℹ️ Table Information

• Table ID: 9
• UUID: 1C150D42AE7E4341870D4DBFA6AD3288
• Primary Key: 🔑 ID
• Generated: 🕐 2025-12-04T14:33:36Z

---

📑 Table of Contents

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

---

📋 Fields

Field	Type	Constraints	Description
Advice_Note_No	Long Integer	⚡ Auto, 🚫 Not Null	-
Customer_Code	String (3)	🚫 Not Null	-
🔑 ID	Long Integer	🔑 PK, ✨ Unique, ⚡ Auto, 🚫 Not Null	-
DespatchDate	Date	-	-
ArrivalDate	Date	-	-
Transport	String (255)	-	-

🔍 Indexes

Field	Type	Kind	Unique
ID	Keywords	regular	✨ Yes
Advice_Note_No	Keywords	regular	-

🔗 One-to-Many Relations

Relation Name	Source Table	Source → Destination	State	Description
CofCSelection	CofC	Advice_Note_No → Advice_Note_No	Active	-
PickRequestSelection	PickRequest	AdviceNoteID → ID	Active	-

🔗 Related Items

📦 Classes

• Advice_NoteEntity - ORDA Entity class for Advice_Note table

📄 Forms

• ConsignmentCallOff - Data source for ConsignmentCallOff form
• OrderDelivery - Data source for OrderDelivery form
• PalletDespatchList - Data source for PalletDespatchList form

---

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