Database Changes
This section contains the database changes from Maconomy version 2.6.1 to 2.6.2.
Maconomy Changes
Summary
6 relations created
0 relations removed
27 were expanded
0 were moved
6 were renamed
98 new fields
10 removed fields
0 renamed fields
Database Relation
Relation: EXTERNALACCOUNT
Field: TEXT4 added
Field: TEXT5 added
Field: TEXT6 added
Field: TEXT7 added
Field: TEXT8 added
Field: TEXT9 added
Field: TEXT10 added
Relation: USERROLEACTIONINFORMATION
Field: CANSEEALLEXPENSESHEETDOCUMEN added
Relation: SUBSCRIPTIONLINE
Field: KEEPPRICE added
Relation: EMPLOYEEFIELDACCESS
Field: TIMESHEETSTARTDATE removed
Field: TIMESHEETENDDATE removed
Relation: PEPPOLMAPPINGHEADER
Field: ISPUFMAPPING added
Relation: DATAIMPORTPACKAGE
Field: PACKAGETYPE added
Relation: APPROVALLINE
Field: APPROVEREMPLOYEEGROUPNAME added
Field: SUBSTITUTEEMPLOYEEGROUPNAME added
Field: SUPERAPPROVEREMPLOYEEGROUPNA added
Relation: EMPLOYEEREFERENCEFIELD
Field: FIELDNAME removed
Relation: DATAIMPORTPACKAGELINE
Field: PACKAGETYPE added
Relation: SUBSCRIPTIONORDERHEADER
Field: REFERENCE added
Field: KEEPPRICE added
Relation: OUTPUTDATARECORD
Field: VARIABLEOPERATION11 added
Field: VARIABLEOPERATION12 added
Field: VARIABLEOPERATION13 added
Field: VARIABLEOPERATION14 added
Field: VARIABLEOPERATION15 added
Field: VARIABLEOPERATION16 added
Field: VARIABLEOPERATION17 added
Field: VARIABLEOPERATION18 added
Field: VARIABLEOPERATION19 added
Field: VARIABLEOPERATION20 added
Relation: COMPANYINFORMATION
Field: SENDTOPAGERO added
Field: COUNTRYLISTNAME added
Relation: CUSTOMER
Field: KEEPPRICESUBSCRIPTIONORDERS added
Field: SENDTOPAGERO added
Relation: OUTPUTDATAFORMAT
Field: AMOUNT1000SEPARATOR added
Field: TEXT1DESCRIPTION added
Field: TEXT2DESCRIPTION added
Field: TEXT3DESCRIPTION added
Field: TEXT4DESCRIPTION added
Field: TEXT5DESCRIPTION added
Field: TEXT6DESCRIPTION added
Field: TEXT7DESCRIPTION added
Field: TEXT8DESCRIPTION added
Field: TEXT9DESCRIPTION added
Field: TEXT10DESCRIPTION added
Field: VARIABLETYPE11 added
Field: VARIABLETYPE11FIXEDTEXT added
Field: VARIABLETYPE12 added
Field: VARIABLETYPE12FIXEDTEXT added
Field: VARIABLETYPE13 added
Field: VARIABLETYPE13FIXEDTEXT added
Field: VARIABLETYPE14 added
Field: VARIABLETYPE14FIXEDTEXT added
Field: VARIABLETYPE15 added
Field: VARIABLETYPE15FIXEDTEXT added
Field: VARIABLETYPE16 added
Field: VARIABLETYPE16FIXEDTEXT added
Field: VARIABLETYPE17 added
Field: VARIABLETYPE17FIXEDTEXT added
Field: VARIABLETYPE18 added
Field: VARIABLETYPE18FIXEDTEXT added
Field: VARIABLETYPE19 added
Field: VARIABLETYPE19FIXEDTEXT added
Field: VARIABLETYPE20 added
Field: VARIABLETYPE20FIXEDTEXT added
Relation: COMPANYCUSTOMER
Field: KEEPPRICESUBSCRIPTIONORDERS added
Field: SENDTOPAGERO added
Relation: VATSETTLEMENTENTRY
Field: RESPONSIBLEFINANCEENTRYKEY added
Field: EXECUTINGFINANCEENTRYKEY added
Relation: APPROVALTYPENOTIFICATION
Field: EMPLOYEEGROUPNAME added
Relation: OUTPUTDATAFIELD
Field: VARIABLEOPERATION11 added
Field: VARIABLEOPERATION12 added
Field: VARIABLEOPERATION13 added
Field: VARIABLEOPERATION14 added
Field: VARIABLEOPERATION15 added
Field: VARIABLEOPERATION16 added
Field: VARIABLEOPERATION17 added
Field: VARIABLEOPERATION18 added
Field: VARIABLEOPERATION19 added
Field: VARIABLEOPERATION20 added
Relation: CHANGEONCHANGE
Field: FIELDNAME removed
Field: FIELDNAMETOUPDATE removed
Relation: APPRHIERARCHYRULEHEADER
Field: HEADERSHOWMYLINES added
Field: HEADERSHOWEMPLOYEETYPELINES added
Field: HEADERSHOWEMPLOYEEGROUPLINES added
Field: LINESHOWMYLINES added
Field: LINESHOWEMPLOYEETYPELINES added
Field: LINESHOWEMPLOYEEGROUPLINES added
Relation: APPROVALHIERARCHYLINE
Field: APPROVEREMPLOYEEGROUPNAME added
Field: SUBSTITUTEEMPLOYEEGROUPNAME added
Field: SUPERAPPROVEREMPLOYEEGROUPNA added
Relation: TARGETGROUPLINE
Field: FIELDNAME removed
Field: FIELDNAMEOPERAND removed
Relation: PAGEROSETUP
Field: PAGEROUSERNAME removed
Field: PAGEROPASSWORD removed
Relation: DAILYCHECKINHEADER
Field: CHECKINTIMEUNROUNDED added
Relation: APPROVALFIELDCHANGE
Field: FIELDNAME removed
Relation: PAYMENTAGENTINFORMATION
Field: TEXT1 added
Field: TEXT2 added
Field: TEXT3 added
Field: TEXT4 added
Field: TEXT5 added
Field: TEXT6 added
Field: TEXT7 added
Field: TEXT8 added
Field: TEXT9 added
Field: TEXT10 added
Relation: JOBHEADEREXTENSION
Field: ALLOWEMPLOYEEREVENUEDISTRIBU added
Relation: APPREMPLOYEEGROUPMEMBER (new)
Relation: EMPLOYEEGROUP (new)
Relation: EMPLOYEEGROUPMEMBER (new)
Relation: PAGEROCOMPANY (new)
Relation: COUNTRYLISTHEADER (new)
Relation: COUNTRYLISTLINE (new)
People Planner Changes
The following shows the database changes from People Planner version 4.4 to 4.5.Table Name | Columns Removed | Columns Added |
---|---|---|
Calendar |
MaconomyVersionNumber |
|
Event |
IsTemplate TemplateJobNumber ReferenceJobNumber |
|
ImportMasterDataFromMaconomyTask |
RestCompanyFilter RestCustomerFilter RestResourceFilter RestEmployeeRevisionFilter |
|
ImportProjectsFromMaconomyTask |
RestProjectFilter |
|
Language |
LanguageCode |
|
MaconomyExtraEventFields |
PaymentCustomer Description1 Description2 |