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: 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.
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.

⇧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: 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.
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: June 05, 2023, 20:28:21

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.

⇧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: January 08, 2023, 20:39:17

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: January 09, 2023, 20:36: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.
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.

⇧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.

⇧Table dbo.EWD_ObjectTypesOptions

Object ID: 1755113989; Created: March 21, 2018, 12:49:26; 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.ItemGUIDFK: ItemGUID, EWD_Users - owner
CreatedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDFK: ItemGUID, EWD_Users - creator
ModifiedByGUID	uniqueidentifier	☐	⇨ dbo.EWD_Users.ItemGUIDFK: ItemGUID, EWD_Users - last changing user
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
ObjectTypeID	tinyint	☐	⇨ dbo.EWE_ObjectTypes.ObjectTypeID
TrackHistory	bit	☐	DEFAULT ((0))Value indicating whether item has activity history tracking enabled.
ItemState	tinyint	☐	COMPUTEDValue is alway zero. It is used for compatibility with local databases.
PrivateItemsEnabled	bit	☐	DEFAULT ((0))Value indicating whether Private items are enabled for the module.
Server_ID	bigint	☐	IDENTITYSortable unique identifier.