TBM Schema

Tables

dbo.AnalysisImportSettings
dbo.Checklist
dbo.ChecklistItem
dbo.Contractor
dbo.ContractorLanguage
dbo.ContractorMilestone
dbo.ContractorPaymentMethod
dbo.ContractorPriceList
dbo.ContractorService
dbo.ContractorTestPiece
dbo.ContractorUnavailability
dbo.ContractorUnitConversion
dbo.ContractorWorkField
dbo.Country
dbo.Currency
dbo.CurrencyRate
dbo.Customer
dbo.CustomerCategory
dbo.CustomerMilestone
dbo.CustomerPriceList
dbo.CustomField
dbo.DocumentChecklistItem
dbo.DocumentMessage
dbo.EmailAccount
dbo.Employee
dbo.Expense
dbo.ExpenseCategory
dbo.ExpenseType
dbo.FavoriteItem
dbo.FileType
dbo.FuzzyType
dbo.FuzzyTypeKit
dbo.FuzzyTypeKitDetail
dbo.IncomeOther
dbo.Invoice
dbo.InvoiceDetail
dbo.InvoiceDetailCorrection
dbo.InvoiceIn
dbo.InvoiceInDetail
dbo.Language
dbo.LanguageCombination
dbo.MailMessage
dbo.MailMessageRecipient
dbo.MessageTemplate
dbo.Payment
dbo.PaymentDetail
dbo.PaymentMethodSet
dbo.PaymentOut
dbo.PaymentOutDetail
dbo.PlannerException
dbo.PredefinedTaskSet
dbo.PredefinedTaskSetDetail
dbo.PriceList
dbo.PriceListItem
dbo.Quote
dbo.QuoteItem
dbo.Region
dbo.SoftwareApplication
dbo.Tax
dbo.TestPiece
dbo.TestPieceProofreader
dbo.TranslationAssignment
dbo.TranslationAssignmentDetail
dbo.TranslationAssignmentPayable
dbo.TranslationAssignmentPick
dbo.TranslationJob
dbo.TranslationJobDetail
dbo.TranslationJobReceivable
dbo.TranslationJobSchedule
dbo.TranslationProject
dbo.Unit
dbo.UnitWeight
dbo.User
dbo.VendorGroup
dbo.VendorGroupItem
dbo.Workflow
dbo.WorkflowDetail
dbo.WorkingField
dbo.WorkingFieldCategory
dbo.WorkingType

Table AnalysisImportSettings

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	ImportType	bit
	WorkType	uniqueidentifier
	DefaultUnit	uniqueidentifier
	UnitType	int
	ConvertToAnotherUnit	bit
	ConvertTargetUnit	uniqueidentifier
	ConvertBaseUnit	int
	ConvertDividend	money
	AdditionalWorkTypes	uniqueidentifier
	OptimisticLockField	int
Indexes
	PK_AnalysisImportSettings	ON Id
	iAdditionalWorkTypes_AnalysisImportSettings	ON AdditionalWorkTypes
	iConvertTargetUnit_AnalysisImportSettings	ON ConvertTargetUnit
	iDefaultUnit_AnalysisImportSettings	ON DefaultUnit
	iWorkType_AnalysisImportSettings	ON WorkType
Foreign Keys
	FK_AnalysisImportSettings_ConvertTargetUnit	( ConvertTargetUnit ) ref Unit (Id)
	FK_AnalysisImportSettings_DefaultUnit	( DefaultUnit ) ref Unit (Id)
	FK_AnalysisImportSettings_AdditionalWorkTypes	( AdditionalWorkTypes ) ref Workflow (Id)
	FK_AnalysisImportSettings_WorkType	( WorkType ) ref WorkingType (Id)

Table Checklist

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	OptimisticLockField	int
Indexes
	PK_Checklist	ON Id

Table ChecklistItem

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Checklist	uniqueidentifier
	Priority	int
	Contents	nvarchar(300)
	OptimisticLockField	int
Indexes
	PK_ChecklistItem	ON Id
	iChecklist_ChecklistItem	ON Checklist
Foreign Keys
	FK_ChecklistItem_Checklist	( Checklist ) ref Checklist (Id)

Table Contractor

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	DateAdded	datetime
	EmploymentStatus	int
	Name	nvarchar(100)
	LastName	nvarchar(100)
	Title	nvarchar(100)
	Email	nvarchar(100)
	Email2	nvarchar(100)
	Phone	nvarchar(100)
	Phone2	nvarchar(100)
	Fax	nvarchar(100)
	Notes	nvarchar(4000)
	CountryRef	uniqueidentifier
	Address	nvarchar(1000)
	Address2	nvarchar(1000)
	City	nvarchar(100)
	State	nvarchar(100)
	Zip	nvarchar(100)
	Birthday	datetime
	Skype	nvarchar(100)
	OtherMessagingAppId1	nvarchar(100)
	OtherMessagingAppId2	nvarchar(100)
	Folder	nvarchar(1000)
	Web	nvarchar(300)
	WebProz	nvarchar(300)
	WebLinkedIn	nvarchar(300)
	WebFacebook	nvarchar(300)
	WebTransCafe	nvarchar(300)
	WebTwitter	nvarchar(300)
	Photo	varbinary(max)
	CompanyName	nvarchar(200)
	ContractorType	int
	VAT	nvarchar(100)
	DefaultInvoiceDueDateType	int
	DefaultInvoiceDueDateDays	int
	DefaultPOTemplate	nvarchar(100)
	DefaultTax1	uniqueidentifier
	DefaultTax2	uniqueidentifier
	DefaultTax3	uniqueidentifier
	AverageRating	float
	Languages	nvarchar(4000)
	Rates	nvarchar(4000)
	Archived	bit
	ArchiveReason	nvarchar(500)
	DefaultCurrency	uniqueidentifier
	DefaultFuzzyTypeSet	uniqueidentifier
	GroupShareId	nvarchar(100)
	StudioName	nvarchar(100)
	GroupShareUserName	nvarchar(100)
	LanguageCloudId	nvarchar(100)
	DefaultUnit	uniqueidentifier
	NativeLanguage	uniqueidentifier
	NativeLanguagesStr	nvarchar(100)
	MinCharge	money
	TimeZoneId	nvarchar(100)
	LanguageCode	nvarchar(10)
	ServicesProvided	nvarchar(1000)
	DefaultAnalysisImportSettings	uniqueidentifier
	WillingnessToWork	int
	DontOfferTests	bit
	OfferedTestPieces	nvarchar(max)
	DefaultPaymentType	int
	PricePercentageValue	money
	PricePerHour	money
	OptimisticLockField	int
Indexes
	PK_Contractor	ON Id
	iCountryRef_Contractor	ON CountryRef
	iDefaultAnalysisImportSettings_Contractor	ON DefaultAnalysisImportSettings
	iDefaultCurrency_Contractor	ON DefaultCurrency
	iDefaultFuzzyTypeSet_Contractor	ON DefaultFuzzyTypeSet
	iDefaultTax1_Contractor	ON DefaultTax1
	iDefaultTax2_Contractor	ON DefaultTax2
	iDefaultTax3_Contractor	ON DefaultTax3
	iDefaultUnit_Contractor	ON DefaultUnit
	iNativeLanguage_Contractor	ON NativeLanguage
Foreign Keys
	FK_Contractor_DefaultAnalysisImportSettings	( DefaultAnalysisImportSettings ) ref AnalysisImportSettings (Id)
	FK_Contractor_CountryRef	( CountryRef ) ref Country (Id)
	FK_Contractor_DefaultCurrency	( DefaultCurrency ) ref Currency (Id)
	FK_Contractor_DefaultFuzzyTypeSet	( DefaultFuzzyTypeSet ) ref FuzzyTypeKit (Id)
	FK_Contractor_NativeLanguage	( NativeLanguage ) ref Language (Id)
	FK_Contractor_DefaultTax1	( DefaultTax1 ) ref Tax (Id)
	FK_Contractor_DefaultTax2	( DefaultTax2 ) ref Tax (Id)
	FK_Contractor_DefaultTax3	( DefaultTax3 ) ref Tax (Id)
	FK_Contractor_DefaultUnit	( DefaultUnit ) ref Unit (Id)

Table ContractorLanguage

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Contractor	uniqueidentifier
	Language	uniqueidentifier
	Fluency	nvarchar(200)
	Approved	smallint
	OptimisticLockField	int
Indexes
	PK_ContractorLanguage	ON Id
	iContractor_ContractorLanguage	ON Contractor
	iLanguage_ContractorLanguage	ON Language
Foreign Keys
	FK_ContractorLanguage_Contractor	( Contractor ) ref Contractor (Id)
	FK_ContractorLanguage_Language	( Language ) ref LanguageCombination (Id)

Table ContractorMilestone

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Contractor	uniqueidentifier
	MDate	datetime
	Subject	nvarchar(4000)
	Comments	nvarchar(4000)
	Results	nvarchar(2000)
	AlarmTime	datetime
	IsPostponed	bit
	OptimisticLockField	int
Indexes
	PK_ContractorMilestone	ON Id
	iContractor_ContractorMilestone	ON Contractor
Foreign Keys
	FK_ContractorMilestone_Contractor	( Contractor ) ref Contractor (Id)

Table ContractorPaymentMethod

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	Contractor	uniqueidentifier
	Details	nvarchar(4000)
	Currency	uniqueidentifier
	OptimisticLockField	int
Indexes
	PK_ContractorPaymentMethod	ON Id
	iContractor_ContractorPaymentMethod	ON Contractor
	iCurrency_ContractorPaymentMethod	ON Currency
Foreign Keys
	FK_ContractorPaymentMethod_Contractor	( Contractor ) ref Contractor (Id)
	FK_ContractorPaymentMethod_Currency	( Currency ) ref Currency (Id)

Table ContractorPriceList

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Contractor	uniqueidentifier
	PriceList	uniqueidentifier
	Default	bit
	OptimisticLockField	int
Indexes
	PK_ContractorPriceList	ON Id
	iContractor_ContractorPriceList	ON Contractor
	iPriceList_ContractorPriceList	ON PriceList
Foreign Keys
	FK_ContractorPriceList_Contractor	( Contractor ) ref Contractor (Id)
	FK_ContractorPriceList_PriceList	( PriceList ) ref PriceList (Id)

Table ContractorService

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Contractor	uniqueidentifier
	Service	uniqueidentifier
	SourceLanguage	uniqueidentifier
	TargetLanguage	uniqueidentifier
	Comments	nvarchar(1000)
	OptimisticLockField	int
