eWay-CRM Database Schema

⇧Table dbo.EWA_UnifiedRelations

Archive of deleted records from EWR_ObjectRelations.

Object ID: 2089058478; Created: May 18, 2008, 17:25:31; Modified: September 24, 2021, 20:10:27

Name	Type	NULL	Comment
ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
ItemGUID1	uniqueidentifier	☐	GUID of the first item.
ItemGUID2	uniqueidentifier	☐	GUID of the second item.
ObjectTypeID1	tinyint	☐	ObjectTypeID of the first item.
ObjectTypeID2	tinyint	☐	ObjectTypeID of the second item.
RelationDataGUID	uniqueidentifier	☐	Each pair of relations has common information saved here.
RelationType	varchar (30)	☐	Type of the relation, standard type relation is GENERAL.
Direction	int	☐	For one-to-many relations. Standard relation has Direction = 0, one-to-many is saved with 1 and 2.
DeletedDate	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())DateTime when the record was deleted.
◆ArchiveID	bigint	☐	IDENTITYPrimary key of the table.
RelationTypeID	smallint	☒	Relation type ID.

⇧Table dbo.EWD_Actions

WorkFlow actions

Object ID: 2137058649; Created: May 18, 2008, 17:25:31; Modified: December 18, 2022, 20:19:33

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
ObjectTypeID	tinyint	☒	⇨ dbo.EWE_ObjectTypes.ObjectTypeIDObjectTypeID of the module where the action is applied - for actions that are not part of a workflow.
Xml	nvarchar (max)	☒	XML definition of the action.
FileAs	nvarchar (256)	☒	Text description of the action.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
FlowGUID	uniqueidentifier	☒	⇨ dbo.EWF_Flows.ItemGUIDItem identificator of flow.
StatusGUID	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDUnique identifier of workflow status which triggers the action.
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_AdditionalFields

List of additional fields for customized modules

Object ID: 219147826; Created: May 18, 2008, 18:05:06; Modified: February 06, 2023, 20:18:36

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
ObjectTypeID	tinyint	☐	⇨ dbo.EWE_ObjectTypes.ObjectTypeIDObjectTypeID of the module where the additional field will be used.
FieldID	smallint	☐	IDENTITYField number - increased automatically.
Name	nvarchar (256)	☐	Name of the field.
Type	tinyint	☐	0: TextBox, 1: ComboBox, 2: NumericBox, 3: Relation, 4: CheckBox, 5: LinkTextBox, 6: DateEdit, 7: MemoBox, 8: MultiSelectComboBox.
Comment	nvarchar (255)	☒	Tooltip of the field.
Data	nvarchar (max)	☒	Data specific for each type of the field.
ModifiedByGUID	uniqueidentifier	☒	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
CreatedByGUID	uniqueidentifier	☒	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
FileAs	nvarchar (256)	☒	Text description of the record.
Rank	int	☒	Position of item in the list.
Category	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of item category in EnumValues.
GeneralSection	bit	☐	DEFAULT ((1))Indicates whether the field will be displayed in the General Additional Fields section.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Server_ID	smallint	☐	COMPUTEDAlias for the FieldID column.

⇧Table dbo.EWD_AuthClients

Table with OAuth clients.

Object ID: 256329019; Created: September 03, 2020, 20:39:25; Modified: October 05, 2020, 12:08:08

Name	Type	NULL	Comment
◆ID	int	☐	IDENTITYIdentifier of the record.
Enabled	bit	☐	Specifies if client is enabled.
ClientID	nvarchar (200)	☐	Unique ID of the client.
ClientName	nvarchar (200)	☐	Client display name.
ClientSecret	nvarchar (250)	☒	Client secret.
Flow	int	☐	Specifies allowed flow for client (either AuthorizationCode = 0, Implicit = 1, Hybrid = 2, ClientCredentials = 3, ResourceOwner = 4, AuthorizationCodeWithProofKey = 6, HybridWithProofKey = 7).
AccessTokenLifetime	int	☐	Lifetime of access token in seconds (defaults to 300 seconds / 5 minutes).
AuthorizationCodeLifetime	int	☐	Lifetime of authorization code in seconds (defaults to 300 seconds / 5 minutes).
AbsoluteRefreshTokenLifetime	int	☐	Maximum lifetime of a refresh token in seconds. Defaults to 2592000 seconds / 30 days.
SlidingRefreshTokenLifetime	int	☐	Sliding lifetime of a refresh token in seconds. Defaults to 1296000 seconds / 15 days.
RefreshTokenUsage	int	☐	ReUse = 0 (when refreshing the token, the lifetime of the refresh token will be renewed) or OneTime = 1 (the refresh token handle will be updated when refreshing tokens).
RefreshTokenExpiration	int	☐	Sliding = 0 or Absolute = 1 (the refresh token will expire on a fixed point in time).
AccessTokenType	int	☐	Jwt = 0 or Reference = 1.
RedirectUri	nvarchar (2000)	☐	Redirect URI allowed for the client.

⇧Table dbo.EWD_AuthConsents

Object ID: 1141136102; Created: May 28, 2020, 20:34:27

Name	Type	NULL	Comment
◆SubjectID	uniqueidentifier	☐
◆ClientID	nvarchar (200)	☐
Scopes	nvarchar (2000)	☐

⇧Table dbo.EWD_AuthTokens

Table with authorization tokens.

Object ID: 1545993530; Created: May 06, 2020, 21:50:05; Modified: May 25, 2021, 10:02:27

Name	Type	NULL	Comment
◆Key	nvarchar (128)	☐
◆TokenType	smallint	☐
SubjectID	uniqueidentifier	☒
ClientID	nvarchar (200)	☐
JsonCode	nvarchar (max)	☐
Expiry	datetimeoffset	☐	Date and time of expiration.

⇧Table dbo.EWD_BinaryData

Table of binary saved documents and e-mails. Connect to EWD_Documents or EWD_Emails with common ItemGUID.

Object ID: 53575229; Created: May 18, 2008, 17:25:31; Modified: November 21, 2022, 20:30:56

Name	Type	NULL	Comment
ItemGUID	uniqueidentifier	☐	Identifier of the database record.
Revision	int	☐	Revision of the document - zero based.
Data	image	☒	Binary stored data of the file.
Extension	nvarchar (10)	☒	Extension of the file.
FileSize	bigint	☒	Size of the file.
UploadedSize	bigint	☒	Uploaded size of the file.
IsCompressed	bit	☐	DEFAULT ((0))Determines whether file is compressed.
CompressedSize	bigint	☒	Size of compressed record.
◆ID	int	☐	IDENTITYIdentifier of record.
StoredInFileSystem	bit	☐	DEFAULT ((0))Determines whether record is stored in File System.
Created	datetimeoffset	☐	Date when the record was created in the database.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
FileSystemStorageRelativePath	char (7)	☒	Relative path to where is file stored on file system.

⇧Table dbo.EWD_Bonuses

Bonuses for users

Object ID: 69575286; Created: May 18, 2008, 17:25:31; Modified: December 18, 2022, 20:19:32

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
FileAs	nvarchar (256)	☒	Text description of the record.
Price	decimal (18, 2)	☒	Requested amount.
StateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDStatus of the record.
Note	nvarchar (max)	☒	Additional text information.
PrevStateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDPrevious status of the record.
PriceDefaultCurrency	decimal (18, 2)	☒	Price in default currency.
PriceParentCurrency	decimal (18, 2)	☒	Price in currency of the parent object.
CurrencyEn	uniqueidentifier	☐	DEFAULT ('8D70FEA5-8370-4923-97F5-8667707B4802')⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of currency from EnumValues.
PriceChanged	date	☐	Date when the price of bonus was changed last time.
Private	bit	☐	DEFAULT ((0))Determines whether the record of bonus is private. Default is no.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Picture	varbinary (max)	☒
PictureWidth	smallint	☐	DEFAULT ((0))
PictureHeight	smallint	☐	DEFAULT ((0))
TypeEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUID
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_Calendar

