Vorheriges Thema: Objekt „kwrd“Nächstes Thema: Objekt „LONG_TEXTS“


Objekt „loc“

Die Objektdetails lauten wie folgt:

Verknüpfte Tabelle: ca_location

Factorys: default

REL_ATTR: id

Allgemeiner Name: name

Funktionsgruppe: inventory

REST-Vorgänge: CREATE READ UPDATE

Attribut

DB-Feld

Datentyp

SREL-Verweise

Markierungen

address1

address_1

STRING

 

 

address2

address_2

STRING

 

 

address3

address_3

STRING

 

 

address4

address_4

STRING

 

 

address5

address_5

STRING

 

 

address6

address_6

STRING

 

 

city

city

STRING

 

 

description

comment

STRING

 

 

contact_address_flag

contact_address_flag

INTEGER

 

 

country

country

INTEGER

ca_country id

 

county

county

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

 

 

Standort

site_id

INTEGER

ca_site id

 

state

state

INTEGER

ca_state_ province id

 

version_number

version_number

INTEGER

 

 

zip

zip

STRING