| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPIntercompany Data Exchange |
1 | EIDESWTDOC | Switch Document Header | 24 | EXT_REFERENCE | External Switch Document Reference | nvarchar | 80 | 0 | | |
2 | EIDESWTDOCTMP | Temporary Switch Document Header Data | 24 | EXT_REFERENCE | External Switch Document Reference | nvarchar | 80 | 0 | | |
TOPMaster Data |
3 | GMGR | Grant Master | 5 | EXT_REFERENCE | Alternate Grant Identifier | nvarchar | 24 | 0 | | |
TOPMovables |
4 | CMS_MOVABLES | Movable Details - Vehicles, Devices & Aircraft | 22 | EXT_REFERENCE | Reference number for the legacy system | nvarchar | 32 | 0 | | |
TOPRights |
5 | CMS_INS | Insurance Application Table | 19 | EXT_REFERENCE | Reference number for the legacy system | nvarchar | 32 | 0 | | |
6 | CMS_RIG | CMS: Rights table. Includes claims, patents, other rights. | 11 | EXT_REFERENCE | Reference number for the legacy system | nvarchar | 32 | 0 | | |
TOPTrading Contract |
7 | PPE_D_ITEM_LIST | Events | 27 | EXT_REFERENCE | External Identifier for PPE Event | nvarchar | 10 | 0 | | |
TOPTransaction Management |
8 | VTB_WEB_QUOTES | FX Quotes Received | 19 | EXT_REFERENCE | External Reference | nvarchar | 16 | 0 | | |