| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPBasic functions |
1 | COMM_IL_PRDBP | Master Data of Relationship Type Partner | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
2 | COMM_IL_PRDBP_H | Historical Data for Relationship Type Partner | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
TOPCentral Part of Product Master |
3 | COMM_IL_ACCESS | Master Data of Relationship Type Accessories | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
4 | COMM_IL_ACCESS_H | Historical Data of Relationship Type Accessories | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
5 | COMM_IL_COMPET | Assignment of Own Products to Competitor Products | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
6 | COMM_IL_PRDCPN | Master Data of Relationship Type Customers | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
7 | COMM_IL_PRDCPN_H | Historical Data of Relationship Type Customers | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
8 | COMM_IL_PRDCTP | Master Data of Relationship Type Content Provider | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
9 | COMM_IL_PRDCTP_H | Historical Data of Relationship Type Content Provider | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
10 | COMM_IL_PRDMPN | Master Data of Relationship Type Manufacturer | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
11 | COMM_IL_PRDMPN_H | Historical Data of Relationship Type Manufacturer | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
12 | COMM_IL_PRDMRK | Marketing Material | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
13 | COMM_IL_PRDMRK_H | Marketing Material History | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
14 | COMM_IL_PRDVND | Master Data of Relationship Type Vendors | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
15 | COMM_IL_PRDVND_H | Historical Data of Relationship Type Vendors | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
16 | COMM_IL_PROREF | Master Data of Relationship Type Reference Product | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
17 | COMM_IL_PROREF_H | Historical Data of Relationship Type Reference Product | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
18 | COMM_IL_SERVI | Master Data of Relationship Type Services | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
19 | COMM_IL_SERVI_H | Historical Data of Relationship Type Services | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
20 | COMM_IL_SPARE | Master Data of Relationship Type Spare Parts | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
21 | COMM_IL_SPARE_H | Historical Data of Relationship Type Spare Parts | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
TOPClassification System New |
22 | COMM_IL_DSCOPE | Definition Scope | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
23 | COMM_IL_DSCOPE_H | Change Graph for History Table | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
24 | COMM_IL_DTYPE | Engineering Change Management: Change Graph | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
25 | COMM_IL_DTYPE_H | Change Graph for History Table | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
26 | COMM_IL_SCPCHR | Definition Scope -> Characteristic | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
27 | COMM_IL_SCPCHR_H | Change Graph for History Table | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
TOPEngineering Change Management |
28 | COMM_IL_ECMCHG | Engineering Change Management: Change Graph | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |
29 | COMM_IL_ECMCHG_H | Change Graph for History Table | 2 | ILGUID | Internal, Unique ID of a Relationship | varbinary | 16 | 0 | | |