Object ID: 1120723045; Created: September 11, 2009, 16:50:38; Modified: December 18, 2022, 20:19:33

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
FileAs	nvarchar (256)	☒	Text description of the record.
Location	nvarchar (256)	☒	Location of the appointment.
StartDate	smalldatetime	☒	Start date.
EndDate	smalldatetime	☒	End date.
AllDayEvent	bit	☒	Determines whether the appointment is all day event.
Note	nvarchar (max)	☒	Additional text information.
BusyStatus	int	☒	Status of appointment item: Free, Tentative. Busy, OutOfOffice, WorkingElsewhere.
Private	bit	☐	DEFAULT ((0))Determines whether the appointment item is private. Default is no.
Sensitivity	int	☐	DEFAULT ((0))Level of importance: High, Low, Normal.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_CapacityNotes

Object ID: 101575400; Created: May 18, 2008, 17:25:31; Modified: December 18, 2022, 20:19:32

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☒	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
Title	nvarchar (256)	☒	Title.
Body	nvarchar (256)	☒	Additional text info.
IconIndex	int	☒	Icon index.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
CreatedByGUID	uniqueidentifier	☒	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☒	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_CapacityNoteTypes

Object ID: 117575457; Created: May 18, 2008, 17:25:31; Modified: December 18, 2022, 20:19:32

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☒	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
Index	int	☒	Index.
NameEN	nvarchar (50)	☒	Name identifier.
DescriptionEN	nvarchar (255)	☒	Description identifier.
PictureBase64	text	☒	Associated picture encoded in base64.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
CreatedByGUID	uniqueidentifier	☒	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☒	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_Carts

Object ID: 1641772906; Created: January 18, 2011, 16:33:09; Modified: December 18, 2022, 20:19:33

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
FileAs	nvarchar (256)	☒	Text description of the record.
ID	int	☒	ID of record.
EffectiveFrom	date	☒	Date from that the item is effective.
ValidUntil	date	☒	Date until that the item is valid.
Active	bit	☒	DEFAULT ((0))Determines whether the item is active.
TypeEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDType of the record.
PriceTotal	decimal (18, 3)	☒	Total price.
Paid	decimal (18, 3)	☒	Paid amount.
ForPayment	decimal (18, 3)	☒	Amount for payment.
CurrencyEn	uniqueidentifier	☐	DEFAULT ('8D70FEA5-8370-4923-97F5-8667707B4802')⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of currency from EnumValues.
VAT	decimal (18, 3)	☒	VAT amount.
PriceTotalExcludingVAT	decimal (18, 3)	☒	Total price without VAT amount.
GoodsInCartCount	int	☒	Number of goods in cart.
Note	nvarchar (max)	☒	Additional text information.
PriceTotalDefaultCurrency	decimal (18, 3)	☒	Total price in default currency.
PriceTotalParentCurrency	decimal (18, 3)	☒	Total price in currency of the parent object.
ForPaymentDefaultCurrency	decimal (18, 3)	☒	Amount for payment in default currency.
ForPaymentParentCurrency	decimal (18, 3)	☒	Amount for payment in currency of the parent object.
PaidDefaultCurrency	decimal (18, 3)	☒	Paid amount in default currency.
PaidParentCurrency	decimal (18, 3)	☒	Paid amount in currency of the parent object.
PaidChanged	date	☐	Date of latest change of paid amount.
PriceTotalChanged	date	☐	Date of latest change of total price.
PriceTotalExcludingVATDefaultCurrency	decimal (18, 3)	☒	PriceTotalExcludingVAT in default currency.
PriceTotalExcludingVATParentCurrency	decimal (18, 3)	☒	PriceTotalExcludingVAT in currency of the parent object.
VATDefaultCurrency	decimal (18, 3)	☒	VAT amount in default currency.
VATParentCurrency	decimal (18, 3)	☒	VAT amount in currency of the parent object.
StateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDStatus of the record.
PrevStateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDPrevious status of the record.
TaxableSupplyDate	date	☒	VAT tax date.
Server_MoneyS3InvoiceNumber	nvarchar (64)	☒	Invoice number in MoneyS3.
Server_MoneyS3InvoiceNumberUniqueHelper	uniqueidentifier	☒	COMPUTEDSubstitute unique identifier, when Server_MoneyS3GUID is null.
Private	bit	☐	DEFAULT ((0))Determines whether the item is private. Default is no.
AccountingCaseDate	date	☒	Date of accounting transaction.
PaymentDate	date	☒	Day of payment.
Server_PohodaDataSourceType	bit	☐	DEFAULT ((0))Specifies Pohoda data source. 0 = FA, 1 = OBJ.
PurchaseExpenses	decimal (18, 3)	☐	DEFAULT ((0))Purchase expenses.
PurchaseExpensesDefaultCurrency	decimal (18, 3)	☒	Purchase expenses in default currency.
PurchaseExpensesParentCurrency	decimal (18, 3)	☒	Purchase expenses in currency of the parent object.
PurchaseExpensesChanged	date	☐	Date of last change of purchase expenses.
Profit	decimal (18, 3)	☐	DEFAULT ((0))Total price excluding VAT lowered by purchase expenses.
ProfitDefaultCurrency	decimal (18, 3)	☒	Total price excluding VAT lowered by purchase expenses in default currency.
ProfitParentCurrency	decimal (18, 3)	☒	Total price excluding VAT lowered by purchase expenses in currency of the parent object.
ProfitChanged	date	☐	Date of last change of profit.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Server_MoneyS3SourceIdentifier	nvarchar (256)	☒
Picture	varbinary (max)	☒
PictureWidth	smallint	☐	DEFAULT ((0))
PictureHeight	smallint	☐	DEFAULT ((0))
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_Companies

Companies list

