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
📋 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