Compartir a través de


ReleaseUpdateDB60_Ledger.updateLvOtherClients Upgrade Script

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

Class

ReleaseUpdateDB60_Ledger

Method

updateLvOtherClients

Description

This method updates the information for the LvOtherClients table.

Affected Modules and Tables

Affected Modules

Bank

Affected Tables

LvOtherClients

OMOperatingUnit

Remarks

This script updates the information in the LvOtherClients table. This includes the new linkage for uptaking the global address book information, instead of storing it as simple text fields. Since there is no way to easily parse street address information, that information is simply stored in its entirety in the Street field of the LogisticalPostalAddress table.

Data Migration Section

From Table: LvOtherClients

To Table: OMOperatingUnit

Name

Name

From Table: LvOtherClients

To Table: LvOtherClients

Bank

Bank

BankAccount

BankAccount

BankAddress

BankAddress

BankRegNum

BankRegNum

BankSwiftCode

BankSwiftCode

Id

ClientId

RegNum_LV

CompRegistNum

PaymCode_LV

LvPaymTransCodes

Resident

Resident

VATNum

VATNum

From Table: LvOtherClients

To Table: DirPartyPostalAddressView

Address

Street

CountryRegionCode

CountryRegionId

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

OMOperatingUnit

Name

Name

DirPartyPostalAddressView

Party

RefRecId

DirPartyPostalAddressView

Street

LogisticsAddressStreet

DirPartyPostalAddressView

CountryRegionId

LogisticsAddressCountryRegionId