Database Changes

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

Maconomy Changes

Summary

3 relations created

13 relations removed

87 were expanded

8 were moved

77 were renamed

186 new fields

193 removed fields

60 renamed fields

Details per Relation

Relation: LIFECYCLESTAGE (removed) 
Relation: EVENTLINE (removed) 
Relation: COMPENSATIONPACKAGEELEMENT (removed) 
Relation: LIFECYCLESTAGEDEFINITION (removed) 
Relation: TODODEFINITION (removed) 
Relation: MONITOR (removed)
Relation: LIFECYCLEDEFINITION (removed) 
Relation: LIFECYCLETRANSITION (removed) 
Relation: GENERALMONITORHEADER (removed) 
Relation: LIFECYCLETRANSITIONDEFINITION (removed) 
Relation: LIFECYCLE (removed) 
Relation: LIFECYCLETODO (removed) 
Relation: LIFECYCLERULEDEFINITION (removed)

Relation: USERROLEACTIONINFORMATION 
	Field: CANSEEHRFORALLEMPLOYEES added 
	Field: CANSEEHRFORSUBORDINATES added 
	Field: CANSEEHRFORMENTEES added 
	Field: CANSEEHRASSECRETARY added 
	Field: CANAPPROVEMONITORS removed

Relation: SEARCHBUDGETCONTROL 
	Field: EXCHANGERATETABLE added 

Relation: CONTACTCOMPANY 
	Field: BLOCKED removed

Relation: JOBPOSTINGREFERENCELINE 
	Field: WIPUNREALIZEDENTERPRISEEXCHA added 
	Field: IOAUNREALIZEDENTERPRISEEXCHA added 
	Field: COSTPRICEUNITPRICEROUNDING added 
	Field: COSTPRICEUNITPRICEENTERPRISE added

Relation: PURCHASEORDERLINE 
	Field: ACCRUALPLANAMOUNTENTERPRISE added 
	Field: JOBBUDGETLINENUMBER removed 
	Field: REMOVEDTEXTLINE removed 
	Field: REMOVEDINVENTORYCONTROL removed
 
Relation: INVOICECUSTOMERAGING 
	Field: REMOVEDREMAINDER removed 
	Field: REMOVEDREMAINDER30 removed 
	Field: REMOVEDREMAINDER60 removed 
	Field: REMOVEDREMAINDER90 removed 
	Field: REMOVEDREMAINDER120 removed 
	Field: REMOVEDBALANCECREDIT removed

Relation: TARGETGROUPSPECHEADER 
	Field: ACCESSLEVELNAME removed 

Relation: BUDGETREALLOCATIONJOURNAL 
	Field: REALLOCATIONDATE removed 

Relation: FINANCEBUDGETEMPLOYEE 
	Field: DEPRECATEDPRODUCTIVEHOURS removed 
	Field: DEPRECATEDPRODUCTIVEHOURSPER removed

Relation: COMPENSATIONTYPE 
	Field: DEPRECATEDNUMBEROFPAYPERIODS removed 

Relation: SEARCHBUDGETINSPECTION 
	Field: EXCHANGERATETABLE added 

Relation: JOBENTRY 
	Field: INCOMINGCOSTPRICEEVATORIGCUR added 
	Field: INCOMINGCOSTPRICEIVATORIGCUR added 
	Field: NUMBEROFHOURSREGISTERED removed 
	Field: NUMBEROFHOURSINVOICE removed 
	Field: COSTPRICETOTAL removed 
	Field: BILLINGPRICETOTALCURRENCY removed 
	Field: BILLINGPRICETOTALBASE removed 
	Field: INVOICE removed

Relation: APPROVALLINE 
	Field: ALLOWSELFAPPROVAL changed name from SUBMITTERCANAPPROVE
	Field: APPROVERADVANCEDREFERENCE added 
	Field: SUBSTITUTEADVANCEDREFERENCE added 
	Field: SUPERAPPROVERADVANCEDREFEREN added

Relation: EMPLOYEE 
	Field: PRIVATEPHONE added 
	Field: SERVICEINVENTORYNAME removed 
	Field: REVISIONVALIDFROMDATE removed 
	Field: REVISIONVALIDTODATE removed 
	Field: REVISIONNUMBER removed 

