ReleaseUpdateDB60_Cust.createCustInterestVersioning Upgrade Script

Article
05/18/2015

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	createCustInterestVersioning
Description	Inserts records into the CustInterestVersion and CustInterestVersionDetail tables from the CustInterest and CustInterestRate tables.

Affected Modules and Tables

Affected Modules
Accounts receivable

Affected Tables
CustInterestVersion
custInterestVersionDetail

Data Migration Section

From Table: CustInterest	To Table: CustInterestVersion
RecId	CustInterest
DEL_GraceDays	GraceDays
DEL_InterestCodeFromDate	ValidFrom
DEL_InterestCodeToDate	ValidTo

From Table: CustInterest	To Table: CustInterestVersionDetail
DEL_InvoicePer	InterestInterval
DEL_InvoiceCalculate	InterestCalculate
DEL_DebitInterestByRange	InterestByRange
DEL_DebitInterestCalcType	InterestCalcType
DEL_DebitInterestPercent	InterestPercent
DEL_PaymentPer	InterestInterval
DEL_PaymentCalculate	InterestCalculate
DEL_CreditInterestByRange	InterestByRange
DEL_CreditInterestCalcType	InterestCalcType
DEL_CreditInterestPercent	InterestPercent
DEL_AccountDebit	LedgerDimension
DEL_AccountCredit	LedgerDimension

From Table: CustInterestVersion	To Table: CustInterestVersionDetail
RecId	CustInterestVersion

New Tables or Fields

CustInterestVersion

CustInterestVersionDetail

Deleted Tables or Fields

Table	Field
DEL_CustInterestRate
CustInterest	DEL_GraceDays
CustInterest	DEL_InvoicePer
CustInterest	DEL_InvoiceCalculate
CustInterest	DEL_DebitInterestByRange
CustInterest	DEL_DebitInterestCalcType
CustInterest	DEL_DebitInterestPercent
CustInterest	DEL_PaymentPer
CustInterest	DEL_PaymentCalculate
CustInterest	DEL_CreditInterestByRange
CustInterest	DEL_CreditInterestCalcType
CustInterest	DEL_CreditInterestPercent
CustInterest	DEL_AccountDebit
CustInterest	DEL_AccountCredit
CustInterest	DEL_InterestCodeFromDate
CustInterest	DEL_InterestCodeToDate