eWay-CRM Database Schema

dbo.EWA_ObjectRelations

Archive of deleted records from EWR_ObjectRelations.

Object ID: 2089058478; Created: May 18, 2008, 17:25:31; Modified: May 20, 2016, 22:18: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.
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 nvarchar (256) 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 datetime DEFAULT (getdate())DateTime when the record was deleted.
ArchiveID bigint IDENTITYPrimary key of the table.

dbo.EWD_Actions

WorkFlow actions

Object ID: 2137058649; Created: May 18, 2008, 17:25:31; Modified: March 29, 2019, 20:43:16
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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.
Server_FlowGUIDUniqueHelper uniqueidentifier COMPUTED

dbo.EWD_AdditionalFields

List of additional fields for customized modules

Object ID: 219147826; Created: May 18, 2008, 18:05:06; Modified: April 06, 2018, 09:22:03
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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.

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: April 17, 2018, 20:18:25
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 datetime DEFAULT (getdate())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.

dbo.EWD_Bonuses

Bonuses for users

Object ID: 69575286; Created: May 18, 2008, 17:25:31; Modified: October 25, 2018, 21:01:55
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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 datetime 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.

dbo.EWD_Calendar

Object ID: 1120723045; Created: September 11, 2009, 16:50:38; Modified: July 10, 2019, 21:34:03
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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.

dbo.EWD_CapacityNotes

Object ID: 101575400; Created: May 18, 2008, 17:25:31; Modified: April 06, 2018, 09:22:03
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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.

dbo.EWD_CapacityNoteTypes

Object ID: 117575457; Created: May 18, 2008, 17:25:31; Modified: April 06, 2018, 09:22:03
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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.

dbo.EWD_Carts

Object ID: 1641772906; Created: January 18, 2011, 16:33:09; Modified: April 24, 2019, 13:38:28
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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 datetime Date from that the item is effective.
ValidUntil datetime 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 datetime Date of latest change of paid amount.
PriceTotalChanged datetime 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 datetime 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 datetime Date of accounting transaction.
PaymentDate datetime 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 datetime 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 datetime Date of last change of profit.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.
Server_MoneyS3SourceIdentifier nvarchar (256)

dbo.EWD_Companies

Companies list

Object ID: 149575571; Created: May 18, 2008, 17:25:31; Modified: April 24, 2019, 13:38:28
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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 datetime Date of the last activity.
NextStep datetime 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 Company type identificator.
Server_MoneyS3SourceIdentifier nvarchar (256)

dbo.EWD_Contacts

List of contacts

Object ID: 165575628; Created: May 18, 2008, 17:25:31; Modified: January 10, 2019, 21:15:06
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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 datetime Date of a last activity.
NextStep datetime 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 Company type identificator.

dbo.EWD_CurrencyExchangeRates

Object ID: 1997354280; Created: February 03, 2014, 21:07:17; Modified: April 06, 2018, 09:22:03
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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.

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: October 25, 2018, 21:01:55
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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.

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: May 23, 2018, 07:42:08
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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.

dbo.EWD_EnumTypes

Enumerators names, connected with ItemGUID to EWD_EnumValues.EnumType

Object ID: 229575856; Created: May 18, 2008, 17:25:31; Modified: May 04, 2018, 20:48:17
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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.

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 24, 2019, 20:14:16
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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.

dbo.EWD_Features

Object ID: 1264580139; Created: July 03, 2017, 22:41:11; Modified: April 06, 2018, 09:22:03
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 datetime Date when the record was created on the local database.
ItemChanged datetime Date when the record was changed for the last time on the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date when the record was created on the server database.
Server_ItemChanged datetime DEFAULT (getdate())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.

dbo.EWD_GlobalSettings

Object ID: 1108198998; Created: July 31, 2008, 12:59:44; Modified: March 29, 2019, 20:43:17
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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 int DEFAULT ((0))0: String, 1: Bit, 2: Integer, 3: Float, 4: MultiString, 5: ComboBox, 6: CheckedComboBox.
AvailableValues nvarchar (max) List of available values for value column.
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.

dbo.EWD_Goals

Object ID: 192980014; Created: December 10, 2014, 15:07:52; Modified: April 06, 2018, 09:22:04
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
FileAs nvarchar (256) Text description of the record.
GoalTypeEn uniqueidentifier Identifier of goal’s type item in EnumValues.
Note nvarchar (max) Additional text information.
StartDate datetime Star date of the goal.
EndDate datetime 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 datetime Date when the revenue was changed last time.
ProfitGoalChanged datetime Date when the profit was changed last time.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWD_Goods

Object ID: 1689773077; Created: January 18, 2011, 16:33:10; Modified: January 21, 2019, 21:22:42
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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 datetime 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 datetime 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 Product type identificator.

dbo.EWD_GoodsInCart

Object ID: 1769773362; Created: January 18, 2011, 16:33:10; Modified: February 28, 2019, 20:17:07
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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 datetime 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 datetime 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 datetime 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 datetime 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 datetime 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 Product type identificator.

dbo.EWD_GoodsInSet

Object ID: 1460916276; Created: November 26, 2012, 13:00:54; Modified: March 04, 2019, 20:57: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.
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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 Identifier 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.

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: April 06, 2018, 09:22:04
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
ResponsibilityDescription nvarchar (max) 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 (256) 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.

dbo.EWD_History

Object ID: 1817018200; Created: March 05, 2018, 21:11:38; Modified: April 06, 2018, 09:22:04
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 datetime DEFAULT (getdate())Date when the record was changed for the last time on the local database.
Server_ItemChanged datetime DEFAULT (getdate())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 (18, 4) Previous decimal value.
NewValueDecimal decimal (18, 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.

dbo.EWD_Children

Users children

Object ID: 133575514; Created: May 18, 2008, 17:25:31; Modified: April 06, 2018, 09:22:04
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
LastName nvarchar (255) Last name.
PersonalIdentificationNumber nvarchar (255) Personal ID.
MiddleName nvarchar (255) Middle name.
FirstName nvarchar (255) First name.
Agreement bit Agreement with personal information handling.
Prefix nvarchar (255) Prefix.
Birthdate datetime 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.

dbo.EWD_IndividualDiscounts

Object ID: 1849773647; Created: January 18, 2011, 16:33:11; Modified: April 06, 2018, 09:22:04
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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 datetime 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.

dbo.EWD_ItemChanges

Changes for synchronization - items in this table are synchronized automaticaly

Object ID: 231671873; Created: May 18, 2008, 18:17:44; Modified: February 02, 2018, 20:47:01
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 datetime DEFAULT (getdate())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.

dbo.EWD_Journal

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

Object ID: 309576141; Created: May 18, 2008, 17:25:31; Modified: July 10, 2019, 21:34:03
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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.

dbo.EWD_Knowledge

Users knowledges

Object ID: 325576198; Created: May 18, 2008, 17:25:31; Modified: April 06, 2018, 09:22:04
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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.

dbo.EWD_Layouts

Object ID: 1720861693; Created: October 19, 2016, 22:19:25; Modified: January 07, 2019, 21:01: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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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.

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 07, 2019, 21:01: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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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.

dbo.EWD_Leads

Object ID: 1248723501; Created: September 11, 2009, 16:59:49; Modified: October 25, 2018, 21:01:55
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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 datetime 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 datetime Estimated end of the lead.
PrevStateEn uniqueidentifier dbo.EWD_EnumValues.ItemGUIDPrevious status of the record.
Street nvarchar (255) Street of contact address.
Zip nvarchar (255) ZIP code of contact address.
City nvarchar (255) 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 datetime 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 datetime Date of a the last activity.
NextStep datetime 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.

dbo.EWD_LoginHistory

Object ID: 544720993; Created: August 28, 2008, 16:04:31; Modified: August 24, 2018, 20:14:29
Name Type NULL Comment
ItemGUID uniqueidentifier Identifier of the database record.
Created datetime Login time.
ClientVersion nvarchar (50) Client version.
UserHostID nvarchar (50) Client ID.
Successful bit Indicates whether the login was successful.
CommunicatedUserHostAddress varchar (45) IP host address which the client claims to be using (created for WCF IP retransmitting).
UserHostAddress varchar (45) IP host address of the remote client.
UserHostName nvarchar (50) Name of the host.
UserGUID uniqueidentifier Identifier of the user.
SID uniqueidentifier Session GUID.
TimeZone nvarchar (32) Time zone identifier.

dbo.EWD_Mappings

Object ID: 1644949332; Created: November 20, 2015, 22:09:54; Modified: April 06, 2018, 09:22:04
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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.

dbo.EWD_Marketing

Object ID: 86291367; Created: March 16, 2011, 10:25:15; Modified: October 25, 2018, 21:01:55
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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 datetime Estimated start of the marketing campaign.
EstimatedEnd datetime 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 datetime Real start of the marketing campaign.
RealEnd datetime 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 (30) 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.

dbo.EWD_MarketingList

Object ID: 326292222; Created: March 16, 2011, 10:25:31; Modified: July 10, 2019, 21:34:04
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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.

dbo.EWD_MarketingListSources

Object ID: 422292564; Created: March 16, 2011, 10:25:38; Modified: April 06, 2018, 09:22:04
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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.

dbo.EWD_ObjectTypesOptions

Object ID: 1755113989; Created: March 21, 2018, 12:49:26; Modified: April 06, 2018, 09:22:04
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 datetime Date when the record was created on the local database
ItemChanged datetime Date when the record was changed for the last time on the local database
Server_ItemCreated datetime DEFAULT (getdate())Date when the record was created on the server database
Server_ItemChanged datetime DEFAULT (getdate())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.

dbo.EWD_Payments

Object ID: 1070171108; Created: June 17, 2014, 21:27:47; Modified: April 06, 2018, 09:22:04
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
Date datetime Date of payment.
Paid decimal (18, 3) Paid amount.
PaidDefaultCurrency decimal (18, 3) Default currency of payment.
PaidParentCurrency decimal (18, 3) Payment currency of the parent object.
CurrencyEn uniqueidentifier DEFAULT ('8D70FEA5-8370-4923-97F5-8667707B4802')dbo.EWD_EnumValues.ItemGUIDIdentifier of the currency.
Server_PohodaId int Unique identifier of this item in system Pohoda.
Server_PohodaIdUniqueHelper uniqueidentifier COMPUTEDSubstitute unique identifier, when the Server_PohodaId is null.
FileAs nvarchar (256) Text description of the record.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWD_PriceListGroups

Object ID: 177435706; Created: January 24, 2013, 15:08:15; Modified: April 06, 2018, 09:22:04
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
FileAs nvarchar (256) Text description of the record.
Server_PohodaId int Unique identifier of this item in system Pohoda.
Note nvarchar (max) Additional text information.
Server_PohodaIdUniqueHelper uniqueidentifier COMPUTEDSubstitute unique identifier, when the Server_PohodaId is null.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWD_Prices

Object ID: 418673135; Created: July 28, 2017, 22:44:31; Modified: April 06, 2018, 09:22:04
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 datetime Date when the record was created on the local database.
ItemChanged datetime Date when the record was changed for the last time on the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date when the record was created on the server database.
Server_ItemChanged datetime DEFAULT (getdate())Date when the record was changed for the last time on the server database.
SalePriceGUID uniqueidentifier dbo.EWD_SalePrices.ItemGUIDGUID from EWD_SalesPrices, type of sale’s price.
GoodsItemGUID uniqueidentifier dbo.EWD_Goods.ItemGUIDGUID from EWD_Goods.
Price decimal (18, 3) Sale price.
CurrencyEn uniqueidentifier DEFAULT ('8D70FEA5-8370-4923-97F5-8667707B4802')Identifier of currency in EnumValues.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWD_ProjectAssignments

Object ID: 341576255; Created: May 18, 2008, 17:25:31; Modified: April 06, 2018, 09:22:04
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.
WeekNumber int Week number.
Year int Year number.
AssignmentHours decimal (18, 2) Assigned hours.
ItemCreated datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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.

dbo.EWD_Projects

List of projects

Object ID: 791673868; Created: June 19, 2008, 18:11:48; Modified: October 25, 2018, 21:01:55
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
Note nvarchar (max) Additional text information.
Price decimal (18, 2) Price.
ProjectEnd datetime Project end.
ProjectStart datetime Project start.
ProjectName nvarchar (256) Name of the project.
TypeEn uniqueidentifier dbo.EWD_EnumValues.ItemGUIDType of the record.
StateEn uniqueidentifier dbo.EWD_EnumValues.ItemGUIDStatus of the record.
FileAs nvarchar (256) Text description of the record.
PeopleExpenses decimal (18, 2) People expenses.
ProjectRealEnd datetime Real end.
EstimatedPrice decimal (18, 2) Estimated price.
HID int Project ID.
ProjectOriginEn uniqueidentifier dbo.EWD_EnumValues.ItemGUIDIdentifier origin.
PaymentTypeEn uniqueidentifier dbo.EWD_EnumValues.ItemGUIDPayment type identifier.
OtherExpenses decimal (18, 2) Other expenses.
Margin decimal (18, 4) Margin.
PaymentMaturity int Payment maturity.
InvoicePaymentDate datetime Payment date.
InvoiceIssueDate datetime Invoice date.
EstimatedMargin decimal (18, 4) Estimated margin.
EstimatedPeopleExpenses decimal (18, 2) Estimated people expenses.
EstimatedOtherExpenses decimal (18, 2) Estimated other expenses.
LicensesCount int Number of licenses.
LicensePrice decimal (18, 2) Price per license.
PrevStateEn uniqueidentifier dbo.EWD_EnumValues.ItemGUIDPrevious status of the record.
ShowInCaplan bit DEFAULT ((1))Indicates whether the project is visible in the CaPlan application.
af_14 nvarchar (255)
EstimatedWorkHours int Estimated work hours on project.
TotalWorkHours decimal (18, 3) Total work hours on project.
EstimatedPeopleExpensesDefaultCurrency decimal (18, 2) Estimated people expenses in default currency.
EstimatedOtherExpensesDefaultCurrency decimal (18, 2) Estimated other expenses in default currency.
EstimatedPriceDefaultCurrency decimal (18, 2) Estimated price of project in default currency.
PeopleExpensesDefaultCurrency decimal (18, 2) People’s expenses in default currency.
OtherExpensesDefaultCurrency decimal (18, 2) Other expenses in default currency.
PriceDefaultCurrency decimal (18, 2) Price of project in default currency.
CurrencyEn uniqueidentifier DEFAULT ('8D70FEA5-8370-4923-97F5-8667707B4802')dbo.EWD_EnumValues.ItemGUIDIdentifier of the currency.
EstimatedPeopleExpensesChanged datetime Date and time when was EstimatedPeopleExpensesDefaultCurrency changed.
EstimatedOtherExpensesChanged datetime Date and time when was EstimatedOtherExpensesDefaultCurrency changed.
OtherExpensesChanged datetime Date and time when was OtherExpensesDefaultCurrency changed.
EstimatedPriceChanged datetime Date and time when was OtherExpensesDefaultCurrency changed.
PriceChanged datetime Date and time, when was PriceDefaultCurrency changed.
LicensePriceChanged datetime Date and time, when was LicensePriceDefaultCurrency changed.
LicensePriceDefaultCurrency decimal (18, 2) Price of License in default currency.
Private bit DEFAULT ((0))Determines whether the item is private. Default is no.
LastActivity datetime Date of the last activity.
NextStep datetime Date of the next step.
Profit decimal (18, 3) Project actual profit.
ProfitDefaultCurrency decimal (18, 3) Project actual profit in default currency.
EstimatedProfit decimal (18, 3) Project estimated profit.
EstimatedProfitDefaultCurrency decimal (18, 3) Project estimated profit in default currency.
PeopleExpensesChanged datetime Date and time, when was OtherExpensesDefaultCurrency changed.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWD_QueuedJobs

Object ID: 2081090850; Created: August 10, 2015, 22:08:47; Modified: August 11, 2015, 22:07:43
Name Type NULL Comment
ItemCreated datetime DEFAULT (getdate())Date and time when the record has been created in the local database.
ID bigint IDENTITYNumber identifier of item.
Name varchar (256) Name of the SQL stored procedure.
Parameters nvarchar (max) Parameters of the stored procedure.
BatchStart datetime Date and time when the batch started.
IsError bit Indicates whether the job finished with error.
ErrorMessage nvarchar (max) Error message.

dbo.EWD_RecurrencePatterns

Object ID: 1972878791; Created: June 14, 2018, 20:20:57; Modified: June 15, 2018, 20:19:59
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 datetime Date when the record was created on the local database
ItemChanged datetime Date when the record was changed for the last time on the local database
Server_ItemCreated datetime DEFAULT (getdate())Date when the record was created on the server database
Server_ItemChanged datetime DEFAULT (getdate())Date when the record was changed for the last time on the server database
TaskGUID uniqueidentifier dbo.EWD_Tasks.ItemGUIDUnique identificator of related task
RecurrenceType tinyint Recurrence type
Interval int Recurrence interval
Instance tinyint Recurrence instance
DayOfWeekMask tinyint Days of week mask used for recurrence
DayOfMonth tinyint Day of month of ocurrence
MonthOfYear tinyint Month of year of ocurrence
Regenerate bit Value indicating whether task should be regenerate after being completed
NoEndDate bit Value indicating whether end date of recurrence is set
Occurrences int Number of occurrences
PatternStartDate datetime Start date of recurrence
PatternEndDate datetime End date of recurrence
EndKind tinyint Value indicating kind of recurrence pattern end.

dbo.EWD_RelationData

Additional data for relations - connected by ItemGUID to EWR_ObjectRelations.RelationDataGUID

Object ID: 389576426; Created: May 18, 2008, 17:25:31; Modified: April 06, 2018, 09:22:04
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWD_Reports

Table of reports definitions, not shown on any form - should be in Administrator UI soon.

Object ID: 608721221; Created: September 04, 2008, 19:58:32; Modified: January 25, 2019, 20:58:59
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
FileAs nvarchar (255) Text description of the record.
Category uniqueidentifier Category identifier.
Name varchar (128) Name of the report.
Description nvarchar (255) Detailed description.
Definition nvarchar (max) XML definition of the report (contents of the RDL file).
Data nvarchar (max) Additional data.
Active bit DEFAULT ((1))Value indicating whether the report is active.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWD_Responses

Object ID: 214291823; Created: March 16, 2011, 10:25:24; Modified: February 09, 2017, 22:19:24
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
FileAs nvarchar (256) Text description of the record.
ResponseTypeEn uniqueidentifier dbo.EWD_EnumValues.ItemGUIDIdentifier of the response type.
Date datetime Date and time of the response.
ResponseFormEn uniqueidentifier dbo.EWD_EnumValues.ItemGUIDIdentifier of the response form.
Note nvarchar (max) Additional text information.
Respondent nvarchar (256) Name of the respondent.
EmailCampaignResponseType tinyint Identifier of the response type.
Private bit DEFAULT ((0))Determines whether the item is private. Default is no.
Server_ResponseJournalGUID uniqueidentifier Identifier of journal which has been converted from response entry.

dbo.EWD_RevisionsHistory

Object ID: 742293704; Created: May 27, 2011, 14:16:57; Modified: May 23, 2018, 07:42:08
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.
ItemCreated datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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.
OwnerGUID uniqueidentifier dbo.EWD_Users.ItemGUIDOwner of the database record.
Revision int DEFAULT ((1))Number of the revision.
DocumentGUID uniqueidentifier dbo.EWD_Documents.ItemGUIDGUID of the related document.
FileAs nvarchar (256) Text description of the record.
FileSize bigint Size of the document file in bytes.
FileCreationTime datetime Creation date and time.
FileLastWriteTime datetime Date and time of the last document change.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWD_Salaries

Users salaries

Object ID: 437576597; Created: May 18, 2008, 17:25:31; Modified: April 06, 2018, 09:22:04
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
GrossSalary decimal (18, 2) Gross salary.
Note nvarchar (max) Additional text information.
ValidTo datetime Valid to.
MealTickets bit Meal tickets.
SupergrossSalary decimal (18, 2) DEFAULT ((0))Supergross salary.
Default bit Just one default salary can exist in a time.
ValidFrom datetime Valid from.
FileAs nvarchar (256) Text description of the record.
WorkLoadEn uniqueidentifier WorkLoad identifier.
SalaryTypeEn uniqueidentifier Salary type identifier.
Workload int Week work hours.
GrossSalaryDefaultCurrency decimal (18, 2) Amount of gross salary in default currency.
SupergrossSalaryDefaultCurrency decimal (18, 2) Amount of super gross salary in default currency.
CurrencyEn uniqueidentifier DEFAULT ('8D70FEA5-8370-4923-97F5-8667707B4802')dbo.EWD_EnumValues.ItemGUIDIdentifier of currency.
Private bit DEFAULT ((0))Determines whether the item is private. Default is no.
AdditionalCosts decimal (18, 2) DEFAULT ((0))Amount of additional costs.
AdditionalCostsDefaultCurrency decimal (18, 2) Amount of additional costs in default currency.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWD_SalePricePrices

Object ID: 1942154560; Created: July 27, 2017, 22:40:58; Modified: July 27, 2017, 22:40:59
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 datetime Date when the record was created on the local database.
ItemChanged datetime Date when the record was changed for the last time on the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date when the record was created on the server database.
Server_ItemChanged datetime DEFAULT (getdate())Date when the record was changed for the last time on the server database.
SalePriceGUID uniqueidentifier dbo.EWD_SalePrices.ItemGUIDGUID from EWD_SalesPrices, type of sale’s price.
GoodsItemGUID uniqueidentifier dbo.EWD_Goods.ItemGUIDGUID from EWD_Goods.
Price decimal (18, 3) Sale price.
CurrencyEn uniqueidentifier DEFAULT ('8D70FEA5-8370-4923-97F5-8667707B4802')Identifier of currency in EnumValues.

dbo.EWD_SalePrices

Object ID: 1591012749; Created: May 28, 2013, 06:56:39; Modified: April 06, 2018, 09:22:04
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
FileAs nvarchar (256) Text description of the record.
Note nvarchar (max) Additional text information.
Discount decimal (18, 4) Discount in percent.
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.

dbo.EWD_Sessions

Object ID: 453576654; Created: May 18, 2008, 17:25:31; Modified: August 24, 2018, 20:14:29
Name Type NULL Comment
SID uniqueidentifier GUID identifier.
UserGUID uniqueidentifier dbo.EWD_Users.ItemGUIDGUID of the user.
Created datetime Date and time of session creation.
LastActivity datetime Date and time of session last activity.
ClientVersion nvarchar (50) Client version.
UserHostAddress varchar (45) IP host address of the remote client.
UserHostId varchar (50) Unique identification of the remote client.
Success bit DEFAULT ((1))Value indicating whether was login successful.
CommunicatedUserHostAddress varchar (45) IP host address which the client claims to be using (created for WCF IP retransmitting).
UserHostName nvarchar (50) Name of the host.
TimeZone nvarchar (32) Time zone identifier.

dbo.EWD_SqlObjects

SQL definition of objects needed in local database.

Object ID: 1495676376; Created: June 23, 2008, 13:20:26; Modified: April 06, 2018, 09:22:04
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
Name nvarchar (256) Name of the object.
Type int 1: Table, 2: View, 3: Procedure, 4: Function, 5: Trigger.
Script nvarchar (max) Script definition.
Rank int Position of the item.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWD_Tasks

Object ID: 759673754; Created: June 18, 2008, 18:39:18; Modified: July 10, 2019, 21:34:03
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
Body nvarchar (max) Body of task.
Complete bit DEFAULT ((0))Determines whether the task is completed.
DueDate datetime Due date of the task.
Importance int Number identifier of the importance (0, 1, 2).
PercentComplete int Percents of task completion.
StartDate datetime Start date of task.
Status int Number identifier of task status (0, 1, 2, 3).
Subject nvarchar (256) Subject of task.
FileAs nvarchar (1280) Text description of the record.
Level int DEFAULT ((1))Level of task (1 .. 8).
RTFBody nvarchar (max) RTF version of the task body.
TeamTask bit DEFAULT ((0))Indicates whether the task i team task.
Private bit DEFAULT ((0))Determines whether the item is private. Default is no.
Sensitivity int DEFAULT ((0))Number identifier of task sensitivity (0, 1, 2).
Categories nvarchar (max) Contains data from the Outlook's TaskItem Categories field.
ActualWorkHours decimal (18, 3) Summarization of related work sheets duration.
EstimatedWorkHours decimal (18, 3) Taks estimated efford value from Outlook.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.
TypeEn uniqueidentifier DEFAULT ('F8622121-6206-47DE-9A3A-C7DC7E9AF92A')Workflow type identificator.
StateEn uniqueidentifier dbo.EWD_EnumValues.ItemGUIDWorkflow previous status identificator.
PrevStateEn uniqueidentifier dbo.EWD_EnumValues.ItemGUID
PercentCompleteDecimal decimal (5, 4) Percents of task completion.
Reminder bit DEFAULT ((0))Value indicating whether is reminder active.
ReminderDate smalldatetime Date of task reminder.
ImportanceEn uniqueidentifier dbo.EWD_EnumValues.ItemGUIDLevel of task importance.
CompletedDate datetime Date when task was completed.

dbo.EWD_TeamRoles

Description of team members roles.

Object ID: 501576825; Created: May 18, 2008, 17:25:31; Modified: April 06, 2018, 09:22:04
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
RelationDataGUID uniqueidentifier dbo.EWD_RelationData.ItemGUIDGUID of the RelationData of the relation between project and user.
GroupGUID uniqueidentifier dbo.EWD_Groups.ItemGUIDRelated group identifier.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWD_Training

Users trainings

Object ID: 533576939; Created: May 18, 2008, 17:25:31; Modified: April 06, 2018, 09:22:04
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
Date datetime Date.
TitleEn uniqueidentifier dbo.EWD_EnumValues.ItemGUIDTitle identifier.
GradeEn uniqueidentifier dbo.EWD_EnumValues.ItemGUIDGrade identifier.
Result nvarchar (256) Result.
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.

dbo.EWD_Users

eWay users

Object ID: 549576996; Created: May 18, 2008, 17:25:31; Modified: June 24, 2019, 20:14:16
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
UserName nvarchar (50) Login name.
Server_Password char (32) Hashed password.
FirstName nvarchar (256) First user name.
MiddleName nvarchar (256) Middle user name.
Suffix nvarchar (50) Suffix.
FileAs nvarchar (1280) Text description of the record.
Active bit DEFAULT ((0))Indicates whether the user is active or not.
MobilePhoneNumber nvarchar (256) Mobile number.
Email1Address nvarchar (256) First email address.
BusinessPhoneNumber nvarchar (256) Telephone number.
BankAccount nvarchar (256) Bank account.
BirthPlace nvarchar (256) Birth place.
Note nvarchar (max) Additional text information.
HomeAddressPostalCode nvarchar (256) Postal code of user's home address.
IDCardNumber nvarchar (256) ID card number.
Birthdate datetime Birthday.
IdentificationNumber nvarchar (256) ID.
HomeAddressCountry nvarchar (256) Country of user's home address.
HomeAddressState nvarchar (256) State of user's home address.
HealthInsurance nvarchar (256) Health insurance.
Prefix nvarchar (256) Prefix.
HolidayLength decimal (5, 2) Holiday length.
LastName nvarchar (256) Last name.
PersonalIdentificationNumber nvarchar (256) Personal ID.
MSN nvarchar (256) MSN contact.
ICQ nvarchar (256) ICQ nickname.
HomeAddressStreet nvarchar (256) Street of user's home address.
Email2Address nvarchar (256) Second email address.
HomeAddressCity nvarchar (256) City of user's home address.
Skype nvarchar (256) Skype name.
HomeAddressPOBox nvarchar (256) POBox of user's home address.
FamilyStatusEn uniqueidentifier Family status identifier.
SalaryDateEn uniqueidentifier Salary date identifier.
TransportMode nvarchar (256) Transport mode.
TravelDistance nvarchar (256) Travel distance.
TimeAccessibility nvarchar (256) Time accessibility.
IsHRManager bit Obsolete, but used for costs calculation or in CaPlan. Should be deleted in near future.
IsProjectManager bit Obsolete, but used for costs calculation or in CaPlan. Should be deleted in near future.
ShowInCaplan int Obsolete, but used for costs calculation or in CaPlan. Should be deleted in near future.
Server_PhoneListAlgorithmEnd datetime Related to the PhoneList functionality.
PrefixEn uniqueidentifier dbo.EWD_EnumValues.ItemGUIDIdentifier of the prefix.
SuffixEn uniqueidentifier dbo.EWD_EnumValues.ItemGUIDIdentifier of the suffix.
WorkdayStartTime nchar (5) DEFAULT ('09:00')Hour when the user workday begins.
RemainingDaysOfHoliday decimal (5, 2) DEFAULT ((0))Number of remaining holiday days for the current year.
Server_OutlookAccess bit DEFAULT ((0))Indicates whether the user has access to Outlook client.
Server_WebAccess bit DEFAULT ((0))Indicates whether the user has access to WebAccess client.
Server_LastLogin datetime Date and time of last user login on server.
Server_LastActivity datetime Date and time of last user server activity.
HomeAddressCountryEn uniqueidentifier DEFAULT ('E130FB18-0950-4D21-8D96-13387D519DD7')dbo.EWD_EnumValues.ItemGUIDGUID of user's home address country.
MobilePhoneNumberNormalized varchar (256) Normalized mobile.
BusinessPhoneNumberNormalized varchar (256) Normalized phone number.
Server_MobileAccess bit DEFAULT ((0))Indicates whether the user has access to Mobile client.
IsSystem bit DEFAULT ((0))Value indicating whether the user is a system uer.
JobTitle nvarchar (256) Job title of the user.
ProfilePicture varbinary (max) Profile picture of the user.
ProfilePictureWidth int DEFAULT ((0))Width of the profile picture.
ProfilePictureHeight int DEFAULT ((0))Height of the profile picture.
Server_AccountLockedTime datetime Value indicating whether was account locked and when.
Server_ForcePasswordChange bit DEFAULT ((0))Value indicating whether is change of user password forced.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWD_UserSettings

Object ID: 1216723387; Created: September 11, 2009, 16:58:08; Modified: April 06, 2018, 09:22:04
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
Name nvarchar (64) Name.
Value nvarchar (max) Value.
Path nvarchar (256) Path.
FileAs nvarchar (256) Text description of the record.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWD_Vacation

Users vacations.

Object ID: 565577053; Created: May 18, 2008, 17:25:31; Modified: July 10, 2019, 21:34:03
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
StartDate smalldatetime Start.
EndDate smalldatetime End.
Place nvarchar (256) Place.
Note nvarchar (max) Additional text information.
TypeEn uniqueidentifier dbo.EWD_EnumValues.ItemGUIDType of the record.
FileAs nvarchar (256) Text description of the record.
StateEn uniqueidentifier dbo.EWD_EnumValues.ItemGUIDStatus of the record.
PrevStateEn uniqueidentifier dbo.EWD_EnumValues.ItemGUIDPrevious status of the record.
Duration decimal (5, 2) Duration in days.
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.

dbo.EWD_Version

Object ID: 1556916618; Created: November 26, 2012, 13:00:54; Modified: December 16, 2016, 12:30:04
Name Type NULL Comment
ID int IDENTITYNumber identifier of version.
eWay nvarchar (32) eWay-CRM version identifier.
WebAccess nvarchar (32) WebAccess version identifier.
AvailableVersionApproved bit This bit specifies whether the available version was already allowed/denied/not seen by the administrator.
AvailableWebServiceVersion nvarchar (20) This bit specifies whether the available version was already allowed/denied/not seen by the administrator.
AvailableOutlookClientVersion nvarchar (20) This bit specifies whether the available version was already allowed/denied/not seen by the administrator.
AvailableVersionChangeLogLink nvarchar (1024) Link to translated web page containing change log and support for eWay upgrade.
AvailableVersionReleaseDate datetime This is the date when the available version was created in the LS. It is the release date of the particular version.
eWayChecksum char (32) Checksum of the client installation file.

dbo.EWD_WebAccess2Options

Object ID: 689437530; Created: March 06, 2013, 15:20:49; Modified: April 06, 2018, 09:22:04
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.
ItemCreated datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
OwnerGUID uniqueidentifier dbo.EWD_Users.ItemGUIDOwner of the database record.
Key nvarchar (768) Key.
Type nvarchar (768) Type.
Value nvarchar (max) Value.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWD_WebAccessOptions

Object ID: 581577110; Created: May 18, 2008, 17:25:31; Modified: April 06, 2018, 09:22:04
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.
OptionName nvarchar (50) Name of option.
OptionValue nvarchar (256) Value of option.
OwnerGUID uniqueidentifier dbo.EWD_Users.ItemGUIDOwner of the database record.
ItemCreated datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWD_WorkCommitments

Object ID: 597577167; Created: May 18, 2008, 17:25:31; Modified: April 06, 2018, 09:22:04
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.
WeekNumber int Weeknumber of commitment.
Year int Year of commitment.
WorkCommitment int Committed hours.
ItemCreated datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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.

dbo.EWD_WorkReports

Users worked hours

Object ID: 613577224; Created: May 18, 2008, 17:25:31; Modified: July 10, 2019, 21:34:03
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.
Subject nvarchar (256) Subject.
Date datetime Date.
Duration decimal (18, 3) Duration in hours.
Note nvarchar (max) Additional text information.
Rate decimal (18, 2) Costs of the item.
ItemCreated datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
WorkReportEn uniqueidentifier dbo.EWD_EnumValues.ItemGUIDType of the record.
ImportanceEn uniqueidentifier dbo.EWD_EnumValues.ItemGUIDImportance.
FromTime smalldatetime From.
ToTime smalldatetime To.
DayTypeEn uniqueidentifier Day type identifier.
Overtime bit Indicates whether the item is overtime.
Calendar_ORIGIN uniqueidentifier dbo.EWD_Calendar.ItemGUIDRelated item from EWD_Calendar.
Year int Year.
Month tinyint Month.
CalendarEntryID varchar (140) EntryID of the related appointment from Outlook.
RateDefaultCurrency decimal (18, 2) Default currency rate.
RateParentCurrency decimal (18, 2) Parent currency rate.
CurrencyEn uniqueidentifier DEFAULT ('8D70FEA5-8370-4923-97F5-8667707B4802')dbo.EWD_EnumValues.ItemGUIDIdentifier of the currency.
StateEn uniqueidentifier dbo.EWD_EnumValues.ItemGUIDStatus of the record.
PrevStateEn uniqueidentifier dbo.EWD_EnumValues.ItemGUIDPrevious status of the record.
Private bit DEFAULT ((0))Determines whether the item is private. Default is no.
RateAdditional decimal (18, 2) Additional costs.
RateAdditionalDefaultCurrency decimal (18, 2) Additional costs in default currency.
RateAdditionalParentCurrency decimal (18, 2) Additional costs in parent currency.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWD_WrongClientVersions

List of not allowed client versions for current data structure.

Object ID: 596197174; Created: July 15, 2008, 11:27:21; Modified: November 26, 2012, 13:00:38
Name Type NULL Comment
ClientVersion nvarchar (50) Client version.

dbo.EWD_XsltTransformations

Object ID: 1881773761; Created: January 18, 2011, 16:33:11; Modified: April 06, 2018, 09:22:04
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
FileAs nvarchar (256) Text description of the record.
LangCode nchar (2) DEFAULT (N'cs')Language code (cs, en, ru, de, no, sk).
Definition nvarchar (max) XML definition of the template.
Namespace nvarchar (128) DEFAULT ('urn:eway:document-schemas:proposal')Namespace of the template.
ObjectTypeID tinyint DEFAULT ((70))dbo.EWE_ObjectTypes.ObjectTypeIDObjectTypeID of the module where the transformation will be used.
TransformationVersion int DEFAULT ((1))Version of the transformation.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWE_ClientVersions

Object ID: 1612493469; Created: February 28, 2018, 20:21:12; Modified: March 05, 2018, 21:11:38
Name Type NULL Comment
ID bigint IDENTITYId of the specific record.
ClientVersion nvarchar (50) Client version.

dbo.EWE_ColumnPermissions

Permissions for specified columns.

Object ID: 645577338; Created: May 18, 2008, 17:25:31; Modified: December 21, 2018, 20:16:21
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 datetime DEFAULT (getdate())Date and time when the record has been created in the local database.
ItemChanged datetime DEFAULT (getdate())Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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.
GroupGUID uniqueidentifier dbo.EWD_Groups.ItemGUIDRelated group identifier.
ObjectTypeID tinyint dbo.EWE_ObjectTypes.ObjectTypeIDObjectTypeID of the module where the column permission is applied.
ColumnName nvarchar (255) Column name.
FileAs nvarchar (256) Text description of the record.
Type tinyint DEFAULT ((0))0: None, 1: All, 2: Own, 3: Readonly, 4: Invisible.
Mandatory tinyint DEFAULT ((0))Represents a mandatory column.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.
IsMandatoryEditable bit DEFAULT ((1))Value indicating whether is module permission system and therefore not editable.
IsTypeEditable bit DEFAULT ((1))Value indicating whether user is able to change Type.

dbo.EWE_Holidays

Object ID: 1424724128; Created: November 12, 2009, 16:43:38; Modified: April 06, 2018, 09:22:04
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
FileAs nvarchar (50) Text description of the record.
Date smalldatetime Date of holiday.
CalcFunction nvarchar (50) Name of SQL function, which calculates date of holiday.
CountryEn uniqueidentifier DEFAULT ('E130FB18-0950-4D21-8D96-13387D519DD7')Country identifier.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWE_ModulePermissions

Permissions for a group on a specified module.

Object ID: 661577395; Created: May 18, 2008, 17:25:31; Modified: April 06, 2018, 09:22:04
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 datetime DEFAULT (getdate())Date and time when the record has been created in the local database.
ItemChanged datetime DEFAULT (getdate())Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())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.
FileAs nvarchar (256) Text description of the record.
GroupGUID uniqueidentifier dbo.EWD_Groups.ItemGUIDRelated group identifier.
ObjectTypeID tinyint dbo.EWE_ObjectTypes.ObjectTypeIDObjectTypeID of the module where the module permission is applied.
View varchar (16) NONE, OWN, RELATED, GROUP, INHERITED, ALL.
Edit varchar (16) NONE, OWN, RELATED, GROUP, INHERITED, ALL.
Delete varchar (16) NONE, OWN, RELATED, GROUP, INHERITED, ALL.
Create varchar (16) ALL, NONE.
Export varchar (16) DEFAULT ('ALL')ALL, NONE, OWN.
RowsRestriction int DEFAULT ((0))Number of allowed rows.
IsSystem bit DEFAULT ((0))Value indicating whether is module permission system and therefore not editable.
History varchar (16) DEFAULT ('ALL')ALL, NONE, OWN.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWE_ObjectTypes