Relation: OUTPUTDATALINE 
	Field: ISCANCELLED removed 
	Field: CANCELLINGENTRY removed 
	Field: CANCELLEDENTRYPRINTED removed 
	Field: CANCELLEDPAYMENTNUMBER removed 
	Field: CANCELLEDPAYMENTLINENUMBER removed 

Relation: ORDERLINE 
	Field: NEGATEDORIGINALORDERNUMBER removed 

Relation: PAYMENTMODE 
	Field: REMOVEDPAYMENTMODENUMBER removed

Relation: TARGETGROUPJOBREVENUERECOGNI 
	Field: REMOVEDINCLUDEJOBSINQUOTE removed 

Relation: EMPLOYEEREVISION 
	Field: PERSONALEMAILADDRESS changed name from PERSONALEMAILADDRESS 
	Field: PRIVATEPHONE added 
	Field: SERVICEINVENTORYNAME removed 

Relation: PAYMENTMODEREMITTANCE 
	Field: REMOVEDPAYMENTMODENUMBER removed 

Relation: INTERCOMPANYENTRY 
	Field: AMOUNTENTERPRISEEXECUTING changed name from AMOUNTENTERPRISE 
	Field: PAYMENTCUSTOMER added 
	Field: AMOUNTENTERPRISERESPONSIBLE added 

Relation: SETTLEMENTINVOICE 
	Field: AMOUNTENTERPRISEEXECUTING changed name from AMOUNTENTERPRISE 
	Field: AMOUNTENTERPRISERESPONSIBLE added

Relation: USERINFORMATION 
	Field: CLIENTTYPE removed 
	Field: STANDARDCOMPONENT removed

Relation: JOBINVOICELINE 
	Field: TOBEPRINTED removed 
	Field: NUMBEROFHOURSINVOICE removed 
	Field: OVERRUNADJUSTMENT removed 

Relation: JOBREGISTRATIONBUDGETRELATIO 
	Field: JOBBUDGETLINENUMBER removed 

Relation: TASKPROGRESSENTRY 
	Field: JOBBUDGETLINENUMBER removed 

Relation: INVOICINGPLANLINE 
	Field: ACTIVITYTYPE added 

Relation: ASSETENTRY 
	Field: AMOUNTADJUSTMENTCURRENCY changed name from THEAMOUNT 
	Field: ASSETBASECURRENCY changed name from CURRENCY 
	Field: AMOUNTASSETBASE changed name from AMOUNTCURRENCY 
	Field: AMOUNTASSETENTERPRISE changed name from AMOUNTENTERPRISE 
	Field: AMOUNTADJUSTMENTENTERPRISE added

Relation: INTCOMPINTERESTNOTEJOURNAL 
	Field: INTERESTENTERPRISEEXECUTING changed name from INTERESTENTERPRISE 
	Field: INTERESTENTERPRISERESPONSIBL added 

Relation: JOBHEADER 
	Field: BLOCKEDFORPURCHASING added 
	Field: SPECIFICATIONTIME removed 
	Field: SPECIFICATIONAMOUNT removed 
	Field: INVOICECOSTPRICE removed 
	Field: INVOICEBILLINGPRICECURRENCY removed 
	Field: INVOICEBILLINGPRICEBASE removed 
	Field: OPENCOSTPRICE removed 
	Field: OPENBILLINGPRICECURRENCY removed 
	Field: OPENBILLINGPRICEBASE removed 
	Field: SHOWONLYTOTAL removed 
	Field: SHOWAMOUNTONLINES removed 
	Field: INVOICEFROMQUOTE removed 
	Field: SHOWITEMSSEPARATELY removed 
	Field: SHOWMARKUPSEPARATLY removed 
	Field: INVOICECOSTPRICEENTERPRISE removed 
	Field: OPENCOSTPRICEENTERPRISE removed 
	Field: OPENBILLINGPRICEENTERPRISE removed 
	Field: INVOICEBILLINGPRICEENTERPRIS removed 
	Field: KONASPACENUMBER removed

