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 |