List of every modules in eWay

Object ID: 304720138; Created: August 21, 2008, 15:00:40; Modified: January 07, 2019, 21:01:25
Name Type NULL Comment
ObjectTypeID tinyint IDENTITYID of the module.
FolderName nvarchar (50) Folder name.
TableName nvarchar (50) Name of corresponding table in server database.
ReadOnly bit Indicates whether the module is readonly.
FullTextEnabled bit Indicates whether fulltext is enabled on this module.
RecentItemsEnabled bit Indicates whether recent items is enable on this module.
Customizable bit DEFAULT ((1))Additional fields can be added or not.
IsModule bit Indicates whether users may define permission on this module.
PrivateItemsEnabled bit DEFAULT ((0))Determines whether items in corresponded module can be private.
SupportsFileAs bit DEFAULT ((1))Indicates whether module uses FileAs column.
Active bit DEFAULT ((1))Value indicating whether the module is active.
GDPR bit DEFAULT ((0))Value indicating whether modul supports GDPR logic.
GDPRHistory bit DEFAULT ((0))Value indicating whether item has GDPR history.

dbo.EWF_Flows

Possible state changes in WorkFlows

Object ID: 709577566; Created: May 18, 2008, 17:25:31; Modified: August 24, 2018, 13:04:39
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
ModelGUID uniqueidentifier dbo.EWF_Models.ItemGUIDGUID of the workflow model.
ParentStatusGUID uniqueidentifier dbo.EWD_EnumValues.ItemGUIDIdentifier of the parent status.
ChildStatusGUID uniqueidentifier dbo.EWD_EnumValues.ItemGUIDIdentifier of the child status.
Roundtrip bit DEFAULT ((0))Indicates whether the flow allows step back.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWF_History

History of states changes for each WF

Object ID: 725577623; Created: May 18, 2008, 17:25:31; Modified: April 06, 2018, 09:22:04
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
ParentStatusGUID uniqueidentifier dbo.EWD_EnumValues.ItemGUIDIdentifier of the source status.
ChildStatusGUID uniqueidentifier dbo.EWD_EnumValues.ItemGUIDIdentifier of the destination status.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWF_Models

WorkFlow Models, for each WF must exist just one Model

Object ID: 741577680; Created: May 18, 2008, 17:25:31; Modified: April 06, 2018, 09:22:04
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
EnumTypeGUID uniqueidentifier dbo.EWD_EnumTypes.ItemGUIDIdentifier of the enumeration with corresponding workflow statuses.
FileAs nvarchar (256) Text description of the record.
ParentType uniqueidentifier dbo.EWD_EnumValues.ItemGUIDIdentifier of the enum value which represents a type of the item.
IsSystem bit DEFAULT ((0))Determines whether the model is system model.
IsVisible bit DEFAULT ((1))Determines whether the model is visible.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWR_EnumValuesRelations

Object ID: 316436797; Created: October 06, 2017, 22:53:45; Modified: September 20, 2018, 20:17:21
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 datetime Date when the record was created on the local database
ItemChanged datetime Date when the record was changed for the last time on the local database
Server_ItemCreated datetime DEFAULT (getdate())Date when the record was created on the server database
Server_ItemChanged datetime DEFAULT (getdate())Date when the record was changed for the last time on the server database
EnumValueGUID uniqueidentifier dbo.EWD_EnumValues.ItemGUID
RelatedItemGUID uniqueidentifier
FieldName nvarchar (256)
ObjectTypeID tinyint dbo.EWE_ObjectTypes.ObjectTypeIDObjectTypeID of the items.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWR_ItemCopyRelations

Table of relations between source item and copied item

Object ID: 2001754534; Created: April 28, 2015, 21:13:36; Modified: April 06, 2018, 09:22:04
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 datetime Date and time when the record has been created in the local database.
ItemChanged datetime Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
CopyFrom uniqueidentifier Source item identifier.
CopyTo uniqueidentifier Target item identifier.
ObjectTypeID tinyint dbo.EWE_ObjectTypes.ObjectTypeIDObjectTypeID of the items.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.EWR_ObjectRelations

Table of all relations between modules. Each relation is created by pair of relations with opposite ItemGUID1 and ItemGUID2

Object ID: 900198257; Created: July 29, 2008, 16:56:03; Modified: November 07, 2018, 20:16:30
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.
ItemCreated datetime DEFAULT (getdate())Date and time when the record has been created in the local database.
ItemChanged datetime DEFAULT (getdate())Date and time when the record has been updated in the local database.
Server_ItemCreated datetime DEFAULT (getdate())Date and time when the record was created on the server.
Server_ItemChanged datetime DEFAULT (getdate())Date and time when the record was updated on the server.
ItemGUID1 uniqueidentifier GUID of the first item.
ItemGUID2 uniqueidentifier GUID of the second item.
ObjectTypeID1 tinyint dbo.EWE_ObjectTypes.ObjectTypeIDObjectTypeID of the first item.
ObjectTypeID2 tinyint dbo.EWE_ObjectTypes.ObjectTypeIDObjectTypeID of the second item.
RelationDataGUID uniqueidentifier dbo.EWD_RelationData.ItemGUIDEach pair of relations has common information saved here.
RelationType varchar (30) Type of the relation, standard type relation is GENERAL.
Direction tinyint For one-to-many relations. Standard relation has Direction = 0, one-to-many is saved with 1 and 2.
OwnerGUID uniqueidentifier dbo.EWD_Users.ItemGUIDOwner of the database record.
ItemState tinyint COMPUTEDValue is alway zero. It is used for compatibility with local databases.

dbo.schema_migrations

Object ID: 614293248; Created: May 03, 2011, 13:47:44; Modified: October 03, 2013, 21:41:36
Name Type NULL Comment
version bigint

dbo.vw_BusinessHours

Object ID: 186796073; Created: May 06, 2015, 08:08:20
Name Type NULL Comment
DayInWeek int
DayInWeekName nvarchar (30)
hh_From int
mm_From int
hh_To int
mm_To int