Relation: SETTLEMENTINVOICESPECIFICATI 
	Field: AMOUNTENTERPRISEEXECUTING changed name from AMOUNTENTERPRISE
	Field: AMOUNTENTERPRISERESPONSIBLE added

Relation: MOVEMENTVOUCHER 
	Field: INVENTORYVALUEBASE changed name from INVENTORYVALUE 
	Field: ROUNDINGRECEIVINGENTERPRISE changed name from ROUNDINGENTERPRISE 
	Field: INVENTORYVALUERECEIVINGINVEN changed name from INVENTORYVALUETORECEIVINGINV 
	Field: INVENTORYVALUECURRENCY added 
	Field: INVENTORYVALUESHIPPINGENTERP added 
	Field: INVENTORYVALUERECEIVINGENTER added 
	Field: DUTYTOINVENTORYENTERPRISE added 
	Field: ROUNDINGBASE removed 

Relation: VATCODE 
	Field: VATPOPUP5 added 
	Field: VATPOPUP6 added 
	Field: VATPOPUP7 added 
	Field: VATPOPUP8 added 
	Field: VATPOPUP9 added 
	Field: VATPOPUP10 added

Relation: VENDORINVOICEJOURNAL 
	Field: INVOICERECEIVEDDATE added 

Relation: COMPANYINFORMATION 
	Field: SALESEXCHANGERATETABLE added 
	Field: PURCHASEEXCHANGERATETABLE added 
	Field: DUTYEXCHANGERATETABLE added 
	Field: BUDGETEXCHANGERATETABLE added 
	Field: MISCELLANEOUSEXCHANGERATETAB added 
	Field: FROMOPENENTRY removed 
	Field: TOOPENENTRY removed 
	Field: JOBCOSTFROMOPENENTRY removed 
	Field: JOBCOSTTOOPENENTRY removed 
	Field: ACCRUALTOOPENENTRY removed 

Relation: JOBPRICELISTLINE 
	Field: OVERTIMECHGPCTCOSTORBASESALA changed name from OVERTIMECHGPERCENTAGECOST 
	Field: ZEROMARKUPPERCENTAGE added 
	Field: ZEROSTDMARKUPPERCENTAGE added 
	Field: ZEROINTERCOMPPRICEPERCENTAGE added 
	Field: ZEROADJUSTMENTPERCENTAGE added 
	Field: JOBPRICELISTNUMBER removed 

Relation: PARENTPLANELEMENT 
	Field: JOBBUDGETLINENUMBER removed

