ReleaseUpdateDB60_Vend.createPurchLine_W Upgrade Script

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

Class

ReleaseUpdateDB60_Vend

Method

createPurchLine_W

Description

Migrates country/region specific fields from the <c>PurchLine</c> table to <c>PurchLine_W</c> table

Affected Modules and Tables

Affected Modules

Accounts payable

Affected Tables

PurchLine

PurchLine_W

Remarks

Updates all purchase lines linked to Inventory Table which meet the following condition: Type is Service, MarkupCode_RU is not empty.

Data Migration Section

From Table: PurchLine

To Table: PurchLine_W

CountryRegionName_RU

CountryRegionName_RU

DeviationQty_RU

DeviationQty_RU

InvoiceGTDId_RU

InvoiceGTDId_RU

MarkupCode_RU

MarkupCode_RU

PostingProfile_RU

PostingProfile_RU

PriceAgreementDate_RU

PriceAgreementDate_RU

RefReturnInvoiceTrans_W

RefReturnInvoiceTrans_W

SadInvoiceLineNo_PL

SadInvoiceLineNo_PL