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 |