Indexes
	PK_ContractorService	ON Id
	iContractor_ContractorService	ON Contractor
	iService_ContractorService	ON Service
	iSourceLanguage_ContractorService	ON SourceLanguage
	iTargetLanguage_ContractorService	ON TargetLanguage
Foreign Keys
	FK_ContractorService_Contractor	( Contractor ) ref Contractor (Id)
	FK_ContractorService_SourceLanguage	( SourceLanguage ) ref Language (Id)
	FK_ContractorService_TargetLanguage	( TargetLanguage ) ref Language (Id)
	FK_ContractorService_Service	( Service ) ref WorkingType (Id)

Table ContractorTestPiece

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Contractor	uniqueidentifier
	ReferenceNumber	int
	DateAdded	datetime
	DateSubmitted	datetime
	Status	int
	TestPiece	uniqueidentifier
	SourceText	nvarchar(max)
	TargetText	nvarchar(max)
	Comments	nvarchar(4000)
	Score	int
	OptimisticLockField	int
Indexes
	PK_ContractorTestPiece	ON Id
	iContractor_ContractorTestPiece	ON Contractor
	iTestPiece_ContractorTestPiece	ON TestPiece
Foreign Keys
	FK_ContractorTestPiece_Contractor	( Contractor ) ref Contractor (Id)
	FK_ContractorTestPiece_TestPiece	( TestPiece ) ref TestPiece (Id)

Table ContractorUnavailability

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Contractor	uniqueidentifier
	DateStart	datetime
	DateEnd	datetime
	Reason	nvarchar(300)
	OptimisticLockField	int
Indexes
	PK_ContractorUnavailability	ON Id
	iContractor_ContractorUnavailability	ON Contractor
Foreign Keys
	FK_ContractorUnavailability_Contractor	( Contractor ) ref Contractor (Id)

Table ContractorUnitConversion

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Contractor	uniqueidentifier
	ServiceType	uniqueidentifier
	SourceUnit	uniqueidentifier
	TargetUnit	uniqueidentifier
	OptimisticLockField	int
Indexes
	PK_ContractorUnitConversion	ON Id
	iContractor_ContractorUnitConversion	ON Contractor
	iServiceType_ContractorUnitConversion	ON ServiceType
	iSourceUnit_ContractorUnitConversion	ON SourceUnit
	iTargetUnit_ContractorUnitConversion	ON TargetUnit
Foreign Keys
	FK_ContractorUnitConversion_Contractor	( Contractor ) ref Contractor (Id)
	FK_ContractorUnitConversion_SourceUnit	( SourceUnit ) ref Unit (Id)
	FK_ContractorUnitConversion_TargetUnit	( TargetUnit ) ref Unit (Id)
	FK_ContractorUnitConversion_ServiceType	( ServiceType ) ref WorkingType (Id)

Table ContractorWorkField

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Contractor	uniqueidentifier
	WorkField	uniqueidentifier
	Approved	smallint
	OptimisticLockField	int
Indexes
	PK_ContractorWorkField	ON Id
	iContractor_ContractorWorkField	ON Contractor
	iWorkField_ContractorWorkField	ON WorkField
Foreign Keys
	FK_ContractorWorkField_Contractor	( Contractor ) ref Contractor (Id)
	FK_ContractorWorkField_WorkField	( WorkField ) ref WorkingField (Id)

Table Country

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	Code	nvarchar(100)
	NameL1	nvarchar(100)
	NameL2	nvarchar(100)
	NameL3	nvarchar(100)
	Region	uniqueidentifier
	OptimisticLockField	int
Indexes
	PK_Country	ON Id
	iRegion_Country	ON Region
Foreign Keys
	FK_Country_Region	( Region ) ref Region (Id)

Table Currency

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	NameL1	nvarchar(100)
	NameL2	nvarchar(100)
	NameL3	nvarchar(100)
	Symbol	nvarchar(10)
	OptimisticLockField	int
Indexes
	PK_Currency	ON Id

Table CurrencyRate

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Date	datetime
	Currency	uniqueidentifier
	Rate	money
	OptimisticLockField	int
Indexes
	PK_CurrencyRate	ON Id
	iCurrency_CurrencyRate	ON Currency
Foreign Keys
	FK_CurrencyRate_Currency	( Currency ) ref Currency (Id)

Table CustomField

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	EntityType	int
	Name	nvarchar(100)
	Caption	nvarchar(100)
	PredefinedValues	nvarchar(1000)
	ValueType	int
	MaxLength	int
	IsRequired	bit
	RequireUpdate	bit
	RequireDelete	bit
	OptimisticLockField	int
Indexes
	PK_CustomField	ON Id

Table Customer

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	NameL1	nvarchar(100)
	NameL2	nvarchar(100)
	NameL3	nvarchar(100)
	NameShort	nvarchar(100)
	Round	smallint
	Address	nvarchar(1000)
	Street	nvarchar(500)
	House	nvarchar(100)
	Zip	nvarchar(100)
	City	nvarchar(100)
	State	nvarchar(100)
	CountryRef	uniqueidentifier
	AddressCode	nvarchar(100)
	StandardTerm	int
	FirstContact	datetime
	WebPortal	nvarchar(400)
	WebPortalLogin	nvarchar(400)
	WebPortalPassword	nvarchar(400)
	InvoicingDetails	nvarchar(4000)
	InvoicingAmount	int
	Category	uniqueidentifier
	Code	nvarchar(100)
	VAT	nvarchar(100)
	DefaultCurrency	uniqueidentifier
	DefaultTax1	uniqueidentifier
	DefaultTax2	uniqueidentifier
	DefaultTax3	uniqueidentifier
	TaxNumber	nvarchar(100)
	Logo	varbinary(max)
	DefaultInvoiceTemplate	nvarchar(300)
	QuoteDefaultTemplate	nvarchar(100)
	ParentCustomer	uniqueidentifier
	DefaultFuzzyTypeSet	uniqueidentifier
	BlueBoardId	int
	BlueBoardFeedbackLeft	bit
	MinCharge	money
	DefaultInvoiceDueDateType	int
	DefaultInvoiceDueDateDays	int
	DefaultPaymentMethod	uniqueidentifier
	Phone	nvarchar(100)
	Fax	nvarchar(100)
	SupplierCode	nvarchar(100)
	DefaultRate	nvarchar(4000)
	NumberOfJobs	int
	NumberOfInvoices	int
	LatestJob	datetime
	LatestInvoice	datetime
	LastPM	uniqueidentifier
	HideFromQuickJobCreation	bit
	DefaultLanguage	nvarchar(100)
	ApplicationLanguage	int
	NumerationSequence	int
	StudioId	nvarchar(100)
	Color	nvarchar(100)
	DefaultAnalysisImportSettings	uniqueidentifier
	ChargeFree	bit
	LanguageCloudId	nvarchar(100)
	Folder	nvarchar(1000)
	OptimisticLockField	int
Indexes
	PK_Customer	ON Id
	iCategory_Customer	ON Category
	iCountryRef_Customer	ON CountryRef
	iDefaultAnalysisImportSettings_Customer	ON DefaultAnalysisImportSettings
	iDefaultCurrency_Customer	ON DefaultCurrency
	iDefaultFuzzyTypeSet_Customer	ON DefaultFuzzyTypeSet
	iDefaultPaymentMethod_Customer	ON DefaultPaymentMethod
	iDefaultTax1_Customer	ON DefaultTax1
	iDefaultTax2_Customer	ON DefaultTax2
	iDefaultTax3_Customer	ON DefaultTax3
	iParentCustomer_Customer	ON ParentCustomer
Foreign Keys
	FK_Customer_DefaultAnalysisImportSettings	( DefaultAnalysisImportSettings ) ref AnalysisImportSettings (Id)
	FK_Customer_CountryRef	( CountryRef ) ref Country (Id)
	FK_Customer_DefaultCurrency	( DefaultCurrency ) ref Currency (Id)
	FK_Customer_ParentCustomer	( ParentCustomer ) ref Customer (Id)
	FK_Customer_Category	( Category ) ref CustomerCategory (Id)
	FK_Customer_DefaultFuzzyTypeSet	( DefaultFuzzyTypeSet ) ref FuzzyTypeKit (Id)
	FK_Customer_DefaultPaymentMethod	( DefaultPaymentMethod ) ref PaymentMethodSet (Id)
	FK_Customer_DefaultTax1	( DefaultTax1 ) ref Tax (Id)
	FK_Customer_DefaultTax2	( DefaultTax2 ) ref Tax (Id)
	FK_Customer_DefaultTax3	( DefaultTax3 ) ref Tax (Id)

Table CustomerCategory

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	NameL1	nvarchar(100)
	NameL2	nvarchar(100)
	NameL3	nvarchar(100)
	Code	nvarchar(10)
	OptimisticLockField	int
Indexes
	PK_CustomerCategory	ON Id

Table CustomerMilestone

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Customer	uniqueidentifier
	MDate	datetime
	Subject	nvarchar(4000)
	Comments	nvarchar(4000)
	ContactPerson	uniqueidentifier
	Results	nvarchar(2000)
	AlarmTime	datetime
	IsPostponed	bit
	OptimisticLockField	int
Indexes
	PK_CustomerMilestone	ON Id
	iContactPerson_CustomerMilestone	ON ContactPerson
	iCustomer_CustomerMilestone	ON Customer
Foreign Keys
	FK_CustomerMilestone_Customer	( Customer ) ref Customer (Id)
	FK_CustomerMilestone_ContactPerson	( ContactPerson ) ref Employee (Id)

Table CustomerPriceList

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Customer	uniqueidentifier
	PriceList	uniqueidentifier
	Default	bit
	OptimisticLockField	int
Indexes
	PK_CustomerPriceList	ON Id
	iCustomer_CustomerPriceList	ON Customer
	iPriceList_CustomerPriceList	ON PriceList
Foreign Keys
	FK_CustomerPriceList_Customer	( Customer ) ref Customer (Id)
	FK_CustomerPriceList_PriceList	( PriceList ) ref PriceList (Id)

Table DocumentChecklistItem

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	TranslationJob	uniqueidentifier
	TranslationProject	uniqueidentifier
	TranslationAssignment	uniqueidentifier
	Completed	bit
	Priority	int
	Contents	nvarchar(300)
	OptimisticLockField	int
Indexes
	PK_DocumentChecklistItem	ON Id
	iTranslationAssignment_DocumentChecklistItem	ON TranslationAssignment
	iTranslationJob_DocumentChecklistItem	ON TranslationJob
	iTranslationProject_DocumentChecklistItem	ON TranslationProject
