ROW_ID

Varchar (15)

Required. Siebel system field.

PER_COMM_ADDR_ID

Varchar (15)

Required. The communication address best version record ID. The foreign key table is S_PER_COMM_ADDR.

COMM_MEDIUM_CD

Varchar (30)

Required. Comm Medium Code. Comm Medium Code refers to the code for the communication media channel. Examples are email, ICQ, phone, and so on.

CIF_EXT_SYST_ID

Varchar (15)

Required. The external system ID. The foreign key table is S_CIF_EXT_SYST.

EXT_COMM_ADDR_ID1

Varchar (100)

Required. The first cross reference ID.

EXT_COMM_ADDR_ID2

Varchar (100)

The second cross reference ID.

EXT_COMM_ADDR_ID3

Varchar (100)

The third cross reference ID.

COMMENTS

Varchar (250)

Comments.

CONFLICT_ID

Varchar (15)

Required. Siebel system field.

CREATED

UTC Date Time (7)

Required. Siebel system field.

CREATED_BY

Varchar (15)

Required. Siebel system field. The foreign key table is S_USER.

DB_LAST_UPD

UTC Date Time (7)

Siebel system field.

DB_LAST_UPD_SRC

Varchar (50)

Siebel system field.

LAST_UPD

UTC Date Time (7)

Required. Siebel system field.

LAST_UPD_BY

Varchar (15)

Required. Siebel system field. The foreign key table is S_USER.

MODIFICATION_NUM

Number (22)

Required. Siebel system field.