Database Changes

This section contains the database changes from Maconomy version 2.6 to 2.6.1.

Maconomy Changes

Summary

1 relations created

0 relations removed

10 were expanded

0 were moved

0 were renamed

34 new fields

0 removed fields

0 renamed fields

Database Relation

Relation: APPROVEINVOICESELECTIONACTIO
	Field: FROMPREFERREDINVOICEDATE added
	Field: TOPREFERREDINVOICEDATE added
	Field: ZERONONZERO added
	Field: ONLYJOBSWITHBATCHINVOICESELE added
	Field: CUSTOMERGROUP added
	Field: FROMSETTLINGCOMPANYNUMBER added
	Field: TOSETTLINGCOMPANYNUMBER added  

Relation: USERINFORMATION
	Field: ISSYSTEMUSER added  

Relation: VENDOR
	Field: SUPPLEMENTVSNAME added
	Field: SUPPLEMENTVBPMNAME added  

Relation: COMPANYVENDOR
	Field: SUPPLEMENTCVSNAME added
	Field: SUPPLEMENTCVBPMNAME added

Relation: INVOICEDRAFTSTATUSTARGETGROU
	Field: LANGUAGE added
	Field: RESPONSIBLE added
	Field: POPUP1 added
	Field: POPUP2 added
	Field: POPUP3 added
	Field: POPUP4 added
	Field: POPUP5 added
	Field: CUSTOMERPOPUP1 added
	Field: CUSTOMERPOPUP2 added
	Field: CUSTOMERPOPUP3 added
	Field: CUSTOMERPOPUP4 added
	Field: CUSTOMERPOPUP5 added
	Field: TELEX added
	Field: JOBGROUP added  

Relation: CUSTOMER  
	Field: SUPPLEMENTCSNAME added  
	Field: SUPPLEMENTCBPMNAME added  

Relation: JOBPRICELISTLINE  
	Field: ZEROBASESALARYMARKUPPERCENTA added  
	Field: ZEROSTDBASESALARYMARKUPPERCE added  

Relation: COMPANYCUSTOMER  
	Field: SUPPLEMENTCCSNAME added  
	Field: SUPPLEMENTCCBPMNAME added  

Relation: VATSETTLEMENTENTRY  
	Field: EMPLOYEENUMBER added  

Relation: USERROLEINFORMATION  
	Field: ISSYSTEMUSER added  

Relation: BATCHINVOICESELECTIONERROR (new)

People Planner Changes

Following are the database changes from People Planner version 4.3 to 4.4.

Table Name Columns Removed Columns Added
Assignment MatchedEventRequiredSkillCount
BatchDefinitionTask ForceVerboseLogging
DeleteOldLogEntriesTask ForceVerboseLogging
DeleteProjectDeletedInMaconomyTask ForceVerboseLogging
Event RequiredSkillCount

MatchedRequiredSkillCount

SkillRequirementKey

ExchangeSyncTask ForceVerboseLogging
ExportAssignmentsToMaconomyTask ForceVerboseLogging
ImportAbsenceFromMaconomyTask ForceVerboseLogging
ImportActualsFromMaconomyTask ForceVerboseLogging
ImportExternalMasterDataTask ForceVerboseLogging
ImportMasterDataFromMaconomyTask ForceVerboseLogging
ImportProjectsFromMaconomyTask ForceVerboseLogging
PropertyLevel CalculationValue

LevelName

PropertyType MaconomyPopupOrdinal

MaconomyPopupValue

RegisteredCostByAmount EntryKey
ResourcePropertyAssignment LevelAcquiredDate

SkillAcquiredDate

TimeRegistrationEntry EntryKey
UpdateReportingTablesTask ForceVerboseLogging
User WebUserSettings

Tables Changed from Release 4.3 to Release 4.4

Table Name
ActualsRegistrationEntryForUpdate
ActualsRegistrationEntryForUpdateArchive
EventSkillRequirement
ImportIncrementalActualsFromMaconomyTask
MaconomyJobEntries
SkillRequirementType
WebUserSettings