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