| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAddress ManagementBusiness Address |
1 | ADCP | Person/Address Assignment (Business Address Services) | 20 | DEFLT_COMM | Communication Method (Key) (Business Address Services) | nvarchar | 3 | 0 | | |
2 | ADCPS | Shadow Table: Assignment Person/Addr. (Bus. Addr. Services) | 21 | DEFLT_COMM | Communication Method (Key) (Business Address Services) | nvarchar | 3 | 0 | | |
3 | ADRC | Addresses (Business Address Services) | 59 | DEFLT_COMM | Communication Method (Key) (Business Address Services) | nvarchar | 3 | 0 | | |
4 | ADRCS | Shadow Table: Addresses (Business Address Services) | 60 | DEFLT_COMM | Communication Method (Key) (Business Address Services) | nvarchar | 3 | 0 | | |
5 | ADRCS2 | Shadow Table 2: Addresses (Business Address Services) | 61 | DEFLT_COMM | Communication Method (Key) (Business Address Services) | nvarchar | 3 | 0 | | |
TOPBank Customer Accounts |
6 | BCA_US_BC_ADDR | Addresses Associated with Bank Cheques | 50 | DEFLT_COMM | Communication Method (Key) (Business Address Services) | nvarchar | 3 | 0 | | |
TOPFinancial Accounting |
7 | AC400ADRC | P01 Adressen für Programm AC400DEBITOR | 59 | DEFLT_COMM | Kommunikationsart (Schlüssel) (Business Address Services) | nvarchar | 3 | 0 | | |
TOPGlobal Trade Services |
8 | /SAPSLL/PREVDAUD | SLL: Preference: Vend.Decl. for Customer Purp.: Audit | 78 | DEFLT_COMM | Communication Method (Key) (Business Address Services) | nvarchar | 3 | 0 | | |
9 | /SAPSLL/SPLAUD | Legal Control - SPL - Audit | 111 | DEFLT_COMM | Communication Method (Key) (Business Address Services) | nvarchar | 3 | 0 | | |
TOPMaster Data |
10 | EFISEL | Field Selection Control for Address Data | 19 | DEFLT_COMM | Communication Type (Key) (Central Address Management) | nvarchar | 1 | 0 | | |
TOPWaste Management |
11 | EPROP_ADRFLD_SEL | Field Selection Control for Address Screen of Property | 19 | DEFLT_COMM | Communication Type (Key) (Central Address Management) | nvarchar | 1 | 0 | | |
12 | EROB_ADDRFLD_SEL | Field Selection Control for Add. Screen of Cleaning Object | 19 | DEFLT_COMM | Communication Type (Key) (Central Address Management) | nvarchar | 1 | 0 | | |