Relation: NOTIFICATIONTYPE 
	Field: DEPRECATEDNOTIFICATIONCATEGO changed name from NOTIFICATIONCATEGORY 
	Field: DEPRECATEDPRIORITYTYPE changed name from PRIORITYTYPE 
	Field: DEPRECATEDNOTIFICATIONRELATI changed name from NOTIFICATIONRELATION 
	Field: DEPRECATEDDUPLICATEHANDLING changed name from DUPLICATEHANDLING 
	Field: DEPRECATEDBELONGSTOWORKFLOW changed name from BELONGSTOWORKFLOW 
	Field: DEPRECATEDLIFECYCLEDEFINITIO changed name from LIFECYCLEDEFINITIONNUMBER 
	Field: DEPRECATEDGENERALMONITORNUMB changed name from GENERALMONITORNUMBER 
	Field: DEPRECATEDDEFINITIONKEYNUMBE changed name from DEFINITIONKEYNUMBER 
	Field: DEPRECATEDPRESENTATIONDIALOG changed name from PRESENTATIONDIALOG 
	Field: STANDARDPRIORITY removed 
	Field: PRESENTATIONUNIVERSE removed 
	Field: PRESENTATIONLAYOUT removed 
	Field: ROUTINE1PROCEDURE removed 
	Field: ROUTINE2PROCEDURE removed 
	Field: ROUTINE3PROCEDURE removed 
	Field: ROUTINE4PROCEDURE removed 
	Field: ROUTINE5PROCEDURE removed 
	Field: ROUTINE1NAME removed 
	Field: ROUTINE2NAME removed 
	Field: ROUTINE3NAME removed 
	Field: ROUTINE4NAME removed 
	Field: ROUTINE5NAME removed 
	Field: ACCESSLEVELNAME removed 
	Field: PARAMETERNAME1 removed 
	Field: PARAMETERNAME2 removed 
	Field: PARAMETERNAME3 removed 
	Field: PARAMETERNAME4 removed 
	Field: PARAMETERNAME5 removed 
	Field: PARAMETERNAME6 removed 
	Field: PARAMETERNAME7 removed 
	Field: PARAMETERNAME8 removed 
	Field: PARAMETERNAME9 removed 
	Field: PARAMETERNAME10 removed 
	Field: PARAMETERREFERENCE1 removed 
	Field: PARAMETERREFERENCE2 removed 
	Field: PARAMETERREFERENCE3 removed 
	Field: PARAMETERREFERENCE4 removed 
	Field: PARAMETERREFERENCE5 removed 
	Field: PARAMETERREFERENCE6 removed 
	Field: PARAMETERREFERENCE7 removed 
	Field: PARAMETERREFERENCE8 removed 
	Field: PARAMETERREFERENCE9 removed 
	Field: PARAMETERREFERENCE10 removed
	Field: STANDARDTEXTFIELD1 removed 
	Field: STANDARDTEXTFIELD2 removed 
	Field: STANDARDTEXTFIELD3 removed 
	Field: STANDARDTEXTFIELD4 removed 
	Field: STANDARDTEXTFIELD5 removed 
	Field: STANDARDTEXTFIELD6 removed 
	Field: STANDARDTEXTFIELD7 removed 
	Field: STANDARDTEXTFIELD8 removed 
	Field: STANDARDTEXTFIELD9 removed 
	Field: STANDARDTEXTFIELD10 removed 
	Field: ROUTINE1PACKAGE removed 
	Field: ROUTINE2PACKAGE removed 
	Field: ROUTINE3PACKAGE removed 
	Field: ROUTINE4PACKAGE removed 
	Field: ROUTINE5PACKAGE removed 
	Field: EFFECTIVEFROMPACKAGE removed 
	Field: EFFECTIVEFROMPROCEDURE removed

Relation: VATSETTLEMENTENTRY 
	Field: VATPOPUP5 added 
	Field: VATPOPUP6 added 
	Field: VATPOPUP7 added 
	Field: VATPOPUP8 added 
	Field: VATPOPUP9 added 
	Field: VATPOPUP10 added 

Relation: INTCOMPINTERESTCALCSPECIFICA 
	Field: INTERESTENTERPRISEEXECUTING changed name from INTERESTENTERPRISE 
	Field: INTERESTENTERPRISERESPONSIBL added 

Relation: SALESLISTSYSTEMREPENTRY 
	Field: DEPRECATEDLASTLINENUMBER removed 

Relation: JOBBUDGETLINEPERIOD 
	Field: JOBBUDGETLINENUMBER removed 

Relation: MODULUSCALCULATION 
	Field: ADDZEROES removed

Relation: NOTIFICATION 
	Field: MONITORNUMBER removed 
	Field: EFFECTIVEFROMDATE removed 
	Field: EFFECTIVEFROMTIME removed 
	Field: NOTIFICATIONTEXT removed 
	Field: PRIORITYTYPE removed 
	Field: PRIORITY removed 
	Field: CONFIRMEDDATE removed 
	Field: CONFIRMEDTIME removed
	Field: ALLOWNORECEIVER removed

Relation: EMAILALERTSTEMPLATE 
	Field: PORTALLOGINURL removed 

Relation: CUSTOMERJOURNAL 
	Field: ORIGINALCURRENCY removed 
	Field: ORIGINALAMOUNT removed 