dbo.vw_CalculateProjectsPricesWorkReports

Object ID: 955618943; Created: July 27, 2016, 22:19:58
Name Type NULL Comment
ItemGUID uniqueidentifier

dbo.vw_Company2Contact

List of companies and related contacts - for reports.

Object ID: 1892201791; Created: August 08, 2008, 12:08:03; Modified: March 06, 2013, 11:24:10
Name Type NULL Comment
CompanyGUID uniqueidentifier
CompanyName nvarchar (256)
AccountNumber nvarchar (256)
TaxNumber nvarchar (256)
Department nvarchar (256)
IdentificationNumber nvarchar (256)
Note ntext
Phone nvarchar (256)
WebPage nvarchar (256)
POBox nvarchar (256)
Email nvarchar (256)
Fax nvarchar (256)
FirstContact nvarchar (50)
BusinessActivities nvarchar (256)
Importance nvarchar (50)
Suppliers bit
Purchaser bit
Address1Street nvarchar (256)
Address1City nvarchar (256)
Address1State nvarchar (256)
Address1Country nvarchar (256)
Address1PostalCode nvarchar (256)
Address2Street nvarchar (256)
Address2City nvarchar (256)
Address2State nvarchar (256)
Address2Country nvarchar (256)
Address2PostalCode nvarchar (256)
Address3Street nvarchar (256)
Address3City nvarchar (256)
Address3State nvarchar (256)
Address3Country nvarchar (256)
Address3PostalCode nvarchar (256)
ContactGUID uniqueidentifier
BusinessAddressCity nvarchar (256)
BusinessAddressCountry nvarchar (256)
BusinessAddressPostalCode nvarchar (256)
BusinessAddressState nvarchar (256)
BusinessAddressStreet nvarchar (256)
Email1Address nvarchar (256)
FamilyName nvarchar (256)
FirstName nvarchar (256)
HomeAddressCity nvarchar (256)
HomeAddressCountry nvarchar (256)
HomeAddressPostalCode nvarchar (256)
HomeAddressState nvarchar (256)
HomeAddressStreet nvarchar (256)
JobTitle nvarchar (256)
MiddleName nvarchar (256)
ContactNote text
OtherAddressCity nvarchar (256)
OtherAddressCountry nvarchar (256)
OtherAddressPostalCode nvarchar (256)
OtherAddressState nvarchar (256)
OtherAddressStreet nvarchar (256)
TelephoneNumber1 nvarchar (256)
TelephoneNumber2 nvarchar (256)
TelephoneNumber3 nvarchar (256)
TelephoneNumber4 nvarchar (256)
Title nvarchar (256)
ContactWebPage nvarchar (256)
FileAs nvarchar (256)
TEL nvarchar (4000)

dbo.vw_DataIntegrity_Dupl_Customer

Object ID: 112719454; Created: August 14, 2008, 15:37:22; Modified: March 06, 2013, 11:24:09
Name Type NULL Comment
ItemGUID uniqueidentifier
ItemCreated datetime
RelationDataGUID uniqueidentifier
Customer nvarchar (256)
Owner nvarchar (256)

dbo.vw_DataIntegrity_Dupl_Supervisor

Object ID: 128719511; Created: August 14, 2008, 15:37:22; Modified: March 06, 2013, 11:24:09
Name Type NULL Comment
ItemGUID uniqueidentifier
ItemCreated datetime
RelationDataGUID uniqueidentifier
Owner nvarchar (256)
Supervisor nvarchar (256)

dbo.vw_DataIntegrity_Dupl_WR_Project

Object ID: 144719568; Created: August 14, 2008, 15:37:22; Modified: March 06, 2013, 11:24:09
Name Type NULL Comment
WRGUID uniqueidentifier
FileAs nvarchar (256)
ItemCreated datetime
RelationDataGUID uniqueidentifier
ProjectName nvarchar (256)
Owner nvarchar (256)

dbo.vw_DataIntegrity_Dupl_WR_User

Object ID: 160719625; Created: August 14, 2008, 15:37:22; Modified: March 06, 2013, 11:24:09
Name Type NULL Comment
WRGUID uniqueidentifier
FileAs nvarchar (256)
ItemCreated datetime
RelationDataGUID uniqueidentifier
Owner nvarchar (256)
Person nvarchar (256)

dbo.vw_DataIntegrity_Not_Saved_Documents

Object ID: 176719682; Created: August 14, 2008, 15:37:22; Modified: March 06, 2013, 11:24:09
Name Type NULL Comment
Owner nvarchar (256)
DocName nvarchar (256)
Extension nvarchar (128)
CreationTime datetime

dbo.vw_DataIntegrity_Not_Saved_Emails

Object ID: 192719739; Created: August 14, 2008, 15:37:22; Modified: March 06, 2013, 11:24:09
Name Type NULL Comment
Owner nvarchar (256)
FileAs nvarchar (256)
ItemCreated datetime
Subject nvarchar (256)

dbo.vw_DefaultEnumValues

Object ID: 795774538; Created: January 10, 2018, 07:56:29; Modified: January 10, 2018, 07:56:29
Name Type NULL Comment
EnumType uniqueidentifier

dbo.vw_DoNotRecalculateOtherCurrencyPricesItems

Object ID: 941050934; Created: December 21, 2016, 22:24:57
Name Type NULL Comment
ItemGUID uniqueidentifier
FolderName varchar (50)

dbo.vw_ExpenseCarts

Object ID: 1995062789; Created: November 16, 2017, 09:11:46
Name Type NULL Comment
ProjectGUID uniqueidentifier
FolderName nvarchar (50)
FileAs nvarchar (256)
CartItemGUID uniqueidentifier
CartTypeItemGUID uniqueidentifier
AmountExcludingVAT decimal (38, 3)
AmountExcludingVATParentCurrency decimal (38, 3)
AmountExcludingVATDefaultCurrency decimal (38, 3)
PurchaseExpensesParentCurrency decimal (38, 3)
PurchaseExpensesDefaultCurrency decimal (38, 3)
TaxableSupplyDate datetime
AccountingCaseDate datetime

dbo.vw_IncomeCarts

Object ID: 1696021819; Created: July 12, 2018, 20:23:43
Name Type NULL Comment
ProjectGUID uniqueidentifier
FolderName nvarchar (50)
CartItemGUID uniqueidentifier
CartTypeItemGUID uniqueidentifier
AmountExcludingVAT decimal (38, 3)
AmountDefaultCurrency decimal (38, 3)
CurrencyEn uniqueidentifier
AmountExcludingVATParentCurrency decimal (38, 3)
AmountExcludingVATDefaultCurrency decimal (38, 3)
PurchaseExpensesParentCurrency decimal (38, 3)
PurchaseExpensesDefaultCurrency decimal (38, 3)
ForPaymentParentCurrency decimal (38, 6)
ForPaymentDefaultCurrency decimal (38, 6)
ValidUntil datetime
EffectiveFrom datetime
TaxableSupplyDate datetime
AccountingCaseDate datetime
IsProjectCartType int

dbo.vw_LastWeekCapacityAssignment

View returns all active users and there last assignment in Caplan - used for reporrt

Object ID: 1220199397; Created: August 01, 2008, 10:55:40; Modified: March 06, 2013, 11:24:09
Name Type NULL Comment
USERNAME nvarchar (256)
ACTIVE bit
LastWeek int
Year int

dbo.vw_MonthlyTotals

Total worked hours per month by user - used for counting costs from month salary (hour rate is month salary / monthly hours).

Object ID: 1957582012; Created: May 18, 2008, 17:47:38; Modified: March 06, 2013, 11:24:10
Name Type NULL Comment
TotalDuration float (53, 0)
ItemGUID uniqueidentifier
period int

dbo.vw_MonthlyTotals_Projects

Object ID: 720721620; Created: September 05, 2008, 13:39:03; Modified: March 06, 2013, 11:24:09
Name Type NULL Comment
TotalDuration float (53, 0)
ProjectName nvarchar (256)
Period int

dbo.vw_Notes_Attendance_x_Project

Used in Leads report for searching project start date from Journal and Work reports.

Object ID: 1719677174; Created: June 25, 2008, 13:50:44; Modified: March 06, 2013, 11:24:10
Name Type NULL Comment
ProjectGUID uniqueidentifier
Type nvarchar (61)
Start datetime
Subject nvarchar (4000)
Duration float (53, 0)
UserFullName nvarchar (256)

dbo.vw_NotifyAboutTasks

Object ID: 389888756; Created: January 29, 2015, 21:58:17
Name Type NULL Comment
ItemGUID uniqueidentifier

dbo.vw_NotifyTeamAboutNewDocumentInProject

Object ID: 497436846; Created: February 22, 2013, 08:09:27; Modified: March 06, 2013, 11:24:09
Name Type NULL Comment
ItemGUID uniqueidentifier

dbo.vw_NotifyTeamAboutNewEmailInProject

Object ID: 465436732; Created: February 22, 2013, 08:09:27; Modified: March 06, 2013, 11:24:09
Name Type NULL Comment
ItemGUID uniqueidentifier

dbo.vw_NotifyTeamAboutNewJournalInProject

Object ID: 2084918499; Created: January 24, 2013, 15:08:14; Modified: March 06, 2013, 11:24:10
Name Type NULL Comment
ItemGUID uniqueidentifier

dbo.vw_NotifyUsersAboutNewDocumentInCompany

Object ID: 579533148; Created: June 07, 2013, 21:07:45
Name Type NULL Comment
ItemGUID uniqueidentifier

dbo.vw_NotifyUsersAboutNewDocumentInContact

Object ID: 595533205; Created: June 07, 2013, 21:07:45
Name Type NULL Comment
ItemGUID uniqueidentifier

dbo.vw_NotifyUsersAboutNewDocumentInLead

Object ID: 433436618; Created: February 22, 2013, 08:09:27; Modified: March 06, 2013, 11:24:09
Name Type NULL Comment
ItemGUID uniqueidentifier

dbo.vw_NotifyUsersAboutNewEmailInCompany

Object ID: 1737109279; Created: July 01, 2013, 21:07:58
Name Type NULL Comment
ItemGUID uniqueidentifier

dbo.vw_NotifyUsersAboutNewEmailInContact

Object ID: 1753109336; Created: July 01, 2013, 21:07:58
Name Type NULL Comment
ItemGUID uniqueidentifier

dbo.vw_NotifyUsersAboutNewEmailInLead

Object ID: 401436504; Created: February 22, 2013, 08:09:26; Modified: March 06, 2013, 11:24:09
Name Type NULL Comment
ItemGUID uniqueidentifier

dbo.vw_NotifyUsersAboutNewJournalInCompany

Object ID: 547533034; Created: June 07, 2013, 21:07:45
Name Type NULL Comment
ItemGUID uniqueidentifier

dbo.vw_NotifyUsersAboutNewJournalInContact

Object ID: 563533091; Created: June 07, 2013, 21:07:45
Name Type NULL Comment
ItemGUID uniqueidentifier

dbo.vw_NotifyUsersAboutNewJournalInLead

Object ID: 2100918556; Created: January 24, 2013, 15:08:14; Modified: March 06, 2013, 11:24:10
Name Type NULL Comment
ItemGUID uniqueidentifier

dbo.vw_Project_Starts_FromStatusChange

Used in Leads report for searching project first status change.

Object ID: 1687677060; Created: June 25, 2008, 13:41:56; Modified: March 06, 2013, 11:24:10
Name Type NULL Comment
ItemCreated datetime
ItemGUID uniqueidentifier
ProjectGUID uniqueidentifier
ProjectName nvarchar (256)

dbo.vw_ProjectDeadlineAlerts

Object ID: 1788181766; Created: March 24, 2015, 21:32:23
Name Type NULL Comment
ItemGUID uniqueidentifier
En nvarchar (50)
ProjectsTypeFileAs nvarchar (256)
Cs nvarchar (50)
FileAs nvarchar (256)
DayCount nvarchar (256)

dbo.vw_ProjectDeadlineEmails

Object ID: 1820181880; Created: March 24, 2015, 21:32:23
Name Type NULL Comment
ProjectGUID uniqueidentifier
HID int
ProjectName nvarchar (256)
ProjectType nvarchar (50)
ProjectState nvarchar (50)
ProjectEnd datetime
DaysToEnd int
Price decimal (18, 2)
Currency uniqueidentifier
EmailAddresses nvarchar (max)
PMGUID uniqueidentifier
PMName nvarchar (256)

dbo.vw_ProjectManagers

List of PM, used in reports.

Object ID: 130099504; Created: May 18, 2008, 17:47:40; Modified: March 06, 2013, 11:24:09
Name Type NULL Comment
UserGUID uniqueidentifier
ProjectName nvarchar (256)
RelationType nvarchar (256)
ProjectGUID uniqueidentifier
UserName nvarchar (50)
UserFullName nvarchar (514)

dbo.vw_ProjectsEnds

Object ID: 1804181823; Created: March 24, 2015, 21:32:23
Name Type NULL Comment
ProjectGUID uniqueidentifier
ProjectName nvarchar (256)
HID int
ProjectType nvarchar (50)
ProjectsTypeFileAs nvarchar (256)
ProjectTypeFileAs nvarchar (256)
ProjectState nvarchar (50)
ProjectStateFileAs nvarchar (256)
ProjectEnd datetime
DaysToEnd int
Price decimal (18, 2)
Currency uniqueidentifier

dbo.vw_ProjectTotals

Sum of costs per project - used in reports.

Object ID: 1735677231; Created: June 25, 2008, 13:52:48; Modified: March 06, 2013, 11:24:10
Name Type NULL Comment
ProjectGUID uniqueidentifier
TotalRate numeric (38, 2)
TotalDuration float (53, 0)
Costs float (53, 0)

dbo.vw_RandomNumber

Object ID: 584441206; Created: August 02, 2013, 10:07:50
Name Type NULL Comment
RandomNumber float (53, 0)

dbo.vw_UnifiedRelations

Object ID: 995951070; Created: May 20, 2016, 22:18:30
Name Type NULL Comment
RelationDataGUID uniqueidentifier
ItemGUID_A uniqueidentifier
ItemGUID_B uniqueidentifier
IsOriented bit
ObjectTypeID_A tinyint
ObjectTypeID_B tinyint
RelationType varchar (48)

dbo.vw_WorkReportRateTypes

Object ID: 1999554407; Created: May 26, 2014, 12:27:18
Name Type NULL Comment
enName nvarchar (50)
csName nvarchar (50)
EnumValueRateGUID uniqueidentifier
RateCoefficient numeric (2, 1)
IsFix int

dbo.CaPlan_RemoveProjectAssignments

CaPlan - remove (or display) project assignment for user for week for project.

Object ID: 2021582240; Created: May 18, 2008, 17:47:39; Modified: March 06, 2013, 11:24:10
Name Type Default Comment
@UserName nvarchar (50)
@ProjectName nvarchar (256)
@Year int
@WeekNumber int
@Action nvarchar (50)

dbo.eWaySP_ActivateMobileAccessForLastLoggedUsers

Enables the mobile access flag for the last logged N users excluding admin and wa agent.

dbo.eWaySP_AddCategoriesToItem

Adds the specified categories to the item. Categories are given by name in one string joined by specified delimiter. The default delimiter is comma ','. Raises error if unknown category name is detected.

Object ID: 500157523; Created: March 29, 2018, 10:21:47
Name Type Default Comment
@ItemGUID uniqueidentifier Identified of the item that should be categorized.
@ItemFolderName nvarchar (256) Folder name the item belongs to.
@GroupsList nvarchar (max) String of group names separated by delimiter.
@Delimiter char (1) Delimiter used in the @GroupList parameter to separate the group names. Default delimiter is comma ','.
@PreserveExistingCategories bit While being 1 preserves existing categories. Default value is 1.

dbo.eWaySP_AddEmailToProject

Connect email to project with GENERAL relation when is email connected to completed lead.

Object ID: 1283236072; Created: February 23, 2016, 22:10:43
Name Type Default Comment
@EmailGUID uniqueidentifier GUID of email.
@LeadGUID uniqueidentifier GUID of lead.

dbo.eWaySP_AddProcedureIntoJobQueue

Add procedure into job queue with parameters as text.

Object ID: 2015710629; Created: September 17, 2015, 22:07:13
Name Type Default Comment
@ProcedureName varchar (256) Name of the procedure to execute.
@Parameters nvarchar (max) Parameters of procedure as text.

dbo.eWaySP_AddProcedureIntoJobQueueWithNamedParameters

Add procedure into job queue with parameters as text.

Object ID: 1237279863; Created: October 12, 2015, 22:10:37
Name Type Default Comment
@ProcedureName varchar (256) Name of the procedure to execute.
@Parameter1Name nvarchar (256) Name of the procedure parameter for 1st pair name-value. It has to start with @.
@Parameter1Value sql_variant Value of the procedure parameter for 1st pair name-value.
@Parameter2Name nvarchar (256)
@Parameter2Value sql_variant
@Parameter3Name nvarchar (256)
@Parameter3Value sql_variant
@Parameter4Name nvarchar (256)
@Parameter4Value sql_variant
@Parameter5Name nvarchar (256)
@Parameter5Value sql_variant
@Parameter6Name nvarchar (256)
@Parameter6Value sql_variant
@Parameter7Name nvarchar (256)
@Parameter7Value sql_variant
@Parameter8Name nvarchar (256)
@Parameter8Value sql_variant
@Parameter9Name nvarchar (256)
@Parameter9Value sql_variant

dbo.eWaySP_AlterDatabaseRemoveFilesLimits

Removes the MDF and MDF files limitation since the DB limits will be maintained by Licensing Server and the WS itself.

dbo.eWaySP_ApproveAvailableVersion

Signs the new version as approved. Raises error if the current version is different than the approved one.

Object ID: 152699942; Created: March 24, 2015, 21:32:27
Name Type Default Comment
@AvailableWebServiceVersion nvarchar (20) Web service version to be approved.
@AvailableOutlookClientVersion nvarchar (20) Outlook client version to be approved.

dbo.eWaySP_AssingUserTeamRole

Assigns a team role to a user on a specified project.

Object ID: 807634616; Created: March 22, 2018, 21:27:02
Name Type Default Comment
@UserGUID uniqueidentifier GUID of the user.
@ProjectGUID uniqueidentifier GUID of the project.
@TeamRoleName nvarchar (256) Name of the role.
@GroupGUID uniqueidentifier GUID of the role.

dbo.eWaySP_AutoAssignCompanyToContactActivity

Object ID: 87579996; Created: November 16, 2017, 09:11:48
Name Type Default Comment
@ActivityGUID uniqueidentifier
@ActivityOT int
@ContactGUID uniqueidentifier

dbo.eWaySP_AutoAssignLeadEmailToContactPerson

Object ID: 695634217; Created: March 22, 2018, 21:27:00
Name Type Default Comment
@EmailGUID uniqueidentifier
@LeadGUID uniqueidentifier

dbo.eWaySP_AutomaticJournalCityFiller_SuperiorItemChanged

Object ID: 465644952; Created: June 11, 2014, 21:46:08
Name Type Default Comment
@SuperiorItemFolderName nvarchar (256)
@SuperiorItemGUID uniqueidentifier
@City nvarchar (256)
@PreviousCity nvarchar (256)

dbo.eWaySP_AutomaticLeadProbabilityFiller

Object ID: 1680021762; Created: July 12, 2018, 20:23:42
Name Type Default Comment
@LeadGUID uniqueidentifier
@StateGUID uniqueidentifier
@PrevStateGUID uniqueidentifier

dbo.eWaySP_AutomaticUserLoginAndActivityTimeTracking

Track user's login time and last activity time from table Sessions to table Users.

dbo.eWaySP_BackupDatabase

Creates FULL backup of the database on the end of the week and DIFF backups on the other days.

dbo.eWaySP_CalculateLeadsEstimatedValue

dbo.eWaySP_CalculateLeadsPrices

Object ID: 437433178; Created: May 08, 2017, 22:37:51
Name Type Default Comment
@CartGUID uniqueidentifier
@LeadGUID uniqueidentifier

dbo.eWaySP_CalculateLeadsPrices_JOB

dbo.eWaySP_CalculateProjectEstimatedWorkHours

Object ID: 1480912893; Created: May 01, 2017, 22:25:03
Name Type Default Comment
@ProjectAssignmentGUID uniqueidentifier
@ProjectGUID uniqueidentifier

dbo.eWaySP_CalculateProjectEstimatedWorkHours_JOB

Fills EstimatedWorkHours on all projects.

dbo.eWaySP_CalculateProjectsPrices

Object ID: 516157580; Created: March 29, 2018, 10:21:47
Name Type Default Comment
@CartGUID uniqueidentifier
@WorkReportGUID uniqueidentifier
@LeadGUID uniqueidentifier
@ProjectGUID uniqueidentifier
@BonusGUID uniqueidentifier

dbo.eWaySP_CalculateProjectsPrices_JOB

dbo.eWaySP_CalculateProjectsPricesAfterWorkReportsChanged

Insert execution of procedure eWaySP_CalculateProjectPrices into EWD_QueuedJobs.

Object ID: 1109279407; Created: October 12, 2015, 22:10:35
Name Type Default Comment
@WorkReportGUID uniqueidentifier Guid of work report for recalculation.
@ProjectGUID uniqueidentifier
@LeadGUID uniqueidentifier

dbo.eWaySP_CalculateRates

Recalculate rates on work reports with respect to global settings 'IncludeEntireFixRateInWorkReports' for fix rate.

Object ID: 1118743884; Created: July 10, 2019, 21:34:04
Name Type Default Comment
@DaysBack int Days to back for backward calculation.
@UserName nvarchar (256) UserName of user that is related to work reports.
@WorkReportGUID uniqueidentifier Guid of WorkReports item.
@StartDate datetime WorkReports are recalulated from @StartDate date.
@EndDate datetime WorkReports are recalulated to @EndDate date.

dbo.eWaySP_CalculateRates_Last2Months

dbo.eWaySP_CalculateRates_User

Object ID: 1726069335; Created: March 04, 2014, 21:38:23
Name Type Default Comment
@DaysBack int
@UserGUID uniqueidentifier

dbo.eWaySP_Cart_RecalculatePrices

dbo.eWaySP_Cart_SetID

dbo.eWaySP_CategorizeItem

Object ID: 1209771367; Created: September 09, 2010, 13:42:28; Modified: March 06, 2013, 11:24:09
Name Type Default Comment
@ItemGUID uniqueidentifier
@UserGUID uniqueidentifier
@FolderName nvarchar (256)