Object ID: 149575571; Created: May 18, 2008, 17:25:31; Modified: February 06, 2023, 20:18:36

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
Note	nvarchar (max)	☒	Additional text information.
Reversal	decimal (18, 2)	☒	Turnover.
CompanyName	nvarchar (256)	☒	Name of the company.
Department	nvarchar (256)	☒	Department of the company.
AccountNumber	nvarchar (256)	☒	Account number.
EmployeesCount	int	☒	Number of employees.
VatNumber	nvarchar (256)	☒	VAT number.
Address1Street	nvarchar (256)	☒	Billing address street.
Address1City	nvarchar (256)	☒	Billing address city.
Address1State	nvarchar (256)	☒	Billings address state.
Address1Country	nvarchar (256)	☒	Billings address country.
Address1PostalCode	nvarchar (256)	☒	Billing address ZIP.
Address2Street	nvarchar (256)	☒	Physical address street.
Address2City	nvarchar (256)	☒	Physical address city.
Address2State	nvarchar (256)	☒	Physical address state.
Address2Country	nvarchar (256)	☒	Physical address country.
Address2PostalCode	nvarchar (256)	☒	Physical address ZIP.
Address3Street	nvarchar (256)	☒	Other address street.
Address3City	nvarchar (256)	☒	Other address city.
Address3State	nvarchar (256)	☒	Other address state.
Address3Country	nvarchar (256)	☒	Other address country.
Address3PostalCode	nvarchar (256)	☒	Other addresses ZIP.
ImportanceEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDImportance of the company.
FirstContactEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDFirst contact.
FileAs	nvarchar (256)	☒	Text description of the record.
Purchaser	bit	☒	Indicates whether the company is our customer.
Suppliers	bit	☒	Indicates whether the company is our vendor.
IdentificationNumber	nvarchar (256)	☒	Identification number.
Email	nvarchar (256)	☒	Email address.
Phone	nvarchar (256)	☒	Business phone.
ICQ	nvarchar (256)	☒	ICQ nickname.
Fax	nvarchar (256)	☒	Fax number.
Skype	nvarchar (256)	☒	Skype name.
Address2POBox	nvarchar (256)	☒	Physical address PO Box.
Address1POBox	nvarchar (256)	☒	Billing address PO Box.
Address3POBox	nvarchar (256)	☒	Other address PO Box.
WebPage	nvarchar (256)	☒	Homepage of the company.
MSN	nvarchar (256)	☒	MSN contact.
LineOfBusiness	nvarchar (256)	☒	Industry of the company.
MailingListEmail	bit	☒	Determines whether the company wants to be get marketing info by e-mail.
MailingListOther	bit	☒	Determines whether the company wants to get marketing info in another way.
MailingListOtherValue	nvarchar (256)	☒	Determines how the company wants to get marketing info.
Mobile	nvarchar (256)	☒	Mobile phone number.
af_17	nvarchar (255)	☒
SalePriceGUID	uniqueidentifier	☒	⇨ dbo.EWD_SalePrices.ItemGUIDIdentifier of sale price.
AdditionalDiscount	decimal (18, 4)	☒	DEFAULT ((0))Global discount in percents.
ID	bigint	☐	IDENTITYNumeric identifier of company.
Server_MoneyS3GUID	uniqueidentifier	☒	Unique identifier of item from system MoneyS3.
Server_MoneyS3GUIDUniqueHelper	uniqueidentifier	☒	COMPUTEDSubstitute unique identifier, when Server_MoneyS3GUID is null.
Address1CountryEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of the country in billing address.
Address2CountryEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of the country in physical address.
Address3CountryEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of the country in other address.
Private	bit	☐	DEFAULT ((0))Determines whether the item is private. Default is no.
Competitor	bit	☒	Determines whether the company is competitor.
PhoneNormalized	varchar (256)	☒	Normalized business phone number.
MobileNormalized	varchar (256)	☒	Normalized mobile number.
LastActivity	date	☒	Date of the last activity.
NextStep	date	☒	Date of the next step.
EmailOptOut	bit	☐	DEFAULT ((0))Value indicating whether the company wants be excluded from marketing lists.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
TypeEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDCompany type identificator.
Server_MoneyS3SourceIdentifier	nvarchar (256)	☒
Picture	varbinary (max)	☒
PictureWidth	smallint	☐	DEFAULT ((0))
PictureHeight	smallint	☐	DEFAULT ((0))
StateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUID
PrevStateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUID
Server_ID	bigint	☐	COMPUTEDAlias for the ID column.

⇧Table dbo.EWD_Contacts

List of contacts

Object ID: 165575628; Created: May 18, 2008, 17:25:31; Modified: December 18, 2022, 20:19:32

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
BusinessAddressCity	nvarchar (256)	☒	City of the business address.
BusinessAddressCountry	nvarchar (256)	☒	Country of the business address.
BusinessAddressPostalCode	nvarchar (256)	☒	ZIP of the business address.
BusinessAddressState	nvarchar (256)	☒	State of the business address.
BusinessAddressStreet	nvarchar (256)	☒	Street of the business address.
Email1Address	nvarchar (256)	☒	First email address.
LastName	nvarchar (256)	☒	Contact last name.
FirstName	nvarchar (256)	☒	Contact first name.
HomeAddressCity	nvarchar (256)	☒	City of the home address.
HomeAddressCountry	nvarchar (256)	☒	Country of the home address.
HomeAddressPostalCode	nvarchar (256)	☒	Postal code of the home address.
HomeAddressState	nvarchar (256)	☒	State of the home address.
HomeAddressStreet	nvarchar (256)	☒	Street of the home address.
MiddleName	nvarchar (256)	☒	Contact middle name.
Note	nvarchar (max)	☒	Additional text information.
OtherAddressCity	nvarchar (256)	☒	City of the other address.
OtherAddressCountry	nvarchar (256)	☒	Country of the other address.
OtherAddressPostalCode	nvarchar (256)	☒	Postal code of the other address.
OtherAddressState	nvarchar (256)	☒	State of the other address.
OtherAddressStreet	nvarchar (256)	☒	Street of the other address.
Title	nvarchar (256)	☒	Job title.
WebPage	nvarchar (256)	☒	Web page.
FileAs	nvarchar (1280)	☒	Text description of the record.
Email3Address	nvarchar (256)	☒	Second email address.
Email2Address	nvarchar (256)	☒	Third email address.
ImportanceEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDImportance.
TelephoneNumber1	nvarchar (256)	☒	Business phone.
TelephoneNumber2	nvarchar (256)	☒	Home phone.
TelephoneNumber4	nvarchar (256)	☒	Other phone number.
TelephoneNumber3	nvarchar (256)	☒	Mobile phone.
OtherAddressPOBox	nvarchar (256)	☒	PO Box of the other address.
Prefix	nvarchar (256)	☒	Title.
BusinessAddressPOBox	nvarchar (256)	☒	PO Box of the business address.
Suffix	nvarchar (256)	☒	Suffix.
MSN	nvarchar (256)	☒	MSN contact.
ICQ	nvarchar (256)	☒	ICQ nickanme.
Skype	nvarchar (256)	☒	Skype name.
HomeAddressPOBox	nvarchar (256)	☒	PO Box of the home address.
PrefixEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of the prefix.
SuffixEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of the suffix.
TelephoneNumber5	nvarchar (256)	☒	Second business phone.
TelephoneNumber6	nvarchar (256)	☒	Business fax.
Department	nvarchar (256)	☒	Department.
BusinessAddressCountryEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of the country of the business address.
HomeAddressCountryEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of the country of the home address.
OtherAddressCountryEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of the country of the other address.
Private	bit	☐	DEFAULT ((0))Determines whether the item is private. Default is no.
TelephoneNumber1Normalized	varchar (256)	☒	Normalized business phone.
TelephoneNumber2Normalized	varchar (256)	☒	Normalized home phone.
TelephoneNumber3Normalized	varchar (256)	☒	Normalized other phone number.
TelephoneNumber4Normalized	varchar (256)	☒	Normalized mobile phone.
TelephoneNumber5Normalized	varchar (256)	☒	Normalized second business phone.
TelephoneNumber6Normalized	varchar (256)	☒	Normalized business fax.
DoNotSendNewsletter	bit	☐	DEFAULT ((0))Do not send newsletter to the contact.
ProfilePicture	varbinary (max)	☒	Profile picture of the contact.
ProfilePictureWidth	int	☐	DEFAULT ((0))Width of the profile picture.
ProfilePictureHeight	int	☐	DEFAULT ((0))Height of the profile picture.
LastActivity	date	☒	Date of a last activity.
NextStep	date	☒	Date of the next step.
Company	nvarchar (256)	☒	Name of company.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
TypeEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDCompany type identificator.
StateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUID
PrevStateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUID
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_CurrencyExchangeRates

Object ID: 1997354280; Created: February 03, 2014, 21:07:17; Modified: January 09, 2023, 20:36:53

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
InputCurrencyEn	uniqueidentifier	☐	DEFAULT ('8D70FEA5-8370-4923-97F5-8667707B4802')⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of the input currency.
OutputCurrencyEn	uniqueidentifier	☐	DEFAULT ('8D70FEA5-8370-4923-97F5-8667707B4802')⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of the output currency.
Rate	decimal (18, 3)	☒	Rate from input currency to output currency.
From	smalldatetime	☒	Rate is valid from this date.
To	smalldatetime	☒	Rate is valid to this date.
Valid	bit	☐	If the rate is valid today.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_Documents

List of saved documents, connected to EWD_BinaryData with common ItemGUID

