| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCross-Application Components |
1 | /OPT/VPR_ADDR | Vendor Address for Registered Vendor and Partner | 2 | ADDR_ID | Address ID to link to /OPT/VPR_ADDR table | nvarchar | 10 | 0 | | |
2 | /OPT/VPR_LOC | Vendor Registration Location | 3 | ADDR_ID | Address ID to link to /OPT/VPR_ADDR table | nvarchar | 10 | 0 | | |
TOPMovables |
3 | CMS_MOVABLES | Movable Details - Vehicles, Devices & Aircraft | 11 | ADDR_ID | Location / Address | nvarchar | 10 | 0 | | |
TOPReal Estate |
4 | CMS_RE_OBJ | Real estate header details | 5 | ADDR_ID | Address ID | nvarchar | 10 | 0 | | |
TOPRights |
5 | CMS_RIG | CMS: Rights table. Includes claims, patents, other rights. | 24 | ADDR_ID | Address of the object (for build.sav.contr./rental claim) | nvarchar | 10 | 0 | | |