Compartilhar via


ReleaseUpdateDB60_Srm.initPOCreationRule 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

initPOCreationRule

Description

Initializes records for PO creation related tables.

Affected Modules and Tables

Affected Modules

SRM

Affected Tables

PurchReqSourcingPolicyRule

PurchReqSourcingSplitRule

PurchReqSourcingPriceToleranceRule

PurchReqSourcingHoldRule

PurchReqParameters

SysPolicyOrganization

SysPolicySequence

SysPolicyTypeSequence

SysPolicy

SysPolicyOrganization

Remarks

Policy framework has been introduced in this release. This upgrade script inserts records into tables that are related to PO creation from purchase requisition. The data is being migrated primarily from the PurchReqParameters table and the script will also inserts records in policy framework tables if not found.

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

PurchReqSourcingPolicyRule

IsBatchGenerationEnabled

NoYes

PurchReqSourcingPolicyRule

DefaultPurchaseRequisitionName

PurchReqName

PurchReqSourcingPolicyRule

ErrorOption

PurchReqPurchOrderGenerationErrorOption

PurchReqSourcingSplitRule

SplitByRequisitioner

NoYes

PurchReqSourcingSplitRule

SplitByLineType

NoYes

PurchReqSourcingSplitRule

SplitByProductCategory

NoYes

PurchReqSourcingSplitRule

PolicyRule

RefRecId

PurchReqSourcingPriceToleranceRule

EnablePriceTolerance

NoYes

PurchReqSourcingPriceToleranceRule

PercentageLimit

Percent

PurchReqSourcingPriceToleranceRule

AmountLimit

Amount

PurchReqSourcingPriceToleranceRule

PolicyRule

RefRecId

PurchReqSourcingPriceToleranceRule

EnableAmountLimit

NoYes

PurchReqSourcingPriceToleranceRule

EnablePercentageLimit

NoYes

PurchReqSourcingHoldRule

EnableHoldByPrePayment

NoYes

PurchReqSourcingHoldRule

EnableManualHold

PurchReqSourcingManualType

PurchReqSourcingHoldRule

EnableHoldByInternalCatalogItem

PurchReqSourcingCatalogItemHoldType

PurchReqSourcingHoldRule

EnableHoldByExternalCatalogItem

PurchReqSourcingCatalogItemHoldType

PurchReqSourcingHoldRule

EnableHoldByNonCatalogItem

PurchReqSourcingCatalogItemHoldType

PurchReqSourcingHoldRule

PolicyRule

RefRecId

Deleted Tables or Fields

Table

Field

PurchReqParameters

DEL_CatalogType

PurchReqParameters

DEL_ProductGroupIdCategory

PurchReqParameters

DEL_LockMultiples

PurchReqParameters

DEL_LockMinQty

PurchReqParameters

DEL_LockMaxQty

PurchReqParameters

DEL_ProductGroupId

PurchReqParameters

DEL_AutoCreatePurch