| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ADDRNUMBER | Address number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | PERSNUMBER | Person number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | DATE_FROM | Valid-from date - in current Release only 00010101 possible | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | CONSNUMBER | Sequence Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 6 | FLGDEFAULT | Flag: this address is the default address | char | 1 | 0 | | | | Allow NULL? |
| 7 | FLG_NOUSE | Flag: This Communication Number is Not Used | char | 1 | 0 | | | | Allow NULL? |
| 8 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | char | 1 | 0 | | | | Allow NULL? |
| 9 | DFT_RECEIV | Flag: Recipient is standard recipient for this address | char | 1 | 0 | | | | Allow NULL? |
| 10 | R3_USER | Flag: Connected to an SAP System | char | 1 | 0 | | | | Allow NULL? |
| 11 | TXT_ENCODE | Desired text data coding (X.400) | char | 1 | 0 | | | | Allow NULL? |
| 12 | TNEF | Flag: Receiver can receive TNEF coding via X.400 | char | 1 | 0 | | | | Allow NULL? |
| 13 | X4COUNTRY | X.400 country code | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | X4ADMIN | X.400 administration domain | nvarchar | 16 | 0 | | | | Allow NULL? |
| 15 | X4PRIVD | X.400 private domain | nvarchar | 16 | 0 | | | | Allow NULL? |
| 16 | X4ORG | X.400 organization | nvarchar | 64 | 0 | | | | Allow NULL? |
| 17 | X4ORG1 | X.400 organizational unit 1 | nvarchar | 32 | 0 | | | | Allow NULL? |
| 18 | X4ORG2 | X.400 organizational unit 2 | nvarchar | 32 | 0 | | | | Allow NULL? |
| 19 | X4ORG3 | X.400 organizational unit 3 | nvarchar | 32 | 0 | | | | Allow NULL? |
| 20 | X4ORG4 | X.400 organizational unit 4 | nvarchar | 32 | 0 | | | | Allow NULL? |
| 21 | X4LNAME | X.400 last name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 22 | X4FNAME | X.400 first name | nvarchar | 16 | 0 | | | | Allow NULL? |
| 23 | X4INI | X.400 Initials | nvarchar | 5 | 0 | | | | Allow NULL? |
| 24 | X4GENER | X.400 generation | nvarchar | 3 | 0 | | | | Allow NULL? |
| 25 | X4X121 | X.400 X.121 network address | nvarchar | 15 | 0 | | | | Allow NULL? |
| 26 | X4TERMID | X.400 Terminal ID | nvarchar | 24 | 0 | | | | Allow NULL? |
| 27 | X4TERMTP | X.400 terminal type | char | 1 | 0 | | | | Allow NULL? |
| 28 | X4UANUMID | X.400 user agent numeric ID | nvarchar | 32 | 0 | | | | Allow NULL? |
| 29 | DDA_TYPE1 | X.400 domain defined attribute, type 1 | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | DDA_VALUE1 | X.400 domain defined attribute, value 1 | nvarchar | 128 | 0 | | | | Allow NULL? |
| 31 | DDA_TYPE2 | X.400 domain defined attribute, type 2 | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | DDA_VALUE2 | X.400 domain defined attribute, value 2 | nvarchar | 128 | 0 | | | | Allow NULL? |
| 33 | DDA_TYPE3 | X.400 domain defined attribute, type 3 | nvarchar | 8 | 0 | | | | Allow NULL? |
| 34 | DDA_VALUE3 | X.400 domain defined attribute, value 3 | nvarchar | 128 | 0 | | | | Allow NULL? |
| 35 | DDA_TYPE4 | X.400 domain defined attribute, type 4 | nvarchar | 8 | 0 | | | | Allow NULL? |
| 36 | DDA_VALUE4 | X.400 domain defined attribute, value 4 | nvarchar | 128 | 0 | | | | Allow NULL? |
| 37 | VALID_FROM | Communication Data: Valid From (YYYYMMDDHHMMSS) | nvarchar | 14 | 0 | | | | Allow NULL? |
| 38 | VALID_TO | Communication Data: Valid To (YYYYMMDDHHMMSS) | nvarchar | 14 | 0 | | | | Allow NULL? |
