| 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 | 12 | CTOOI | Country of Origin (Intrastat Code) | nvarchar | 2 | 0 | | |
2 | /ECRS/RPAC | Aggregated Correction Item | 15 | CTOOI | Country of Origin (Intrastat Code) | nvarchar | 2 | 0 | | |
3 | /ECRS/RPAI | Aggregated Declaration Item | 12 | CTOOI | Country of Origin (Intrastat Code) | nvarchar | 2 | 0 | | |
4 | /ECRS/RPIC | Correction Item | 18 | CTOOI | Country of Origin (Intrastat Code) | nvarchar | 2 | 0 | | |
5 | /ECRS/RPIT | Declaration Item | 15 | CTOOI | Country of Origin (Intrastat Code) | nvarchar | 2 | 0 | | |
6 | /ECRS/TCOO | Country of Origin (Intrastat Code) | 2 | CTOOI | Country of Origin (Intrastat Code) | nvarchar | 2 | 0 | | |
7 | /ECRS/TCOOT | Country of Origin (Intrastat Code) Name | 3 | CTOOI | Country of Origin (Intrastat Code) | nvarchar | 2 | 0 | | |
8 | /ECRS/TMCO | Exceptions for Mapping to Country of Origin | 5 | CTOOI | Country of Origin (Intrastat Code) | nvarchar | 2 | 0 | | |
9 | /ECRS/TRCO | Country of Origin (Intrastat Code) Assignm. to Ctry of Decl. | 3 | CTOOI | Country of Origin (Intrastat Code) | nvarchar | 2 | 0 | | |