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 |