Compartir a través de


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

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

Table

Field

Extended Data Type

-or- Base Enum

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