If a customer wants to test Sales Automation during a Sedona Office conversion process, that data will need to be cleared in the corresponding Alarm Biller database between each pass and especially before go live.
delete aEstimatermr
delete aEstimateItem
delete aCalendarEmployee
delete aCalendarAppointment
delete aEstimatePart
delete cf_Recipient
delete cf_InstanceStage
delete cf_FormInstance
delete cf_PackageInstance
delete aEstimate
delete aCustomerSystem
update sDealerDefaults set ServiceLevelId = 2
delete rServiceLevel where ServiceLevelId > 2
delete rItem where ItemId > 10
delete rPart
delete rSalesTaxRate
delete rSalesTaxBaseSalesTax
delete aCustomerSite
update sDealerDefaults set SalesTaxId =1
delete rSalesTax where SalesTaxId > 1
delete rTerm where TermId > 2
delete rRecurringReason
delete rWarranty where WarrantyTypeId > 3
update sDealerDefaults set SystemTypeId = 1
delete from rSystemType where SystemTypeId > 5
delete sForteAuthorization
delete sa_aLead
delete aCustomer
delete from aSyncEntity
