BaseTZLocation table - SuperOffice

BaseTZLocation Table (248)

Time zone location for the database (how tz-related datetimes should be stored in the database)

Fields

Name	Description	Type	Nullable
BaseTZLocation_id	Primary key	PK	No
TZLocation_id	Country that this timezone location is defined for	FK TZLocation	No
validFrom	When is this tzLocation valid from, as THE database timezonelocation	DateTime	No
databaseId	Actually travelcurrent.current_id, the id of the database this basetimezonelocation is meant for	Id	No
description	Descriptive text	String(254)	No
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No

Indexes

Fields	Types	Description

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
TZLocation	Time zone location

Replication Flags

Replicate changes DOWN from central to satellites and travellers.
Replicate changes UP from satellites and travellers back to central.
Copy to satellite and travel prototypes.

Security Flags

No access control via user’s Role.

Related topics

TZLocation table chat_topic table Get Base Time Zone Knowledge Base dictionary_base table attachment_location table

⌘I