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 |