ReleaseUpdateDB60_Vend.updateVendInvoiceInfoTableSymbol Upgrade Script

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

Class

ReleaseUpdateDB60_Vend

Method

updateVendInvoiceInfoTableSymbol

Description

This method updates the bank constant symbol information for the VendInvoiceInfoTable table.

Affected Modules and Tables

Affected Modules

Accounts payable

Affected Tables

BankConstantSymbol

VendInvoiceInfoTable

VendInvoiceInfoTableSymbol

Remarks

The bank constant symbol 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 BankConstantSymbol table through an extension table, namely the VendInvoiceInfoTableSymbol table.

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

BankConstantSymbol

ConstantSymbol

CzConstantSymbol

BankConstantSymbol

Name

Name

VendInvoiceInfoTableSymbol

BankConstantSymbol

RefRecId

VendInvoiceInfoTableSymbol

CustInvoiceTable

RefRecId

VendInvoiceInfoTableSymbol

SpecificSymbol

SpecificSymbol

Name Changes for Tables or Fields

Old Table Name: VendInvoiceInfoTable

New Table Name: VendInvoiceInfoTableSymbol

Old Field Name:

New Field Name:

ConstantSymbol_CZ

BankConstantSymbol (SFK)

SpecificSymbol_CZ

SpecificSymbol