ReleaseUpdateDB60_Retail.updateRetailConnTables 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

updateRetailConnTables

Description

Removes the records from the RetailConnAOSProfile table, if the DEL_RetailDefaultCompanyForParametersUpg.selectedDataAreaId field is not equal to the RetailConnAOSProfile.DEL_DataAreaId field. Removes records from the RetailConnConnectionProfile table, if the DEL_RetailDefaultCompanyForParametersUpg.selectedDataAreaId field is not equal to the RetailConnConnectionProfile.DEL_DataAreaId field. Removes the records from the RetailConnCustomConnectionProfile table, if the DEL_RetailDefaultCompanyForParametersUpg.selectedDataAreaId is not equal to the RetailConnCustomConnectionProfile.DEL_DataAreaId field. Removes the records from the RetailConnDatabaseProfile table, if the DEL_RetailDefaultCompanyForParametersUpg.selectedDataAreaId is not equal to RetailConnDatabaseProfile.DEL_DataAreaId field.

Affected Modules and Tables

Affected Modules

Retail

Affected Tables

DEL_RETAILCONNCHILDLOCATIONS

DEL_RETAILCONNDISTRIBUTIONINCEXCLIST

DEL_RETAILCONNINITIALREPLICATIONCOUNTER

DEL_RETAILCONNSCHEDULERJOBTYPE

DEL_RETAILDEFAULTCOMPANYFORPARAMETERSUPG

RETAILCONNAOSPROFILE

RETAILCONNCONNECTIONPROFILE

RETAILCONNCUSTOMCONNECTIONPROFILE

RETAILCONNDATABASEPROFILE

RETAILCONNDISTRIBUTIONGROUP

RETAILCONNDISTRIBUTIONGROUPMEMBER

RETAILCONNDISTRIBUTIONLIST

RETAILCONNDISTRIBUTIONLOCATION

RETAILCONNDISTRIBUTIONSUBGROUP

RETAILCONNDISTRIBUTIONSUBLOCATIONTABLE

RETAILCONNPARAMETERS

RETAILCONNPREACTIONLOG

RETAILCONNSCHEDULERDISTRIBUTIONFILTER

RETAILCONNSCHEDULERLOG

RETAILCONNSCHEDULERREPLICATIONCOUNTER

RETAILCONNSTORECONNECTPROFILE

RETAILCONNSTORECONNECTUPLOADOPTIONS