| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | BBP_SUS_STG_FAX | Staging address table | 14 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 2 | BBP_SUS_STG_MAIL | staging mail table | 11 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 3 | BBP_SUS_STG_TEL | Staging table for telephone | 13 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 4 | NWS_EXT_ADFA2 | Transfer structure for fax numbers (central address admin.) | 6 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 5 | NWS_EXT_ADFAX | Transfer structure for fax numbers (central address admin.) | 6 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 6 | NWS_EXT_ADPA2 | Transfer Structure for Page Numbers (Centr. Addr. Mgmnt) | 6 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 7 | NWS_EXT_ADPAG | Transfer Structure for Page Numbers (Centr. Addr. Mgmnt) | 6 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 8 | NWS_EXT_ADPR2 | Transfer Structure for PRT Addresses (Centr. Address Mgmnt) | 5 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 9 | NWS_EXT_ADPRT | Transfer Structure for PRT Addresses (Centr. Address Mgmnt) | 5 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 10 | NWS_EXT_ADRF2 | Transfer Structure for RFC Addresses (Centr. Addr. Mgmnt) | 5 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 11 | NWS_EXT_ADRFC | Transfer Structure for RFC Addresses (Centr. Addr. Mgmnt) | 5 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 12 | NWS_EXT_ADRM2 | Transfer Structure for RML Addresses (Centr. Addr. Mgmnt) | 5 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 13 | NWS_EXT_ADRML | Transfer Structure for RML Addresses (Centr. Addr. Mgmnt) | 5 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 14 | NWS_EXT_ADSM2 | Transfer Structure for SMTP Addresses (Centr. Addr. Mgmnt) | 5 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 15 | NWS_EXT_ADSMT | Transfer Structure for SMTP Addresses (Centr. Addr. Mgmnt) | 5 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 16 | NWS_EXT_ADSS2 | Transfer Structure for SSF Addresses (Centr. Addr. Mgmnt) | 4 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 17 | NWS_EXT_ADSSF | Transfer Structure for SSF Addresses (Centr. Addr. Mgmnt) | 4 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 18 | NWS_EXT_ADTE2 | Transfer Structure for Telephone Nos (Centr. Addr. Mgmnt) | 6 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 19 | NWS_EXT_ADTEL | Transfer Structure for Telephone Nos (Centr. Addr. Mgmnt) | 6 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 20 | NWS_EXT_ADTL2 | Transfer Structure for Telex Nos (Centr. Addr. Mgmnt) | 6 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 21 | NWS_EXT_ADTLX | Transfer Structure for Telex Nos (Centr. Addr. Mgmnt) | 6 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 22 | NWS_EXT_ADTT2 | Transfer Structure for Teletex Numbers (Centr. Addr. Mgmnt) | 6 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 23 | NWS_EXT_ADTTX | Transfer Structure for Teletex Numbers (Centr. Addr. Mgmnt) | 6 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 24 | NWS_EXT_ADUR2 | URI address transfer structure (central address management) | 4 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 25 | NWS_EXT_ADURI | URI address transfer structure (central address management) | 4 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 26 | NWS_EXT_ADX40 | Transfer Structure for X.400 Addresses (Centr. Addr. Mgmnt) | 5 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 27 | NWS_EXT_ADX42 | Transfer Structure for X.400 Addresses (Centr. Addr. Mgmnt) | 5 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| TOPAddress ManagementBusiness Address |
| 28 | ADR10 | Printer (Business Address Services) | 8 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 29 | ADR10S | Shadow Table: Printer (Business Address Services) | 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 30 | ADR10S2 | Shadow Table 2: Printer (Business Address Services) | 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 31 | ADR11 | SSF (Business Address Services) | 8 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 32 | ADR11S | Shadow Table: SSF (Business Address Services) | 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 33 | ADR11S2 | Shadow Table 2: SSF (Business Address Services) | 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 34 | ADR12 | FTP and URL (Business Address Services) | 8 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 35 | ADR12S | Shadow Table: FTP and URL (Business Address Services) | 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 36 | ADR12S2 | Shadow Table 2: FTP and URL (Business Address Services) | 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 37 | ADR13 | Pager (Business Address Services) | 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 38 | ADR13S | Shadow Table: Pager (Business Address Services) | 10 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 39 | ADR13S2 | Shadow Table 2: Pager (Business Address Services) | 10 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 40 | ADR14 | Reserve Communication Method (Business Address Services) | 7 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 41 | ADR15 | Reserve Communication Method (Business Address Services) | 7 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 42 | ADR16 | Reserve Communication Method (Business Address Services) | 7 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 43 | ADR2 | Telephone Numbers (Business Address Services) | 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 44 | ADR2S | Shadow Table: Telephone Numbers (Business Address Services) | 10 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 45 | ADR2S2 | Shadow Table 2: Telephone Nos (Business Address Services) | 10 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 46 | ADR3 | Fax Numbers (Business Address Services) | 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 47 | ADR3S | Shadow table: Fax numbers (Business Address Services) | 10 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 48 | ADR3S2 | Shadow Table 2: Fax Numbers (Business Address Services) | 10 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 49 | ADR4 | Teletex Numbers (Business Address Services) | 8 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 50 | ADR4S | Shadow Table: Teletex Numbers (Business Address Services) | 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 51 | ADR4S2 | Shadow Table 2: Teletex Numbers (Business Address Services) | 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 52 | ADR5 | Telex Numbers (Business Address Services) | 8 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 53 | ADR5S | Shadow Table: Fax Numbers (Business Address Services) | 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 54 | ADR5S2 | Shadow Table 2: Telex Numbers (Business Address Services) | 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 55 | ADR6 | E-Mail Addresses (Business Address Services) | 8 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 56 | ADR6S | Shadow Table: SMTP Numbers (Business Address Services) | 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 57 | ADR6S2 | Shadow Table 2: SMTP Numbers (Business Address Services) | 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 58 | ADR7 | Remote Mail Addresses (SAP - SAP - Communication; BAS) | 8 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 59 | ADR7S | Shadow Table: RML Addresses (Business Address Services) | 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 60 | ADR7S2 | Shadow Table 2: RML Addresses (Business Address Services) | 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 61 | ADR8 | X.400 Numbers (Business Address Services) | 8 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 62 | ADR8S | Shadow Table: X.400 Numbers (Business Address Services) | 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 63 | ADR8S2 | Shadow Table 2: X.400 Numbers (Business Address Services) | 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 64 | ADR9 | RFC Destinations (Business Address Services) | 8 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 65 | ADR9S | Shadow Table: RFC Destinations (Business Address Services) | 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
| 66 | ADR9S2 | Shadow Table 2: RFC Destination (Business Address Services) | 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | nvarchar | 1 | 0 | | |
