Compartilhar via


ReleaseUpdateDB60_Bank.UpdateCashReceiptsLV Upgrade Script

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

Class

ReleaseUpdateDB60_Bank

Method

UpdateCashReceiptsLV

Description

Upgrades the script for the cash receipts table and related fields for Latvia.

Affected Modules and Tables

Affected Modules

Bank

Affected Tables

LedgerJournalTrans_Rcash

RCashTrans

LvCashReceiptTrans

LvCashReceiptTable

Remarks

The upgrade script is necessary due to the following changes in the data model from previous version. 1.The FK constraint has been changed from the BatchId field to the RefRecId field. 2. The LV specific fields have been moved from the ledgerJournalTrans table to the LedgerJournalTrans_RCash table.

Data Migration Section

From Table: LvCashReceiptTable

To Table: LedgerJournalTrans_RCash

RecId

LvCashReceiptTable

From Table: LvCashReceiptTable

To Table: RCashTrans

RecId

LvCashReceiptTable

From Table: LvCashReceiptTable

To Table: LvCashReceiptTrans

Recid

LvCashReceiptTable

From Table: HcmWorker

To Table: LvCashReceiptTrans

RecId

HcmWorker

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

LvCashReceiptTrans

LvCashReceiptTable