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

updateCustInvoiceTrans_IN

Description

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

Affected Modules and Tables

Affected Modules

Accounts receivable

Affected Tables

CustInvoiceTrans

CustomsTariffCodeTable_IN

ExciseTariffCodes_IN

ServiceCodeTable_IN

Data Migration Section

From Table: CustomsTariffCodeTable_IN

To Table: CustInvoiceTrans

RecId

CustomsTariffCodeTable_IN

From Table: ExciseTariffCodes_IN

To Table: CustInvoiceTrans

RecId

ExciseTariffCodes_IN

From Table: ServiceCodeTable_IN

To Table: CustInvoiceTrans

RecId

ServiceCodeTable_IN

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

CustInvoiceTrans

CustomsTariffCodeTable_IN

RefRecId

CustInvoiceTrans

ExciseTariffCodes_IN

RefRecId

CustInvoiceTrans

ServiceCodeTable_IN

RefRecId

Deleted Tables or Fields

Table

Field

CustInvoiceTrans

del_CustomsTariffCode_IN

CustInvoiceTrans

del_ExciseTariffCode_IN

CustInvoiceTrans

del_ServiceCode_IN