svn commit: r1818765 - in /ofbiz: ofbiz-framework/trunk/applicat
Locked
svn commit: r1818765 - in /ofbiz: ofbiz-framework/trunk/applicat
 
|
Author: jleroux
Date: Wed Dec 20 09:44:43 2017 New Revision: 1818765 URL: http://svn.apache.org/viewvc?rev=1818765&view=rev Log: Completed: Create a DATAMODELCHANGES.md to track data model changes (OFBIZ-9902) We have already the wiki page Revisions+Requiring+Data+Migration+-+upgrade+ofbiz but it's only by revisions. This adds a applications/datamodel/DATAMODEL_CHANGES.md document by releases and put an HTML copy in tools/wiki-files/data-model which will be referenced by the wiki page above I wondered about putting a copy in tools/documentation/data-model/DATAMODEL_CHANGES.md but I think it's not needed Also updates themes/README.md.html while at it Thanks: Aditya Deepak and all http://markmail.org/message/4mrffmp5j2mujv3w participants Added: ofbiz/ofbiz-framework/trunk/applications/datamodel/DATAMODEL_CHANGES.md (with props) ofbiz/tools/wiki-files/data-model/ ofbiz/tools/wiki-files/data-model/DATAMODEL_CHANGES.md.html (with props) Modified: ofbiz/tools/wiki-files/themes/README.md.html Added: ofbiz/ofbiz-framework/trunk/applications/datamodel/DATAMODEL_CHANGES.md URL: http://svn.apache.org/viewvc/ofbiz/ofbiz-framework/trunk/applications/datamodel/DATAMODEL_CHANGES.md?rev=1818765&view=auto ============================================================================== --- ofbiz/ofbiz-framework/trunk/applications/datamodel/DATAMODEL_CHANGES.md (added) +++ ofbiz/ofbiz-framework/trunk/applications/datamodel/DATAMODEL_CHANGES.md Wed Dec 20 09:44:43 2017 @@ -0,0 +1,381 @@ +<!-- +Licensed to the Apache Software Foundation (ASF) under one +or more contributor license agreements. See the NOTICE file +distributed with this work for additional information +regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the +"License"); you may not use this file except in compliance +with the License. You may obtain a copy of the License at + +http://www.apache.org/licenses/LICENSE-2.0 + +Unless required by applicable law or agreed to in writing, +software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +KIND, either express or implied. See the License for the +specific language governing permissions and limitations +under the License. +--> +Apache OFBiz® Data Model Changes +============= +Apache OFBiz follows **The Universal Data Model** by **Len Silverston**, with a grain of salt. + +The following file contains information about the data model changes in the Apache OFBiz. +The detailed description of migration scripts specified here can be found at [Revisions Requiring Data Migration - upgrade ofbiz](https://cwiki.apache.org/confluence/x/LoBr) page. + +##Changes with OFBiz 17 +Field types "id-ne", "id-long-ne" & "id-vlong-ne" has been removed. Use "id", "id-long" and "id-vlong" instead (detailed description at [OFBIZ-9351](https://issues.apache.org/jira/browse/OFBIZ-9351)). + +###Entity Changes +No changes + +###Field Changes + +| Entity | Field | Action | IsPK | Revision | +|:------------- |:---------------:|:---------------:|:---------------:| -------------:| +| MarketingCampaignPrice | fromDate | Added | Yes | R1805961 | +| MarketingCampaignPrice | thruDate | Added | No | R1805961 | +| MarketingCampaignPromo | fromDate | Added | Yes | R1805961 | +| MarketingCampaignPromo | thruDate | Added | No | R1805961 | +| MarketingCampaignRole | fromDate | Added | Yes | R1805961 | +| MarketingCampaignRole | thruDate | Added | No | R1805961 | +| Product | manufacturerPartyId | Removed | No| R1804408 | +| SecurityGroupPermission | fromDate | Added | Yes | R1812383 | +| SecurityGroupPermission | thruDate | Added | No | R1812383 | + +###Migration Scripts +1. Updated sql-type for date-time and time field in fieldtypemysql.xml file +R1793300 "Update msyql sql-type for datetime field-type to support Fractional Seconds in Time Values +Please upgrade mysql to at least 5.6.4 or higher. +After upgrade run 'generateMySqlFileWithAlterTableForTimestamps' service, groupName is required field for this service, +It will generate sql file with alter query statement for date-time and time field at location "${ofbiz.home}/runtime/tempfiles/<groupName>.sql" +You can use execute sql statement from any of the mysql batch command. + +##Changes between OFBiz 9 to OFBiz 16 + +###Entity Changes +**Added 77 new entities** + +1. JobRequisition +2. ProductAverageCostType +3. WorkEffortSurveyAppl +4. WorkEffortIcalData +5. WebSiteContactList +6. WebAnalyticsType +7. WebAnalyticsConfig +8. UserLoginSecurityQuestion +9. UomGroup +10. TrainingRequest +11. ThirdPartyLogin +12. TestFieldType +13. TestingSubtype +14. TestingStatus +15. TestingRemoveAll +16. TestingItem +17. TestingCrypto +18. SystemProperty +19. ShipmentGatewayUsps +20. ShipmentGatewayUps +21. ShipmentGatewayFedex +22. ShipmentGatewayDhl +23. ShipmentGatewayConfig +24. ShipmentGatewayConfigType +25. ReturnContactMech +26. QuoteNote +27. ProductPromoContent +28. ProductPromoContentType +29. ProductGroupOrder +30. ProductCostComponentCalc +31. CostComponentCalc +32. PayPalPaymentMethod +33. PaymentGroupType +34. PaymentGroup +35. PaymentGroupMember +36. PaymentGatewayConfig +37. PaymentGatewayConfigType +38. PaymentGatewayWorldPay +39. PaymentGatewaySecurePay +40. PaymentGatewaySagePay +41. PaymentGatewayOrbital +42. PaymentGatewayEway +43. PaymentGatewayCyberSource +44. PaymentGatewayAuthorizeNet +45. PaymentGatewayIDEAL +46. PaymentContentType +47. PaymentContent +48. OAuth2LinkedIn +49. OAuth2GitHub +50. JobManagerLock +51. JobInterviewType +52. JobInterview +53. JavaResource +54. InvoiceNote +55. InvoiceItemAssocType +56. InvoiceItemAssoc +57. InvoiceContentType +58. InvoiceContent +59. GlAccountCategoryType +60. GlAccountCategoryMember +61. GlAccountCategory +62. GitHubUser +63. FixedAssetTypeGlAccount +64. FacilityContent +65. ExcelImportHistory +66. EmplLeaveReasonType +67. EbayShippingMethod +68. EbayConfig +69. CountryAddressFormat +70. ContentSearchResult +71. ContentSearchConstraint +72. ContentKeyword +73. CheckAccount +74. AgreementFacilityAppl +75. AgreementContentType +76. AgreementContent + +**Removed 8 entities** + +1. DepreciationMethod +2. FixedAssetMaintMeter +3. OagisMessageErrorInfo +4. OagisMessageInfo +5. SalesOpportunityTrackingCode +6. SimpleSalesTaxLookup +7. TestBlob +8. WorkEffortAssignmentRate + + +###Field Changes +| Entity | Field | Action | IsPK | Revision | +|:------------- |:---------------:|:---------------:|:---------------:| -------------:| +| AcctgTransAttribute | attrDescription | Added | No| | +| AcctgTransEntry | inventoryItemId | Added | No| | +| AcctgTransTypeAttr | description | Added | No| | +| BenefitType | parentTypeId | Added | No| | +| BenefitType | hasTable | Added | No| | +| BudgetAttribute | attrDescription | Added | No| | +| BudgetItemAttribute | attrDescription | Added | No| | +| BudgetItemTypeAttr | description | Added | No| | +| BudgetStatus | changeByUserLoginId | Added | No| | +| BudgetTypeAttr | description | Added | No| | +| CommunicationEventRole | statusId | Added | No| | +| CommunicationEventType | contactMechTypeId | Added | No| | +| ContactListCommStatus | partyId | Added | No| | +| ContactListCommStatus | messageId | Added | No| | +| ContactListCommStatus | changeByUserLoginId | Added | No| | +| ContactMechAttribute | attrDescription | Added | No| | +| ContactMechTypeAttr | description | Added | No| | +| DeductionType | parentTypeId | Added | No| | +| DeductionType | hasTable | Added | No| | +| DocumentAttribute | attrDescription | Added | No| | +| DocumentTypeAttr | description | Added | No| | +| EmploymentApp | approverPartyId | Added | No| | +| EmploymentApp | jobRequisitionId | Added | No| | +| EmploymentAppSourceType | parentTypeId | Added | No| | +| EmploymentAppSourceType | hasTable | Added | No| | +| EmplPositionClassType | parentTypeId | Added | No| | +| EmplPositionClassType | hasTable | Added | No| | +| EmplPositionType | parentTypeId | Added | No| | +| EmplPositionType | hasTable | Added | No| | +| EmplPositionType | partyId | Removed | No| | +| EmplPositionType | roleTypeId | Removed | No| | +| FinAccountAttribute | attrDescription | Added | No| | +| FinAccountTransAttribute | attrDescription | Added | No| | +| FinAccountTrans | glReconciliationId | Added | No| | +| FinAccountTrans | statusId | Added | No| | +| FinAccountTransTypeAttr | description | Added | No| | +| FinAccountTypeAttr | description | Added | No| | +| FinAccountStatus | changeByUserLoginId | Added | No| | +| FixedAsset | acquireOrderId | Added | No| | +| FixedAsset | acquireOrderItemSeqId | Added | No| | +| FixedAssetAttribute | attrDescription | Added | No| | +| FixedAssetTypeAttr | description | Added | No| | +| GlAccount | externalId | Added | No| | +| GlAccount | openingBalance | Added | No| | +| GlReconciliation | createdDate | Added | No| | +| GlReconciliation | lastModifiedDate | Added | No| | +| GlReconciliation | statusId | Added | No| | +| GlReconciliation | openingBalance | Added | No| | +| InventoryItemAttribute | attrDescription | Added | No| | +| InventoryItemStatus | changeByUserLoginId | Added | No| | +| InventoryItemTypeAttr | description | Added | No| | +| InvoiceAttribute | attrDescription | Added | No| | +| InvoiceItemAttribute | attrDescription | Added | No| | +| InvoiceItemTypeAttr | description | Added | No| | +| InvoiceStatus | changeByUserLoginId | Added | No| | +| InvoiceTypeAttr | description | Added | No| | +| InvoiceTermAttribute | attrDescription | Added | No| | +| JobSandbox | currentRetryCount | Added | No| | +| JobSandbox | tempExprId | Added | No| | +| JobSandbox | currentRecurrenceCount | Added | No| | +| JobSandbox | maxRecurrenceCount | Added | No| | +| JobSandbox | jobResult | Added | No| | +| OrderAdjustment | amountAlreadyIncluded | Added | No| | +| OrderAdjustment | isManual | Added | No| | +| OrderAdjustment | oldPercentage | Added | No| | +| OrderAdjustment | oldAmountPerQuantity | Added | No| | +| OrderAdjustment | lastModifiedDate | Added | No| | +| OrderAdjustment | lastModifiedByUserLogin | Added | No| | +| OrderAdjustmentAttribute | attrDescription | Added | No| | +| OrderAdjustmentTypeAttr | description | Added | No| | +| OrderAttribute | attrDescription | Added | No| | +| OrderItem | supplierProductId | Added | No| | +| OrderItem | cancelBackOrderDate | Added | No| | +| OrderItem | changeByUserLoginId | Added | No| | +| OrderItemAttribute | attrDescription | Added | No| | +| OrderItemShipGroup | facilityId | Added | No| | +| OrderItemShipGroup | estimatedShipDate | Added | No| | +| OrderItemShipGroup | estimatedDeliveryDate | Added | No| | +| OrderItemShipGrpInvRes | priority | Added | No| | +| OrderItemShipGrpInvRes | oldPickStartDate | Added | No| | +| OrderItemTypeAttr | description | Added | No| | +| OrderTermAttribute | attrDescription | Added | No| | +| OrderPaymentPreference | track2 | Added | No| | +| OrderPaymentPreference | swipedFlag | Added | No| | +| OrderPaymentPreference | lastModifiedDate | Added | No| | +| OrderPaymentPreference | lastModifiedByUserLogin | Added | No| | +| OrderShipment | shipGroupSeqId | Added | No| | +| OrderTypeAttr | description | Added | No| | +| PartyAcctgPreference | orderSequenceEnumId | Removed | No| | +| PartyAcctgPreference | quoteSequenceEnumId | Removed | No| | +| PartyAcctgPreference | invoiceSequenceEnumId | Removed | No| | +| PartyAcctgPreference | oldOrderSequenceEnumId | Added | No| | +| PartyAcctgPreference | oldQuoteSequenceEnumId | Added | No| | +| PartyAcctgPreference | oldInvoiceSequenceEnumId | Added | No| | +| PartyAcctgPreference | orderSeqCustMethId | Added | No| | +| PartyQual | infoString | Removed | No| | +| PartyQual | institutionInternalId | Removed | No| | +| PartyQual | institutionPartyId | Removed | No| | +| PartyQual | partyQualId | Removed | No| | +| PartyRate | percentageUsed | Added | No| | +| PartyRate | rate | Removed | No| | +| PartyResume | contentId | Added | No| | +| PaymentAttribute | attrDescription | Added | No| | +| PaymentGatewayResponse | gatewayCvResult | Added | No| | +| PaymentMethod | finAccountId | Added | No| | +| PaymentTypeAttr | description | Added | No| | +| PerfRatingType | parentTypeId | Added | No| | +| PerfRatingType | hasTable | Added | No| | +| PerfReview | payHistoryRoleTypeIdTo | Removed | No| | +| PerfReview | payHistoryRoleTypeIdFrom | Removed | No| | +| PerfReview | payHistoryPartyIdTo | Removed | No| | +| PerfReview | payHistoryPartyIdFrom | Removed | No| | +| PerfReview | payHistoryFromDate | Removed | No| | +| PerfReviewItemType | parentTypeId | Added | No| | +| PerfReviewItemType | hasTable | Added | No| | +| PersonTraining | trainingRequestId | Added | No| | +| PersonTraining | workEffortId | Added | No| | +| PersonTraining | approverId | Added | No| | +| PersonTraining | approvalStatus | Added | No| | +| PersonTraining | reason | Added | No| | +| PostalAddress | houseNumber | Added | No| | +| PostalAddress | houseNumberExt | Added | No| | +| PostalAddress | cityGeoId | Added | No| | +| PostalAddress | municipalityGeoId | Added | No| | +| PostalAddress | geoPointId | Added | No| | +| PosTerminal | terminalName | Added | No| | +| PosTerminalInternTx | reasonEnumId | Added | No| | +| Product | releaseDate | Added | No| | +| Product | originalImageUrl | Added | No| | +| Product | inventoryItemTypeId | Added | No| | +| Product | shippingWeight | Added | No| | +| Product | productWeight | Added | No| | +| Product | diameterUomId | Added | No| | +| Product | productDiameter | Added | No| | +| Product | virtualVariantMethodEnum | Added | No| | +| Product | defaultShipmentBoxTypeId | Added | No| | +| Product | lotIdFilledIn | Added | No| | +| Product | orderDecimalQuantity | Added | No| | +| Product | weight | Removed | No| | +| Product | taxCategory | Removed | No| | +| Product | taxVatCode | Removed | No| | +| Product | taxDutyCode | Removed | No| | +| ProductAttribute | attrDescription | Added | No| | +| ProductAverageCost | productAverageCostTypeId | Added | No| | +| ProductAverageCost | facilityId | Added | No| | +| ProductContent | sequenceNum | Added | No| | +| ProductKeyword | keywordTypeId | Added | No| | +| ProductKeyword | statusId | Added | No| | +| ProductRole | sequenceNum | Added | No| | +| ProductStore | balanceResOnOrderCreation | Added | No| | +| ProductStore | defaultTimeZoneString | Added | No| | +| ProductStore | oldStyleSheet | Added | No| | +| ProductStore | oldHeaderLogo | Added | No| | +| ProductStore | oldHeaderRightBackground | Added | No| | +| ProductStore | oldHeaderMiddleBackground | Added | No| | +| ProductStore | styleSheet | Removed | No| | +| ProductStore | headerLogo | Removed | No| | +| ProductStore | headerRightBackground | Removed | No| | +| ProductStore | headerMiddleBackground | Removed | No| | +| ProductStorePaymentSetting | paymentCustomMethodId | Added | No| | +| ProductStorePaymentSetting | paymentGatewayConfigId | Added | No| | +| ProductStoreShipmentMeth | shipmentCustomMethodId | Added | No| | +| ProductStoreShipmentMeth | shipmentGatewayConfigId | Added | No| | +| ProductStoreShipmentMeth | allowancePercent | Added | No| | +| ProductStoreShipmentMeth | minimumPrice | Added | No| | +| ProductTypeAttribute | attrDescription | Added | No| +| QuoteAdjustment | lastModifiedDate | Added | No| | +| QuoteAdjustment | lastModifiedByUserLogin | Added | No| | +| QuoteAttribute | attrDescription | Added | No| | +| QuoteItem | leadTimeDays | Added | No| | +| QuoteRole | fromDate | Added | Yes| | +| QuoteRole | thruDate | Added | No| | +| QuoteTerm | termDays | Added | No| | +| QuoteTerm | textValue | Added | No| | +| QuoteTerm | description | Added | No| | +| QuoteTermAttribute | attrDescription | Added | No| | +| QuoteTypeAttr | description | Added | No| | +| RequirementAttribute | changeByUserLoginId | Added | No| | +| RequirementStatus | changeByUserLoginId | Added | No| | +| ResponsibilityType | parentTypeId | Added | No| | +| ResponsibilityType | hasTable | Added | No| | +| ReturnAdjustment | createdByUserLoginId | Added | No| | +| ReturnAdjustment | lastModifiedDate | Added | No| | +| ReturnAdjustment | lastModifiedByUserLogin | Added | No| | +| ReturnHeader | supplierRmaId | Added | No| | +| ReturnItemResponse | finAccountTransId | Added | No| | +| ReturnStatus | changeByUserLoginId | Added | No| | +| SalaryStep | fromDate | Added | Yes| | +| SalaryStep | thruDate | Added | No| | +| SalaryStep | createdByUserLoginId | Added | No| | +| SalaryStep | lastModifiedByUserLogin | Added | No| | +| SalesOpportunity | nextStepDate | Added | No| | +| ServiceSemaphore | lockedByInstanceId | Added | No| | +| ShoppingListItem | modifiedPrice | Added | No| | +| SkillType | parentTypeId | Added | No| | +| SkillType | hasTable | Added | No| | +| SupplierProduct | shippingPrice | Added | No| | +| SupplierProduct | supplierCommissionPerc | Removed | No| | +| TaxAuthorityRateProduct | isTaxInShippingPrice | Added | No| | +| TerminationType | parentTypeId | Added | No| | +| TerminationType | hasTable | Added | No| | +| TestingNodeMember | extendFromDate | Added | No| | +| TestingNodeMember | extendThruDate | Added | No| | +| TimeEntry | planHour | Added | No| | +| Timesheet | approvedByUserLoginId | Added | No| | +| TrainingClassType | parentTypeId | Added | No| | +| TrainingClassType | hasTable | Added | No| | +| UnemploymentClaim | thruDate | Added | No| | +| UserLogin | externalAuthId | Added | No| | +| UserLogin | userLdapDn | Added | No| | +| UserLogin | disabledBy | Added | No| | +| ValueLinkKey | createdByUserLogin | Added | No| | +| WebSite | visualThemeSetId | Added | No| | +| WebSite | hostedPathAlias | Added | No| | +| WebSite | isDefault | Added | No| | +| WebSite | displayMaintenancePage | Added | No| | +| WebSitePathAlias| fromDate | Added | Yes | R1738588 | +| WebSitePathAlias| thruDate | Added | No | R1738588 | +| WorkEffort | tempExprId | Added | No| | +| WorkEffort | sequenceNum | Added | No| | +| WorkEffortAttribute | attrDescription | Added | No| | +| WorkEffortAssocAttribute | attrDescription | Added | No| | +| WorkEffortAssocTypeAttr | description | Added | No| | +| WorkEffortContactMech | fromDate | Added | Yes| | +| WorkEffortContactMech | thruDate | Added | No| | +| WorkEffortFixedAssetAssign | availabilityStatusId | Added | No| | +| WorkEffortPartyAssignment | assignedByUserLoginId | Added | No| | +| WorkEffortPurposeType | parentTypeId | Added | No| | +| WorkEffortStatus | reason | Added | No| | +| WorkEffortTypeAttr | description | Added | No| | +| WorkOrderItemFulfillment | shipGroupSeqId | Added | No| | Propchange: ofbiz/ofbiz-framework/trunk/applications/datamodel/DATAMODEL_CHANGES.md ------------------------------------------------------------------------------ svn:eol-style = native Propchange: ofbiz/ofbiz-framework/trunk/applications/datamodel/DATAMODEL_CHANGES.md ------------------------------------------------------------------------------ svn:keywords = Date Rev Author URL Id Propchange: ofbiz/ofbiz-framework/trunk/applications/datamodel/DATAMODEL_CHANGES.md ------------------------------------------------------------------------------ svn:mime-type = text/plain Added: ofbiz/tools/wiki-files/data-model/DATAMODEL_CHANGES.md.html URL: http://svn.apache.org/viewvc/ofbiz/tools/wiki-files/data-model/DATAMODEL_CHANGES.md.html?rev=1818765&view=auto ============================================================================== --- ofbiz/tools/wiki-files/data-model/DATAMODEL_CHANGES.md.html (added) +++ ofbiz/tools/wiki-files/data-model/DATAMODEL_CHANGES.md.html Wed Dec 20 09:44:43 2017 @@ -0,0 +1,1846 @@ +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> +<html xmlns="http://www.w3.org/1999/xhtml"> +<head> + <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> + <meta http-equiv="Content-Style-Type" content="text/css" /> + <meta name="generator" content="pandoc" /> + <title></title> + <style type="text/css">code{white-space: pre;}</style> +</head> +<body> +<!-- +Licensed to the Apache Software Foundation (ASF) under one +or more contributor license agreements. See the NOTICE file +distributed with this work for additional information +regarding copyright ownership. The ASF licenses this file +to you under the Apache License, Version 2.0 (the +"License"); you may not use this file except in compliance +with the License. You may obtain a copy of the License at + +http://www.apache.org/licenses/LICENSE-2.0 + +Unless required by applicable law or agreed to in writing, +software distributed under the License is distributed on an +"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +KIND, either express or implied. See the License for the +specific language governing permissions and limitations +under the License. +--> +<h1 id="apache-ofbiz-data-model-changes">Apache OFBiz® Data Model Changes</h1> +<p>Apache OFBiz follows <strong>The Universal Data Model</strong> by <strong>Len Silverston</strong>, with a grain of salt.</p> +<p>The following file contains information about the data model changes in the Apache OFBiz. The detailed description of migration scripts specified here can be found at <a href="https://cwiki.apache.org/confluence/x/LoBr">Revisions Requiring Data Migration - upgrade ofbiz</a> page.</p> +<h2 id="changes-with-ofbiz-17">Changes with OFBiz 17</h2> +<p>Field types "id-ne", "id-long-ne" & "id-vlong-ne" has been removed. Use "id", "id-long" and "id-vlong" instead (detailed description at <a href="https://issues.apache.org/jira/browse/OFBIZ-9351">OFBIZ-9351</a>).</p> +<h3 id="entity-changes">Entity Changes</h3> +<p>No changes</p> +<h3 id="field-changes">Field Changes</h3> +<table> +<thead> +<tr class="header"> +<th align="left">Entity</th> +<th align="center">Field</th> +<th align="center">Action</th> +<th align="center">IsPK</th> +<th align="right">Revision</th> +</tr> +</thead> +<tbody> +<tr class="odd"> +<td align="left">MarketingCampaignPrice</td> +<td align="center">fromDate</td> +<td align="center">Added</td> +<td align="center">Yes</td> +<td align="right">R1805961</td> +</tr> +<tr class="even"> +<td align="left">MarketingCampaignPrice</td> +<td align="center">thruDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right">R1805961</td> +</tr> +<tr class="odd"> +<td align="left">MarketingCampaignPromo</td> +<td align="center">fromDate</td> +<td align="center">Added</td> +<td align="center">Yes</td> +<td align="right">R1805961</td> +</tr> +<tr class="even"> +<td align="left">MarketingCampaignPromo</td> +<td align="center">thruDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right">R1805961</td> +</tr> +<tr class="odd"> +<td align="left">MarketingCampaignRole</td> +<td align="center">fromDate</td> +<td align="center">Added</td> +<td align="center">Yes</td> +<td align="right">R1805961</td> +</tr> +<tr class="even"> +<td align="left">MarketingCampaignRole</td> +<td align="center">thruDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right">R1805961</td> +</tr> +<tr class="odd"> +<td align="left">Product</td> +<td align="center">manufacturerPartyId</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right">R1804408</td> +</tr> +<tr class="even"> +<td align="left">SecurityGroupPermission</td> +<td align="center">fromDate</td> +<td align="center">Added</td> +<td align="center">Yes</td> +<td align="right">R1812383</td> +</tr> +<tr class="odd"> +<td align="left">SecurityGroupPermission</td> +<td align="center">thruDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right">R1812383</td> +</tr> +</tbody> +</table> +<h3 id="migration-scripts">Migration Scripts</h3> +<ol style="list-style-type: decimal"> +<li>Updated sql-type for date-time and time field in fieldtypemysql.xml file<br /> +R1793300 "Update msyql sql-type for datetime field-type to support Fractional Seconds in Time Values<br /> +Please upgrade mysql to at least 5.6.4 or higher.<br /> +After upgrade run 'generateMySqlFileWithAlterTableForTimestamps' service, groupName is required field for this service,<br /> +It will generate sql file with alter query statement for date-time and time field at location "${ofbiz.home}/runtime/tempfiles/<groupName>.sql"<br /> +You can use execute sql statement from any of the mysql batch command.</li> +</ol> +<h2 id="changes-between-ofbiz-9-to-ofbiz-16">Changes between OFBiz 9 to OFBiz 16</h2> +<h3 id="entity-changes-1">Entity Changes</h3> +<p><strong>Added 77 new entities</strong></p> +<ol style="list-style-type: decimal"> +<li>JobRequisition</li> +<li>ProductAverageCostType</li> +<li>WorkEffortSurveyAppl</li> +<li>WorkEffortIcalData</li> +<li>WebSiteContactList</li> +<li>WebAnalyticsType</li> +<li>WebAnalyticsConfig</li> +<li>UserLoginSecurityQuestion</li> +<li>UomGroup</li> +<li>TrainingRequest</li> +<li>ThirdPartyLogin</li> +<li>TestFieldType</li> +<li>TestingSubtype</li> +<li>TestingStatus</li> +<li>TestingRemoveAll</li> +<li>TestingItem</li> +<li>TestingCrypto</li> +<li>SystemProperty</li> +<li>ShipmentGatewayUsps</li> +<li>ShipmentGatewayUps</li> +<li>ShipmentGatewayFedex</li> +<li>ShipmentGatewayDhl</li> +<li>ShipmentGatewayConfig</li> +<li>ShipmentGatewayConfigType</li> +<li>ReturnContactMech</li> +<li>QuoteNote</li> +<li>ProductPromoContent</li> +<li>ProductPromoContentType</li> +<li>ProductGroupOrder</li> +<li>ProductCostComponentCalc</li> +<li>CostComponentCalc</li> +<li>PayPalPaymentMethod</li> +<li>PaymentGroupType</li> +<li>PaymentGroup</li> +<li>PaymentGroupMember</li> +<li>PaymentGatewayConfig</li> +<li>PaymentGatewayConfigType</li> +<li>PaymentGatewayWorldPay</li> +<li>PaymentGatewaySecurePay</li> +<li>PaymentGatewaySagePay</li> +<li>PaymentGatewayOrbital</li> +<li>PaymentGatewayEway</li> +<li>PaymentGatewayCyberSource</li> +<li>PaymentGatewayAuthorizeNet</li> +<li>PaymentGatewayIDEAL</li> +<li>PaymentContentType</li> +<li>PaymentContent</li> +<li>OAuth2LinkedIn</li> +<li>OAuth2GitHub</li> +<li>JobManagerLock</li> +<li>JobInterviewType</li> +<li>JobInterview</li> +<li>JavaResource</li> +<li>InvoiceNote</li> +<li>InvoiceItemAssocType</li> +<li>InvoiceItemAssoc</li> +<li>InvoiceContentType</li> +<li>InvoiceContent</li> +<li>GlAccountCategoryType</li> +<li>GlAccountCategoryMember</li> +<li>GlAccountCategory</li> +<li>GitHubUser</li> +<li>FixedAssetTypeGlAccount</li> +<li>FacilityContent</li> +<li>ExcelImportHistory</li> +<li>EmplLeaveReasonType</li> +<li>EbayShippingMethod</li> +<li>EbayConfig</li> +<li>CountryAddressFormat</li> +<li>ContentSearchResult</li> +<li>ContentSearchConstraint</li> +<li>ContentKeyword</li> +<li>CheckAccount</li> +<li>AgreementFacilityAppl</li> +<li>AgreementContentType</li> +<li>AgreementContent</li> +</ol> +<p><strong>Removed 8 entities</strong></p> +<ol style="list-style-type: decimal"> +<li>DepreciationMethod</li> +<li>FixedAssetMaintMeter</li> +<li>OagisMessageErrorInfo</li> +<li>OagisMessageInfo</li> +<li>SalesOpportunityTrackingCode</li> +<li>SimpleSalesTaxLookup</li> +<li>TestBlob</li> +<li>WorkEffortAssignmentRate</li> +</ol> +<h3 id="field-changes-1">Field Changes</h3> +<table> +<thead> +<tr class="header"> +<th align="left">Entity</th> +<th align="center">Field</th> +<th align="center">Action</th> +<th align="center">IsPK</th> +<th align="right">Revision</th> +</tr> +</thead> +<tbody> +<tr class="odd"> +<td align="left">AcctgTransAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">AcctgTransEntry</td> +<td align="center">inventoryItemId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">AcctgTransTypeAttr</td> +<td align="center">description</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">BenefitType</td> +<td align="center">parentTypeId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">BenefitType</td> +<td align="center">hasTable</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">BudgetAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">BudgetItemAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">BudgetItemTypeAttr</td> +<td align="center">description</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">BudgetStatus</td> +<td align="center">changeByUserLoginId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">BudgetTypeAttr</td> +<td align="center">description</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">CommunicationEventRole</td> +<td align="center">statusId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">CommunicationEventType</td> +<td align="center">contactMechTypeId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">ContactListCommStatus</td> +<td align="center">partyId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">ContactListCommStatus</td> +<td align="center">messageId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">ContactListCommStatus</td> +<td align="center">changeByUserLoginId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">ContactMechAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">ContactMechTypeAttr</td> +<td align="center">description</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">DeductionType</td> +<td align="center">parentTypeId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">DeductionType</td> +<td align="center">hasTable</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">DocumentAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">DocumentTypeAttr</td> +<td align="center">description</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">EmploymentApp</td> +<td align="center">approverPartyId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">EmploymentApp</td> +<td align="center">jobRequisitionId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">EmploymentAppSourceType</td> +<td align="center">parentTypeId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">EmploymentAppSourceType</td> +<td align="center">hasTable</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">EmplPositionClassType</td> +<td align="center">parentTypeId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">EmplPositionClassType</td> +<td align="center">hasTable</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">EmplPositionType</td> +<td align="center">parentTypeId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">EmplPositionType</td> +<td align="center">hasTable</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">EmplPositionType</td> +<td align="center">partyId</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">EmplPositionType</td> +<td align="center">roleTypeId</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">FinAccountAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">FinAccountTransAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">FinAccountTrans</td> +<td align="center">glReconciliationId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">FinAccountTrans</td> +<td align="center">statusId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">FinAccountTransTypeAttr</td> +<td align="center">description</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">FinAccountTypeAttr</td> +<td align="center">description</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">FinAccountStatus</td> +<td align="center">changeByUserLoginId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">FixedAsset</td> +<td align="center">acquireOrderId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">FixedAsset</td> +<td align="center">acquireOrderItemSeqId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">FixedAssetAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">FixedAssetTypeAttr</td> +<td align="center">description</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">GlAccount</td> +<td align="center">externalId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">GlAccount</td> +<td align="center">openingBalance</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">GlReconciliation</td> +<td align="center">createdDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">GlReconciliation</td> +<td align="center">lastModifiedDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">GlReconciliation</td> +<td align="center">statusId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">GlReconciliation</td> +<td align="center">openingBalance</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">InventoryItemAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">InventoryItemStatus</td> +<td align="center">changeByUserLoginId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">InventoryItemTypeAttr</td> +<td align="center">description</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">InvoiceAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">InvoiceItemAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">InvoiceItemTypeAttr</td> +<td align="center">description</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">InvoiceStatus</td> +<td align="center">changeByUserLoginId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">InvoiceTypeAttr</td> +<td align="center">description</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">InvoiceTermAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">JobSandbox</td> +<td align="center">currentRetryCount</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">JobSandbox</td> +<td align="center">tempExprId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">JobSandbox</td> +<td align="center">currentRecurrenceCount</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">JobSandbox</td> +<td align="center">maxRecurrenceCount</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">JobSandbox</td> +<td align="center">jobResult</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">OrderAdjustment</td> +<td align="center">amountAlreadyIncluded</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">OrderAdjustment</td> +<td align="center">isManual</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">OrderAdjustment</td> +<td align="center">oldPercentage</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">OrderAdjustment</td> +<td align="center">oldAmountPerQuantity</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">OrderAdjustment</td> +<td align="center">lastModifiedDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">OrderAdjustment</td> +<td align="center">lastModifiedByUserLogin</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">OrderAdjustmentAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">OrderAdjustmentTypeAttr</td> +<td align="center">description</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">OrderAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">OrderItem</td> +<td align="center">supplierProductId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">OrderItem</td> +<td align="center">cancelBackOrderDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">OrderItem</td> +<td align="center">changeByUserLoginId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">OrderItemAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">OrderItemShipGroup</td> +<td align="center">facilityId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">OrderItemShipGroup</td> +<td align="center">estimatedShipDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">OrderItemShipGroup</td> +<td align="center">estimatedDeliveryDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">OrderItemShipGrpInvRes</td> +<td align="center">priority</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">OrderItemShipGrpInvRes</td> +<td align="center">oldPickStartDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">OrderItemTypeAttr</td> +<td align="center">description</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">OrderTermAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">OrderPaymentPreference</td> +<td align="center">track2</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">OrderPaymentPreference</td> +<td align="center">swipedFlag</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">OrderPaymentPreference</td> +<td align="center">lastModifiedDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">OrderPaymentPreference</td> +<td align="center">lastModifiedByUserLogin</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">OrderShipment</td> +<td align="center">shipGroupSeqId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">OrderTypeAttr</td> +<td align="center">description</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">PartyAcctgPreference</td> +<td align="center">orderSequenceEnumId</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">PartyAcctgPreference</td> +<td align="center">quoteSequenceEnumId</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">PartyAcctgPreference</td> +<td align="center">invoiceSequenceEnumId</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">PartyAcctgPreference</td> +<td align="center">oldOrderSequenceEnumId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">PartyAcctgPreference</td> +<td align="center">oldQuoteSequenceEnumId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">PartyAcctgPreference</td> +<td align="center">oldInvoiceSequenceEnumId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">PartyAcctgPreference</td> +<td align="center">orderSeqCustMethId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">PartyQual</td> +<td align="center">infoString</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">PartyQual</td> +<td align="center">institutionInternalId</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">PartyQual</td> +<td align="center">institutionPartyId</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">PartyQual</td> +<td align="center">partyQualId</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">PartyRate</td> +<td align="center">percentageUsed</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">PartyRate</td> +<td align="center">rate</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">PartyResume</td> +<td align="center">contentId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">PaymentAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">PaymentGatewayResponse</td> +<td align="center">gatewayCvResult</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">PaymentMethod</td> +<td align="center">finAccountId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">PaymentTypeAttr</td> +<td align="center">description</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">PerfRatingType</td> +<td align="center">parentTypeId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">PerfRatingType</td> +<td align="center">hasTable</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">PerfReview</td> +<td align="center">payHistoryRoleTypeIdTo</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">PerfReview</td> +<td align="center">payHistoryRoleTypeIdFrom</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">PerfReview</td> +<td align="center">payHistoryPartyIdTo</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">PerfReview</td> +<td align="center">payHistoryPartyIdFrom</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">PerfReview</td> +<td align="center">payHistoryFromDate</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">PerfReviewItemType</td> +<td align="center">parentTypeId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">PerfReviewItemType</td> +<td align="center">hasTable</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">PersonTraining</td> +<td align="center">trainingRequestId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">PersonTraining</td> +<td align="center">workEffortId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">PersonTraining</td> +<td align="center">approverId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">PersonTraining</td> +<td align="center">approvalStatus</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">PersonTraining</td> +<td align="center">reason</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">PostalAddress</td> +<td align="center">houseNumber</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">PostalAddress</td> +<td align="center">houseNumberExt</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">PostalAddress</td> +<td align="center">cityGeoId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">PostalAddress</td> +<td align="center">municipalityGeoId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">PostalAddress</td> +<td align="center">geoPointId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">PosTerminal</td> +<td align="center">terminalName</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">PosTerminalInternTx</td> +<td align="center">reasonEnumId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">Product</td> +<td align="center">releaseDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">Product</td> +<td align="center">originalImageUrl</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">Product</td> +<td align="center">inventoryItemTypeId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">Product</td> +<td align="center">shippingWeight</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">Product</td> +<td align="center">productWeight</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">Product</td> +<td align="center">diameterUomId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">Product</td> +<td align="center">productDiameter</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">Product</td> +<td align="center">virtualVariantMethodEnum</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">Product</td> +<td align="center">defaultShipmentBoxTypeId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">Product</td> +<td align="center">lotIdFilledIn</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">Product</td> +<td align="center">orderDecimalQuantity</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">Product</td> +<td align="center">weight</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">Product</td> +<td align="center">taxCategory</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">Product</td> +<td align="center">taxVatCode</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">Product</td> +<td align="center">taxDutyCode</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">ProductAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">ProductAverageCost</td> +<td align="center">productAverageCostTypeId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">ProductAverageCost</td> +<td align="center">facilityId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">ProductContent</td> +<td align="center">sequenceNum</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">ProductKeyword</td> +<td align="center">keywordTypeId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">ProductKeyword</td> +<td align="center">statusId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">ProductRole</td> +<td align="center">sequenceNum</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">ProductStore</td> +<td align="center">balanceResOnOrderCreation</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">ProductStore</td> +<td align="center">defaultTimeZoneString</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">ProductStore</td> +<td align="center">oldStyleSheet</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">ProductStore</td> +<td align="center">oldHeaderLogo</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">ProductStore</td> +<td align="center">oldHeaderRightBackground</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">ProductStore</td> +<td align="center">oldHeaderMiddleBackground</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">ProductStore</td> +<td align="center">styleSheet</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">ProductStore</td> +<td align="center">headerLogo</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">ProductStore</td> +<td align="center">headerRightBackground</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">ProductStore</td> +<td align="center">headerMiddleBackground</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">ProductStorePaymentSetting</td> +<td align="center">paymentCustomMethodId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">ProductStorePaymentSetting</td> +<td align="center">paymentGatewayConfigId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">ProductStoreShipmentMeth</td> +<td align="center">shipmentCustomMethodId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">ProductStoreShipmentMeth</td> +<td align="center">shipmentGatewayConfigId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">ProductStoreShipmentMeth</td> +<td align="center">allowancePercent</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">ProductStoreShipmentMeth</td> +<td align="center">minimumPrice</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">ProductTypeAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">QuoteAdjustment</td> +<td align="center">lastModifiedDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">QuoteAdjustment</td> +<td align="center">lastModifiedByUserLogin</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">QuoteAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">QuoteItem</td> +<td align="center">leadTimeDays</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">QuoteRole</td> +<td align="center">fromDate</td> +<td align="center">Added</td> +<td align="center">Yes</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">QuoteRole</td> +<td align="center">thruDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">QuoteTerm</td> +<td align="center">termDays</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">QuoteTerm</td> +<td align="center">textValue</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">QuoteTerm</td> +<td align="center">description</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">QuoteTermAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">QuoteTypeAttr</td> +<td align="center">description</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">RequirementAttribute</td> +<td align="center">changeByUserLoginId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">RequirementStatus</td> +<td align="center">changeByUserLoginId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">ResponsibilityType</td> +<td align="center">parentTypeId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">ResponsibilityType</td> +<td align="center">hasTable</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">ReturnAdjustment</td> +<td align="center">createdByUserLoginId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">ReturnAdjustment</td> +<td align="center">lastModifiedDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">ReturnAdjustment</td> +<td align="center">lastModifiedByUserLogin</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">ReturnHeader</td> +<td align="center">supplierRmaId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">ReturnItemResponse</td> +<td align="center">finAccountTransId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">ReturnStatus</td> +<td align="center">changeByUserLoginId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">SalaryStep</td> +<td align="center">fromDate</td> +<td align="center">Added</td> +<td align="center">Yes</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">SalaryStep</td> +<td align="center">thruDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">SalaryStep</td> +<td align="center">createdByUserLoginId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">SalaryStep</td> +<td align="center">lastModifiedByUserLogin</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">SalesOpportunity</td> +<td align="center">nextStepDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">ServiceSemaphore</td> +<td align="center">lockedByInstanceId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">ShoppingListItem</td> +<td align="center">modifiedPrice</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">SkillType</td> +<td align="center">parentTypeId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">SkillType</td> +<td align="center">hasTable</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">SupplierProduct</td> +<td align="center">shippingPrice</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">SupplierProduct</td> +<td align="center">supplierCommissionPerc</td> +<td align="center">Removed</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">TaxAuthorityRateProduct</td> +<td align="center">isTaxInShippingPrice</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">TerminationType</td> +<td align="center">parentTypeId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">TerminationType</td> +<td align="center">hasTable</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">TestingNodeMember</td> +<td align="center">extendFromDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">TestingNodeMember</td> +<td align="center">extendThruDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">TimeEntry</td> +<td align="center">planHour</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">Timesheet</td> +<td align="center">approvedByUserLoginId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">TrainingClassType</td> +<td align="center">parentTypeId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">TrainingClassType</td> +<td align="center">hasTable</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">UnemploymentClaim</td> +<td align="center">thruDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">UserLogin</td> +<td align="center">externalAuthId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">UserLogin</td> +<td align="center">userLdapDn</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">UserLogin</td> +<td align="center">disabledBy</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">ValueLinkKey</td> +<td align="center">createdByUserLogin</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">WebSite</td> +<td align="center">visualThemeSetId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">WebSite</td> +<td align="center">hostedPathAlias</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">WebSite</td> +<td align="center">isDefault</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">WebSite</td> +<td align="center">displayMaintenancePage</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">WebSitePathAlias</td> +<td align="center">fromDate</td> +<td align="center">Added</td> +<td align="center">Yes</td> +<td align="right">R1738588</td> +</tr> +<tr class="even"> +<td align="left">WebSitePathAlias</td> +<td align="center">thruDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right">R1738588</td> +</tr> +<tr class="odd"> +<td align="left">WorkEffort</td> +<td align="center">tempExprId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">WorkEffort</td> +<td align="center">sequenceNum</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">WorkEffortAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">WorkEffortAssocAttribute</td> +<td align="center">attrDescription</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">WorkEffortAssocTypeAttr</td> +<td align="center">description</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">WorkEffortContactMech</td> +<td align="center">fromDate</td> +<td align="center">Added</td> +<td align="center">Yes</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">WorkEffortContactMech</td> +<td align="center">thruDate</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">WorkEffortFixedAssetAssign</td> +<td align="center">availabilityStatusId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">WorkEffortPartyAssignment</td> +<td align="center">assignedByUserLoginId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">WorkEffortPurposeType</td> +<td align="center">parentTypeId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">WorkEffortStatus</td> +<td align="center">reason</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="even"> +<td align="left">WorkEffortTypeAttr</td> +<td align="center">description</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +<tr class="odd"> +<td align="left">WorkOrderItemFulfillment</td> +<td align="center">shipGroupSeqId</td> +<td align="center">Added</td> +<td align="center">No</td> +<td align="right"></td> +</tr> +</tbody> +</table> +</body> +</html> Propchange: ofbiz/tools/wiki-files/data-model/DATAMODEL_CHANGES.md.html ------------------------------------------------------------------------------ svn:eol-style = native Propchange: ofbiz/tools/wiki-files/data-model/DATAMODEL_CHANGES.md.html ------------------------------------------------------------------------------ svn:keywords = Date Rev Author URL Id Propchange: ofbiz/tools/wiki-files/data-model/DATAMODEL_CHANGES.md.html ------------------------------------------------------------------------------ svn:mime-type = text/html Modified: ofbiz/tools/wiki-files/themes/README.md.html URL: http://svn.apache.org/viewvc/ofbiz/tools/wiki-files/themes/README.md.html?rev=1818765&r1=1818764&r2=1818765&view=diff ============================================================================== --- ofbiz/tools/wiki-files/themes/README.md.html (original) +++ ofbiz/tools/wiki-files/themes/README.md.html Wed Dec 20 09:44:43 2017 @@ -245,7 +245,7 @@ under the License. <span class="kw"><VisualThemeResource</span><span class="ot"> visualThemeId=</span><span class="st">"BLUELIGHT"</span><span class="ot"> resourceTypeEnumId=</span><span class="st">"VT_HDR_JAVASCRIPT"</span><span class="ot"> resourceValue=</span><span class="st">"/common/js/jquery/plugins/jquery.maskedinput-1.3.1.min.js"</span><span class="ot"> sequenceId=</span><span class="st">"10"</span><span class="kw">/></span> <span class="kw"><VisualThemeResource</span><span class="ot"> visualThemeId=</span><span class="st">"BLUELIGHT"</span><span class="ot"> resourceTypeEnumId=</span><span class="st">"VT_HDR_JAVASCRIPT"</span><span class="ot"> resourceValue=</span><span class="st">"/common/js/jquery/plugins/jeditable/jquery.jeditable-1.7.3.js"</span><span class="ot"> sequenceId=</span><span class="st">"11"</span><span class="kw">/></span> <span class="kw"><VisualThemeResource</span><span class="ot"> visualThemeId=</span><span class="st">"BLUELIGHT"</span><span class="ot"> resourceTypeEnumId=</span><span class="st">"VT_HDR_JAVASCRIPT"</span><span class="ot"> resourceValue=</span><span class="st">"/common/js/jquery/plugins/validate/jquery.validate.min.js"</span><span class="ot"> sequenceId=</span><span class="st">"12"</span><span class="kw">/></span> - <span class="kw"><VisualThemeResource</span><span class="ot"> visualThemeId=</span><span class="st">"BLUELIGHT"</span><span class="ot"> resourceTypeEnumId=</span><span class="st">"VT_HDR_JAVASCRIPT"</span><span class="ot"> resourceValue=</span><span class="st">"/images/OpenLayers-2.13.1.js"</span><span class="ot"> sequenceId=</span><span class="st">"13"</span><span class="kw">/></span> + <span class="kw"><VisualThemeResource</span><span class="ot"> visualThemeId=</span><span class="st">"BLUELIGHT"</span><span class="ot"> resourceTypeEnumId=</span><span class="st">"VT_HDR_JAVASCRIPT"</span><span class="ot"> resourceValue=</span><span class="st">"/common/js/plugins/OpenLayers-2.13.1.js"</span><span class="ot"> sequenceId=</span><span class="st">"13"</span><span class="kw">/></span> <span class="kw"><VisualThemeResource</span><span class="ot"> visualThemeId=</span><span class="st">"BLUELIGHT"</span><span class="ot"> resourceTypeEnumId=</span><span class="st">"VT_HDR_JAVASCRIPT"</span><span class="ot"> resourceValue=</span><span class="st">"/common/js/util/OfbizUtil.js"</span><span class="ot"> sequenceId=</span><span class="st">"15"</span><span class="kw">/></span> <span class="kw"><VisualThemeResource</span><span class="ot"> visualThemeId=</span><span class="st">"BLUELIGHT"</span><span class="ot"> resourceTypeEnumId=</span><span class="st">"VT_HDR_JAVASCRIPT"</span><span class="ot"> resourceValue=</span><span class="st">"/common/js/util/fieldlookup.js"</span><span class="ot"> sequenceId=</span><span class="st">"16"</span><span class="kw">/></span> <span class="kw"><VisualThemeResource</span><span class="ot"> visualThemeId=</span><span class="st">"BLUELIGHT"</span><span class="ot"> resourceTypeEnumId=</span><span class="st">"VT_HDR_JAVASCRIPT"</span><span class="ot"> resourceValue=</span><span class="st">"/common/js/plugins/date/date.format-1.2.3-min.js"</span><span class="ot"> sequenceId=</span><span class="st">"17"</span><span class="kw">/></span> |
«
Return to OFBiz - Commits
|
1 view|%1 views
| Free forum by Nabble | Edit this page |