ReleaseUpdateDB60_Vend.updateVendReasonCodes Upgrade Script

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

Class	ReleaseUpdateDB60_Vend
Method	updateVendReasonCodes
Description	Merges reason records from the PurchRFQReasonCode table into the ReasonTable table, and updates related tables.

Affected Modules and Tables

Affected Modules
Accounts payable

Affected Tables
VendRFQJour
VendRFQTrans
PurchRFQTable
PurchRFQLine
ReasonTableRef

Remarks

The reason ID in the PurchRFQReasonCode table has a length of twenty characters, and truncation logic ensures that unique reason IDs will be assigned. The reason ID will be assigned to the ReasonTable.ReasonId field. If it is larger than ten characters, it will be truncated to ten characters. If it does not exist in the ReasonTable table, the assigned ID will be used. If the assigned reason ID already exists in the ReasonTable with the same description, then the Vend property will be set to true if it is false. If the reason ID is matched to a reason ID with a different description, a new reason ID will be assigned by truncating the ID to seven characters, and combining it with a tilde and a unique numeric value. A record that has the assigned ID, the original description and the Vend property of true is inserted into the ReasonTable table. Once a valid reason ID is assigned, the updateReasonCodeReferences method will be called to update the new reason code reference in the VendRFQJour, PurchRFQTable, PurchRFQLine, VendRFQTrans, and ReasonTableRef tables.

Data Migration Section

From Table: PurchRFQReasonCode	To Table: ReasonTable

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
VendRFQJour	ReasonRef	RecId
VendRFQTrans	ReasonRef	RecId
PurchRFQTable	ReasonRef	RecId
PurchRFQLine	ReasonRef	RecId

Deleted Tables or Fields

Table	Field
PurchRFQReasonCode	*