Object ID: 1924201905; Created: August 08, 2008, 18:09:14; Modified: December 18, 2022, 20:19:33

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
FileAs	nvarchar (128)	☒	Text description of the record.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
DocName	nvarchar (118)	☒	Name of the document without extension.
Extension	nvarchar (9)	☒	Extension of the document without dot.
CreationTime	datetime	☒	Time when the document has been created.
LastWriteTime	datetime	☒	Time when the document has been changed.
DocSize	bigint	☐	Size of the document in bytes.
ImportanceEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDImportance.
DocTypeEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDType of the document.
Note	nvarchar (max)	☒	Additional text information.
StateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDStatus of the record.
PrevStateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDPrevious status of the record.
af_13	decimal (18, 3)	☒
Private	bit	☐	DEFAULT ((0))Determines whether the item is private. Default is no.
Preview	varbinary (max)	☒	Binary image preview of the document.
PreviewWidth	int	☐	DEFAULT ((0))Image width of the preview.
PreviewHeight	int	☐	DEFAULT ((0))Image height of the preview.
GDPR	bit	☐	DEFAULT ((0))Value indicating whether is record GDPR relevant.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_Emails

List of saved e-mails, connected to EWD_BinaryData with common ItemGUID

Object ID: 197575742; Created: May 18, 2008, 17:25:31; Modified: August 18, 2024, 21:32:57

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
FileAs	nvarchar (256)	☒	Text description of the record.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
Subject	nvarchar (256)	☒	Subject.
SenderEmailAddress	nvarchar (256)	☒	Email address of the sender.
SentOn	datetime	☒	Time when the email was sent.
ReceivedTime	datetime	☒	Time when the email was received.
AttachmentsCount	int	☐	Number of attachments.
To	nvarchar (max)	☒	Recipients addresses.
Cc	nvarchar (max)	☒	Addresses of users in carbon copy.
Note	nvarchar (max)	☒	Additional text information.
ImportanceEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDImportance.
Checksum	int	☒	Computed hash value. Not used anymore.
MessageId	varchar (256)	☒	Message identifier.
Hash	char (32)	☒	Specifies the hash code calculated from Subject, SenderEmailAddress, To and SentOn.
ConversationIndex	varchar (896)	☒	String that indicates the relative position of the item within the conversation thread, comming from Outlook.
Private	bit	☐	DEFAULT ((0))Determines whether the item is private. Default is no.
EmailFileExtension	nvarchar (9)	☐	DEFAULT ('.msg')Required extension of the saved email file. It should be same as the extension in corresponding BinaryData record.
SentMailGUID	uniqueidentifier	☐	DEFAULT (newid())Unique identifier of the e-mail sent inside Exchange.
GDPR	bit	☐	DEFAULT ((0))Value indicating whether is record GDPR relevant.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
FileSize	bigint	☐	Size of the email in bytes.
Picture	varbinary (max)	☒
PictureWidth	smallint	☐	DEFAULT ((0))
PictureHeight	smallint	☐	DEFAULT ((0))
TypeEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUID
StateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUID
PrevStateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUID
Server_ID	bigint	☐	IDENTITYSortable unique identifier.
Summary	nvarchar (256)	☒	Human language written summary of the whole email message. Primarily filled by AI.
SentimentTone	tinyint	☒	Rank-based enum value of the overall sentiment or tone of the email message. Matches values from the enum type 'SentimentTone'. Primarily filled by AI.
Server_LlamaAiFillingState	bit	☒	Column indicating whether the AI fields filling has already been processed on this email. NULL - AI did not see this email, 0 - AI was processed, but was not able to read the email OR the email is from pre-AI era OR AI was disabled by license/GS, 1 - AI was processed and has filled something.

⇧Table dbo.EWD_EnumTypes

Enumerators names, connected with ItemGUID to EWD_EnumValues.EnumType

Object ID: 229575856; Created: May 18, 2008, 17:25:31; Modified: December 18, 2022, 20:19:33

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
EnumName	nvarchar (50)	☐	Name of the enumeration.
System	bit	☐	DEFAULT ((1))Indicates whether the record is a system record.
FileAs	nvarchar (256)	☒	Text description of the record.
AllowEditVisibility	bit	☐	DEFAULT ((0))Allows users to edit visibility of the enumeration values.
AllowEditLastActivity	bit	☐	DEFAULT ((0))Indicates whether a user is able to edit if an enum value is included in the last activity calculation.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
RequireDefaultValue	bit	☐	DEFAULT ((0))Value indicating whether is enumeration default value required.
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_EnumValues

List of values of specified enumerator - connected with EnumType to EWD_EnumTypes.ItemGUID

Object ID: 245575913; Created: May 18, 2008, 17:25:31; Modified: June 05, 2023, 20:28:25

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
FileAs	nvarchar (256)	☐	Text description of the record.
EnumType	uniqueidentifier	☐	⇨ dbo.EWD_EnumTypes.ItemGUIDIdentifier of the enumeration.
Rank	int	☐	DEFAULT ((1))Position of item in the list.
en	nvarchar (256)	☐	Translation to English.
cs	nvarchar (256)	☐	DEFAULT ('N/A')Translation to Czech.
IsSystem	bit	☐	DEFAULT ((0))Indicates whether the record is a system record.
Visible	bit	☐	DEFAULT ((1))Allows item to be visible in the application.
de	nvarchar (256)	☐	DEFAULT ('N/A')Translation to German.
ru	nvarchar (256)	☐	DEFAULT ('N/A')Translation to Russian.
sk	nvarchar (256)	☐	DEFAULT ('N/A')Translation to Slovak.
no	nvarchar (256)	☐	DEFAULT ('N/A')Translation to Norwegian.
IncludeInLastActivityCalculation	bit	☐	DEFAULT ((0))Indicates whether an enum value is included in last activity calculation.
Default	bit	☐	DEFAULT ((0))Value indicating whether is value default value for EnumerationType.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Server_ID	bigint	☐	IDENTITYSortable unique identifier.
IsCompletedState	bit	☒	Indicates whether the enum value represents a completed state.
IsLostState	bit	☒	Indicates whether the enum value represents a lost state.

⇧Table dbo.EWD_Features

Object ID: 1264580139; Created: July 03, 2017, 22:41:11; Modified: January 09, 2023, 20:36:53

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Id of the specific record.
ItemVersion	int	☐	DEFAULT ((1))Version number, increased after each record change.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date when the record was created on the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date when the record was changed for the last time on the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date when the record was created on the server database.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date when the record was changed for the last time on the server database.
FileAs	nvarchar (256)	☒	Feature name.
Active	bit	☐	DEFAULT ((0))Value determines whether the feature is active.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_GlobalSettings

