Tema anterior: Objeto kwrdTema siguiente: Objeto LONG_TEXTS


Objeto loc

Los detalles del objeto son los siguientes:

Tabla asociada: ca_location

Fábricas: predeterminado

REL_ATTR: id

Nombre común: nombre

Grupo de funciones: inventario

Operaciones REST: CREATE READ UPDATE

Atributo

Campo BD

Tipo de dato

Referencias SREL

Indicadores

address1

address_1

STRING

 

 

address2

address_2

STRING

 

 

address3

address_3

STRING

 

 

address4

address_4

STRING

 

 

address5

address_5

STRING

 

 

address6

address_6

STRING

 

 

ciudad

ciudad

STRING

 

 

description

comentario

STRING

 

 

contact_address_flag

contact_address_flag

integer

 

 

país

país

integer

ca_country id

 

condado

condado

STRING

 

 

creation_date

creation_date

LOCAL_TIME

 

 

creation_user

creation_user

STRING

 

 

delete_time

delete_time

LOCAL_TIME

 

 

exclude_registration

exclude_registration

integer

 

 

fax_number

fax_number

STRING

 

 

geo_coord_type

geo_coord_type

integer

 

 

geo_coords

geo_coords

STRING

 

 

delete_flag

inactive

integer

actbool enum

 

last_mod

last_update_date

LOCAL_TIME

 

 

last_update_user

last_update_user

STRING

 

 

name

location_name

STRING

 

 

id

location_uuid

UUID

 

UNIQUE REQUIRED KEY

mail_address_1

mail_address_1

STRING

 

 

mail_address_2

mail_address_2

STRING

 

 

mail_address_3

mail_address_3

STRING

 

 

mail_address_4

mail_address_4

STRING

 

 

mail_address_5

mail_address_5

STRING

 

 

mail_address_6

mail_address_6

STRING

 

 

pri_phone_number

pri_phone_number

STRING

 

 

primary_contact_uuid

primary_contact_uuid

UUID

 

 

site

site_id

integer

ca_site id

 

estado

estado

integer

ca_state_ province id

 

version_number

version_number

integer

 

 

zip

zip

STRING