ReleaseUpdateDB60_Cust.updateCustQuotationTrans_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

updateCustQuotationTrans_IN

Description

Updates the CustQuotationTrans 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

CustQuotationTrans

ExciseTariffCodes_IN

ServiceCodeTable_IN

Data Migration Section

From Table: CustomsTariffCodeTable_IN

To Table: CustQuotationTrans

RecId

CustomsTariffCodeTable_IN

From Table: ExciseTariffCodes_IN

To Table: CustQuotationTrans

RecId

ExciseTariffCodes_IN

From Table: ServiceCodeTable_IN

To Table: CustQuotationTrans

RecId

ServiceCodeTable_IN

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

CustQuotationTrans

CustomsTariffCodeTable_IN

RefRecId

CustQuotationTrans

ExciseTariffCodes_IN

RefRecId

CustQuotationTrans

ServiceCodeTable_IN

RefRecId

Deleted Tables or Fields

Table

Field

CustQuotationTrans

del_CustomsTariffCode_IN

CustQuotationTrans

del_ExciseTariffCode_IN

CustQuotationTrans

del_ServiceCode_IN