Object ID: 1108198998; Created: July 31, 2008, 12:59:44; Modified: December 18, 2022, 20:19:33

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
Name	nvarchar (256)	☐	Name of the global setting.
Value	nvarchar (max)	☒	Value of the global setting.
Category	uniqueidentifier	☐	⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of category.
Visible	bit	☐	DEFAULT ((1))Allows item to be visible in the administration interface.
Type	tinyint	☐	DEFAULT ((0))0: String, 1: Bit, 2: Integer, 3: Float, 4: MultiString, 5: ComboBox, 6: CheckedComboBox, 7: GroupsCheckedComboBox, 8: LastActivityCheckedComboBox, 9: TimeInterval.
AvailableValues	nvarchar (max)	☒	List of available values in format '{key1=value1}{key2=value2}'. Works only with ComboBox and CheckedComboBox.
en	nvarchar (256)	☒	English translation.
cs	nvarchar (256)	☒	Czech translation.
de	nvarchar (256)	☒	German translation.
ru	nvarchar (256)	☒	Russian translation.
sk	nvarchar (256)	☒	Slovak translation.
no	nvarchar (256)	☒	Norwegian translation.
MinValue	int	☒	Value indicating minimum value of numeric settings which will be required by validation process.
MaxValue	int	☒	Value indicating maximum value of numeric settings which will be required by validation process.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
IsLegacy	bit	☐	DEFAULT ((0))Settings marked as legacy will be removed in future.
FeatureGUID	uniqueidentifier	☒	⇨ dbo.EWD_Features.ItemGUIDIdentifier of the related feature.
Rank	int	☒	Position of item in the list.
KbUrlShortCode	nchar (5)	☒	Short code for the KB help link.
DependsOn	nvarchar (256)	☒	⇨ dbo.EWD_GlobalSettings.NameName of the GS that needs to be "active" to make this GS visible.
DependsOnValue	nvarchar (max)	☒	Value that needs to be in the dependand GS.
UnlimitedValue	nvarchar (max)	☒	Value indicating that the GS in unlimited.
DisabledValue	nvarchar (max)	☒	Value indicating that the GS is disabled.
DependsOnValueInverted	bit	☒	When the value is 1 the GS will be "visible" when the value of dependand GS does not equal DependsOnValue value.
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_Goals

Object ID: 192980014; Created: December 10, 2014, 15:07:52; Modified: January 09, 2023, 20:36:53

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
FileAs	nvarchar (256)	☒	Text description of the record.
GoalTypeEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of goal’s type item in EnumValues.
Note	nvarchar (max)	☒	Additional text information.
StartDate	date	☒	Star date of the goal.
EndDate	date	☒	End date of the goal.
TurnoverGoal	decimal (18, 2)	☒	Revenue goal.
TurnoverActual	decimal (18, 2)	☒	Actual revenue of the goal.
TurnoverCompleted	decimal (18, 4)	☒	Percent completed from the revenue goal.
ProfitGoal	decimal (18, 2)	☒	Profit goal.
ProfitActual	decimal (18, 2)	☒	Actual profit of the goal.
ProfitCompleted	decimal (18, 4)	☒	Percent completed from the profit goal.
CurrencyEn	uniqueidentifier	☐	DEFAULT ('8D70FEA5-8370-4923-97F5-8667707B4802')⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of the goal currency.
TurnoverGoalDefaultCurrency	decimal (18, 2)	☒	Revenue in default currency.
ProfitGoalDefaultCurrency	decimal (18, 2)	☒	Profit in default currency.
TurnoverGoalChanged	date	☐	Date when the revenue was changed last time.
ProfitGoalChanged	date	☐	Date when the profit was changed last time.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Picture	varbinary (max)	☒
PictureWidth	smallint	☐	DEFAULT ((0))
PictureHeight	smallint	☐	DEFAULT ((0))
StateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUID
PrevStateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUID
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_Goods

Object ID: 1689773077; Created: January 18, 2011, 16:33:10; Modified: January 11, 2023, 20:14:58

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
FileAs	nvarchar (256)	☐	Text description of the record.
Code	nvarchar (64)	☐	Code of the product.
SaleCurrencyEn	uniqueidentifier	☐	DEFAULT ('8D70FEA5-8370-4923-97F5-8667707B4802')⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of the sale currency.
PurchaseCurrencyEn	uniqueidentifier	☐	DEFAULT ('8D70FEA5-8370-4923-97F5-8667707B4802')⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of the purchase currency.
UnitEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of the unit.
PurchasePrice	decimal (18, 3)	☒	Purchase price.
SalePrice	decimal (18, 3)	☒	List price.
Note	nvarchar (max)	☒	Additional text information.
Structure	nvarchar (256)	☒	Warehouse location.
PriceListGroupGUID	uniqueidentifier	☒	⇨ dbo.EWD_PriceListGroups.ItemGUIDGuid of the price list group.
IsPriceSum	bit	☐	DEFAULT ((0))Indicates whether the price is sum of the sub-items.
Description	nvarchar (256)	☒	Additional description.
InventoryQuantity	decimal (18, 2)	☐	DEFAULT ((0))Quantity of the product in stock.
SalePriceDefaultCurrency	decimal (18, 3)	☒	List price in default currency.
SalePriceChanged	date	☐	Date when list price was changed last time.
Private	bit	☐	DEFAULT ((0))Determines whether the item is private. Default is no.
PurchasePriceDefaultCurrency	decimal (18, 3)	☒	Purchase price in default currency.
PurchasePriceChanged	date	☐	Date when purchase price was changed last time.
VATRate	decimal (5, 4)	☒	VAT rate in percent.
VATIncluded	bit	☐	DEFAULT ((0))Indicates whether VAT is included in the price.
Picture	varbinary (max)	☒	Product picture.
PictureWidth	int	☐	DEFAULT ((0))Width of the product picture.
PictureHeight	int	☐	DEFAULT ((0))Height of the product picture.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
TypeEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDProduct type identificator.
StateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUID
PrevStateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUID
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_GoodsInCart

Object ID: 1769773362; Created: January 18, 2011, 16:33:10; Modified: April 14, 2023, 09:03:02

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
FileAs	nvarchar (256)	☐	Text description of the record.
Code	nvarchar (64)	☐	Code of the product.
SaleCurrencyEn	uniqueidentifier	☐	DEFAULT ('8D70FEA5-8370-4923-97F5-8667707B4802')⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of the sale currency.
PurchaseCurrencyEn	uniqueidentifier	☐	DEFAULT ('8D70FEA5-8370-4923-97F5-8667707B4802')⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of the purchase currency.
UnitEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of the unit.
PurchasePrice	decimal (18, 3)	☒	Purchase price.
SalePrice	decimal (18, 3)	☒	Sale price.
Quantity	decimal (18, 3)	☒	Quantity.
Note	nvarchar (max)	☒	Additional text information.
PriceTotal	decimal (18, 3)	☒	Total price.
Structure	nvarchar (256)	☒	Warehouse locatio.
ListPrice	decimal (18, 3)	☒	List price.
Discount	decimal (18, 4)	☒	Discount in percent.
HierarchyInSet	nvarchar (68)	☐	Hierarchy in set: [PARENT_GOOD_CODE]\[CHILD_GOOD_CODE].
IsFromSet	bit	☒	DEFAULT ((0))Indicates whether the item is a set item.
ParentGUID	uniqueidentifier	☒	⇨ dbo.EWD_GoodsInCart.ItemGUIDGUID of the parent item.
Rank	int	☐	Position of the item in the list.
IsPriceSum	bit	☐	DEFAULT ((0))Indicates whether the price is sum of the sub-items.
IncludeInCartPrice	bit	☐	DEFAULT ((1))Indicates whether the price will be used to calculate total price of the cart.
ListPriceCustomized	bit	☐	DEFAULT ((0))Indicates whether the list price has been modified by the user.
Description	nvarchar (256)	☒	Additional description.
ChildItemsCount	int	☐	DEFAULT ((0))Number of child items.
VATRate	decimal (5, 4)	☒	Rate of VAT in percent.
PriceTotalExcludingVAT	decimal (18, 3)	☒	Total price without VAT amount.
VATTotal	decimal (18, 3)	☒	Total VAT amount.
SalePriceExcludingVAT	decimal (18, 3)	☒	Sale price without VAT amount.
VAT	decimal (18, 3)	☒	VAT amount.
PurchasePriceDefaultCurrency	decimal (18, 3)	☒	Purchase price in default currency.
PurchasePriceParentCurrency	decimal (18, 3)	☒	Purchase price in currency of the parent object.
PurchasePriceChanged	date	☐	Date when the purchase price was changed for the last time.
SalePriceDefaultCurrency	decimal (18, 3)	☒	Sale price in default currency.
SalePriceParentCurrency	decimal (18, 3)	☒	Sales price in currency of the parent object.
SalePriceChanged	date	☐	Date when the sale price of good was changed for the last time.
PriceTotalDefaultCurrency	decimal (18, 3)	☒	Total price in default currency.
PriceTotalParentCurrency	decimal (18, 3)	☒	Total price in currency of the parent object.
PriceTotalChanged	date	☐	Date when the total price of good was changed for the last time.
ListPriceDefaultCurrency	decimal (18, 3)	☒	List price in default currency.
ListPriceParentCurrency	decimal (18, 3)	☒	List price in currency of the parent object.
ListPriceChanged	date	☐	Date when the list price of good was changed last time.
PriceTotalExcludingVATDefaultCurrency	decimal (18, 3)	☒	Total price without VAT amount in default currency.
PriceTotalExcludingVATParentCurrency	decimal (18, 3)	☒	Total price without VAT amount in currency of the parent object.
VATTotalDefaultCurrency	decimal (18, 3)	☒	Total VAT amount in default currency.
VATTotalParentCurrency	decimal (18, 3)	☒	Total VAT amount in currency of the parent object.
SalePriceExcludingVATDefaultCurrency	decimal (18, 3)	☒	Sale price without VAT amount in default currency.
SalePriceExcludingVATParentCurrency	decimal (18, 3)	☒	Sale price without VAT amount in currency of the parent object.
VATDefaultCurrency	decimal (18, 3)	☒	VAT amount in default currency.
VATParentCurrency	decimal (18, 3)	☒	VAT amount in currency of the parent object.
Private	bit	☐	DEFAULT ((0))Determines whether the item is private. Default is no.
Server_PohodaDataSourceType	bit	☐	DEFAULT ((0))Specifies Pohoda data source. 0 = FA, 1 = OBJ.
JoinedToGUID	uniqueidentifier	☒	⇨ dbo.EWD_GoodsInCart.ItemGUIDGUID of the related item.
PurchasePriceTotal	decimal (18, 3)	☒	Total purchase price.
PurchasePriceTotalDefaultCurrency	decimal (18, 3)	☒	Total purchase price in default currency.
PurchasePriceTotalParentCurrency	decimal (18, 3)	☒	Total purchase price in currency of the parent object.
PurchasePriceTotalChanged	date	☐	Date when the total purchase price of good was changed for the last time.
VATIncluded	bit	☐	DEFAULT ((0))Indicates whether VAT is included in the ListPrice.
Picture	varbinary (max)	☒	Product picture.
PictureWidth	int	☐	DEFAULT ((0))Width of the product picture.
PictureHeight	int	☐	DEFAULT ((0))Height of the product picture.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
TypeEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDProduct type identificator.
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_GoodsInSet

