| 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 | 5 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
2 | /ECRS/POIA | Provider of Information | 3 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
3 | /ECRS/RPAC | Aggregated Correction Item | 5 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
4 | /ECRS/RPAI | Aggregated Declaration Item | 5 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
5 | /ECRS/RPHD | Intrastat Declaration Header Data | 5 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
6 | /ECRS/RPIC | Correction Item | 6 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
7 | /ECRS/RPIT | Declaration Item | 6 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
8 | /ECRS/TBTT | Business Transaction Type (Intrastat Code) | 2 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
9 | /ECRS/TBTTT | Business Transaction Type (Intrastat Code) Name | 3 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
10 | /ECRS/TCCE | Collection Center (Intrastat Code) | 2 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
11 | /ECRS/TCCET | Collection Center (Intrastat Code) Name | 3 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
12 | /ECRS/TCIF | Control Field: Declaration Item | 1 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
13 | /ECRS/TCIM | Special Case Determination: Declaration Item | 1 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
14 | /ECRS/TCIS | Field Control: Declaration Item | 1 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
15 | /ECRS/TCPC | Foreign Currency in Partner Country | 2 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
16 | /ECRS/TERE | Exclusion of Regions from Intrastat | 2 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
17 | /ECRS/TFCH | Field Control: Declaration Header | 1 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
18 | /ECRS/TFCP | Field Control: Provider of Information | 1 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
19 | /ECRS/TGFC | Format of Declaration File | 1 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
20 | /ECRS/TGFCT | Format of Declaration File - Name | 2 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
21 | /ECRS/TINC | Incoterms (Intrastat Code) | 2 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
22 | /ECRS/TINCT | Incoterms (Intrastat Code) Name | 3 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
23 | /ECRS/TMCO | Exceptions for Mapping to Country of Origin | 2 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
24 | /ECRS/TMOT | Mode of Transport at the Border (Intrastat Code) | 2 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
25 | /ECRS/TMOTT | Mode of Transport at the Border (Intrastat Code) Name | 3 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
26 | /ECRS/TMPC | Exceptions for Mapping to Partner Country | 2 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
27 | /ECRS/TMRE | Region Mapping | 2 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
28 | /ECRS/TPRC | Procedure (Intrastat Code) | 2 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
29 | /ECRS/TPRCT | Procedure (Intrastat Code) Name | 3 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
30 | /ECRS/TPRT | Port/Airport (Intrastat Code) | 2 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
31 | /ECRS/TPRTT | Port/Airport (Intrastat Code) Name | 3 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
32 | /ECRS/TRAP | Partner Country Assignment (Intrastat Code) to Ctry of Decl. | 2 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
33 | /ECRS/TRCO | Country of Origin (Intrastat Code) Assignm. to Ctry of Decl. | 2 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
34 | /ECRS/TRFL | Rounding of Intrastat Fields | 1 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
35 | /ECRS/TRGI | Region (Intrastat Code) | 2 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
36 | /ECRS/TRGIT | Region (Intrastat Code) Name | 3 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
37 | /ECRS/TRPC | Country of Declaration (ISO Code) | 1 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
38 | /ECRS/TRPCT | Country of Declaration (ISO Code) Name | 2 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
39 | /ECRS/TRPL | Declaration Level | 1 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
40 | /ECRS/TRPLT | Declaration Level Name | 2 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
41 | /ECRS/TSMC | Special Movement Code (Intrastat Code) | 2 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
42 | /ECRS/TSMCT | Special Movement Code (Intrastat Code) Name | 3 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |
43 | /ECRS/WLEN | Worklist for Intrastat Declaration | 49 | RPCTI | Country of Declaration (ISO Code) | nvarchar | 2 | 0 | | |