Compartir a través de


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