Relation: POPUPTYPE 
	Field: TITLEOFRESERVEDSTRING1 changed name from FIXEDTEXTS1 
	Field: TITLEOFRESERVEDSTRING2 changed name from FIXEDTEXTS2 
	Field: TITLEOFRESERVEDSTRING3 changed name from FIXEDTEXTS3 
	Field: TITLEOFRESERVEDSTRING4 changed name from FIXEDTEXTS4 
	Field: TITLEOFRESERVEDAMOUNT1 changed name from FIXEDTEXTA1 
	Field: TITLEOFRESERVEDAMOUNT2 changed name from FIXEDTEXTA2 
	Field: TITLEOFRESERVEDAMOUNT3 changed name from FIXEDTEXTA3 
	Field: TITLEOFRESERVEDAMOUNT4 changed name from FIXEDTEXTA4 
	Field: TITLEOFRESERVEDREAL1 changed name from FIXEDTEXTR1 
	Field: TITLEOFRESERVEDREAL2 changed name from FIXEDTEXTR2 
	Field: TITLEOFRESERVEDREAL3 changed name from FIXEDTEXTR3 
	Field: TITLEOFRESERVEDREAL4 changed name from FIXEDTEXTR4 
	Field: TITLEOFRESERVEDINTEGER1 changed name from FIXEDTEXTI1 
	Field: TITLEOFRESERVEDINTEGER2 changed name from FIXEDTEXTI2 
	Field: TITLEOFRESERVEDINTEGER3 changed name from FIXEDTEXTI3 
	Field: TITLEOFRESERVEDINTEGER4 changed name from FIXEDTEXTI4 
	Field: TITLEOFRESERVEDBOOLEAN1 changed name from FIXEDTEXTB1 
	Field: TITLEOFRESERVEDBOOLEAN2 changed name from FIXEDTEXTB2 
	Field: TITLEOFRESERVEDBOOLEAN3 changed name from FIXEDTEXTB3 
	Field: TITLEOFRESERVEDBOOLEAN4 changed name from FIXEDTEXTB4 
	Field: TITLEOFRESERVEDDATE1 changed name from FIXEDTEXTD1 
	Field: TITLEOFRESERVEDDATE2 changed name from FIXEDTEXTD2 
	Field: TITLEOFRESERVEDDATE3 changed name from FIXEDTEXTD3 
	Field: TITLEOFRESERVEDDATE4 changed name from FIXEDTEXTD4 
	Field: TITLEOFRESERVEDTIME1 changed name from FIXEDTEXTT1 
	Field: TITLEOFRESERVEDTIME2 changed name from FIXEDTEXTT2 
	Field: TITLEOFRESERVEDTIME3 changed name from FIXEDTEXTT3 
	Field: TITLEOFRESERVEDTIME4 changed name from FIXEDTEXTT4 

Relation: DOCUMENTARCHIVELINE 
	Field: INTERNALDOCUMENTTYPE removed 
	Field: DOCUMENTTYPE removed 
	Field: DOCUMENTSIZE removed 
	Field: CHANGEDDATE removed
	Field: CHANGEDTIME removed 
	Field: REMARK1 removed 
	Field: REMARK2 removed 
	Field: REMARK3 removed

Relation: JOBCURRENCYADJUSTMENT 
	Field: ADJUSTMENTENTERPRISE added 
	Field: ADJUSTMENTBALANCINGENTERPRIS added 

Relation: VATREPORTINGUNIT 
	Field: EXCHANGERATETABLE added 

Relation: VATREPUNITSELECTIONLINE 
	Field: VATPOPUP5 added 
	Field: VATPOPUP6 added 
	Field: VATPOPUP7 added
	Field: VATPOPUP8 added 
	Field: VATPOPUP9 added 
	Field: VATPOPUP10 added 

Relation: LOCALSPEC10LINE 
	Field: EMPLOYEENUMBER1 added 
	Field: EMPLOYEENUMBER2 added 
	Field: EMPLOYEENUMBER3 added 
	Field: EMPLOYEENUMBER4 added
	Field: EMPLOYEENUMBER5 added 
	Field: EMPLOYEENUMBER6 added
	Field: EMPLOYEENUMBER7 added 
	Field: EMPLOYEENUMBER8 added 
	Field: EMPLOYEENUMBER9 added 
	Field: EMPLOYEENUMBER10 added 

Relation: JOBREALLOCATIONENTRY 
	Field: INVOICE removed 
	Field: ACCRUALBASE removed 
	Field: ACCRUALENTERPRISE removed 