Object ID: 1460916276; Created: November 26, 2012, 13:00:54; Modified: December 18, 2022, 20:19:33

Name	Type	NULL	Comment
ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
Server_PohodaId	int	☒	Unique identifier of this item in system Pohoda.
ParentGUID	uniqueidentifier	☐	⇨ dbo.EWD_Goods.ItemGUIDGUID of the parent product.
ChildGUID	uniqueidentifier	☐	⇨ dbo.EWD_Goods.ItemGUIDGUID of the child product.
Quantity	decimal (18, 2)	☒	Quantity.
Rank	int	☒	Position of the item.
Price	decimal (18, 3)	☒	Price of the product.
IsRegular	bit	☐	DEFAULT ((0))Indicates whether the item is a set or not.
Server_PohodaIdUniqueHelper	uniqueidentifier	☒	COMPUTEDSubstitute unique identifier, when the Server_PohodaId is null.
CurrencyEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of currency from EnumValues.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
IncludeInCart	bit	☐	DEFAULT ((1))Value indicating whether should be product into bookkeeping along with parent.
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_Groups

List of groups of users. Each group can have its own permissions

Object ID: 277576027; Created: May 18, 2008, 17:25:31; Modified: September 11, 2024, 21:28:15

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
ResponsibilityDescription	nvarchar (256)	☒	Description of the responsibility.
FileAs	nvarchar (256)	☐	Text description of the record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
IsAdmin	bit	☐	DEFAULT ((0))Indicates whether the group is Administrators group.
GroupName	nvarchar (256)	☐	Name of the group.
Description	nvarchar (max)	☒	Description.
IsPM	bit	☐	DEFAULT ((0))One group has to be marked as Project Managers - special unique relation (RelationType SUPERVISOR) between projects and users is created for each project.
System	bit	☐	DEFAULT ((0))System group cannot be deleted.
IsRole	bit	☐	DEFAULT ((0))Indicates that the group is a role.
IsCategory	bit	☐	DEFAULT ((0))Indicates that the group is category.
DisallowControlModulePermissions	bit	☐	DEFAULT ((0))Indicates that the user won't be able to change group's module permissions.
DisallowControlColumnPermissions	bit	☐	DEFAULT ((0))Indicates that the user won't be able to change group's column permissions.
IsOutlookCategory	bit	☐	DEFAULT ((0))Indicates that the group is Outlook category.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
DisallowControlUserAssignment	bit	☐	DEFAULT ((0))Indicates that the administrator won't be able to add or remove users from the group.
Picture	varbinary (max)	☒
PictureWidth	smallint	☐	DEFAULT ((0))
PictureHeight	smallint	☐	DEFAULT ((0))
Server_ID	bigint	☐	IDENTITYSortable unique identifier.
ColorEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDGroup Color.

⇧Table dbo.EWD_History

Object ID: 1817018200; Created: March 05, 2018, 21:11:38; Modified: March 03, 2024, 21:18:36

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Id of the specific record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date when the record was changed for the last time on the local database.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date when the record was changed for the last time on the server database.
ModifiedItemGUID	uniqueidentifier	☐	Identifier of changed item .
ObjectTypeID	tinyint	☐	⇨ dbo.EWE_ObjectTypes.ObjectTypeIDID of the module of changed item.
ColumnName	nvarchar (128)	☒	Name of column which value changed.
ClientID	bigint	☐	⇨ dbo.EWE_ClientVersions.ID
PrevValueGUID	uniqueidentifier	☒	Previous unique identifier value.
NewValueGUID	uniqueidentifier	☒	New unique identifier value.
PrevValueVarChar	nvarchar (256)	☒	Previous variable characters value.
NewValueVarChar	nvarchar (256)	☒	New variable characters value.
PrevValueVarCharMax	nvarchar (max)	☒	Previous variable characters value.
NewValueVarCharMax	nvarchar (max)	☒	New variable characters value.
PrevValueBit	bit	☒	Previous bit value.
NewValueBit	bit	☒	New bit value.
PrevValueInt	int	☒	Previous integer value.
NewValueInt	int	☒	New integer value.
PrevValueBigInt	bigint	☒
NewValueBigInt	bigint	☒
PrevValueDecimal	decimal (19, 4)	☒	Previous decimal value.
NewValueDecimal	decimal (19, 4)	☒	New decimal value.
PrevValueDateTime	datetime	☒	Previous date time value.
NewValueDateTime	datetime	☒	New date time value.
PrevValueVarBinary	varbinary (max)	☒	Previous binary value.
NewValueVarBinary	varbinary (max)	☒	New date binary value.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
SID	uniqueidentifier	☒	⇨ dbo.EWD_LoginHistory.ItemGUIDSession ID which was used by the client that made the change.
Server_ID	bigint	☐	IDENTITY

⇧Table dbo.EWD_Children

Users children

