ReleaseUpdateDB60_Retail.updateRetailConnOneCompanyTables Upgrade Script

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Class

ReleaseUpdateDB60_Retail

Method

updateRetailConnOneCompanyTables

Description

Post-sync upgrade script for the RetailConn tables. Removes the records from the retailConnParameters table, if the DEL_RetailDefaultCompanyForParametersUpg.selectedDataAreaId field is not equal to the retailConnParameters.DEL_DataAreaId field. Removes the records from the retailConnPreactionLog table, if the DEL_RetailDefaultCompanyForParametersUpg.selectedDataAreaId field is not equal to retailConnPreactionLog.DEL_DataAreaId field. Removes the records from the retailConnSchedulerLog table, if the DEL_RetailDefaultCompanyForParametersUpg.selectedDataAreaId field is not equal to the retailConnSchedulerLog.DEL_DataAreaId field. Removes the records from the retailConnSchedulerReplicationCounter table, if the DEL_RetailDefaultCompanyForParametersUpg.selectedDataAreaId field is not equal to the retailConnSchedulerReplicationCounter.DEL_DataAreaId field. Removes the records from the retailConnStoreConnectProfile table, if the DEL_RetailDefaultCompanyForParametersUpg.selectedDataAreaId field is not equal.

Affected Modules and Tables

Affected Modules

Retail

Affected Tables

DEL_RETAILDEFAULTCOMPANYFORPARAMETERSUPG

RETAILCONNPARAMETERS

RETAILCONNPREACTIONLOG

RETAILCONNSCHEDULERLOG

RETAILCONNSCHEDULERREPLICATIONCOUNTER

DEL_RETAILCONNCHILDLOCATIONS

DEL_RETAILCONNDISTRIBUTIONINCEXCLIST

DEL_RETAILCONNINITIALREPLICATIONCOUNTER

DEL_RETAILCONNSCHEDULERJOBTYPE