| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBasic functions |
1 | VEKP | Handling Unit - Header Table | 115 | LYARD | Yard | nvarchar | 3 | 0 | | |
TOPYard Management |
2 | LYACT | Yard activities | 2 | LYARD | Yard | nvarchar | 3 | 0 | | |
3 | LYDTP | Location time-dependent properties | 2 | LYARD | Yard | nvarchar | 3 | 0 | | |
4 | LYFAG | Forwarding agent attributes | 2 | LYARD | Yard | nvarchar | 3 | 0 | | |
5 | LYGRR | Geographical location groups relationship | 2 | LYARD | Yard | nvarchar | 3 | 0 | | |
6 | LYGTP | Yard Scheduling Graphic Tool Personalization | 2 | LYARD | Yard | nvarchar | 3 | 0 | | |
7 | LYLCP | Location type capacity | 2 | LYARD | Yard | nvarchar | 3 | 0 | | |
8 | LYLGR | Geographical location group | 2 | LYARD | Yard | nvarchar | 3 | 0 | | |
9 | LYLGRT | Define Location Groups | 3 | LYARD | Yard | nvarchar | 3 | 0 | | |
10 | LYLOC | Yard location | 2 | LYARD | Yard | nvarchar | 3 | 0 | | |
11 | LYLTY | Physical location type | 2 | LYARD | Yard | nvarchar | 3 | 0 | | |
12 | LYLTYT | Text Table for Physical Location Type | 3 | LYARD | Yard | nvarchar | 3 | 0 | | |
13 | LYRSN | Reason codes | 2 | LYARD | Yard | nvarchar | 3 | 0 | | |
14 | LYRSNT | Text Table for Reason Codes | 3 | LYARD | Yard | nvarchar | 3 | 0 | | |
15 | LYSPF | Scheduling profile | 2 | LYARD | Yard | nvarchar | 3 | 0 | | |
16 | LYSPFT | Text Table for Scheduling Profile | 3 | LYARD | Yard | nvarchar | 3 | 0 | | |
17 | LYYRD | Yard | 2 | LYARD | Yard | nvarchar | 3 | 0 | | |
18 | LYYRDT | Text Table for Yard | 3 | LYARD | Yard | nvarchar | 3 | 0 | | |