Foreign Keys
	FK_DocumentChecklistItem_TranslationAssignment	( TranslationAssignment ) ref TranslationAssignment (Id)
	FK_DocumentChecklistItem_TranslationJob	( TranslationJob ) ref TranslationJob (Id)
	FK_DocumentChecklistItem_TranslationProject	( TranslationProject ) ref TranslationProject (Id)

Table DocumentMessage

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Quote	uniqueidentifier
	TranslationJob	uniqueidentifier
	TranslationProject	uniqueidentifier
	Author	uniqueidentifier
	Date	datetime
	Message	nvarchar(1000)
	OptimisticLockField	int
Indexes
	PK_DocumentMessage	ON Id
	iAuthor_DocumentMessage	ON Author
	iQuote_DocumentMessage	ON Quote
	iTranslationJob_DocumentMessage	ON TranslationJob
	iTranslationProject_DocumentMessage	ON TranslationProject
Foreign Keys
	FK_DocumentMessage_Quote	( Quote ) ref Quote (Id)
	FK_DocumentMessage_TranslationJob	( TranslationJob ) ref TranslationJob (Id)
	FK_DocumentMessage_TranslationProject	( TranslationProject ) ref TranslationProject (Id)

Table EmailAccount

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	Default	bit
	Login	nvarchar(100)
	Password	nvarchar(100)
	FromName	nvarchar(100)
	Smtp	nvarchar(100)
	Port	int
	SSL	bit
	OptimisticLockField	int
Indexes
	PK_EmailAccount	ON Id

Table Employee

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	LastName	nvarchar(100)
	FirstName	nvarchar(100)
	Title	nvarchar(100)
	Email	nvarchar(100)
	EmailAlternative	nvarchar(100)
	Phone	nvarchar(100)
	Skype	nvarchar(50)
	OtherMessagingAppId1	nvarchar(100)
	OtherMessagingAppId2	nvarchar(100)
	Invoicing	bit
	Customer	uniqueidentifier
	Notes	nvarchar(4000)
	Photo	varbinary(max)
	Archived	bit
	OptimisticLockField	int
Indexes
	PK_Employee	ON Id
	iCustomer_Employee	ON Customer
Foreign Keys
	FK_Employee_Customer	( Customer ) ref Customer (Id)

Table Expense

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Date	datetime
	CreatedBy	nvarchar(100)
	CreatedAt	datetime
	ModifiedBy	nvarchar(100)
	ModifiedAt	datetime
	DocNum	int
	Currency	uniqueidentifier
	AmountNet	money
	Tax	uniqueidentifier
	AmountTax	money
	Amount	money
	AmountBase	money
	Distribution	int
	Notes	nvarchar(4000)
	Payee	nvarchar(4000)
	ExpenseType	uniqueidentifier
	TranslationProject	uniqueidentifier
	TranslationJob	uniqueidentifier
	OptimisticLockField	int
Indexes
	PK_Expense	ON Id
	iCurrency_Expense	ON Currency
	iExpenseType_Expense	ON ExpenseType
	iTax_Expense	ON Tax
	iTranslationJob_Expense	ON TranslationJob
	iTranslationProject_Expense	ON TranslationProject
Foreign Keys
	FK_Expense_Currency	( Currency ) ref Currency (Id)
	FK_Expense_ExpenseType	( ExpenseType ) ref ExpenseType (Id)
	FK_Expense_Tax	( Tax ) ref Tax (Id)
	FK_Expense_TranslationJob	( TranslationJob ) ref TranslationJob (Id)
	FK_Expense_TranslationProject	( TranslationProject ) ref TranslationProject (Id)

Table ExpenseCategory

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	NameL1	nvarchar(100)
	NameL2	nvarchar(100)
	NameL3	nvarchar(100)
	OptimisticLockField	int
Indexes
	PK_ExpenseCategory	ON Id

Table ExpenseType

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	Category	uniqueidentifier
	ExcludeFromLedger	bit
	NameL1	nvarchar(100)
	NameL2	nvarchar(100)
	NameL3	nvarchar(100)
	OptimisticLockField	int
Indexes
	PK_ExpenseType	ON Id
	iCategory_ExpenseType	ON Category
Foreign Keys
	FK_ExpenseType_Category	( Category ) ref ExpenseCategory (Id)

Table FavoriteItem

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	Shortcut	nvarchar(1000)
	ShortcutObjectKey	nvarchar(100)
	Category	nvarchar(100)
	Image	nvarchar(100)
	Comment	nvarchar(100)
	OptimisticLockField	int
Indexes
	PK_FavoriteItem	ON Id

Table FileType

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	AdditionalFiles	bit
	OptimisticLockField	int
Indexes
	PK_FileType	ON Id

Table FuzzyType

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	SortOrder	int
	NameL1	nvarchar(100)
	NameL2	nvarchar(100)
	NameL3	nvarchar(100)
	MatchType	int
	FuzzyBandMin	int
	FuzzyBandMax	int
	Synonyms	nvarchar(4000)
	OptimisticLockField	int
Indexes
	PK_FuzzyType	ON Id

Table FuzzyTypeKit

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	OptimisticLockField	int
Indexes
	PK_FuzzyTypeKit	ON Id

Table FuzzyTypeKitDetail

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	FuzzyTypeKit	uniqueidentifier
	Sort	int
	FuzzyType	uniqueidentifier
	Factor	money
	OptimisticLockField	int
Indexes
	PK_FuzzyTypeKitDetail	ON Id
	iFuzzyType_FuzzyTypeKitDetail	ON FuzzyType
	iFuzzyTypeKit_FuzzyTypeKitDetail	ON FuzzyTypeKit
Foreign Keys
	FK_FuzzyTypeKitDetail_FuzzyType	( FuzzyType ) ref FuzzyType (Id)
	FK_FuzzyTypeKitDetail_FuzzyTypeKit	( FuzzyTypeKit ) ref FuzzyTypeKit (Id)

Table IncomeOther

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Date	datetime
	CreatedBy	nvarchar(100)
	CreatedAt	datetime
	ModifiedBy	nvarchar(100)
	ModifiedAt	datetime
	DocNum	int
	Amount	money
	Currency	uniqueidentifier
	AmountBase	money
	Notes	nvarchar(4000)
	Payer	nvarchar(1000)
	IncomeType	uniqueidentifier
	OptimisticLockField	int
Indexes
	PK_IncomeOther	ON Id
	iCurrency_IncomeOther	ON Currency
	iIncomeType_IncomeOther	ON IncomeType
Foreign Keys
	FK_IncomeOther_Currency	( Currency ) ref Currency (Id)
	FK_IncomeOther_IncomeType	( IncomeType ) ref ExpenseType (Id)

Table Invoice

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Date	datetime
	CreatedBy	nvarchar(100)
	CreatedAt	datetime
	ModifiedBy	nvarchar(100)
	ModifiedAt	datetime
	CorrectiveInvoice	bit
	CorrectedInvoice	uniqueidentifier
	CorrectionReason	nvarchar(100)
	Status	int
	DocNum	int
	Number	nvarchar(100)
	Term	datetime
	PaymentReminderSent	bit
	ContractNumber	nvarchar(100)
	ContractDate	datetime
	Notes	nvarchar(4000)
	NotesInternal	nvarchar(4000)
	Customer	uniqueidentifier
	CustomerContact	uniqueidentifier
	Currency	uniqueidentifier
	PaymentMethods	nvarchar(500)
	AmountDetails	money
	Discount	money
	DiscountFixed	money
	Tax1	uniqueidentifier
	AmountTax1	money
	Tax2	uniqueidentifier
	AmountTax2	money
	Tax3	uniqueidentifier
	AmountTax3	money
	ChargedExpenses	money
	Amount	money
	CurrencyRate	money
	AmountBase	money
	AmountPaid	money
	AmountDue	money
	Imported	bit
	AdvanceInvoice	bit
	Hash	nvarchar(1000)
	Folder	nvarchar(1000)
	XmlGenerated	bit
	PurchaseOrderNumbers	nvarchar(max)
	OptimisticLockField	int
Indexes
	PK_Invoice	ON Id
	iCorrectedInvoice_Invoice	ON CorrectedInvoice
	iCurrency_Invoice	ON Currency
	iCustomer_Invoice	ON Customer
	iCustomerContact_Invoice	ON CustomerContact
	iTax1_Invoice	ON Tax1
	iTax2_Invoice	ON Tax2
	iTax3_Invoice	ON Tax3
Foreign Keys
	FK_Invoice_Currency	( Currency ) ref Currency (Id)
	FK_Invoice_Customer	( Customer ) ref Customer (Id)
	FK_Invoice_CustomerContact	( CustomerContact ) ref Employee (Id)
	FK_Invoice_CorrectedInvoice	( CorrectedInvoice ) ref Invoice (Id)
	FK_Invoice_Tax1	( Tax1 ) ref Tax (Id)
	FK_Invoice_Tax2	( Tax2 ) ref Tax (Id)
	FK_Invoice_Tax3	( Tax3 ) ref Tax (Id)

Table InvoiceDetail

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Invoice	uniqueidentifier
	Sort	int
	TranslationJob	uniqueidentifier
	Description	nvarchar(4000)
	PartialFactor	money
	WorkType	uniqueidentifier
	Quantity	money
	Unit	uniqueidentifier
	Price	money
	Amount	money
	Notes	nvarchar(4000)
	OptimisticLockField	int
Indexes
	PK_InvoiceDetail	ON Id
	iInvoice_InvoiceDetail	ON Invoice
	iTranslationJob_InvoiceDetail	ON TranslationJob
	iUnit_InvoiceDetail	ON Unit
	iWorkType_InvoiceDetail	ON WorkType
Foreign Keys
	FK_InvoiceDetail_Invoice	( Invoice ) ref Invoice (Id)
	FK_InvoiceDetail_TranslationJob	( TranslationJob ) ref TranslationJob (Id)
	FK_InvoiceDetail_Unit	( Unit ) ref Unit (Id)
	FK_InvoiceDetail_WorkType	( WorkType ) ref WorkingType (Id)

Table InvoiceDetailCorrection

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Invoice	uniqueidentifier
	InvoiceDetail	uniqueidentifier
	Sort	int
	WorkType	uniqueidentifier
	Quantity	money
	Unit	uniqueidentifier
	Price	money
	Amount	money
	InitialQuantity	money
	InitialAmount	money
	Notes	nvarchar(4000)
	OptimisticLockField	int
Indexes
	PK_InvoiceDetailCorrection	ON Id
	iInvoice_InvoiceDetailCorrection	ON Invoice
	iInvoiceDetail_InvoiceDetailCorrection	ON InvoiceDetail
	iUnit_InvoiceDetailCorrection	ON Unit
	iWorkType_InvoiceDetailCorrection	ON WorkType
