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

updateCustInvoiceLine_IN

Description

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

CustInvoiceLine

CustomsTariffCodeTable_IN

ExciseTariffCodes_IN

ServiceCodeTable_IN

Data Migration Section

From Table: CustomsTariffCodeTable_IN

To Table: custInvoiceLine

RecId

CustomsTariffCodeTable_IN

From Table: ExciseTariffCodes_IN

To Table: custInvoiceLine

RecId

ExciseTariffCodes_IN

From Table: ServiceCodeTable_IN

To Table: custInvoiceLine

RecId

ServiceCodeTable_IN

New Tables or Fields

Table

Field

Extended Data Type

-or- Base Enum

custInvoiceLine

CustomsTariffCodeTable_IN

RefRecId

custInvoiceLine

ExciseTariffCodes_IN

RefRecId

custInvoiceLine

ServiceCodeTable_IN

RefRecId

Deleted Tables or Fields

Table

Field

CustInvoiceLine

del_CustomsTariffCode_IN

CustInvoiceLine

del_ExciseTariffCode_IN

CustInvoiceLine

del_ServiceCode_IN