ReleaseUpdateDB60_Cust.updateEximCustInvoiceTrans_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 |
updateEximCustInvoiceTrans_IN |
Description |
Updates the EximCustInvoiceTrans_IN table. The record IDs of Incentive scheme group, Exim Ports, Exim Product Group and Customs tariff code are now stored in place of the TariffCode, IncentiveSchemeGroup, PortId and ProductGroup field values. |
Affected Modules and Tables
Affected Modules |
|---|
Accounts receivable |
Affected Tables |
|---|
CustomsTariffCodeTable_IN |
EximCustInvoiceTrans_IN |
EximIncentiveSchemeGroup_IN |
EximPorts_IN |
EximProductGroupTable_IN |
Data Migration Section
From Table: EximIncentiveSchemeGroup_IN |
To Table: EximCustInvoiceTrans_IN |
|---|---|
RecId |
EximIncentiveSchemeGroup |
From Table: EximPorts_IN |
To Table: EximCustInvoiceTrans_IN |
|---|---|
RecId |
EximPorts |
From Table: EximProductGroupTable_IN |
To Table: EximCustInvoiceTrans_IN |
|---|---|
RecId |
EximProductGroupTable |
From Table: CustomsTariffCodeTable_IN |
To Table: EximCustInvoiceTrans_IN |
|---|---|
RecId |
CustomsTariffCodeTable |
New Tables or Fields
Table |
Field |
Extended Data Type -or- Base Enum |
|---|---|---|
EximCustInvoiceTrans_IN |
EximIncentiveSchemeGroup |
RefRecId |
EximCustInvoiceTrans_IN |
EximPorts |
RefRecId |
EximCustInvoiceTrans_IN |
EximProductGroupTable |
RefRecId |
EximCustInvoiceTrans_IN |
CustomsTariffCodeTable |
RefRecid |
Deleted Tables or Fields
Table |
Field |
|---|---|
EximCustInvoiceTrans_IN |
del_IncentiveSchemeGroup |
EximCustInvoiceTrans_IN |
del_PortId |
EximCustInvoiceTrans_IN |
del_ProductGroup |
EximCustInvoiceTrans_IN |
del_TariffCode |