Stock_Location

📊 Overview: 6 Fields

4 Indexes

5 One-to-Many Relations

📝 Description

🗨️ Master data table defining physical storage locations for inventory (warehouses, bays, consignment sites). Used by Finished_Stock and Stock_Movement for location tracking.

ℹ️ Table Information

• Table ID: 29
• UUID: 916903B13AB83B4A9937B1348364CCA9
• Primary Key: 🔑 StockLocationID_l
• Generated: 🕐 2025-12-04T14:33:55Z

---

📑 Table of Contents

• 📋 Fields (6)
• 🔍 Indexes (4)
• 🔗 One-to-Many Relations (5)
• 🔗 Related Items
  • Classes (2)
  • Forms (9)

---

📋 Fields

Field	Type	Constraints	Description
🔑 StockLocationID_l	Long Integer	🔑 PK, ✨ Unique, ⚡ Auto, 🚫 Not Null	-
Location_Name_s	String (30)	🚫 Not Null	-
Is_Consignment_b	Boolean	🚫 Not Null	-
Location_Code_s	String (5)	🚫 Not Null	-
DeafultPackingLocation_b	Boolean	🚫 Not Null	-
DespatchLocation	Boolean	🚫 Not Null	-

🔍 Indexes

Field	Type	Kind	Unique
Is_Consignment_b	Keywords	regular	-
DeafultPackingLocation_b	Keywords	regular	-
DespatchLocation	Keywords	regular	-
StockLocationID_l	Keywords	regular	✨ Yes

🔗 One-to-Many Relations

Relation Name	Source Table	Source → Destination	State	Description
Stock_MovementSelection	Stock_Movement	To_Location_l → StockLocationID_l	Active	-
Finished_StockSelection	Finished_Stock	LocationID_l → StockLocationID_l	Active	-
CofCSelection	CofC	LocationID_l → StockLocationID_l	Active	-
BoxLabelsSelection	BoxLabels	Stock_LocationID → StockLocationID_l	Active	-
CustomerSelection	Customer	ConsignmentLocationID → StockLocationID_l	Active	-

🔗 Related Items

📦 Classes

• Stock_Location - ORDA DataClass class for Stock_Location table
• Stock_LocationEntity - ORDA Entity class for Stock_Location table

📄 Forms

• %2AStockControl - Data source for %2AStockControl form
• ConsignmentCallOff - Data source for ConsignmentCallOff form
• ConsignmentSSLs - Data source for ConsignmentSSLs form
• EDIgenerator - Data source for EDIgenerator form
• OrderOverview - Data source for OrderOverview form
• PalletTransfer - Data source for PalletTransfer form
• SNRSUMMARY - Data source for SNRSUMMARY form
• StockAtLocation - Data source for StockAtLocation form
• StockMovements - Data source for StockMovements form

---

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