Object ID: 133575514; Created: May 18, 2008, 17:25:31; Modified: December 18, 2022, 20:19:32

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
LastName	nvarchar (256)	☒	Last name.
PersonalIdentificationNumber	nvarchar (256)	☒	Personal ID.
MiddleName	nvarchar (256)	☒	Middle name.
FirstName	nvarchar (256)	☒	First name.
Agreement	bit	☒	Agreement with personal information handling.
Prefix	nvarchar (256)	☒	Prefix.
Birthdate	date	☒	Brithdate.
Note	nvarchar (max)	☒	Additional text information.
FileAs	nvarchar (256)	☒	Text description of the record.
Suffix	nvarchar (256)	☒	Suffix.
PrefixEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of item prefix.
SuffixEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of item suffix.
Private	bit	☐	DEFAULT ((0))Determines whether the record is private. Default is no.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_IndividualDiscounts

Object ID: 1849773647; Created: January 18, 2011, 16:33:11; Modified: December 18, 2022, 20:19:33

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
Price	decimal (18, 3)	☒	Price amount.
Discount	decimal (18, 4)	☒	Discount in percent.
Companies_INDIVIDUALDISCOUNT	uniqueidentifier	☒	⇨ dbo.EWD_Companies.ItemGUIDGuid of the company.
Goods_INDIVIDUALDISCOUNT	uniqueidentifier	☒	⇨ dbo.EWD_Goods.ItemGUIDGuid of the product.
PriceListGroupGUID	uniqueidentifier	☒	⇨ dbo.EWD_PriceListGroups.ItemGUIDGuid of the price list group.
CurrencyEn	uniqueidentifier	☐	DEFAULT ('8D70FEA5-8370-4923-97F5-8667707B4802')⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of the currency.
PriceDefaultCurrency	decimal (18, 3)	☒	Price amount in default currency.
PriceChanged	date	☐	Date when the price of individual discount was changed for the last time.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_ItemChanges

Changes for synchronization - items in this table are synchronized automaticaly

Object ID: 231671873; Created: May 18, 2008, 18:17:44; Modified: September 19, 2023, 11:05:08

Name	Type	NULL	Comment
◆ChangeID	bigint	☐	IDENTITYIdentity column.
ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ObjectTypeID	tinyint	☐	⇨ dbo.EWE_ObjectTypes.ObjectTypeIDObjectTypeID of the changed record.
Removed	bit	☐	DEFAULT ((0))Indicates whether the record was removed or not.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
FileAs	nvarchar (1280)	☒	Text description of the record.
ModifiedByGUID	uniqueidentifier	☒	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemVersion	int	☐	Version number of the database record. Increments with each update.

⇧Table dbo.EWD_Journal

Calls, meetings, notes, events and changes related to projects

Object ID: 309576141; Created: May 18, 2008, 17:25:31; Modified: December 18, 2022, 20:19:33

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
Note	nvarchar (max)	☒	Additional text information.
EventStart	smalldatetime	☐	DEFAULT (getdate())Start time.
EventEnd	smalldatetime	☐	DEFAULT (getdate())End time.
TypeEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDType of the record.
ImportanceEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDImportance.
FileAs	nvarchar (256)	☒	Text description of the record.
System	bit	☒	DEFAULT ((0))System items cannot be changed by the user.
ChangedField	nvarchar (256)	☒	Name of the changed field.
FieldValue	nvarchar (256)	☒	New value.
PrevFieldValue	nvarchar (256)	☒	Old value.
Calendar_ORIGIN	uniqueidentifier	☒	⇨ dbo.EWD_Calendar.ItemGUIDGUID of the connected appointment item.
CalendarEntryID	varchar (140)	☒	Appointment EntryID from Outlook.
Private	bit	☐	DEFAULT ((0))Determines whether the item is private. Default is no.
EmailCampaignResponseType	tinyint	☒	Sent = 1, Delivered = 2, Viewed = 3, Logout = 4, NotDelivered = 5, LinkOpened = 6, MarkedAsSpam = 7.
Phone	nvarchar (256)	☒	Phone number of related phone call.
PhoneNormalized	varchar (256)	☒	Normalized phone number of related phone call.
GDPR	bit	☐	DEFAULT ((0))Value indicating whether is record GDPR relevant.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Picture	varbinary (max)	☒
PictureWidth	smallint	☐	DEFAULT ((0))
PictureHeight	smallint	☐	DEFAULT ((0))
StateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUID
PrevStateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUID
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_Knowledge

Users knowledges

Object ID: 325576198; Created: May 18, 2008, 17:25:31; Modified: December 18, 2022, 20:19:33

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
TitleEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDTitle identifier.
TypeEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDType of the record.
LevelEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDLevel identifier.
Note	nvarchar (max)	☒	Additional text information.
FileAs	nvarchar (256)	☒	Text description of the record.
Private	bit	☐	DEFAULT ((0))Determines whether the item is private. Default is no.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Picture	varbinary (max)	☒
PictureWidth	smallint	☐	DEFAULT ((0))
PictureHeight	smallint	☐	DEFAULT ((0))
StateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUID
PrevStateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUID
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_Layouts

Object ID: 1720861693; Created: October 19, 2016, 22:19:25; Modified: January 09, 2023, 20:36:53

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
FileAs	nvarchar (256)	☒	Text description of the record.
ObjectTypeID	tinyint	☐	⇨ dbo.EWE_ObjectTypes.ObjectTypeIDObjectTypeID of the module for which is layout designed.
Definition	nvarchar (max)	☐	Layout definition.
Default	bit	☐	DEFAULT ((0))Value determines whether layout is a default layout.
System	bit	☐	DEFAULT ((0))Value determines whether layout is a system layout and therefore not editable.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_LayoutsModels

Layout Models, for each item type must exist just one Layout definition

Object ID: 2012599004; Created: January 07, 2019, 21:01:25; Modified: March 03, 2024, 21:18:58

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
ObjectTypeID	tinyint	☐	⇨ dbo.EWE_ObjectTypes.ObjectTypeIDObjectTypeID of the module for which is layout designed.
LayoutGUID	uniqueidentifier	☐	⇨ dbo.EWD_Layouts.ItemGUIDIdentifier of the form layout definition.
ItemTypeGUID	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of the enum value which represents a type of the item.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Server_ID	bigint	☐	IDENTITYSortable unique identifier.
GroupGUID	uniqueidentifier	☒	⇨ dbo.EWD_Groups.ItemGUIDIf not null, the layout i assigned to this group. If user has this group set as the "default group", this layout overrides the layout by type or default layout. If this column is not null, ItemTypeGUID then must be null.

⇧Table dbo.EWD_Leads

Object ID: 1248723501; Created: September 11, 2009, 16:59:49; Modified: December 22, 2022, 20:35:54

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
FileAs	nvarchar (256)	☒	Text description of the record.
StateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDStatus of the record.
LeadOriginEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of the source.
ReceiveDate	date	☒	Date received.
Email	nvarchar (256)	☒	Email address.
Phone	nvarchar (256)	☒	Telephone number.
Note	nvarchar (max)	☒	Additional text information.
Customer	nvarchar (256)	☒	Name of company.
ContactPerson	nvarchar (256)	☒	Name of contact person.
HID	int	☒	Number identifier of the lead.
Probability	decimal (18, 4)	☒	Probability of the achievement.
Price	decimal (18, 2)	☒	Price of the lead.
EstimatedEnd	date	☒	Estimated end of the lead.
PrevStateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDPrevious status of the record.
Street	nvarchar (256)	☒	Street of contact address.
Zip	nvarchar (256)	☒	ZIP code of contact address.
City	nvarchar (256)	☒	City of contact address.
PriceDefaultCurrency	decimal (18, 2)	☒	Price of lead in default currency.
CurrencyEn	uniqueidentifier	☐	DEFAULT ('8D70FEA5-8370-4923-97F5-8667707B4802')⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of currency.
PriceChanged	date	☐	Date when the price of lead was changed for the last time.
Private	bit	☐	DEFAULT ((0))Determines whether the item is private. Default is no.
PhoneNormalized	varchar (256)	☒	Normalized telephone number.
TypeEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDType of the record.
LastActivity	date	☒	Date of a the last activity.
NextStep	date	☒	Date of the next step.
EstimatedValue	decimal (18, 3)	☒	Estimated value calculated from estimated revenue and probability.
EstimatedValueDefaultCurrency	decimal (18, 3)	☒	Estimated value in default currency.
EmailOptOut	bit	☐	DEFAULT ((0))Value indicating whether the lead should be excluded from marketing lists.
CountryEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDIdentifier of the country.
State	nvarchar (256)	☒	State name.
POBox	nvarchar (256)	☒	PO Box.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Picture	varbinary (max)	☒
PictureWidth	smallint	☐	DEFAULT ((0))
PictureHeight	smallint	☐	DEFAULT ((0))
Server_ID	bigint	☐	IDENTITYSortable unique identifier.
CompletedDate	date	☒	Date when lead was marked as completed.
LostDate	date	☒	Date when lead was marked as lost.