Foreign Keys
	FK_InvoiceDetailCorrection_Invoice	( Invoice ) ref Invoice (Id)
	FK_InvoiceDetailCorrection_InvoiceDetail	( InvoiceDetail ) ref InvoiceDetail (Id)
	FK_InvoiceDetailCorrection_Unit	( Unit ) ref Unit (Id)
	FK_InvoiceDetailCorrection_WorkType	( WorkType ) ref WorkingType (Id)

Table InvoiceIn

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Date	datetime
	Number	nvarchar(100)
	Term	datetime
	Approved	bit
	InvoiceType	int
	Contractor	uniqueidentifier
	Party	nvarchar(100)
	PaymentMethod	uniqueidentifier
	Currency	uniqueidentifier
	Notes	nvarchar(2000)
	NotesPayment	nvarchar(2000)
	AmountNet	money
	Discount	money
	AmountDiscount	money
	Tax1	uniqueidentifier
	AmountTax1	money
	Tax2	uniqueidentifier
	AmountTax2	money
	Tax3	uniqueidentifier
	AmountTax3	money
	Amount	money
	CurrencyRate	money
	AmountBase	money
	AmountPaid	money
	AmountDue	money
	CreatedBy	nvarchar(100)
	CreatedAt	datetime
	ModifiedBy	nvarchar(100)
	ModifiedAt	datetime
	Folder	nvarchar(1000)
	OptimisticLockField	int
Indexes
	PK_InvoiceIn	ON Id
	iContractor_InvoiceIn	ON Contractor
	iCurrency_InvoiceIn	ON Currency
	iPaymentMethod_InvoiceIn	ON PaymentMethod
	iTax1_InvoiceIn	ON Tax1
	iTax2_InvoiceIn	ON Tax2
	iTax3_InvoiceIn	ON Tax3
Foreign Keys
	FK_InvoiceIn_Contractor	( Contractor ) ref Contractor (Id)
	FK_InvoiceIn_PaymentMethod	( PaymentMethod ) ref ContractorPaymentMethod (Id)
	FK_InvoiceIn_Currency	( Currency ) ref Currency (Id)
	FK_InvoiceIn_Tax1	( Tax1 ) ref Tax (Id)
	FK_InvoiceIn_Tax2	( Tax2 ) ref Tax (Id)
	FK_InvoiceIn_Tax3	( Tax3 ) ref Tax (Id)

Table InvoiceInDetail

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Invoice	uniqueidentifier
	TranslationAssignment	uniqueidentifier
	Description	nvarchar(1000)
	Amount	money
	OptimisticLockField	int
Indexes
	PK_InvoiceInDetail	ON Id
	iInvoice_InvoiceInDetail	ON Invoice
	iTranslationAssignment_InvoiceInDetail	ON TranslationAssignment
Foreign Keys
	FK_InvoiceInDetail_Invoice	( Invoice ) ref InvoiceIn (Id)
	FK_InvoiceInDetail_TranslationAssignment	( TranslationAssignment ) ref TranslationAssignment (Id)

Table Language

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	NameL1	nvarchar(100)
	NameL2	nvarchar(100)
	NameL3	nvarchar(100)
	Iso2	nvarchar(10)
	Iso3	nvarchar(10)
	Synonyms	nvarchar(4000)
	Flag	int
	OptimisticLockField	int
Indexes
	PK_Language	ON Id

Table LanguageCombination

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	LanguageSource	uniqueidentifier
	LanguageTarget	uniqueidentifier
	OptimisticLockField	int
Indexes
	PK_LanguageCombination	ON Id
	iLanguageSource_LanguageCombination	ON LanguageSource
	iLanguageTarget_LanguageCombination	ON LanguageTarget
Foreign Keys
	FK_LanguageCombination_LanguageSource	( LanguageSource ) ref Language (Id)
	FK_LanguageCombination_LanguageTarget	( LanguageTarget ) ref Language (Id)

Table MailMessage

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Date	datetime
	Sent	bit
	Text	nvarchar(max)
	Subject	nvarchar(100)
	NotificationDelivery	bit
	NotificationRead	bit
	CC	nvarchar(1000)
	Assignment	uniqueidentifier
	Job	uniqueidentifier
	Project	uniqueidentifier
	Quote	uniqueidentifier
	Contractor	uniqueidentifier
	Customer	uniqueidentifier
	InvoiceIn	uniqueidentifier
	TestPiece	uniqueidentifier
	Recipients	nvarchar(2000)
	EmailAccount	uniqueidentifier
	Folder	nvarchar(1000)
	OptimisticLockField	int
Indexes
	PK_MailMessage	ON Id
	iAssignment_MailMessage	ON Assignment
	iContractor_MailMessage	ON Contractor
	iCustomer_MailMessage	ON Customer
	iEmailAccount_MailMessage	ON EmailAccount
	iInvoiceIn_MailMessage	ON InvoiceIn
	iJob_MailMessage	ON Job
	iProject_MailMessage	ON Project
	iQuote_MailMessage	ON Quote
	iTestPiece_MailMessage	ON TestPiece
Foreign Keys
	FK_MailMessage_Contractor	( Contractor ) ref Contractor (Id)
	FK_MailMessage_TestPiece	( TestPiece ) ref ContractorTestPiece (Id)
	FK_MailMessage_Customer	( Customer ) ref Customer (Id)
	FK_MailMessage_EmailAccount	( EmailAccount ) ref EmailAccount (Id)
	FK_MailMessage_InvoiceIn	( InvoiceIn ) ref InvoiceIn (Id)
	FK_MailMessage_Quote	( Quote ) ref Quote (Id)
	FK_MailMessage_Assignment	( Assignment ) ref TranslationAssignment (Id)
	FK_MailMessage_Job	( Job ) ref TranslationJob (Id)
	FK_MailMessage_Project	( Project ) ref TranslationProject (Id)

Table MailMessageRecipient

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	MailMessage	uniqueidentifier
	Name	nvarchar(100)
	LastName	nvarchar(100)
	Email	nvarchar(100)
	Title	nvarchar(100)
	CC	nvarchar(max)
	BCC	nvarchar(max)
	OptimisticLockField	int
Indexes
	PK_MailMessageRecipient	ON Id
	iMailMessage_MailMessageRecipient	ON MailMessage
Foreign Keys
	FK_MailMessageRecipient_MailMessage	( MailMessage ) ref MailMessage (Id)

Table MessageTemplate

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	Subject	nvarchar(500)
	IncludeReadNotificationRequest	bit
	Text	nvarchar(max)
	TextShort	nvarchar(max)
	Notes	nvarchar(1000)
	DefaultTargetMessagetype	int
	CC	nvarchar(1000)
	Disabled	bit
	OptimisticLockField	int
Indexes
	PK_MessageTemplate	ON Id

Table Payment

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Date	datetime
	CreatedBy	nvarchar(100)
	CreatedAt	datetime
	ModifiedBy	nvarchar(100)
	ModifiedAt	datetime
	DocNum	int
	Customer	uniqueidentifier
	Amount	money
	AmountUndistributed	money
	Currency	uniqueidentifier
	Charges	money
	PaymentMethod	uniqueidentifier
	Invoices	nvarchar(4000)
	Notes	nvarchar(4000)
	CurrencyRate	money
	AmountBase	money
	InvoiceAmountTax	money
	InvoiceAmountWithoutTax	money
	OptimisticLockField	int
Indexes
	PK_Payment	ON Id
	iCurrency_Payment	ON Currency
	iCustomer_Payment	ON Customer
	iPaymentMethod_Payment	ON PaymentMethod
Foreign Keys
	FK_Payment_Currency	( Currency ) ref Currency (Id)
	FK_Payment_Customer	( Customer ) ref Customer (Id)
	FK_Payment_PaymentMethod	( PaymentMethod ) ref PaymentMethodSet (Id)

Table PaymentDetail

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Payment	uniqueidentifier
	Invoice	uniqueidentifier
	Amount	money
	AmountInvoiceCurrency	money
	CurrencyRate	money
	OptimisticLockField	int
Indexes
	PK_PaymentDetail	ON Id
	iInvoice_PaymentDetail	ON Invoice
	iPayment_PaymentDetail	ON Payment
Foreign Keys
	FK_PaymentDetail_Invoice	( Invoice ) ref Invoice (Id)
	FK_PaymentDetail_Payment	( Payment ) ref Payment (Id)

Table PaymentMethodSet

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	NameL1	nvarchar(100)
	NameL2	nvarchar(100)
	NameL3	nvarchar(100)
	Currency	uniqueidentifier
	Details	nvarchar(4000)
	Notes	nvarchar(200)
	IsDefault	bit
	Archived	bit
	ArchiveNotes	nvarchar(100)
	OptimisticLockField	int
Indexes
	PK_PaymentMethodSet	ON Id
	iCurrency_PaymentMethodSet	ON Currency
Foreign Keys
	FK_PaymentMethodSet_Currency	( Currency ) ref Currency (Id)

Table PaymentOut

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Date	datetime
	CreatedBy	nvarchar(100)
	CreatedAt	datetime
	ModifiedBy	nvarchar(100)
	ModifiedAt	datetime
	DocNum	int
	Contractor	uniqueidentifier
	PartyExternal	nvarchar(100)
	Amount	money
	Charges	money
	Currency	uniqueidentifier
	CurrencyRate	money
	AmountBase	money
	AmountUndistributed	money
	PaymentMethod	nvarchar(100)
	Account	uniqueidentifier
	Notes	nvarchar(4000)
	InvoiceNumbers	nvarchar(500)
	OptimisticLockField	int
Indexes
	PK_PaymentOut	ON Id
	iAccount_PaymentOut	ON Account
	iContractor_PaymentOut	ON Contractor
	iCurrency_PaymentOut	ON Currency
Foreign Keys
	FK_PaymentOut_Contractor	( Contractor ) ref Contractor (Id)
	FK_PaymentOut_Currency	( Currency ) ref Currency (Id)
	FK_PaymentOut_Account	( Account ) ref PaymentMethodSet (Id)

Table PaymentOutDetail

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	PaymentOut	uniqueidentifier
	Invoice	uniqueidentifier
	TranslationAssignment	uniqueidentifier
	Amount	money
	CurrencyRate	money
	AmountInvoiceCurrency	money
	OptimisticLockField	int
Indexes
	PK_PaymentOutDetail	ON Id
	iInvoice_PaymentOutDetail	ON Invoice
	iPaymentOut_PaymentOutDetail	ON PaymentOut
	iTranslationAssignment_PaymentOutDetail	ON TranslationAssignment