Relation: CONTACTPERSON 
	Field: LINKEDEMPLOYEENUMBER added 
	Field: SUPERIOREMPLOYEE added 
	Field: TUTOREMPLOYEE added 
	Field: SECRETARYEMPLOYEE added 

Relation: INVOICEALLOCATIONLINE 
	Field: REMOVEDINVENTORYCONTROL removed 
	Field: REMOVEDSELECTEDFORSUBCONTRAC removed

Relation: DIALOGGROUP 
	Field: ROLENUMBER removed 
	Field: ROLENAME removed 
	Field: STANDARDCOMPONENT removed

Relation: LOCALSPEC1LINE 
	Field: EMPLOYEENUMBER1 added 
	Field: EMPLOYEENUMBER2 added 
	Field: EMPLOYEENUMBER3 added 
	Field: EMPLOYEENUMBER4 added 
	Field: EMPLOYEENUMBER5 added 
	Field: EMPLOYEENUMBER6 added 
	Field: EMPLOYEENUMBER7 added 
	Field: EMPLOYEENUMBER8 added 
	Field: EMPLOYEENUMBER9 added 
	Field: EMPLOYEENUMBER10 added 

Relation: INTERCOMPANYINVOICE 
	Field: AMOUNTENTERPRISEEXECUTING changed name from AMOUNTENTERPRISE 
	Field: AMOUNTENTERPRISERESPONSIBLE added 

Relation: PARENTSUBORDINATEREFERENCERE (changed from NOTIFICATIONREFERENCERELATIO) 
Relation: COMPENSATIONAGREEMENT 
	Field: DEPRECATEDVALUEOFAGREEMENTPA removed 
	Field: DEPRECATEDVALUEOFAGREEMENTCU removed 
	Field: DEPRECATEDEXPECTEDVALUEOFAGR removed

Relation: FINANCEVATCODE 
	Field: VATPOPUP5 added 
	Field: VATPOPUP6 added 
	Field: VATPOPUP7 added 
	Field: VATPOPUP8 added 
	Field: VATPOPUP9 added 
	Field: VATPOPUP10 added 

Relation: PLANNINGLINE 
	Field: JOBBUDGETLINENUMBER removed 

Relation: EMAILALERTSNOTIFICATIONTYPE 
	Field: DEPRECATEDNOTIFICATIONCLIENT changed name from NOTIFICATIONCLIENTTYPE 

Relation: JOBREALLOCATIONJOURNAL 
	Field: INVOICE removed 

Relation: LOCALSPEC2LINE 
	Field: EMPLOYEENUMBER1 added 
	Field: EMPLOYEENUMBER2 added 
	Field: EMPLOYEENUMBER3 added 
	Field: EMPLOYEENUMBER4 added 
	Field: EMPLOYEENUMBER5 added 
	Field: EMPLOYEENUMBER6 added
	Field: EMPLOYEENUMBER7 added 
	Field: EMPLOYEENUMBER8 added 
	Field: EMPLOYEENUMBER9 added 
	Field: EMPLOYEENUMBER10 added

Relation: JOBACTIVITY 
	Field: CLOSEREMAINDER removed 
	Field: DIRECTINVOICING removed 
	Field: EMPLOYEENUMBER removed 

Relation: JOBBUDGETITEMLINE 
	Field: JOBBUDGETLINENUMBER removed 
	Field: THEKEY removed 

Relation: VENDORENTRY 
	Field: INVOICERECEIVEDDATE added 

Relation: APPRHIERARCHYRULEHEADER 
	Field: AUTOMATICSUBMISSIONATREAPPRO removed 

Relation: LOCALSPEC3LINE 
	Field: EMPLOYEENUMBER1 added 
	Field: EMPLOYEENUMBER2 added 
	Field: EMPLOYEENUMBER3 added 
	Field: EMPLOYEENUMBER4 added 
	Field: EMPLOYEENUMBER5 added 
	Field: EMPLOYEENUMBER6 added 
	Field: EMPLOYEENUMBER7 added 
	Field: EMPLOYEENUMBER8 added 
	Field: EMPLOYEENUMBER9 added 
	Field: EMPLOYEENUMBER10 added

