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