Foreign Keys
	FK_PaymentOutDetail_Invoice	( Invoice ) ref InvoiceIn (Id)
	FK_PaymentOutDetail_PaymentOut	( PaymentOut ) ref PaymentOut (Id)
	FK_PaymentOutDetail_TranslationAssignment	( TranslationAssignment ) ref TranslationAssignment (Id)

Table PlannerException

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Date	datetime
	DateEnd	datetime
	Volume	money
	OptimisticLockField	int
Indexes
	PK_PlannerException	ON Id

Table PredefinedTaskSet

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	OptimisticLockField	int
Indexes
	PK_PredefinedTaskSet	ON Id

Table PredefinedTaskSetDetail

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	PredefinedTaskSet	uniqueidentifier
	Order	int
	WorkType	uniqueidentifier
	Unit	uniqueidentifier
	FuzzyType	uniqueidentifier
	Quantity	money
	Notes	nvarchar(100)
	OptimisticLockField	int
Indexes
	PK_PredefinedTaskSetDetail	ON Id
	iFuzzyType_PredefinedTaskSetDetail	ON FuzzyType
	iPredefinedTaskSet_PredefinedTaskSetDetail	ON PredefinedTaskSet
	iUnit_PredefinedTaskSetDetail	ON Unit
	iWorkType_PredefinedTaskSetDetail	ON WorkType
Foreign Keys
	FK_PredefinedTaskSetDetail_FuzzyType	( FuzzyType ) ref FuzzyType (Id)
	FK_PredefinedTaskSetDetail_PredefinedTaskSet	( PredefinedTaskSet ) ref PredefinedTaskSet (Id)
	FK_PredefinedTaskSetDetail_Unit	( Unit ) ref Unit (Id)
	FK_PredefinedTaskSetDetail_WorkType	( WorkType ) ref WorkingType (Id)

Table PriceList

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	Description	nvarchar(4000)
	Default	bit
	UsageType	int
	Date	datetime
	NotesPublic	nvarchar(4000)
	NotesInternal	nvarchar(4000)
	Contractors	nvarchar(max)
	Customers	nvarchar(max)
	Archived	bit
	OptimisticLockField	int
Indexes
	PK_PriceList	ON Id

Table PriceListItem

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	PriceList	uniqueidentifier
	WorkType	uniqueidentifier
	FuzzyType	uniqueidentifier
	LanguageCombination	uniqueidentifier
	Unit	uniqueidentifier
	WorkFieldCategory	uniqueidentifier
	RateValue	money
	Currency	uniqueidentifier
	OptimisticLockField	int
Indexes
	PK_PriceListItem	ON Id
	iCurrency_PriceListItem	ON Currency
	iFuzzyType_PriceListItem	ON FuzzyType
	iLanguageCombination_PriceListItem	ON LanguageCombination
	iPriceList_PriceListItem	ON PriceList
	iUnit_PriceListItem	ON Unit
	iWorkFieldCategory_PriceListItem	ON WorkFieldCategory
	iWorkType_PriceListItem	ON WorkType
Foreign Keys
	FK_PriceListItem_Currency	( Currency ) ref Currency (Id)
	FK_PriceListItem_FuzzyType	( FuzzyType ) ref FuzzyType (Id)
	FK_PriceListItem_LanguageCombination	( LanguageCombination ) ref LanguageCombination (Id)
	FK_PriceListItem_PriceList	( PriceList ) ref PriceList (Id)
	FK_PriceListItem_Unit	( Unit ) ref Unit (Id)
	FK_PriceListItem_WorkFieldCategory	( WorkFieldCategory ) ref WorkingFieldCategory (Id)
	FK_PriceListItem_WorkType	( WorkType ) ref WorkingType (Id)

Table Quote

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Date	datetime
	CreatedBy	nvarchar(100)
	CreatedAt	datetime
	ModifiedBy	nvarchar(100)
	ModifiedAt	datetime
	DocNum	int
	Number	nvarchar(100)
	QuoteDueDate	datetime
	DeliveryDate	nvarchar(100)
	Status	int
	Customer	uniqueidentifier
	CustomerContact	uniqueidentifier
	PriceList	uniqueidentifier
	Currency	uniqueidentifier
	JobTitle	nvarchar(1000)
	Notes	nvarchar(max)
	NotesInternal	nvarchar(4000)
	PaymentPolicy	nvarchar(1000)
	ResponsiblePerson	uniqueidentifier
	Specialization	uniqueidentifier
	SourceLanguage	uniqueidentifier
	Languages	nvarchar(4000)
	AmountNet	money
	AdditionalExpenses	money
	AdditionalExpensesDescription	nvarchar(100)
	Tax1	uniqueidentifier
	Tax1Amount	money
	Tax2	uniqueidentifier
	Tax2Amount	money
	Tax3	uniqueidentifier
	Tax3Amount	money
	Amount	money
	CurrencyRate	money
	AmountBase	money
	FuzzyScheme	uniqueidentifier
	Folder	nvarchar(1000)
	FolderFixed	bit
	TradosProjectId	nvarchar(100)
	TradosProjectFilePath	nvarchar(1000)
	GroupShareId	nvarchar(100)
	LanguageCloudId	nvarchar(100)
	OptimisticLockField	int
	Term	datetime
Indexes
	PK_Quote	ON Id
	iCurrency_Quote	ON Currency
	iCustomer_Quote	ON Customer
	iCustomerContact_Quote	ON CustomerContact
	iFuzzyScheme_Quote	ON FuzzyScheme
	iPriceList_Quote	ON PriceList
	iResponsiblePerson_Quote	ON ResponsiblePerson
	iSourceLanguage_Quote	ON SourceLanguage
	iSpecialization_Quote	ON Specialization
	iTax1_Quote	ON Tax1
	iTax2_Quote	ON Tax2
	iTax3_Quote	ON Tax3
Foreign Keys
	FK_Quote_ResponsiblePerson	( ResponsiblePerson ) ref Contractor (Id)
	FK_Quote_Currency	( Currency ) ref Currency (Id)
	FK_Quote_Customer	( Customer ) ref Customer (Id)
	FK_Quote_CustomerContact	( CustomerContact ) ref Employee (Id)
	FK_Quote_FuzzyScheme	( FuzzyScheme ) ref FuzzyTypeKit (Id)
	FK_Quote_SourceLanguage	( SourceLanguage ) ref Language (Id)
	FK_Quote_PriceList	( PriceList ) ref PriceList (Id)
	FK_Quote_Tax1	( Tax1 ) ref Tax (Id)
	FK_Quote_Tax2	( Tax2 ) ref Tax (Id)
	FK_Quote_Tax3	( Tax3 ) ref Tax (Id)
	FK_Quote_Specialization	( Specialization ) ref WorkingField (Id)

Table QuoteItem

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Quote	uniqueidentifier
	Order	int
	WorkType	uniqueidentifier
	Description	nvarchar(100)
	FuzzyType	uniqueidentifier
	Language	uniqueidentifier
	Quantity	money
	Unit	uniqueidentifier
	Price	money
	DiscountPercent	money
	PriceWithDiscount	money
	Amount	money
	OptimisticLockField	int
Indexes
	PK_QuoteItem	ON Id
	iFuzzyType_QuoteItem	ON FuzzyType
	iLanguage_QuoteItem	ON Language
	iQuote_QuoteItem	ON Quote
	iUnit_QuoteItem	ON Unit
	iWorkType_QuoteItem	ON WorkType
Foreign Keys
	FK_QuoteItem_FuzzyType	( FuzzyType ) ref FuzzyType (Id)
	FK_QuoteItem_Language	( Language ) ref LanguageCombination (Id)
	FK_QuoteItem_Quote	( Quote ) ref Quote (Id)
	FK_QuoteItem_Unit	( Unit ) ref Unit (Id)
	FK_QuoteItem_WorkType	( WorkType ) ref WorkingType (Id)

Table Region

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	OptimisticLockField	int
Indexes
	PK_Region	ON Id

Table SoftwareApplication

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	Version	nvarchar(50)
	OptimisticLockField	int
Indexes
	PK_SoftwareApplication	ON Id

Table Tax

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	NameL1	nvarchar(100)
	NameL2	nvarchar(100)
	NameL3	nvarchar(100)
	Rate	money
	GrossBased	bit
	OptimisticLockField	int
	Aaa	nvarchar(100)
Indexes
	PK_Tax	ON Id

Table TestPiece

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	LanguagePair	uniqueidentifier
	Specialization	uniqueidentifier
	Notes	nvarchar(2000)
	Instructions	nvarchar(2000)
	SourceText	nvarchar(max)
	OfferToNewVendors	bit
	Proofreaders	int
	OptimisticLockField	int
Indexes
	PK_TestPiece	ON Id
	iLanguagePair_TestPiece	ON LanguagePair
	iSpecialization_TestPiece	ON Specialization
Foreign Keys
	FK_TestPiece_LanguagePair	( LanguagePair ) ref LanguageCombination (Id)
	FK_TestPiece_Specialization	( Specialization ) ref WorkingField (Id)

Table TestPieceProofreader

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	TestPiece	uniqueidentifier
	Contractor	uniqueidentifier
	Paid	bit
	OptimisticLockField	int
Indexes
	PK_TestPieceProofreader	ON Id
	iContractor_TestPieceProofreader	ON Contractor
	iTestPiece_TestPieceProofreader	ON TestPiece
Foreign Keys
	FK_TestPieceProofreader_Contractor	( Contractor ) ref Contractor (Id)
	FK_TestPieceProofreader_TestPiece	( TestPiece ) ref TestPiece (Id)

Table TranslationAssignment

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Date	datetime
	CreatedBy	nvarchar(100)
	CreatedAt	datetime
	ModifiedBy	nvarchar(100)
	ModifiedAt	datetime
	DocNum	int
	Status	int
	StatusPayment	int
	TranslationJob	uniqueidentifier
	LanguagePair	uniqueidentifier
	Specialization	uniqueidentifier
	TranslationProject	uniqueidentifier
	Term	datetime
	DeliveryDate	datetime
	Contractor	uniqueidentifier
	PriceList	uniqueidentifier
	PONumber	nvarchar(1000)
	PODate	datetime
	JobName	nvarchar(1000)
	Amount	money
	CurrencyRate	money
	AmountBase	money
	WeightQuantity	money
	Notes	nvarchar(4000)
	Instructions	nvarchar(max)
	Rating	int
	InvoiceNumber	nvarchar(100)
	PaymentTerm	datetime
	Number	nvarchar(100)
	Currency	uniqueidentifier
	FuzzyScheme	uniqueidentifier
	NoteFromVendor	nvarchar(4000)
	AutomationRule	uniqueidentifier
	TradosFileIds	nvarchar(2000)
	Folder	nvarchar(1000)
	FolderFixed	bit
	GroupShareFileIds	nvarchar(max)
	GroupShareFileNames	nvarchar(max)
	OptimisticLockField	int