dbo.eWaySP_CategorizeItemByRelatedCompany

Categorize items by related company.

Object ID: 75771973; Created: January 04, 2018, 22:40:50
Name Type Default Comment
@CompanyGUID uniqueidentifier Guid of source company.
@ItemGUID uniqueidentifier Guid of target item for category copying.
@ItemObjectType int Object type of target item.

dbo.eWaySP_ClearDatabase

dbo.eWaySP_ClearForeignKeysFromFolderItems

Object ID: 978818549; Created: November 26, 2012, 12:41:36; Modified: March 06, 2013, 11:24:09
Name Type Default Comment
@ItemGUID uniqueidentifier
@UserGUID uniqueidentifier
@FolderName nvarchar (256)
@ColumnName nvarchar (256)

dbo.eWaySP_CloseSession

WS, clearing the session.

dbo.eWaySP_Companies_CalculateCompaniesReversals

dbo.eWaySP_Companies_CalculateDebts

dbo.eWaySP_ConvertLeadToCompanyProjectContact

Porceeds the fully automatic conversion of the Lead into Company, Project and Contact entities. This procedure was originally created for the automatic Trial/Free Lead buying purposes.

Object ID: 312400928; Created: November 07, 2018, 20:16:30
Name Type Default Comment
@LeadItemGUID uniqueidentifier ItemGUID of the Lead that has to be converted.
@CreateCompany bit Determines whether the Company record has to be created.
@CreateContact bit Determines whether the Contact record has to be created.
@CreateProject bit Determines whether the Project record has to be created.
@CopyAddtionalFieldsToNewCompany bit Determines whether the additional field values have to be copied into the Company record.
@CopyAddtionalFieldsToNewContact bit Determines whether the additional field values have to be copied into the Contact record.
@CopyAddtionalFieldsToNewProject bit Determines whether the additional field values have to be copied into the Project record.
@UserGUID uniqueidentifier The user that will be responsible for all the chages made by this procedure..
@CompanyItemGUID uniqueidentifier
@ContactItemGUID uniqueidentifier
@ProjectItemGUID uniqueidentifier

dbo.eWaySP_CopyAddtionalFieldsData

Copies the additional fields' values from the source folder record to the associated target folder record.

Object ID: 71579939; Created: November 16, 2017, 09:11:48
Name Type Default Comment
@SourceObjectTypeID int Copied source object type/folder.
@TargetObjectTypeID int Copying target object type/folder.
@SourceItemGUID uniqueidentifier Copied source item identifier.
@TargetItemGUID uniqueidentifier Copying target item identifier.
@UserGUID uniqueidentifier Responsible user item identifier.

dbo.eWaySP_CopyComboBoxValueToTextBox

Copy additional field combox value to additional field textbox on given module and item.

Object ID: 2076182792; Created: March 24, 2015, 21:32:25
Name Type Default Comment
@ItemGUID uniqueidentifier Guid of item.
@FolderName nvarchar (256) FolderName of item.
@ComboBoxAdditionalField varchar (10) Name of af column type of combobox (1) eg. af_86
@TextBoxAdditionalField varchar (10) Name of af column type of textbox (0) eg. af_86
@LanguageCode nvarchar (256) Column of EnumValues that is source for textbox value. Default is en.

dbo.eWaySP_CopyUserViewToOtherUsers

Copy user's view used in grid for another users. Does not update existing views, but is possible overwrite this default behaviour.

Object ID: 518097432; Created: January 09, 2017, 22:25:52
Name Type Default Comment
@ViewName nvarchar (255) Nasme of view to copy
@ModuleName nvarchar (255) Module name of given view
@FromUserName nvarchar (256) Name of user that is owner of the view to copy
@ToUserNames nvarchar (1000) Usernames of users that will have the copy of view
@OverwriteTargetView bit Overwrite existing by "To" user
@FromUserGUID uniqueidentifier Guid of user that is owner of the view to copy
@ToUserGUID uniqueidentifier Guid of user that will have the copy of view

dbo.eWaySP_CorrectIndividualDiscountPrice

Object ID: 300072355; Created: May 26, 2014, 12:27:22
Name Type Default Comment
@GoodItemGUID uniqueidentifier
@SalePrice decimal (18, 3)
@PreviousSalePrice decimal (18, 3)
@CurrencyGUID uniqueidentifier
@PreviousCurrencyGUID uniqueidentifier
@ModifiedByGUID uniqueidentifier

dbo.eWaySP_CreateAdditionalField

Creates additional field column.

Object ID: 1150743998; Created: July 10, 2019, 21:34:04
Name Type Default Comment
@FieldID int Additional field ID.
@FieldType int Additional field type.
@ObjectTypeID tinyint Additional field object type ID.

dbo.eWaySP_CreateAttachmentCopy

Creates document copy.

Object ID: 577241657; Created: February 28, 2017, 22:19:19
Name Type Default Comment
@SourceItemGUID uniqueidentifier Source document GUID.
@SourceRevision int Source document revision.
@DestinationItemGUID uniqueidentifier Destination document GUID.
@UserGUID uniqueidentifier GUID of the user.

dbo.eWaySP_CreateCalendar

Creates Calendar item with relations. Subject is generated from given subject and superior item information.

Object ID: 184400472; Created: November 07, 2018, 20:16:28
Name Type Default Comment
@Subject nvarchar (256) Calendar subject.
@OwnerGUID uniqueidentifier Calendar owner unique identifier. Gets Admin unique identifier if supplied value is null.
@SuperiorItemGUID uniqueidentifier Calendar superior item unique identifier.
@SuperiorItemFolder nvarchar (256) Calendar superior item folder name.
@CalendarGUID uniqueidentifier Calendar unique identifier. Generates new unique identifier if supplied value is null.
@Location nvarchar (256) Calendar appointment location.
@StartDate datetime Calendar start date. Gets actual date and time if supplied value is null.
@EndDate datetime Calendar end date. Gets actual date and time if supplied value is null.
@AllDayEvent bit Value indicating whether is calendar all day event.
@Note nvarchar (max) Calendar body.
@Sensitivity int Calendar sensitivity.
@BusyStatus int Calendar busy status.

dbo.eWaySP_CreateCategoriesFromList

Object ID: 932302481; Created: December 16, 2013, 21:25:11
Name Type Default Comment
@CatgoriesList nvarchar (max)
@Delimiter char (1)

dbo.eWaySP_CreateCategory

Creates new category group

Object ID: 909714789; Created: September 08, 2016, 22:16:39
Name Type Default Comment
@GUID uniqueidentifier Guid of the group
@GroupName nvarchar (256) Name of the group.
@Description nvarchar (256) Description of the group.
@UserGUID uniqueidentifier Guid of author.

dbo.eWaySP_CreateClrProcedures

Creates CLR procedures.

dbo.eWaySP_CreateCurrencyExchangeRate

Create currency exchange rate

Object ID: 1492004892; Created: December 02, 2016, 22:21:19
Name Type Default Comment
@From datetime Date from
@To datetime Date to
@InputCurrency varchar (3) Input currency
@OutputCurrency varchar (3) Output currency
@Rate float (53, 0) Rate

dbo.eWaySP_CreateFileSystemAttachmentCopy

Object ID: 283264910; Created: July 12, 2019, 13:16:41
Name Type Default Comment
@SourceItemGUID uniqueidentifier
@SourceRevision int
@DestinationItemGUID uniqueidentifier

dbo.eWaySP_CreateJournalEntry

Creates journal entry.

Object ID: 1936022674; Created: July 12, 2018, 20:23:45
Name Type Default Comment
@ItemGUID uniqueidentifier Guid of related item.
@UserGUID uniqueidentifier Guid of author of modification.
@ObjectType tinyint TINYINT type of related item.
@FileAs nvarchar (256) FileAS for new journal entry.
@NewValue nvarchar (256) New value as NVARCHAR(256) if some field was changed.
@OldValue nvarchar (256) Old value as NVARCHAR(256) if some field was changed.
@IsSystem bit Mark journal as system journal.
@ChangedField nvarchar (256) Name for field with @OldValue and @NewValue.
@Note nvarchar (max) Note for new journal entry.
@TypeEn uniqueidentifier Type of new journal entry.
@ImportanceEn uniqueidentifier Importance for new journal entry.
@EventStart datetime Event start for new journal entry.
@EventEnd datetime Event end for new journal entry.
@NewJournalGUID uniqueidentifier GUID of new journal entry as OUTPUT parameter.

dbo.eWaySP_CreateMissingRelationItems

Creates missing relation side.

dbo.eWaySP_CreateNewTaskOccurrence

Creates new occurrence of recurring task.

Object ID: 1054743656; Created: July 10, 2019, 21:34:03
Name Type Default Comment
@TaskGUID uniqueidentifier Recurring task unique identifier.
@ModifiedByGUID uniqueidentifier Unique identifier of user who completed task.

dbo.eWaySP_CreateNotifyActivityEmailText

Create email body for activity email notification.

Object ID: 1432912722; Created: May 01, 2017, 22:24:59
Name Type Default Comment
@NewItemFolderName nvarchar (50) Folder name of new activity item.
@NewItemId uniqueidentifier Guid of new activity item.
@ParentFolderName nvarchar (50) Folder name of parent item.
@ParentItemId uniqueidentifier Guid of parent item.
@Text nvarchar (max) Output text.

dbo.eWaySP_CreateProjectTeamMember

Object ID: 823634673; Created: March 22, 2018, 21:27:02
Name Type Default Comment
@ProjectGUID uniqueidentifier
@UserGUID uniqueidentifier
@RoleGUID uniqueidentifier

dbo.eWaySP_CreateRelation

Create new relation in the system.

Object ID: 1028927483; Created: November 17, 2018, 07:52:27
Name Type Default Comment
@ItemGUID1 uniqueidentifier GUID of the parent item (eg. Project).
@FolderName1 varchar (50) Folder name of the parent item.
@ItemGUID2 uniqueidentifier GUID of the child item (eg. Document).
@FolderName2 varchar (50) Folder name of the child item.
@RelationType varchar (256) Type of the relation.
@SetDirection bit 1 for 1:N relation otherwise 0.
@UserGUID uniqueidentifier GUID of the user who creates the relation.
@DeleteGeneralRelation bit When creating 1:N relation the GENERAL relation will be removed when the parameter is set to 1.

dbo.eWaySP_CreateRelations

Create new relation in the system.

Object ID: 1012927426; Created: November 17, 2018, 07:52:27
Name Type Default Comment
@pGUID_Admin uniqueidentifier GUID of the user who creates the relation. Admin GUID is used by default.
@pGUID_Item1 uniqueidentifier GUID of the parent item (eg. Project).
@pOT_Item1 tinyint ObjectTypeID of the parent item.
@pGUID_Item2 uniqueidentifier GUID of the child item (eg. Document).
@pOT_Item2 tinyint ObjectTypeID of the child item.
@pRelationType nvarchar (256) Type of the relation.
@pOT_RelData tinyint Deprecated. ObjectTypeID of the table RelationData.
@pOT_ObjRel tinyint Deprecated. ObjectTypeID of the table Relations.
@pSetDirection bit 1 for 1:N relation otherwise 0.
@pRelationDataGUID uniqueidentifier GUID of the RelationData used to create the relation.
@pDeleteGeneralRelation bit When creating 1:N relation the GENERAL relation will be removed when the parameter is set to 1.

dbo.eWaySP_CreateRelationsInBatch

Create relations specified by parameters. Procedure process data in temp table #CreateRelationsInBatch.

Object ID: 1997822775; Created: August 31, 2017, 22:57:09
Name Type Default Comment
@ParentFolderName nvarchar (256) FolderName of parent module (for relation with direction = 0 does not matter what is parent and child module).
@ChildFolderName nvarchar (256) FolderName of child module.
@RelationType nvarchar (256) RelationType eg. GENERAL.
@SetDirection bit Determines whether relation is oriented.
@CleanSourceData bit Clean temp table #CreateRelationsInBatch at the end of procedure? Does not matter if procedure failed or run successfully.
@DateTimeOfImport datetime This value is used for ...Created/Changed columns in created records.
@UserGUID uniqueidentifier This value is used for ...CreatedBy/ModifiedBy/OwnerGUID columns in records.
@Verbose bit Print counts of inserted rows in touched tables.
@DisableDBTriggers bit Disables database triggers on EWR_ObjectRelations table.

dbo.eWaySP_CreateRelationToChangedOwner

Object ID: 152400358; Created: November 07, 2018, 20:16:27
Name Type Default Comment
@ItemGUID uniqueidentifier
@OwnerGUID uniqueidentifier
@OwnerGUID_Previous uniqueidentifier
@FolderName nvarchar (50)

dbo.eWaySP_CreateRevisionHistoryLog

Object ID: 962818492; Created: November 26, 2012, 12:41:36; Modified: March 06, 2013, 11:24:09
Name Type Default Comment
@DocumentGUID uniqueidentifier
@Revision int
@CreatedByGUID uniqueidentifier
@FileAs nvarchar (256)
@FileSize bigint
@FileCreationTime datetime
@FileLastWriteTime datetime

dbo.eWaySP_CreateSession

Creates new session.

Object ID: 407685246; Created: September 07, 2018, 20:41:41
Name Type Default Comment
@UserGUID uniqueidentifier GUID of the logged user.
@ClientVersion nvarchar (50) Name and version of the client application.
@UserHostAddress varchar (45) IP host address of the remote client.
@UserHostId varchar (50) Unique identification of the remote client.
@Success bit Value indicating whether was log in successful.
@CommunicatedUserHostAddress varchar (45) IP host address which the client claims to be using (created for WCF IP retransmitting).
@UserHostName nvarchar (50) Name of the host.
@TimeZone nvarchar (32) Time zone identifier of the client.

dbo.eWaySP_CreateTask

Creates Task item with relations. Subject is generated from given subject and superior item information.

Object ID: 168400415; Created: November 07, 2018, 20:16:27
Name Type Default Comment
@TaskSubject nvarchar (256) Task subject.
@DelegatorGUID uniqueidentifier Task delegator unique identifier.
@SolverGUID uniqueidentifier Task solver unique identifier.
@SuperiorItemGUID uniqueidentifier Task superior item unique identifier.
@SuperiorItemFolder nvarchar (256) Task superior item folder name.
@TaskGUID uniqueidentifier Task unique identifier. Generates new unique identifier if supplied value is null.
@OwnerGUID uniqueidentifier Task owner unique identifier. Uses Delegator unique identifier if supplied value is null.
@DueDate datetime Task due date. Gets actual date and time if supplied value is null.
@StartDate datetime Task start date. Gets actual date and time if supplied value is null.
@TaskBody nvarchar (max) Task body.
@Complete bit Task complete.
@Importance int Task importance - obsolete.
@PercentComplete int Task completion in percentage - obsolete.
@Status int Task status.
@Level int Task level.
@RTFBody ntext Task rich text formated body.
@ImportanceGUID uniqueidentifier Task importance.
@PercentCompleteDecimal decimal (5, 4) Task completion in percentage.
@TypeGUID uniqueidentifier Task type identifier.
@CompanyGUID uniqueidentifier Task related Company identifier.
@ContactGUID uniqueidentifier Task related Contact identifier.
@ReminderDate datetime Task reminder date and time.

dbo.eWaySP_CreateWorkFlowHistoryForItem

Create workflow history item in EWF_History, check states in workflow and referenced item.

Object ID: 2092182849; Created: March 24, 2015, 21:32:25
Name Type Default Comment
@ItemGUID uniqueidentifier Guid of item with state change.
@ItemFolder nvarchar (256) Folder name of item with state change.
@PrevStateEn uniqueidentifier Previous state guid.
@NewStateEn uniqueidentifier New state guid.

dbo.eWaySP_CreateWorkflowModel

Object ID: 1092459216; Created: December 10, 2014, 15:07:19
Name Type Default Comment
@ModelEnumTypeName nvarchar (256)
@ModelParentType uniqueidentifier
@ModelEnumType uniqueidentifier
@Model uniqueidentifier

dbo.eWaySP_DeactivateAccessForEarliestLoggedUsers

Disables the (OA|MA|WA) mobile access flag for the earliest logged users excluding admin, wa agent and the deactivated users.

Object ID: 15299810; Created: May 18, 2018, 20:38:09
Name Type Default Comment
@Count int Number of allowed X-access users.
@AccessType nchar (2) Type of access: OA/MA/WA.

dbo.eWaySP_DefragmentIndexes

dbo.eWaySP_DeleteCart

dbo.eWaySP_DeleteDocument

Delete document with all it's revisions.

dbo.eWaySP_DeleteDuplicatedRelations

Delete duplicated 1 to N relations.

dbo.eWaySP_DeleteGoodsItemFromGoodsInSet

dbo.eWaySP_DeleteIndividualDiscounts

Object ID: 440440693; Created: August 02, 2013, 10:07:48
Name Type Default Comment
@CompanyGUID uniqueidentifier
@GoodsGUID uniqueidentifier

dbo.eWaySP_DeleteItem

Delete eWay item from database with related relations.

Object ID: 951635129; Created: March 22, 2018, 21:27:04
Name Type Default Comment
@ItemGUID uniqueidentifier Guid of item to delete.
@ItemOT tinyint Object type ID of item to delete.
@ItemFolderName nvarchar (50) Folder name of item to delete.
@UseItemChanges bit For insert row into EWD_ItemChanges for delete set to 1 (default is 1).
@ModifiedByGUID uniqueidentifier Guid of user that deleted item.
@FileAs nvarchar (1280) File as for row in EWD_ItemChanges.
@ItemVersion int ItemVersion for row in EWD_ItemChanges.
@FolderName nvarchar (50) The same meaning as @ItemFolderName, but this parameter has better name for common development.

dbo.eWaySP_DeleteMarketing

Deletes whole marketing campaign.

dbo.eWaySP_DeleteOldItemChanges

Deletes old items in the EWD_ItemChanges table.

dbo.eWaySP_DeleteParentTask

dbo.eWaySP_DeleteRelations

Object ID: 996927369; Created: November 17, 2018, 07:52:27
Name Type Default Comment
@RelationDataGUID uniqueidentifier
@UseItemChanges bit
@ModifiedByGUID uniqueidentifier

dbo.eWaySP_DeleteSystemJournal

dbo.eWaySP_DeleteUser

Delete user and all relations on them.

dbo.eWaySP_DeleteUserView

Delete all records related to given UserView.

Object ID: 1888022503; Created: July 12, 2018, 20:23:44
Name Type Default Comment
@UserGUID uniqueidentifier ItemGUID of user.
@ViewName nvarchar (255) Name of deleted UserView.
@FolderName nvarchar (255) Name of module.

dbo.eWaySP_DeleteWebAccessSettings

Removes all rows in WebAccess2Options for the given user.

dbo.eWaySP_DeleteWorkflowHistory

Deletes workflow history records of an item. Used when changing type.

Object ID: 1230692228; Created: January 25, 2019, 20:59:01
Name Type Default Comment
@SubjectItemGUID uniqueidentifier ItemGUID of the item whose workflow history has to be cleared.
@ModyfiedByGUID uniqueidentifier User guid who made the change.

dbo.eWaySP_DropAdditionalFieldColumn

Object ID: 900302367; Created: December 16, 2013, 21:25:10
Name Type Default Comment
@ObjectTypeID int
@FieldID smallint

dbo.eWaySP_DropDefaultConstraint

Object ID: 935010412; Created: May 01, 2013, 21:47:27
Name Type Default Comment
@TableName nvarchar (128)
@ColumnName nvarchar (128)

dbo.eWaySP_DuplicateXsltTransformationToOtherLanguages

Duplicate template for xsl transformation from given language to other languages.

Object ID: 1310692513; Created: January 25, 2019, 20:59:02
Name Type Default Comment
@Name nvarchar (256) Name of the source tamplate to copy.
@LangCode varchar (2) Language code of source template to copy.
@FolderName nvarchar (256) Folder name of source template to copy.
@ForceRewrite bit

dbo.eWaySP_EnumValues_InsertAndGetEnumValue

Creates new enum value.

Object ID: 1512913007; Created: May 01, 2017, 22:25:03
Name Type Default Comment
@EnumValueGUID uniqueidentifier GUID of the new enum value.
@EnumTypeName nvarchar (256) Name of the enumeration in which the value will be created.
@en nvarchar (256) English translation.
@cs nvarchar (256) Czech translation.
@FileAs nvarchar (256) Enum value name.
@de nvarchar (256) German translation.
@ru nvarchar (256) Russian translation.
@sk nvarchar (256) Slovakian translation.
@no nvarchar (256) Norwegian translation.
@checkDuplicity bit Check duplicity.

dbo.eWaySP_EnumValues_KeepEntryUnique

Object ID: 1988462408; Created: December 10, 2014, 15:07:22
Name Type Default Comment
@ItemGUID uniqueidentifier
@EnumType uniqueidentifier
@NewRank int
@NewFileAs nvarchar (256)

dbo.eWaySP_eWaySystem_SendUserAccountLockedNotification

dbo.eWaySP_ExecuteUrl

Executes specified URL and returns HTTP status code.

dbo.eWaySP_FillDayTypeEn

Object ID: 1059235274; Created: February 23, 2016, 22:10:40
Name Type Default Comment
@WorkReportGUID uniqueidentifier
@UserGUID uniqueidentifier

dbo.eWaySP_FillDirection

Object ID: 1920725895; Created: March 23, 2010, 08:35:00; Modified: March 06, 2013, 11:24:10
Name Type Default Comment
@RelationType nvarchar (256)
@Modul nvarchar (256)

dbo.eWaySP_FillLastActivityAndNextStepFields

Fill Last Activity and Next Step fields on Lead, Project, Company and Contact.

Object ID: 1060927597; Created: November 17, 2018, 07:52:28
Name Type Default Comment
@ItemGUID uniqueidentifier ItemGUID of the item.
@FolderName nvarchar (256) FolderName of the item (Leads, Projects, Companies and Contacts).
@ModifiedByGUID uniqueidentifier ItemGUID of the user who is making the changes.

dbo.eWaySP_FillLastActivityAndNextStepFields_JOB

Fills Last Activity and Next Step fields on all items.

dbo.eWaySP_FillLastActivityAndNextStepFieldsAfterActivityChanged

Updates Last Activity and Next Step fields on parent objects when activity is changed.

