Tema anterior: Objeto cnoteTema siguiente: Objeto cnt_role


Objeto cnt

Los detalles del objeto son los siguientes:

Tablas asociada: ca_contact, usp_contact

Fábricas: predeterminado, agt, cst, grp

REL_ATTR: id

Nombre común: combo_name

Grupo de funciones: contacto

Tabla ca_contact

Operaciones REST: CREATE READ UPDATE

Atributo

Campo BD

Tipo de dato

Referencias SREL

Indicadores

access_type

access_type

SREL

acctyp.id

 

admin_org

admin_organization_uuid

UUID

ca_organization uuid

 

alias

alias

STRING

 

 

alt_phone

alt_phone_number

STRING

 

 

cnthandling_list

 

BREL

contact_handling

 

contact_num

alternate_identifier

STRING

 

 

notas

comentario

STRING

 

 

company

company_uuid

UUID

ca_company company_uuid

 

type

contact_type

integer

ca_contact_type id

 

id

contact_uuid

UUID

 

UNIQUE REQUIRED KEY

billing_code

cost_center

INTEGER

ca_resource_cost_center id

 

creation_date

creation_date

LOCAL_TIME

 

 

creation_user

creation_user

STRING

 

 

delete_time

delete_time

LOCAL_TIME

 

 

dept

departamento

INTEGER

ca_resource_department id

 

email_address

email_address

STRING

 

 

exclude_registration

exclude_registration

integer

 

 

fax_phone

fax_number

STRING

 

 

first_name

first_name

STRING

 

 

floor_location

floor_location

STRING

 

 

delete_flag

inactive

integer

actbool enum

 

job_function

job_function

integer

 

 

position

job_title

integer

ca_job_title id

 

last_name

last_name

STRING

 

 

last_mod

last_update_date

LOCAL_TIME

 

 

last_mod_by

last_update_user

STRING

 

 

ubicación

location_uuid

UUID

ca_location location_uuid

 

mail_stop

mail_stop

STRING

 

 

middle_name

middle_name

STRING

 

 

mobile_phone

mobile_phone_number

STRING

 

 

organización

organization_uuid

UUID

ca_organization uuid

 

pemail_address

pager_email_address

STRING

 

 

beeper_phone

pager_number

STRING

 

 

phone_number

pri_phone_number

STRING

 

 

funciones

funciones

LISTA

 

 

room_location

room_location

STRING

 

 

supervisor_contact_uuid

supervisor_contact_uuid

UUID

ca_contact uuid

 

ID de usuario

ID de usuario

STRING

 

 

version_number

version_number

integer