Indexes
	PK_TranslationAssignment	ON Id
	iAutomationRule_TranslationAssignment	ON AutomationRule
	iContractor_TranslationAssignment	ON Contractor
	iCurrency_TranslationAssignment	ON Currency
	iFuzzyScheme_TranslationAssignment	ON FuzzyScheme
	iLanguagePair_TranslationAssignment	ON LanguagePair
	iPriceList_TranslationAssignment	ON PriceList
	iSpecialization_TranslationAssignment	ON Specialization
	iTranslationJob_TranslationAssignment	ON TranslationJob
	iTranslationProject_TranslationAssignment	ON TranslationProject
Foreign Keys
	FK_TranslationAssignment_Contractor	( Contractor ) ref Contractor (Id)
	FK_TranslationAssignment_Currency	( Currency ) ref Currency (Id)
	FK_TranslationAssignment_FuzzyScheme	( FuzzyScheme ) ref FuzzyTypeKit (Id)
	FK_TranslationAssignment_LanguagePair	( LanguagePair ) ref LanguageCombination (Id)
	FK_TranslationAssignment_PriceList	( PriceList ) ref PriceList (Id)
	FK_TranslationAssignment_TranslationJob	( TranslationJob ) ref TranslationJob (Id)
	FK_TranslationAssignment_TranslationProject	( TranslationProject ) ref TranslationProject (Id)
	FK_TranslationAssignment_Specialization	( Specialization ) ref WorkingField (Id)

Table TranslationAssignmentDetail

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	TranslationAssignment	uniqueidentifier
	TranslationJobDetail	uniqueidentifier
	Sort	int
	WorkingType	uniqueidentifier
	FuzzyType	uniqueidentifier
	Unit	uniqueidentifier
	Rate	money
	DiscountMarkup	money
	Quantity	money
	WorkTime	float
	Amount	money
	Notes	nvarchar(1000)
	OptimisticLockField	int
Indexes
	PK_TranslationAssignmentDetail	ON Id
	iFuzzyType_TranslationAssignmentDetail	ON FuzzyType
	iTranslationAssignment_TranslationAssignmentDetail	ON TranslationAssignment
	iTranslationJobDetail_TranslationAssignmentDetail	ON TranslationJobDetail
	iUnit_TranslationAssignmentDetail	ON Unit
	iWorkingType_TranslationAssignmentDetail	ON WorkingType
Foreign Keys
	FK_TranslationAssignmentDetail_FuzzyType	( FuzzyType ) ref FuzzyType (Id)
	FK_TranslationAssignmentDetail_TranslationAssignment	( TranslationAssignment ) ref TranslationAssignment (Id)
	FK_TranslationAssignmentDetail_TranslationJobDetail	( TranslationJobDetail ) ref TranslationJobDetail (Id)
	FK_TranslationAssignmentDetail_Unit	( Unit ) ref Unit (Id)
	FK_TranslationAssignmentDetail_WorkingType	( WorkingType ) ref WorkingType (Id)

Table TranslationAssignmentPayable

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	TranslationAssignment	uniqueidentifier
	Sort	int
	WorkType	uniqueidentifier
	Unit	uniqueidentifier
	Rate	money
	DiscountMarkup	money
	Quantity	money
	Amount	money
	Notes	nvarchar(1000)
	OptimisticLockField	int
Indexes
	PK_TranslationAssignmentPayable	ON Id
	iTranslationAssignment_TranslationAssignmentPayable	ON TranslationAssignment
	iUnit_TranslationAssignmentPayable	ON Unit
	iWorkType_TranslationAssignmentPayable	ON WorkType
Foreign Keys
	FK_TranslationAssignmentPayable_TranslationAssignment	( TranslationAssignment ) ref TranslationAssignment (Id)
	FK_TranslationAssignmentPayable_Unit	( Unit ) ref Unit (Id)
	FK_TranslationAssignmentPayable_WorkType	( WorkType ) ref WorkingType (Id)

Table TranslationAssignmentPick

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	TranslationAssignment	uniqueidentifier
	Contractor	uniqueidentifier
	Status	int
	Notes	nvarchar(4000)
	NotesFromContractor	nvarchar(4000)
	EstimatedAmount	money
	EstimatedAmountCurrency	uniqueidentifier
	AcceptanceBehavior	int
	OptimisticLockField	int
Indexes
	PK_TranslationAssignmentPick	ON Id
	iContractor_TranslationAssignmentPick	ON Contractor
	iEstimatedAmountCurrency_TranslationAssignmentPick	ON EstimatedAmountCurrency
	iTranslationAssignment_TranslationAssignmentPick	ON TranslationAssignment
Foreign Keys
	FK_TranslationAssignmentPick_Contractor	( Contractor ) ref Contractor (Id)
	FK_TranslationAssignmentPick_EstimatedAmountCurrency	( EstimatedAmountCurrency ) ref Currency (Id)
	FK_TranslationAssignmentPick_TranslationAssignment	( TranslationAssignment ) ref TranslationAssignment (Id)

Table TranslationJob

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Date	datetime
	CreatedBy	nvarchar(100)
	CreatedAt	datetime
	ModifiedBy	nvarchar(100)
	ModifiedAt	datetime
	DocNum	int
	Term	datetime
	DeliveryDate	datetime
	RejectionDate	datetime
	Status	int
	StatusPayment	int
	Customer	uniqueidentifier
	CustomerContact	uniqueidentifier
	PriceList	uniqueidentifier
	PONumber	nvarchar(300)
	PODate	datetime
	ProjectName	nvarchar(1000)
	Currency	uniqueidentifier
	Field	uniqueidentifier
	LanguageCombination	uniqueidentifier
	Amount	money
	AmountBase	money
	WeightQuantity	money
	WeightRate	money
	TranslationProjectBig	uniqueidentifier
	Folder	nvarchar(1000)
	FolderFixed	bit
	Notes	nvarchar(4000)
	NotesInternal	nvarchar(4000)
	Instructions	nvarchar(max)
	ClientRef	nvarchar(50)
	Invoices	nvarchar(4000)
	InvoicedAmount	money
	DeliveryMethod	nvarchar(100)
	Number	nvarchar(100)
	EditTime	float
	EditTimeMinutes	float
	EditTimeFixed	bit
	WordsPerHour	float
	AmountPerHour	money
	MemoQId	nvarchar(100)
	LinkedCatTool	int
	LinkedCatToolProjectId	nvarchar(100)
	LinkedCatToolFilePath	nvarchar(1000)
	GroupShareId	nvarchar(100)
	LanguageCloudId	nvarchar(100)
	Contractors	nvarchar(4000)
	AssignedQuantity	money
	AssignedAmount	money
	Margin	money
	CurrencyRate	money
	WIWOPosted	bit
	WIWOId	int
	ResponsiblePerson	uniqueidentifier
	ScheduleManual	bit
	ScheduleWeekends	bit
	Quote	uniqueidentifier
	FuzzyScheme	uniqueidentifier
	AnalysisImportSettings	uniqueidentifier
	OptimisticLockField	int
	Words	int
Indexes
	PK_TranslationJob	ON Id
	iAnalysisImportSettings_TranslationJob	ON AnalysisImportSettings
	iCurrency_TranslationJob	ON Currency
	iCustomer_TranslationJob	ON Customer
	iCustomerContact_TranslationJob	ON CustomerContact
	iField_TranslationJob	ON Field
	iFuzzyScheme_TranslationJob	ON FuzzyScheme
	iLanguageCombination_TranslationJob	ON LanguageCombination
	iPriceList_TranslationJob	ON PriceList
	iQuote_TranslationJob	ON Quote
	iResponsiblePerson_TranslationJob	ON ResponsiblePerson
	iTranslationProjectBig_TranslationJob	ON TranslationProjectBig
Foreign Keys
	FK_TranslationJob_AnalysisImportSettings	( AnalysisImportSettings ) ref AnalysisImportSettings (Id)
	FK_TranslationJob_ResponsiblePerson	( ResponsiblePerson ) ref Contractor (Id)
	FK_TranslationJob_Currency	( Currency ) ref Currency (Id)
	FK_TranslationJob_Customer	( Customer ) ref Customer (Id)
	FK_TranslationJob_CustomerContact	( CustomerContact ) ref Employee (Id)
	FK_TranslationJob_FuzzyScheme	( FuzzyScheme ) ref FuzzyTypeKit (Id)
	FK_TranslationJob_LanguageCombination	( LanguageCombination ) ref LanguageCombination (Id)
	FK_TranslationJob_PriceList	( PriceList ) ref PriceList (Id)
	FK_TranslationJob_Quote	( Quote ) ref Quote (Id)
	FK_TranslationJob_TranslationProjectBig	( TranslationProjectBig ) ref TranslationProject (Id)
	FK_TranslationJob_Field	( Field ) ref WorkingField (Id)

Table TranslationJobDetail

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	TranslationProject	uniqueidentifier
	WorkingType	uniqueidentifier
	FuzzyType	uniqueidentifier
	Unit	uniqueidentifier
	Rate	money
	DiscountMarkup	money
	RateWithDiscountMarkup	money
	Quantity	money
	Amount	money
	Sort	int
	Notes	nvarchar(1000)
	EditTime	float
	OptimisticLockField	int
Indexes
	PK_TranslationJobDetail	ON Id
	iFuzzyType_TranslationJobDetail	ON FuzzyType
	iTranslationProject_TranslationJobDetail	ON TranslationProject
	iUnit_TranslationJobDetail	ON Unit
	iWorkingType_TranslationJobDetail	ON WorkingType
Foreign Keys
	FK_TranslationJobDetail_FuzzyType	( FuzzyType ) ref FuzzyType (Id)
	FK_TranslationJobDetail_TranslationProject	( TranslationProject ) ref TranslationJob (Id)
	FK_TranslationJobDetail_Unit	( Unit ) ref Unit (Id)
	FK_TranslationJobDetail_WorkingType	( WorkingType ) ref WorkingType (Id)

Table TranslationJobReceivable

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	TranslationJob	uniqueidentifier
	Sort	int
	WorkType	uniqueidentifier
	Unit	uniqueidentifier
	Rate	money
	DiscountMarkup	money
	RateWithDiscountMarkup	money
	Quantity	money
	Amount	money
	Notes	nvarchar(1000)
	OptimisticLockField	int