⇧Table dbo.EWD_LoginHistory

Object ID: 544720993; Created: August 28, 2008, 16:04:31; Modified: January 26, 2023, 20:17:43

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
Created	datetimeoffset	☐	Login time.
UserHostID	nvarchar (50)	☒	Client ID.
Successful	bit	☐	Indicates whether the login was successful.
UserHostAddress	varchar (45)	☒	IP host address of the remote client.
UserHostName	varchar (200)	☒	Name of the host.
UserGUID	uniqueidentifier	☐	Identifier of the user.
SID	uniqueidentifier	☒	Session GUID.
TimeZone	nvarchar (32)	☒	Time zone identifier.
IsFullSync	bit	☒	Indicates whether the client runs full sync.
ProxyAddress	varchar (45)	☒	Proxy address provided during login.
ClientID	bigint	☐	Client version ID.

⇧Table dbo.EWD_Mappings

Object ID: 1644949332; Created: November 20, 2015, 22:09:54; Modified: January 09, 2023, 20:36:53

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
SynchronizationType	tinyint	☐	Type of synchronization 3rd party software.
SynchronizationObjectName	nvarchar (256)	☐	Synchronization object name.
Field	nvarchar (256)	☐	Field in eWay-CRM described by [FolderName].[FieldName].
MappedField	nvarchar (256)	☐	3rd party software field description.
System	bit	☐	DEFAULT ((0))Default mapping which cannot be changed by user.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_Marketing

Object ID: 86291367; Created: March 16, 2011, 10:25:15; Modified: December 18, 2022, 20:19:32

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
FileAs	nvarchar (256)	☐	Text description of the record.
ID	int	☒	Number identifier of item.
TypeEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDType of the record.
StateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDStatus of the record.
PrevStateEn	uniqueidentifier	☒	⇨ dbo.EWD_EnumValues.ItemGUIDPrevious status of the record.
EstimatedStart	date	☒	Estimated start of the marketing campaign.
EstimatedEnd	date	☒	Estimated end of the marketing campaign.
Budget	decimal (18, 2)	☒	Budget of the marketing campaign.
EstimatedResponses	int	☒	Estimated amount of responses.
EstimatedRevenues	decimal (18, 2)	☒	Estimated revenues.
RealStart	date	☒	Real start of the marketing campaign.
RealEnd	date	☒	Real end of the marketing campaign.
Expenses	decimal (18, 2)	☒	Expenses of the marketing campaign.
FinalResponses	int	☒	Final amount of responses.
FinalRevenues	decimal (18, 2)	☒	Final revenues.
Note	nvarchar (max)	☒	Additional text information.
EmailCampaignHash	varchar (50)	☒	Email campaign has (emailkampane.cz).
EmailsSent	int	☒	Number of sent emails.
EmailsDelivered	int	☒	Number of delivered emails.
EmailsViewed	int	☒	Number of viewed emails.
PeopleUnsubscribed	int	☒	Number of unsubscribed people.
TargetGroup	int	☒	Target group.
Private	bit	☐	DEFAULT ((0))Determines whether the item is private. Default is no.
EmailCampaignContactListChanged	bit	☐	DEFAULT ((0))Date when the ContactList was changed during the last check.
EmailsMarkedAsSpam	int	☒	Count of emails marked as spam.
EmailCampaignEmailSent	datetime	☒	Date of email sent via Emailkampane.cz.
LastResponsesDownloadTime	datetime	☒	Date of last statistics download from emailkampane.cz.
ResponsesDownloadCount	int	☒	Emailkampane.cz statistics download counter.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Picture	varbinary (max)	☒
PictureWidth	smallint	☐	DEFAULT ((0))
PictureHeight	smallint	☐	DEFAULT ((0))
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_MarketingList

Object ID: 326292222; Created: March 16, 2011, 10:25:31; Modified: December 18, 2022, 20:19:33

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
Contact	nvarchar (256)	☒	Contact name.
Company	nvarchar (256)	☒	Company name.
Email1Address	nvarchar (256)	☒	Email address of contact.
Phone	nvarchar (256)	☒	Phone number of contact.
AddressPostalCode	nvarchar (256)	☒	Postal code of contact address.
AddressCity	nvarchar (256)	☒	City of the contact address.
AddressStreet	nvarchar (256)	☒	Street of the contact address.
MarketingGUID	uniqueidentifier	☒	⇨ dbo.EWD_Marketing.ItemGUIDGUID of connected marketing campaign item.
FolderName	nvarchar (50)	☒	⇨ dbo.EWE_ObjectTypes.FolderNameFolder name for source of the contact.
FirstName	nvarchar (256)	☒	First name of the contact.
LastName	nvarchar (256)	☒	Last name of the contact.
Private	bit	☐	DEFAULT ((0))Determines whether the item is private. Default is no.
LeadGUID	uniqueidentifier	☒	⇨ dbo.EWD_Leads.ItemGUIDGUID of the lead.
ContactGUID	uniqueidentifier	☒	⇨ dbo.EWD_Contacts.ItemGUIDGUID of the contact.
CompanyGUID	uniqueidentifier	☒	⇨ dbo.EWD_Companies.ItemGUIDGUID of the company.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Server_ID	bigint	☐	IDENTITYSortable unique identifier.

⇧Table dbo.EWD_MarketingListSources

Object ID: 422292564; Created: March 16, 2011, 10:25:38; Modified: December 18, 2022, 20:19:33

Name	Type	NULL	Comment
◆ItemGUID	uniqueidentifier	☐	Identifier of the database record.
ItemVersion	int	☐	DEFAULT ((1))Version number of the database record. Increments with each update.
OwnerGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDOwner of the database record.
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who created the record.
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDIdentifier of the user who updated the record for the last time.
ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been created in the local database.
ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record has been updated in the local database.
Server_ItemCreated	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was created on the server.
Server_ItemChanged	datetimeoffset	☐	DEFAULT (sysdatetimeoffset())Date and time when the record was updated on the server.
Definition	nvarchar (max)	☒	SQL script definition.
FileAs	nvarchar (256)	☒	Text description of the record.
en	nvarchar (256)	☐	DEFAULT ('N/A')English translation.
cs	nvarchar (256)	☐	DEFAULT ('N/A')Czech translation.
de	nvarchar (256)	☐	DEFAULT ('N/A')German translation.
ru	nvarchar (256)	☐	DEFAULT ('N/A')Russian translation.
System	bit	☐	DEFAULT ((0))Determines whether the item is system or not.
sk	nvarchar (256)	☐	DEFAULT ('N/A')Slovak translation.
no	nvarchar (256)	☐	DEFAULT ('N/A')Norwegian translation.
Active	bit	☐	DEFAULT ((1))Value indicating whether the marketing list source is active.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Server_ID	bigint	☐	IDENTITYSortable unique identifier.