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 |