| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | ADDRNUMBER | Address number | nvarchar | 10 | 0 | | | | Allow NULL? |
| 2 | CONSNUMBER | Sequence Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 3 | FLGDEFAULT | Standard Sender Address in this Communication Type | char | 1 | 0 | | | | Allow NULL? |
| 4 | FLG_NOUSE | Flag: This Communication Number is Not Used | char | 1 | 0 | | | | Allow NULL? |
| 5 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | char | 1 | 0 | | | | Allow NULL? |
| 6 | SMTP_ADDR | E-Mail Address | nvarchar | 241 | 0 | | | | Allow NULL? |
| 7 | SMTP_SRCH | E-Mail Address Search Field | nvarchar | 20 | 0 | | | | Allow NULL? |
| 8 | DFT_RECEIV | Flag: Recipient is standard recipient for this number | char | 1 | 0 | | | | Allow NULL? |
| 9 | R3_USER | Flag: Connected to an SAP System | char | 1 | 0 | | | | Allow NULL? |
| 10 | ENCODE | Desired Data Coding (E-Mail) | char | 1 | 0 | | | | Allow NULL? |
| 11 | TNEF | Flag: Receiver can receive TNEF coding via SMTP | char | 1 | 0 | | | | Allow NULL? |
| 12 | REMARK | Communication link notes | nvarchar | 50 | 0 | | | | Allow NULL? |
| 13 | VALID_FROM | Communication Data: Valid From (YYYYMMDDHHMMSS) | nvarchar | 14 | 0 | | | | Allow NULL? |
| 14 | VALID_TO | Communication Data: Valid To (YYYYMMDDHHMMSS) | nvarchar | 14 | 0 | | | | Allow NULL? |
| 15 | UPDATEFLAG | Change operation code ('I'nsert, 'U'pdate, 'D'elete) | char | 1 | 0 | | | | Allow NULL? |
