| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPElectronic Compliance Reporting |
1 | /ECRS/RPAC | Aggregated Correction Item | 4 | GUID_RPHD | GUID in 'RAW' format | varbinary | 16 | 0 | | |
2 | /ECRS/RPAI | Aggregated Declaration Item | 4 | GUID_RPHD | GUID in 'RAW' format | varbinary | 16 | 0 | | |
3 | /ECRS/RPCF | Control Field: Declaration Item | 2 | GUID_RPHD | GUID in 'RAW' format | varbinary | 16 | 0 | | |
4 | /ECRS/RPCH | Field Control: Declaration Header | 2 | GUID_RPHD | GUID in 'RAW' format | varbinary | 16 | 0 | | |
5 | /ECRS/RPCM | Special Case Determination: Declaration Item | 2 | GUID_RPHD | GUID in 'RAW' format | varbinary | 16 | 0 | | |
6 | /ECRS/RPCS | Field Control: Declaration Item | 2 | GUID_RPHD | GUID in 'RAW' format | varbinary | 16 | 0 | | |
7 | /ECRS/RPHD | Intrastat Declaration Header Data | 2 | GUID_RPHD | GUID in 'RAW' format | varbinary | 16 | 0 | | |
8 | /ECRS/RPIC | Correction Item | 4 | GUID_RPHD | GUID in 'RAW' format | varbinary | 16 | 0 | | |
9 | /ECRS/RPIT | Declaration Item | 4 | GUID_RPHD | GUID in 'RAW' format | varbinary | 16 | 0 | | |
10 | /ECRS/RPLH | Log Header Import from Worklist | 4 | GUID_RPHD | GUID in 'RAW' format | varbinary | 16 | 0 | | |
11 | /ECRS/RPLI | Log Item Import from Worklist | 3 | GUID_RPHD | GUID in 'RAW' format | varbinary | 16 | 0 | | |