ReleaseUpdateTransformDB50_CRM.updateCzVendAdvanceInvoiceTable Upgrade Script

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

Class

ReleaseUpdateTransformDB50_CRM

Method

updateCzVendAdvanceInvoiceTable

Description

Transforms data from the address fields to the <c>PostalAddress</c> field in the <c>CzVendAdvanceInvoiceTable</c> table.

Script Type

Preprocessing 60: Live

Ax Version

Microsoft Dynamics AX 2009

Affected Modules and Tables

Affected Modules

Accounts receivable

Affected Tables

CzVendAdvanceInvoiceTable

Shadow_CzVendAdvanceInvoiceTable_GAB

Data Migration Section

From Table: CzVendAdvanceInvoiceTable

To Table: Shadow_CzVendAdvanceInvoiceTable_GAB

Address

PostalAddress

City

PostalAddress

CountryRegionId

PostalAddress

County

PostalAddress

State

PostalAddress

Street

PostalAddress

Zipcode

PostalAddress

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

CzVendAdvanceInvoiceTable

PostalAddress

LogisticsPostalAddressRecId

Deleted Tables or Fields

Table

Field

CzVendAdvanceInvoiceTable

DEL_Address

CzVendAdvanceInvoiceTable

DEL_City

CzVendAdvanceInvoiceTable

DEL_CountryRegionId

CzVendAdvanceInvoiceTable

DEL_County

CzVendAdvanceInvoiceTable

DEL_State

CzVendAdvanceInvoiceTable

DEL_Street

CzVendAdvanceInvoiceTable

DEL_ZipCode