ReleaseUpdateDB60_Srm.initRFQEnhancementsFeature 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_Srm
Method	initRFQEnhancementsFeature
Description	Introduces and initializes new fields to the RFQ tables to uptake the new Blanket Order framework and procurement categories.

Affected Modules and Tables

Affected Modules
SRM

Affected Tables
PurchRFQCaseLine
PurchRFQCaseTable
PurchRFQLine
PurchRFQTable
PurchRFQReplyLine
PurchRFQReplyTable
VendRFQJour
VendRFQTrans

Remarks

The new script adds a small number of fields to the RFQ tables and initializes them appropriately. These data upgrades are needed by the RFQ Enhancements feature in M2. The resulting data upgrade class is now attribute-based. The details of the upgrades will be published in the corresponding design document.

New Tables or Fields

Table	Field	Extended Data Type -or- Base Enum
PurchRFQCaseTable	ResponsibleEmployeeId	ResponsibleEmplId
PurchRFQCaseTable	ValidityDateStart	ValidFromDate
PurchRFQCaseTable	ValidityDateEnd	ValidToDate
PurchRFQTable	ResponsibleEmployeeId	ResponsibleEmplId
PurchRFQTable	ValidityDateStart	ValidFromDate
PurchRFQTable	ValidityDateEnd	ValidToDate
PurchRFQTable	BlanketId	PurchBlanketOrderId
PurchRFQReplyTable	ValidityDateStart	ValidFromDate
PurchRFQReplyTable	ValidityDateEnd	ValidToDate
VendRFQJour	ResponsibleEmployeeId	ResponsibleEmplId
VendRFQJour	ValidityDateStart	ValidFromDate
VendRFQJour	ValidityDateEnd	ValidToDate
VendRFQJour	BlanketId	PurchBlanketOrderId
PurchRFQCaseLine	CategoryId	PurchCategory
PurchRFQLine	CategoryId	PurchCategory
PurchRFQLine	BlanketId	PurchBlanketOrderId
VendRFQTrans	CategoryId	PurchCategory

Deleted Tables or Fields

Table	Field
PurchRFQTable	VendPriceGroupId
VendRFQJour	RFQDocNum
VendRFQJour	VendPriceGroupId