Object ID: 529241486; Created: February 28, 2017, 22:19:18
Name Type Default Comment
@ActivityGUID uniqueidentifier ItemGUID of the updated activity.
@ModifiedByGUID uniqueidentifier ItemGUID of the user who has updated the activity.

dbo.eWaySP_FixAdditionalFieldsRank

Fixes rank of the additional fields.

Object ID: 1668005519; Created: December 02, 2016, 22:21:23
Name Type Default Comment
@ObjectTypeID int ObjectTypeID of the module which additional fields should be fixed.
@ModifiedByGUID uniqueidentifier GUID of the user who is making the change.

dbo.eWaySP_FixEmailsMultipleBlankLines

Fixes multiple blank lines in emails note.

dbo.eWaySP_FixNormalizedPhoneNumberColumns

Checks and fixes all normalized phone number columns in database.

dbo.eWaySP_FixRelationDirection

Object ID: 964302595; Created: December 16, 2013, 21:25:12
Name Type Default Comment
@FolderName1 varchar (256)
@FolderName2 varchar (256)
@RelationType varchar (256)
@NewDirection int

dbo.eWaySP_FixTeamSupervisorRelations

Fixed SUPERVISOR relations based on the TeamRoles.

dbo.eWaySP_Forex_SyncGoods

dbo.eWaySP_GetActiveUserCountWithFilterOnProductsAndExcludeOneUser

Object ID: 1508004949; Created: December 02, 2016, 22:21:19
Name Type Default Comment
@ExcludingUser uniqueidentifier
@OutlookAccessActive bit
@WebAccessActive bit
@MobileAccessActive bit

dbo.eWaySP_GetAdditionalFieldValue

Object ID: 1284459900; Created: December 10, 2014, 15:07:20
Name Type Default Comment
@ItemGUID uniqueidentifier
@FolderName nvarchar (256)
@FieldName nvarchar (256)
@Value sql_variant

dbo.eWaySP_GetAdministratorGUID

dbo.eWaySP_GetAdministratorMail

dbo.eWaySP_GetAllUsedPohodaAccountingUnits

dbo.eWaySP_GetCollisionWorkReports

Get the work reports, which are duplicate in manner of time overlapping.

Object ID: 544577574; Created: June 28, 2017, 22:40:28
Name Type Default Comment
@UserGUID uniqueidentifier The tested user.
@ExcludeItemGUID uniqueidentifier The work report, which will be excluded from the list. Usually the tested one. Can be null.
@From datetime Date and time of start.
@To datetime Date and time of end.

dbo.eWaySP_GetColumnPermissionsAffectedColumns

dbo.eWaySP_GetDefaultBackupDirectory

dbo.eWaySP_GetForeignKeyReferencedObjects

Gets referenced table name and column name by given foreign key name.

dbo.eWaySP_GetForeignKeys

Gets list of foreign keys on the current database.

dbo.eWaySP_GetGroupsRelatedToUser

WS - returns list of groups of the user.

dbo.eWaySP_GetChangedItemIdentifiers

Gets items from EWD_ItemChanges table.

Object ID: 1589437282; Created: May 12, 2017, 22:22:16
Name Type Default Comment
@LastChange bigint First item to be returned.
@MaxLastChange bigint Maximum change id of the item to be returned.

dbo.eWaySP_GetIntAdditionalFieldValue

Object ID: 1428460413; Created: December 10, 2014, 15:07:21
Name Type Default Comment
@ItemGUID uniqueidentifier
@FolderName nvarchar (256)
@FieldName nvarchar (256)
@Value int

dbo.eWaySP_GetItemHistory

Gets history of changes related to specific item.

dbo.eWaySP_GetItemsLastChange

Gets last ChangeID from EWD_ItemChanges.

dbo.eWaySP_GetItemsToBeRemovedConsequently

Gets items (guid, folder name) that have to be deleted as a consequence of the incomming deletion of the given item. For example. before deleting a general item, all its relations and relation data have to be deleted first.

Object ID: 1294692456; Created: January 25, 2019, 20:59:02
Name Type Default Comment
@BeingRemovedItemGUID uniqueidentifier ItemGUID of the item that is going to be removed.
@BeingRemovedItemFolderName nvarchar (255) Containing folder name of the item that is going to be removed.

dbo.eWaySP_GetItemsWithChangedForeignKeyRelations

Gets items which are affected by relation change or deletion. The affected items are the items which uses the relations for generating foreign keys from 1:N relations. Returns only itemguids of the affected items.

Object ID: 440401384; Created: November 07, 2018, 20:16:31
Name Type Default Comment
@LastChange bigint Minimal considered change id - exclusive.
@MaxLastChange bigint Maximal considered change id - inclusive.
@ObjectTypeID tinyint The desired affected items folder identifier or null if all results have to be taken.

dbo.eWaySP_GetLastChangedItemsOfType

Object ID: 164455910; Created: December 10, 2014, 15:07:16
Name Type Default Comment
@FoldeName nvarchar (256)
@DateFrom datetime
@DaysBefore int

dbo.eWaySP_GetListOfDataProviders

dbo.eWaySP_GetNewAdditionalFieldRank

dbo.eWaySP_GetNVarCharAdditionalFieldValue

Object ID: 1444460470; Created: December 10, 2014, 15:07:21
Name Type Default Comment
@ItemGUID uniqueidentifier
@FolderName nvarchar (256)
@FieldName nvarchar (256)
@Value nvarchar (max)

dbo.eWaySP_GetPermissionsRelevantChangesCount

Gets count of the ItemChanges records which may change the given user's permissions.

Object ID: 920858843; Created: October 17, 2016, 12:50:56
Name Type Default Comment
@LastChange bigint Minimal considered change id - exclusive.
@MaxLastChange bigint Maximal considered change id - inclusive.
@UserItemGUID uniqueidentifier The user, whose permissions we test.

dbo.eWaySP_GetTableOfItemType

Returns table name for specified ID.

dbo.eWaySP_GetTableSchema

dbo.eWaySP_GetUnifiedRelations

Gets all unified relations. Returns exactly one row per every relation pair. In case of unoriented relations selects the row where ItemGUID1 < ItemGUID2. In case of oriented relations selects the row where Direction = 2. Unoriented relations between one and the same item (ItemGUID1 = ITEMGUID2 & Direction = 0) are ignored.

dbo.eWaySP_GetUnifiedRelationsItemChangeIdentifiers

Gets changes of the unified relations.

Object ID: 528577517; Created: June 28, 2017, 22:40:28
Name Type Default Comment
@LastChange bigint
@MaxLastChange bigint

dbo.eWaySP_GetUniqueIndexReferencedObjects

Gets referenced table name and column name by given unique index name.

dbo.eWaySP_GetUnorientedUnifiedRelationsIdentifiers

Gets only the identifiers of the M:N and AF unified relations of the specified modules.

Object ID: 512577460; Created: June 28, 2017, 22:40:28
Name Type Default Comment
@ObjectTypeID1 tinyint
@ObjectTypeID2_1 tinyint
@ObjectTypeID2_2 tinyint
@ObjectTypeID2_3 tinyint
@ObjectTypeID2_4 tinyint
@ObjectTypeID2_5 tinyint

dbo.eWaySP_GetUserID

Gets user ItemGUID, password hash and username.

dbo.eWaySP_GetUsersInSameGroups

WS, returns list of users in the same group as the specified user.

dbo.eWaySP_GetUserViews

Get list of user views of a specified user.

dbo.eWaySP_GetUserWithProducts

dbo.eWaySP_GetWrongClientVersions

WS, checking versions.

dbo.eWaySP_GlobalSettings_SetVisibility

Sets visibility on specified Global Setting.

Object ID: 376401156; Created: November 07, 2018, 20:16:31
Name Type Default Comment
@Name nvarchar (256) Global Setting name.
@Visible bit Value indicating whether will be setting visible.

dbo.eWaySP_GoodsInCart_UpdatePriceTotal

dbo.eWaySP_CheckBinaryDataRecord

Checks whether BinaryData record for the specified document or email exists. If not, raises an error. If the record exists, does nothing. In case of Documents folder, the proc also checks the revision history record. This proces is ment to be an after save trigger.

Object ID: 1771218156; Created: February 06, 2019, 20:15:13
Name Type Default Comment
@ItemGUID uniqueidentifier ItemGUID of the uploaded document or email.
@FolderName nvarchar (32) Folder name of the uploaded item module.

dbo.eWaySP_CheckClrConfiguration

Used by CheckStatus WebService method to check whether WebServicePath is correct.

dbo.eWaySP_CheckData

dbo.eWaySP_CheckDateOnJournalWhenUploading

Check event start date on journal that is being created, if conforms to 'GetJournalFirstAcceptableDate' limit.

Object ID: 1544913121; Created: May 01, 2017, 22:25:04
Name Type Default Comment
@JournalGUID uniqueidentifier Guid of journal.
@JournalType uniqueidentifier
@EventStart datetime Date of event start.

dbo.eWaySP_CheckDuplicatedRelations

Tests database for duplicated relations.

dbo.eWaySP_CheckForDuplicatedValues

Checks duplicated values in given column or by given relation type.

Object ID: 923618829; Created: July 27, 2016, 22:19:58
Name Type Default Comment
@ColumnName nvarchar (256) Column name to be checked
@ObjectTypeID tinyint Id of object type to be checked

dbo.eWaySP_CheckRelationsPointingToNonExistingItems

Tests database for relations between non-existing items.

dbo.eWaySP_InsertIntoHistory

Inserts new record int EWD_History table.

Object ID: 983635243; Created: March 22, 2018, 21:27:04
Name Type Default Comment
@ItemGUID uniqueidentifier Identifier of the user who updated the record.
@ObjectTypeID tinyint
@ModifiedByGUID uniqueidentifier
@ItemChanged datetime
@ServerItemChanged datetime
@ColumnName nvarchar (128)
@ClientVersion varchar (50)
@PrevValueVarChar nvarchar (256)
@NewValueVarChar nvarchar (256)
@PrevValueVarCharMax nvarchar (max)
@NewValueVarCharMax nvarchar (max)
@PrevValueBit bit
@NewValueBit bit
@PrevValueInt int
@NewValueInt int
@PrevValueBigInt bigint
@NewValueBigInt bigint
@PrevValueDecimal decimal (18, 4)
@NewValueDecimal decimal (18, 4)
@PrevValueDateTime datetime
@NewValueDateTime datetime
@PrevValueGUID uniqueidentifier
@NewValueGUID uniqueidentifier
@PrevValueVarBinary varbinary (max)
@NewValueVarBinary varbinary (max)

dbo.eWaySP_InsertIntoItemChanges

Inserts updated or removed item into the EWD_ItemChanges table.

Object ID: 63299981; Created: May 18, 2018, 20:38:10
Name Type Default Comment
@ItemGUID uniqueidentifier Identifier of the item.
@FolderName nvarchar (256) Folder name of the item.
@Removed bit 1 if the item has been removed, otherwise 0.
@ItemCreated datetime Time of the change, by default it is the same as Server_ItemChanged of the item.
@FileAs nvarchar (1280) FileAs of the item.
@ModifiedByGUID uniqueidentifier GUID of the user who has issued the update.
@ItemVersion int Item version of the item.

dbo.eWaySP_InvalidateOldCurrencyExchangeRateItems

dbo.eWaySP_IsAdmin

WS, checks whether the specified user is administrator.

dbo.eWaySP_IsEmailCampaignResponseDuplicate

Object ID: 433241144; Created: February 28, 2017, 22:19:17
Name Type Default Comment
@JournalResponseId uniqueidentifier
@RespondentId uniqueidentifier

dbo.eWaySP_IsProjectAssignmentDuplicate

Object ID: 496108908; Created: October 30, 2013, 11:40:48
Name Type Default Comment
@ProjectAssignmentGUID uniqueidentifier
@ProjectGUID uniqueidentifier

dbo.eWaySP_IsRelationPresent

Checks whether a relation is present.

Object ID: 39579825; Created: November 16, 2017, 09:11:48
Name Type Default Comment
@ItemGUID1 uniqueidentifier Identififer of the first item.
@ItemGUID2 uniqueidentifier Identififer of the second item.
@ObjectTypeID1 tinyint ID of first object type.
@ObjectTypeID2 tinyint ID of second object type.
@RelationType nvarchar (64) Type of the relation.
@DifferDirection bit True to use direction.

dbo.eWaySP_IsUserAccountLocked

dbo.eWaySP_IsUserActive

dbo.eWaySP_IsWorkCommitmentDuplicate

Object ID: 480108851; Created: October 30, 2013, 11:40:48
Name Type Default Comment
@WorkCommitmentGUID uniqueidentifier
@UserGUID uniqueidentifier

dbo.eWaySP_ItemExists

Object ID: 1933822547; Created: August 31, 2017, 22:57:04
Name Type Default Comment
@ItemGUID uniqueidentifier
@FolderName nvarchar (50)
@ObjectTypeID int

dbo.eWaySP_Leads_OwnerChangedNotifier

Notify new owner of lead about lead. Procedure is calling in BeforeSave trigger on Leads.

Object ID: 405888813; Created: January 29, 2015, 21:58:17
Name Type Default Comment
@LeadGUID uniqueidentifier Guid of created lead.
@OwnerGUID uniqueidentifier Guid of owner of lead.
@ModifiedByGUID uniqueidentifier Guid of author of modification.
@PrevOwnerGUID uniqueidentifier Guid of previous owner of lead.

dbo.eWaySP_LogLogin

Save login history.

Object ID: 423685303; Created: September 07, 2018, 20:41:41
Name Type Default Comment
@UserGUID uniqueidentifier User identifier.
@SID uniqueidentifier Session identifier.
@ClientVersion nvarchar (50) Version of client.
@UserHostAddress varchar (45) IP host address of the remote client.
@Successful bit Value indicating whether was login successful.
@UserHostID varchar (50) Unique identification of the remote client.
@UserHostName nvarchar (50) Name of the host.
@CommunicatedUserHostAddress varchar (45) IP host address which the client claims to be using (created for WCF IP retransmitting).
@TimeZone nvarchar (32) Time zone identifier of the client.

dbo.eWaySP_LogOwnerChange

Object ID: 2079554692; Created: May 26, 2014, 12:27:19
Name Type Default Comment
@ItemGUID uniqueidentifier
@OwnerGUID uniqueidentifier
@PreviousOwnerGUID uniqueidentifier
@FolderName nvarchar (50)
@UserGUID uniqueidentifier

dbo.eWaySP_LogStateChange

Logs item state change into new Journal item.

Object ID: 341888585; Created: January 29, 2015, 21:58:17
Name Type Default Comment
@HistoryGUID uniqueidentifier Guid of history item.
@HistoryTypeID tinyint Object type ID for folder name "History".
@ItemGUID uniqueidentifier Guid of changed item.
@ObjectTypeID tinyint Type of changed item.

dbo.eWaySP_MakeFieldEditable

Object ID: 716073837; Created: May 26, 2014, 12:27:24
Name Type Default Comment
@FolderName nvarchar (50)
@ColumnName nvarchar (255)

dbo.eWaySP_MakeFieldReadonly

Object ID: 732073894; Created: May 26, 2014, 12:27:24
Name Type Default Comment
@FolderName nvarchar (50)
@ColumnName nvarchar (255)

dbo.eWaySP_MakeItemsVisibleForAll

dbo.eWaySP_ManageCartRelationsToProjectOrCompany

Object ID: 1911938133; Created: December 10, 2014, 15:07:12
Name Type Default Comment
@CartGUID uniqueidentifier
@NewProjectGUID uniqueidentifier
@NewCompanyGUID uniqueidentifier

dbo.eWaySP_MarkBinaryDataAsStoredInFileSystem

Object ID: 2130783344; Created: May 18, 2018, 20:38:08
Name Type Default Comment
@ItemGUID uniqueidentifier
@Revision int
@FileSystemStorageRelativePath char (7)

dbo.eWaySP_Marketing_SetID

dbo.eWaySP_Marketing_UpdateRevenue

Object ID: 1692897448; Created: June 07, 2015, 16:36:28
Name Type Default Comment
@ReleatedLeadId uniqueidentifier
@MarketingId uniqueidentifier
@ReleatedLeadPrice numeric (18, 2)
@ReleatedLeadPreviousPrice numeric (18, 2)
@ReleatedLeadState uniqueidentifier
@ReleatedLeadPreviousState uniqueidentifier
@ReleatedLeadRemoving bit

dbo.eWaySP_MarketingList_RemoveAssignments

Removes assignements on Item from MarketingList Items

Object ID: 200700113; Created: March 24, 2015, 21:32:27
Name Type Default Comment
@ItemGUID uniqueidentifier Item unique identifier
@FolderName nvarchar (50) Item folder name

dbo.eWaySP_MergeItems

This procedure merges two items into the third. Optional use is to supply target item GUID the same as the first source item GUID. This procedure goes through the folder columns (except system ones) and uses the first not empty value (in order: source1, source2). The "Null or unique" columns specified bellow are filled by the same policy, but the source field is nulled (unique const.) Then this procedure reconnects all the relations of the sources to the target item. The foreign keys are redirected to the target item too.

Object ID: 1787218213; Created: February 06, 2019, 20:15:15
Name Type Default Comment
@FolderName nvarchar (256) GUID of the second source item.
@TargetItemGUID uniqueidentifier GUID of the target item.
@SourceItemGUID1 uniqueidentifier
@SourceItemGUID2 uniqueidentifier

dbo.eWaySP_ModifyUserName

Modify username for user in eWay system.

Object ID: 2095255165; Created: January 04, 2018, 22:40:44
Name Type Default Comment
@OldUserName nvarchar (50) Old username.
@NewUserName nvarchar (50) New username.

dbo.eWaySP_NewPhoneListUser

Object ID: 912722304; Created: April 24, 2009, 16:41:48; Modified: March 06, 2013, 11:24:09
Name Type Default Comment
@UserGUID uniqueidentifier
@GroupGUID uniqueidentifier
@Remove int

dbo.eWaySP_NormalizePhoneNumber

Fills the 'Normalized' column for the changed phone number column.

Object ID: 1262692342; Created: January 25, 2019, 20:59:01
Name Type Default Comment
@FolderName nvarchar (64) Module folder name.
@ColumnName nvarchar (128) The telephone number column that has been changed. Ex. 'TelephoneNumber1'.
@ItemGUID uniqueidentifier Item guid of item that was changed.

dbo.eWaySP_NotifyAboutLeadsDeadline

Procedure for sending e-mails about expired deadlines of leads.

dbo.eWaySP_NotifyAboutMissingExchangeRates

dbo.eWaySP_NotifyAboutProjectDeadline

Procedure for sending e-mails about finishing projects.

dbo.eWaySP_NotifyAboutTaskChange

Object ID: 1054691601; Created: January 25, 2019, 20:58:58
Name Type Default Comment
@TaskGUID uniqueidentifier
@ModifiedByGUID uniqueidentifier
@NewSolverGUID uniqueidentifier
@NewSuperiorItemGUID uniqueidentifier
@NewSuperiorItemObjectTypeID tinyint
@NewOwnerGUID uniqueidentifier
@OldOwnerGUID uniqueidentifier
@NewTypeGUID uniqueidentifier
@OldTypeGUID uniqueidentifier
@NewStatusGUID uniqueidentifier
@OldStatusGUID uniqueidentifier
@NewSubject nvarchar (256)
@OldSubject nvarchar (256)
@NewStartDate datetime
@OldStartDate datetime
@NewDueDate datetime
@OldDueDate datetime
@NewReminderDate datetime
@OldReminderDate datetime
@NewReminder bit
@OldReminder bit
@NewImportanceGUID uniqueidentifier
@OldImportanceGUID uniqueidentifier
@NewComplete bit
@OldComplete bit
@NewPercentCompleteDecimal decimal (5, 4)
@OldPercentCompleteDecimal decimal (5, 4)
@NewActualWorkHours decimal (18, 3)
@OldActualWorkHours decimal (18, 3)
@NewEstimatedWorkHours decimal (18, 3)
@OldEstimatedWorkHours decimal (18, 3)
@NewNote nvarchar (max)
@OldNote nvarchar (max)
@NewCompanyGUID uniqueidentifier
@NewContactGUID uniqueidentifier

dbo.eWaySP_NotifyAboutTaskChanges

Object ID: 1472424715; Created: November 10, 2015, 22:13:25
Name Type Default Comment
@ItemGUID uniqueidentifier
@ObjectType tinyint
@UpdateType tinyint
@ChangedByGuid uniqueidentifier
@RelatedTaskGUID uniqueidentifier

dbo.eWaySP_NotifyAboutTasks

Notify delegators and solvers about tasks.

dbo.eWaySP_NotifyAboutTeamChanged

Object ID: 1504424829; Created: November 10, 2015, 22:13:25
Name Type Default Comment
@UserGUID uniqueidentifier
@ProjectGUID uniqueidentifier
@LeadGUID uniqueidentifier
@Removed bit

dbo.eWaySP_NotifyAboutUnpaidInvoices

dbo.eWaySP_NotifyTeamAboutNewDocumentInProject

Notify team about new document in project.

Object ID: 1536424943; Created: November 10, 2015, 22:13:26
Name Type Default Comment
@DocumentGUID uniqueidentifier Guid of document.
@ProjectGUID uniqueidentifier Guid of project.
@CreatedOrModifiedGUID uniqueidentifier Guid of modificator.
@DocumentItemVersion int Version of document item.
@RecipientUserGUID uniqueidentifier Guid of recepient.

dbo.eWaySP_NotifyTeamAboutNewEmailInProject

Notify team about new email in project.

Object ID: 1552425000; Created: November 10, 2015, 22:13:26
Name Type Default Comment
@EmailGUID uniqueidentifier Guid of email.
@ProjectGUID uniqueidentifier Guid of project.
@CreatedOrModifiedGUID uniqueidentifier Guid of modificator.
@EmailItemVersion int Version of document item.
@RecipientUserGUID uniqueidentifier Guid of recepient.

dbo.eWaySP_NotifyTeamAboutNewJournalInProject

Notify team about new journal in project.

Object ID: 1568425057; Created: November 10, 2015, 22:13:26
Name Type Default Comment
@JournalGUID uniqueidentifier Guid of journal.
@ProjectGUID uniqueidentifier Guid of project.
@CreatedOrModifiedGUID uniqueidentifier Guid of modificator.
@JournalItemVersion int Version of journal item.
@RecipientUserGUID uniqueidentifier Guid of recepient.

