| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAssortment |
| 1 | WRF_APC_PABD | Planned Article Basic Data | 24 | EAN_UPC_TYPE | Type of material identification | nvarchar | 2 | 0 | | |
| 2 | WRF_APC_PAVAR | Planned Article Variants | 9 | EAN_UPC_TYPE | Type of material identification | nvarchar | 2 | 0 | | |
| TOPElectronic Data Interchange |
| 3 | PRICAT_K003 | PRICAT: Catalog item basic data | 6 | EAN_UPC_TYPE | Type of material identification | nvarchar | 2 | 0 | | |
| 4 | PRICAT_K003_PRO | Indication of Data to be Adopted from PRICAT_K003 | 6 | EAN_UPC_TYPE | Indicator for copying catalog data | nvarchar | 1 | 0 | | |
| 5 | PRICAT_K004 | PRICAT:Cat. item units of measure, dimensions, weights,EANs | 7 | EAN_UPC_TYPE | Type of material identification | nvarchar | 2 | 0 | | |
| 6 | PRICAT_K004_PRO | Indication of Data to be Adopted from PRICAT_K004 | 5 | EAN_UPC_TYPE | Indicator for copying catalog data | nvarchar | 1 | 0 | | |
