This document details the changes that were made to existing fields in the ServiceCEO database for ServiceCEO version 6.2.
The following two fields were removed:
This information is now stored in the new Alert fields of tblCustomer .
Prior to deprecating the CreditProblem and IssueAlert columns the following data migration is performed. If, prior to upgrading to ServiceCEO 6.2:
The five existing custom fields for Equipment were renamed:
| 6.1 Name |
6.2 Name |
| tblOSEquip.Custom1 |
tblOSEquip.Extra1 |
| tblOSEquip.Custom2 |
tblOSEquip.Extra2 |
| tblOSEquip.Custom3 |
tblOSEquip.Extra3 |
| tblOSEquip.Custom4 |
tblOSEquip.Extra4 |
| tblOSEquip.Custom5 |
tblOSEquip.Extra5 |
The following charge (product and service) fields were captured information about charge-level custom fields. They have been replaced with the Extra1-Extra25 fields in every appropriate table (lkpProducts.Extra1, for example).
| lkpProducts.CCID1 lkpProducts.CCID2 lkpProducts.CCID3 lkpProducts.Concentration lkpServices.CCID1 lkpServices.CCID2 lkpServices.CCID3 lkpServices.Concentration lnkKitItems.CCID1 lnkKitItems.CCID2 lnkKitItems.CCID3 lnkKitItems.Concentration MD_tblProductCharges.CCID1 MD_tblProductCharges.CCID2 MD_tblProductCharges.CCID3 MD_tblProductCharges.decConcentration MD_tblServiceCharges.CCID1 MD_tblServiceCharges.CCID2 MD_tblServiceCharges.CCID3 MD_tblServiceCharges.decConcentration tblBatchJobProduct.CCID1 tblBatchJobProduct.CCID2 tblBatchJobProduct.CCID3 |
tblBatchJobProduct.Concentration tblBatchJobService.CCID1 tblBatchJobService.CCID2 tblBatchJobService.CCID3 tblBatchJobService.Concentration tblBillingProps.tenantid tblBillingProps.COMPANYID tblCompleteProduct.CCID1 tblCompleteProduct.CCID2 tblCompleteProduct.CCID3 tblCompleteProduct.Concentration tblCompleteService.CCID1 tblCompleteService.CCID2 tblCompleteService.CCID3 tblCompleteService.Concentration tblSchedProd.CCID1 tblSchedProd.CCID2 tblSchedProd.CCID3 tblSchedProd.Concentration tblSchedService.CCID1 tblSchedService.CCID2 tblSchedService.CCID3 tblSchedService.Concentration |
The lkpJobSubStatus.QuickNote field was dropped to make the Quick Note Substatus like other substatuses.
All of the following contact fields were moved from tblLocation to tblContact :
| tblLocation.ContactName tblLocation.Type1 tblLocation.Phone1A tblLocation.Phone1 tblLocation.Type2 tblLocation.Phone2A tblLocation.Phone2 tblLocation.Email1 tblLocation.Title tblLocation.Type3 tblLocation.Phone3A tblLocation.Phone3 tblLocation.Type4 tblLocation.Phone4A tblLocation.Phone4 tblLocation.SecondContactName tblLocation.SecondPhoneType1 tblLocation.SecondPhone1A tblLocation.SecondPhone1 tblLocation.SecondPhoneType2 tblLocation.SecondPhone2A tblLocation.SecondPhone2 tblLocation.SecondPhoneType3 tblLocation.SecondPhone3A tblLocation.SecondPhone3 tblLocation.SecondPhoneType4 tblLocation.SecondPhone4A tblLocation.SecondPhone4 tblLocation.SecondEmail1 tblLocation.ThirdContactName tblLocation.ThirdPhoneType1 tblLocation.ThirdPhone1A tblLocation.ThirdPhone1 tblLocation.ThirdPhoneType2 |
tblLocation.ThirdPhone2A tblLocation.ThirdPhone2 tblLocation.ThirdPhoneType3 tblLocation.ThirdPhone3A tblLocation.ThirdPhone3 tblLocation.ThirdPhoneType4 tblLocation.ThirdPhone4A tblLocation.ThirdPhone4 tblLocation.ThirdEmail1 tblLocation.FourthContactName tblLocation.FourthPhoneType1 tblLocation.FourthPhone1A tblLocation.FourthPhone1 tblLocation.FourthPhoneType2 tblLocation.FourthPhone2A tblLocation.FourthPhone2 tblLocation.FourthPhoneType3 tblLocation.FourthPhone3A tblLocation.FourthPhone3 tblLocation.FourthPhoneType4 tblLocation.FourthPhone4A tblLocation.FourthPhone4 tblLocation.FourthEmail1 tblLocation.SecondTitle tblLocation.ThirdTitle tblLocation.FourthTitle tblLocation.AllowWeb tblLocation.WebPassword tblLocation.SecondAllowWeb tblLocation.SecondWebPassword tblLocation.ThirdAllowWeb tblLocation.ThirdWebPassword tblLocation.FourthAllowWeb tblLocation.FourthWebPassword |
The following tables were removed from the database:
Latitude and Longitude columns were added to both tblLocation and tblOrganisation.