dbo.eWaySP_NotifyUserAboutDocument

Object ID: 1588460983; Created: December 10, 2014, 15:07:21
Name Type Default Comment
@DocumentGUID uniqueidentifier
@CreatedOrModifiedGUID uniqueidentifier
@RecipientUserGUID uniqueidentifier

dbo.eWaySP_NotifyUserAboutEmail

Object ID: 680441548; Created: August 02, 2013, 10:07:50
Name Type Default Comment
@EmailGUID uniqueidentifier
@CreatedOrModifiedGUID uniqueidentifier
@RecipientUserGUID uniqueidentifier

dbo.eWaySP_NotifyUserAboutJournal

Object ID: 2057370694; Created: January 29, 2015, 21:58:14
Name Type Default Comment
@JournalGUID uniqueidentifier
@CreatedOrModifiedGUID uniqueidentifier
@RecipientUserGUID uniqueidentifier

dbo.eWaySP_NotifyUsersAboutNewDocumentInCompany

Object ID: 1584425114; Created: November 10, 2015, 22:13:26
Name Type Default Comment
@DocumentGUID uniqueidentifier
@CompanyGUID uniqueidentifier
@CreatedOrModifiedGUID uniqueidentifier
@DocumentItemVersion int
@RecipientUserGUID uniqueidentifier

dbo.eWaySP_NotifyUsersAboutNewDocumentInContact

Object ID: 1600425171; Created: November 10, 2015, 22:13:26
Name Type Default Comment
@DocumentGUID uniqueidentifier
@ContactGUID uniqueidentifier
@CreatedOrModifiedGUID uniqueidentifier
@DocumentItemVersion int
@RecipientUserGUID uniqueidentifier

dbo.eWaySP_NotifyUsersAboutNewDocumentInLead

Notify team about new document in lead.

Object ID: 1616425228; Created: November 10, 2015, 22:13:26
Name Type Default Comment
@DocumentGUID uniqueidentifier Guid of document.
@LeadGUID uniqueidentifier Guid of lead.
@CreatedOrModifiedGUID uniqueidentifier Guid of modificator.
@DocumentItemVersion int Version of document item.
@RecipientUserGUID uniqueidentifier Guid of recepient.

dbo.eWaySP_NotifyUsersAboutNewEmailInCompany

Object ID: 1632425285; Created: November 10, 2015, 22:13:26
Name Type Default Comment
@EmailGUID uniqueidentifier
@CompanyGUID uniqueidentifier
@CreatedOrModifiedGUID uniqueidentifier
@EmailItemVersion int
@RecipientUserGUID uniqueidentifier

dbo.eWaySP_NotifyUsersAboutNewEmailInContact

Object ID: 1648425342; Created: November 10, 2015, 22:13:26
Name Type Default Comment
@EmailGUID uniqueidentifier
@ContactGUID uniqueidentifier
@CreatedOrModifiedGUID uniqueidentifier
@EmailItemVersion int
@RecipientUserGUID uniqueidentifier

dbo.eWaySP_NotifyUsersAboutNewEmailInLead

Object ID: 1664425399; Created: November 10, 2015, 22:13:26
Name Type Default Comment
@EmailGUID uniqueidentifier
@LeadGUID uniqueidentifier
@CreatedOrModifiedGUID uniqueidentifier
@EmailItemVersion int
@RecipientUserGUID uniqueidentifier

dbo.eWaySP_NotifyUsersAboutNewJournalInCompany

Object ID: 1680425456; Created: November 10, 2015, 22:13:26
Name Type Default Comment
@JournalGUID uniqueidentifier
@CompanyGUID uniqueidentifier
@CreatedOrModifiedGUID uniqueidentifier
@JournalItemVersion int
@RecipientUserGUID uniqueidentifier

dbo.eWaySP_NotifyUsersAboutNewJournalInContact

Object ID: 1696425513; Created: November 10, 2015, 22:13:26
Name Type Default Comment
@JournalGUID uniqueidentifier
@ContactGUID uniqueidentifier
@CreatedOrModifiedGUID uniqueidentifier
@JournalItemVersion int
@RecipientUserGUID uniqueidentifier

dbo.eWaySP_NotifyUsersAboutNewJournalInLead

Notify team about updated journal in lead.

Object ID: 1712425570; Created: November 10, 2015, 22:13:26
Name Type Default Comment
@JournalGUID uniqueidentifier Guid of journal.
@LeadGUID uniqueidentifier Guid of lead.
@CreatedOrModifiedGUID uniqueidentifier Guid of modificator.
@JournalItemVersion int Version of journal item.
@RecipientUserGUID uniqueidentifier Guid of recepient.

dbo.eWaySP_NotifyUsersAfterUpdate

dbo.eWaySP_NotifyUsersBeforeUpdate

Notifies users when update finishes.

dbo.eWaySP_ParseContactName_Clr

Object ID: 299264967; Created: July 12, 2019, 13:16:41
Name Type Default Comment
@ContactName nvarchar (max)
@Prefix nvarchar (256)
@FirstName nvarchar (256)
@MiddleName nvarchar (256)
@LastName nvarchar (256)
@Suffix nvarchar (256)

dbo.eWaySP_ProcessQueuedJobs

Process queued jobs from table EWD_QueuedJobs.

dbo.eWaySP_Projects_CalculateEstimatedMargin

Object ID: 1773821977; Created: August 31, 2017, 22:57:02
Name Type Default Comment
@ProjectGUID uniqueidentifier
@EstimatedMargin decimal (18, 4)
@EstimatedProfit decimal (18, 4)
@EstimatedPrice decimal (18, 2)
@EstimatedOtherExpenses decimal (18, 2)
@EstimatedPeopleExpenses decimal (18, 2)

dbo.eWaySP_Projects_OwnerChangedNotifier

Notify new owner of Project about Project. Procedure is calling in BeforeSave trigger on Projects.

Object ID: 1358692684; Created: January 25, 2019, 20:59:03
Name Type Default Comment
@ProjectGUID uniqueidentifier Guid of created Project.
@OwnerGUID uniqueidentifier Guid of owner of Project.
@ModifiedByGUID uniqueidentifier Guid of author of modification.
@PrevOwnerGUID uniqueidentifier Guid of previous owner of Project.

dbo.eWaySP_Projects_PriceChange

Create journal entry for change on project field "Price"

Object ID: 373888699; Created: January 29, 2015, 21:58:17
Name Type Default Comment
@ProjectGUID uniqueidentifier Guid of project
@UserGUID uniqueidentifier Guid of modification author
@Price decimal (18, 0) Price new value
@PrevPrice decimal (18, 0) Price old value

dbo.eWaySP_Projects_ProjectEndChange

Create journal entry for change on project field "ProjectEnd"

Object ID: 309888471; Created: January 29, 2015, 21:58:17
Name Type Default Comment
@ProjectGUID uniqueidentifier Guid of project
@UserGUID uniqueidentifier Guid of modification author
@ProjectEnd datetime ProjectEnd new value
@PrevProjectEnd datetime ProjectEnd old value

dbo.eWaySP_Projects_RemoveProjectAssignments

dbo.eWaySP_Projects_RemoveRelatedTasks

dbo.eWaySP_Projects_SetHID

Object ID: 496720822; Created: August 27, 2008, 17:32:01; Modified: March 06, 2013, 11:24:09
Name Type Default Comment
@ItemGUID nvarchar (36)
@Type int

dbo.eWaySP_Projects_UpdateSuperiorProject

Object ID: 1454068366; Created: March 04, 2014, 21:38:21
Name Type Default Comment
@ProjectGUID uniqueidentifier
@Removing int
@FirstSlave uniqueidentifier

dbo.eWaySP_PropagateDocumentationOnSubGoods

Object ID: 28071386; Created: May 26, 2014, 12:27:20
Name Type Default Comment
@IsDeleted bit
@SuperiorGoodGUID uniqueidentifier
@RelatedObjectGUID uniqueidentifier
@GoodObjectTypeID tinyint
@RelatedObjectObjectTypeID tinyint

dbo.eWaySP_ReadAttachment

Object ID: 1910297865; Created: November 26, 2012, 12:41:28; Modified: March 06, 2013, 11:24:10
Name Type Default Comment
@ItemGUID uniqueidentifier
@Revision int
@Offset int
@Size int
@Compressed bit

dbo.eWaySP_ReasignTasks

Reasign tasks with given state from old user to new user

Object ID: 569469503; Created: November 25, 2015, 22:11:39
Name Type Default Comment
@OldUserGuid uniqueidentifier Guid of old user.
@OldUserName nvarchar (256) Name of old user.
@NewUserGuid uniqueidentifier Guid of new user.
@NewUserName nvarchar (256) Name of new user.

dbo.eWaySP_RecalculateAccountManagerGoals

Fill goals item of type "Account manager".

dbo.eWaySP_RecalculateGoals

Recalculate prices on goals.

dbo.eWaySP_RecalculateOtherCurrencyPrices

dbo.eWaySP_RecalculateProjectManagerGoals

Fill goals item of type "Project manager".

dbo.eWaySP_RecalculateSalesManagerGoals

Fill goals item of type "Sales manager".

dbo.eWaySP_RelationValidationFailed

Object ID: 92071614; Created: May 26, 2014, 12:27:20
Name Type Default Comment
@FolderName1 nvarchar (256)
@ObjectTypeId1 int
@FolderName2 nvarchar (256)
@ObjectTypeId2 int
@RelationType nvarchar (256)
@DirectionShouldBeSet bit
@IsBadRelationType bit

dbo.eWaySP_RemoveAdditionalField

Removes additional field from eWay-CRM.

Object ID: 248400700; Created: November 07, 2018, 20:16:28
Name Type Default Comment
@AdditionalFieldItemGUID uniqueidentifier GUID of the additional field.
@DeletedByGUID uniqueidentifier GUID of the user who deleted the additional field.

dbo.eWaySP_RemoveAttachment

Object ID: 902294274; Created: May 27, 2011, 14:16:57; Modified: March 06, 2013, 11:24:09
Name Type Default Comment
@DocumentGUID uniqueidentifier
@Revision int

dbo.eWaySP_RemoveAvailableVersionInfo

Removes info about available new version because no new version is available.

dbo.eWaySP_RemoveCategoryByRelatedCompany

Remove category from related items when is removed from company.

Object ID: 1189279692; Created: October 12, 2015, 22:10:35
Name Type Default Comment
@CompanyGUID uniqueidentifier Guid of company with deleted category
@RemoveCategoryGUID uniqueidentifier Guid of deleted category from company

dbo.eWaySP_RemoveGeneralRelationWhenOneToManyIsCreated

Used to remove GENERAL relation when one to many relation is being saved.

Object ID: 464577289; Created: June 28, 2017, 22:40:28
Name Type Default Comment
@ItemGUID1 uniqueidentifier ItemGUID1 of the relation being saved.
@ItemGUID2 uniqueidentifier ItemGUID2 of the relation being saved.

dbo.eWaySP_RemoveLayoutsModelsItemBeforeRelatedItemRemoved

Object ID: 1342692627; Created: January 25, 2019, 20:59:02
Name Type Default Comment
@RelatedItemGUID uniqueidentifier
@RelatedItemFolderName nvarchar (50)

dbo.eWaySP_RemoveLeftForeignKeysBeforeCompanyRemoved

Removes individual discounts related to Company before Company is being removed.

dbo.eWaySP_RemoveLeftForeignKeysBeforeGoodsRemoved

Remove Prices, GoodsInSet items related to Good before Good is being removed.

dbo.eWaySP_RemoveLeftForeignKeysBeforeMarketingRemoved

Set foreign key on marketing list to NULL when marketing is removed.

dbo.eWaySP_RemoveLeftForeignKeysBeforePriceListGroupRemoved

Removes individual discounts related to Price List Group before Price List Group is being removed.

dbo.eWaySP_RemoveLeftForeignKeysBeforeSalePriceRemoved

Set foreign key on companies to NULL when SalePrice is removed.

dbo.eWaySP_RemoveLeftForeignKeysBeforeTaskRemoved

Removes recurrence patterns related to Task before Task is being removed.

dbo.eWaySP_RemoveLeftItemsBeforeRelationDataRemoved

Removes items which use RelationData as foreign key and has not yet been removed

dbo.eWaySP_RemoveOldSessions

dbo.eWaySP_RemoveRelationsPointingToNoneExistingItems

Remove relations pointing to nonexistent items.

dbo.eWaySP_RemoveRevisionHistoryAndBinaryData

dbo.eWaySP_RemoveSessions

Removes sessions of specified user.

Object ID: 1494361184; Created: March 29, 2019, 20:43:18
Name Type Default Comment
@UserGUID uniqueidentifier GUID of the user.
@IgnoreSessionGUID uniqueidentifier GUID of the session that will be kept.

dbo.eWaySP_RemoveUnusedBinaryData

Removes BinaryData which is not related to document or email.

dbo.eWaySP_ReorderRankForEnumType

Sorts order (Rank) of the enumeration by specified column.

Object ID: 1978138488; Created: August 25, 2015, 14:54:50
Name Type Default Comment
@EnumTypeGUID uniqueidentifier Enumeration identifier.
@OrderByColumnName nvarchar (256) Name of the column used for sort.
@OrderByDirection nvarchar (16) Sort order mode (ASC or DESC).
@RankStart int Rank initial number.

dbo.eWaySP_ReorderRankForGoodsInCart

Fixed Rank of GoodsInCart.

dbo.eWaySP_ResetCloudDatabaseChanges

Reset some GlobalSetting parameters to default.

dbo.eWaySP_ResetDefaultCurrency

Sets default value on currency columns based on current DefaultCurrency GS.

dbo.eWaySP_ResetHolidays

Creates holidays for new year.

dbo.eWaySP_ResetSynchronizationMappingToDefault

Resets synchronization mapping to default.

Object ID: 1558361412; Created: March 29, 2019, 20:43:18
Name Type Default Comment
@SynchronizationObjectName nvarchar (256) Name of synchronization object to reset mappings on.
@SynchronizationField nvarchar (256) Field identificator to reset mappings on.

dbo.eWaySP_Responses_CreateTaskMarketingListRelation

Creates relation between task and marketing participant

dbo.eWaySP_RestoreDeletedRelations

Restore relations of deleted item.

Object ID: 1182692057; Created: January 25, 2019, 20:58:59
Name Type Default Comment
@FolderName nvarchar (50) Name of folder.
@DeletedItemGUID uniqueidentifier GUID of deleted item.
@NewItemGUID uniqueidentifier GUID of new item.
@FromDeletedDate datetime Date filter for column DeletedDate.

dbo.eWaySP_RevertProjectToLead

Delete project created from lead and map its related items to original lead.

Object ID: 1588565093; Created: July 27, 2015, 12:43:11
Name Type Default Comment
@ProjectHID int HID of project to delete
@NewLeadStateFileAs nvarchar (256) FileAs of new state for lead after project is reverted to lead.
@CreateNewLeadIfNotExist bit

dbo.eWaySP_SaveAttachment

Object ID: 2114783287; Created: May 18, 2018, 20:38:08
Name Type Default Comment
@ItemGUID uniqueidentifier
@Revision int
@Data image
@FileSize bigint
@Extension varchar (10)
@UploadedSize bigint
@CompressedFileSize bigint
@Compressed bit
@StoredInFileSystem bit
@CreatedByGuid uniqueidentifier
@Created datetime
@FileSystemStorageRelativePath char (7)

dbo.eWaySP_SendActivityEmail

Object ID: 2146783401; Created: May 18, 2018, 20:38:09
Name Type Default Comment
@ActivityGUID uniqueidentifier
@SuperiorItemGUID uniqueidentifier
@BodyText nvarchar (max)
@Subject nvarchar (255)
@BlackListUserGUID uniqueidentifier
@SingleRecipientGUID uniqueidentifier

dbo.eWaySP_SendMail

Sends e-mail via SQL server DB Mail service.

Object ID: 1655676946; Created: June 24, 2008, 16:12:01; Modified: July 12, 2019, 13:16:41
Name Type Default Comment
@to nvarchar (4000)
@text nvarchar (max)
@subj nvarchar (4000)
@format varchar (20)
@cc nvarchar (4000)
@bcc nvarchar (4000)

dbo.eWaySP_SendMail_Clr

Object ID: 251264796; Created: July 12, 2019, 13:16:41
Name Type Default Comment
@to nvarchar (4000)
@subject nvarchar (4000)
@body nvarchar (max)
@async bit True
@cc nvarchar (4000)
@bcc nvarchar (4000)

dbo.eWaySP_SendMailPlain

Object ID: 267264853; Created: July 12, 2019, 13:16:41
Name Type Default Comment
@to nvarchar (4000)
@subject nvarchar (4000)
@body nvarchar (max)
@async bit True
@cc nvarchar (4000)
@bcc nvarchar (4000)

dbo.eWaySP_SetAdditionalFieldValue

Set additional field value.

Object ID: 1508564808; Created: July 27, 2015, 12:43:11
Name Type Default Comment
@ItemGUID uniqueidentifier Guid of item with additional field to set.
@FolderName varchar (50) Folder name of item with additional field to set.
@FieldName varchar (256) Name of additional field to set.
@Value sql_variant New value.
@WriteItemChanges bit Should be changes written in ItemChanges.

dbo.eWaySP_SetAdminGroupModulePermisison

Set module permissions for Administrator group.

Object ID: 1805822091; Created: August 31, 2017, 22:57:03
Name Type Default Comment
@FolderName nvarchar (50)
@View varchar (16) Permissions of module for view records (ALL, INHERITED, RELATED, OWN, GROUP, NONE).
@Edit varchar (16) Permissions of module for edit records (ALL, INHERITED, RELATED, OWN, GROUP, NONE).
@Delete varchar (16) Permissions of module for delete records (ALL, INHERITED, RELATED, OWN, GROUP, NONE).
@Create varchar (16) Permissions of module for create records (ALL, INHERITED, RELATED, OWN, GROUP, NONE).
@Export varchar (16) Permissions of module for export records (ALL, INHERITED, RELATED, OWN, GROUP, NONE).
@RowsRestriction int Rows restriction of records in eWay-CRM controls.

dbo.eWaySP_SetColumnPermissionForGdprFunctionality

Object ID: 743634388; Created: March 22, 2018, 21:27:01
Name Type Default Comment
@FunctionalityEnabled bit
@PreviousFunctionalityEnabled bit

dbo.eWaySP_SetColumnPermissionForPeopleExpensesSumarization

Object ID: 759634445; Created: March 22, 2018, 21:27:01
Name Type Default Comment
@SumarizationEnabled bit
@PreviousSumarizationEnabled bit

dbo.eWaySP_SetColumnPermissionForPriceSumarization

Object ID: 1300459957; Created: December 10, 2014, 15:07:20
Name Type Default Comment
@FolderName nvarchar (256)
@SumarizationEnabled bit
@PreviousSumarizationEnabled bit

dbo.eWaySP_SetDefaultCurrencyGUID

Object ID: 348072526; Created: May 26, 2014, 12:27:22
Name Type Default Comment
@FolderName nvarchar (256)
@ItemGUID uniqueidentifier

dbo.eWaySP_SetEnumAdditionalFieldValue

Set additional field value (enumeration).

Object ID: 497241372; Created: February 28, 2017, 22:19:18
Name Type Default Comment
@ItemGUID uniqueidentifier Guid of item with additional field to set.
@FolderName varchar (50) Folder name of item with additional field to set.
@FieldName varchar (256) Name of additional field to set.
@EnumValue varchar (256) FileAs of EnumValue (string).
@WriteItemChanges bit Should be changes written in ItemChanges.

dbo.eWaySP_SetEnumValue

Insert or update enum value.

Object ID: 1528913064; Created: May 01, 2017, 22:25:03
Name Type Default Comment
@EnumTypeName nvarchar (256) Name of the enumeration in which the value will be created.
@EnumValueFileAs nvarchar (256) Enum value name (FileAs).
@en nvarchar (256) English translation.
@cs nvarchar (256) Czech translation.
@de nvarchar (256) German translation.
@ru nvarchar (256) Russian translation.
@sk nvarchar (256) Slovakian translation.
@no nvarchar (256) Norwegian translation.
@checkDuplicity bit Check duplicity.

dbo.eWaySP_SetEnumValueNewRank

Create new order of enum values according to specified EunmName, FileAs and newRank

Object ID: 609137661; Created: January 17, 2016, 14:52:53
Name Type Default Comment
@EnumName nvarchar (256) EnumName for right EnumValues subset.
@FileAs nvarchar (256) FileAs of item in subset of EnumValues given by EnumName.
@NewRank int New Rank value for selected EunmValues item.
@UseItemChanges bit
@UseControlSelect bit

dbo.eWaySP_SetFunctionDescription

Sets function description.

Object ID: 719914232; Created: September 28, 2017, 22:52:47
Name Type Default Comment
@FunctionName nvarchar (256) Name of the function.
@Description nvarchar (4000) Description of the function.

dbo.eWaySP_SetFunctionParameterDescription

Sets function parameter description.

Object ID: 703914175; Created: September 28, 2017, 22:52:47
Name Type Default Comment
@FunctionName nvarchar (256) Name of the function.
@ParameterName nvarchar (256) Name of the parameter.
@Description nvarchar (4000) Description of the parameter.

dbo.eWaySP_SetGroupColumnPermission

Object ID: 340456537; Created: December 10, 2014, 15:07:18
Name Type Default Comment
@GroupName nvarchar (255)
@FolderName nvarchar (50)
@ColumnName nvarchar (255)
@Type tinyint

dbo.eWaySP_SetGroupModulePermission

Set module permissions for specified group.

Object ID: 107772087; Created: January 04, 2018, 22:40:50
Name Type Default Comment
@GroupGUID uniqueidentifier
@FolderName nvarchar (50)
@View varchar (16) Permissions of module for view records (ALL, INHERITED, RELATED, OWN, GROUP, NONE).
@Edit varchar (16) Permissions of module for edit records (ALL, INHERITED, RELATED, OWN, GROUP, NONE).
@Delete varchar (16) Permissions of module for delete records (ALL, INHERITED, RELATED, OWN, GROUP, NONE).
@Create varchar (16) Permissions of module for create records (ALL, INHERITED, RELATED, OWN, GROUP, NONE).
@Export varchar (16) Permissions of module for export records (ALL, INHERITED, RELATED, OWN, GROUP, NONE).
@RowsRestriction int Rows restriction of records in eWay-CRM controls.
@IsSystem bit Value indicating whether will be permission system and therefore uneditable.