Relation: SYSTEMINFORMATION 
	Field: MISCELLANEOUSEXCHANGERATETAB added 
	Field: POSTJOBSPERACTIVITY removed 
	Field: REMOVEDGETENTRYTEXTFROMVENDO removed 
	Field: REMOVEDUSENAMEASENTRYTEXT removed 
	Field: REMOVEDRECONCILENONAPPROVEDV removed 
	Field: REMOVEDSUGGESTNAMEASENTRYTEX removed 
	Field: JOBCOSTFROMOPENENTRY removed 
	Field: JOBCOSTTOOPENENTRY removed 
	Field: ACCRUALTOOPENENTRY removed 

Relation: LOCALSPEC4LINE 
	Field: EMPLOYEENUMBER1 added 
	Field: EMPLOYEENUMBER2 added 
	Field: EMPLOYEENUMBER3 added 
	Field: EMPLOYEENUMBER4 added
	Field: EMPLOYEENUMBER5 added 
	Field: EMPLOYEENUMBER6 added 
	Field: EMPLOYEENUMBER7 added 
	Field: EMPLOYEENUMBER8 added
	Field: EMPLOYEENUMBER9 added 
	Field: EMPLOYEENUMBER10 added

Relation: APPROVALGROUP 
	Field: EMPLOYEENUMBER added 

Relation: ITEMJOURNAL 
	Field: INVENTORYVALUEORIGINAL changed name from INVENTORYVALUE 
	Field: ORIGINALCURRENCY changed name from INVENTORYCURRENCY 
	Field: INVENTORYVALUEBASE added 
	Field: INVENTORYVALUEFROMINVENTORYE added 
	Field: INVENTORYVALUETOINVENTORYENT added 

Relation: LOCALSPEC5LINE 
	Field: EMPLOYEENUMBER1 added 
	Field: EMPLOYEENUMBER2 added 
	Field: EMPLOYEENUMBER3 added 
	Field: EMPLOYEENUMBER4 added 
	Field: EMPLOYEENUMBER5 added 
	Field: EMPLOYEENUMBER6 added 
	Field: EMPLOYEENUMBER7 added 
	Field: EMPLOYEENUMBER8 added 
	Field: EMPLOYEENUMBER9 added 
	Field: EMPLOYEENUMBER10 added 

Relation: APPROVALHIERARCHYLINE 
	Field: ALLOWSELFAPPROVAL changed name from SUBMITTERCANAPPROVE 
	Field: APPROVERADVANCEDREFERENCE added 
	Field: SUBSTITUTEADVANCEDREFERENCE added 
	Field: SUPERAPPROVERADVANCEDREFEREN added

Relation: INTCOMPINTERESTNOTE 
	Field: INTERESTENTERPRISEEXECUTING changed name from INTERESTENTERPRISE 
	Field: INTERESTENTERPRISERESPONSIBL added 

Relation: LOCALSPEC6LINE 
	Field: EMPLOYEENUMBER1 added 
	Field: EMPLOYEENUMBER2 added 
	Field: EMPLOYEENUMBER3 added 
	Field: EMPLOYEENUMBER4 added 
	Field: EMPLOYEENUMBER5 added 
	Field: EMPLOYEENUMBER6 added 
	Field: EMPLOYEENUMBER7 added 
	Field: EMPLOYEENUMBER8 added
	Field: EMPLOYEENUMBER9 added 
	Field: EMPLOYEENUMBER10 added

Relation: CUSTOMERPAYMENTMODEREMITTANC 
	Field: REMOVEDCUSTOMERPAYMENTMODENU removed 

Relation: OUTGOINGPAYMENTFORM 
	Field: ALLOWCANCELLATION removed 

Relation: EMAILALERTSSETUP 
	Field: REMOVEDSMTPSERVERNAME removed 
	Field: REMOVEDSMTPSERVERPORTNUMBER removed 

Relation: LOCALSPEC7LINE 
	Field: EMPLOYEENUMBER1 added 
	Field: EMPLOYEENUMBER2 added 
	Field: EMPLOYEENUMBER3 added 
	Field: EMPLOYEENUMBER4 added 
	Field: EMPLOYEENUMBER5 added 
	Field: EMPLOYEENUMBER6 added 
	Field: EMPLOYEENUMBER7 added 
	Field: EMPLOYEENUMBER8 added 
	Field: EMPLOYEENUMBER9 added 
	Field: EMPLOYEENUMBER10 added 

