| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCentral Part of Product Master |
1 | COMC_SETTYPE | Administrative Tables for Set Types | 1 | FRGTYPE_GUID | Internal Key of a Set Type | nvarchar | 32 | 0 | | |
2 | COMC_SETTYPE_SFW | Definition of Switch per Set Type and Product Type | 1 | FRGTYPE_GUID | Internal Key of a Set Type | nvarchar | 32 | 0 | | |
3 | COMC_SETTYPE_T | Set Type Text | 1 | FRGTYPE_GUID | Internal Key of a Set Type | nvarchar | 32 | 0 | | |
4 | COMM_CATFRGR | Category Set-Type Assignment | 3 | FRGTYPE_GUID | Internal Key of a Set Type | varbinary | 16 | 0 | | |
5 | COMM_CATFRGRH | Assignment Category - Set Type: History | 3 | FRGTYPE_GUID | Internal Key of a Set Type | varbinary | 16 | 0 | | |
6 | COMM_FRGTYPE | Set Type | 1 | FRGTYPE_GUID | Internal Key of a Set Type | nvarchar | 32 | 0 | | |
7 | COMM_FRGTYPE_T | Set Type Text | 1 | FRGTYPE_GUID | Internal Key of a Set Type | nvarchar | 32 | 0 | | |
8 | COMM_PRCATFRGR | Assignment Product Category - Set Type | 3 | FRGTYPE_GUID | Internal Key of a Set Type | varbinary | 16 | 0 | | |
9 | COMM_PRCATFRGRH | Product Category - Set Type Assignment: History | 3 | FRGTYPE_GUID | Internal Key of a Set Type | varbinary | 16 | 0 | | |
10 | COMM_PT_FT_CREAT | Which Sets May Be Created for Which Product Type | 2 | FRGTYPE_GUID | Internal Key of a Set Type | varbinary | 16 | 0 | | |