dbo.eWaySP_SetMandatoryUniqueConstraint

Sets mandatory unique constraint.

Object ID: 799914517; Created: September 28, 2017, 22:52:49
Name Type Default Comment
@ColumnName nvarchar (255) Name of column for which should be constraint created or deleted.
@ObjectTypeID tinyint Id of object type where to be constraint created or deleted.
@PrevMandatoryType tinyint Mandatory type previously set.
@NewMandatoryType tinyint Mandatory type to be set.

dbo.eWaySP_SetNewAvailableVersion

Sets info about available version.

Object ID: 1540564922; Created: July 27, 2015, 12:43:11
Name Type Default Comment
@AvailableWebServiceVersion nvarchar (20) New available web service version.
@AvailableOutlookClientVersion nvarchar (20) New available outlook client version.
@AvailableVersionChangeLogLink nvarchar (1024) New available version changelog KB link.
@ReleaseDate datetime The release date of the available version.

dbo.eWaySP_SetObjectTypeTrackHistory

Sets TrackHistory value for specified ObjectType.

Object ID: 1510361241; Created: March 29, 2019, 20:43:18
Name Type Default Comment
@ObjectTypeID tinyint ObjectTypeID of the module to be tracked.
@NewValue bit 1 to enable tracking otherwise 0.

dbo.eWaySP_SetPohodaSynchronizationSystemFields

Object ID: 1171235673; Created: February 23, 2016, 22:10:43
Name Type Default Comment
@ItemGUID uniqueidentifier
@FolderName nvarchar (50)
@ServerPohodaID int
@ServerPohodaAccountingUnit nvarchar (255)
@ServerPohodaDataSourceType tinyint

dbo.eWaySP_SetProcedureDescription

Sets procedure description.

Object ID: 671914061; Created: September 28, 2017, 22:52:47
Name Type Default Comment
@ProcedureName nvarchar (256)
@Description nvarchar (4000)

dbo.eWaySP_SetProcedureParameterDescription

Sets procedure parameter description.

Object ID: 655914004; Created: September 28, 2017, 22:52:46
Name Type Default Comment
@ProcedureName nvarchar (256) Name of the procedure.
@ParameterName nvarchar (256) Name of the parameter.
@Description nvarchar (4000) Description of the parameter.

dbo.eWaySP_SetSystemGroupColumnPermission

Set column permissions for given column and group System.

Object ID: 1294744511; Created: July 10, 2019, 21:34:05
Name Type Default Comment
@FolderName nvarchar (50) Name of the folder.
@ColumnName nvarchar (255) Name of the column.
@Type tinyint 0: None, 1: All, 2: Own, 3: Readonly, 4: Invisible.
@Mandatory tinyint Indicates whether a column is mandatory.
@CheckColumnExistence bit Checks whether the column exists in the specified table.
@IsMandatoryEditable bit Indicates whether user will be able to change mandatory settings of the column.
@IsTypeEditable bit Indicates whether user will be able to change permission type of the column.

dbo.eWaySP_SetSystemGroupModulePermission

Set module permissions for group System (all users).

Object ID: 1246692285; Created: January 25, 2019, 20:59:01
Name Type Default Comment
@FolderName nvarchar (50)
@View varchar (16) Permissions of module for view records (ALL, INHERITED, RELATED, OWN, GROUP, NONE).
@Edit varchar (16) Permissions of module for edit records (ALL, INHERITED, RELATED, OWN, GROUP, NONE).
@Delete varchar (16) Permissions of module for delete records (ALL, INHERITED, RELATED, OWN, GROUP, NONE).
@Create varchar (16) Permissions of module for create records (ALL, INHERITED, RELATED, OWN, GROUP, NONE).
@Export varchar (16) Permissions of module for export records (ALL, INHERITED, RELATED, OWN, GROUP, NONE).
@RowsRestriction int Rows restriction of records in eWay-CRM controls.

dbo.eWaySP_SetTableColumnDescription

Sets table column description.

Object ID: 687914118; Created: September 28, 2017, 22:52:47
Name Type Default Comment
@TableName nvarchar (256) Name of the table.
@ColumnName nvarchar (256) Name of the column.
@Description nvarchar (4000) Description of the column.

dbo.eWaySP_SetTableDescription

Sets table description.

Object ID: 735914289; Created: September 28, 2017, 22:52:47
Name Type Default Comment
@TableName nvarchar (256) Name of the table.
@Description nvarchar (4000) Description of the table.

dbo.eWaySP_SetUpFeatures

Sets up eWay-CRM features by given parameters.

Object ID: 1446361013; Created: March 29, 2019, 20:43:17
Name Type Default Comment
@ContactsAndCompanies bit Value indicating whether will be contacts and companies features active.
@Sales bit Value indicating whether will be sales feature active.
@Projects bit Value indicating whether will be projects feature active.
@MarketingCampaigns bit Value indicating whether will be marketing campaigns feature active.
@QuotesAndBilling bit Value indicating whether will be quotes and billing feature active.
@TimeSheetsAndPlaning bit Value indicating whether will be time sheets and planning features active.
@PerformInitialSetup bit Value indicating whether will be table EWD_Features updated as well.

dbo.eWaySP_ShowGlobalSettingsHistory

Shows history on GlobalSettings.

dbo.eWaySP_SynchronizeColumnPermissions

Makes changes on all items of the folder to force synchronization of permission changes on column.

Object ID: 2044182678; Created: March 24, 2015, 21:32:24
Name Type Default Comment
@ObjectTypeID int ObjectTypeID of the module.
@PrevType tinyint Previous permission type.
@NewType tinyint New permission type.

dbo.eWaySP_Task_InsertLogTeamTaskChange

Object ID: 515532920; Created: June 07, 2013, 21:07:43
Name Type Default Comment
@UserName nvarchar (256)
@TaskGUID uniqueidentifier
@ColumnTranslatedName nvarchar (256)
@oldValue nvarchar (max)
@newValue nvarchar (max)
@fieldName nvarchar (256)

dbo.eWaySP_Task_LogTeamTaskChanges

Object ID: 1760022047; Created: July 12, 2018, 20:23:43
Name Type Default Comment
@UserGUID uniqueidentifier
@TaskGUID uniqueidentifier
@newFileAs nvarchar (256)
@newStartDate datetime
@newDueDate datetime
@newImportance int
@newStatus uniqueidentifier
@newBody nvarchar (max)
@newPercentComplete decimal (5, 4)

dbo.eWaySP_Task_MirrorTeamTaskRelations

Object ID: 950294445; Created: May 27, 2011, 14:16:57; Modified: March 06, 2013, 11:24:09
Name Type Default Comment
@TaskGUID uniqueidentifier
@RelatedItemGUID uniqueidentifier
@RelatedItemOT int
@RelationType nvarchar (256)
@Direction int
@Remove int
@DelegatedFromTask uniqueidentifier

dbo.eWaySP_Tasks_AssignTaskRelatedItemToSuperiorItem

Create relation between Journal / Email / Document related to a task and the task's superior item.

Object ID: 432577175; Created: June 28, 2017, 22:40:27
Name Type Default Comment
@TaskGUID uniqueidentifier GUID of the task.
@RelatedItemGUID uniqueidentifier GUID of the Journal / Email / Document.
@RelatedItemOT int ObjectTypeID of the Journal / Email / Document.

dbo.eWaySP_Tasks_CalculateSuperiorTeamTaskCompletion

dbo.eWaySP_Tasks_CreateTask

Object ID: 1728021933; Created: July 12, 2018, 20:23:43
Name Type Default Comment
@pTaskFileAs nvarchar (256)
@pTaskBody nvarchar (1000)
@pDelegatorGUID uniqueidentifier
@pSolverGUID uniqueidentifier
@pParentGUID uniqueidentifier
@pParentOT tinyint
@pTopLevelItemGUID uniqueidentifier
@pTopLevelItemOT tinyint
@pSubTaskGUID uniqueidentifier
@pComplete bit
@pImportance int
@pPercentComplete decimal (5, 4)
@pDueDate datetime
@pStartDate datetime
@pRTFBody ntext
@pStatus uniqueidentifier
@pLevel int
@pTeamTask bit
@pTeamParentTask uniqueidentifier

dbo.eWaySP_Tasks_CreateTaskForTeamMember

Object ID: 1744021990; Created: July 12, 2018, 20:23:43
Name Type Default Comment
@pTaskGUID uniqueidentifier
@pUserGUID uniqueidentifier

dbo.eWaySP_Tasks_CreateTasksForAllTeamMembers

dbo.eWaySP_Tasks_DistributeCompletion

dbo.eWaySP_Tasks_FillActualWorkHoursField

Fills ActualWorkHours on Tasks according to related WorkReports duration.

dbo.eWaySP_Tasks_FillActualWorkHoursField_JOB

Fills ActualWorkHours on all tasks according to related WorkReports duration.

dbo.eWaySP_Tasks_RemoveSubTasks

dbo.eWaySP_Tasks_RemoveUserFromTaskTeam

Object ID: 1593772735; Created: January 18, 2011, 16:32:21; Modified: March 06, 2013, 11:24:10
Name Type Default Comment
@pTaskGUID uniqueidentifier
@pUserGUID uniqueidentifier

dbo.eWaySP_Tasks_UpdateFileAsAndLevelOnRelatedTasksByTaskParentRelation

Sets task FileAs on related tasks by TASKPARENT relation..

Object ID: 1044927540; Created: November 17, 2018, 07:52:27
Name Type Default Comment
@TaskGUID uniqueidentifier Task unique identifier.
@LeadGUID uniqueidentifier Lead unique identifier.
@ProjectGUID uniqueidentifier Project unique identifier.
@MarketingGUID uniqueidentifier Marketing unique identifier.

dbo.eWaySP_Tasks_UpdateSubTasks

Object ID: 1776022104; Created: July 12, 2018, 20:23:43
Name Type Default Comment
@pSuperiorTaskGUID uniqueidentifier
@pNewPercentComplete decimal (5, 4)
@pNewDueDate datetime

dbo.eWaySP_Tasks_ValidateSubTask

dbo.eWaySP_TransferUserAgenda

Transfers user's active agenda to another user. The procedure transfers companies, contacts, active projects with team roles, active leads, open tasks.

Object ID: 135580167; Created: November 16, 2017, 09:11:49
Name Type Default Comment
@PreviousUser nvarchar (50) Username of the previous Agenda owner.
@NewUser nvarchar (50) Username of the new Agenda owner.

dbo.eWaySP_TruncateTables

Object ID: 1750297295; Created: November 26, 2012, 12:41:26; Modified: March 06, 2013, 11:24:10
Name Type Default Comment
@FolderNames nvarchar (max)
@DoNotCreateItemChanges bit

dbo.eWaySP_UnlockUserAccount

dbo.eWaySP_UpdateCartVATPrices

dbo.eWaySP_UpdateDefaultValueForCurrencyColumnsBasedOnGlobalSettings

Updates DF for CurrencyEn like columns.

dbo.eWaySP_UpdateSession

Object ID: 1246744340; Created: July 10, 2019, 21:34:05
Name Type Default Comment
@SID uniqueidentifier
@LastActivity datetime

dbo.eWaySP_UpdateWorkReportsByCoutryOfUser

Update WorkReports day type by coutry of user.

dbo.eWaySP_Users_CountRemainingDaysOfHoliday

Object ID: 1230744283; Created: July 10, 2019, 21:34:05
Name Type Default Comment
@UserGUID uniqueidentifier
@VacationGUID uniqueidentifier

dbo.eWaySP_Vacation_SetDuration

Sets duration on Vacation.

Object ID: 1150691943; Created: January 25, 2019, 20:58:59
Name Type Default Comment
@VacationGUID uniqueidentifier
@UserGUID uniqueidentifier Identifier of the User.

dbo.eWaySP_WorkFlow_RemoveEnumValue

dbo.eWaySP_WorkFlow_RemoveModel

dbo.eWaySP_WorkReports_CalculateDuration

Fills the duration if it does not fit the dates.

dbo.eWaySP_WorkReports_CalculatePeopleExpenses

dbo.eWaySP_WorkReports_CalculateRate

Calculate rates and prices on work report. For fix rate recalculate rates and prices on related work reports too.

Object ID: 1983710515; Created: September 17, 2015, 22:07:13
Name Type Default Comment
@WorkReportGUID uniqueidentifier Guid of work report.
@WorkReportDate datetime Date of work report.

dbo.eWaySP_WorkReports_CalculateYearAndMonth

Sets Year and Month columns if they are not specified.

dbo.FK_Generator

Object ID: 2020918271; Created: January 24, 2013, 15:08:13
Name Type Default Comment
@action char (6)
@tsql nvarchar (max)

dbo.Migrace_CreateRelation

Object ID: 820197972; Created: July 21, 2008, 17:25:06; Modified: March 06, 2013, 11:24:09
Name Type Default Comment
@ItemGUID1 uniqueidentifier
@ItemGUID2 uniqueidentifier
@ItemType1 tinyint
@ItemType2 tinyint
@RelationType nvarchar (256)
@DirectionDiffer bit
@OwnerGUID uniqueidentifier

dbo.Migrace_SetExtendedDescription

Object ID: 2036202304; Created: August 11, 2008, 17:23:48; Modified: August 12, 2008, 15:08:01
Name Type Default Comment
@ObjectName nvarchar (128)
@ColumnName nvarchar (128)
@Description sql_variant
@ObjectType varchar (128)

dbo.AddEmailIntoCommaSeparatedEmailList

Object ID: 1724897562; Created: June 07, 2015, 16:36:30
Name Type Default Comment
nvarchar (max)
@stringEmails nvarchar (max)
@email nvarchar (256)

dbo.AddWorkDays

Object ID: 353240859; Created: February 28, 2017, 22:19:16
Name Type Default Comment
datetime
@FromDate datetime
@DaysToAdd int

dbo.CalculateAge

Object ID: 1732917245; Created: November 26, 2012, 13:00:56
Name Type Default Comment
int
@Birthdate datetime

dbo.CalculateCartPriceTotal

Calculates cart price total with VAT.

Object ID: 219772486; Created: January 04, 2018, 22:40:51
Name Type Default Comment
decimal (18, 3)
@CartGUID uniqueidentifier Cart GUID.

dbo.CalculateCartPriceTotalExcludingVAT

Calculates cart price total without VAT.

Object ID: 155772258; Created: January 04, 2018, 22:40:50
Name Type Default Comment
decimal (18, 3)
@CartGUID uniqueidentifier Cart GUID.

dbo.CompareNames

Object ID: 818817979; Created: November 26, 2012, 12:41:34; Modified: March 06, 2013, 11:24:09
Name Type Default Comment
bit
@name1 nvarchar (256)
@name2 nvarchar (256)

dbo.CompareVersions

Object ID: 427265423; Created: July 12, 2019, 13:16:41
Name Type Default Comment
int
@Version1 nvarchar (256)
@Version2 nvarchar (256)

dbo.ComputeEmailHash

Object ID: 275584120; Created: October 03, 2013, 21:41:37
Name Type Default Comment
char (32)
@ItemGUID uniqueidentifier

dbo.ConcateEmailAddresses

Object ID: 1796461724; Created: December 10, 2014, 15:07:22
Name Type Default Comment
nvarchar (max)
@EmailAdresses1 nvarchar (max)
@EmailAdresses2 nvarchar (max)
@Separator nvarchar (2)

dbo.Concatenate5Values

Get string from items separated with given delimiter.

Object ID: 2042138716; Created: August 25, 2015, 14:54:51
Name Type Default Comment
nvarchar (2330)
@Delimiter nvarchar (20)
@Argument1 sql_variant Item to concatenate.
@Argument2 sql_variant Item to concatenate.
@Argument3 sql_variant Item to concatenate.
@Argument4 sql_variant Item to concatenate.
@Argument5 sql_variant Item to concatenate.

dbo.ConvertCurrency

Object ID: 737138117; Created: January 17, 2016, 14:52:56
Name Type Default Comment
float (53, 0)
@InputCurrency uniqueidentifier
@OutputCurrency uniqueidentifier
@Date datetime
@Price float (53, 0)

dbo.ConvertCurrencyOrReturnNull

Object ID: 1540005063; Created: December 02, 2016, 22:21:20
Name Type Default Comment
float (53, 0)
@InputCurrency uniqueidentifier
@OutputCurrency uniqueidentifier
@Date datetime
@Price float (53, 0)

dbo.ConvertCurrencyOrReturnZero

Object ID: 1588005234; Created: December 02, 2016, 22:21:21
Name Type Default Comment
float (53, 0)
@InputCurrency uniqueidentifier
@OutputCurrency uniqueidentifier
@Date datetime
@Price float (53, 0)

dbo.ConvertDateTimeToUniversalSortableFormat

Object ID: 1265491637; Created: September 04, 2013, 21:57:10
Name Type Default Comment
char (20)
@DateTime datetime

dbo.ConvertToDefaultCurrency

Object ID: 1470068423; Created: March 04, 2014, 21:38:21
Name Type Default Comment
float (53, 0)
@InputCurrency uniqueidentifier
@Date datetime
@Price float (53, 0)

dbo.ConvertToEnglishTitleCase

Object ID: 443265480; Created: July 12, 2019, 13:16:41
Name Type Default Comment
nvarchar (max)
@Input nvarchar (max)

dbo.CreateLink

Object ID: 2061966422; Created: April 04, 2013, 21:32:51
Name Type Default Comment
nvarchar (2000)
@ItemGUID uniqueidentifier
@ItemFolderName nvarchar (256)
@LinkText nvarchar (256)

dbo.CreateTeamTaskFileAs

Object ID: 1369771937; Created: January 18, 2011, 16:29:10
Name Type Default Comment
nvarchar (max)
@TaskFileAs nvarchar (256)
@DelegatorFileAs nvarchar (256)
@Language nvarchar (2)

dbo.DateDiffHumanReadable

Generates a human readable difference between two dates, in the form '1y 5d 3h 2m 6s 10ms'

Object ID: 1112703362; Created: March 30, 2015, 21:29:50
Name Type Default Comment
varchar (64)
@DateStart datetime Start date.
@DateEnd datetime End date.
@Precision varchar (2) Precision can be one of y, d, h, m, s, ms.

dbo.DecodeFromBase64

Decode text from base64.

Object ID: 277888357; Created: January 29, 2015, 21:58:17
Name Type Default Comment
varchar (max)
@InputTextInBase64 varchar (max) Text in base64 that will be decoded.

dbo.EncodeToBase64

Encode text to base64.

Object ID: 261888300; Created: January 29, 2015, 21:58:17
Name Type Default Comment
varchar (max)
@InputText varchar (max) Text to encode to base64.

dbo.EscapeString

Object ID: 1670297010; Created: November 26, 2012, 12:41:24
Name Type Default Comment
nvarchar (max)
@Text nvarchar (max)

dbo.eWaySVF_ApplyColumnPermissions

Object ID: 1008722646; Created: April 24, 2009, 16:47:20; Modified: March 06, 2013, 11:24:09
Name Type Default Comment
bit
@columnName nvarchar (255)
@folderName nvarchar (50)
@ownerGUID uniqueidentifier
@userID uniqueidentifier

dbo.F_GetDateFromWeek

Object ID: 1236199454; Created: August 01, 2008, 10:57:05; Modified: August 01, 2008, 12:54:52
Name Type Default Comment
smalldatetime
@week int

dbo.FormatDateTime

Object ID: 379265252; Created: July 12, 2019, 13:16:41
Name Type Default Comment
nvarchar (max)
@Datetime datetime
@FormatString nvarchar (max)

dbo.GeneratePassword

Generates random password.

Object ID: 1093279350; Created: October 12, 2015, 22:10:34
Name Type Default Comment
varchar (256)
@PasswordLength int Length of the password.

dbo.GetAdditionalFieldByName

Object ID: 1252459786; Created: December 10, 2014, 15:07:20
Name Type Default Comment
varchar (8)
@FieldName nvarchar (256)
@FolderName nvarchar (50)

dbo.GetAdditionalFieldFromGlobalSettings

Object ID: 1364460185; Created: December 10, 2014, 15:07:21
Name Type Default Comment
varchar (8)
@FolderName nvarchar (256)
@GlobalSettingsName nvarchar (256)
@GlobalSettingsCategoryName nvarchar (256)

dbo.GetAdditionalFieldsMaxServerItemChanged

Selects the newest additional field's server_itemchanged inform the wcf cache whether to refresh.

dbo.GetAdministratorGUID

dbo.GetAllWorkflowStatesWithName

Object ID: 292456366; Created: December 10, 2014, 15:07:17
Name Type Default Comment
@EnumName nvarchar (256)
@StateFileAs nvarchar (256)

dbo.GetAssociatedAdditionalFields

Returns table of associated additional fields for the two given folders.

Object ID: 641137775; Created: January 17, 2016, 14:52:55
Name Type Default Comment
@SourceObjectTypeID int Object type of the source folder.
@TargetObjectTypeID int Object type of the target folder.

dbo.GetColumnNamesIgnoredByChangeValueLogingHistoryMechanism

Returns table of ignored fields during item fields value changes into history.

dbo.GetContactCompaniesList

Object ID: 1469964313; Created: March 14, 2013, 10:05:47
Name Type Default Comment
nvarchar (max)
@ContactGUID uniqueidentifier

dbo.GetContactMail

Object ID: 809769942; Created: July 12, 2010, 15:16:09; Modified: March 06, 2013, 11:24:09
Name Type Default Comment
nvarchar (256)
@ContactGUID uniqueidentifier

dbo.GetContactPhoneNumber

Get Contact phone number in the same way as eWay GUI.

Object ID: 1468896650; Created: June 07, 2015, 16:36:26
Name Type Default Comment
nvarchar (256)
@ContactGUID uniqueidentifier ParameterDescription

dbo.GetCorpusChristi

Object ID: 116455739; Created: December 10, 2014, 15:07:15
Name Type Default Comment
smalldatetime
@Year int

dbo.GetDateAndTimeInNVarchar

Object ID: 783914460; Created: September 28, 2017, 22:52:48
Name Type Default Comment
nvarchar (256)
@DateTime datetime

dbo.GetDateInNVarchar

Object ID: 1141279521; Created: October 12, 2015, 22:10:35
Name Type Default Comment
nvarchar (256)
@DateTime datetime

dbo.GetDatesDifferenceInBussinesHours

Get difference between two dates as business hours sum in this interval.