Relation: JOBBUDGETTEXTLINE 
	Field: THEKEY removed 

Relation: TIMESHEETLINE 
	Field: JOBBUDGETLINENUMBER removed

Relation: LOCALSPEC8LINE 
	Field: EMPLOYEENUMBER1 added 
	Field: EMPLOYEENUMBER2 added 
	Field: EMPLOYEENUMBER3 added 
	Field: EMPLOYEENUMBER4 added 
	Field: EMPLOYEENUMBER5 added 
	Field: EMPLOYEENUMBER6 added 
	Field: EMPLOYEENUMBER7 added 
	Field: EMPLOYEENUMBER8 added 
	Field: EMPLOYEENUMBER9 added 
	Field: EMPLOYEENUMBER10 added 

Relation: INTCOMPGROUPINGJOURNAL 
	Field: AMOUNTENTERPRISEEXECUTING changed name from AMOUNTENTERPRISE 
	Field: AMOUNTENTERPRISERESPONSIBLE added

Relation: PAYMENTAGENTINFORMATION
	Field: REMOVEDPAYMENTAGENTNUMBER removed 

Relation: LOCALSPEC9LINE 
	Field: EMPLOYEENUMBER1 added 
	Field: EMPLOYEENUMBER2 added 
	Field: EMPLOYEENUMBER3 added 
	Field: EMPLOYEENUMBER4 added 
	Field: EMPLOYEENUMBER5 added 
	Field: EMPLOYEENUMBER6 added 
	Field: EMPLOYEENUMBER7 added 
	Field: EMPLOYEENUMBER8 added 
	Field: EMPLOYEENUMBER9 added 
	Field: EMPLOYEENUMBER10 added 

Relation: JOBBUDGETLINE 
	Field: APPROVEDASLINENUMBER removed 
	Field: LINEKEY removed 

Relation: NOTIFICATIONCATEGORY 
	Field: PRIORITYTYPE removed

Relation: INVOICELAYOUTINFORMATION 
	Field: CREATEINVOICEONACCOUNTFROMQU added 
	Field: REMOVEDINVOICEEDITINGMANDATO removed 
	Field: REMOVEDINVOICINGPRINCIPLE removed 
	Field: REMOVEDHANDLINGOFOVERRUNS removed
	Field: REMOVEDJOBPROCESSING removed 
	Field: REMOVEDRESULTTYPE removed 
	Field: REMOVEDHEADINGTYPE removed 
	Field: REMOVEDRECOGNIZEREVENUEBYCP removed 
	Field: REMOVEDFIXEDPRICEBASIS removed 
	Field: REMOVEDFIXEDPRICEBUDGETTYPE removed 
	Field: REMOVEDINCLUDEOUTLAYSINFIXED removed 

Relation: ASSETGROUP 
	Field: REMOVEDASSETGROUPNUMBER removed 

Relation: CHARGECODEINFO 
	Field: LANGUAGETEXTGROUP removed 

Relation: EMPLOYEESKILL 
	Field: EXPIRYDATE added 

Relation: APPROVALHIERARCHYHEADER 
	Field: ALLOWSELFAPPROVAL changed name from DEFAULTSUBMITTERCANAPPROVE 

Relation: OPPORTUNITY 
	Field: KONASPACENUMBER removed

Relation: ADVANCEDREFERENCE (new) 
Relation: EMPLOYEEFIELDACCESS (new) 
Relation: DUMMYROOT (new)

People Planner Changes

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

Tables Changed from Release 4.2.3 to Release 4.3
Table Name Columns Removed Columns Added
Event

Remark1

Remark2

Remark3

Remark4

Remark5

Remark6

Remark7

Remark8

Remark9

Remark10

UpdateReportingTablesTask AmountLine
Tables Changed from Release 4.2.3 to Release 4.3
Table Name
CryptoKeyUpdateHistory
LicenseHistory