| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPElectronic Compliance Reporting |
1 | /ECRS/DVIA | Default Values for Import Worklist | 8 | MOTAB | Mode of Transport at the Border (Intrastat Code) | nvarchar | 1 | 0 | | |
2 | /ECRS/RPAC | Aggregated Correction Item | 16 | MOTAB | Mode of Transport at the Border (Intrastat Code) | nvarchar | 1 | 0 | | |
3 | /ECRS/RPAI | Aggregated Declaration Item | 13 | MOTAB | Mode of Transport at the Border (Intrastat Code) | nvarchar | 1 | 0 | | |
4 | /ECRS/RPIC | Correction Item | 19 | MOTAB | Mode of Transport at the Border (Intrastat Code) | nvarchar | 1 | 0 | | |
5 | /ECRS/RPIT | Declaration Item | 16 | MOTAB | Mode of Transport at the Border (Intrastat Code) | nvarchar | 1 | 0 | | |
6 | /ECRS/TMOT | Mode of Transport at the Border (Intrastat Code) | 3 | MOTAB | Mode of Transport at the Border (Intrastat Code) | nvarchar | 1 | 0 | | |
7 | /ECRS/TMOTT | Mode of Transport at the Border (Intrastat Code) Name | 4 | MOTAB | Mode of Transport at the Border (Intrastat Code) | nvarchar | 1 | 0 | | |
8 | /ECRS/TPRT | Port/Airport (Intrastat Code) | 3 | MOTAB | Mode of Transport at the Border (Intrastat Code) | nvarchar | 1 | 0 | | |
9 | /ECRS/TPRTT | Port/Airport (Intrastat Code) Name | 4 | MOTAB | Mode of Transport at the Border (Intrastat Code) | nvarchar | 1 | 0 | | |
10 | /ECRS/WLEN | Worklist for Intrastat Declaration | 52 | MOTAB | Mode of Transport at the Border (Intrastat Code) | nvarchar | 1 | 0 | | |
TOPPublic Sector |
11 | T5D7G | Variants for Different Pay Scale Elements | 3 | MOTAB | Name of Table for Defining Pay Scale Variants | nvarchar | 5 | 0 | | |