Object ID: 1744425684; Created: November 10, 2015, 22:13:27
Name Type Default Comment
decimal (18, 2)
@From datetime From this date with time count bussiness fours.
@To datetime To this date with time count bussiness fours.
@UserGUID uniqueidentifier Guid of user - vacation is taked into account.

dbo.GetDefaultBackupDirectory

dbo.GetDefaultCurrencyIdentifier

dbo.GetDefaultLanguage

Get default language of eway.

dbo.GetDefaultLanguageEnumValue

Get enum translation in default language.

Object ID: 47299924; Created: May 18, 2018, 20:38:09
Name Type Default Comment
nvarchar (256)
@ItemGUID uniqueidentifier ItemGUID from dbo.EWD_EnumValues.

dbo.GetDefaultRate

Object ID: 1556005120; Created: December 02, 2016, 22:21:21
Name Type Default Comment
@UserGUID uniqueidentifier
@Date datetime

dbo.GetDelay

Object ID: 592721164; Created: September 03, 2008, 19:26:33; Modified: March 06, 2013, 11:24:09
Name Type Default Comment
int
@ProjectGUID uniqueidentifier

dbo.GetDurationInHours

Object ID: 1812917530; Created: November 26, 2012, 13:00:57
Name Type Default Comment
decimal (18, 2)
@StartDate datetime
@EndDate datetime

dbo.GetEasterFriday

Object ID: 100455682; Created: December 10, 2014, 15:07:15
Name Type Default Comment
smalldatetime
@Year int

dbo.GetEasterMonday

Object ID: 1654296953; Created: November 26, 2012, 12:41:24
Name Type Default Comment
smalldatetime
@Year int

dbo.GetEmailsFromGroup

Object ID: 852302196; Created: December 16, 2013, 21:25:10
Name Type Default Comment
nvarchar (max)
@GroupGUID uniqueidentifier

dbo.GetEmailsFromGroupByName

Object ID: 868302253; Created: December 16, 2013, 21:25:10
Name Type Default Comment
nvarchar (max)
@GroupName nvarchar (256)

dbo.GetEmptyGUID

Gets empty unique identifier.

dbo.GetEnumGUID

Object ID: 388456708; Created: December 10, 2014, 15:07:18
Name Type Default Comment
uniqueidentifier
@EnumTypeName nvarchar (50)
@EnumValueName nvarchar (50)

dbo.GetEnumTypeName

Gets EnumType EnumName by specified EnumValue ItemGUID

Object ID: 136699885; Created: March 24, 2015, 21:32:26
Name Type Default Comment
nvarchar (50)
@EnumValueGUID uniqueidentifier EnumValue item unique identifier

dbo.GetExchangeRate

Object ID: 132455796; Created: December 10, 2014, 15:07:15
Name Type Default Comment
float (53, 0)
@InputCurrency uniqueidentifier
@OutputCurrency uniqueidentifier
@Date datetime

dbo.GetExchangeRatesDefaultCurrencyColumnsTable

dbo.GetExchangeRatesParentRelationTypesTable

dbo.GetExtendedPropertyValue

Object ID: 1860461952; Created: December 10, 2014, 15:07:22
Name Type Default Comment
sql_variant
@ExtededPropertyName varchar (256)

dbo.GetFinDirEmails

dbo.GetFirstDayOfMonth

Get first day of month from date given by parameter.

Object ID: 149887901; Created: January 29, 2015, 21:58:16
Name Type Default Comment
datetime
@Date datetime Some day of desired month.

dbo.GetFullName

Object ID: 1222295414; Created: July 21, 2011, 07:50:39
Name Type Default Comment
nvarchar (256)
@pLastName nvarchar (256)
@pFirstName nvarchar (256)
@pMiddleName nvarchar (256)
@pPrefix nvarchar (256)
@pSuffix nvarchar (256)

dbo.GetGlobalSettingValue

Gets GlobalSetting value.

Object ID: 1134691886; Created: January 25, 2019, 20:58:58
Name Type Default Comment
nvarchar (max)
@SettingsName nvarchar (256) Internal name of the GlobalSetting.
@SettingsCategoryName nvarchar (256) Not used anymore. Use NULL.
@DefaultValue nvarchar (max) Default value returned when the setting does not have any value defined.

dbo.GetGlobalSettingValueOrNull

Object ID: 1102691772; Created: January 25, 2019, 20:58:58
Name Type Default Comment
nvarchar (max)
@SettingsName nvarchar (256)

dbo.GetHourlyRate

Object ID: 1518068594; Created: March 04, 2014, 21:38:22
Name Type Default Comment
int
@UserGUID uniqueidentifier
@Date datetime

dbo.GetHourlyRateAndHourlyRateDefaultCurrency

Object ID: 2015554464; Created: May 26, 2014, 12:27:18
Name Type Default Comment
@UserGUID uniqueidentifier
@Date datetime

dbo.GetIndexesOnColumn

Gets indexes referenced by specified column.

Object ID: 2066783116; Created: May 18, 2018, 20:38:06
Name Type Default Comment
@TableName nvarchar (256) Name of the table.
@ColumnName nvarchar (256) Name of the column.

dbo.GetInternalProjects

dbo.GetJournalFirstAcceptableDate

Gets the value represents first date that is acceptable by journal lock logic

dbo.GetLanguages

Get all languages supported in eWay.

dbo.GetLastDayOfMonth

Get last day of month from date given by parameter.

Object ID: 165887958; Created: January 29, 2015, 21:58:16
Name Type Default Comment
datetime
@Date datetime Some day of desired month.

dbo.GetLeadContactPerson

Object ID: 792858387; Created: October 17, 2016, 12:50:55
Name Type Default Comment
nvarchar (max)
@ItemGUID uniqueidentifier
@ReturnAsLink bit

dbo.GetLeadCustomer

Object ID: 808858444; Created: October 17, 2016, 12:50:55
Name Type Default Comment
nvarchar (max)
@ItemGUID uniqueidentifier
@ReturnAsLink bit

dbo.GetLeadModuleCommonRelationsForCopying

Object ID: 2107063188; Created: November 16, 2017, 09:11:48
Name Type Default Comment
@SourceItemGUID uniqueidentifier
@TargetItemGUID uniqueidentifier
@TargetObjectTypeID tinyint

dbo.GetLocalizedEnumValueStringByLanguage

Gets localized enumeration value by given language code.

Object ID: 1968022788; Created: July 12, 2018, 20:23:46
Name Type Default Comment
nvarchar (256)
@EnumValueItemGUID uniqueidentifier FileAs of localized string.
@LanguageCode varchar (2) Language to localize enumeration value.

dbo.GetLocalizedString

Get localized string.

Object ID: 1376424373; Created: November 10, 2015, 22:13:23
Name Type Default Comment
nvarchar (256)
@FileAs nvarchar (256) FileAs of localized string.

dbo.GetLocalizedStringByLanguage

Get localized string by given language code.

Object ID: 1952022731; Created: July 12, 2018, 20:23:46
Name Type Default Comment
nvarchar (256)
@Language varchar (6) Language to localize string.
@FileAs nvarchar (256) FileAs of localized string.

dbo.GetMD5

Object ID: 1233491523; Created: September 04, 2013, 21:57:10
Name Type Default Comment
char (32)
@Input nvarchar (max)

dbo.GetMD5NonUnicode

Encrypts non-unicode string using MD5.

Object ID: 1166744055; Created: July 10, 2019, 21:34:04
Name Type Default Comment
char (32)
@Input varchar (max) Non-unicode string.

dbo.GetMeetingResponseRelationType

Object ID: 1286295642; Created: September 13, 2011, 17:33:10; Modified: March 06, 2013, 11:24:10
Name Type Default Comment
nvarchar (50)
@UserItemGUID uniqueidentifier
@CalendarItemGUID uniqueidentifier

dbo.GetMonthlyTotals

Object ID: 1134743941; Created: July 10, 2019, 21:34:04
Name Type Default Comment
@UserGUID uniqueidentifier
@Year int
@Month tinyint

dbo.GetNextWorkDay

Object ID: 2075063074; Created: November 16, 2017, 09:11:47
Name Type Default Comment
datetime
@time datetime

dbo.GetNormalizedPhoneNumber

Returns normalized phone number in the same way as eWay GUI.

Object ID: 277328498; Created: April 04, 2016, 22:11:55
Name Type Default Comment
varchar (256)
@PhoneNumber nvarchar (256) Phone number
@IgnorePlusSign bit

dbo.GetNumberOfColumnsOnIndex

Gets number of columns associated with specified index.

Object ID: 2082783173; Created: May 18, 2018, 20:38:07
Name Type Default Comment
int
@IndexName varchar (256) Name of the index.
@CountIncludedColumns bit Add also included columns.

dbo.GetNumberOfWorkDays

Object ID: 1118691829; Created: January 25, 2019, 20:58:58
Name Type Default Comment
decimal (18, 3)
@CountryEn uniqueidentifier
@StartDate datetime
@EndDate datetime

dbo.GetObjectTypeID

Object ID: 1204459615; Created: December 10, 2014, 15:07:20
Name Type Default Comment
int
@FolderName varchar (50)

dbo.GetParentCurrencyOfCart

Object ID: 1630068993; Created: March 04, 2014, 21:38:23
Name Type Default Comment
uniqueidentifier
@CartGUID uniqueidentifier

dbo.GetParentCurrencyOfGoodsInCart

Object ID: 925714846; Created: September 08, 2016, 22:16:39
Name Type Default Comment
uniqueidentifier
@GoodsInCartGUID uniqueidentifier

dbo.GetParentCurrencyOfPayments

Object ID: 2073370751; Created: January 29, 2015, 21:58:14
Name Type Default Comment
uniqueidentifier
@PaymentsGUID uniqueidentifier

dbo.GetParentCurrencyOfWorkReport

Object ID: 31299867; Created: May 18, 2018, 20:38:09
Name Type Default Comment
uniqueidentifier
@WorkReportGUID uniqueidentifier

dbo.GetPeriod

Object ID: 789577851; Created: May 18, 2008, 17:47:36
Name Type Default Comment
int
@RelDate smalldatetime

dbo.GetPhoneNumberColumnsTable

Returns table with phone number columns including normalized phone number columns.

dbo.GetPohodaDefaultCurrencyCode

dbo.GetPohodaInvoiceTypeID

Get Pohoda invoice type ID from eWay cart type fileas.

Object ID: 2127711028; Created: September 17, 2015, 22:07:14
Name Type Default Comment
int
@CartTypeFileAs nvarchar (256) eWay cart type fileas.

dbo.GetPohodaLanguageCode

Get language code from internal Pohoda database table.

dbo.GetPreviousBusinessDay

dbo.GetProjectLeadEmailSubject

Get normalized email subject leading for differents email notifications.

Object ID: 1096703305; Created: March 30, 2015, 21:29:50
Name Type Default Comment
nvarchar (256)
@SuperiorFileAs nvarchar (256) FileAs of lead or project.
@SuperiorHID int HID of lead or project.
@CustomerFileAs nvarchar (256) FileAs of customer.

dbo.GetProjectManagerEmail

Object ID: 1895938076; Created: December 10, 2014, 15:07:12
Name Type Default Comment
nvarchar (256)
@ProjectGUID uniqueidentifier

dbo.GetProjectTeamEmails

Object ID: 396072697; Created: May 26, 2014, 12:27:22
Name Type Default Comment
nvarchar (max)
@ProjectGUID uniqueidentifier

dbo.GetRandomTime

Object ID: 332684383; Created: March 26, 2014, 09:43:08
Name Type Default Comment
varchar (16)
@MinTime varchar (8)
@MaxTime varchar (8)

dbo.GetRecipientsFromUserGroup

Object ID: 1622296839; Created: November 26, 2012, 12:41:20; Modified: March 06, 2013, 11:24:10
Name Type Default Comment
nvarchar (max)
@GroupName nvarchar (256)

dbo.GetRecurringTaskNewOccurenceDate

Object ID: 1038691544; Created: January 25, 2019, 20:58:57
Name Type Default Comment
datetime
@TaskGUID uniqueidentifier

dbo.GetSalary

Object ID: 197888072; Created: January 29, 2015, 21:58:16
Name Type Default Comment
@UserGUID uniqueidentifier
@Date datetime
@WorkReportEn uniqueidentifier

dbo.GetSalary_Old

Object ID: 84195350; Created: July 11, 2008, 14:32:20; Modified: March 06, 2013, 11:24:09
Name Type Default Comment
float (53, 0)
@UserGUID uniqueidentifier
@Date datetime
@RateType int

dbo.GetShortDate

Object ID: 1342067967; Created: March 04, 2014, 21:38:20
Name Type Default Comment
datetime
@Date datetime

dbo.GetTableColumnList

Gets list of columns in table (without computed columns).

Object ID: 1574361469; Created: March 29, 2019, 20:43:18
Name Type Default Comment
nvarchar (max)
@TableName nvarchar (64) Name of the table.
@NotLikeFilter nvarchar (64) Expression to filter some columns.
@Prefix nvarchar (64) Prefix for the column names.

dbo.GetTeamTaskSolversHTMLList

Object ID: 1353771880; Created: January 18, 2011, 16:29:03; Modified: March 06, 2013, 11:24:10
Name Type Default Comment
nvarchar (max)
@pParentTaskGUID uniqueidentifier

dbo.GetTimeInNVarchar

Object ID: 1492460641; Created: December 10, 2014, 15:07:21
Name Type Default Comment
nvarchar (256)
@DateTime datetime

dbo.GetUserEmail

Object ID: 1760425741; Created: November 10, 2015, 22:13:27
Name Type Default Comment
nvarchar (256)
@UserGUID uniqueidentifier

dbo.GetUsersFromGroups

Get users GUIDs and emails from list of groups separated by semicolon.

dbo.GetUserTeamRoles

Object ID: 1270295585; Created: September 13, 2011, 17:33:10; Modified: March 06, 2013, 11:24:10
Name Type Default Comment
nvarchar (max)
@UserItemGUID uniqueidentifier
@ProjectItemGUID uniqueidentifier

dbo.GetUTC

Object ID: 1249491580; Created: September 04, 2013, 21:57:10
Name Type Default Comment
datetime
@DateTime datetime

dbo.GetWebServiceSetting

Object ID: 347265138; Created: July 12, 2019, 13:16:41
Name Type Default Comment
nvarchar (max)
@SettingName nvarchar (max)

dbo.GetWeek

Gets the year and the week number. WARNING! This procedure does not return the week number according the ISO standard.

Object ID: 1481524807; Created: June 23, 2016, 22:18:42
Name Type Default Comment
varchar (10)
@RelDate smalldatetime

dbo.GetWorkflowActionInfo

Function helps find out in what workflow is action used.

dbo.GetWorkflowStateGuid

Object ID: 1628897220; Created: June 07, 2015, 16:36:28
Name Type Default Comment
uniqueidentifier
@StateFileAs nvarchar (256)
@ParentTypeGUID uniqueidentifier

dbo.GetWorkflowStateGuidByGlobalSettingsName

Object ID: 332072469; Created: May 26, 2014, 12:27:22
Name Type Default Comment
uniqueidentifier
@GlobalSettingsName nvarchar (256)
@ItemTypeGUID uniqueidentifier

dbo.GetWorkingDaysDifference

Get dates difference in working days.

Object ID: 1604565150; Created: July 27, 2015, 12:43:11
Name Type Default Comment
int
@StartDate datetime First date for computation FirstDate - SecondDate = result
@EndDate datetime Second date for computation FirstDate - SecondDate = result
@UserGUID uniqueidentifier GUID of user, that is checked for vacation and legal holidays.

dbo.HtmlDecode

Object ID: 363265195; Created: July 12, 2019, 13:16:41
Name Type Default Comment
nvarchar (max)
@Text nvarchar (max)

dbo.IsColumnEditable

Object ID: 561437074; Created: February 22, 2013, 08:32:02; Modified: March 06, 2013, 11:24:09
Name Type Default Comment
bit
@ColumnName nvarchar (255)
@FolderName nvarchar (50)

dbo.IsDateWeekend

Indicates whether a specified day is a weekend day.

Object ID: 1070691658; Created: January 25, 2019, 20:58:58
Name Type Default Comment
bit
@Day datetime Day to be checked.

dbo.IsFeatureEnabled

Gets value indicating whether is feature enabled.

Object ID: 1757821920; Created: August 31, 2017, 22:57:01
Name Type Default Comment
bit
@FeatureName nvarchar (256) Name of the feature.

dbo.IsItemChangedRecentlyByUser

Indicates whether an item has been updated by user.

Object ID: 1091235388; Created: February 23, 2016, 22:10:40
Name Type Default Comment
bit
@ItemGUID uniqueidentifier GUID of the item.
@Minutes bigint Interval in minutes.

dbo.IsNullOrEmpty

Object ID: 793769885; Created: July 12, 2010, 15:16:02
Name Type Default Comment
nvarchar (256)
@TestedValue nvarchar (256)
@DefaultValue nvarchar (256)

dbo.IsUserAdmin

Object ID: 2023938532; Created: December 10, 2014, 15:07:14
Name Type Default Comment
bit
@UserGUID uniqueidentifier

dbo.IsValidGuid

Object ID: 917578307; Created: May 18, 2008, 17:47:37
Name Type Default Comment
bit
@input nvarchar (max)

dbo.IsWorkingDay

Indicates whether a specified day is a working day of a defined user.

Object ID: 1289524123; Created: June 23, 2016, 22:18:39
Name Type Default Comment
bit
@UserGUID uniqueidentifier Identifier of the user.
@Date datetime Date to check.

dbo.MaxNumber

Object ID: 1814297523; Created: November 26, 2012, 12:41:27
Name Type Default Comment
sql_variant
@val1 sql_variant
@val2 sql_variant

dbo.NormalizeLineEndings

Object ID: 459265537; Created: July 12, 2019, 13:16:41
Name Type Default Comment
nvarchar (max)
@Input nvarchar (max)

dbo.NormalizeMultipleBlankLines

Object ID: 475265594; Created: July 12, 2019, 13:16:41
Name Type Default Comment
nvarchar (max)
@Input nvarchar (max)

dbo.RaiseFunctionError

Object ID: 1086691715; Created: January 25, 2019, 20:58:58
Name Type Default Comment
bit
@SourceFunctionName nvarchar (256)
@Message nvarchar (256)

dbo.RegexIsMatch

Object ID: 411265366; Created: July 12, 2019, 13:16:41
Name Type Default Comment
bit
@Input nvarchar (max)
@Pattern nvarchar (max)

dbo.RegexReplace

Object ID: 395265309; Created: July 12, 2019, 13:16:41
Name Type Default Comment
nvarchar (max)
@Input nvarchar (max)
@Pattern nvarchar (max)
@Replacement nvarchar (max)

dbo.RemoveDiacritics

Object ID: 996302709; Created: December 16, 2013, 21:25:13
Name Type Default Comment
nvarchar (1024)
@input nvarchar (1024)

dbo.RemoveInvalidCodePoints

Object ID: 507265708; Created: July 12, 2019, 13:16:41
Name Type Default Comment
nvarchar (max)
@Input nvarchar (max)

dbo.RemoveInvalidPathCharacters

Removes invalid characters in Windows file path.

Object ID: 151580224; Created: November 16, 2017, 09:11:49
Name Type Default Comment
nvarchar (1024)
@FileName nvarchar (1024) File name which should be fixed.

dbo.RemoveInvalidXmlCharacters

Object ID: 491265651; Created: July 12, 2019, 13:16:41
Name Type Default Comment
nvarchar (max)
@Input nvarchar (max)

dbo.RemoveNonBmpCharacters

Removes all UTF-16 surrogate code points.

Object ID: 1214744226; Created: July 10, 2019, 21:34:05
Name Type Default Comment
nvarchar (max)
@Input nvarchar (max) Input string.

dbo.ShowWhiteSpace

Object ID: 260456252; Created: December 10, 2014, 15:07:17
Name Type Default Comment
nvarchar (max)
@Text nvarchar (max)

dbo.StripName

Object ID: 802817922; Created: November 26, 2012, 12:41:34; Modified: March 06, 2013, 11:24:09
Name Type Default Comment
nvarchar (256)
@name nvarchar (256)
@charsToStrip nvarchar (256)
@charsToStripDelimiter char (1)
@stripSpaces bit

dbo.StripSpaces

Object ID: 625437302; Created: February 22, 2013, 08:32:03
Name Type Default Comment
nvarchar (max)
@Text nvarchar (max)

dbo.StripTags

Object ID: 1901965852; Created: March 27, 2013, 21:39:05
Name Type Default Comment
nvarchar (max)
@HTMLText nvarchar (max)

dbo.TableHasIdentity

Object ID: 1517964484; Created: March 14, 2013, 10:05:48
Name Type Default Comment
bit
@TableName nvarchar (64)

dbo.TallySplit

Object ID: 1812461781; Created: December 10, 2014, 15:07:22
Name Type Default Comment
@String nvarchar (max)
@Delim char (1)

dbo.TranslateQueryToLocal

This function translates simple queries to be callable at local databases. Translate process: Replace '[EWD_' -> '[' Replace '[EWR_' -> '[' Replace '[EWE_' -> '[' Replace '[EWF_' -> '[' Replace ''EWD_' -> '' Replace ''EWR_' -> '' Replace ''EWE_' -> '' Replace ''EWF_' -> '' Replace '[ItemGUID]' -> '[ItemID]' Replace '--LocalOnly: ' -> '' - place for statements local only. Ex. --LocalOnly: Table.ItemState != 3' Replace '/* -ServerOnly- */' -> '/*' Replace '/* -/ServerOnly- */' -> '*/'

Object ID: 337240802; Created: February 28, 2017, 22:19:13
Name Type Default Comment
nvarchar (max)
@Query nvarchar (max) The query to be translated.

dbo.Trim

Object ID: 408401270; Created: November 07, 2018, 20:16:31
Name Type Default Comment
nvarchar (max)
@Value nvarchar (max)
@MaxLength int
@IncludeDots bit
@TrimLeftSide bit

dbo.TruncateToSmallDateTime

Object ID: 1060302937; Created: December 16, 2013, 21:25:14
Name Type Default Comment
datetime
@DateTime datetime

dbo.UpperFirstLetter

Upper first letter of given string.

Object ID: 1392424430; Created: November 10, 2015, 22:13:23
Name Type Default Comment
nvarchar (256)
@Text nvarchar (256) Text where will be first letter upper case.