| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPBasic Data |
| 1 | NPER | IS-H: Persons | 7 | EXPNR | IS-H: External Personnel Number | nvarchar | 10 | 0 | | |
| TOPDistributor-Reseller-Management |
| 2 | /SAPHT/DRMCPACNV | DRM Partner Conversion | 4 | EXPNR | Additional data, e.g. ILN or D&B no. | nvarchar | 70 | 0 | | |
| TOPElectronic Data Interchange |
| 3 | EDPAR | Convert External < > Internal Partner Number | 4 | EXPNR | External partner number (in customer system) | nvarchar | 20 | 0 | | |
| TOPGermany |
| 4 | P01Y15 | PAISY: Management Table Subrecord Type 15 | 4 | EXPNR | PAISY: Export Number | nvarchar | 8 | 0 | | |
