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