| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPALE Integration Technology |
| 1 | EDFI2 | EDI: Last processed document in file | 4 | DELETEFLAG | Flag: Delete IDoc file | nvarchar | 1 | 0 | | |
| TOPBusiness Configuration Sets |
| 2 | SCPRRECA | BC Set: BC Set record attributes | 10 | DELETEFLAG | BC Sets: Data Record Deletion Flag | nvarchar | 1 | 0 | | |
| 3 | SCPRSRECA | Switch BC Set: BC Set Data Record Attributes | 10 | DELETEFLAG | BC Sets: Data Record Deletion Flag | nvarchar | 1 | 0 | | |
| TOPClassification System New |
| 4 | COMM_IL_DSCOPE | Definition Scope | 12 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 5 | COMM_IL_DSCOPE_H | Change Graph for History Table | 13 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 6 | COMM_IL_DTYPE | Engineering Change Management: Change Graph | 12 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 7 | COMM_IL_DTYPE_H | Change Graph for History Table | 13 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 8 | COMM_IL_SCPCHR | Definition Scope -> Characteristic | 12 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 9 | COMM_IL_SCPCHR_H | Change Graph for History Table | 13 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| TOPLogistics Basic Data |
| 10 | WRF_CMMD_CDT1 | Category | 20 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 11 | WRF_CMMD_CDT2 | Subcategory | 20 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 12 | WRF_CMMD_CDT3 | Segment | 20 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 13 | WRF_CMMD_CDT4 | Subsegment | 20 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 14 | WRF_CMMD_CDT5 | Sub-Subsegment | 20 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 15 | WRF_CMMD_CDT6 | Product Group | 20 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 16 | WRF_CMMD_CDT7 | Brand | 20 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 17 | WRF_CMMD_SKU | CDT-SKU Assignment Table | 20 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 18 | WRF_MATGRP_MD1 | Hierarchy Level 1 - Time-Dependent | 19 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 19 | WRF_MATGRP_MD10 | Hierarchy Level 10 - Time-Dependent | 28 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 20 | WRF_MATGRP_MD2 | Hierarchy Level 2 - Time-Dependent | 20 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 21 | WRF_MATGRP_MD3 | Hierarchy Level 3 - Time-Dependent | 21 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 22 | WRF_MATGRP_MD4 | Hierarchy Level 4 - Time-Dependent | 22 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 23 | WRF_MATGRP_MD5 | Hierarchy Level 5 - Time-Dependent | 23 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 24 | WRF_MATGRP_MD6 | Hierarchy Level 6 - Time-Dependent | 24 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 25 | WRF_MATGRP_MD7 | Hierarchy Level 7 - Time-Dependent | 25 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 26 | WRF_MATGRP_MD8 | Hierarchy Level 8 - Time-Dependent | 26 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 27 | WRF_MATGRP_MD9 | Hierarchy Level 9 - Time-Dependent | 27 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
| 28 | WRF_MATGRP_PROD | Hierarchy-Product Assignment Table | 27 | DELETEFLAG | Deletion Indicator | nvarchar | 1 | 0 | | |
