address_1

nvarchar(50)

This is address line 1.

address_2

nvarchar(50)

This is address line 2.

address_3

nvarchar(50)

This is address line 3.

address_4

nvarchar(50)

This is address line 4.

address_5

nvarchar(50)

This is address line 5.

address_6

nvarchar(50)

This is address line 6.

city

nvarchar(50)

Specifies the name of the city.

comment

nvarchar(255)

Shows the textual comment.

contact_address_
flag

INTEGER

Flag indicating that this ca_location record has been created only to specify address information for the contact given in the primary_contact_uuid field.

country

INTEGER

ca_country::id

Foreign key to the id field of the ca_country table representing the location's country.

county

nvarchar(50)

Identifies the name of the county.

creation_date

INTEGER

Shows the date of when this record was created.

creation_user

nvarchar(64)

Identifies the user or process that created the record.

delete_time

INTEGER

Identifies the time of the deletion.

exclude_registration

INTEGER

Indicates to exclude registration.

fax_number

nvarchar(40)

Identifies the fax number.

geo_coord_type

INTEGER

Foreign key to the id field of the ca_geo_coord_type table for geographic coordinates type (GPS).

geo_coords

nvarchar(40)

Identifies the geographic coordinates values (GPS).

id

INTEGER

Primary key of this table.

inactive

INTEGER

Active_Boolean_ Table::enum

Sets the Active flag, as follows:
0—False (Active)
1—True (Inactive)

last_update_date

INTEGER

Specifies the date the record was last updated.

last_update_user

nvarchar(64)

Identifies the user or process that last updated the record.

location_name

nvarchar(100)

Identifies the location name.

location_type_id

INTEGER

Foreign key to the id field of the ca_location_type table representing the location's type.

location_uuid

Byte(16)

This is a unique identifier, and is the Primary key.

mail_address_1

nvarchar(50)

Mailing address 1.

mail_address_2

nvarchar(50)

Mailing address 2.

mail_address_3

nvarchar(50)

Mailing address 3.

mail_address_4

nvarchar(50)

Mailing address 4.

mail_address_5

nvarchar(50)

Mailing address 5.

mail_address_6

nvarchar(50)

Mailing address 6.

parent_location_uuid

byte(16)

Foreign key to the location_uuid field of the ca_location table for the company's parent location.

pri_phone_number

nvarchar(40)

Identifies the private phone number.

primary_contact_uuid

byte(16)

Foreign key to the contact_uuid field of the ca_contact table representing the location's primary contact.

site_id

INTEGER

ca_site::id

Identifies the Site ID.

state

INTEGER

ca_state_province ::id

Primary key. Identifies the State or Province ID.

version_number

INTEGER

Version number for transaction integrity.

zip

nvarchar(20)

Identifies the ZIP code.