Indexes
	PK_TranslationJobReceivable	ON Id
	iTranslationJob_TranslationJobReceivable	ON TranslationJob
	iUnit_TranslationJobReceivable	ON Unit
	iWorkType_TranslationJobReceivable	ON WorkType
Foreign Keys
	FK_TranslationJobReceivable_TranslationJob	( TranslationJob ) ref TranslationJob (Id)
	FK_TranslationJobReceivable_Unit	( Unit ) ref Unit (Id)
	FK_TranslationJobReceivable_WorkType	( WorkType ) ref WorkingType (Id)

Table TranslationJobSchedule

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	TranslationProject	uniqueidentifier
	Date	datetime
	TimeStart	float
	TimeEnd	float
	Volume	money
	OptimisticLockField	int
Indexes
	PK_TranslationJobSchedule	ON Id
	iTranslationProject_TranslationJobSchedule	ON TranslationProject
Foreign Keys
	FK_TranslationJobSchedule_TranslationProject	( TranslationProject ) ref TranslationJob (Id)

Table TranslationProject

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Date	datetime
	CreatedBy	nvarchar(100)
	CreatedAt	datetime
	ModifiedBy	nvarchar(100)
	ModifiedAt	datetime
	Status	int
	DocNum	int
	DateLast	datetime
	Description	nvarchar(4000)
	NotesInternal	nvarchar(4000)
	ProjectName	nvarchar(4000)
	Term	datetime
	SourceLanguage	uniqueidentifier
	Languages	nvarchar(4000)
	Customer	uniqueidentifier
	CustomerContact	uniqueidentifier
	PriceList	uniqueidentifier
	PONumber	nvarchar(300)
	ResponsiblePerson	uniqueidentifier
	Field	uniqueidentifier
	Instructions	nvarchar(max)
	Quantity	money
	Amount	money
	AmountAssigned	money
	Quote	uniqueidentifier
	AmountExpenses	money
	AmountMargin	money
	AmountMarginPercentage	money
	GroupShareId	nvarchar(100)
	LanguageCloudId	nvarchar(100)
	TradosProjectId	nvarchar(100)
	TradosProjectFilePath	nvarchar(2000)
	IncludeInCV	bit
	FuzzyScheme	uniqueidentifier
	Folder	nvarchar(1000)
	FolderFixed	bit
	EditTime	float
	EditTimeMinutes	float
	EditTimeFixed	bit
	WordsPerHour	float
	AmountPerHour	money
	AutomationRule	uniqueidentifier
	Workflow	uniqueidentifier
	AnalysisImportSettings	uniqueidentifier
	OptimisticLockField	int
	RefNumber	nvarchar(100)
Indexes
	PK_TranslationProject	ON Id
	iAnalysisImportSettings_TranslationProject	ON AnalysisImportSettings
	iAutomationRule_TranslationProject	ON AutomationRule
	iCustomer_TranslationProject	ON Customer
	iCustomerContact_TranslationProject	ON CustomerContact
	iField_TranslationProject	ON Field
	iFuzzyScheme_TranslationProject	ON FuzzyScheme
	iPriceList_TranslationProject	ON PriceList
	iQuote_TranslationProject	ON Quote
	iResponsiblePerson_TranslationProject	ON ResponsiblePerson
	iSourceLanguage_TranslationProject	ON SourceLanguage
	iWorkflow_TranslationProject	ON Workflow
Foreign Keys
	FK_TranslationProject_AnalysisImportSettings	( AnalysisImportSettings ) ref AnalysisImportSettings (Id)
	FK_TranslationProject_ResponsiblePerson	( ResponsiblePerson ) ref Contractor (Id)
	FK_TranslationProject_Customer	( Customer ) ref Customer (Id)
	FK_TranslationProject_CustomerContact	( CustomerContact ) ref Employee (Id)
	FK_TranslationProject_FuzzyScheme	( FuzzyScheme ) ref FuzzyTypeKit (Id)
	FK_TranslationProject_SourceLanguage	( SourceLanguage ) ref Language (Id)
	FK_TranslationProject_PriceList	( PriceList ) ref PriceList (Id)
	FK_TranslationProject_Quote	( Quote ) ref Quote (Id)
	FK_TranslationProject_Workflow	( Workflow ) ref Workflow (Id)
	FK_TranslationProject_Field	( Field ) ref WorkingField (Id)

Table Unit

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	NameL1	nvarchar(100)
	NameL2	nvarchar(100)
	NameL3	nvarchar(100)
	BaseUnit	uniqueidentifier
	AdjustmentFactor	money
	IsTime	bit
	FlatRate	bit
	OptimisticLockField	int
Indexes
	PK_Unit	ON Id
	iBaseUnit_Unit	ON BaseUnit
Foreign Keys
	FK_Unit_BaseUnit	( BaseUnit ) ref Unit (Id)

Table UnitWeight

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Unit	uniqueidentifier
	WorkType	uniqueidentifier
	AdjustmentFactor	money
	OptimisticLockField	int
Indexes
	PK_UnitWeight	ON Id
	iUnit_UnitWeight	ON Unit
	iWorkType_UnitWeight	ON WorkType
Foreign Keys
	FK_UnitWeight_Unit	( Unit ) ref Unit (Id)
	FK_UnitWeight_WorkType	( WorkType ) ref WorkingType (Id)

Table User

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	FirstName	nvarchar(100)
	LastName	nvarchar(100)
	CompanyName	nvarchar(100)
	Birthday	datetime
	TimeZoneId	nvarchar(100)
	VAT	nvarchar(100)
	TaxId	nvarchar(100)
	UserPhotoEmbed	varbinary(max)
	LogoEmbed	varbinary(max)
	SendErrorInformation	bit
	EarnAccountType	bit
	EarningAccountingMethod	int
	MailSenderSendCopy	bit
	MailSenderAddSentWithBaccs	bit
	MailSenderAttachmentLimit	int
	FinancialYearStart	datetime
	DisablePricePickupMechanism	bit
	AllowVendorSelfRegister	bit
	ShowLanguagePairsAsCodes	bit
	ShowLanguagesAsFlags	bit
	DefaultChecklistJob	uniqueidentifier
	DefaultChecklistProjects	uniqueidentifier
	DefaultChecklistAssignments	uniqueidentifier
	DefaultAnalysisImportSettings	uniqueidentifier
	NumberingSystem	int
	NumberingSystemInvoices	int
	InvoiceNumberFormat	nvarchar(100)
	JobNumberFormat	nvarchar(100)
	QuoteNumberFormat	nvarchar(100)
	AssignmentNumberFormat	nvarchar(100)
	AssignmentPONumberFormat	nvarchar(100)
	JobNumberResetEachYear	bit
	InvoiceNumberResetEachYear	bit
	InvoiceNumberResetEachMonth	bit
	InvoiceNumberResetDate	datetime
	Email	nvarchar(100)
	Phone	nvarchar(100)
	Fax	nvarchar(100)
	Skype	nvarchar(100)
	Web	nvarchar(100)
	WebProz	nvarchar(100)
	WebLinkedIn	nvarchar(100)
	WebFacebook	nvarchar(100)
	WebTransCafe	nvarchar(100)
	WebTwitter	nvarchar(100)
	WebPortal	nvarchar(100)
	FullAddress	nvarchar(2000)
	Country	nvarchar(100)
	Address	nvarchar(100)
	Address2	nvarchar(100)
	City	nvarchar(50)
	State	nvarchar(50)
	Zip	nvarchar(20)
	Currency	uniqueidentifier
	DefaultTax	uniqueidentifier
	DefaultLanguageCombination	uniqueidentifier
	DefaultUnit	uniqueidentifier
	DefaultFuzzyTypeSet	uniqueidentifier
	DefaultWorkType	uniqueidentifier
	DefaultVendorPaymentType	int
	SetInvoiceAccent	nvarchar(100)
	SetInvoiceSubscription	nvarchar(100)
	SetInvoiceVariant	nvarchar(100)
	InvoiceFileName	nvarchar(100)
	InvoiceSaveDir	nvarchar(100)
	InvoiceItaly	bit
	InvoicePoland	bit
	InvoicePortugal	bit
	PersonalDetails	nvarchar(4000)
	PersonalSlogan	nvarchar(200)
	CareerStartYear	int
	NativeLanguage	nvarchar(100)
	UseSchedulerWorkloadPlannerSync	bit
	DefaultJobsDir	nvarchar(100)
	FolderBaseProjects	nvarchar(100)
	FolderBaseJobs	nvarchar(100)
	FolderBaseAssignments	nvarchar(100)
	FolderBaseQuotes	nvarchar(100)
	FolderBaseInvoices	nvarchar(100)
	FolderBaseInvoicesIn	nvarchar(100)
	FolderBaseCustomers	nvarchar(100)
	FolderBaseVendors	nvarchar(100)
	FolderBaseMailMessages	nvarchar(100)
	DefaultStudioFolderName	nvarchar(100)
	DefaultJobFolderName	nvarchar(200)
	DefaultInternalDirs	nvarchar(500)
	DefaultProjectFolderName	nvarchar(200)
	DefaultInternalDirsProject	nvarchar(500)
	DefaultQuoteFolderName	nvarchar(200)
	DefaultInternalDirsQuotes	nvarchar(500)
	DefaultAssignmentFolderName	nvarchar(200)
	DefaultInternalDirsAssignment	nvarchar(500)
	DefaultInvoiceFolderName	nvarchar(200)
	DefaultPOTemplate	nvarchar(100)
	AssignmentsResetNumberingEachYear	bit
	AssignmentAutoSendNotifications	bit
	AssignmentNotifyOtherCandidates	bit
	AssignmentMachineLearningModel	varbinary(max)
	AssignmentMachineLearningPipeline	varbinary(max)
	AssignmentMachineLearningModelDate	datetime
	AssignmentDisableRecommendBasedOnPreviousWork	bit
	AssignmentDisableRecommendMachineLearning	bit
	QuoteDefaultTemplate	nvarchar(100)
	QuoteDefaultPaymentTerms	nvarchar(1000)
	QuoteAlwaysCreateProjectOnAccept	bit
	DropboxAccessToken	nvarchar(100)
	MailSenderAutoUploadCloudDriveType	int
	MailSenderAutoUploadSizeLimit	int
	MailSenderAutoUploadPath	nvarchar(500)
	MailSenderAutoUploadLinksHeader	nvarchar(100)
	MailSenderConstantRecipients	nvarchar(100)
	SDLGroupShareServer	nvarchar(100)
	SDLGroupShareLogin	nvarchar(100)
	SDLGroupSharePassword	nvarchar(100)
	SDLGroupShareWorkTypeTranslation	uniqueidentifier
	SDLGroupShareWorkTypeReview	uniqueidentifier
	SDLGroupShareWorkTypeFinalization	uniqueidentifier
	SDLGroupShareSyncReview	bit
	SDLGroupShareSyncFinalisation	bit
	SDLLCAccountId	nvarchar(100)
	SDLLCServer	nvarchar(100)
	SDLLCClientId	nvarchar(500)
	SDLLCClientSecret	nvarchar(500)
	BackupOn	bit
	BackupPath	nvarchar(100)
	UseWorkLoadPlanner	bit
	ProductivityCapacity	money
	ProductivityDayStart	datetime
	ProductivityDayEnd	datetime
	ProductivityAllocationMethod	int
	ProductivityMinCapacityEvenly	money
	ProductivityIncludeWeekends	bit
	ProductivityRemoveFinishedJobs	bit
	CalendarType	int
	UseGoogleCalendar	bit
	UseScheduler	bit
	SchedulerSingleEntry	bit
	StandardSchedulerSubject	nvarchar(1000)
	UseGoogleCalendarInvoice	bit
	GoogleCalendarTextInvoice	nvarchar(100)
	SchedulerAddInvoices	bit
	CurrencyRateDownloadSource	int
	CurrencyRateDownload1	uniqueidentifier
	CurrencyRateDownload2	uniqueidentifier
	CurrencyRateDownload3	uniqueidentifier
	NotificationsStaffCreatedJobs	bit
	NotificationsStaffCreatedProjects	bit
	NotificationsStaffStatusJobs	bit
	NotificationsStaffStatusProjects	bit
	AllowEditOnlyEmptyFields	bit
	AuditTrailQuotes	bit
	AuditTrailProjects	bit
	AuditTrailJobs	bit
	AuditTrailAssignments	bit
	AuditTrailInvoices	bit
	AuditTrailInvoicesIn	bit
	AuditTrailPayments	bit
	AuditTrailPaymentsOut	bit
	OptimisticLockField	int
