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