| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | ADDRNUMBER | Address number | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | AD_ADDRNUM | Allow NULL? |
| 2 | CONSNUMBER | Sequence Number | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | AD_CONSNUM | Allow NULL? |
| 3 | FLGDEFAULT | Standard Sender Address in this Communication Type | char | 1 | 0 | CHAR | (N' ') | Yes | | AD_FLGDFNR | Allow NULL? |
| 4 | FLG_NOUSE | Flag: This Communication Number is Not Used | char | 1 | 0 | CHAR | (N' ') | Yes | | AD_FLNOUSE | Allow NULL? |
| 5 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | char | 1 | 0 | CHAR | (N' ') | Yes | | AD_FLGHOME | Allow NULL? |
| 6 | X4COUNTRY | X.400 country code | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | AD_X4CNTRY | Allow NULL? |
| 7 | X4ADMIN | X.400 administration domain | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | AD_X4ADMIN | Allow NULL? |
| 8 | X4PRIVD | X.400 private domain | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | AD_X4PRIVD | Allow NULL? |
| 9 | X4ORG | X.400 organization | nvarchar | 64 | 0 | CHAR | (N' ') | Yes | | AD_X4ORG | Allow NULL? |
| 10 | X4ORG1 | X.400 organizational unit 1 | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | AD_X4ORG1 | Allow NULL? |
| 11 | X4ORG2 | X.400 organizational unit 2 | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | AD_X4ORG2 | Allow NULL? |
| 12 | X4ORG3 | X.400 organizational unit 3 | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | AD_X4ORG3 | Allow NULL? |
| 13 | X4ORG4 | X.400 organizational unit 4 | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | AD_X4ORG4 | Allow NULL? |
| 14 | X4LNAME | X.400 last name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | AD_X4LNAME | Allow NULL? |
| 15 | X4FNAME | X.400 first name | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | AD_X4FNAME | Allow NULL? |
| 16 | X4INI | X.400 Initials | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | AD_X4INI | Allow NULL? |
| 17 | X4GENER | X.400 generation | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | AD_X4GENER | Allow NULL? |
| 18 | X4X121 | X.400 X.121 network address | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | AD_X4X121 | Allow NULL? |
| 19 | X4TERMID | X.400 Terminal ID | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | AD_X4TRMID | Allow NULL? |
| 20 | X4TERMTP | X.400 terminal type | char | 1 | 0 | CHAR | (N' ') | Yes | | AD_X4TRMTP | Allow NULL? |
| 21 | X4UANUMID | X.400 user agent numeric ID | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | AD_X4UANID | Allow NULL? |
| 22 | DDA_TYPE1 | X.400 domain defined attribute, type 1 | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | AD_X4DDAT1 | Allow NULL? |
| 23 | DDA_VALUE1 | X.400 domain defined attribute, value 1 | nvarchar | 128 | 0 | CHAR | (N' ') | Yes | | AD_X4DDAV1 | Allow NULL? |
| 24 | DDA_TYPE2 | X.400 domain defined attribute, type 2 | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | AD_X4DDAT2 | Allow NULL? |
| 25 | DDA_VALUE2 | X.400 domain defined attribute, value 2 | nvarchar | 128 | 0 | CHAR | (N' ') | Yes | | AD_X4DDAV2 | Allow NULL? |
| 26 | DDA_TYPE3 | X.400 domain defined attribute, type 3 | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | AD_X4DDAT3 | Allow NULL? |
| 27 | DDA_VALUE3 | X.400 domain defined attribute, value 3 | nvarchar | 128 | 0 | CHAR | (N' ') | Yes | | AD_X4DDAV3 | Allow NULL? |
| 28 | DDA_TYPE4 | X.400 domain defined attribute, type 4 | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | AD_X4DDAT4 | Allow NULL? |
| 29 | DDA_VALUE4 | X.400 domain defined attribute, value 4 | nvarchar | 128 | 0 | CHAR | (N' ') | Yes | | AD_X4DDAV4 | Allow NULL? |
| 30 | DFT_RECEIV | Flag: Recipient is standard recipient for this number | char | 1 | 0 | CHAR | (N' ') | Yes | | AD_DFTRCNR | Allow NULL? |
| 31 | R3_USER | Flag: Connected to an SAP System | char | 1 | 0 | CHAR | (N' ') | Yes | | AD_R3_USER | Allow NULL? |
| 32 | TXT_ENCODE | Desired text data coding (X.400) | char | 1 | 0 | CHAR | (N' ') | Yes | | AD_TENCODE | Allow NULL? |
| 33 | TNEF | Flag: Receiver can receive TNEF coding via X.400 | char | 1 | 0 | CHAR | (N' ') | Yes | | AD_TNEF8 | Allow NULL? |
| 34 | REMARK | Communication link notes | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | AD_REMARK2 | Allow NULL? |
| 35 | VALID_FROM | Communication Data: Valid From (YYYYMMDDHHMMSS) | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | AD_VALFROM | Allow NULL? |
| 36 | VALID_TO | Communication Data: Valid To (YYYYMMDDHHMMSS) | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | AD_VALTO | Allow NULL? |
| 37 | UPDATEFLAG | Change operation code ('I'nsert, 'U'pdate, 'D'elete) | char | 1 | 0 | CHAR | (N' ') | Yes | | AD_OP_CODE | Allow NULL? |