| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2RG_NIC | National Insurance Contributions | 8 | PRRTY | NI calculation priority | nvarchar | 2 | 0 | | |
TOPBasic functions |
2 | VEKP | Handling Unit - Header Table | 119 | PRRTY | Vehicle Priority | nvarchar | 2 | 0 | | |
TOPGeneral Functions |
3 | CMAP_MVMP | Multiattribute Value Mapping | 5 | PRRTY | Priority ID (Also as Database Key Component) | nvarchar | 4 | 0 | | |
4 | CMAP_VLMP | Attribute Value Mapping | 4 | PRRTY | Priority ID (Also as Database Key Component) | nvarchar | 4 | 0 | | |
TOPTask Resource Management |
5 | LPRVL_TSK | Entities value table for task management package | 5 | PRRTY | Priority | decimal | 5 | 2 | | |
TOPUnited Kingdom |
6 | T5G_DTONI | National Insurance Data Take-on | 10 | PRRTY | NI calculation priority | nvarchar | 2 | 0 | | |
7 | T5G_NIDTO | National Insurance data take on | 8 | PRRTY | NI calculation priority | nvarchar | 2 | 0 | | |
TOPYard Management |
8 | LYACT | Yard activities | 12 | PRRTY | Vehicle Priority | nvarchar | 1 | 0 | | |