ReleaseUpdateDB60_Ledger.updateLedgerJournalTransPaymTransCodes Upgrade Script

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

Class

ReleaseUpdateDB60_Ledger

Method

updateLedgerJournalTransPaymTransCodes

Description

This method updates the payment transaction codes information for the LedgerJournalTrans table.

Affected Modules and Tables

Affected Modules

Bank

Affected Tables

LvPaymTransCodes

CustTable

Remarks

The payment transaction codes information used to be stored as a textual string in the old fields in AX4 and AX5. The new data model is a field that now holds a surrogate foreign key reference to the new LvPaymTransCodes table. This is linked through the new LedgerJournalTransPaymTransCodes extension table.

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

LvPaymTransCodes

Description

Description

LvPaymTransCodes

PaymTransCode

LvPaymCode

LedgerJournalTransPaymTransCodes

LedgerJournalTrans

RefRecId

LedgerJournalTransPaymTransCodes

LvPaymTransCodes

PaymTransCodeRecId

Name Changes for Tables or Fields

Old Table Name: LedgerJournalTrans

New Table Name: LedgerJournalTransPaymTransCode

Old Field Name:

New Field Name:

PaymCode_LV

LvPaymTransCodes