Indexes
	PK_User	ON Id
	iCurrency_User	ON Currency
	iCurrencyRateDownload1_User	ON CurrencyRateDownload1
	iCurrencyRateDownload2_User	ON CurrencyRateDownload2
	iCurrencyRateDownload3_User	ON CurrencyRateDownload3
	iDefaultAnalysisImportSettings_User	ON DefaultAnalysisImportSettings
	iDefaultChecklistAssignments_User	ON DefaultChecklistAssignments
	iDefaultChecklistJob_User	ON DefaultChecklistJob
	iDefaultChecklistProjects_User	ON DefaultChecklistProjects
	iDefaultFuzzyTypeSet_User	ON DefaultFuzzyTypeSet
	iDefaultLanguageCombination_User	ON DefaultLanguageCombination
	iDefaultTax_User	ON DefaultTax
	iDefaultUnit_User	ON DefaultUnit
	iDefaultWorkType_User	ON DefaultWorkType
	iSDLGroupShareWorkTypeFinalization_User	ON SDLGroupShareWorkTypeFinalization
	iSDLGroupShareWorkTypeReview_User	ON SDLGroupShareWorkTypeReview
	iSDLGroupShareWorkTypeTranslation_User	ON SDLGroupShareWorkTypeTranslation
Foreign Keys
	FK_User_DefaultAnalysisImportSettings	( DefaultAnalysisImportSettings ) ref AnalysisImportSettings (Id)
	FK_User_DefaultChecklistAssignments	( DefaultChecklistAssignments ) ref Checklist (Id)
	FK_User_DefaultChecklistJob	( DefaultChecklistJob ) ref Checklist (Id)
	FK_User_DefaultChecklistProjects	( DefaultChecklistProjects ) ref Checklist (Id)
	FK_User_Currency	( Currency ) ref Currency (Id)
	FK_User_CurrencyRateDownload1	( CurrencyRateDownload1 ) ref Currency (Id)
	FK_User_CurrencyRateDownload2	( CurrencyRateDownload2 ) ref Currency (Id)
	FK_User_CurrencyRateDownload3	( CurrencyRateDownload3 ) ref Currency (Id)
	FK_User_DefaultFuzzyTypeSet	( DefaultFuzzyTypeSet ) ref FuzzyTypeKit (Id)
	FK_User_DefaultLanguageCombination	( DefaultLanguageCombination ) ref LanguageCombination (Id)
	FK_User_DefaultTax	( DefaultTax ) ref Tax (Id)
	FK_User_DefaultUnit	( DefaultUnit ) ref Unit (Id)
	FK_User_DefaultWorkType	( DefaultWorkType ) ref WorkingType (Id)
	FK_User_SDLGroupShareWorkTypeFinalization	( SDLGroupShareWorkTypeFinalization ) ref WorkingType (Id)
	FK_User_SDLGroupShareWorkTypeReview	( SDLGroupShareWorkTypeReview ) ref WorkingType (Id)
	FK_User_SDLGroupShareWorkTypeTranslation	( SDLGroupShareWorkTypeTranslation ) ref WorkingType (Id)

Table VendorGroup

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	Notes	nvarchar(300)
	Disabled	bit
	Customer	uniqueidentifier
	Project	uniqueidentifier
	Specialization	uniqueidentifier
	Vendors	nvarchar(max)
	OptimisticLockField	int
Indexes
	PK_VendorGroup	ON Id
	iCustomer_VendorGroup	ON Customer
	iProject_VendorGroup	ON Project
	iSpecialization_VendorGroup	ON Specialization
Foreign Keys
	FK_VendorGroup_Customer	( Customer ) ref Customer (Id)
	FK_VendorGroup_Project	( Project ) ref TranslationProject (Id)
	FK_VendorGroup_Specialization	( Specialization ) ref WorkingField (Id)

Table VendorGroupItem

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	VendorGroup	uniqueidentifier
	Vendor	uniqueidentifier
	Service	uniqueidentifier
	LanguagePair	uniqueidentifier
	Priority	smallint
	OptimisticLockField	int
Indexes
	PK_VendorGroupItem	ON Id
	iLanguagePair_VendorGroupItem	ON LanguagePair
	iService_VendorGroupItem	ON Service
	iVendor_VendorGroupItem	ON Vendor
	iVendorGroup_VendorGroupItem	ON VendorGroup
Foreign Keys
	FK_VendorGroupItem_Vendor	( Vendor ) ref Contractor (Id)
	FK_VendorGroupItem_LanguagePair	( LanguagePair ) ref LanguageCombination (Id)
	FK_VendorGroupItem_VendorGroup	( VendorGroup ) ref VendorGroup (Id)
	FK_VendorGroupItem_Service	( Service ) ref WorkingType (Id)

Table Workflow

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	OptimisticLockField	int
Indexes
	PK_Workflow	ON Id

Table WorkflowDetail

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Workflow	uniqueidentifier
	Order	int
	WorkType	uniqueidentifier
	OptimisticLockField	int
Indexes
	PK_WorkflowDetail	ON Id
	iWorkflow_WorkflowDetail	ON Workflow
	iWorkType_WorkflowDetail	ON WorkType
Foreign Keys
	FK_WorkflowDetail_Workflow	( Workflow ) ref Workflow (Id)
	FK_WorkflowDetail_WorkType	( WorkType ) ref WorkingType (Id)

Table WorkingField

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	Category	uniqueidentifier
	NameL1	nvarchar(100)
	NameL2	nvarchar(100)
	NameL3	nvarchar(100)
	OptimisticLockField	int
Indexes
	PK_WorkingField	ON Id
	iCategory_WorkingField	ON Category
Foreign Keys
	FK_WorkingField_Category	( Category ) ref WorkingFieldCategory (Id)

Table WorkingFieldCategory

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	NameL1	nvarchar(100)
	NameL2	nvarchar(100)
	NameL3	nvarchar(100)
	OptimisticLockField	int
Indexes
	PK_WorkingFieldCategory	ON Id

Table WorkingType

Idx	Field Name	Data Type
*	Id	uniqueidentifier
	Name	nvarchar(100)
	ServiceCode	nvarchar(60)
	NameL1	nvarchar(100)
	NameL2	nvarchar(100)
	NameL3	nvarchar(100)
	DefaultUnit	uniqueidentifier
	AdjustmentFactor	money
	LanguageDependency	int
	Notes	nvarchar(300)
	OptimisticLockField	int
Indexes
	PK_WorkingType	ON Id
	iDefaultUnit_WorkingType	ON DefaultUnit
Foreign Keys
	FK_WorkingType_DefaultUnit	( DefaultUnit ) ref Unit (Id)

Layout with Tools

Tables

Table AnalysisImportSettings

Table Checklist

Table ChecklistItem

Table Contractor

Table ContractorLanguage

Table ContractorMilestone

Table ContractorPaymentMethod

Table ContractorPriceList

Table ContractorService

Table ContractorTestPiece

Table ContractorUnavailability

Table ContractorUnitConversion

Table ContractorWorkField

Table Country

Table Currency

Table CurrencyRate

Table CustomField

Table Customer

Table CustomerCategory

Table CustomerMilestone

Table CustomerPriceList

Table DocumentChecklistItem

Table DocumentMessage

Table EmailAccount

Table Employee

Table Expense

Table ExpenseCategory

Table ExpenseType

Table FavoriteItem

Table FileType

Table FuzzyType

Table FuzzyTypeKit

Table FuzzyTypeKitDetail

Table IncomeOther

Table Invoice

Table InvoiceDetail

Table InvoiceDetailCorrection

Table InvoiceIn

Table InvoiceInDetail

Table Language

Table LanguageCombination

Table MailMessage

Table MailMessageRecipient

Table MessageTemplate

Table Payment

Table PaymentDetail

Table PaymentMethodSet

Table PaymentOut

Table PaymentOutDetail

Table PlannerException

Table PredefinedTaskSet

Table PredefinedTaskSetDetail

Table PriceList

Table PriceListItem

Table Quote

Table QuoteItem

Table Region

Table SoftwareApplication

Table Tax

Table TestPiece

Table TestPieceProofreader

Table TranslationAssignment

Table TranslationAssignmentDetail

Table TranslationAssignmentPayable

Table TranslationAssignmentPick

Table TranslationJob

Table TranslationJobDetail

Table TranslationJobReceivable

Table TranslationJobSchedule

Table TranslationProject

Table Unit

Table UnitWeight

Table User

Table VendorGroup

Table VendorGroupItem

Table Workflow

Table WorkflowDetail

Table WorkingField