Table 431. S_CIF_ADDR_MAP table details
|
|
|
ROW_ID |
Varchar (15) |
Siebel system field. |
ADDR_ID |
Varchar (15) |
Address best version record ID. The foreign key table is S_ADDR_PER. |
CIF_EXT_SYST_ID |
Varchar (15) |
External system ID. The foreign key table is S_CIF_EXT_SYST. |
EXT_ADDR_ID1 |
Varchar (100) |
The first cross reference ID. |
EXT_ADDR_ID2 |
Varchar (100) |
Place holder for second cross reference ID. |
EXT_ADDR_ID3 |
Varchar (100) |
Place holder for third cross reference ID. |
PAR_OBJTYPE_CD |
Varchar (30) |
Parent object type: Account, or Contact. The bounded LOV is :UCM_OBJECT_TYPE_CD. |
COMMENTS |
Varchar (250) |
Comments. |
CONFLICT_ID |
Varchar (15) |
Siebel system field. |
CREATED |
UTC Date Time (7) |
Siebel system field. |
CREATED_BY |
Varchar (15) |
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) |
Siebel system field. |
LAST_UPD_BY |
Varchar (15) |
Siebel system field. The foreign key table is S_USER. |
MODIFICATION_NUM |
Number (22) |
Siebel system field. |