Share via


ReleaseUpdateDB60_Cust.updateSalesQuotationLine_IN 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_Cust

Method

updateSalesQuotationLine_IN

Description

Updates the SalesQuotationLine table. The record IDs of the Customs tariff code, Excise tariff code and Service code are now stored in place of the CustomsTariffCode_IN, ExciseTariffCode_IN and ServiceCode_IN field values.

Affected Modules and Tables

Affected Modules

Accounts receivable

Affected Tables

CustomsTariffCodeTable_IN

ExciseTariffCodes_IN

SalesQuotationLine

ServiceCodeTable_IN

Data Migration Section

From Table: CustomsTariffCodeTable_IN

To Table: SalesQuotationLine

RecId

CustomsTariffCodeTable_IN

From Table: ExciseTariffCodes_IN

To Table: SalesQuotationLine

RecId

ExciseTariffCodes_IN

From Table: ServiceCodeTable_IN

To Table: SalesQuotationLine

RecId

ServiceCodeTable_IN

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

SalesQuotationLine

CustomsTariffCodeTable_IN

RefRecId

SalesQuotationLine

ExciseTariffCodes_IN

RefRecId

SalesQuotationLine

ServiceCodeTable_IN

RefRecId

Deleted Tables or Fields

Table

Field

salesQuotationLine

del_CustomsTariffCode_IN

salesQuotationLine

del_ExciseTariffCode_IN

salesQuotationLine

del_ServiceCode_IN