Previous Topic: kwrd ObjectNext Topic: LONG_TEXTS Object


loc Object

The object details are as follows:

Associated Table: ca_location

Factories: default

REL_ATTR: id

Common Name: name

Function Group: inventory

REST Operations: CREATE READ UPDATE

Attribute

DB Field

Data Type

SREL References

Flags

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

 

 

site

site_id

integer

ca_site id

 

state

state

integer

ca_state_ province id

 

version_number

version_number

integer

 

 

zip

zip

STRING